Extra Co-Curricular Activities (Wisconsin)

Tool Search: School Performance Report

The SPR Extra Co-Curricular Activities Extract reports school-sanctioned activities intended to broaden, develop an enhance a student's school experience in the areas of academics, athletics and music. These courses are under the guidance and supervision of school staff and are designed to provide students such experiences as motivation, enjoyment and improvement of skills.

These activities are reported at the school level only; no student categories are involved in this collection. All district files need to be submitted to DPI by June 30 and can be submitted throughout the year.


Screenshot of the Extra Co-Curricular Extract editor..Extra Co-Curricular Extract


Report Logic

Course Setup

The report lists courses that have a value in the Extra Co-Curricular Activity field, located on the Course editor. The following options are available for selection:

  • AC - Academic
  • AT - Athletic
  • MS - Music

The Course must be an active course. 

Grade Levels

  • The most recent enrollment by start date is used to determine and report the student's grade level. Students must be enrolled in a state grade level of 06-12.
  • Students are only counted one time for each activity type.

Excluded Students

Students are not included in this report when:

  • Their enrollment record is marked as No Show or is marked as State Exclude.
  • They are enrolled in a grade level marked as State Exclude.
  • They are enrolled in a calendar marked as State Exclude.

Report Editor

The following table defines the available options on the report editor.

Data Element

Description

Extract Type

Indicates which SPR Extract is being generated. For this instance, choose the Extra Co-Curricular Activities option.

Format

Determines how the report is generated. Options are:

  • HTML
  • State Format (CSV)
  • Student Detail (CSV)
  • Course Detail (CSV)

Calendar

Indicates which school and year is being reported. Calendars can be selected by active year, school name or by year.

Student Selection

Select students to include on the report by choosing either a Grade level of enrollment for the students or an Ad hoc Filter.

  • To include students in all grade levels, choose All Students in the Grade Level options.
  • Selecting an existing ad hoc filter reports only those students or courses included in those filters, if they meet the reporting requirements of the report.
Report Generation

Use the Generate Extract option to immediately produce the report.

Or, use the Submit to Batch option to choose when the report should generate. This option is helpful when the amount of data being returned is large and could tax the server. Choosing a time after normal school hours may be best. See the Batch Queue article for more information.


Generate the Report

  1. Select the Extra Co-Curricular Activities option from the Extract Type dropdown list.
  2. Select the Format in which to generate the report.
  3. Select the Calendars to include in the report.
  4. Select the students to include in the report by choosing either a Grade level or an Ad hoc Filter.
  5. Click the Generate Extract button to display the report immediately, or use the Submit to Batch button to determine when the report should generate. The report displays in the selected format.

Sample images of each format type are included in the Report Layout sections. 

HTML and State Format Report Layout

The HTML and State Formats meet the reporting needs as defined by DPI. The State Format is the only format that should be submitted to the state, and does not include any column headers.

 Screenshot of the Extra Co-Curricular Extract in State Format (CSV).State Format (CSV) 

Screenshot of the Extra Co-Curricular Extract in HTML format.HTML Format

Data ElementDescriptionType, Format and LengthCampus DatabaseCampus Interface
School NumberReports the number of the school associated with the student's most recent enrollment.Numeric, 4 digitsSchool.numberSchool Information > School Number
Category

Represents the assigned Course category. Options are:

  • AC (Academic)
  • AT (Athletic)
  • MS (Music)
Alphanumeric, 2 charactersCourse.activity Code Course > Extra-Curricular Activity
OfferedA count of the number of each instance of the activity type offered (by course) for the reporting period based on the assigned Extra-Curricular Activity on the Course editor.Numeric, 3 digitsCalculated field, value not storedCalculated field, value not stored
ParticipationA count of all students who are enrolled in courses of the specified activity type based on the assigned Extra-Curricular Activity assigned to the course and the student's enrollment into that course.Numeric, 3 digitsCalculated field, value not storedCalculated field, value not stored

Detail Student Format Report Layout

This student detail format is for data analysis and troubleshooting; it is NOT submitted to the state. Reported students are those who are counted in the Participation column of the State and HTML and Formats described above. Data is sorted in the following order:

  1. Last Name
  2. First Name
  3. School Code
  4. Category

Screenshot of the Extra Co-Curricular Extract in Student Detail Format (CSV).Student Detail Format (CSV)  

Data ElementDescriptionType, Format and LengthCampus DatabaseCampus Interface
School Code

Reports the number of the school associated with the student's most recent enrollment.

If the School Override field is populated on the student's enrollment record, that number populates on the report.

Numeric, 4 digitsSchool.numberSchool Information > School Number
School Name

Displays the name of the school.

If the School Override number does not correspond to a number in the district, a blank value reports for the school name.

Alphanumeric, 40 charactersSchool.nameSchool Information > Name
WSNDisplays the assigned state ID for the student.Numeric, 10 digitsPerson.stateIDDemographics > Student State ID
PIDDisplays the Campus assigned person ID for the student.Numeric, 10 digitsIdentity.personIDDemographics > Person ID
Last NameReports the student's last name.Alphanumeric, 40 charactersIdentity.lastNameDemographics >  Last Name
First NameReports the student's first name.Alphanumeric, 35 charactersIdentity.firstNameDemographics >  First Name
Middle NameReports the student's middle name.Alphanumeric, 30 charactersIdentity.middleNameDemographics > Middle Name
GradeReports the student's most recent grade level of enrollment.Alphanumeric, 2 charactersEnrollment.gradeEnrollments > Grade
School OverrideReports the School Override Number, if populated. If it is not populated, a blank value reports.Numeric, 4 digitsEnrollment.school Override Enrollments > State Reporting Fields > School Override
Category

Reports the assigned Extra Co-Curricular activity assigned to the course into which the student is scheduled. Options are: 

  • AC (Academic)
  • AT (Athletic)
  • MS (Music)

Students report only one time per category.

Alphanumeric, 2 charactersCourse.activity CodeCourse > Extra-Curricular Activity


Detail Course Format Report Layout

This course detail format is for data analysis and troubleshooting; it is NOT submitted to the state. Courses are aggregated by school, then calendar name, and are included in the Offering column reported on the State Format.

Screenshot of the Extra Co-Curricular Extract in Course Detail Format (CSV).Course Detail Format (CSV)

Data Element

Description

Type, Format and Length

Campus Database

Campus Interface

School CodeReports the number of the school associated with the student's most recent enrollment.Numeric, 4 digitsSchool.numberSchool Information > School Number
School NameDisplays the name of the school.Alphanumeric, 40 charactersSchool.nameSchool Information > Name
Calendar NameDisplays the name of the calendar in which the course takes place.Alphanumeric, 30 charactersCalendar.nameCalendar > Name
Course NumberDisplays the number of the course.Alphanumeric, 13 charactersCourse.number Course > Number
Course NameDisplays the name of the course.Alphanumeric, 30 charactersCourse.nameCourse > Name
Category

Reports the Extra Co-Curricular Activity assigned to the course. Options are:

  • AC (Academic)
  • AT (Athletic)
  • MS (Music)
Alphanumeric, 2 charactersCourses.activity CodeCourse > Extra Co-Curricular Activity