Outcomes: You will be able to use simple formula to solve problems and create graphs and charts to display data
Intro - 2 minutes
Starter
Using this link, you have 3 minutes to memorise as much as you can about spreadsheets. Write on the whiteboards!
http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/
RED TASK
http://www.bbc.co.uk/bitesize/ks3/ict/software_applications/spreadsheets/activity/
Main
RED TASK
The Wizards Challenge
Download The Wizards Challenge spreadsheet into your Sites/Skills Building folder. This will help you to understand cell references. Complete the task.
How does what you've learnt relate to anything you wrote down during your starter? AMBER TASK
Download The Wizards Challenge spreadsheet into your Sites/Skills Building folder. This will help you to understand cell references. Complete the task.
How does what you've learnt relate to anything you wrote down during your starter? AMBER TASK
The Gold Mine
Download and complete The Gold Mine challenge that will introduce basic formula.
GREEN TASK
Download and complete The Gold Mine challenge that will introduce basic formula.
GREEN TASK
The Sweet Challenge.... THE CHALLENGE.
(Green for Green)
The Sweet Challenge requires you to use trial and error and problem solving to solve
(Green for Green)
The Sweet Challenge requires you to use trial and error and problem solving to solve
Plenary
You are planning a party. How could using a spreadsheet help you?
Who do you think uses spreadsheets as part of their daily work life?
Who do you think uses spreadsheets as part of their daily work life?
No comments:
Post a Comment