Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use Excel to mark student's tests?
I have used excel to try and mark some tests for my students. I have their
answers on one sheet and then my answers on another sheet. I am trying to use an IF statement to mark the answers but its not working, can anyone offer any advice as to how I should go about this? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I use Excel to mark student's tests?
How is it that you want to mark them? One simple way of doing it would be
to use the following IF formula to compare answers on sheet one to sheet 2. Assuming there is a 20 question test, with each question being worth 5 points, you could have the formula return either a 5 or a 0....then simply sum up the total to determine the final grade. The points may be changed depending on the number of questions. =IF(A1=Sheet2!A1,5,0) Just click and drag the formula down for each question to be graded. I hope this helps "Brownsugar9686" wrote: I have used excel to try and mark some tests for my students. I have their answers on one sheet and then my answers on another sheet. I am trying to use an IF statement to mark the answers but its not working, can anyone offer any advice as to how I should go about this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Why not introducing worksheet for business students in MS EXCEL? | Excel Discussion (Misc queries) | |||
How do I make a water mark on an excel spreadsheet? | Charts and Charting in Excel | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) |