Difference between revisions of "LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 7: Line 7:
 
|-
 
|-
 
||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:07
 
||00:07
||In this tutorial we will learn about:Formatting Borders, background colors.
+
||In this tutorial, we will learn about: * Formatting '''Borders, background colors'''.
  
 
|-
 
|-
 
||00:14
 
||00:14
||Formatting multiple lines of text using Automatic Wrapping.
+
||* Formatting multiple lines of text using '''Automatic Wrapping'''.
  
 
|-
 
|-
 
||00:19
 
||00:19
||Merging Cells.Shrinking text to fit the cell.
+
||* Merging Cells, Shrinking text to fit the '''cell'''.
  
 
|-
 
|-
 
||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  
||First let us learn about formatting borders in LibreOffice Calc.
+
||First, let us learn about formatting borders in LibreOffice Calc.
  
 
|-
 
|-
Line 35: Line 35:
 
|-
 
|-
 
||00:43
 
||00:43
||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:49
 
||00:49
||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:00
 
||01:00
||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:07
 
||01:07
||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:13
 
||01:13
||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'''.
  
 
|-
 
|-
Line 71: Line 71:
 
|-
 
|-
 
||01:41
 
||01:41
||Let us undo this change.
+
||Let us '''undo''' this change.
  
 
|-
 
|-
 
||01:44
 
||01:44
||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:53
 
||01:53
||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 95: Line 95:
 
|-
 
|-
 
||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:21
 
||02:21
||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”'''.
  
 
|-
 
|-
 
||02:33
 
||02:33
||Again notice the change in the preview window.
+
||Again, notice the change in the '''preview''' window.
  
 
|-
 
|-
 
||02:37
 
||02:37
||Spacing to contents has the “Synchronize” option checked.  
+
||'''Spacing to contents''' has the '''“Synchronize”''' option checked.  
  
 
|-
 
|-
Line 119: Line 119:
 
|-
 
|-
 
||02:46
 
||02:46
||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:52
 
||02:52
||I will change “Top” and “Bottom” margins to 1.4pt.
+
||I will change '''“Top”''' and '''“Bottom”''' margins to '''1.4pt'''.
  
 
|-
 
|-
 
||02:59
 
||02:59
||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
 
||03:03
||Click on OK.  
+
||Click on '''OK'''.  
  
 
|-
 
|-
Line 143: Line 143:
 
|-
 
|-
 
||03:17
 
||03:17
||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.
  
 
|-
 
|-
 
||03:27  
 
||03:27  
||Now let us see how it is implemented.
+
||Now, let us see how it is implemented.
  
 
|-
 
|-
Line 155: Line 155:
 
|-
 
|-
 
||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:43
 
||03:43
||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:49
 
||03:49
||After selecting the entire horizontal row containing the headings, click on the “Background Color” option in the Formatting toolbar.
+
||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.
  
 
|-
 
|-
 
||04:08  
 
||04:08  
||Let us click on “Grey” color.
+
||Let us click on '''“Grey”''' color.
  
 
|-
 
|-
 
||04:11
 
||04:11
||You can see that the cell background for the headings turns grey.
+
||You can see that the '''cell background''' for the headings turns grey.
  
 
|-
 
|-
Line 183: Line 183:
 
|-
 
|-
 
||04:21
 
||04:21
||The first one is by using “Automatic Wrapping”.
+
||The first one is by using '''“Automatic Wrapping”'''.
  
 
|-
 
|-
 
||04:25
 
||04:25
||"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:32
 
||04:32
||So let us see how it is implemented.
+
||So, let us see how it is implemented.
  
 
|-
 
|-
 
||04:35
 
||04:35
||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.
  
 
|-
 
|-
Line 203: Line 203:
 
|-
 
|-
 
||04:47
 
||04:47
||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:53
 
||04:53
||Now click on the “Alignment” tab in the dialog box.
+
||Now, click on the '''“Alignment”''' tab in the '''dialog box'''.
  
 
|-
 
|-
 
||04:57
 
||04:57
||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.
  
 
|-
 
|-
Line 223: Line 223:
 
|-
 
|-
 
||05:19
 
