The following guidelines are recommended for the USF Morsani College of Medicine community in mapping required exams. This will identify specific course exams to each medical student for a given semester. These test scores are loaded to the Health Education Data Warehouse and other student information.
Archive - Contains the Course Exams Mapping files that have been loaded to the database in the past.
Error_Logs - contains the following two files:
EXMS_Incorrect_Exams.csv - Contains invalid exams IDs in the file when data was last available.
EXMS_Incorrect_Students.csv - Contains U-number records which don't match any Health Banner students in the file when data was last loaded.
Required file format - Contains the template file 'CourseExamsMapping.xls'. Please use it to generate any files that need to be loaded to the database as it contains the necessary columns in the correct order.
The exams that have multiple courses for a singular exam (currently Course 1) need to be listed on 2 separate tabs.
Exams - First tab used to pull in the student scores for the singular exam from Examsoft.
2_Exams_Per_Banner_Course - Second tab is similar to the first tab, except it allows the ability to split an exam into separate banner courses based on the description of the individual question (currently MS or CA).
If there is ever a change in the descriptor fields or new descriptors need to be added, it will require a change in the process that loads the Examsoft data.
It is important that the Excel files be closed and not open for editing before the load process begins. When the data load begins if the file is open then the process will error out. The load happens on every Saturday at 9:15AM.