Difference between revisions of "Supporting materials for computational WeBWorK problems"

From UBCMATH WIKI
Jump to: navigation, search
(→‎For those using Excel or similar spreadsheets)
 
(20 intermediate revisions by 2 users not shown)
Line 1: Line 1:
−
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.
+
Here are some videos, interactive tools and screenshots demonstrating techniques and ideas that will be useful for doing the computational 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.  
−
 
+
−
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.
+
  
 
{|style="border-collapse: collapse;" class="withlines"
 
{|style="border-collapse: collapse;" class="withlines"
Line 10: Line 8:
 
!
 
!
 
|-
 
|-
−
|How to plot the graph of a function
+
|How to plot the graph of a function (Excel)
−
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/PlottingGraphsOfFunctions.mov mov]
+
 
|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://slesse.math.ubc.ca/Teaching/Screencasts/ZoomingInAndOut.mov mov]
+
 
|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://slesse.math.ubc.ca/Teaching/Screencasts/AddingAnotherGraphToAPlot.mov mov]
+
 
|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|spreadsheet screenshot (png)]]
+
|style="text-align:center;"|[[Media:NewtonsMethod.png| png]]
−
|style="text-align:center;"|
+
|-
 +
|An example of Newton's method using Google sheet
 +
|style="text-align:center;"|[https://docs.google.com/spreadsheets/d/1UHq31ybqFmIY4xELbbsWxIcVfE1Wo3LMe09Sqme_npQ Google sheet]
 
|-
 
|-
−
|Using Desmos to determine when a function does or does not have inflection points
+
|How to determine when a function does or does not have inflection points (Desmos)
−
|style="text-align:center;"|[http://www.desmos.com/calculator/ddtcyjgsnu Desmos app]
+
|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;"|[http://www.youtube.com/watch?v=kRDAAjlSKc8 new video] ([http://www.youtube.com/watch?v=xtdQkTuV6IQ old video])
 +
|-
 +
|How to estimate slope using slope of secant line (Google Sheets)
 +
|style="text-align:center;"|[http://youtu.be/C5bUS3Pdqds youtube]
 +
|-
 +
|Fitting a line to data (part 1 - $y=ax$)
 +
|style="text-align:center;"|[http://youtu.be/ZING4RUA0k4 youtube].
 +
|style="text-align:center;"|
 +
|-
 +
|Fitting a line to data (part 2 - $y=ax+b$)
 +
|style="text-align:center;"|[http://youtu.be/fX4reKjGVLg youtube].
 +
|style="text-align:center;"|
 +
|-
 +
|Euler's method for solving differential equations
 +
|style="text-align:center;"|[http://youtu.be/z7Kbp8hl950 youtube].
 +
|style="text-align:center;"|
 
|-
 
|-
 
|}
 
|}
Line 41: Line 59:
 
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/AntiderivativesNumerically.mov full]
 
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/AntiderivativesNumerically.mov full]
 
|style="text-align:center;"|[http://www.youtube.com/watch?v=FeDB9O2r0e0&feature=youtu.be part 1], [http://www.youtube.com/watch?v=g6LOihN1dKE&feature=youtu.be part 2].
 
|style="text-align:center;"|[http://www.youtube.com/watch?v=FeDB9O2r0e0&feature=youtu.be part 1], [http://www.youtube.com/watch?v=g6LOihN1dKE&feature=youtu.be part 2].
−
|-
 
−
|Fitting a line to data (part 1 - $y=ax$)
 
−
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/LinearRegression1.mov full]
 
−
|style="text-align:center;"|N/A yet.
 
−
|-
 
−
|Fitting a line to data (part 2 - $y=ax+b$)
 
−
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/LinearRegression2.mov full]
 
−
|style="text-align:center;"|N/A yet.
 
−
|-
 
−
|Euler's method for solving differential equations
 
−
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/EulersMethod.mov full]
 
−
|style="text-align:center;"|N/A yet.
 
 
|-
 
|-
 
-->
 
-->
Line 58: Line 64:
 
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].
  
−
===LEK says: check out some of these Additional resources online (Other Videos, not Math 102 related)===
+
===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 )
−
|[https://www.youtube.com/watch?v=jrodFbUWL8s]
+
|[https://www.youtube.com/watch?v=CYMbu4p3VMQ]
 
|-
 
|-
 
|ScatterPlot on iPad Numbers
 
|ScatterPlot on iPad Numbers
−
|[https://www.youtube.com/watch?v=-mCPTlYY13I]
+
|[http://www.youtube.com/watch?v=-mCPTlYY13I]
 
|-
 
|-
 
|Two plots on same axes on iPad Numbers
 
|Two plots on same axes on iPad Numbers
−
|[https://www.youtube.com/watch?v=qv3Een81ycc]
+
|[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)
−
|[https://www.youtube.com/watch?v=J7YBtwfZLrU]
+
|[http://www.youtube.com/watch?v=J7YBtwfZLrU]
  
 
|}
 
|}
 +
 +
<!-- Number of views as of Sept 6, 2016: 9,948 -->

Latest revision as of 17:18, 27 September 2017

Here are some videos, interactive tools and screenshots demonstrating techniques and ideas that will be useful for doing the computational WeBWorK problems. These will continue to appear as the term progresses so keep coming back to see the newest ones.

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.

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
An example of Newton's method using Google sheet Google sheet
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) new video (old video)
How to estimate slope using slope of secant line (Google Sheets) youtube
Fitting a line to data (part 1 - $y=ax$) youtube.
Fitting a line to data (part 2 - $y=ax+b$) youtube.
Euler's method for solving differential equations 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 ) [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]


Retrieved from "https://wiki.math.ubc.ca/mathbook/M102/index.php?title=Supporting_materials_for_computational_WeBWorK_problems&oldid=8051"