Skip to content
PlayOwl

Computers & Digital Literacy · Grade 6

Spreadsheets and Data Visualization

Learners work in a fictional spreadsheet program with a library reading challenge, a community-garden harvest log and bike-share ride counts. They write formulas with cell references, use SUM, AVERAGE, MIN and MAX on ranges, predict how formulas change when filled down, sort and filter to answer questions, and choose the chart that fits the question: bar, line, pie or scatter.

  • 4 lessons
  • About 100 minutes
  • Spreadsheets and charts check: 10 questions
  • Ways to answer: fill in the blanks, choose an answer, trace code, 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

  • Identify cells, rows, columns and ranges, and write formulas that start with = and use cell references instead of typed numbers.
  • Use SUM, AVERAGE, MIN and MAX on ranges and predict how relative references change when a formula is filled down.
  • Sort and filter a table, keeping rows together, to answer questions about the data.
  • Choose a chart that fits the question: bar for comparing categories, line for change over time, pie for parts of one whole with few slices, scatter for relationships.

Lessons

  1. Cells, references and formulas 6 steps4 practiceabout 24 min
  2. Functions and filling down 7 steps5 practiceabout 26 min
  3. Sort and filter 7 steps5 practiceabout 24 min
  4. Choosing the right chart 6 steps3 practiceabout 26 min
  5. Spreadsheets and charts check 10 questions at the end

Keep exploring

More 6th grade computer skills

Guide for grown-ups