Docstoc

FTE Report

Document Sample
FTE Report Powered By Docstoc
					                                                                actual data at end of each day; page 1

                                                                                 State
                                                                                Support
                                      State Support Categories                   FTEs                       Quarterly Totals            09-10 Annual Totals
                                                                                                            Total
                                                                                                         Headcount Total FTEs                             Total FTEs
                                                                                                              All   all funding                           all funding
                                                                                                         Enrollment  sources                               sources
                                                                                                           s (Non-     (Fund                                 (Fund
                                                                                SUM of                      state   Source 1-5                            Source 1-5
                        100-200     300-400                  100-200 300-400   Technical, Academy &       support    includes      AFTE                    includes
 DAY                    Level       Level        Adult Basic Level    Level     ABE, & Running           and state- non-report-    (State       State     non-report-
of Reg       Date       Technical   Technical        Ed      Gen Ed Gen Ed      Gen ED Start FTE          support)  able FTEs)    Support)   Allocation   able FTEs)
DSS       02/08/10          38.15         0.00        0.33 25.40                   63.88        37.60           64      444.32     1603.44        2947      1962.00
  1       02/09/10         488.40         0.00        1.33 207.54                 697.27        68.27          805      770.28     2838.04        2947      2070.65
  2       02/10/10         615.90         0.00        3.00 267.32                 886.22        94.40         1037      982.98     2901.60        2947      2141.55
  3       02/11/10         709.94         0.00        6.74 342.54                1059.22       123.47         1268     1184.48     2959.27        2947      2208.72
  4       02/12/10         757.62         0.66        8.73 379.51                1146.52       134.73         1384     1282.88     2988.37        2947      2241.52
  5       02/13/10         757.62         0.66        8.73 379.51                1146.52       134.73         1384     1282.88     2988.37        2947      2241.52
  6       02/14/10         757.62         0.66        8.73 379.51                1146.52       134.73         1384     1282.88     2988.37        2947      2241.52
  7       02/15/10         757.62         0.66        8.73 379.51                1146.52       134.73         1384     1282.88     2988.37        2947      2241.52
  8       02/16/10         807.66         0.66       11.08 429.47                1248.87       161.40         1549     1411.19     3022.19        2947      2284.29
  9       02/17/10         851.50         0.66       13.06 459.12                1324.34       181.03         1652     1504.29     3048.64        2947      2315.32
 10       02/18/10         879.38         0.66       13.06 486.32                1379.42       198.97         1744     1578.98     3067.06        2947      2340.22
 11       02/19/10         931.23         7.67       15.06 530.24                1484.20       234.10         1909     1718.54     3102.08        2947      2386.74
 12       02/20/10         931.23         7.67       15.06 530.24                1484.20       234.10         1909     1718.54     3102.08        2947      2386.74
 13       02/21/10         931.23         7.67       15.06 530.24                1484.20       234.10         1909     1718.54     3102.08        2947      2386.74
 14       02/22/10         931.23         7.67       15.06 530.24                1484.20       234.10         1909     1718.54     3102.08        2947      2386.74
 15       02/23/10
 16       02/24/10
 17       02/25/10
 18       02/26/10
 19       02/27/10


      Reflects actuals at the end of business on the designated day.
                                                               actual data at end of each day; page 2


20       02/28/10
21       03/01/10
22       03/02/10
23       03/03/10
24       03/04/10
25       03/05/10
26       03/06/10
27       03/07/10
28       03/08/10
29       03/09/10
30       03/10/10
31       03/11/10
32       03/12/10
33       03/13/10
34       03/14/10
35       03/15/10
36       03/16/10
37       03/17/10
38       03/18/10
39       03/19/10
40       03/20/10
41       03/21/10
42       03/22/10
43       03/23/10
44       03/24/10
45       03/25/10
46       03/26/10
47       03/27/10


     Reflects actuals at the end of business on the designated day.
                                                               actual data at end of each day; page 3


48       03/28/10
49       03/29/10
50       03/30/10
51       03/31/10
52       04/01/10
53       04/02/10
54       04/03/10
55       04/04/10
56       04/05/10
57       04/06/10
58       04/07/10
59       04/08/10
60       04/09/10
61       04/10/10
62       04/11/10
63       04/12/10
64       04/13/10
65       04/14/10
66       04/15/10
67       04/16/10
68       04/17/10
69       04/18/10
70       04/19/10
71       04/20/10
72       04/21/10
73       04/22/10
74       04/23/10
75       04/24/10


     Reflects actuals at the end of business on the designated day.
                                                                actual data at end of each day; page 4


 76       04/25/10
 77       04/26/10
 78       04/27/10
 79       04/28/10
 80       04/29/10
 81       04/30/10
 82       05/01/10
 83       05/02/10
 84       05/03/10
 85       05/04/10
 86       05/05/10
 87       05/06/10
 88       05/07/10
 89       05/08/10
 90       05/09/10
 91       05/10/10
 92       05/11/10
 93       05/12/10
 94       05/13/10
 95       05/14/10
 96       05/15/10
 97       05/16/10
 98       05/17/10
 99       05/18/10
