Introduction to spreadsheet application; starting Calc and its parts

Hello students, welcome to Kwickprep. Your class teacher adds marks of forty students in five subjects. Doing this on paper takes hours, and one mistake means doing it again. A spreadsheet does it in seconds. Today we will learn what a spreadsheet is, how to start LibreOffice Calc, and the parts of its window.

A spreadsheet is a computer program that works like an electronic register. It is a grid of rows and columns, like a big table. Each small box can store a number or some text. It can calculate totals, averages and percentages using formulas. When you change a mark, every total that uses it changes by itself.

Let us compare a paper register with a spreadsheet. Adding forty totals by hand is slow, but a spreadsheet does it in seconds. On paper, fixing one mark means redoing the total, while a spreadsheet updates it automatically. On paper you draw a graph by hand, but a spreadsheet makes a chart in a few clicks. And a spreadsheet file can be saved and copied easily.

Spreadsheets are used almost everywhere. Schools use them for marks, result sheets and attendance. Families use them for a monthly budget and to track electricity bills. A kirana shop uses them to track stock, sales and bills. Offices use them for salary sheets and reports.

There are many spreadsheet programs. LibreOffice Calc is made by The Document Foundation, and it is free and open source. Open source means anyone can see and improve its code. Microsoft Excel is made by Microsoft and is paid software. Google Sheets is made by Google and works free inside a web browser. In this lesson we use LibreOffice Calc, but the ideas are the same in all of them.

Here are the steps to start Calc on Windows. First, click the Start button on the taskbar. Then find and open LibreOffice in the list of apps. Next, click LibreOffice Calc. A new blank spreadsheet opens, ready for data.

There are a few other ways to start Calc. On a Linux computer, open Applications, then Office, then LibreOffice Calc. If the LibreOffice Start Center is open, click Calc Spreadsheet. You can also double-click a saved Calc file, which ends with .ods, and it opens in Calc.

Now let us learn the parts of the Calc window, starting from the top. The title bar is at the very top and shows the file name, like Untitled 1 for a new file. Below it is the menu bar, with menus such as File, Edit and Insert. The standard toolbar has buttons to open, save and print. The formatting toolbar has buttons for font, bold and alignment.

Below the toolbars is the formula bar, which has four parts. The Name Box on the left shows the address of the selected cell, like A1. The Function Wizard button, marked with fx, helps you pick a ready function. The Sum button, with the Greek sigma sign, adds numbers quickly. The input line on the right shows what is inside the selected cell, even a full formula.

Next comes the work area, where your data lives. Column headers are the letters A, B, C along the top. Row headers are the numbers one, two, three down the left side. A cell is one box where a row and a column meet, and it holds one entry. The cell pointer is the thick border around the active cell, the cell you are typing in. Scroll bars on the right and bottom move you around the sheet.

Finally, the bottom of the window. Sheet tabs at the bottom left show sheet names like Sheet 1, and you click one to switch sheets. The status bar at the very bottom shows the sheet number, and the sum and average of selected cells. The zoom slider at the bottom right makes the sheet look bigger or smaller.

Two words students often mix up. A workbook, also called a spreadsheet file, is the whole Calc file, saved with the .ods extension. A worksheet is one sheet, or page, inside that file. One workbook can hold many worksheets, like a register with many pages. Pause and predict: is Sheet 1 a workbook or a worksheet? It is a worksheet.

Let us revise what we learned today. A spreadsheet is a grid of rows and columns that stores data and calculates. Calc is free, Excel is paid, and Google Sheets works online. To start Calc on Windows, click Start, open LibreOffice, then click LibreOffice Calc. The formula bar has the Name Box, the Function Wizard, the Sum button and the input line. A workbook is the whole file, and a worksheet is one sheet inside it. Open Calc today and find each part yourself.