Vocational Monthly and Annual FTEADM Summary
Introduction
This report includes average daily membership (ADM) values for students enrolled in vocational courses, including students in grade levels 7-12 and special education students who are assigned to 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 assigned to the appropriate reporting period via Start Page > School Setup > Reporting Segments.
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.
ADM Calculation
Average daily membership (ADM) is calculated using the following logic for this report:
((Student Days Membership x Class Duration) / Standard Day) / Report Period Days
- Student Days Membership = The number of days the student is enrolled in vocational class periods.
- 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 Membership, the report determines how many class periods of the vocational course the student was enrolled in during the report date range. For example, the course may be taught 1 period every day or 2 periods every other day, either way, the number of days for each period is totaled. The report then multiplies the class periods by the Class Duration, which is based on 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 membership minutes to membership days, the report divides by the Standard Day value entered for the student on the Tennessee Student Information page.
Finally, to obtain ADM, the report divides by the number of in-session school days during the reporting period.
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 period end date.
- The student must have exited the course section after the report period start date.
- The student must not be excluded from state reporting.
- The student must either be enrolled in grade level 7, 8, 9, 10, 11, or 12, or the student must have a special program enrollment during the reporting period 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.
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:
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:
|
Report 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.
|
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. |
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 left blank if the report is 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, FTEADM | The report calculates ADM for special education students who are enrolled in vocational classes. To be included in this count, students must meet the following criteria:
| [SpEnrollments]StudentID [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 FTEADM | The report calculates ADM for students in grade levels 5 and 6 who are enrolled in vocational courses. The student must be enrolled in a vocational course with a classification (department) of STEM or HUSV (for 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 |
11 | (2) Grades 7-8 FTEADM | The report calculates ADM for students in grade levels 7 and 8 who are enrolled in vocational courses. 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 |
12 | (3) Grade 9 FTEADM | The report calculates ADM for students in grade level 9 who are enrolled in vocational courses. The student must be enrolled in a vocational course with a classification (department) code for the appropriate year. See Appendix for year-specific values. 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 |
13 | (4) Grades 10-12 FTE ADM | The report calculates ADM for students in grade levels 10, 11, and 12 who are enrolled in vocational courses. The student must be enrolled in a vocational course with a classification (department) code for the appropriate year. See the Appendix for year-specific values. 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 |
14 | (5) Gross District FTEADM Sum of Column (1) through Column (4) | The sum of columns 1 through 4. | N/A |
15 | (6) +/- Other FTEADM | The report calculates the average daily membership for students who meet one of the two following criteria:
The report adds the value for students taking vocational classes offered by the district and subtracts the value for students taking vocational classes offered by another district. | [Students]DistrictOfResidence [Sections]WhereTaughtDistrict |
16 | (7) Net District FTEADM Column (5) plus or minus Column (6) | The sum of column 5 and column 6. | N/A |