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

From Help Wiki
(Adding info on sheets)
 
(28 intermediate revisions by the same user not shown)
Line 1: Line 1:
−
== Spreadsheets ==
+
== Making Relevant Graphs ==
−
* [https://en.wikipedia.org/wiki/Spreadsheet As explained by Wikipedia]
+
# Bar graph demonstrating whole class growth over time for estimation
 +
# Bar graph demonstrating whole class growth over time for graphing
 +
# Bar graph demonstrating growth over time for student 1 for estimation
 +
# Bar comparing growth over time for student 1 and student 4 for graphing
  
−
''simple explanation''
+
=== Excercise 1 ===
−
''what are they good for''
+
''Get the data into a spreadsheet, such as Excel''
 +
* Does the data need to be munged?
  
−
=== The World of Spreadsheets ===
+
=== Excercise 2 ===
−
* [http://www.gnumeric.org/ Gnumeric] ''most powerful spreadsheet program''
+
''Learning how to filter''
−
** ''Single editor environment''
+
−
** Project doesn't provide Windows binaries; lag for latest version to be ported to Windows or Macintosh
+
−
* [https://www.libreoffice.org/discover/calc/ Libre Calc]
+
−
** ''Single editor environment''
+
−
** ''Size Limit: each sheet can have a maximum of 1,048,576 rows and a maximum of 1024 columns.''
+
−
*** ''Each document has a size limit of 4 GB''
+
−
* [https://www.google.com/sheets/about/ Google Sheets]
+
−
** ''Multi-editor environment''
+
−
** [https://support.google.com/docs/answer/37603?hl=en ''Size Limit Up to 2 million cells'']
+
−
* [https://products.office.com/en-us/excel?legRedir=true&CorrelationId=ac23a6ed-b7a9-4788-95e9-f82d9706af1b Microsoft Excel]
+
−
** ''Single editor environment''
+
  
 +
=== 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 ==
 +
[https://docs.google.com/spreadsheets/d/1H7MEeJHA3gmQIySmKgy2O4PGV-hEVNuJmKiWxnsRpWQ MIT Workshop Grade Score]
 +
 +
 +
<br/>
 +
<br/>
 +
[[The World of spreadsheets and simple graphing]]
 +
<br/>
 +
<br/>
 
[[Category:2015-2016]]
 
[[Category:2015-2016]]

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

Retrieved from "http://helpwiki.evergreen.edu/wiki/index.php?title=MIT_The_World_of_spreadsheets_and_simple_graphing&oldid=26929"

The Evergreen State College