Our most recent Excel project this year began our exploration of circle, or pie, graphing. We created a 2-column table to record purchases we thought we might like to make from our very own DDES School Store and the amount of money we might spend, up to $25.00, for those items. We learned how to create a circle, or pie, graph using Excel to display the items we might have chosen and the portion of the $25.00 each of our planned purchases would represent within our circle graph. We followed a written check-list to create our Excel-lent graphs, amazed at how similar the process was to our experience creating bar graphs with Excel. We learned how to insert patterns and change colors within each section of our circle graphs and are proud to have them displayed on our hallway bulletin board. Our confidence and competence with the technology just continues to grow!This project aligned with the following Pennsylvania Academic Standards:
1.6.5 Speaking and Listening
1.8.5 Research
2.2.5 Computation and Estimation
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
Listen to the Beat of Your Heart!
This page was created April 16, 2005 and last updated: January 28, 2010
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)
* 3.7.5 Technological Devices
rs.
ingman's
ifth
rade
xcel-lent
raphing
Planet Weights
How Much Do We (or Our Pets) Weigh on Other Planets?
Planet Clipart Courtesy of Jim's Planets
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:
2.2.5 Computation and Estimation
2.6.5 Statistics and Data Analysis
3.4.5 Physical Science, Chemistry, and Physics
3.7.5 Technological Devices
Summer Fun
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 quite 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:
1.6.5 Speaking and Listening
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
Where in the World is Milford?
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
2.6.5 Statistics and Data Analysis
2.11.5 Concepts of Calculus
3.7.5 Technological Devices
And the Survey Says... Fabulous Fall!
We began our second Excel project of the year and created fall-themed questions, surveying 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 quite done...We searched online to find clipart images to insert in the bars of our graphs, complimenting each of the survey questions asked. We carefully followed Mrs. Dingman's written checklist directions to insert the clipart images we saved from our "My Pictures" folder into each bar of our graphs, reviewing how to stack and scale those images to fit perfectly. This project was completed as a performance task. Very limited oral directions were given as we each carefully followed a written checklist to complete the steps creating our graphs. We enjoyed using the laptops to create our graphs and our competence and confidence using the available technology continues to grow! Pennsylvania Academic Standards continued to be met with this project:
1.6.5 Speaking and Listening
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
Going for Gold
We began our first Excel project of the year individually choosing 5 countries from a list of those participating in this summer's Olympic games. We visited the Beijing 2008 web site and researched the total number of gold medals earned by the countries we selected. We organized our data within a frequency table and began to create our Excel-lent bar graphs to display it. Mrs. Dingman introduced us to the Chart Wizard in Excel and we each created a bar graph to show the countries we chose and the gold medals earned. We learned how to adjust the graph's scale to display our data in its most easily read form. Ahhh... but we weren't done!We visited another online resource to select the flag images for each country we chose. Carefully following Mrs. Dingman's oral directions, we inserted the flag images within each bar of our graphs. And, we were introduced to another fabulous Excel feature when Mrs. Dingman guided us to "stack and scale" each image to fit perfectly within the bars of our graphs. We enjoyed using our new laptops to complete this project! And, our Promethean board made following the steps to create our graphs very easy! This project aligned with the following Pennsylvania Academic Standards:
1.6.5 Speaking and Listening
1.8.5 Research
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
Our second Excel project this year continued the Summer 2008 Olympic Games theme. We each chose our favorite Olympic sport from a partial list of those featured in this summer's Olympic Games. We conducted a class survey to see who shared our favorite sport opinions and recorded the survey results data in a table. Choosing 5 favorite sports from those survey results, we reviewed using the Chart Wizard in Excel and created a bar graph to show our data. We reviewed how to adjust the graph's scale to display our data in its most easily read form. Ahhh... but we weren't done!We visited Microsoft.com to select clipart images to compliment each favorite sport selected in our graphs. We reviewed the process to save each sport image to our "My Pictures" folder. We carefully followed Mrs. Dingman's oral directions, and inserted the sports clipart images within each bar of our graphs, reviewing "stacking and scaling" each image to fit perfectly. We continued to enjoy using our new laptops to complete this project! And, our Promethean board made following the steps to create our graphs very easy! This project aligned with the following Pennsylvania Academic Standards:
1.6.5 Speaking and Listening
1.8.5 Research
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
... and the Survey Says...
Sensational Summer Olympics Sports
Homework? On Halloween?
Mrs. Dingman!! Seriously??
Our third Excel project this year continued our exploration of bar graphing. We sorted and counted our Halloween goodies and recorded the data in a frequency table. Using this data, we independently used the Chart Wizard in Excel to create bar graphs to show our "goodies" collected categories and amounts collected. We reviewed how to adjust the graph's scale to display our data in its most easily read form. Ahhh... but we weren't quite done!We visited Yahoo Shopping to select name-brand images to compliment each type of "goodie" represented in our graphs. We reviewed the process to save each image to our "My Pictures" folders. We carefully followed Mrs. Dingman's checklist directions and inserted the images within each bar of our graphs, reviewing "stacking and scaling" each image to fit perfectly. The bar graphs were completed as a performance task. No oral directions were given. We followed a written checklist to create our Excel-lent graphs with growing confidence and competence!We continued to enjoy using our new laptops to complete this project! And, our Promethean board continued to make following the steps to create our graphs very easy! This project aligned with the following Pennsylvania Academic Standards:
1.6.5 Speaking and Listening
1.8.5 Research
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
School Store Shopping
By popular request, project directions and scoring rubric now available.
Click HERE for more information.
When is YOUR Birthday?
We began our first Excel project of the year with a survey to find out in which month we each celebrated a birthday. 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 quite done...We searched online to find a birthday-themed clipart image to insert in the bars of our graphs. We carefully followed Mrs. Dingman's written checklist directions to insert the clipart image we saved from our "My Pictures" folder. And, we were introduced to another fabulous Excel feature. We learned how to stack and scale the image to fit perfectly into the bars of the graph. This project was completed as a performance task. Very limited oral directions were given as we each carefully followed a written checklist to complete the steps creating our graphs. We enjoyed using the laptops to create our graphs and our competence and confidence using the available technology continues to grow! Pennsylvania Academic Standards continued to be met with this project:
1.6.5 Speaking and Listening
1.8.5 Research
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
By popular request, project directions and scoring rubrics are now available.
Click HERE for more information.
Valentine Candy Hearts Fun
We continued our exploration of Excel-lent graphing with an introduction to circle, or pie, graphs, completing a performance task project that was fun and delicious!We reviewed fractional parts of a whole, sorting and counting the candy hearts by the colors we found in our individual boxes. We reviewed reducing those fractions, converting those fractions to decimals, and furthered our understanding of percentages, using a table to record and organize our information.We learned how to create a circle, or pie, graph using Excel to display the portion, or percentage, each candy color represented within our individual boxes. We reviewed how to insert patterns and change the foreground color within each section of our circle graphs, amazed at how similar this process was to our experience creating bar graphs with Excel. Our confidence and competence with the technology just continues to grow! This project aligned with the following Pennsylvania Academic Standards:
2.2.5 Computation and Estimation
2.4.5 Mathematical Reasoning and Connections
2.6.5 Statistics and Data Analysis
3.7.5 Technological Devices
