Difference between revisions of "MIT The World of spreadsheets and simple graphing"
From Help Wiki
(2 intermediate revisions by the same user not shown) | |||
Line 4: | Line 4: | ||
# Bar graph demonstrating growth over time for student 1 for estimation | # Bar graph demonstrating growth over time for student 1 for estimation | ||
# Bar comparing growth over time for student 1 and student 4 for graphing | # 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 | ||
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