Name: Hayden Hall

Affiliation: Withheld.

Location: UConn Regional Campus

Request Date Start: 04/23/2020

Request Date End: 05/07/2020

Details: I hope you are healthy during this time. I am requesting the grade distributions by percent and/or letter grade, for every class and instructor for the last two years. Please ensure the documents are FERPA compliant, usually this means removing courses with less than 12 individuals.

I request that the information is in digital CSV format (.csv or .xlsx), with each semester being in a separate spreadsheet if possible. Preferably in the form:

Course Subject, Course Number, Course Title, Course Section, Term/Semester, Primary Instructor, A+, A, A-, B+, B, B-, C+, C, C-, D+, D, D-, F, W, Average Grade in GPA.

The following code should be representative of how to complete this request from a database:

SELECT course_subject,course_number,course_title,…
FROM orders
INTO OUTFILE ‘/tmp/summer2019.csv’
FIELDS TERMINATED BY ‘,’
ENCLOSED BY ‘“‘
LINES TERMINATED BY ‘\n’;

Please notify me of any expenses prior to incurring them.

Notes: