This is the second post in the OpenOffice Calc Tutorial Series. In this post, we learn entering and editing data as well as basic computation using OpenOffice Calc. In particular, we compute the average quiz grades of four students as in the figure below.
Part I: Basic Input and Editing
First, open OpenOffice Calc and type the data shown in the figure below.
Things to remember in entering and editing data: » Read more
This is the first post in the OpenOffice Calc Tutorial Series. In this post, we familiarize ourselves with the Calc interface.
The Calc environment is very similar to that of Microsoft Excel’s. It is made up of columns and rows. Each column is name by a letter (see column header) and each row is named with a number (see row header). Column D and row 5 are highlighted below.
A cell is an intersection of a column and a row and is named using a cell address. D5 is the cell address of the cell in column D and row 5. The cell where data will appear when you typed is the active cell denoted by a rectangular box called the cell pointer. The name box contains the address of the active cell.
The formula bar is used for entering and editing data and formulas. The menu bar and toolbar are also present just like in most application environment. The sheet tabs contains the different sheets or pages.
Before we begin our tutorial in the next post, try to familiarize yourself with the environment of Calc and its part. We will use terms mentioned above often, so it is important that you are familiar with them.
OpenOffice Calc is one of the software in the OpenOffice.org application suite. Calc is a spreadsheet which is very similar to Microsoft Office’s Excel; in fact, most of the formula and function commands are the same. In this series, we learn the basics of Calc and explore ways to integrate it in teaching and learning mathematics. Below are the the list of tentative topics that we will discuss:
- The Calc Environment
- Data Entry, Editing and Basic Computation
- Working with Formulas (Part 1)
- Working with Formulas (Part 2)
- Formatting and Aesthetics
- Charts and Graphs
- Basic Statistics
- Working with Multiple sheets
OpenOffice.org is the free and open-source equivalent of Microsoft Office.