This project aims to make use of the ICT platform of both QR scanning and google sheets to tabulate and display data in various forms to provide immediate feedback to the participants of a Physical Education class. The general concept of the data collection and manipulation will be illustrated, together with some suggested variations to suit different requirements of the lesson or school event.
The project requires the use of a mobile phone application that is able to scan and send data to a google sheet. After some research, the team has found the following:
The above mentioned applications allow teachers to scan a QR code and send the code, together with the timestamp to a google sheet (determined by the url). The concept can be summarized in the following diagram.
Concept of QR scanning
Teachers will need to generate a set of QR codes (example from 1 to 40) and assign them to students in a class list. Once the data is sent to the google sheet (master data sheet), it will be possible to identify which student has completed the task (be it a round, lap or circuit). With some formulas and manipulation, the data can be represented in various forms for easy viewing. In order to ensure that the data is not editable by the student, there will be a need to use the “IMPORTRANGE” formula in google sheets to direct data from the master data sheet.
This will allow immediate display of their completion status in terms of the number of laps they have completed, either individually or by the group assigned.
Scan to sheet
Use of IMPORTRANGE function
With the use of the formulas of VLOOKUP and ARRAYFORMULA, it is also possible to search through the raw data for the first and last scan of the code. With the start and end timestamp, a subtraction will yield the elapsed time and this can be used for events that require timing, such as 2.4km run or mass run.
Recording of Running Timing
The following video demonstrates (Refer to Headings in Video):
This screen shows how the app scans the pre-printed QR codes.
The QR code information is sent to the linked google sheet. Data includes the QR code (can be any number) as well as the timestamp of the scan.
One variation of presentation of collated data in the form of a gauge meter. The gauge meter can be set to have different green, orange or red zones for better visual appreciation to encourage students to aim for the red zone.
The leader chart can be used to sort the timestamp of the scans and it can be used to display the leading students in real time.
By adding an additional team tag to the students, it is also possible to collate the data by teams and show students the cumulative rounds completed by their teams in real time. Side by side bar graph gives very good visual of which team is leading.
Video shows the use of the formulas of VLOOKUP and ARRAYFORMULA, to search through the raw data for the first and last scan of the code for the start and end timestamp. Formula is inserted to calculate the elapsed time for events that require timing, such as 2.4km run or mass run.
The department has used the system for PE lessons for circuit based fitness challenge as well as for the NAPFA 2.4km run (Pre-COVID). The following comments were recorded.
“It’s really nice to see the live update of the score once I complete one round. I just feel more motivated to continue.”
“I like the team score format. This will make me feel that my effort contributes to the success of my team and I will want to put in more.”
“Everyone is excited to do more. It really feels more intense but I like it.”
“The live updates and charts kind of gamify the PT sessions and pushes us to give our best so we can win.”
“A choke point tends to form at the first few rounds of the 2.4km run. But after a while, it gets better when the others slow down.”
“For 2.4km, it is quite troublesome to scan but I do like the anytime start feature so I can just start at any time.”
“The scanning of the codes can be done and the scores updated quickly. Only thing is it gets a bit difficult when a queue forms. However, this can be mitigated by using staggered start times.” (Mr. Justin Chong)
“I can see the students being more motivated to complete more rounds when they see their bar graph move in real time.” (Mr. Sean Ross)
“Even the students who are normally not very participative are motivated to achieve a minimum number of rounds.” (Mr Winston Chua)
“For use with 2.4km runs, there could be some confusion when handling very large number of scans. It is not too bad but maybe it is more suitable for a route that needs only 3 to 4 rounds as compared to our current state of 8 rounds.”, (Ms. Stacey Ang)
“Good thing when using the timestamp is that you can start of the students at separate time. This is especially good for training runs.” (Ms. Eileen Ong)
After using the application for Physical Education lessons, the team found that the instant feedback display and allowing students to compare their progress with other students or teams motivate them to put in more effort to complete more laps.
The use of the application to track running time is reliable but there are issues with timely scanning of the codes. Nonetheless, the system will be good for mass events where the winning class would be the one that completes the most number of laps in a given time (mass run, mass circuits etc).
Moving on to the closing of 2020, the system will be used in our year-end inter-class games, which is in a time-based telematch format to record and display the cumulative sets completed by the class in 30 minutes. Please visit the link to view the photos and videos of the use of the system.
For 2021, we will implement our original 2020 plan to use the system to record and display the number of rounds completed by the classes during our annual mass run for Sec 1 and 3 (not taking NAPFA) as a form of alternative assessment for their 2.4km run. The cumulative distance completed will also be used in conjunction with the “Walk for Rice” event organized by NTUC and the South East Community Development Council to raise food items for needy families.
There may be some technical parts of the system that may be difficult to completely explain through written form. Please feel free to look for the following for a more in-depth explanation:
|Mr Poon Zi Liemail@example.com|
|Mr Justin Chongfirstname.lastname@example.org|