Difference between revisions of "MIT The World of spreadsheets and simple graphing"

From Help Wiki
(Excercise 3)
 
Line 18: Line 18:
 
* Print an individual chart
 
* Print an individual chart
 
** CTRL + P
 
** CTRL + P
 +
 +
=== Global Tips & tricks ===
 +
* CTRL + Z to undo
 +
  
 
== Live feed to Google sheet ==
 
== Live feed to Google sheet ==

Latest revision as of 11:18, 23 October 2015

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