Form Return – Quick Plots

In a previous article you were introduced to Form Return. In this short article, you will see some of the immediate results you can produce from the raw data captured using Form Return answer sheets.

Each of these graphs or tables only tells a small part of the story. The more detailed analysis and statistics will be the subject of a future article. These graphs do not necessarily indicate a problem with a question but may suggest a question (or answer key) deserves a second look. 

Figure 1: Frequency of student responses for a multiple choice question, n = 28. Correct answer in light blue. Graphed in Excel.

Figure 2: Frequency of student responses for a numerical response question, n = 28. Correct answer in light blue. Graphed in Excel.

Figure 3: Plot of student final exam grades (%) sorted from highest to lowest. Does not include Written Response scores. Graphed in Excel.

Student ID	U1 Exam	U2 Exam	U3 Exam	U4 Exam	Final Exam
id1	33.3	56.0	22.2	21.1	29.1
id2	58.3	36.0	44.4	31.6	36.4
id3	75.0	96.0	66.7	78.9	69.1
id4	91.7	84.0	33.3	63.2	67.3
id5	70.8	76.0	44.4	84.2	60.0
id6	70.8	56.0	55.6	57.9	25.5
id7	75.0	88.0	83.3	78.9	61.8
id8	70.8	92.0	61.1	78.9	69.1
id9	62.5	56.0	44.4	73.7	27.3

Table 1: Marks (%) from all exams in a course can be linked by student ID. Data shown here does not include written response scores.