The purpose of this three day lesson is to work with graphing on a deeper level for freshman and sophomore level students. Although many students have had practice with graphing in the lower grades, their expertise is limited and seems to focus mainly on bar graphs rather than line or other types of visual representations of data. Extracting and analyzing data from visual resources such as graphs is an important skill for science students and one I want to begin building into our classroom structure as soon as possible in our new semester.
Day 1 of this lesson provides students with the opportunity to build their skills with Excel software while reviewing basic guidelines for well constructed graphs.
Standards: RST.9-10.3, RST.9-10.7
Day 2 is when we compare student constructed graphs to the graphing guidelines and check for quality and reader usability of both hand drawn and Excel graphs.
Standards: SL.9-10.7, RST.9-10.7, SP1, SP8
On Day 3, we move into a data analysis and prediction lesson using our student constructed graphs. By using interesting and accessible world population numbers, the lesson allows students to construct and discuss the implications of their visual representation of the data. This classroom discussion also gives them the opportunity to discuss potential extensions to the data/graph and is a natural transition activity into our next unit on the basic chemistry and wide ranging implications of climate change.
Standards: SL.9-10.1, SL.9-10.1d, HS-ETS-1, XC-P-HS-4, SP1, SP4, SP7
1. Announce to students that this week they will be working with graphs--how to make them and how to use them to better understand data and to make predictions from data.
2. Pass out the graphing activity handout. Ask for student volunteers to share out the major components of well constructed graphs listed on the top of the page. You may also give out a half-sheet of these guidelines for easy reference by students after they turn in the graphing activity handout.
3. As student volunteers read, write the most important/new vocabulary on the board: units, variables, x and y axis, descriptive title, independent and dependent variable. Discuss and review each term as needed for your particular student group.
4. Share with students that today they will be working on graphing with Excel and that the procedure for this is found on page two of the handout.
1. Ask students to assist you in reading the introductory paragraph and directions for the activity. You can use a popcorn method or call on students to read.
2. Take students through the computer login process and have them follow along with your computer work on the projector screen to ensure every student can get into the Excel program.
3. Allow students to work on computers to construct their Excel graph of world population data. You will find that the workroom tends to be busy and productive, with very little off-task conversations during this activity. The directions are explicit and at the same time, they do require attention and concentration.
4. If a student finishes early, take time to review their graph with them. There will typically be some aspect of their graph that they need to revisit, revise, or redo. If this is not the case, you can have that student begin to work on their hand drawn graph by following the directions listed on the document.
5. I've included a sample Excel graph for you to see what you might get from students. At this point in our discussion, I am looking only for attention to the most basic graphing rules: a title and each axis labeled with units and variables.
1. As the class session comes to an end, announce that students should bring a print-out of their Excel graphs to class tomorrow. Alternatively, you can have them print out their graphs in class with you now or bring and use their personal devices to access the graphs in class tomorrow.
2. Let students know that their graphs don't need to be perfect by tomorrow's class session and that you'll be using them for an extended activity with a final due date later in the week.
Now on to Day 2!