290
edits
Changes
Jump to navigation
Jump to search
Line 36:
Line 36: − + − ====For Ubuntu OS====+ − #The application is part of the Ubuntu custom distribution. − #In case you do not find it on your computer, you can install by choosing “LibreOffice” in Ubuntu Software Centre − #If you would like to install through the terminal follow these steps below: − ##Open terminal by clicking (Ctrl+Alt+T), − ##Once Window page is open, in front of dollar($) symbol just type below command. − ##sudo apt-get install libreoffice − ==== For Windows OS ====+ − # Download "''LibreOffice windows installer''" from below − ##[https://www.libreoffice.org/download/libreoffice-fresh/?type=win-x86&lang=pick Click here for the 32-bit version] − ## [https://www.libreoffice.org/download/libreoffice-fresh/?type=win-x86_64&lang=pick Click here for the 64-bit version] − # If you are unsure which Windows version you have, press Win+Pause to open your system properties window. The LibreOffice Main Installer download page can be selected with a built-in help file for your language: − # Double-click on download "''LibreOffice_..._Win_x64.msi''" file to begin installation − # It will start downloading "LibreOffice" into your computer (by default browser will save the files in ''Downloads'' folder in your system) − Click "Yes" if it asks your permission to allow this program make change to the computer. The installation wizard welcome dialog box opens advising that the installation process is about to be started. Click “Next” − <gallery mode="packed" heights="300px">+ − File:Step1 LO Installation.png|Downloading LibreOffice − File:Step2 LO Installation.png|Installation wizard − </gallery> − − Another dialog box opens, giving you a choice whether you want a default installation, or whether you want to choose special locations and components. If you want a default installation, click “Next”. <gallery mode="packed" heights="400px"> − File:Step3 LO Installation.png|Setup type − File:Step6 LO Installation.png|File type selection − </gallery> − − Another dialog box opens, inviting you to choose whether to open Microsoft Office documents with LibreOffice. By default, this feature is not enabled. If you want LibreOffice to open Microsoft Office files (documents, spreadsheets and presentations), put a check mark in all four check boxes. Another dialog box opens, asking you whether: − − * A shortcut to open LibreOffice should be placed on your desktop. The default option is to create a shortcut. − * To load LibreOffice during system start-up. − − <gallery mode="packed" heights="400px"> − File:Step7 LO Installation.png|Ready to install the program − File:Step9 LO Installation.png|Finish − </gallery> − − − − If you are not able to install LibreOffice in your windows machine''''',''''' [https://www.libreoffice.org/get-help/install-howto/windows/ follow this official website installation instruction] or [https://youtu.be/ne-8PMLCj_k Click here] to see the LibreOffice Installation- English Tutorial − − ====For MAC OS==== − #Click [https://www.fosshub.com/LibreOffice.html this link] and click on "''LibreOffice MAC OS"'' for MAC laptops. − #It will start downloading "''LibreOffice_..._MacOS_x86-64.dmg"'' into your computer (by default browser will save the files in "''Downloads"'' folder in your system − #Double-click on download "''LibreOffice_..._MacOS_x86-64.dmg"'' file to begin installation − #An installation window appears: drag and drop the LibreOffice icon onto the Applications icon in the same window. You may be required to enter your administrator password. − #The files are copied over and a progress bar shows when the installation is complete. − If you are not able to install LibreOffice in your MAC machine, [https://www.libreoffice.org/get-help/install-howto/macos/ follow this official website installation instructions] − − − + Line 103:
Line 58: − + Line 120:
Line 75: − + Line 139:
Line 94: − + − Line 147:
Line 101: − + Line 164:
Line 118: − + Line 173:
Line 127: − + Line 187:
Line 141: − + Line 212:
Line 166: − + Line 225:
Line 179: − + Line 233:
Line 187: − + Line 243:
Line 197: − + Line 252:
Line 206: − + − +
Learn LibreOffice Calc (view source)
Revision as of 11:29, 26 September 2022
, 11:29, 26 September 2022→Installation
Spreadsheet application is used for recording, processing and analyzing data. It is also used for creating text and graphical outputs. The application has many arithmetical, statistical, text processing functions which make it a very powerful desktop tool. Data can be sorted, filtered and processed into outputs, including multi-variate tables.
Spreadsheet application is used for recording, processing and analyzing data. It is also used for creating text and graphical outputs. The application has many arithmetical, statistical, text processing functions which make it a very powerful desktop tool. Data can be sorted, filtered and processed into outputs, including multi-variate tables.
===Installation===
==== Installation ====
Please click on the below link to learn about LibreOffice Installation & Configuration
[https://teacher-network.in/OER/index.php/LibreOffice_Installation_and_Configuration Click here]
===Working with the application===
==Working with the application==
# [https://teacher-network.in/OER/images/9/96/REDUCED_MINIMUM_-_Learning_spreadsheet_-_Bangalore_South_3_Block_Schools_Dise_data_2015-16_March_2018.ods Download this file] to practice on a simple sample data sheet.
# [https://teacher-network.in/OER/images/9/96/REDUCED_MINIMUM_-_Learning_spreadsheet_-_Bangalore_South_3_Block_Schools_Dise_data_2015-16_March_2018.ods Download this file] to practice on a simple sample data sheet.
# [https://teacher-network.in/OER/images/1/1d/Bangalore_South_3_Block_Schools_Dise_data_2015-16_aided_September_2017.ods Download this file] of additional sheets with analyses, reports etc.
# [https://teacher-network.in/OER/images/1/1d/Bangalore_South_3_Block_Schools_Dise_data_2015-16_aided_September_2017.ods Download this file] of additional sheets with analyses, reports etc.
===Opening a spreadsheet===
====Opening a spreadsheet====
<gallery mode="packed" heights="350">
<gallery mode="packed" heights="350">
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
File:LO Calc 1 viewing a spreadsheet.png|Basic spreadsheet interface
{{clear}}
{{clear}}
=== Navigating a spreadsheet ===
==== Navigating a spreadsheet ====
<gallery mode="packed" heights="350">
<gallery mode="packed" heights="350">
File:Cal step 2.png|Navigation from various sheets
File:Cal step 2.png|Navigation from various sheets
{{clear}}
{{clear}}
=== Formatting a spreadsheet ===
==== Formatting a spreadsheet ====
<gallery mode="packed" heights="350">
<gallery mode="packed" heights="350">
File:LO Calc 6 Formatting numbers.png| Formatting in Calc
File:LO Calc 6 Formatting numbers.png| Formatting in Calc
To Split a merged cell, right click on the merged cell and click "split cell".
To Split a merged cell, right click on the merged cell and click "split cell".
=== Freeze or Unfreeze rows and columns ===
==== Freeze or Unfreeze rows and columns ====
If you enter data for a large number of rows or columns, you will not be able to read the row/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".<gallery mode="packed" heights="320">
If you enter data for a large number of rows or columns, you will not be able to read the row/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".<gallery mode="packed" heights="320">
File:LO Calc 2 Freeze rows and columns.png|Freezing the cells
File:LO Calc 2 Freeze rows and columns.png|Freezing the cells
{{clear}}
{{clear}}
=== Inserting formulae for computations===
==== Inserting formulae for computations====
<gallery mode="packed" heights="400">
<gallery mode="packed" heights="400">
File:LO Calc 3 Processing the data .png|Inserting the formula
File:LO Calc 3 Processing the data .png|Inserting the formula
{{clear}}
{{clear}}
=== Sorting the data ===
==== Sorting the data ====
<gallery mode="packed" heights="320">
<gallery mode="packed" heights="320">
File:LO_Calc_4_Sorting_data.png|Sorting the Data
File:LO_Calc_4_Sorting_data.png|Sorting the Data
{{clear}}
{{clear}}
=== Preparing charts and graphs===
==== Preparing charts and graphs====
<gallery mode="packed" heights="200px">
<gallery mode="packed" heights="200px">
#In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".
#In the Last window Give the title if you want it to be appeared on the top of the chart. Click "Finish".
=== Working with Pivot tables ===
==== Working with Pivot tables ====
The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.
The pivot table (formerly known as Data Pilot) allows you to combine, compare, and analyze large amounts of data. You can view different summaries of the source data, you can display the details of areas of interest, and you can create reports. A table that has been created as a pivot table is an interactive table. Data can be arranged, rearranged or summarized according to different points of view.
<gallery mode="packed" heights="250">
<gallery mode="packed" heights="250">
{{Clear}}
{{Clear}}
=== Print Preview ===
==== Print Preview ====
Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.
Before printing any document you must make sure about the overall preview of the page. So get that you can click on "File--> Print Preview". This gives user the broader idea of how the printed material looks like.
[[File:LO Calc Margin.png|thumb|Setting the margin ]]
[[File:LO Calc Margin.png|thumb|Setting the margin ]]
# Use "Format --> Page" option to insert header / footer information, such as file name, page number etc. <br>Use "Print preview" feature to keep checking if the formatting is satisfactory <br>
# Use "Format --> Page" option to insert header / footer information, such as file name, page number etc. <br>Use "Print preview" feature to keep checking if the formatting is satisfactory <br>
=== Adding Page Header or Footer ===
==== Adding Page Header or Footer ====
<gallery mode="packed" heights="300">
<gallery mode="packed" heights="300">
File:LO Calc Header Footer.png|Header/Footer option in Print Preview
File:LO Calc Header Footer.png|Header/Footer option in Print Preview
{{clear}}
{{clear}}
=== Saving the files and formats ===
==== Saving the files and formats ====
# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.
# Like in most applications, a file can be saved using the File –-> Save command, or by the shortcut key Ctrl+S. Always give a meaningful file name, reading which you should get an idea of the file contents. This file has been named “''Rainfall information for cities in South India, October 2016.ods''”. Often adding the month-year information when the file was created can be useful later.
# The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").
# The files will be saved as ".ods". You can save a spreadsheet as a Microsoft Excel format also ("File --> Save As").
To do this, "File --> Export as PDF". A window appears which lets you to change the default settings. You can do the required changes and click "Export". In the next window it asks you to give the path where to export the file.
To do this, "File --> Export as PDF". A window appears which lets you to change the default settings. You can do the required changes and click "Export". In the next window it asks you to give the path where to export the file.
== 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.
* 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.
* You can also generate multi-variate tables using the 'Pivot' feature.
* Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.
* Vlookup is an interesting feature with which you can query for a particular information using a simple syntax.
==Ideas for resource creation==
===Ideas for resource creation===
# 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.
# 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.
==References==
===References===
#[https://en.wikipedia.org/wiki/LibreOffice_Calc Wikipedia]
#[https://en.wikipedia.org/wiki/LibreOffice_Calc Wikipedia]
#[https://help.libreoffice.org/scalc/.uno:HelpIndex?Language=en-US&System=UNIX&Version=5.2 User manual for LO Calc]
#[https://help.libreoffice.org/scalc/.uno:HelpIndex?Language=en-US&System=UNIX&Version=5.2 User manual for LO Calc]