MIT The World of spreadsheets and simple graphing

From Help Wiki

Making Relevant Graphs

  1. Bar graph demonstrating whole class growth over time for estimation
  2. Bar graph demonstrating whole class growth over time for graphing
  3. Bar graph demonstrating growth over time for student 1 for estimation
  4. Bar comparing growth over time for student 1 and student 4 for graphing

Excercise 1

Get the data into a spreadsheet, such as Excel

  • Does the data need to be munged?

Excercise 2

Learning how to filter

Excercise 3

Charts

  • Move a chart
  • When looking at the range for the axis, make it the full range, i.e. 1-5
  • Print an individual chart
    • CTRL + P

Global Tips & tricks

  • CTRL + Z to undo


Live feed to Google sheet

MIT Workshop Grade Score




The World of spreadsheets and simple graphing