spreadsheet

A word wall of key words that can be cut out, laminated and stuck / hung in the classroom to remind students of the terminology and the spelling.

A tracking spreadsheet for round 1 and round 2 of the 2010 world cup.

A great spreadsheet with all the groups for the 2010 World Cup. Students can change the fonts and colours, enter the formulas to work out the points total and goal difference and try to hyperlink the country's flags to the relevant Wikipedia articles.

Coming soon...

If you have the results of a test or exam and you have the grade boundaries you can use the VLOOKUP function in Excel to automatically attribute a grade to each student. This spreadsheet is all setup and working - so use it as an example or add your own data and off you go.

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.