Basic Techniques in Using Excel to Analyze Assessment Data

In this workshop you will learn basic techniques to enter data into Excel; check for data-entry errors; summarize questionnaire data, test scores, and rubric ratings using formulas and charts/tables.

PowerPoint and Handout
Excel file example1 and example2
Workshop Evaluation Report

What do you do after you collect valuable feedback and information on student learning outcomes through questionnaires, quizzes, and/or rubrics? This workshop will share basic and useful techniques to organize, clean, and analyze data using Microsoft Excel.

Level: Beginner
Format: Demonstration + hands-on practice
Requirement: Please bring a laptop with Microsoft Excel installed (Version 2007 and 2010 are preferred)
Date/time/location: Thursday, November 15, 2012, 1:00-2:15, KUY 106