spreadsheet

This is a complete scheme about modelling designed for year 8 students. This includes an assessment sheet matched against the national curriculum level descriptors.

A simple starter activity where student need to match up the questions and answers. A teachers answer sheet is provided.

The success criteria to show students what they need to create a successful business spreadsheet.

A simplified spreadsheet definitions worksheet for KS3.

The fourth section of work about spreadsheets and modelling including a spreadsheets quiz to test understanding.

The third section of work for students studying spreadsheets and modelling. This resources are used to teach students about formulas and functions.

A selection of resources to continue teaching students about modelling. This includes a battleships cell referencing game starter and a plenary sheet.

During this lesson students will learn what a 'model' is and how formatting features improve readibility and clarity of data.

Studens are given a scenario in which santa needs to work out whether his income (generated through selling the mince pies etc. left out by the people he visits) is enough to cover his spending (the cost of presents, elf wages etc.)

A template spreadsheet is provided for students and a completed spreadsheet including formatting etc. is provided for teachers.

This fun excel workbook works out how many days old you are. Great for a quick starter or plenary to demonstrate the power of spreadsheets.

A cell referencing quiz in which students have to look up letters in the cell references given to spell out words.

.

Here is the makings of a fun spreadsheet model to learn about conditional formatting and formulas. It needs tailoring to your own requirements but the majority of the work is done.

*Updated* - A guide sheet is now included. This isn't really explicit; instead students should try to figure things out for themselves using the 'Help' feature and Google. Students could try to produce their own stadium working in small groups.

.

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.

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.

This spreadsheet can be used as an example to students who should then produce their own. The invoice uses formulas to calculate the totals, the SUM function and an IF statement to print a 'free' delivery message if the total spend is over £100