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

From Script | Spoken-Tutorial
Jump to: navigation, search
(Created page with " {|Border=1 ||'''Time''' ||'''Narration''' |- ||00:00 ||Welcome to the Spoken tutorial on LibreOffice Calc – Formatting Data in Calc. |- ||00:07 ||In this tutorial we wi...")
 
Line 1: Line 1:
−
 
+
'''Resources for recording'''
 +
[[Media:Formatting Data.zip |Formatting Data]]
  
 
{|Border=1
 
{|Border=1
Line 10: Line 11:
  
 
|-
 
|-
−
||00:07
+
||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:14
+
||00:12
 
||Formatting multiple lines of text using Automatic Wrapping.
 
||Formatting multiple lines of text using Automatic Wrapping.
  
 
|-
 
|-
−
||00:19
+
||00:18
 
||Merging Cells.Shrinking text to fit the cell.
 
||Merging Cells.Shrinking text to fit the cell.
  
 
|-
 
|-
−
||00:23
+
||00:22
−
||Here we are using Ubuntu Linux 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.
  
 
|-
 
|-
Line 30: Line 31:
  
 
|-
 
|-
−
||00:38
+
||00:39
 
||Let us open our “personal finance tracker.ods” file.
 
||Let us open our “personal finance tracker.ods” file.
  
 
|-
 
|-
−
||00:43
+
||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:49
+
||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:00
+
||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:07
+
||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:13
+
||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:22
+
||01:23
 
||A drop down box opens up containing several border styles.
 
||A drop down box opens up containing several border styles.
  
 
|-
 
|-
−
||01:27
+
||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:32
+
||01:33
 
||I will click on the last option.
 
||I will click on the last option.
  
 
|-
 
|-
−
||01:35
+
||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:41
+
||01:39
 
||Let us undo this change.
 
||Let us undo this change.
  
 
|-
 
|-
−
||01:44
+
||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:53
+
||01:54
 
||Now click on the “Borders” tab.  
 
||Now click on the “Borders” tab.  
  
Line 86: Line 87:
  
 
|-
 
|-
−
||02:04
+
||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:08
+
||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:21
+
||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:37
+
||02:38
 
||Spacing to contents has the “Synchronize” option checked.  
 
||Spacing to contents has the “Synchronize” option checked.  
  
 
|-
 
|-
−
||02:41
+
||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:46
+
||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:52
+
||02:53
 
||I will change “Top” and “Bottom” margins to 1.4pt.
 
||I will change “Top” and “Bottom” margins to 1.4pt.
  
 
|-
 
|-
−
||02:59
+
||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
+
||03:04
 
||Click on OK.  
 
||Click on OK.  
  
 
|-
 
|-
−
||03:05
+
||03:06
 
||This will apply the chosen style to the selected cells.
 
||This will apply the chosen style to the selected cells.
  
 
|-
 
|-
−
||03:10
+
||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:17
+
||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:43
+
||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:49
+
||03:50
−
||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 to::olbar.
  
 
|-
 
|-
Line 178: Line 179:
  
 
|-
 
|-
−
||04:16
+
||04:17
 
||Calc provides various options for formatting multiple lines of text.
 
||Calc provides various options for formatting multiple lines of text.
  
 
|-
 
|-
−
||04:21
+
||04:22
 
||The first one is by using “Automatic Wrapping”.
 
||The first one is by using “Automatic Wrapping”.
  
 
|-
 
|-
−
||04:25
+
||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:32
+
||04:33
 
||So let us see how it is implemented.
 
||So let us see how it is implemented.
  
 
|-
 
|-
−
||04:35
+
||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:43
+
||04:44
 
||For example lets click on cell number “B12”.
 
||For example lets click on cell number “B12”.
  
 
|-
 
|-
−
||04:47
+
||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:53
+
||04:54
 
||Now click on the “Alignment” tab in the dialog box.
 
||Now click on the “Alignment” tab in the dialog box.
  
 
|-
 
|-
−
||04:57
+
||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:06
+
||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:13
+
||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:22
+
||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:28
+
||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
+
||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:11
+
||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:29
+
||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:42
+
||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:51
+
||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.
  
 
|-
 
|-
−
||06:59
+
||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:10
+
||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:23
+
||07:24
 
||You see that the “Format Cells” dialog box opens.
 
||You see that the “Format Cells” dialog box opens.
  
 
|-
 
|-
−
||07:27
+
||07:28
 
||Click on the “Alignment” tab in the dialog box.
 
||Click on the “Alignment” tab in the dialog box.
  
 
|-
 
|-
−
||07:32
+
||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:53
+
||07:54
 
||Lets undo the changes
 
||Lets undo the changes
  
 
|-
 
|-
−
||07:56
+
||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:01
+
||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
+
||08:09
 
||Formatting multiple lines of text using Automatic Wrapping.
 
||Formatting multiple lines of text using Automatic Wrapping.
  
Line 330: Line 331:
  
 
|-
 
|-
−
||08:17
+
||08:19
 
||COMPREHENSIVE ASSIGNMENT
 
||COMPREHENSIVE ASSIGNMENT
  
 
|-
 
|-
−
||08:20
+
||08:21
 
||Open “spreadsheet practice.ods” sheet.
 
||Open “spreadsheet practice.ods” sheet.
  
 
|-
 
|-
−
||08:24
+
||08:25
 
||Select all the headings.
 
||Select all the headings.
  
 
|-
 
|-
−
||08:25
+
||08:27
 
||Give the background color to the headings as blue.
 
||Give the background color to the headings as blue.
  
 
|-
 
|-
−
||08:30
+
||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:36
+
||08:37
 
||Shrink this text to fit in the cell.
 
||Shrink this text to fit in the cell.
  
 
|-
 
|-
−
||08:39
+
||08:40
 
||Watch the video available at the following link
 
||Watch the video available at the following link
  
 
|-
 
|-
−
||08:42
+
||08:43
 
||It summarises the Spoken Tutorial project
 
||It summarises the Spoken Tutorial project
  
 
|-
 
|-
−
||08:45
+
||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:50
+
||08:51
 
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials
 
||The Spoken Tutorial Project Team Conducts workshops using spoken tutorials
  
 
|-
 
|-
−
||08:55
+
||08:56
 
||Gives certificates for those who pass an online test
 
||Gives certificates for those who pass an online test
  
 
|-
 
|-
−
||08:59
+
||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:05
+
||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:10
+
||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:28
+
||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:23, 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

Contributors and Content Editors

PoojaMoolya, Sandhya.np14

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice-Calc-on-BOSS-Linux/C2/Formatting-Data/English-timed&oldid=19521"