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

From Help Wiki
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
* Easiest entry into "application development" --you don't even have to be a developer/programmer
+
# Bar comparing growth over time for student 1 and student 4 for graphing
  
=== The Good, The Bad, and the Ugly ===
 
  
==== The Good ====
+
== Live feed to Google sheet ==
* Spreadsheets is a low entry point for an application framework, in the same way that WordPress is a website framework
+
[https://docs.google.com/spreadsheets/d/1H7MEeJHA3gmQIySmKgy2O4PGV-hEVNuJmKiWxnsRpWQ MIT Workshop Grade Score]
** You don't have to be a developer/programmer
+
  
====The Bad ====
 
* Spreadsheets are used to make applications
 
** 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''']
 
 
== 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.
 
 
== Basics ==
 
* relative vs. absolute cell reference
 
* dragging cells to auto-fill
 
 
 
== Tips & Tricks ==
 
 
=== Keyboard shortcuts (Navigation) ===
 
* [https://support.office.com/en-us/article/keyboard-shortcuts-in-excel-2010-20603861-42b6-4c93-82ec-66924ea9b323 Excel]
 
* [https://help.libreoffice.org/Calc/Shortcut_Keys_for_Spreadsheets Calc]
 
 
 
=== Formulas ===
 
* With complex formulas, work backwards, or right to left:
 
** LEFT(ROUND(SUM(A:A))/COUNT(A:A),3)
 
 
 
 
 
== Graphing (Charts) ==
 
 
=== 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/>
 
+
=== Anatomy of a Graph/Chart ===
+
* Graph/Chart type
+
** 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
+
 
+
=== Tips & Tricks ===
+
* To print individual charts, select the chart, then press CTRL + P, this bring up print properties just for the selected chart.
+
 
+
 
+
==== Data Manipulation ====
+
* Swap X Y or switch row/column
+
** "Select Data..." from Chart filter
+
 
+
==== 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]
+
** ''"let my dataset change your mindset"''
+
* [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.informationisbeautiful.net/visualizations/snake-oil-supplements/ Bubble Race visualization]
+
* [http://www.gapminder.org/ Gapminder] --requires Adobe Flash plugin :-(
+
 
+
 
+
 
[[The World of spreadsheets and simple graphing]]
 
[[The World of spreadsheets and simple graphing]]
<br/>
 
<br/>
 
<br/>
 
<br/>
 
'''''Shout out to [https://duckduckgo.com DuckDuckGo] search engine for bursting my [http://dontbubble.us/ filter bubble]'''''
 
[[FILE: Logo_ddg_community.png | 50px]]
 
 
<br/>
 
<br/>
 
<br/>
 
<br/>
 
[[Category:2015-2016]]
 
[[Category:2015-2016]]

Revision as of 09:58, 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


Live feed to Google sheet

MIT Workshop Grade Score




The World of spreadsheets and simple graphing