It’s been two months since we convened in sunny (and randomly 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…
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…
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!