Information_Technology_802_Class-11

INFORMATION TECHNOLOGY INFORMATION TECHNOLOGY Dr. Sanjay Jain Based on Windows & OpenOffice CODE 802 | Skill Education CBSE 11Published by: Orange Education An ISO 9001: 2015 Company 9, Daryaganj New Delhi-110002 Phone: 43776600 8588814859 Email: [email protected] Website: www.orangeeducation.in IE Code: 0511063121 Branches: • Chennai • Guwahati Regional Offices: • Ahmedabad • Bengaluru • Bhopal • Bhubaneswar • Dehradun • Hyderabad • Jaipur • Kochi • Kolkata • Lucknow • Mumbai • Patna • Raipur • Ranchi Printed at: © Publishers No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher. Disclaimer All product names, brand names and product logos mentioned or shown in this book are trademarks, registered trademarks, or trade names of their respective owners. The reproduction of these product names, brand names, and product logos and all instances of references of proprietary software in this book, are for educational purposes only. Although every safety measure has been taken to verify the precision of the information contained herein, the author(s) and publisher assume no responsibility for any error or omission. No liability is assumed for damages that may result from the use of information contained within. Printed and Distributed by Orange House Pvt Ltd“Computer literacy has become an integral part of today’s education system and prospering employment”. The chapters of this book have been selected and designed as per the CBSE curriculum of skill course on IT. The main features of this book are as follows:  The language of the book is simple and easy to understand.  The book focuses on Free and Open-Source Software (FOSS).  Notes are given for add-on knowledge.  Students are provided with fun facts about the topic.  Lab Activities are added in between the chapters to develop practical skills.  The applications of IT Tools are discussed with real life scenarios.  The contents will help to create opportunity for better job prospects with respect to IT fields. We hope that the book will help the students to learn the concepts and find their applications for progressive development of computer-aided education. We look forward to any suggestions to improve the book. Here’s wishing young readers lots of tech fun and knowledge filled journey ahead! —Author Dr. Sanjay Jain (MBA, M.Sc-Comp. Sc.) PREFACEThe key features of the series have been designed to ensure better learning, assessment and evaluation. Learning Resources INSIDE THE SERIES Do you Know? This section contains a fact about the topic. Notes This section contains additional information to enrich the subject. Touchpad Information Technology-XI 130 1.13 OPERATING SYSTEM In the early days of computer use, computers were huge machines that were expensive to buy, run, and maintain. The user at that time interacted directly with the hardware through machine language. The software was required to perform basic tasks such as recognising input from the keyboard, sending output to the display screen, keeping track of files on the disk, and controlling peripheral devices such as printers and scanners. The search for such software led to the evolution of the modern-day operating system. This software is loaded on top of the memory and performs all the basic tasks. An operating system is a collection of system programs that together control the operation of a computer system. It is the most important part of any computer system. It acts as an intermediary between a user and the computer hardware. The operating system has two major objectives. Firstly, an operating system controls the computer’s hardware. The second objective is to provide an interactive interface to the user and interpret commands so that they can communicate with the hardware. 1.13.1 Need for Operating System Some of the needs for an operating system are as follows: Ð Managing Hardware: The prime objective of the operating system is to manage and control the various hardware resources of a computer system. These hardware resources include the processor, memory, disc space, and so on. It receives the user’s input from the keyboard and then outputs the data to the monitor. The operating system supervises which input device’s data is requested to be processed and which processed data is ready to be displayed on the output device. In addition to communicating with hardware, the operating system provides an error handling procedure and displays an error notification. Ð Providing an Interface: The operating system organises applications so that users can easily access, use, and store them. When an application is opened, the operating system assists the application by providing the major part of the user interface. It provides a stable and consistent way for applications to deal with the hardware without the user having to know all the details of the hardware. If the program is not functioning properly, the operating system again takes control, stops the application, and displays an appropriate error message. Gary Arlen Kiddle is known as the father of OS. Notes Ð OS as a Platform for Application Programs: An operating system is needed as a platform to run application programs that help users perform specific tasks easily. It acts as an interface between the computer and the user, and is designed in such a manner that it operates, controls, and executes various applications on the computer. Ð Managing Input-Output Unit: The operating system also allows the computer to manage its own resources, such as memory, monitor, keyboard, printer, etc. Management of these resources is required for effective utilisation. The operating system controls the various system input-output resources and allocates them to the users or programs as per their requirements. Ð Consistent User Interface: The operating system provides the user with an easy-to-use user interface, so the user doesn’t have to learn a different UI every time and can focus on the content and be productive as quickly as possible. The operating system provides templates and UI components to make the working of a computer really easy for the user. Computer Hardware Operating System Utilities End User Application Program Networking and Internet 177 Do you know? IEEE standard for LAN & MAN is IEEE 802-2002. Characteristics of WAN Some characteristics of WAN are as follows: Ð The speed of data transfer is up to 150 Mbps. Ð It connects large geographical areas at a lesser cost. Ð In WAN, two or more networks are connected through a gateway that establishes connectivity between the protocol used in one network with the other network. Do you know? The First WAN to be designed and developed was private network ARPANET in USA. Difference between LAN, MAN and WAN Some differences between Lan, Man and Wan are given below: BASIS LAN MAN WAN Range The range is from 1 to 10 km. The range is up to 100 km. The range is beyond 100 km. Media used It uses guided media. It uses guided as well as unguided media. It uses unguided media. Speed It has high speed i.e., from 100 kbps.to 1000 kbps. It is optimized for a larger geographical area so, it is slower than LAN. It is meant for long-distance communications, which may or may not be provided by a public pocket network. Therefore, it is much slower in speed. Cost It is cheaper in comparison to others. It is costly compared to LAN & WAN. It is quite expensive. Equipment needed NIC, Switch and Hub. Modem and Router Microwave, Radio, Infra-red laser. Examples School, college and hospital City, Building Internet 2.4.4 VAN (Value Added Network) A value-added network (VAN) is a private, hosted service that provides companies with a secure way to send and share data with their counterparties. Value-added networks were a common way to facilitate electronic data interchange (EDI) between companies. As the Internet created competition for this service with the advent of secure email, VANs responded by expanding their service offerings to include things like message encryption, secure email, and management reporting. Touchpad Information Technology-XI 70 Ð ICT means enabling users to store, access, and manipulate data in digital format. Ð The toolbar is at the bottom of the menu bar. Ð Text Formatting means changing the appearance of text. Ð The writer allows its user to insert lists, tables, pictures, and shapes into a document. Ð We can insert a table in our document to represent the data in a tabular format. Ð OpenOffice Writer allows us to insert pictures and shapes into our documents. Ð The header and footer are used to display information on every page in the same place. Ð Tracking changes in an Open Office document means keeping records of the changes made to the document. Recap Zone To start tracking changes, click on EditàChangesà Record. To start tracking changes, you must first click Record or press Ctrl + Shift + E, as shown in the figure. As soon as you click on Record, the changes made to the document are recorded and displayed in a different colour. When you are ready to stop the process of tracking changes, click Record again. Tracking Options When the recording option is turned on, all changes are recorded. These are displayed in different colours. Deleted text is displayed with a strike through line (This text is deleted). There are many options in this Track Changes Submenu. You can use the Next and Previous options to move from one change to another. When a change is selected, use the Approve and Deny options to approve or reject the change. If you accept, the changes in the document will be permanent, and if you reject any change, the original text will be restored. If you think all the changes are okay, use the Accept All command to accept all the changes in one go. If you do not want to accept any change and want to restore the original text, use the Deny All option. In some cases, you may want to see what the document will look like with all the changes accepted without actually accepting the changes. In that case, click the Show option to display the document as if the changes have been applied. Click Show again to see document in track mode with the changes. You can also protect your changes by adding a password. Click on Project. This will open the Enter Password dialog box as shown in the figure. Add the password. Now only those who know this password can approve or reject the change. Compare Documents and Manage Changes When you click Compare Documents, Open Office compares the current file with the file you specify. This will open the Manage Change dialog box with a list of all the differences between the two files. You can now accept or reject these differences, and the current file will be updated accordingly. Touchpad Information Technology-XI 476 GLOSSARY Auto Correct: It changes the misspelt words in the whole document automatically. Auto Spellcheck: It is a facility in Writer that enables you to automatically check each word as it is typed and display a red wavy line under the misspelt words. When the word is corrected, the red wavy line disappears. Boolean value: This option helps to write the number in the form of true or false. Borders: It is used to create borders around the selected cells. Different designs of borders are available. Users can select the design according to their need. Cardinality: It refers to the uniqueness of data values contained in a particular column of a database table. Changes: Lists the commands that are available for tracking changes in your file. Check Spelling: OpenOffice Calc checks the entire active worksheets, including cell values, cell comments, embedded charts, text boxes, buttons, headers and footers for spelling errors. Communication medium: It is a powerful communication medium. Information can be easily exchanged between computers in a network. Cyber law: It is the area of law that is part of the overall legal system that is related to legal informatics and supervises the digital circulation of information, e-commerce, software and information security. Data Hiding: It ensures data security by providing limited access of information to a user. Delay: Communication delay is directly proportional to the number of nodes, adding a device would increase the communication delay. Digital footprint: is the data or trail of data you create while using the internet, it includes websites you visit, emails you send or information you submit for online services. Digital literacy: It refers to an individual’s ability to find, evaluate, and clearly communicate information through various digital platforms. Domain: It is defined as the set of all unique values permitted for a column. F F F F F F F F F F F F F F Glossary This section contains definition of common terms. Recap Zone This section contains the summary of the chapter. This section contains an activity to apply the concepts learnt. Lab Assignment 'N Activity Touchpad Information Technology-XI 278 5 Select the sheet to unhide and click on the OK button. The hidden sheet(s) will re-appear in the worksheet. 3.14.10 Navigation Navigation is a feature in Calc, by which the cursor can be placed directly anywhere in a sheet. To move directly to any cell, follow the given steps: 1 Click on Navigation from the Standard Toolbar. [Or], 2 Select the option Navigator from the View menu. 3 The Navigator window opens. In the column and row fields, specify the column and the row number respectively, and then press the Enter key. The cursor moves to the typed address of the desired cell. Ð Begin ‘Calc’ and open the file ‘Cricket’. Ð Add a new sheet after Sheet1 and rename the sheet as ‘Scores’. Ð Move the newly added sheet to the end position. Ð Copy the entire content of the first Sheet to the last Sheet. Ð Hide the last sheet and then Unhide it. Ð Using ‘Navigator’, move to the different parts of an opened Workbook. Ð Add another sheet before Sheet1 and rename as ‘Players’. Ð Copy Player Name, Country into the newly added Sheet. Ð Delete the unused sheet from the worksheet. Ð Hide the sheet ‘Scores’. Ð Save and Exit from ‘Calc’. Lab Assignment ‘n ActivityAssessment Resources Projects Sample Question Paper This is an assessment to challenge the students to apply the concepts learnt. This section contains sample question paper. 217 Networking and Internet Section A (Objective Type Questions) A. Multiple choice questions. 1. A ............................. is a set of rules that governs data communication. i. Protocols ii. Standards iii. RFCs iv. Servers 2. Bluetooth is an example of ............................. . i. Personal Area Network ii. Local Area Network iii. Virtual Private Network iv. Wide Area Network 3. Which of the following performs modulation and demodulation? i. Fiber optic ii. Satellite iii. Modem iv. coaxial cable 4. The types of transmission channel or media used for LAN or WAN are ............................. . i. Twisted pair cables ii. Coaxial cables iii. fibre optic cables and radio waves iv. All of these 5. Which one of the following is not a network topology? i. Star ii. Ring iii. Hybrid iv. Peer to Peer Section B (Subjective Type Questions) A. Short answer type questions. 1. Why do we need a network? Ans. Networking is necessary for the following reasons:  Resource sharing: All the computers in a network can share software (programs, data) and hardware devices (printer, scanner, CD drive, etc.).  Reliability: If one computer fails, the other computer can perform the work without any delay. This is very important for banking, air traffic control and other applications.  Communication medium: It is a powerful communication medium. Information can be easily exchanged between computers in a network.  Scalable: This means, system performance can be increased by adding computers to a network. 2. What do you mean by hybrid topology? Ans. The combination of various different topologies is known as hybrid topology. When two or more different topologies are combined together is termed as hybrid topology and if similar topologies are connected with each other will not result in hybrid topology. 3. What is Network Interface Unit? Ans. A network interface unit is a device attached to each node and thus is connected to the server. It acts as a common interface to establish connections between networked computers to connect to an outside network. NIU is popularly known as Network Interface Card. A unique physical address is given to each Network Interface Card by its manufacturer; known as Media Access Control (MAC) address. Each network interface unit has a unique node address. It serves as a common interface for various other devices within a Local Area Network (LAN) or as an interface to allow networked computers to connect to an outside network. 4. What is fiber optics? Ans. Fiber Optic cables have more capacity and provide a higher speed of data transfers. In fiber optics cable, data are transferred through electromagnetic waves. One cable of such type can support over 30,000 telephone lines at a time. Fiber optic cable are expensive and fragile in nature. Using optical fibers, one can achieve a bandwidth of 20 GHz and a transmission rate up Solved Exercise Sample Question Paper INFORMATION TECHNOLOGY (Subject Code–802) Class XI Touchpad Information Technology-802-XI 478 Max. Time: 3 Hours Max. Marks: 60 General Instructions: 1. Please read the instructions carefully. 2. This Question Paper consists of 24 questions in two sections – Section A & Section B. 3. Section A has Objective type questions whereas Section B contains Subjective type questions. 4. Out of the given (6 + 18 =) 24 questions, a candidate has to answer (6 + 11 =) 17 questions in the allotted (maximum) time of 3 hours. 5. All questions of a particular section must be attempted in the correct order. 6. SECTION A - OBJECTIVE TYPE QUESTIONS (30 MARKS): i. This section has 06 questions. ii. There is no negative marking. iii. Do as per the instructions given. iv. Marks allotted are mentioned against each question/part. 7. SECTION B – SUBJECTIVE TYPE QUESTIONS (30 MARKS): i. This section contains 18 questions. ii. A candidate has to do 11 questions. iii. Do as per the instructions given. iv. Marks allotted are mentioned against each question/part. SECTION A: OBJECTIVE TYPE QUESTIONS Q 1. Answer any 4 out of the given 6 questions on Employability Skills (1 x 4 = 4 marks) i. List the 7 Cs of effective communication. 1 ii. How do rewards motivate the team? 1 iii. What is Text Formatting? 1 iv. A greater inflow of ................................. will help the business grow. 1 (a) ideas (b) customers (c) money (d) offers v. Prime Minister Shri. Narendra Modi launched the “Swachh Bharat Abhiyan” on ................................. . 1 (a) October 31st, 2014 (b) November 14th, 2014 (c) Sending text files only (d) August 15th, 2014 vi. Any team-building exercise should encourage collaboration rather than competition. 1 Q 2. Answer any 5 out of the given 7 questions. (1 x 5 = 5 marks) i. Which of the following is not a measurement of the speed of a printer? 1 (a) CPS (b)  (c)  (d)  ii. A hub and switch are ................................. devices. 1 (a) LAN (b) WAN (c) MAN (d) PAN iii. Which alignment is not available on LibreOffice Impress? 1 (a) Central Alignment (b) Left Alignment (c) Justify Alignment d. Right Alignment Touchpad Information Technology-XI 470 Projects OFFICE AUTOMATION TOOLS 1. Create the same table in Calc and save it with “Monthly sales” name. Name January February March April May June Suresh Dubey 45000 55000 39000 55000 34000 45000 Aman Kapoor 30000 38000 45000 45000 55000 67000 Disha Puri 28000 56000 67000 65000 65000 55000 Pooja Gupta 30000 45000 59000 34000 44000 30000 Manisha Lal 35000 39000 34000 45000 65000 59000 Nisha Gautam 42000 50000 78000 76000 45000 54000 Sourav Sharma 29000 54000 45000 56000 56000 40000 Nitish Aggarwal 37000 39000 44000 67000 60000 66000 TOTAL AVERAGE HIGHEST LOWEST Perform the following operations on the above table: i. Use appropriate formula to calculate the TOTAL, AVERAGE, HIGHEST, LOWEST • Use SUM() function to calculate the TOTAL • Use AVERAGE() function to calculate the AVERAGE • Use MIN() function to calculate the LOWEST • Use MAX() function to calculate the HIGHEST ii. Create a column chart. iii. Insert a table title “MONTHLY SALES” at the top of the spreadsheet. 2. Type the give paragraph in OpenOffice Writer. Experts say that if you feel drowsy during the day, even during boring activities, you haven’t had enough sleep. If you routinely fall asleep within five minutes of lying down, you probably have severe sleep deprivation, possibly even a sleep disorder Microsleeps, or very brief episodes of sleep in an otherwise awake person, are another mark of sleep deprivation. In many cases, people are not aware that they are experiencing micro-sleeps. The widespread practice of “burning the candle at both ends” in Western industrialised societies has created so much sleep deprivation that what was once considered really abnormal sleepiness is now almost the norm. Many studies make it clear that sleep deprivation is dangerous. Inter-Disciplinary Creativity 61 Self-Management Skills–III 7. What important questions do you need to ask yourself while using a priority matrix to use it efficiently? 8. What is team building? State its purpose. C. Competency-based/Application-based questions: Suppose that you have joined a new school. How will you make new friends there? Explain how networking skills will help you to do so. 1. Amit hasto organise a Christmas event for his class. He has been assigned a team of 10 classmatesto help him. Prepare a to-do list to organise the party as well as to whom to delegate the various tasks. 2. Assignment -- Motivation [NCERT] Material required: Pen/Pencil Procedure: i. Make a list of reasons that stop you from being motivated. ii. Write down ways by which you will motivate yourself to overcome them. Reasons for not being motivated Ways to overcome Example: People make fun of the way I speak English. Example: I will learn to speak English correctly by attending classes after school. Example: My parents do not share their feelings with me. Example: I will make sure that I spend time talking with my parents and ask them how do they feel? 3. Group Exercise — Staying motivated [NCERT] Material required: Pen or pencil, notepad or sheets of paper, chart paper Procedure: i. Form groups of at least three students. ii. Choose any one of the following situations and discuss amongst yourselves what each one would do to motivate oneself. Choose from one of the below situations. Your teacher gives you feedback on your rude behaviour with your classmates who are of different gender. There are a lot of areas where you can improve. What will you do to motivate yourself to improve your behaviour? Your father has given you the responsibility of arranging material for a health camp in a nearby government school. You do not want to do this task. How will you motivate yourself to do the work? iii. One person can take down all the points made by members of the group and present it to the entire class. 4. Assignment — Working in a Team Material required: Pen or pencil, notepad or sheets of paper, chart paper Procedure: i. Work in groups. Using a chart paper, each group will create a poster that has information about any one of the following topics: (a) Planting saplings to save the environment (b) Sharing responsibility at home (c) Playing a game (d) Disaster management (e) Children standing around a ring and holding it with finger. Class Activity Experiential Learning Art Integration Class Activity This section has Hands-on activities to engage students for an enriched learning experience. This section contains questions to assess the intellectual and comprehensive writing skills. Objective & Subjective Questions This section contains fun based interactive task. Competency-based/ Application-based questions 103 Green Skills-III D. Match the following: 1. National Green Tribunal a. Sanitation & cleanliness 2. National Solar Mission b. Settles disputes 3. Greener India Mission c. Protecting Forest covers 4. Swachh Bharat Abhiyan d. Uses 100% solar energy 5. Diu e. Clean energy Section B (Subjective Type Questions) A. Answer the following questions: 1. What is Green Economy? 2. What is the role of NGT? 3. What is the HelpUsGreen project? 4. Why do we need to harvest the rainwater? 5. Name the 8 missions of NAPCC. 6. Define the meaning of a business idea. [NCERT] 7. How can waste management be performed? 8. List the roles of Government and Private agencies in green economy. 9. Write about the ‘Walkie Talkie Mobi Charger’ and ‘Mitticool’ projects in India. 10. Explain the green economy policy ‘Swachh Bharat Abhiyan’. 11. Explain any two sectors of green economy. 12. Write any two business ideas that you would want to try out? [NCERT] B. Competency-based/Application-based questions: Diya discovered that the only fresh water source in her community was being contaminated by rubbish being dumped into the surrounding river by a tiny fashion shop. She now wants to file a complaint against the fashion house, along with a few other townspeople. Where do her grievances belong to? Critical Thinking Prepare a project on Padma Shri awardee Jadav “Molai” Payeng, also known as the Forest Man of India, and his contributions to the field of afforestation. Group Exercise: Prepare a Poster on ‘Sectors of Green Economy’ Material required: Pens, colouring material, chartpaper [NCERT] Procedure: • Form groups of 4-5 students each. • Make a poster showing the sectors of green economy you discussed in the previous activity. This can be completed as homework if there is less time in class. Class Activity Communication Art Integration Practical Work 463 1. Create the following table – Students, solve the given queries on the table. Table: Students Roll_No. Stu_Name English Hindi Math Science Computer 01 Aman 67 56 45 72 87 02 Heena 81 78 67 81 66 03 Mukesh 59 69 82 69 56 04 Neeti 87 83 90 76 78 Solve the following queries based on the above table: Ð Display all students’ names whose marks are greater than 80 in computer subject Ð Display all the content of student table Ð Display the record of student name Aman Ð Display the record whose roll no 04 2. Create the following table: Workers with the field name Emp_no. as a primary key. Emp_no Gender Date_of_joining Date_of_birth Emp_name Emp_salary 101 Female 12-10-2015 1-09-1990 Sarita Devi 45,000 102 Male 26-12-2000 26-12-1970 Ashwani Kumar 50,000 103 Male 13-05-2002 22-03-1980 Rajesh Kapoor 45,000 104 Female 07-02-2012 07-02-1985 Jyoti Puri 40,000 Solve the following queries based on the above table: ÐÐInsert a record of employeewith empno-106, gender-female, dateofjoining-15-09-2010, dateofbirth-13-02-1992, empname-Kavita bhogal, emp salary-42,000 ÐÐDisplay the records of those employees whose earnings are less than RS. 45,000 ÐÐDisplay all records of employees whose gender is male ÐÐDisplay the names of employees whose date of joining is between 2000 to 2015 3. Type the following paragraph in OpenOffice. Computers play a very important role in human lives. The primary reason for using a computer is to make life easier. All the tasks performed by a computer may also be performed by human beings, but at the expense of a lot of time and labour. Applications of computers can be seen in every electronic device nowadays, whether it is a television, a washing machine, smart watches, and the list is endless. With the advancement in use and technology, the use of electronic devices has increased manifold. Make the following changes in the above paragraph. ÐÐChange the font type -Arial ÐÐAdd footer as page number ÐÐMake sure font size is 12pt Computational Thinking Inter-Disciplinary Art Integration Practical Work This section has sample questions for practical examination. Practical WorkJOB ROLE: DOMESTIC IT HELPDESK ASSISTANT CLASS–XI Total Marks: 100 (Theory-60 + Practical-40) The present course curriculum offers an opportunity for students to understand the basics of computer software and hardware for working efficiently on computer. This course will enable students to hone skills to develop desktop based applications etc. With extensive demand of designers, the course aims at inculcating not only programming skills but also the understanding of graphics. Graphics in itself is a wide and very interesting area which helps in shaping the creativity of a student. PREAMBLE Computer is now affecting energy sphere of human activity. It is instrumental in bringing revolutionary changes in industry, scientific research and education. This is not only the demand of time but also the demand of almost each and every subject to have an associated computer learning to equip a student with start-of-art technology to prove himself/herself a better candidate than those without computer knowledge. COURSE OVERVIEW Domestic IT Helpdesk Assistant requires the individual to have thorough knowledge of various technology trends. This job involves working on a computer, entering, retrieving and sharing data He/she can assist a programmer or a database engineer. He/she can independently interact with customers. The individual should be result oriented and should be able to demonstrate logical thinking and interpersonal skills and should be willing to work at a desk based job. The person is responsible to maintain hardware and software systems according to company policies. Inspect, and Troubleshoot basic network, hardware and software components. COURSE OUTCOMES On completion of the course, students should be able to:  Apply effective oral and written communication skills to interact with people and customers.  Identify the principal components of a computer system.  Demonstrate the basic skills of using computer.  Identify the solution for small applications in the form of computer programmes.  Use the computer for the data entry process with speed and accuracy.  Manage the database and handle queries.  Understand basic cyber safety and security norms.  Will be able to troubleshoot the computer system. SALIENT FEATURES OF THE COURSE The course will equip students with skills to analyze various problems and their trouble shooting. Content of the course has been designed as such to make students capable of independently working on a desktop and be able to develop applications to handle computations of small scale and record keeping. Students will develop following skills:  It will empower students with various skills required to work efficiently on computer.  Understand basic functional and computational units.  Understand networking and internet concepts.  Recognize various internet devices and threats to cyber security. (vi) INFORMATION TECHNOLOGY (CODE–802) Skills to work efficiently with basic office tools like word, spreadsheets, presentation.  Understand basics of databases and SQL to handle databases.  Develop programming skills in Java. Through this course students will not only gain knowledge about the basics of computer but will also develop confidence in developing small applications through programming. SCHEME OF UNITS This course is a planned sequence of instructions consisting of units meant for developing employability and vocational competencies of students of Class XI opting for skill subject along with other education subjects. The unit-wise distribution of hours and marks is given overleaf: UNITS NO. OF HOURS for Theory and Practical MAX. MARKS for Theory and Practical Employability Skills PART A Unit 1: Communication Skills-III 10 2 Unit 2: Self-Management Skills-III 10 3 Unit 3: ICT Skills-III 10 1 Unit 4: Entrepreneurial Skills-III 15 3 Unit 5: Green Skills-III 05 1 Total 50 10 PART B Subject Specific Skills          Marks Unit 1: Computer Organization     15       15 5 Unit 2: Networking and Internet    15       25 10 Unit 3: Office Automation Toools    15       30 10 Unit 4: RDBMS    15       20 10 Unit 5: Fundamental of Java    25       35 15 Total   85      125 50 PART C Practical Work Office Automation Tools 15 Java Programme 10 MySQL Commands 5 Total 30 PART D Project Work Practical File 05 Viva Voce 05 Total 10 GRAND TOTAL 260 100 Theory (In Hours) Practical (In Hours) (vii)EMPLOYABILITY SKILLS Unit Learning Outcome Theory Practical COMMUNICATION SKILLS-III 1. Demonstrate knowledge of various methods of communication. 1. Methods of communication • Verbal • Non-verbal • Visual 1. Writing pros and cons of written, verbal and non-verbal communication. 2. Listing do’s and don’ts for avoiding common body language mistakes. 2. Identify elements of communication cycle 1. Communication styles- assertive, aggressive, passive-aggressive, submissive, etc. 1. Observing and sharing communication styles of friends, teachers and family members and adapting the best practices 2. Role plays on communication styles 3. Demonstrate basic writing skills 1. Writing skills to the following:    • Sentence    • Phrases    • Kinds of sentences    • Parts of sentence    • Parts of speech    • Use of articles    • Construction of a paragraph 1. Demonstration and practice of writing sentences and paragraphs on topics related to the subject. SELF-MANAGEMENT SKILLS-III 1. Demonstrate impressive appearance and grooming 1. Describe the importance of dressing appropriately, looking decent and positive body language 2. Describe the term grooming 3. Prepare a personal grooming checklist 4. Describe the techniques of self- exploration 1. Demonstration of impressive appearance and groomed personality 2. Demonstration of the ability to self- explore 2. Demonstrate team work skills 1. Describe the important factors that influence in team building 2. Describe factors influencing team work 1. Group discussion on qualities of a good team 2. Group discussion on strategies that are adopted for team building and team work 3. Apply time management strategies and techniques 1. Meaning and importance of time management – setting and prioritizing goals, creating a schedule, making lists of tasks, balancing work and leisure, using different optimization tools to break large tasks into smaller tasks. 1. Game on time management 2. Checklist preparation 3. To-do-list preparation (viii)ICT SKILLS-III 1. Create a document on word processor 1. Introduction to word processing. 2. Software packages for word processing. 3. Opening and exiting the word processor. 4. Creating a document 1. Demonstration and practice of the following:    • Listing the features of word processing    • Listing the software packages for word processing    • Opening and exit the word processor    • Creating a document 2. Edit, save and print a document in word processor 1. Editing text 2. Wrapping and aligning the text 3. Font size, type and face. 4. Header and Footer 5. Auto correct 6. Numbering and bullet 7. Creating table 8. Find and replace 9. Page numbering. 10. Printing document. 11. Saving a document in various formats. 1. Demonstration and practicing the following:   • Editing the text   • Word wrapping and alignment   • Changing font type, size and face   • Inserting header and footer   • Removing header and footer 2. Using autocorrect option 3. Insert page numbers and bullet 4. Save and print a document ENTREPRENEURIAL SKILLS-III 1. Describe the significance of entrepreneurial values and attitude 1. Values in general and entrepreneurial values 2. Entrepreneurial value orientation with respect to innovativeness, independence, outstanding performance and respect for work 1. Listing of entrepreneurial values by the students. 2. Group work on identification of entrepreneurial values and their roles after listing or reading 2-3 stories of successful entrepreneur. 3. Exhibiting entrepreneurial values in Ice breaking, rapport building, group work and home assignments. 2. Demonstrate the knowledge of attitudinal changes required to become an entrepreneur 1. Attitudes in general and entrepreneurial attitudes 2. Using imagination/ intuition 3. Tendency to take moderate risk 4. Enjoying freedom of expression and action 5. Looking for economic opportunities 6. Believing that we can change the environment 7. Analyzing situation and planning action 8. Involving in activity 1. Preparing a list of factors that influence attitude in general and entrepreneurial attitude 2. Demonstrating and identifying own entrepreneurial attitudes during the following micro lab activities like thematic appreciation test 3. Preparing a short write-up on “who am I” 4. Take up a product and suggest how its features can be improved 5. Group activity for suggesting brand names, names of enterprises, etc. GREEN SKILLS-III 1. Describe importance of main sector of green economy 1. Main sectors of green economy- E-waste management, green transportation, renewal energy, green construction, water management 2. Policy initiatives for greening economy in India 1. Preparing a poster on any one of the sectors of green economy 2. Writing a two-page essay on important initiatives taken in India for promoting green economy 2. Describe the major green Sectors/Areas and the role of various stakeholder in green economy 1. Stakeholders in green economy 2. Role of government and private agencies in greening cities, buildings, tourism, industry, transport, renewable energy, waste management, agriculture, water, forests and fisheries 1. Preparing posters on green Sectors/ Areas: cities, buildings, tourism, industry, transport, renewable energy, waste management, agriculture, water, forests and fisheries (ix)