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

Getting Started: Excel Projects

To create your benchmark assignment, you'll be using Excel. There are 2 projects that will help you review various features of Excel. First you'll be creating an interactive gradebook. Second you'll be using ISAT data for a 4th Grade class to work on measures of variance and central tendency. They projects do overlap, you learn the skill in the gradebook since it matches the screencasts I've made, then you practice on the ISAT data on your own to make sure you can do it. You don't have to do both if you feel you have got the process down...I'm not collecting either in the Course by Arrangment...it's for your knowledge / skill development. If you're already doing great with Excel...you can breeze through these and jump straight into the final benchmark assignment.

Download the Excel Project Sheet from the resources, left side of blog, to create the Interactive Gradebook. The next few screencasts will walk you through the process.

Randy
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)