1 / 22

Graphing Dinosaurs

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

deborah
Download Presentation

Graphing Dinosaurs

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Graphing Dinosaurs Introducing graphing concepts through the use of Excel Presented by Ruth Kelly

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

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

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

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

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

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

  8. Completed Graph

  9. Procedure Session 3 Demonstrate moving between worksheets. Use information on data sheet to complete additional graphs. 7 2 1 7 3 0

  10. #2 – Sample Time Periods #3 – Sample Size

  11. Procedure Session 3 Autosum - Sum • Demonstrate • Use C10 133 C14

  12. Procedure Session 3 Autosum - Average • Demonstrate • Use D10 8 D15

  13. Procedure • Session 4 - Charts • Graph # 1 - Column chart • Select graph • Click Chart Wizard

  14. Select charttype Click Next Use default Click Next Type Chart Title Click Next • Select “As new Sheet” • Type sheet name; • Click Next • or Finish

  15. Completed Column Chart

  16. Procedure • Graph # 2 - Pie chart • Select graph • Chart Wizard Select charttype Click Next Follow same steps as before

  17. Completed Pie Chart

  18. Procedure • Graph #3 - Cylinder chart • Select graph • Click on Chart Wizard Select charttype Click Next

  19. Use default; Click Next Select Show data table Select legend keys Click Next Type Chart Title Click Data Table Follow same steps as before

  20. Completed Cylinder Chart

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

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

More Related