Q12: Individual project: Do at least one of the following. (i) Recall the previous day and fill in the approximate time spent lying down, sitting, and standing/moving around, etc. Ask at least 2 of your family members about their day and fill it in. Alternatively, you can choose to track just your own body‑state for any one of the weekdays, Saturday, and Sunday. Visualise it using a stacked bar chart. Discuss with your class how you arrived at the estimated time spent in each state. (ii) Visualise your family’s monthly expenditure using a stacked bar chart. (a) First, identify the expense categories in your family budget. (b) Discuss with your family members to decide how you will collect and organise the data. (c) Collect expense data for at least 3 months. (d) Represent the data in a stacked bar chart, with each bar showing how the total monthly expenditure is divided across the different categories. (e) Finally, write your observations and inferences based on the chart.
UNDERSTAND THE QUESTION
The project requires you to collect real‑time data about either (i) the amount of time you and your family members spend in different body states (lying, sitting, standing/moving) or (ii) the monthly expenditure of your family. The data must then be visualised as a stacked bar chart, where each bar represents a month and the segments show the proportion of total expenditure (or time) spent in each category. Finally, you must write observations and inferences based on the chart.
(i)PART I
Recall the previous day and fill in the approximate time spent lying down, sitting, and standing/moving around, etc. Ask at least 2 of your family members about their day and fill it in. Alternatively, you can choose to track just your own body‑state for any one of the weekdays, Saturday, and Sunday. Visualise it using a stacked bar chart. Discuss with your class how you arrived at the estimated time spent in each state.Step 1 — CHOOSE THE DAY AND CATEGORIES
Select a specific day (e.g., yesterday) and decide on the categories you will record: lying down, sitting, standing/moving, and any other relevant state such as sleeping or exercising. Write these categories clearly on a sheet.
Step 2 — RECORD YOUR OWN TIME
Using a watch or a phone timer, note the approximate start and end times for each state. Subtract the start time from the end time to get the duration in minutes. Sum the durations to obtain the total time for the day.
Step 3 — ASK FAMILY MEMBERS
Speak to at least two family members and ask them to estimate the time they spent in each state on the same day. Record their estimates in the same format as yours.
Step 4 — CONVERT TO PERCENTAGES
For each person, add the durations of all states to get the total time. Then, for each state, divide the duration by the total time and multiply by 100 to obtain the percentage. For example, if you spent 120 minutes lying down out of 480 minutes total, the percentage is .
Step 5 — CREATE THE STACKED BAR CHART
Draw a horizontal bar for each person. Divide the bar into segments whose lengths are proportional to the percentages calculated. Label each segment with the category name and its percentage. Use different colours for each category to make the chart readable.
Step 6 — DISCUSS THE RESULTS
In class, explain how you estimated the times, how you converted them to percentages, and what the chart shows about the distribution of body states. Discuss any differences between family members and possible reasons for those differences.
ANSWER (I)
Project completed with a stacked bar chart showing the distribution of time spent in each body state for each person, along with a written discussion of observations.
(ii)PART II
Visualise your family’s monthly expenditure using a stacked bar chart.Step 1 — IDENTIFY EXPENSE CATEGORIES
List all major expense categories that appear in your family budget, e.g., Food, Rent/Mortgage, Utilities, Transport, Education, Entertainment, Savings, Miscellaneous.
Step 2 — PLAN DATA COLLECTION
Decide how you will gather the data: ask each family member to keep a diary of expenses, use bank statements, or collect receipts. Agree on a consistent method for all months to be collected.
Step 3 — COLLECT DATA FOR 3 MONTHS
For each of the last three months, record the amount spent in each category. Keep a separate sheet for each month and write down the total expenditure for that month.
Step 4 — CONVERT TO PERCENTAGES
For each month, add the amounts of all categories to get the total monthly expenditure. Then, for each category, calculate the percentage of the total: .
Step 5 — DRAW THE STACKED BAR CHART
Draw three bars, one for each month. For each bar, divide it into segments whose lengths are proportional to the percentages calculated in step 4. Label each segment with the category name and its percentage. Use a consistent colour scheme for each category across all bars.
Step 6 — WRITE OBSERVATIONS AND INFERENCES
Analyse the chart to see which categories dominate each month, how the proportions change over time, and any patterns such as seasonal spikes or savings trends. Write a short paragraph summarising these observations and what they imply about the family’s spending habits.
ANSWER (II)
Project completed with a stacked bar chart for three months of family expenditure and a written report of observations and inferences.
COMMON MISTAKES
- Not converting to percentages – forgetting to divide by the total and multiply by 100, which makes the chart misleading.
- Inconsistent data collection – using different methods for different months or family members, leading to incomparable figures.
- Incorrect bar proportions – drawing segments that are not proportional to the calculated percentages.
- Omitting category labels – leaving out the names or percentages on the chart, which makes it hard to interpret.
- Rounding errors – rounding percentages too early; it is better to round only the final percentages for the chart.