Skip to content
PlayOwl

Computers & Digital Literacy · Grade 4

Spreadsheets and Formulas

Using Grid Sheet, a pretend spreadsheet, learners name cells by column letter and row number, read and write formulas that start with = (such as `=B2*C2`), add a range with `=SUM(D2:D4)`, and see that formulas recalculate automatically when data changes, solving a class bake-sale problem along the way.

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

What learners will discover

  • Name the parts of a spreadsheet: cells, rows (numbers), columns (letters), cell addresses such as B3 and ranges such as B2:B5.
  • Read and write simple formulas that start with =, use cell addresses to add, subtract, multiply or divide, and add a range with SUM.
  • Explain that formulas recalculate automatically when data changes, and use a spreadsheet to answer a real question.

Lessons

  1. Cells, rows and columns 3 steps2 practiceabout 16 min
  2. Formulas 4 steps2 practiceabout 18 min
  3. Adding a range with SUM 4 steps3 practiceabout 16 min
  4. Change it and watch it update 5 steps3 practiceabout 20 min
  5. Spreadsheet check 8 questions at the end

Keep exploring

More 4th grade computer skills

Guide for grown-ups