GRADE 6 COMPUTING LESSON

Unit 3: Managing Data, Models & Simulators

Part 1: Data, Models and Simulators

1. Theory Explanation:

• Data: Facts, numbers, or information (e.g., height, temperature).

• Model: A computer program that copies a real-life object or situation using data and rules.
It helps us understand how the real world works.

• Simulator: A more ”interactive” type of model. It allows you to interact with it and see the
results change in real-time (like playing a video game).

How data is used in different industries:

• Health: Simulators let doctors practice surgery safely before operating on a real patient.

• Manufacture: Car companies use computer models to simulate car crashes instead of de-
stroying hundreds of real cars.

• Retail: Supermarkets model customer walking habits to decide the best place to put candy
shelves to sell more.

2. Concrete Example:
If you want to design a new rollercoaster:

• Model: A 3D drawing on a computer that calculates the steepness and wind resistance.

• Simulator: A VR (Virtual Reality) program where you can ”ride” the rollercoaster to see if
it makes passengers dizzy!

3. Quick Review Questions:

1. What is the main difference between a regular Model and a Simulator?

2. Why do airlines ask trainee pilots to fly using a ”Flight Simulator” on their first day instead
of a real airplane?

1
Part 2: Effective Data Capture

1. Theory Explanation:
For a computer to work well, the data we input must be clean and consistent.
Data capture forms are documents or online pages used to collect information (like Google
Forms). An effective form helps people fill it out quickly and without mistakes.

The best way to do this is to stop people from typing words themselves (to avoid spelling mistakes).
Instead, use checkboxes, radio buttons, or drop-down lists.
2. Concrete Example:
Your school hands out a Sports Club Registration form:

• INEFFECTIVE capture: A blank text box asking ”What is your class?”. One student
types ”Class 6A”, another types ”6a”, another types ”six A”. The computer will be very
confused!

• EFFECTIVE capture: A drop-down list containing: ”6A, 6B, 6C”. The student just clicks
one. The data is 100% consistent.

3. Quick Review Questions:

1. When asking for a ”Date of Birth” on a form, should you use a blank text box or a Calendar
picker tool? Why?

Part 3: Primary Keys

1. Theory Explanation:
In a database table, there can be thousands of rows. A Primary Key is a special field (column)
that uniquely identifies each row. Rules of a Primary Key:

• It must be unique (no duplicates allowed).

• It cannot be left blank.

2. Concrete Example:
Imagine there are two students named ”John Smith” in your school.

• If the teacher says: ”John Smith, come here!” → Both students stand up. (”Name” cannot
be a primary key because it can be duplicated).

• But if the teacher says: ”Student with ID number 005, come here!” → Only one student
steps forward.

2
→ Student ID is the perfect Primary Key!
3. Quick Review Questions:

1. In a hospital patient list, which of these is the best Primary Key: Patient Name, Age, or ID
Card Number? Why?

2. Why is a ”Phone Number” sometimes a bad Primary Key for middle school students? (Hint:
Do you share a phone with your parents?)

Part 4: Simple Data Analysis

1. Theory Explanation:
When we have a massive database, we can’t read every row with our eyes. Computers give us 2
great tools:

• A. Searching with criteria: We use math symbols like > (greater than), < (less than), or =
(equal to) to filter exactly what we need.

• B. Conditional Formatting: Writing rules to make the computer automatically color cells
if they meet certain conditions. This helps our eyes spot important information in 1 second.

2. Concrete Example:
A teacher has a spreadsheet with the grades of 1,000 students.

• Searching Example: The teacher wants to give prizes to top students. He searches using
the criterion: Math Score > 9. The computer hides everyone else and only shows students
with 9.5 or 10.

• Conditional Formatting Example: The teacher wants to see who is failing. He sets a rule:
”If Math Score is < 5, turn the cell RED”. Instantly, all the low scores light up in red and
are very easy to spot!

3. Quick Review Questions:

1. If you want to find toys cheaper than $50 in a toy store database, what search criterion would
you use?

2. Create a ”Conditional Formatting” rule to help a doctor instantly spot patients who have a
high fever over 38◦C in a spreadsheet.