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 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).
For students in courses where the grade is not posted to Transcript, such as elementary students, the student must have a grade posted to a state-reported Grading Task or Standard to report.
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 can submit 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.
Report Layout
| Element | Logic | Location |
|---|---|---|
| ADMINID | The VT AOE assigned unique identifier for the Supervisory Union/District 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 a 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 |
