- 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

Related searches for Graphing Dinosaurs

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

- 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

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

- General

- 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

- Microsoft Excel

- Session 1
- Introduce Project
- Review and overview

- Introduce Project

- 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

- Introduce Excel

Carnivore

- Select, cell name, input, edit

C4

- Practice

A8

- Data Input
- Show Graph
- Demonstrate

Row 8

- Input data (five dinosaurs)

Session 3

Demonstrate moving between worksheets.

Use information on data sheet to complete additional graphs.

7

2

1

7

3

0

#3 – Sample Size

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

Follow same steps as before

Click Next

Select Show data table

Select legend keys

Click Next

Type Chart Title

Click Data Table

Follow same steps as before

- Assessment
- Dinosaur Quiz
- Rubric

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

Download Presentation

Connecting to Server..