View Single Post
Old 11-28-2011, 08:06 AM   #2
lbb
Location: Massachusetts
Join Date: Jun 2006
Posts: 2,832
United_States
Offline
Re: Attendance Tracking revisited

I made another one, for excel, that has some bells and whistles. You can insert a "test date" column, and depending on whether that column indicates that a person has tested, you either reset their hours or keep the total going forward. The "hours toward next test" field also has conditional formatting, so when the student has achieved the number of hours it shows in green and when they're getting close, it shows in amber. I don't think google spreadsheets can do all that I'm doing in this spreadsheet, but I'll share the excel with anyone who wants.
  Reply With Quote