## Lesson 1 What is a spreadsheet?

Curriculum > KS2 > Unit > Lesson

Learners will collect and organise data in a format of their choice. They will then explore how data can be structured in a table. Finally they will input data into a spreadsheet.

## Learning objectives

To create a data set in a spreadsheet

## Package contents

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

## Help us make these resources better

Or email us at [email protected]

## Key Stage 2 , Computing , Spreadsheets

- STEM Ambassadors
- STEM Community
- ITE and governors
- ENTHUSE Partnerships
- Helping those that need it most
- Invest in schools
- Benefits and impact
- Our supporters
- Build your STEM Ambassadors
- Become a STEM Ambassador
- Request a STEM Ambassador
- Partner information
- Training and support
- STEM Ambassador Hubs
- Working with community groups
- Search icon
- Join the STEM Community

## Spreadsheets Make Sense

Favourite colours - carry out a survey and use ICT to display the data

Multiplication spreadsheet - create a multiplication table

Pocket money - perform repeated calculations quickly

Planning a party - create a simple model using a variety of operations

142857 multiplication table - identify recurring decimals

Again and again - generate a sequence using an iterative process leading to limits

Square roots investigation - identify a limit using patterns and algebra

Squidge - use brackets to create an algebraic expression to investigate sequences

A rich aunt - appreciate the power of a spreadsheet to solve real-life problem

Averaging out - use the mean to generate a sequence of numbers leading to a limit

A problem of power - introduce students to modulo function

Marbles - use algebra to model a real life situation

Strings - numbers which are formed from the integer parts of terms of sequences

Converging sequences - the limit of a sequence formed from the ratios of corresponding terms

Geometry sequences - investigate infinite sequences with finite sums

## Show health and safety information

## Show downloads

- Primary Hub
- Art & Design
- Design & Technology
- Health & Wellbeing
- Secondary Hub
- Citizenship
- Primary CPD
- Secondary CPD
- Book Awards
- All Products
- Primary Products
- Secondary Products
- School Trips
- Trip Directory
- Trips by Subject
- Trips by Type
- Trips by Region
- Submit a Trip Venue

## Trending stories

## Top results

## Spreadsheet Sweet Shop – Forget Data Input, Excel Is An Easy Way To Introduce Kids To Programming Basics

"Looking at modelling and variables will provide a strong foundation for learning to code"

## Behind the scenes

## What if…

## Real-life scenarios

- Calculating what percentage of pupils in the school come by bus, train, car or walk
- Planning a party (stipulate a maximum spend of, say, £50)
- Creating a school timetable (stipulate a maximum number of hours per week such as 100)
- Sports: use conditional formatting to show highest and lowest scorers, for example

## Digital skills

## Sign up to our newsletter

Which sectors are you interested in?

Thank you for signing up to our emails!

## You might also be interested in...

## Why join Teachwire?

Exclusive classroom resource downloads

Free worksheets and lesson plans

CPD downloads, written by experts

Resource packs to supercharge your planning

Special web-only magazine editions

Educational podcasts & resources

Access to free literacy webinars

## Create free account

By signing up you agree to our terms and conditions and privacy policy .

Already have an account? Log in here

## Thanks, you're almost there

To help us show you teaching resources, downloads and more you’ll love, complete your profile below.

## Welcome to Teachwire!

## Log in to Teachwire

Not registered with Teachwire? Sign up for free

## Reset Password

Remembered your password? Login here

## Simon Haughton's website

15 november 2013, year 6 spreadsheet lessons 2013.

Download 1. McDonald's spreadsheet (insructions)

Download 1. McDonald's spreadsheet (template)

Download 2. Manchester attractions spreadsheet (instructions)

Download 2. Manchester attractions spreadsheet (template)

Download Manchester Attractions Prices

Examples of work produced: Lesson 1 Lesson 2

## 15 October 2013

Introducing spreadsheets lessons 2013.

My tried and tested collection of resources for introducing spreadsheets to KS2 children:

Download LI for Introduction to Spreadsheets by Simon Haughton

Download 1. Wizard's Challenge

Download 4. Sweet Shop Problem

Download 6. Shopping Bills - Alternative

http://www.ferryhalim.com/orisinal/g3/00starry.swf

Download 8. Conditional Formatting Quiz

## 11 December 2011

Introducing spreadsheets - planning, 16 november 2010, spreadsheet quiz.

## 27 May 2010

Introducing spreadsheets - week 5.

## 20 May 2010

Introducing spreadsheets - week 4.

- a =MI N() formula to identify the minimum total points scored by a child;
- a =M AX() formula to identify the maximum total points scored by a child;

## 10 May 2010

Introducing spreadsheets - week 3.

Download Race Points Spreadsheet

Download Shopping Bills Spreadsheet

## 29 April 2010

Introducing spreadsheets - week 2.

I began by showing them a blank Excel sheet and asking them to copy the following table into it:

## 22 April 2010

Introducing spreadsheets - week 1.

- Level 1 – Just addition calculations (+)
- Level 2 – A mixture of addition and subtraction calculations (+ -)
- Level 3 – A mixture of additions, subtractions, divisions and multiplications (+ - / *)

## Mr Haughton

## Recent Comments

Teaching Spreadsheets - A guide to introducing Spreadsheets to Primary Students

## Year 2 & 3

In Year 2 & 3 I have been teaching spreadsheets so they can achieve the following skills:

