What I Did This Summer: A NACE14 Check-In

Vanessa Newton

Vanessa Newton, Program Analyst, University of Kansas
Twitter: https://twitter.com/vlnewt
LinkedIn: www.linkedin.com/in/vanessaliobanewton
Blog: www.wellnessblogging.com


It’s been two months since we convened in sunny (and randomlyVN Instagram Shot rainy) San Antonio and it’s time to do a quick check-in on your progress.  If you are anything like me, you left San Antonio feeling inspired and ready to implement some of the amazing ideas you learned at NACE14 (*cough, creating dashboards, thanks a lot Joe, Carrie, and Jenny, cough*).

I got back to Kansas and started YouTube-ing progress Gantt charts. I took an event that I run, the part-time job fair, and plugged some data in to see what I could create. After a few stressful moments and referring back to my favorite Irish YouTube Excel expert (SubjectMoney also makes a very useful tutorial), I developed a dashboard that looked a little bit like this…

VN Dashboard Screen ShotIf you look at the screen shot (at left—click to enlarge) at the different sheets in the workbook I created, you’ll find the checklist and the progress Gantt chart.

I wanted the overview sheet to be, well, just that, an overview. I didn’t want it to be too clogged up with all the little details that need to be taken care of.

The checklist spreadsheet is just that—all the little things that need be done. Here’s a glimpse of what that looks like…

VN Checklist Screen Shot

The Gantt chart spreadsheet is the spreadsheet, broken down into more direct action items (for example instead of “send a final registration e-mail, if needed, to employers” it is “send final invitation”). This way my Gantt chart doesn’t look ridiculous with a huge long phrase in the chart. Trust me on this—I did that initially. The YouTube tutorials (linked above) take you step-by-step on how to set up a Gantt chart and I recommend referring to them when setting up your chart.

Once I got the hang of how to get the dashboard set up, I started implementing dashboards into other events. And then, I got an idea to work on creating a website and writing the code so that my dashboards are available any place and any time, not just when I am at my desk. (See what you did Joe, Carrie, and Jenny? You created a data monster!) I’m still working on the logistics of writing the code and it will take much longer than just setting up the dashboards did, but hey, we are only two months out! If you aren’t as much of tech/code nerd like I am, you could always upload your Excel docs to a One Drive or G-Drive.

Erin Chamlee and Desalina Allen from NYU also did an excellent presentation on assessment timelines. Key points are up on my white board as reminders to myself. Reminders such as “what gets measured gets done” and “how can we streamline our assessments?”

Two months out—what have you implemented from NACE14? Any strategies or initiatives that you are working on? Perhaps creating progress Gantt charts of your own for your office? Let me know in the comments below!


This entry was posted in NACE14 by wellnessblogging. Bookmark the permalink.

About wellnessblogging

25. M.S. in Industrial and Organizational Psychology and B.A. in Psychology. I was a Wellness Graduate Assistant with Campus Recreation and Eastern Kentucky University for 2 years. I'm currently based in Kansas where I am a Wellness Champion with state.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s