Forum Discussion
Excel Help - Student Attendance
Hello!
I work at an online school and have well over 200 students. I am looking for an efficient way of running attendance using the bigbluebutton csv report that is generated for us. It has the student name and then two of the many columns I'd like to use - one is the number of chat responses, the other is the number of poll responses. I'd like to set it up similar to what I have below, for an example. The students name in column A. Then two columns of data that I can copy/paste in somehow. Sometimes I get new students or lose students, so I'd like any new names to automatically be added when a new list is added, along with their data.
Is there a good way to do this so I can just copy/paste the names, polls, and chats each day & have just the poll and chat data match up with the name in the A column? I'd like to have the student name on just once. The hard part that is confusing me is removal or addition of students, so I can't just copy/paste like normal, the sheet would need to help me find the root name & match that up. I hope this makes sense! It's just so I can have everything there at a quick glance.
26 Replies
- What does the CSV file look like? There might be an easier way to get your output to look like your image looks, to do so without needing to copy and paste. Just add the most recent set of data from that CSV, with date, name, chat# and poll#
But it would help to see what that raw data looks like (again, using "names" like Jane Doe and Bob Jones)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.
