Embedded Files
- Setting up the Data Categories
An image of the data categories recorded in the Google Sheets
To track emissions effectively, I first identified major contributors to carbon output within my school environment. I grouped data into four core areas:
Category
IC Trips
Canteen
LPG Consumption
Electricity Usage
Why it Matters
Transportation is a key emitter of greenhouse gases (GHG)
Meat, fish, and processed foods have high carbon footprints
Fuel usage for cooking and heating contributes to CO₂ emissions
Energy production affects emissions, depending on the source
2. Collecting the Data
2. Collecting the Data
Data Sources Used:
• Receipts, monthly reports and menus from:
• Canteen services (ingredient breakdowns, meal types)
• Admin office (electricity bills, LPG records)
• Transport department (trip logs, bus fuel usage)
• Google Forms to gather weekly input on student/staff commute modes (walking, carpool, bus, etc.)
Learning Moment: I had to standardize units (e.g., liters of LPG, kWh of electricity, kg of food items) to make data usable.
IC TRIP Collection
IC TRIP Collection
Finding the distance from one destination to the other with the help of Google Maps
CANTEEN DATA COLLECTION
CANTEEN DATA COLLECTION
Understanding the ungredients contained in every meal and understanding the carbon matter and even the process involved that may emit carbon
KKM064.pdfLPG CONSUMPTION COLLECTION
LPG CONSUMPTION COLLECTION
Understanding how much litres of gas was contained in every purchase by the school using receipts
KPLC29339.pdfELECTRICITY CONSUMPTION RECEIPT
ELECTRICITY CONSUMPTION RECEIPT
Understanding what High Rate and Low rate is and using them to calculate how much electricity is used by different buildings in school.
3. Applying Carbon Emission Formulas
3. Applying Carbon Emission Formulas
Each dataset required conversion into CO₂ equivalents using carbon factors. I followed emission factors from sources like:
UK Government GHG Conversion Factors
FAO (Food and Agriculture Organization) food carbon data
Carbon Trust
Section
Transport
Example use of formula
CO₂ = Liters of fuel used × 2.31 kg CO₂/litre OR Distance × Emission factor by vehicle
Collected formula for calculating IC Trips
Canteen
Grams of CO₂ per meal = Meal weight (kg) × Carbon factor (e.g., beef = 27 kg CO₂/kg)
Electricity
CO₂ = kWh used × Emission factor (e.g., 0.43 kg CO₂/kWh)
LPG
CO₂ = Liters of LPG × 1.51 kg CO₂/litre
Understanding formulas was challenging, but I learned how math and environmental science intersect to solve real problems.
4. Organizing and Analyzing the Data
4. Organizing and Analyzing the Data
I used Google Sheets to:
Input raw data
Apply formulas for automated carbon calculations
Create graphs for visual understanding
Categorize daily, weekly, and monthly emissions
I also calculated:
Total emissions per category
Average carbon per student/staff
Emission reduction opportunities (e.g., replacing beef meals with vegetarian options)
IC TRIPS GOOGLE SHEET
CANTEEN DATA GOOGLE SHEET
ELECTRICITY CONSUMPTION GOOGLE SHEETS
LPG CONSUMPTION GOOGLE SHEET
Page updated
Report abuse