School-Sponsored Community Activities (Wisconsin)

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

  1. Select the School-Sponsored Community 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.

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