Category Archives: Uncategorized
I’m working on a new way to visualize eye-tracking data. Last year, I had a number of students watch a video while my camera recorded their eyes. After exporting the raw data, I wrote a custom script with Three.JS to plot the fixations in a 3d world.
The gif to the right shows my current version. Each person’s eye track is shown as a line. As time progresses, the lines shift/move with their eye fixations.
The major benefit of this approach is that we can zoom out and see aggregate behavior fairly clearly. While we can get a similar look with the bar chart I posted earlier in the year, this way does a better job of allowing you to compare the time dimension.
If you have a Google Cardboard, the current version will allow you to see the visualization in a 3d VR world.
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
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.
Here are the slides for my guest lecture in MRKT 301 at Woodbury.