[Year 12 IT Apps] SAC Timing manager

[Mark KELLY]

Hi all.  This might be useful to some folk.

I got sick of keeping track of how much time was owed to which kids who were
absent during SAC periods.  My paper diary notes soon got out of control.

(Damn - this is starting to sound like a case study!)

This spreadsheet timing manager is a simple way to record daily minutes used
on SACs. During each session, I just fill in the session length at the top,
autofill it down, then zero out the kids who are absent. Conditional
formatting makes absences show up pink.  As they catch up on lost time
during lunch, frees or after school, I put the minutes in the 'catchup'
region.  Conditional formatting also does graduated colour coding of minutes
owed - if you haven't played with conditional formatting in Excel 2007, it's
a lot of fun!

The spreadsheet keeps count of how much time kids are still owed. Naturally
if they don't catch up within a certain period, they lose their owed time.

Anyway, this might spark some similar class management ideas in some of you.

P.S. It also neatly adds up the total class time you allow for the SAC, and
I've just realised I gave my kids 698 minutes for a SAC I wrote which
allowed between 755 & 940 minutes.  They haven't complained, so I might
shave the timings for similar big SACs I write for 2011-2014.

Cheers
Mark

-- 
Mark Kelly
Information Systems Manager; Reporting Manager
McKinnon Secondary College
McKinnon Rd McKinnon 3204, Victoria, Australia
Direct line / Voicemail: 8520 9085
School Phone +613 8520 9000, Fax +613 9578 9253
kel at mckinnonsc.vic.edu.au
VCE IT Lecture notes: http://vceit.com
Moderator: IT Applications Mailing List

One day my friend suddenly thrust a seabird into my hands.  He gave me quite
a tern.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100901/cab3e3f0/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: u4o1 timekeeping-demo.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 14821 bytes
Desc: not available
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20100901/cab3e3f0/attachment.bin