IT Spark Class- 5 Flipbook

5 For Age Group 9 to 11 years COMPUTER BOOK Computer Education Series Concept by: Composed by: Contributed by: Gagan Agarwal David S. Gareema Balwani Hitesh Saini Founder M.D. CLDP, MCA,15 yrs exp. with NIIT Jameel Khan

Contents 1. Evolution of Computers 4 6. MS Excel 2013: Introduction 66  History of the Computers  Entering Data & Data Types  Generations of Computers  Workbook & Worksheet  Classification According to Size 7. MS Excel: 2. MS PowerPoint: Views 15 Working with Worksheet 78  Master Views  Presentation Views  Working with Data  Autofill & Custom Lists 3. MS PowerPoint:  Working wit Rows & Columns Graphics and Multimedia 21 8. Internet Searching and Surfing 93  Slide Layout 36  Services provided by Internet  Tables and Graphics  Know Your Browser  Searching on Internet  Supplement: Google Slides 4. MS Word: Layout and Views 38 9. Interactive Programming  Page Margin and Size with Scratch  Hyperlinks, Header & Footer 104  Document Views  Scratch Libraries  Event, Sound, Costume 5. MS Word: Project 112 Working with Tables 54 MS Word: Digital India Poster  Working with Table  Table Designs MS Word: School Calendar MS PowerPoint: Right to Education

SAFE COMPAUNTDINHGAPPINESS INTERNET USAGE DONT’S 1. Don't give anyone your password & other details as well as any information about your family. 2. Don't talk to strangers on the Internet. 3. Don't agree to meet any of your online friends in person. 4. Don't fill in any form online that asks for details like address or phone number. 5. Don't visit any online chat room without elder’s or parent's permission. 6. Don't watch online any stuff that you think your parents won't like. 7. Don't post family and personal pictures without your parents' knowledge. 8. Don't download/install anything on your PC without your parents' permission. 9. If you have any doubts, ask your parents, teachers or elders. 10. If anyone cyberbullies, get in touch with your teachers and parents. CYBERBULLYING Cyberbullying is bullying that takes place over digital devices like cell phones, computers, and tablets. Cyberbullying includes sending, posting, or sharing negative, harmful, false, or mean content about someone else. How to keep safe?  Don't respond to any emails or messages sent by anyone who cyberbullies you.  Don't cyberbully others online. Respect everyone’s privacy and rights.  Save the messages and screen-shots of the messages as an evidence of cyberbullying.  If you are being bullied, inform your elders immediately.

1 Evolution of Computers Dear Teacher, Dear Students, We wonder how In this chapter we shall computers actually came learn about the into being. How these evolution of computers amazing machines were and their classification invented? Who created across generations. them? There had been many contributors to the development of computers. Of course, this development did not happen at once, there were various stages across several years till today where we have computers so small that they fit in our palms. But earlier, computers were not that compact and smart. Let us briefly discuss the different stages in the development of computers. Evolution of Computer The term ‘Computer’ came from the word ‘compute’, which means ‘to count’ or ‘to calculate’. Early men used their fingers, stones and bones to count. Abacus (5000 years ago) Abacus was the first calculating device invented by Chinese Abacus the Chinese around 5000 years ago. The working of this device was based on the movement of its beads up and down along wooden or Amazing Fact metal rods. Napier’s Bones (1550 -1617) The three most popular abacuses Napier’s Bones was invented by John Napier (1550- were- Chinese abacus, Japanese 1617), a Scottish mathematician and scientist. abacus and Russian abacus. Napier’s bones were multiplication tables written on strips of wood or bones. This invention helped in multiplying, dividing, taking square roots and cube roots. There are 9 different ‘bones’ or strips with numbers marked on them. Napier’s Bones John Napier 4

Pascaline (1642) The Pascaline, invented by Blaise Pascal (France) in 1642, was a mechanical calculator. This device was invented for the purpose of addition and subtraction, via turning discs at the bottom of the device. Blaise Pascal After crunching the handle the answers Pascaline appeared on a window. Charles Babbage Analytical Engine (1833) Analytical Engine The Analytical Engine, an important step in the history of computer, was the fully- automatic calculating machine, designed by Charles Babbage in 1833. He is known as “the father of modern computer”. This machine was designed to perform complex mathematical calculations. Tabulating Machine (1890) Tabulating Machine Herman Hollerith In 1890, Herman Hollerith invented the tabulating machine to process the data (for U.S. Census). This device could automatically read information which had been punched on the card. In later years, Hollerith’s machine became very useful for wide varieties of statistical applications. In February 1924, Hollerith’s company changed its name to International Business Machines, or IBM. Generations of Computers Now-a-days, computers are being used at different places. The volume of work, features, functionality, etc. varies from place to place. So, it was required to develop different types of computers. Generation refers to the time period when a computer is being developed. After each and every generation, the technology of computer advanced significantly to fulfill human needs. Let us look at distinct generations of computers. 5

First Generation of Computers (1940 - 1956, Vacuum Tubes) Technology used: Vacuum tubes for the circuits and magnetic drums for memory. Size: As big as a room. Programming Language: Machine language. Input: Punched cards, paper tape and switches. No keyboard. Output: Printouts. Features: Expensive, immense Vacuum Tube & First Generation Computer electricity consumption, generation of huge amount of heat Examples: The UNIVAC (UNIVersal Automatic Computer) and ENIAC (Electronic Numerical Integrator And Calculator) are the examples of first generation computers. Howard Aiken’s Mark 1 (1944), Maunchly and Eckert’s ENIAC (1946). Second Generation of Computers (1956 - 1963, Transistors) Technology used: Transistors. Magnetic cores were used as primary memory, magnetic tapes and disks as secondary storage devices. Size: As big as a small room. Programming Language: Assembly language for processing. High level languages for programming such as COBOL and FORTRAN. Input/Output: Keyboard. Display on monitor. Features: Smaller, faster, cheaper, more Transistor and Second Generation Computers energy- efficient and reliable than the first generation computers. Examples: IBM 1401, PDP-1. Third Generation of Computers (1964 - 1971, Integrated Circuits) Technology used: Transistors shrunk into silicon chips called Integrated Circuit (IC). Size: Smaller. Could be kept on a desktop. Programming Language: High level languages for programming such as C and PASCAL. Single user, single tasking operating system such as DOS. 6

