Skip to main content
Continuing Online Operations
Loyola is continuing online operations while we prepare for reopening safely in the fall. Coronavirus resources

Evaluation Kit Data Processing: Input/Output

Source Information

Course and enrollment information for a given semester is download from LORA/SIS using Blackboard Extract reports implemented using WebFocus. A username and password is needed to access these reports. 

 

The reports used are:

Blackboard – Batch Create Instructors – Includes CWID

Blackboard – Batch Create Students – Includes CWID

Blackboard – Batch Enroll Instructors – Includes CWID

Blackboard – Batch Enroll Students – EXCLUDES WD

Blackboard -- Raw Courses Report (Includes Session) - 06-09-2016-Updated

Input Text File Headers

Text files captured from the WebFocus reports can be imported as tables in the MS Access database after the column information left by WebFocus has been removed and replaced with a pre-defined header line. 

Raw Courses

TERM,COLL,DEPT,XLIST,XLISTID,COURSEID,SECTION,TITLE,ENROLL,INSTR1,INSTR2,ACTIVITY,LORAP,STATUS,NOTE

 Students

OldUName,Username,Lastname,Firstname,Email,Pwd

Instructors         

OldUName,Username,Lastname,Firstname,Email,Pwd,SortName

Enrollments (both Students and Instructors)

CourseID,OldUName,Username,Role  

Uploadable File Format

Each file uploaded to the Evaluation Kit system specifies the enrollments in one or more courses, each with an Evaluation Kit project ID and set of survey start and end dates. Each uploaded file must have the following header as its first line:

ProjectID,AddDrop,Code,Title,UniqueID,UserTypeID,Firstname,Lastname,Email,Username,SurveyStart,SurveyEnd,AdminStart,InstructorStart

An example of a data line is:

29222,1,16S-ACCT-B202-001,FIN ACCT FOR DEC MKG,16S-ACCT-B202-001,3,example first name,example last name,example email@domain.edu,12345678,mm/dd/yyyy,mm/dd/yyyy,mm/dd/yyyy,mm/dd/yyyy

The fields comprising the data line, from left to right, are:

FIELD

DESCRIPTION

Project Id

The EK Project ID identifying a particular survey format for a particular semester and group of courses.  Project IDs must already exist in the EK database before enrollments related to them can be uploaded.

Add/Drop

1 to add an enrollment from an EK project; 0 to drop an enrollment from an EK project

Code

The Blackboard Course ID, always identical to the UniqueID field.

Title

The title (name) of the course.

UniqueID

The Blackboard Course ID, always identical to the Code field.

UserTypeID

3 for an instructor; 4 for a student.

Firstname

The first name of a student or instructor

Lastname

The last name of a student or instructor

Email

The email address of a student or instructor

Username

The Blackboard user name identifying a student or an instructor; almost always a Campus Wide ID number.

SurveyStart

First date on which a student can complete the survey.

SurveyEnd

Last date on which a sttudent can complete the survey.

AdminStart

First date on which a department administrator can view survey results

InstructorStart

First date on which an instructor can view survey results.