Greetings,
My spreadsheet contains 500 students categorized by random identification numbers (i.e. ‘random_id’ =366). The three columns of concern in the spreadsheet are: ‘student#’, ‘question_id’, and ‘q_correct’.
First, can I assign the random student IDs a standard value starting with 1 (i.e. 366=1, 368=2….4000=500)?
On the second sheet (see attached), ‘Item Response’, I would like to tabulate which questions each student got correct; 1=correct, 0=incorrect. I have manually entered student 1 and 2s responses to demonstrate.
Other information; there are 314 total questions in a database and each student will take an exam with 70 questions and I would like to leave blanks where there was no response.
Thank you for your time!
Last edited by gradstu2010; 04-01-2010 at 01:50 PM.
Here's a possible solution using sumproduct. Perhaps unnecessary complicated (?), but seems to do the job.
By the way, it would probably be better to just use a pivot table.
You are right; the formula may be unnecessarily long, but it seems to do the job. I am learning more about pivot tables.
Thank you for the quick response!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks