Awards
Objectives
All students are able to use spreadsheet software to attempt to create an organised data structure.
All students are able to use at least one function such as countif in spreadsheet software
All students can use spreadsheet software to automate calculations
All students can set up one rule with conditional formatting.
Most students use spreadsheet software to successfully create an organised data structure.
Most students understand the difference between absolute and relative cell references
Most students can use multiple rules conditional formatting
Some students can use at least one advanced function (such as countif + countif) in spreadsheet software.
All students are able to use spreadsheet software to attempt to create an organised data structure.
All students are able to use at least one function such as countif in spreadsheet software
All students can use spreadsheet software to automate calculations
All students can set up one rule with conditional formatting.
Most students use spreadsheet software to successfully create an organised data structure.
Most students understand the difference between absolute and relative cell references
Most students can use multiple rules conditional formatting
Some students can use at least one advanced function (such as countif + countif) in spreadsheet software.
Bronze |
Silver |
Gold |
|
|
|
Project
You are going to create a stadium booking and finance system. The stadium can be for any event - sports, music, cinema etc. It will allow the booking of seats and generate a financial report from that.
Time
You will have this half term to complete the project. Your work will need to be submitted the week before the last week of term. You will receive feedback in the final week.
Tasks
- Create the stadium
- Count the seats sold
- Create the financial sheet