As per the CISCE curriculum

7

Incorporates

NEP 2020

ICSE

T uchpad uch

®

iPRIME

Ver. 2.1

School Fee

Protection*

Orange Global Olympiad

CYBER

Coding Classes

Computer Science Textbook | Windows 10 & MS Office 2016

7

As per the CISCE curriculum

ICSE

T uchpad

®

iPRIME

Ver. 2.1

This book belongs to .................................................................................................... .....................

......................

.........................

......................

................................................................................................................ ................................................................................................................

Content Team Orange

Computer Science Textbook | Windows 10 & MS Office 2016

Published by:

Orange Education Pvt Ltd 9, Daryaganj New Delhi-110002 Phone: 43776600 8588814859 Email: [email protected] IE Code: 0511063121 Branches: • Chennai • Guwahati Regional Offices: • Ahmedabad • Bengaluru • Bhopal • Bhubaneswar • Dehradun • Hyderabad • Jaipur • Kochi • Kolkata • Lucknow • Mumbai • Patna • Raipur • Ranchi

Printed at:

© Publishers No part of this publication may be reproduced, distributed, or transmitted in any form or by any means, including photocopying, recording, or other electronic or mechanical methods, without the prior written permission of the publisher.

Disclaimer All product names, brand names and product logos mentioned or shown in this book are trademarks, registered trademarks, or trade names of their respective owners. The reproduction of these product names, brand names, and product logos and all instances of references of proprietary software in this book, are for educational purposes only. Although every safety measure has been taken to verify the precision of the information contained herein, the author(s) and publisher assume no responsibility for any error or omission. No liability is assumed for damages that may result from the use of information contained within.

School Fee Protection* School fee protection is an initiative by Orange Education to protect student’s fee in case of demise of the earning parent. Orange Education will bear the tuition fee of beneficiary as long as school remains subscribed to our books. All claims are subject to terms & conditions available on the website of Orange Education.

PREFACE Computers have become an integral part of our education system. Computer Science is now not limited to just teaching definitions and commands. Instead, it helps the learners to understand and appreciate the varied uses of computers and its vast applications. Touchpad iPRIME (Ver 2.1) series based on Windows 10 and Office 2016 is comprehensively designed as per the new ICSE syllabus. We believe computer education is a hands-on subject and too much of bookish knowledge can take away the pleasure of learning. All these points have been kept in mind while designing this book and to produce the content that is not only appealing but also challenging to the students. The topics in the book have been hand picked after an extensive research by a team of experts of the subject based on utility, interest, skill, basic and trending applications in the global market. We have designed the lessons in such a way that they can be well-integrated with other subjects. Step by step approach will make it simple and easy for our students to grasp the concepts. Relevance of the topics was of prime importance throughout the compilation of the book. Learning is done best when it’s fun-filled and activity based. To ensure that the content intrigues the students at all times and keeps them interested throughout the course of the book, we have included interesting key features like Student Corner, Tech Funda, Clickipedia, Comp Caution, Reboot, One Touch Learn, Let’s Do It, Crack The Code, Hands-On, Fun In Lab, Teacher’s Corner, Worksheet, Test Sheet, Project, Speech Drill, Supplement Pages and Glossary. These features will ensure better learning, assessment, evaluation and enable children to take their knowledge beyond the classroom. Sample questions of Orange Global Olympiad (Cyber) have been included to promote awareness about the national level competition. We hope that the book contributes to the progressive development of computer aided education system and prepares our students for all upcoming challenges. We want the children to learn the concepts with not only the purpose of gaining knowledge but also to be able to find its applications. This will enable then to enrich the quality of their lives as well as others. —Publisher

INCORPORATES NEP 2020 Created with new dimension of Joyful Learning along with completely mapped parameters of National Education Policy, 2020 Computational Thinking Enables to help solve problems and make thinking more engaging

Inter-Disciplinary Connects knowledge across the curriculum for holistic development

Art Integration Interlinks education with art and culture

Aimed at understanding and skill developing in specific subject

Critical Thinking

Communication

Strengthens logical decision making and innovation

