Set Up Google Sheets and Google Drive - shiftsayan/gradecard GitHub Wiki

Gradecard uses Google Sheets as its backend and frontend. Student data is stored and aggregated in the Gradecard Sheet. Each student can view their own data along with aggregate statistics in their individual Student Cards. In this step we will make copies of the base Gradecard Sheet and the base Card.

  1. Make a copy of the base Gradecard Sheet. This serves as the base for the Gradecard Sheet.

  2. Make a copy of the base Card. This serves as the base for the Student Cards and also cards for other agents such as TAs.

  3. Create a Google Drive folder to store all the Student Cards.

  4. Move both files and the folder into a single Google Drive folder. Make sure the email address associated with the Google Cloud Platform project has 'Editor' access to this new folder.

  5. Store the spreadsheet IDs for the Gradecard Sheet and the Base Student Card in the GRADECARD_SPREADSHEET_ID and BASE_STUDENT_SPREADSHEET_ID variables in secrets.py. The spreadsheet ID can be found in the URL (https://docs.google.com/spreadsheets/d/<spreadsheet_id>/edit#gid=0) of the sheets.

  6. Similarly, store the folder ID for the Student Cards folder in the STUDENT_CARDS_FOLDER_ID variable in secrets.py. The folder ID can also be found in the URL (https://drive.google.com/drive/folders/<folder_id>) of the folder.

  7. Repeat these steps for other agents such as TAs.

⚠️ **GitHub.com Fallback** ⚠️