||05:19
||Lets undo the changes
+
||Let's '''undo''' the changes.
  
 
|-
 
|-

Revision as of 12:17, 17 August 2015


Time Narration
00:00 Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc.
00:07 In this tutorial, we will learn about: * Formatting Borders, background colors.
00:14 * Formatting multiple lines of text using Automatic Wrapping.
00:19 * Merging Cells, Shrinking text to fit the cell.
00:23 Here we are using GNU/Linux as our operating system and LibreOffice Suite version 3.3.4.
00:33 First, let us learn about formatting borders in LibreOffice Calc.
00:38 Let us open our “personal finance tracker.ods” file.
00:43 Formatting of borders can be done on a particular cell or a block of cells.
00:49 For example, let us format the cells with the headings “Serial Number”, “Item”, “Cost”, “Spent”, ”Received”, ”Date” and ”Account”.
01:00 So, let us first click on the cell with the heading Serial Number, denoted by “SN”.
01:07 Now, hold down the left mouse button and drag it along the cells containing the headings.
01:13 After selecting the entire horizontal row containing the headings, click on the “Borders” icon on the Formatting toolbar.
01:22 A drop down box opens up containing several border styles.
01:27 Click on one of the styles you want to apply on the borders.
01:32 I will click on the last option.
01:35 We see that the borders get formatted according to our selected style.
01:41 Let us undo this change.
01:44 The selected cells are still highlighted. Right-click on the selection and choose “Format Cells” option.
01:53 Now click on the “Borders” tab.
01:56 You will see the options for “Line arrangement”, “Line”, “Spacing to contents” and “Shadow style”.
02:04 Displayed in each of these are the default settings of Calc.
02:08 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:21 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:37 Spacing to contents has the “Synchronize” option checked.
02:41 This means that the same spacing is applied to all the margins.
02:46 One can uncheck it and change the margin spacing as per the requirement.
02:52 I will change “Top” and “Bottom” margins to 1.4pt.
02:59 I will leave you to explore the various Shadow styles, on your own.
03:03 Click on OK.
03:05 This will apply the chosen style to the selected cells.
03:10 After learning how to format borders, now let us learn how to give background colors to cells.
03:17 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:43 Now hold down the left mouse button and drag it along the cells containing the headings.
03:49 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:16 Calc provides various options for formatting multiple lines of text.
04:21 The first one is by using “Automatic Wrapping”.
04:25 "Automatic Wrapping” allows a user to enter multiple lines of text into a single cell.
04:32 So, let us see how it is implemented.
04:35 Now, in our “personal finance tracker.ods” sheet, let us click on a empty cell.
04:43 For example lets click on cell number “B12”.
04:47 Now, do a right click on cell and then click on the “Format Cells” option.
04:53 Now, click on the “Alignment” tab in the dialog box.
04:57 At the bottom of the dialog box, click on the “Wrap text automatically” option and then click on the “OK” button.
05:06 Now we type “THIS IS A PERSONAL FINANCE TRACKER. IT IS VERY USEFUL”.
05:13 You see that the multiple statements get wrapped in a single cell.
05:19 Let's undo the changes.
05:22 After learning about “Automatic Wrapping”, we will now learn how to merge cells in Calc.
05:28 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:06 In the sidebar which pops up, click on the “Merge Cells” option.
06:11 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:29 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:42 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:51 Lets type the text “This is for the month of January” in the cell referenced as B14.
06:59 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:10 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:23 You see that the “Format Cells” dialog box opens.
07:27 Click on the “Alignment” tab in the dialog box.
07:32 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:53 Lets undo the changes
07:56 This brings us to the end of the Spoken Tutorial on LibreOffice Calc.
08:01 To summarize, we learned about: Formatting Borders, background colors in Calc.
08:08 Formatting multiple lines of text using Automatic Wrapping.
08:14 Merging Cells. Shrinking text to fit the cell.
08:17 COMPREHENSIVE ASSIGNMENT
08:20 Open “spreadsheet practice.ods” sheet.
08:24 Select all the headings.
08:25 Give the background color to the headings as blue.
08:30 Using “Automatic Wrapping” type the text, “This is a Department Spreadsheet”.
08:36 Shrink this text to fit in the cell.
08:39 Watch the video available at the following link
08:42 It summarises the Spoken Tutorial project
08:45 If you do not have good bandwidth, you can download and watch it
08:50 The Spoken Tutorial Project Team Conducts workshops using spoken tutorials
08:55 Gives certificates for those who pass an online test
08:59 For more details, please write to contact at spoken hyphen tutorial dot org
09:05 Spoken Tutorial Project is a part of the Talk to a Teacher project
09:10 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:28 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

Contributors and Content Editors

PoojaMoolya, Sandhya.np14