Input/Output: Keyboard. Display on monitor. Features: Smaller, faster, cheaper than its predecessors. Examples: PDP-8, PDP-11, ICL 2900, IBM 360 and IC and Third Generation Computers IBM 370. Fourth Generation of Computers (1971 - present, VLSI Microprocessor) Technology used: Thousands of Integrated Circuits built into a single microprocessor. Data storage as primary memory and storage devices as secondary memory (disks). Computers can be connected to form networks. Wireless technology and Internet. Size: Smaller. Could be kept on a desktop, laptops, notebooks, handheld devices. Programming Language: High level languages C++, Java, Python etc. Powerful multi-user, multi-tasking operating systems such as Windows, MacOS etc with Graphical User Interface (GUI). Input/Output: Keyboard, mouse, scanners, microphone. Output on monitor, printer, plotters, speakers etc. Features: Smaller, faster, cheaper, huge data storage. Examples: IBM- PC, Apple- Macintosh, Compaq PC. Fifth Generation of Computers (Present and Beyond, Artificial Intelligence) Research in the field of developing computers which could learn and respond like humans are going on. This field is called Artificial Intelligence (AI) involving Machine Learning. Some AI applications are voice or face recognition, thumb impression recognition, robotics, natural language processing like humans do, capability of self-learning and recalling computers. The major technology changes in the generations of computer. 1st Generation 2nd Generation 3rd Generation 4th Generation 5th Generation Vacuum Tube Transistor Integrated Cicuit Microprocessor Artificial Intelligence 7

Characteristics of Computers Today, computers can perform most of the tasks quickly and accurately saving a lot of time and efforts. Computers work for longer hours without getting tired and store a lot of data. Let us see the characteristics of computers that make them the most revolutionary machine of this age. 1. Computers are fast! (Speed) Computers think in milliseconds. That means, processor of a computer can perform billions of calculations in a second. Amazing Fact IBM’s Deep Blue supercomputer could think 200 million positions of chess pieces in one second. 2. Computers don’t goof-up! (Accuracy) Computers are accurate in calculation however, their accuracy depends on the accuracy of input. This means, computers will only give incorrect output if input is incorrect. This is called Garbage In Garbage Out (GIGO). 3. Computers are efficient! (Versatile) Computers are capable to perform a variety of tasks and at the same time. This is called their versatility. For example, you can play a game on computer while it is playing music, printing a multi-page document and downloading a file. 4. Computers are tireless! (Diligent) Computers work for longer hours without getting tired. They do not get bored doing the same task again and again. Ability to perform repetitive task for longer duration is called diligence. For example, computers working as web servers over the internet work constantly for days. 5. Computers store a lot of data! (High storage capacity) Computers store bulk data. A common micro-computer can hold data in Tera Bytes. Even a simple handheld computer has storage capacity in Giga Bytes. 6. Computers are automatic! There are several tasks which computers can perform automatically as a routine. For example, computers in a packaging unit control entire process without human intervention. Another example is taking a multiple pages printout. Once command is given, computer can print pages without assistance. 7. Computers are programmable ! For the tasks that need to be done regularly, the set of instructions is fed into the computer 8

once and then computers execute these instructions in sequence. This set of instructions is called program. To run several instructions again and again , we just need to run the program. For example, calculating the grade for all students, a computer program is used, to control the traffic, a traffic control program runs on the computers that control the traffic. Limitations of Computers While computers offer remarkable benefits, they have certain limitations also. Let us have a look at them. 1. Computers do not have self-intelligence Computers perform exactly as the instructions are fed to them. They cannot figure out situation on their own. They are unable to take their own decisions. 2. Computers cannot learn Computers are not able to retain the knowledge and use it further just like we humans do. Computers just store the data. 3. Computers cannot express emotions Computers do not react to the situations. The warnings and errors they display are the part of the programs they run. They do not have emotions and feelings. 4. Computers need human care Computers need to be maintained by human beings. They will get spoilt or malfunction if humans do not take good care of them. 5. Computers cannot replace human processes entirely Computers are automatic but up to some extent only. As on date, computers are mere tools to accomplish tasks accurately, faster and efficiently but they are not reliable completely. Still, many computer systems need monitoring and control by humans to work. Classification According to Size According to size, computers can be classified in the following categories: 1. Super computer 2. Mainframe computer 3. Mini computer 4. Micro computer Super Computers As the name super computer suggests, these are the most powerful computers in the world. They are used for special purposes. They handle most complex scientific, statistical applications or programs. Key features:  These computers use very high level of technology.  They have very high memory capacity. Super Computer 9

 Data processing is ultra fast.  Highly sophisticated technology is used in these computers e.g. parallel processing.  Cost varies from 1 million to 5 million dollars or more. Examples: PARAM Yuva-II, TATA’ EKA (both are India’s super computers) Drawbacks:  Operating a super computer requires highly qualified staff.  Experts are required for such computer engineering.  They are highly sensitive to temperature, humidity, dust, etc.  They are non-portable & very large in size. Amazing Fact World’s first super computer was CRAY-1, developed by Seymour Cray, US, 1976. PARAM 8000 is considered to be India’s first supercomputer. Mainframe Computers These are very powerful and large computers. They can handle many users at a time. Terminals are used to connect users to this computer and users submit their task through terminals. Terminal is a device which has keyboard and a screen. These are mostly used as servers for website on the Internet. Key features:  Smaller in size than the super computer.  Large memory capacity.  Allows networking of up to 100 terminals.  Cost in lakhs. Examples: Fujitsu-ICL VME, IBM zSeries, etc. IBM zSeries Drawbacks:  Experts and highly qualified professionals are required to operate it.  Sophisticated technology is required for manufacturing and assembling the computer. Mini Computers These computers came into existence in 1960s. At that time mainframe computers were very costly. Mini computers were available at lower prices (costing less than 25,000 USD), so users started using these computers. These are obsolete now. Mini Computer 10

