exceluser1982
New Member
- Joined
- Dec 8, 2014
- Messages
- 3
Hi Everyone,
I'm looking to create an attendance monitoring system in Excel for students at a University attending a project week. I have made a start on this with the following steps:
I have tested this and it works fine, prompting the user to log in to the University system which ensures the email address is logged. There are a few feature requests I'm currently stuck on. They are:
1) There will be multiple classrooms and each teacher should be able to login and see info re their class only so they can do a manual head count and check all ok. So we would be ideally looking to use one overall spreadsheet with multiple worksheets - we do not want to use lots QR codes but this may be the only way?
2) We would like to add up the 'lateness' cumulatively during the week so we can flag to students who are building up a period of lateness.
3) We would also like to highlight non-attendance, this could be via a 'vlookup', cross checking against a list of email addresses for each class. I'm not sure on the formula though.
Any help much appreciated with this!
Many Thanks
I'm looking to create an attendance monitoring system in Excel for students at a University attending a project week. I have made a start on this with the following steps:
- Created a simple google form linked to a spreadsheet which records the email address of the student and time
- Generated a QR (Quick Response) code which links to the spreadsheet so users can scan this with their mobile phone. We do not have access to barcode scanners this year so will be relying on students and their smartphones where possible.
I have tested this and it works fine, prompting the user to log in to the University system which ensures the email address is logged. There are a few feature requests I'm currently stuck on. They are:
1) There will be multiple classrooms and each teacher should be able to login and see info re their class only so they can do a manual head count and check all ok. So we would be ideally looking to use one overall spreadsheet with multiple worksheets - we do not want to use lots QR codes but this may be the only way?
2) We would like to add up the 'lateness' cumulatively during the week so we can flag to students who are building up a period of lateness.
3) We would also like to highlight non-attendance, this could be via a 'vlookup', cross checking against a list of email addresses for each class. I'm not sure on the formula though.
Any help much appreciated with this!
Many Thanks