Digital Book class-6 2nd edition With Coding

["Step-5\t:\t Click on 'Ok'. Or Step-1\t:\tSelect the multiple columns by dragging along the column heading. Step-2\t:\t Drag the boundary of a single selected column to re-size the column. Step-3\t:\t The selected columns will be changed in their width. Resizing Multiple Row Steps to Follow: Step-1\t:\t Select the multiple rows by dragging the cursor over the row heading. Step-2\t:\t Click the 'Format' arrow in the 'Cells' group of the 'Home' tab. Step-3\t:\t Click on 'Row height'. you get dialog box. Step-4\t:\t Enter the new 'Height' Step-5\t:\t Click on 'Ok'. Smart Computer Science Book-6 195","FORMATTING DATA IN THE WORK SHEET Formatting refers to arrangement of data set for good presentation, and appearance on a printed page or visual display. To present the data in effective way, some data can be placed in bold type, italic , in different font face, size and color. This makes worksheet attractive and easy to read. There are different aspects of data formatting i.e. number formatting, date\/time formatting, text formatting, etc. Here we learn how to make text formatting. Steps to Follow: Step-1\t:\t Select the Cells you want to format. Step-2\t:\t Click the 'Home' tab. Step-3\t:\t Use the Font and Alignment group for basic formatting. Here selecting B1 to D1 and making bold face text formatting. Merging & Center Cell Join the selected cells into one larger cell and center the content into new cell. This is often used to create labels that spans multiple columns. Let's follow the following steps in order to merge and center the cell. 196 Electronic Spreadsheet","Steps to Follow Step-1\t:\t Select the cell. Step-2\t :\t Click the 'Merge & Center' drop down option of 'Alignment' group of 'Home' tab Step-3\t:\t Select the 'Merge Center' option. Here, it is selected cell range A1 to D3 to merge and center a obtained new cell center to write. Insert Worksheet Steps to Follow: Step-1\t:\t Click the 'Home' tab. Step-2\t :\t Click the 'Insert Sheet' option from the cell group of 'Home' tab. Smart Computer Science Book-6 197","Deleting Worksheet Steps to Follow Step-1\t:\t Click the 'Home' tab. Step-2\t:\t Click the 'Delete' option from the Cell group of the 'Home' tab. Step-3\t:\t Select the 'Delete Sheet' option. Alignment of data Steps to Follow Step-1\t:\t Select data. Step-2\t:\t From 'Home' tab of 'Alignment' group. Click the appropriate Alignment option. Style of Data in sheet Steps to Follow Step-1\t:\t Select data. Step-2\t:\t Form 'Home' tab of 'Style' group. Click the appropriate Style option. If you are willing to explore more style, click the more drop down arrow. 198 Electronic Spreadsheet","Lab Activity 1. \tPrepare the following Worksheet and perform the given tasks: a.\t Look in the row 4, the name is h. \tIncrease the column width for typed 'Uma' that should be Muna Name and add their surname. and column H GK that is Social. i. \t Insert a column between Science \t b.\t Similarly in the row 6, name is and Social and add one more typed 'Kamala' that is 'Kamal subject 'Moral Science' . c.\t In the row 10, Rahul is not in this j. \t Insert a row between row 8 and list. He is in another section. You 9 and add one more record of have to remove it. Hemanta. d.\t Copy the row number 2 in row 10 k. \t Increase the font size 14 pt and and change the name Sumnima change font style. The heading an Roll is 9. should be changed bold. e.\t Move your entire data in row 2. f. \t Align the data heading as left. g. \t Increase the row height as you like Smart Computer Science Book-6 199","Knowledge Test 1. Answer the following questions: a.\t What do you mean by row and column? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... b. \tWhen do you increase row height and column width? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... c. When do you insert worksheet? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... d.\t What do you mean by re-sizing row and column? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... .................................................................................................................................... e.\t When do you insert row and column? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... 200 Electronic Spreadsheet","f.\t What do you mean by formatting worksheet? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... g.\t What do you mean by alignment? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... h.\t Differentiate between Copy and Cut. Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... i.\t What do you mean by Merging Cell? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... FORMULA IN MS-EXCEL We can use formula in MS-Excel to carry out calculation. Formula always begins with an equal to (=) sign. Formula is typed in formula bar. The formula is consisted by following elements: a. Values: Value may number (Numeric like 10, 20, 50.5,) or string (alpha character\\\". b. \tCell Address : A2, B10, C5, etc. c. \tFunction : SUM, AVERAGE, MIN, MAX, etc. d. \tOperator : +, -, \/, *, >, <, =, ^, , %,( ), etc. Smart Computer Science Book-6 201","Example of Formulae: = A1+B1 = A1 *10\/100 =B5*C5 =SUM(G5:G10) In this example, the formula =C2*D2 is entered in the cell E2 . Due to this formula, the result 12000 is obtained. Copy Formula It is not necessary to write same formula frequently. Once a formula is written, it can be copied for other cells. We can copy formula in two methods: a. Using Copy and Paste command b. Using Fill Handle. Using Copy and Paste Command Steps to follow: Step-1\t:\t Select the cell where formula is applied. Step-2\t: Click the 'copy' from 'Home' tab of 'Clip Board' group . 202 Electronic Spreadsheet","Step-3\t:\t Select the cell to paste the copied formula. Step-3\t:\t Click Paste in the 'Clip Board' group of 'Home' tab. In this example, formula is copied from cell E2 and paste in cell range E3 to E6: Using Fill Handle A fill handle is a small black square at the bottom right corner of an active Cell or range of Cells. It is used to copy a formula and display series of data in continues scale such as, 1, 2, 3..........., Sunday, Monday............ Saturday, January, February................December. Steps to Follow Step-1\t:\t Select the cell containing the formula. Step-2\t:\t Click the Fill Handle and drag it over the range to be filled. Step-3\t:\t The formula gets pasted to all the cells. In the given example, the fill handle of cell address A1 to C2 is dragged and drop up to A12 to C12 in the up coming sequence. Smart Computer Science Book-6 203","Lab Activity 1. \tPrepare the following Worksheet and perform the given task : a.\t Calculate Gross Total (Quantity \u00d7Rate) b.\t Find the discount 10 % of Gross total c.\t Find the Net total (Gross Total-Discount) d.\t Find the Net Total Amount. a. Calculate Gross Total Step-1\t:\t Place your cursor in E2. Step-2\t:\t Click the formula bar and type the formula as: =C2*D2 and press enter key. 204 Electronic Spreadsheet","Step-3\t:\t Now you get the value in the E2 cell. Step-4\t:\t Click on the E2. Step-5\t:\tClick in the fill handle and drag the mouse till E6 to copy formula. Now you get all the values of Gross Total. Calculate Discount Step-1\t:\t Place the cursor in F2. Step-2\t:\t Click on formula bar. Step-3\t:\tType the formula as: = (10*E2)\/100 and press enter key. Step-4\t:\t Copy the formula by clicking and dragging the fill handle till F6. Calculate Net Total Step-1\t:\t Place the cursor in G2. Step-2\t:\t Click on formula bar. Step-3\t:\t Type the formula as: = E2-F2 and press enter key. Step-4\t:\t Copy the formula by clicking and dragging the fill handle till G6. Calculate Total Amount Step-1\t:\t Place the cursor in G7. Step-2\t:\t Click on drop down button of 'AutoSum' from 'Editing' group of 'Home' tab . Or Step-3\t:\tType the formula in formula bar as: =SUM (G2:G10) and press enter. Finally you get your worksheet as given below: Smart Computer Science Book-6 205","Knowledge Test 1. Answer the following questions: a.\t Where do you write formula? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... b.\t What do you write in the beginning of the formula? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... c.\t What may the content of formula be? Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... ..................................................................................................................................... d.\t Write the method to copy a formula. 206 Electronic Spreadsheet","Ans:\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026... ..................................................................................................................................... Points to Know \u2022\t Spreadsheet is a software tool that lets us enter, calculate, manipulate and analyze sets of data which help to take right decision in the different official activities. \u2022\t It is similar to the manual spreadsheet used by accountant with pencil, eraser, paper and calculator, but it is an electronic version. \u2022\t MS-Excel is a one of the popular spreadsheet software which is developed by Micro Soft company, in USA. It comes with MS-Office package. \u2022\t Worksheet is a grid made up row and columns where you can input your data and formula. It is, just as a book, has number of pages. \u2022\t Document which you create in MS-Excel is called Workbook. \u2022\t The horizontal arrangement cells of worksheet is known as row and vertical arrangement of cells is called column. \u2022\t The cell is a unit of a worksheet which is formed by the intersection of row and column. \u2022\t The cell in which your pointer is placed and ready to type data is called active cell Terms to Know Cell Pointer \t : \t The active cell which is highlighted by a bolder rectangle Range of Cell\t : \t A collection of selected cells in a spreadsheet Cell\t: \t Intersection between a row and a column on a spreadsheet Operators \t : \t Symbols used in formulae Cell Reference : A range of cells on a worksheet and can be used in a formula Column \t :\t A vertical series of cells Row\t:\t A horizontal series of cells Smart Computer Science Book-6 207","Worksheet Objective Questions 1. Fill in the blanks: a.\t ........................................ is a software where you enter, calculate, manipulate and analyze data. b. \tSpread sheet consists of ............................... and ............................. c. \tMS-Excel comes with ..................................... package. d. \tWorksheet where you can input ............................. and ............................... e.\t ................................... displays the name of workbook. f. \t ...................................... is a document you create in MS-Excel. g. \tThere are .................................. rows and ................................ columns in MS- Excel 2007. h. \t........................... is used to carry out calculation. 2. State whether the following statements are true or false: a. \tData are re-managed in the paragraph form in the spreadsheet. b. \tMs-Excel is a popular word processing software. c. \tTitle bar is placed in the top of the window. d. \tRibbon is an organization of commands and instructions. e. \tWorkbook comes inside a worksheet. f. \t Vertical arrangement of cells is called row. g. \tHorizontal arrangement of cells is called column. h. \tCell is the biggest unit of a spreadsheet. 208 Electronic Spreadsheet","3. Match the following: a. Ctrl+Home\t\t View the different area of a worksheet. b. F5\t\t\t Copy a formula and display continuous series of data c. Scroll Bar\t\t Spreadsheet software. d. Lotus 1-2-3\t\t Move the cursor to the desired cell. e. Fill Handle\t\t Move the cursor to the first cell. Descriptive Questions 1. Answer the following questions: a. What is spreadsheet software? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... b. Write the features of MS-Excel. Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... c. What do you mean by active cell? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... d. What does formulae include? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... e. Why do you use fill handle? Smart Computer Science Book-6 209","Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... Skill Test-1 1. Prepare the following Worksheet and perform the given task : a. \tSelect the range A1 to C5 b. \tSelect the range A1 : B5 and D1 : D5 c. \tSelect third and fourth row d. Select the E and F column e. \tCalculate total marks 2. Prepare a worksheet with the detail information of your computer accessories such as serial number, name of accessories, brand name, tentative price. Now, find out cost of your computer. 210 Electronic Spreadsheet","Skill Test-2 1.\tSuppose your school organized an athletic meet last week. Now you have to prepare a worksheet on the number of each type of medals(Gold, Bronze and Sliver) to be owned by each house out of green, yellow, red and blue house. 2. Rasmita has been assigned a task to prepare the following worksheet in practical exam. She has made the following mistakes. a. \t Make Science and English instead of Scie and Eng respectively. b. \tIn B2 cell the name should be Rahuk instead of Rahul. c. \t In B5 cell instead of Shyamu, it should be Shyam. d. \t In Cell B3, Correct the name Subu to Shambu. e. \t Insert one column right hand side of name and add cast as Sing, Karki, Sherpa, Chudary and Gupta. Now, You have to make correction in this worksheet. s Smart Computer Science Book-6 211","Skill Test-3 1.\t Khusmila Upadhya typed the following data in the worksheet but finally realized that she has typed wrong data in the cell range C2 to F6. Now prepare the following of Khusmila's worksheet and make correction. Finally, calculate the total marks. 2.\tHikmat Pulami prepared the following worksheet. However, he typed roll number in column D, it should be in column C. Now, prepare the same worksheet and make correction using suitable technique. 212 Electronic Spreadsheet","Skill Test-4 1. Raghuji Mahaseth has been assigned a project work focusing in the final examination. He has prepared the following worksheet and performed the given work. Now, as Raghuji, you have to prepare the given worksheet as following and perform the given tasks. a. \t There is 'Math' in C1 cell, make f. \t Insert four more rows after the current it 'Maths'. third row and add records . b. \t Insert one more column after g.\t Kamla and Subu have already left the column E and add one more school, delete their records. subject Nepali and tentative marks. h. \t Move the marks of Maths after the marks of Science. c. \t Insert three rows in the top of the worksheet and merge center i. \t Make the duplicate copy of this cell range C1: D3 and type the worksheet in the new worksheet. name of school, address, and telephone Number. j. \t Computer marks of Shyamu should be 87 instead of 78. d. \t Format heading data bold, for name of school font size 18, font k. \t Practice cursor movement technique face bold. and selection technique given in this chapter. e. \tAdjust the row height and column width, if it is needed. l. \t Calculate total marks and copy the formula in other cells. Smart Computer Science Book-6 213","12Presentation with PowerPoint CHAPTER Learn and Act.. Miku\t : \tWow, so interesting! Today, we learn about digital presentation. Teacher\t : \tOf course, today onward, you will be able to make digital presentations. Miku\t : \tHow do we make attractive and effective presentation Ma'am? Teacher\t : PowerPoint software is used to make a presentation. There are a lot of features. You can place text, image, shapes and drawing, sound as well as video in your presentation. You can create animation and apply a lot of interesting slide transition features in the slide presentation. Without delay, let's start! INTRODUCTION Presentation software is a tool, which is used to create visual presentations. These presentations are usually created in the slide show format. The presentation programs make it possible to combine text and graphic elements to convey important information to a group of people at once. Common uses for this type of software includes teaching a new concept to a group of students, announcing the launch of new product or 214 Presentation with powerpoint","service campaign to employees, training for employees on key concepts of new policies or presenting a proposal to a group. One of the popular presentation software is Microsoft PowerPoint. Microsoft PowerPoint Microsoft PowerPoint is a powerful multimedia presentation program, which comes with Microsoft office package. It is developed by Microsoft Company. Using the PowerPoint, we can create a presentation containing text, graphics, sound, animation and videos. A presentation made up of a number of slides in the Powerpoint which comes in sequential order. Features of PowerPoint d.\t Support art gallery. e.\t Hands out can be created. a. \t Create a presentation slide. b. \t Audio, video and animation can be added. f.\t Timings can be rehearsed. c. \t Graphical object can be added. How to Start MS-Power point Step-1\t:\t Click the \u2018Start\u2019 button Step-2\t:\tType PowerPoint in search box. Step-3\t:\t You get the PowerPoint App as given in picture. Step-4\t:\tNow, click the PowerPoint App. Step-5\t:\tYou can see startup PowerPoint and get the home screen. The PowerPoint Window When you start Microsoft PowerPoint, you get its window which looks as given: Smart Computer Science Book-6 215","Quick Access Tool Bar Ribbon Title Bar Menu Tab Order of Slide Slide Status Bar Notes Place Holder View Buttons Zooming Create New Presentation Step-1\t:\t Click the File tab. Step-2\t:\t Click on \u2018New\u2019. Step-3\t:\tYou get a 'New Presentation' dialog box. Step-4\t:\t Select the desired Template or 'Blank Presentation' Step-5\t:\t Click the \u2018Create\u2019 button. Step-6\t:\t Now, you get your new presentation window. 216 Presentation with powerpoint","Select Presentation Layout 217 Step-1\t:\t Click the \u2018Drop Down\u2019 button of \u2018Layout\u2019 option from \u2018Slide\u2019 group of \u2018Home\u2019 Tab. Step-2\t:\tYou get the \u2018Office Theme\u2019 dialog box. Step-3\t:\tSelect your desire Layout theme from the Office Theme gallery. Step-4\t:\t Here, \u2018Title Slide\u2019 theme is selected. Select Slide design theme Step-1\t:\t Click the 'Design' Tab. Step-2\t:\t Right click on the desire design theme form \u2018Themes\u2019 group and select the option to . In this slide, \u2018Office Theme' 'Apply to All slides\u2019 is selected. Insert Slide Step-1\t:\t Click the \u2018Home\u2019 tab. Step-2\t:\t Click the \u2018New slide\u2019 icon from \u2018Slides\u2019 group. Step-3\t :\t Now, You get new slide. Smart Computer Science Book-6","Insert Text Box 'Insert' Steps to follow: Step-1\t:\t Select the tab. Step-2\t:\t Select 'Text Box' from 'Text' group. Step-3\t:\tDraw a text box by dragging the mouse. Step-4\t:\t Type your text. Insert Image Step-1\t:\t Click the \u2018Insert\u2019 tab. Step-2\t:\t Click the \u2018Picture\u2019 icon option. Step-3\t:\t Find the location. Step-4\t:\t Select your Image\/ picture. Step-5\t:\t Click the \u2018Insert\u2019 tab. FORMATTING TEXT Formatting text refers to the changes in the appearance of the text which includes font style, size, color, alignment, indentation, bold, italic, etc. You can format the text using 'Font' and 'Paragraph' group of 'Home' tab. Formatting from Font group Steps to Follow: Step-1\t:\t Select Text. 218 Presentation with powerpoint","Step-2\t:\t Click the 'Home' tab. By default, it is selected. Step-3\t:\t Find the 'Font' group. You can find a lot of formatting parameters such as Bold, Italic, Font face, Font size, Strike through, Shadow, Character spacing, Change case, Color,etc. Step-4\t:\t You can select and change as you like. Step-5\t:\tYou can activate Font dialog box for advance character formatting, by clicking the 'Flyer' button of 'Font' group. Formatting from Paragraph Group Steps to Follow: Step-1\t:\t Select Text. Step-2\t:\t Click the 'Home' tab. By default, it is selected. Step-3\t:\t Find the 'Paragraph' group where you can find a lot of paragraph formatting parameters such as Alignment, Columns, Bullet and Number list, Increase Decrease list level, Line spacing, Text direction, Align Text, Convert to SmartArt, etc. Step-4\t:\t You can select and change the parameters as you like. Step-5\t :\t You can activate 'Paragraph' dialog box for advance paragraph formatting, by clicking on 'Flyer' button of 'Paragraph' group. Smart Computer Science Book-6 219","Delete Slide Step-1\t:\t Select the Slide to delete and right mouse click. Step-2\t:\t You get the context menu. Step-3\t:\t Click the \u2018Delete Slide\u2019 option. Step-4\t:\t Now, Slide will be deleted. Organizing Slide Re-arrange the slides in slide pane is known as the organizing the slide. Sometimes, you need to change the place of slide, in such a case you have to do this task. Steps to Follow: Step-1\t:\t Select the slide in the Slide Pane. 220 Presentation with powerpoint","Step-2\t:\t Drag to the position you want. Step-3\t:\t Release the mouse button. Step-4\t:\t Now, you look, the slide position is changed. Lab Activity 1. Prepare the following Slides: Smart Computer Science Book-6 221","Knowledge Test 1. Answer the following questions: a. How do you start Microsoft Office PowerPoint? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... b. How do you start new presentation? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... c. Where do you get Layout of Presentation? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... d. Where do you get slide design theme? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... e. How do you insert slide? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... 222 Presentation with powerpoint","f. How do you delete slide? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... g. How do you write text in slide? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... h. How do you place picture in slide? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... i. How can you format your text in slide? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... Change Text Direction Steps to Follow: Step-1\t:\t Select Text. Step-2\t:\t Click the \u2018Home\u2019 tab. Step-3\t:\t In the \u2018Paragraph\u2019 group, click the \u2018Text Direction\u2019 drop down button. Step-4\t:\tSelect your desire option. Smart Computer Science Book-6 223","How to Insert Bullet or Number List Steps to Follow Step-1\t:\t Select Text. Step-2\t:\t Click the 'Home' tab. Step-3\t:\t Click the \u2018Drop down\u2019 button of the bullet list icon from \u2018Paragraph\u2019 group to insert Bullet List. \t\tor \t\tClick the \u2018Drop down\u2019 button of Number list icon from \u2018Paragraph\u2019 group to insert Number List. Step-4\t:\t Select the desired bullet. Convert to Smart Object Steps to Follow Step-1\t:\t Select list of Text. Step-2\t:\t Click the 'Home' tab. Step-3\t:\t Click the \u2018Drop down\u2019 button of the 'Convert to Smart Object\u2019 Paragraph group of Home tab. Step-4\t:\tSelect and click the desired Smart object. Step-5\t:\t You notice that selected text converts in to the form of Smart object. 224 Presentation with powerpoint","Lab Activity 1. Prepare the following two slides : Smart Computer Science Book-6 225","Lab Activity 1. Prepare the following slide: Knowledge Test 1. Answer the following questions: a. What do you mean by text direction? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... b. How many types of basic text directions are there? Write their name. 226 Presentation with powerpoint","Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... c. How do you change text direction? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... d. When do you use bullet list? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... e. When do you use number list? Ans: ............................................................................................................................ ..................................................................................................................................... .................................................................................................................................... f. Where do you get Bullet List Gallery? Ans: ............................................................................................................................ ..................................................................................................................................... .................................................................................................................................... g. Where do you get Number List Gallery? Ans: ............................................................................................................................ ..................................................................................................................................... .................................................................................................................................... h. Where do you get Text Direction Gallery? Ans: ............................................................................................................................ Smart Computer Science Book-6 227","..................................................................................................................................... ..................................................................................................................................... i. What do you mean by smart object? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... j. Why do you use smart object? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... Apply Slide Transition Slide transitions are the effects which appear when you switch from one slide to next slide during the slide show. Steps to Follow: Step-1\t:\t Select the slide where you want to apply transition effect Step-2\t:\t Click the \u2018Animations\u2019 tab. Step-3\t:\t Find the 'Transition to This Slide'. Step-4\t:\t Choose the appropriate transition. 228 Presentation with powerpoint","Run PowerPoint Slide Show After creating your slides, you can run your slides to show. You can run slide in any one of the following ways. Steps to Follow Step-1\t:\t Press F5 to run from first slide or Press Shift+F5 to run from current slide. \t\tor Step-2\t:\t Select the Slide Show tab. Step-3\t:\t Find the 'Start Slide Show' group. Step-4\t:\t Click 'From Beginning' button to run from first slide. But if you want to run from current slide, click on 'From Current Slide'. Save Presentation Steps to Follow: Step-1\t:\t Click the \u2018File\u2019 menu tab. Step-2\t:\t Click the \u2018Save\u2019. Step-3\t:\t Click the 'Browse' button to locate the location . Step-4\t:\t Type the file name. Step-5\t:\t Click the \u2018Ok\u2019. Close presentation & Exit from MS- PowerPoint Steps to follow: Step-1\t:\t Click the \u2018File\u2019 tab. Step-2\t:\t Click the \u2018Close\u2019. Step-3\t:\t Click the close button of PowerPoint Window to exit from PowerPoint program. Smart Computer Science Book-6 229","How to Review Presentation Steps to follow: Step-1\t:\t Click the \u2018Review\u2019 Tab. Step-2\t:\t Select object to comment and click the 'New comment'. You get a comment icon and comment pane. Step-3\t:\t Start to type your comment in comment pane. Lab Activity 1. \tPrepare the given slide and set the desired slide transition and make comment. 230 Presentation with powerpoint","Knowledge Test 1. Answer the following questions: a. How do you apply slide transition? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... b. What is the function of F5 in PowerPoint? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... c. What is the function of Shift+F5 in PowerPoint? Ans:............................................................................................................................. .................................................................................................................................... .................................................................................................................................... d. Why do you save your presentation? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... e. Is it necessary to close the presentation before exiting from PowerPoint? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 231","Points to Know \u2022\t Presentation software is used to create visual presentations. \u2022\t Presentation software makes it possible to combine text and graphic elements to convey important information to a group of people at once. \u2022\t Common use of presentation software includes teaching, campaign, training to a group of people. \u2022\t Microsoft PowerPoint is a powerful multimedia presentation software program, which comes with Microsoft Office Package. \u2022\t Using the PowerPoint, we can create a presentation containing text, graphics, sound, animation and videos. \u2022\t Formatting text refers to change the appearance of the text which includes font style, size, color, alignment, indentation, bold, italic, etc. Terms to Know Presentation\t : \t The process of presenting a topic to an audience Slide\t: \t A single page of a presentation Multimedia\t: \t Content that uses a combination of text, audio, images, animations, video and interactive content Animation \t : \t A method in which pictures are manipulated to appear as moving im- ages Zooming \t : \t Focusing on a section of an image and increasing its overall size for greater detail Layout \t :\t The arrangement or plan of visual elements on a page\t Office Theme\t :\t A set of ready made formatting choices Indention\t:\t Increase or decrease of space between the left and right margin of a paragraph Transition\t:\t Effects appears when change from one slide to next Slide Show\t :\t A series of pictures or pages of information displayed on large screen. Current Slide\t :\t The slide which is selected or running\t 232 Presentation with powerpoint","Worksheet Objective Questions 1. Fill in the blanks: a. \t...................................... software is a tool used to create visual presentation. b. \tPresentations are usually created in ........................ ......................... format. c. \tMicrosoft PowerPoint is a ...........................................presentation software. d. \t................................. text refers to change the appearance of text. e. \tText is formatted using ............................. and ...................... group of Home tab. 2. State whether the following statements are true or false. a. F5 is used to run the slide from current position. b. Shift+F5 is used to run the presentation from beginning. c. Only Close and Exit command are available under the 'Office Button'. d. Slide transition is appears when you switch from one slide to next slide during the slide show. e. There are four basic types of text directions in MS-Powerpoint. f. Changing the place of slide is known as the organizing the slide. g. You can format your text from Font and Paragraph group. h. Re-arrange the slides in slide pane is known as the organizing the slide. Smart Computer Science Book-6 233","Descriptive Questions 1. Answer the following questions: a. What do you mean by presentation software? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... b. What tasks does presentation software make possible? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... .................................................................................................................................... .................................................................................................................................... c. Why is presentation software commonly used? Ans:.............................................................................................................................. ..................................................................................................................................... d. What is Microsoft PowerPoint? Ans: ............................................................................................................................ ..................................................................................................................................... ..................................................................................................................................... e. What do you mean by organizing slide? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... 234 Presentation with powerpoint","f. What do you mean by text formatting? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... g. What do you mean by slide transition? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... h. Why do you save your presentation? Ans:............................................................................................................................. ..................................................................................................................................... .................................................................................................................................... .................................................................................................................................... .................................................................................................................................... i. \tIs it necessary to close the presentation before exiting from presentation software? Ans:............................................................................................................................. ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... ..................................................................................................................................... Smart Computer Science Book-6 235","Case Study and Application-based Questions 1. \tManish Dhami has been assigned a task to create a presentation about his school, containing 5 to 6 slides. He prepared and saved his presentation named 'My School'. Later on, he made some changes in the presentation and saved the modified presentation again with the same name. Finally, He saved entire presentation in a new name. a. How did he insert new slides? ............................................................... ............................................................... Solution:.......................................... ............................................................... ............................................................... ............................................................... b. How did he save the file time? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... c. How did he save file after making changes with the same name? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... d. How did he save file with a new name? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... 236 Presentation with powerpoint","2. \tBhurka Chaudhary is a computer science teacher. He has assigned a project for class six students to create a slide presentation on the topic 'Importance of Computer Technology'. After collecting the project, he has to check and assign the grade for this project. a. How will Bhurka review the slides? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... b. How will he view the presentation? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... 3. \tBinita Tripathi has started a blank presentation to make a presentation on her daily life. Later on, she thought to add slide design theme? a. How will she add individual design theme for each slide? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... b. How will she add the same theme for all the slide? Solution:.......................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... Smart Computer Science Book-6 237","4. Looking at the given slide answer the following questions: a. Which alignment is used for the heading ? How do you change it ? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... b. Which theme is used in the slide ? How do you change it? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... 238 Presentation with powerpoint","c. Which feature has been used to mark the point ? How is it possible ? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... d. \t How is it possible to underline the sub heading of a slide? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... e. Which option is used to change the color? How do you change color? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... f. \t How is it possible to place a picture in the slide ? Solution:.................................................................................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... ............................................................... Smart Computer Science Book-6 239","Lab Project 1. \t The Computer Science teacher has asked you to make a presentation of 5 to 6 slides on the topic 'Application fields of computer'. The presentation should include: Text, Image, Slide transitions, Font formatting, and Paragraph formatting features. 2. Your School is going to organize the Children's Day celebration program. In this program, you are planning to give a small presentation about 'Stop Child Labour'. Now, prepare a slide presentation having 5 to 6 slides and include all the features of Ms- PowerPoint that you have learned in this chapter. 3. \tYour School is going to organize an 'Election Program' to select the school- captain, head-boy, head-girl, house-captain and class- captain. You are also going to participate in this program. For this, you think to organise a group campaigning. So,for this campaigning, create an effective PowerPoint presentation, which will impress your audience. 240 Presentation with powerpoint","More on Scratch Coding CHAPTER Learn and Act.. 13 Teacher\t : \tHi ! Today, we learn more on Scratch, are you ready? Miku\t : \tYes, we are ready for this. What features will we learn, ma'am? Teacher\t:\tWe will learn about Variables, Input\/Output, Operators, List blocks and Pen extension. Miku\t: \tHow can we repeat a task for number of times, Ma'am? Teacher\t : \t We should use LOOP blocks for this. It is also included in this chapter, Miku. Miku\t:\t Wow, interesting ! Is there any technique to take decision like yes or no? Teacher\t : \t We use conditional blocks for this case. Miku\t: \t Sometimes, I have to frequently use same bunch of codes. Is there any idea to reduce codes, Teacher? Teacher \t : \t There is 'My Blocks' in the Scratch, we study in this chapter. Introduction to Scratch Scratch is a block based visual programming language that allows us to create our own interactive stories, games and animations. As we design Scratch projects, we learn to think creatively, reason systematically, and work collaboratively. It builds logic and analytical skills with fun. Scratch was created by the Lifelong Kindergarten group at MIT Media lab and is available for free download at http:\/\/scratch.mit.edu. Once Scratch is downloaded and installed to a computer, you do not need Internet access to create a project. Smart Computer Science Book-6 241","Variable Variable is a name of storage location which holds changeable value in memory. Variables can only hold one value at a time. These values can be either numbers or strings any text. Clicking on an isolated variable in the scripts area displays a small bubble reporting the value of the variable. Scratch does not allow variables to be created by a script as it runs. Instead, variables are created with the \\\"Make a Variable\\\" button in the Block Palette. There are five different blocks relating to variables: Types of variable There are three types of variables: i) Global Variables: By default, when a variable is created, it is a global variable. Global variables can be read and changed by any sprite, or the Stage. All variables are stored in RAM, and default value is zero. 242 More on Scratch Coding","Local Variables: Local, (or private\/personal) variables are created the same way as global, but another option is selected in the variable creation dialog box, \\\"For this sprite only\\\". Local variables can be read and changed by only one sprite, or the Stage. Cloud variable: Cloud variables are variables that are stored on the cloud server. You will get its access, if you have already become scratcher. Creating a variable To create a variable, follow the following steps: Steps to follow: Step-1\t:\t Click the 'Variables' section from the 'Code' tab Step-2\t: \tIn the variables palette, click Make a variable. Given dialog box will appear. Step-3 \t: \t Type the name of the variable, and select whether it should be \\\"for all sprites\\\" (global) or \\\"for this sprite only\\\" (local). Step-4 \t: \t Press OK. Input\/Output The Ask () and Wait block is a Stack\/Cap block. It is available under a Sensing category block. This block will make the question and show an input box at the bottom of the screen. If this block is used in a sprite, the question asked Smart Computer Science Book-6 243","will show similar to the Say () (block). When the sprite is hidden, the question pops up above the input box. Scratchers can input text into it and submit it, then the input is stored in the Answer() block. The Answer block automatically updates to most recent input. Sample Program-1 Let's create a program to make question and answer. Mathematical Operators Block In scratch, mathematical operators blocks are used to perform the mathematical operation. These blocks are also called reporters block. Mathematical blocks in scratch are: Operators Function Add two numbers Subtract two numbers Multiply two numbers Divide two numbers Return remainder of two numbers Round up a number Return absolute value 244 More on Scratch Coding"]