Microsoft Word - CS XI 2015 PDF.docx

[Audio] CHAPTER TEN CHAPTER TEN CHAPTER TEN CHAPTER TEN 10 COMPUTER COMPUTER COMPUTER COMPUTER SYSTEM SYSTEM SYSTEM SYSTEM APPLICATIONS APPLICATIONS APPLICATIONS APPLICATIONS OBJECTIVE: When you have completed this chapter, you will be able to know about the Short Answer Questions Q1. Why it is necessary to learn computer. Q2. What are the areas in general life where computer systems are used? Q3. How computer can b used for personal productivity? Q4. How computer is helpful in the field of arts and graphics? Q5. How government of a country is using computer to manage government affairs? Q6. What is the role of computer in agriculture? Long Answer Questions Q1. Why it is necessary to learn computer. What is the practical use of computer in daily life? Page 93 of 157 VER: 04.

[Audio] CHAPTER # 10 COMPUTER SYSTEM APPLICATIONS =============Short Questions and Answers========== Q1. Why it is necessary to learn computer. OR What is the practical use of computer in daily life? The Computer is digital equipment. It contains most modern technology to solve all kind of problems. It is use not only for business, scientific, and technical purpose but also to solve general life problems. Reasons To Study Computer The computer is used in various areas of life. It facilitates the user in almost all the spheres of life. It is used for the following purposes.  For Learning And Academic Studies   For Employment And Business Activities   For Technological Developments   For Fun And Entertainment Q2. What are the areas in general life where computer systems are used? A computer system is a multipurpose device it is used not only for business and technical problems but also for general life problems. The following are the areas where computer systems are serving the man kind. 1. Communication 2. Science, Research, Engineering 3. Education And Teaching 4. Fun And Entertainment 5. Arts And Imaging 6. Business And Ecommerce 7. Health And Medicines 8. Agriculture And Farming 10. Government Management Affair Q3. How computer can b used for personal productivity? The growth of personal computing is an environment in which persons utilizes the computer systems for the management of their activities.. It's not uncommon for companies to have more personal computers more than of telephones. A variety of domestic and business applications of personal computing forms the personal productivity of the computer system. Domestic applications include everything from personal finance to education and even for entertainment. Microcomputer software is available to support thousands of common and not-so-common business applications. A growing family of software for personal or business productivity is the foundation of personal computing in the home and in the business world. Page 94 of 157 VER: 04.

[Audio] Q4. How computer is helpful in the field of arts and graphics? Artists are using personal computer to generate and manipulate images. Sculptures, for example, can use personal computers to create models and experiment with variations before committing to an actual physical piece. Some fine arts museums of have created a permanent use of computer art, in which visitors can view art and also use computers to experiment with their own images. Film industry makes extensive use of personal computers to control camera movements for special effect sequences in movies such as those in the star wars series. With a Musical Instrument Digital Interface (MIDI), personal computers can be used to control synthesizers to produce music. Q5. How government of a country is using computer to manage government affairs? The largest single user of computers is the federal government. The NADRA, for example; produces millions of tax documents, voter lists, national identity cards etc. A month with the help of computers. Computers are also used for forecasting weather, for servicing parts, for processing immigrants, for imparting justice, and-of-course- for collecting taxes. Q6. What is the role of computer in agriculture? Computers have penetrated to farms. Farmers now use small computers purchased for less than the price of a tractor to help with billings, crops information, cost per acre, feed combinations, and market price checks. Cattle ranchers can also use computers for information about livestock breeding and performance. Furthermore, sheep can be shared by a computerized robotic shearing arm. The arm is guided by sensors and computer memory, which stores the dimensions of a typical sheep. In addition, computers can give people the option of working at home instead of in city offices. ===========Long Questions and Answers========= Q1. Why it is necessary to learn computer. What is the practical use of computer in daily life? The Computer is digital equipment. It contains most modern technology to solve all kind of problems. It is use not only for business, scientific, and technical purpose but also to solve general life problems. Reasons To Study Computer The computer is used in various areas of life. It facilitates the user in almost all the spheres of life. It is used for the following purposes.  For Learning And Academic Studies The computer science is a modern technology which facilitates the students of schools, colleges, Universities and other professional institutes to enhance their capabilities. Using computers the students can search the required academic information and can improve their knowledge. Now a day's most of the educational institutes are using computers for learning and teaching. Page 95 of 157 VER: 04.

