LibreOffice-Suite-Calc/C2/Basic-Data-Manipulation/English-timed - Revision history

PoojaMoolya at 07:19, 23 March 2017

2017-03-23T07:19:29Z

Sandhya.np14 at 16:34, 7 January 2016

2016-01-07T16:34:55Z

Sandhya.np14 at 13:11, 7 January 2016

2016-01-07T13:11:42Z

Sandhya.np14 at 09:38, 8 October 2015

2015-10-08T09:38:00Z

Show changes

Sandhya.np14 at 07:34, 8 October 2015

2015-10-08T07:34:50Z

Pratik kamble at 09:52, 9 July 2014

2014-07-09T09:52:30Z

Minal: Created page with ' TOC =Resources for recording= Basic Data Manipulation {| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tut…'

2012-12-27T10:47:45Z

Created page with ' __TOC__ =Resources for recording= Basic Data Manipulation {| border=1 || VISUAL CUE || NARRATION |- || 00:00 || Welcome to the Spoken tut…'

New page

__TOC__
=Resources for recording=
[[Media:Basicmanipulation.zip |Basic Data Manipulation]]

{| border=1
|| VISUAL CUE
|| 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 Ubuntu Linux version 10.04 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:35
||Formulas are equations that use numbers and variables to get a result.

|-
|| 00:41
||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:02
|| 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:19
||And we shall click on the cell A8 and give the serial number as “7”.

|-
|| 01:25
|| Now lets click on cell number “C8” where we want to display the total of the costs.

|-
|| 01:32
|| 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
||Now press “Enter” on the keyboard.

|-
|| 01:47
||You see that all the items under “Cost” gets added.

|-
|| 01:51
|| Now lets learn how to subtract in Calc.

|-
|| 01:55
|| 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:17
||Press the “Enter” key on the keyboard.

|-
|| 02:20
|| We see that the cost in the two cell references get subtracted and the result is displayed in cell number A9.

|-
|| 02:29
||Lets undo the changes.

|-
|| 02:32
|| Similarly, one can divide and multiply data in different cells.

|-
|| 02:37
|| Another basic operation in a spreadsheet is finding the “Average” of numbers.

|-
|| 02:43
||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:04
|| 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:15
|| Similarly, you can find average of elements in a horizontal row.

|-
|| 03:20
|| We will learn more about formulae and operators in advanced level tutorials.

|-
|| 03:25
||Let us now learn how to “Sort” data in a Calc spreadsheet.

|-
|| 03:30
|| Sorting arranges the visible cells on the sheet in any desired manner.

|-
|| 03:35
||In Calc, you can sort the data using upto three criteria, which are then applied one after another.

|-
|| 03:43
||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:12
|| 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:24
|| 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:37
||In order to sort the “Cost” in ascending order, click on the “Ascending” option just next to it.

|-
|| 04:44
|| Now click on the “OK” button.

|-
|| 04:47
|| You see that the column gets sorted in the ascending order.

|-
|| 04:51
|| Similarly, to sort in the descending order, click on “Descending” and then click on the “OK” button.

|-
|| 04:59
||Let us Undo the changes

|-
|| 05:02
|| 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:14
||So first select these columns as we did earlier.

|-
|| 05:18
|| Now click on the “Data” option in the menu bar and then click on “Sort”.

|-
|| 05:24
|| In the dialog box which appears, first select “Cost” in the “Sort by” field.

|-
|| 05:30
||Then select “SN” in the “Then by” field.

|-
|| 05:35
|| Click on “ Descending” in both the options near them and then click on the “OK” button.

|-
|| 05:43
|| You see that both the headings get sorted in the descending order.

|-
|| 05:47
||Lets Undo the changes

|-
|| 05:49
|| Now lets learn how to filter data in LibreOffice Calc.

|-
|| 05:53
||A filter is a list of conditions that each entry has to meet in order to be displayed.

|-
|| 06:00
|| In order to apply a filter in the spreadsheet, lets click on the cell named “Item”.

|-
|| 06:07
||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:16
|| You see that an arrow mark appears on the headings.

|-
|| 06:20
||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:34
|| You see that only the data related to “Electricity Bill” is displayed in the sheet.

|-
|| 06:40
||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:52
|| We see that we are now able to view all the data which we had originally written.

|-
|| 06:59
|| 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
|| 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:30
||*It summarises the Spoken Tutorial project

|-
|| 07:33
||*If you do not have good bandwidth, you can download and watch it

|-
|| 07:37
||The Spoken Tutorial Project Team

|-
|| 07:40
||*Conducts workshops using spoken tutorials

|-
|| 07:43
||*Gives certificates for those who pass an online test

|-
|| 07:47
||*For more details, please write to contact@spoken-tutorial.org

|-
|| 07:53
||*Spoken Tutorial Project is a part of the Talk to a Teacher project

|-
|| 07:58
||*It is supported by the National Mission on Education through ICT, MHRD, Government of India

|-
|| 08:06
||*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

|-

|}

