436
edits
Changes
Jump to navigation
Jump to search
Line 45:
Line 45: − + Line 95:
Line 95: + + +
no edit summary
===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 practise 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 practise 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 second 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 second file of additional sheets with analyses, reports etc.
#Selecting data - Select the data (columns A and B) and select Insert → chart option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn
#Selecting data - Select the data (columns A and B) and select Insert → chart option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn
#Inserting charts - You can prepare charts and show it alongside the data
#Inserting charts - You can prepare charts and show it alongside the data
==== Working with Pivot tables ====
A pivot table is a table that summarizes data from another table, and is made by applying an operation such as sorting, averaging, or summing to data in the first table, typically including grouping of the data.
==== Printing a spreadsheet ====
==== Printing a spreadsheet ====