To prepare for the lesson the teacher should:
1. Print out Life_Span_Data, data sheet/black line master, and distribute one copy of the data sheet to each student (The data sheet can be laminated to save resources).
2. Print out Life_Span_Key (The Spreadsheet Answer Key) for teacher use later in this lesson.
In the computer lab:
Enter values and formulas in a spreadsheet:
1. In the lab, the students are to open the file Life_Span_SS.
2. The teacher may display the spreadsheet for demonstration purposes in either of two ways. The teacher can open the actual spreadsheet (Life_Span_SS) on the lab teacher's station and use a video projection device or the teacher can make a transparency of the second page of Life_Span_Data (black line master) to use with an overhead projector in the lab.
3. The students will enter the data from the Life_Span_Data data sheet into appropriate cells with the guidance of the teacher.
4. Once all data has been entered, the teacher will guide the students in entering a spreadsheet formula: =E3-D3 in cell C3. The teacher should call attention to the calculated value that appears now in cell C3.
5. The teacher will then guide the students in entering the formula =E4-D4 in cell C4 and the formula =E5-D5 in cell C5.
6. Students will then enter the formula =E6-D6 in cell C6 and the formula =E7-D7 in cell C7 on their own.
7. Once all formulas have been entered in cells C3 through C5, the teacher should call on certain students to volunteer the values now being displayed in cells C3 through C5.
8. The teacher should lead a discussion to determine the formula for finding the "Average Age at Death" (order of operation is important).
9. The teacher will guide the students through the process of entering the formula
"=(C3+C4+C5+C6+c7)/5" in cell C8.
10. The teacher should choose a student to share their calculated "Average Age at Death" with the rest of the class.
11. Once all students have arrived at the same calculated "Average Age at Death," the teacher should proceed to guide the students through means of representing the data or information.
Create a chart to display the data:
1. The students should be directed to click in cell B2. Students should then be told to hold down a shift key and while holding it down, click in cell C7. (This will cause cells B2 through C7 to be selected.)
2. Students should choose the appropriate tool on the toolbar to create a "Bar" graph.
If there is no button for creating a chart, the student can choose Create New Chart from the Tools menu (In AppleWorks New Chart is under the Options menu).
3. Students should enter a title for the chart. Call upon the students to decide a good title for the data to be displayed.
4. Click OK to generate the chart.
5. Students should choose Headers from the View menu to enter their name in the header of the spreadsheet. (Insert Header is under the Format in AppleWorks.)
6. Once the bar graph is displayed on the monitor with the student's name as a part of it, the teacher will guide the students through the printing process.
|
