Skip to main content

Year 6

Lesson 2 Formatting a spreadsheet

Curriculum > KS2 > Unit > Lesson

Learners will develop their understanding of the structure of a spreadsheet. They will be introduced to cell references, data items and the concept of formatting cells. Learners will see data items formatted in different ways, they will then choose formats for data items before applying formats in their own spreadsheet.

Learning objectives

To build a data set in a spreadsheet

  • 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

Package contents

  • Lesson plans
  • Learning graphs
  • Unit overviews
  • Activities
Log in to download

Not registered yet?

Create an account and get access to over 500 hours of free teaching resources.

Help us make these resources better

Provide your feedback

Or email us at [email protected]