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.

• Introduction Screencast: http://www.screencast.com/t/tyA79p9K

• Data set for gradebook: http://myclass.nl.edu/tie/tie533/Excel_project.doc

• Tutorial 1: http://www.screencast.com/t/KynTTk6YF

• Tutorial 2: http://www.screencast.com/t/GO3mBsPj

• http://myclass.nl.edu/tie/tie533/CentralTendenciesClassAssignment.pdf