[Year 12 IT Apps] SAC Timing manager

[Brendyn Hancock]

Thanks. 

 

I use something similar but not as comprehensive.

 

Cheers

 

Brendyn Hancock

ICT Manager

Nagle College

PO Box 507

BAIRNSDALE VIC 3875

p 03 5152 6122 ext954

f 03 5152 6220

 

Disclaimer: This email and any attachments may be confidential. If
received in error, please contact us and delete all copies. Before
opening or using attachments check them for viruses and defects.
Regardless of any loss, damage or consequence, whether caused by the
negligence of the sender or not, resulting directly or indirectly from
the use of any attached files our liability is limited to resupplying
any affected attachments. Any representations or opinions expressed are
those of the individual sender, and not necessarily those of Nagle
College. < http://www.nagle.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
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.



Scanned by Sonar. 
Date: 2010-09-01 14:56:16.718
From: bhancock at nagle.vic.edu.au
To: itapps at edulists.com.au
Profile: default_out
Mail id: challenge-33169763633w5-0
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20100901/e47385ef/attachment-0001.html