Skip to content
PlayOwl

Computers & Digital Literacy · Grade 5

Spreadsheets, Formulas and Charts

Using Grid Sheet, a pretend spreadsheet, learners summarise data with SUM, AVERAGE, MIN and MAX, fill a formula down a column and predict how its cell references shift, sort and filter rows without breaking them apart, and choose and read the right chart (bar, line or pie) for a question, finishing by describing what a chart shows.

  • 4 lessons
  • About 80 minutes
  • Spreadsheets and charts check: 8 questions
  • Ways to answer: fill in the blanks, choose an answer, estimate, match pairs, type a number and put in order
Try it now (no account) One of the five free starter courses Open in PlayOwl

What learners will discover

  • Use SUM, AVERAGE, MIN and MAX on a range and explain what each returns.
  • Fill a formula down a column and predict how relative references change; sort and filter whole rows to answer questions.
  • Choose and read the right chart (bar for comparing groups, line for change over time, pie for parts of a whole) with a title and labelled axes.

Lessons

  1. Summary functions 4 steps2 practiceabout 20 min
  2. Fill, sort and filter 5 steps4 practiceabout 20 min
  3. Choose the right chart 3 steps2 practiceabout 18 min
  4. Tell the story of the data 3 steps2 practiceabout 22 min
  5. Spreadsheets and charts check 8 questions at the end

Keep exploring

More 5th grade computer skills

Guide for grown-ups