Tool Search: SLDS
The Student Section Results extract collects the scores the student received in a course and aims to enhance Vermont's ability to efficiently and accurately manage, analyze, and use education data.
Report Logic
Students who have any enrollment in the calendar that is before the entered Effective Date are included in the report, unless their enrollment record is marked as State Exclude.
The Course must have a SCED code assigned to it to be included (Scheduling > Courses > Course > NCES Data > NCES Code).
Students must have a State Grade assigned to them.
Students must have a grading task or standard marked as State Reported.
Report Editor
| Field | Description |
|---|---|
| Submission Code for File Name | Indicates the report naming convention based on the submission time frame of the report. |
| Extract Type | Indicates which extract generates. For this instance, select 14a Stu Section Enrollment. |
| Effective Date | Indicates the date from which data is pulled for the report. This field auto-populates with the current date; use the calendar icon to select a new date or enter a new date in mmddyy format. |
| Format | Determines the format for the report. Use State Submission when submitting the final data. Use HTML for data review and testing. |
| Report Legal Identities | When marked, the student or staff name and gender report from the Protected Identities Information on the Identities record. |
| Select Calendars | The calendar(s) from which data is pulled for the report. This option is only available when generating the HTML for the File Format and can assist with verifying data for individual calendars. |
Generate Report Submit to Batch | Users have the option of submitting the report request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process allows larger reports to generate in the background without disrupting the use of Campus. |
Generate the Report
- Select the appropriate Submission Code for file name from the dropdown.
- Select 15 Student Sec Results for the Extract Type.
- Enter the desired Effective Date.
- Select the desired Format.
- If desired, mark the Report Legal Identities checkbox.
- If generating in HTML Format, select the desired Calendars from which to report data.
- Click the Generate Report button. The report displays in the selected format.
Student Section Results - HTML Format
Student Section Results - State Submission Format
Report Layout
| Element | Logic | Location |
|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District that is submitting data. Alphanumeric, 6 characters | System Administration > Resources > District Information > District Detail > State District Number District.number |
| PERMNUMBER | The VT AOE assigned unique student identifier. This number is distinct for each student over time. Numeric, 10 digits | Census > People > Demographics > Person Identifiers > Student State ID. Person.stateID |
| ENRORGID | The VT AOE assigned unique identifier for an organization providing direct instructional or educational services. Alphanumeric, 6 characters | System Administration > Resources > School > School Detail > State School Number School.number |
| LOCALCOURSEID | A unique identifier assigned by the school to each of their courses offered in a school year. Alphanumeric, 55 characters | Scheduling > Courses > Course > Course Editor > Number Course.number |
| COURSESECTION | A unique identifier assigned by the school to each of their course sections offered in a given school year. The Course Section number is the Course Number and Section Number combined. It also includes an Flexible Pathways code that is selected on the Course Section editor. A Course Number of 100, a Section Number of 20, and a Flexible Pathways code of CP reports as 10020_CP. Alphanumeric, 30 characters | Scheduling > Courses > Course > Course Information > Number Course.number Scheduling > Courses > Course > Sections > Section Editor > Section Number Section.number Scheduling > Courses > Course > Sections > Section Editor > Flexible Pathways Section.instructionalSetting |
| COURSELETTERMARK | An alphabetical or categorical expression of performance earned by an individual. Reports from Grading Tasks that are marked as State Reported. The State Score from the Score Group List Items Detail reports. Code 99 reports a numeric Score. Numeric, 2 digits | Grading & Standards > Grading Tasks Grading & Standards > Score Groups & Rubrics>Score Group List Items Detail > State Score ScoreListItem.stateScore |
| COURSENUMERICMARK | A course mark on a 100-point (percentage) scale. Reports from Grading Tasks that are marked as State Reported. The State Score from the Score Group List Items Detail reports. If State Code 99 is selected on State Code on Score Group and Rubrics, then the Numeric Score reports and Code 99 reports as the Course Letter Mark score. Numeric, 6 digits NNN.NN | Grading & Standards > Grading Tasks Grading & Standards > Score Groups & Rubrics>Score Group List Items Detail > State Score ScoreListItem.score |
| CreditsEarned | The amount of credits earned by a student upon completion of the course section. The default value for this field is 0. Numeric, 5 digits (NN.NN) | Student Information > General > Transcripts > Transcript Credit > Earned GradingTaskCredit.credit |
| SY | The school year for which data is being submitted. Numeric, 4 digits (YYYY) | N/A |
