GROUP 1
Raw Data 20 Students
Student Score
S001 78
S002 65
S003 92
S004 55
S005 83
S006 88
S007 72
S008 95
S009 60
S010 79
S011 84
S012 91
S013 67
S014 74
S015 82
S016 59
S017 90
S018 76
S019 69
S020 87
Instructions (Stages of Data Processing)
1. Collection: Use the raw scores provided.
2. Preparation: Check for missing or duplicate entries (none
here).
3. Processing:
- Sort scores in ascending order.
- Classify into Pass (≥75) and Fail (<75).
- Compute average, highest, lowest.
4. Output: Present results in a summary table or chart.
5. Storage: Imagine storing results in a gradebook or database.
6. Feedback: Suggest how teachers might adjust teaching
based on performance.
GROUP 2
Raw Data 15 Transactions
Transaction ID Product Units Sold
T001 Notebook 10
T002 Ballpen 25
T003 Backpack 5
T004 Calculator 8
T005 USB Drive 12
T006 Notebook 15
T007 Ballpen 30
T008 Backpack 7
T009 Calculator 10
T010 USB Drive 20
T011 Notebook 18
T012 Ballpen 22
T013 Backpack 9
T014 Calculator 12
T015 USB Drive 25
Instructions (Stages of Data Processing)
1. Collection: Use the raw transaction data.
2. Preparation: Ensure entries are consistent (units sold are in-
tegers).
3. Processing:
- Sort transactions by units sold.
- Classify into High Sales (≥15) and Low Sales (<15).
- Compute average, highest, lowest.
4. Output: Present results in a frequency table or bar chart.
5. Storage: Imagine storing results in a company’s accounting
system.
6. Feedback: Suggest how managers might adjust inventory or
marketing.
GROUP 3
Raw Data 15 Students
Student ID Satisfaction 1–5
S001 5
S002 3
S003 4
S004 2
S005 5
S006 4
S007 1
S008 3
S009 5
S010 4
S011 2
S012 5
S013 3
S014 4
S015 5
S016 3
S017 4
S018 2
S019 1
S020 5
Instructions (Stages of Data Processing)
1. Collection: Use the raw survey ratings.
2. Preparation: Check for missing or invalid ratings (none here).
3. Processing:
- Sort ratings in ascending order.
- Classify into Satisfied (4–5) and Not Satisfied (1–3).
- Compute average, highest, lowest.
4. Output: Present results in a summary table or pie chart.
5. Storage: Imagine storing results in a survey database.
6. Feedback: Suggest how teachers might improve lesson de-
livery.
GROUP 4
Raw Data 15 Posts
Post ID Like Shares Comments
P001 120 30 15
P002 85 20 10
P003 200 50 40
P004 60 10 5
P005 150 35 25
P006 95 22 12
P007 180 45 30
P008 70 15 8
P009 210 55 42
P010 130 28 18
P011 75 18 9
P012 160 40 27
P013 55 8 4
P014 140 32 20
P015 100 25 14
Instructions (Stages of Data Processing)
1. Collection: Use raw engagement data (likes, shares, com-
ments).
2. Preparation: Remove spam/bot entries (none here).
3. Processing:
- Sort posts by likes ascending.
- Classify: High Engagement (≥120 likes) and Low Engage-
ment (<120 likes).
- Compute average likes, highest, lowest.
4. Output: Present results in a summary table or chart.
5. Storage: Imagine storing results in cloud servers.
6. Feedback: Suggest how companies adjust content strate-
gies.
GROUP 5
Worksheet 5: Sales Records
Raw Data 15 Sales Entries
Transaction ID Product Units Sold
S001 Notebook 12
S002 Ballpen 28
S003 Backpack 7
S004 Calculator 15
S005 USB Drive 20
S006 Notebook 18
S007 Ballpen 35
S008 Backpack 10
S009 Calculator 22
S010 USB Drive 25
S011 Notebook 30
S012 Ballpen 40
S013 Backpack 12
S014 Calculator 19
S015 USB Drive 27
---
Instructions (Stages of Data Processing)
1. Collection: Use the raw sales data provided.
2. Preparation: Check for missing or inconsistent entries.
3. Processing:
- Sort transactions by units sold (ascending).
- Classify into High Sales (≥20) and Low Sales (<20).
- Compute average, highest, lowest units sold.
4. Output: Present results in a summary table or bar chart.
5. Storage: Imagine storing results in a company’s sales data-
base.
6. Feedback: Suggest how managers might adjust inventory or
promotions.