[Audio]  For Employment And Business Activities The computer system has become a fundamental part for all types of business organizations like offices, superstores, multinational companies and manufacturing industries. The employers demand the human recourses that are familiar to operate computer system because the computer system plays an important role to perform business activities properly.  For Technological Developments The scientists and technicians use computer systems for research and development for various modern products. Scientific and technical calculations are performed with high accuracy and increased productivity.  For Fun And Entertainment A computer system is a multipurpose device it is not only used for technical and business activities but also it is used for fun and entertainment. A number of multimedia games and audio and video files can be played on computers. Page 96 of 157 VER: 04.

[Audio] CHAPTER ELEVEN CHAPTER ELEVEN CHAPTER ELEVEN CHAPTER ELEVEN 11 COMPUTER COMPUTER COMPUTER COMPUTER SYSTEM SECURITY SYSTEM SECURITY SYSTEM SECURITY SYSTEM SECURITY OBJECTIVE: When you have completed this chapter, you will be able to know about the Short Answer Questions Q1. Define computer virus? How many types of computer viruses are there? Q2. How a computer system can be prevented from a virus infection? Q3. Define software piracy. types of buses are there? Explain in detail. Long Answer Questions Q1. Define computer virus? How many types of computer viruses are there? Describe how a virus can affect a computer system. Q2. How a computer system can be prevented from a virus infection? Q3. Define software piracy. What is the role of the copy right law to overcome software piracy? CHAPTER # 11 Page 97 of 157 VER: 04.

[Audio] COMPUTER SYSTEM SECURITY ===========Short Questions and Answers========= Q1. Define computer virus? How many types of computer viruses are there? Computer Virus A computer virus is a program designed to disturb, alter or destroy data stored on computer system. Explanation A computer virus is designed for the destruction of data in the computer system by business competitors, hackers and destructive mind persons. A computer virus can be passed from one computer to another floppy disk, over the local area network, over remote modem connection and over the internet connection. Major Types of Viruses The following are the major types of viruses.  Worm   Trojan Horse  Time Bombs   File Infectors  Macro Viruses   Boot Sector Virus Q2. How a computer system can be prevented from a virus infection? A virus can cause a serious problem for computer system. Different viruses produce different type of threats for computer system. Thousands of viruses are in existence, and more are being written each day. For a computer user there must be some strategy to prevent computer system from virus infection. Antivirus An antivirus is software which works to prevent the computer system from virus infection. Famous anti viruses: Some popular antivirus programs include the following:  McAfee virus scan   IBM antivirus  Doctor Solomon's   Norton Antivirus   Symantec antivirus for the Macintosh Q3. Define software piracy. Software Piracy Software piracy is a computer related crime which is an illegal duplication of copy righted software. Explanation Page 98 of 157 VER: 04.

[Audio] Software piracy is a biggest issue affecting the computer industry. Millions of computers have made copies of program which they do not legally own. In most cases copying software is as easy as duplicating a cassette or photocopying a book. Using software piracy a user can gain the use of the program without paying for it to the vendor. People are not aware that software piracy is a serious crime in Pakistan's criminal law. ===========Long Questions and Answers========= Q1. Define computer virus? How many types of computer viruses are there? Describe how a virus can affect a computer system. Computer Virus A computer virus is a program designed to disturb, alter or destroy data stored on computer system. Explanation A computer virus is designed for the destruction of data in the computer system by business competitors, hackers and destructive mind persons. A computer virus can be passed from one computer to another a floppy disk, over the local area network, over remote modem connection and over the internet connection. What A Virus Can Do  A virus can destroy the data on computer system.  A virus can destroy the software installed on computer system.   A virus can produce problems like device locking, storage media lacking, and problem in system's speed.   A virus can provide problems like continuous restart, drive formatting and hanging.   Sometimes a virus can destroy even the hardware like storage media. Major Types of Viruses Viruses can be divided into several categories. These include worms Trojan horses, time bombs, file infectors, macro viruses, and boot sector viruses.  Worm A worm is a program whose purpose is to duplicate itself. An effective worm will fill entire disks copies of itself and it can spread to multiple computers on a network, essentially clogging the entire system with copies. Worms can commonly spread over the internet via-email message attachments and internet relay chat (IRC).  Trojan horse A Trojan horse refers to illegal instructions placed in the middle of a useful program. The program does something useful but also, via the Trojan horse instructions, does something destructive in the background. Sometimes a Trojan horse is disguised as a game or a utility program that users will find appealing; then, when the users begin running the "game", they discover that they have loaded another animal entirely. A Trojan horse may erase the data on the hard disk or cause other damages.  Time bombs Page 99 of 157 VER: 04.

