Difference between revisions of "Geogebra/C3/Spreadsheet-View-Advanced/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(13 intermediate revisions by 2 users not shown)
Line 5: Line 5:
 
|-
 
|-
 
||00:00
 
||00:00
||Hello Everybody.
+
||Hello Everybody. Welcome to this Geogebra tutorial on '''Spreadsheet view advanced.'''
 
+
|-
+
||00:01
+
||Welcome to this geogebra tutorial on Spreadsheet view advanced.
+
  
 
|-
 
|-
 
||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 Basics''' tutorial.
  
 
|-
 
|-
 
||00:15
 
||00:15
||In this tutorial we will use the spreadsheet view to
+
||In this tutorial, we will use the spreadsheet view to:
  
 
|-
 
|-
Line 29: Line 25:
 
|-
 
|-
 
||00:29
 
||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
+
||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
 
||00:40
||Now to the geogebra window.
+
||Now to the Geogebra window.
  
 
|-
 
|-
 
||00:43
 
||00:43
||To make the spreadsheet visible go to the view menu option and check the spreadsheet view option.
+
||To make the spreadsheet visible, go to the '''View''' menu option and check the '''Spreadsheet View''' option.
  
 
|-
 
|-
 
||00:52
 
||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.
+
||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
 
||01:07
||Lets move the xValue towards minimum value.
+
||Let's move the '''xValue''' towards minimum value.
  
 
|-
 
|-
 
||01:12
 
||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.
+
||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
 
||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.
+
||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
 
||01:50
||And press close. Let us move the spreadsheet view so we can see columns A and B.
+
||And press '''Close'''. Let us move the spreadsheet view, so we can see columns A and B.
  
 
|-
 
|-
 
||02:02
 
||02:02
||Now lets select the record to spreadsheet option in the first tool the third option here.
+
||Now let's select the '''Record to Spreadsheet''' option in the first tool, the third option here.
  
 
|-
 
|-
 
||02:10
 
||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.
+
||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.
  
 
|-
 
|-
Line 73: Line 69:
 
|-
 
|-
 
||02:34
 
||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.
+
||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
 
||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.
+
||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
 
||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.
+
||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
 
||03:15
||To summarize,
+
||To summarize:
  
 
|-
 
|-
 
||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'''.
  
 
|-
 
|-
 
||03:34
 
||03:34
||We predicted an input function by studying the number patterns
+
||We predicted an input function by studying the number patterns.
  
 
|-
 
|-
 
||03:40
 
||03:40
||Now to the second part of the lesson. First lets remove the trace from point A.
+
||Now, to the second part of the lesson. First, let's remove the '''Trace''' from point A.
  
 
|-
 
|-
 
||03:53
 
||03:53
||Lets add the y intercept parameter
+
||Let's add the y intercept parameter.
  
 
|-
 
|-
 
||03:56
 
||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.
+
||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
 
||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
+
||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
 
||04:24
||Then right click on point A. Select object properties change the y coordinates to 3 xValue + b, hit tab on the keyboard.
+
||Then, right click on point A. Select '''Object Properties''', change the Y coordinate to 3 xValue + b, hit tab on the keyboard.
  
 
|-
 
|-
 
||04:40
 
||04:40
||check the show trace on. Then move the spreadsheet view so you can see column C and D.
+
||Check the '''Show Trace''' on. Then move the '''spreadsheet view''', so you can see column C and D.
  
 
|-
 
|-
 
||04:50
 
||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.
+
||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
 
||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.
+
||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
 
||05:17
||From this data you can ask the students to understand the pattern and predict the function.
+
||From this data, you can ask the students to understand the pattern and predict the function.
  
 
|-
 
|-
 
||05:22
 
||05:22
||Repeat this process for different b values. The predicted function can be input in the input bar.
+
||Repeat this process for different 'b' values. The predicted function can be input in the '''Input bar'''.
  
 
|-
 
|-
 
||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.
  
 
|-
 
|-
 
||05:51
 
||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.
+
||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
 
||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.
  
 
|-
 
|-
 
||06:11
 
||06:11
||We predicted an input function f(x) = 3 x + b. here we just call the function g(x).
+
||We predicted an input function f(x) = 3 x + b. Here we just call the function g(x).
  
 
|-
 
|-
Line 161: Line 157:
 
|-
 
|-
 
||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'''.
  
 
|-
 
|-
 
||06:33
 
||06:33
||Plot a point A with coordinates xValue for the x coordinate and a xValue^2 for the y coordinate.
+
||Plot a point A with coordinates xValue for the x coordinate and xValue^2 for the y coordinate.
  
 
|-
 
|-
 
||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 173:
 
|-
 
|-
 
||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.
  
 
|-
 
|-
 
||07:26
 
||07:26
||predict and input the function f(x) = a x^2 + b x + 3.
+
||Predict and input the function f(x) = a x^2 + b x + 3.
  
 
|-
 
|-
 
||07:32
 
||07:32
||I have already created this geogebra file. In this case let us select the trace on, its already on.
+
||I have already created this Geogebra file. In this case let us select the '''Trace On''', it's already on.
  
 
|-
 
|-
 
||07:43
 
||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.
+
||We will change the xValue to minimum and then use the '''Record to Spreadsheet''', select point A and move the xValue slider.
  
 
|-
 
|-
 
||08:05
 
||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.
+
||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.
  
 
|-
 
|-
Line 213: Line 209:
 
|-
 
|-
 
||09:02
 
||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.
+
||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
 
||09:16
||Thank you. This is bindu from IT for change, Benaluru, signing off. Enjoy exploring geogebra.
+
||Thank you. This is bindu from IT for change, Bengaluru, signing off. Enjoy exploring Geogebra.
 
   
 
   
 
|-
 
|-
  
 
|}
 
|}

Latest revision as of 17:16, 27 March 2017

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.

Contributors and Content Editors

Minal, PoojaMoolya, Pratik kamble, Sandhya.np14