Computer Science IX (English).pdf

TE ST ED IT IO N THE TEXTBOOK OF COMPUTER SCIENCE For Grade 9 SINDH TEXTBOOK BOARD, JAMSHORO  N...

TE ST ED IT IO N THE TEXTBOOK OF COMPUTER SCIENCE For Grade 9 SINDH TEXTBOOK BOARD, JAMSHORO  N IO IT ED ST TE THE TEXTBOOK OF COMPUTER SCIENCE For Grade 9 SINDH TEXTBOOK BOARD, JAMSHORO  All rights are reserved with the SINDH TEXTBOOK, BOARD, JAMSHORO. Prepared by ASSOCIATION FOR ACADEMIC QUALITY (AFAQ) for SINDH TEXT BOOK BOARD JAMSHORO. Reviewed by Provincial Review Committee Directorate of Curriculum Assessment and Research Sindh Jamshoro (DCAR). Prescribed as a Textbook by the Boards of Intermediate and secondary Education, Karachi, Hyderbad, Sukkur, Larkana and Mirpurkhas for Secondary School Certificate Examination in the Province of Sindh. Approved by the Education and Literacy Department, Government of Sindh. No. SED/HCW/181/2018 Dated 22-7-2020 for the province of Sindh. Patron in Chief Ahmed Bux Narejo Chairman, Sindh Textbook Board. Shahid Warsi Khawaja Asif Mushtaq Managing Director Project Director Association For Academic Quality (AFAQ) Association For Academic Quality (AFAQ) Rafi Mustafa Yousuf Ahmed Shaikh Project Manager Cheif Supervisor Association For Academic Quality (AFAQ) Sindh Textbook Board. AUTHORS REVIEWERS Ms. Zufishan Kamal Mr. Abdul Majeed Bhurt Mr. Ajmal Saeed Professor (Retd.) Muhammad Zahid Shaikh Mr. Imran Pathan Mr. Hanif Ahsan Zubedi Mr. Amjad Ali Yousuf Zai Mr. Mushtaque Ahmed Ansari EDITORS TECHNICAL ASSISTANCE CO-ORDINATOR Mr. Nazir Ahmed Shaikh Mr. M. Arslan Shafaat Gaddi COMPOSING DESIGNING & ILLUSTRATION Department of Designing & Illustration Association For Academic Quality (AFAQ) Printed at:  PREFACE The New Textbook of Computer Science for Grade 9 is in your hand. This book is written on the Reviewed Curriculum of Computer Science 2018 by Directorate of Curriculum, Assessment and Research Sindh, Jamshoro. It took some time to develop and publish this book. No doubt that Textbook of Computer should be revised frequently and this is what STBB commits now with all the stakeholders. I hope that this book will be helpful for teachers to impart latest knowledge and skills in students. This book will meet the diverse needs of students at large. Computer Science Textbook discourages rote learning and promotes performance based skill development for students. Readers of this book will find and appreciate the rigorous effort to promote critical thinking, creativity, analysis and self-learning. The world is changing rapidly. To compete with the world we need to equip our youth with IT skills. Teachers bear this responsibility and do their best to offer academic excellence. This textbook will be a great tool for teachers in this regard. Our organization is indebted to all the Authors and Reviewers of this book who made rigorous efforts to deliver a book that is competitive with any other textbook at this level. We encourage teachers, students, parents, researchers and all the stakeholders to give their feedback and suggestion to further improve this book. Chairman Sindh Textbook Board, Jamshoro  About the Book The new textbook of Computer Science is for Grade 9 holds some important features. This book is aligned with the Curriculum of Computer Science (2018) reviewed by Directorate of Curriculum, Assessment and Research Sindh Jamshoro. To provide better experience of teaching and learning there are some important things which are included in this book. A Textbook is a means to achieve the standards and benchmark that are set in curriculum. The standards and benchmarks are described in curriculum through Students Learning Outcomes (SLOs). SLOs SLOs are measureable instructional goals established for a specic group of students over a set period of time. The formative and summative assessments should be Teacher based on SLOs. Since in many institutions teachers Note and students do not have access to curriculum, therefore SLOs are given in each unit. Teacher Note: Teachers are given some guidelines in this textbook wherever needed. This guideline will express how teachers are expected to teach a specic concept. The exercises in this book discourage rote learning. Many questions are inquiry EXERCISE based. Teachers are expected to facilitate students to nd the answers and accept and appreciate the variety of answers as far as they address the questions. At the end of each chapter, activities are ACTIVITIES given in this textbook. The purpose of these activities is to inculcate skills and attitude in students to propel self- learning. These activities will challenge WEBLINKS/ students to learn unconventionally. WEBSITES In our context, students often cannot buy additional reference books. However, in this era of technology, students and teachers can access internet at very low cost. Therefore, the readers can nd weblinks at the end of this book for further reading and understanding of any concept given in this book.  CONTENTS Unit Page No. Description No. 1. Fundamentals of Computer 1 2. Fundamentals of Operating System 30 3. Office Automation 46 Data Communication and Computer 4. 65 Networks 5. Computer Security and Ethics 95 6. Web Development 117 7. Introduction to Database System 142 FUNDAMENTALS OF COMPUTER Unit 1 First Generation Second Generation ird Generation Fifth Generation Fourth Generation  2 SLOs Ÿ Demonstrate the understanding about the history of computers Ÿ Outline the various generations of computers Ÿ Classify the computers as per their size and technology used to date 1.1 INTRODUCTION TO COMPUTER 1.1 A computer is an electronic data processing machine or device that performs processes, calculations and operations based on instructions provided by a program. Computers are now used vastly in every field of life. The advancement in computer caused advancement in knowledge, science and technology. Today, computers are used in fields of business, industry, education, banking, transportation, research, explorations, media, entertainment , etc. 1.1.1 Evolution Of Computers The computers which we see today are modern shape of computers which have been evolved since centuries. The evolution of computers is generally divided in following three eras. (i) Mechanical Era (Dark Age) Men have been trying to invent machines that can solve mathematical problems. In mechanical era, human became successful to make simple machines that could help performing simple arithmetic operation, in other words computing. These machines were manually operated since the electricity was not invented. Some of the important machines of this era are: (a) Abacus (3000 B.C.) Abacus was invented about 5000 years ago. It is also known as counting frame. Abacus is still used to teach basic arithmetic operations to the students. Abacus is considered as first computer prototype. Fig: 1.1 Abacus  3 (b) Napier's Bones (1612 A.D.) Scottish mathematician John Napier developed Napier's Bones, in 1612.It is also called Napier's Rods. It was a small machine that contained ten rods. The rods were made up of bones, wood or metal. Napier's Bones was used for multiplication and division. Fig: 1.2 Napier’s Bones (c) Slide Rule (1622 A.D.) English mathematician William Oughtred invented a Slide Rule. This was basically a pair of two moveable rules placed side by side. They had a standardized set of markings called scales. These scales were used for mathematical computations. Slide Rule was used to multiply and divide numbers. Fig: 1.3 Slide Rule The modern slide rules are still used in some countries. (d) Pascaline or Pascal's Calculator (1642 A.D.) French mathematician Blaise Pascal invented a mechanical calculator which was called Pascaline. He developed this machine to help his father who was a tax collector. Pascaline can perform addition and subtraction by eight figures. User had to adjust wheels in order to perform these Fig: 1.4 Pascaline calculations. (e) Leibniz's Calculator (1694 A.D.) Leibniz's Calculator was developed by the German mathematician Gottfried Wilhelm Leibniz. It was also called stepped reckoner. It was the first calculator that could perform all four basic arithmetic Fig: 1.5 Leibniz Calculator operations; addition, subtraction, multiplication and division.  4 (f) Babbage's Difference and Analytical Engines (1822 and 1837 A.D.) Charles Babbage was an English mathematician and mechanical engineer. He is known as Father of Computer because he developed the first complete computing machine. His first invention was Difference Engine. It was an automatic mechanical calculator. Difference Engine was a large machine, made of metal and was powered by steam. The Difference Engine had storage (mechanical memory) that could hold the data temporarily for processing and to store results. It was used to allow a user to enter calculations and get printed results. The Difference Engine worked on difference equations. Then, Charles Babbage designed but could not build a very big machine in 1837. This was named Analytical Engine. The proposed design included an ALU with basic programmatic flow control. It was programmed using punched cards and contained integrated memory. Historians consider it to be the first design concept of a general-purpose computer because of its comprehensive design. Fig: 1.6 Babbage’s Difference Engine Fig: 1.7 Babbage’s Analytical Engine (ii) Electro-Mechanical Era (Middle Age) This era starts from the mid of 19th century. In this era scientists became able to develop faster and more accurate computing machines as they were powered by steam and electricity. One of such machines was Tabulating Machine.  5 (a) Herman Hollerith's Tabulating Machine (1890 A.D.) It was invented by American inventor Herman Hollerith in 1890.Hollerith's first tabulator was used for the U.S. 1890 Census. Because of Hollerith's tabulating machine census data took only six months to compile, which was very fast as compared to previous U.S. census in 1880 which took 7 years to be completed. Hollerith Tabulating Machine became very famous and used in many offices of U.S. Government. Fig: 1.8 Tabulating Machine (iii) Electronic Era (Modern Age) The advancement in the vacuum or electron tube gave birth to the electronic era. In this era the true computers were invented which worked on the principle of input, store, process and output. Continuous advancement in electronic engineering increased efficiency and speed of computers considerably. The electronic era may be categorized in generations on the basis of core technology used to build computers. (a) First Generation of Computers (1940 to1956) Based on vacuum tubes, first generation computers were very large in size. This generation computers used machine language (i.e. 1's and 0's).Magnetic drums were used as primary internal storage medium and punched cards for input. In this generation mainly batch processing operating system was used. Computers of this generation were primarily used for scientific and research purposes. Electronic Numerical Integrator and Calculator (ENIAC), Universal Automatic Computer (UNIVAC) are examples of first generation Fig: 1.9 Vacuum Tubes computers.  6 (b) Second Generation of Computers (1956 to 1963) Because of transistors computers became smaller, faster, cheaper and more efficient. Assembly language and a high-level language FORTRAN were introduced. Magnetic core was used as primary internal storage medium. Punched Cards were used for input. Batch processing and Multiprogramming Operating systems were used. These computers were mainly used for commercial productions, scientific and engineering analysis and design. Examples are IBM 7094 and IBM 1401. Fig: 1.10 Transistors (c) Third Generation of Computers (1964 to 1971) Use of ICs further decreased size of computers and increased the speed and efficiency. Less expensive computers were introduced. High level programming languages such as Pascal and COBOL were used. Keyboard as input and monitor as output also eased the use of computer. Time-sharing and Realtime Operating Systems were used. The use of computers was extended to Fig: 1.11 Integrated Circuits (ICs) database management and automatic industrial control. IBM 360 and IBM 370 are the examples of this generation's computers. (d) Fourth Generation of Computers (1971 to Present) The invention of microprocessors was revolutionary which caused the development of faster, less expensive, smaller and more reliable computers. They used semi-conductor memories RAM and ROM and magnetic storage became popular. More high-level languages were introduced like C, C++, Java, etc. These computers are used in almost every field of life, like space applications, business and art work. Fig: 1.12 Microprocessors  7 Time sharing, real time and distributed operating system are used. This generation also saw the development of Graphical User Interfaces (GUIs). Examples are Apple Macintosh, IBM PC. (e) Fifth Generation of Computers (Present and Beyond) Fifth Generation computing devices are still being developed. In this generation computers will be capable of self- learning, reasoning and generalization. These computers or controlled machines like robot will also be able to process human languages. The branches of AI include; Machine Learning, Deep Learning. Natural Language Processing, Robotics and Expert Systems. Fig: 1.13 Humanoid Robot 1.1.2 Classification Of Computers Computers can be classified into different ways as shown below: Classification of Computers Technology/ Type of Purpose Size Data Handled Super General Analog Computer Purpose Mainframe Special Digital Computer Purpose Mini Hybrid Computer Micro Computer  8 (i) According to Technology According to technology or type of data they handle, computers are classified into three types. (a) Analog Computers Analog Computers are used to process analog data. Analog data are in the form of continuously varying physical quantities like pressure, temperature, voltage, speed and weight. Examples of Analog computer are speedometer of a car, voltmeter etc. Fig: 1.14 Analog Computer (b) Digital Computers Digital Computers are most commonly used type of computers. They are used to process information with quantities using the binary number system (0's and 1's). Digital Computers are used in home, educational institutes, offices, business, scientific fields, etc. Fig: 1.15 Digital Computer (c) Hybrid Computers Hybrid Computers are the combination of Analog and Digital Computer system. These computers combine analog and digital features of computers in a single machine. A Hybrid Computer uses analog to digital and digital to analog conversion. It may input or output either digital or analog data. Fig: 1.16 VA Meter (ii) According to Size Computers are also divided into four groups according to their size. (a) Super Computers Super Computers are the most powerful, fastest and largest computers. They are extremely expensive. These computers are widely  9 used in scientific applications such as aerodynamics, design simulations, processing of geological data, weather forecasting and nuclear research. (b) Mainframe Mainframe Computers are powerful multi-user and multi- processors computers. They can process huge amount of calculations at very high speed. Mainframes are also very expensive and require a lot of technical expertise to be installed and operated. They are used in banks and many large business organizations where several users work simultaneously. (c) Minicomputer These are smaller than mainframe computers, but they are more powerful than Microcomputers. Minicomputers usually use multi-user operating system. Multiple users can use the Minicomputers through terminals. Minicomputers may be used as network servers and Internet servers. DEC VAX and IBM AS/400 are good examples of minicomputers. (d) Microcomputers Microcomputers are also called Personal Computers (PCs). The use of microprocessor has made computers cheaper yet faster and more reliable. These are the smallest computers designed to be used by individuals. PCs can be used for variety of tasks like documentation, calculations, illustration and entertainment. The power of network and internet has also made it more useful. Now computers are also used for communication and socialization. (iii) According to Purpose According to purpose, computers are either general purpose or special purpose. (a) General Purpose Computers Most computers in use today are General Purpose Computers. These computers can process variety of tasks. These computers can store and execute different programs in their memory. Therefore, various tasks like word processing (typing & editing), payrolls, accounts, inventory  10 control, manipulating facts in a database, making scientific calculations and statistical data analysis, and controlling security system of an organizations are achieved by these computers. Desktops, laptops, tablets and smart phones are examples of General Purpose Computers. Fig: 1.17 General Purpose (b) Special Purpose Computers Computer As the name states, Special Purpose Computers are designed to perform specific tasks. Special Purpose Computers repeatedly perform single job more efficiently. They are also known as Dedicated Computers. These computers are useful in traffic lights control system, navigational system, aviation, weather Fig: 1.18 Computerized forecasting, satellite tracking and ATMs. Wheel Alignment Machine Ÿ Explain the uses of computers in different fields of SLOs life. Ÿ Discuss how computer is affecting our lifestyle by providing variety of choices for entertainment and day to day tasks. Ÿ Tell about scope of the different careers in IT sector. 1.2 ROLE OF COMPUTER 1.2 The role of computer in our lives is increasing day by day. In this section, we will discuss different aspects of the changing role of computer. 1.2.1 Computers In Different Fields Of Life We are living today in the information era and the information has become one of the most valuable assets. To process this information, we make use of computers in various fields in our daily life. Computers have been integrated in our life in different shapes and sizes like desktops, laptops, mobile phones, gaming consoles and smart devices. Our lives have become so dependent of computers that we cannot work even a single day without the help of it. We have automated many of the repetitive tasks with the help of more advanced, faster and accurate computers and  11 brought our routine tasks, office works, businesses, researches and industrial applications to a new level. Computers are largely used in every field of life. Manufacturing, ecommerce, education, medical, banking, communication, entertainment, engineering, agriculture, architecture, business, defense, Fig: 1.19 Radiology computer and sports are highly influenced by computers. Computers Today and Tomorrow 21st century is the era of technological revolution. Previously, technology was only used to access and share information. However, with the passage of time, the rapid change in technology has made it nearly impossible to perform any human activity without its use. Computers are playing an important part in our daily life. News, weather updates, travelling information and bookings, money transfer and even taxi bookings are done with the help of mobile phone apps. Many managerial tasks are also done by computer software. School, library and hospital management are some examples. Online shopping is becoming a trend in our society too. Computers are also providing variety of choices for entertainment like online games in which players from different parts of the world can participate simultaneously. 3D graphical software has given a new look to movies in which different comic characters can act with human actors. Photo, sound and video editor software not only help artists and singers to produce extraordinary creations but also inexperienced people can enjoy their productivity with ease of use. The emerging technologies are also getting better day by day and we can imagine that how computer will be used in future. Artificial Intelligence, Robotics, Wireless Communication and Virtual Realities are some areas which are shaping the modern world.  12 Artificial Intelligence is based on simulating human intelligence in machines that can easily mimic and execute tasks from simple to more complex operations. The term A.I. may also be referred to any machine that displays qualities associated with a human brain such as learning, reasoning and problem solving. A.I. is also used for Machine Learning. It learns from our daily routines and suggests us different options. Like google maps suggest the best ways for our daily commute. A.I. is vastly used in scientific experiment, healthcare and space technologies. Robots are the machines that can be controlled by a computer and are capable of carrying out a complex series of actions automatically. Robots can be controlled by an external control device or through programming. Robotics deals with designing, creating and programming of the robot and enhancing it by taking sensory feedback and processing information. Robots are commonly used in manufacturing, industry, science, medicine and education. Wireless Communication has become an integral part of our lives. Wireless communication technology transmits information using electromagnetic waves like IR (Infrared), RF (Radio Frequency), satellite, etc. Global Positioning System (GPS) is now used to find real time location of people and objects. Smart phones that include 3G, 4G and 5G networks have transformed the conventional use of telephones. These phones not only provide better coverage but also fast mobile internet experience. Wireless communication is also giving new meaning to the socialization and human interactivity. Virtual Reality is an artificial environment that is created with software and presented to the user in a way that the user feels it as a real environment. Virtual reality can be used for the simulation of a real environment for training and education. It is also used for development of an imagined environment for a game or interactive story. Teacher It is very important to orient students about the Note contemporary and upcoming technologies. Teachers may show videos on smartphone or projectors for better understanding of students, in this regard.  13 1.2.2 Careers In IT Field Today Computer Science plays a key role in all fields of life. Computer Science (CS) jobs are ranked as having some of the highest salaries in the world. It's no surprise that Computer Science and Information Technology (IT) are changing tomorrow's job market. Let's look at different careers that are present in the IT sector. (i) Software Engineer A Software Engineer is a person who uses different programming languages to develop software products like games, Learning Management System (LMS), business applications, educational and entertainment software. (ii) Network Administrator Network Administrator is an IT expert who manages an organization’s network. He or She is responsible for installing, maintaining and upgrading any software or hardware required to efficiently run a computer network. (iii) Database Administrator A Database Administrator (also known as DBA) is a skilled professional who maintains a secure database environment in an office, business or organization. (iv) Web Designer Web is short for World Wide Web or www. This is another name for internet. Web designers are people who build websites. They prepare a site's content with eye-catching designs, attractive images and strong text. They rely on many web designing tools to ensure an interactive website. How the site works and how it looks is the responsibility of web designers. They are also responsible for maintaining and updating an existing site. (v) Graphic Designer Graphic is another word for image. Graphics Designers develop overall layouts of brochures, magazines and other types of published  14 advertisements and documents. They do this by using various computer graphics software. This task is usually accomplished by combining art and technology, conveying ideas through images, layout of websites and printed matter. (vi) Information Security Analyst These people protect networks. They plan and carry out security measures to ensure that no loss of data (or information) occurs. We can call them the police force of the internet. Computer technology has expanded into online banking and businesses. Computer hackers are always on the lookout for customer account details that they can use to steal money. Information Security Analysts ensure that no such theft occurs. (vii) Computer Science or IT Teacher Another very rewarding career for Computer Science graduates and post-graduates is teaching in schools, colleges and universities. These instructors instill in their students the importance of computers in today's world, and the impact these machines will have in their later lives. Ÿ Describe computer hardware Ÿ Explain the function of different parts of system SLOs unit like: Motherboard, Processor Ÿ Differentiate between various input devices Ÿ Recognize different output devices Ÿ Differentiate between Primary and Secondary memory Ÿ Classify different hardware devices as per their functionality 1.3 COMPUTER HARDWARE Computers consist of software and hardware. Software is the programs and applications that run on computer. Hardware is the physical parts of the computer that run programs and applications. Hardware can be seen and touched while software cannot. Computer hardware is a collection of all the physical parts or components of a computer. It includes the computer casing, the CPU or Central Processing Unit, computer memory, VGA graphics card, sound card, and the motherboard.  15 1.3.1 System Unit A System Unit is the part of a computer that contains the primary devices. The system unit performs operations and produces results for complex calculations. It includes the motherboard, CPU, RAM and other components, as well as the case in which these devices are enclosed. (i) Motherboard The motherboard is the main board which connects different parts of computer. It includes the following general components: Microprocessor (CPU), Slots, Ports, Buses, RAM, ROM and other electronic components for example resistors, capacitors, diodes, transistors, jumpers etc. Fig: 1.20 Motherboard Just like nervous system it allows communication between all parts of the computer. We can find CPU, memory slots, expansion slots and a number of chipsets on motherboard. Motherboards are made of layered fiberglass. These layers contain copper lines that form the circuitry by which electrical signals are provided to all parts of computer. Various components of computer may be attached, detached and upgraded on motherboard according to need of the user. Motherboards also have connectors called ports. These ports are used to connect input, output and other peripheral devices. Teacher Uncover the casing of computer and demonstrate different Note parts on and attached with motherboard. Ask students to write names and functions of the components.  16 (ii) Microprocessor (CPU) CPU or microprocessor is the brain of computer. The microprocessor is a chip containing millions of tiny transistors. These transistors manipulate data. Microprocessor performs all the calculations necessary to make the computer work. These calculations are performed at very high speed and accuracy. Microprocessor is made up of silicon. The microprocessor fetches, decodes, executes and Fig: 1.21 Microprocessor stores all the instructions given by the user or any other device. The speed of computer mainly depends upon the speed of microprocessor. A microprocessor that has faster clock speed (measured in GHz) and more cores and cache works faster. There are typically five components of a microprocessor. (a) Arithmetic Logic Unit (ALU) ALU performs all the actual calculations like arithmetic operations and logical comparisons. Arithmetic operations include addition, subtraction, multiplication and division while logical comparisons include comparing, selecting and matching of data. (b) Control Unit (CU) Control Unit is responsible for controlling the transfer of data and instructions among other units of a computer. This unit controls the operations of all parts of the computer but does not carry out any actual data processing operations. CU functions just like a traffic policeman. It manages and coordinates all the units of the computer. (c) Clock Clock generates pulses and instructions are executed on the basis of pulses. Clock speed is measure in MHz and GHz.  17 (d) Registers It is a temporary storage area that holds the data that is being processed. It is also known as programming model which may be of 8 bits, 16 bits, 32 bits or 64 bits. (e) Cache Cache is an intermediate storage area, which is available inside microprocessor. The immediate processed information is stored in cache. The cache inside the microprocessor is called internal cache and outside is called external cache. (iii) Buses In computer, Buses are the electric paths on which data is sent and received by different components. They are just like roads. As roads connect different places, buses connect all the parts of the computer to each other. They also connect all internal components on the motherboard. There are three types of buses; control bus, data bus and address bus. Control Bus carries command between different components to control all activities in a computer. Data Bus carries data between the processor, memory unit and other components. Address Bus carries the address of the data (but not the data).The address bus is used to specify memory location to be used by microprocess for specific operaation. 1.3.2 Input Devices Input devices are used to enter data into computers. These devices can be categorized into Text Entering, Pointing and Image Scanning Devices. (i) Text Entering Devices Keyboard: It is the most common text entering device and used to enter data usually in text format or to perform other controlling functions.  18 When a key is pressed, keyboard controller chip sends its corresponding code in keyboard buffer called scan code, which is then processed by CPU. (ii) Pointing Devices (Mouse and its variants) They are used for the quick movement of cursor on screen needed usually in graphic mode. It includes mouse, joy stick, track ball and track pad. (iii) Image Scanners Scanners convert image into electronic format understandable by computers through light sensing. They also work on Optical Recognition which occurs when a device scans a clear printed surface and translates the image into machine-readable formats that a computer understands. Image scanners include Optical Mark Recognition (OMR), Optical Barcode Reader (OBR) and Optical Character Recognition (OCR). (iv) Other Types of Input devices There are also other input devices. For example, microphones are used to accept sound input and convert it in digital audio format. Microphones are also used for voice recognition which can convert voice input into text files. Touch Screen is also used for input. It accepts input directly on monitor by touching finger or any object on the screen. Magnetic Ink Character Recognition (MICR) and Magnetic Strip Reader are also used for input. 1.3.3 Output Devices A hardware device that sends data from a computer (CPU) to another device or user is called an output device. The most common output devices of a computer are monitor and printer. There are two types of output devices. (i) Soft Copy Output Devices It is screen display or voice output. It is volatile output and lost when other output is shown or computer is turned off. Following are some of the devices used to give output in soft form.  19 (a) Monitors It is TV like device that displays data by small bright dots called pixels. Monitors are of two types. Ÿ Cathode Ray Tube (CRT) Ÿ Flat Panel Display (FDP) (b) Data Projectors Data projectors are used to show colorful slides and images directly from computer disk on a wall or large screen through an optical lens. They are also called digital light projectors and video projectors. (c) Speakers Speakers give output in form of sound. They are good for people with visual disabilities or where display is not easy. (ii) Hard Copy Output Devices It is output on paper. It is nonvolatile output that is relatively stable and permanent form. Hard Copy Output Devices are: (a) Printers They usually give output on paper and can print both text and graphics. There are two types of printers: Ÿ Impact Ÿ Non-Impact (b) Plotters Like printer it gives images on paper but typically used to print large format images such as maps, construction drawing, advertising hoardings etc. 1.3.4 Storage Devices A storage device refers to a hardware used to store information. There are two types of storage devices; Primary and Secondary.  20 (i) Primary Storage Devices Primary storage devices are used by computer during processing. They are quite smaller in storage capacity. Most primary storage devices are found inside the computer, and they have the fastest access to data. Primary devices include RAM and ROM. ROM is the Read Only Memory. It is permanent memory. ROM is quite small in capacity. It stores the major setting of computer permanently. RAM is Random Access Memory. RAM is volatile, means it loses its content as the power supply is disconnected. This is used to store data and instructions temporarily. (ii) Secondary Storage Devices Secondary storage devices have a larger storage capacity and can store data permanently. Users save their data on secondary storage devices. Hard Disk, CD and DVD, SD Card and USB flash disk are the examples of secondary storage devices. SLOs Ÿ Understand the basic operations of computer Ÿ Differentiate among the four basic operations of computer Ÿ Draw the block diagram of computer's basic operations 1.4 BASIC OPERATIONS OF A COMPUTER A computer is a machine that acts according to the instructions given by the user. A computer performs four basic operations: input, processing, output and storage. (i) Input Computer input has many forms. It can be from a command entered using a keyboard or a mouse. It can be data sent from another computer on a network. (ii) Processing Processing is done inside the computer by CPU. Processing is the conversion of input into output. After processing, data is turned into meaningful information. This is carried out with the help of arithmetic and logical operations.  21 (iii) Storage Storage refers to the holding or saving data. RAM, ROM and Hard Disk are the devices that are used for storage. (iv) Output Output is the result of a computer processing. Output may be viewed on a monitor screen, heard through speakers or printed on paper. Here, monitor screen, speakers and printer are called output devices. SLOs Ÿ Develop the understanding about computer software Ÿ Recognize various types of system software Ÿ List out the names of different application software Ÿ Differentiate between application software and system software 1.5 COMPUTER SOFTWARE Software is a set of instructions that a computer uses to perform a task. It is a general term for a computer program. There are two main types of software; System Software and Application Software. 1.5.1 System Software System software is a computer program that coordinates all activities and functions of a computer. It also controls all the operations of the computer hardware. It includes operating systems, device drivers, utility programs and language translators. (i) Operating System Operating system is the master control program that manages all the system resources. It creates an interface between computer system and user. Windows and Linux are commonly used operating systems. (ii) Device Drivers Device drivers are computer programs that control a particular device when it is connected to a computer. Any hardware that we have in our computer must have a device driver to communicate with operating  22 system. A device driver is a translator between the operating system and the hardware device. For many devices, operating system has drivers pre- installed in them. This gave rise to the concept of Plug and Play, where the device would be attached to the computer and the operating system will instantly recognize it. A non-plug-and-play device would require you to go through several steps of installing drivers and setting up the device before it would work. (iii) Utility Programs Utility means being useful. Utility programs are useful computer programs that help to manage, maintain and control computer resources. Operating systems usually have pre-installed programs that can serve the purpose, but utility software provides further functionality. One example of utility program is an antivirus software. This computer program helps to protect a computer from viruses and other harmful files. Hard Disk tools are also part of utility programs. They manage hard disk drives and other storage devices. This includes utilities to scan the hard disks for any potential problems. Disk cleaner utility is used to remove any unnecessary files while disk defragmenter is used to re- organize file on a hard disk drive to increase performance of disk. (iv) Language Translators Language Translators are used to translate human readable instructions into machine language. Computer can only understand machine language which is composed of 0's and 1's. The computer languages are used to make computer programs (software). Generally, software is written in high-level languages, using natural language words. Language translator are of three types; assembler, compiler and interpreter. Teacher Teachers are suggested to demonstrate how to configure/ Note install device drivers and use utility programs like Disk Defragmenter, Disk Cleaner etc.  23 (a) Assembler: The assembler translates the program written in assembly language into machine language instructions for execution. (b) Compiler: It translates the entire high-level language program at once into machine language before it is executed. (c) Interpreter: It translates the high-level language program line by line into machine language. 1.5.2 Application Software Application Software is used to complete specific tasks, such as creating documents, databases, spreadsheets and presentations. Computer games, media players and web browsers are also the examples of application software. User needs to install application software to accomplish specific tasks. Application software are not pre-installed on operating system. They are installed separately. For example, making spreadsheet is not possible with Windows. For that application software such as MS Excel is used. There are different types of application software. (i) Productivity Software This kind of application software is used to produce things such as documents, spreadsheets, databases and presentations. Many of the productivity software are intended to be used in businesses and offices. MS Office for Windows is an example of productivity software. (ii) Business Software Business Software are used to manage business activities efficiently. It is used to provide many business functions such as billing, database management and inventory management. (iii) Entertainment Software This type of software provides amusement and fulfills a user's hobby. The most common entertainment software are video games. (iv) Educational Software Educational software is used for teaching and learning. This kind of software is used in many schools to enhance knowledge of students in learning different subjects.  24 SUMMARY w A computer is an electronic data processing machine or device that performs processing, calculations and operations based on instructions provided by a software or program. w The evolution of computers is generally divided in three eras like Mechanical era, Electro-mechanical era, Electronic era. w First Generation of Computers (1940 to1956): Technology Used: Vacuum Tubes. w Second Generation of Computers (1956 to 1963): Technology Used: Transistors. w Third Generation of Computers (1964 to 1971): Technology Used: Integrated Circuits (ICs). w Fourth Generation of Computers (1971 to Present): Technology Used: Microprocessors. w Fifth Generation of Computers (Present and Beyond): Technology Used: Articial Intelligence Technology. w Computers are classied in three types according to technology like Analog Computers, Digital Computers and Hybrid Computers. w Digital Computers are further divided into four groups according to their size like Super Computers, Mainframe Computers, Minicomputers and Microcomputers. w According to purpose; computers are either General Purpose or Specic Purpose. w Different careers are present in the IT sector like Software Engineer, Network Administrator, Database Administrator, Web Designer, Graphic Designer, Information Security Analyst, Computer Science or IT Teacher. w Computers consist of software and hardware. w Software is set of instructions or a program. w Computer hardware is a collection of all the physical parts or components of a computer. w A system unit includes the motherboard, CPU, RAM and other components, as well as the case in which these devices are housed.  25 w The motherboard is the main board which connects different parts of computer. It includes the following general components: Microprocessor (CPU), Slots, Ports, Buses, RAM, ROM, other electronic components for example resisters, capacitors, diodes, transistors, jumpers, etc. w There are typically ve components of a microprocessor (CPU); Arithmetic Logic Unit (ALU), Control Unit (CU), Clock, Registers and Cache. w Clock generates pulses and instructions are executed on the bases of pulses. Clock speed is measured in MHz and GHz. w Register is a temporary storage area known as programming model of 8 bits, 16 bits, 32 bits and 64 bits. Registers are visible as well as invisible on the microprocessor. w Cache is an intermediate storage area, which is available inside microprocessor IC known as internal cache and outside microprocessor IC known as external cache. w CPU has three buses; control bus, data bus and address bus. w The most common input devices of a computer are keyboard and mouse. w The most common output devices of a computer are monitor and printer. w There are two types of storage devices; Primary and Secondary. w Primary storage devices include RAM and ROM w A secondary storage device like hard disk has a larger storage capacity and can store data permanently. w A computer performs four basic operations: input, processing, output and storage. w System software includes operating systems, device drivers, utility programs and language translators. w Language translators are of three types; assembler, compiler and interpreter. w Different types of application software are Productivity Software, Business Software, Entertainment Software, and Educational Software.  26 EXERCISE A. Choose the right answer: 1. The device that converts hard copy into soft copy is: a) printer b) plotter c) scanner d) barcode reader 2. The volatile memory a) is permanent b) loses contents as the power is disconnected c) possesses large storage d) manages hardware resources 3. Media players are: a) business software b) education software c) entertainment software d) productivity software 4. The programs that are generally installed to manage and maintain overall computer resources is: a) operating system b) utility program c) language translator d) device driver 5. Modern languages use a) compiler b) interpreter c) convertor d) assembler 6. A collection of wires connecting the CPU with main memory that is used to identify particular locations is: a) control bus b) data bus c) address bus d) memory bus 7. The inexpensive and most commonly used computers are: a) super computer b) mainframe computer c) minicomputer d) microcomputer 8. Computer cannot start without: a) operating system b) utility program c) device drivers d) business software  27 9. Graphical User Interface (GUI) was developed in: a) second generation b) fourth generation c) mechanical era d) electro-mechanical era 10. A person who uses different programming languages to develop programs is: a) database administrator b) web designer c) software engineer d) graphic designer B. Respond the following: 1. Discuss the use of computer in any two elds of life. 2. Differentiate Compiler and Assembler. 3. Differentiate System and Application software. 4. Describe articial intelligence with examples. 5. Discuss Impact and Non-Impact Printers with examples. 6. Write the use of these storage devices: Hard Disk, USB Flash Disk, SD Card. 7. Which monitor will you prefer in your school; CRT or FPD? Why? 8. List any ve components present on motherboard. 9. Prepare a table of generations. Example of Generation Period Technology Machines First Second Third Forth Fifth  28 10. Give examples of business, education, entertainment and productivity software. S.No. Business Education Entertainment Productivity (i) (ii) (iii) C. Match the columns: S.NO. A S.NO. B C Period of manually (i) ALU (a) operated machines (ii) Input Devices (b) PC Process information (iii) Secondary Storage (c) using binary number Devices system Perform arithmetic and (iv) Productivity Software (d) logical operations Helps to produce (v) Mechanical Era (e) spreadsheets, database etc Large storage capacity, (vi) Digital Computers (f) store data permanently Hardware device that (vii) Microcomputer (g) sends data into a computer  29 ACTIVITIES 1. Develop a timeline for major innovations in computer evolution. 2. Prepare a list of input and output devices and write their uses. 3. Make a list of specications that you should know before buying a computer. 4. List analog, digital and hybrid devices from your surroundings (any ve). 5. Label the following block diagram of computer system. CPU  30 FUNDAMENTALS OF OPERATING SYSTEM Unit 2  31 SLOs Ÿ Dene OS Ÿ Develop the understanding about different functions of OS Ÿ Distinguish among various types of interfaces of OS 2.1 2.1 INTRODUCTION OF OPERATING SYSTEM (OS) An Operating System is a software which performs all the basic tasks like booting the computer, le management, memory management, process management, and controlling peripheral devices such as hard disk, printer, etc. It manages computer resources efciently. Most common operating systems are: DOS, Windows, Linux, Android, Mac OS and iOS. Fig: 2.1 Different Operating Systems 2.1.1 Function Of Operating System Operating system manages every activity of a computer. It is the master control program that provides an interface for a user to communicate with computer. System software and application software run on operating system as shown in gure 2.2. Operating System performs the following functions.  32 (i) Booting User Booting is a process of starting the computer operating system. It checks the computer System Application resources and makes it ready to Software Software perform different tasks. (ii) Resource Management Operating system manages Operating System all the hardware and software resources. This includes allocation and de-allocation of processor, memory, access to shared cache Hardware CPU RAM I/O memory and access to network resources. Fig: 2.2 Operations of an OS (iii) User Interface or Command Interpreter We interact with operating system through user interface. Command interpreter is one of the parts of operating system which reads the commands from user, interprets them and translates them into machine language instructions that the computer hardware can understand. (iv) Memory Management Memory management module performs the task of allocation and de-allocation of memory space to programs and data in need of these resources. (v) Input / Output (I/O) Management An Operating System provides the device driver to facilitate I/O functions involving I/O devices. These device drivers are software that control I/O devices through their controllers.  33 (vi) File Management It manages all the le-related activities such as organization storage, retrieval, naming, sharing, and protection of les. (vii) Process Management A process is a job or activity to be performed by the system. Process management manages creation, deletion, suspension and resumption of processes. The term process refers here to program code that has been loaded into a computer's memory for execution by the central processing unit (CPU). In a multiprogramming system, there will be a number of computing processes. The operating system must ensure that each process gets a fair share of the CPU's time. The OS decides the order in which processes have access to the processor, and how much processing time each process should get. This function of OS is called process scheduling. Fig: 2.3 Task Manager  34 (viii) User Management In modern operating systems, user management describes the ability of administrators to control user access to various computer resources like software, I/O devices, storage system, networks, etc. 2.1.2 Types Of Interface An interface is a program that allows a user to interact with the computer or another computer over a network. A User Interface (UI) is the part of operating system, program, or devices that allows a user to enter and receive information. There are many types of User Interfaces. Two most common user interfaces are discussed below: (i) Command Line Interface Fig: 2.4 Command Line Interface (CLI) A Command Line Interface (CLI) is a screen or text based representation in which the user types the commands on place called prompt to operate the computer. Command contains string of characters.CLI is difcult to use because the user has to remember the commands and their syntaxes but it is fast in use because text mode takes less resources.It was primarily provided to users by computer terminals onUNIX, and personal computers including MS-DOS and Apple DOS.  35 (ii) Graphical User Interface (GUI) A GUI provides a user friendly environment where user can interact with computers through graphical objects such as menus, icons, buttons and other graphical objects. It is easy to use as users are supposed to just click on a picture to run commands without memorizing them. GUI is slower than CLI as graphical mode takes more memory and resources. Windows and IOS are the example of GUI. Fig: 2.5 Graphical User Interface (GUI) SLOs Ÿ Discuss different types of OS Ÿ Differentiate among the various types of OS 2.2 TYPES OF OPERATING SYSTEM 2.2 The Operating System can be categorized as under: Ÿ Single User and Multi-User OS Ÿ Batch Processing OS Ÿ Time Sharing OS Ÿ Real Time Processing OS  36 2.2.1 Single User And Multi-user Operating System In a Single User Operating System, a single user can access the computer system at a time. These types of operating systems are commonly used. DOS for PCs and Windows 98 for PCs are example of single user operating system. A Multi-User Operating System allows multiple users to access the computer at same time. The operating system manages the memory and resources among the various users according to the requirement. Linux and UNIX are the most common examples of the multi-user operating system. 2.2.2 Batch Processing Operating System General term of Batch Processing is used for programs that are executed with minimum human interaction. This type of operating system does not interact with the computer directly (Figure 2.5). Each user prepares his job and submits it to the computer operator. To speed up processing; jobs with similar needs are batched together and run as a group by an operator. The main function of a batch processing system is to automatically keep executing the jobs in a batch. The benets of batch processing are: Ÿ Batch systems can be shared by multiple users. Ÿ The idle time for batch system is very less. Ÿ Next job starts just after the current one. User Batch jo s b User job job Operator Computer job User job s job Batch User Fig: 2.6 Batch Processing Operating System  37 2.2.3 Time Sharing Operating System Time sharing is a method that allows multiple users to share resources simultaneously. Multiple users can use specic computer at the same time in different places. A time sharing operating system is that in which from many tasks each task is given some time to execute so that all processes run smoothly without any problem. Multiple jobs are executed by the CPU by switching between them. As the system switches rapidly from one task or user to the other, a short time slot is given to each task or user for their executions and all feel that system is not shared. Thus, the user can receive an immediate response. For example, in a transaction processing, the processor executes each user program in a short time.These systems are also known as Multitasking Systems. The task can be from single user or from different users also. The time that each task gets to execute is called quantum. After this time interval is over OS switches over to next task. User 3 User 2 CPU User 4 User 1 User 5 Fig: 2.7 Time Sharing Operating System 2.2.4 Real Time Processing Operating System (RT OS) A Real Time Processing Operating System is a time bound operating system which has xed time limit. Processing has to be done within the dened time limit otherwise system will be failed. Real Time Process System classied into two parts:  38 Hard Real Time System: A Hard Real Time System guarantees that critical tasks complete on time, even the shortest delay or urgency is not acceptable. Here system should meet the deadline. Missile systems and Air Trafc Control System are best examples of Hard Real Time System. Soft Real Time System: In this time constraint is less strict. The meeting of deadline is not compulsory for each task, every time. A critical real-time task gets priority over other tasks until it completes. It does not guarantee that task will be completed in dened time but before a certain time and according to the priority. Online Transaction System, Airline Ticket Reservation in which reservation could be delayed but should be done after checking available seats and completed before aeroplane ight, etc. are the examples of Soft Real Time System. SLOs Ÿ Apply and demonstrate the installation process of Windows OS and other software in a computer Ÿ Apply installation process of any antivirus in a computer. 2.3 SOFTWARE INSTALLATION 2.3 Software installation is the process of making programs ready for execution. Software installation or installer is a computer program that installs les, such as applications, drivers, or other software, onto a computer. Software is installed onto a computer by various means. They can be downloaded from the internet. They can also be installed from an installation CD or DVD or from a USB ash drive. 2.3.1 Installing Windows Operating System Operating system is the most essential software and there are many operating systems available. Windows is the most commonly used operating system which is developed by Microsoft. Choosing an operating system depends upon the hardware that we have. To maintain compatibility between hardware and software, the operating system vendor species the minimum hardware requirement. For installing Windows 10, we will need at least the following conguration.  39 Processor 1GHz (speed of CPU should be at least 1 Gigahertz) 1GB for 32-bit or 2GB for 64-bit (RAM – Random Memory Acces Memory – a type of computer memory, 32 bit and 64 bit are data units) Storage 32GB (hard disk space should be at least 32 Gigabytes) DirectX 9 or later with WDDM 1.0 driver (graphics card Graphics card is computer hardware that produces images seen on monitor screen) Display 800x600 (computer monitor capability) Major Steps for Installing Windows Ÿ Insert the Windows Installation DVD/Flash Drive Ÿ Restart your Computer Ÿ Wait for the rst startup screen Ÿ Press or hold Del or F2 to enter the BIOS screen Ÿ Locate the Boot order/ Boot sequence Ÿ Select Boot order/ Boot sequence as per your installation source a. USB Flash/USB Hard Disk b. USB CD/DVD ROM c. Internal CD/DVD ROM Ÿ Select any option: a. Upgrade b. Customize Installation (Advance) Ÿ Select any drive for installing your operating system Ÿ Follow the on screen instructions Teacher Ÿ Teachers should focus and reinforce on important Note steps of installation like selection of drive, formatting and deleting drive and other setting. Ÿ Ideally, students should be given a chance to install Windows in groups.  40 2.3.2 Installing Ofce Automation Software Windows is an Operating System which needs to install other software to make the best use of our computer. Ofce Automation software is the most common software package that we install on our computers. Ofce Automation software is a group of computer programs that help users in their daily work. Generally you will nd MS Ofce in school lab, ofces and other places. MS Ofce contains word processor (MS Word), spreadsheet (MS Excel), multimedia presentation (MS PowerPoint), database management system (MS Access) and email application (MS Outlook). In class 9, we will use MS- Word, MS Excel and MS-Access in coming units. Fig: 2.8 Common Programs in MS Ofce To install MS- Ofce package we need to take following steps. Ÿ Run the MS- Ofce setup from USB, DVD or Hard Disk backup. Ÿ Check the box marked 'I accept the terms of this agreement' and click on 'Continue'. Ÿ Enter Product Key Ÿ Click on Install Now or Customize procedure. Ÿ Select the package which you want to install. Click on 'Install Now'. Ÿ Then installation begins. Ÿ MS Ofce installer will notify automatically after nishing the installation.  41 Before installing MS- Ofce, make sure that your hardware and software meet with the minimum requirements for the version of MS- Ofce that you want to install. The minimum requirements may differ from version to version. (For MS- Ofce 2013 the minimum requirements are: 1.6 GHz processor, 1 GB RAM, 3 GB hard disk free space, minimum Windows 7 operating system and graphics driver). 2.3.3 Installing Antivirus To keep our computer secure and free from viruses, we need to install an antivirus software. A number of free antivirus software are available online. AVG, Avast, Avira and Kaspersky are some of the free antivirus software. These days we need to download installation le from respective antivirus software and run it but make sure that computer has the access of internet. After running the installation le, antivirus software will be automatically installed on our computer. Most important component of an antivirus software is the virus database which antivirus software updates time to time. We must update our virus database for preventing virus threats. Ÿ There are 5 lab periods allocated to complete the SLOs of this unit. However, teachers can manage Teacher Note more practical for students and help enhancing their skills to use operating system efciently. Students at this level should be able to manage les and folders and congure simple settings of operating system. Ÿ Teachers are also suggested to demonstrate the installation and conguration process of any hardware driver e.g. printer.  42 SUMMARY w An Operating System is a software which performs all the basic tasks like booting the computer, le management, memory management, process management, and controlling peripheral devices such as hard disk, printer, etc. w Operating System performs the following functions like Booting, Resource Management, User Interface or Command Interpreter, Memory Management, Input / Output Management, File Management, Process Management, User Management. w An interface is a program that allows a user to interact with the computer or another computer over a network like Command Line Interface, Graphical User Interface (GUI). w The Operating Systems have been evolved as Single User and Multi- User OS, Batch Processing OS, Time Sharing OS, Real Time Processing OS. w A single user operating system allows only one user to operate computer at a time. w A Multi-User Operating System allows multiple users to access the computer at same time. w In fact the real time operating system consists of Windows, Linux, etc. w In batch processing operating system each user prepares his job and submits it to the computer operator. w Time sharing is a method that allows multiple users to share resources simultaneously. w A Real Time Processing operating system is a time bound operating system which has xed time limit. w A Hard Real Time System guarantees that critical tasks complete on time. Missile systems and Air Trafc Control System are best examples of Hard Real Time System. w Soft Real Time System does not guarantee that task will be completed in dened time. Online Transaction systems, Airline Ticket Reservation, etc. are the examples of Soft Real Time System. w Software Installation means to put something in a new place, ready to be used.  43 w Ofce Automation Software is a group of computer programs that help ofce workers in their daily work. w MS Ofce 2010 contains MS Word, MS Excel, MS PowerPoint and MS Outlook. w For MS- Ofce 2013 the minimum requirements are: 1.6 GHz processor, 1 GB RAM, 3 GB hard disk, minimum Windows 7 operating system and graphics driver. EXERCISE A. Choose the right answer: 1. The software which performs all basic tasks is: a) antivirus b) start menu c) operating system d) ofce automation 2. A program that enables user to interact with computer is called: a) my document b) start menu c) desktop d) interface 3. The process of checking computer, starting operating system and making it ready to work is referred to as: a) resource management b) booting c) error checking d) le management 4. The number of user(s) that can access the resources simultaneously on a Multiuser OS is /are: a) one b) two c) many d) only administrators 5. Which management controls the dynamic allocation and de-allocation of processor, memory, etc? a) Resource b) File c) I/O d) User 6. In which operating system jobs are executed in groups? a) Batch Processing b) Time Sharing c) Single User d) Real Time  44 7. The system that guarantees that critical tasks should be completed without shortest delay is: a) Batch Processing b) Hard Real Time c) Soft Real Time d) Time Sharing 8. DOS is an example of: a) Real Time Processing OS b) Multi Processing OS c) Single User OS d) Multi User OS 9. The group of programs that helps ofce workers to do a number of routine tasks easily and efciently is called: a) operating system b) e-mail c) anti-virus d) ofce automation 10. The operating system that allows frequent switching from one task to another is: a) Batch Processing b) Real Time Processing c) Single User d) Time Sharing B. Respond the following: 1. Dene Operating System. Give three examples of operating systems. 2. List the functions of an OS? Write briey about any two. 3. Differentiate between CLI and GUI. Write any two benets of each. 4. Which resources are managed by Resource Management function of OS? 5. What is the difference between single user and multi user OS? If you are a manager of a large organization which type of OS will you prefer? Justify your answer with any two reasons. 6. What is the purpose of ofce automation software? With examples, explain how can ofce automation help employees to be productive and efcient? 7. List the programs available in MS Ofce and write why each program is used? 8. What is the major difference between Soft Real Time and Hard Real Time systems? 9. Why it is important to install an antivirus?  45 C. Match the columns: S.NO. A S.NO. B C Time bond operating (i) CLI (a) system (ii) Windows (b) Ofce automation Function of operating (iii) Process (c) system (iv) Ms Excel (d) Operating system Real time processing A job to be performed (v) (e) operating system by the system Input / Output (vi) (f) Interface Management ACTIVITIES 1. Teacher should demonstrate installation process of Ÿ Windows Operating System (feasible version) Ÿ Microsoft Ofce (feasible version) Ÿ Any free antivirus software 2. Students should be given task to make use of antivirus software. 3. Student should observe and work with different Ÿ icons on Windows Desktop Ÿ Start Menu Ÿ Utility Programs available 4. Student should also practice creating, copying, moving and deleting les and folders. 5. Teacher should also demonstrate the Task Manager for explaining Task Management concept. 6. Teacher should also demonstrate the BIOS screen.  46 OFFICE AUTOMATION Unit 3  47 SLOs Ÿ Demonstrate Page Layout Tab of MS Word Ÿ Identify the different groups of Page Layout Tab Ÿ Apply different features available in groups of Page Layout Tab 3.1 3.1 MS WORD Microsoft Word (MS Word) is one of the most famous word-processing software. It was rst released and made public in early 1980s by Microsoft. It allows its user to type text and manipulate it. MS Word rst introduced the concept of WYSIWYG (What You See Is What You Get) by introducing text formatting and document preview exactly as we would get it on a paper. It has advanced features like tables, images, advanced formatting and reviewing that give its users Figure 3.1 the ability to customize their documents as MS Word 2010 required. Even most of this book has been written, edited and formatted on MS Word. Latest versions of MS Word come as a part of Microsoft Ofce Suite (which includes other software as well like MS Excel and MS PowerPoint). MS Word is still most widely used word-processing software in the world. We will be using MS Word 2010 version in this chapter. 3.1.1 Page Layout Tab The Page Layout Tab allows user to control the look and feel of his or her document. User can set margins, apply themes, control page orientation and size, add sections and line breaks, display line numbers, and set paragraph indentation and lines. The Page Layout tab has ve groups of related commands namely Themes, Page Setup, Page Background, Paragraph and Arrange. Figure 3.2 Page Layout tab  48 (i) Themes Group A theme is a predened set of formatting, colors and settings that changes the overall design and look of the entire document. Applying themes to our work gives it a professional look. There are different themes available relevant to the type of document being composed. (ii) Page Setup Group Page Setup settings help us set the page layout properties such as margins, orientation and size. The settings in this section are often applied throughout the document. Margins (HOTKEY: ALT+P+M) A margin is the area or space between the main content of a page and the page edges. This button is used to change the margins of the entire document or selected section. Orientation (HOTKEY: ALT+P+O) Page orientation or print orientation is the placement of contents on a page. This button sets the contents of the page or section in portrait (Vertical) or landscape (Horizontal) layouts. Size (HOTKEY: ALT+P+S+Z) The size button is used to choose the size of the paper for current section or entire document. Columns (HOTKEY: ALT+P+J) This button is used to split the text into two or more vertical columns. Breaks (HOTKEY: ALT+P+B) Breaks button is used to insert page, section or column breaks in the document. Line Numbers (HOTKEY: ALT+P+L+N) This button is used to add line numbers on the left side of each line of the document. Hyphenation (HOTKEY: ALT+P+H) This button is used to specify how hyphenation in a document should be applied.  49 (iii) Page Background Group These settings are used mostly for special documents such as certicates, invitations, brochures, essays, etc. It consists of 3 buttons namely, Watermark, Page Color and Page Borders. Watermark (HOTKEY: ALT+P+P+W) A watermark is a faded background image that displays behind the text in a document. This button is used to insert logos, images or text behind the contents of a page. Page Color (HOTKEY: ALT+P+P+C) This button is used when user wants to apply a color for the background of the page. Page Border (HOTKEY: ALT+P+P+B) Page Border button is used to put a border around the page. (iv) Paragraph Group The Paragraph Group is where we can modify all the settings of the paragraphs that appear in our document. This allows us to set a few basic paragraph styles and also adjust the indents and spacings. Indent Left (HOTKEY: ALT+P+I+L) Indent Left is used to dene amount of blank space (in centimeters) used to separate a paragraph from left margin. Indent Right (HOTKEY: ALT+P+I+R) Indent Right is used to dene amount of blank space (in centimeters) used to separate a paragraph from right margin.  50 Space Before (HOTKEY: ALT+P+S+B) Space Before is used to indicate how much space (in points) is added before the selected paragraph. Space After (HOTKEY: ALT+P+S+A) Space After is used to indicate how much space (in points) is added after the selected paragraph. (v) Arrange Group The buttons in Arrange Group help the users to quickly arrange graphical and other elements of the document in relation to the main textual content. Position (HOTKEY: ALT+P+P+O) Position is used to place an object (picture or shape) on the page wherever you want. Wrap Text (HOTKEY: ALT+P+T+W) Text wrapping is used to arrange the text around an object like an image. Bring Forward (HOTKEY: ALT+P+A+F) Brings a selected object in front of all other objects. Send Backward (HOTKEY: ALT+P+A+E) Sends a selected object behind all other objects. Selection Pane (HOTKEY: ALT+P+A+P) Selection Pane is used to select, show, hide and change the order of objects in the document. Align (HOTKEY: ALT+P+A+A) Align is used to place objects like pictures, shapes, icons, etc. in alignment with margins, edge, or relative to another object in the document.  51 Group (HOTKEY: ALT+P+A+G) Group is used to combine two or more objects together so that they can be treated as a single object. Rotate (HOTKEY: ALT+P+A+Y) Rotate is used to rotate or ip the selected object. SLOs Ÿ Insert manual and automatic table of contents in a document. Ÿ Compose in Urdu and Sindhi languages in MS Word. 3.1.2 Table of Contents (ToC) A Table of Contents (ToC) is an organized listing of the sections, groups and headings of content in a document and identied by page numbers where they are placed. It provides an overview of the document and allows readers to go directly to specic section or content in the document. ToC usually appears after the Title Page in a document. MS Word 2010 provides an advanced feature for automatically creating a ToC. A user can create an Automatic or a Manual table of contents in a document. To create a Table of Contents in MS Word document, go to the References Tab where Table of Contents button appears as the rst option of that tab. MS Word provides several options of creating a ToC that include Automatic Table creation, Manual Table creation or the user can even create a Customized Table of Contents based on the requirements of the document. (i) Automatic Table Automatic Table creates a Table of Contents automatically based on the content used as Heading presets of MS Word. Based on the type of  52 Heading, Automatic Table of Contents will create the appropriate levels and show page numbers where those Headings are placed. The only difference between Automatic Table 1 and Automatic Table 2 is the title of the table that is “Contents” or “Table of Contents”. (ii) Manual Table Choosing Manual Table from the Table of Contents menu will create a template of a generic table of contents. This table will need to be edited and dened manually by providing all the headings, sub-headings and page numbers. To extend the table, simply copy and paste the template lines and edit them to preserve proper formatting. 3.1.3 Typing in Urdu and Sindhi Languages MS Word 2010 helps in writing letters, applications, CVs, question papers and books in default language set by Microsoft Windows (that is usually English). MS Word 2010 also supports typing text in various other languages like Urdu and Sindhi. To be able to write in other languages, the keyboards for those languages have to be installed in Microsoft Windows. MS Word also supports changing and setting its default language. To change the default language, go to the File menu and select Options. From the Word Options dialog box, select Language tab. Now choose one of the available languages as the default language for MS Word 2010. Teachers are required to demonstrate the installation of Teacher Note multiple languages like Urdu and Sindhi in Microsoft Windows. They can do so by adding languages from the Regional Settings of Windows Control Panel. Installation of these languages also installs their keyboard layouts and enables the ability to type text in those languages.  53 Urdu Keyboard Layout Urdu Phonetic Unicode Keyboard Layout (With SHIFT) (for regular Urdu alphabets) _ ~ ! @ # $ % ^ & * ( ) + Fathatan or Exclamation Urdu Date Hamza SAW Dammatan Alef with Do zer Comma Isolated Yeh Nukta Hamza Above Left Parenthesis Right Parenthesis Shadda Mad Above Waw with Back Key Kasratan or Urdu 1 Urdu 2 Urdu 3 Urdu 4 Urdu 5 Urdu 6 Urdu 7 Urdu 8 Urdu 9 Urdu 0 Alef Hamza Do Zabar Hamza Above ` 1 2 3 4 5 6 7 8 9 0 - = Q W E R T Y U I O P { } | Urdu Jazam SAW AS RReh Tteh Sanah Sign Inverted Damma Alef Kada Zabar Teh Marbuta Damma - Pesh Left Qoutation Right Qoutation Takhalus Sign Tab Qaf Waw Ain Reh Teh Yeh Barree Ulta Pesh Yeh Hamza Yeh Gol Heh Gol Peh Left Square Bracket Right Square Bracket Verse Sign q w e r t y u i o p [ ] \ A S D F G H J K L : " Maddah Sad Ddal Alif Khada Zer Hah Dad Khah Colon Tatweel (Kashish) Ghain Rehmat Sign Caps Lock Dal Feh Gaf Dochashmee Jeem Enter Alef Seen Kaf Laam Arabic Semicolon Arabic Fullstop a s d f g h j k l ; ' Z X C V B N M < > ? Thal Jeh Theh Zah Ghunna Alif Hamza Kasra or Zer Fatha or Zabar Arabic Question Shift Key Raziallah Sign Beh Below Arabic Jazam Shift Key Zain Sheen Tcheh Tah Noon Meem Arabic Comma Urdu Fullstop z x c v b n m ,. / Ctrl Alt Spacebar Right Alt Ctrl Sindhi Keyboard Layout Normal State Shift State  54 SLOs Ÿ Review the basics of MS Excel Ÿ Identify the Elements of MS Excel User Interface Ÿ Display data with charts 3.2 MS EXCEL 2010 3.2 Microsoft Excel (MS Excel) is a software that uses spreadsheet system to organize, display, format and calculate data using advanced features and formulas. MS Excel is a part of Microsoft Ofce Suite and integrates with other applications in the Ofce Suite. MS Excel offers advanced features to perform calculations, visualize data in graphs and create pivot tables. It efciently makes use of spreadsheets to organize, analyze and store data in tabular and graphical forms. It is the most widely used spreadsheet system and has a high demand in many organizations for keeping records of data and presenting them as tables and graphs. 3.2.1 MS Excel User Interface Quick Access Title Bar Help Icon File Tab Ribbon Toolbar Column Header Row Indicators Status Bar Worksheet Area View Buttons Zoom Slider Fig: 3.3 MS Excel Screen  55 3.2.2 Sorting Sorting is the process of rearranging or reordering data based on different criteria like size, quality, value and quantity. MS Excel has the ability to sort data according to the needs of the user. To help better understand this concept, take or create a list of products with their unit prices and quantities as shown below. The objective is to sort this list of products with prices and quantities, in alphabetical order based on the names of the products. To achieve this, rst select all the rows and columns which make up this product list then go to the Data tab and select the Sort option. In the Sort dialog box, choose Product from the Sort by dropdown list and make sure that in the Order dropdown list, A to Z is selected. Your data will be rearranged and sorted alphabetically based on the values in Product column and their respective prices and quantities will also be rearranged as sorted data as shown in the gure here. This data can also be sorted in terms of unit price and quantity. 3.2.3 Formulas MS Excel 2010 allows its user to perform numerous calculations on data. Common calculations include addition, subtraction, multiplication and division. Comparison of two numbers and nding their average is also  56 possible. Formulas tell MS Excel what calculation needs to be performed on the data. Formulas always start with an equal sign (=). They are den