TIE533 Course by Arrangment: Interactive Gradebook Project

Overview

The overall project for this course is to learn more about using data to make important educational decisions. You’ll read articles on using data for decision making. For the final project you’ll be investigating an area of ‘need’ in your school, where collecting data and presenting it can provide guidance to solve the problem.

Most students use Excel to create a data collection / presentation tool. I’ve created several tutorials on how to use the basic / advanced features within excel. We’ll begin the class with the readings and Excel tools. You’ll have to determine the area you’re going to investigate / collect data with the new tool you’re going to build. There is a ‘benchmark assignment’ document (resource section) that will provide you with an overview of the final project. I’ve also included a link to Cindy’s final project for you to look over and get an idea what I’m looking for.

Let me know if you have questions. When you’re ready to begin, shoot me an email giving me a heads up.

Randy

Friday, July 22, 2011

Interactive Gradebook Project - builds basic Excel Skills

Topics/Activities - download the PDF of the activities

1. Review the Introduction

Unable to display content. Adobe Flash is required.

2. Website overviews of Central Tendency

Read through the following sites to review mean, meadian, mode, and range.

http://www.quickmba.com/stats/centralten/

http://cnx.org/content/m10942/latest/

http://www.une.edu.au/WebStat/unit_materials/c4_descriptive_statistics/central_tendency_measure.html

short video, for high school, but it’s a very simplistic overview of central tendencies

" target="_blank">http://www.youtube.com/watch?v=qw5aJEfqwfU

Be able to define / discuss what is each of these and why they are important statistical analysis of a data set:

mean

median

mode

range

3. Begin Interactive Gradebook project.

I've included an overview screencast of the interactive gradebook and 2 videos to walk through the first steps of the project. They can be found here:

Unable to display content. Adobe Flash is required.