1,735
edits
Changes
Jump to navigation
Jump to search
no edit summary
Line 3:
Line 3:
=== Introduction ===+==== Basic information ====+==== Overview of features ====+====Installation====+=====For Ubuntu OS=====+===== For Windows OS =====+=====For MAC OS=====+===Working with the application===+====Opening a spreadsheet====+==== Navigating a spreadsheet ====+==== Formatting a spreadsheet ====+==== Freeze or Unfreeze rows and columns ====+
==== Inserting formulae for computations====+==== Sorting the data ====+==== Preparing charts and graphs====+==== Working with Pivot tables ====+==== Print Preview ====+==== Adding Page Header or Footer ====+==== Saving the files and formats ====+==== Advanced features ====+===Ideas for resource creation===+===References===+
[https://teacher-network.in/OER/hi/index.php/%E0%A4%B2%E0%A4%BF%E0%A4%AC%E0%A4%B0%E0%A5%87%E0%A4%91%E0%A4%AB%E0%A4%BF%E0%A4%B8_%E0%A4%95%E0%A5%88%E0%A4%B2%E0%A5%8D%E0%A4%95_%E0%A4%B8%E0%A5%80%E0%A4%96%E0%A4%BF%E0%A4%8F हिन्दी में देखिये]
[https://teacher-network.in/OER/hi/index.php/%E0%A4%B2%E0%A4%BF%E0%A4%AC%E0%A4%B0%E0%A5%87%E0%A4%91%E0%A4%AB%E0%A4%BF%E0%A4%B8_%E0%A4%95%E0%A5%88%E0%A4%B2%E0%A5%8D%E0%A4%95_%E0%A4%B8%E0%A5%80%E0%A4%96%E0%A4%BF%E0%A4%8F हिन्दी में देखिये]
{{Template:Book-sidebar}}
{{Template:Book-sidebar}}
−== Introduction ==
The spreadsheet is a sheet with a collection of columns and rows. It contains number of cells. A cell is a combination or intersection of a row and a column, in which information both text and numeric can be input. A sheet can be simply understood as an array of cells. Altogether Spreadsheets are useful for capturing and analyzing data.
The spreadsheet is a sheet with a collection of columns and rows. It contains number of cells. A cell is a combination or intersection of a row and a column, in which information both text and numeric can be input. A sheet can be simply understood as an array of cells. Altogether Spreadsheets are useful for capturing and analyzing data.
−=== Basic information ===
{| class="wikitable"
{| class="wikitable"
|ICT Competency
|ICT Competency
Line 33:
Line 33:
|}
|}
−=== Overview of features ===
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===
−====For Ubuntu OS====
#The application is part of the Ubuntu custom distribution.
#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
#In case you do not find it on your computer, you can install by choosing “LibreOffice” in Ubuntu Software Centre
Line 45:
Line 45:
##sudo apt-get install libreoffice
##sudo apt-get install libreoffice
−==== For Windows OS ====
# Download "''LibreOffice windows installer''" from below
# 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&lang=pick Click here for the 32-bit version]
Line 79:
Line 79:
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
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.
#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
#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
Line 87:
Line 87:
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]
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]
−==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===
<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
Line 103:
Line 103:
{{clear}}
{{clear}}
−=== 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
Line 120:
Line 120:
{{clear}}
{{clear}}
−=== 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
Line 139:
Line 139:
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 ===
+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
Line 146:
Line 147:
{{clear}}
{{clear}}
−=== 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
Line 163:
Line 164:
{{clear}}
{{clear}}
−=== 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
Line 172:
Line 173:
{{clear}}
{{clear}}
−=== Preparing charts and graphs===
<gallery mode="packed" heights="200px">
<gallery mode="packed" heights="200px">
Line 186:
Line 187:
#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 ===
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">
Line 211:
Line 212:
{{Clear}}
{{Clear}}
−=== 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 ]]
Line 224:
Line 225:
# 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 ===
<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
Line 232:
Line 233:
{{clear}}
{{clear}}
−=== 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").
Line 242:
Line 243:
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 ==
* 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.
Line 251:
Line 252:
* 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==
# 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==
#[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]