|
|
(16 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]
| + | |
− | | + | |
− | | + | |
| [[Category:2015-2016]] | | [[Category:2015-2016]] |