Modelling - Spreadsheets

This unit re-introduces the learners to spreadsheets. They will be supported in organising data into columns and rows to create their own data set. Learners will be taught the importance of formatting data to support calculations, while also being introduced to formulas and will begin to understand how they can be used to produce calculated data. 

You will utilise the following skills from previous units and year groups:

1. A basic knowledge of how databases work from year 5 (Superhero Database Unit)

2. Computational Thinking skills from earlier in the year

3. Problem solving/mathematical reasoning skills

4. Resilience

You will learn the following skills:

1. Learners will be taught how to apply formulas that include a range of cells. 

2. Apply formulas to multiple cells by duplicating them. Learners will use spreadsheets to plan an event and answer questions. 

3. Finally, learners will create charts, and evaluate their results in comparison to questions asked. 

Where this will/could take you:

1. Modelling data unit in years 7 

2. GCSE Computer science

3. It is a life skill...you will use spreadsheets when you are older!

4. Support your mathematical reasoning skills

5. A large and diverse number of jobs, not just in ICT, which require the use of spreadsheets (82% of jobs now do!) - See the list below...

• Administrative Assistant. ...

• Accountants. ...

• Retail Manager. ...

• Cost Estimator. ...

• Financial Analyst. ...

• Project Manager. ...

• Business Analyst. ...

• Data Journalist.

• The list goes on!

Emerging: I can identify the reference of a cell. I can add simple data into a spreadsheet.

Developing A: I can collect some data of my own and input it into a spreadsheet. I can colour format cells in order to make my spreadsheet clear.

Developing B: With support I can apply a formula to do a calculation using some data I have collected myself.

Mastery: I can collect and display data, formatting cells suitably. I can use filtering, formula and functions to perform tasks.

Greater Depth: Mastery plus - I can create a chart to show the answer to a question. I know how to use conditional formatting.

Week 1:

• I can collect data

• I can suggest how to structure my data

• I can enter data into a spreadsheet

Week 2:

• I can explain what an item of data is

• I can choose an appropriate format for a cell

• I can apply an appropriate format to a cell

Week 3:

• I can explain which data types can be used in calculations

• I can construct a formula in a spreadsheet

• I can identify that changing inputs changes outputs

Week 4:

• I can calculate data using different operations

• I can create a formula which includes a range of cells

• I can apply a formula to multiple cells by duplicating it

Week 5:

• I can use a spreadsheet to answer questions

• I can explain why data should be organised

• I can apply a formula to calculate the data I need to answer questions

Week 6:

• I can produce a chart

• I can use a chart to show the answer to a question

• I can suggest when to use a table or chart

• Cell: A small box in a spreadsheet that can hold data.

• Column: A vertical group of cells.

• Row: A horizontal group of cells.

• Range: A group of cells that are next to each other.

• Formula: A mathematical equation that can be used to calculate values in a spreadsheet.

• Function: A pre-defined formula that can be used to perform common tasks in a spreadsheet.

• Data: The information that is stored in a spreadsheet.

• Chart: A visual representation of data.

• Filter: A way to restrict the data that is displayed in a spreadsheet.

• Sort: A way to organize the data in a spreadsheet.

• Print: A way to create a hard copy of a spreadsheet.