INTEGRATED PROJECT 1 · WATER AND PUBLIC UTILITIES · 6 SUBJECTS

Safe Water for Our Community

Treat, pump, store, test and bill: the work of a water authority uses every one of your subjects.

MathematicsAdditional MathematicsPhysicsChemistryBiologyInformation Technology
0%
DONE
Your progress

0 of 18 tasks attempted

Mathematics0/3
Additional Mathematics0/2
Physics0/3
Chemistry0/3
Biology0/3
Information Technology0/4

Tick “I have attempted this” on each task. Your progress is saved in this browser only.

The brief

Southfield Water Authority needs your team

Southfield Water Authority (a fictional utility) supplies about 12 000 people. After a week of heavy rain, four problems land on the manager’s desk:

The manager asks a small technical team for a short briefing with numbers and recommendations.

Your role: junior technical officer on the Authority’s response team, with a mathematician, a physicist, a chemist, a biologist and a data officer all working from the same facts.
How this project works. Each subject has a short task set from the point of view of the team. The lessons that give you the skills are linked at the top of each task. Work in any order, then bring your results together in the final briefing. Use g = 10 N/kg and π = 3.14 unless told otherwise. Worked solutions are hidden: attempt each task on paper first.
The big idea

How the six subjects connect in this project

The same ideas keep appearing. Each row shows one shared topic and where you meet it in your lessons.

Pressure, volume and flow

Water pressure in the pipes depends on height; tank size depends on volume of a cylinder; flow rates tell you how long filling takes.

Acids, alkalis and concentration

The chemist measures acidity by titration, then the same concentration idea sizes the lime dose for a whole river’s worth of waste.

Growth and decay

Bacteria in warm stagnant water double at a steady rate. Add Maths exponentials model it, and Biology explains why it matters.

Rates of change and optimisation

Calculus finds when the reservoir is fullest and how fast it is filling or emptying.

Energy, power and efficiency

A pump does work against gravity; its efficiency decides how much electrical power the Authority must buy.

Data, validation and decisions

Test results are only useful if they are recorded correctly, summarised in a spreadsheet and flagged by rules.

Task · Mathematics

Tanks, pumping time and the water bill

The storage tank is a cylinder. You will find its capacity, the time to fill it, and check a customer’s bill.

Skills from your lessons: Maths A11 Maths A3 Maths A4 Maths A5 Maths A7
  1. The storage tank is a cylinder of radius 3.0 m and height 4.0 m. Using π = 3.14, find its volume (a) in m³ and (b) in dm³ (litres).[3 marks]
    Show worked solution

    (a) V = πr²h = 3.14 × 3.0² × 4.0 = 3.14 × 9 × 4 = 113.04 m³ (≈ 113 m³). [2]

    (b) 1 m³ = 1000 dm³, so 113.04 × 1000 = 113 040 dm³. [1]

  2. A pump delivers 0.5 m³ of water per minute. How long does it take to fill the empty tank? Give your answer in hours and minutes.[3 marks]
    Show worked solution

    Time = 113.04 ÷ 0.5 = 226.08 minutes. [2]

    226 min = 3 × 60 + 46, so about 3 hours 46 minutes. [1]

  3. A household uses 18 m³ in a month. Water costs $4.50 per m³ and 15% tax is added to the total. (a) Calculate the bill. (b) After a price rise of 8% on the bill, what is the new amount?[5 marks]
    Show worked solution

    (a) 18 × $4.50 = $81.00 [1]. Tax = 15% of 81.00 = $12.15 [1]. Bill = 81.00 + 12.15 = $93.15. [1]

    (b) 93.15 × 1.08 = 100.602 ≈ $100.60. [2]

Task total: 11 marks

Task · Additional Mathematics

When is the reservoir fullest? How fast do bacteria multiply?

The volume of water in the hillside reservoir changes after rain. Warm stagnant water also grows bacteria quickly.

  1. The volume, V m³, of water in the reservoir t hours after the rain starts is V = 200 + 12t − t², for 0 ≤ t ≤ 12. (a) Find dV/dt. (b) Find the time at which the volume is a maximum. (c) Find the maximum volume. (d) Find dV/dt when t = 8 and explain what it means.[7 marks]
    Show worked solution

    (a) dV/dt = 12 − 2t. [1]

    (b) Set dV/dt = 0: 12 − 2t = 0, so t = 6 hours. [2] (The second derivative is −2, which is negative, so this is a maximum.)

    (c) V = 200 + 12(6) − 36 = 200 + 72 − 36 = 236 m³. [2]

    (d) dV/dt = 12 − 16 = −4. At t = 8 the volume is decreasing at 4 m³ per hour. [2]

  2. The number of bacteria in a stagnant pool is N = 50 × 2^(t/3), where t is the time in hours. After how many hours will N first exceed 3200?[3 marks]
    Show worked solution

    Set 50 × 2^(t/3) = 3200, so 2^(t/3) = 64. [1]

    64 = 2⁶, so t/3 = 6. [1]

    t = 18 hours. After 18 hours there are exactly 3200 bacteria, so N first exceeds 3200 just after 18 hours. [1]

