Difference between revisions of "Geogebra/C2/Spreadsheet-View-Basics/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(4 intermediate revisions by one other user not shown)
Line 5: Line 5:
 
|-
 
|-
 
||00:01
 
||00:01
||Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets
+
||Hello Everybody. Welcome to the Geogebra tutorial on '''Basics of Spreadsheets'''.
  
 
|-
 
|-
 
||00:05
 
||00:05
||If this is the first time you are using Geogebra, please see the “Introduction to Geogebra” Tutorial on the spoken tutorial website.
+
||If this is the first time you are using Geogebra, please see the '''Introduction to Geogebra''' tutorial on the spoken tutorial website.
  
 
|-
 
|-
 
||00:12
 
||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
+
||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
 
||00:23
||The objective of this tutorial is see how to use the Spreadsheet in Geogebra
+
||The objective of this tutorial is to see how to use the '''Spreadsheet''' in Geogebra.
  
 
|-
 
|-
 
||00:29
 
||00:29
||In this tutorial we will use the spreadsheet to perform basic data representation and calculations.
+
||In this tutorial, we will use the spreadsheet to perform basic data representation and calculations
  
 
|-
 
|-
 
||00:36
 
||00:36
||and Use the data to construct a histogram.
+
||and use the data to construct a histogram.
  
 
|-
 
|-
Line 33: Line 33:
 
|-
 
|-
 
||00:49
 
||00:49
||First we will use the marks of 50 students in a 50 mark test.
+
||First, we will use the marks of 50 students in a 50 mark test.
  
 
|-
 
|-
 
||00:53
 
||00:53
||the From and to class boundaries and frequency is available here.
+
||The 'From' and 'To' class boundaries and 'Frequency' is available here.
  
 
|-
 
|-
 
||00:59
 
||00:59
||I am going to copy the frequency on to the clipboard.
+
||I am going to copy the Frequency on to the clipboard.
  
 
|-
 
|-
 
||01:05
 
||01:05
||Now to the geogebra window.
+
||Now to the Geogebra window.
  
 
|-
 
|-
Line 53: Line 53:
 
|-
 
|-
 
||01:13
 
||01:13
|| Select the menu item view, and Check the spreadsheet view.
+
|| Select the menu item View, and check the Spreadsheet View.
  
 
|-
 
|-
 
||01:19
 
||01:19
||lets move the spreadsheet view here.
+
||Let's move the spreadsheet view here.
  
 
|-
 
|-
 
||01:25
 
||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.
  
 
|-
 
|-
 
||01:36
 
||01:36
||Now I have copied the frequency , so let me paste it here.
+
||Now, I have copied the Frequency , so let me paste it here.
  
 
|-
 
|-
 
||01:41
 
||01:41
||Now for the From and To values.
+
||Now for the 'From' and 'To' values,
  
 
|-
 
|-
Line 89: Line 89:
 
|-
 
|-
 
||02:04
 
||02:04
||and 10
+
||and 10.
  
 
|-
 
|-
 
||02:06
 
||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.
+
||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
 
||02:16
||Similarly I can do that for the To value.
+
||Similarly, I can do that for the 'To' values.
  
 
|-
 
|-
 
||02:22
 
||02:22
||Let us create the class boundary list and the frequency list. To do that select the column B here.
+
||Let us create the class boundary list and the frequency list. To do that, select the column B here.
  
 
|-
 
|-
 
||02:30
 
||02:30
||Right Click and say create List. Notice L1 here which means L_1 is created.
+
||Right Click and say Create List. Notice L1 here, which means L_1 is created.
  
 
|-
 
|-
 
||02:40
 
||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   
+
||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
 
||02:53
||and press close.  
+
||and press Close.  
  
 
|-
 
|-
 
||02:57
 
||02:57
||Now for the frequency list do the same thing. Select the frequency right click and say create list.
+
||Now for the 'Frequency' list, do the same thing. Select the Frequency, right click and say Create list.
  
 
|-
 
|-
Line 129: Line 129:
 
|-
 
|-
 
||03:15
 
||03:15
||You can select from the commands here or you can just type histogram.
+
||You can select from the '''commands''' here or you can just type '''histogram'''.
  
 
|-
 
|-
 
||03:22
 
||03:22
||Now right here between the square brackets, if you press Enter it tells you the different options.  
+
||Now, right here, between the square brackets, if you press Enter, it tells you the different options.  
  
 
|-
 
|-
 
||03:28
 
||03:28
||One of the options is the list of class boundaries and list of raw data.lets use that
+
||One of the options is, the '''List of Class Boundaries and List of Raw Data'''. Let's use that.
  
 
|-
 
|-
 
||03:35
 
||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.
+
||I would say L_1, geogebra is case sensitive, and for the class boundaries and L_2 for the frequencies and press Enter.
  
 
|-
 
|-
Line 149: Line 149:
 
|-
 
|-
 
||03:52
 
||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.
+
||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
 
||04:15
||Then I can zoom out.  
+
||Then I can '''Zoom Out'''.  
  
 
|-
 
|-
 
||04:22
 
||04:22
||And again move the drawing pad.
+
||And again '''Move the Drawing pad'''.
  
 
|-
 
|-
Line 165: Line 165:
 
|-
 
|-
 
||04:34
 
||04:34
||A is the sum of the product of length and width of each bar
+
||'''a''' is the sum of the product of length and width of each bar.
  
 
|-
 
|-
 
||04:41
 
