LibreOffice-Suite-Calc/C2/Working-with-data/English-timed - Revision history

Pratik kamble at 12:17, 26 October 2016

2016-10-26T12:17:16Z

Sandhya.np14 at 04:59, 8 January 2016

2016-01-08T04:59:25Z

Sandhya.np14 at 12:24, 8 October 2015

2015-10-08T12:24:44Z

Show changes

Pratik kamble at 09:53, 9 July 2014

2014-07-09T09:53:28Z

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

2012-12-27T10:49:07Z

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

New page

__TOC__
=Resources for recording=
[[Media:Working With Data.zip |Working With Data]]

{| border=1
|| VISUAL CUE
|| NARRATION

|-
|| 00:00
|| Welcome to the Spoken tutorial on LibreOffice Calc – Working with data.

|-
|| 00:06
|| In this tutorial we will learn about:

|-
|| 00:09
||Speed up using Fill tools and Selection lists.

|-
|| 00:13
||Sharing content between sheets.

|-
|| 00:16
||Removing data, Replacing data, Changing part of a data.

|-
|| 00:23
|| Here we are using Ubuntu Linux version 10.04 and LibreOffice Suite version 3.3.4.

|-
||00:32
|| Entering data into a spreadsheet can be very labor-intensive, but Calc provides several tools for making it considerably easier.

|-
|| 00:42
||The most basic ability is to drag and drop the contents of one cell to another with a mouse.

|-
|| 00:49
||But Calc also includes several other tools for automating input, especially of repetitive material.

|-
|| 00:57
||These tools are namely, “Fill tool”, “Selection lists”.

|-
|| 01:01
||These can input information into multiple sheets of the same document.

|-
|| 01:06
|| We will learn about each one of them one by one.

|-
|| 01:09
||Let us open our “Personal-Finance-Tracker.ods” file.

|-
|| 01:14
|| The Fill tool is a useful method for duplicating the contents in the sheet.

|-
|| 01:19
||In our “Personal-Finance-Tracker.ods” file, lets say we want to copy the data under the heading “Cost” to the adjacent cells.

|-
|| 01:30
||Then first select all the data which needs to be copied by clicking on the cell which contains the entry, “6000”.

|-
|| 01:38
||Now holding down the left mouse button, drag the mouse till the end of the cell which contains the cost entry, “2000”.

|-
|| 01:46
||Also select the cells where we want to copy the data.

|-
|| 01:51
||Now release the left mouse button.

|-
|| 01:53
|| Click on the “Edit” option in the menu bar and then click on the “Fill” option.

|-
|| 01:59
||In the pop up menu, click on the “Right” option.

|-
|| 02:03
|| You see that the data under the heading “Cost” gets copied to the adjacent cells.

|-
|| 02:09
||Let us undo the changes.

|-
|| 02:12
|| A more complex use of the Fill tool is to use it for filling some series as data in sheets.

|-
|| 02:20
||Calc provides default lists for the full and abbreviated days of the week and the months of the year.

|-
|| 02:27
||It also enables the user to create his own lists.

|-
|| 02:34
|| Now lets insert a new heading named “Days” in our sheet.

|-
|| 02:38
||Under this, we will display the seven days of the week automatically.

|-
|| 02:43
|| Select the first seven cells below the heading “Days”.

|-
|| 02:48
|| Now click on the “Edit” option in the menu bar and go to the“Fill” option.

|-
|| 02:53
||Click on the “Series” option in the menu.

|-
|| 02:57
|| You see that a dialog box appears with the heading as “Fill Series”.

|-
|| 03:02
|| Now under the heading, “Series type”, click on the “AutoFill” option.

|-
|| 03:07
|| In the “Start value” field, we type our first day of the week, that is, “Sunday”.

|-
|| 03:13
||The increment is already set as “1”.

Now click on the “OK” button.

|-
|| 03:18
|| You see that the days are automatically entered into the cells.

|-
|| 03:23
||You can enter only weekdays, month or year by the same method as they are pre-defined in Calc.

|-
|| 03:32
|| Another method for auto-filling of sequential data is as follows-

|-
|| 03:37
||Type “Sunday” in a cell and press Enter. This will shift the focus to the next cell in the column.

|-
|| 03:46
||Go back to the cell where “Sunday” was typed. You will now see a small black box at the bottom-right-hand corner of the cell.

|-
|| 03:55
||Click on this box with the mouse.

|-
|| 03:57
||Drag it downwards till you see Saturday in the display box on the right.

|-
|| 04:04
||Release the mouse button.

|-
|| 04:06
||The cells get filled with the weekdays automatically.

|-
|| 04:10
||This trick works for all data that are sequential.
let undo the changes

|-
||04:17
|| You can also create a one-time fill series for numbers by entering the start, end and the increment values.

|-
|| 04:24
||To demonstrate this, we will first delete the serial numbers already entered in the cells “A1” to “ A7”

|-
|| 04:33
|| After deleting the numbers, select the cells referenced as “A2” to “A7” again.

|-
|| 04:40
|| Now click on the “Edit” in the menu bar and then on “Fill” and “Series” option.

|-
|| 04:46
|| A dialog box appears in front of us.

Now click on the “Linear” option, under the heading “Series type”, if it is not selected by default.

|-
|| 04:57
|| In the “Start value” field, we will type the first serial number, that is, “1”.

|-
|| 05:03
|| In the “End value” field, we will type the last value to be entered as “6”.

|-
|| 05:08
|| Now we set the “Increment” value as “1” and finally click on the “OK” button.

|-
|| 05:14
||We see that the cells automatically get filled with the sequential serial numbers.

|-
|| 05:21
|| In all these cases, the Fill tool creates only a momentary connection between the cells. Once they are filled, the cells have no further connection with one another.

|-
||05:32
|| Apart from Fill tools there is one more speed up tool called “Selection lists” which is limited to using only text.

|-
|| 05:40
||We will discuss it in the later tutorials of this series.

|-
|| 05:45
|| After learning about the “Fill tools” and “Selection lists” we will now learn how to share content between sheets.

|-
|| 05:52
||Calc enables a user to enter the same information in the same cell on multiple sheets.

|-
|| 05:58
||This means, instead of entering the same list on
each sheet individually, you can enter it in all the sheets at once.

|-
|| 06:07
|| In our “Personal-Finance-Tracker.ods” file, our entire data is on “Sheet 1”.

|-
|| 06:14
||Now we want “Sheet 2” as well as “Sheet 3” to show the same data as in “Sheet 1”.

|-
|| 06:21
|| So we click on the “Edit” option in the menu bar and then click on the “Sheet” option.

|-
|| 06:27
|| Now click on “Select”.

|-
|| 06:30
|| Now in the dialog box which appears, using shift key we select the options “Sheet 1”, “Sheet 2”, and “Sheet 3”.

|-
|| 06:40
||And then click on the “OK” button.

|-
|| 06:42
|| This takes us back to “Sheet 1”.

|-
|| 06:45
||Now lets enter some data in “Sheet 1”.

|-
|| 06:49
||For example,in the cell referenced as “F12”, we’ll type “This will be displayed on multiple sheets”.

|-
|| 06:57
||Now click on the “Sheet 2” and the “Sheet 3” tab one after the other.

|-
|| 07:02
||We see that in each of these sheets, the cell referenced as “F12” contains the same data.

|-
|| 07:09
||Let us undo the changes.

|-
|| 07:12
|| Next we will learn about different ways in which we can delete and edit data in the cells.

|-
|| 07:18
||To delete data without removing any of the formatting of the cell, just select a cell.

|-
|| 07:25
||You see that the data of the cell is displayed in the “Input line” field.

|-
|| 07:30
||Now press the “Backspace” button on the keyboard.

|-
|| 07:35
||You see that the data gets deleted.

|-
|| 07:37
||Let us undo the changes.

|-
|| 07:39
|| To replace the data in a cell, simply select the cell and type over the old data.

|-
|| 07:46
||The new data will retain the original formatting.
Let us undo the changes.

|-
|| 07:52
|| In order to change a part of the data in a cell, without removing all of the contents, just double click on the cell.

|-
|| 08:01
||Now by navigating the cursor, you can edit the cell as per your requirement.

|-
|| 08:07
||Let us undo the changes.

|-
|| 08:09
|| This brings us to the end of the Spoken Tutorial on LibreOffice Calc:

|-
|| 08:15
||To summarize, we learned about:

|-
|| 08:17
||Speed up using Fill tools and Selection lists.

|-
|| 08:20
||Sharing content between sheets.

|-
|| 08:23
||Removing data, Replacing data, Changing a part of the data

|-
|| 08:29
||*Watch the video available at the following link

|-
|| 08:32
||*It summarises the Spoken Tutorial project

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

|-
||08:40
||The Spoken Tutorial Project Team

|-
|| 08:43
||*Conducts workshops using spoken tutorials

|-
|| 08:46
||*Gives certificates for those who pass an online test

|-
|| 08:49
||*For more details, please write to contact at spoken hyphen tutorial dot org

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

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

|-
|| 09:07
||*More information on this Mission is available at

|-
|| 09:11
||*spoken hyphen tutorial dot org slash NMEICT hyphen Intro

|-
|| 09:18
||*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 1: / Line 1: @@
 {| border=1
 || '''Time'''
@@ Line 18: / Line 13: @@
 |-
 || 00:09
-||* Speed up using '''Fill''' tools and '''Selection lists'''.
+||Speed up using '''Fill''' tools and '''Selection lists'''.
 |-
 || 00:13
-||* Sharing content between '''sheet'''s.
+||Sharing content between '''sheets'''.
 |-
 || 00:16
-||* Removing data, replacing data and  changing part of a data.
+||Removing data, replacing data and  changing part of a data.
 |-
 || 00:23
-|| Here we are using:
+|| Here we are using:'''Ubuntu Linux''' version '''10.04''' and'''LibreOffice Suite''' version '''3.3.4'''.
-* '''Ubuntu Linux''' version '''10.04''' and
-* '''LibreOffice Suite''' version '''3.3.4'''.
 |-
@@ Line 44: / Line 37: @@
 |-
 || 00:49
-||But '''Calc''' also includes several other '''tool'''s for automating input, especially of repetitive material.
+||But '''Calc''' also includes several other '''tools''' for automating input, especially of repetitive material.
 |-
@@ Line 68: / Line 61: @@
 |-
 || 01:19
-||In our “Personal-Finance-Tracker.ods” file, let's say- we want to copy the data under the heading '''“Cost”''' to the adjacent cells.
+||In our “Personal-Finance-Tracker.ods” file, let's say- we want to copy the data under the heading '''Cost''' to the adjacent cells.
 |-
@@ Line 148: / Line 141: @@
 |-
 || 03:13
-||The increment is already set as “1”.
+||The increment is already set as “1”.Now, click on the '''OK''' button.
 Now, click on the '''OK''' button.
 |-
@@ Line 209: / Line 201: @@
 |-
 || 04:46
-|| A dialog-box appears in front of us.
+|| A dialog-box appears in front of us.Now, click on the '''Linear''' option, under the heading '''“Series type”''', if it is not selected by default.
 Now, click on the '''Linear''' option, under the heading '''“Series type”''', if it is not selected by default.
 |-
@@ Line 254: / Line 245: @@
 |-
 || 06:07
-|| In our “Personal-Finance-Tracker.ods” file, our entire data is on '''“Sheet 1”'''.
+|| In our “Personal-Finance-Tracker.ods” file, our entire data is on '''Sheet 1'''.
 |-
 || 06:14
-||Now, we want “Sheet 2” as well as “Sheet 3” to show the same data as in “Sheet 1”.
+||Now, we want “Sheet 2” as well as “Sheet 3” to show the same data as in '''Sheet 1'''.
 |-
@@ Line 266: / Line 257: @@
 |-
 || 06:27
-|| Now, click on '''“Select”'''.
+|| Now, click on '''Select'''.
 |-
 || 06:30
-|| Now, in the dialog-box which appears, using '''shift key''' we select the options '''“Sheet 1”, “Sheet 2”''' and '''“Sheet 3”'''.
+|| Now, in the dialog-box which appears, using '''shift key''' we select the options '''Sheet 1, “Sheet 2”''' and '''Sheet 3'''.
 |-
@@ Line 278: / Line 269: @@
 |-
 || 06:42
-|| This takes us back to “Sheet 1”.
+|| This takes us back to '''Sheet 1'''.
 |-
@@ Line 330: / Line 321: @@
 |-
 || 07:46
-||The new data will retain the original formatting.
+||The new data will retain the original formatting.Let us '''undo''' the changes.
 Let us '''undo''' the changes.
 |-
@@ Line 355: / Line 345: @@
 |-
 || 08:17
-||* Speed up using '''Fill''' tools and '''Selection lists'''.
+||Speed up using '''Fill''' tools and '''Selection lists'''.
 |-
 || 08:20
-||* Sharing content between sheets.
+||Sharing content between sheets.
 |-
 || 08:23
-||* Removing data, replacing data, changing a part of the data.
+||Removing data, replacing data, changing a part of the data.
 |-
@@ Line 383: / Line 373: @@
 |-
 || 08:43
-||* Conducts workshops using spoken tutorials.
+||Conducts workshops using spoken tutorials.
 |-
 || 08:46
-||* Gives certificates for those who pass an online test.
+||Gives certificates for those who pass an online test.
 |-
 || 08:49
-||For more details, please write to:
+||For more details, please write to:'''contact at spoken hyphen tutorial dot org'''.
 '''contact at spoken hyphen tutorial dot org'''.
 |-
@@ Line 412: / Line 401: @@
 |-
 || 09:18
-||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.
+||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.
 Thanks for joining.
 |-
 |}

@@ Line 18: / Line 18: @@
 |-
 || 00:09
-||* Speed up using '''Fill tool'''s and '''Selection lists'''.
+||* Speed up using '''Fill''' tools and '''Selection lists'''.
 |-
 || 00:13
-||* Sharing content between sheets.
+||* Sharing content between '''sheet'''s.
 |-
 || 00:16
-||* Removing data, replacing data, changing part of a data.
+||* Removing data, replacing data and  changing part of a data.
 |-
 || 00:23
-|| Here we are using '''Ubuntu Linux''' version '''10.04''' and  '''LibreOffice Suite''' version '''3.3.4'''.
+|| Here we are using:
 |-
@@ Line 38: / Line 40: @@
 |-
 || 00:42
-||The most basic ability is to drag and drop the contents of one '''cell''' to another with a '''mouse'''.
+||The most basic ability is to '''drag and drop''' the contents of one '''cell''' to another with a '''mouse'''.
 |-
 || 00:49
-||But '''Calc''' also includes several other tools for automating input, especially of repetitive material.
+||But '''Calc''' also includes several other '''tool'''s for automating input, especially of repetitive material.
 |-
@@ Line 58: / Line 60: @@
 |-
 || 01:09
-||Let us open our '''“Personal-Finance-Tracker.ods”''' file.
+||Let us open our “Personal-Finance-Tracker.ods” file.
 |-
@@ Line 66: / Line 68: @@
 |-
 || 01:19
-||In our “Personal-Finance-Tracker.ods” file, let's say- we want to copy  the data under the heading '''“Cost”''' to the adjacent cells.
+||In our “Personal-Finance-Tracker.ods” file, let's say- we want to copy the data under the heading '''“Cost”''' to the adjacent cells.
 |-
@@ Line 74: / Line 76: @@
 |-
 || 01:38
-||Now, holding down the left '''mouse button''', drag the '''mouse''' till the end of the '''cell''' which contains the  cost entry “2000”.
+||Now, holding down the '''left mouse button''', drag the '''mouse''' till the end of the '''cell''' which contains the  cost entry “2000”.
 |-
 || 01:46
-||Also select the cells where we want to copy the data.
+||Also, select the cells where we want to copy the data.
 |-
 || 01:51
-||Now release the left '''mouse button'''.
+||Now, release the '''left mouse button'''.
 |-
@@ Line 106: / Line 108: @@
 |-
 || 02:20
-||'''Calc''' provides default lists for the full and abbreviated days of the week and the months of the year.
+||'''Calc''' provides '''default list'''s for the full and abbreviated days of the week and the months of the year.
 |-
@@ Line 114: / Line 116: @@
 |-
 || 02:34
-|| Now let's insert a new heading named “Days” in our sheet.
+|| Now, let's insert a new heading named “Days” in our sheet.
 |-
@@ Line 147: / Line 149: @@
 || 03:13
 ||The increment is already set as “1”.
-Now click on the '''OK''' button.
+Now, click on the '''OK''' button.
 |-
@@ Line 212: / Line 214: @@
 |-
 || 04:57
-|| In the '''“Start value”''' field, we will type the first serial number, that is “1”.
+|| In the '''“Start value”''' field, we will type the first serial number- that is “1”.
 |-
@@ Line 264: / Line 266: @@
 |-
 || 06:27
-|| Now click on '''“Select”'''.
+|| Now, click on '''“Select”'''.
 |-
@@ Line 284: / Line 286: @@
 |-
 || 06:49
-||For example, in the '''cell''' referenced as '''“F12”''', we’ll type '''“This will be displayed on multiple sheets”'''.
+||For example- in the '''cell''' referenced as '''“F12”''', we’ll type '''“This will be displayed on multiple sheets”'''.
 |-
@@ Line 300: / Line 302: @@
 |-
 || 07:12
-|| Next, we will learn about different ways in which we can delete and edit data in the cells.
+|| Next, we will learn about different ways in which we can delete and '''edit''' data in the cells.
 |-
 || 07:18
-||To delete data  without removing any of the formatting of the cell, just select a '''cell'''.
+||To delete data without removing any of the formatting of the cell, just select a '''cell'''.
 |-
@@ Line 312: / Line 314: @@
 |-
 || 07:30
-||Now press the '''Backspace''' button on the keyboard.
+||Now, press the '''Backspace''' button on the keyboard.
 |-
@@ Line 377: / Line 379: @@
 |-
 ||08:40
-||The Spoken Tutorial Project team:
+||The Spoken Tutorial project team:
 |-
@@ Line 389: / Line 391: @@
 |-
 || 08:49
-||For more details, please write to: contact at spoken hyphen tutorial dot org.
+||For more details, please write to:
 |-
@@ Line 405: / Line 408: @@
 |-
 || 09:11
-||spoken hyphen tutorial dot org slash NMEICT hyphen Intro.
+||'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
 |-

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