Term 2 – Spreadsheets (Suki and Sid’s Snow School)

7_4_1_1_aw

Sid and Suki are mad for extreme sports, and they have set up a skate shop and a snow school in Scotland. The businesses are doing quite well, because so many teenagers are getting hooked on snowboarding and skateboarding. But they would like to make a bit more money, and they need your help!

In this unit you are going to help Sid and Suki run their businesses – Sid’s Snow School and Suki’s Skate Shop. You are going to help them increase their profit (that’s the money they make) by using spreadsheets.

Lesson 1 – Formulae: The Basics
Lesson 2 – Costs and Profit
Lesson 3 – Absolute and Relative Cell Referencing
Lesson 4 – Developing a Model (Phase 1)
Lesson 5 – Developing a Model (Phase 2)
Lesson 6 – Creating Charts
Lessons 7 and 8 – Unit Assessment

The content of these lessons are (c)2010 Smart Learning Ltd and licenced to Belper School and Sixth Form Centre.  These resources are for use by students and staff of Belper School and Sixth Form Centre only and must not be used by any other persons.  Lessons above are only accessible from Belper School computers.