||04:41
||I can move this A value up here.  
+
||I can move this '''a''' value up here.  
  
 
|-
 
|-
 
||04:49
 
||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
+
||The next step is to create points and lines in the spreadsheet view to get a set of parallel lines to the Y axis.
  
 
|-
 
|-
Line 181: Line 181:
 
|-
 
|-
 
||05:02
 
||05:02
||Now any command from the geogebra can be typed in a cell here.
+
||Now, any command from the Geogebra can be typed in a cell here.
  
 
|-
 
|-
 
||05:07
 
||05:07
||First to create a point, you just have to give a point like this  
+
||First, to create a point, you just have to give a point like this.
  
 
|-
 
|-
 
||05:19
 
||05:19
||Notice the point appears here with the name A1, which is column A row 1 the cell address with coordinates 1,2.
+
||Notice the point appears here with the name A1, which is column A, row 1, the cell address with coordinates 1,2.
  
 
|-
 
|-
 
||05:34
 
||05:34
||Similarly I can type in here 2.2 and press enter I get A2.
+
||Similarly, I can type in here 2,2 and press enter. I get A2.
  
 
|-
 
|-
 
||05:45
 
||05:45
||Now If I select these two cells and then drag the blue square down  
+
||Now, If I select these two cells and then drag the blue square down,
  
 
|-
 
|-
Line 205: Line 205:
 
|-
 
|-
 
||05:56
 
||05:56
||For this tutorial I will close the Algebra view.  
+
||For this tutorial I will close the '''Algebra view'''.  
  
 
|-
 
|-
 
||06:02
 
||06:02
||notice I get 10 points here.
+
||Notice I get 10 points here.
  
 
|-
 
|-
 
||06:08
 
||06:08
||And similarly I will in column B I will  
+
||And similarly I will, in column B, I will.
  
 
|-
 
|-
 
||06:16
 
||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.
+
||1,4 as a point. I get this point here. I can right click and say '''Show Label''', it shows B1- the cell address.
  
 
|-
 
|-
Line 225: Line 225:
 
|-
 
|-
 
||06:35
 
||06:35
||2,4 and I get b 2.
+
||2,4 and I get B2.
  
 
|-
 
|-
Line 233: Line 233:
 
|-
 
|-
 
||06:48
 
||06:48
||Now In the third column if i want to create the line segment.
+
||Now in the third column, if I want to create the line segment,
  
 
|-
 
|-
 
||06:56
 
||06:56
||I can use the geogebra command segment and in the value I can give the cell address A1
+
||I can use the geogebra command '''Segment''' and in the value I can give the cell address A1
  
 
|-
 
|-
 
||07:08
 
||07:08
||let me move this here  
+
||let me move this here,
  
 
|-
 
|-
 
||07:12
 
||07:12
||,B1 and say enter.
+
||,(comma) B1 and say Enter.
  
 
|-
 
|-
 
||07:17
 
||07:17
||this is the length of the line which is between A1 and B1.
+
||This is the length of the line which is between A1 and B1.
  
 
|-
 
|-
Line 257: Line 257:
 
|-
 
|-
 
||07:33
 
||07:33
||One more thing to note is if you go to options and Algebra.
+
||One more thing to note is if you go to '''Options''' and '''Algebra''',
  
 
|-
 
|-
 
||07:40
 
||07:40
||Right now it's at value so you see the length of the line in the column C.  
+
||right now it's at '''Value'''. So you see the length of the line in the column C.  
  
 
|-
 
|-
 
||07:44
 
||07:44
||I can change it to command and it will show me the command.
+
||I can change it to '''Command''' and it will show me the command.
  
 
|-
 
|-
Line 273: Line 273:
 
|-
 
|-
 
||07:55
 
||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.
+
||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
 
||08:04
||I have the class boundaries and frequencies here
+
||I have the class boundaries and frequencies here.
  
 
|-
 
|-
 
||08:09
 
||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
 
||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
 
||08:18
||Change the frequency and observe the change in the histogram
+
|| Change the frequency and observe the change in the histogram.
  
 
|-
 
|-
Line 297: Line 297:
 
|-
 
|-
 
||08:26
 
||08:26
||notice the  
+
||Notice the  
  
 
|-
 
|-
 
||08:31
 
||08:31
||histogram here  
+
||histogram here.
  
 
|-
 
|-
Line 309: Line 309:
 
|-
 
|-
 
||08:36
 
||08:36
||In assignment two we will Create concentric circles using the spreadsheet view
+
||In assignment two, we will create concentric circles using the spreadsheet view.
  
 
|-
 
|-
 
||08:43
 
||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
+
||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
 
||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
 
||08:58
||Move the Centre point A and observe  
+
||Move the Centre point A and observe.
  
 
|-
 
|-
Line 333: Line 333:
 
|-
 
|-
 
||09:10
 
||09:10
||observe the circles  
+
||observe the circles.
  
 
|-
 
|-
Line 349: Line 349:
 
|-
 
|-
 
||09:27
 
||09:27
||Thank you this is Bindu signing off. Enjoy exploring Geogebra.
+
||Thank you. This is Bindu, signing off. Enjoy exploring Geogebra.
  
 
|}
 
|}

Latest revision as of 17:59, 26 October 2016

Time Narration
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 to 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 Let's 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' values.
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. Let's use that.
03:35 I would say L_1, geogebra is case sensitive, 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 B2.
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 ,(comma) 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 Radius.
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.

Contributors and Content Editors

Madhurig, Minal, Pratik kamble, Sandhya.np14