Analysing and visualising data
Lesson details
Learning outcome
I can analyse data using functions and summarise findings using charts.
Key learning points
- A spreadsheet function is a predefined formula that performs calculations.
- Spreadsheet functions can be used to analyse data.
- Charts can be used to visualise data in a way that is easier to understand.
Keywords
Function - a predefined formula that performs a calculation
Chart - a graphical representation of data
Common misconception
All range references in a spreadsheet needs to be the same as cell references in the format of column letter followed by row number (e.g. A1:A4).
If you want to reference the whole column you can remove the row numbers (e.g. A:A). Note that this is the only case where cell references do not have to follow the column:row convention.
Teacher tip
All Oak resources can be customised to suit the local context of your school. Change the examples in the spreadsheet used for tasks to suit the interests of your class and to reflect the context of your local area.
Equipment
Pupils will need access to a device with spreadsheet software. Examples in this lesson use Google Sheets https://oak.link/google-sheets
File needed for this lesson
Party planning 253.39 KB (XLSX)
Download this file to use in the lesson.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.Facts and figures that have been organised so that they have meaning is the definition of __________.
Q2.A school publishes a report on the number of students who are entitled for free school meals. Is this primary or secondary data?
Q3.The government issues leaflets containing new health and nutrition guidelines published by researchers in France. Is this primary or secondary data?
Q4. is raw facts or figures without any meaning.
Q5.=A1*C1 is an example of a _________.
Q6.Which of these is a cell reference?
Assessment exit quiz
6 Questions
Q1.Which of these is used to visualise information as a picture?
Q2.Which of these functions would you use to add up a range of numbers?
Q3.What does the MAX function find?
Q4.What function would you use to find the smallest value?
Q5.What does the COUNTA function tell you?
Q6.Which of the following are acceptable cell references?
To help you plan your 7 computing lesson on: Analysing and visualising data, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your 7 computing lesson on: Analysing and visualising data, download all teaching resources for free and adapt to suit your pupils' needs.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 3 computing lessons from the Data modelling unit, dive into the full secondary computing curriculum, or learn more about lesson planning.