Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed"
From Script | Spoken-Tutorial
PoojaMoolya (Talk | contribs) |
PoojaMoolya (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | + | '''Resources for recording''' | |
| + | [[Media:Formatting Data.zip |Formatting Data]] | ||
{|Border=1 | {|Border=1 | ||
| Line 10: | Line 11: | ||
|- | |- | ||
| − | ||00: | + | ||00:06 |
||In this tutorial we will learn about:Formatting Borders, background colors. | ||In this tutorial we will learn about:Formatting Borders, background colors. | ||
|- | |- | ||
| − | ||00: | + | ||00:12 |
||Formatting multiple lines of text using Automatic Wrapping. | ||Formatting multiple lines of text using Automatic Wrapping. | ||
|- | |- | ||
| − | ||00: | + | ||00:18 |
||Merging Cells.Shrinking text to fit the cell. | ||Merging Cells.Shrinking text to fit the cell. | ||
|- | |- | ||
| − | ||00: | + | ||00:22 |
| − | ||Here we are using | + | ||Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4. |
|- | |- | ||
| Line 30: | Line 31: | ||
|- | |- | ||
| − | ||00: | + | ||00:39 |
||Let us open our “personal finance tracker.ods” file. | ||Let us open our “personal finance tracker.ods” file. | ||
|- | |- | ||
| − | ||00: | + | ||00:45 |
||Formatting of borders can be done on a particular cell or a block of cells. | ||Formatting of borders can be done on a particular cell or a block of cells. | ||
|- | |- | ||
| − | ||00: | + | ||00:50 |
||For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”and ”Account”. | ||For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”and ”Account”. | ||
|- | |- | ||
| − | ||01: | + | ||01:01 |
||So let us first click on the cell with the heading Serial Number, denoted by “SN”. | ||So let us first click on the cell with the heading Serial Number, denoted by “SN”. | ||
|- | |- | ||
| − | ||01: | + | ||01:08 |
||Now hold down the left mouse button and drag it along the cells containing the headings. | ||Now hold down the left mouse button and drag it along the cells containing the headings. | ||
|- | |- | ||
| − | ||01: | + | ||01:14 |
||After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar. | ||After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar. | ||
|- | |- | ||
| − | ||01: | + | ||01:23 |
||A drop down box opens up containing several border styles. | ||A drop down box opens up containing several border styles. | ||
|- | |- | ||
| − | ||01: | + | ||01:28 |
||Click on one of the styles you want to apply on the borders. | ||Click on one of the styles you want to apply on the borders. | ||
|- | |- | ||
| − | ||01: | + | ||01:33 |
||I will click on the last option. | ||I will click on the last option. | ||
|- | |- | ||
| − | ||01: | + | ||01:34 |
||We see that the borders get formatted according to our selected style. | ||We see that the borders get formatted according to our selected style. | ||
|- | |- | ||
| − | ||01: | + | ||01:39 |
||Let us undo this change. | ||Let us undo this change. | ||
|- | |- | ||
| − | ||01: | + | ||01:45 |
||The selected cells are still highlighted.Right-click on the selection and choose “Format Cells” option. | ||The selected cells are still highlighted.Right-click on the selection and choose “Format Cells” option. | ||
|- | |- | ||
| − | ||01: | + | ||01:54 |
||Now click on the “Borders” tab. | ||Now click on the “Borders” tab. | ||
| Line 86: | Line 87: | ||
|- | |- | ||
| − | ||02: | + | ||02:05 |
||Displayed in each of these are the default settings of Calc. | ||Displayed in each of these are the default settings of Calc. | ||
|- | |- | ||
| − | ||02: | + | ||02:10 |
||But one can change any of these to suit our requirement. | ||But one can change any of these to suit our requirement. | ||
| Line 98: | Line 99: | ||
|- | |- | ||
| − | ||02: | + | ||02:22 |
||I will choose the third option under “Default” and you can see that it is reflected in the preview window. | ||I will choose the third option under “Default” and you can see that it is reflected in the preview window. | ||
| Line 110: | Line 111: | ||
|- | |- | ||
| − | ||02: | + | ||02:38 |
||Spacing to contents has the “Synchronize” option checked. | ||Spacing to contents has the “Synchronize” option checked. | ||
|- | |- | ||
| − | ||02: | + | ||02:42 |
||This means that the same spacing is applied to all the margins. | ||This means that the same spacing is applied to all the margins. | ||
|- | |- | ||
| − | ||02: | + | ||02:47 |
||One can uncheck it and change the margin spacing as per the requirement. | ||One can uncheck it and change the margin spacing as per the requirement. | ||
|- | |- | ||
| − | ||02: | + | ||02:53 |
||I will change “Top” and “Bottom” margins to 1.4pt. | ||I will change “Top” and “Bottom” margins to 1.4pt. | ||
|- | |- | ||
| − | || | + | ||03:00 |
||I will leave you to explore the various Shadow styles, on your own. | ||I will leave you to explore the various Shadow styles, on your own. | ||
|- | |- | ||
| − | ||03: | + | ||03:04 |
||Click on OK. | ||Click on OK. | ||
|- | |- | ||
| − | ||03: | + | ||03:06 |
||This will apply the chosen style to the selected cells. | ||This will apply the chosen style to the selected cells. | ||
|- | |- | ||
| − | ||03: | + | ||03:11 |
||After learning how to format borders, now let us learn how to give background colors to cells. | ||After learning how to format borders, now let us learn how to give background colors to cells. | ||
|- | |- | ||
| − | ||03: | + | ||03:18 |
||In order to give background colors to cells, Calc provides an option called “Background Color”, located in the Formatting toolbar. | ||In order to give background colors to cells, Calc provides an option called “Background Color”, located in the Formatting toolbar. | ||
| Line 158: | Line 159: | ||
|- | |- | ||
| − | ||03: | + | ||03:44 |
||Now hold down the left mouse button and drag it along the cells containing the headings. | ||Now hold down the left mouse button and drag it along the cells containing the headings. | ||
|- | |- | ||
| − | ||03: | + | ||03:50 |
| − | ||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting | + | ||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting to::olbar. |
|- | |- | ||
| Line 178: | Line 179: | ||
|- | |- | ||
| − | ||04: | + | ||04:17 |
||Calc provides various options for formatting multiple lines of text. | ||Calc provides various options for formatting multiple lines of text. | ||
|- | |- | ||
| − | ||04: | + | ||04:22 |
||The first one is by using “Automatic Wrapping”. | ||The first one is by using “Automatic Wrapping”. | ||
|- | |- | ||
| − | ||04: | + | ||04:26 |
||"Automatic Wrapping” allows a user to enter multiple lines of text into a single cell. | ||"Automatic Wrapping” allows a user to enter multiple lines of text into a single cell. | ||
|- | |- | ||
| − | ||04: | + | ||04:33 |
||So let us see how it is implemented. | ||So let us see how it is implemented. | ||
|- | |- | ||
| − | ||04: | + | ||04:37 |
||Now in our “personal finance tracker.ods” sheet, let us click on a empty cell. | ||Now in our “personal finance tracker.ods” sheet, let us click on a empty cell. | ||
|- | |- | ||
| − | ||04: | + | ||04:44 |
||For example lets click on cell number “B12”. | ||For example lets click on cell number “B12”. | ||
|- | |- | ||
| − | ||04: | + | ||04:49 |
||Now do a right click on cell and then click on the “Format Cells” option. | ||Now do a right click on cell and then click on the “Format Cells” option. | ||
|- | |- | ||
| − | ||04: | + | ||04:54 |
||Now click on the “Alignment” tab in the dialog box. | ||Now click on the “Alignment” tab in the dialog box. | ||
|- | |- | ||
| − | ||04: | + | ||04:58 |
||At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the “OK” button. | ||At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the “OK” button. | ||
|- | |- | ||
| − | ||05: | + | ||05:08 |
||Now we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”. | ||Now we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”. | ||
|- | |- | ||
| − | ||05: | + | ||05:11 |
||You see that the multiple statements get wrapped in a single cell. | ||You see that the multiple statements get wrapped in a single cell. | ||
| Line 226: | Line 227: | ||
|- | |- | ||
| − | ||05: | + | ||05:21 |
||After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc. | ||After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc. | ||
|- | |- | ||
| − | ||05: | + | ||05:29 |
||In our “personal finance tracker.ods” file , if we want to merge cells containing the Serial Number with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”. | ||In our “personal finance tracker.ods” file , if we want to merge cells containing the Serial Number with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”. | ||
| Line 246: | Line 247: | ||
|- | |- | ||
| − | ||06: | + | ||06:07 |
||In the sidebar which pops up, click on the “Merge Cells” option. | ||In the sidebar which pops up, click on the “Merge Cells” option. | ||
|- | |- | ||
| − | ||06: | + | ||06:12 |
||In order to move the contents of both the cells in a single cell, click on the “Yes” option in the dialog box which appears. | ||In order to move the contents of both the cells in a single cell, click on the “Yes” option in the dialog box which appears. | ||
| Line 258: | Line 259: | ||
|- | |- | ||
| − | ||06: | + | ||06:31 |
||Now let us undo the merging we did by clicking by pressing “CTRL+Z” together. | ||Now let us undo the merging we did by clicking by pressing “CTRL+Z” together. | ||
| Line 266: | Line 267: | ||
|- | |- | ||
| − | ||06: | + | ||06:41 |
||The font size of the data in a cell can be automatically adjusted to fit into a cell. | ||The font size of the data in a cell can be automatically adjusted to fit into a cell. | ||
| Line 274: | Line 275: | ||
|- | |- | ||
| − | ||06: | + | ||06:50 |
||Lets type the text “This is for the month of January” in the cell referenced as B14. | ||Lets type the text “This is for the month of January” in the cell referenced as B14. | ||
|- | |- | ||
| − | || | + | ||07:00 |
||You see that the text doesn't fit into the cell. | ||You see that the text doesn't fit into the cell. | ||
| Line 286: | Line 287: | ||
|- | |- | ||
| − | ||07: | + | ||07:11 |
||Now click on the “Format” option in the menu bar and then click on “Cells”. | ||Now click on the “Format” option in the menu bar and then click on “Cells”. | ||
| Line 294: | Line 295: | ||
|- | |- | ||
| − | ||07: | + | ||07:24 |
||You see that the “Format Cells” dialog box opens. | ||You see that the “Format Cells” dialog box opens. | ||
|- | |- | ||
| − | ||07: | + | ||07:28 |
||Click on the “Alignment” tab in the dialog box. | ||Click on the “Alignment” tab in the dialog box. | ||
|- | |- | ||
| − | ||07: | + | ||07:31 |
||At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the “OK” button. | ||At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the “OK” button. | ||
| Line 310: | Line 311: | ||
|- | |- | ||
| − | ||07: | + | ||07:54 |
||Lets undo the changes | ||Lets undo the changes | ||
|- | |- | ||
| − | ||07: | + | ||07:57 |
||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. | ||
|- | |- | ||
| − | ||08: | + | ||08:02 |
||To summarize, we learned about: Formatting Borders, background colors in Calc. | ||To summarize, we learned about: Formatting Borders, background colors in Calc. | ||
|- | |- | ||
| − | ||08: | + | ||08:09 |
||Formatting multiple lines of text using Automatic Wrapping. | ||Formatting multiple lines of text using Automatic Wrapping. | ||
| Line 330: | Line 331: | ||
|- | |- | ||
| − | ||08: | + | ||08:19 |
||COMPREHENSIVE ASSIGNMENT | ||COMPREHENSIVE ASSIGNMENT | ||
|- | |- | ||
| − | ||08: | + | ||08:21 |
||Open “spreadsheet practice.ods” sheet. | ||Open “spreadsheet practice.ods” sheet. | ||
|- | |- | ||
| − | ||08: | + | ||08:25 |
||Select all the headings. | ||Select all the headings. | ||
|- | |- | ||
| − | ||08: | + | ||08:27 |
||Give the background color to the headings as blue. | ||Give the background color to the headings as blue. | ||
|- | |- | ||
| − | ||08: | + | ||08:31 |
||Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”. | ||Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”. | ||
|- | |- | ||
| − | ||08: | + | ||08:37 |
||Shrink this text to fit in the cell. | ||Shrink this text to fit in the cell. | ||
|- | |- | ||
| − | ||08: | + | ||08:40 |
||Watch the video available at the following link | ||Watch the video available at the following link | ||
|- | |- | ||
| − | ||08: | + | ||08:43 |
||It summarises the Spoken Tutorial project | ||It summarises the Spoken Tutorial project | ||
|- | |- | ||
| − | ||08: | + | ||08:46 |
||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 | ||
|- | |- | ||
| − | ||08: | + | ||08:51 |
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials | ||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials | ||
|- | |- | ||
| − | ||08: | + | ||08:56 |
||Gives certificates for those who pass an online test | ||Gives certificates for those who pass an online test | ||
|- | |- | ||
| − | || | + | ||09:00 |
||For more details, please write to contact at spoken hyphen tutorial dot org | ||For more details, please write to contact at spoken hyphen tutorial dot org | ||
|- | |- | ||
| − | ||09: | + | ||09:06 |
||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 | ||
|- | |- | ||
| − | ||09: | + | ||09:11 |
||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 | ||
| Line 390: | Line 391: | ||
|- | |- | ||
| − | ||09: | + | ||09:29 |
||This tutorial has been contributed by ...............................(Name of the translator and narrator) | ||This tutorial has been contributed by ...............................(Name of the translator and narrator) | ||
Revision as of 10:26, 19 January 2015
Resources for recording Formatting Data
| Time | Narration |
| 00:00 | Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc. |
| 00:06 | In this tutorial we will learn about:Formatting Borders, background colors. |
| 00:12 | Formatting multiple lines of text using Automatic Wrapping. |
| 00:18 | Merging Cells.Shrinking text to fit the cell. |
| 00:22 | Here we are using Ubuntu Linux version 10.04 as our operating system and LibreOffice Suite version 3.3.4. |
| 00:33 | First let us learn about formatting borders in LibreOffice Calc. |
| 00:39 | Let us open our “personal finance tracker.ods” file. |
| 00:45 | Formatting of borders can be done on a particular cell or a block of cells. |
| 00:50 | For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date”and ”Account”. |
| 01:01 | So let us first click on the cell with the heading Serial Number, denoted by “SN”. |
| 01:08 | Now hold down the left mouse button and drag it along the cells containing the headings. |
| 01:14 | After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar. |
| 01:23 | A drop down box opens up containing several border styles. |
| 01:28 | Click on one of the styles you want to apply on the borders. |
| 01:33 | I will click on the last option. |
| 01:34 | We see that the borders get formatted according to our selected style. |
| 01:39 | Let us undo this change. |
| 01:45 | The selected cells are still highlighted.Right-click on the selection and choose “Format Cells” option. |
| 01:54 | Now click on the “Borders” tab. |
| 01:56 | You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”. |
| 02:05 | Displayed in each of these are the default settings of Calc. |
| 02:10 | But one can change any of these to suit our requirement. |
| 02:14 | Under “User-defined”, you can see a small preview window which displays the selection. |
| 02:22 | I will choose the third option under “Default” and you can see that it is reflected in the preview window. |
| 02:29 | I will also change the “Style”, “Width” and “Color”. |
| 02:33 | Again notice the change in the preview window. |
| 02:38 | Spacing to contents has the “Synchronize” option checked. |
| 02:42 | This means that the same spacing is applied to all the margins. |
| 02:47 | One can uncheck it and change the margin spacing as per the requirement. |
| 02:53 | I will change “Top” and “Bottom” margins to 1.4pt. |
| 03:00 | I will leave you to explore the various Shadow styles, on your own. |
| 03:04 | Click on OK. |
| 03:06 | This will apply the chosen style to the selected cells. |
| 03:11 | After learning how to format borders, now let us learn how to give background colors to cells. |
| 03:18 | In order to give background colors to cells, Calc provides an option called “Background Color”, located in the Formatting toolbar. |
| 03:27 | Now let us see how it is implemented. |
| 03:30 | For example, let us give a background color to the cells containing the headings. |
| 03:36 | So let us first click on the cell which contains the heading Serial Number, denoted by “SN”. |
| 03:44 | Now hold down the left mouse button and drag it along the cells containing the headings. |
| 03:50 | After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting to::olbar. |
| 04:00 | A pop up menu opens up where you can select the color you want to apply as a background. |
| 04:08 | Let us click on “Grey” color. |
| 04:11 | You can see that the cell background for the headings turns grey. |
| 04:17 | Calc provides various options for formatting multiple lines of text. |
| 04:22 | The first one is by using “Automatic Wrapping”. |
| 04:26 | "Automatic Wrapping” allows a user to enter multiple lines of text into a single cell. |
| 04:33 | So let us see how it is implemented. |
| 04:37 | Now in our “personal finance tracker.ods” sheet, let us click on a empty cell. |
| 04:44 | For example lets click on cell number “B12”. |
| 04:49 | Now do a right click on cell and then click on the “Format Cells” option. |
| 04:54 | Now click on the “Alignment” tab in the dialog box. |
| 04:58 | At the bottom of the dialog box click on the “Wrap text automatically” option and then click on the “OK” button. |
| 05:08 | Now we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”. |
| 05:11 | You see that the multiple statements get wrapped in a single cell. |
| 05:19 | Lets undo the changes |
| 05:21 | After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc. |
| 05:29 | In our “personal finance tracker.ods” file , if we want to merge cells containing the Serial Number with the heading “SN” and their corresponding items, then first click on the data entry '1' under the heading “SN”. |
| 05:46 | Now hold down the “Shift” key on the keyboard and click on the cell with its corresponding item, “Salary”. |
| 05:55 | This highlights the two cells that are to be merged. |
| 05:59 | Next click on the “Format” option in the menu bar and then click on the “Merge Cells” option. |
| 06:07 | In the sidebar which pops up, click on the “Merge Cells” option. |
| 06:12 | In order to move the contents of both the cells in a single cell, click on the “Yes” option in the dialog box which appears. |
| 06:21 | You see that the selected cells get merged into one and the contents are also within the same merged cell. |
| 06:31 | Now let us undo the merging we did by clicking by pressing “CTRL+Z” together. |
| 06:37 | Next we will learn how to shrink text to fit into the cell. |
| 06:41 | The font size of the data in a cell can be automatically adjusted to fit into a cell. |
| 06:49 | Let us learn how to do it. |
| 06:50 | Lets type the text “This is for the month of January” in the cell referenced as B14. |
| 07:00 | You see that the text doesn't fit into the cell. |
| 07:03 | In order to shrink the text so that it fits, click on the cell referenced as B14 first. |
| 07:11 | Now click on the “Format” option in the menu bar and then click on “Cells”. |
| 07:18 | Alternately, right-click on the cell and click on “Format Cells”. |
| 07:24 | You see that the “Format Cells” dialog box opens. |
| 07:28 | Click on the “Alignment” tab in the dialog box. |
| 07:31 | At the bottom of the dialog box, click on the “Shrink to fit cell size” check-box and then click on the “OK” button. |
| 07:41 | You see that the entire text shrinks and adjusts itself by decreasing its font size so that the text fits into the cell referenced as B14. |
| 07:54 | Lets undo the changes |
| 07:57 | This brings us to the end of the Spoken Tutorial on LibreOffice Calc. |
| 08:02 | To summarize, we learned about: Formatting Borders, background colors in Calc. |
| 08:09 | Formatting multiple lines of text using Automatic Wrapping. |
| 08:14 | Merging Cells. Shrinking text to fit the cell. |
| 08:19 | COMPREHENSIVE ASSIGNMENT |
| 08:21 | Open “spreadsheet practice.ods” sheet. |
| 08:25 | Select all the headings. |
| 08:27 | Give the background color to the headings as blue. |
| 08:31 | Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”. |
| 08:37 | Shrink this text to fit in the cell. |
| 08:40 | Watch the video available at the following link |
| 08:43 | It summarises the Spoken Tutorial project |
| 08:46 | If you do not have good bandwidth, you can download and watch it |
| 08:51 | The Spoken Tutorial Project Team Conducts workshops using spoken tutorials |
| 08:56 | Gives certificates for those who pass an online test |
| 09:00 | For more details, please write to contact at spoken hyphen tutorial dot org |
| 09:06 | Spoken Tutorial Project is a part of the Talk to a Teacher project |
| 09:11 | It is supported by the National Mission on Education through ICT, MHRD, Government of India |
| 09:18 | More information on this Mission is available at spoken hyphen tutorial dot org slash NMEICT hyphen Intro |
| 09:29 | 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 |