Emphasis on soft skills and power of language

Creativity Enhances imagination to generate new ideas

Subject Enrichment

Experiential Learning

Life Skills & Values

Encourages ‘learning by doing’ through hands-on activities

Inclined towards empowering moral values in learner

DIGITAL RESOURCES For Teachers & Students

Only for Teachers

Orange Mobile App

Get it on

Test Paper Generator

Animated Audio & Video eBook Works offline after download

Generates Random & Manual Question Paper (QP)

Chapter Audio & Video Interactive Exercises with Answer Checks & Subjective questions Features like Spotlight, Zoom Sliders, Add Notes, Highlighter & Pencil on the eBook

Student Worksheet

Export Paper in Word format

Lesson Plan

Software Download Link

Practice Worksheets

(iii) Visit www.orangeeducation.in or scan the QR Code to register on our web support.

Answer Key

INSIDE THE SERIES

The key features of the series have been designed to ensure better learning, assessment and evaluation.

Learning Resources

Your Aim: This section describes the objective of the chapter.

Tech Funda: This section provides a practical information or tip to the students.

Clickipedia: This section provides interesting computer facts.

Tech Funda

Comp Caution: This section (in I, II) describes ways to handle the computer cautiously.

Reboot: This section provides a summary of the chapter for quick recapitulation.

You can also exit Word 2016 by pressing the + F4 keys.

Hands-On: This section contains an activity for Home assignment.

Fun in Lab: This is a lab activity to develop practical skills.

Glossary: This section contains definition of important IT terms.

Your Aim

QR Code: Scan the QR Code given on the

first page of each chapter to start chapter animation.

to learn about: Natural and man-made things What are machines? Computer—A wonderful machine Difference between computers and machines Features of a computer Types of computers

Assessment Resources

One Touch Learn: This section has objective based quick questions.

Let's Do It: This section has subjective type questions.

Crack the Code: This section has puzzle or fun based activity to help understand the concepts better.

Worksheet: Two Worksheets are included to evaluate the knowledge of the students.

Test Sheet: This section has questions to assess students.

Project: This is an assessment to challenge the students to apply the concepts learnt.

Contents

Contents

Contents

Computer Studies ICSE Syllabus Topic 1: Topic 2: Topic 3: Topic 4:

Topic 5: Spreadsheets—An Introduction Topic 6: Database and DBMS—An Introduction Topic 7: HTML—Advanced Features

Computer—Hardware Components Number System—An Introduction Computer Virus Ethics and Safety Measures in Computing

Contents 01 02

Computer—Hardware Components 7  Hardware

 Merging Cells    

 New Trends in Hardware

Number System  Number System

20

Worksheet-1 Test Sheet-1

 Number System Conversion

 Operations on Binary Numbers

03

Computer Virus  What is a Computer Virus?

77

08

More on Access

91

09

Lists and Tables in HTML  Creating Lists

103

More on HTML  Inserting Images

116

 Types of Computer Virus

 How does a Computer get Infected with Virus?  How Do You Know Your PC has a Virus?  How to Prevent Your PC from a Virus?  Malware

 Antivirus  Firewall

04

Ethics and Safety Measures in Computing  What is Internet?

37

 Computer Ethics

 What are Internet Ethics?

 What are Unethical Practices?  Safety Measures While Using

Computer/Internet  Digital Footprints

05

Spreadsheets—An Introduction  Features of Excel 2016

49

10

 Components of Excel 2016 Window  Data Types

 Entering Data in the Worksheet  Saving a Workbook

 Selecting Cells in a Worksheet

 Forms in Access  Queries in Access  Reports in Access

   

 Creating a New Workbook

06

 Concept of a database  Advantages of a database system  Types of databases  Terms related to a database  Access 2016  Components of Access 2016  Creating a database  Data types in Access 2016  Types of views in Access  Rules for writing a field name in Access  Creating a table  Opening an existing database  Exiting Access 2016

 Creating Tables

 Starting Excel 2016

More on Spreadsheets

74 75

Database and DBMS— An Introduction

07

28

Formatting Spreadsheets AutoFill Using Formulas to Perform Calculation Order of Operation