Key features:  Higher processing speed than lower category computer but slower than super computer and mainframe computer.  They are expensive and larger than microcomputers.  Mostly used as servers to control the networks. Examples: PDP-11, VAX, 7500 MAGNUM, etc. PDP-11 Micro Computers These computers use a microprocessor chip called CPU. Two major types of these computers are laptop and desktop computer. Only one user can use these computers at a time that's why they are also known as personal computers (PC). They are used everywhere like schools, offices, shops, home, etc. Key features:  These are smaller than mini computers.  These are high speed computers.  Costs in thousands.  They are portable in size.  These computers use RAM as primary memory. Apple iMac 20  These computers support different type of secondary memories for permanent storage of data e.g. hard disk, DVD and flash drive.  They support almost all modern computer languages e.g., FORTRAN, Basic, COBOL, Pascal, C, C++,C#, JAVA, SQL, etc. Examples: HCL, Wipro, IBM-PC, HP, Apple iMac 20. Desktop Computer Apple iMac 20 Laptop Amazing Fact Today, computers come in different shapes and sizes e.g. smart phones, digital cameras, wristwatches, GPS systems and heart rate monitors. Some people prefer to buy a tower case and fill it with components they find locally - then, they assemble the computer by hand to save money and get the features and power they want. 11

Quick Review  Abacus, Napier’s Bones, Pascaline,Analytical Engine andTabulating machine were the primary inventions in the field of computing.  Charles Babbage is known as“the father of modern computer”.  The first generation of computers used vacuum tubes and magnetic drums.  Transistors replaced vacuum tubes in the second generation of computers.  Third generation computers used integrated circuit (IC).  The microprocessor is a single silicon chip with thousands of integrated circuits.  Computers are fast,accurate,versatile,diligent,automatic,programmable and store bulk data.  Computers cannot learn, express feelings, have no experience, need human care and cannot replace humans entirely. A. Choose the correct answer. 1. ________________was the first calculating device invented by Chinese around 5000 years ago. a) Napier's Bones b) Pascaline c) Abacus d) Tabulating machine 2. Thousands of integrated circuits were built into single silicon chip called ______________. a) Vacuum Tube b) LED c) Microprocessor d) AI 3. _______________ is known as the father of modern computer. a) Charles Babbage b) Bill Gates c) John Napier d) Pascaline 4. Which of the following is not a characteristic of a computer? a) Accuracy b) Diligence c) Self-intelligence d) Programmable 5. Which of the following is not a limitation of computers? a) Computers cannot learn b) Computers lack emotions c) Computers need human care d) Computers are fast 12

B. Fill in the blanks. Program, Assembly, Silicon chip, Versatile, Napier's Bones 1. ___________ contain the multiplication tables written on strips of wood or bones. 2. Second generation computers used _______________ language for processing. 3. ________________ is the basic component of Fourth generation of computers. 4. A set of instructions is called a ________________. 5. Computers are _____________ because they can perform a variety of tasks. C. Tick () the correct statement and cross () out the wrong one. 1. Computers can learn and take decisions. 2. Computers can work for long hours without getting tired. 3. Artificial Intelligence computers are first generation computers. 4. Transistors replaced Vacuum Tubes in Third generation of computers. 5. Computers do not need humans to take care. D. Answer the following questions. 1. What do you mean by Generations of Computers? ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2. Distinguish between the following: a) First and Second generation of computers. ___________________________________________________________________ ___________________________________________________________________ b) Third and Fourth generation of computers. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3. Briefly list any 3 limitations of computers. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ E. Describe the following characteristics of computers very briefly: 1. Diligent: ________________________________________________________ 13

2. Versatile: ________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3. Fast: ____________________________________________________________ ___________________________________________________________________ F. Briefly list 2 key features of each type of computer classified on the basis of size. _______________________________________________________________________ _______________________________________________________________________ _______________________________________________________________________ _______________________________________________________________________ _______________________________________________________________________ _______________________________________________________________________ _______________________________________________________________________ G. Match the following. Column-I Column-II 1. First generation of computer a. PDP-8, ICL- 2900, IBM 360 2. Second generation of computer b. Artificial Intelligence 3. Third generation of computer c. NIVAC, ENIAC 4. Fifth generation of computer d.. IBM 1401, PDP-1 Teacher's Signature : __________________ Teacher's Remark : WEB http://www.webopedia.com/DidYouKnow/Hardware_Software/FiveGenerations.asp LINKS http://www.btob.co.nz/article/five-generations-computers Teacher’s Corner Dear teacher, give information about the modern computers /IT gadgets to the students. For example, smart watch, etc. 14

2 MS PowerPoint: Views Dear Teacher, Yes Students, How can we set a In this chapter, we will design to the slides? learn about Slide Master And how can we view tool to set a design and the presentation in formatting to all the slides different ways? and the different ways to view a presentation. In the previous class, you studied about formatting the slides in a PowerPoint presentation. Let us learn some more options about formatting (slide master). 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. Amazing Fact  When you select a theme in PowerPoint, it rearranges the text on the slides and adds colours and shapes to the background. These can be edited with a Slide Master view.  Editing the slide master or layouts after creating the individual slides, will need to reapply the changed layouts to the existing slides in the presentation in Normal view. 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). 15

3. Scroll up Slide pane and select the first slide. This is the slide master. Apply the changes in the slide as you require like changing theme, inserting pictures, adding textbox or shape etc. 4. Finally, click on Close Master View button. 2 1 Now, all newly inserted slides will have the same theme and text as in slide master. 4 3 Do it Yourself Open MS PowerPoint, take a blank presentation and do the following: 1. Click on View tab. In Master Views group click on Slide Master. 2. In Slide Master view, click on master slide (first slide in slide pane). 3. From Edit Theme group, select a design theme. 4. Click on Insert tab and insert a text box at the bottom left of the master slide. Type the text ‘My Presentation’. 5. Click on Slide Master tab and click on Close Master View button. 6. Insert a new slide (Title and Content). Enter the text content in both slides. 7. Save the file. 8. View the slide show. Viewing the Presentation PowerPoint includes different slide views present at View tab. 16

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. 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. 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. Amazing Fact Though PowerPoint supports only two monitors for a presentation, you can configure more monitors/projectors to run a presentation. 17

Quick Review  Slide Master view enables you to modify the slide layouts and appearance of slides in the presentation.  Normal view is the default view that you see when you first start PowerPoint.  Slide Sorter View sets all the slides in thumbnail form.  Outline view displays the outline of the slides.  Notes Page view allows you to type notes to the current slide.  Reading view allows you to view the presentation in a full screen like Slide Show view. A. Choose the correct answer. 1. To open Slide Master view, click on ____ tab, select ____ option in Master Views. a) View, Slide Master b) Insert, Slides Editing c) Master Views, Slide Master d) None of these 2. _______ is a type of Master view in PowerPoint. a) Slide Master b) Handout Master c) Notes Master d) All of these 3. ____________ sets all the slides in the form of thumbnail. a) Normal view b) Outline view c) Notes page view d) Slide Sorter view 4. ___________ allows you to types notes for the current slide. a) Normal view b) Slide Sorter view c) Notes page view d) None of these 5. _____________ includes the controls to flip through the slides. a) Normal view b) Notes page view c) Outline view d) Reading view 6. PowerPoint supports how many monitors by default? a) One b) Two c) Seven d) None of these 18

B. Fill in the blanks. Outline view, Normal view, Slide sorter view, Background styles, Notes Page view 1. _________________________ is the default view that we see when we first start MS PowerPoint. 2. __________________________displays the outlines of the slide, in the slide pane, instead of thumbnails. 3. _______________________________ allows us to type notes for the current slide. 4. __________________________ helps us to sort & organize the sequence of slides. 5. We can set only background using ___________________________ in background group. C. Tick () the correct statement and cross () out the wrong one. 1. Each slide theme has built-in slide layouts and background graphics. 2. We can modify individual slide layout in MS PowerPoint 2013. 3. Editing the slide master, reapplies the changes to the existing slides in the presentation. 4. We can edit font scheme in MS PowerPoint 2013. 5. Normal view allows us to type notes for the current slide. D. Answer the following questions. 1. What is the use of Slide Master view? ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2. Name the different slide views available in MS PowerPoint 2013. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 19

3. Distinguish between Normal view and Slide Sorter View. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 4. Write a few words about Reading view. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ Create a presentation on ‘My School’, containing five slides. 1. Open Slide Master and apply ‘Orange Red’ theme (from Edit Themes group). 2. Apply a header on the top-right of the master slide. 3. Close Master view and save the file with file name ‘yourname_slidemaster’ in D: drive. Teacher's Signature : __________________ Teacher's Remark : WEB http://www.teachucomp.com/how-to-use-slide-masters-in-powerpoint/ http://www.gcflearnfree.org/powerpoint2013/30 LINKS Teacher’s Corner Dear teacher, some more assignments can be given to use Slide Master tool to apply changes in the presentation. 20

3 MS PowerPoint: Graphics and Multimedia Dear Teacher, Dear Students, Is there a way to insert Let's learn the graphical objects in steps to insert PowerPoint slides to graphical objects make the presentation in the slides. more effective? In the previous chapter, you learnt about various slide views of PowerPoint and their uses. Let's now learn about slide layouts and how to insert graphics and other objects in the slides to enhance our presentation. Slide Layouts You know that slide layout is the arrangement of all the objects on a slide. Slide layouts can contain formatting of text (including body text, bulleted lists and titles), tables, charts, SmartArt graphics, pictures, online pictures and video. There are nine basic slide layouts in MS PowerPoint 2013. Let's have a look on all the nine slide layouts. 1. Title Slide: This is used at the starting of your 1 2 3 presentation, or to divide sections of your presentation. 2. Title and Content: This is a default and most 4 5 6 commonly used slide layout. It is used to give topic and its content. 3. Section Header: This slide type is used to separate 7 8 9 different sections of the same presentation, rather than using an additional Title slide. It can also be used as an alternate to the Title slide layout. 21

4. Two Content: This slide layout is used, if you wish to show text in addition to a graphic content type. 5. Comparison: It is similar to the Two Content slide layout, but this slide type also includes a heading text box over each type of content. This type of slide layout is used to: • Compare two types of the same content type (for example- two different charts). • Show text in addition to a graphic content type. 6. Title Only: This slide layout is used, if you want to place only a title on the page, rather than a title and a subtitle. You can then insert other types of objects such as clip art, Word art, pictures or charts if desired. 7. Blank: A blank slide layout is often used when a picture or other graphic object that needs no further information, will be inserted to cover the whole slide. 8. Content with Caption: This layout is used to place content (most often a graphic object such as a chart or picture) on the right side of the slide. The left side is used for a title and text to describe the topic/object. 9. Picture with Caption: The right part of the slide is used to place a picture. The left side is used for a title and text to describe the topic/picture. Using ‘Title and Content’ layout, inserting the different contents on the slide 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 are some iconic images 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. 2 3 Insert Chart Insert Insert Table SmartArt Graphic Insert Insert Picture Video Insert Online Pictures Now, let's start inserting the objects in the slide using these icons. Following steps are in continuation with inserting the ‘Title and Content’ slide in the presentation. 22

Inserting Table You know that tables are used to present given data in the form of rows and columns. It is very useful in organizing and presenting the data in an effective way. The steps to insert a table on the slide are: (After the first three steps...) 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. Note 1 4 2 5 Alternatively, click on Insert tab. In Tables group, click on Table 3 button → Insert Table option from the list. 3 Note 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. Do it Yourself Open MS PowerPoint 2013 and do the following as per the guidelines given below: 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 a design. 23

Inserting Chart A chart is the pictorial/graphical form to present the data. When you need to describe the relation between two or more sets of values in your presentation, charts are your best option. The steps to insert a chart in the slide are: (After the first three steps...) 4. On Title and Content slide layout, click on Chart icon. Or, on Insert tab, in Illustrations group, click on Chart button. 4 6 The Insert Chart dialog appears. 5 5. Select the chart type in the left pane and the sub-type of the select chart in the right pane. For example, select the Column option in left pane and its first subtype in the right pane. Click on OK button. 6. The chart is displayed with a data sheet (in MS Excel) that contains the default data (on which chart is created). 7. Change the default data. To change the data in the sheet, do the following: 7 8 Changing the data in datasheet 24

Click on a cell and type the new data (this action will replace the old data with new data). For example, click on A2 cell and type ‘Petrol’. Press down arrow key ‘↓’ and type ‘Diesel’. 8. As you change the data in datasheet, the column in the charts changes accordingly. After entering the data, close the datasheet. Formatting the chart: Once the chart in inserted in the slide, it can be formatted by changing its title, bar/line colours, border style, data series, etc. Note Select the chart to format. A set of Chart Tools appear on the Ribbon. It contains two tabs: Design and Format. These tabs contain the sets of tools to change the design and format the chart. Design tab contains the tools to change the chart layouts, chart styles, change chart type and change the (chart) data. Format tab contains the tools to modify the chart outline, format the chart text, shape styles, etc. Do it Yourself Open MS PowerPoint 2013 and do the following as per the guidelines given below: Insert a 3-D Pie chart. Use the data as you used in ‘Inserting Chart’ topic in this book. Inserting SmartArt Graphic A SmartArt graphic is a visual presentation of your information to effectively communicate your message or ideas. SmartArt allows you to communicate information with graphics instead of just using text. Traditional bulleted points can be transformed into eye-catching SmartArt graphic. The steps to insert a chart on the slide are: (After the first three steps...) 4. On Title and Content slide layout, click on SmartArt Graphic icon. 25

Or, on Insert tab, in Illustrations group, click on SmartArt button. 4 The Choose a SmartArt Graphic dialog appears. There are a variety of SmartArt styles to choose from, which you can use to illustrate many different types of ideas. 5. Select the SmartArt layout in the left pane and its sub-type in the right pane. For example, select Cycle in the left pane and Basic Radial on the right pane. Click on OK button. 6. The selected SmartArt graphic 5 is inserted in the slide. Click on the ‘[Text]’ on the inserted SmartArt graphic one by one and enter your text. 67 7. Click on the ‘Click to add title’ placeholder and type ‘Input Devices ’. Center align the text, make it bold and set text colour ‘Blue’. Note When a SmartArt graphic is selected, a set of SmartArt tools appear on the Ribbon. It contains two tabs: Design and Format. These tabs contain the sets of tools to change the design and format the chart. 26

Design tab contains the tools to change the SmartArt graphic layouts, SmartArt styles, etc. Format tab contains the tools to change the Shape Styles, Shape Outline, Shape Colour, Text Styles, etc. Changing SmartArt Graphic Layout, Style and Colour After inserting a SmartArt graphic, its layout, style and colour can be changed. Steps to change the layout, style and colour of SmartArt graphic are, 1. Select the SmartArt graphic on the slide. A set of SmartArt Tools appears on the Ribbon. 2. Click on Design tab. Changing the layout: 5 3. Click on drop-down arrow of Layouts. 4. Click on layout that you want to change. Changing the styles: 5. Click on drop-down arrow of SmartArt Styles 6 and select the style of the SmartArt graphic from the list. 3 4 2 1 Changing the colours: 6. Click on Change Colors button and click on required option. 27

See the changes on the selected SmartArt graphic on the slide. Formatting SmartArt graphic shape style Steps to format the SmartArt graphic are, 1. Select the part of SmartArt 2 graphic on the slide, a set of 3 SmartArt Tools appear on the Ribbon. 1 2. Click on Format tab. 3. Click on drop-down arrow of Shape Styles. Select the required option. See the changes on the selected SmartArt graphic on the slide. Do it Yourself Open MS PowerPoint 2013 and do the following as per the guidelines given below: 1. Insert SmartArt ‘Cycle Arrow Process’ of Cycle category. 2. Change the colour of the SmartArt and enter the text (as shown in figure). Inserting Picture You have already learned about inserting a picture through Picture tool from Insert tab in previous class. Let's recall this topic. The steps to insert a picture in the slide are: (After the first three steps...) 4. 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. 5. Locate and select the picture and click 4 on Insert button. Picture is inserted in the slide. 28

