Special Education Report of 12th Graders
Introduction
This report includes totals for 12th grade special education students during the appropriate graduation period. Students are grouped by gender, ethnicity and diploma type. Students must be assigned a Document Type on the Tennessee State Information page via Start Page > Student > State/Province – TN.
Selection Criteria
Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.
Student Selection
The report selects records from the [Students] table based on the following criteria:
- The student must be enrolled in a school included in the report during the report date range.
- The student must have a valid gender (M or F).
- The student must be assigned a valid ethnicity (W, B, H, A, I, P).
- The student must have a grade level of 12 for the school enrollment that falls within the report date range.
- The student must be assigned a valid Document Type (diploma).
Note: If the EDPlan import is being used special education option status will be derived from the imported data. If the EDPlan import is not being used the report will use Student > Special Programs to derive special education options status.
Report Input
For help with navigation and report generation, see How to Find and Generate a Report.
Field | Description |
For Current School Only | Choose one of the following from the pop-up menu:
|
Use Current Selection | This field defaults to Don’t Use Current Selection, which includes all students in the current school or district who meet the selection criteria. Note: This report cannot be run for a selection of students. |
Processing Options | Choose a time to run the report from the pop-up menu:
|
Specific Date/Time | Enter a date using the format mm/dd/yyyy or mm-dd-yyyy in order to run the report on a specific day. The incorrect format displays an alert and the date field is submitted as a blank entry. Use the pop-up menus to schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05. |
Graduation Date | Enter the appropriate graduation date. Note: Students are included in the report based on their value for Completion Document Date entered on the Tennessee State Information page via Start Page > Student > State/Province – TN. |
Start Date of Graduation Period | Enter the first day of the graduation period. |
End Date of Graduation Period | Enter the last day of the graduation period. |
Report Output
Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.
Item # | Data Element | Description | [Table]FieldName |
|---|---|---|---|
1 | School Name | The name of the school. This field is blank if the report is run for the district. | [Schools]Name |
2 | District Name | The district name. | [Prefs]Value [Prefs]Name=districtname |
3 | District Number | The district number. | [Prefs]Value [Prefs]Name=districtnumber |
4 | School Number | The school number. This field is blank if the report is run for the district. | [Schools]School_Number |
5 | Address | The school street address. This field is blank if the report is run for the district. | [Schools]SchoolAddress |
6 | City & Zip Code | The school's city and zip code. These fields are blank if the report is run for the district. | [Schools]SchoolCity [Schools]SchoolZip |
7 | Phone Number | The school phone number. This field is blank if the report is run for the district. | [Schools]SchoolPhone |
8 | Graduation Date | The graduation date entered at report runtime. | N/A |
9 | Beginning Date | The first day of the graduation period, entered at report runtime. | N/A |
10 | Ending Date | The last day of the graduation period, entered at report runtime. | N/A |
11 | Regular Diploma | The number of students who received a regular diploma during the graduation period. Students must meet the selection criteria for the report and have a Document Type of "(1) Regular Diploma." | [S_TN_STU_X]Completion=1 [S_TN_STU_X]GraduationPeriod=1, 2, or 3 [Students]Grade_Level=12 [Students]Gender=M or F [Students]Ethnicity=W, B, H, A, I, or P |
12 | Honors Diploma | The number of students who received an honors diploma during the graduation period. Students must meet the selection criteria for the report and have a Document Type of "(2) Honors Diploma." | [S_TN_STU_X]Completion=2 [S_TN_STU_X]GraduationPeriod=1, 2, or 3 [Students]Grade_Level=12 [Students]Gender=M or F [Students]Ethnicity=W, B, H, A, I, or P |
13 | Special Education Diploma | The number of students who received a special education diploma during the graduation period. Students must meet the selection criteria for the report and have a Document Type of "(3) Special Education Diploma." | [S_TN_STU_X]Completion=3 [S_TN_STU_X]GraduationPeriod=1, 2, or 3 [Students]Grade_Level=12 [Students]Gender=M or F [Students]Ethnicity=W, B, H, A, I, or P |
14 | High School Certificate | The number of students who received a high school certificate during the graduation period. Students must meet the selection criteria for the report and have a Document Type of "(4) High School Certificate." | [S_TN_STU_X]Completion=4 [S_TN_STU_X]GraduationPeriod=1, 2, or 3 [Students]Grade_Level=12 [Students]Gender=M or F [Students]Ethnicity=W, B, H, A, I, or P |
15 | No Diploma, Senior But Did Not Complete | The number of students who received no diploma and did not complete graduation requirements during the graduation period. Students must meet the selection criteria for the report and have a Document Type of "(5) No Diploma, Senior But Did Not Complete." | [S_TN_STU_X]Completion=5 [S_TN_STU_X]GraduationPeriod=1, 2, or 3 [Students]Grade_Level=12 [Students]Gender=M or F [Students]Ethnicity=W, B, H, A, I, or P |