KS3 Computer Science: Spreadsheets Topic
Fully resourced KS3 Spreadsheets topic, including assessment.
Contains:
5 lessons
1 recap lesson with online quiz
1 assessment with mark scheme
1 assessment review lesson with self-review sheet
All 5 topic lessons follow the structure of:
Multiple-choice starter task
Learning objectives
Information slides
Knowledge check tasks (paper / mini whiteboards)
Main lesson task
Answer slides (where necessary)
Plenary task
Lessons:
Lesson 1 - Spreadsheet Cells (identifying cells, cell references, and cell ranges)
Lesson 2 - Quick Calculations (using formula for addition, subtraction, multiplication, and division)
Lesson 3 - Data Master (using the MAX, MIN, and COUNT functions)
Lesson 4 - Fun With Graphs (editing pre-existing and generating graphs)
Lesson 5 - Filter Skills (using filter and sort tools)
Lesson 6 - Topic Recap (keyword recap, True/False challenge, online quiz)
Lesson 7 - Assessment Point (22 question assessment, including mark scheme)
Lesson 8 - Assessment Point Review (common misconceptions, review sheet)




