6. C l i c k o n t h e ‘ C l i c k t o a d d t i t l e ’ placeholder and type the relevant text, e.g. ‘Koala’. Center align the text, make it bold and set text colour ‘Blue’. 6 5 Note When the picture is selected on the slide, a set of Picture Tools appear on the Ribbon that contains the Format tab. You can format the pictures using the tools available in Format tab. Inserting Video Video can be inserted from a file (in your PC) or online (from web), in the slide. Here you will learn about inserting a video from a file. The steps to insert a video in the slide are: (After the first three steps...) 4. On Title and Content slide layout, click on Videos icon . Select From a file option in the Insert Video dialog box. 4 Or, on Insert tab, in Media group, click on Video button and select Video on My PC option. The Insert Video dialog box appears to select the video file. 29

5. Locate and select the video and click on Insert button. A black rectangular area is inserted in the slide (in which the video will be played). 6. Click on the ‘Click to add title’ placeholder 5 and type the relevant text, e.g. ‘Wildlife’. Center align the text, make it bold and set text colour ‘Green’. 7. Hover the mouse over the black rectangular area, the controls to play the video are displayed. 8. Click on Play button to play the video. 6 7 8 Note When the video area is selected on the slide, a set of Video Tools appear on the Ribbon. It contains two tabs: Format and Playback. Format tab contains the tools to change the video (area) style, preview, etc. Playback tab contains the tools to set video options, preview, video editing, etc. Inserting Audio You can insert audio/music in the slide that can be run during the presentation in the background. 30

The steps to insert/add an audio are: 1. Select the slide on which you want to add the audio file and click on Insert tab. 2. In Media group, click on Audio button and select Audio on My PC option. The Insert Audio dialog box appears. 1 2 3. Locate the audio file and click on Insert button. 4. A sound icon appears on the slide and Playback tab activates on the Ribbon. 3 5. On Playback tab, in Audio Styles 45 group, click on Play in Background button. Now, run the slide show, the inserted audio file will run automatically. Inserting a Photo Album A PowerPoint photo album is a presentation that you can create to display your personal or other photographs. You have learnt about inserting a picture in the slide. Steps to create a photo album are, 1. Open a new Blank Presentation. 2. On Insert tab, in Images group, click 2 on Photo Album button and select New Photo Album option. 3. The Photo Album dialog box appears. Click on File/Disk button. 31

3 4 4. Locate and select the image files that are 5 to be added in the photo album and click on Insert button. 6 5. The selected pictures are shown in a list in Pictures in album section in Photo Album dialog box. You can select and move up and down the order of the picture or remove the unwanted pictures here. 6. Click on Create button. The selected photos are adjusted on the slides. Now, the photo album can be run as a normal slide show. 32

Do it Yourself Open MS PowerPoint 2013 and do the following as per the guidelines given below: 1. Create a photo album consisting of photographs of your birthday or any other occasion. 2. Give appropriate title on the first slide. Quick Review  A slide layout is the arrangement of all the objects on a slide.  A table is used to represent a given data in the form of rows and columns.  A chart is the pictorial/graphical form to represent the data.  A SmartArt graphic is a visual representation of your information to effectively communicate your message or ideas.  Video can be inserted from a file (in your PC) or online (from web), in the slide.  You can insert audio/music in the slide that can be run during the presentation in the background.  A PowerPoint photo album is a presentation that you can create to display your personal photographs. A. Choose the correct answer. 1. If you want to place only a title on the slide, ___________ slide layout can be used. a) Title and content b) Two content c) Title only d) Section header 2. ___________ slide layout is used to give a topic and it’s content. a) Title and content b) Title c) Content with caption d) Picture with caption 3. Name the set of tabs that appear under Tables Tools, while working on a table. a) Table and Data b) Row and Column c) Design and Layout d) None of these 4. Name the set of tabs that appear under Chart Tools, while working on a chart. a) Format and Layout b) Design and Format c) Design and Layout d) None of these 33

5. Name the set of tabs that appear under Video Tools, while working on a video. a) Design and Format b) Design and Playback c) Edit and Replay d) Format and Playback B. Fill in the blanks. Playback, Design, Chart, Insert Table, Format 1. To insert a table, click on Insert tab →Tables button →______________________. 2. To insert a chart, click on Insert tab →____________ button in Illustrations group. 3. ________________ tab of Chart Tools contains the tools to change the chart layouts, styles and chart. 4. ________________ tab of SmartArt Tools contains the tools to change the Shape styles, outlines, colour, etc. 5. ________________ tab of Video Tools contains the tools to set video options, preview, video editing, etc. C. Answer the following questions. 1. Name the objects that can be inserted on the content area of ‘Title and Content’ slide layout._________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 2. What is SmartArt graphic? What is its use in a presentation. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 3. Write few words about PowerPoint album. ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ ___________________________________________________________________ 34

A. Create a presentation on Teacher's day. There should be a number of slides according to the total number of teachers in your school. • Each slide should be related to a teacher with his/ her picture. • Use a Title Slide as first slide (which gives information about the presentation). • Use proper slide design. • Apply a slide transition. B. Create a presentation using Sample template on Yoga. • Use Title Slide as first slide (which gives information about the presentation). • Apply Two Content layout to second slide which should contain details about Yoga. • Use Title and Content layout on other slides. • Use proper slide transition. Teacher's Signature : __________________ Teacher's Remark : WEB http://www.indezine.com/products/powerpoint/learn/picturesandvisuals/2013/ picture-layouts.html LINKS http://www.gcflearnfree.org/powerpoint2013/30.2 Teacher’s Corner Dear teacher, more assignments can be given to work with pictures, audio and video. For example, 1) Create a photo album, 2) Play family function video with text line on a slide, etc. 35

