I have an assignment to develop a spreadsheet lesson framework for creating tables and graphs in 6th grade science. I used the following lesson last year with my students. It was a tough concept to grasp, but eventually they got it.
- Provide a description of the topic: A basic introduction to Tables and Graphs.
- There are 3 common types of graphs. They are:
- Line Graphs
- Bar Graphs
- Circle Graphs
- There are 3 common types of graphs. They are:
- List goals of lesson and the complex concepts students will understand after using the spreadsheet: Students will describe the differences between the 3 common types of graphs and when is appropriate to use each type.
- Provide a description of the data that will be used, the column & row headings you will use, and where the data will come from.
- We will use data from Glencoe Science: Level Red, Student Edition (2008).
- For our line graph, our column headings will be Year and Number of Endangered Species.
- For our bar graph, our labels will be Number of Species and Animals
- For our circle graph, we will use the data from our bar graph to determine parts of the whole number of endangered species.
- Create a sample (working) Spreadsheet to support your lesson ideas (either by "attaching" an Excel file or embedding a Google Spreadsheet).
- You can find a link to my Line Graph here.
- You can find a link to my Bar Graph here.
- You can find a link to my Circle/Pie Graph here.