Classic View: WI State Reporting > School Performance Reports > School-Sponsored Community Activities

Search Term: School-Sponsored Activities

The School-Sponsored Community Activities extract reports students in grades 9 through 12 involved in school-sponsored and supervised activities that emphasize service to and involvement with the community. These activities are either voluntary (participation is not required and no grade/credit towards graduation is given) or required (participation is mandatory and a grade/credit towards graduation is given).

These activities are reported at the school level only; no student categories are involved in this collection. Information is collected over the entire school year and should be submitted to DPI by June 30.

School Performant Report

Report Logic

Students are counted one time for required activities and one time for voluntary activities; the number does not increase based on the number of activities in which the student participates.

The School-Sponsored Community Activities report uses the School-Sponsored Activity field on the Course Editor. Options are:

RE: Required Community Activity
VO: Voluntary Community Activity

Courses must be marked as active.

School-Sponsored Activity Field on Course Editor

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 School-Sponsored Community Activities option.
Format	Determines how the report is generated. Options are: State Format (CSV) (see Image 3) HTML (see Image 4) Student Detail (CSV) (see Image 5) Course Detail (CSV) (see Image 6)
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 Reports

Select the School-Sponsored Community Activities option from the Extract Type dropdown list.
Select the Format in which to generate the report.
Select the Calendars to include in the report.
Select the students to include in the report by choosing either a Grade level or an Ad hoc Filter.
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.

School-Sponsored Report - State Format (CSV)

School-Sponsored Report - HTML Format

Data Element	Description	Location
School Code	District-assigned school number for the calendar selected in the extract editor. If the School Override field is populated on the student's enrollment record, that school number displays on the report. Numeric, 4 digits	System Administration > Resources > School > Number School.number Student Information > General > Enrollments > State Reporting Fields > School Override
Category Type	Reports the assigned Activity Category on the Course editor. Values report as: RE (Required) VO (Voluntary) Alphanumeric, 2 characters	Scheduling > Courses > Course > Custom Data Elements > School-Sponsored Activity Course. communityActivity
Offerings	Total number of each instance of the activity type offered by course for the reporting period. At least one student must be scheduled into the course. If the only student in the course is also marked as Voluntary 30 Hour, the course is still counted as an offering for the Voluntary category. Each course is counted only once. Numeric, 3 digits	Calculated value, data not stored
Participants	Total number of all students who are enrolled in courses of the specified category. A student will count in the Voluntary Participant total even if they are not scheduled into a community activity courses IF the student has Voluntary 30 Hour selected on their enrollment record. If the student is marked as Voluntary 30 Hour and is also in a qualifying Voluntary course, the student is counted only once in the Voluntary Participant count. Numeric, 3 digits	Calculated value, data not stored

Student Detail Format Report Layout

The Detail CSV Format is provided to aid users in data analysis and troubleshooting. This format is not submitted to the state. The Student Detail Format provides detailed information for the students counted in the Participants column of the State Format.

Data sorts in the following order:

Last Name
First Name
School Code
Category

School-Sponsored Report, Student Detail - State Format (CSV)

Data Element	Description	Location
School Code	District-assigned school number for the calendar selected in the extract editor. If the School Override field is populated on the student's enrollment record, that school number displays on the report. Numeric, 4 digits	System Administration > Resources > School > Number Student Information > General > Enrollments > State Reporting Fields > School Override 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 characters	System Administration > Resources > School > Name School.name
WSN	Displays the assigned state ID for the student. Numeric, 10 digits	Census > People > Demographics > Person Identifiers > Student State ID Person.stateID
PID	Displays the Campus assigned person ID for the student. Numeric, 10 digits	Census > People > Demographics > Person Information > Person ID Identity.personID
Last Name	Reports the student's last name. Alphanumeric, 40 characters	Census > People > Demographics > Person Information > Last Name Identity.lastName
First Name	Reports the student's first name. Alphanumeric, 35 characters	Census > People > Demographics > Person Information > First Name Identity.firstName
Middle Name	Reports the student's middle name. Alphanumeric, 30 characters	Census > People > Demographics > Person Information > Middle Name Identity.middleName
Grade	Reports the student's most recent grade level of enrollment. Alphanumeric, 2 characters	Student Information > General > Enrollments > General Enrollment Information > Grade Enrollment.grade
30-Hour Vol	Displays a value of 1 if the 30 Hour Voluntary Grad Req checkbox is marked on the student's enrollment record. Numeric, 1 character	Student Information > General > Enrollments > State Reporting Fields > 30 Hour Voluntary Grad Reg Enrollment. voluntary30hr
School Override	Reports the School Override Number, if populated. If it is not populated, a blank value reports. Numeric, 4 digits	Student Information > General > Enrollments > State Reporting Fields > School Override Enrollment.school Override
Category	Represents the assigned activity category in which the student is enrolled. Values report as: RE (Required) VO (Voluntary) Alphanumeric, 2 characters	Scheduling > Courses > Course > Custom Data Elements > School-Sponsored Activity Course. communityActivity

Course Detail Format Report Layout

This Detail CSV Format is provided to aid users in data analysis and troubleshooting. This format is not submitted to the state. The Course Focus Detail report aggregates courses by school, then by calendar name, and provides the sum of participants for each course.

Courses which pull on this detail report must also qualify to be counted in the State Format Offering column.

Data sorts by the Course Number.

School-Sponsored Report, Course Detail - CSV Format

Data Element	Description	Location
School Code	District-assigned school number for the calendar selected in the extract editor. If the School Override field is populated on the student's enrollment record, that school number displays on the report. Numeric, 4 digits	System Administration > Resources > School > Number School.number Student Information > General > Enrollments > State Reporting Fields > School Override
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 characters	System Administration > Resources > School > Name School.name
Calendar Name	Reports the name of the calendar in which the course takes place. Alphanumeric, 30 characters	System Administration > Calendar > Calendar > Calendar > Name Calendar.name
Course Number	Reports the number of the course marked for the activity category. Alphanumeric, 13 characters	Scheduling > Courses > Course > Number Course.number
Course Name	Reports the name of the course marked for the activity category. Alphanumeric, 30 characters	Scheduling > Courses > Course > Name Course.name
Category	Represents the assigned activity category in which the student is enrolled. Values report as: RE (Required) VO (Voluntary) Alphanumeric, 2 characters	Scheduling > Courses > Course > Custom Data Elements > School-Sponsored Activity Course. communityActivity

School-Sponsored Community Activities (Wisconsin)