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 s...
We could limit the columns imported to just the ones used in the summary, but that’s its own complication. Let’s see when you’ve got a good connection, etc.
Or do a different workbook for each class.
Or do a different workbook for each class.
I have tried a couple of times now and have done a speed test, and have a great connection & it's not wanting to import more data (the longest I've waited is about 10 minutes). I still don't have a ton imported - only about 1/8 of what I need at this point in the year, and this has to last me through January, as far as data imported. It may be just too much data to handle.
Two suggestions:
- Keep separate workbooks for each of your several classes.
- Eliminate from the workbook's raw data sheet all but columns A through I (those aren't used in the summary calculations).
See the attached to see how the latter operates, and try copying and pasting in just those first 9 columns from your incoming data sheets,