View source for The World of spreadsheets and simple graphing

__NOTOC__
== Spreadsheets ==
* [https://en.wikipedia.org/wiki/Spreadsheet As explained by Wikipedia]
* Best application for data gathering/collection
* Easiest entry into "application development" --you don't even have to be a developer/programmer

=== The Good, The Bad, and the Ugly ===

==== The Good ====
* Spreadsheets is a low entry point for an application framework, in the same way that WordPress is a website framework
** 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/>
[https://www.biostat.wisc.edu/~kbroman/topten_worstgraphs/ The Top Ten Worst Graphs]

=== 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]
* [http://galacticmilk.com Color Sphere by MUDCUBE]

=== 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 :-(


<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/>
[[Category:Curricular_Technologies]]