treyhowell
Level 1 (4 points)
iWork

Q: 'Questions students missed the most' graph

I'm a math teacher, and want to get a graph and some stats about which questions were missed, and have a nice visual graph of that and get some statistics from there. I'm having trouble getting this done, not sure if I'm missing the wrong template or if I'm formatting the sheet incorrectly. Any suggestions?

MacBook Pro with Retina display, iOS 10

Posted on Sep 18, 2016 10:51 PM

Close
treyhowell

Q: 'Questions students missed the most' graph

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Sep 19, 2016 5:25 AM in response to treyhowell
    Level 6 (19,141 points)
    iWork
    Sep 19, 2016 5:25 AM in response to treyhowell

    I suggest starting with something like this:

    Screen Shot 2016-09-19 at 7.18.14 AM.png

     

    the first row is a header row

    the last two rows are footer rows.

    Screen Shot 2016-09-19 at 7.24.36 AM.png

     

     

    enter the students names in the first column and format the cells for each question as a checkbox

     

    In the footer rows (row 10 and 11 in this example) the totals will be created by using formulas.

    B10=COUNTIF(B, TRUE)

     

    this is shorthand for... select cell B10, then type (or copy and paste from here) the formula:

    =COUNTIF(B, TRUE)

    B11=COUNTIF(B, FALSE)

     

    select cells B10 and B11, copy

    select cells B10 thru the end of column 11, paste

     

    select ROW 11 and add the 2D column chart

    now adjust as needed