|
|
(5 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 |
− | * 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 === | + | === Excercise 1 === |
| + | ''Get the data into a spreadsheet, such as Excel'' |
| + | * Does the data need to be munged? |
| | | |
− | ==== The Good ==== | + | === Excercise 2 === |
− | * Spreadsheets is a low entry point for an application framework, in the same way that WordPress is a website framework
| + | ''Learning how to filter'' |
− | ** You don't have to be a developer/programmer
| + | |
| | | |
− | ====The Bad ==== | + | === Excercise 3 === |
− | * Spreadsheets are used to make applications | + | ''Charts'' |
− | ** You don't have to be a developer/programmer | + | * Move a chart |
− | ** Complex spreadsheets suffer from errors; become difficult to troubleshoot | + | * When looking at the range for the axis, make it the full range, i.e. 1-5 |
| + | * Print an individual chart |
| + | ** CTRL + P |
| | | |
− | ==== The Ugly ==== | + | === Global Tips & tricks === |
− | * [http://www.jstatsoft.org/article/view/v034i04 '''On the Numerical Accuracy of Spreadsheets'''] | + | * CTRL + Z to undo |
| | | |
− | == 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 == | + | == Live feed to Google sheet == |
− | [http://vita.had.co.nz/papers/tidy-data.html ''Tidy Data''] by [http://vita.had.co.nz/ ''Hadley Wickham''] | + | [https://docs.google.com/spreadsheets/d/1H7MEeJHA3gmQIySmKgy2O4PGV-hEVNuJmKiWxnsRpWQ MIT Workshop Grade Score] |
− | # 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 charts.
| |
− |
| |
− |
| |
− | ==== 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 :-(
| |
− |
| |
− |
| |
− |
| |
− | <br/>
| |
− | <br/>
| |
| <br/> | | <br/> |
| <br/> | | <br/> |
− | '''''Shout out to [https://duckduckgo.com DuckDuckGo] search engine for bursting my [http://dontbubble.us/ filter bubble]'''''
| + | [[The World of spreadsheets and simple graphing]] |
− | [[FILE: Logo_ddg_community.png | 50px]]
| + | |
| <br/> | | <br/> |
| <br/> | | <br/> |
| [[Category:2015-2016]] | | [[Category:2015-2016]] |