...
To do's
- Get faculty data (from Joyce?). Ensure we include emeritus faculty who are active or might otherwise call on ChemIT's services.
- Include only "Current" from the Grad student list.
- Don't include "withdraw", for example. (And "Former" Grads already not being included, apparently.)
- Standardize columns so all data can easily be used within one sheet (same column heading titles and order)
- Idea: Add dummy fields in any DB that won't have data so automatically get correct column heading.
- With Grads: NetID, not NetID-based email
- To Grad DB: Add a "title" or "Position" field. And have it auto-filled with the word "Grad" (or something like this).
- In Grad DB: "NetID" field exists but is currently empty. Fill it with the NetID for each grad. Q: Business need for PatH, if any?
- Note: Still will want fully qualified email field since Outlook won't always resolve a NetID automatically. Can that email field be auto-generated from the NetID field?
...
- chemistry staff (include researchers, post docs, visiting scholars, regular staff) and
- graduate students
- faculty (including visiting profs and emeritus)graduate students
Fields needed for each research and staff / faculty group
| Group | First name | Last name | NetID | Position | Campus address | Source | NOTES: | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Staff | PI | FirstName | LastName | NetID | title | CampusAddress | Sharon de Roos |
| ||||||
Grads | Chair | First | Last | email* | Fill in with: Grad |
| Pat Hine | Don't include grads in DB who aren't here. Eg: "withdraw" | ||||||
Faculty |
|
|
|
|
|
| n/a | n/a | n/a | n/a | Fill in with: *Faculty |
| Sharon de Roos | Initially from Sharon's phone directory's Excel file (not a DB); update by hand. It's what Joyce Boda recommends using. |
* When and if Grad DB gets their NetID field 100% populated, pull that one instead of their "email" data. Otherwise, just keep using this field and do the required data munging.
Required
- Group affiliation
- Name- First
- Name- Last
- Cornell NetID
...