Overview

Full database documentation can be found on the Google Drive here

Scripts for parsing data are located in:

    backend > server

Updating Attendance

• Download attendance CSV files from Zoom

    Go to: set [From - To] date > click search > click participants number > Export
  

• Place CSV files into: server > data> zoom data.

• Run attendance.js [data will be parsed then exported in the output folder]

• Download template from Microsoft Dynamics

• Paste exported data into template then upload to Microsoft Dynamics

Updating Grades

• Download grades CSV files from Canvas Grades

    Go to: course > gradebook > export > export entire gradebook
  

• Place CSV files into: server > data> canvas data.

• Run grade.js [data will be parsed then exported in the output folder]

• Download template from Microsoft Dynamics

• Paste exported data into template then upload to Microsoft Dynamics

How to update script files at the start of every quarter

1. Open the script file (attendance.js or grade.js)

2. Ctrl + f for the TODO comment, this will list the fields to be updated, likely:

    - spreadsheetId (this pulls names, not needed if hard-coded)
   
    - QUARTER
   
    - YEAR
   
    - PROGRAM
   
    - LEVELS
   
    - END_DATE
   
    - group
   
    - students array (only if hard-coded students at the end)