Office of Environmental Sustainability
NUS Office of Environmental Sustainability Intern Position
NUS Office of Environmental Sustainability (OES) monitors the university’s carbon emission to work towards achieving NUS emission target. One of our targets for emission monitoring is Scope 3 emission. Scope 3 emission encompasses indirect greenhouse gas emissions resulting from the university’s activities such as air travelling. Air travel has been a major contributor to NUS overall emission. In 2009, staff air travel accounted for 25% for NUS’ total carbon emission. This resulted in a 20% cut in air budget for staff for the following financial year to help mitigate global warming from air travel carbon emission. However, the calculation method for carbon emission from air travel is a routine, given the large volume of flights yearly. In the past, the calculation and recording process were time-consuming as data were inputted manually. Hence, the OES would like to invite any individuals with programming acumen to come forth to create software that can calculate air travel emission more efficiently.
Job Scope and DescriptionTo develop software to calculate air travel emission more efficiently
The software needs to process roughly 450 entries from 1000 air tickets issued monthly. The air travel data will be provided in Excel sheet format. Each data contains information on detailed itinerary, including flight class and transit flights. Using this information, the data will be fed into an online carbon emission calculator Atmosfair (www.atmosfair.com), which will return the equivalent amount of carbon emitted by the flights. These numbers will then be recorded into the same Excel sheet.
Here are a couple of data as examples for the air travel emission calculation.
SIN/LAX/SIN means the flights are from Singapore Changi Airport (SIN) to Los Angeles International Airport (LAX) and back to Singapore Changi Airport (SIN).
SIN/PEK//XMN/SIN means the flights are from Singapore Changi Airport (SIN) to Beijing Capital International Airport (PEK), and followed by Xiamen Airport (XMN) to Singapore Changi Airport (SIN).
Each flight data at different class will be inputted into online calculator Atmosfair. Subsequently, the amount of carbon emitted will be recorded in the Excel sheet accordingly.