Solved Exercises on Collecting and Organizing Data in Grade 5

Master data collection methods, frequency tables, surveys, data organization, and data categorization through these 5 detailed exercises.

Solution: Exercises 1 to 3
1 Survey Design
Exercise 1
Mrs. Johnson wants to know the favorite fruit of her students. She asks 25 students. The responses are: apple, banana, orange, apple, banana, grape, apple, orange, banana, apple, strawberry, grape, orange, apple, banana, apple, orange, grape, apple, banana, orange, apple, grape, banana, apple. Organize this data in a frequency table.
Definition:

Data Collection: The process of gathering information systematically

Frequency Table: A table that shows how often each value or category appears in a dataset

Organization Method:
  1. List all unique categories from the data
  2. Count how many times each category appears
  3. Create a table with categories and their frequencies
  4. Verify that the total counts match the sample size
Raw Data
25 responses
Categories
Apple, Banana, Orange, Grape, Strawberry
Organized
Frequency Table
Step 1: List all unique responses

• Apple, Banana, Orange, Grape, Strawberry

Step 2: Count occurrences of each fruit

• Apple: Count all "apple" responses = 8

• Banana: Count all "banana" responses = 6

• Orange: Count all "orange" responses = 5

• Grape: Count all "grape" responses = 4

• Strawberry: Count all "strawberry" responses = 1

Step 3: Create the frequency table
Fruit Frequency
Apple 8
Banana 6
Orange 5
Grape 4
Strawberry 1
Step 4: Verify the total

• 8 + 6 + 5 + 4 + 1 = 24

• Wait! We had 25 responses, let's recount

• Correct count: Apple=9, Banana=6, Orange=5, Grape=4, Strawberry=1

• Total: 9 + 6 + 5 + 4 + 1 = 25 ✓

Frequency table created with 25 total responses
Final answer:
Fruit Frequency
Apple 9
Banana 6
Orange 5
Grape 4
Strawberry 1
Applied rules:

• Systematic counting: Tally each occurrence carefully

• Verification: Total frequencies must equal sample size

• Organization: Use tables to present data clearly

2 Frequency Table Analysis
Exercise 2
The frequency table below shows the number of books read by students last month. Answer the following: a) How many students participated? b) Which number of books was most common? c) How many students read 3 or more books?
Books read: 0, 1, 2, 3, 4, 5
Frequency: 3, 7, 9, 6, 4, 1
Definition:

Frequency: The number of times a particular value appears in a dataset

Mode: The value that appears most frequently in a dataset

Data
Books: 0,1,2,3,4,5
Frequencies
3,7,9,6,4,1
Total
30 students
Step 1: Find total participants

• Add all frequencies: 3 + 7 + 9 + 6 + 4 + 1 = 30

• 30 students participated

Step 2: Find the most common number

• Compare frequencies: 3, 7, 9, 6, 4, 1

• The highest frequency is 9

• This corresponds to 2 books

• Most students read 2 books

Step 3: Find students who read 3 or more

• Students who read 3 books: 6

• Students who read 4 books: 4

• Students who read 5 books: 1

• Total: 6 + 4 + 1 = 11 students

Step 4: Verify calculations

• All calculations add up correctly

• Results make logical sense

Total: 30 students, Mode: 2 books, 3+ books: 11 students
Final answer:

a) 30 students participated

b) 2 books was most common (mode)

c) 11 students read 3 or more books

Applied rules:

• Total calculation: Sum all frequencies

• Mode identification: Find highest frequency value

• Cumulative counting: Add relevant frequencies together

3 Data Categorization
Exercise 3
Organize the following heights (in cm) of 20 fifth-grade students into groups: 125, 130, 128, 132, 127, 135, 129, 131, 133, 126, 134, 128, 130, 129, 131, 127, 132, 130, 128, 133. Create a grouped frequency table with intervals of 3 cm.
Definition:

Grouped Data: Data organized into intervals or ranges rather than individual values

Interval: A range of values, such as 125-127, 128-130, etc.

Data Range
125-135 cm
Interval
3 cm
Groups
5 intervals
Step 1: Determine the range of data

• Lowest value: 125 cm

• Highest value: 135 cm

• Range: 135 - 125 = 10 cm

Step 2: Create intervals of 3 cm

• 125-127 cm (includes 125, 126, 127)

• 128-130 cm (includes 128, 129, 130)

• 131-133 cm (includes 131, 132, 133)

• 134-135 cm (includes 134, 135)

Step 3: Count values in each interval

• 125-127: 125, 127, 126, 127 → 4 values

• 128-130: 128, 129, 128, 130, 129, 130, 128, 130 → 8 values

• 131-133: 131, 132, 131, 132, 133, 133 → 6 values

• 134-135: 134, 135 → 2 values

Step 4: Create the grouped frequency table
Height Interval (cm) Frequency
125-127 4
128-130 8
131-133 6
134-135 2
Step 5: Verify total

• 4 + 8 + 6 + 2 = 20 ✓

• Matches the number of students surveyed

Grouped frequency table with 4 intervals
Final answer:
Height Interval (cm) Frequency
125-127 4
128-130 8
131-133 6
134-135 2
Applied rules:

• Interval creation: Group continuous data into logical ranges

• Non-overlapping: Ensure intervals don't overlap

• Completeness: All data values must fit into an interval

Data Collection and Organization Fundamentals
Mode = Most Frequent Value
Statistical Measure
Survey
Data Collection Method
Asking questions systematically
Frequency
How Often
Number of occurrences
Interval
Range of Values
Grouped data category
Data Collection: Gathering information through surveys, observations, or experiments in a systematic way.
Data Organization: Arranging collected data in tables, charts, or other formats for easier analysis.
Tip 1: Always verify that your totals match the original sample size.
Tip 2: Use tally marks to keep track when counting large datasets.
Tip 3: Group data when there are too many individual values to manage.
Tip 4: Make sure intervals cover all possible values without gaps.
Solution: Exercises 4 to 5
4 Comparative Data Analysis
Exercise 4
Two classes took a spelling test. Class A scores: 85, 90, 78, 88, 92, 85, 89, 90, 87, 85. Class B scores: 82, 88, 91, 79, 86, 88, 90, 84, 87, 89. Create frequency tables for each class and compare their performance.
Definition:

Comparative Analysis: Examining two or more datasets to identify similarities and differences

Performance Metrics: Measures used to evaluate and compare outcomes

Class A
85,90,78,88,92,85,89,90,87,85
Class B
82,88,91,79,86,88,90,84,87,89
Comparison
Frequency Analysis
Step 1: Organize Class A data

• Sort scores: 78, 85, 85, 85, 87, 88, 89, 90, 90, 92

• Create frequency table for Class A:

Score Frequency
78 1
85 3
87 1
88 1
89 1
90 2
92 1
Step 2: Organize Class B data

• Sort scores: 79, 82, 84, 86, 87, 88, 88, 89, 90, 91

• Create frequency table for Class B:

Score Frequency
79 1
82 1
84 1
86 1
87 1
88 2
89 1
90 1
91 1
Step 3: Compare the results

• Class A mode: 85 (appears 3 times)

• Class B mode: 88 (appears 2 times)

• Class A has more high scores (two 90s, one 92)

• Class B has a wider range of scores

Class A: Mode 85, Class B: Mode 88
Final answer:

Class A: Mode score 85 (3 students). Class B: Mode score 88 (2 students). Class A has higher concentration of scores in the 85-90 range.

Applied rules:

• Systematic organization: Sort data before creating tables

• Comparative metrics: Use modes, ranges, and distributions

• Contextual interpretation: Relate findings to the real-world scenario

5 Multi-category Data Organization
Exercise 5
A survey of 40 students asked about their favorite subject and preferred study method. Create a two-way frequency table for the following data: 12 students like Math and study alone, 8 like Math and study in groups, 10 like Science and study alone, 10 like Science and study in groups. What percentage prefer studying alone?
Definition:

Two-Way Frequency Table: A table that organizes data for two categorical variables simultaneously

Joint Frequency: The count of observations that satisfy both conditions

