Forum Discussion

axbase01's avatar
axbase01
Copper Contributor
Sep 01, 2023

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 s...
excel
mathetes's avatar
mathetes
Silver Contributor
Sep 01, 2023
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)
axbase01's avatar
axbase01
Copper Contributor
Sep 01, 2023

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.

  • mathetes's avatar
    mathetes
    Silver Contributor
    Sep 01, 2023

    axbase01 

    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.

Resources