Copy their email address into the Excel spreadsheet, next to their nameĪ lot of experimentation and a lot of digging around in HTML source code later, a very rough-and-ready, very situation-specific, but nonetheless functional program did eventually emerge.Seeing as I was working in Excel, I came up with the idea of writing a VBA program that would: Skipping forward to the point where I needed to let the other peer mentors know who they needed to contact, I decided that seeing as I had nothing else to be doing, I could save my fellow mentors a bit of time by finding the email addresses of the new students myself on the university computing system.įour or five names in, however, I was already reassessing my benevolent decision - faced with another 320-odd names, and not willing to admit defeat, I decided to see if I could somehow automate the process. Attached to this email was a list of the names of the new students in an Excel spreadsheet.
I am, in fact, a 'lead' peer mentor - generally speaking this doesn't entail much more work than the peer mentoring itself, but occasionally there is a little bit of work to be done around the management of the peer mentoring scheme within the department.Ī little while ago, I was sent an email by the maths department's Director of Studies asking if I would mind helping to mix up and then divide the new intake of maths students between the 42 peer mentors. A bit of context: as well as being a super-hard-working maths student (.), I am a peer mentor for eight first-year students who have just started maths courses at the university.
0 kommentar(er)
