Grade Cluster 7-8      Task #2

The Grade Cluster & Task #:                   Grade Cluster 7-8, Task # 2

The Product/Performance:                      A Persuasive Presentation

The Components:                                     Spreadsheet, Graphing, Multimedia

The Task:

Students will create a linear multimedia presentation (slideshow) that will include a persuasive argument utilizing charts to support a conjecture.

 

Students will conduct a survey collecting numerical information and enter it into a spreadsheet that they format.  They will analyze the data to draw conclusions. After meeting with the teacher to define the nature of the data, they will present their information in a graphical representation.   They will move their charts from the spreadsheet to the multimedia application and will present their findings.

 

Rationale:        

Clearly articulating an argument to persuade an audience is an important skill for students.  Using a spreadsheet to analyze numerical data offers students a reliable way to consider many options and alternatives. It provides opportunities for students to visualize the relationship between variables.  Constructing a visual presentation requires organization, sequencing, careful consideration of the content, and visual articulation of the author’s point of view.

IT1 - Basic Operations & Concepts

·       Cutting, copying, and pasting within a document, across documents, and across applications.

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 MEDIAN, MODE, ROUND), formatting cells (e.g. numeric, monetary, percent, values).

·       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)

IT4 - Communication

·       Creating a linear and non-linear presentation including title slide, graphics, text, voice, sound related to topic, scanned or digital photo, animation, bibliography and table of contents, video clip

IT5 - Research, Problem Solving & Decision Making

Not Assessed in this task

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

Multimedia

http://www.youthlearn.org/learning/activities/multimedia/presentations.asp

            http://www.ncsu.edu/midlink/rub.pres.html

            http://www.actden.com/pp/