Geogebra/C3/Spreadsheet-View-Advanced/English-timed
From Script | Spoken-Tutorial
| Time | Narration |
| 00:00 | Hello Everybody. Welcome to this Geogebra tutorial on Spreadsheet view advanced. |
| 00:05 | If this is the first time you are using spreadsheets for Geogebra, please see the spoken tutorial web site for the Spreadsheet View Basics tutorial. |
| 00:15 | In this tutorial, we will use the spreadsheet view to: |
| 00:19 | Record the X and Y coordinates of a point, traced along the function by using a slider. |
| 00:24 | Use the data to recognize number patterns and make predictions about a function graph. |
| 00:29 | To get started with geogebra, I am using the new Linux operating system Ubuntu version 10.04 LTS and the Geogebra version 3.2.40. |
| 00:40 | Now to the Geogebra window. |
| 00:43 | To make the spreadsheet visible, go to the View menu option and check the Spreadsheet View option. |
| 00:52 | Now let us create a slider here named xValue. We will leave the minimum and maximum default value and change the Increment to 1. |
| 01:07 | Let's move the xValue towards minimum value. |
| 01:12 | Plot a point A. Change the coordinates of point A, by right clicking on the point and selecting Object Properties, to xValue for the X coordinate and '3 times xValue' for the Y coordinate. |
| 01:36 | Here we are setting the slope of the line that will be traced by this point to 3. Hit Tab on the keyboard, also select the Show Trace on. |
| 01:50 | And press Close. Let us move the spreadsheet view, so we can see columns A and B. |
| 02:02 | Now let's select the Record to Spreadsheet option in the first tool, the third option here. |
| 02:10 | Select point A. If it is not visible from the drawing pad, please select it from the Algebra View. And then move the slider 'xValue' from minimum to maximum. |
| 02:23 | Notice the X coordinate of point A is traced in column A of the spreadsheet, and the Y coordinate of point A in column B. |
| 02:34 | Once this lesson is prepared you can ask students to predict the function by seeing the visual trace or the data in the Spreadsheet View. |
| 02:44 | The predicted function can be input in the Input bar as f(x) = 3 x. For times in Geogebra we can use the space and press Enter. |
| 03:05 | If the prediction is correct, all the points traced will fall on the line that was input or the function that was input. |
| 03:15 | To summarize: |
| 03:18 | We made a slider xValue. We drew a point A with coordinates (xValue, 3 xValue). |
| 03:27 | We used the Record to Spreadsheet option to record the X and Y coordinates of point A, for different xValues. |
| 03:34 | We predicted an input function by studying the number patterns. |
| 03:40 | Now, to the second part of the lesson. First, let's remove the Trace from point A. |
| 03:53 | Let's add the y intercept parameter. |
| 03:56 | Create another slider and let's name it 'b' leaving the minimum and maximum default values and changing the increment to 1 and click Apply. |
| 04:10 | Next we will move the value of b, use the Move tool and move the value of b to 2, change xValue towards minimum value. |
| 04:24 | Then, right click on point A. Select Object Properties, change the Y coordinate to 3 xValue + b, hit tab on the keyboard. |
| 04:40 | Check the Show Trace on. Then move the spreadsheet view, so you can see column C and D. |
| 04:50 | Place your cursor on cell C1, again use the Record to Spreadsheet option. First, select point A. That's what you want to trace and then move the 'xValue' from minimum to maximum. |
| 05:06 | You can see that the X coordinate of point A is traced in column C of the spreadsheet and Y coordinate of point A in column D. |
| 05:17 | From this data, you can ask the students to understand the pattern and predict the function. |
| 05:22 | Repeat this process for different 'b' values. The predicted function can be input in the Input bar. |
| 05:29 | Since we already have f(x) I will use g(x)= 3 x + b, the value of b here is 2. And press Enter. |
| 05:51 | Now to summarize: we made another slider named 'b', altered point A coordinate to xValue and 3 xValue + b for the y coordinate. |
| 06:02 | used the Record to Spreadsheet option to record the x and y coordinates of point A, for different xValue and b values. |
| 06:11 | We predicted an input function f(x) = 3 x + b. Here we just call the function g(x). |
| 06:23 | Now to the assignment. |
| 06:25 | The assignment consists of tracing a quadratic function by making sliders xValue and a. |
| 06:33 | Plot a point A with coordinates xValue for the x coordinate and xValue^2 for the y coordinate. |
| 06:43 | Use the Record to Spreadsheet option to record the X and Y coordinates of point A for different xValue and a values. |
| 06:51 | And to predict and input the function f(x)= a x^2. To continue with the assignment, we will be tracing a quadratic function a x^2 + bx + 3. |
| 07:05 | We make another slider b. Plot a point A with coordinates xValue, a xValue^2 + b xValue + 3 for the Y coordinate. |
| 07:18 | Use the Record to Spreadsheet option to record the X and Y coordinates of a point A for different a and b value combinations. |
| 07:26 | Predict and input the function f(x) = a x^2 + b x + 3. |
| 07:32 | I have already created this Geogebra file. In this case let us select the Trace On, it's already on. |
| 07:43 | We will change the xValue to minimum and then use the Record to Spreadsheet, select point A and move the xValue slider. |
| 08:05 | We can input the predicted function to f(x) = 2 x^2 + 2 x + 3 is what I have used to set the constant value as. |
| 08:28 | Notice the traces along this parabola. |
| 08:36 | Watch the video available at this web site, it summarizes the spoken tutorial project. If you do not have good bandwidth, you can download and watch it. |
| 08:47 | The spoken tutorial project team conducts workshops using spoken tutorials, gives certificates to those who pass an online test. For more details please contact them at this e-mail address. |
| 09:02 | Spoken Tutorial Project is a part of the Talk to a Teacher project. It is supported by the National Mission on Education through ICT, MHRD, Government of India. More information is available at this web site. |
| 09:16 | Thank you. This is bindu from IT for change, Bengaluru, signing off. Enjoy exploring Geogebra. |
