Determine which students solve given quiz problems correct

[csarami]

Hi,

For a particular multiple choice quiz with 33 problems, I need to create a table where

- first column is student names

- the top row ( header) is the problem number with columns: 1, 2, ...33.

I need to fill out the table cells as follow:

if student i (say #3) solve problem j (say #10) correct, we Mark 1 in the cell (row =3 , column = 10) for the correct answer, 0 otherwise.

I tried both item analysis and student analysis. Neither of them contains information on whether a student solves a particular question correctly or incorrectly.

Any help would be much appreciated.