Quiz Banker

Last year, I created a prototype of a tool that takes Google Documents linked from a spreadsheet and merges them together. During the summer, Frandy and Erik from our Data and Systems team along with some other members of the Cloudlab team at New Visions for Public Schools upgraded the tool into a Google Sheets Add-on. We gave it the name Quiz Banker.


The goal of this work was to take a repetitive task that almost all NY State public school math teachers do, which is to merge and typeset items from Regents exams, and greatly reduce how long this task takes, thus saving teachers time to do other more important tasks. We can easily typeset Regents questions centrally at a fairly low cost, and then a tool like Quiz Banker makes it easier for teachers to work with those typeset questions.

During the summer we asked teachers how long it would normally take them to take all of the Regents questions associated with a particular domain of mathematics and typeset them into the same document. Answers from teachers ranged from 5 minutes to 8 hours with most teachers estimating about an hour. When we demoed Quiz Banker, it took 2 minutes to accomplish this task, including the time spent installing the add-on.

During the summer suggestion I told teachers, “If it used to take you 40 minutes to create a quiz and now it takes 2 minutes, use those 38 minutes you saved to make sure that quiz assesses what you want it to assess.” As Patrick Honner notes frequently on his blog, not every Regents question is of equal quality.

Having a question typeset also means you can easily modify a multiple choice question into a more open-ended question, modify the language of a question to get a slightly different mathematical idea, or just increase the font-size so that students with differences in visual processing are able to read the question.

QuizBanker also includes meta-data like what Common Core Domain, Cluster, and Standard to which each question is aligned as well as alignment to the Units and Big Ideas in the New Visions’ Math Curriculum. This further reduces how long it takes teachers to aggregate those questions usefully.

Quickly filtering for question type


More broadly I believe that if teachers are going to work on changing their teaching, this takes time, but time is a fixed quantity. The cheapest way to give teachers more time to work on improving their teaching is to take repetitive and time-consuming tasks they do and change the amount of time spent on these tasks either by eliminating those tasks altogether or by reducing how long the task takes to do.

What other tasks do you see math teachers doing frequently that could save time if there was a tool that made that task easier and faster to do?


Approximating Teaching Practice

When someone is learning a new practice, it is common to isolate that practice from other elements of the greater body of work they are also learning. For some areas of learning, this is easier to do than others. For example when learning how to play the piano, one can reasonably easily practice scales and […]

How to use technology with only one computer

A very common situation in many classrooms is that there is only one computer and it is usually attached to a projector. How can one meaningfully use technology under these circumstances?     Here is a strategy that may help when you want students to use an interactive tool but either have limited access to […]

Responding to Student Mistakes

A while ago, I had something very similar to the following shared with me. The student was given the diagram and asked to find the measure of the angle marked with the question mark. The student has clearly made a mistake. Why did they do it? I asked on Twitter and here are some theories: Using […]

Online Practice is Terrible Practice

One of the ways computers are being used in math education is to provide students with online practice. There are a bunch of serious problems with most of these programs.   Here is one example from the Khan Academy (apparently at least one of the flaws outlined below no longer applies to the Khan Academy. […]

10 things that might actually disrupt US education

There’s a list being shared of ten things that will disrupt US education and I agree with Dan Willingham. My bold prediction: none of these 10 will disrupt education. None. https://t.co/pUAtmUOK7E — Daniel Willingham (@DTWillingham) October 16, 2017   In no particular order, here are ten things that might actually disrupt US education.   Teachers […]

A Conference Experiment

My colleagues have long been frustrated sharing our work at conferences primarily because the work we do is complex and hard for people to understand thoroughly within the constraints of a conference session where we only have at most 75 minutes to work on an idea. So we contacted the organizers of the two NCTM […]

Questions about Curriculum

Here are some questions that I ask myself whenever I read through a mathematics curriculum:   • Does this curriculum assume that children will forget ideas over time? • Does this curriculum provide instructional supports that increase the odds that all children have access to it? • Does the curriculum assume all students are capable of […]

Mathematical Representations

There is evidence that students who have access to and understand how to use different mathematical representations of the same mathematical concepts are more successful learning mathematics than students who only have access to one representation type. The issue is that mathematical representations are not intrinsically meaningful on their own. Some mathematical representations are completely […]

Teaching to Big Ideas

On Big Mathematical Ideas, Cathy Fosnot writes:   Underlying these strategies are big ideas. Big ideas are “the central, organizing ideas of mathematics—principles that define mathematical order”(Schifter and Fosnot 1993, 35). Big ideas are deeply connected to the structures of mathematics. They are also characteristic of shifts in learners’ reasoning—shifts in perspective, in logic, in […]