Thread: [Solved] Conditional Formula if a learner comes late in the morning, afternoon or morning and afternoon
View Single Post
 
Old 11-03-2018, 08:02 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
  
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default
BTW, the teachers are fully supportive of the added (creative) triangles for am, pm and am/pm cutting classes. They clarified that am or pm cutting class is equivalent to .5 or half day absent while am and pm cutting class is 1 day absent in the computation for daily attendance.


I have a attached a list of about 54 codes for every possible student behaviour affecting daily attendance. Please feel free to change or add any for clarity and consistency.


I'm really sorry about the ever changing codes. I deal with numbers daily but I don't know how the teachers keep track of the myriad movements and attendance of their students.
Attached Files
File Type: xlsx Code List.xlsx (15.5 KB, 10 views)
Last edited by Marcia; 11-04-2018 at 05:07 AM.
Reply With Quote