Multiple choice quiz grading (true +1p, false -0,5p, blank +0p)

[lauriten]

Hello,

my problem is following:

I have a quiz with 40 questions and with only 1 correct answer for each question. My students will submit their answers on paper and I would like to input them into excel in order to produce statistical data swiftly. I am unsure about implementing this, because scoring on answers varies:

• Correct answer +1p
• False answer -0,5p
• Blank answer +0p

This is my initial plan:

Which formula or formulas should I use here? Currently there is no formula for the points column as I just wrote in the scores to demonstrate my problem. Any help is appreciated!

Br,

-lt

 

[Scott Huish]

By False answer, I am assuming you mean incorrect answer:

Excel Workbook
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2		Correct Answers						Students Answers
3
4			A	B	C	D			A	B	C	D	Points
5		1	x					1	x				1
6		2		x				2					0
7		3				x		3			x		-0.5
Sheet1

 

[Smitty]

Welcome to the Board!

Maybe something like this:

=IF(COUNTA(I5:L5)=0,0,IF(MATCH("x",C5:F5)=MATCH("x",I5:L5),1,IF(MATCH("x",C5:F5)<>MATCH("x",I5:L5),-0.5)))

HTH,