After cleaning up the data we had collected about the cars, the questions was:
How do we find the emission data for each model?
After doing some research on the internet and a few tips from Dr. Odero we found the website of the National Association of Automobile Manufacturers of South Africa.
This online database had stored the CO2 emission values of almost every car model driving on Namibian roads.
On the webpage one chooses the car manufacturer and model. With the help of the specifics given in the survey (like engine capacity and transmission) we were able to identify the CO2 Emission in g/km of the individual cars.
With this information we completed our excel table.
To calculate the carbon footprint for our school we multiplied the emissions of the individual cars by the amount of trips the student took to and from school per week by the distance travelled in km.
This gave us the carbon footprint of each participant per week. These results were then used to calculate the average carbon footprint per student per week:
11.57 kg of carbon dioxide are emitted on average by every student at DHPS through his transport to and from school every week.
To calculate the total carbon footprint of the whole school, we multiplied this value by the number of weeks per year and the number of students at our school.
The result was the annual transport carbon footprint of DHPS: