Graphing Dinosaurs
Download
1 / 22

Graphing Dinosaurs - PowerPoint PPT Presentation


  • 178 Views
  • Updated On :

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

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

PowerPoint Slideshow about 'Graphing Dinosaurs' - deborah


An Image/Link below is provided (as is) to download presentation

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
Slide1 l.jpg

Graphing Dinosaurs

Introducing graphing concepts

through the use of Excel

Presented by Ruth Kelly


Slide2 l.jpg

  • 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

    • Session 2: Demonstrate Excel; Input data

    • Session 3: Use data

    • Session 4: Create charts; Insert into PowerPoint presentation


Slide3 l.jpg

Objectives

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


Slide4 l.jpg

Technology Skills

  • 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


Slide5 l.jpg

Technology Skills

  • 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


Slide6 l.jpg

Procedure

  • 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


Slide7 l.jpg

Procedure

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



Slide9 l.jpg

Procedure

Session 3

Demonstrate moving between worksheets.

Use information on data sheet to complete additional graphs.

7

2

1

7

3

0


Slide10 l.jpg

#2 – Sample Time Periods

#3 – Sample Size


Slide11 l.jpg

Procedure

Session 3

Autosum - Sum

  • Demonstrate

  • Use

C10

133

C14


Slide12 l.jpg

Procedure

Session 3

Autosum - Average

  • Demonstrate

  • Use

D10

8

D15


Slide13 l.jpg

Procedure

  • Session 4 - Charts

    • Graph # 1 - Column chart

      • Select graph

  • Click Chart Wizard


Slide14 l.jpg

Select charttype

Click Next

Use default

Click Next

Type Chart Title

Click Next

  • Select “As new Sheet”

  • Type sheet name;

    • Click Next

    • or Finish



Slide16 l.jpg

Procedure

  • Graph # 2 - Pie chart

    • Select graph

    • Chart Wizard

Select charttype

Click Next

Follow same steps as before



Slide18 l.jpg

Procedure

  • Graph #3 - Cylinder chart

    • Select graph

    • Click on Chart Wizard

Select charttype

Click Next


Slide19 l.jpg

Use default;

Click Next

Select Show data table

Select legend keys

Click Next

Type Chart Title

Click Data Table

Follow same steps as before



Slide21 l.jpg

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>.


Slide22 l.jpg

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


ad