A Feedback Loop for the Classroom
    - Test Analysis a la Ruth Hoffman
                                      -- Agnes Azzolino


     
Pre Session Warm Up Activities & Questions
There will be a quiz.
The quiz will cover order of operations and basic statistics.
1. Get a cheat sheet to use to study before the quiz.
2. Get ready for the quiz by thinking about what it might cover.
3. Introduce yourself to those around you and discuss the answers to what might be on the quiz.

    Text   Spreadsheet    

This page mathnstuff.com/papers/amtnj1b.htm.
The book version of this page is mathnstuff.com/papers/craft/c26.htm.




























This Stuff Is On The Quiz.

    Text   Spreadsheet    
































The Quiz

    Text   Spreadsheet    

































Growth Reflected in Dark Green Cells

    Text   Spreadsheet    
































Even Partial Credit May Be Analyzed

    Text   Spreadsheet    
































Some Things Good Teacher Pay Attention To

    Text   Spreadsheet    
































Answers to the Quiz

    Text   Spreadsheet   stdev  
































Compute Points & Percent

    Text   Spreadsheet    
































Compute Points & Percents For Each Student

    Text   Spreadsheet    
































Compute Percent of Mastery on Each Question

    Text   Spreadsheet    
































In the Larger Picture: Compute the Mean

    Text   Spreadsheet    































In the Larger Picture: Compute the Standard Deviation

    Text   Spreadsheet   stdev    
































A Cheat Sheet of Excel Formulas is Provided

    Text   Spreadsheet    
































Color Code Full Mastery, Partial Mastery, No Mastery

    Text   Spreadsheet    
































Sort Students Based on Their Performance

    Text   Spreadsheet    
































Sort Questions Based on % of Mastery by Students

    Text   Spreadsheet    
































Use Z-Scores to Analyze Student Performance or Quiz Mastery

    Text   Spreadsheet   stdev    
































All the Components Make A Full Picture

    Text   Spreadsheet    
































It's Time to Analyze Our Quiz

    Text   Spreadsheet    
































Debrief


Syntax Statistics Teaching Practices Excel Use


    Text   Spreadsheet    





























Index     Text   Spreadsheet  
[MC,i. Home] [Table] [Words] Classes [this semester's schedule w/links] [Good Stuff -- free & valuable resources] spread sheet notes
© 2011, Agnes Azzolino
www.mathnstuff.com/papers/amtnj1b.htm