Changes

File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface

File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface

</gallery>

</gallery>

LibreOffice  Calc can be opened from Applications  → Office  → LibreOffice Calc. This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application,  it will show a window like this. The spreadsheet consists of rows and columns.  Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter. <br>

* LibreOffice  Calc can be opened from Applications  → Office  → LibreOffice Calc. This opens a ‘work book’. A work book can have many ‘sheets’. When you open the LO Calc application,  it will show a window like this. The spreadsheet consists of rows and columns.  Each column-row intersection is a cell; this is the place you will enter data in a spreadsheet. You can click the cursor on any cell and type in the information you want to enter. <br> Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall. <br> You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type CTRL+B) to make the headings '''bold.'''

Select Cell A1 and type “Name of city”, Hit enter. Next select cell B1 and type “Average annual rainfall (cms). Hit enter, and select cells of Column A to enter names of cities and Cells of Column B to enter annual average rainfall. <br>

You can click on the A1 and B1 cells and click on the BOLD function icon (or simply type CTRL+B) to make the headings '''bold.'''

 

Like in the case of text document, you can use the File menu to save your spreadsheet.  The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.

Like in the case of text document, you can use the File menu to save your spreadsheet.  The file will be saved with a .ods extension. ODS is the short form of Open Document Spreadsheet.

{{clear}}

{{clear}}

File:Cal step 2.png|Navigation from various sheets

File:Cal step 2.png|Navigation from various sheets

</gallery>

</gallery>

You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using CTRL Keys, such as CTRL-Home (go to Cell A1), CTRL-End (bottom rightmost part of filled cells / entered data), CTRL – Up Arrow (next cell in same column, before an empty cell) etc. <br>

* You can move across cells using the arrow keys. You can also quickly go to the ends of the sheet using CTRL Keys, such as CTRL-Home (go to Cell A1), CTRL-End (bottom rightmost part of filled cells / entered data), CTRL – Up Arrow (next cell in same column, before an empty cell) etc. <br> It is useful to become comfortable using keyboard to move across the spreadsheet.<br> Columns and rows can be inserted or deleted or hidden in a spreadsheet.  You can right click anywhere on the spreadsheet and insert/ delete rows and columns.  You can also go to Sheet menu and insert rows/ columns.  <br>

It is useful to become comfortable using keyboard to move across the spreadsheet.<br>

 

Columns and rows can be inserted or deleted or hidden in a spreadsheet.  You can right click anywhere on the spreadsheet and insert/ delete rows and columns.  You can also go to Sheet menu and insert rows/ columns.  <br>

==== Inserting a new sheet ====

==== Inserting a new sheet ====

Sheets can be added or deleted from a work book using the "+" symbol seen next to the sheet name.  Sheets can be named and renamed by right clicking on the name of the sheet visible in the bottom panel.

Sheets can be added or deleted from a work book using the "+" symbol seen next to the sheet name.  Sheets can be named and renamed by right clicking on the name of the sheet visible in the bottom panel.

* There are two useful options available for any cells known as Merge cell and Split cell.

* There are two useful options available for any cells known as Merge cell and Split cell.

* Merge cell combines two or more cells together to make it as one. For example, If you want the main heading to be given in a particular column which is having two or more submenus or subsections you can use this feature. To merge cells, select two or more cells and right click on anyone of the selected cells and click on merge cell.

* Merge cell combines two or more cells together to make it as one. For example, If you want the main heading to be given in a particular column which is having two or more sub menus or subsections you can use this feature. To merge cells, select two or more cells and right click on anyone of the selected cells and click on merge cell.

* Split cell is needed when you accidentally merged the cells which are no longer required and you want them to be the separate cells. To Split a merged cell, give right click on the merged cell and click split cell.

* Split cell is needed when you accidentally merged the cells which are no longer required and you want them to be the separate cells. To Split a merged cell, give right click on the merged cell and click split cell.

</gallery>

</gallery>

We saw earlier how to enter headings for columns. However, if you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View → Freeze Cells → Freeze Rows and Columns.

In a case, If you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View → Freeze Cells → Freeze Rows and Columns.

{{clear}}

{{clear}}

File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot

File:2. LO Calc Pivot 2. Inserting pivot.png|Inserting Pivot

</gallery>

</gallery>

1. Position the cursor within a range of cells containing values, row and column headings. <br>2. Choose Insert - Pivot Table - Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as <br>

# Position the cursor within a range of cells containing values, row and column headings.  

# Choose Insert --> Pivot Table --> Create. The Select Source dialog appears. Choose Current selection and confirm with OK. The table headings are shown as

# The table headings are shown as buttons in the Pivot Table dialog. Drag these buttons as required and drop them into the layout areas "Page Fields", "Column Fields", "Row Fields" and "Data Fields". <br>Drag the desired buttons into one of the four areas.<br><br>

<gallery mode="packed" heights="250">   

<gallery mode="packed" heights="250">   

File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard  

File:3. LO Calc Data Pivot 3. Current Selection.png|Selection wizard  

File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>

File:4. LO Calc Data Pivot 4. Pivot form.png|Pivot Table wizard </gallery>

Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br>

Drag a button to the '''Page Fields''' area to create a button and a listbox on top of the generated pivot table. The listbox can be used to filter the pivot table by the contents of the selected item. You can use drag-and-drop within the generated pivot table to use another page field as a filter. <br>

<gallery mode="packed" heights="200">

<gallery mode="packed" heights="200">

==== Advanced features ====

==== Advanced features ====

Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books. You can also generate multi-variate tables using the 'Pivot' feature. The 'functions' in Calc are many and can meet statistical, mathematical functions which can be useful for exploring topics in Mathematics and Statistics. You can use Calc to store contact information, which can be used along with the Thunderbird email client, to generate customised mass email messages (this functionality is called 'mail merge'). You can repeat the column or row headings automatically across printed  pages (hint – define print area). You can refer to the [https://wiki.documentfoundation.org/images/4/47/CG41-CalcGuideLO.pdf Calc user manual] for learning these advanced features

* Calc is a very sophisticated software application and can even be used as a database, by cross referring data across sheets and books.  

* You can also generate multi-variate tables using the 'Pivot' feature.  

* The 'functions' in Calc are many and can meet statistical, mathematical functions which can be useful for exploring topics in Mathematics and Statistics.  

* You can use Calc to store contact information, which can be used along with the Thunderbird email client, to generate customised mass email messages (this functionality is called 'mail merge').  

* You can repeat the column or row headings automatically across printed  pages (hint – define print area). You can refer the references section for learning these advanced features.

===Ideas for resource creation===

===Ideas for resource creation===

# Calc can be used for analysing data sets generated by your students as part of projects. Large secondary data sets can also be analysed.  Some of these project ideas include information about family members, houses in the area, crops / vegetation in the area, goods sold and prices in local shop and programs of the local government and budgets etc. The collected information can be analysed and published in tabular cum graph formats.  

# Calc can be used for analyzing data sets generated by your students as part of projects. Large secondary data sets can also be analyzed.  Some of these project ideas include information about family members, houses in the area, crops / vegetation in the area, goods sold and prices in local shop and programs of the local government and budgets etc. The collected information can be analyzed and published in tabular cum graph formats.  

# Spreadsheets are also useful for helping solving numeric puzzles by setting up formulas and extrapolating.  

# Spreadsheets are also useful for helping solving numeric puzzles by setting up formulas and extrapolating.