Location

\\hscetl\

...

ExamSoft

The folder also has the following sub-folders:

• • Archive - Contains the Course Exams Mapping files that have been loaded to the database in the past.
  • 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.

Rules for Data

1. All columns in the template file are required. Is this true? Section isn't required is it?
2. Must have a valid Exam and Posting ID which can be found within Examsoft.
3. Multiple rows per Exam ID are allowed with different Posting IDs.
4. Must have a valid U-Number for a USF Health Student.
5. Must have a valid term code available in Health Banner.
   1. Example format: 201707
   2. The first 4 digits are the year during which the term begins.
6. Must have a valid Course Abbreviation and Course Number available in Health Banner.
7. Sequence numbers are used to identify the order the exams were administered or types of exams
   1. 1-4
   2. 20-23:Reserved for Anatomy Practical Exams
   3. 30 and 31: EBCR Exams
   4. 75: Remediation exams that may cover more than 1 original exam topic
8. Columns must be in the order indicated on the 'CourseExamsMapping.xls'

New File Loading Process

Follow these steps to add a new Exam to be loaded into the Educational Data Warehouse:

Data Correction and Loading Process

Follow these steps to provide a corrected mapping file for loading the Examsoft exams to the database:

1. Go to the folder location.
2. Locate the error log file name mentioned in the email.
3. For Incorrect Students,
4. For Incorrect Exams,

Load Schedule

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 is expected to happen XXXXXXXXXX.

Examsoft Tests that are used for 2 courses

BMS 6640 and BMS 6816

BMS 6640 and BMS 6206

At this time we are unsure what to do with these courses.

Additional Information that may need to be moved to inside the body:

The above shared drive folder has the following files:

CourseExamsMapping.xls - This file has multiple uses.  It is used to map the Examsoft test name to the Banner course number.  It is also used to determine which Examsoft exams need to be used to look up student scores.

EXMS_Incorrect_Exams.csv - This file has a list of Exams that cannot be found in the Educational Data Warehouse.

EXMS_Incorrect_Students.csv - This file has a list of Students that cannot be found in the Educational Data Warehouse.

The folder also has the following sub-folders:

• Archive - contains old versions of the input file CourseExamsMapping.xls 
• Required file format - contains a version of the CourseExamsMapping.xls that has the columns in the correct order, as well as only the columns that are necessary.

...

Examsoft API required fields:

EXAMID and POSTINGID are the only 2 needed to pull data from Examsoft.  It is ok to have multiple EXAMID and different POSTINGID, when multiple duplicate EXAMID's are used the data load will pull full data sets that then get reduced by removing duplicates.

Educational Data Warehouse required fields

...

SEQ and TERM are used to list the exact course sequence and the term the ExamSoft coure is taken.

Load Schedule

It is important that the Excel file CourseExamsMapping.xls should not be left open.  When the data load begins if the file is open then the process will error out.

Examsoft Tests that are used for 2 courses

BMS 6640 and BMS 6816

BMS 6640 and BMS 6206

At this time we are unsure what to do with these courses.