[Audio] Time bombs and logic bombs are designed to sit harmlessly on a system until a certain event or date causes the program to become active some bomb are activated by a date, a change to a file, or a particular action taken by a user or a program. The most famous time bomb is the Michelangelo virus, named after the great artist. On the artist's birthday (March 6) each year, the virus designed to destroy the contents.  File infectors Most viruses are file infectors that spread from program to program and do damage to files (such as exe or com files), data and directories. A file infector virus hidden on a floppy disk will transfer itself to any hard disk that the floppy comes into contact with. When another floppy disk is inserted into the computer containing that hard disk, the virus will copy itself onto that floppy disk. It is clear that viruses can spread rapidly through an organization.  Macro Viruses A macro virus is designed to infect a specific type of document file, such as Microsoft word or Excel files. These types of documents can include macros, which are small programs that execute commands.  Boot sector virus Regarded as one of the most hostile types of virus, a boot sector virus infects the boot record of a hard or floppy disk (a boot sector is a special area of a disk that stores essential files, the computer accesses during startup). The virus moves the boot sector's data to a different part of the disk or can make the data stored on the disk in accessible. When the computer is started, the virus copies itself into memory where it can hide and infect other disks. Q2. How a computer system can be prevented from a virus infection? A virus can cause a serious problem for computer system. Different viruses produce different type of threats for computer system. Thousands of viruses are in existence, and more are being written each day. For a computer user there must be some strategy to prevent computer system from virus infection. Antivirus An antivirus is software which works to prevent the computer system from virus infection. Function Of The Antivirus 1. An antivirus searches for the virus in the storage media which exists in the form of file, this process is called virus scanning. 2. The antivirus deletes or destroys the virus files from the computer system. 3. The antivirus repairs and manages the infected data files of the user in the storage media. 4. An antivirus is an automatic program which keeps an eye over every start up, on device attachment (like USB, Floppy, and File etc) and while network connection. 5. An antivirus prevents the computer system from virus destruction. Famous Anti Viruses Page 100 of 157 VER: 04.

[Audio] Some popular antivirus programs include the following:  McAfee virus scan  IBM antivirus   Doctor Solomon's   Norton Antivirus  Virex   Symantec antivirus for the Macintosh Q3. Define software piracy. What is the role of the copy right law to overcome software piracy? Software Piracy Software piracy is a computer related crime which is an illegal duplication of copy righted software.  Explanation Software piracy is a biggest issue affecting the computer industry. Millions of computers have made copies of program which they do not legally own. In most cases copying software is as easy as duplicating a cassette or photocopying a book. Using software piracy a user can gain the use of the program without paying for it to the vendor. People are not aware that software piracy is a serious crime in Pakistan's criminal law. Copyright Criminal Law The copyright act 1992 of Pakistan is an amendment in the constitution which demonstrates it as a crime.  Explanation According to this copyright act it is illegal to make or distribute copies of computer programs without authorization. No other copy can be made without specific authorization from the copyright owner.  Penalties for software piracy: If the company programs have been pirated by someone, the company can take the following measures: 1. The company may prosecute under the provision of the copyright law. 2. The penalties and fines can be imposed by judicial inquiry. 3. The criminal can be imprisoned up to 3 years. Page 101 of 157 VER: 04.

[Audio] CHAPTER TWELVE CHAPTER TWELVE CHAPTER TWELVE CHAPTER TWELVE 12 WORD PROCESSOR WORD PROCESSOR WORD PROCESSOR WORD PROCESSOR AND AND AND AND SPREAD SHEETS SPREAD SHEETS SPREAD SHEETS SPREAD SHEETS OBJECTIVE: When you have completed this chapter, you will be able to know about the Short Answer Questions Q1. Define word-processing? What is the purpose of a word-processor? Give examples of word processors. Q2. Write a short note on spreadsheet? Long Answer Questions Q1. What is word-processing? What is the purpose of a word-processor? Q2. Write a short note on spreadsheet? CHAPTER # 12 Page 102 of 157 VER: 04.

