![]() Less conveniently not all attendance sessions are entered, so there is no pattern to base things on.) (conveniently, the classes are all entire day classes, and there is no date overlap for any single student. We meet with students after a certain number of absences and lates - but if they are absent for both morning and evening session it counts as a single absence (lates both count)Īt a minimum, I would like to consolidate the AM and PM row for "absent" and "explained absent" occurring for the same student on the same day into one row, instead of spread across two so I can just count rows (explained, absent, late, and left early) instead of count and then manually track and compare. attendance (Present, Absent, Late, Left Early, Excused, Explained).Its both time consuming and students fall through the cracks. Right now I'm filtering the data, turning that into a pivot table and then manually cross-referencing the pivot table count and the filtered data dates & sessions and tracking new absences by pasting them into a "master list." The closest approximation ( Combining duplicate entries with unique data in Excel & the one linked in comments) runs into problems with Scripting.Dictionary not being a thing on Macs? I've been searching all over the web for days and tried multiple different methods, even the most promising of haven't worked. I'm stuck with a fairly finicky data report that I don't have the option of customizing at all, that I would like to prepare in such a way to make my life easier. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |