Code 402 Class 9 MS Office Base

1. Click on the Slide Show tab. 2. In the Start Slide Show group, click on the From Beginning button (F5) (to run the slideshow from the beginning), or From Current Slide (Shift + F5) (to run the slideshow from the slide which is selected/open in the PowerPoint window). You can also click on the Slideshow icon on the status bar of the PowerPoint window to run slideshow from the beginning. Press Esc key to quit the slideshow. Exercise 1. Open the presentation created in the previous session and press F5 to view it from the beginning. 2. In Normal View, go to third slide and try running the slide show from this current slide. Session-5 Using Help For help, press F1 or click on the ? icon near the Control buttons on the right hand side on the Title bar. In the Help window, type the topic or term on which you need help and press Enter key. The help topics will be listed. Click on them to learn more. In the Help window, type the topic or term on which you need help and press Enter key. The help topics will be listed. Click on them to learn more. 200

You can click on Back, Forward and Home icons to browse the topics in the Help window. Print icon can print the contents of the current window. If you are online then Help topics are listed from the online sources too. Help topics can also be located by checking out various topic categories. Note: ? icon is also found in the Title bar of the dialog boxes. Exercise 1. Using Help feature, find out how to apply various animation styles on the slide objects. 2. Practice going backward and forward in the help window across various help topics. 3. Practice coming to the Help Home page. 4. Try locating your topic in the Help categories. Session-6 Edit Text - Font Size, Style and Colour You can apply font size, style and colour on the text using different text formatting options on the Home tab in different groups. Let us see these options. 201

Select the text you need to format and click on the desired option on the ribbon in the Font group of the Home tab. Exercise Open the presentation saved in the previous session and format the text as directed below: Slide 1: Font Impact, Font Size 72, Font Color Navy Blue Slide 2: Name of the school in Agency FB, Blue and Font Size at 40 or more. School address in Arial, Italicised, Green, Size little lesser than the size of School Name. Slide 3: Name of the sports activities in Calibri font, bold, maroon colour, size 18 Slide 4: Your name and rollno any font, colour and size of your choice. Session-7 Edit Text in a Presentation You can format the text on the slide using different text formatting options, available in MS PowerPoint. The options are available on the Home tab in different groups. Let us see these options. In the image given below, some options for text formatting are highlighted. To apply any type of formatting, first select the text (that you want to format) and click on desired option. Bullets and Numbering To display points in the form of Bullets and numbered items: Home tab > Paragraph group > Bullets drop-down or Numbering drop-down. 202

Exercise Create a new presentation with Blank Slide. Add two text boxes – one for title and the other for content. Type the Title as About PowerPoint. In the second text box, type about PowerPoint (refer to Session 1). Then do the following: Format the title as: Impact Font, Size maximum 72, Shadow effect, Change the title to Uppercase, Font colour: Dark Orange, Format Content as: Times New Roman Font, Size maximum 36, Italicised, Font colour: Dark blue Session-8 Viewing the Presentation PowerPoint includes different slide views present at View tab. The slide view commands are also located at the bottom-right of the PowerPoint window. There are five main slide views: Normal View This is the default view that you see when you first start PowerPoint. It displays all the slides in thumbnails in the slide pane (on the left), the current slide in the slide area (in the middle) and a notes area at the bottom. This is the main editing view, where you can create and design your presentation. 203

Slide Sorter View Slide Sorter View sets all the slides in thumbnail form, on the screen so that you can see how they look as a whole and apply transition effects and design changes to the whole presentation at once. This view helps you to sort and organize the sequence (by dragging) of the slides. Outline View This view displays the outline of the slides, in the slide pane (on the left), instead of the thumbnails. This view displays only the text on your slide. The current slide is displayed in slide area and the notes are at the bottom. 204

Notes Page View This view allows you to type notes for the current slide. Notes area is located below the current slide. Notes can be printed or included in the presentation. Reading View Reading view allows you to view the presentation in full screen like Slide Show view. It shows the controls to browse the slides. Exercise Open MS PowerPoint, take a blank presentation and do the following: 1. Name the different slide views available in MS PowerPoint 2013. 2. Distinguish between Normal view and Slide Sorter View. 3.. Write a few words about: a. Normal View. b. Slide Sorter View. c. Outline View. 205

Session-9 Inserting Animations Animation is one of the chief ingredients of electronic presentations. An animation makes the presentation effective, attractive and professional looking. We have discussed earlier (in the previous classes), that we can add animation to a PowerPoint presentation. In this chapter, you will learn about adding different types of animation effects to the presentation. A simulation of movement, created by displaying a series of pictures, or frames is called animation. An animation contains visual effects (including movement) and sound effects.Animation can be applied to the text, images, shapes, tables, SmartArt and other objects. Cartoons on television are an example of animation. There are different types of animation effects: 1. Entrance Animation Effect: It determines the manner in which an object enters onto the slide. 2. Emphasis Animation Effect: It does something to draw attention to an object. For example, the object can become larger. 3. Exit Animation Effect: It determines the manner in which an object leaves a slide. 206

4. Motion Paths Animation: It determines how an object moves around a slide. Applying Animation The steps to apply animation to an object are: 1. Select the object that you want to animate. 2. On Animations tab, click on More drop-down arrow in the Animation group. Or, click on Add Animation button in Advanced Animation group. 3. A drop-down menu appears. Select the desired effect. 4. The effect is applied to the object. The object will have a small number next to it (to show that it has an animation). At the bottom of the menu, you can access even more effects. Some effects will have options you can change. For example, with the Wheel effect you set the number of spokes. These options can be accessed from the Effect Options button in the Animation group. 207

Adding Multiple Animations to an Object Selecting a new animation from the menu in the Animation group replaces the object's current animation. However, you can add more than one animation to an object. The steps to add more animation to an object are: 1. Select the object. 2. On Animations tab, in Advanced Animation group, click on the Add Animation button and select the desired animation effect. Removing an Animation Steps to remove an animation are, 1. Select the small number located next to the animated object. 2. Press the Delete key. The animation will be deleted. Setting Up Animation You can modify the animation in terms of starting method, duration and delay. On Animations tab, in Timing group, set the different options of Start, Duration and Delay. Start : It specifies the option/method to play the animation. There are three options: • Start on Click: This will start the effect when the mouse is clicked. Duration : • Start With Previous: This will start the effect at the same time as the previous Delay : effect. • Start After Previous: This will start the effect when the previous effect ends. It specifies the timing of the animation effects. It sets the delay time before the animation begins. Exercise 1. Open the presentation created earlier about your school and apply various animation effects to the objects and text on the slides. 2. Experiment with Entrance, Emphasise and Exit categories of animation effects. 3. Take a new slide and draw three circles of green, blue and red fill colours. Keep green circle on the left side of the slide, red to the right and blue at the top of the slide. Apply animation so 208

that when you run the presentation and press enter on the slide, the green circle should move and take the place of red, red circle should move and take the place of blue and blue circle should move and take the place of the green circle. These three movements should occur simultaneously. 4. Take a new slide and add text WELCOME on it in large font size & green colour. When presentation is run, WELCOME should appear with an Entrance effect on the screen, after 5 seconds it should turn orange & next 5 seconds it should fly off in left direction very slowly. Session-10 Working with Tables You know that tables are used to represent a given data in the form of rows and columns. It is very useful in organizing and representing the data in an effective way. Inserting a using Title and Content Slide Layout 1. Open MS PowerPoint and take a Blank Presentation. A new presentation of single slide with Title Slide layout appears. 2. On Home tab, in Slides group, click on Layout button. A list of slide layouts appears. Click on Title and Content layout option. Or, you can insert a new slide of Title and Content layout. 3. There is a set of 6 icons at the center of the content area. These are the links to insert objects (Table, Chart, SmartArt Graphic, Picture, Online Picture and Video) in the slide. 4. On Title and Content slide layout, click on Table icon. The Insert Table dialog box appears. 5. Enter the required number of columns and rows and click on OK button. 209

Inserting Table on Any Slide 1. Click on Insert tab. 2. In Tables group, click on Table button 3. Click on Insert Table option from the list. 4. Enter the required number of columns and rows and click on OK button. When the table is selected, two tabs appear on the Ribbon: Design and Layout. You can use them to change the number of rows and columns, design and other properties of table. Design tab contains the set of table designing tools. Layout tab contains the set of table layouts and editing tools. Layout tab contains the set of table layouts and editing tools. Selecting Cells, Rows and Columns Click on the starting cell and drag the mouse to select other cells. To select entire row, bring the mouse pointer to the extreme left of the table against that row, the mouse pointer turns into a thick black pointer that points at the row to be selected. Click and entire row will be selected. To select a column, bring the mouse pointer to the top the desired column. The mouse pointer turns into a thick black pointer that points down at the column to be selected. Click and entire column will be selected. Adjusting Row Height and Column Width One way is to simply bring the mouse pointer over row divider or column divider. The mouse pointer turns into a double-headed arrow. Click to grab the divider and move mouse to adjust the divider. Other way is to used Height and Width options in Cell size group under Layout tab. Setting Table Border and Background In Design tab, you can Table Styles, Shading and Borders options to set the background colour and borders for a table. Design tab appears when you select the table. 210

Exercise 1. Insert a table of 6 rows and 3 columns in the slide. Merge the first row in one cell and enter the following text in it: Top 5 Tennis Players, and in the second row, give column headings: Player Name, Country, Ranking. 2. Make a list of top five tennis players in the world. 3. Select the table and apply different design to heading and column headings. 4. Data rows should be of two designed applied alternatively to them. 5. Save the file. Session-11 Working with Images The steps to insert a picture in the slide are: 1. On Title and Content slide layout, click on Pictures icon. Or, on Insert tab, in Images group, click on Pictures button. The Insert Picture dialog box appears. 2. Locate and select the picture and click on Insert button. Picture is inserted in the slide. 3. Click on the ‘Click to add title’ placeholder and type the relevant text, e.g. ‘Koala’. Center align the text, make it bold and set text colour ‘Blue’. 1 3 2 211

When an image is selected, Format ribbon is activated. It contains various options to work with the selected image. Some common operations are: 1. Adjusting Image Brightness and Colour Settings: After selecting an image, brightness and colour adjustments can be done by using Corrections and Color options in Adjust group. 2. Applying Picture Styles: Various styles of images are there in Picture Styles library. Click open its drop-down and select the desired style. 3. Applying Picture Border, Effects and Layout: In Picture Styles group, click on the Picture Border drop-down to select various options for image border colour and outline. A variety of image effects can be picked up from Picture Effects drop-down in Picture Styles group such as Shadow, Reflection, Glow, Soft Edges, Bevel. 3-D Rotation along with certain preset effects. 212

Various image layouts can be applied using Picture Layout drop- down in Picture Styles group. 4. Arranging, Rotating, Grouping/ Ungrouping Images: Images can be arranged above or below one another by using Bring Forward and Send Backward option in Arrange group. In the same group, options to group and later ungroup the images are there. To group the images, all required images need to be selected using mouse while pressing Ctrl or Shift keys. Images can be rotated or flipped using Rotate drop-down. 5. Cropping and Resizing Images: Unwanted surrounding part of the image can be removed using Crop option in Size group. In the same group, size of the images can also be set. Note: Format Picture pane can be used to have better control over the formatting and arrangement of images. This pane can be displayed by right clicking on the desired image and selecting Format Picture option. 213

Exporting Presentation as PDF Using File tab > Export option, click on Export PDF/XPS button and click on Save button on the Publish as PDF or XPS dialog box after specifying the location and the name of the file. Exercise A. Open the presentation created in previous session and insert two images. Place one image in the top-right corner of the slide and the other in the top-left corner. Using Format tab, apply following formatting on the image: 1. Apply a Picture Style to the left image and an Artistic Effect to the right image. 2. Try out some Picture Effects on the left image. 3. Try rotating and flipping the right image. B. Create a presentation on Teacher's day. 1. Each slide should be related to a teacher with his/ her picture. 2. Use a Title Slide as first slide (which gives information about the presentation). Session-12 Add Shapes in a Presentation You can insert various shapes on the slides with the help of the Shapes tool. These are ready-made shapes in different categories e.g. Lines, Rectangles, Basic Shapes, Block Arrows, Equation Shapes, Flowchart, Stars and Banners and Call outs. The steps to insert the shapes are: 1. On the Insert tab, in the Illustrations group, click on the Shapes button. A drop-down list of different types of shapes in different groups appears. 2. Double-click on the shape which you want to insert into the document. The shape is inserted in the document. Now, you can resize, move or format the shape. 3. Resize the shape using the resizing handles. 214

Applying Various Styles on Shape As you select the shape, Formatting tab appears. The Shape Styles group of the ribbon provides a variety of preformatted styles, shape fill options, shape outline options and shape effects. Preformatted Shape Styles Select the shape. Open the drop-down list of the shape styles and select the desired style for your shape. Shape Fill This option provides a wide variety of fill options for your shape like solid colours, pictures, gradient, textures etc. If you click on Picture… option, Insert Picture dialog box will popup. Locate and select the desired picture. The shape will be filled with the selected picture. If you click on Gradient option, a set of preformatted gradients will be displayed. You can select More Gradient… option to apply various grid settings from the Format Shape pane. Using this pane, you can set the Type, Direction, Angle, Color, Position, Transparency and Gradient Stops. 215

If you select Texture option, various preset textures are displayed. You can select More Textures… option to apply various texture settings in Format pane. Shape Outline It provides various options and settings for the outline of the selected shape like weight (width), Dash (outline style) and Arrows (outline head style). Shape Effects This option displays a comprehensive library of various eye-catching special effects like Shadow, Reflection, Glow etc., which can be applied on the selected shape. Grouping/Ungrouping Shapes To group the shapes, first select the desired shapes and select Group option in Group drop-down in Arrange group under Format tab. To ungroup, Ungroup option is located there also. Shortcut Group: Ctrl + G Ungroup: Ctrl + Shift + G 216

You can also right click on the shapes and select these option. Exercise Insert 3 Text Boxes. Arrange them in a row on the slide. In the left box, type INPUT, in the middle one, type PROCESS and in the right one, type OUTPUT. Draw two arrows and place them as shown here: Now, do the following: 1. On Input box, apply a preformatted style. 2. On Output box, apply some gradient fill settings. 3. On Process box, apply some texture settings. 4. On Arrows, apply 6 point thick outline with dark colour and give them some reflection and glow. Session-13 Master Views Slide Master Slide Master view enables you to modify the slide layout and appearance of the slides in the presentation. Editing the slide master, affects every slide, including the newly added slides, in the presentation. The steps to use Slide Master are: 1. Click on View tab. 2. In Master Views group, click on Slide Master button. The Slide Master tab appears on the Ribbon and the presentation switches to Slide Master view. In Slide pane, the current slide master and layout is selected and displayed for for editing in the slide area (main window). 217

Exercise 1. Write the steps to use slide master view. 2. What is the use of Slide Master view? Session-14 Slide Transitions Slide transitions are visual effects that occur in Slide Show view, when you move from one slide to the next during an on-screen presentation. You can control the speed of each slide transition effect and you can also add sound. Slide transitions enhance the presentation visually to keep the interest and curiosity of the audience. Judicious use of transitions provides a professional touch to the presentation. Transition Categories There are three categories of transitions: 1. Subtle: These are the most basic types of transitions. They use simple animations to move between slides. 2. Exciting: These are complex animations to transition between slides. Adding moderate transitions can give a nice touch to the transition between important slides. 3. Dynamic Content: If you're transitioning between two slides that use similar slide layouts, dynamic transitions will move only the placeholders, not the slides themselves. When used correctly, dynamic transitions can help unify your slides and add a further level of polish to the presentation. Applying Transition The steps to apply transition to a slide(s) are: 1. Select the slide (that will appear after the transition) in the Slide Navigation pane. 218

2. On Transitions tab, in Transition to This Slide group, click on More drop-down arrow. A drop-down menu appears. 3. Select the desired transition to apply it to the selected slide. • Click on Apply To All button in Timing group (on Transitions tab) to apply the same transition to all the slides in the presentation. 4. Click on Preview button to preview the slide transition. Modifying Transitions You can customize the direction of the transition. 1. Select the slide (with the transition, that you want to modify). 2. On Transitions tab, in Transition to This Slide group, click on Effect Options and choose the desired option. Setting the Timing for a Transition The steps to set the duration of the transition between the previous slide and the current slide are: 219

1. On Transitions tab, in Timing group, in Duration box, type or select the speed that you want. 2. To specify how long before the current slide advances to the next, use one of the following procedures: • To advance the slide when you click the mouse, select the On Mouse Click check box. • To advance the slide after a specified time, in the After box, set the time that you want. Adding Sound to the Transition The steps to add a sound to a slide transition are: 1. Select the desired slide (that will appear after the transition) in the Slide Navigation pane. 2. On Transitions tab, in Timing group, click on Sound drop-down list box and choose a sound to apply it to the selected slide. Removing a Transition The steps to remove a transition are: 1. Select the slide with the transition that you want to remove. 2. Choose None from the Transition to This Slide group on the Transitions tab. The transition will be removed. Exercise 1. Open the presentation created earlier about your school and apply various transitions effects on the slides. For some slides setup some duration after wjich slides should change automatically. Also apply a duration of transitions same for all the slides. 2. Experiment with Subtle, Exciting and Dynamic categories of transition effects. 3. In the transition of the first slide, add a welcome music sound to play when transition occurs. 220

Assessment 1. What is a presentation? 2. What is the use of slide show tool in PowerPoint? 3. How can we change the background of a slide in a presentation? 4. Name the different slide views available in MS PowerPoint. 5. How can we add text to our presentation? 6. Write a few words about Reading view. 7. Describe briefly about various options available in following panes/ dialog boxes: a. Format Shape b. Format Picture c. Format Background 8. What are the uses of various Slide Layouts. Common Keyboard Shortcuts Keyboard Function Shortcut Insert a new slide Ctrl + M Duplicate the current side Ctrl + D Increase font size Ctrl + Shift + > Decrease font size Ctrl + Shift + < Change case Shift + F3 Apply superscript formatting Ctrl + = Apply subscript formatting Ctrl + Shift + Plus sign Remove manual character formatting Ctrl + Spacebar Center a paragraph Ctrl + E Justify a paragraph Ctrl + J Left align a paragraph Ctrl + L Right align a paragraph Ctrl + R Run a presentation F5 Activate the pen tool during a show Ctrl + P Help F1 View the slide show from the current slide forward Shift + F5 Spellcheck F7 Opens Save As dialog box F12 Stop the show. Press S again to restart the show S End the slide show Esc Select to the end of a word Ctrl + Shift + Right arrow Select to the beginning of a word Ctrl + Shift + Left arrow 221

Ctrl + A (on Slides tab) Select all objects Ctrl + A (in Slide Sorter view) Select all slides Ctrl + A (on the Outline tab) Select all text Ctrl + Backspace Delete one word to the left Ctrl + Delete Delete one word to the right Ctrl + X Cut selected object or text Ctrl + C Copy selected object or text Ctrl + V Paste cut or copied object or text Ctrl + Z Undo Ctrl + Y Redo Ctrl + F Open Find dialog box TEST YOUR KNOWLEDGE 1. Electronic presentations can be: a. Given to live audience b. Given in webinars c. Run on handheld devices d. All of these 2. To paste the copied text as hyperlink ________________ option is used. a. Paste special b. Paste as Hyperlink c. Paste for web d. Paste as URL 3. To apply a formatting to multiple parts of text one-by-one, _________ on Format Painter first. a. Click b. Right click c. Double click d. Any of these 4. A Blank slide layout does not provide _____________ by default. a. Background b. Placeholder c. Slides pane d. Slide area 5. Section header slide layout can also be used in place of ________________ layout. a. Title slide b. Blank slide c. Comparison d. Two Content 6. To play the slide show from the first slide, press _____________. a. F5 b. Shift + F5 c. Escape key d. Shift + Escape 7. Which tab help in running the slide show? a. Slide Show b. Review c. View d. Any of these 8. Picture styles can be applied using ________ tab. a. Design b. Format c. Style d. Review 222

9. Pictures option under Insert tab in MS PowerPoint, inserts pictures _____________? a. On local storage b. online c. Both a) and b) d. clicked by camera 10. Select the odd one out: a. Lines b. Chart c. Flowchart d. Rectangles 11. Shape Styles group is found under ______________ tab. a. Styles b. Formatting c. Format d. Design 12. Select the odd one out: a. Texture b. Gradient c. Picture d. Weight 13. Transition effect applies to which of the following? a. An object b. Entire slide c. Text d. Presentation 14. If you are on 10th slide and press F5 key then, presentation will run from which slide? a. Current slide b. First slide c. Title slide d. None of these 15. Transparency cannot be set in which of the following slide background fill options? a. Pattern fill b. Solid fill c. Picture fill d. Texture fill 16. Which of the following views in MS PowerPoint is most suited to rearrange slide sequences. a. Normal view b. Slide show view c. Slide sorter view d. Any of these Watch www.eduitspl.com le&arn www.youtube.com/edusoftknowledgeverse 223

Projects Word Processing OPERATING SYSTEMS Do some research and create a four page write up on Operating Systems including tabular comparison of features of various operating systems, borders around pages and certain important paragraphs in your content, give any light pastel shading to important points. Show important points in different colours and style. Overall, make the document well formatted, aligned and pleasant in reading. ASSESSMENT « Writing skills. « Documentation and formatting skills. « Information search and analysis skills. Digital Presentation IMPACT OF INTERNET & WWW ON EDUCATION Do some research and create a 5 slides presentation on impact of Internet and World Wide Web on education including some images and shapes. Apply a design theme on the presentation also. ASSESSMENT « Presentation design skills. « Presentation planning skills. 224

Spreadsheet LAPTOP SALES WORKSHEET Assume that you own a laptop showroom that sells laptops of various 5 companies. Laptops have following distinct qualities: ¤ Different models. ¤ Different product features like OS, memory, screen size etc. ¤ Different price. Create a well formatted spreadsheet showing the sales of any 3 months of various laptops. Show the following calculations in your spreadsheet: 1. Company-wise total sales value in 3 months. 2. Model-wise total sales value in 3 months. 3. Company-wise total sales in each month. Use the following format: Company Laptop Unit Jan Jan Feb Feb Mar Mar Total Model Price Qty Sale Qty Sale Qty Sale Sale Sold Value Sold Value Sold Value ASSESSMENT « Data layout and presentation in spreadsheet. « Electronic spreadsheets basic skills. 225

Sample Question Paper - 1 Information Technology (402) Class IX General Instructions I. Question paper is divided into four sections : Part A (Employability Skills) – Multiple choice questions. Part B (Subject Specific Skills) Section A – Very Short Answer (2 mark each). Section B – Short Answer (3 mark each). Section C – Long Answer (5 mark each) II. The maximum time allowed is 2 hours. III. Maximum marks are 50. Part A (Employability Skills) 10 X 1 = 10 1. Receiver ___________ the message during a communication. a. encodes b. decodes c. encrypts d. decrypts. 2. The prime characteristics of a well encoded message are: a. Clear and complete b. Complete and correct c. Clear and correct d. All of these 3. Which of the following guarantees self-confidence? a. Good looks b. Positive attitude c. A lot of money d. Fair complexion 4. Which of the following are the main ingredients of self-management? a. Resources b. Time management c. Both a) and b) d. None of these 5. Internet is also called ________________________. a. Network of networks b. Intranet c. Internet of networks d. All of these 6. We can ______________ information. a. Access and create b. Share c. Store d. All of these 7. Find the odd one out: a. CD-RW b. Hard disk c. Pen drive d. External hard disk 226

8. In entrepreneurship development what is kept in consideration? a. Concrete objectives b. Local market c. Right location d. All of these 9. A fresher joining a company is called its ___________________. a. Share holder b. Entrepreneur c. Liability d. Human resource 10. Size of particulate matter in air is measured in _____________. a. Macrometers b. Micrometers c. Millimeters d. PM Part B (Subject Specific Skills) Section A 5 X 2 = 10 1. Describe the terms MNC, ISP and GIC with reference to IT-BPM industry.. 2. Briefly describe the role of ICT in classroom.. 3. Name the different ways in which an MS Word document can be viewed. 4. List any 2 advantages of MS Excel. 5. What is the basic difference between Title Slide layout and Title and Content layout? OR How will you insert a picture stored on a CD inserted in E: Drive in your slide? Section B 5 X 3 = 15 1. Describe the basic features of RapidTyping interface. 2. How will you add a new lesson using lesson editor in RapidTyping? 3. Describe the use of any 2 options (commands) of ribbons Home, Insert and Page Layout in MS Word. 4. Write the steps to insert a row and column in a spreadsheet. 5. What is the use of fill handle? Explain with a small example. Section C 3 X 5 = 15 1. Explain the process of mail-merge in MS Word. 2. With an example, explain how will you calculate your percentage marks out of 10 students in IT subject. 3. How will you perform the following tasks in PowerPoint: a) Insert a text box on a blank slide and write the text WELCOME in it. b) Convert all the text in a text box into Uppercase. c) Insert an Arrow shape and apply fill colour and outline colour in it. d) Apply a theme on the slides. e) Bring slide 2, Slide 3 and Slide 4 between Slide 17 and Slide 18. 227

Sample Question Paper - 2 Information Technology (402) Class IX General Instructions I. Question paper is divided into four sections : Part A (Employability Skills) – Multiple choice questions. Part B (Subject Specific Skills) Section A – Very Short Answer (2 mark each). Section B – Short Answer (3 mark each). Section C – Long Answer (5 mark each) II. The maximum time allowed is 2 hours. III. Maximum marks are 50. Part A (Employability Skills) 10 X 1 = 10 1. The possible reason for low self-confidence is _____________________. a. over-confidence b. over-preparedness c. fear of failure d. expensive clothes 2. Which of the following does not constitute noon-verbal communication? a. Expressions b. Silence c. Duration of communication d. Gestures 3. Which of the following is most costly mode of communication? a. Verbal b. Written c. Audio-visual d. Oral 4. A ___________________ is a good tool to allocate time to tasks. a. Good plan b. SMART target c. Timetable d. Task list 5. Planning involves which of the following order? a. Goals > Targets > Plan for targets b. Targets > Goals > plan for goals c. Goals > plan for goals > Target d. Targets > plan for targets > Goals 6. Blogs are in the form of simple _________________. a. Web sites b. Report c. File d. Email message 7. If computer needs any additional input, it shows a/an _______________. a. Dialog box b. Menu c. Window d. Error 228

8. A fresher joining a company is called its ___________________. a. Share holder b. Entrepreneur c. Liability d. Human resource 9. Which type of business buys products at wholesale price and sells them in retail? a. Service b. Manufacturing c. Merchandise d. Hybrid 10. ________________ saves us from harmful UV rays. a. Lithosphere b. Atmosphere c. Hydrosphere d. Biosphere Part B (Subject Specific Skills) 5 X 2 = 10 Section A 1. Very briefly explain BPO services. 2. What do you mean by a learning management system? 3. What do you mean by word processing? List 4 advantages of a word processor. 4. Describe the structure of a spreadsheet with a small example. 5. List any 4 slide layouts in PowerPoint. OR How will you apply same slide background on all the slides in a presentation? Section B 5 X 3 = 15 1. List the main components of RapidTyping window. 2. Describe briefly what details are shown by Result window of RapidTyping software. 3. Describe any two ways to insert a table in MS Word. 4. How will you adjust width of all the columns in a spreadsheet automatically? 5. Write the steps to add a new command in Quick Access Toolbar in Excel. Section C 3 X 5 = 15 1. Briefly describe the use of any 3 views of MS Word document. 2. With distinct examples, explain the usage of +, -, / and * operators in Excel. 3. How friend is making a presentation on Water Pollution. Help her in the following tasks in PowerPoint: a) Adding a “Two Content” slide between slide 2 and slide 3. b) Insert an image from internet into a slide. c) Insert a circle shape on a slide and fill a gradient in the shape. d) Apply a theme named Integral on all the slides of the presentation. e) Bring slide 13, after slide 5. 229

IT General Knowledge - Important Terminology Bit: A bit is the smallest unit of information that a computer handles. A single bit can hold only one of two values, 0 or 1. Byte: A byte is a combination of eight bits arranged in sequence. Central Processing Unit (CPU): The central processing unit (CPU) is the primary hardware device that interprets and runs the commands you give to the computer. Commands: A command is an instruction, which you give to a computer that causes an action to be carried out. Commands are either typed by using a keyboard or are chosen from a menu. Communication Channel: A communication channel is a path or a link that connects computers or peripheral devices, such as printers and disk drives, to transfer information. Data: Data is the plural for the Latin word datum, meaning an item of information. Database Programs: Database programs are used to store and manage data in an organized way. You can also use these programs to sort or search for information stored in a database. Desktop: The desktop is an on-screen work area that uses a combination of menus and icons. Desktop Computers: Desktop computers are made up of individual components such as a monitor, a keyboard, a system unit, and a printer. Digital camera: A camera that stores images digitally on a memory device, such as a flash memory card or a mini hard disk. Digital versatile disc (DVD): A storage device used to store data in a digital format. Folder: A folder is a container for programs and files in GUI interfaces. Gigabyte: One gigabyte (GB) is equal to 1,024 MB, which is approximately equal to one billion bytes. Graphical User Interface (GUI): A graphical user interface (GUI) displays images and pictures that allow a computer user to interact with a computer easily. Hardware: Hardware refers to all the physical components of a computer. Icon: An icon is a small image displayed on the screen to represent an object. Input Devices: An input device is used to provide information to a computer. A keyboard is an example of an input device. Intranet: A special type of network used to communicate and share information within an organization. Kilobyte: One kilobyte (KB) is equal to 1,024 bytes. Local Area Network (LAN): A LAN connects devices within a limited area, such as a home or a small group of offices. Megabyte: One megabyte (MB) is equal to 1,024 KB. Menu: A menu is a list of options from which a user can select an option to perform a desired action, such as choosing a command or applying a particular format to part of a document. Many programs, especially those that offer a graphical interface, use menus as a means to provide the user with an easy-to-use alternative to memorizing program commands and their appropriate usage. Network: A network is a group of computers that are connected to share resources and exchange information. Online: When a computer is connected to the Internet, it is said to be online. Operating System: The operating system controls the computer's hardware and provides services and access to the hardware to programs. It also manages the computer's operations and tasks, such as logging on, logging off, and shutting down. 230