100       05/19/10
101       05/20/10
102       05/21/10
103       05/22/10


      Reflects actuals at the end of business on the designated day.
                                                                actual data at end of each day; page 5


104       05/23/10
105       05/24/10
106       05/25/10
107       05/26/10
108       05/27/10
109       05/28/10
110       05/29/10
111       05/30/10
112       05/31/10
113       06/01/10
114       06/02/10
115       06/03/10
116       06/04/10
117       06/05/10
118       06/06/10
119       06/07/10
120       06/08/10
121       06/09/10
122       06/10/10
123       06/11/10
124       06/12/10
125       06/13/10
126       06/14/10
127       06/15/10
128       06/16/10
129       06/17/10
130       06/18/10
131       06/19/10
132       06/20/10


      Reflects actuals at the end of business on the designated day.
                                                            actual data at end of each day; page 6


133  06/21/10
134  06/22/10
135  06/23/10
136  06/24/10
137  06/25/10
138  06/26/10
139  06/27/10
140  06/28/10
141  06/29/10
142  06/30/10
143  07/01/10
162 End of Qtr
163 MIS FINALS




  Reflects actuals at the end of business on the designated day.
                                                           actual data at end of each day; page 7




                                       Comments
      DSS Registration
      Continuing Student/WRT Registration


      New Student Registration
      Open Student Registration




      Data for 02-19-10 is missing, replaced with following day data.




Reflects actuals at the end of business on the designated day.
                                                          actual data at end of each day; page 8




      EASL registration
      EASL registration




Reflects actuals at the end of business on the designated day.
                                                          actual data at end of each day; page 9




      Spring quarter starts




      1st week of quarter




Reflects actuals at the end of business on the designated day.
                                                         actual data at end of each day; page 10




      2nd week of quarter




Reflects actuals at the end of business on the designated day.
                                                         actual data at end of each day; page 11




Reflects actuals at the end of business on the designated day.
                                                         actual data at end of each day; page 12




Reflects actuals at the end of business on the designated day.
                         Spring 10 Spring 09
Continuing students         697.27    307.74
New admits                 1059.22    517.80
                                                                                         QFTE Comparison
1st day open reg.          1146.52    601.06       3000.00
5 weeks before quarter               1063.85
3 weeks before quarter               1465.65
                                                   2500.00
2 weeks before quarter               1772.49
13 days before quarter               1870.23
12 days before quarter               1870.23       2000.00
11 days before quarter               1997.60
10 days before quarter               1997.60       1500.00
9 days before quarter                1997.60
8 days before quarter                2050.73       1000.00
1 week before quarter                2095.50
6 days before quarter                2172.10
                                                    500.00
5 days before quarter                2172.10
4 days before quarter                2380.57
3 days before quarter                2380.57          0.00


                                                                            Continuing…




                                                                         5 days before…

                                                                         3 days before…




                                                                          2nd week of…
                                                                       12 days before…

                                                                       10 days before…
                                                                         9 days before…
                                                                         8 days before…
                                                                        1 week before …
                                                                         6 days before…

                                                                         4 days before…

                                                                         2 days before…
                                                                       3 weeks before…
                                                                       2 weeks before…
                                                                       13 days before…

                                                                       11 days before…
                                                                       5 weeks before…




                                                                          1 day before…
                                     2380.57




                                                                  8th week of quarter
                                                                  5th week of quarter
                                                                    3rd day of quarter
                                                                   2nd day of quarter




                                                                        End of quarter
                                                                  1st week of quarter
                                                                           New admits




                                                                    8th day of quarter
                                                                     1st day open reg.




                                                                    4th day of quarter

                                                                    6th day of quarter
                                                                    7th day of quarter

                                                                    9th day of quarter
                                                                    1st day of quarter




                                                                  3rd week of quarter
2 days before quarter
1 day before quarter                 2432.21
1st day of quarter                   2516.82
2nd day of quarter                   2543.36
                                                      Spring 10
3rd day of quarter                   2564.57
4th day of quarter                   2580.71          Spring 09


