Study Hub

Study Guides

This pupil-friendly study guide includes a unit summary, clear notes, common mistakes, and quick questions with answers.

Back to Study HubBrowse Year 7 Computing Guides

Year 7 - Computing

Applying conditional formatting to data

Data modelling

Unit Summary

By the end of this unit pupils should be able to model data within a spreadsheet. Pupils will progress from using basic formulas to using inbuilt functions. Pupils will apply sorting and searching techniques to data and explore how conditional formatting can be used to present data effectively.

Lesson Summary

You will learn to use conditional formatting and a range of tools to present data effectively.

Key Notes

  • 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.

Vocabulary To Learn

  • conditional formatting: applies a style or format to a cell based on whether a cell matches a certain criteria

Common Mistakes To Avoid

  • Pupils may think that conditional formatting can only be used to add background colour to a cell.

3 Quick Questions (With Answers)

1. Describe the system or process from this lesson in clear steps.

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.

2. Define this computing term and give one practical example. 'conditional formatting'

applies a style or format to a cell based on whether a cell matches a certain criteria. Add one real device or system example to prove understanding.

3. Correct this common computing misconception.

Mistake: Pupils may think that conditional formatting can only be used to add background colour to a cell. Correction: Conditional formatting can be used to apply a range of formatting a cell including the text of the cell itself.

More Lessons In This Unit

Browse all guides in the Year 7 Computing guide library.