CU Boulder Grade Data
Steps to Update Database:
- Fetch Latest Data from CU's ODA Website (Over Time Reports -> Grades -> Grade distributions) (should be a file named gradesall on Google Drive)
- Export
Data
sheet as a CSV file. Saydata2.csv
- Using
sqlite3
import the CSV file.
$ sqlite3 newdb.sqlite
sqlite> CREATE TABLE IF NOT EXISTS "raw_data" (
"YearTerm" INTEGER,
"CrsPBADept" TEXT,
"CrsPBAColl" TEXT,
"CrsPBADiv" TEXT,
"Subject" TEXT,
"Course" INTEGER,
"CourseTitle" TEXT,
"Level" TEXT,
"CrsLvlNum" TEXT,
"Activity_Type" TEXT,
"Instruction_Mode" TEXT,
"Hours" REAL,
"N_EOT" INTEGER,
"N_ENROLL" INTEGER,
"N_GRADE" REAL,
"PCT_GRADE" TEXT,
"AVG_GRD" REAL,
"PCT_A" TEXT,
"PCT_B" TEXT,
"PCT_C" TEXT,
"PCT_D" TEXT,
"PCT_F" TEXT,
"PCT_C_MINUS_OR_BELOW" TEXT,
"PCT_DF" TEXT,
"PCT_DFW" TEXT,
"PCT_WDRAW" TEXT,
"PCT_INCOMP" TEXT,
"N_PASS" INTEGER,
"N_NOCRED" INTEGER,
"N_INCOMP" INTEGER,
"RAP" INTEGER,
"Honors" INTEGER,
"insname1" TEXT,
"insgrp1" TEXT,
"insttl1" TEXT,
"insname2" TEXT,
"insgrp2" TEXT,
"insttl2" TEXT,
"insname3" TEXT,
"insgrp3" TEXT,
"insttl3" TEXT,
"Section" TEXT,
"NComb" INTEGER,
"Subject_Label" TEXT
);
sqlite> .mode csv
sqlite> .import data2.csv raw_data
sqlite> DELETE from raw_data where YearTerm < 20161;
sqlite> VACUUM;
Now, you can replace the database with the latest version:
$ mv newdb.sqlite grades.sqlite