Overview
The DS Minor review process currently requires advisors to manually verify information provided by students. This process can be streamlined by integrating information from SIS API for automated verification. API credentials for this purpose have already been obtained.
Inputs
Students will fill out a Google Form that collects information including their Student ID (SID). The raw form responses will be input to the script. The Google Sheets holding the Google Form Responses contains all responses ever for people both applying to the minor and people dropping the minor. Responses with “drop the Data Science Minor” in the column titled "Type of Request" can be ignored for the purposes of this script.
Only responses for the current review period should be evaluated. Because the review periods are not programmatically determined and may shift year to year, a sheet defining the review periods (or maybe just the current review period) will be necessary. This could shift to continuous evaluation where instead of bulk SIS API queries, we query for an individual response at the time of submission. The script should be written to allow for both bulk review and continuous review.
Outputs
The script will verify the following
- Terms in attendance
- EGT
- Eligibility: Data 8/Stat 20 taken for C- or better
- Eligibility: Course 1 toward the minor
- Term (or in progress)
- Course name
- Grade
- evaluation: approved course taken for C- or better OR in progress
- Eligibility: Course 2 toward the minor
- Term (or in progress)
- Course name
- Grade
- evaluation: approved course taken for C- or better OR in progress
- Overall eligibility
Overview
The DS Minor review process currently requires advisors to manually verify information provided by students. This process can be streamlined by integrating information from SIS API for automated verification. API credentials for this purpose have already been obtained.
Inputs
Students will fill out a Google Form that collects information including their Student ID (SID). The raw form responses will be input to the script. The Google Sheets holding the Google Form Responses contains all responses ever for people both applying to the minor and people dropping the minor. Responses with “drop the Data Science Minor” in the column titled "Type of Request" can be ignored for the purposes of this script.
Only responses for the current review period should be evaluated. Because the review periods are not programmatically determined and may shift year to year, a sheet defining the review periods (or maybe just the current review period) will be necessary. This could shift to continuous evaluation where instead of bulk SIS API queries, we query for an individual response at the time of submission. The script should be written to allow for both bulk review and continuous review.
Outputs
The script will verify the following