Geogebra/C2/SpreadsheetViewBasics/English
Title of the tutorials: SpreadsheetViewBasics
Author: Bindu Thirumalai
Key words: Spreadsheet view, histogram, create List, row, column, cell, Create class boundary and Frequency lists video tutorial.
Resources for "Geogebra  Spreadsheet Basics"


Show slide number 1  Hello Everybody. Welcome to the Geogebra tutorial on Basics of Spreadsheets

Switch to slide number 2
(Lesson Objective ) 
To get started with Geogebra, I am using the GNU/Linux operating system Ubuntu Version 10.04 LTS and Geogebra Version 3.2.40.0

Switch to slide number 3
(Lesson Outline) 
In this tutorial we will use the spreadsheet to perform basic data representation and calculations. Use the data to construct a histogram.

Switch to Slide 4
(Lesson Activities) 
First we will use these marks of 50 students in a 50 mark test. From and to class boundaries and frequency is available here. I am going to copy the frequency to the clipboard. 
Switch to Geogebra Window  Now to the geogebra window . First step is to make the spreadsheet view visible. Select menu item view, Check spreadsheet view.
Select these two cells and then drag the blue square on the right here all the way down, notice an arithmetic progression is created. Similarly if I select these two cells.
To create the histogram , go to the input bar here. You can select from the commands or just type histogram here.

Switch to Slide 5
(Lesson Activities) 
Now the next step is to create points and lines in the spreadsheet view to get a set of parallel lines to the Y axis 
Geogebra Window – Spreadsheet View and Geogebra Objects  I will take a new Geogebra window. Any command from the geogebra can be typed in a cell here.
I get the length of the segment 2 between A1 and B1.

Switch to Slide 6
(Assignment) 
Now to the assignments , In the first assignment create a histogram using the following data: distance between home and school for a class of 35 students. I have the class boundaries and frequencies here 
Switch to Slide 7
(Assignment 1) 
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

Switch to Geogebra File BarChart.ggb  I have created this assignments here. Observe the two lists. 
Switch to Slide 8
(Assignment 2) 
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 Radii Use column B of the spreadsheet to create the circles with centre A and radius from Column A Move the Centre point A and observe 
Switch to Geogebra File ConcentricCircles.ggb  In the second assignment observe what happens when the centre point is moved. 
Switch to Slide 9
(Acknowledgement) 
I would like to acknowledge the spoken tutorial project which is part of the talk to a teacher project.

Switch to Slide 10  Thank you this is Bindu signing off. Enjoy exploring Geogebra. 