Software Solutions
Viewing 0 reply threads
  • Author
    Posts
    • #1756
      MikeMike
      Participant

      Maybe I’m late to the game but I’ve been using Activexpressions for years and now with Classflow we can generate the same reports from online student assessments; however, I’ve always had to perform the item analysis by hand.  For instance, today I gave a practice ACT math test and I need to know how many times students missed each question.  Normally I’d have looked at the colors of the cells and counted them by hand – a tedious process with a 60 problem test and 20+ students.  Today the thought crossed my mind that Excel could do this for me in the report that’s generated.  I requested this inclusion years ago on the reports but I’ve finally thought to Google it and found the solution fairly painless.  For anyone interested you can find the directions from the link below.

      https://www.extendoffice.com/documents/excel/1155-excel-count-sum-cells-by-color.html

Viewing 0 reply threads
  • You must be logged in to reply to this topic.