Task total: 10 marks

Task · Physics

Pressure at the tap and the power of the pump

The Authority stores water high on a hill so that gravity provides pressure. A pump lifts water up to the tower.

Skills from your lessons: Physics A15 Physics A13 Physics A14 Physics A3
  1. The surface of the water in the tower is 25 m above a tap. The density of water is 1000 kg/m³. (a) Calculate the pressure due to the water at the tap. (b) Explain why a house at the bottom of the hill has higher water pressure than one near the top.[3 marks]
    Show worked solution

    (a) P = hρg = 25 × 1000 × 10 = 250 000 Pa (250 kPa). [2]

    (b) Pressure in a liquid increases with depth (the height of water above the point), so the lower house has a taller column of water above it. [1]

  2. A pump raises 2000 kg of water through 30 m every minute. (a) Calculate the energy gained by the water each minute. (b) Calculate the useful output power. (c) The pump is 80% efficient. Calculate the electrical power it must be supplied with.[5 marks]
    Show worked solution

    (a) E = mgh = 2000 × 10 × 30 = 600 000 J. [2]

    (b) Power = energy ÷ time = 600 000 ÷ 60 = 10 000 W. [1]

    (c) Input power = 10 000 ÷ 0.80 = 12 500 W (12.5 kW). [2]

  3. A 250 cm³ sample of muddy river water has a mass of 262.5 g. Calculate its density in g/cm³ and explain why it is greater than the density of pure water (1.0 g/cm³).[3 marks]
    Show worked solution

    Density = mass ÷ volume = 262.5 ÷ 250 = 1.05 g/cm³. [2]

    The suspended mud (soil particles) is denser than water, so it increases the mass per unit volume. [1]

Task total: 11 marks

Task · Chemistry

The acidic discharge: how much lime to neutralise it?

A factory upstream releases acidic waste. The chemist finds its concentration by titration, then calculates the lime needed to neutralise a day’s discharge.

Titration result: 25.0 cm³ of the waste (hydrochloric acid, HCl) was neutralised by 20.0 cm³ of 0.100 mol/dm³ sodium hydroxide, NaOH. (Ar: H = 1, O = 16, Ca = 40)
  1. Calculate the concentration of the acid in the waste in mol/dm³.[4 marks]
    Show worked solution

    Moles NaOH = 0.100 × 20.0 ÷ 1000 = 0.00200 mol. [1]

    HCl + NaOH → NaCl + H₂O, a 1 : 1 ratio, so moles HCl = 0.00200 mol. [1]

    Concentration = 0.00200 ÷ 0.0250 dm³ = 0.0800 mol/dm³. [2]

  2. The factory discharges 10 000 dm³ of waste per day. Lime, calcium hydroxide Ca(OH)₂, neutralises it: Ca(OH)₂ + 2HCl → CaCl₂ + 2H₂O. Calculate the mass of lime needed per day.[4 marks]
    Show worked solution

    Moles HCl = 0.0800 × 10 000 = 800 mol. [1]

    Mole ratio Ca(OH)₂ : HCl = 1 : 2, so moles Ca(OH)₂ = 400 mol. [1]

    M(Ca(OH)₂) = 40 + 2(16 + 1) = 74 g/mol, mass = 400 × 74 = 29 600 g = 29.6 kg. [2]

  3. (a) Name the two metal ions that cause hardness in water. (b) Residents complain of scum with soap and scale in kettles. State one disadvantage of hard water and one method of softening it.[3 marks]
    Show worked solution

    (a) Calcium ions (Ca²⁺) and magnesium ions (Mg²⁺). [1]

    (b) Disadvantage: it wastes soap by forming scum / it forms scale that blocks pipes and kettles. [1] Softening: boiling (for temporary hardness) or ion exchange / adding washing soda. [1]

Task total: 11 marks

Task · Biology

The fish kill and the mosquito pools

A stretch of river below the sewage outlet has lost its fish, and stagnant pools around the town are breeding mosquitoes.

Skills from your lessons: Biology A6 Biology A7 Biology A4 Biology B19
Dissolved oxygen in the river
Position2 km upstream0.5 km below outlet3 km below8 km below
Oxygen (mg/dm³)8.23.04.57.0
  1. (a) Describe the trend in dissolved oxygen shown by the table. (b) Explain why the oxygen level falls below the sewage outlet. (c) Suggest one reason why it recovers further downstream.[6 marks]
    Show worked solution

    (a) Oxygen is high upstream (8.2), falls sharply just below the outlet (3.0), then rises steadily to 7.0 by 8 km. [2]

    (b) Sewage contains organic matter and nutrients. Bacteria (decomposers) multiply and use up dissolved oxygen in aerobic respiration as they break it down. [1] Nutrients may cause an algal bloom; when the algae die, more bacteria decompose them and use more oxygen (eutrophication). [1] Fish and other animals cannot get enough oxygen and die. [1]

    (c) The organic matter is used up or diluted; oxygen dissolves from the air and is added by photosynthesis of water plants. [1]

  2. (a) Name the four stages in the life cycle of the mosquito. (b) Explain why draining standing water reduces the number of mosquito-borne disease cases. (c) State one disease spread by mosquitoes.[5 marks]
    Show worked solution

    (a) Egg → larva → pupa → adult. [2]

    (b) The eggs, larvae and pupae develop in water; removing standing water takes away the breeding sites, so the life cycle is broken and fewer adult mosquitoes can bite people and pass on the disease. [2]

    (c) Dengue fever (also malaria, Zika, chikungunya). [1]

  3. Describe two ways the community could reduce water pollution while protecting the river ecosystem.[2 marks]
    Show worked solution

    Any two: treat sewage before it is released; stop dumping waste and chemicals in the river; plant vegetation along the banks to filter runoff; reduce fertiliser use near the river; educate the public. [1 each]

