Year 9 One Lesson Task :: Congratulations [Spreadsheet]
Congratulations!
Imagine you have won first prize in a competition!
There are four different prizes to choose from. Use your computer to help you decide which is the best!
| Prize A | Prize B | |
| £1,000 in the first year, £2,000 in the second year, £3,000 in the third year, £4,000 in the fourth year, £5,000 in the fifth year and so on for 25 years. | 1p in the first year, 2p in the second year, 4p in the third year, 8p in the fourth year, 16p in the fifth year and so on for 25 years. | |
| Prize C | Prize D | |
| £10,000 each year for 25 years. | £250 in the first year then plus 25% each year. |
Tasks:
- Which prize do you think will pay the most after 25 years?
- Use a Spreadsheet to calculate the amount you will receive each year for each prize. [You will need to use formulas!]
- Which prize pays the most after 25 years?
- If each prize only lasted 10 years - which would be the best?
Ingredients:
- Example Layout
- Excel
Assessment:
- Multiple choice test
10 Questions :: <15 Mins
Time:
- 1 Lesson
Documents
See also...
Explore...
Do you want to work in The creative Industries when you leave school?
Microbit Multiplayer Game // Maverick
1.3 Computer networks, connections and protocols Flashcards | Quizlet
C# Cook Book // Picture Block Puzzle (GUI)
GCSE CS: 1.6 Social Engineering Excerise
DynaMaze - Creating enemies and item pickups
TwitBook - Can you spot the problems with this profile page?
New...
Local Governing Body Information
BACK TO THE FUTURE, the musical. Thursday 5th June 2025. Years 7 to 10.
What happens to your examination script?
Teacher of Mathematics (possibility to combine with a head of year post)
Teacher of Science (possibility to combine with a head of year post)
Teacher of History (possibility to combine with a head of year role)
Teacher of Mathematics (with specific year group responsibilities for key stage 5)
Discover...
Key Stage 3 Year 9 Tasks ICT Computer Science Internet Theatre Homework Trustees Trips Policy Programming Design Mathematics Repl.It Robmiles.Com Computer News and Articles Link Keystage 5 LMC
Uh-oh - we were unable to load our website on your browser so we're showing you a plain HTML version.
We use many features found in modern browsers and regrettably yours seems incompatible.
However this legacy version contains (very, very nearly) all the same content. Each page is rendered on our server and doesn't rely on any browser features except the odd font. It doesn't even need Javascript or fancy CSS. It's like being in 1995!
Your browser is reporting itself to us as Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com). Please consider updating your browser to make the most of our website.
If you would like to try our proper website again - you can do so here...