Press "Enter" to skip to content

How to create a macro in Microsoft Office Excel to process survey and test data from Blackboard 9.1

For the last 7 years I’ve been working with data from firstly WebCT then from Blackboard 9.  Staff and students wanted to be able to take the data from tests and surveys and then report on it in Microsoft Excel.
Simple? No.
WebCT and Blackboard would prefer you to purchase their additional tools to do all of this.
As someone familiar to working with macros in Excel I chose to do my own thing.  I wrote a macro to churn through the output and produce graphs and readable text. I then went on to producing RAG ratings (Red, Amber and Green indicators of performance) and everything was formatted into a report for surveys such as module evaluations.
Recently I’ve started developing my own survey tool in .net using a responsive design, but I’ll cover that another time.
I’ve been asked by Laura Sheffey from Mary Baldwin College OIT if it would be possible for me to share how I’ve been doing this.  I’ve put together the basics in the following video and provided a stripped down version of my code.  (This wasn’t written for anyone else to use so sorry for the lack of comments – the video should help).
If anything is unclear please comment below and I will clarify for you.
Download the example code:

Creative Commons Licence
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

When using this code please attribute it to myself and link back to this blog post.
Enjoy and good luck!

Be First to Comment

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.