# 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 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 syntax Statistics mean standard deviation z-score Teaching Practices Some Things to Pay Attention To When Grading A Test Excel Use formulas sorting shading

Text   Spreadsheet

Index
• Pre Session Warm Up Activities & Questions
• This Stuff Is On The Quiz.
• The Quiz
• Growth Reflected in Dark Green Cells
• Even Partial Credit May Be Analyzed
• Some Things Good Teacher Pay Attention To
• Answers to the Quiz
• Compute Points & Percent
• Compute Points & Percents For Each Student
• Compute Percent of Mastery on Each Question
• In the Larger Picture: Compute the Mean
• In the Larger Picture: Compute the Standard Deviation
• A Cheat Sheet of Excel Formulas is Provided
• Color Code Full Mastery, Partial Mastery, No Mastery
• Sort Students Based on Their Performance
• Sort Questions Based on % of Mastery by Students
• Use Z-Scores to Analyze Student Performance or Quiz Mastery
• All the Components Make A Full Picture
• It's Time to Analyze Our Quiz
• Debrief
• Index
Text   Spreadsheet
 © 2011, Agnes Azzolino www.mathnstuff.com/papers/amtnj1b.htm