References:
BC Ferries wants to provide an app to help SD 68 (Nanaimo/Ladysmith Area) Elementary and Secondary school teachers to organize group ferry travels from Nanaimo's Duke Point to Vancouver's Tsawwassen in school events.
For group travelling in school events, BC Ferries charges $10.00 for each student that is 12 to 18 years old, $5.00 for each student that is 5 to 11 years old, and $17.10 for each accompanying adult. And there is an additional charge called Nanaimo Port Authority Fee. This additional fee charges $0.50 for each passenger that is 12 years or older, and $0.30 for each passenger that is 5 to 11 years old.
Assuming that the students will be travelling using a bus, BC Ferries charges $5.40 per foot of the bus.
Just to give you an idea, a standard school bus is approximately 35 feet long. Suppose the event is a class event using a standard bus, there are 20 students aged 12 and 10 students aged 11 in the class, and there are 3 accompanying adults (including teachers, bus drivers and other supervising adults) travelling with the class, then the total charge the school needs to pay for the one way ferry trip would be:
20 * $10 + 20 * $0.5 (for older students) + 10 * $5 + 10 * $0.3 (for younger students) + 3 * $17.1 + 3 * $0.5 (for the 3 accompanying adults) + 35 * $5.4 (for the 35 feet long bus) --------------------------------------- = $504.8
Before submitting your assignment, you need to check at least the following things:
How to submit:
To submit your macro enabled solution Excel file, First login to your VIU Learn account, find the CSCI 112 course page, click on the "Assessment" drop-down menu, click on the "Assignments" item, then click on the folder named "A3". Then you can click on the "Add a File" button to browse and upload your solution file.
If you have difficulties to make the VIU Learn submission work, please email me to let me know and attach your Excel solution file with your email.