1st week of quarter                  2580.74
6th day of quarter                   2580.74
7th day of quarter                   2598.58
8th day of quarter                   2603.02
                                                                                                       2009-2010
9th day of quarter                   2591.96                                                         AFTE Production
2nd week of quarter                  2478.79
3rd week of quarter                  2513.86                                                State Allocation
5th week of quarter                  2609.42                                                      2975             Current AFTE
8th week of quarter                  2605.78                                                                         3102.08
                                                                              4000.00
End of quarter                       2626.87                                                                                      Spring

                                                                              3000.00                            494.73
                                                                                             837.76                               Winter
                   09-10 AFTE Production                                                                        1025.19           Fall
State Allocation           2975      Trend*    Actual     % Target             2000.00       864.54
                                                                                                                                  Summer
Summer                     12.68% 377.23           514.64 136.43%                                               1067.51
                                                                               1000.00       895.475
Fall                       30.10% 895.475        1067.51 119.21%
                                                                                              377.23             514.64
Winter                     29.06% 864.54         1025.19 118.58%                  0.00
Spring                     28.16% 837.76           494.73 59.05%
                                                                                            Trend*              Actual
                              Total     2975     3102.08 104.27%
                                    Excess        127.08
*Trend is based on historical average percentage of AFTE production by quarter

         8f93b8c4-6a2f-4fa0-acb2-b17f9ba5f79c.xls 3/11/2010
                                                               State
                                                              Support
                   State Support Categories                    FTEs                  Quarterly Totals          09-10 Annual Totals
                                                                                     Total    Total FTEs                     *Total FTEs
                                                                                   Headcount all funding                      all funding
                                                                                      All      sources                         sources
                                                                                  Enrollments    (Fund                           (Fund
                                                            SUM of Academy         (Non-state Source 1-5                     Source 1-5
               100-200   300-400           100-200 300-400 Technical, &           support and  includes   AFTE                 includes
                Level     Level    Adult    Level Level Gen ABE, & Running           state-   non-report- (State     State   non-report-
    Date      Technical Technical Basic Ed Gen Ed    Ed     Gen ED Start FTE        support)  able FTEs) Support) Allocation able FTEs)
  3/10/2010     931.23     7.67      15.06 530.24              1484.20   234.10         1909     1718.54   3102.08       2947    2386.74 *Before Spring 08
  2/24/2009     613.87                3.99 242.04      0.00     859.90   200.40         1165     1076.59   1627.94       2944    1913.54 Total FTE included only
                     6 weeks before quarter       % Change     72.60%                                                                    Funding Source 1-3




8f93b8c4-6a2f-4fa0-acb2-b17f9ba5f79c.xls 3/11/2010
       Spring 2010 Department/Division Report as of :                             March 11, 2010
                                                      Dept/
                                                       Div  All State                      All       State
YRQ DEPT DIV                    Title                  CAP ENR ENR OPEN          FILL     FTE     Support FTE
A904   ABED     Adult Basic Education                  350    41    41   309    11.71%     13.6          13.6
A904   ACCT     Accounting                             336    77    70   259    22.92%     22.5          20.7
A904   ACRT     Auto Collision Repair                  480    76    68   404    15.83%     20.0          18.4
A904   ADHS     Adult High School                      305    86    57   219    28.20%     21.1          17.2
A904   APDZ     Baccalaureate Upper Division            90    23    23    67    25.56%      7.7           7.7
A904   ARCH     Architectural Graphics                 334    71    67   263    21.26%     16.0          15.1
A904   ARST     Auto Restoration                       144     0     0   144     0.00%      0.0           0.0
A904   ART      Art                                    114    11     4   103     9.65%      3.6           1.3
A904   ASL&     American Sign Language                  40     9     9    31    22.50%      3.0           3.0
A904 AUTO       Auto Collision                         224   159   141    65    70.98%     81.2          72.6
A904 BAKE       Baking                                  90   27    21     63    30.00%      8.0           6.2
A904   BIOL     Biology                                 50    36    31    14    72.00%     12.0          10.3
A904   BIOL&    Biology (Common Courses)               336   241   227    95    71.73%     88.2          83.2
A904   BPMT     Building & Plant Maintance              48    22    22    26    45.83%     11.7          11.7
A904   BUHR     Human Resources                        105    16    12    89    15.24%      1.5           1.0
A904   BUS&     Business (Common Courses)               50     8     5    42    16.00%      2.7           1.7
A904 BUSA       Business Applications Support          214   19    19    195     8.88%      6.3           6.3
A904 CEGT       Civil Engineering Graphics             312   22    22    290     7.05%      5.9           5.9
A904 CFOR       Information Assurance & Computer        60   53    44      7    88.33%     32.2          26.4
                Forensics
