Grade 7: Managing Data

​Unit 2: Managing Data

By Soleha Majeed

What is a Spreadsheet?

A spreadsheet is a computer file used to:

• Make calculations

• Create databases

• Analyse data

• Model solutions

Structure of a Spreadsheet:

• Rows: Run horizontally

• Columns: Run vertically

• Cells: The boxes where a row and column meet

Conditional Formatting

Replace this with your body text. Duplicate this text as many times as you would like. All provided templates can be reused multiple times. Wish you a good day.

Happy teaching!

Introduction to Managing Data

• Data is information we collect, store, and use to make decisions.

• Computers help us manage data quickly and accurately.

• Managing data means collecting, organizing, analyzing, and interpreting it.

Example:
A restaurant records customer orders to know which dish sells the most.

"Have you ever worked in managing data to make smart decisions?"

Download this link

https://docs.google.com/spreadsheets/d/1TTIQv1u1uCAw-iR4GSRNknlJoesNYR8S/edit?usp=sharing&ouid=101246322010639961344&rtpof=true&sd=true

Multiple Choice

Managing data means:

• Deleting data without any backup.
• Sharing data without any security measures.
• Organizing, storing, and maintaining data effectively.

Multiple Choice

A computer model helps us:

• Guess without data

• Predict results using data

What Is Modeling?

• Modeling is using data to represent a real-life situation.

• A computer model helps us predict what will happen if we make certain changes.

• Models can be built in spreadsheets.

Example:
A bakery uses a spreadsheet to see how profit changes if the price of cupcakes increases.

Multiple Choice

Why do we collect data like this before making decisions?

• We gather data to support our beliefs and biases.

• We collect data to make informed decisions based on evidence and analysis.

Parts of a Spreadsheet Model

• A basic spreadsheet model includes:

  1. Data – information you input

  2. Labels – text describing what data means

  3. Calculations – formulas that give results

Multiple Choice

What are labels in a spreadsheet?

• The money values

• The text that explains data

• The numbers in the cells

Understanding Spreadsheet Calculations

Formulas start with =.
Examples:

Formula	Meaning
=E4+E5	Adds values
=E4*0.8	Multiplies
=E4/12	Divides
=SUM(E4:E8)	Adds all values in range
=COUNT(E4:E8)	Counts number of numeric cells

Multiple Choice

Which formula adds up a range of cells?

• =PLUS(A1:A5)

• =SUM(A1:A5)

• =ADD(A1:A5)

Using Spreadsheet Models

We can change data values to see different outcomes.
This is called modelling.

Example:
If building hire increases from $800 → $1500, what happens to total costs?

Show a sample “before and after” in Excel. Let students guess what happens.

Multiple Choice

Changing a value in a spreadsheet to test new outcomes is called:

• Predicting

• Modeling

• Typing

Practical Activity — Sofia’s Bike Loan

Sofia wants a new bike. Her parents lend her money with interest


Enter data in white cells

• Use formulas:

  • =Cost - Deposit

  • =Loan + Interest

  • =ROUNDUP((Loan/Months) * 2)

✅ We learned:

• What modeling is

• How data helps decision-making

• How formulas and functions work

• How to model real-life problems in spreadsheets

​Summary & Reflection

What is one benefit of using spreadsheets for modeling?

Answer in your notebooks

What is a Simulator?

• A simulator is a computer system that mimics real-life situations.

• To mimic means to imitate or behave like something in real life.

• Simulators are used to train people or test situations safely.

• Example: Flight simulators, driving simulators, hospital layout simulators

​“Have you ever played a game that feels like real life — like a car racing game or flight game?”

Multiple Choice

Which of the following best describes a simulator?

• A device used for playing games only

• A computer system that imitates real-life situations

• A real-world experiment

Simulator in Pilot Training

• Flight simulators are used to train pilots before they fly real planes.

• The simulator looks like a real cockpit with all controls and screens.

• The “windows” are screens showing what the pilot would see in real life.

• This helps pilots:

  • Learn safely without accidents

  • Practice flying in bad weather

  • Learn emergency responses (like engine failure)

Simulator in Pilot Training

​“Why might it be risky for beginners to train in real planes?”

Multiple Choice

Why is a flight simulator used instead of a real plane for training?

• It’s more fun

• It’s faster

• It’s safer and cheaper

• It uses real fuel

Advantages of Using Simulators

• Safety: No real risk to life or property.

• Cost-effective: No fuel, no damage to real equipment.

• Practice anytime: Repeated training possible.

• Data collection: Simulators record data for analysis.

  Why “practice without danger” is important in risky professions?

Multiple Choice

Which is NOT an advantage of simulators?

• Safer training

• Costs less

• Always realistic

• Can collect data

Simulators in Healthcare

• Doctors and surgeons use simulators to practice surgeries safely.

• Helps in:

  • Learning surgical skills

  • Testing new medical techniques

  • Planning responses to emergencies (like earthquakes)

• Hospital layout simulators help design efficient hospital spaces.
  Examples like virtual surgery trainers or VR medical training.

Multiple Choice

How do simulators help surgeons?

• By treating real patients

• By replacing doctors

• By allowing safe practice and testing

Simulators in Manufacturing

• Used to test new designs and predict performance.

• Example: Car manufacturers test how a car shape affects speed.

• Helps to:

  • Save money

  • Avoid building multiple prototypes

  • Improve design faster

Simulators in Retail

• Used to test new designs and predict performance.

• Example: Car manufacturers test how a car shape affects speed.

• Helps to:

  • Save money

  • Avoid building multiple prototypes

  • Improve design faster

Multiple Choice

Why do manufacturers use simulators?

