Difference between revisions of "Geogebra/C3/Spreadsheet-View-Advanced/English-timed"
From Script | Spoken-Tutorial
| Line 13: | Line 13: | ||
|- | |- | ||
||00:05 | ||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 basic tutorial. | + | ||If this is the first time you are using spreadsheets for geogebra please see the spoken tutorial web site for the '''spreadsheet view basic tutorial'''. |
|- | |- | ||
| Line 89: | Line 89: | ||
|- | |- | ||
||03:18 | ||03:18 | ||
| − | ||We made a slider 'xValue'. We drew a point A with coordinates (xValue, 3 xValue) | + | ||We made a slider '''xValue'''. We drew a point A with coordinates (xValue, 3 xValue) |
|- | |- | ||
||03:27 | ||03:27 | ||
| − | ||We used the 'Record to Spreadsheet' option to record the X and Y coordinates of point A, for different xValues. | + | ||We used the '''Record to Spreadsheet''' option to record the X and Y coordinates of point A, for different xValues. |
|- | |- | ||
| Line 141: | Line 141: | ||
|- | |- | ||
||05:29 | ||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. | + | ||Since we already have f(x) i will use g(x)= 3 x + b the value of '''b''' here is 2. And press enter. |
|- | |- | ||
| Line 149: | Line 149: | ||
|- | |- | ||
||06:02 | ||06:02 | ||
| − | ||used the Record to Spreadsheet option to record the x and y coordinates of point A, for different 'xValue' and 'b' values. | + | ||used the Record to Spreadsheet option to record the x and y coordinates of point A, for different '''xValue''' and '''b''' values. |
|- | |- | ||
| Line 161: | Line 161: | ||
|- | |- | ||
||06:25 | ||06:25 | ||
| − | ||The assignment consists of tracing a quadratic function by making sliders 'xValue' and 'a' | + | ||The assignment consists of tracing a quadratic function by making sliders '''xValue''' and '''a''' |
|- | |- | ||
| Line 169: | Line 169: | ||
|- | |- | ||
||06:43 | ||06:43 | ||
| − | ||Use the Record to Spreadsheet option to record the x and y coordinates of point A, for different 'xValue' and 'a' values. | + | ||Use the Record to Spreadsheet option to record the x and y coordinates of point A, for different '''xValue''' and '''a''' values. |
|- | |- | ||
| Line 177: | Line 177: | ||
|- | |- | ||
||07:05 | ||07:05 | ||
| − | ||We make another slider 'b'. Plot a point A with coordinates xValue, a xValue^2 + b xValue + 3 for the y coordinate. | + | ||We make another slider '''b'''. Plot a point A with coordinates xValue, a xValue^2 + b xValue + 3 for the y coordinate. |
|- | |- | ||
||07:18 | ||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. | + | ||Use the Record to Spreadsheet option to record the x and y coordinates of a point A, for different '''a''' and '''b''' value combinations. |
|- | |- | ||
Revision as of 11:54, 5 September 2014
| Time | Narration |
| 00:00 | Hello Everybody. |
| 00:01 | 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 basic 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 | Lets 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 lets 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 lets remove the trace from point A. |
| 03:53 | Lets add the y intercept parameter |
| 03:56 | Create another slider and lets 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 coordinates 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 thats 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 a 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, its already on. |
| 07:43 | We will change the x value to minimum, and the 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, Benaluru, signing off. Enjoy exploring geogebra. |
