Student Class Report (New Hampshire)

Classic View: NH State Reporting > i4see Extracts > Student Class Report

Search Terms: i4see Extracts 

The Student Class Report is used to report both the student's grade at the end of each term and the progress grade.

Student Class Report  

Report Logic

  • If the Start Date and End Date are blank on the Extract Editor, reports all students who are enrolled at the school in the year selected to report.This allows districts to report students who have future enrollments.
  • If the Start Date and End Date are populated on the Extract Editor, reports all students who are enrolled at the school during the entered date range. This allows district to update data at the state level for a single quarter, semester, etc.
  • Students do not need to finish a course to be reported.
  • Only grading tasks marked as State Reported are included in the report.
  • If the Exclude from State Reporting checkbox is marked on the Course tab, the course will be removed from State Reporting.
  • Courses assigned a CIP Code are not included.

Start and End Dates

  • If a Start Date is entered on the Extract Editor, an End Date must also be entered. A warning message displays indicating the need for the End Date.
  • If an End Date is entered on the Extract Editor, a Start Date must also be entered. A warning message displays indicating the need for the Start Date.
  • If a Start Date or End Date is not entered, the extract will generate for the entire school year for the selected calendar(s).

Report Editor Options

Data Element

Description

Extract Type

Indicates the type of extract selected. Select Student Class Report from the list of options. 

Start Date

Beginning date of the student enrollment records. Dates are entered in mmddyy format or can be selected by using the calendar icon.

End Date

End date of the student enrollment records. Dates are entered in the mmddyy format or can be selected by using the calendar icon.

Ad Hoc Filter

Selection of previously made filter that contains specific students to include in the label request.

Grading Task

A list of all of the grading tasks in the district.

Report Format

Determines how the request is generated - in the State Format (CSV) or HTML. Use the HTML format when reviewing data. Use the State Format when submitting the list to the state.

Select Calendars

At least one calendar must be selected in order for the extract to generate. Calendars are selected by the active year, by the school, or by the year. Students in the chosen calendars are included in the extract.

Generate the Report

  1. Select the Student Class Report from the Extract Type dropdown list.
  2. Enter the Start Date and End Date of the enrollment records to include.
  3. Select an Ad Hoc Filter from the dropdown list to reduce the amount of students included in the extract.
  4. Select the Grading Task from the dropdown list to be reported.
  5. Select the Report Format.
  6. Select the Calendars from which to pull students in the report.
  7. Click the Generate Extract button. The report will display in the selected format.

Student Class Report - HTML Format

Student Class Report - Stat Format (CSV)

Extract Layout

Data Element

Description

Type, Format
and Length

Campus Database

Campus Interface

SASID

The State Assigned Student ID.

Numeric, 10 digits

Person.stateID

Census > People > Demographics > Person Identifiers > State ID

Date of Birth

The Student's date of birth.

Date field, 10 characters

MM/DD/YYYY

Identity.birthdate

Census > People > Demographics > Person Information > Birth Date

SAU Number

The School Administrate Unit Number.

Numeric, 3 digits

School.SAUnumber

System Administration > Resources > District Information > District Info > SAU Number

District Number

The state-assigned district number.

Numeric, 3 digits

District.number

System Administration > Resources > District Information > District Info > District Number

School Number

The district-assigned school number.

Numeric, 5 digits

School.number

System Administration > Resources > School > School Detail > State School Number

Local Class Code

Identifies the course number

Numeric, 6 characters 

Course.number

Scheduling > Courses > Course > Course Editor > Number

Course Grade ID

Indicates the grade received for the course. If the student does not have a grade for the selected grading task, reports NULL.

Numeric, 3 digits

Course.gradingTask

Scheduling > Courses > Course > Grading Task

Section ID

Identifies the section number of the course the student is taking.

Numeric, 3 digits

Section.Number

Scheduling > Courses > Section > Section Editor > Section Number

School Year

Identifies the school year. 

Numeric, 4 digits

YYYY

Calendar.year

System Administration > Calendar > School Years > School Year Editor > End Year

Term ID

Indicates the term when the course occurred.

  • If the section occurs in each division of the school year (semester, trimester, etc), reports as Year Long (30).
  • If school year division is Quarters:
    • If the section spans 3 out of 4 quarters, reports as Multi Term (31) 
    • If the section spans 2 quarters and the minterm = 1 and maxterm = 2, reports as Semester 1 (01)
    • If the section spans 2 quarters and the minterm = 3 and maxterm = 4, reports as  Semester 2 (02).
    • Otherwise reports as Multi Term (31).
    • If the section spans 1 term based on maxTerm, reports the appropriate Quarter number (01, 02, etc.).
  • If school year division is Trimesters 
    • If section spans 2 out of 3 trimesters, reports as Multi Term (31)
    • If section spans 1 trimester, based on maxTerm, reports the appropriate Trimester number (01, 02, etc.).
  • If school year division is Semesters and section spans 1 out of 2 semesters, reports the appropriate Semester number (01 or 02).
  • If school year division is Terms based on the maxterm, reports the appropriate Term number (01, 02, etc.).
    • If section spans more than one term, reports as Multi Term (31).

Numeric, 2 digits

Calendar.term

Scheduling > Courses > Section > Section Schedule Placement