Supplement Google Slides Google Slides is the part of online Google docs and is available through Google Drive interface. It is a free tool to create and work with presentations online for free. Here is a quick introduction to Google Slides. To work with Slides, you need to have a Google account. Starting with Google Slides From your Gmail account, go to your Google Drive interface. Then click on New > Google Slides. Here, you can start from a template or a blank presentation. From a Template option will take you to the template library to choose from. Working with a Blank Presentation In blank presentation, slides are available in different layouts and you can apply various themes listed on the side panel to apply anytime. You can add text in the text boxes present on the slides. Additional text boxes, images, shapes and lines can be added using Standard Toolbar buttons for the same. 36

Insert menu allows adding images, videos, shapes, charts, diagrams, Word arts, Lines, New slides, hyperlinks, comments and animations to your presentation. Applying Animation and Transition  Select the object to animate.  Insert menu > Animation In Animations panel:  Click on +Add Animation option.  Open the animation drop down list and select the desired Animation type and Start condition.  Click on Play button to test your animation.  Click on Slide: No Transition option and select the desired slide transition from the drop down list. Slide Layout Slide menu > Apply Layout Sharing Presentation  Save your presentation and click on SHARE button at top right corner.  In the Share with others dialog box, mention the email IDs of the recipients and permission level to Edit, Comment or View the presentation.  Finally click on Send button. 37

4 MS Word: Layout and Views Dear Teacher, Yes Students, We studied about MS In this chapter, we Word. Now, we want to will learn about all learn how to set page these features. size, page margins and page orientation in MS Word. Dear children, you have learned about the text and paragraph formatting. As you know, text formatting refers to the changes that can be made in the text appearance, to make it attractive. In this chapter, you will learn about some more tools of page layout that affects the appearance of the content that includes the page orientation, margins and size. You will also learn about some tools that allow to view the document in the different ways. Page Margin 1 2 A page margin is a blank white space between the text and the edge of the page on all sides. Click here to set margins of your choice. The steps to set the page margins are: 1. On the Page Layout tab, in Page Setup group, click on the drop-down arrow of Margins button. A list of predefined page margins appear. 2. Click on the desired page margin. The margins of the page will be changed. You can also click on Custom Margins option to set your own margin values. 38

Top margin Amazing Fact Left margin By default, page margin is 1” on all sides of a page in MS Word 2013. Right margin 23 Bottom margin 4 Custom Margin You can also set the page margin of your choice. 1. Click on the Custom Margins option in the Margins drop-down list. The Page Setup dialog box appears. 2. Click on the Margins tab (if not selected). 3. In Margins section, set the Top, Bottom, left and Right margins in their respective boxes. 4. Click on the OK button. Note If you click on Set As Default button, the new default settings are saved in the template on which the document is based. Each new document based on that template automatically uses the new margin settings. Page Orientation Page orientation is the direction in which a document is displayed or printed. The two types of page orientation are portrait (vertical) and landscape (horizontal). 39

The steps to set page orientation are: 1 2 1. On the Page Layout tab, in Page Setup group, click on the drop- down arrow of Orientation button. 2. Click on the Portrait or Landscape option. Portarit Landscape Amazing Fact Note By default, page orientation is Portrait. Using Page Setup dialog box, you can Note set page margins, orientation and size. To open Page Setup dialog box, click on the Page Setup dialog box launcher, on Page Layout tab, in Page Setup group, 1 Page Size 2 You can specify a size for the paper on which you want to Click here to set other print your Word documents. page size option. The steps to set page size are: 1. On the Page Layout tab, in Page Setup group, click on the drop-down arrow of Size button. 2. Click on the required page size on the list. 40

More Paper Size  1 2 To view other paper size options click on the More Paper Sizes option in the paper size drop-down list. 3 The Page Setup dialog box appears. Then: 1. Click on the Paper tab (if not selected). 2. In the Paper size section, click on arrow of paper size list box and click the desired page size. Or, set the page width and height in Width and Height boxes. 3. Click on the OK button. Note Amazing Fact If you click on the Set As Default button, the By default, page size is letter in new default settings are saved in the template MS Word 2013. on which the document is based. Each new document based on that template automatically Generally, the paper size on uses the new page size settings. which you take printouts is A4. Do it Yourself Open MS Word and take a New Blank document. 1. Open Page Setup dialog box and set the following: i. Page Size: A4 ii. Margins: Top- 1”, Bottom-1”, Left- 1.25” and Right- 1.25” iii. Orientation: Landscape 2. Text alignment: Center 3. Type a paragraph of 100 words on the topic- ‘My Teacher’. 4. Save the file with filename ‘your_name_class’ in D: drive. Setting Text In Multi-columns You must have seen the newspapers. They contain the text in multi-columns (the text is written in more than one column on the same page), instead of single column as you see the text in your normal MS Word document. The steps to set the text in multi-columns are: 1. On the Page Layout tab, in Page Setup group, click on the drop-down arrow of Columns button. 41

2. Click on the desired number of columns from the list. 1 2 The text on the document will be set in the selected number of columns. More Columns Option Click here to open Columns dialog box and view more To view other columns options, do the following: columns options. 1. Click on the More Columns option in the columns drop-down list. The Columns dialog box appears. 2 2. In the Number of columns box, set the 3 required number of columns. 4 3. Check Line between check box, if you want a line between the columns. 4. Click on the OK button. See the figures given below to effect of other columns options. One Column (original text) Two columns Three columns with line Left columns Note When you select the number of columns, the width of the columns and space between them are adjusted automatically. You can set width of columns and space between as per your requirement using Columns dialog box. 42

