Module 6- spreadsheets and graphing

I think spreadsheets and graphs are a great tool for the classrooms. It allows student self evaluations as well as visual representing and organizing of knowledge and work. I would use a variety of reasons such as timelines, tracking grades, and simple graphing. I think graphs are a good information organizer for economical, marketing, and research projects (which integrates real life situations into the classroom). Spreadsheets are great for math in the areas of problem solving, organizing formulas, probability, and statistics.

I would introduce the use of spreadsheets through a three part module. The first part would consist of a tutorial, which would be set up as a class activity with the focus on learning the skills collaboratively. Using Excel projected onto a screen, the class would monitor the teacher's steps as they together create a spreadsheet. The students would choose a fun topic such as "planning a party" to make the learning more fun and interesting.

Module 2 would utilize the following online tutorial instructing students how to make a spreadsheet:

http://www.internet4classrooms.com/excel_enter_edit.htm (using an excel worksheet- Entering and Editing Data)

Module 3 would require the student to apply the new knowledge of spreadsheets for a math lesson. For example:

"The local zoo requires the purchase of new animals. You have a budget of $20,000 to spend. You can choose from a list of animals:

Zebras- $500 each

Lions- $900 each

Penguins- $399 each

Deer- $50 each

Monkeys-$319 each

Crocodiles- $495 each

Pandas- $1000 each

Flamingos- $298 each

You are required to decided and budget how many of each animal you would like to purchase.

In Excel create a spreadsheet using this data. Make sure you use a title and your name. You must include proper columns and rows (such as animal of choice, the price, amount of animals, sum of purchase for each animal, and total purchase.) Make note not to go over budget."

I would also require the students to hand in a summary explaining their choices.

Just for extra fun: We (Krystal Ingold and myself) found a great website for creating graphs. You should check it out!!!!

http://nces.ed.gov/nceskids/createagraph/

***Please note- I worked with my classmate, Krystal Ingold, on this assignment, therefore; there will be similarities within our blogs for this module.*

## 0 Comments:

Post a Comment

<< Home