# GeoGebra Tutorial 19 – Basic Spreadsheet Recording

This is the 19th tutorial of the GeoGebra Intermediate Tutorial Series. If this is your first time to use GeoGebra, you might want to read first the GeoGebra Essentials Series.

A spreadsheet is a program that can be used to organize data in tables and  perform mathematical computations. Recently, GeoGebra integrated spreadsheet in its graphical user interface. In this tutorial, we learn how to use the GeoGebra spreadsheet.

Figure 1

The figure above shows the different parts of a spreadsheet.  The following are the descriptions. You should familiarize yourself with these terms because we are going to use them in this tutorial and the two more tutorials to come.

1. Column – the horizontal division of the spreadsheet. Columns are labeled with letters.
2. Row – the vertical division of a spreadsheet. Rows are labeled with numbers.
3. Column/Row Headers – The part of the spreadsheet where the column/row labels are placed.
4. Cells – the smallest unit in a spreadsheet, or the intersection of a column and a row.
5. Cell Addresses – the name used to refer to a particular cell; that is, their column header and row header. For example, cell A1 is the cell on the first column and the first row. F3 is the cell with the orange box in Figure 1.
6. Cell Pointer – a rectangular box that indicates the cell is being edited.

In this tutorial, we use the Record to Spreadsheet tool to record the coordinates of a moving point along a graph of a function.  We graph the function f(x) = x2,  and construct point P with coordinates (a,f(a)), where a is a value on a slider. We  then record the coordinates of the traces of P on the spreadsheet window. The output of this tutorial is shown in Figure 2.

Figure 2

If you want to follow this tutorial step-by-step, you can open the GeoGebra window in your browser by clicking here.  You can view the output of this tutorial here.

Step-by-Step Instructions

Note: It is important to place double quotes on both sides of the text you want write. Typing a single letter may be misinterpreted by the spreadsheet. For example, if you type x without double quotes, the spreadsheet will read it as y = f(x) and GeoGebra will graph the said function.

## 6 thoughts on “GeoGebra Tutorial 19 – Basic Spreadsheet Recording”

1. An excellent tutorial. I could not figure out how to use the spreadsheet option until I saw your explanation. I have also enjoyed some other suggestions.
Best wishes, Carole

• Thanks Carole. I still have 3 to 4 more tutorials on spreadsheet, before proceeding to more advance featuresso just keep posted. 🙂

2. Awesome tutorial.

I’m not sure what I was missing but when I record to the spreadsheet it only shows the independent variable a. Column b is empty.

Any help would be awesome.

Thanks again!

• @Matt.

Thanks for your comment. I followed the tutorial and I actually missed two steps in number 9 (or maybe because of the change of version). Anyway, I just fixed it, so I hope you would be able to do the the worksheet correctly. My apologies.

Kindly inform me if there’s more problem. It will be a great help since I am revising the tutorials for the current version.