CVCUE Conference

I am in charge of the CVCUE Spring 2012 conference committee. So many things to manage. In the past when we did evaluations we had participants fill out a form on paper (I know, you’re thinking what is this “paper” that you speak of). This required someone to manually type up the evaluations (students I had in detention worked nicely for this). The problem with this is many fold. It takes time to type up evals, some handwriting is illegible and for data purposes it can be tricky to compile all the information about each session when they are filled out differently.

Trick #1 Use a Google Form for Conference Evaluations.  Let the participants do their own typing.

Trick #2 Use QR codes to link to the session evaluations. I like to use http://goo.gl to create a short URL and a QR code at the same time.

Trick #3 Use &entry_5=session name appended to the end of the evaluation URL to pre fill in the session number, session title and presenter name.

Trick #5 Use Google Chrome. I like the chrome store add on called shorten me.

Trick #6 I use a Google spreadsheet to organize the sessions provided.  I have a column for session number, a column for session name, a column for speaker first name and a column for speaker last name.
I then make a column for session URL and write the formula =”
and then paste the form URL
=”https://docs.google.com/a/cvcue.org/spreadsheet/viewform?formkey=dGdHUGEwNXMySDFxSDlGRXdUZ3JRMmc6MA
Then I want to append to the end the pre filled in information so ultimately it would look like this
https://docs.google.com/a/cvcue.org/spreadsheet/viewform?formkey=dGdHUGEwNXMySDFxSDlGRXdUZ3JRMmc6MA&entry_6=2&entry_7=Session Title&entry_8=Mr+Person

But my formula looks like this
=”https://docs.google.com/a/cvcue.org/spreadsheet/viewform?formkey=dGdHUGEwNXMySDFxSDlGRXdUZ3JRMmc6MA&entry_6=”&A13&”&entry_7=”&C13&”&entry_8=”&I13&”+”&J13
Where A13 is the session number
C13 is the session title
i13 is the presenter first name
j13 is the presenter last name.

I then drag down the formula and have a customized URL for EACH session.

Trick #7 I open a new window in Google Chrome and copy and paste the custom URL into the toolbar (I have the spreadsheet and new window side by side). I can then use my Google Chrome extension and the short URL is automatically copied to the clipboard. Copy this into a column in your spreadsheet.

Trick #8 I then go back to the chrome extention and right click on the QR code and copy the image URL.  I paste that into a different column in the spreadsheet.

Trick #9 In another column on the spreadsheet I type the formula =Image(N13,1)
where N13 in this case is where you would find the URL of the QR code.
This automatically creates the QR code in the spreadsheet.

Now I have for each session a short URL and a QR code with minimal effort.