This page was created April 16, 2005 and last updated: October 25, 2007
We continued to explore using Excel to create and analyze data. Children created bar graphs to compare their own pulse rates with the pulse rate of a partner. Pulses were taken and recorded on a table at different times during the course of a day and after 2 different gym classes.
The bar graph was completed as a performance task; children independently created the graph in Excel using a written checklist. No oral directions were given to them by me! I am very proud of each child’s growing ability to use the technology with confidence and competence.
Pennsylvania Academic Standards continued to be met with this project:
* 2.6.5 Statistics and Data Analysis
* 3.3.5 Biological Sciences (Science textbook support Unit F)
We first multiplied our weight (or the weight of our pet) by hand, using the decimal that would allow us to see what our weight (or our pet's) would be if we lived on another planet. We checked that multiplication with a calculator, and then explored how Excel can perform this simple function. Inserting the formula was very easy... once we knew how! Ah, but we weren't quite done!
We searched on the Internet for planet clipart. Working between our Excel chart and the clipart web site, we inserted images of the planets into the bars of our graphs. We learned how to scale the images to fit the bars,reviewed using the Chart Wizard tool, and independently created the graphs using a checklist prepared by Mrs. Dingman.
Enjoy these amazing graphs!
Pennsylvania Academic Standards continued to be met with this project:
We surveyed our classmates to find out about some of our summer activities. We created bar graphs, using Excel, to show the results of our survey. We were introduced to the Chart Wizard and learned how this tool can make creating graphs very easy! Ahhhh ... but, we weren't done...
We searched online to find clipart images to insert in the bars of our graphs, complimenting the survey question results we chose to graph. We were excellent listeners and carefully followed Mrs. Dingman's oral directions to insert clipart we saved from our Pictures folder and were introduced to another fabulous Excel feature. We learned how to stack and scale the images to fit perfectly into the bars of the graph.
We enjoyed using the laptops to begin our graphs and our new Promethean board made following the steps to create our graph very easy!
Pennsylvania Academic Standards continued to be met with this project:
There are 15 states in our country that have a town named Milford. We tracked the temperature over a one-week period, using several online weather web sites, and recorded the daily temperature for the Milford we live near and a Milford located in another state.
Using Excel, we created double bar graphs to display our temperature comparison data. We easily and effectively used the Chart Wizard and carefully followed the checklist prepared by Mrs. Dingman to insert patterns within the bars.
Our bar graphs were created as a performance task assignment, as we followed our checklists independently and with confidence. We reviewed finding mean, median, and mode, as well as declarative and interrogative sentences, as we wrote statements and questions about the data collected.
Enjoy our Excel-lent graphs!
Pennsylvania Academic Standards continued to be met with this project:
2.3.5 Measurement and Estimation
2.4.5 Mathematical Reasoning and Connections
2.5.5 Mathematical Problem Solving and Communication
We created fall-themed questions and surveyed our classmates to find out about their interest in some of our favorite fall activities. We created bar graphs, reviewing the Chart Wizard in Excel, to show the results of our survey. Ahhhh ... but, we weren't done...
We searched online to find clipart images to insert in the bars of our graphs, complimenting the survey question results. We were excellent listeners and carefully followed Mrs. Dingman's oral directions to insert clipart we saved from our Pictures folders. And, we were introduced to another fabulous Excel feature. We learned how to stack and scale the images to fit perfectly into the bars of the graph. Enjoy our Excel-lent graphs!
Pennsylvania Academic Standards continued to be met with this project: