Skip to content

Grade Distribution

Jump to bottom
Kev Wang edited this page Feb 28, 2023 · 12 revisions

Updating Grades

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

  1. Go to the CalAnswers dashboard https://caauth.berkeley.edu/dashboard and request "Global Dashboards Access" for "Type of Access"
  2. 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.
  3. 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
Screenshot 2023-02-15 at 5 25 40 PM
  1. Apply, then at the bottom, pick Export -> csv
  2. Save as fall_2018_under.csv in berkeleytime/backend/grades/resource/raw/
  3. 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!
  1. 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.
  1. This generates a new file fall_2018.csv in berkeleytime/berkeleytime/backend/grades/resource/formatted/
  2. Commit and push these changes to staging.
  3. Wait a bit for the staging to deploy (~15-20 min at most)
  4. Check out and follow the sets of Setting Up Kubernetes.
  5. 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.
  6. Ensure that the database update works for staging, and then deploy and run the same command on prod!
Clone this wiki locally