1 / 22

# Graphing Dinosaurs - PowerPoint PPT Presentation

Graphing Dinosaurs. Introducing graphing concepts through the use of Excel. Presented by Ruth Kelly. Audience 2nd Grade Gifted & Talented Class Time Frame Begin after completion of 2nd Grade DinoSite Web Quest Four 30 minute computer lab sessions Session 1: Introduction & research

Related searches for Graphing Dinosaurs

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

## PowerPoint Slideshow about 'Graphing Dinosaurs' - deborah

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

Introducing graphing concepts

through the use of Excel

Presented by Ruth Kelly

• Audience

• Time Frame

• Begin after completion of 2nd Grade DinoSite Web Quest

• Four 30 minute computer lab sessions

• Session 1: Introduction & research

• Session 2: Demonstrate Excel; Input data

• Session 3: Use data

• Session 4: Create charts; Insert into PowerPoint presentation

Students will

• Gather and record data from website

• Use recorded information to complete workbook sheets

• Create a chart to illustrate their findings

• Use the autosum button to add a column of numbers

• Use autosum buttonto find the average of a column of numbers

• Insert chart into PowerPoint presentation

• Required Prior Knowledge

• General

• Simple keyboarding

• Commands (open, save, quit, select, cut, copy, paste, print)

• Microsoft Word

• Basic formatting (font style, color, size, and position)

• Microsoft Powerpoint

• Create, format, and animate slides (basic)

• Insert and resize pictures from file

• Internet (Microsoft Explorer)

• Hyperlinks, Favorites, Scroll, Back, Forward

• New Knowledge (at age appropriate level)

• Microsoft Excel

• Columns and rows

• Select and input to cell

• Edit data in cell

• Name cell by location (ie., D3)

• Select a series of cells

• Use Autosum

• Use Chart Wizard

• Copy chart and paste into presentation program

• Session 1

• Introduce Project

• Review and overview

• Show research page

• Groups of 4; 5 dinosaurs each

• Demonstrate gathering and recording information

• Research & Record

• Gather and record information

Column A

• Session 2

• Introduce Excel

• Show columns and rows

Carnivore

• Select, cell name, input, edit

C4

• Practice

A8

• Data Input

• Show Graph

• Demonstrate

Row 8

• Input data (five dinosaurs)

• Print

Session 3

Demonstrate moving between worksheets.

Use information on data sheet to complete additional graphs.

7

2

1

7

3

0

#3 – Sample Size

Session 3

Autosum - Sum

• Demonstrate

• Use

C10

133

C14

Session 3

Autosum - Average

• Demonstrate

• Use

D10

8

D15

• Session 4 - Charts

• Graph # 1 - Column chart

• Select graph

• Click Chart Wizard

Select charttype

Click Next

Use default

Click Next

Type Chart Title

Click Next

• Select “As new Sheet”

• Type sheet name;

• Click Next

• or Finish

• Graph # 2 - Pie chart

• Select graph

• Chart Wizard

Select charttype

Click Next

• Graph #3 - Cylinder chart

• Select graph

• Click on Chart Wizard

Select charttype

Click Next

Click Next

Select Show data table

Select legend keys

Click Next

Type Chart Title

Click Data Table

Credits

Dinosaurs. The Children’s Stomping Ground. Retrieved 30 Apr. 2004 < http://www.oink.demon.co.uk/ topics/dinosaur.htm >.

Jividen, Bruce R. Extinction. Kubder.net. Retrieved 30 Apr. 2004 <http://www.timg.demon. co.uk/starman/extinction.htm>.

New Jersey Core Curriculum Content Standards. New Jersey Department of Education. Retrieved 30 Apr. 2004 <http://www.state.nj.us/njded/aps/cccs/math/>.

Tucciarone, Joe. The Dinosaur Art Gallery of Joe Tucciarone. Retrieved 30 Apr. 2004 <http://mem bers.aol.com/Dinoplanet/joe.html>.

Zoom Dinosaur. EnchantedLearning.com. Retrieved 21 Apr. 2004 <http://www.EnchantedLearning.com /subjects/dinosaurs/index.html>.

NJCCCS - Mathematics Standards

Standard 7 - Geometry/Spatial Sense (7.1, 7.3, 7.8) All students will develop spatial sense and an ability to use geometric properties and relationships to solve problems in mathematics and in everyday life.

EXPLANATION: Students create charts showing their data and use those charts to answer questions about size and time periods of their dinosaurs. Students use the function keys to determine total length and average height of all their dinosaurs and the average height of their dinosaurs.

Standard 2 - Communication

(2.1, 2.2, 2.3) All students will communicate mathematically through written, oral, symbolic, and visual forms of expression.

EXPLANATION: Students gather information and record on data sheets (written). Information is illustrated through the use of charts (symbolic) and presented using PowerPoint (oral and visual)

Standard 6 - Number Sense (6.5)

All students will develop number sense and an ability to represent numbers in a variety of forms and use numbers in diverse situations.

EXPLANATION: Students represent numbers using three separate graphs and three different charts