Activity

Spreadsheet Tutorial 2: Autofill Data, Cell References, and Standard Deviation

Curated and Reviewed by Lesson Planet

If you've always wanted to know more about spreadsheets, here's a perfect resource for you. A self-paced tutorial introduces how to autofill and copy formulas in a Google sheet or Excel spreadsheet. It also shows users how to find range, standard deviation, and variance using the spreadsheet's built-in formulas.

13 Views 11 Downloads
Instructional Ideas
  •  Assign the exercise sheet as homework
Classroom Considerations
  • Pupils should have some familiarity with spreadsheets (this is the second of five tutorials in the Spreadsheet Data Analysis unit)
  • Learners must have knowledge of range, standard deviation, and variance
Pros
  • Instructions are clear and easy to execute
  • Includes an exercise for scholars to complete on their own
Cons
  • None