With almost universal availability of Internet and the availability of reliable on-line productivity tools, such as Google Docs, individuals as well as companies are switching over to Cloud Computing. In this blog I will post items of interest to my colleagues/patrons/clients.
Sunday, March 19, 2017
yogi_Create Table Of Students With Incomplete Assignments (marked *)
I work with a team of teachers and we use Google Sheets as our shared gradebook. We have multiple tabs (one for each class) where we record our grades. Not all of our students are in each class, so each tab has column A where the students names are listed and row 1 where the assignments are listed. We would like to use a macro or formula to look through all of the tabs for "*", which represents an incomplete assignment and return the student's name, the assignment title, and the tab (class) name to a new tab. This would allow us to have an always up-to-date list of work that students are behind in.
I've read about a lot of ideas that seem to work for only part of the problem. We would really appreciate help on this.