探花楼

Using non-technical tools for effective data viz

May 7, 2018
  • data visualization
Six brightly colored graphics all designed in a circle pattern. Registrars are charged with collecting information, securing it, and making it available as necessary and appropriate.

鈥淭hat鈥檚 been true for centuries, but today we have more data and more tools than ever before at our fingertips,鈥 said Carla L Boyd, Registrar at University of Minnesota Duluth. 

鈥淲e play an important academic support role and can bridge the gap to reaching campus or system goals through how we present information,鈥 said Ken Myers, Registrar and Associate Professor at University of Minnesota Crookston.

Effective data visualization helps the office of the registrar tell more powerful, accessible stories based on the data they steward. Not only does that information help students and stakeholders, but it can also demonstrate the scope of the registrar鈥檚 responsibilities beyond just registering students.

So, what鈥檚 effective? 
鈥淚t鈥檚 not just pulling data; it鈥檚 selecting what pieces of the data are really needed and how to share it in the best way -- utilizing color, charts or graphs, and goal-setting,鈥 said Myers, whose campus has found friendly competition to be effective -- setting a benchmark and having academics departments compete to reach the goal. 

鈥淔or example, using Excel: for the last two semesters, we鈥檝e had 100 percent of faculty post syllabi, a big improvement over the previous years,鈥 Myers said. 鈥淏y using conditional formatting in Excel and pre-establishing that formatting so sometimes it鈥檚 just a copy-and-paste of data-specific columns into a spreadsheet so it automatically changes the color of the cells based on department and percentage, each department is able to see exactly where they stand compared to other departments.鈥 

鈥淜en has done a great job with Microsoft [Excel] pulling data in and making it visual and appealing to create data transparency and understanding,鈥 Boyd said. 鈥淥ur campus is using the Google suite to do the same thing in a different way, rolling it out in a web-based form.鈥 

鈥淭hese are free, non-technical tools provided by our system鈥檚 Microsoft and GSuite licenses that anyone can use,鈥 she added. 鈥淚n the past, we had this data but we needed tech people in order to use it, which depended on campus resources. Now there are tools and methodologies that registrars can apply, based on what we know about how people learn, and applying it to data.鈥

Now, instead of drowning in big data, registrars can add value to the data, focusing on necessary questions and coaching stakeholders in how to use the data. In many cases, registrars are mentoring and teaching faculty and staff how to glean, share, and use analytical data to support student success, and further the campus mission and values. Boyd and Myers have implemented training sessions for new faculty and staff, establishing the registrar鈥檚 offices as partner, as well as a knowledgeable, engaged and available resource -- not a resource 鈥渙n a shelf somewhere,鈥 Myers said.

Information is power
鈥淲e want to learn to do this well in order to to tell powerful stories that change the way we understand who we are, what we are, and why we鈥檙e doing it,鈥 Boyd said. 

Working within the UM system, Myers and Boyd have developed a synergy among offices, where they try various things at different campuses in order to learn and grow together. That kind of collaboration has been critical to their learning, and they鈥檙e bringing that spirit to the 2018 探花楼 Technology and Transfer Conference in July.

鈥淭hat鈥檚 one of the things I love about 探花楼 Tech,鈥 Boyd said. 鈥淚t鈥檚 a wonderful opportunity to bring theory and practice together for collaborative thinking, which can be brought back to campus to use immediately.鈥

Attendees at the 鈥淒ata Visualization鈥 session will come away with new skills and feel empowered to make immediate changes on their campuses. 

鈥淲e鈥檒l give more specific examples about what we鈥檙e doing and how it was implemented, which can be used or tweaked as necessary,鈥 Myers said.

鈥淚n addition, people new to their positions can begin to get a handle on and an understanding of all the data they have,鈥 Boyd added. 鈥淗ow do you take that first step? How have others taken that first step? What鈥檚 the next step after that?鈥 

 

Subscribe

探花楼's bi-weekly professional development e-newsletter is open to members and non-members alike.