If you are starting a faculty position, here’s something you can do that will make your life easier: start a spreadsheet with info on your undergrads.* My spreadsheet has a list by semester, which includes a list of all the undergrads who were working in the lab that semester. In addition, the spreadsheet has a section where I list each student in a separate row. In that section, I have columns for:
- each grant I have, where I can indicate if they worked on that grant
- whether they were part of an official university research program (UROP here at Michigan, PURA at Georgia Tech, possibly some other combination of letters at your institution)
- whether they did an honors thesis (ideally, you would have the title in here, too)
- whether they are a member of an underrepresented group
- whether they are a coauthor on an article in prep or in review
- whether they are a coauthor on a published article, and
- what they are currently doing (or what they were doing when I last was in touch).
This information is really, really useful when working on annual reports for grants, when working on new grant proposals (e.g., for the broader impacts section on an NSF grant), and when preparing department annual reports and tenure dossiers.
Some examples: When preparing a tenure dossier, I could say something like “on average, I’ve had four to five undergraduates in my lab each semester”. On grant proposals, I can say how many former undergrads in my lab are coauthors on publications. When going back to prepare a final report for a grant, I can easily tally how many students worked on that grant, how many were from underrepresented groups, and how many of them did an honors thesis related to that grant. And, when writing a letter of recommendation for a former lab undergrad, I can quickly pull up the exact semesters they were in the lab, info on their projects, etc. This is all really useful.
So, like I said, start a spreadsheet with info on your undergrads. It will be really, really useful.
Footnote: On twitter, Jason Venkiteswaran (@JJVenky) suggested also having permission forms required to use their names on grant applications, such as this NSERC form. This is a great idea, though I’ve never heard of such a permission form in the US. I never report student names in grant proposals, especially because I don’t think it’s appropriate to indicate info on demographics related to a particular student in a proposal. Instead, I just give aggregate info.
*After I tweeted about this last week, someone emailed me to point out that it can be useful to have a similar sheet for grad students. And others pointed out on twitter that this can be useful for lots of people other than just faculty.