Difference between revisions of "LibreOffice-Suite-Calc/C2/Formatting-Data/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
 
(6 intermediate revisions by 2 users not shown)
Line 8: Line 8:
 
|-
 
|-
 
||00:00  
 
||00:00  
||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc.
+
||Welcome to the '''Spoken tutorial''' on '''LibreOffice Calc – Formatting Data in Calc'''.
  
 
|-
 
|-
 
||00:06  
 
||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:12  
 
||00:12  
||Formatting multiple lines of text using Automatic Wrapping.
+
||Formatting multiple lines of text using '''Automatic Wrapping'''
  
 
|-
 
|-
 
||00:18  
 
||00:18  
||Merging Cells.Shrinking text to fit the cell.
+
||Merging Cells Shrinking text to fit the cell.
  
 
|-
 
|-
 
||00:22
 
||00:22
||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:33  
 
||00:33  
||First let us learn about formatting borders in LibreOffice Calc.
+
||First, let us learn about formatting borders in '''LibreOffice Calc'''.
  
 
|-
 
|-
 
||00:39
 
||00:39
||Let us open our “personal finance tracker.ods” file.
+
||Let us open our "personal finance tracker.ods" file.
  
 
|-
 
|-
 
||00:45  
 
||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:50  
 
||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: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:08
 
||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:14  
 
||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:23  
 
||01:23  
||A drop down box opens up containing several border styles.
+
||A drop-down box opens up containing several border styles.
  
 
|-
 
|-
 
||01:28
 
||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:33
 
||01:33
||I will click on the last option.
+
||I will click on the last option,We see that the borders get formatted according to  our selected style.
 
+
|-
+
||01:34
+
||We see that the borders get formatted according to  our selected style.
+
  
 
|-
 
|-
 
||01:39
 
||01:39
||Let us undo this change.
+
||Let us '''undo''' this change.
  
 
|-
 
|-
 
||01:45  
 
||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:54  
 
||01:54  
||Now click on the “Borders” tab.  
+
||Now, click on the '''Borders''' tab.  
  
 
|-
 
|-
 
||01:56
 
||01:56
||You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”.  
+
||You will see the options for '''Line arrangement''', '''Line''', '''Spacing to contents''' and '''Shadow style'''.  
  
 
|-
 
|-
Line 92: Line 88:
 
|-
 
|-
 
||02:10
 
||02:10
||But one can change any of these to suit our requirement.
+
||But, one can change any of these to suit our requirement.
  
 
|-
 
|-
 
||02:14  
 
||02:14  
||Under “User-defined”, you can see a small preview window which displays the selection.
+
||Under '''User-defined''', you can see a small '''preview window''' which displays the selection.
  
 
|-
 
|-
 
||02:22
 
||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.
  
 
|-
 
|-
 
||02:29  
 
||02:29  
||I will also change the “Style”, “Width” and “Color”.
+
||I will also change the '''Style''', '''Width''' and '''Color'''.
  
 
|-
 
|-
Line 112: Line 108:
 
|-
 
|-
 
||02:38  
 
||02:38  
||Spacing to contents has the “Synchronize” option checked.  
+
||'''Spacing to contents''' has the '''Synchronize''' option checked.  
  
 
|-
 
|-
Line 124: Line 120:
 
|-
 
|-
 
||02:53
 
||02:53
||I will change “Top” and “Bottom” margins to 1.4pt.
+
||I will change '''Top''' and '''Bottom''' margins to '''1.4pt'''.
  
 
|-
 
|-
 
||03:00
 
||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:04
 
||03:04
||Click on OK.  
+
||Click on '''OK'''.  
  
 
|-
 
|-
Line 144: Line 140:
 
|-
 
|-
 
||03:18  
 
