LibreOffice Calc basics


 * 1) A spreadsheet is a software application used for computations and data processing eg LibreOffice Calc, OpenOffice Calc
 * 2) Spreadsheet is made of rows and columns which are referred to by numbers and alphabets
 * 3) A cell is a combination of a row and a column which is referred to by alphabet+number eg A1, N100
 * 4) Basic features
 * 5) Insert row/column (INSERT- ROW, INSERT -COLUMN)
 * 6) Delete row/column (EDIT- DELETE CELLS-DELETE ROW/COLUMN)
 * 7) Hide row/column (FORMAT -ROW/COLUMN -HIDE)
 * 8) Show row/column (FORMAT -ROW/COLUMN -SHOW)
 * 9) Others - multiple sheets (One_cluster, one_block, Mix), workbook, naming book and sheet,
 * 10) Basic column width, row height etc
 * 11) Freeze panes (column headings) WINDOW - FREEZE
 * 12) Important commands – SORT
 * 13) Sorting – is used to sort the data by a particular column or set of columns (DATA-SORT)
 * 14) If column headings are not seen, use TAB  and tick 
 * 15) Use Edit- select All (or control A) to select sheet before DATA-SORT
 * 16) e.g. sort DISE data by DISTRICTNAME-BLOCKNAME-CLUSTERCD or RURAL-GIRLSTOILET or sort School Admission Register data by Sex, Mother tongue
 * 17) FILTER
 * 18) Used to filter some rows based on selection
 * 19) Use Edit- select All (or control A) to select sheet before DATA-SORT
 * 20) Do DATA-FILTER-AUTO FILTER to create a filter (you can see Arrow sign on each column)
 * 21) Click on the arrow on any column to select filter
 * 22) Filter School Admission Register data on APL/BPL
 * 23) FORMULA
 * 24) Addition, (total boys, total girls in HPS =AE2+AG2+AI2+AK2)
 * 25) Copy formula across rows by double clicking bottom right part when you get + sign
 * 26) Sum of TOTENR for the cluster (use sigmal sign, or formula =sum(AK2:AK12)
 * 27) Division ( Teacher pupil ration = Total children / Teachers posted 'P' =AL2/Jj2)
 * 28) Use formula for other cases – subtraction, multiplication, division, percentages
 * 29) Use formula to connect across work sheets and across work books
 * 30) If then conditional formula (calculate student grades from marks, download student grade computation.ods. Use CCE Register to calculate student grades from marks)
 * 31) Can use statistical functions – average, product, Frequency, Countif etc
 * 32) Other features
 * 33) List of values (validation for data entry)
 * 34) Algebra – plotting linear equations in single and two variables
 * 35) Creating graphs from tabular data
 * 36) Copy paste from ODS to ODT (table)
 * 37) Paste special – formatted text, transpose cells to convert rows to columns and vice versa
 * 38) Formatting spreadsheets
 * 39) Print rage definition for spreadsheets to repeat row headings in printouts
 * 40) Text alignment (word wrap) to control column width
 * 41) Header and Footer information
 * 42) Data Pilot
 * 43) Open the spreadsheet “Yadgir Primary School DISE 2010 Information for Decision Support.ods”
 * 44) Select the data – through Control Home (to go to top), then Control Shift Down Arrow and Control Shift Right Arrow
 * 45) Data - Data Pilot - Start - Current Selection
 * 46) You will see the Data Pilot Form. It has four boxes -
 * 47) Move BLKNAME to Row Fields
 * 48) Move SCHME_DESC to Column Fields
 * 49) Move SCHNAME to Data field
 * 50) Double click on SCHNAME in the Data field and select Function COUNT (can also do this through Options button)
 * 51) Move LIB_RARY to Page Fields
 * 52) Click on OK.  The Data Pilot is the most advanced feature in spreadsheet software application. It can be used to analyze data in multiple ways
 * 53) Practice using spreadsheet
 * 54) Use the spreadsheet to create data pilot
 * 55) Insert a column “Total Boys” and use formula to add the number of girls class 1,2,3,4,5,6,7,8. Hide the columns containing number of boys so that the ##Total girls is seen after the columns with number of girls
 * 56) Calculate the number (count) of schools which are in rural areas and which do not have girls toilet facility
 * 57) Number of schools with private management
 * 58) Number of children (sum of girls and boys)