Course Evaluation

Data Processing and Storage

Course Evaluation input sources (MUO/MFCF and IST) are validated against Quest records of instructors/sections for a given term in order to normalize instructor IDs and to add class IDs where missing.

Normalization and Import process

• See CourseEvaluationSysadminDocs for detailed instructions on the import process, and the database schema.

Data is stored in postgres table raw_course containing:

• one record for each class section per term with summary reports of responses to particular questions:

Data Processing

• The data is then processed via python script to produce summary statistics for each class section per term

• Key for calculations in the last column (celln corresponds to sub-answer of question)

Summary Statistics Per Term

Data is stored in postgres table ratings containing:

• one record for each class section per term with calculations based on the data in raw_course:

• summary is also known as the "Tompa Score" for a particular course.
• An instructor's overall summary for a term can be calculated by averaging the summary for all the courses they have taught.

Summary Statistics Aggregate

Data is stored in postgres table report_5year containing:

• one record for each class section per term with calculations based on the data in ratings:

Five Year Report (15 terms), averages per-instructor and per-course:

The above sample shows that in the Fall 2010 term, when John Doe taught section 2 of
MATH 123, 113 persons responded, accounting for 73% of the students;

they attended 85% of the lectures on average (N.B. the highest
possible value here is 90% since I [Frank] rate "x-y%" as if it were x%),
worked 5.5 hours per week outside of class;

they graded the professor at 3.49 for preparation, 3.84 for delivery,
3.63 for effectiveness (these 3 on a scale of 5=best to 1=worst), for
3.65 average score.

In 6 offerings of this course during the last 15 terms (up to last
term), the averages were 4.12, 4,12, 4.08, 4.10 for preparation,
delivery, effectiveness, and weighted average, respectively.

In 4 offerings by this instructor during the last 15 terms, the
averages were 3.68, 3.84, 3.67, 3.72 for preparation, delivery,
effectiveness, and weighted average, respectively.

Report output format (for pasting in instructions to faculty)

-- DanielAllen - 2013-11-02