update to include Fall 2023

1 files changed, 70 insertions, 0 deletions

diff --git a/README.md b/README.md
new file mode 100644
index 0000000..de732eb
--- /dev/null
+++ b/README.md
@@ -0,0 +1,70 @@
+# CU Boulder Grade Data
+
+## Steps to Update Database:
+
+1. Fetch Latest Data from [CU's ODA Website](https://www.colorado.edu/oda/student-data/courses) (Over Time Reports -> Grades -> Grade distributions) (should be a file named gradesall on Google Drive)
+2. Export `Data` sheet as a CSV file. Say `data2.csv`
+3. 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
+```