Geogebra/C2/Spreadsheet-View-Basics/English-timed
From Script | Spoken-Tutorial
| 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. |
