I’m happy to say that my article reviewing PPT files has been published. I used C# to automate the analysis of a 30,000 PowerPoint files from a large academic publisher. It was a fun exercise in “big” data, involving a lot of files and a lot of data cleaning.
How Do Academic Disciplines Use PowerPoint?
This project analyzed PowerPoint files created by an academic publisher to supplement textbooks. An automated analysis of 30,263 files revealed clear differences by disciplines. Single-paradigm “hard” disciplines used less complex writing but had more words than multi-paradigm “soft” disciplines. The “hard” disciplines also used a greater number of small graphics and fewer large ones. Disciplines identified by students as being more effective users of PowerPoint used larger images and more complex sentences than disciplines identified as being less effective in this regard. This investigation suggests that PowerPoint best practices are not universal and that we need to account for disciplinary differences when creating presentation guidelines.
I’ve been working on a better way to visualize data generated by my eye tracking camera. The typical approach smashes data into a single image. However, I’m really interested in seeing how eye gaze moves over time, meaning that aggregating loses the critical aspects.
The gif above shows the tool I’m currently developing. It uses three.js to place the recorded video and image slide into a 3d space. I then display *every* person’s gaze as a point, and update it in real-time. This also allows me to include pupil dilation, which is a key marker of cognitive load.
It still needs work, but is a pretty cool way of seeing how people reacted during the one-on-one experimental sessions.
These are the slides from a presentation I made on the Faculty Development Day. The previous presenters went long, so I only had 3 minutes. However, I was able to keep to the time limit by doing 1 sentence per slide…
Here are my evaluations for the Fall semester. I’ve picked out a few of the more interesting comments.
The workload is a bit much for brand new material.
This is a persistent issue in the class — we cover a lot of material. The class goes over Word, Excel, and PowerPoint. We also spend a lot of time working on Capsim, which is a business simulation. I enjoy Capsim, as it gives a practical context to the abstract skills people learn. However, it has a significant learning curve. I’ve been using the MBA version of the class to develop a simpler business game that doesn’t involve quite as many details.
On a lighter side, some people left humorous comments
Funny, helps learning stale information slightly less painful.
Capsim is fun despite people’s hatred towards it
Several left nice comments
There is a lot about excel and word especially that I did not know. This has already been beneficial to me throughout work and school. I feel like this course will be extremely helpful at the beginning of a student’s educational experience.”
Professor garrett is always there for you and genuinely cares about your performance in the course. He schedules meetings with students to ensure a solid grade and understanding of the course
My most recent paper, titled “Textbooks for Responsible Data Analysis in Excel” has been put online at the Journal of Education for Business.
Abstract: With 27 million users, Excel (Microsoft Corporation, Seattle, WA) is the most common business data analysis software. However, audits show that almost all complex spreadsheets have errors. The author examined textbooks to understand why responsible data analysis is taught. A purposeful sample of 10 textbooks was coded, and then compared against spreadsheet development best practices. The results show a wide range of approaches, and reveal that none of the 10 books fully cover the methodologies needed to create well-rounded Excel data analysts. There is a need to re-evaluate the teaching approaches being used in office application courses.
Below is a presentation for the Carl-Benz Academy on May 20th, 2015.
Improved Data Wrangling and Validation in Excel
Presented November, ’14 at CAIR
Are your Excel spreadsheets error-free? This presentation is intended to help you use automated processes to clean up and transform data in Excel. The overall approach combines vLookup, conditional formatting, named cells and ranges, formatting for meaning, and spatial layout. The resulting approach reduces errors, increases auditability, and speeds up repetitive tasks. Virtually all Excel audits find errors; this presentation is designed to increase your confidence in data wrangling tasks.
Garrett CAIR Workbook
More than just getting input, we used focus groups to build a policy, grow support, and fast-track implementation. For our small tuition-dependent university, admissions standards are a politically charged topic. A small team began by creating data-driven admission criteria. We then used focus groups to engage with stakeholders campus-wide. Each focus group began with a brief presentation, and then quickly transitioned into a guided dialogue. The meetings allowed the team to find and address points of opposition. By the time the proposal went to the full faculty body and administration, most of the potential critics had already been engaged. This session will present the focus group methodology used to build consensus.