Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Working-with-data/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
Sandhya.np14 (Talk | contribs) |
||
| Line 6: | Line 6: | ||
|- | |- | ||
|| 00:00 | || 00:00 | ||
| − | || Welcome to the Spoken tutorial on LibreOffice Calc – Working with data. | + | || Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Working with data'''. |
|- | |- | ||
|| 00:06 | || 00:06 | ||
| − | || In this tutorial we will learn about: | + | || In this tutorial, we will learn about: |
|- | |- | ||
|| 0:10 | || 0:10 | ||
| − | ||Speed up using Fill tools and Selection lists. | + | ||* Speed up using Fill tools and Selection lists. |
|- | |- | ||
|| 00:14 | || 00:14 | ||
| − | ||Sharing content between sheets. | + | ||* Sharing content between sheets. |
|- | |- | ||
|| 00:17 | || 00:17 | ||
| − | ||Removing data, Replacing data, Changing part of a data. | + | ||* Removing data, Replacing data, Changing part of a data. |
|- | |- | ||
|| 00:23 | || 00:23 | ||
| − | || Here we are using GNU/Linux 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'''. |
|- | |- | ||
||00:33 | ||00:33 | ||
| − | || Entering data into a spreadsheet can be very labor-intensive | + | || Entering data into a '''spreadsheet''' can be very labor-intensive but '''Calc''' provides several tools for making it considerably easier. |
|- | |- | ||
|| 00:43 | || 00:43 | ||
| − | ||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:50 | || 00:50 | ||
| − | ||But Calc also includes several other tools for automating input, especially of repetitive material. | + | ||But '''Calc''' also includes several other tools for automating input, especially of repetitive material. |
|- | |- | ||
|| 00:57 | || 00:57 | ||
| − | ||These tools are namely | + | ||These tools are namely- '''“Fill tool”, “Selection lists”'''. |
|- | |- | ||
| Line 58: | Line 58: | ||
|- | |- | ||
|| 01:14 | || 01:14 | ||
| − | || The Fill tool is a useful method for duplicating the contents in the sheet. | + | || The '''Fill''' tool is a useful method for duplicating the contents in the sheet. |
|- | |- | ||
|| 01:20 | || 01:20 | ||
| − | ||In our “Personal-Finance-Tracker.ods” file, | + | ||In our “Personal-Finance-Tracker.ods” file, let's say we want to copy the data under the heading '''“Cost”''' to the adjacent cells. |
|- | |- | ||
|| 01:30 | || 01:30 | ||
| − | ||Then first select all the data which needs to be copied by clicking on the cell which contains the entry | + | ||Then, first select all the data which needs to be copied by clicking on the '''cell''' which contains the entry “6000”. |
|- | |- | ||
|| 01:38 | || 01:38 | ||
| − | ||Now holding down the left mouse button, drag the mouse till the end of the cell which contains the cost entry | + | ||Now, holding down the '''left mouse button''', drag the '''mouse''' till the end of the '''cell''' which contains the cost entry “2000”. |
|- | |- | ||
| Line 78: | Line 78: | ||
|- | |- | ||
|| 01:51 | || 01:51 | ||
| − | ||Now release the left mouse button. | + | ||Now, release the '''left mouse button'''. |
|- | |- | ||
|| 01:54 | || 01:54 | ||
| − | || Click on the “Edit” option in the menu bar and then click on the “Fill” option. | + | || Click on the '''“Edit”''' option in the '''menu bar''' and then click on the '''“Fill”''' option. |
|- | |- | ||
|| 02:00 | || 02:00 | ||
| − | ||In the pop up menu, click on the “Right” option. | + | ||In the pop-up menu, click on the '''“Right”''' option. |
|- | |- | ||
| Line 94: | Line 94: | ||
|- | |- | ||
|| 02:10 | || 02:10 | ||
| − | ||Let us undo the changes. | + | ||Let us '''undo''' the changes. |
|- | |- | ||
|| 02:13 | || 02:13 | ||
| − | || A more complex use of the Fill tool is to use it for filling some series as data in sheets. | + | || A more complex use of the '''Fill''' tool is to use it for filling some series as data in sheets. |
|- | |- | ||
|| 02:21 | || 02:21 | ||
| − | ||Calc provides default lists for the full and abbreviated days of the week and the months of the year. | + | ||'''Calc''' provides default lists for the full and abbreviated days of the week and the months of the year. |
|- | |- | ||
| Line 110: | Line 110: | ||
|- | |- | ||
|| 02:35 | || 02:35 | ||
| − | || Now | + | || Now let's insert a new heading named '''“Days”''' in our sheet. |
|- | |- | ||
| Line 122: | Line 122: | ||
|- | |- | ||
|| 02:48 | || 02:48 | ||
| − | || Now click on the “Edit” option in the menu bar | + | || Now, click on the '''“Edit”''' option in the menu bar and go to the '''“Fill”''' option. |
|- | |- | ||
|| 02:54 | || 02:54 | ||
| − | ||Click on the “Series” option in the menu. | + | ||Click on the '''“Series”''' option in the menu. |
|- | |- | ||
|| 02:58 | || 02:58 | ||
| − | || You see that a dialog box appears with the heading as “Fill Series”. | + | || You see that a dialog box appears with the heading as '''“Fill Series”'''. |
|- | |- | ||
|| 03:02 | || 03:02 | ||
| − | || Now under the heading, “Series type”, click on the “AutoFill” option. | + | || Now under the heading, '''“Series type”''', click on the '''“AutoFill”''' option. |
|- | |- | ||
|| 03:08 | || 03:08 | ||
| − | || In the “Start value” field, we type our first day of the week, that is, “Sunday”. | + | || In the '''“Start value”''' field, we type our first day of the week, that is, “Sunday”. |
|- | |- | ||
| Line 146: | Line 146: | ||
|- | |- | ||
||03:16 | ||03:16 | ||
| − | ||Now click on the | + | ||Now click on the '''OK''' button. |
|- | |- | ||
| Line 162: | Line 162: | ||
|- | |- | ||
|| 03:37 | || 03:37 | ||
| − | || | + | ||type “Sunday” in a '''cell''' and press '''Enter'''. This will shift the focus to the next cell in the column. |
|- | |- | ||
| Line 170: | Line 170: | ||
|- | |- | ||
|| 03:56 | || 03:56 | ||
| − | ||Click on this box with the mouse. | + | ||Click on this box with the '''mouse'''. |
|- | |- | ||
|| 03:58 | || 03:58 | ||
| − | ||Drag it downwards till you see Saturday in the display box on the right. | + | ||Drag it downwards till you see "Saturday" in the display box on the right. |
|- | |- | ||
|| 04:04 | || 04:04 | ||
| − | ||Release the mouse button. | + | ||Release the '''mouse button'''. |
|- | |- | ||
| Line 187: | Line 187: | ||
|| 04:10 | || 04:10 | ||
||This trick works for all data that are sequential. | ||This trick works for all data that are sequential. | ||
| − | + | Let us '''undo''' the changes. | |
|- | |- | ||
| Line 195: | Line 195: | ||
|- | |- | ||
|| 04:25 | || 04:25 | ||
| − | ||To demonstrate this, we will first delete the serial numbers already entered in the cells | + | ||To demonstrate this, we will first delete the serial numbers already entered in the cells '''A1''' to '''A7'''. |
|- | |- | ||
|| 04:34 | || 04:34 | ||
| − | || After deleting the numbers, select the cells referenced as | + | || After deleting the numbers, select the cells referenced as '''A2''' to '''A7''' again. |
|- | |- | ||
|| 04:40 | || 04:40 | ||
| − | || Now click on the | + | || Now click on the '''Edit''' in the menu bar and then on '''Fill''' and ''Series''' option. |
|- | |- | ||
|| 04:47 | || 04:47 | ||
| − | || A dialog box appears in front of us.Now click on the | + | || 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 | || 04:57 | ||
| − | || In the | + | || In the '''Start value''' field, we will type the first serial number, that is, “1”. |
|- | |- | ||
|| 05:03 | || 05:03 | ||
| − | || In the | + | || In the '''End value''' field, we will type the last value to be entered as “6”. |
|- | |- | ||
|| 05:08 | || 05:08 | ||
| − | || Now we set the | + | || Now we set the '''Increment''' value as “1” and finally click on the '''OK''' button. |
|- | |- | ||
| Line 227: | Line 227: | ||
|- | |- | ||
|| 05:21 | || 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. | + | || 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:33 | ||05:33 | ||
| − | || Apart from Fill tools there is one more speed up tool called “Selection lists” which is limited to using only text. | + | || Apart from '''Fill''' tools, there is one more speed up tool called '''“Selection lists”''' which is limited to using only text. |
|- | |- | ||
| Line 243: | Line 243: | ||
|- | |- | ||
|| 05:52 | || 05:52 | ||
| − | ||Calc enables a user to enter the same information in the same cell on multiple sheets. | + | ||'''Calc''' enables a user to enter the same information in the same cell on multiple sheets. |
|- | |- | ||
|| 05:58 | || 05:58 | ||
| − | ||This means, instead of entering the same list on | + | ||This means, instead of entering the same list on each sheet individually, you can enter it in all the sheets at once. |
| − | each sheet individually, you can enter it in all the sheets at once. | + | |
|- | |- | ||
|| 06:08 | || 06:08 | ||
| − | || 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:15 | || 06:15 | ||
| − | ||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”. |
|- | |- | ||
|| 06:21 | || 06:21 | ||
| − | || So we click on the | + | || So, we click on the '''Edit''' option in the menu bar and then click on the '''Sheet''' option. |
|- | |- | ||
|| 06:28 | || 06:28 | ||
| − | || Now click on | + | || Now, click on '''Select'''. |
|- | |- | ||
|| 06:31 | || 06:31 | ||
| − | || 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”. |
|- | |- | ||
|| 06:40 | || 06:40 | ||
| − | ||And then click on the | + | ||And then click on the '''OK''' button. |
|- | |- | ||
| Line 280: | Line 279: | ||
|- | |- | ||
|| 06:46 | || 06:46 | ||
| − | ||Now | + | ||Now let's enter some data in “Sheet 1”. |
|- | |- | ||
|| 06:50 | || 06:50 | ||
| − | ||For example | + | ||For example-in the cell referenced as '''F12''', we’ll type: “This will be displayed on multiple sheets”. |
|- | |- | ||
|| 06:58 | || 06:58 | ||
| − | ||Now click on the “Sheet 2” and the “Sheet 3” tab one after the other. | + | ||Now, click on the '''“Sheet 2”''' and the '''“Sheet 3”''' tab one after the other. |
|- | |- | ||
|| 07:03 | || 07:03 | ||
| − | ||We see that in each of these sheets, the cell referenced as | + | ||We see that in each of these sheets, the cell referenced as '''F12''' contains the same data. |
|- | |- | ||
|| 07:10 | || 07:10 | ||
| − | ||Let us undo the changes. | + | ||Let us '''undo''' the changes. |
|- | |- | ||
| Line 304: | Line 303: | ||
|- | |- | ||
|| 07:19 | || 07:19 | ||
| − | ||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. |
|- | |- | ||
|| 07:26 | || 07:26 | ||
| − | ||You see that the data of the cell is displayed in the “Input line” field. | + | ||You see that the data of the cell is displayed in the '''“Input line”''' field. |
|- | |- | ||
|| 07:31 | || 07:31 | ||
| − | ||Now press the | + | ||Now, press the '''Backspace''' button on the keyboard. |
|- | |- | ||
| Line 320: | Line 319: | ||
|- | |- | ||
|| 07:37 | || 07:37 | ||
| − | ||Let us undo the changes. | + | ||Let us '''undo''' the changes. |
|- | |- | ||
|| 07:41 | || 07:41 | ||
| − | || To replace the data in a cell, simply select the cell and type over the old data. | + | || To replace the data in a cell, simply select the '''cell''' and type over the old data. |
|- | |- | ||
|| 07:47 | || 07:47 | ||
||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 341: | Line 340: | ||
|- | |- | ||
|| 08:08 | || 08:08 | ||
| − | ||Let us undo the changes. | + | ||Let us '''undo''' the changes. |
|- | |- | ||
|| 08:10 | || 08: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 353: | Line 352: | ||
|- | |- | ||
|| 08:17 | || 08:17 | ||
| − | ||Speed up using Fill tools and Selection lists. | + | ||* Speed up using Fill tools and Selection lists. |
|- | |- | ||
|| 08:21 | || 08:21 | ||
| − | ||Sharing content between sheets. | + | ||* Sharing content between sheets. |
|- | |- | ||
|| 08:24 | || 08:24 | ||
| − | ||Removing data, Replacing data, Changing a part of the data | + | ||* Removing data, Replacing data, Changing a part of the data. |
|- | |- | ||
|| 08:29 | || 08:29 | ||
| − | || | + | ||Watch the video available at the following link: |
|- | |- | ||
|| 08:33 | || 08:33 | ||
| − | || | + | ||It summarizes the Spoken Tutorial project. |
|- | |- | ||
|| 08:36 | || 08:36 | ||
| − | || | + | ||If you do not have good bandwidth, you can download and watch it. |
|- | |- | ||
||08:41 | ||08:41 | ||
| − | ||The Spoken Tutorial Project | + | ||The Spoken Tutorial Project team: |
|- | |- | ||
|| 08:43 | || 08:43 | ||
| − | ||*Conducts workshops using spoken tutorials | + | ||* Conducts workshops using spoken tutorials |
|- | |- | ||
|| 08:46 | || 08:46 | ||
| − | ||*Gives certificates for those who pass an online test | + | ||* Gives certificates for those who pass an online test. |
|- | |- | ||
|| 08:50 | || 08:50 | ||
| − | || | + | ||For more details, please write to contact at spoken hyphen tutorial dot org. |
|- | |- | ||
|| 08:56 | || 08:56 | ||
| − | || | + | ||'''Spoken Tutorial''' project is a part of the '''Talk to a Teacher''' project. |
|- | |- | ||
|| 09:01 | || 09:01 | ||
| − | || | + | ||It is supported by the National Mission on Education through ICT, MHRD, Government of India. |
|- | |- | ||
|| 09:08 | || 09:08 | ||
| − | || | + | ||More information on this mission is available at: |
|- | |- | ||
|| 09:11 | || 09:11 | ||
| − | || | + | ||spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
|- | |- | ||
|| 09:19 | || 09:19 | ||
| − | || | + | ||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. | |
| − | And this is -----------------------(name of the recorder) from | + | |
| − | + | ||
| − | + | ||
|- | |- | ||
|} | |} | ||
Revision as of 17:32, 17 August 2015
| Time | Narration |
| 00:00 | Welcome to the Spoken tutorial on LibreOffice Calc – Working with data. |
| 00:06 | In this tutorial, we will learn about: |
| 0:10 | * Speed up using Fill tools and Selection lists. |
| 00:14 | * Sharing content between sheets. |
| 00:17 | * Removing data, Replacing data, Changing part of a data. |
| 00:23 | Here we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4. |
| 00:33 | Entering data into a spreadsheet can be very labor-intensive but Calc provides several tools for making it considerably easier. |
| 00:43 | The most basic ability is to drag and drop the contents of one cell to another with a mouse. |
| 00:50 | 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:10 | 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:20 | In our “Personal-Finance-Tracker.ods” file, let's 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:47 | Also select the cells where we want to copy the data. |
| 01:51 | Now, release the left mouse button. |
| 01:54 | Click on the “Edit” option in the menu bar and then click on the “Fill” option. |
| 02:00 | In the pop-up menu, click on the “Right” option. |
| 02:04 | You see that the data under the heading “Cost” gets copied to the adjacent cells. |
| 02:10 | Let us undo the changes. |
| 02:13 | A more complex use of the Fill tool is to use it for filling some series as data in sheets. |
| 02:21 | Calc provides default lists for the full and abbreviated days of the week and the months of the year. |
| 02:28 | It also enables the user to create his own lists. |
| 02:35 | Now let's insert a new heading named “Days” in our sheet. |
| 02:39 | 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:54 | Click on the “Series” option in the menu. |
| 02:58 | 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:08 | In the “Start value” field, we type our first day of the week, that is, “Sunday”. |
| 03:14 | The increment is already set as “1”. |
| 03:16 | Now click on the OK button. |
| 03:18 | You see that the days are automatically entered into the cells. |
| 03:24 | 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:56 | Click on this box with the mouse. |
| 03:58 | Drag it downwards till you see "Saturday" in the display box on the right. |
| 04:04 | Release the mouse button. |
| 04:07 | The cells get filled with the weekdays automatically. |
| 04:10 | This trick works for all data that are sequential.
Let us 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:25 | To demonstrate this, we will first delete the serial numbers already entered in the cells A1 to A7. |
| 04:34 | 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:47 | 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:15 | 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:33 | 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:08 | In our “Personal-Finance-Tracker.ods” file, our entire data is on “Sheet 1”. |
| 06:15 | 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:28 | Now, click on Select. |
| 06:31 | 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:43 | This takes us back to “Sheet 1”. |
| 06:46 | Now let's enter some data in “Sheet 1”. |
| 06:50 | For example-in the cell referenced as F12, we’ll type: “This will be displayed on multiple sheets”. |
| 06:58 | Now, click on the “Sheet 2” and the “Sheet 3” tab one after the other. |
| 07:03 | We see that in each of these sheets, the cell referenced as F12 contains the same data. |
| 07:10 | 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:19 | To delete data without removing any of the formatting of the cell, just select a cell. |
| 07:26 | You see that the data of the cell is displayed in the “Input line” field. |
| 07:31 | 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:41 | To replace the data in a cell, simply select the cell and type over the old data. |
| 07:47 | The new data will retain the original formatting.
Let us undo the changes. |
| 07:53 | 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:02 | Now by navigating the cursor, you can edit the cell as per your requirement. |
| 08:08 | Let us undo the changes. |
| 08:10 | 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:21 | * Sharing content between sheets. |
| 08:24 | * Removing data, Replacing data, Changing a part of the data. |
| 08:29 | Watch the video available at the following link: |
| 08:33 | It summarizes the Spoken Tutorial project. |
| 08:36 | If you do not have good bandwidth, you can download and watch it. |
| 08:41 | The Spoken Tutorial Project team: |
| 08:43 | * Conducts workshops using spoken tutorials |
| 08:46 | * Gives certificates for those who pass an online test. |
| 08:50 | For more details, please write to contact at spoken hyphen tutorial dot org. |
| 08:56 | Spoken Tutorial project is a part of the Talk to a Teacher project. |
| 09:01 | It is supported by the National Mission on Education through ICT, MHRD, Government of India. |
| 09:08 | More information on this mission is available at: |
| 09:11 | spoken hyphen tutorial dot org slash NMEICT hyphen Intro. |
| 09:19 | 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. |