A904 CHEM&      Chemistry (Common Courses)              96   59    56     37    61.46%     19.6          18.7
A904 CISA       Computer Applications                  458   175   160    283   38.21%     47.8          43.7
A904 CIVE       Engineering Graphics                  1240   227   184   1013   18.31%     54.9          44.2
A904 CJ&                                                30    22    16      8   73.33%      7.3           5.3
                Criminal Justice (Common Courses)
A904 CMES       Esthetician                            100    10     2    90    10.00%      2.8           0.9
A904 CMST&      Communications (Common                 278   139   118   139    50.00%     46.3          39.3
                Courses)
A904 COSM       Cosmetology                            200    2     2    198     1.00%      1.5           1.5
A904 CSNT       Computer Security & Network            240   99    82    141    41.25%     51.2          43.0
                Technician
A904   CULA     Culinary Arts                          528   125    97   403     23.67%    47.7          36.7
A904   CWEX     Cooperative Work Experience            396    19    18   377      4.80%     3.7           3.3
A904   DENT     Dental Assistant                       300   218   208    82     72.67%    50.3          47.9
A904   DHET     Diesel and Heavy Equipment             122   122   117     0    100.00%    24.7          23.7
A904 DHYG       Dental Hygiene                         298    0     0    298     0.00%      0.0           0.0
A904 EASL       English as a Second Language          1379    5     5    1374    0.36%      2.0           2.0
A904 ECEM       Child Care Manager                     205   12     8    193     5.85%      3.2           2.1
A904 ECON&      Economics (Common Courses)              25    9     8     16    36.00%      3.0           2.7
A904   EDUC     Education, Professional Technical       75     0     0    75     0.00%      0.0           0.0
A904   ELEC     Electronics                            733   119   119   614    16.23%     36.9          36.9
A904   EMTB     Emergency Medical Technician            30     4     4    26    13.33%      2.7           2.7
A904   ENGL     English                                575   148   120   427    25.74%     47.3          38.0
A904   ENGL&    English (Common Courses)               300   158   125   142    52.67%     52.6          41.6
A904   ETEC     Energy & Science Technician            144    18    15   126    12.50%      5.0           4.2
A904   FSE      Funeral Service                        123    52    52    71    42.28%     11.2          11.2
A904   FTNS     Fitness Specialist/Personal Trainer    523    98    76   425    18.74%     23.9          20.8
A904   HMDS     College Strategies                     272    28    24   244    10.29%      3.7           3.2


        8f93b8c4-6a2f-4fa0-acb2-b17f9ba5f79c.xls 3/11/2010
                                                    Dept/
                                                     Div  All State                        All       State
 YRQ DEPT DIV                  Title                 CAP ENR ENR OPEN            FILL     FTE     Support FTE
A904 HORT     Environmental Horticulture             272     144    124   128    52.94%    32.7          28.1
A904 IFAD     7-hr HIV AIDS Training                  56      32     31    24    57.14%     1.4           1.3
A904 INTL     International Students                  72       2      2    70     2.78%     0.8           0.8
A904 ITAD     Information Technology Applications    180      40     33   140    22.22%    13.3          11.0
A904 LEGL     Legal Support Professional              48       7      7    41    14.58%     1.8           1.8
A904 MACH     Machine Technology                      49      47     43     2    95.92%    22.9          20.7
A904 MAST     Massage Therapy                        120      27     24    93    22.50%     9.4           8.6
A904 MATH     Mathematics                           1066     498    429   568    46.72%   165.4         142.5
A904 MATH& Mathematics (Common Courses)              336      89     77   247    26.49%    29.7          25.6
A904 MEDA     Medical Assisting                      446     278    267   168    62.33%    82.1          78.9
A904 METR     Medical Transcription                  100       7      7    93     7.00%     2.3           2.3
A904 MHIT     Healthcare Fundamentals                 30       0      0    30     0.00%     0.0           0.0
A904 MMDP     Multimedia Design & Production        1305     446    354   859    34.18%   124.0          99.2
A904 MMPE     Motorcycle, Marine & Power             210     139    127    71    66.19%    35.0          32.0
              Equipment Technology
A904 MOHD     Motorcycle, Harley Davidson             90       9      9     81   10.00%     3.0           3.0
A904 Multiple Continuing Education (Non-Credit      1117      26     14   1091    2.33%     0.0           0.0
     Codes    Courses)
