Lesson Aim
- Re-inforce creation of formulas
- Create IF Formulas
- Created Nested IF Formulas
Task
Download the worksheets below and complete the tasks
Extension
Tag: spreadsheets
Spreadsheet Exercises
Lesson Aim
Introduce Spreadsheet Terminology
Learn to Create Formulas in Spreadsheets
Tasks
Download the files below and work through the exercises
Extension
Introduction to Spreadsheets
Lesson Aim
-
Learn spreadsheet vocabulary
-
Create simple formulas
Main
Download the spreadsheet below and complete all the worksheets
Week 1 – 2 Spreadsheet tasks – Skills building
Plenary
Introduction to Spreadsheets (BUH)
Lesson Aim
-
Learn spreadsheet vocabulary
-
Create simple formulas
Starter
test_your_skills
Main Task
Download and complete the spreadsheet below:
Week 3 tuckshop – worksheet 17
Week 3 tuckshop with worksheet 17
Plenary
Spreadsheets plenary
Plenary
Protected: Year 7 – Spreadsheet exercises
Year 8 – Spreadsheet task
Lesson Aim
- Reinforce spreadsheet skills
- Create formulas using functions (sum, count)
You will need to work on the worksheets in Spreadsheet below to revise all the spreadsheet techniques you learnt last year.
Extension
Complete the spreadsheet below