Presentation Programs: Presentation programs are used to present information in the form of slides. Processing Devices: Processing devices are used by computer users to process the input data and generate the desired output. Programs: A program is a sequence of instructions that can be executed by a computer. A program is also known as software. Publishing Programs: Publishing programs are used to combine text and graphics to create documents such as brochures, greeting cards, annual reports, books, or magazines. Server: The server is the main computer on a network that provides services to other computers on the network. A server decides which computers are allowed to access the hardware and software on the network. Software: Software is a sequence of instructions that a computer can execute. It is also referred to as programs. Spreadsheet Programs: Spreadsheet programs are used to create budgets, manage accounts, perform mathematical calculations, and convert numerical data into charts and graphs. Storage Devices: Storage devices are used to store data. A hard disk is an example of a storage device. System Unit: A system unit refers to the box that holds the processor, motherboard, disk drives, power supply, and the expansion bus. Taskbar: The taskbar is a rectangular bar that is usually located at the bottom of the screen. You can use the taskbar to select a program running on your computer. Terabyte: One terabyte is equal to 1,024 GB, approximately equal to trillion bytes. Wallpaper: Wallpaper is a pattern or picture on the screen background that you can choose. Wide Area Network (WAN): A network that connects devices in geographically separated areas. Window : A rectangular area on the monitor that displays a program. Each program has its own window. Word-processing Programs: Word-processing programs are used to create and modify text-based documents. Workstation: A workstation refers to a computer connected to a network. You use a workstation to access the hardware and software on a network. INTERNET RELATED TERMS Access point: An access point is a wireless connection device. It is used to connect a wireless computing device to a wired network. Chat Program: Chat programs allow you to send and receive messages instantly. You can use a chat program to communicate with several people at the same time. Computer Privacy: Keeping a user's data, including personal files and e-mail messages, such that the data is not accessible by anyone without appropriate permission. Computer Security: The protection of a computer system and its data from accidental or intentional loss and tampering. Cookie: A small file on a computer that is created when a user visits a Web site. A Web site uses cookies to identify users who visit the site, and also track the preferences of the users. E-commerce: E-commerce refers to the business transactions made over the Internet, such as buying and selling items online. Electronic mail (e-mail): The exchange of text messages and computer files over the Internet. An electronic mail (e-mail) is the electronic form of the traditional postal mail. E-mail allows you to exchange messages and files over a network. 231

Firewall: A filter that blocks unreliable information from the Internet before it reaches your computer or a private network. It provides additional protection against threats such as hackers and viruses. A firewall also helps to ensure computer privacy by restricting external access by any unauthorized user. Hacker: A person who uses computer expertise to gain unauthorized access to a computer, and then misuses or tampers the programs and data stored on the computer. Hyperlinks: An element in an electronic document that links to another place in the same document or to a different document. Generally, you click on the hyperlink to follow the link. Hyperlinks are the most necessary element in all hypertext systems, including the World Wide Web. Internet: The Internet is a worldwide collection of public networks that are linked to each other for information exchange. Internet Service Provider (ISP): An ISP is a company that provides Internet connectivity to individuals, businesses, and organizations. IP address: An Internet Protocol (IP) address is a numeric address that specifies the exact location of a computer on the Web. Modem: A modem is a connection device that allows you to connect your computer to the Internet. It converts digital information into analog information and transmits it over a phone line. Network: A network is a group of computers that are connected to share resources and exchange information. Online: When a computer is connected to the Internet, it is said to be online. Online communities: Online communities are formed by groups of computer users who have common interests and purpose to communicate with each other over the Internet. Portal: A portal is a Web site that offers information related to a specific topic in the form of a directory. A portal acts as a starting point to a number of resources on the Web. Protocol: A protocol is a standard method of transferring data between different computers. Search engine: A search engine is a program that allows you to search and retrieve information over the Internet. The Web: The Web, also known as the World Wide Web (WWW), is a collection of information that is accessible on the Internet. This information is arranged logically and stored on computers known as Web servers. Web address: A Web address specifies the protocol to be used for transferring data between different computers and the exact location of the Web site. A Web address is also known as the Uniform Resource Locator (URL). Web browser: A Web browser is a program that enables you to view and interact with various resources on the Web. Web page: A Web page is a formatted text document on the Web. Web site: A Web site is a collection of one or more Web pages that are linked together and made available through a Web server. 232