Skip to content
PlayOwl

Computers & Digital Literacy · Grade 9

Spreadsheets, Formulas and Data Quality

Using a fictional bike-share's trip log, learners make formulas copy correctly with relative, absolute and mixed references, summarize data with COUNTIF, SUMIF and AVERAGEIF, classify with nested IF and retrieve values with an exact-match lookup. They then judge data against six quality dimensions, design validation rules, and audit a sheet for error values and the silent mistakes that produce plausible but wrong numbers.

  • 4 lessons
  • About 120 minutes
  • Check what you learned: 10 questions
  • Ways to answer: choose an answer, trace code, highlight a text, match pairs, type a number and sort into groups
Try it now (no account) One of the five free starter courses Open in PlayOwl

What learners will discover

  • Predict how relative, absolute and mixed references change when a formula is copied, and choose the reference type that makes a formula fill correctly.
  • Summarize and classify data with COUNTIF, SUMIF, AVERAGEIF and nested IF, and retrieve values with an exact-match lookup.
  • Diagnose data problems using the dimensions accuracy, completeness, consistency, timeliness, validity and uniqueness, and choose validation rules that prevent them.
  • Audit a spreadsheet by interpreting error values, tracing formulas and finding silent errors such as short ranges and hard-coded numbers.

Lessons

  1. References that copy correctly 7 steps4 practiceabout 26 min
  2. Conditional summaries, nested IF and lookups 7 steps4 practiceabout 30 min
  3. Data quality and validation rules 6 steps4 practiceabout 26 min
  4. Auditing formulas and error values 7 steps4 practiceabout 24 min
  5. Check what you learned 10 questions at the end

Keep exploring

More 9th grade computer skills

Guide for grown-ups