Creating Marquee Linking Web Pages Frames Creating Forms in HTML

Worksheet-2 Test Sheet-2 Project Explore More (Introduction to Flash CS6) OGO Cyber Sample Questions Glossary

59

 Copying/Moving Data

 Using Undo and Redo Features

 Column Width and Row Height  Inserting Rows/Columns

(vi)

137 138 140 142 145 148

1

Computer-Hardware Components

Your Aim

to learn about: l

Hardware

l

New trends in hardware

Computer system is made up of two types of components: hardware and software. Both these components are equally important for functioning of a computer system. Without software component, the hardware components are useless and vice-versa. Software is a set of instructions that makes the computer perform tasks. Software is another term for a computer program. Software can be classified into two broad categories: system software and application software. We have already learned about different types of software in the previous classes. In this chapter, let us learn more about hardware.

HARDWARE All the physical components of a computer system are called hardware. These are the parts which we can see or touch. Hardware components are classified into two types: internal and external. Let us learn about these in detail.

Internal Hardware Components All the hardware components that are located inside the CPU Box (System Cabinet) are called internal hardware components. Examples of the internal hardware components are CPU, Motherboard, Power Supply (SMPS), Disk Drives, Modem, Ports, etc. Let us learn about some of them in detail. Memory Unit

CPU CPU (Central Processing Unit) is a processor, sometimes called a microprocessor. It is the brain of the computer that does all the calculations and runs all the programs. It manages all the operations and carries out the basic instructions which operate a computer.

Control Unit

CPU box

CPU

ALU Functioning of CPU

Computer—Hardware Components

7

The three main components of the CPU are: ALU (Arithmetic Logic Unit): Performs mathematical and logical operations. CU (Control Unit): Directs all the operations of a processor. Memory Unit: Stores data and instructions.

Clickipedia The speed of a CPU is measured in Megahertz. Higher the value, faster is the information processed by the CPU.

Motherboard The motherboard is sometimes called the system board or main circuit board. Many electronic components are attached to the motherboard or are built into it.

The motherboard contains the connectors or slots for attaching additional boards, CPU and memory.

Motherboard

Disk Drive

A disk drive is an internal hardware component of the computer system that is used to read and write on storage disks. Disk drives can either be located internally within a CPU box or located in a separate box that is external to the CPU box. Most of the disk drives work in a similar fashion. They spin the disk for reading and writing data on the disk. Hard disk drive is the most commonly used disk drive. Some other types of disk drives are Compact Disk (CD) drive, Digital Versatile Disk (DVD) drive, Blu-ray Disk (BD) drive.

Hard disk drive

CD/DVD drive drive

Blu-ray disk drive

SMPS Switched Mode Power Supply (SMPS) is a hardware component of the computer used to control the power supply. It is also known as the power supply unit of the computer. It takes the Alternating Current (AC) from a source and converts it into low voltage Direct Current (DC) and then supply it to other parts of the computer system. It has a switching regulator which control the output voltage. It also has an in-built fan to reduce the heat.

SMPS

Ports A port is a slot on the motherboard that is used to connect other components of the computer such as keyboard, mouse, monitor, etc. to the motherboard. There are various types of ports on the motherboard which are used to connect internal as well as external components of the computer system. 8

Touchpad iPRIME (Version 2.1)–VII

Some of them are as follows: Serial Port: It is also known as communication port, used to transfer data in or out sequentially one bit at a time. It has pins to connect to the computer. Generally, serial ports are used to connect modem. Universal Serial Bus (USB) Port: It is also known as standard cable connection interface, used to connect USB devices and provide power supply to the devices connected to it. Mouse, keyboard, etc., are connected to the computer with the help of USB ports. Parallel Port: It is very similar to a serial port. The only difference is that it transfer multiple bits at the same time. Parallel ports are used to connect the devices which require high-speed data transmission like printer. PS/2 Port: It was used to connect the keyboard and mouse with the computer. Now, USB ports are used in place of PS/2 ports. Video Graphics Array (VGA) Port: It is also similar to the serial port. The only difference is that it has holes instead of pins. With the advancement in technology, HDMI and Display ports are used in place of VGA port. Audio Port: It is used to connect external speakers, headphones, microphone and external audio device. Ethernet Port: It is used to connect network cable to the computer.

