Wednesday 20 June 2018

Calculating Volunteer Hours

In Ontario, students are required to complete 40 hours of community service to graduate.  In our district, when students complete hours, students must complete a form and submit it to the Student Services department.

I had a teacher reach out to ask me about calculating all those hours.  She is the P.E. department head, and she gives hours to students who help with after school sporting events (time keeping, score keeping, etc.).  Rather than have students fill out a paper form after each activity, she has them fill out a Google Form indicating their name, the activity, and the number of hours completed.  All the info populates to a Google Sheet.  The problem is that students might have multiple entries and she was looking for a quick way to calculate the total number of hours per student. 

The answer:  Pivot Tables!
pivot table is a tool that allows you to reorganize and summarize selected columns and rows of data in a spreadsheet or database table to obtain a desired report.

In this case, you can select the student names and then find the sum of all their entries.

Here is the video I created to help...hope it helps you too.