<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16850" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=890200205-01092010><FONT face=Arial
color=#0000ff size=2>thanks Mark, I am trying to do this and it is a
nightmare to keep track of catch up time.</FONT></SPAN></DIV>
<DIV> </DIV>
<DIV align=left><FONT face=Arial size=2>Philip Pike</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Director of ICT</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Bacchus Marsh Grammar</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Sth Maddingley Rd</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Bacchus Marsh 3340</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Ph 53664800 Ext 849</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>Fax 53664850</FONT></DIV>
<DIV align=left><FONT face=Arial size=2>email: pikep@bmg.vic.edu.au</FONT></DIV>
<DIV> </DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> itapps-bounces@edulists.com.au
[mailto:itapps-bounces@edulists.com.au] <B>On Behalf Of </B>Mark
KELLY<BR><B>Sent:</B> Wednesday, 1 September 2010 2:16 PM<BR><B>To:</B> Year 12
IT Applications Teachers' Mailing List<BR><B>Subject:</B> [Year 12 IT Apps] SAC
Timing manager<BR></FONT><BR></DIV>
<DIV></DIV>Hi all. This might be useful to some folk. <BR><BR>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.
<BR><BR>(Damn - this is starting to sound like a case study!)<BR><BR>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!<BR><BR>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.<BR><BR>Anyway, this might spark some similar class management ideas in
some of you.<BR><BR>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.<BR><BR>Cheers<BR>Mark<BR clear=all><BR>-- <BR>Mark
Kelly<BR>Information Systems Manager; Reporting Manager<BR>McKinnon Secondary
College<BR>McKinnon Rd McKinnon 3204, Victoria, Australia<BR>Direct line /
Voicemail: 8520 9085<BR>School Phone +613 8520 9000, Fax +613 9578 9253<BR><A
href="mailto:kel@mckinnonsc.vic.edu.au"
target=_blank>kel@mckinnonsc.vic.edu.au</A><BR>VCE IT Lecture notes: <A
href="http://vceit.com" target=_blank>http://vceit.com</A><BR>Moderator: IT
Applications Mailing List<BR><BR>One day my friend suddenly thrust a seabird
into my hands. He gave me quite a tern.<BR></BODY></HTML>