Versions Compared

Old Version 8

changes.mady.by.user trichar2

Saved on

compared with

New Version 9

changes.mady.by.user jrussel1

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.
    • 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.

 

Rules for Data

  1. All columns in the template file are required.
  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: Course Exams
    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'
  9. Exams with multiple banner courses (Course 1) need to be listed on both of the tabs.  The second tab allows the Banner Course mapping to occur at the individual question level.

New File Loading Process

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

...

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:

 

Examsoft API required fields:

Educational Data Warehouse required fields

COURSEABBR,COURSENUM ,SEQ,TERM

COURSEABBR, COURSENUM are used to tie the courses to the actual Banner courses, 

...

(Course 1)

The exams that are have multiple courses for a singular exam (course 1) need to be listed on 2 separate tabs.  The first tab (Exams) is used to pull in the student scores for the singular exam from Examsoft.  The second tab (2_Exams_Per_Banner_Course) is almost a duplicate of the first tab, except it allows the ability to split a course into separate banner courses based on the description of the individual question (MS or CA).  If there is ever a change in those descriptor fields, or new descriptors need to be added it will require a change in the process that loads the Examsoft data.  The exams that have multiple courses need to be listed on both tabs.

 

 

 

  •  jrussel1: We need to clean up this page still.

...