Amazing Fact To put only a particular part of the text in multi columns, select the required text and choose the multi columns option. Columns and Page Breaks The text added in columns, is adjusted automatically and flows to the next columns. You can start a particular text from a new column. In the same way, you can start a particular text in a new page also. The steps to start a new column or page are: 1. Place the cursor just before the text from which you want the text to appear in the new column or page. 2. On the Page Layout tab, in Page Setup 1 group, click on the drop- down arrow of Breaks button. 3. To break the column, click on Column option. Or, to break the page, click on the Page option. Original text on a page in continuous columns 3 2 Text after column break 43

Note You can use Page Break tool from Insert tab, in Pages group also. Text after page break Inserting a Blank Page Sometimes, while entering the text in the document, you need to add a blank page after a particular text. The steps to insert a blank page are: 1. Put the cursor in the document after which you want to insert a blank page. 2. On the Insert tab, in Pages group, click on the Blank Page button. 2 1 Before entering a blank page Do it Yourself Open the document that you have created in the previous activity. 1. Use Page layout tab and select four columns options. 2. Set a line between the columns. 3. Save the changes. Creating Hyperlinks Hyperlinks to a text or picture can provide access to a file, document or website directly from your document. 44

The steps to create hyperlink to a text (to link other document) are: 2 1. Select the text you want to put as a hyperlink. 2. On the Insert tab, in Links group, click on the Hyperlink button. Or, right-click on the selected text and click on the Hyperlink option. The Insert Hyperlink dialog box appears. 3. Locate the drive/folder, where the file is located (to open from the hyperlink) in Look in list box. 4. Select the required file. 5. Click on the OK button. 3 12 4 6 6 The hyperlinked text gets underlined and its colour changes to blue. 6. Now, press and hold Ctrl key (on the keyboard) and click on the hyperlink text. The file/document linked through the hyperlinked text appears. In the same way, you can create a hyperlink to a website. Header and Footer Header and footer are the content which appear at the top and the bottom margin of every page in the document. It can be an image, text, page number, date, company name, etc. Header appears at the top margin of the page while footer appears at the bottom margin of the page. The steps to insert a header (and footer) in the document are: 45

1. On the Insert tab, in Header & Footer section, click on the Header button. 2. A pull down list appears. It provides some pre- formatted header options such as Blank, Blank (Three Columns), Austin and Banded. Click on the required option. 3. The header area activates at the top (and footer area at the bottom) of the page. Type the text to be set as a header. 1 3 2 Note If you want to set the footer also (while header area is activated), then do the following: 4. Click on the footer area or press Page Down/Down arrow key, the typing cursor blinks in the footer area. Type the text to set as a footer. 5. Click anywhere on the page. The steps to insert a footer from the Insert tab are: 1. On the Insert tab, in Header & Footer section, click on the Footer button. 2. A pull down list appears. It provides some pre- formatted footer options such as Blank, Blank (Three Columns), Austin and Banded. Click on the required option. 46

3. The footer (and 1 header) area activates 2 at the bottom of the page. Type the text to set as a footer. 4. Click anywhere on the page. 3 Remember Header and footer are applied on all the pages (if there are more than one pages in the document). Inserting Page Number Page number can be inserted at the top or bottom of the page. The steps to insert page numbers are: 1. On the Insert tab, in Header & Footer section, click on the Page Number button. 2. A pull down list appears. Hover the mouse over on an option to open the sub menu e.g. Bottom of Pages . 3. Click on the style of page number. 4. The page number is inserted on every page of the document. 5. Click anywhere 1 on the page. 2 3 4 47

Inserting and Drawing a Text Box A text box is a graphical element in Word. A text box is a way to make a block of text stand out from the rest of the document. The steps to insert a text box are: 1. On the Insert tab, in Text group, click on the Text Box button. 2. Click any one of the pre-formatted text 1 boxes or select Draw Text Box option from the list. 3. For pre-formatted option: A text box appears on the document. 2 For Draw Text box option: Drag and draw the text box on the document and type the required text. Note Generally, when you insert a text box in the document, it is inserted at the center of the line, on which the typing cursor is blinking. You can move and resize it, as per your requirement. To move the text box: Click on the edge of the text box, mouse cursor converts into move handle. Drag and move the text box to the new location. To resize the text box: Generally, when you enter the text in the text box, it is resized automatically. To resize it manually: 1. Click on the text box. 2. Put the mouse cursor on the resize handle, drag it to resize the text box. Inserting Symbols and Special Characters 3 Symbols like ☺, ☼, ♣, → and special characters like @, $ and © can be inserted in the document. The steps to insert a symbol are: 1. On the Insert tab, in Symbols group, click on the Symbol button, a list of symbols appears. 2. Click on the required symbol. If your desired symbol is not appeared in the list, click on the More Symbols option. 48

3. The Symbol dialog box appears. Click 4 on the Symbol tab. Scroll and double- 5 click on the required symbol to insert the symbol in the document. Or, select the symbol and click on the Insert button. The symbol gets inserted in the document. 6 To insert a special character in the document: 4. Click on the Special Characters tab. 5. Double-click on the required special Do it Yourself character to insert it in the document. Open the document on which you Or, select the special character and click worked in the previous activity. on Insert button. 1. Set a header- ‘My Teacher’, with 6. Click on the Close button to close the center alignment. dialog box. 2. Set a footer- ‘your name’, with right alignment. 3. Save the changes. Document Views MS Word provides different ways in which a document can be viewed, depending on the purpose for which it is viewed. These are:  Read Mode  Print Layout View  Web Layout View  Outline View  Draft View Read Mode Previous page Next page This layout is used to read or review a document. In Read Mode, the document fills the window and is formatted in magazine-style. The view is especially useful for proofing the documents. 49