One of my 3 sections took the Chapter 1 Test today.
I had no problem accessing the students overall grades but when I downloaded the “other” spreadsheet breaking the test down by individual responses, I was looking for an easy way to access summary statistics by question. I already have a “work-around” to summarize with a bar graph for each question but as you can imagine, it’s a copy paste, click click click click work around. Call me high maintenance. Sorry.
Are there are plans to summarize class results by question?
A simple bar graph by question would be perfect.
Thoughts?
I’m pretty savvy with spreadsheets but I couldn’t wrap my head around a quick solution to summarize by question based upon how the spreadsheet was laid out. Thoughts?
I am willing to root for the Bears if Baker has a quick solution between diaper changes. HA
This is what I did on the Mac . Refer to the picture I attached in my reply above.
Select all the cells in the table
From the Data menu select Pivot table. It will ask you where you want to create the Pivot table. Select your destination
A black window shows up to select the rows and columns to be included in the table summary. My picture above shows the black window and the selections I had made.
Under Field name, select Question and Correctness
In Column Labels drag in Correctness
In Row Labels drag in Question
In the Values box you will need to drag Correctness, if it is not already in there. If it is already there you can click on the ? and change it to count Correctness.
The Pivot table is live, you will need to make a copy of its values into a new sheet.
Select the columns you want included in a bar chart and plot.