• Manufacturers use simulators to reduce production costs.
• Manufacturers use simulators to enhance marketing strategies.
• Manufacturers use simulators to test designs and improve safety.

Simulators in Retail

• Used to plan shopping center layouts.

• Helps managers study how customers move around the store.

• Improves space design for comfort and efficiency.

Multiple Choice

What can a retail simulator help with?

• Improving online marketing strategies and social media presence.
• Training staff and optimizing retail operations.
• Enhancing product design and manufacturing processes.
• Increasing customer dissatisfaction and reducing sales.

Data and Simulators

• Simulators rely on data to behave like real situations.

• Data can be about:

  • Speed, temperature, timing

  • Object shapes or weights

  • Human behavior patterns

• The more accurate the data, the more realistic the simulator.

example: “If flight simulator data is wrong, what could happen?”

Multiple Choice

Why is accurate data important for simulators?

• Inaccurate data enhances the realism of simulation results.
• Accurate data is important for simulators to ensure reliable and realistic simulation outcomes.
• Simulators rely on outdated data for effective performance.
• Accurate data is irrelevant for simulators and does not affect outcomes.

Multiple Choice

What is a data?

• Data is a type of software used for storage.
• Data is information, often in numerical or categorical form, used for analysis.
• Data is a programming languages.

Open Ended

Where do we store student records, library books, and employee data? What if we can't store these in Word or Excel?

​Why use MS Access over Excel?

Database: A database is an organized collection of information, or data, that is stored and accessed electronically.

Multiple Choice

Which software becomes slower when handling very large datasets?

• Excel

• Access

Excel is spreadsheet software (for calculations, charts, financial tasks).

MS Access is a Database Management System meant for storing, managing, and organizing data efficiently.

Multiple Choice

Which of the following is a relational database management system?

• Excel

• Access

Multiple Choice

Which software is best for performing complex calculations?

• Excel

• Access

• Understand what MS Access is and why organizations or companies uses it.

• Identify major components or tools of MS Access

• Create a simple table with fields and appropriate data types.

​MS ACCESS

Multiple Choice

Which of the following best defines a DBMS? (data based management system)

• A system that prints documents

• A software that helps organize and manage databases

Multiple Choice

The main purpose of using a DBMS is to:

• Make presentations

• Store large amounts of data efficiently

​LET'S START WORKING IN MS ACCESS

Analyse!

https://www.youtube.com/redirect?event=video_description&redir_token=QUFFLUhqbTBlcGN1UUMzSDBSMmRvZHNVYXJaUE1CNUw4QXxBQ3Jtc0tsZF8xWHFVVTcyOWVoeWdxajBUNHF3dE5JN0ZGaW5XZEVKX09WcHo1eHlYMHpydG1QLUxjdzg1djBobng1bm5fb2p5dHB5VnAyWkR4R2F2VWJoYVFYWFItam1DV1Vha1JBUEZPRk1oWEJ4Q0t4WHpwcw&q=https%3A%2F%2F1drv.ms%2Fu%2Fs%21AmxrofZZlZ-whKx-OHtH9VLpU4PdJw%3Fe%3D0aRP1p&v=ubmwp8kbfPc

What is a Primary Key?

A Primary Key is:

• A special field in a table

• Has unique data for each record

• Helps identify each row without confusion

Examples of Primary Keys

• Student Roll Number

• Product Code

• ID Number

Multiple Choice

1. What is a primary key?

• A primary key is a unique identifier for a record in a database table.
• A primary key is a duplicate identifier for multiple records in a database table.
• A primary key is a random identifier for a record in a database table.
• A primary key is an optional identifier for a record in a database table.

When a Field Cannot Be Primary Key

Example Database 2 (Players & Games):

Two players named Mohammed Khan play the same game.
→ So the combination of fields is not unique.

Solution:
✔ Add a new field, such as Player Number

Multiple Choice

Which of these can repeat in a database?

• Primary key

• Genre

Multiple Choice

Why is "Game Name(e.g: Cricket, football)" not always a good primary key?

• It is too long

• It may repeat in large databases

Query: What Is It?

A query is a special search that finds data that meets certain conditions.

Examples:

• Find all puzzle games

• Find products with less than 10 items in stock

• Find students aged above 12

Multiple Choice

What is a query?

• A new table

• A search based on criteria

• A type of form

How to Create a Query (MS Access)

1. Click Create → Query Design

2. Add the required tables

3. Select fields for the query

4. Enter criteria

5. Run the query

Example Query

What Is a Data Capture Form?

A data capture form collects information from people.

Examples:

• Admission forms

• Event registration

• Surveys

Good forms must be:
✔ Clear
✔ Easy to understand
✔ Well-structured
✔ Ask only necessary questions

Common Mistakes in Forms

❌ Confusing questions
❌ Not giving answer format (e.g., DD/MM/YYYY)
❌ Not enough space to write
❌ Hidden questions (e.g., written on back)

Effective Form Design Checklist

A good data capture form:

• Has clear instructions

• Gives options where possible

• Has correct space sizes

• Asks only needed questions

• Uses sensible ordering

Multiple Choice

Which of these is a problem in a data capture form?

• Clear questions

• Correc answer format

• Missing answer choices

Multiple Choice

A good data capture form must be:

• Confusing

• Unclear

• Well organised

• Missing questions

Multiple Choice

What is the problem if date formatting is not specified?

• Too much text

• People may write different formats

Multiple Choice

In a query, Which criteria will show names starting with A?

• =A

• A#

Multiple Choice

What is file extension called for Ms Access?

• .mdb
• .xls
• .docx
• .accdb

Let's make a query on access

https://drive.google.com/file/d/1YLpWoJ58FdISr4_zAvhPQazLEfFh2c9g/view?usp=sharing