Title of script: Spreadsheet-View-Advanced
Author: Bindu Thirumalai
Keywords: Spreadsheet View, slider, 'Trace On', 'Record to Spreadsheet', 'input bar', Quadratic Function, minimum, increment and maximum values
columns, cell, functions, 'quadratic coefficient', Spoken tutorial, video tutorial.
Resources for "Spreadsheet View - Advanced"
| Visual Cue
|
Narration
|
| Show slide number 1
|
Hello Everybody.
Welcome to this Geogebra tutorial on Spreadsheet View Advanced
If this is the first time you are using spreadsheets with Geogebra,
please see the spoken tutorial website for the “Spreadsheets view Basics” tutorial.
|
| Switch to slide number 2
(Learning Objectives)
|
In this tutorial
we will use the spreadsheet view to
record X and Y Coordinates of a Point traced along a function by using a slider
Use the data to recognise number patterns and make predictions about a function graph
|
| Switch to slide number 3
(System Requirements)
|
To get started with Geogebra,
I am using the GNU/Linux operating system Ubuntu Version 10.04 LTS
and Geogebra Version 3.2.40.0
|
| Switch to Geogebra Window
(Line Through Origin)
|
Now to the Geogebra Window.
To make the spreadsheet visible,
Go to View Menu option and check the spreadsheet view option .
Create a slider named xValue
we will leave the minimum and maximum default values
and change the increment to 1.
Move the xValue to its minimum value
Plot a point A
Change the Coordinates of Point A
by Right Clicking and selecting Object Properties to xValue for the x coordinate and 3 times Xvalue for the Y coordinate
Here we are setting the slope of the line that this point will traced by this point to 3 .
Hit tab on the key board
Also select the “Trace On” Option and click close
Let us move the spreadsheet view so we can see columns A and B
Select the “Record to Spreadsheet” Option in the first tool , the third option here,
select point A if it is not visible on the drawing pad then select it from the algebra view
Move the slider xValue from the minimum to maximum.
Notice the x coordinate of point A.
This is traced in Column A of the spreadsheet
and the Y coordinate of point A in column B.
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.
The predicted function can be an input in the input bar. f(x) = 3 times x.
For times in GeoGebra we can just use space, press enter
If the prediction is correct all the points traced will fall on the line that was input or the function that was input.
|
| Switch to Slide 4 and 5
(Line through Origin)
|
To Summarise,
we made a slider xValue
Drew a point A with coordinates (xValue, 3 xValue)
Used the Record To Spreadsheet option
to record the x and y coordinates of point A,
for different 'xValue' values
Predicted and input the function by studying the number patterns
|
| Geogebra Window – Linear Equation with Y - Intercept
|
Now to the second part of the lesson
First lets remove Trace on Point A
Lets add the Y Intercept parameter
create a slider named b
with default minimum and maximum values
and increment of 1 and click apply.
Move the value of b to 2
Set xValue to the minimum
Right click on point A select obkect properties and Change the Coordinates of Point A to (xValue, 3 Xvalue + b)
Hit tab on the keyboard
Check the show trace on then move the spreadsheet view so you can see columns C and D.
Place your cursor on cell C1
Select the Record to Spreadsheet Option ,
select point A
Move the slider x Value from the minimum to maximum.
Notice the x coordinate of point A is traced in Column C of the spreadsheet
and the Y coordinate of point A in column D.
From this data you can ask the student to understand the pattern and predict the function.
Repeat this process for different b values
The predicted function can be input in the input bar. g(x) = 3 x + b, the value of b here is 2. Press Enter
|
| Switch to Slide 6 and 7
(Line with Y Intercept)
|
To summarise again,
We made another slider named b
Altered point A coordinates (xValue, 3 xValue + b)
Used the Record To Spreadsheet option
to record the x and y coordinates of point A,
for different ’xValue’ and ’b’ values
Predicted an input function f(x) =
3x+b . Here we just called the function g(x)
|
| Switch to Slide 8
(Assignment)
|
Now to the assignments –
Trace a Quadratic Function
Make sliders ’xValue’ and 'a' for the quadratic coefficient
Plot a point A with coordinates (xValue, a xValue2)
Use the Record To Spreadsheet option to record the x and y coordinates of point A, for different ’xValue’ and 'a' values
Predict and input the f(x) = a x2
|
| Switch to Slide 9
(Assignment contd)
|
Make another slider b for the linear coefficient and set the constant term to 3
Plot a point A with coordinates (xValue, a xValue2 + b xValue + 3)
for the Y coordinate
Use the Record To Spreadsheet option to record the x and y coordinates of point A, for different ’a’ and ’b’ value combinations
Predict and input the f(x) = a x2 + b x + 3
|
| Switch to Geogebra File Quadratic.ggb
|
I have already this assignments here. In this case let us select the trace on. We will change the xValue to the minimum. And then use the record to spreadsheet, select point A and move the xValue slider. We can input the predicted function 2 x squared + 2 x + 3. Notice the trace is along the parabola.
|
| Switch to Slide 10
(About the Spoken Tutorial Project)
|
Watch the video available at
http://spoken-tutorial.org
/What is a Spoken Tutorial
It summarises the Spoken Tutorial
project
If you do not have good
bandwidth, you can download
and watch it
|
| Switch to Slide 11
(About Spoken Tutorial Workshops)
|
The Spoken Tutorial Project Team
Conducts workshops using spoken
tutorials
Gives certificates to those who
pass an online test
For more details, contact
sptutemail@gmail.com
|
| Switch to Slide 12
(Acknowledgements)
|
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 on this Mission
is available at : http://spoken-tutorial.org
/NMEICT-Intro
|
| Switch to Slide 13
|
Thank you this is Bindu from IT for Change, Bengaluru signing off.
Enjoy exploring Geogebra.
|
