...
Downloading the course audit file
Traditional option: Go to the new Course Audit website
You can also access this site through the FCQ website and click on “Course Audit”
Quick view option: Go to the course audit dashboard and click on the “Course Audit - Quick View” tab
This is a truncated version of the audit designed for quickly reviewing your classes on the web
To download the audit from this location, go to the “Course Audit - Download” tab and click the “Download Course Audit Spreadsheet” button in the upper-right corner
Both options take you to a OneDrive folder where all audits are available for download
You can also download a file with all classes (useful for coordinators in charge of multiple programs) by selecting the file named “audit(term).xlsx” (e.g., “audit2207.xlsx” for fall 2020)FCQ website and select Course Audit from the top menu
Select “View/Download course audit files”
This takes you to a OneDrive folder with course audits for the current and previous semesters
You can view any file in the window or download for your records
Key to the file names
Previous_Semesters
This is a folder containing the course audits from previous semesters going back to fall 2017
Abbreviations.xlsx
This is a glossary identifying all of the department abbreviations used in the file names
This is especially useful for new coordinators or folks in departments that have had name changes
audit(term)_all.xlsx
This is the master file for all participating campuses, which lists every class
Use filters to select your campus and department
This is primarily used for record keeping, but could be used for auditing
audit(term)_campusxx.xlsx
This is the master file for the individual campuses, similar to the _all file but separated by campus
Use filters to select your department, subjects, instructors, etc.
This is particularly useful for coordinators who oversee multiple departments
audit(term)_(campus)_(college)_(department).xlsx
These are the files for each individual department
Easiest to use since they are already sorted by campus and department
Reviewing the course audit file
The course audit file contains a lot of information, which can be intimidating at first glance. Here is a quick overview to the layout:
Columns A-BC state whether or not a class is setup to receive FCQs (not , and if so, when they will be open
Note that this information is NOT listed in CU-SIS
Columns C-G and K-V are course details (for reference only)
Columns H-J are items that can be updated in CU-SIS
Column R lists the dates a class is scheduled to receive FCQs (not in CU-SIS)
The primary columns to review are A, B, H, I and R. Here is a quick guide to the contents of these columns and what needs to be reviewed:
Column A states whether or not a class is setup to receive FCQs (“YES” or “NO”)
Ensure that the “YES” and “NO” schedules match your needs
Column B states the reason why a class will not receive FCQs (if column A is “NO”)
To turn a “NO” to a “YES,” address the issue listed in column B (note: this is not always a possibility)
Column H lists the instructor name
Is the correct instructor(s) listed? Are there instructors who should be added or removed?
Column I states whether or not the “Print” box is checked for this instructor
“YES” means an instructor may be evaluated (though the class must also be eligible)
Column R lists the dates a class is scheduled to receive FCQs
The information in these columns is generated by our office based on CU-SIS information
Columns I-K list the instructors assigned to this class in CU-SIS, their role and whether or not they have been marked “eligible” to get FCQs
This information is pulled directly from CU-SIS and reflects what your department has officially entered into the UIS system
If changes are needed, they must be made in CU-SIS by your curriculum manager
All remaining columns show the class details currently entered into CU-SIS
These can be useful, but aren’t always necessary for reviewing the course audit
This information is pulled directly from CU-SIS and reflects what your department has officially entered into the UIS system
If changes are needed, they must be made in CU-SIS by your curriculum manager
How to make changes to the course audit
...
If you’re making changes outside of the designated course audit window: Contact the FCQ program to let us know of the changes.
Lastly, download a new copy of the view or download an updated course audit file to verify that your changes have gone through.