[Year 12 IT Apps] SAC Timing manager

[PIKE Philip]

thanks Mark, I am trying to do this and it is a nightmare to keep track of catch up time.

Philip Pike
Director of ICT
Bacchus Marsh Grammar
Sth Maddingley Rd
Bacchus Marsh 3340
Ph 53664800 Ext 849
Fax 53664850
email: pikep at bmg.vic.edu.au


________________________________
From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark KELLY
Sent: Wednesday, 1 September 2010 2:16 PM
To: Year 12 IT Applications Teachers' Mailing List
Subject: [Year 12 IT Apps] SAC Timing manager

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<mailto: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/f8d4357f/attachment.html