I am a teacher for Third year Engineering class for which student Roll no’s ranging A div with Roll No 1 to 70 and Student from B div with Roll No 1 to 70 are attending the classes. I want to Create a google sheet so that I can monitor daily attendee of student. In one sheet get details of Date and Either present or absent roll no list and using this data generate another sheet which maintains attendee record day wise. also add details of percentage of Present

I tried in Google sheet but its not working properly