||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 color'''s to cells, '''Calc''' provides an option called '''Background Color''', located in the '''Formatting toolbar'''.
  
 
|-
 
|-
 
||03:27  
 
||03:27  
||Now let us see how it is implemented.
+
||Now, let us see how it is implemented.
  
 
|-
 
|-
Line 156: Line 152:
 
|-
 
|-
 
||03:36
 
||03:36
||So let us first click on the cell which contains the heading Serial Number, denoted by “SN”.
+
||So, let us first click on the '''cell''' which contains the heading "Serial Number", denoted by "SN".
  
 
|-
 
|-
 
||03:44
 
||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:50  
 
||03:50  
||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting to::olbar.
+
||After selecting the entire horizontal row containing the headings, click on the '''“Background Color”''' option in the '''Formatting toolbar'''.
  
 
|-
 
|-
 
||04:00  
 
||04:00  
||A pop up menu opens up where you can select the color you want to apply as a background.
+
||A pop-up menu opens up where you can select the color you want to apply as a background.
  
 
|-
 
|-
Line 180: Line 176:
 
|-
 
|-
 
||04:17  
 
||04:17  
||Calc provides various options for formatting multiple lines of text.
+
||'''Calc''' provides various options for formatting multiple lines of text.
  
 
|-
 
|-
 
||04:22
 
||04:22
||The first one is by using “Automatic Wrapping”.
+
||The first one is by using '''“Automatic Wrapping”'''.
  
 
|-
 
|-
Line 192: Line 188:
 
|-
 
|-
 
||04:33  
 
||04:33  
||So let us see how it is implemented.
+
||So, let us see how it is implemented.
  
 
|-
 
|-
 
||04:37
 
||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 an empty cell.
  
 
|-
 
|-
 
||04:44  
 
||04:44  
||For example lets click on cell number “B12”.
+
||For example- let's click on cell number “B12”.
  
 
|-
 
|-
 
||04:49
 
||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:54  
 
||04:54  
||Now click on the “Alignment” tab in the dialog box.
+
||Now, click on the '''“Alignment”''' tab, in the dialog-box.
  
 
|-
 
|-
 
||04:58
 
||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:08  
 
||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”.
  
 
|-
 
|-
Line 224: Line 220:
 
|-
 
|-
 
||05:19
 
||05:19
||Lets undo the changes
+
||Let's '''undo''' the changes.
  
 
|-
 
|-
 
||05:21  
 
||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:29  
 
||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”.
  
 
|-
 
|-
 
||05:46  
 
||05:46  
||Now hold down the “Shift” key on the keyboard and click on the cell with its corresponding item, “Salary”.
+
||Now, hold down the '''Shift''' key on the keyboard and click on the '''cell''' with its corresponding item, '''“Salary”'''.
  
 
|-
 
|-
Line 244: Line 240:
 
|-
 
|-
 
||05:59  
 
||05:59  
||Next click on the “Format” option in the menu bar and then click on the “Merge Cells” option.
+
||Next, click on the '''“Format”''' option in the menu bar and then click on the '''“Merge Cells”''' option.
  
 
|-
 
|-
 
||06:07  
 
||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:12  
 
||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 260: Line 256:
 
|-
 
|-
 
||06:31  
 
||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 on '''Ctrl+Z''' together.
  
 
|-
 
|-
 
||06:37  
 
||06:37  
||Next we will learn how to shrink text to fit into the cell.
+
||Next, we will learn how to shrink text to fit into the cell.
  
 
|-
 
|-
 
||06:41  
 
||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.
  
 
|-
 
|-
 
||06:49
 
||06:49
||Let us learn how to do it.
+
||Let us learn how to do it,Let's type the text “This is for the month of January” in the cell referenced as '''B14'''.
 
+
|-
+
||06:50
+
||Lets type the text “This is for the month of January” in the cell referenced as B14.
+
  
 
|-
 
|-
Line 284: Line 276:
 
|-
 
|-
 
||07:03  
 
||07:03  
||In order to shrink the text so that it fits, click on the cell referenced as B14 first.
+
||In order to shrink the text so that it fits, click on the cell referenced as '''B14''' first.
  
 
|-
 
|-
 
||07:11
 
||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'''.  
  
 
|-
 
|-
 
||07:18
 
||07:18
||Alternately, right-click on the cell and click on “Format Cells”.
+
||Alternately, right-click on the cell and click on '''Format Cells'''.
  
 
|-
 
|-
 
||07:24  
 
||07:24  
||You see that the “Format Cells” dialog box opens.
+
||You see that the “Format Cells” dialog-box opens.
  
 
|-
 
|-
 
||07:28
 
||07:28
||Click on the “Alignment” tab in the dialog box.
+
||Click on the '''Alignment''' tab in the dialog-box.
  
 
|-
 
|-
 
||07:31  
 
||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.
  
 
|-
 
|-
 
||07:41
 
||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.
+
||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  
 
||07:54  
||Lets undo the changes
+
||Let's '''undo''' the changes.
  
 
|-
 
|-
 
||07:57  
 
||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:02  
 
||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:09  
 
||08:09  
||Formatting multiple lines of text using Automatic Wrapping.
+
||Formatting multiple lines of text using '''Automatic Wrapping'''.
  
 
|-
 
|-
 
||08:14
 
||08:14
||Merging Cells. Shrinking text to fit the cell.
+
||Merging Cells. * Shrinking text to fit the cell.
  
 
|-
 
|-
 
||08:19
 
||08:19
||COMPREHENSIVE ASSIGNMENT
+
||COMPREHENSIVE ASSIGNMENT-
  
 
|-
 
|-
Line 348: Line 340:
 
|-
 
|-
 
||08:31  
 
||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:37
 
||08:37
||Shrink this text to fit in the cell.
+
||Shrink this text to fit in the '''cell'''.
  
 
|-
 
|-
 
||08:40  
 
||08:40  
||Watch the video available at the following link
+
||Watch the video available at the following link.
  
 
|-
 
|-
 
||08:43
 
||08:43
||It summarises the Spoken Tutorial project
+
||It summarizes the Spoken Tutorial project.
  
 
|-
 
|-
 
||08:46  
 
||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:51  
 
||08:51  
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials
+
||The '''Spoken Tutorial''' project team: Conducts workshops using spoken tutorials.
  
 
|-
 
|-
 
||08:56  
 
||08:56  
||Gives certificates for those who pass an online test
+
||Gives certificates for those who pass an online test.
  
 
|-
 
|-
 
||09:00
 
||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:06
 
||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:11
 
||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.
  
 
|-
 
|-
 
||09:18  
 
||09:18  
||More information on this Mission is available at spoken hyphen tutorial dot org slash NMEICT hyphen Intro
+
||More information on this mission is available at:'''spoken hyphen tutorial dot org slash NMEICT hyphen Intro'''.
  
 
|-
 
|-
 
||09:29  
 
||09:29  
||This tutorial has been contributed by ...............................(Name of the translator and narrator)
+
||This tutorial has been contributed by DesiCrew Solutions Pvt. Ltd.Thanks for joining.
 
+
And this is -----------------------(name of the recorder) from --------------------------(name of the place)signing off. Thanks for watching.
+
 
+
  Thanks for joining
+

Latest revision as of 12:41, 23 March 2017

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,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 toolbar.
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 an empty cell.
04:44 For example- let's 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 Let's 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 on 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,Let's 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 Let's 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 summarizes 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 DesiCrew Solutions Pvt. Ltd.Thanks for joining.

Contributors and Content Editors

Minal, PoojaMoolya, Pratik kamble, Sandhya.np14