1 / 29

Starting Graphs

Starting Graphs. Before You Begin…. Underpinning knowledge: How to sort Can use keyboard and mouse Data skills like sorting, using tables and tally charts Have number skills: comparing numbers, terms like more, less, same/equal; operations. Before the Computer.

Download Presentation

Starting Graphs

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

  2. Before You Begin…. • Underpinning knowledge: • How to sort • Can use keyboard and mouse • Data skills like sorting, using tables and tally charts • Have number skills: comparing numbers, terms like more, less, same/equal; operations

  3. Before the Computer • Start with concrete activities: • Sort objects according to characteristics • Record results of sorting in a table or tally chart • Create simple graphs with table data using pencil and paper • Ensure students have a basic understanding of data handling especially organizing data

  4. Click this Icon to Open Excel

  5. Columns Rows

  6. Cells Columns Rows Cells The columns and rows form a pattern of cells

  7. Cells Rows J2 L2 H3 K4 Cells Columns Each cell has its own address. Cells are named by their row and column.

  8. Templates are a Great Place to Start!

  9. Spreadsheets are used to Store Information • Sort these balls Colour: orange, blue Size: large, small Sample 1B

  10. Spreadsheets are Used to Store Information that We Collect Class survey question: Which pet do you own? “What if…” questions

  11. We can record this information or data in a chart in a spreadsheet workbook Click the cell you want to enter the data into and begin to type here. We can write words or labels in the cell boxes We can write numbers or values in the cell boxes Sample 1A

  12. We can add clip art to a spreadsheet • Insert clipart from the illustrations menu. Sample 1A

  13. We can create graphs with a spreadsheet Bar Graph Pie Chart

  14. To Create A Chart/Graph Step 1. Click and drag to highlight the data you want to use for your chart. Step 2. Click the Insert menu to see the types of charts you can make.

  15. Select the type of chart you want to use.

  16. Use the Chart Menu to make changes to your chart. Change chart type Change chart appearance • Students should be able to answer: • What does the chart tell us? • What comparisons can you make?

  17. Meaningful • Student surveys • Data about Bermuda, neighbourhoods • Planning an event

  18. What if…. questions • Session 4

  19. Cells can contain….. • Labels (words, text) • Numbers (1,250 etc.) • Formatting Labels & Numbers

  20. Formula • Always starts with = sign =6+10 • Entered in place where you want the answer to appear Typed in formula bar Answer appears in cell B1

  21. Formula • can include mathematical functions + add - subtract * multiply / divide

  22. Formula • Can include the address of another cell =A3+B3 =3*(b2-c2) =D3-7

  23. Talking about Spreadsheets • What is the spreadsheet displaying? • What are the formulas doing? • Which cells are they working on? • What does this ~ mean? Session 2

  24. Cell Locations • Using cell names in calculations • What difference does this make? Session 2&3

  25. Plan First! • Plan your spreadsheet on paper. • Check formulas and cell locations • At the computer, enter data carefully!

  26. Special Points to Cover • Review tab for Spelling check • Importance of recording correct data • Strategies for checking accuracy of data • Show Formulas – Control~ Check! Check!

  27. Using Spreadsheet Functions • Formulas = Functions • Functions are built into your spreadsheet • Common functions are average, sum, count, mode, mean • They include a range of numbers or cells =average(B1:B10) =sum(A1+E3+D5) =mode(B9:J11)

  28. Working with Formulas • Moving formulae- copying and pasting: Click + Drag! Session 3 • What difference does it make? Does moving or copying formulas make a difference? What do you notice about a formula when you copy it? • Brackets and Order • Show Formulas - Control ~

  29. Spreadsheet Vocabulary

More Related