Forum Discussion
Excel Help - Student Attendance
https://docs.google.com/spreadsheets/d/1AUL8yLAmIxU9cYGzLElFx2RAr_Z52Y-v/edit?usp=sharing&ouid=112250675240238655034&rtpof=true&sd=true
OK -- here's a first pass. I've designed this so that what you can do is simply copy each subsequent day's CSV report to the bottom of the data table. The formulas will accommodate any new initials. However, assuming there IS a full roster of registered students, it would make more sense to have that on the left most column as a fixed text list. You will still need to add columns for Chat and Poll and copy the formulas to the new columns. Some documentation in the form of text boxes is included.
The result looks like this.
Thank you so much for your time and trying to help me out. Once I get a working sheet, it will save me many, many hours a week. Unfortunately the roster is very fluid, as students get added and withdrawn many times per week & we teachers don't know we are getting new kids till they pop up in our roster their first day. Online schools are very different with this than traditional schools. Over the year I probably have 500 kids total come in and out. Only about 100 will be the same all year.
I downloaded the sheet you made, but as soon as I paste new data below the old data, all numbers in the report have dashes. I have been using excel a long time, but only do very simple things, so am not extremely well versed. Poll # change each day - not sure if that matters. Some days we will have 1 or 2, others 4-7. Here are 3 things I tried & I'm not sure what I am doing wrong. I played around with it a bit more before making the video and cannot figure it out. https://somup.com/c0QhD3Akve
- Sadly, the video doesn't really help me grasp it all. Is it possible for you to post another copy with a new day's data (or maybe two) in their own raw data form. then I'll create an updated one with more detailed instructions on how to manage that changing number of students.
- I have found xl_func in your video which may mean the forumla not work properly.
What is your excel version?