@@ Line 18: / Line 18: @@
 |-
 || 00:09
-||* Introduction to basics of '''Formula'''
+|| Introduction to basics of '''Formula'''
 |-
 || 00:12
-||* Sorting by '''Column'''s
+|| Sorting by '''Column'''s
 |-
 || 00:15
-||* Basics of '''Filtering Data'''.
+|| Basics of '''Filtering Data'''.
 |-
@@ Line 53: / Line 53: @@
 |-
-||01:02
+|| 01:02
 || 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 62: / Line 62: @@
 |-
 || 01:19
-||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”.
 |-
@@ Line 73: / Line 73: @@
 |-
-|| 01:44
+||01:44
 ||Now, press '''Enter''' on the keyboard.
@@ Line 322: / Line 322: @@
 |-
 || 07:18
-||* Introduction to basics of '''formula'''
+|| Introduction to basics of '''formula'''
 |-
 || 07:21
-||* Sorting by columns
+|| Sorting by columns
 |-
 || 07:23
-||* Basics of filtering data.
+|| Basics of filtering data.
 |-
@@ Line 350: / Line 350: @@
 |-
 || 07:40
-||* Conducts workshops using spoken tutorials.
+||Conducts workshops using spoken tutorials.
 |-
 || 07:43
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-
 || 07:47
-||For more details, please write to:
+||For more details, please write to:'''contact@spoken-tutorial.org'''
 '''contact@spoken-tutorial.org'''
 |-
@@ Line 381: / Line 380: @@
 ||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
 Thanks for joining.
 |-
 |}

@@ Line 270: / Line 270: @@
 |-
 || 06:07
-||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 286: / Line 286: @@
 |-
 || 06:24
-|| Now, suppose, if you want to display only the data related to “Electricity Bill”.
+|| Now, suppose if you want to display only the data related to “Electricity Bill”..
 |-
@@ Line 314: / Line 314: @@
 |-
 || 07:11
-|| 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 322: / Line 322: @@
 |-
 || 07:18
-||* Introduction to basics of Formula
+||* Introduction to basics of '''formula'''
 |-
 || 07:21
-||* Sorting by Columns
+||* Sorting by columns
 |-
 || 07:23
-||* Basics of Filtering Data.
+||* Basics of filtering data.
 |-
@@ Line 346: / Line 346: @@
 |-
 || 07:37
-||The Spoken Tutorial Project team:
+||The Spoken Tutorial project team:
 |-
@@ Line 358: / Line 358: @@
 |-
 || 07:47
-||For more details, please write to: contact@spoken-tutorial.org
+||For more details, please write to:
 |-
@@ Line 374: / Line 375: @@
 |-
 || 08:08
-||http://spoken-tutorial.org slash NMEICT hyphen Intro.
+||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
 |-

@@ Line 18: / Line 18: @@
 |-
 || 00:09
-||* Introduction to basics of Formula
+||* Introduction to basics of '''Formula'''
 |-
 || 00:12
-||* Sorting by Columns
+||* Sorting by '''Column'''s
 |-
 || 00:15
-||* Basics of Filtering Data.
+||* Basics of '''Filtering Data'''.
 |-
 || 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 '''Ubuntu Linux''' version '''10.04''' as our operating system and  '''LibreOffice Suite''' version '''3.3.4'''.
 |-
