Eye-Tracking in Instructional Videos

Eye-Tracking in Instructional Videos is a presentation I gave at the ISECON 2015 Conference.  A copy of the paper is also available below.
Posted in Research | Comments Off on Eye-Tracking in Instructional Videos

Welcome Faculty: Moodle Overview

Posted in Uncategorized | Comments Off on Welcome Faculty: Moodle Overview

New paper published

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.

Posted in Presentations | Comments Off on New paper published

Informatics & the Auto Industry

Below is a presentation for the Carl-Benz Academy on May 20th, 2015.

Posted in education | Comments Off on Informatics & the Auto Industry

Excel CAIR Presentation

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

Posted in Uncategorized | Comments Off on Excel CAIR Presentation

CAIR Focus Group Presentation

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.

Posted in education | Comments Off on CAIR Focus Group Presentation

Combining columns of text in Excel

Excel’s & (ampersand) symbol is powerful tool for combining columns.  For example, you can

  • Display names in different ways.  Eg., “John” in A1 and “Smith” in B1 can be shown as
    • John  Smith by =A1 & ” ” & B1
    • Smith, John by =B1 & “, ” & A1
  • Making a mini-mailmerge for copying & pasting student grades into an email (see video).
    • Named fields help with this.  Instead of =”Hello, how are  you today ” & A1 & “?” , write =Greet & A1 &”?”, and name a cell Greet with the opening message.
    • Another useful function is =char(10), which inserts a line break into your text.

Posted in Excel | Tagged , , , | Comments Off on Combining columns of text in Excel

Course Evaluations for Fall 2013

I recently received my course evaluations for the Fall 2013 term. They’re linked below.

Posted in Woodbury | Tagged | Comments Off on Course Evaluations for Fall 2013

Globalization of the Halal Market

Dr. Angelo Camillo presented this at Woodbury’s weekly colloquium.

Posted in PowerPoint, Presentations | Tagged , | Comments Off on Globalization of the Halal Market

eLearn 2013 Presentation on Moocs

I was able to present some of my summary work on Moocs at the eLearn conference today. Below is my presentation, but my written paper is also available for download.  This presentation was a collaboration with a Woodbury MBA Student, Yesica Allaya.

Abstract: 

How will Moocs influence the college and university system?  This paper examines them with the “iron triangle” principles of access, cost, and quality.  These show that while Moocs have lower cost, they also have reduced access.  Because they reduce person-to-person contact, students must already be skilled life-long learners.  In addition, while Moocs are currently free, this is a result of them being subsidized.  Their actual cost per successful completer is closer to 1/10th of a traditional face-to-face or online course.  As a result, Moocs are unlikely to significantly affect existing face-to-face or online delivery mechanisms.  Instead, they are likely to reach new life-long learners.

 

Posted in education | Tagged | Comments Off on eLearn 2013 Presentation on Moocs