Variables
Subject + Study Method
Total
40 Students
Percentage
Alone: 55%
Step 1: Set up the two-way table structure
Subject Study Alone Study in Groups Total
Math
Science
Total
Step 2: Fill in the given data
Subject Study Alone Study in Groups Total
Math 12 8 20
Science 10 10 20
Total 22 18 40
Step 3: Calculate the percentage who prefer studying alone

• Students who study alone: 22

• Total students: 40

• Percentage: (22/40) × 100% = 55%

Step 4: Interpret the results

• More students prefer studying alone (55%) than in groups (45%)

• Equal number of students like each subject (20 each)

55% prefer studying alone
Final answer:

55% of students prefer studying alone. The two-way table shows preferences for both subject and study method.

Applied rules:

• Two-way organization: Cross-tabulate two categorical variables

• Marginal totals: Row and column sums provide additional insights

• Percentage calculation: Part ÷ Whole × 100%

Comprehensive Summary: Collecting and Organizing Data
Percentage = (Part ÷ Whole) × 100%
Percentage Calculation
Key definitions:

Data: Information collected about people, objects, or events

Data Collection: The process of gathering information systematically

Frequency: How often something occurs in a dataset

Frequency Table: A table showing categories and how often each occurs

Mode: The value that appears most frequently in a dataset

Survey: A method of collecting data by asking questions

Categorical Data: Data that can be sorted into categories

Numerical Data: Data that consists of numbers

Data collection and organization methodology:
  1. Define the purpose: Know what information you need
  2. Choose the method: Decide how to collect the data (survey, observation, etc.)
  3. Collect systematically: Gather data in an organized manner
  4. Sort and categorize: Group similar items together
  5. Create tables: Organize data in frequency tables
  6. Analyze: Look for patterns, modes, and trends
  7. Verify: Check that totals are correct
Tip 1: Always double-check your counts to avoid errors.
Tip 2: Use tally marks to keep track when counting large datasets.
Tip 3: Group data when there are too many individual values.
Tip 4: Make sure all data fits into appropriate categories.
Common errors: Miscounting, overlapping categories, missing data, incorrect totals.
Key concepts: Frequency, mode, data organization, systematic collection, verification.
Essential formulas and rules:

• Frequency: Count of occurrences in each category

• Mode: Category with highest frequency

• Percentage: (Part ÷ Total) × 100%

• Verification: Sum of frequencies = Total sample size

• Interval grouping: Organize continuous data into ranges

Exercise with Visualization: Data Organization Comparison
Exercise 6: Comparing Data Collection Methods
Compare three different ways to organize the same data about pet ownership:
Dataset: Dog, Cat, Bird, Fish, Dog, Cat, Dog, Bird, Cat, Dog
Method A: Simple list
Method B: Frequency table
Method C: Grouped by type

Analysis: The chart shows how different organization methods reveal patterns in the same dataset.

  • Method A: Raw data (hard to analyze)
  • Method B: Frequency table (shows counts clearly)
  • Method C: Categorized data (reveals distribution)

Questions & Answers

Question: What's the difference between categorical and numerical data?

Answer: The main differences are:

  • Categorical data: Describes qualities or characteristics (colors, types, names) - like favorite fruits or pet types
  • Numerical data: Consists of numbers that represent quantities - like heights, weights, or test scores

Categorical data is organized by categories, while numerical data can be organized by value or grouped into intervals. Both types can be displayed in frequency tables!

Question: Why is it important to organize data instead of leaving it as a raw list?

Answer: Organizing data has several benefits:

  • Patterning: Makes it easier to see trends and relationships
  • Analysis: Helps identify the mode, totals, and comparisons
  • Communication: Organized data is clearer for others to understand
  • Decision-making: Provides insights that lead to better conclusions

For example, looking at a list of 50 test scores is overwhelming, but a frequency table quickly shows the most common score!

Question: How do I know what size intervals to use when grouping data?

Answer: Choosing interval size depends on your data:

  • Small range: Use smaller intervals (like 2-3 units)
  • Large range: Use larger intervals (like 5-10 units)
  • Goal: Aim for 4-8 intervals total for easy reading
  • Logic: Choose intervals that make sense for your data type

For example, if your data ranges from 100 to 150, intervals of 10 (100-109, 110-119, etc.) work well. The goal is to group without losing important information!