Madhurig at 12:29, 26 October 2016

2016-10-26T12:29:18Z

Sandhya.np14 at 06:27, 23 April 2015

2015-04-23T06:27:17Z

Sandhya.np14 at 06:24, 23 April 2015

2015-04-23T06:24:33Z

Sandhya.np14 at 12:35, 20 February 2015

2015-02-20T12:35:49Z

Show changes

Sandhya.np14 at 10:40, 20 February 2015

2015-02-20T10:40:47Z

Show changes

Pratik kamble at 06:42, 9 July 2014

2014-07-09T06:42:49Z

Minal: Created page with '{|Border=1 ||Time ||Naraation |- ||00:01 ||Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets |- ||00:05 ||If this is the first time you are using Geog…'

2012-12-26T12:31:14Z

Created page with '{|Border=1 ||Time ||Naraation |- ||00:01 ||Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets |- ||00:05 ||If this is the first time you are using Geog…'

New page

{|Border=1
||Time
||Naraation

|-
||00:01
||Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets

|-
||00:05
||If this is the first time you are using Geogebra, please see the “Introduction to Geogebra” Tutorial on the spoken tutorial website.

|-
||00:12
||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

|-
||00:23
||The objective of this tutorial is see how to use the Spreadsheet in Geogebra

|-
||00:29
||In this tutorial we will use the spreadsheet to perform basic data representation and calculations.

|-
||00:36
||and Use the data to construct a histogram.

|-
||00:39
||We will also see how the spreadsheet view can be used to create recurring Geogebra objects like creating a set of parallel lines.

|-
||00:49
||First we will use the marks of 50 students in a 50 mark test.

|-
||00:53
||the From and to class boundaries and frequency is available here.

|-
||00:59
||I am going to copy the frequency on to the clipboard.

|-
||01:05
||Now to the geogebra window.

|-
||01:09
||The first step is to make the spreadsheet view visible.

|-
||01:13
|| Select the menu item view, and Check the spreadsheet view.

|-
||01:19
||lets move the spreadsheet view here.

|-
||01:25
||the first column A represents the from class boundary.column b To and column c frequency.

|-
||01:36
||Now I have copied the frequency , so let me paste it here.

|-
||01:41
||Now for the From and To values.

|-
||01:46
||I did not paste these because I will show you another feature of geogebra spreadsheets.

|-
||01:53
||First I will start with

|-
||01:56
||0,

|-
||01:59
||then 5, 5

|-
||02:04
||and 10

|-
||02:06
||Now if I select the two cells here and then drag this blue square all the way down, notice an arithmetic progression is created.

|-
||02:16
||Similarly I can do that for the To value.

|-
||02:22
||Let us create the class boundary list and the frequency list. To do that select the column B here.

|-
||02:30
||Right Click and say create List. Notice L1 here which means L_1 is created.

|-
||02:40
||We just have to modify this by right clicking and checking on object properties and making sure the first value zero appears here

|-
||02:53
||and press close.

|-
||02:57
||Now for the frequency list do the same thing. Select the frequency right click and say create list.

|-
||03:04
||I have L_2.

|-
||03:09
||Now to create the histogram , go to the input bar here.

|-
||03:15
||You can select from the commands here or you can just type histogram.

|-
||03:22
||Now right here between the square brackets, if you press Enter it tells you the different options.

|-
||03:28
||One of the options is the list of class boundaries and list of raw data.lets use that

|-
||03:35
||I would say L_1 geogebra is case sensetive and for the class boundaries and L_2 for the frequencies and press Enter.

|-
||03:47
||Notice that the histogram is created here.

|-
||03:52
||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.

|-
||04:15
||Then I can zoom out.

|-
||04:22
||And again move the drawing pad.

|-
||04:28
||Notice when I create the histogram, it creates this value a=250.

|-
||04:34
||A is the sum of the product of length and width of each bar

|-
||04:41
||I can move this A value up here.

|-
||04:49
||the next step is to create points and lines in the spreadsheet view to get a set of parallel lines to the Y axis

|-
||04:56
||I will take a new Geogebra window.

|-
||05:02
||Now any command from the geogebra can be typed in a cell here.

|-
||05:07
||First to create a point, you just have to give a point like this

|-
||05:19
||Notice the point appears here with the name A1, which is column A row 1 the cell address with coordinates 1,2.

|-
||05:34
||Similarly I can type in here 2.2 and press enter I get A2.

|-
||05:45
||Now If I select these two cells and then drag the blue square down

|-
||05:54
||let me move this here.

|-
||05:56
||For this tutorial I will close the Algebra view.

|-
||06:02
||notice I get 10 points here.

|-
||06:08
||And similarly I will in column B I will

|-
||06:16
||1,4 as a point I get this point here I can right click and say show label it shows B1 the cell address.

|-
||06:28
||I can type in

|-
||06:35
||2,4 and I get b 2.

|-
||06:41
||I can again drag this and I get 10 points here.

|-
||06:48
||Now In the third column if i want to create the line segment.

|-
||06:56
||I can use the geogebra command segment and in the value I can give the cell address A1

|-
||07:08
||let me move this here

|-
||07:12
||,B1 and say enter.

|-
||07:17
||this is the length of the line which is between A1 and B1.

|-
||07:23
||Now I can just select this cell and drag it all the way down, I get a set of 10 parallel lines.

|-
||07:33
||One more thing to note is if you go to options and Algebra.

|-
||07:40
||Right now it's at value so you see the length of the line in the column C.

|-
||07:44
||I can change it to command and it will show me the command.

|-
||07:51
||Now to do assignments ,

|-
||07:55
||In the first assignment create a histogram using the following data of a Distance between home and school for a class of 35 students.

|-
||08:04
||I have the class boundaries and frequencies here

|-
||08:09
||Use the spreadsheet view to represent the data Create class boundary and Frequency lists

|-
||08:15
||Use the input bar to create the histogram with the lists

|-
||08:18
||Change the frequency and observe the change in the histogram

|-
||08:22
||I have already created this tutorial here.

|-
||08:26
||notice the

|-
||08:31
||histogram here

|-
||08:33
||Now to the next assignment.

|-
||08:36
||In assignment two we will Create concentric circles using the spreadsheet view

|-
||08:43
||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 Radias

|-
||08:52
||Use column B of the spreadsheet to create the circles with centre A and the radius from Column A

|-
||08:58
||Move the Centre point A and observe

|-
||09:02
||I have created assignment here.

|-
||09:06
||Move the center point and

|-
||09:10
||observe the circles

|-
||09:12
||I would like to acknowledge the spoken tutorial project which is part of the talk to a teacher project.

|-
||09:18
||It is supported by the National Mission on Education through ICT, MHRD government of India.

|-
||09:23
||You can see more information about this at this website.

|-
||09:27
||Thank you this is Bindu signing off. Enjoy exploring Geogebra.

|}

