Avatar photo

How a Spreadsheet Helped 90 Percent of My Students Earn a Pulitzer

  Reading time 6 minutes

If you think keeping traditional students motivated is a challenge, try getting experienced, brilliant college professors to do their homework with nothing but passion and positive reinforcement at your disposal. That’s where I’ve found myself for the last few years as the lead designer and facilitator of the DePaul Online Teaching Series.

On the one hand, I love that I don’t have to evaluate the DOTS participants. The program is designed to introduce faculty to new tools and techniques and get them inspired about what’s possible as they make the transition to online teaching. As a result, the atmosphere of every workshop meeting is positive and supportive. On the other hand, this means I have to get creative when it comes to assignment design and maximizing participation.

Just before our December 2012 cohort began, I was desperately seeking a simple way to give faculty a big-picture view of everything they could accomplish during DOTS. For years, we’d been giving faculty clear assignment instructions and checklists to help them stay on track, but we lacked a single place in the course where they could see all of the assignments at a glance. This left many faculty feeling unclear on just how DOTS was going to help them get a jump start on essential course-building tasks. The pieces were all there, but with no way to see how everything fit together and track their progress, the assignments felt disconnected and faculty weren’t particularly motivated to share their latest triumphs.

To solve this problem, I wanted to tap into two commonly used elements of game design that increase player motivation: progress indicators and competition. I’ve been a fan of applying game-design principles to education since my grad-school days, but figuring out how to make them work under tight deadlines has always been a challenge. In addition, I knew anything I used in DOTS needed to serve as an attainable model that our faculty could use themselves.

My initial fantasy was to create beautiful badges through Mozilla’s open-badge initiative, manually review every assignment each participant submitted, and then award badges and display them on some dedicated, private website that didn’t yet exist. I researched open badges, but realized quickly that it would take far more time than I could afford to invest, particularly for a new experiment that the DOTS participants might wholeheartedly reject.

So I went back to my essential requirements. I needed a way for each participant to see all of the assignments at a glance, view his or her progress, and stay motivated by seeing how that progress measured up against the rest of the class. And, ideally, I wanted the identity of each participant to remain confidential so that no one would feel humiliated for falling behind.

In the end, I decided I could accomplish all of these things with a simple online spreadsheet. You can see a noneditable copy of the final spreadsheet here.

I began by listing “code names” for all of the participants in the leftmost column. Because we had a large group of English faculty in our December cohort, I decided to use the names of famous authors. Then, across the top row, I created color-coded levels of achievement that also incorporated the literary theme. In each module, as participants completed new tasks, they were given the same set of instructions:

  • Open the spreadsheet.
  • Find their code name and locate the next empty cell in their row.
  • Select their latest achievement from the drop-down menu in each cell. (See Figure 1.)
  • Revel in their latest accomplishment and daydream about how they’ll spend their billions when they reach J.K. Rowling status.

spreadsheet
Figure 1

Because I wasn’t sure if the participants would actually use the spreadsheet, they weren’t required to prove they’d done something before adding it to the spreadsheet. In the end, I was surprised to see how many of the participants regularly updated it and how many reached the highest levels. It was a pleasant surprise, to be sure, but I’m now considering how to up the ante for our next cohort. One option would be to require that faculty show off their work on a designated discussion board for all their peers to see before they can check off an item on the spreadsheet. This might reduce some of the anonymity of the code names, but it should provide an added incentive to encourage sharing and peer feedback—something I’ve always had trouble fostering in the past.

At first, I was a bit embarrassed that my candy-colored Google spreadsheet was such a far cry from the sophisticated digital badges and personalized achievement pages I had envisioned. When I mentioned this to a friend who works in software development, where a rapid cycle of feedback and revision is the norm, she said, “If you’re not embarrassed the first time you show something new to other people, you’re waiting too long to share it.” It’s a mantra that could easily be applied to any attempt at innovation in education. My little experiment exceeded expectations and even got some faculty thinking about how game principles can be applied in relatively simple ways to motivate learners without increasing instructor workload. It was an achievement that made me feel like I’d “leveled up” myself, although J.K. Rowling status remains, for the moment, just a distant, purple dream somewhere on the horizon.

Avatar photo

About Daniel Stanford

Daniel Stanford is a Learning Design Consultant and former Director of Faculty Development and Technology Innovation at DePaul University's Center for Teaching and Learning. His work in online learning has received awards from the the POD Network, the Online Learning Consortium, NAFSA, the Instructional Technology Council, the University of Wisconsin, and Blackboard Inc. Follow @dstanford on Twitter | Connect on LinkedIn |

3 thoughts on “How a Spreadsheet Helped 90 Percent of My Students Earn a Pulitzer

  1. Interesting post, Daniel. I like how you made what would have ordinarily been a boring spreadsheet come alive using game design principles. But I have to take issue with your choosing J. K. Rowling as a barometer of success. What about the Nobel Prize for Literature? :)

  2. Thanks, Joe! The use of J.K. Rowling for the top level was actually something one of the participants did. I’m sure his intention was to add a little levity to the “levels” and not to imply that we should all aspire to write the next Harry Potter. One of the challenges with giving all students editor permissions is you open the door to all sorts of changes you might not have expected. From this experience, I could probably write another blog post about the pros and cons crowd sourcing and turning over control to your students.

Leave a Reply

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