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

From UBCMATH WIKI
Jump to: navigation, search
 
(24 intermediate revisions by 3 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"
 
!Title
 
!Title
!style="width:150px;"|Full version
+
!style="width:150px;"|
!Compressed youtube version
+
!
 
|-
 
|-
|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 full]
+
 
|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 full]
+
 
|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 full]
+
 
|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]
 
|-
 
|-
|Understanding the ''wagon wheel effect''
+
|Newton's method for solving f(x)=0 (Excel)
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/WagonWheel.mov full]
+
|style="text-align:center;"|[[Media:NewtonsMethod.png| png]]
|style="text-align:center;"|[http://www.youtube.com/watch?v=7K547kJAs38&feature=youtu.be youtube].
+
 
|-
 
|-
|Finding antiderivatives numerically (numerical integration)
+
|An example of Newton's method using Google sheet
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/AntiderivativesNumerically.mov full]
+
|style="text-align:center;"|[https://docs.google.com/spreadsheets/d/1UHq31ybqFmIY4xELbbsWxIcVfE1Wo3LMe09Sqme_npQ Google sheet]
|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].
+
|-
 +
|How to determine when a function does or does not have inflection points (Desmos)
 +
|style="text-align:center;"|[http://www.desmos.com/calculator/ddtcyjgsnu app]
 +
|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$)
 
|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;"|[http://youtu.be/ZING4RUA0k4 youtube].
|style="text-align:center;"|N/A yet.
+
|style="text-align:center;"|
 
|-
 
|-
 
|Fitting a line to data (part 2 - $y=ax+b$)  
 
|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;"|[http://youtu.be/fX4reKjGVLg youtube].
|style="text-align:center;"|N/A yet.
+
|style="text-align:center;"|
 
|-
 
|-
 
|Euler's method for solving differential equations
 
|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;"|[http://youtu.be/z7Kbp8hl950 youtube].
|style="text-align:center;"|N/A yet.
+
|style="text-align:center;"|
|-
+
|Newton's method for solving f(x)=0
+
|style="text-align:center;"|[[Media:NewtonsMethod.png|.png]]
+
|style="text-align:center;"|N/A.
+
 
|-
 
|-
 
|}
 
|}
 +
 +
 +
<!--
 +
|Understanding the ''wagon wheel effect''
 +
|style="text-align:center;"|[http://slesse.math.ubc.ca/Teaching/Screencasts/WagonWheel.mov full]
 +
|style="text-align:center;"|[http://www.youtube.com/watch?v=7K547kJAs38&feature=youtu.be youtube].
 +
|-
 +
|Finding antiderivatives numerically (numerical integration)
 +
|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].
 +
|-
 +
-->
  
 
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].
  
===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)
 +
|[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]