A904 NURS     Nursing                                964     194    191   770    20.12%    47.1          46.4
A904 NUTR& Nutrition                                 108      56     53    52    51.85%    18.6          17.7
A904 OFTC     Office Assistant                       294      49     47   245    16.67%    11.7          11.1
A904 OTA      Occupational Therapy Assistant         120      65     65    55    54.17%    13.8          13.8
A904 PAED     Parent Education                       960       0      0   960     0.00%     0.0           0.0
A904   PHIL&    Philosophy (Common Courses)            25       3      3    22   12.00%    1.0            1.0
A904   PHYS&    Physics (Common Courses)               25      15     15    10   60.00%    5.0            5.0
A904   PSYC     Psychology                            120      23     20    97   19.17%    7.7            6.7
A904   PSYC&    Psychology (Common Courses)           354     181    153   173   51.13%   60.3           50.9
A904   PTA      Physical Therapist Assistant          120       0      0   120    0.00%    0.0            0.0
A904   SHSV     Social & Human Services               222     116     87   106   52.25%   33.8           24.9
A904   SOC&     Sociology (Common Courses)            129      38     33    91   29.46%   12.6           11.0
A904   SPAN&    Spanish (Common Courses)               98      15     12    83   15.31%    4.9            4.0
A904   TRAN     Transportation Core & Maintenance
                Welding Fabrication                   100      86     56    14   86.00%   22.8           15.0
A904   WELD     Technology                            252     210    157    42   83.33%   59.1           42.4
A904   WINE     Wine Technology                        96      19     19    77   19.79%    3.4            3.4
                                                    21836    5726   4958 16110   26.22% 1732.1          1505




        8f93b8c4-6a2f-4fa0-acb2-b17f9ba5f79c.xls 3/11/2010
Tab 1 FTE Report
                                                           State
                                                          Support
             State Support Categories                      FTEs                 Quarterly Totals           09-10 Annual Totals
                                                                                Total
                                                                             Headcount    Total FTEs                         Total FTEs
                                                                                  All     all funding                        all funding
                                                                             Enrollment    sources                            sources
                                                                               s (Non-       (Fund                              (Fund
                                                           SUM of               state     Source 1-5                         Source 1-5
Technical Actual                 Internation              Technical, Academy  support      includes   AFTE                    includes
(Prep + Supp       Adult Basic     al (INTL    Gen Ed      ABE, & & Running and state-    non-report- (State     State       non-report-
+ Coop)                Ed         Courses)     Actual      Gen ED Start FTE   support)    able FTEs) Support) Allocation     able FTEs)
Daily report of FTE
State Support Categories (10th Day Enrollment)
Technical Actual - All Technical FTE
Adult Basic Ed - ABE/EASL FTE
International - Intensive English FTE
Gen Ed Actual - Academic Core FTE
Each of the above added together equal our State Support FTE total
Academy and Running Start FTE - Combined FTE, not included in State Support total

Quarterly Totals
Total Headcount - Number of students enrolled in both state support and non-state support, includes Academy
Total FTE - FTE in both state support and non-state support classes, includes Academy

07-08 Annual Totals
AFTE (State Support) - State support FTE for current and past quarters for the academic year divided by three, does not include Academy
State Allocation - FTE budgeted to LWTC by the State
Total FTE - FTE in both state support and non-state support classes for current and past quarters for the academic year divided by three

Tab 2 Comparison
Quarterly FTE comparison by benchmark dates with corresponding graph.
Table at the bottom is a running total of Annualized FTE for all quarters compared against quarterly and annual target/allocation

Tab 3 FTE Dashboard
Similar to tab one but includes a comparison against same day of the quarter for the previous year

Tab 4 DEPT-DIV
                                                                                                                   State
                                               Dept/Div                                                           Support
        YRQ           DEPT DIV      Title        CAP    All ENR State ENR     OPEN        FILL    All FTE           FTE
Enrollment capacity and Enrollment by program (DEPT-DIV code)
YRQ - Current year quarter code.
DEPT DIV - Department Division Code
Title - Program title associated with the DEPT DIV code
Dept/Div CAP - Combined capacities for all courses in DEPT DIV (from SMS)
All ENR - Total headcount, includes Academy
State ENR - 10th day headcount/headcount that counts towards state support, does not include Academy
OPEN - Number of open spots within DEPT DIV (CAP minus All Enr)
FILL - percentage of fill within DEPT DIV (All ENR divided by CAP)
All FTE - Quarterly FTE for all courses within DEPT DIV, includes Academy
State Support FTE - Quarterly FTE for all courses within DEPT DIV, does not include Academy

				
DOCUMENT INFO