Forum Discussion
Excel Help - Student Attendance
It looks just like the data in the image, except with many more columns (that I don't need) & only on date. I added the other dates for an example of what I need set up. The big thing I cannot figure out is how to have only one set of names and have everything still match if a student is added/removed and the data rows change due to that.
It looks just like the data in the image, except with many more columns (that I don't need) & only on[e?] date.
If there's only one date, that means (or so I'm inferring) that it doesn't look "just like" the data in the image; there's some kind of difference, most likely in how chats and polls are reported. Are real names used, or is there a student ID (more unique, so that John Doe #1 can't be confused with John Doe #2)
That aside, for an ongoing process, it's often best to separate raw data (the input end of things) from the output. You're asking here for a way, a process--be it formula or something else--that will enable you to take the daily (weekly?/monthly?) data from that CSV and generate a summary view of the data like you have in your initial image.
Right now your process is to take portions of the input data and copy and paste.
Could you create a slightly more expansive edition of the raw data (with false names) CSV and post it on OneDrive or GoogleDrive, pasting a link here that grants access to it, as well as that spreadsheet you created as a sample of the output. Working with actual workbooks (or mockups) would be more relevant than images.....I am quite sure we can work up a fairly simple process for you.
- Sure - here is the raw data from two days. Thank you for your help! I use excel normally, but here is it pasted onto a google link in editor form.
https://docs.google.com/spreadsheets/d/1AUL8yLAmIxU9cYGzLElFx2RAr_Z52Y-v/edit?usp=sharing&ouid=112250675240238655034&rtpof=true&sd=true- https://b23.tv/hI1vKzm
Another option 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
Thanks. I've downloaded that. BTW, it's not at all in the same format as the example file you showed, but more what I expected. I'll won't be able to get to devote much time until the weekend.....
can you tell me how often the student roster changes, and are they altogether new, or just different from day to day with, in fact, a master list somewhere so that we could in fact work from something like "students registered this semester"? It seems odd to care so much if people are always coming and going; I can understand that any one person will have absences, etc., but totally new showing up?!
