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.

1 comment:

  1. When i studied at my university there was also such a thing as community service for the sake of getting a diploma. But this only extended to those students who wanted to have a second degree on behalf of the university. Probably this diploma is nowhere and will not be useful to anyone. So i didn’t work for this degree. I didn't always have time to do all my homework. So i had no time for additional loads. Maybe if at the time when i was studying at the university there were such services (which help with writing research papers and with homework), then i would have spent time on community work instead of homework, and would buy homework from special services 🖌. But i don't think so.