www.ICT-Teacher.com
Mathstutor 2003-07
for rights & liabilities see:  mathstutor

 

Applied GCSE Unit 1

Spreadsheets

Starter: Powerpoint instructions:

Starter: Introduction to Spreadsheets. Task to create a spreadsheet to model the cost of a group holiday to Disneyland:

Introduction.      

Data.        

Introduction

Disney Holiday Instructions

Excel holiday spreadsheet (formulae)

Familiarisation exercise

 

Rows.

Intermediate:

Task to create a spreadsheet for the 'Mickey's Mobile Mania' Pay Roll.

Instruction sheet.

Wages template (Wages.xlt).

Help - Sum, Format.

Help - Cell References.

Help - The IF Function.

Copy data for Charts

Hours sheets: Week 1  

Hours sheets: Week 2

Hours sheets: Week 3  

Hours sheets: Week 4

The results: Excel Pay.xls.