Recognise the elements of a spreadsheet (cell, row, column)

Move to a specific cell on a spreadsheet (eg C7)

Enter text or numbers & move among cells in a spreadsheet

Select & format a cell or range of cells

Create an Assignment in Google Classroom

Organise and present data in a data handling application

Use own collected data to create and format graphs (eg, bar chart, pie chart)

Students would then need to come up with three questions they need to ask about the data. Such as :

Which colour car passed the school gate the most?

Did how many more or less yellow cars were there than the red cars?

Enter & use simple formulae (eg A2+B2)

Use basic functions (eg, SUM, AVERAGE etc)

Use drag and copy to apply functions & formulae to a range of cells

Traffic webcams around the world

Piazza Venezia, Altare della Patria - Rome

Antoine de Paule Square - Paola

## Starter Activity

Once the time limit is up, students to transfer their data onto the spreadsheet.

Ask students to start asking questions about the data they have gathered.

The use of cells, columns and rows

Using single quote to enter special characters as text

Using the Dollar sign to fix a formula position

The asterisk as a multiplication symbol

Conditions using the IF Function

Embedded functions with other functions

Formating cells with the fill option

Colouring cells based on conditions

This lesson will look at how to achieve the following:

Dollar sign to fix a formula position

Times table Quiz using Spreadsheets Lesson 1 - alignment, basic formula, dollar sign, asterisk, copy

In this lesson you will use the following to turn this spreadsheet into a quiz.

Times table Quiz using Spreadsheets Lesson 2 - If then else conditions, hiding columns, Google sheet

Times table Quiz using Spreadsheets Lesson 3 - embed functions, IF THEN ELSE condition, Google Sheet

Times table Quiz using Spreadsheets Lesson 4 - Conditional Formatting, Colour, Color, Google Sheet

Times table Quiz using Spreadsheets Lesson 5 - Algebraic Equation Algebra Substitution Google Sheet

## The Spreadsheet Challenges

## Featured Posts

Should young people of today need to learn about World War II?

Breaking down the Coding Barriers for our Teachers

Using Twitter with Primary or Elementary Students

## Recent Posts

UK School Closures - Are you prepared? Advice, Suggestions and Ideas on how to get prepared.

The Edtech Files: Episode 3 - Using iMovie on the iPad

The Edtech Files: Episode 2 - Creating a Magazine Cover

The Edtech File: Episode 1 - Teaching Copy & Paste

## Search By Tags

Join our email newsletter to receive free updates!

Search for Ideas and Resources

## More English

## Popular Books

## Popular Authors

- Mental Starters
- Problem Solving
- Maths Inspiration Posters
- Picture Puzzles
- Place Value
- Number Patterns
- Subtraction
- Multiplication
- All Four Operations
- Percentages

## More Number

- Animals and Habitats
- Circuits and Electricity
- Earth and Beyond
- Experiments and Investigations
- Human Biology

## More Science

## More Computing

## Popular Artists

## Follow us on...

- Cutting and Scissor Skills
- School Uniforms
- Local Geography
- Global Geography
- Maps and Atlases
- Natural Disasters
- Geography Inspiration
- Britain since 1948
- Early Human History
- World War 1
- World War 2
- History Inspiration Posters
- Sign Language
- Warm-up Ideas
- Parachute Activities
- Cool-down Ideas

## Religious Education

## Classroom Management

- Celebrating Birthdays
- Classroom Countdowns
- Classroom Quotes
- Classroom Rewards
- Display Tips and Resources
- Finishing Work
- Gaining Attention
- Managing Breaks
- Moving Around
- School Club Resources
- Staffroom Quotes
- Transition Activities
- Working with Parents

## Time-Fillers

## Other Topics

- Commonwealth (+Games)
- Famous People
- Football and World Cup
- Harvest on the Farm
- Keeping Healthy
- Kings and Queens
- Lights, Camera, Action!
- Magic and Mystery
- Outdoor Learning
- People Who Help Us
- Rainforests
- Staying Safe Online
- Superheroes
- The Environment
- Traditional Tales
- Under the Sea
- Have you made a great resource? Share it here!
- Stay up to date and receive our free email newsletter!

## IMAGES

## VIDEO

## COMMENTS

In this video, Twinkl Teacher Arthur showcases Darshna's brilliant lesson series which teaches children how to use spreadsheets:

Learners will collect and organise data in a format of their choice. They will then explore how data can be structured in a table.

If you're finding learning on KS2 Computing to be a bit of a struggle, this fun and useful lesson on Spreadsheets could be just what you and your children

Free online lessons for students across a variety of UK school curriculum subjects. ... What is a spreadsheet? 7m video · Lesson 2

This resource from SMILE contains 21 activities for using spreadsheets to solve mathematical problems. Teachers' notes give advice on appropriate ways of

KS1 computing – IT around us lesson plan. Download Now Download Now. PrimaryComputing. Spreadsheets are dead, right? Wrong! Not only are they a great tool

Over the past five years, my theme park spreadsheet lessons for Year 6 have ... of resources for introducing spreadsheets to KS2 children:

So how can we teach spreadsheet effectively in Year 3, 4, 5 and 6? Giving the students a basic understanding of what they do and then ensuring they understand

Primary Resources - free worksheets, lesson plans and teaching ideas for primary and elementary teachers.

Help your children to learn about and use spreadsheets effectively with our teaching ideas and resources.