Index to Science Facility Database
|
Content |
Title |
Type |
Notes |
|
All courses for college |
Courses and credits |
Table |
|
|
All classes taught in the three buildings (sorted by building and room) |
Courses in LES, WILK, or MCS |
Query |
|
|
All classes taught in the three buildings (sorted by department and course number) |
Building courses by department |
Query |
|
|
Division faculty list |
Faculty |
Table |
|
|
|
|
|
|
|
All classes taught by faculty in the division (sorted by term, home department and course number) |
Courses taught by the division |
Query |
|
|
All classes taught by faculty in the division (sorted by term, home department and faculty member) |
Courses taught by department and faculty |
Query |
|
|
All classes taught by faculty in the division (sorted by term, faculty member and course number) |
Courses taught by faculty member |
Query |
|
|
|
|
|
|
|
All courses per department (by semester) |
Courses and Credits XXX (where XXX is each department’s 3-letter code) |
Query |
|
|
Classroom courses per department (by semester) |
Classroom courses taught by division |
Query |
|
|
Lab courses per department (by semester) |
Lab courses taught by division |
Query |
|
|
|
|
|
|
|
Total credits per department (by semester) |
Contact Hours by semester and dept |
Query |
|
|
Classroom credits per department (by semester) |
Classroom hours by semester and department |
Query |
|
|
Lab hours per department (by semester) |
Lab hours by semester and department |
Query |
|
|
|
|
|
|
|
FTE’s per department (by semester) |
FTE's per year by Department |
Query |
22 credits/FTE (partial difference for lab – check and fix this later) |
|
|
|
|
|
|
Courses taught sorted by room |
Room utilization |
Query |
|