Collecting & Visualising Data

Data Handling

1
2
3
4
5
6

Welcome to Data Handling! In this strand, you will learn how to collect, organize, visualize, and analyze information using pictograms, branching databases, charts, and digital logging tools to answer real-world questions.

Level 1

Sorting & Pictograms

Sorting objects by attributes and creating pictograms.

Learning objective

Learning About: Data Sorting. Learning To: Create pictograms. Learning To Be: Inquirer.

Let's Go!

Learn

Data is information we collect! By grouping items with shared attributes and drawing pictograms, we can visually compare amounts quickly.

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Sort & Picture!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Sort physical or digital items by one property (e.g. colour).

Developing

Count items in groups and place them in row lists.

Secure (Goal)

Construct a simple digital pictogram where 1 picture = 1 item.

Mastery

Interpret pictograms to answer 'which has the most/least?'. Typing: 5 WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Sorting & Pictograms includes:

  • Core Deliverable: Sort & Picture!
  • Target Quality: Construct a simple digital pictogram where 1 picture = 1 item.
  • Excellence & Polish: Interpret pictograms to answer 'which has the most/least?'. Typing: 5 WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

How confident are you at reading data from a simple pictogram?

Low
High

Learning check

Learning Check

In a pictogram where 1 apple icon = 1 student, how many students chose apples if there are 4 icons?

Select the matching icon or option below:

Answer correctly to unlock the next level.

Great job! 4 icons equal 4 students when each icon represents 1.Count each apple icon again carefully.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: See, Think, Wonder

Achievement pathway

  • Foundation: Sort physical or digital items by one property (e.g. colour).
  • Developing: Count items in groups and place them in row lists.
  • Secure: Construct a simple digital pictogram where 1 picture = 1 item.
  • Mastering: Interpret pictograms to answer 'which has the most/least?'. Typing: 5 WPM.

Curriculum links

Curriculum strand: MAT.01.C.1.4

Outcome: DH-O-01 โ€” Sorting objects by attributes and creating pictograms.

PYP: Form ยท Organizing objects helps us make sense of our world.

Learner profile: Inquirer

Competency tags

  • data-sorting
  • pictograms
  • attributes
  • counting

Gate support

Accessibility alternative:

Teacher override: allow

Back to top

Locked level

Level 2: Branching Databases

Complete the previous learning check to unlock this next level.

Level 2

Branching Databases

Binary classification and yes/no branching keys.

Learning objective

Learning About: Binary Keys. Learning To: Build decision trees. Learning To Be: Thinker.

Let's Go!

Learn

Branching databases divide items using clear yes/no questions. Each question splits the group into two smaller paths until every item is uniquely identified!

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Build a Decision Tree!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Answer simple yes/no questions about an object's properties.

Developing

Follow a printed branching database key to identify an item.

Secure (Goal)

Create a 3-level branching database using binary (yes/no) questions.

Mastery

Test a branching key to ensure every item reaches a unique destination. Typing: 10 WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Branching Databases includes:

  • Core Deliverable: Build a Decision Tree!
  • Target Quality: Create a 3-level branching database using binary (yes/no) questions.
  • Excellence & Polish: Test a branching key to ensure every item reaches a unique destination. Typing: 10 WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

Did your Yes/No questions successfully separate all four items?

Low
High

Learning check

Learning Check

You want to split birds and fish in a branching database. Which Yes/No question works best?

Choose the best Yes/No question.

Answer correctly to unlock the next level.

Correct! 'Does it have feathers?' clearly separates birds from fish.Think about which question strictly separates birds from fish.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Zoom In

Achievement pathway

  • Foundation: Answer simple yes/no questions about an object's properties.
  • Developing: Follow a printed branching database key to identify an item.
  • Secure: Create a 3-level branching database using binary (yes/no) questions.
  • Mastering: Test a branching key to ensure every item reaches a unique destination. Typing: 10 WPM.

Curriculum links

Curriculum strand: MAT.02.C.1.4

Outcome: DH-O-02 โ€” Binary classification and yes/no branching keys.

PYP: Function ยท Classification systems help us organize and identify living things and objects.

Learner profile: Thinker

Competency tags

  • branching-databases
  • binary-trees
  • classification
  • yes-no-questions

Gate support

Accessibility alternative:

Teacher override: allow

Back to top

Locked level

Level 3: Bar Charts & Tables

Complete the previous learning check to unlock this next level.

Level 3

Bar Charts & Tables

Collecting data via tally charts and generating bar charts.

Learning objective

Learning About: Data Visualization. Learning To: Plot bar charts. Learning To Be: Knowledgeable.

Let's Go!

Learn

Bar charts turn rows of numbers into visual towers! Placing categories on the horizontal X-axis and quantities on the vertical Y-axis lets you compare results at a glance.

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Tally & Chart!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Record tally marks in groups of 5 on a frequency table.

Developing

Input numerical data into a digital table with labeled headers.

Secure (Goal)

Generate a digital bar chart with custom title and labeled X/Y axes.

Mastery

