Vocational Monthly and Annual FTEADA Summary

Introduction

This report includes average daily attendance (ADA) values for students enrolled in vocational courses, including students in grade levels 7-12 and special education students who are assigned special education options 7, 8, or 9.

In-session school days must have the "In Sess" checkbox selected via Start Page > School Setup > Calendar Setup. Courses must be set up with the Vocational checkbox selected and a vocational value entered in the Department field via Start Page > School Setup > Courses > Edit Course District Information.

If the report is run for a monthly reporting period, then reporting segments must be set up via Start Page > School Setup > Reporting Segment. Nine reporting segments must be set up, with each assigned a valid Tennessee reporting period.

To track special education students, special programs must be set up via Start Page > District Setup > Special Programs with the names Option 07, Option 08, and/or Option 09 and marked as a special education program. Special education students must be enrolled in one of these programs during the report date range.

ADA Calculation

Average daily attendance is calculated using the following logic for this report:
((Student Days Present x Class Duration) / Standard Day) / Report Period Days

Student Days Present = The number of days the student is present in vocational class periods, based on attendance
Class Duration = The number of minutes the period is taught, based on the bell schedule.
Standard Day = The number of minutes the student normally attends school per day
Report Period Days = The number of days in the reporting period.

To obtain Student Days Present, the report determines how many class periods of the vocational course the student attended during the report date range. For example, the student may attend 1 period every day or 2 periods every other day, either way, the number of present days for each period is totaled. The report then multiples the class periods by the Class Duration, which is determined by the period length in the bell schedule. If the student has multiple class periods of different lengths for the same course, then each period is multiplied by the appropriate minute length and then summed.

To convert the student's minutes present to days present, the report divides by the Standard Day, as entered on the Tennessee Student Information page.

Finally, to obtain ADA, the report divides the student's days present by the number of in session school days during the reporting period.

Note: See article 6182 on PowerSource for assistance with troubleshooting attendance totals.

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.

Course Enrollment Selection

The report selects records from the [CC] table based on the following criteria:

The course must be assigned to a school included in the report and the school must not be excluded from state reporting.
The course must be marked as Vocational.
The course must have a Department equal to A12, FCS, FCSO, HS, TI, TEE, BT, ME, CA, or VOCM (2012-13 and prior).
The course must have a Department equal to AG, CONS, ARTS, BUS, EDU, FIN, GOV, HS, HOSP, HUSV, IT, LAW, MANU, MKTG, TRAN, STEM, WBL, CA or CTE (2013-Present).
The student must have enrolled in the course section on or before the report end date.
The student must have exited the course section on or after the report start date.
The student must not be excluded from state reporting.
The student must be either enrolled in grade level 7, 8, 9, 10, 11, or 12, or the student must have a special program enrollment with the name Option 07, Option 08, or Option 09.

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.

Back to Top

Report Input

