Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Basic-Data-Manipulation/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 1: Line 1:
−
    __TOC__
+
   
−
=Resources for recording=
+
−
[[Media:Basicmanipulation.zip |Basic Data Manipulation]]
+
−
 
+
  
 
{| border=1
 
{| border=1
Line 30: Line 27:
 
|-
 
|-
 
|| 00:17
 
|| 00:17
−
|| Here we are using Ubuntu Linux version 10.04 as our operating system and  LibreOffice Suite version 3.3.4
+
|| Here we are using GNU/Linux as our operating system and  LibreOffice Suite version 3.3.4
  
 
|-
 
|-
Line 37: Line 34:
  
 
|-
 
|-
−
|| 00:35
+
|| 00:33
 
||Formulas are equations that use numbers and variables to get a result.
 
||Formulas are equations that use numbers and variables to get a result.
  
 
|-
 
|-
−
|| 00:41
+
|| 00:39
 
||In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.
 
||In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.
  
Line 53: Line 50:
  
 
|-
 
|-
−
||01:02
+
||01:01
 
|| In our “personal finance tracker.ods” file, let us see how to add the cost of all the expenses mentioned under the heading, “Cost”.
 
|| In our “personal finance tracker.ods” file, let us see how to add the cost of all the expenses mentioned under the heading, “Cost”.
  
Line 61: Line 58:
  
 
|-
 
|-
−
|| 01:19
+
|| 01:18
 
||And we shall click on the cell A8 and give the serial number as “7”.
 
||And we shall click on the cell A8 and give the serial number as “7”.
  
 
|-
 
|-
−
|| 01:25
+
|| 01:24
 
|| Now lets click on cell number “C8” where we want to display the total of the costs.
 
|| Now lets click on cell number “C8” where we want to display the total of the costs.
  
 
|-
 
|-
−
|| 01:32
+
|| 01:31
 
|| In order to add all the costs, we’ll type“is equal to SUM” and within braces the range of columns to be added,that is,”C3 colon C7”.
 
|| In order to add all the costs, we’ll type“is equal to SUM” and within braces the range of columns to be added,that is,”C3 colon C7”.
  
 
|-
 
|-
−
|| 01:44
+
|| 01:43
 
||Now press “Enter” on the keyboard.
 
||Now press “Enter” on the keyboard.
  
 
|-
 
|-
−
|| 01:47
+
|| 01:46
 
||You see that all the items under “Cost” gets added.
 
||You see that all the items under “Cost” gets added.
  
 
|-
 
|-
−
|| 01:51
+
|| 01:50
 
|| Now lets learn how to subtract in Calc.
 
|| Now lets learn how to subtract in Calc.
  
 
|-
 
|-
−
|| 01:55
+
|| 01:54
 
|| If we want to subtract the cost of “House Rent” and “ Electricity Bill”, and display it in the cell referenced as A9, simply click on the A9 cell first.
 
|| If we want to subtract the cost of “House Rent” and “ Electricity Bill”, and display it in the cell referenced as A9, simply click on the A9 cell first.
  
Line 93: Line 90:
  
 
|-
 
|-
−
|| 02:17
+
|| 02:16
 
||Press the “Enter” key on the keyboard.
 
||Press the “Enter” key on the keyboard.
  
 
|-
 
|-
−
|| 02:20
+
|| 02:19
 
|| We see that the cost in the two cell references get subtracted and the result is displayed in cell number A9.
 
|| We see that the cost in the two cell references get subtracted and the result is displayed in cell number A9.
  
 
|-
 
|-
−
|| 02:29
+
|| 02:28
 
||Lets undo the changes.
 
||Lets undo the changes.
  
 
|-
 
|-
−
|| 02:32
+
|| 02:31
 
|| Similarly, one can divide and multiply data in different cells.
 
|| Similarly, one can divide and multiply data in different cells.
  
 
|-
 
|-
−
|| 02:37
+
|| 02:36
 
|| Another basic operation in a spreadsheet is finding the “Average” of numbers.
 
|| Another basic operation in a spreadsheet is finding the “Average” of numbers.
  
 
|-
 
|-
−
|| 02:43
+
|| 02:42
 
||Let us see how it is implemented.
 
||Let us see how it is implemented.
  
Line 133: Line 130:
  
 
|-
 
|-
−
|| 03:04
+
|| 03:03
 
|| Press the “Enter” key on the keyboard.
 
|| Press the “Enter” key on the keyboard.
  
Line 145: Line 142:
  
 
|-
 
|-
−
|| 03:15
+
|| 03:14
 
|| Similarly, you can find average of elements in a horizontal row.
 
|| Similarly, you can find average of elements in a horizontal row.
  
 
|-
 
|-
−
|| 03:20
+
|| 03:19
 
|| We will learn more about formulae and operators in advanced level tutorials.
 
|| We will learn more about formulae and operators in advanced level tutorials.
  
 
|-
 
|-
−
|| 03:25
+
|| 03:24
 
||Let us now learn how to “Sort” data in a Calc spreadsheet.  
 
||Let us now learn how to “Sort” data in a Calc spreadsheet.  
  
 
|-
 
|-
−
|| 03:30
+
|| 03:29
 
|| Sorting arranges the visible cells on the sheet in any desired manner.
 
|| Sorting arranges the visible cells on the sheet in any desired manner.
  
 
|-
 
|-
−
|| 03:35
+
|| 03:34
 
||In Calc, you can sort the data using upto three criteria, which are then applied one after another.
 
||In Calc, you can sort the data using upto three criteria, which are then applied one after another.
 
   
 
   
 
|-
 
|-
−
|| 03:43
+
|| 03:42
 
||They  are handy when you are searching for a particular item and become even more powerful after you have filtered data.
 
||They  are handy when you are searching for a particular item and become even more powerful after you have filtered data.
  
Line 181: Line 178:
  
 
|-
 
|-
−
|| 04:12
+
|| 04:11
 
|| This selects the column which we want to sort.
 
|| This selects the column which we want to sort.
  
Line 193: Line 190:
  
 
|-
 
|-
−
|| 04:24
+
|| 04:23
 
|| You see that a dialog box appears with tabs as “Sort criteria” and “Options”.
 
|| You see that a dialog box appears with tabs as “Sort criteria” and “Options”.
  
Line 201: Line 198:
  
 
|-
 
|-
−
|| 04:37
+
|| 04:36
 
||In order to sort the “Cost” in ascending order, click on the “Ascending” option just next to it.
 
||In order to sort the “Cost” in ascending order, click on the “Ascending” option just next to it.
  
 
|-
 
|-
−
|| 04:44
+
|| 04:43
 
|| Now click on the “OK” button.
 
|| Now click on the “OK” button.
  
 
|-
 
|-
−
|| 04:47
+
|| 04:46
 
|| You see that the column gets sorted in the ascending order.
 
|| You see that the column gets sorted in the ascending order.
  
 
|-
 
|-
−
|| 04:51
+
|| 04:50
 
|| Similarly, to sort in the descending order, click on “Descending” and then click on the “OK” button.
 
|| Similarly, to sort in the descending order, click on “Descending” and then click on the “OK” button.
  
 
|-
 
|-
−
|| 04:59
+
|| 04:58
 
||Let us Undo the changes
 
||Let us Undo the changes
  
 
|-
 
|-
−
|| 05:02
+
|| 05:01
 
|| Multiple columns can be sorted by first selecting all the columns and then applying the sort options.
 
|| Multiple columns can be sorted by first selecting all the columns and then applying the sort options.
  
Line 229: Line 226:
  
 
|-
 
|-
−
|| 05:14
+
|| 05:13
 
||So first select these columns as we did earlier.
 
||So first select these columns as we did earlier.
  
 
|-
 
|-
−
|| 05:18
+
|| 05:17
 
|| Now click on the “Data” option in the menu bar and then click on “Sort”.
 
|| Now click on the “Data” option in the menu bar and then click on “Sort”.
  
 
|-
 
|-
−
|| 05:24
+
|| 05:23
 
|| In the dialog box which appears, first select “Cost” in the “Sort by” field.
 
|| In the dialog box which appears, first select “Cost” in the “Sort by” field.
  
 
|-
 
|-
−
|| 05:30
+
|| 05:29
 
||Then select “SN” in the “Then by” field.
 
||Then select “SN” in the “Then by” field.
  
 
|-
 
|-
−
|| 05:35
+
|| 05:34
 
|| Click on “ Descending” in both the options near them and then click on the “OK” button.
 
|| Click on “ Descending” in both the options near them and then click on the “OK” button.
  
 
|-
 
|-
−
|| 05:43
+
|| 05:40
 
|| You see that both the headings get sorted in the descending order.
 
|| You see that both the headings get sorted in the descending order.
  
 
|-
 
|-
−
|| 05:47
+
|| 05:45
 
||Lets Undo the changes
 
||Lets Undo the changes
  
 
|-
 
|-
−
|| 05:49
+
|| 05:48
 
|| Now lets learn how to filter data in LibreOffice Calc.
 
|| Now lets learn how to filter data in LibreOffice Calc.
  
 
|-
 
|-
−
|| 05:53
+
|| 05:52
 
||A filter is a list of conditions that each entry has to meet in order to be displayed.
 
||A filter is a list of conditions that each entry has to meet in order to be displayed.
  
 
|-
 
|-
−
|| 06:00
+
|| 05:57
 
|| In order to apply a filter in the spreadsheet, lets click on the cell named “Item”.
 
|| In order to apply a filter in the spreadsheet, lets click on the cell named “Item”.
  
 
|-
 
|-
−
|| 06:07
+
|| 06:05
 
||Now click on the “Data” option in the menu bar and then click on “Filter”.
 
||Now click on the “Data” option in the menu bar and then click on “Filter”.
  
Line 277: Line 274:
  
 
|-
 
|-
−
|| 06:16
+
|| 06:15
 
|| You see that an arrow mark appears on the headings.
 
|| You see that an arrow mark appears on the headings.
  
 
|-
 
|-
−
|| 06:20
+
|| 06:19
 
||Click on the down arrow on the cell named “Item”.
 
||Click on the down arrow on the cell named “Item”.
  
Line 293: Line 290:
  
 
|-
 
|-
−
|| 06:34
+
|| 06:32
 
|| You see that only the data related to “Electricity Bill” is displayed in the sheet.
 
|| You see that only the data related to “Electricity Bill” is displayed in the sheet.
  
 
|-
 
|-
−
|| 06:40
+
|| 06:39
 
||The rest of the options are filtered out.
 
||The rest of the options are filtered out.
  
Line 305: Line 302:
  
 
|-
 
|-
−
|| 06:52
+
|| 06:51
 
|| We see that we are now able to view all the data which we had originally written.
 
|| We see that we are now able to view all the data which we had originally written.
  
 
|-
 
|-
−
|| 06:59
+
|| 06:58
 
|| Apart from “AutoFilter”, there are two more filter options namely “Standard Filter” and “Advanced Filter” which we will learn about in the later stages of this series.
 
|| Apart from “AutoFilter”, there are two more filter options namely “Standard Filter” and “Advanced Filter” which we will learn about in the later stages of this series.
  
 
|-
 
|-
−
|| 07:11
+
|| 07:10
 
|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc:
 
|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc:
  
Line 337: Line 334:
  
 
|-
 
|-
−
|| 07:30
+
|| 07:29
 
||*It summarises the Spoken Tutorial project
 
||*It summarises the Spoken Tutorial project
  
 
|-
 
|-
−
|| 07:33
+
|| 07:32
 
||*If you do not have good bandwidth, you can download and watch it
 
||*If you do not have good bandwidth, you can download and watch it
  
 
|-
 
|-
−
|| 07:37
+
|| 07:36
 
||The Spoken Tutorial Project Team
 
||The Spoken Tutorial Project Team
  
Line 353: Line 350:
  
 
|-
 
|-
−
|| 07:43
+
|| 07:42
 
||*Gives certificates for those who pass an online test
 
||*Gives certificates for those who pass an online test
  
 
|-
 
|-
−
|| 07:47
+
|| 07:46
 
||*For more details, please write to contact@spoken-tutorial.org
 
||*For more details, please write to contact@spoken-tutorial.org
  
 
|-
 
|-
−
|| 07:53
+
|| 07:52
 
||*Spoken Tutorial Project is a part of the Talk to a Teacher project
 
||*Spoken Tutorial Project is a part of the Talk to a Teacher project
  
 
|-
 
|-
−
|| 07:58
+
|| 07:57
 
||*It is supported by the National Mission on Education through ICT, MHRD, Government of India
 
||*It is supported by the National Mission on Education through ICT, MHRD, Government of India
  
 
|-
 
|-
−
|| 08:06
+
|| 08:05
 
||*More information on this Mission is available at
 
||*More information on this Mission is available at
  

Revision as of 10:28, 19 January 2015


Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Calc – Basics of Data Manipulation.
00:07 In this tutorial we will learn about:
00:09 Introduction to basics of Formula
00:12 Sorting by Columns
00:15 Basics of Filtering Data
00:17 Here we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4
00:27 Let us begin the tutorial by learning about the basic formulas used in LibreOffice Calc.
00:33 Formulas are equations that use numbers and variables to get a result.
00:39 In a spreadsheet, the variables are cell locations that hold the data needed for the equation to be completed.
00:47 The most basic arithmetic operations which are performed are addition, subtraction, multiplication and division.
00:56 Let us open our “Personal-Finance-Tracker.ods” file first.
01:01 In our “personal finance tracker.ods” file, let us see how to add the cost of all the expenses mentioned under the heading, “Cost”.
01:13 We shall give one more heading as “SUM TOTAL” just under “Miscellaneous”.
01:18 And we shall click on the cell A8 and give the serial number as “7”.
01:24 Now lets click on cell number “C8” where we want to display the total of the costs.
01:31 In order to add all the costs, we’ll type“is equal to SUM” and within braces the range of columns to be added,that is,”C3 colon C7”.
01:43 Now press “Enter” on the keyboard.
01:46 You see that all the items under “Cost” gets added.
01:50 Now lets learn how to subtract in Calc.
01:54 If we want to subtract the cost of “House Rent” and “ Electricity Bill”, and display it in the cell referenced as A9, simply click on the A9 cell first.
02:06 Now in this cell, type “is equal to” and within braces the respective cell references, that is, “C3 minus C4”.
02:16 Press the “Enter” key on the keyboard.
02:19 We see that the cost in the two cell references get subtracted and the result is displayed in cell number A9.
02:28 Lets undo the changes.
02:31 Similarly, one can divide and multiply data in different cells.
02:36 Another basic operation in a spreadsheet is finding the “Average” of numbers.
02:42 Let us see how it is implemented.
02:45 Lets give the heading as “Average” just below the “SUM TOTAL” cell.
02:50 Here we want to display the average of the total cost.
02:55 So lets click on the “C9” cell.
02:58 Now we type “is equal to” Average and Cost within braces.
03:03 Press the “Enter” key on the keyboard.
03:07 You see that the average of the “Cost” column gets displayed in the cell.
03:11 Lets undo the changes.
03:14 Similarly, you can find average of elements in a horizontal row.
03:19 We will learn more about formulae and operators in advanced level tutorials.
03:24 Let us now learn how to “Sort” data in a Calc spreadsheet.
03:29 Sorting arranges the visible cells on the sheet in any desired manner.
03:34 In Calc, you can sort the data using upto three criteria, which are then applied one after another.
03:42 They are handy when you are searching for a particular item and become even more powerful after you have filtered data.
03:51 Lets say, we want to sort the data under the heading “Costs” in the ascending order.
03:57 So first, we highlight the cells to be sorted by clicking on the cell “Cost”.
04:03 Now holding down the left mouse button, drag it along the column till the end of the cell which says “2000”.
04:11 This selects the column which we want to sort.
04:15 Now click on the “Data” option in the menu bar and then click on “Sort”.
04:21 Next Select “Current Selection”
04:23 You see that a dialog box appears with tabs as “Sort criteria” and “Options”.
04:31 In the “Sort criteria” tab, select “Cost” in the “Sort by” field.
04:36 In order to sort the “Cost” in ascending order, click on the “Ascending” option just next to it.
04:43 Now click on the “OK” button.
04:46 You see that the column gets sorted in the ascending order.
04:50 Similarly, to sort in the descending order, click on “Descending” and then click on the “OK” button.
04:58 Let us Undo the changes
05:01 Multiple columns can be sorted by first selecting all the columns and then applying the sort options.
05:09 Lets say, we want to sort the serial numbers as well as the cost.
05:13 So first select these columns as we did earlier.
05:17 Now click on the “Data” option in the menu bar and then click on “Sort”.
05:23 In the dialog box which appears, first select “Cost” in the “Sort by” field.
05:29 Then select “SN” in the “Then by” field.
05:34 Click on “ Descending” in both the options near them and then click on the “OK” button.
05:40 You see that both the headings get sorted in the descending order.
05:45 Lets Undo the changes
05:48 Now lets learn how to filter data in LibreOffice Calc.
05:52 A filter is a list of conditions that each entry has to meet in order to be displayed.
05:57 In order to apply a filter in the spreadsheet, lets click on the cell named “Item”.
06:05 Now click on the “Data” option in the menu bar and then click on “Filter”.
06:12 Click on the “AutoFilter” option in the pop up menu.
06:15 You see that an arrow mark appears on the headings.
06:19 Click on the down arrow on the cell named “Item”.
06:24 Now suppose if you want to display only the data related to “Electricity Bill”.
06:29 So click on the “Electricity Bill” option.
06:32 You see that only the data related to “Electricity Bill” is displayed in the sheet.
06:39 The rest of the options are filtered out.
06:43 In order to view all the data, again click on the downward arrow on the cell named ”Item” and click on “All”.
06:51 We see that we are now able to view all the data which we had originally written.
06:58 Apart from “AutoFilter”, there are two more filter options namely “Standard Filter” and “Advanced Filter” which we will learn about in the later stages of this series.
07:10 This brings us to the end of the Spoken Tutorial on LibreOffice Calc:
07:15 To summarize, we learned about:
07:18 Introduction to basics of Formula
07:21 Sorting by Columns
07:23 Basics of Filtering Data
07:26 *Watch the video available at the following link
07:29 *It summarises the Spoken Tutorial project
07:32 *If you do not have good bandwidth, you can download and watch it
07:36 The Spoken Tutorial Project Team
07:40 *Conducts workshops using spoken tutorials
07:42 *Gives certificates for those who pass an online test
07:46 *For more details, please write to contact@spoken-tutorial.org
07:52 *Spoken Tutorial Project is a part of the Talk to a Teacher project
07:57 *It is supported by the National Mission on Education through ICT, MHRD, Government of India
08:05 *More information on this Mission is available at
08:08 *http:spoken-tutorial.org slash NMEICT hyphen Intro
08:16 This tutorial has been contributed by ...............................(Name of the translator and narrator)

And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching. 

 Thanks for joining

Contributors and Content Editors

PoojaMoolya, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Calc-on-BOSS-Linux/C2/Basic-Data-Manipulation/English-timed&oldid=19527"