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>