top of page

Paper 1: Testimonial

Unit 6 - Modelling data using spreadsheets

This spreadsheet unit will take your from having very little knowledge of spreadsheets to being able to confidently model data with a spreadsheet. The unit includes a range of activities It will give you a good set of skills that you can use in computing lessons and in other subject areas.

Topic 1 - Getting to know a spreadsheet

Working with Spreadsheets

1. Introduction to spreadsheets

Identify columns, rows, cells, and cell references in spreadsheet software
Use formatting techniques in a spreadsheet

Topic 2 - Quick calculations

$Math Formulas$

2. Using formulas

Use basic formulas with cell references to perform calculations in a spreadsheet (+, -, *, /)
Use the autofill tool to replicate cell data

Topic 3 - Collecting data

Paramedic Filling a Questionnaire

3. Creating a survey

Explain the difference between data and information
Explain the difference between primary and secondary sources of data
Collect data

Topic 4 - Become a data master!

Analyzing the data

4. Charts and formulas

Analyse data
Create appropriate charts in a spreadsheet
Use the functions SUM, COUNTA, MAX, and MIN in a spreadsheet

Topic 5 - Level up your data skills!

$Math Formulas and a Calculator$

5. Sorting data

Analyse data
Use a spreadsheet to sort and filter data
Use the functions AVERAGE, COUNTIF, and IF in a spreadsheet

Topic 6 - Conditional Formatting

Stock Trading Graph

5. Test your skills

Use conditional formatting in a spreadsheet
Apply all of the spreadsheet skills covered in this unit

Assessment

Image by Glenn Carstens-Peters

6. End of unit assessment

Reflection

bottom of page