Modem It stands for MODULATOR – DEMODULATOR. It is a hardware device that is used to connect a computer to the Internet via a telephone line or a wireless medium. It converts data from digital to analog and vice versa. The process of Internal modem External modem converting analog signals to digital signals is called modulation. The process of converting digital signals to analog signals is called demodulation. Modem are of two types: internal and external. Internal modem is located inside the CPU box as like the motherboard plate. On the other hand, external modem is a separate device which you can connect to the computer with the help of USB port. It generally contains indicators in the form of small lights.

Sound Card A sound card is a hardware part of the computer system. It is located inside the CPU box and used to convert the sound into digital data and vice-versa. It allows computer to play music with the help of an output device like speaker. A sound card has audio ports through which we can connect the speakers and headphones to the computer.

Video Card

Video card

Sound card

Video card is an expansion card. It is used to convert the digital data into video form and vice-versa. After converting the digital data into video, it displays the output on the display devices like monitor and TV. A video card is also used to improve the quality of the pictures and videos. It has processing as well as storage capability. Computer—Hardware Components

9

External Hardware Components The hardware components that are located outside the CPU box are called external hardware components. As these components are connected to the computer externally, they are also called peripheral components. External hardware components can be classified into three categories: External Hardware Components

Input Devices

Output Devices

Storage Devices

Let us discuss these in detail.

Input Devices A computer accepts data and instructions from you through input devices. Data can be in the form of numbers, text, sound or graphics. Some of the input devices are: Keyboard: A computer keyboard is the main input device for computers. Similar to a typewriter used earlier, a keyboard is composed of buttons which are called keys. You can press the keys on it to input data in the form of words and numbers.

Keyboard

A standard keyboard has 104 keys, which can be classified as follows: •

Alphanumeric keys (A-Z, a-z, 0-9)

•

Control keys (Ctrl, Alt, Esc, etc.)

•

Function keys (F1-F12)

•

Special keys (Caps Lock, Backspace, Spacebar, Arrow keys, Home, End, etc.)

•

Punctuation keys (“ , ” , “-”, ; , etc.)

Mouse: It is a pointing device that allows you to put data into a computer by using the point, click and drag and drop commands. It controls the movement of the pointer on the screen. It is used to move and select icons, files and folders on your computer. There are two main types of mouse: optical and mechanical. An optical mouse is an advanced computer pointing device that uses a light-emitting diode (LED) and an optical sensor. This type of mouse does not require any internal cleaning since there are no rotating parts; however, they can get sticky over time as dust collects near the light emitter. This can cause erratic cursor movement or prevent the mouse from working. You must clean the surface of the mouse and the mouse pad regularly to Optical mouse prevent dust from accumulating on the mouse. 10 Touchpad iPRIME (Version 2.1)–VII

Mechanical mouse uses a rubber ball that makes contact with wheels inside the unit when it is rolled on a pad or desktop. This type of mouse is especially susceptible to dust and particles that can accumulate inside the mouse, which can make it difficult to track or move properly. If the mouse pointer does not move smoothly, you will have to clean the rubber ball. Mechanical mouse

Scanner: Scanner is a device that helps to input printed pictures and text into the computer by reading them. Different types of scanners are available. The choice of scanners depends on the purpose for which these are to be used. Some popular types of scanners are:

• Hand-Held Scanner: It is a type of scanner that can be held

in hand and rolled over a flat image or document. It is used to scan documents into their digital forms. This type of scanners are small in size, portable and less expensive. Hand-Held Scanner

• Flatbed Scanner: It is a type of scanner that uses a flat, glass

Flatbed Scanner

surface for scanning documents. It looks like a photostat machine. Unlike hand-held scanner, flatbed scanner does not require movement on the document.

• Sheetfed Scanner: It is a type of scanner that allows multiple

