Report of 12th Graders

Introduction

This report includes totals for 12^th grade students during the appropriate graduation period. Students are grouped by gender, ethnicity and diploma type. Students must be assigned a Document Type and Graduation Period 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 have a Graduation Period of Spring, Summer, or Early.
The student must be assigned a valid Document Type (diploma).

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: Current School Only (Default) – Includes all student records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list. District Wide – Includes all student records on the PowerSchool server that meet the selection criteria.
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: In Background Now (Recommended) – Execute the report immediately in the background. ASAP – Execute the report in the order it is received in the Report Queue. At Night – Execute the report during the next evening. On Weekend – Execute the report during the next weekend. On Specific Time – Execute the report on the date and time specified.
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. Schedule the report to be run at a specific hour and minute. Example: 7/29/2008 @ 10 AM : 05.
School Year	Choose the appropriate school year. Note: The report can be run for any available academic year.
Graduation Period	Choose the appropriate graduation period. Spring Summer Early Note: Students are included in the report based on their value for Graduation Period entered on the Tennessee State Information page via Started 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.

Back to Top

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 Period	The graduation period selected at report runtime.	N/A
9	School Year	The school year selected at report runtime.	N/A
10	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 one of the following: (1) Regular Diploma (11) Regular Diploma with Foreign Language Waiver (12) Regular Diploma with Fine Arts Waiver (13) Regular Diploma with Foreign Language and Fine Arts Waiver.	[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
11	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
12	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
13	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
14	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
15	Occupational Diploma	The number of students who received an occupational diploma during the graduation period. Students must meet the selection criteria for the report and have a Document Type of “(7) Occupational Diploma.”

Back to Top