Tutorial:Combining Spreadsheet View & Graphics View

GeoGebra provides different views of mathematical objects: a Graphics View, a numeric Algebra View and a Spreadsheet View. Thereby, all representations of the same object are linked dynamically and adapt automatically to changes made to any of the representations, no matter how they were initially created.

File:10 views.PGN

Spreadsheet Cells Input

In GeoGebra’s Spreadsheet View every cell has a specific name that allows you to directly address each cell. For example, the cell in column A and row 1 is named A1.

Note: These cell names can be used in expressions and commands in order to address the content of the corresponding cell.

You can not only use numbers in spreadsheet cells, but all types of mathematical objects that are supported by GeoGebra (e.g., coordinates of points, functions, lines). If possible, GeoGebra immediately displays the graphical representation of the object you enter into a spreadsheet cell in the Graphics View as well. Thereby, the name of the object matches the name of the spreadsheet cell used to initially create it (e.g., A5, C1). {{note|By default, spreadsheet objects are classified as auxiliary objects in the Algebra View. You can show or hide these auxiliary objects by selecting Auxiliary Objects from the styling bar at the top of the Algebra View.

Record to Spreadsheet

Preparations

• Open a new GeoGebra window.
• Go to Perspectives – Spreadsheet & Graphics.

Construction Steps

1		Create a slider a with default interval and increment 1. Hint: Select tool Slider and click in the Graphics View to set the position for the slider. In the appearing dialog window change the increment to 1 and click the Apply button.
2		Create point A by entering A = (a, 2a) into the Input Bar. Hint: The value of slider a determines the x-coordinate of point A while the y-coordinate is a multiple of this value.
3		Show the label of point A in the Graphics View.
4		Change the value of slider a to examine different positions of point A.
5		Use tools Move Graphics View, as well as Zoom In and Zoom Out to adjust the visible part of the Graphics View and make point A visible in all positions.
6		Record the coordinates for different positions of point A to the spreadsheet: Select tool Record to Spreadsheet. Then, click on point A in order to highlight it. Note: The coordinates for the actual position of point A are immediately entered into cells A1 (x-coordinate) and B1 (y-coordinate) of the spreadsheet. Now, change the value of slider a in order to record the coordinates of all other possible positions of point A to the spreadsheet as well. Note: Do not switch to another tool before moving the slider.