papers to be scanned at a time. In this scanner, the stack of papers is kept on top and the scanner automatically scans the pages one by one. It is widely used in offices to scan documents.

Clickipedia

Sheetfed Scanner

The difference between Flatbed scanner and Sheetfed scanner is that Sheetfed scanner allows you to scan a stack of papers while Flatbed scanner deals with one paper at a time. Webcam: It is a digital video camera connected to a computer. It helps to put your image into the computer when you are connected to the Internet. It is smaller than the traditional camera and generally attached to the monitor of the computer or built into the hardware.

Graphic tablet

Webcam

Graphic Tablet: It allows to directly draw on a computer screen. The device consists of a flat surface upon which you can draw with an attached stylus which looks like a pen. Computer—Hardware Components

11

Joystick: Joystick is a pointing device which is used to control the movement of a pointer on your computer screen. It is mostly used to play games on the computer.

Joystick

Microphone

Microphone: It is an input device that is used to record voice, music and sound into the computer system. It captures the sound waves and converts them into digital form. It is generally used in different types of communications, as well as music and speech recording.

Touchscreen: A touchscreen is screen sensitive to touch. We can interact with a computer by touching areas on the screen. Tablets, smartphones, ATMs have touchscreen in them. Touchscreen

Output Devices

The output devices are used to display the information and result of computation to the user. Some of the output devices are:

Monitor

Monitor: The monitor is one of the most familiar output device. It is called the Visual Display Unit (VDU). The images that you see on the monitor are made up of tiny dots called pixels. The clarity of the images depends on the number of dots/pixels on the screen per inch. The maximum number of dots per inch (dpi) will give you more clarity or better display. Nowadays, monitors with Light Emitting Diode (LED) screens have become very popular because of the clarity of the images and the slim shape of the monitor.

Printer: A printer is an output device that allows to print the work done on the computer on a sheet of paper. Printers are categorised as impact or non-impact depending on their working. Impact printers create an image on a paper by striking the paper with a metal. Non-impact printer create an image on a paper by spraying ink on the paper. Some of the common printers are: •

Dot matrix printer Dot matrix printers work like a typewriter. The printer head strikes the paper and ink ribbon to print a character. It is an impact printer.

12 Touchpad iPRIME (Version 2.1)–VII

Dot matrix printer

•

Inkjet printer Inkjet Printers are non-impact printers. Printing is done line-by-line by spraying ink on a sheet of paper. These printers are much faster than dot matrix printers. However, these are more expensive and consume more ink. Inkjet printers use ink cartridges.

Inkjet printer

• Laser printer Laser Printers are also known as non-impact printers. These printers use a laser beam to print on the paper. These printers are much faster than inkjet printers and the print quality is superior. However, these printers are expensive and are mainly used in places where fine quality printing is required. • Plotters

Laser printer

Plotters are used to print good quality drawings. They are mainly used in desktop publishing offices and by architects to print building construction plans. They are just like printers but are much bigger in size. They are also expensive than printers. The print quality of plotters is better than printers as they print in great details. There are mainly two types of plotters: Drum Plotter and Flatbed Plotter.

Flatbed Plotter

Drum Plotter

Speakers: Speaker is an output device that produce music, speech or other sounds from the computer. These are also used for listening to and watching movies on a computer. Speakers

Projector

Projector: A projector is an output device used to project the output from the computer screen to a large screen. It takes the input from the computer in the form of image and displays it on a wide screen. In school’s smart classes, office meetings and cinemas, projectors are used for teaching students, giving a presentation in front of office employees and projecting movies respectively. Computer—Hardware Components

13

Storage Devices Storage devices are used to store data into a computer. There are number of storage devices such as hard disk, CD, DVD, Blu-Ray and Flash Drive. Hard disk: The hard disk consists of one or more magnetic disks called platters. Each disk in the pack has top and bottom surfaces on which data is recorded using magnetic head. It is permanently fixed on the motherboard. It is usually used for permanent mass storage. The most important function of the hard disk is to store program files and data files. The hard disk comes in a variety of sizes with storage capacities as high as 5 TB (TeraByte) or even more. The CPU accesses data stored on a hard disk much faster than it can access data on a CD.

