Graphing & Data Analysis

Introduction

Collaborative Data Analysis

• •  Video  Collaborative Analysis of Pooled Data - Analyzing Hurricane Data  (20:58).  

  •  Video  Collaborative Analysis of Pooled Data - What Causes Something to Float or Sink? (11:42)

  •  Video  Collaborative Analysis of Pooled Data - Investigating the Cell Cycle (11:58)

  •  Video  Collaborative Analysis of Pooled Data - Composition of Biological Molecules (13:11)

  •  Video   Creating Forms & Spreadsheets [18:09]

    • Relationship between: Edit forms; Live Forms; Spreadsheet; Summary Responses

  •  Video  Editing  Forms [10:42]

    • Choosing a Response Destination; Adding, Deleting, Editing and Arranging Questions; Page Breaks and Page Titles; Images, Appearance, Themes; Conditional Sequencineg

  •  Video  Sharing Forms, Collecting Data [9:42]

    • sharing a form via email; embedding forms in websites; linking to forms 

Building CSCS Spreadsheets

• •  Video  Viewing & Sharing Data [7:48]

    • Linking to data; embedding data tables in websites; showing summary data; analytics; setting permission privileges

  •  Video  Creating Data Entry Tables [9:35]

    • Sharing Settings; Coloring; Protecting blocks; Freezing rows and columns

  •  Video  Conditional Formatting [8:03]

    • Highlighting data based on specific criteria

  •  Video  Calculations - Number Crunching!  [13:02]

    • Using formulas and Functions; Relative copying of formulas; absolute copying of formulas. 

    • Practice files (note - first copy the spreadsheet and then practice on the copy).

  •  Video  Graphing & Analyzing Data  [16:28]

    • Creating graphs & charts 

    • Practice files 

(20.1) Calculations and Computer Modeling

• Spreadsheet for 20.1

(20.2) Relating Graphs to Real-World Experiences

• Walking Through Graphs (figure 20.7)

(20.3) Graphing Stories

• Spreadsheet of Atmospheric Carbon Dioxide (figure 20.8)

• Matching Graphs and Stories (figure 20.9)

• Create Stories from These Graphgs (figure 20.10)

(20.4) Scatter and Line Graphs

• Spreadsheets and graphs for section 20.4

  • 20.4.1.2 Current air pollution data 

  • 20.4.1.4 Hertzprung Russel Diagram

  • 20.4.1.4 Sunspots

  • 20.4.2 Endangered Species

(20.5) Column and Bar Graphs 

• Spreadsheets and graphs for section 20.5

  • 20.5.1.1 World population data

  • 20.5.3.2 Endangered Species

(20.6) Pie and Area Graphs

• Spreadsheets and graphs for section 20.6

  • 20.6.1.1 World population data

  • 20.6.1.2 Biomes

  • 20.6.1.3 Sources of Energy

(20.7) High-Low, Combination, and Log Plots

• Spreadsheets and graphs for section 20.7

  • 20.7.1.2 Climate data

  • Climographs & photos

(20.8) Statistics

• Spreadsheets and graphs for section 20.8

Additional Resources

• Related CSCS activities

• Chapter 20 (pdf) - (CSUN faculty only)

• Types of graphs (xls)

• Spreadsheets

• Chapter activities

• Google Spreadsheets