Year 6 - Computing
Event planning using a spreadsheet
Introduction to spreadsheets
Study Hub
Study Guides
This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.
Unit Summary
This unit introduces pupils to how spreadsheets can be used to organise data and create their own data sets. They will discover the importance of formatting data to support calculations, while also examining how formulas can be used to produce calculated data and how graphs can present this data.
Lesson Summary
You will learn to use a spreadsheet to plan an event.
Key Notes
- Spreadsheets are useful as planning tools.
- A budget is a value of money that can be spent as part of a plan.
- Subtotals are used to work out overall totals in smaller steps.
Vocabulary To Learn
- budget: an amount of money planned to be spent
- subtotal: a part of an overall total based on some of the values
Common Mistakes To Avoid
- Spreadsheets make planning an event more difficult as you have to enter data and use formulas.
3 Quick Questions (With Answers)
1. Describe the system or process from this lesson in clear steps.
Spreadsheets are useful as planning tools. A budget is a value of money that can be spent as part of a plan.
2. Define this computing term and give one practical example. 'budget'
an amount of money planned to be spent. Add one real device or system example to prove understanding.
3. Correct this common computing misconception.
Mistake: Spreadsheets make planning an event more difficult as you have to enter data and use formulas. Correction: Spreadsheets make planning an event easier as they have useful tools that save you work and allow you to make changes. You can use spreadsheets to model changes to the event and instantly recalulate all the important information.
More Lessons In This Unit
Browse all guides in the Year 6 Computing guide library.