Versions Compared

Old Version 7

changes.mady.by.user trichar2

Saved on

compared with

New Version 8

changes.mady.by.user trichar2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: update based on Kautuk's page changes, some clean up

...

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

...

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

  1. Go to the folder location.
  2. Open the CourseExamsMapping.xls file.
  3. Add a new row for each exam you would like loaded with all required fields.
  4. Save and close the file.

Data Correction and Loading Process

...

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

...

:

...

 

...

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.

 

 

Examsoft API required fields:

...

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

 

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

...