Attendance % Calculation, fluid slots

From the November 2014 monthly mailing:

 

Rate Based Attendance - Performance Standards
The FY14 performance standards reports are available in Cognos. Please note that there are two ways to look at the percent attendance data in Cognos. The performance standards data looks at total attended hours divided by total planned hours to get the percent attendance. If the project has more than one site, the data is combined to get the total at the project level. See the example below where the two sites have different points at the site level, but the combined data for the project level is what appears in the report.

This is the criteria for each benchmark:

Benchmarks:

 # of pointsCut Points for Attendance
Advanced 3 77% and above
Meets Standard 2 66%-76%
Needs Improvement 1 55%-65%
Remedial Action 0 54% and below

 

Performance Standards Report: Percent Attendance By Project

ProjectPlanned
Hours
Attended
Hours
PercentPoints
Project A 30,000 25,000 83% 3


Percent Attendance By Site

SitePlanned
Hours
Attended
Hours
PercentPoints
Site 1 20,000 14,000 70% 2
Site 2 10,000 8,000 80% 3
Total 30,000 22,000 73% 2

 

 

Rate Based Percent Attendance - Cognos Cube
The purpose of the attendance cube is to see how well programs are doing in filling the seats/slots approved in the class plan. The criteria to determine rate based percent attendance per month is based on the number of planned slots unless the number of students with attendance for the month is less than the planned number. The attendance formula is based on the date the student enrolls in the class as well as the planned class hours for the month. The attendance is prorated for each student based on the date enrolled and planned hours/month for the enrollment period. This only applies when a student enrolls or exits on a date other than the first or the last day of the month. The percent attendance is based on all enrollments per month, and classes that are under-enrolled are based on the planned slots.

For example, if class 301 has 13 planned slots and 11 attended in a month, the percent attendance is based on 13 students for that month which is 85%. For example, if a program enrolled 8 students in a particular month and 8 attended, the attendance percent is not 100%. In this case, it would be 8/13 which is 62%.

 

From the November 2011 Monthly Mailing:

      Revised Formula for Percent Attendance

      Since the attendance criteria changed in FY12 due to fluid slots, the formula to calculate  percent attendance has changed. The attendance formula is based on the date the student enrolls in the class as well as the scheduled class hours for the enrollment period.  This only applies when a student enrolls or exits on a date other than the first or the last day of the month. The attendance is based on all students enrolled each month and is not based on planned slots as in the past.  The percent attendance is based on all enrollments per month and classes that are under-enrolled are based on the planned slots. For example, if a 100 level class has only 6 students enrolled for that month, the percent attendance is based on 7 students for that month. The note on the slot screen indicates the minimum number of slots that are held for various classes:

            NOTE: All “100” Level classes have 7 slots held for class enrollments and all  other classes have 9 slots held for class enrollments.

 Once a class meets the maximum available to enroll, no more enrollments can be entered. The site slot summary screen shows the total number available to enroll while the Site Slots Detail  screen shows the number available to enroll for each class.    

Site Slots Summary

 Slots

Total
(Planned + 20% Overenrolled)

Enrolled

Available to enroll

ABE

58

53

5

ESOL

66

48

18

(ABE +ESOL)

124

101

23

 

 

Site Slots Details

Class

Type

Planned

Planned + 20% Overenrolled

Enrolled

101

ABE

9

11

12

201

ABE

11

13

16

301

ABE

14

17

14

302

ABE

114

17

11

501

ESOL

112

14

18

502

ESOL

114

17

18

601

ESOL

114

17

7

602

ESOL

115

18

5

 

TOTAL

103

  124

101

 

This example show how the percent attendance is calculated. Note that some students enrolled in mid-month so the scheduled hours are prorated.

 

October Attendance for Class 501: class meets 3 hours/class on Tuesdays and Wednesdays

 

ENROLL DATE

POSSIBLE DAYS

ATTENDED

POSSIBLE ATTENDED HOURS

ACTUAL ATTENDED HOURS

PRORATED SCHEDULED HOURS

SS 1

9/1/2011 -

8

24

24

24

SS 2

9/1/2011 -

8

24

24

24

SS 3

9/1/2011 -

8

24

24

24

SS 4

9/1/2011 -

8

24

12

24

SS 5

9/1/2011 -

8

24

21

24

SS 6

9/1/2011 -

8

24

24

24

SS 7

10/12/2011-

5

15

12

15

SS 8

10/18/2011-

4

12

12

12

SS 9

10/19/2011-

3

9

6

9

 

 

 

159

180

 

 

 

 

 

 

 

Class 301

Total Attended Hours

159

 

 

 

 

Total Scheduled Hours

180

 

 

 

 

Attendance %

88.33%

 

 

 

 

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk