Several sample spreadsheets for students to play with and complete the exercises.
Very basic cell referencing game, works very well for students with no prior knowledge of spreadsheets (in my experience) after a small explanation.
Used as a starter activity for a second lesson on spreadsheets for Y7.
Could be used as a starter/plenary/homework for any KS3 lesson on spreadsheets.
2 versions in one document. One easier/eal version with words listed to find. One without words!
Matching the key terms to the description.
Used as a starter activity for a Y7 lesson on spreadsheets.
Students should already know to how do many of the things mentioned on the activity.
Could be used for any KS3 lesson on spreadsheets.
A simple starter activity where student need to match up the questions and answers. A teachers answer sheet is provided.
A simplified spreadsheet definitions worksheet for KS3.
This is a complete scheme about modelling designed for year 8 students. This includes an assessment sheet matched against the national curriculum level descriptors.
During this lesson students will learn what a 'model' is and how formatting features improve readibility and clarity of data.
A selection of resources to continue teaching students about modelling. This includes a battleships cell referencing game starter and a plenary sheet.
The third section of work for students studying spreadsheets and modelling. This resources are used to teach students about formulas and functions.
The fourth section of work about spreadsheets and modelling including a spreadsheets quiz to test understanding.
A cell referencing quiz in which students have to look up letters in the cell references given to spell out words.
.
Y7 - Spreadsheet models
Powerpoint presentation on spreadsheet models.
Definition of model, rule and variable.
Also included is an example spreadsheet for demo, a task sheet for lesson, the task spreadsheet and a help sheet.
Also a homework on models.
A fun exercise on Excel graphing and charting for Year 7 students.