Can you identify two types of data your students could collect as part of a lesson?
Pretty much any data can be collected during a lesson and entered into a spreadsheet. Two examples are as follows:
Students might collect numerical data for a math class and use spreadsheets and built in formulas to solve problems or filters to create patterns and collect data.
Students can also collect information such as home recycling items and could then discuss how often the community recycles and determine how many trees might be saved due to the amount of paper recycled.
Voting patterns could be collected and students could discuss the changes these patterns have caused in the state over the last 10 years.
The list could go on and on. Collection of data can be used in most lesson plans and students can learn to use spreadsheets and graphs to assist in all of the this data collection.
How could your students manipulate the data to discover relationships or trends?
Through the creation of databases we are able to collect information into personalized, individualized, organized fields and then pull queries based on this information. This information could be pretty much anything, from numbers to names and address, etc. For example, you might have your students study non-profit business plans and have them pull queries on donations given to the organizations. Students could break the information down into age of donors, demographic information, location, who donated the most each year, etc. With this same database, students could practice mail merges and follow up letters to donors and create an end of the year report showing graphs and charts demonstrating overall donations, etc. On a more simplistic approach to discovering relationships and trends, you can enter information into a spreadsheet and by highlighting/selecting specific cells, you can sort data, alphabetically, numerically, or by font or cell color. If the information is entered correctly, you can break down your information any way you'd like. Using filter functions, you can use a spreadsheet in place of a database to select specific information. By entering calculations and formulas into your spreadsheets, you can perform calculations and increase productivity by calculating an entire page of information all at once vs. doing so one entry at a time. Spreadsheets are useful tools for creating simulations, analyzing data, and exploring number concepts and mathematical relationships. As mentioned in our text, teachers can use spreadsheets to demonstrate many relationships and trends. For example, when discussing gravity and the different effects of gravity on different planets, teachers can use a spreadsheet to demonstrate what students weight might be on each planet. This allows students to conceptualize the true effects of gravity. This study could be done with multiple items, from students to common objects and over a period or two, students could enter in the weights of these different objects to study the concept of gravity. To take the example a step further, students could study what is needed in a trip to space and the individual weight of each item and what could or could not be taken on a voyage. They could eliminate items based on weight by using the spreadsheet to adjust calculations and maintain the set weight limit. By using formulas, students could manipulate the information in their spreadsheet until they come up with the right combination of items. This example is one of simulation. Another example of using spreadsheets to discover relationships and trends is by creating discovery spreadsheets. Discovery spreadsheets are simulations that allow students to manipulate variables and discover rules and laws.
Can you identify three graphs or charts your students could make that would help them develop a better understanding of the content?
Spreadsheets create a wide variety of ways to display your data ranging from traditional bar, line, and pie graphs to several other variations. You can create interactive graphing with a spreadsheet that allow you to perform calculations, sort data, or select data.
This is a sample of a bar graph illustrating student's favorite colors. This would be a great graph to use in 1st or 2nd grade when discussing numbers or even demonstrating graphs and charts.
Below is another example of a bar chart showing the number of kids in a class, how many have pets and what type of pets they have.
For grades k-8, the pie chart below illustrates whether or not school uniforms make kids more or less competitive. The pie charts take into consideration age and grade and may be a great study for students to do.
Another example of a pie chart is shown below and may really get kids attention because it discusses a topic kids love, game boxes. This is a comparison study illustrating what is more popular, Play Stations, Wii, or Xbox. This could be a great lesson in math, using percentages.
To illustrate a pie chart with a few more details, the chart below shows not only the pie chart itself describing how many pets are on a street, but also a color coded chart of what type of animals have been found and the percentages of each. This just illustrates how you can get as simple or elaborate as you'd like when creating charts and graphs.
The next example shown is of a line graph, also describing the number of animals found in a street. Like the pie chart shows above, the line chart illustrates how many pets are found, what type, and the percentages. The same information can be shown in multiple forms of graphs and charts and students should have practice creating all of these.
Pie charts can be shown in 3D as well for more graphic appeal.
A great lesson plan focusing on the environment and being conscious of its well being could be a school wide trash pick up day. To turn this into a lesson in creating charts, students can break down their findings and chart them. This exercise could be tied into a discussion in science about recycling and biodegrading materials. You could discuss what items out of your findings would still be present in 100 years and how your findings effect the environment and the life found in that area.
Is it possible to create an interactive simulation or model with a spreadsheet?
Yes it is possible to create an interactive simulation or model with a spreadsheet. For example, when discussing conversion between temperatures represented in Celsius and Fahrenheit, you could use a spreadsheet with a built in formula calculating the differences. Students could then enter in various temperatures into either the Celsius or Fahrenheit cells and because the formula is already entered, the calculation will appear immediately.
Converting Temperature Scales
•Celsius to Fahrenheit
•F= (9/5 x C) + 32
•Fahrenheit to Celsius
•C = 5/9(F-32)
By entering these calculations, your students would get the correct conversions.