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

From Help Wiki
(Visualization)
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
== Spreadsheets ==
+
== Making Relevant Graphs ==
''give a simple explanation''
+
# Bar graph demonstrating whole class growth over time for estimation
* [https://en.wikipedia.org/wiki/Spreadsheet As explained by Wikipedia]
+
# Bar graph demonstrating whole class growth over time for graphing
* Best application for data gathering/collection
+
# Bar graph demonstrating growth over time for student 1 for estimation
 +
# 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?
  
=== The Good, The Bad, and the Ugly ===
+
=== Excercise 2 ===
 +
''Learning how to filter''
  
==== The Good ====
+
=== Excercise 3 ===
* Spreadsheet's is a low entry point for an application framework, in the same way that WordPress is a website framework
+
''Charts''
** You don't have to be a developer/programmer
+
* 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
  
====The Bad ====
+
=== Global Tips & tricks ===
* Spreadsheets are used to make applications
+
* CTRL + Z to undo
** You don't have to be a developer/programmer
+
** Complex spreadsheets suffer from errors; become difficult to troubleshoot
+
  
==== The Ugly ====
 
* [http://www.jstatsoft.org/article/view/v034i04 '''On the Numerical Accuracy of Spreadsheets''']
 
  
 +
== Live feed to Google sheet ==
 +
[https://docs.google.com/spreadsheets/d/1H7MEeJHA3gmQIySmKgy2O4PGV-hEVNuJmKiWxnsRpWQ MIT Workshop Grade Score]
  
=== The World of Spreadsheets ===
 
* [http://www.gnumeric.org/ Gnumeric] ''most powerful spreadsheet program''
 
** ''Single editor environment''
 
** [https://en.wikipedia.org/wiki/List_of_spreadsheet_software#Specifications ''Size Limit:''] ''Max rows: 16,777,216; Max Columns: 16,384; Max Cells: 274,877,906,944''
 
** 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''
 
** x32 bit vs. x64 bit
 
** [https://support.office.com/en-us/article/Excel-specifications-and-limits-ca36e2dc-1f09-4620-b726-67c00b05040f ''Size Limit:''] ''1,048,576 rows by 16,384 columns''
 
*** ''x32 bit: Each document limited to 2GB''
 
*** ''x64 bit: Each document limited by system physical memory
 
* [https://products.office.com/en-ca/home Microsoft Excel Online in Office 365]
 
** ''Multi-editor environment'' ''--Maximum of 5 concurrent editors''
 
** [https://support.office.com/en-us/article/Data-Model-specification-and-limits-19AA79F8-E6E8-45A8-9BE2-B58778FD68EF ''Size Limit:''] ''250 MB''
 
  
== Tidy Data ==
 
[http://vita.had.co.nz/papers/tidy-data.html ''Tidy Data''] by [http://vita.had.co.nz/ ''Hadley Wickham'']
 
# Each variable forms a column,
 
# Each observation forms a row,
 
# Each table (or file) stores data about one class of experimental unit.
 
 
== Graphing ==
 
 
=== The Top Ten Worst Graphs ===
 
''Learning from others mistakes''
 
 
<br/>
 
<br/>
[https://www.biostat.wisc.edu/~kbroman/topten_worstgraphs/ The Top Ten Worst Graphs]
+
<br/>
 
+
[[The World of spreadsheets and simple graphing]]
=== Anatomy of a Graph ===
+
<br/>
* Graph/Chart type
+
<br/>
** Column
+
** Bar
+
** Pie
+
** Area
+
** Line
+
** XY Scatter
+
** Bubble
+
** Net
+
** Boxplot
+
** Mixed
+
* Chart/Graph Title
+
** Chart/Graph Subtitle
+
* Chart/Graph X-Axis Label
+
* Chart/Graph Y-Axis Label
+
* Chart/Graph Legend
+
 
+
==== Color ====
+
 
+
* [http://ethanschoonover.com/solarized Solarized]
+
* [http://colorbrewer2.org/ Color Brewer]
+
* [https://99designs.com/designer-blog/2013/04/17/designers-need-to-understand-color-blindness/ Color Blind considerations]
+
 
+
=== Visualization Data ===
+
 
+
==== TED TALK's ====
+
* [http://www.ted.com/talks/david_mccandless_the_beauty_of_data_visualization David McCandless: The beauty of data visualization]
+
* [http://www.ted.com/speakers/hans_rosling Hans Rosling]
+
* [http://www.ted.com/talks/manuel_lima_a_visual_history_of_human_knowledge Manuel Lima: A visual history of human knowledge]
+
 
+
==== Visualization ====
+
* [http://www.informationisbeautiful.net/ Information Is Beautiful]
+
* [http://www.gapminder.org/ Gapminder] --requires Adobe Flash plugin :-(
+
 
+
 
+
 
+
 
[[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