@@ Line 61: / Line 61: @@
 |-
 ||01:25
-||The first column A represents the From class boundary, column B To and column c Frequency.
+||The first column A represents the From class boundary, column B To and column C Frequency.
 |-

@@ Line 53: / Line 53: @@
 |-
 ||01:13
-|| Select the menu item View, and check the Spreadsheet view.
+|| Select the menu item View, and check the Spreadsheet View.
 |-

@@ Line 1: / Line 1: @@
 {|Border=1
-||Time
+||'''Time'''
-||Naraation
+||'''Narration'''
 |-

@@ Line 281: / Line 281: @@
 |-
 ||08:09
-||* Use the spreadsheet view to represent the data * Create class boundary and Frequency lists.
+||Use the spreadsheet view to represent the data * Create class boundary and Frequency lists.
 |-
 ||08:15
-||* Use the input bar to create the histogram with the lists.
+||Use the input bar to create the histogram with the lists.
 |-
 ||08:18
-||* Change the frequency and observe the change in the histogram.
+|| Change the frequency and observe the change in the histogram.
 |-
@@ Line 313: / Line 313: @@
 |-
 ||08:43
-|| * 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.
+||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.
 |-
 ||08:52
-||* Use column B of the spreadsheet to create the circles with centre A and the radius from Column A.
+||Use column B of the spreadsheet to create the circles with centre A and the radius from Column A.
 |-
 ||08:58
-||* Move the Centre point A and observe.
+||Move the Centre point A and observe.
 |-