[Audio] WORD PROCESSORS AND SPREAD SHEETS ===========Short Questions and Answers========= Q1. Define word-processing? What is the purpose of a wordprocessor? Give examples of word processors. Word Processing Word processing refers to typing, editing, formatting, and printing of text. Word processing is done through some software called word processor. Word Processor A word processor is an application software used to edit, format, and print the text in the form of a document. Examples 1. WordStar 2. Word Perfect 3. Ms-Word Q2. Write a short note on spreadsheet? A spreadsheet is application software which facilitates the user to represent and manipulate text and numeric data in tabular form. Explanation Spreadsheet software represents the data in tabular form on which mathematical and business calculation can be applied. A spreadsheet contains a number of commands in the form of formulas and functions for the evaluation of data. A spreadsheet contains rows and columns. A cell is created by the intersection of row and column each cell in a spread sheet is identified by its own unique cell address. Example Microsoft Excel ===========Long Questions and Answers========= Q1. What is word-processing? What is the purpose of a wordprocessor? Word Processing Word processing refers to typing, editing, formatting, and printing of text. Word processing is done through some software called word processor. Word Processor A word processor is an application software used to edit, format, and print the text in the form of a document. Explanation The documentation is required in most of the areas related to business and general life problems. Mostly written communication is in the form of memos, letters, reports, proposals, legal briefs, contracts, terms and conditions, theses, articles and books. Microsoft Word Page 103 of 157 VER: 04.

[Audio] Microsoft word is the famous word processor. It is used widely throughout the world. It contains a number of functions for editing and formatting of text. Function of a Word Processor A word processor like ms word contains following types of functions. 1. Creating documents 2. Editing documents 3. Moving and copying text 4. Find ad replace feature 5. Preview and printing document 6. Proofreading documents 7. Formatting of documents 8. Applying graphics to documents 9. Inserting tables, images, and geometrical shapes 10. Web-publishing of documents Examples 4. WordStar 5. Word Perfect 6. Ms-Word Q2. Write a short note on spreadsheet? A spreadsheet is application software which facilitates the user to represent and manipulate text and numeric data in tabular form. Explanation Spreadsheet software represents the data in tabular form on which mathematical and business calculation can be applied. A spreadsheet contains a number of commands in the form of formulas and functions for the evaluation of data. A spreadsheet contains rows and columns. A cell is created by the intersection of row and column each cell in a spread sheet is identified by its own unique cell address. Features In a spreadsheet data can be entered in a cell in the following forms; 1. Data can be entered in the form of numbers on which evaluation can be applied. 2. Data can be entered in the form of labels which are just captions or headings or title for the data. 3. Data can be entered in the form of mathematical formulas. 4. Data can be entered in the form of mathematical, statistical or business functions. Functions of a Spreadsheet Most of the spreadsheet packages includes the following types of functions; 1. Mathematical: Function that does fairly simple calculations on numerical values, 2. Statistical: Function that perform calculation on lists of values 3. Business: Function that performs common business calculation on involving loans, investment and cash flows. 4. Text: Function that manipulate labels and parts of labels. 5. Data and time; Function that return dates and times in various formats. Page 104 of 157 VER: 04.

[Audio] 6. Logical: Function that allows you to compare values in cells and performs different actions based on the results of those comparisons. 7. Trigonometric: Function that deals with angles and triangle. 8. Logarithmic: Function that deals with exponents and powers for scientific and engineering calculation. Examples Some common examples of these types of function are providing which are included in many spreadsheet programs. Mathematical Functions ABS Computes the absolute value of a number. INT Returns the integar (whole number) part of a number. Computes the remainder (modules) of a division MOD operation. Gives a random number between 0&1. RAND Rounds a value to a given number of decimal places. ROND Computes the square root of a number. SQRT Computes the sum of a list of value. SUM Statistical Functions AVERAGE Computes the average of a list of values. COUNT Computes the number of entries in a list of value MAX Returns the largest value in a list of values. MIN Returns the smallest value in a list of values. STO Computes the standard deviation of a list of values. Computes the various of a list value. VAR Date and Time Functions DATE Returns a code number representing the given date. TIME Returns a code number representing the given time of a day NOW Returns a code number representing the current date and time. Page 105 of 157 VER: 04.