z[ARCHIVED] Grade Distribution

Updating Grades

To update grades, first retrieve the grade data from CalAnswers.

0. Go to the CalAnswers dashboard https://caauth.berkeley.edu/dashboard and request "Global Dashboards Access" for "Type of Access"
1. Log in to http://calanswers.berkeley.edu and navigate to Student Data Dashboards > Student Curriculum > Course Grade Distribution, then go to the Grade Distribution tab.
2. To download course grades for a semester (i.e. Fall 2018), filter by the following:

• Semester: Fall 2018
• Course Level: lower, upper
• Everything else: deselect everything for all

---

3. Apply, then at the bottom, pick Export -> csv
4. Save as fall_2018_under.csv in berkeleytime/backend/grades/resource/raw/
5. Do the same for Course Level: grad and save as fall_2018_grad.csv

• NOTE: On Mac OS a .DS_Store file may be created (it is a hidden file), make sure to remove this file before going on to the next step!

6. Run python manage.py translate-grades.

• If there is an error complaining about a department name, fix it in backend/playlist/utils/config/abbreviation.yaml
• Or use the flag --skip-broken with translate-grades.

7. This generates a new file fall_2018.csv in berkeleytime/berkeleytime/backend/grades/resource/formatted/
8. Commit and push these changes to staging.
9. Wait a bit for the staging to deploy (~15-20 min at most)
10. Check out and follow the sets of Setting Up Kubernetes.
11. SSH into the berekelytime-stage pod per the instructions of #11. Then run python manage.py grade --semester fall --year 2018 to update the database.
12. Ensure that the database update works for staging, and then deploy and run the same command on prod!