Madhurig at 07:49, 18 December 2013

2013-12-18T07:49:21Z

Madhurig at 07:48, 18 December 2013

2013-12-18T07:48:52Z

Chandrika: Created page with '[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"] {| style="border-spacing:0;" | style="border-top:0.002cm…'

2012-11-27T12:09:06Z

Created page with '[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"] {| style="border-spacing:0;" | style="border-top:0.002cm…'

New page

[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"]

{| style="border-spacing:0;"
| style="border-top:0.002cm solid #000000;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Visual Cue
| style="border:0.002cm solid #000000;padding:0.097cm;"| Narration

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Show slide number 1
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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.

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to slide number 2

(Learning Objectives)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to slide number 3

(System Requirements)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Geogebra Window

(Line Through Origin)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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.

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 4 and 5

(Line through Origin)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Geogebra Window – Linear Equation with Y - Intercept
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 6 and 7

(Line with Y Intercept)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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)

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 8

(Assignment)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 9

(Assignment contd)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Geogebra File Quadratic.ggb
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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.

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 10

(About the Spoken Tutorial Project)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 11

(About Spoken Tutorial Workshops)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 12

(Acknowledgements)
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| 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

|-
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:none;padding:0.097cm;"| Switch to Slide 13
| style="border-top:none;border-bottom:0.002cm solid #000000;border-left:0.002cm solid #000000;border-right:0.002cm solid #000000;padding:0.097cm;"| Thank you this is Bindu from IT for Change, Bengaluru signing off.

Enjoy exploring Geogebra.

|}

← Older revision		Revision as of 07:49, 18 December 2013
Line 4:		Line 4:

	Keywords: Spreadsheet View, slider, 'Trace On', 'Record to Spreadsheet', 'input bar', Quadratic Function, minimum, increment and maximum values		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.	+	columns, cell, functions, 'quadratic coefficient', Spoken tutorial, video tutorial.

← Older revision		Revision as of 07:48, 18 December 2013
Line 1:		Line 1:
		+	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.
		+
		+
	[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"]		[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"]

Geogebra/C3/Spreadsheet-View-Advanced/English - Revision history

Madhurig at 07:49, 18 December 2013

Madhurig at 07:48, 18 December 2013

Chandrika: Created page with '[http://spoken-tutorial.org/wiki/images/3/31/Spreadsheet_view_Advanced.zip Resources for "Spreadsheet View - Advanced"] {| style="border-spacing:0;" | style="border-top:0.002cm…'