View source for Geogebra/C3/Spreadsheet-View-Advanced/English-timed

{| border=1
|| VISUAL CUE
|| 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.
 
|-

|}