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