Applying conditional formatting to data
I can use conditional formatting and a range of tools to present data effectively.
Applying conditional formatting to data
I can use conditional formatting and a range of tools to present data effectively.
These resources will be removed by end of Summer Term 2025.
Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.
These resources were created for remote use during the pandemic and are not designed for classroom teaching.
Lesson details
Key learning points
- Conditional formatting applies a style or format to a cell based on whether a cell matches a certain criteria.
- Conditional formatting can be applied to specific data in a range of cells.
- Conditional formatting can be used to highlight or pick out key pieces of data.
- Spreadsheet tools can be combined to analyse and present data.
Keywords
Conditional formatting - applies a style or format to a cell based on whether a cell matches a certain criteria
Common misconception
Pupils may think that conditional formatting can only be used to add background colour to a cell.
Conditional formatting can be used to apply a range of formatting a cell including the text of the cell itself.
To help you plan your year 7 computing lesson on: Applying conditional formatting to data, download all teaching resources for free and adapt to suit your pupils' needs...
To help you plan your year 7 computing lesson on: Applying conditional formatting to 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.
Files needed for this lesson
- UK forestry data 277.38 KB (XLSX)
- Weather data 145.23 KB (XLSX)
Download these files to use in the lesson.
Equipment
Pupils will require access to a device with software that provides spreadsheet capabilities.
Licence
Lesson video
Loading...
Prior knowledge starter quiz
6 Questions
Q1.Which tool is used to organise data in ascending or descending order in a spreadsheet?
Q2.Which function would you use to count the number of non-blank cells in a range?
Q3.What does the function =IF(A1>10, "Yes", "No") do?
Q4.What does the function =MIN(A1:A10) do?
Q5.Write the formula you would use to multiply the value in A1 by the value in B1.
Q6.The function used to add a group of numbers together is = (A1:A10).
Assessment exit quiz
4 Questions
Q1.What is the purpose of conditional formatting?
Q2.Which of these is an example of conditional formatting?
Q3.Which of these rules can be applied with conditional formatting?
Q4.Match the term to the definition.
adds a group of numbers together
finds the smallest number in a range
finds the largest number in a range
highlights cells based on their values
displays only rows that meet certain criteria