How to do test result analyses

Why  

Test result analyses help you to find the answer to the following questions: 

1. To what extent to my students master the individual learning objectives? This helps you to adjust the rest of your course or to improve next year’s course. 
2. What was the quality of the individual (sub)questions or criteria? This will help you adjust the answer model / grading per criteria for this group of students, and improve the questions and course for next year. 
3. What was the quality and difficulty of my assessment as a whole? This will help you decide if you need to adjust the grades as a whole.  

Guiding principles 

The main quality requirements for assessment are validity, reliability and transparency.  

General information on test result analysis 

General information on test result analysis can be found in the TU Delft Assessment manual in chapter 3.  

How to do test result analysis in existing tools 

Assessment tools do their own test result analyses. Here are links to information pages on this: 

• Brightspace assignments 
• Brightspace quizzes 
• Ans 
• Möbius: how to export data to Excel 

How to do test result analysis using spreadsheets 

There are Excel files available to do test result analyses for projects/large assignments, and for e.g. handwritten exams. They can also be used to analyse date from e.g. Möbius in more detail. Per type of spreadsheet, an example and an empty version are available below. 

Project/assignment: 

• Empty spreadsheet for projects/assignments 
• Example spreadsheet for projects/assignments

Exams: 

• Empty spreadsheet for exams in general 
• Example spreadsheet for exams in general 

Multiple choice questions: 

• Empty spreadsheet for multiple choice questions 
• Example spreadsheet for multiple choice questions