S Shodan Nov 27, 2009 #1 Is there a template that I could use to track school class attendance throughout the year?
T trip_to_tokyo Nov 27, 2009 #2 I have just run up a Worbook for you at:- http://www.pierrefondes.com/ Look at the first item on the home page (number 20). 1. The numbers (1 to 30 in row 1) need to be changed for your student names. 2. If a student has attended enter 1 in his / her column for the correct day. If you look at column B student has attended every day for the whole year so at cell B 367 his / her attendance is 365. 3. If a student has not attended enter 0 in his / her column for the correct day. If you look at column C student has failed to attend every day for the whole year so at cell C 367 his / her attendance is 0. 4. You could enter a 0.5 for half days. If my comments have helped please hit Yes. Thanks.
I have just run up a Worbook for you at:- http://www.pierrefondes.com/ Look at the first item on the home page (number 20). 1. The numbers (1 to 30 in row 1) need to be changed for your student names. 2. If a student has attended enter 1 in his / her column for the correct day. If you look at column B student has attended every day for the whole year so at cell B 367 his / her attendance is 365. 3. If a student has not attended enter 0 in his / her column for the correct day. If you look at column C student has failed to attend every day for the whole year so at cell C 367 his / her attendance is 0. 4. You could enter a 0.5 for half days. If my comments have helped please hit Yes. Thanks.
