Grade Cluster 9-12 Task # 5

The Grade Cluster & Task #: Grade Cluster 9-12, Task # 5

The Product/Performance: Graphs and Charts to support a conclusion

The Components: Spreadsheet, Graphing Calculator

The Task:

Students will create a simulation or model using a graphing calculator. They will use digital tools to capture this data. (e.g., light from a fluorescent bulb, temperature from a variety of liquids over time, etc.) They will then analyze the data and import it into a spreadsheet. Students will manipulate the data appropriately, construct charts to justify their conclusions, and report the results visually.

Rationale: Real-world scientific process is best accomplished using real-world tools. With the ability of technological tools to capture and manipulate data, students will focus on the understanding rather than the recording of data. Once the results are measured and scenarios understood, the learner will engage in presenting their findings. True learning occurs when explanation of that learning is evident.

IT1 - Basic Operations & Concepts

· Using digital tools to capture images and other information (e.g., temperature, light, sound, etc.) and import them into a computer.

IT2 - Social, Ethical & Human Issues

· Not assessed in this task.

IT3 - Productivity Tools

· Creating a spreadsheet from a blank page, including formulas and functions (MIN, MAX, ROUND), formatting cells (e.g., numeric, monetary, percent, values).

· Documenting spreadsheets with named cells and comments

· Creating a graphical representation appropriate to the numerical data (e.g., scatter plot, x-y)

· Manipulating format (e.g., resizing rows and columns, font, colors, hiding grid)

· Referencing formulas from other worksheets

· Using a graphing calculator and grade appropriate applications/ functions (e.g., graphing, statistics, tables, equations, matrix).

IT4 - Communication

· Not assessed in this task.

IT5 - Research, Problem Solving & Decision Making

· Justifying decisions made, e.g. representing data, formatting, setting up formula, selecting criteria for search

· Creating and using simulations or models, (e.g., spreadsheet to design “what if” scenarios)

Glossary:

Spreadsheet- A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with the data.

Resources:

Spreadsheet

http://www.mathsnet.net/spreadsheet/

http://www.dbcc.cc.fl.us/fipse_sh/spreadsheet1.htm

Spreadsheet Tutorial –

http://www.sir.arizona.edu/sm97/506/spreadsheet.htm

http://science.csustan.edu/tutorial/Excel/

http://www.quasar.ualberta.ca/edpy202/tutorial/spreadsheet/spreadsheet.htm

http://www.thinkquest.org/library/site_sum.html?tname=J0110054&url=J0110054/definition.html