Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets.
If this is the first time you are using Geogebra, please see the Introduction to Geogebra tutorial on the spoken tutorial website.
To get started with Geogebra, I am using the GNU/Linux operating system Ubuntu Version 10.04 LTS and the Geogebra Version 3.2.40.0.
The objective of this tutorial is to see how to use the Spreadsheet in Geogebra.
In this tutorial, we will use the spreadsheet to perform basic data representation and calculations
and use the data to construct a histogram.
We will also see how the spreadsheet view can be used to create recurring Geogebra objects like creating a set of parallel lines.
First, we will use the marks of 50 students in a 50 mark test.
The 'From' and 'To' class boundaries and 'Frequency' is available here.
I am going to copy the Frequency on to the clipboard.
Now to the Geogebra window.
The first step is to make the spreadsheet view visible.
Select the menu item View, and check the Spreadsheet View.
Let's move the spreadsheet view here.
The first column A represents the From class boundary, column B To and column C Frequency.
Now, I have copied the Frequency , so let me paste it here.
Now for the 'From' and 'To' values,
I did not paste these because I will show you another feature of geogebra spreadsheets.
First I will start with
0,
then 5, 5
and 10.
Now, if I select the two cells here and then drag this blue square all the way down, notice an arithmetic progression is created.
Similarly, I can do that for the 'To' values.
Let us create the class boundary list and the frequency list. To do that, select the column B here.
Right Click and say Create List. Notice L1 here, which means L_1 is created.
We just have to modify this by right clicking and checking on Object properties and making sure the first value zero appears here.
and press Close.
Now for the 'Frequency' list, do the same thing. Select the Frequency, right click and say Create list.
I have L_2.
Now to create the histogram , go to the input bar here.
You can select from the commands here or you can just type histogram.
Now, right here, between the square brackets, if you press Enter, it tells you the different options.
One of the options is, the List of Class Boundaries and List of Raw Data. Let's use that.
I would say L_1, geogebra is case sensitive, and for the class boundaries and L_2 for the frequencies and press Enter.
Notice that the histogram is created here.
Now, to make the histogram more visible or readable , I will use the Move Drawing Pad. And then I will also right click on Drawing pad properties here and change this Distance to 5 which is the width of each bar and say Close.
Then I can Zoom Out.
And again Move the Drawing pad.
Notice when I create the histogram, it creates this value a=250.
a is the sum of the product of length and width of each bar.
I can move this a value up here.
The next step is to create points and lines in the spreadsheet view to get a set of parallel lines to the Y axis.
I will take a new Geogebra window.
Now, any command from the Geogebra can be typed in a cell here.
First, to create a point, you just have to give a point like this.
Notice the point appears here with the name A1, which is column A, row 1, the cell address with coordinates 1,2.
Similarly, I can type in here 2,2 and press enter. I get A2.
Now, If I select these two cells and then drag the blue square down,
let me move this here.
For this tutorial I will close the Algebra view.
Notice I get 10 points here.
And similarly I will, in column B, I will.
1,4 as a point. I get this point here. I can right click and say Show Label, it shows B1- the cell address.
I can type in
2,4 and I get B2.
I can again drag this and I get 10 points here.
Now in the third column, if I want to create the line segment,
I can use the geogebra command Segment and in the value I can give the cell address A1
let me move this here,
,(comma) B1 and say Enter.
This is the length of the line which is between A1 and B1.
Now I can just select this cell and drag it all the way down, I get a set of 10 parallel lines.
One more thing to note is if you go to Options and Algebra,
right now it's at Value. So you see the length of the line in the column C.
I can change it to Command and it will show me the command.
Now to do assignments ,
In the first assignment, create a histogram using the following data of a Distance between home and school for a class of 35 students.
I have the class boundaries and frequencies here.
Use the spreadsheet view to represent the data * Create class boundary and Frequency lists.
Use the input bar to create the histogram with the lists.
Change the frequency and observe the change in the histogram.
I have already created this tutorial here.
Notice the
histogram here.
Now to the next assignment.
In assignment two, we will create concentric circles using the spreadsheet view.
Draw a point A on the drawing pad to mark the centre of the circle. * Use the spread sheet to create a column A of Radius.
Use column B of the spreadsheet to create the circles with centre A and the radius from Column A.
Move the Centre point A and observe.
I have created assignment here.
Move the center point and
observe the circles.
I would like to acknowledge the spoken tutorial project which is part of the talk to a teacher project.
It is supported by the National Mission on Education through ICT, MHRD government of India.
You can see more information about this at this website.
Thank you. This is Bindu, signing off. Enjoy exploring Geogebra.