Week 2 ยท 45-60 min

Navigating Spreadsheets and Entering Data

Week Summary

A quick preview of the main ideas in this week before you begin the slides.

  • Recap: Spreadsheet Structure
  • Planning a Data Table
  • Entering Data Accurately
  • Using Data Validation

Glossary

Review these key terms before starting this week. They are kept simple so students can learn the new vocabulary before moving into the slides.

Recap: Spreadsheet Structure
Recap: Spreadsheet Structure
Planning a Data Table
Planning a Data Table
Entering Data Accurately
Entering Data Accurately
Slide 1๐Ÿ’ก

Recap: Spreadsheet Structure

Learning goal

Confidently enter and organize data in a spreadsheet.

Read one card at a time. Focus on the main idea first, then look at the visual on the right to help it stick.

Rows, columns, and cells organize spreadsheet data.

Cell references combine a column letter and row number, such as B3.

Workbooks can contain multiple sheets.

Sheet tabs help organize related data.

Good navigation skills speed up analysis work.

Remember

Comfort with spreadsheet structure makes every later task easier.

Recap: Spreadsheet Structure

Recap: Spreadsheet Structure

Slide 1 of 8

Use arrows or dots to move through the lesson

Practice

  1. Write 2-3 sentences about what you learned this week.

Coming Next Week: Next: Sorting and Filtering Data