Difference between revisions of "MIT The World of spreadsheets and simple graphing"
From Help Wiki
(First draft) |
|||
(29 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | == | + | == Making Relevant Graphs == |
− | + | # Bar graph demonstrating whole class growth over time for estimation | |
+ | # Bar graph demonstrating whole class growth over time for graphing | ||
+ | # 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? | ||
− | === | + | === 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 == | ||
+ | [https://docs.google.com/spreadsheets/d/1H7MEeJHA3gmQIySmKgy2O4PGV-hEVNuJmKiWxnsRpWQ MIT Workshop Grade Score] | ||
+ | |||
+ | |||
+ | <br/> | ||
+ | <br/> | ||
+ | [[The World of spreadsheets and simple graphing]] | ||
+ | <br/> | ||
+ | <br/> | ||
[[Category:2015-2016]] | [[Category:2015-2016]] |
Latest revision as of 11:18, 23 October 2015
Contents
Making Relevant Graphs
- Bar graph demonstrating whole class growth over time for estimation
- Bar graph demonstrating whole class growth over time for graphing
- 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?
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