Interpret bar chart scales (e.g. intervals of 2, 5, 10) to compare data points. Typing: 15 WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Bar Charts & Tables includes:

  • Core Deliverable: Tally & Chart!
  • Target Quality: Generate a digital bar chart with custom title and labeled X/Y axes.
  • Excellence & Polish: Interpret bar chart scales (e.g. intervals of 2, 5, 10) to compare data points. Typing: 15 WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

How easy was it to read the highest value from your bar chart?

Low
High

Learning check

Learning Check

Where should category names (like Red, Blue, Green) be placed on a standard vertical bar chart?

Select the correct axis label.

Answer correctly to unlock the next level.

Correct! Categories belong on the horizontal X-axis, while quantities go on the vertical Y-axis.Think about where the names of categories sit on a vertical chart.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Think, Puzzle, Explore

Achievement pathway

  • Foundation: Record tally marks in groups of 5 on a frequency table.
  • Developing: Input numerical data into a digital table with labeled headers.
  • Secure: Generate a digital bar chart with custom title and labeled X/Y axes.
  • Mastering: Interpret bar chart scales (e.g. intervals of 2, 5, 10) to compare data points. Typing: 15 WPM.

Curriculum links

Curriculum strand: CM.02.B.1.1

Outcome: DH-O-03 โ€” Collecting data via tally charts and generating bar charts.

PYP: Connection ยท Visualizing numerical data reveals trends and patterns clearly.

Learner profile: Knowledgeable

Competency tags

  • bar-charts
  • tally-charts
  • axis-labels
  • data-entry

Gate support

Accessibility alternative:

Teacher override: allow

Back to top

Locked level

Level 4: Line Graphs & Data Loggers

Complete the previous learning check to unlock this next level.

Level 4

Line Graphs & Data Loggers

Time-series continuous data and data logging sensors.

Learning objective

Learning About: Continuous Data. Learning To: Plot line graphs. Learning To Be: Inquirer.

Let's Go!

Learn

Unlike bar charts for discrete categories, line graphs show continuous change over time! Data loggers automatically record temperature, light, or sound levels every minute.

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Log & Graph Over Time!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Identify that line graphs show how data changes over time.

Developing

Connect temperature or light sensors to a digital data logger.

Secure (Goal)

Record continuous readings over time and plot a digital line graph.

Mastery

Identify peaks, troughs, and rates of change on a time-series graph. Typing: 20 WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Line Graphs & Data Loggers includes:

  • Core Deliverable: Log & Graph Over Time!
  • Target Quality: Record continuous readings over time and plot a digital line graph.
  • Excellence & Polish: Identify peaks, troughs, and rates of change on a time-series graph. Typing: 20 WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

Can you easily identify when the temperature reached its highest point on your line graph?

Low
High

Learning check

Learning Check

You want to track how the temperature outside changes continuously from 8 AM to 3 PM. Which chart type is best?

Choose the correct graph type.

Answer correctly to unlock the next level.

Spot on! Line graphs are the best tool for showing continuous changes over time.Think about which graph connects data points across time.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: See, Think, Wonder

Achievement pathway

  • Foundation: Identify that line graphs show how data changes over time.
  • Developing: Connect temperature or light sensors to a digital data logger.
  • Secure: Record continuous readings over time and plot a digital line graph.
  • Mastering: Identify peaks, troughs, and rates of change on a time-series graph. Typing: 20 WPM.

Curriculum links

Curriculum strand: CM.03.B.1.3

Outcome: DH-O-04 โ€” Time-series continuous data and data logging sensors.

PYP: Change ยท Environmental sensors allow continuous monitoring of physical change.

Learner profile: Inquirer

Competency tags

  • line-graphs
  • data-loggers
  • temperature-sensors
  • continuous-data

Gate support

Accessibility alternative:

Teacher override: allow

Back to top

Locked level

Level 5: Flat-File Databases

Complete the previous learning check to unlock this next level.

Level 5

Flat-File Databases

Database fields, records, searching, and sorting.

Learning objective

Learning About: Structured Records. Learning To: Query databases. Learning To Be: Open-minded.

Let's Go!

Learn

A database is an organized collection of records! Each row is one full Record (e.g. a planet) and each column is a specific Field (e.g. Diameter or Moons).

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Search & Filter Records!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Distinguish between a database 'field' (column) and 'record' (row).

Developing

Enter new records into an existing flat-file database schema.

Secure (Goal)

Sort records alphabetically or numerically and perform single-field searches.

Mastery

Apply multi-criteria search filters (AND/OR) to extract targeted subsets. Typing: 25 WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Flat-File Databases includes:

  • Core Deliverable: Search & Filter Records!
  • Target Quality: Sort records alphabetically or numerically and perform single-field searches.
  • Excellence & Polish: Apply multi-criteria search filters (AND/OR) to extract targeted subsets. Typing: 25 WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

How confident do you feel using search filters to find specific records in a database?

Low
High

Learning check

Learning Check

In a database containing information about students, what represents all the information about ONE single student?

Select the correct database term.

Answer correctly to unlock the next level.