Task total: 13 marks

Task · Information Technology

The monitoring spreadsheet and the sample database

The data officer must record water-quality tests, flag unsafe samples, and design a small database for the laboratory.

Skills from your lessons: IT B5 IT B6 IT B7 IT B8 IT A8
Spreadsheet: sample IDs in A2:A6, pH readings in B2:B6
ABC
1SamplepHStatus
2A7.2
3B6.8
4C8.9
5D7.5
6E6.1

Safe drinking-water pH range: 6.5 to 8.5.

  1. Write a formula for the average pH of the five samples and state its value.[2 marks]
    Show worked solution

    =AVERAGE(B2:B6) [1] = (7.2 + 6.8 + 8.9 + 7.5 + 6.1) ÷ 5 = 36.5 ÷ 5 = 7.3. [1]

  2. Write a formula for cell C2 that shows “OK” if the pH is within the safe range and “FAIL” if not, so that it can be filled down to C6. Then state which samples fail.[4 marks]
    Show worked solution

    =IF(AND(B2>=6.5,B2<=8.5),"OK","FAIL") [3: IF structure, both conditions joined with AND, correct text results]. (An equivalent nested IF is also accepted.)

    Samples C (8.9) and E (6.1) fail. [1]

  3. Suggest a suitable chart to compare the five pH readings and state two items it must have.[2 marks]
    Show worked solution

    A column (bar) chart of pH for each sample. [1] It needs a title and axis labels (sample on the x-axis, pH on the y-axis); a legend or data labels is also acceptable. [1]

  4. The laboratory database will have two tables, Site and Sample. (a) State the fields of each table and identify the primary key and foreign key. (b) State a validation rule for the pH field and name the type of check.[5 marks]
    Show worked solution

    (a) Site (SiteID, SiteName, Parish); Sample (SampleID, SiteID, Date, pH, Turbidity). Primary keys: SiteID and SampleID. Foreign key: SiteID in Sample, which links each sample to its site (one-to-many). [3]

    (b) pH must be between 0 and 14: a range check. [2]

Task total: 13 marks

Put it together

Final briefing note for the Authority’s manager

Combine your results into a one- to two-page briefing note (or a short presentation of 5 slides). Use the numbers you found: the tank capacity and filling time, the lime dose, the reservoir’s peak volume, the pump’s power, the oxygen trend and the failed samples. End with three prioritised recommendations.

Checklist

How it will be judged (20 marks)

CriterionWhat a top answer showsMarks
Accuracy of calculationsCorrect values with units from all six tasks, with working shown6
Use of subject knowledgeExplains why each result matters using ideas from Chemistry, Biology and Physics5
Data presentationClear labelled chart or table; consistent units3
RecommendationsPractical, prioritised and linked to the evidence4
CommunicationClear, well organised and suited to a manager2

Careers

Who does this work in real life?

Each of these people uses the subjects in this project every day.

Water treatment plant operator / engineer

Runs and designs the plants that make water safe: dosing chemicals, monitoring tanks, pumps and pressure.

Uses: Chemistry (pH, concentration), Physics (pressure, power), Maths (volume, flow)

Pathway: Technical diploma or associate degree in water treatment, or a degree in chemical or civil engineering.

Laboratory analyst / chemist

Tests water and wastewater for acidity, hardness, bacteria and pollutants and reports results.

Uses: Chemistry (titration, analysis), Biology (microbes), IT (data recording)

Pathway: Degree in chemistry, biochemistry or environmental science.

Environmental or public health officer

Inspects pollution sources and mosquito breeding sites and enforces regulations.

Uses: Biology (disease, ecology), Chemistry, Maths (statistics)

Pathway: Degree or diploma in environmental health.

Hydrologist / civil engineer

Predicts rainfall, river flow and reservoir levels and designs dams, pipes and drains.

Uses: Add Maths (rates, optimisation), Physics, Maths

Pathway: Degree in civil engineering or hydrology.

Data analyst for a utility

Builds the spreadsheets, databases and dashboards that turn readings into decisions.

Uses: IT (spreadsheets, databases), Maths (statistics)

Pathway: Degree or certificates in IT, statistics or data science.

Reflect

Think about it

  1. Which of the six jobs would you find most interesting, and which subject helped you most in it?
  2. What went wrong when only one subject was used? For example, what could the chemist not tell you about the river without the biologist?
  3. How would you change your recommendations if the rainy season became longer because of climate change?