Profiles for Incoming 1Ls needed to be created around August 19. Here are the instructions:

1. Pull student submissions from the online form. Limit the export to the current year only. The only data needed are: First Name, Last Name, Undergraduate Institution, Undergraduate Major, and Photo.
2. Open CSV file in Excel, move Last Name to Column A (first column), then sort all columns and rows in alphabetical order according to last names.
3. Open up an Excel template that has HTML included, then paste in the columns accordingly.
4. Copy all the rows and columns from the Excel file then paste into an HTML file template.
5. Open the HTML file in Chrome browser and check to see if the photos cropped properly. If a person’s head got cropped out, add a CSS class (class=crop-center) in the person’s img element: <img class=crop-center src=lastname-firstname.jpg>
6. Once everything looks good, print from Chrome browser (Save as PDF).
7. With the HTML file still open, drag photos into a folder and rename the files to match the student’s last name.
8. Put everything on the ShareDrive.