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)