Hard disk

External hard disks are also available. They are the hard disks that can be connected to any computer with the help of USB port.

External hard disk

Clickipedia

First hard disk was introduced by Seagate in 1979 which could hold 5 MB of data. Compact Disc (CD): The CD drive reads information stored on a compact disc (CD). CD is an external storage device. The lifespan of optical disc is more than a magnetic disc. It can hold upto 700 MB of data. Types of CDs: •

CD-ROM (Compact Disc Read Only Memory): A CD-ROM is a CD containing data which has been written at the time of manufacturing. The data cannot be modified or erased.

•

CD-R (Compact Disc Recordable): A CD-R can be used to write data by the user only once. This data cannot be changed or erased.

•

CD-RW (Compact Disc Rewritable): A CD-RW can be used to write data again and again. The data can be erased and modified as many times as required.

DVD

CD

Digital Versatile or Video Disc (DVD): DVDs are now widely used in computers. They have now become a popular medium for storing information and video. The DVD is almost similar to a CD. Even the working is also similar. The only difference is that it can hold more information than a CD. DVDs are widely used for storing and viewing movies and other data.

14 Touchpad iPRIME (Version 2.1)–VII

Blu-Ray Disc: Blu-ray disc is an optical disc. It is used for storing large amount of data, and playing videos. The main difference between DVDs and Blu-ray discs is storage capacity.

Blu-Ray Disc

Flash Drive: The Flash Drive is a small portable data storage device integrated with a USB (Universal Serial Bus) connector.

•

Pen drive



•

Pen Drive: It acts as a portable hard drive and is easy to use as it is small and can be carried in a pocket and plugged into any computer with a USB drive. Pen drive has storage capacity of upto 1TB.

Memory Card: It is commonly known as multimedia memory card. It is very small in size usually 1–1.5 inches. These are used in mobile phones and digital cameras. You need to have a card reader to read stored data on a memory card.

NEW TRENDS IN HARDWARE

Memory card

Some hardware devices with new technology are already available and some are under the process of development. Let’s discuss some of them.

Wireless Devices

Earlier, all hardware devices were connected to the CPU box through a wire. These days, almost every type of hardware has a wireless version available. They work with the help of radio frequency (RF), infrared (IR) or Bluetooth technology.

Virtual Keyboard

Wireless devices

A virtual keyboard is operated by typing on a detectable surface rather than pressing physical keys. It is actually a software component because it is not a physical part. Virtual Keyboard

3D Camera 3D camera is a real sense device which is able to recognize faces and use that capability to log in into their devices like smartphones or laptops. 3D cameras can also measure distances between items or even scan objects for 3D printing.

3D Camera

Computer—Hardware Components

15

T uch uchpad

®

iPRIME Ver. 2.1

Spotl ght Tech Funda

What’s New in Ver. 2.1? NEP 2020

Clickipedia

Comp Caution

Crack the Code

Hands-On

Glossary

Java BlueJ

AI & Robotics

Art Integration

Inter-Disciplinary

Subject Enrichment

Computational Thinking

Critical Thinking

Communication

Creativity

Experiential Learning

Tech Update

Life Skills & Values

Teaching and Learning Solutions Animated e-Book

Mobile App

Teacher Resource Materials

Webinars & Training Workshops

Computer Lab Health Check-up

Software Tech Support

Protect Yourself From Covid-19

Returning

Stay 6 feet apart from others in school and in the bus.

Back to

school

On reaching school, go straight to your classroom. Wash Your Hands Frequently

Wear a Face Mask

Stay at Home if You are Sick

Use your own things so virus cannot be transmitted. Cough or sneeze into your elbow or use a tissue.

Buy Online

CE

RTIFIED

ISO 5

N

20

Y

9001

1

COMPA

@OrangeEducationPvtLtd

Orange Education Pvt Ltd Adding value to ‘Education’

9, Daryaganj, New Delhi-110002 (India) Phone: +91-11-43776600 E-mail: [email protected] Website: www.orangeeducation.in

MRP: ` 412

(inclusive of all taxes)