DIG091A · Term 2 · Data, Spreadsheets & Information Systems

Interpreting Data in a Dataset

Use spreadsheet-style tools to identify patterns, trends and anomalies in a structured student dataset.

🎯 Learning Intention

We are learning to interpret structured data using spreadsheet tools to identify patterns, trends, and anomalies for real-world decision-making.

✅ Success Criteria

  • I can apply sorting and filtering to organise data.
  • I can use conditional formatting to highlight important information.
  • I can interpret the data to explain patterns, trends, or issues.

🧠 Warm Up – Think Like a Data Analyst

Scenario: A teacher has a large dataset of student scores.

Can you quickly answer: Who improved the most? Who failed? Which class is doing best?

Problem: The data is there… but we can’t easily see the information until we sort, filter, highlight and summarise it.

🔍 What is Interpreting Data?

Data = raw numbers and text.

Information = meaning we extract from the data.

Key idea: Interpreting data means understanding what the data is telling us, not just reading the numbers.

🛠️ Excel Tools for Interpretation

SORT Organises data, such as highest to lowest.

FILTER Shows only data that meets conditions.

CONDITIONAL FORMATTING Highlights important data visually.

🎨 Click to see examples
  • 🔴 Highlight scores below 50.
  • 🟢 Use a colour scale for high to low results.
  • ⚠️ Use icons to show performance levels.

📚 Key Vocabulary

Pattern Something that repeats.

Trend A direction or movement in the data.

Outlier A value far away from the others.

Anomaly Something unusual that may need investigation.

🧪 Interactive Dataset

Use the controls to practise the same thinking before using Excel. Scores below 50 can be highlighted like conditional formatting.

NameClassGenderEnglishMathsScienceAverageFails
Highest class average—
Students failing 2+ subjects—These students may need targeted support.
Needs support in Maths—Maths score below 50.

📊 Class Average Comparison

Use this to help answer: Which class has the highest performance?

📈 Subject Average Comparison

Use this to identify strengths, weaknesses, patterns and possible issues.

🧪 Guided Practice

  1. Sort to find the top 3 English scores.
  2. Filter to find students who failed 2+ subjects.
  3. Apply conditional formatting to highlight failing grades.

Teacher tip: Don’t just find answers — explain what they mean.

🎯 Your Task – Interpret the Data

Use the interactive dataset or Excel to answer:

  • Which class has the highest performance?
  • Are boys or girls performing better?
  • Who needs support in Maths?

Sentence starters:

  • “I can see that…”
  • “This suggests that…”
  • “A pattern in the data is…”

🧠 Think Like an Analyst

💡 Example Thinking
  • “Most low scores are in one class…”
  • “There is one very high score, which may be an outlier…”
  • “Maths has more failures than English…”

✅ Progress Check

  • ☐ I used sorting to organise data.
  • ☐ I used filtering to find specific data.
  • ☐ I used conditional formatting.
  • ☐ I explained what the data shows.

💬 Exit Ticket

Answer in your book:

  • What is one pattern you found?
  • What is one trend or issue?
  • Why is interpreting data important?
Lesson 5: Visualising Data →