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!

Step media

Learn

Data is information we collect! By grouping items with shared attributes and drawing pictograms, we can visually compare amounts quickly. In computing, organizing objects helps us make sense of our world. As you explore the interactive Spreadsheet Simulator below, focus on how to construct a simple digital pictogram where 1 picture = 1 item.

Interactive Simulator Sandbox
๐Ÿ“Š
Spreadsheet StudioStep 1 โ€ข Bronze Tier
|
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Apply Simulator Skills โ€ข Try it yourself

Sort & Picture!

๐Ÿ”„Direct Simulator Transfer: Step 1 Tasks 1, 2 & 3

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

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

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

Teacher notes: Facilitate the See, Think, Wonder routine for 2โ€“3 minutes. Encourage students to connect the prompt to Form (Organizing objects helps us make sense of our world.).

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: Students may verbally explain or point to the correct answer for "In a pictogram where 1 apple icon = 1 student, how many students chose apples if there are 4 icons?" with a teacher or teaching assistant.

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!

Step media

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! In computing, classification systems help us organize and identify living things and objects. As you explore the interactive Diagram Builder Simulator below, focus on how to create a 3-level branching database using binary (yes/no) questions.

Interactive Simulator Sandbox
Diagram Curriculum:Step 2 โ€ข Bronze Tier
๐Ÿท๏ธ
Step 1 โ€ข Bronze (Level 1): Shapes & Labels - Visual Node Placement

Drag or click picture nodes into labeled containers or boxes on screen to organize ideas visually.

In Progress

Apply Simulator Skills โ€ข Try it yourself

Build a Decision Tree!

๐Ÿ”„Direct Simulator Transfer: Step 2 Tasks 4, 5 & 6

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

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

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

Teacher notes: Facilitate the Zoom In routine for 2โ€“3 minutes. Encourage students to connect the prompt to Function (Classification systems help us organize and identify living things and objects.).

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: Students may verbally explain or point to the correct answer for "You want to split birds and fish in a branching database. Which Yes/No question works best?" with a teacher or teaching assistant.

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!

Step media

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. In computing, visualizing numerical data reveals trends and patterns clearly. As you explore the interactive Spreadsheet Simulator below, focus on how to generate a digital bar chart with custom title and labeled X/Y axes.

Interactive Simulator Sandbox
๐Ÿ“Š
Spreadsheet StudioStep 3 โ€ข Bronze Tier
|
A1fx
ABC
1ItemAmount
2Apples5
3Bananas3
4Carrots2
5Total
Challenge: Click cell B5 to inspect how the AutoSum formula adds up column B!

Apply Simulator Skills โ€ข Try it yourself

Tally & Chart!

๐Ÿ”„Direct Simulator Transfer: Step 3 Tasks 7, 8 & 9

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

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

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

Teacher notes: Facilitate the Think, Puzzle, Explore routine for 2โ€“3 minutes. Encourage students to connect the prompt to Connection (Visualizing numerical data reveals trends and patterns clearly.).

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: Students may verbally explain or point to the correct answer for "Where should category names (like Red, Blue, Green) be placed on a standard vertical bar chart?" with a teacher or teaching assistant.

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!

Step media

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. In computing, environmental sensors allow continuous monitoring of physical change. As you explore the interactive Drawing Layers Simulator below, focus on how to record continuous readings over time and plot a digital line graph.

Interactive Simulator Sandbox
Curriculum:Step 4 โ€ข Bronze Tier
๐Ÿ“„
Step 1 โ€ข Bronze (Level 1): Page Balance - Text & Image Placement

Place text and one image on a digital page without overlapping elements.

In Progress

ECO-GUARDIANS NEWSLETTER

Issue 4: Protecting Urban Biodiversity

Urban biodiversity creates resilient community ecosystems. Local parks provide vital stopping points for migratory birds and pollinating native bees.

๐Ÿ๐ŸŒธ
Native Honeybee on Clover

Planting micro-gardens with perennial wildflowers restores nectar corridors along city streets.

Layers & Stacking Order

4 Elements
100%
๐Ÿท๏ธTitle Hierarchy (H1)
๐Ÿ–ผ๏ธPollinator Graphic Image
๐Ÿ“ฐ2-Column Body Article
๐Ÿ’กCallout Box & Footer
Design Pro-Tip:

Maintain comfortable breathing space (margins) so eye movement flows naturally across the headline.

Apply Simulator Skills โ€ข Try it yourself

Log & Graph Over Time!

