Senior Design Expo Yearbooks

Challenge: Upgrade the Senior Design project yearbook from a student souvenir to a polished B2B and recruiting tool.

Photography: After capstone managers identified prominent teams in separate disciplines, I arranged to photograph them with their work.

Design: I collaborated with the university designers on a half-page, two-column template to represent each team, consisting of a standard-sized team image, names of all involved students and professionals, a short summary and one image representing their skills in the project.

Image Editing: Almost all student-submitted images required cropping resizing, lightening and brightening with Photoshop.

Data Merge: To manage the multiple names, images and summaries of the teams, I prepared a version of the master spreadsheet to use as an InDesign data merge.

Excel spreadsheet included image file names collected with an automated process, saving a day’s manual work.
Table of contents listing project titles and pages separated by red academic names such as Civil Engineering and Mechanical Engineering
Table of Contents automatically generated by the H1 titles of each team, divided into categories by a subtitle in its own text-wrap box.
Formatting the headers allowed all 50 teams to generate nearly instantly.
Multiple Record Layout allowed two teams’ information to display on each page. The text could then be edited to remove blank lines and reshape the right column’s contents to fit appropriately.

Home   |   Graphic Design, Layout & Branding