Year 7
Lesson 2 Quick calculations
In this lesson, learners will practise entering text into cells of a spreadsheet and then learn how to perform calculations on the data using basic formulas and cell references. They will learn how to use the autofill tool to duplicate cells and continue a linear pattern, and then combine the autofill tool with basic formulas to quickly populate a results column with calculations.
Learning objectives
- Use basic formulas with cell references to perform calculations in a spreadsheet (+, -, *, /)
- Use the autofill tool to replicate cell data
Package contents
- Lesson plans
- Learning graphs
- Unit overviews
- Activities
Not registered yet?
Create an account and get access to over 500 hours of free teaching resources.