Using Excel to Individualise Basic Mathematics Assignments

Date Added: Jun 2009
Format: PDF

This paper sets out a method for creating and marking individualised mathematics assessments for students based on their ID numbers. It therefore provides a means for setting assessed coursework questions that give students the incentive to put in the practice needed to master mathematical techniques without the risk of collusion between students. A marking grid can then be constructed using only basic Excel skills. The method is explained here in the context of basic mathematical techniques applied to economics, but it can also be applied to other academic disciplines that involve numerical problems.