TEACHER NOTES

Worksheets

Spreadsheet Design
An exercise where the a scenario is analysed and converted into a spreadsheeet. Ultimately the design process will go from the initial layout to the complete spreadsheet.

How to Do It Checklist
A checklist for pupils to complete as they complete spreadsheet exercises

Types of Cursors / Formulae
Microsoft Excel has different mouse shapes that do different jobs. A grid to fill out with a table of example formulae with missing gaps.

Homework 1
Homework exercise

Homework 2
Homework exercise

Charts for the Warmwear exercise
You will need to produce charts from the final Warmwear exercise. Use this worksheet to help you.

Warmwear exercise (answers)
Answers to the Warmwear exercise. This has been changed to HTML format so that the answers can not be copied!

Concerts exercise (answers)
Answers to the Concerts exercise. This has been changed to HTML format so that the answers can not be copied!

Revision Notes for both SS and DB
Revision exercise for SS and DB.