Polan Gradebook

Miss Polan's Gradebook Students Chris Chelsea Daniel John Lisa Maggie Nancy AVERAGE

Drill Sheet (50) 45 50 48 40 45 48 37 44.7

Short Cycle 1 (30) Cell Diagram (50)Dialysis Tubing Lab (50) 24 48 37 21 46 36 26 44 48 25 43 31 23 44 24 27 45 33 14 45 32 22.9 45.0 34.4

Unit Review Packet (50) Benchmark 2 (75) Total Points PercentileLetter Grade 48 68 270 89% B+ 46 75 274 90% A+ 44 73 283 93% A 44 65 248 81% B45 70 251 82% B47 72 272 89% B+ 42 50 220 72% C 45.1 67.6 260 85% B

Assignment Summary 75

Number of Points

70 65 60 55 50 45 40 35 30 25 20 15 10

Drill Sheet (50)

Short Cycle 1 (30)

Cell Diagram (50)

Dialysis Tubing Lab (50)

Assignments

Unit Review Packet

Bench mark 2 (75)

ummary for Miss Polan's Class

t Rew ket

Chris Chelsea Daniel John Lisa Maggie Nancy AVERAGE Bench mark 2 (75)

Students

Final Grades for Miss A VER AGE Nanc y Ma ggi e Lisa John Dani el Chel sea Chris 0.7

0.8

0.9

Percentage

or Miss Polan's Class

1

Spreadsheet technology could be used in the science classroom to analyze data that was collected from a laboratory activity. Data collection is an aspect of core learning goal 1.3 which states, “The student will carry out scientific investigations effectively and employ the instruments, systems of measurement, and materials of science appropriately.” Data collection must also be used in order to achieve core learning goal 1.4 which states, “The student will demonstrate that data analysis is a vital aspect of the process of scientific inquiry and communication.” In the Biochemistry unit students participate in a lab where they sample different substances in order to test the pH of the substance. They are then asked to arrange the substances in a chart based on their respective pH values. Using spreadsheet technology students would be better able to analyze the data because they can formulate their graphs more efficiently. The collected data can be organized into a spreadsheet and then the students can create a bar graph comparing the various pH values. Using the computer to create a spreadsheet will better enable students to communicate their data. They will be able to electronically send their data and graphs. They can also easily incorporate this data into a class presentation such as a powerpoint presentation. When students analyze data by using a computer spreadsheet program instead of the traditional method of plotting on graph paper, they are engaging the utilizing stage of Thomas and Boysen’s taxonomy. The spreadsheet is used as a tool for graphing, which is a task that the students have already learned.