1 / 17

USING EXCEL TO INDIVIDUALISE BASIC MATHEMATICS ASSIGNMENTS

DEE Conference, Cambridge, Sept 2007 Mike Rosser Department of Economics, Finance and Accountancy Coventry University Coventry CV1 5FB UK m.rosser@coventry.ac.uk. USING EXCEL TO INDIVIDUALISE BASIC MATHEMATICS ASSIGNMENTS.

oshin
Download Presentation

USING EXCEL TO INDIVIDUALISE BASIC MATHEMATICS ASSIGNMENTS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DEE Conference, Cambridge, Sept 2007 Mike Rosser Department of Economics, Finance and Accountancy Coventry University Coventry CV1 5FB UK m.rosser@coventry.ac.uk USING EXCEL TO INDIVIDUALISE BASIC MATHEMATICS ASSIGNMENTS

  2. Individualised questions are created for each student based on their ID number All students get same assessment sheet, but letters represent digits in ID number An easily readable answer grid for manual marking is generated via Excel. Note: This presentation just summarises method. See paper for specific examples and formulae. Overview of Method

  3. Students need to practise examples to develop their mathematical skills. Weaker students are often reluctant to put in the effort required unless their work is assessed. Collusion is likely if students are set the same questions for coursework. Rationale

  4. Manual marking is relatively quick but still gives students feedback on specific errors. Can ask students to interpret results. Can set more time consuming questions than in time constrained or on-line tests Can include problems requiring students to construct their own spreadsheets Other Advantages

  5. Following Coventry 2006 degree revision: Mathematical Techniques taught to all Yr 1 Economics students in same module Most do not have A-level Maths, some have weak GSCE Maths, so a very mixed ability group Accountancy students also attend term 1, which focuses on financial mathematics Background

  6. Objective to get all students practising worked numerical examples. Used in lectures and formative practice questions, as well as the summatively assessed individualised questions Approach based on Mike Rosser (2003) “Basic Mathematics for Economists” 2nd Edition, Routledge Teaching Philosophy

  7. Use Excel to convert ID number to digits Specify letters B to H in questions instead of numbers (Col A used for ID). For example : If question specifies TR = 5EFq – 1Gq2 For student ID 1234567 TR = 545q– 16q2 (Note the mix of numbers with letters.) Converting student ID numbers

  8. To ensure acceptable values for students’ answers, some actual numbers may be used with the letters representing ID digits. For example, for student ID 0000007, if digits DE represent the interest rate in an investment problem, a rate of 0% may lead their calculations into a dead end If interest rate is specified as 5.DE% then this student would use 5.00% in his problem. Dealing with Student 007

  9. Excel can convert ID numbers to individual digits by dividing by 10, 100, etc., and rounding down. ( One off task) Parameters can then be created by multiplying by 10, 100, etc. For example, for An amount invested £8FGH =8,000 + 100 x 5 + 10 x 6 + 7 = £8,567 From Digits to Question Parameters

  10. Before producing Answer Grid, best to create “Full Workings” page, with columns showing: Actual numbers created for each student ID Intermediate steps in complex answers For students who get answers wrong, this will enable tutor to check: If students started off with the wrong number At what stage answer started to go wrong. Full Workings Spreadsheet Page

  11. From the tutor’s perspective, perhaps the most difficult task is devising an Excel a formula that will provide the mathematical solution to each question For most teachers of mathematics for economists this will not be too difficult a mathematical challenge Can devise formulae based on standard algebraic solutions to mathematical economics problems. Calculating Answers

  12. For demand function P = 2CD-E.5Q and the supply function P = 2F+ 3.G Q find equilibrium price P and quantity Q. When full list of ID numbers is pasted into column A the formulae for the numbers each student uses and their answers can then be copied down the worksheet page Example : Full Workings

  13. Need to eliminate intermediate stages to get answers to fit on one page Make second worksheet page and delete unwanted columns off Full Workings to get: Answer Grid

  14. First few columns shown (with fictitious IDs) Includes spreadsheet investment problems. Illustrates range of numeric answers Answer Grid – Coventry Assignment 1 Example

  15. Manual marking of method relatively quick if answers are correct If answer incorrect the tutor can use Full Workings to help check if error not obvious Allows feedback on where went wrong Can over-ride and type in if student inputs a wrong digit ( and adjust mark appropriately) Marking Students’ Work

  16. June pass rate up from 69% to 80% Student survey satisfaction with assessment methods 81% Several students made basic errors Eg plus/negative signs mixed up Manual marking allowed feedback on where students need to improve / take more care Evidence - Coventry Results

  17. First Coventry trial of Excel generated maths for economists individualised questions has shown some success in pass rates. Lessons have been learned from the experience in setting questions, constructing and using the Answer Grid Method will be used again and refined. Feedback from others using it are welcomed. Conclusions

More Related