๐Ÿ”„Direct Simulator Transfer: Step 4 Tasks 10, 11 & 12

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

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

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

Teacher notes: Facilitate the See, Think, Wonder routine for 2โ€“3 minutes. Encourage students to connect the prompt to Change (Environmental sensors allow continuous monitoring of physical change.).

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: Students may verbally explain or point to the correct answer for "You want to track how the temperature outside changes continuously from 8 AM to 3 PM. Which chart type is best?" with a teacher or teaching assistant.

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!

Step media

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). In computing, structured databases enable efficient searching, filtering, and analysis of complex records. As you explore the interactive Website Builder Simulator below, focus on how to sort records alphabetically or numerically and perform single-field searches.

Interactive Simulator Sandbox
Curriculum:Step 5 โ€ข Bronze Tier
๐ŸŒ
Step 1 โ€ข Bronze (Level 1): What is a Website? - Website Feature Identification

Name at least one essential feature of a website (e.g. navigation menu or homepage) with support.

In Progress
๐Ÿ  Page: Home4 blocks on this page

Welcome to Our Digital Space!

Designed to share student ideas, projects, and community action with the world.

๐ŸŒฑ๐Ÿ“ธFeature Project Banner Image
๐ŸŽฏ Purpose & Goals
Empowering students to publish creative writing, artwork, and research studies for global peers.
๐Ÿ‘ฅ Target Audience
Tailored for classmates, teachers, families, and partner schools worldwide.

Apply Simulator Skills โ€ข Try it yourself

Search & Filter Records!

๐Ÿ”„Direct Simulator Transfer: Step 5 Tasks 13, 14 & 15

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

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

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...

Teacher notes: Facilitate the I used to think... routine for 2โ€“3 minutes. Encourage students to connect the prompt to Responsibility (Structured databases enable efficient searching, filtering, and analysis of complex records.).

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: Students may verbally explain or point to the correct answer for "In a database containing information about students, what represents all the information about ONE single student?" with a teacher or teaching assistant.

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!

Step media

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. In computing, data analytics informs decision-making but requires critical evaluation for accuracy and bias. As you explore the interactive Python Console Simulator below, focus on how to create a digital infographic communicating key findings to an audience.

Interactive Simulator Sandbox
Python Curriculum:Step 6 โ€ข Bronze Tier
๐Ÿ
Step 1 โ€ข Bronze (Level 1): Code Typing - The Print Statement

Type print("Hello World!") in the code editor and click โ–ถ Run Code to execute your first Python statement.

In Progress
๐Ÿmain.pyClean
1
Snippets:
Target: Type print("Hello World!") and run your script.
Interactive Python REPL (v3.12.2)
Python 3.12.2 (tags/v3.12.2:5acc80f, Feb 6 2024, 01:22:40) [MSC v.1938 64 bit (AMD64)]
Type "help", "copyright", "credits" or "license" for more information.
>>> Ready to execute scripts.
๐ŸŒฒ
AST Root NodeModuleAbstract Syntax Tree representation.
๐Ÿท๏ธ
Symbol Scope0 IdentifiersGlobal variable memory allocations.
๐Ÿ›ก๏ธ
Linter & PEP 8CleanZero syntax or indentation warnings.
โšก
Complexity & LoopsO(1)Bounded iteration & recursion safety.
Python Abstract Syntax Tree (AST)Valid AST

Type Python code in the IDE to view real-time AST node tree parsing.

Runtime Variable Symbol TableStack Memory
IdentifierTypeValueScope
No active variables in memory. Assign variables (e.g. score = 100) to inspect.

Apply Simulator Skills โ€ข Try it yourself

Build an Analytics Dashboard!

๐Ÿ”„Direct Simulator Transfer: Step 6 Tasks 16, 17 & 18

Now that you've practiced the virtual mechanics in the simulator above, apply those exact skills in your real computer environment:

๐ŸŒŸ 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)

๐Ÿ“
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!

Reflect

๐ŸŽฏ

Self-Assessment & Reflection

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

๐ŸŸขSecure Level

Create a digital infographic communicating key findings to an audience.

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

Teacher notes: Facilitate the Step Inside routine for 2โ€“3 minutes. Encourage students to connect the prompt to Reflection (Data analytics informs decision-making but requires critical evaluation for accuracy and bias.).

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: Students may verbally explain or point to the correct answer for "You collect survey data on favourite sports, but only ask students on the basketball court. What issue does this dataset have?" with a teacher or teaching assistant.

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"!