Mastered! A row (Record) contains all attributes belonging to one single entity.Remember: Columns are Fields, while full rows are Records.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: I used to think...

Achievement pathway

  • Foundation: Distinguish between a database 'field' (column) and 'record' (row).
  • Developing: Enter new records into an existing flat-file database schema.
  • Secure: Sort records alphabetically or numerically and perform single-field searches.
  • Mastering: Apply multi-criteria search filters (AND/OR) to extract targeted subsets. Typing: 25 WPM.

Curriculum links

Curriculum strand: CM.03.B.1.3

Outcome: DH-O-05 โ€” Database fields, records, searching, and sorting.

PYP: Responsibility ยท Structured databases enable efficient searching, filtering, and analysis of complex records.

Learner profile: Open-minded

Competency tags

  • flat-file-database
  • records
  • fields
  • sorting
  • searching

Gate support

Accessibility alternative:

Teacher override: allow

Back to top

Locked level

Level 6: Analytics & Dashboards

Complete the previous learning check to unlock this next level.

Level 6

Analytics & Dashboards

Data cleaning, analysis, infographics, and evaluating data bias.

Learning objective

Learning About: Data Analytics. Learning To: Synthesize infographics. Learning To Be: Reflective.

Let's Go!

Learn

Big data analytics transforms raw survey and sensor data into actionable insights! By cleaning data, building interactive dashboards, and recognizing collection bias, we make informed, ethical decisions.

๐Ÿ“Š
Spreadsheet SandboxLevel 1: Cells, Rows & Data Entry
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total=SUM(B2:B4)
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Try it yourself

Build an Analytics Dashboard!

๐ŸŒŸ Student Project GuideSuccess Criteria & WAGOLL (What A Good One Looks Like)โ–พ

๐ŸŽฏ Task Success Criteria (Rubric)

Foundation

Clean dirty data by detecting missing values or duplicate entries.

Developing

Synthesize multiple charts into a cohesive single-page dashboard.

Secure (Goal)

Create a digital infographic communicating key findings to an audience.

Mastery

Critically evaluate dataset sampling bias and ethical implications of data collection. Typing: 30+ WPM.

๐Ÿ‘€ What A Good One Looks Like (WAGOLL)

Exemplar Standard

A top-tier student project for Analytics & Dashboards includes:

  • Core Deliverable: Build an Analytics Dashboard!
  • Target Quality: Create a digital infographic communicating key findings to an audience.
  • Excellence & Polish: Critically evaluate dataset sampling bias and ethical implications of data collection. Typing: 30+ WPM.
๐Ÿ“
Save to Your Website Portfolio:

When you finish creating your project in your software, copy the share link or take a screenshot and publish it onto your student portfolio website!

โญSelf-Assessment: How confident do you feel with this skill?

Reflect

How confident are you at assembling multiple charts into an analytical dashboard?

Low
High

Learning check

Learning Check

You collect survey data on favourite sports, but only ask students on the basketball court. What issue does this dataset have?

Choose the best analytical practice.

Answer correctly to complete this strand.

Spot on! Asking only basketball players creates sampling bias because the sample group isn't representative of the whole school.Think about whether the survey group fairly represents everyone.
Teacher setup, curriculum links and progress descriptors

Spark support

Routine: Step Inside

Achievement pathway

  • Foundation: Clean dirty data by detecting missing values or duplicate entries.
  • Developing: Synthesize multiple charts into a cohesive single-page dashboard.
  • Secure: Create a digital infographic communicating key findings to an audience.
  • Mastering: Critically evaluate dataset sampling bias and ethical implications of data collection. Typing: 30+ WPM.

Curriculum links

Curriculum strand: MAT.03.E.1.6

Outcome: DH-O-06 โ€” Data cleaning, analysis, infographics, and evaluating data bias.

PYP: Reflection ยท Data analytics informs decision-making but requires critical evaluation for accuracy and bias.

Learner profile: Reflective

Competency tags

  • data-analytics
  • data-cleaning
  • dashboards
  • infographics
  • data-ethics

Gate support

Accessibility alternative:

Teacher override: allow

๐ŸŽ’ Students Home โ†’

Install App for Classroom

One-click fullscreen learning for Chromebooks, iPads & PCs

๐Ÿ–ฅ๏ธ
Distraction-FreeFullscreen window without browser tabs or search clutter.
โšก
1-Tap LaunchPin directly to the Chromebook shelf, iPad dock, or Windows taskbar.
๐Ÿ“ถ
Classroom SpeedInstant cached loads for lessons and simulators even on school Wi-Fi.
๐Ÿ”’
Safe & Ad-Free100% free, private, and no app store logins or passwords needed.
  1. 1
    Click the Install button

    In your browser, look at the right end of the top web address bar for the ๐Ÿ’ป Install or โค“ icon.

  2. 2
    Confirm "Install"

    A popup will ask if you want to install "Ed Tech Hub". Click Install.

  3. 3
    Pin to your Shelf

    Right-click (or two-finger tap) the app icon in your Chromebook bottom shelf and select "Pin"!