I like giving students randomized assignments. That is, I like assignments where they all get the same questions, but different numbers. That way, they can collaborate, but have to ask “how did you solve that question?” rather than “what did you get for that question?”
Years ago I tried out Webassign, and I liked the way it built algorithm-based questions. But I don’t have it, and I don’t have money in the budget to pay for it. We use Blackboard as our LMS, and it too has algorithm questions, but the format is kludgy at best. It uses a Java based visual equation editor, which has issues with parsing complex equations, rather than plain text entry. It is so cumbersome I gave up on it. I have Wiley Plus with my senior Physics textbook, which is great, but it doesn’t help with any of my other subjects.
In terms of online resources, I am short of easy and cheap options. But who said it had to be online? I have plenty of tools available right on my laptop that will do the job just fine! Here is how I create personalized, randomized numerical assignments for my students:
Basically, I create a set of questions, then use a spreadsheet to generate random numbers and solutions for those questions. Mail merge tools can then be used to import the randomized numbers into the questions. I use Excel and Word, but any spreadsheet and word processor should do the job.
Let’s step through the process, examine the formulas, and then you can make your very own! To begin, we need a question. For this demo, we will pick something fairly simple. Normally I include 5 or 6 questions in this type of assignment, but we will use one to illustrate. How about
Three light bulbs are connected in parallel. The first has a resistance of [R1]Ω, the second has a resistance of [R2]Ω and the third has a resistance of [R3]Ω. The total voltage for the power supply is [V]V. What is the current in the circuit?
Now we have a question, we need to set up our spreadsheet. I set mine up like this:
Then I decide on my max and min values, and enter them.
Then comes the magic:
To explain briefly, this formula grabs the max and min values, and generates a random number between the two, and rounds that number to the number of decimals required. The dollar signs in front of the cell numbers indicate that the formula must always grab those top three numbers for calculating, that way I can copy the formula anywhere, and it will always work. Here is what it looks like copied to the other cells:
Note that the column (letter) changes in the formula, but the row (number) remains the same. That’s the dollar sign at work.
Next we need a formula for the answer:
Now we are almost ready, but there is one last step. The RAND() function will regenerate random numbers every time the spreadsheet is opened, and every time you modify a cell (note how the values are different in the last two images). So if you want a static set of numbers that will remain the same no matter how many times it is accessed, you need to create one. I copy the excel table (minus the top three rows) and paste it into a word document. Really, any type of document would do, Word can use a spreadsheet, text file, word document, database, or just about anything as a data source.
Now we turn our original question(s) document into a mail merge, define the static data table as the mail merge source, and insert the merge fields for the placeholders we left in the question. We can even insert the student’s name, to personalize it:
And for me, I use a separate mail merge document to generate a table of answers for each student into a master answer sheet:
(For organization purposes, I tend to name my files similarly, like AssignmentX.doc, AssignmentXnumbers.xls, AssignmentXstaticNumbers.doc, AssignmentXanswersheet.doc, and place them in a folder of their own. )
On the assignment sheet itself, I usually include two rows of answer boxes, labeled “1st try” and “2nd try”. If my goal is to get students to understand how to solve these problems, I want them to retry any questions they get wrong. Having answer boxes on the sheet means scoring (marking, grading, whatever term you like) the assignments is easy – they hand me the assignment, I check the answers against my master answer sheet, record their score on my sheet, and hand it back. Maybe 20 seconds per student.
These assignments have a lot going for them – they allow students to collaborate, they offer immediate feedback, they allow students to correct – or at least attempt to correct – their mistakes, they are kind of fun to make, and they are dead easy to mark (grade, score, whatever…). There is some up-front time creating them, but they save loads of time at the other end, and once you have them, year after year you can just drop in the names of your new students, and prep time is minimal. It is used offline – no risk of network issues – and it is free. Even if you don’t have Word and Excel, you can do the same thing in OpenOffice, which is free. So all around, this type of assignment has lots going for it. Really, the only shortcoming is that these are not open-ended inquiry assignments – but then, they are not intended to be the only type of assessment, just one of many.
Try it, and let me know how it works out. Also, if there are any GoogleDoc wizards out there who might know how to create an online version, I would love to hear from you!