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 29, 2012
We continued to explore using Excel to analyze data. Children created double bar graphs to compare their own pulse rates with the pulse rate of a partner. Pulses were taken and recorded within a table at different times during the course of a day. The double 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 21 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
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 our classroom computers 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
Valentine Candy Hearts Fun
We continued our exploration of Excel-lent graphing with a continued look at 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, using a table to record and organize our information. We reviewed rounding fractional parts, making decisions about candy hearts that were not whole and how to include them in our table. We reviewed how to create a circle graph using Excel to display the portion each candy color represented within our individual boxes. We reviewed how to insert patterns and learned how to 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! ... Oh, and when we were done, we enjoyed eating our Valentine candy hearts!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
2009
2010
2007
2009
Bar Graph Projects
Circle Graph Projects
Line Graph Projects
What's the Temperature Like in YOUR Milford?
What's the Temperature Like in YOUR Milford?
There are 21 states in our country, including Pennsylvania, 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-line graphs to display our temperature comparison data, showing change over time for 2 different locations. We easily and effectively used the Chart Wizard and carefully followed the checklist prepared by Mrs. Dingman to change the line width and markers for our temperature lines. Our line graphs were created as a performance task assignment, as we followed our checklists independently and with confidence. We reviewed finding averages and discussed our temperature findings as a class, with a brief introduction to the Scientific Method. Enjoy our Excel-lent graphs! Pennsylvania Academic Standards continued to be met with this project:
1.8.5 Research
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
4.6.5 Ecosystems and Their Interactivity
3.7.5 Technological Devices
Create Your Own
Survey & Graphing
We continued our Excel exploration with a project that allowed us to create our own survey questions. We each thought about our favorite "something", created questions to compliment the selected category, and surveyed our classmates to find out about their interest in those things. We created bar graphs, reviewing the Chart Wizard in Excel, to display our survey data. Ahhhh ... but we weren't quite done...
We searched online to find graphic images to insert in the bars of our graphs, complimenting each of the survey questions asked. We discussed using a variety of search terms to widen our choices, helping us find that "just right" image. We carefully followed Mrs. Dingman's written checklist directions to insert the graphic 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 computers 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
April 2005
May 2011
2010
2011
2011
Our most recent Excel project this year began our exploration of circle, or pie graphing. We created a 2-column sheet with Excel to record purchases we thought we might like to make from our imaginary Amazon.com contest winnings and the amount of money we might spend, up to $1,000.00, for those items. ... but, we weren't quite done...We learned how to use the AutoSum button to show a running total of the items we chose after browsing on Amazon.com, allowing our spreadsheets to keep track of the spending of our imaginary contest winnings. We learned how to create a circle, or pie graph using Excel to display the items we chose and the portion of the $1,000.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
Amazon Shopping Spree
2010
2012
2012
