All data collected within LiveText can be exported to three data export features for LiveText administrators. These features are for administrators who use other data analysis tools in addition to the LiveText reporting and display features. The data is exported in a common file format, CSV, and can be imported into most data analysis tools. These data files can also be connected to LiveText documents and stored in the ExhibitCenter™.
NOTE: This report requires that a special permission be placed on the account with the approval of the institution. If you do not see the Export buttons on the Tools tab in your administrator account, please email support@watermarkinsights.com.
Export Course Assessment Data
Export Assessment Data from Reviews
The Export Assessment button creates a raw data file in a CSV format for all assessment data collected across all rubrics linked in the ExhibitCenter™ (data collected in the Send for Review process)
To export assessment data using Export Assessments:
- From within the Tools tab click the Reports tab
-
Click the Export Assessments button
- Select whether to open the file immediately with Excel (if installed) or to save the file to the local computer. Click the OK button
Export Assessments - fields
The following table lists the fields in the exported file, the data contained in each, and what the data represents. Each rubric within the assessment document will have its own line in this export. Each assessment will be tagged with the following data fields in the export.
| Column | Field Title | Data |
|---|---|---|
| A | Rec ID | A serial number used by the system that is unique and non-repeating. |
| B | Assessee Username | The username of the author of the assessed document. |
| C | Assessee Full-Name | The full name of the author that assessed the document. |
| D | School ID | The school ID of the author entered in user Account Info page or when the user registered with LiveText. |
| E | Assessor Username | The username of the evaluator of the document. |
| F | Assessor Full-Name | The full name of the evaluator |
| G | Artifact ID | The Document ID of the assessed document. It is unique to each LiveText document and in the URL (e.g. https://www.livetext.com/doc/10325837). |
| H | Artifact Title | The title of the assessed document. |
| I | Assessment ID | The Document ID of the assessed document used to evaluate the artifact. It is unique to each LiveText document and in the URL (e.g. https://www.livetext.com/doc/10325837). |
| J | Assessment Title | The title of the document used to assess the artifact. |
| K | Rubric ID | The section ID of the rubric within the assessment document. It is unique to each section of the LiveText document and in the URL (e.g.https://www.livetext.com/doc/10401030/46579080). |
| L | Rubric Title | The title of the rubric section within the assessment document. |
| M | Data Assessed | The date the assessment was last modified, saved or submitted. |
| N | Milestone | The milestone selected at the time of the assessment. |
| O | Scoring | P indicates that Practice was selected when the assessment was last modified, saved, or submitted. O indicates that Official was selected. |
| P | Status | S indicates that the assessment was Submitted using the “Save and Submit Assessment” button at the time of the assessment. P indicates that the assessment was Pending. It was saved but has not been submitted. |
Export 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.
These values are 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.
In this example, the rows have weights of 2, 4, 2, 1 and 1 respectively. The columns have 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 diagram below 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.
Export Rubric Standards
The Export Rubric Standards button creates a raw data file in a CSV format of all standards that are aligned with elements in rubrics within all assessments that are linked in the ExhibitCenter™. It is intended to be combined with the information generated by the Export Assessment feature to connect the assessment data with standards.
To export a list of standards in rubrics using Export Rubric Standards:
- From within the Tools tab click the Reports tab.
-
Click the Export Rubric Standards button.
- Select whether to open the file immediately with Excel (if installed) or to save the file to the local computer. Click the OK button
The following table lists the fields in the exported file, the data contained in each, and what the data represents. Each standard within the rubric document will have its own line in this export. For example, if an element of the rubric contains five standards, the rubric element will have five separate lines in the export.
Export Rubric Standards - fields
| Column | Field Title | Data |
|---|---|---|
| A | Rubric ID | The Section ID of the rubric within the assessment document. This is the same information that appears in the Export Assessments report. |
| B | Element | Identifies the row in the rubric that the standard is aligned with. |
| C | Standard | The number of the standard. |
| D | Standard Set | The source of the standard set |
When combined with the assessment export in a data analysis tool, this report can be used to create a report of student performance as well as instructor and/or program effectiveness that links information to standards.