Difference between revisions of "Supporting materials for computational WeBWorK problems"
From UBCMATH WIKI
(→For those using Excel or similar spreadsheets) |
|||
Line 10: | Line 10: | ||
! | ! | ||
|- | |- | ||
− | |How to plot the graph of a function | + | |How to plot the graph of a function (Excel) |
− | + | ||
|style="text-align:center;"|[http://www.youtube.com/watch?v=RDz_DgMhEQ0&feature=youtu.be youtube]. | |style="text-align:center;"|[http://www.youtube.com/watch?v=RDz_DgMhEQ0&feature=youtu.be youtube]. | ||
+ | |style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/PlottingGraphsOfFunctions.mov mov] | ||
|- | |- | ||
− | |How to zoom in and out on a graph of a function | + | |How to zoom in and out on a graph of a function (Excel) |
− | + | ||
|style="text-align:center;"|[http://www.youtube.com/watch?v=o9IOHheew4w&feature=youtu.be youtube]. | |style="text-align:center;"|[http://www.youtube.com/watch?v=o9IOHheew4w&feature=youtu.be youtube]. | ||
+ | |style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/ZoomingInAndOut.mov mov] | ||
|- | |- | ||
− | |How to add a second graph to a plot | + | |How to add a second graph to a plot (Excel) |
− | + | ||
|style="text-align:center;"|[http://www.youtube.com/watch?v=GXbvBjkhmvU&feature=youtu.be youtube]. | |style="text-align:center;"|[http://www.youtube.com/watch?v=GXbvBjkhmvU&feature=youtu.be youtube]. | ||
+ | |style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/AddingAnotherGraphToAPlot.mov mov] | ||
|- | |- | ||
− | |Newton's method for solving f(x)=0 | + | |Newton's method for solving f(x)=0 (Excel) |
− | |style="text-align:center;"|[[Media:NewtonsMethod.png| | + | |style="text-align:center;"|[[Media:NewtonsMethod.png| png]] |
− | + | ||
|- | |- | ||
− | | | + | |How to determine when a function does or does not have inflection points (Desmos) |
− | |style="text-align:center;"|[http://www.desmos.com/calculator/ddtcyjgsnu | + | |style="text-align:center;"|[http://www.desmos.com/calculator/ddtcyjgsnu app] |
|style="text-align:center;"|[http://youtu.be/UjZAADz4JQs youtube] | |style="text-align:center;"|[http://youtu.be/UjZAADz4JQs youtube] | ||
+ | |- | ||
+ | |How to find the location of minimum slope for a given function (Google Sheets) | ||
+ | |style="text-align:center;"|[ youtube] | ||
|- | |- | ||
|} | |} |
Revision as of 16:38, 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.
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] |