Hi. I'm using Excel 2010 to try to create a spreadsheet so that my school can start to keep track of overall student attendance and administer consequences for chronic absenteeism. I'm a novice at Excel.
I created a workbook where the counselor can enter daily attendance (just a roster of students with calendar, counselor enters "1" if the student is absent), and then a column which lists a sum total of absences for a given student. There is one sheet each for freshman, sophomores, juniors, seniors. I also have a sheet with a roster of teachers where the counselor checks off whether each teacher has turned in their daily attendance, with a column listing how many times the teacher has failed to turn in attendance. What I'd like is for another sheet that would spontaneously update a list of students who have reached certain threshold numbers of days of absences. So like 5 lists, one for 2 absences, one for 3 absences, one for 6 absences, one for 9 absences, one for 12 absences. This is so we can print the list each day to give to the principal to administer consequences for chronic absenteeism.
Thanks for the help. This is for a public school in a small developing nation, and getting a handle on absenteeism will really make a difference.
I created a workbook where the counselor can enter daily attendance (just a roster of students with calendar, counselor enters "1" if the student is absent), and then a column which lists a sum total of absences for a given student. There is one sheet each for freshman, sophomores, juniors, seniors. I also have a sheet with a roster of teachers where the counselor checks off whether each teacher has turned in their daily attendance, with a column listing how many times the teacher has failed to turn in attendance. What I'd like is for another sheet that would spontaneously update a list of students who have reached certain threshold numbers of days of absences. So like 5 lists, one for 2 absences, one for 3 absences, one for 6 absences, one for 9 absences, one for 12 absences. This is so we can print the list each day to give to the principal to administer consequences for chronic absenteeism.
Thanks for the help. This is for a public school in a small developing nation, and getting a handle on absenteeism will really make a difference.