
Spread Sheet: Counting Shapes
As I was reading about using spread sheets in a classroom, I thought "No way that will never work for Kindergarten students!" Well I was wrong. Spread sheets can be as simple or as complex as you make them. When I thought more about it we use spread sheets all the time in the classroom, graphing hair color, how we got to school, how many boys or girls their are, etc., but these spread sheets are not on the computer.
When I started to create my spread sheet for our Shape Exploration unit I began simple. I "played" with the options on the Microsoft Excel program. Then I got brave and that's when I came up with my final product. What I created was a spread sheet to go along with classroom learning experience.
The students will first have a bag of shapes they must sort out by geometric shape, which connects to my overall unit objective Given a set of eight shapes (C) kindergarten students (A) will be able to identify basic geometric shapes (B) with 95% accuracy. The students will then count out the number of each shape and enter those numbers into the spread sheet. This step addresses two of my overall unit objectives, Given five different numbers (C) kindergarten students (A) will match them with corresponding set of objects (B) with 95% accuracy and Given different amounts of set shapes (C) kindergarten students (A) will be able to form the correct number without a model (B) with 95% accuracy. Upon completion of these steps that student will work collaboratively with another student to enter another set of numbers into a different column on the spread sheet. While the students is working on entering numbers into the correct cells, on the right a bar graph is building to visually show the students the difference between the numbers.
There are oodles of different ways that a spread sheet can be used in the class room. A spread sheet can not only be used as a lay out for a student experience but also to make the teacher's life a little eaiser. This
web site show both sides to a spread sheet and gives examples on how both teachers and students can use spread sheets.