Design Thinking Final Project

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

 

Leave a Reply