Difference between revisions of "Supporting materials for computational WeBWorK problems"
From UBCMATH WIKI
(→For those using Excel or similar spreadsheets) |
|||
Line 60: | Line 60: | ||
Feel free to request other screencast topics either on Piazza or by emailing Prof. [http://www.math.ubc.ca/~cytryn Eric Cytrynbaum]. | Feel free to request other screencast topics either on Piazza or by emailing Prof. [http://www.math.ubc.ca/~cytryn Eric Cytrynbaum]. | ||
− | === | + | ===Videos that explain how to use various spreadsheets for various tasks=== |
+ | |||
{| | {| | ||
|XY graph in Google Docs (< 2 min and good!) | |XY graph in Google Docs (< 2 min and good!) | ||
− | |[ | + | |[http://www.youtube.com/watch?v=jrodFbUWL8s] |
|- | |- | ||
|ScatterPlot on iPad Numbers | |ScatterPlot on iPad Numbers | ||
− | |[ | + | |[http://www.youtube.com/watch?v=-mCPTlYY13I] |
|- | |- | ||
|Two plots on same axes on iPad Numbers | |Two plots on same axes on iPad Numbers | ||
− | |[ | + | |[http://www.youtube.com/watch?v=qv3Een81ycc] |
|- | |- | ||
|Open office scatter plot of data with trend line (<5min) | |Open office scatter plot of data with trend line (<5min) | ||
− | |[ | + | |[http://www.youtube.com/watch?v=J7YBtwfZLrU] |
|} | |} |
Revision as of 16:52, 22 September 2014
Here are some screencasts demonstrating spreadsheet techniques that will be useful for doing your spreadsheet-based webwork problems. These will continue to appear as the term progresses so keep coming back to see the newest ones.
For those using Excel or similar spreadsheets
The first three screencasts below are difficult to see on youtube due to compression. Until they are replaced with better quality versions, it is preferable to watch the full sized versions. However, this might not be possible in LSK 121 until a proper viewer is installed on those machines.
Title | ||
---|---|---|
How to plot the graph of a function (Excel) | youtube. | mov |
How to zoom in and out on a graph of a function (Excel) | youtube. | mov |
How to add a second graph to a plot (Excel) | youtube. | mov |
Newton's method for solving f(x)=0 (Excel) | png | |
How to determine when a function does or does not have inflection points (Desmos) | app | youtube |
How to find the location of minimum slope for a given function (Google Sheets) | youtube |
Feel free to request other screencast topics either on Piazza or by emailing Prof. Eric Cytrynbaum.
Videos that explain how to use various spreadsheets for various tasks
XY graph in Google Docs (< 2 min and good!) | [1] |
ScatterPlot on iPad Numbers | [2] |
Two plots on same axes on iPad Numbers | [3] |
Open office scatter plot of data with trend line (<5min) | [4] |