At HKIS, students are late for a variety of different reasons, and when they arrive late, they are told to go to the attendance office to collect a late slip. Unfortunately, walking to the attendance office takes time, the late slips are written manually, and often there is a line to collect them. Because of these factors, students who are not on time are forced to become even more late, and miss out on minutes of valuable learning.
Questionnaire: https://goo.gl/forms/LXvIBO95hKdnNZSK2
Results:
Summary of Results:
From the results in the questionnaire, it is obvious to see that being late is an issue for many students, but more importantly, students overwhelmingly do not have a positive view of the late slip system, and would like to have an app that could make the late slip process more efficient.
Design Thinking Statement:
HKIS students need a way to more efficiently collect late slips, because the current method is inefficient, which wastes valuable class time.
List of Equipment Required for the Project:
- The names, student numbers, and emails of HKIS students
- The class schedules of HKIS students
- The required details students fill in to receive a late slip
- The format of an actual slip
Image of Late Slip Sign In/Out Sheet:
Image of a Late Slip:
Flow Chart:
Pseudocode:
Image of Final Code:
Testing Document:
https://docs.google.com/spreadsheets/d/1NMa1STGdCPZJS2Ah98bFAmh2rTwrfIEEP3s4Flph0XA/edit#gid=0
References:
https://developers.google.com/apps-script/guides/sheets
https://developers.google.com/apps-script/articles/mail_merge
https://support.google.com/docs/answer/46977?co=GENIE.Platform%3DDesktop&hl=en
https://support.google.com/docs/answer/3094123?hl=en