@@ Line 38: / Line 38: @@
 |-
 || 00:35
-||Formulas are equations that use numbers and variables to get a result.
+||Formulas are equations that use numbers and '''variable'''s to get a result.
 |-
@@ Line 58: / Line 58: @@
 |-
 || 01:13
-|| We shall give one more heading as “SUM TOTAL” just under “Miscellaneous”.
+|| We shall give one more heading as “SUM TOTAL”, just under “Miscellaneous”.
 |-
@@ Line 66: / Line 66: @@
 |-
 || 01:25
-|| Now let's click on cell number “C8” where we want to display the total of the costs.
+|| Now, let's click on cell number “C8” where we want to display the total of the costs.
 |-
 || 01:32
-|| 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
-||Now press '''Enter''' on the keyboard.
+||Now, press '''Enter''' on the keyboard.
 |-
 || 01:47
-||You see that all the items under '''“Cost”''' get added.
+||You see that all the items under “Cost” get added.
 |-
 || 01:51
-|| Now let's learn how to subtract in '''Calc'''.
+|| Now, let's learn how to subtract in '''Calc'''.
 |-
@@ Line 90: / Line 90: @@
 |-
 || 02:06
-|| Now in this cell, type “is equal to” and within braces the respective '''cell reference'''s, that is, “C3 minus C4”.
+|| Now, in this cell, type '''is equal to''' and within braces the respective '''cell reference'''s, that is, '''C3 minus C4'''.
 |-
@@ Line 98: / Line 98: @@
 |-
 || 02:20
-|| 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'.
 |-
@@ Line 122: / Line 122: @@
 |-
 || 02:50
-||Here we want to display the average of the total cost.
+||Here, we want to display the average of the total cost.
 |-
@@ Line 162: / Line 162: @@
 |-
 || 03:35
-||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 up to three criteria which are then applied one after another.
 |-
@@ Line 170: / Line 170: @@
 |-
 || 03:51
-|| Let's say, we want to sort the data under the heading “Costs” in the ascending order.
+|| Let's 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”.
+||So, first, we highlight the cells to be sorted by clicking on the cell “Cost”.
 |-
@@ Line 190: / Line 190: @@
 |-
 || 04:21
-||Next, Select '''Current Selection'''.
+||Next, select '''Current Selection'''.
 |-
@@ Line 206: / Line 206: @@
 |-
 || 04:44
-|| Now click on the '''OK''' button.
+|| Now, click on the '''OK''' button.
 |-

@@ Line 10: / Line 10: @@
 |-
 || 00:00
-|| Welcome to the Spoken tutorial on LibreOffice Calc – Basics of Data Manipulation.
+|| Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Basics of Data Manipulation'''.
 |-
 || 00:07
-|| In this tutorial we will learn about:
+|| In this tutorial, we will learn about:
 |-
 || 00:09
-||Introduction to basics of Formula
+||* Introduction to basics of Formula
 |-
 || 00:12
-||Sorting by Columns
+||* Sorting by Columns
 |-
 || 00:15
-||Basics of Filtering Data
+||* Basics of Filtering Data.
 |-
 || 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 '''Ubuntu Linux''' version '''10.04''' 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.
+|| Let us begin the tutorial by learning about the basic formulas used in '''LibreOffice Calc'''.
 |-
@@ Line 42: / Line 42: @@
 |-
 || 00:41
-||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 62: / Line 62: @@
 |-
 || 01:19
-||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
-|| Now lets click on cell number “C8” where we want to display the total of the costs.
+|| Now let's click on cell number “C8” where we want to display the total of the costs.
 |-
 || 01:32
-|| 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
-||Now press “Enter” on the keyboard.
+||Now press '''Enter''' on the keyboard.
 |-
 || 01:47
-||You see that all the items under “Cost” gets added.
+||You see that all the items under '''“Cost”''' get added.
 |-
 || 01:51
-|| Now lets learn how to subtract in Calc.
+|| Now let's learn how to subtract in '''Calc'''.
 |-

@@ Line 5: / Line 5: @@
 {| border=1
-|| VISUAL CUE
+|| '''Time'''
-|| NARRATION
+|| '''Narration'''
 |-