For help with navigation and report generation, see How to Find and Generate a Report.

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Note: The All Schools option is only available when running the report from the District Office.
Select Students	Choose one of the following from the pop-up menu: The Selected X Students Only – Includes only students who are in the current student selection. All Students – Includes all student records on the PowerSchool server that meet the selection criteria for either the current school or all schools.
Reporting Period	Choose the appropriate reporting period from the pop-up menu. The dates for each reporting period are based on the reporting segments set up for each school. Annual First Second Third Fourth Fifth Sixth Seventh Eighth Ninth
Prepared By	Enter a name to print in the “Prepared by” section of the report.
Phone Number	Enter a phone number to print in the “Phone Number” section of the report.
Date Prepared	Enter a date to print in the “Date” section of the report.

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	Month of School	The reporting period chosen at report runtime, i.e. 1, 2, 3, 4, 5, 6, 7, 8, or 9. Note: This field is blank if there report is run for run for the annual report period.	N/A
2	District Name	The district name.	[Prefs]Value [Prefs]Name=districtname
3	District Number	The district number.	[Prefs]Value [Prefs]Name=districtnumber
4	Prepared By	The name entered at report runtime.	N/A
5	Phone Number	The phone number entered at report runtime.	N/A
6	School Name	The name of the school. If the report is run for the district, then this field is left blank.	[Schools]Name
7	School Number	The school number. If the report is run for the district, then this field is left blank.	[Schools]School_Number
8	Date	The date entered at report runtime.	N/A
9	(1) Grade ‘N’ Special Ed. Option 7, 8, 9, FTEADA	The report calculates ADA for special education students who are enrolled in vocational classes. To be included in this count, students must meet the following criteria: The student must be enrolled in a special program where the “Vocational Outside IEP Course Number” field equals a vocational course for the current year. The name of the special program must be Option 07, Option 08, or Option 09. The student must be enrolled in a vocational course with a classification (department) valid for the current year. The student’s district of residence must be the current district.	[SpEnrollments]StudentID [Students]DistrictofResidence [S_TN_SEN_X]VocOutsideIEP= A12, FCS, FCSO, HS, TI, TEE, BT, ME, CA, or VOCM [Gen]Cat=specprog [Gen]Name=Option 07, Option 08, or Option 09
10	(2) Grades 5-6 FTEADA	The report calculates ADA for students in grade levels 5 and 6 who are enrolled in vocational courses and who are not enrolled in a special education program. The student must be enrolled in a vocational course with a classification (department) of STEM or HUSV (2013-14 and later). The student’s district of residence must be the current district.	[Students]Grade_Level=7 or 8 [Students]DistrictofResidence [Students]State_ExcludeFromReporting [Courses]Sched_Department [Courses]Vocational
10	(2) Grades 7-8 FTEADA	The report calculates ADA for students in grade levels 7 and 8 who are enrolled in vocational courses and who are not enrolled in a special education program. 2012-13 and prior - The student must be enrolled in a vocational course with a classification (department) of FCS or TEE. 2013-14 and later - The student must be enrolled in a vocational course with a classification (department) of STEM, HUSV or AG. The student’s district of residence must be the current district.	[Students]Grade_Level=7 or 8 [Students]DistrictofResidence [Students]State_ExcludeFromReporting [Courses]Sched_Department [Courses]Vocational
11	(3) Grade 9 FTEADA	The report calculates ADA for students in grade level 9 who are enrolled in vocational courses and who are not enrolled in a special education program. The student must be enrolled in a vocational course with a classification (department) for the year being reported. The student’s district of residence must be the current district.	[Students]Grade_Level=9 [Students]DistrictofResidence [Students]State_ExcludeFromReporting [Courses]Sched_Department [Courses]Vocational
12	(4) Grades 10-12 FTE ADA	The report calculates ADA for students in grade levels 10, 11, and 12 who are enrolled in vocational courses and who are not enrolled in a special education program. The student must be enrolled in a vocational course with a classification (department) for the year being reported. The student’s district of residence must be the current district.	[Students]Grade_Level=10, 11, 12 [Students]DistrictofResidence [Students]State_ExcludeFromReporting [Courses]Sched_Department [Courses]Vocational
13	(5) Gross District FTEADA Sum of Column (1) through Column (4)	The sum of columns 1 through 4.	N/A
14	(6) +/- Other FTEADA	The report calculates ADA for students who meet one of the two following criteria: Vocational students who reside outside the district, i.e. the student is enrolled in a course that meets the selection criteria, but the student’s district of residence is different than the current district. Students taking vocational classes outside the district, but who reside in the district, i.e. students whose District of Residence is the same as the current district, but who are enrolled in a section with a different district number entered in the “District Where Taught” field.	[Students]DistrictOfResidence [Sections]WhereTaughtDistrict
15	(7) Net District FTEADA Column (5) plus or minus Column (6)	The sum of column 5 and column 6.	N/A

Back to Top