The Export Course Assessments button creates a raw data file in a CSV or Excel format of all assessment data collected in all rubrics. The data collected allows administrators to view student growth within courses.
To access the Course Assessment Data Extract:
- Log into your LiveText administrator account
- Click Tools
-
Click Export Course Assessments
NOTE: If you do not see Export Course Assessments on your Tools page, please Submit a Request or chat Support to request that it be enabled
- Select one or more Terms to include in the extract
- Select one or more Colleges
- Select one or more Departments
- Select one or more Course Sections
- Select one or more Rubrics
- Select one or more Standard Sets
- Select one or more Standards
- Select one or more Student Gender
- Select one or more Student Ethnicity
- Select one or more Completion Year
- Select one or more Major
-
Select one or more Academic Program
NOTE: Student Gender, Ethnicity, Completion Year, Major, and Academic Program data is added through the Student Profiles import
- Select an Extract Format: Classic Format or Advanced Format
- Select a format to Export To: Microsoft Excel or Comma Separated Value (CSV)
- Click Export
Export Course Assessments – fields
| Column | Field Title | Data |
|---|---|---|
| A | Rec ID | The serial number is used by the system that is unique and non-repeating. |
| B | Term | The term/semester in which the assessment took place. |
| C | Course ID | The course number that is listed for the course (CRN number). |
| D | Course Code | The course code is the number that is listed for each course in the student handbook, e.g. LT 101. |
| E | Course Name | The name of the course in which faculty and student are enrolled. |
| F | College | The name of the college or school with which the student is associated with, e.g. College of Education or School of Business. |
| G | Department | The department or unit with which the student is associated with in the college, e.g. Secondary Education. |
| H | Program | The program or area of study within a department, e.g. Special Education, Social Science. |
| I | Section ID | The number given to each section of a course. |
| J | Assessee Username | The username of the author of the assessed document. |
| K | Assessee Full-Name | The full name of the author of the assessed document. |
Export Course Assessments – Understanding RL and RS fields
Each row in the export contains columns marked with RL, RS and a number. This is the representation of the collected assessment data. RL is an abbreviation for “Row Level” and represents the rows of a rubric. RL1 is the first row in the rubric, RL2 is the second row, and so on. The number in this field is the position of the selected performance level column. A “1” in this field would indicate that the assessor selected the left-most column of the rubric for an element, a “2” would indicate the next column to the right was selected and so on. The numbers in the RL fields do NOT represent performance level point values or reflect element weighting.
Note: The number of RL columns containing values will depend on the length of the longest rubric in the ExhibitCenter™. Therefore, for shorter rubrics, some RL fields may be empty.
A sample line from the export appears below.
This is visually represented in the following diagram:
RS is an abbreviation for “Row Score” and represents the weighted score the assessee received based on the point value associated with each performance level and the weight value of each row in the rubric. It is calculated by multiplying the point value of the selected performance level by the weight value of that row. A sample of the same line in the report, which was used in the previous example, is displayed below.
A sample of the same line in the report, which was used in the previous example, appears below.
In this example, the rows contain weights of 2, 4, 2, 1, and 1 respectively. The columns contain a score of 3, 2, 1, and 0. Multiplying the selected column by the weight value of that particular row (not the percentage value) produces the scores that appear in the table above.
The following diagram shows how this relates to the original rubric.
Note: The number of RS columns containing values will depend on the length of the longest rubric in the ExhibitCenter™. Therefore, for shorter rubrics, some RS fields may be empty.