it skillz - it-skillz.pdf · it skillz series of books is the offering from edusoft which is based...

IT Skillz

Teacher’s Reference Manual

Class 1 to 8

Content

CLASS 1 ....................................................................................................................................... 3

CLASS 2 ....................................................................................................................................... 7

CLASS 3 ..................................................................................................................................... 12

CLASS 4 ..................................................................................................................................... 17

CLASS 5 ..................................................................................................................................... 24

CLASS 6 ..................................................................................................................................... 32

CLASS 7 ..................................................................................................................................... 40

CLASS 8 ..................................................................................................................................... 49

Introduction IT SkillzTM, a series of 8 books, is a humble effort to provide futuristic and comprehensive learning of computer

applications covering basic concepts and in-detail insight into the software applications and programming approach. The

series is based on MS-Office 2016 over Windows 10 with suitable references to MS-Office 2010/2013 and Windows 7.

The series is based on Skill-Oriented Methodology with Skill as the key factor. This methodology supports Explicit

Teaching Model where teacher thinks aloud and clearly models the skill through demo and practical examples. Each

knowledge chunk is followed by Skill Practice session to ensure instant skill development on the topic learnt.

NOTE:

Any value-based questions in the end of the chapters should be discussed orally in the classroom or as part of any

activity/ workshop. They should not be used in the written or practical assessments.

IT SKILLZ

Page | 2

ABOUT SKILL ORIENTED METHODOLOGY

IT Skillz series of books is the offering from Edusoft which is based on Skill Oriented Methodology. The series is

designed with Skill as the key factor.

This methodology supports Explicit Teaching Model where teacher thinks aloud and clearly models the skills through

demo and practical examples.

Each knowledge chunk is followed by Skill Practice session that ensures instant skill development on the topic learnt.

Skill Oriented Learning Objectives

For each chapter, the fundamental Targeted Skills are identified. Based on the skills, the learning objectives have been

chalked out.

How the book helps the learners?

• Learners independently garner the meaning from new information.

• Learning is transferred to the learners as literacy skills.

• Onus of learning also lies with the students as they work out Fun Tasks and Skill Practice.

• Value Based Learning through Critical Thinking (from class 4 onwards) opens up students' minds to

think out of the box and look at their learning with various perspectives.

• Higher level thinking (analyse, evaluate and apply) through Projects and LabVenture.

IT SKILLZ

Page | 3

Class 1

SYLLABUS

Term - I

1. Computer: A Digital Machine

2. Computer: Our Useful Friend

3. Parts of a Computer

4. Using a Computer

Term - II

5. Tame the Computer Mouse

6. The Keyboard

7. Computer Data Storage

Exercises

Chapter 1 – Computer: A Digital Machine

A. Choose the correct answer.

1. a 2. a 3. b 4. d 5. b

B. Tick (✓) the correct statement and cross (x) out the wrong one.

1. True (✓) 2. False (x) 3. True (✓) 4. False (x) 5. True (✓)

C. Fill in the blanks.

1. Machine 2. Sharpener 3. Electricity 4. Laptop 5. Natural

D. Match the following:

Column-I Column-II

1. - c

2. - e

IT SKILLZ

Page | 4

3. - a

4. - b

5. - d

E. Encircle the automatic machines from the following:

Chapter 2 – Computer: Our Useful Friend A. Choose the correct answer.

1. b 2. a 3. c 4. d 5. a 6. d 7. b


1. False (x) 2. True (✓) 3. True (✓) 4. False (x) 5. False (x) 6. False (x)


1. Easier 2. Tired 3. Information 4. Inputs 5. Play 6. Computer

D. Identify and write the name of the area in the blank boxes where computers are used commonly.

Top-down answers: Home Travel/ Tourism Schools Hospitals

Chapter 3-Parts of a Computer A. Choose the correct answer.

1. a 2. c 3. d 4. a

B. Fill in the blanks.

1. Monitor 2. Keyboard 3. Headphone 4. Mouse

C. Complete the following words with correct letters:

1. MOUSE 2. MONITOR 3. PRINTER 4. KEYBOARD

IT SKILLZ

Page | 5

D. Match the following:

1. f 2. c 3. a 4. d 5. e 6. b

Chapter 4- Using a Computer A. Choose the correct answer.

1. a 2. d 3. d 4. c 5. d


1. False (x) 2. True (✓) 3. True (✓) 4. False (x) 5. True (✓)

Chapter 5-Tame the Computer Mouse A. Choose the correct answer.

1. d 2. b 3. d 4. d 5. b


1. Buttons 2. Cable 3. Scroll wheel 4. Right- Click 5. Pointer

C. Tick (✓) the correct statement and cross (x) out the wrong one.

1. False (x) 2. True (✓) 3. True (✓) 4. False (x) 5. False (x)

Chapter 6- The Keyboard


1. d 2. a 3. d 4. a 5. D


1. Alphabet 2. Delete 3. Enter 4. Spacebar 5. Up Arrow 6. Number

D. Match the following.

IT SKILLZ

Page | 6

Chapter 7- Computer Data Storage A. Choose the correct answer.

1. d 2. d 3. c 4. b 5. c


1. ROM 2. Hard Disk 3. CD-RW 4. Pen Drive 5. Smart Phonesa


1. True (✓) 2. True (✓) 3. True (✓) 4. False (x) 5. False (x)

D. Answer the following questions.

1. RAM: Random Access Memory ROM: Read Only Memory

2. Primary storage and Secondary storage

3. CD and Pen Drive

4. Smart phone and laptop

IT SKILLZ

Page | 7

Class 2

SYLLABUS

Term - I

1. Computer: An Electronic Device

2. Role of Computers

3. Input and Output Devices

4. Keyboard: Special Keys

Term - II

5. Working with Computer Mouse

6. Introduction to MS Paint

7. Introduction to File Management

Exercises

Chapter 1- Computer: An Electronic Device A. Choose the correct answer.

1. b 2. a 3. b 4. d 5. b

B. Fill in the blanks with the words given below.

1. Input 2. Processing 3. Fast 4. Program 5. Learn

C. Rewrite the jumbled words.

Advantages: Fast, Programmable, Accurate

Limitations: Cannot learn, Need human care, No emotions


1. Computer takes data and instructions. This is called input.

2. After processing the data, computer gives out the result. This is called output.

3. i. Computers are fast.

ii. Computers do not make mistakes.

4. i. Computers cannot learn.

IT SKILLZ

Page | 8

ii. Computers need human care.

5. i. Computer Viruses

ii. Harmful for nature or environment.

E. Tick (✓) the correct statement and cross (x) out the wrong one.

1. False (×) 2. True (✓) 3. True (✓) 4. False (×) 5. True (✓)

Chapter 2 – Role of Computers A. Choose the correct answer.

1. d 2. a 3. d 4. b 5. d


1. Offices 2. Teaching 3. Booking tickets 4. Calls 5. Diseases 6. Shops

C. Write any two uses if a computer at the following places.

1. School: i. Teaching. ii. Printing exam results.

2. Hospital: i. Patient history ii. Diagnose diseases

3. Bank: i. Maintain accounts. ii. Printing documents

4. Railway station: i. Ticket booking. ii. Tracking trains

5. Hotel: i. Keep guest records ii. Room booking


1. - d

2. - e

3. - c

4. - a

5. - b

Chapter 3 – Input and Output Devices A. Choose the correct answer.

1. c 2. d 3. c 4. b 5. a


1. USB 2. Scanner 3. Optical disk 4. Headphones 5. Printer

C. Rewrite jumble words.

1. HEADPHONE 2. KEYBOARD 3. SPEAKERS 4. SCANNER 5. PENDRIVE

IT SKILLZ

Page | 9

6. HARDDISK


1. Monitor 2. Keyboard 3. Printer 4. Webcam 5. Optical disk 6. Memory card

E. Match the following.

1. c 2. e 3. d 4. a 5. b

F. Tick (✓) the correct statement and cross (x) out the wrong one.

1. True (✓) 2. False (×) 3. True (✓) 3. False (×) 4. False (×)

Chapter 4 – Keyboard: Special Keys A. Choose the correct answer.

1. b 2. c 3. a 4. a 5. a 6. b

B. Write the correct number to match the keys with their correct type.

a. 2 b. 1 c. 3 d. 2 e. 1 f. 3


1. Punctuation 2. Symbols 3. Special 4. ? 5. & 6. Alt

F. Tick (✓) the correct statement and cross (x) out the wrong one.

1. False (×) 2. True (✓) 3. False (×) 4. True (✓) 5. True (✓)

Chapter 5 – Working with Computer Mouse A. Choose the correct answer.

1. d 2. d 3. b 4. d 5. b


1. Buttons 2. Left 3. Dragging 4. Dropping 5. Right


1. False (×) 2. True (✓) 3. False (×) 4. False (×) 5. True (✓)

Chapter 6- Introduction to MS Paint A. Choose the correct answer.

1. a 2. d 3.c 4. b 5. d


1. Color 1 2. Fill 3. Shift 4. Fill with Color 5. Color 2

IT SKILLZ

Page | 10

C. Answer the following questions.

1. Shapes tool is a set of various shapes.

2. Fill with Color tool helps in filling a colour inside a shape.

3. PNG, JPG, GIF

D. Label the parts of MS Paint Window (Windows 10)

Drawing Area

Image

section

Tools

sectionShapes section Colors

section

File menu button

Chapter 7- Introduction to File Management


1. d 2. a 3. c 4. b


1. File 2. Desktop 3. Double click 4. Ctrl + S 5. Audio

IT SKILLZ

Page | 11


1. A file stores our work in the computer.

2. Primary name and secondary name.

3. All the work in the main memory is lost when computer is switched off.

4. This PC window shows all the files, folders and drives on our computer.

D. Tick (✓) the correct statement and cross (x) out the wrong one.

1. False (×) 2. True (✓) 3. False (×) 4. True (✓) 5. True (✓)

IT SKILLZ

Page | 12

Class 3 SYLLABUS

Term - I

1. A Computer System

2. GUI Operating System

3. Introduction to Word Processing

Term - II

4. Introduction to Internet

5. Fun with Paint

6. File Management: Organisation of Folders

Popular Computer Application Skils

7. Logical Thinking through Game Design

Exercises

Chapter 1 – A Computer System A. Choose the correct answer.

1. a 2. b 3. b 4. d 5. c


1. ROM 2. Hard Disk 3. CPU 4. Pen Drive 5. Hardware


1. True (✓) 2. False (×) 3. True (✓) 4. False (×) 5. True (✓)


1. A computer is a device made of input, processing, output and storage devices.

2. Input devices: Keyboard and Scanner Output devices: Monitor and printer

3. CPU processes the input and generates output.

4. i. Arithmetic and Logic Unit ii. Control Unit

IT SKILLZ

Page | 13

5. Instruction: MULTIPLY Data: 5, 2

6. Microphone to record the song. Headphones to listen to the song.

7. All physical parts and devices of the computer are called hardware.

Software run on the computer and make use of hardware.

Chapter 2 – GUI Operating System A. Choose the correct answer.

1. a 2. c 3. a 4.b 5. d


1. Taskbar 2. Wallpaper 3. Icons 4. Name 5. Safe

C. Match the following.

Column-I Column-II

1. - c

2. - a

3. - b

4. - e

5. - d


1. Loading of operating system in computer’s memory is called booting.

2. GUI is made of various graphical parts like icons, windows, Start button etc.

3. Safe mode loads essential files of operating system. It is used to fix any problem with operating system.

4. Double clicking on an icon opens the program denoted by it.

Chapter 3 – Introduction to Word Processing A. Choose the correct answer.

1. d 2. d 3. c 4. c 5. a


1. Ctrl + S 2. Status Bar 3. Document Area 4. Editing 5. Open


1. MS Word is a word processing software.

2. Text editing refers to the process of correcting, deleting or modifying the text.

IT SKILLZ

Page | 14

3. MS Word, OO Writer, Word Perfect and Lotus Word Pro

4. i. We can type and format the text.

ii. We can apply special effects to text.

D. Write the steps for the following.

1. Click on Start button → Word option.

2. i. Click on a File tab → Save As option.

ii. Click on This PC or Browse a location.

iii. Give file name in Save As dialog box and click on Save button.

3. i. Place the cursor at the required location.

ii. Start typing the text.

4. Place the cursor at the beginning of the text and press Delete button.

E. Write the shortcut keys for the following.

1. Ctrl + N

2. Ctrl + A

3. Shift + →

4. Shift + ←

Chapter 4 – Introduction to Internet A. Choose the correct answer.

1. a 2. b 3. d 4. c 5. b


1. WWW 2. Home page 3. Google Chrome 4. Search engine 5. Hyperlink


1. The computer networks all over the world connect together to form Internet.

2. A search engine is a website used to search information on the world wide web. Example: Google, Bing

3. i. Do not open emails from unknown sources.

ii. Never share personal information with everyone online.

4. i. Say no to pirated games and movies.

ii. Respect others’ privacy online.

D. Define the following terms.

1. Web page: A web page generally contains text, images, audio, video and hyperlinks etc.

2. Home page: A home page is the first page of a website.

3. A URL is the unique address of a website on internet.

IT SKILLZ

Page | 15

E. Tick (√) the correct statement and cross (×) out the wrong one.

1. False (×) 2. True (√) 3. False (×) 4. True (√) 5. False (×)

Chapter 5 - Fun with Paint A. Choose the correct answer.

1. a 2. b 3. a 4. b


1. Tools 2. Select all 3. Click 4. Selection

C. Answer of the following questions.

1. Color Picker tool helps us to pick a colour from the drawing.

2. Rotate tool is used to rotate the drawing.

3. The Select All tool is used to select entire drawing.

D. Distinguish between the following:

1. Rectangular Selection tool selects a rectangular shaped area of an image while Free-form selection tool

selects an irregular area.

2. Moving a selection means select and drag it while copying a selection means copy and paste it.

3. Rotate tool rotates the shape by degrees while Flip tool turns the sides of the shape.

Chapter 6 – File Management: Organisation of Folders A. Choose the correct answer.

1. d 2. a 3. c 4. b


1. Secondary 2. Ctrl + Shift + N 3. Image 4. Audio-Video 5. New Folder


1. A file stores our work on the computer. Each file is given a name.

2. A folder stores files and other folders.

3. A folder within a folder is called sub-folder.

4. To create a folder:

i. Open This PC.

ii. Select the desired drive.

iii. In the ribbon, click on New Folder in New group.

iv. Type the name of the new folder and press Enter.

IT SKILLZ

Page | 16

D. Select the correct file types for following scenarios.

1. JPG 2. MP3 3. AVI 4. DOC 5. EXE



Chapter 7 – Logical Thinking through Game Design A. Choose the correct answer.

1. b 2. a 3. d 4. a


1. Computer 2. Program 3. New World 4. Change Settings 5. Load World

C. Identify the parts of following Kodu Game Screen.

1. Terrain 2. Characters 3. Play Game button 4. Camera Tool 5. Object Tool

IT SKILLZ

Page | 17

Class 4

SYLLABUS

Term - I

1. Storage and Memory Devices

2. GUI: Desktop Management

3. Tools of Word Processor - 1

Term - II

4. Tools of Word Processor – 2

5. The Internet: Web Browser

6. Introduction to Presentation Software

7. Step-wise Thinking

8. Organisation of Folders

Popular Computer Application Skills

9. Logical Thinking with Kodu

Exercises

Chapter 1 – Storage and Memory Devices A. Choose the correct answer.

1. b 2. a 3. a 4. c 5. b


1. Data 2. DVD 3. Secondary 4. Main 5. Flash

C. Tick (√) the correct statement and cross (×) out the wrong one.

1. True (√) 2. True (√) 3. False (×) 4. True (√) 5. True (√)


1. Age is data and “Ram is 5 years old” is information.

IT SKILLZ

Page | 18

2. A bit is the smallest measuring unit of storage in computers. It is either 0 or 1. A set of 8 bits is called a

byte. Half a byte i.e. 4 bits is called a nibble.

3. Difference between ROM and ROM

ROM RAM

1. Permanent storage 1. Volatile storage

2. Small storage capacity. 2. Larger storage capacity.

4. Secondary storage stores the data permanently in the form of files. Hard disk is used to save our work

permanently in the computer hence it is a secondary storage device.

5. i. Data: Data are simple facts and figures. They alone make no sense.

ii. Information: It is meaningful, processed form of data.

iii. Backup: A copy of the contents of a computer is called backup. It is used to recover data in case of

system crash.

iv. USB: Universal Serial Bus is used to connect variety of devices easily with the computer such as printer,

smartphone, camera etc.

Chapter 2 – GUI: Desktop Management A. Choose the correct answer.

1. c. 2. a 3. c 4. d 5. b


1. Control Panel 2. Unpin 3. Taskbar 4. Lock

C. Tick (√) the correct statement and cross (x) out the wrong one.

1. False (×) 2. True (√) 3. True (√) 4. False (×)


1. Graphical User Interface of operating system is made of graphical components such as icons, windows,

menus etc.

2. Taskbar includes Start button, System Tray, Middle Section.

3. Windows theme refers to the visuals & sound i.e. the desktop background window colour & screen saver

and sound schemes on our computer.


Column-I Column-II

1. - d

2. - e

3. - b

4. - c

IT SKILLZ

Page | 19

5. - a

Chapter 3 – Tools of Word Processor - I A. Choose the correct answer.

1. d 2. a 3. c 4. b 5. d


1. Cases 2. Subscript 3. Paste 4. Toggle 5. Superscript


1. Text formatting refers to changing the text appearance; to make it attractive by changing its style, font,

size and color etc.

2. Spell Check tool is very useful as it helps in correcting the spelling of the word by replacing it with the

correct spelling word. Spell Check highlights the incorrect word. We can also decide to ignore it or type in

the spelling manually.

3. Upper, Lower, Toggle, Sentence, Capitalize each word.

4. i. Home ii. Ctrl + End iii. Ctrl + PgUp iv. End

5. One meaning of sedulous is meticulous which may not be listed in Word dictionary. However, another

close meaning of meticulous is careful. Type sedulous in MS Word. Select it and press Shift + F7 or Review

tab > Thesaurus option in Proofing group. Thesaurus pane will open up and list meanings of sedulous. Right

click on the word careful in the list and select Insert.

D. Tick (√) the correct statement and cross (×) out the wrong one.

1. False (×) 2. True (√) 3. False (×) 4. True (√) 5. True (√)


Column-I Column-II

1. - d

2. - e

3. - a

4. - b

5. - c

Chapter 4 – Tools of Word Processor - II A. Choose the correct answer.

1. c 2. b 3. a 4. b 5. d


1. Left 2. Bullets 3. Paragraph 4. Ctrl + E 5. Ctrl + Shift + L

IT SKILLZ

Page | 20


1. Numbering of items is done when we need to list certain steps in a sequence to do something. For

example, the steps to switch on a computer.

2. Justified text alignment distributes the text evenly between left and right margin (Teacher should ask the

students to find the answer to this question, students should bring mouse pointer on the Justify button in MS

Word and read what pop-up help says)

3. Bullets are used to list items which may not be in a particular sequence. For example, Computer Lab

Rules.

4. The actual, working file created in a software application is called soft copy and its printout from a printer

is called hard copy.




Column-I Column-II

1. - c

2. - a

3. - d

4. - e

5. - b

Chapter 5 – The Internet: Web Browser A. Choose the correct answer.

1. b 2. a 3. c 4. d 5. b


1. Hyperlink 2. Web site 3. Google Chrome 4. Web server 5. Address bar


1. A browser/web browser is an application software that is used to access the information (websites) on the

web. Mozilla Firefox, Internet Explorer, Google Chrome, Safari, Opera and Brave are some commonly used

browsers.

2. Address bar, Search bar, Refresh/Stop, Home, Tools

3. In the History panel, right click on the desired URL and select Delete option.

4. A search engine is a website which is used to search information on the World Wide Web.

IT SKILLZ

Page | 21

D. Define the following terms.

1. Favorites: It lists the URLs of the web pages which are added by you as favourites. They are also called

bookmarks. We can add opened web pages to Favorites by clicking on Add to favorites button

2. History: It lists the URLs of the web pages visited in past days and months.



Chapter 6 – MS PowerPoint: Getting Started


1. b 2. c 3. a 4. d 5. a


1. Ctrl+N 2. .pptx 3. Shift+F5 4. Status bar 5. Blank Slide


1. A presentation is the manner of presenting a topic in an electronic form.

2. Slide Show tool is used to present the series of slides one by one in a full screen mode.

3. A slide layout is the arrangement of the objects/items on a slide.

4. Select the slide in the slide pane and press Delete key on the keyboard.

5. Click on File tab and select Close option.

D. Label the parts of PowerPoint window.


1. False (×) 2. True (√) 3. True (√) 4. True (√) 5. False (×)

IT SKILLZ

Page | 22

Chapter 7 – Step-wise Thinking A. Choose the correct answer.

1. c 2. d 3. b 4. c 5. c


1. Thinking 2. Solution 3. Right 4. Actions 5. Tasks


1. True (√) 2. False (×) 3. False (×) 4. True (√) 5. False (×)


1. Stepwise thinking is the ability to think the right way. It is a process in which we decide the number

and sequence of steps to accomplish a task successfully.

2. Some tasks are too big or complex to complete at once so they are divided into a set of several smaller

tasks. These smaller tasks are called sub-tasks.

3. i. Put the first match stick as base.

ii. Put second match stick at 90 degrees with base stick touching its left end.

iii. Likewise put the third match stick touching right end of the base stick.

iv. Put the third stick on the top of left and right vertical sticks completing the square.

4. i. Tear off that end of the wrapper which has candy’s handle/stick. ii. Reach inside the wrapper and grab

the candy stick. iii. Pull out the candy. iv. Eat the candy.

Chapter 8 – Organisation of Folders A. Choose the correct answer.

1. c 2. b 3. c 4. b 5. d


1. dot 2. F2 3. Recycle Bin 4. Shift 5. Secondary


1. A file stores data and information on a storage device. Each file is given a filename, which is useful to

identify it.

2. A folder stores files and other folders. It helps in organizing our files and folders.

3. i. A folder helps in organizing our files and folders.

ii. We can use folders to distribute multiple files to others. Just keep them in a folder and copy the whole

folder to the pen drive or CD.

4. Select the desired folder, press F2 key, type the new name and press Enter key.

5. Open Recycle Bin. Locate the deleted file in it. Right click on it and select Restore option.

IT SKILLZ

Page | 23


1. True (√) 2. True (√) 3. True (√) 4. True (√) 5. True (√)

E. Match the following keys with their functions.

1. c 2. e 3. d 4. a 5. b

Chapter 9 – Logical Thinking with Kodu A. Choose the correct answer.

1. b 2. a 3. a 4. d 5. a


1. Computer 2. Program 3. New World 4. Change Settings 5. Load World


1. To create computer programs and games we need to think logically. Kodu helps us in developing logical

thinking since it is used to create games which involves thinking in steps and logic.

2. Terrain in Kodu id the place where we keep the characters of the game. It is the playground for the

characters of the game.

Characters are available in Kodu library organized in various categories. Examples, jet, cannon, rock, fish

etc.

View of the Kodu terrain is the camera. We sit right behind the camera and look at the characters in terrain

through the camera.

3. a. Click on Object tool > select the character > from top colour bar, select the colour by using left/right

arrow keys on the keyboard.

b. Click on Object tool > right click on the character > select Change size option > adjust the size slider with

left/ right arrow keys on the keyboard.

c. Click on Camera tool > right click with mouse and move the mouse up, down and sideways.

c. Click on Camera tool > left click with mouse and move the mouse up and down.

D. Identify the parts of following Kodu Game Screen.

1. Terrain 2. Characters 3. Play Game button 4. Camera Tool 5. Object Tool

IT SKILLZ

Page | 24

Class 5 SYLLABUS

Term - I

1. Evolution of Computers

2. Computer Software

3. Advanced Features of Word Processor - 1

Term - II

4. Advanced Features of Word Processor - 2

5. MS PowerPoint: Formatting Presentation

6. Introduction to Scratch

7. Internet Services

Popular Computer Applications Skills

8. GIMP Basics

9. Animation Basics

Exercises

Chapter 1 – Evolution of Computers A. Choose the correct answer.

1. a 2. c 3. a 4. c 5. d


1. Napier’s Bones 2. Assembly 3. Silicon Chip 4. Program 5. Versatile


1. False (×) 2. True (√) 3. False (×) 4. False (×) 5. False (×)

IT SKILLZ

Page | 25


1. Generation of Computers refers to the time period in which the computers are being developed. Each

generation of computers has distinct features and technology.

2. Characteristics of computers: i. Computers give accurate output if correct input is given. ii. Computers can

perform a variety of tasks. iii. Computers can work for very long hours without getting tired.

Limitations of computers: i. Computers do not have self-intelligence. ii. Computers do not express emtions

like humans do. iii. Computers are not a complete replacement of human beings or human resource.

3. a)

3. b)

4. The 3 limitations of computers are:

1. Computers do not have self-intelligence: Computers perform exactly as the instructions are fed to

them. They cannot figure out situation on their own. They are unable to take their own decisions.

2. Computers cannot learn: Computers are not able to retain the knowledge and use it further just like

we humans do. Computers just store the data.

3. Computers cannot express emotions: Computers do not react to the situations. The warnings and

errors they display are the part of the programs they run. They do not have emotions and feelings.

E. Briefly describe the characteristics of computers very briefly.

1. Diligent: Computers work for longer hours without getting tired. They do not get bored doing the same

task again and again.

2. Versatile: Computers are capable to perform a variety of tasks and at the same time. This is called their

versatility.

First Generation Computers Second Generation Computers

1. Vacuum Tubes were used.

2. Big in size.

3. They were expensive.

4. E.g. NIVAC, ENIAC

1. Transistors were used.

2. Small in size.

3. Cheaper than first generation of computer

4. E.g. IBM 1401, PDP- I

Third Generation Computers Fourth Generation Computers

1. Transistors were miniaturized

to make Integrated Circuit.

2. Increased speed and

efficiency.

3. Computers are smaller than

previous generations.

4. E.g. PDP-8, PDP-11, IBM 360

1. VLSI microprocessors.

2. Smaller desktop computers

3. Computers could be connected to form a

network.

4. GUI based Operating systems.

5. E.g. IBM PC, Apple Macintosh

IT SKILLZ

Page | 26

3. Accurate: Computers are accurate in calculation however, their accuracy depends on the accuracy of

input. This means, computers will only give incorrect output if input is incorrect.

4. Fast: Computers think in milliseconds. That means, processor of a computer can perform billions of

calculations in a second.

F. Match the following.

Column-I Column-II

1 - c

2 - d

3 - a

4 - b

Chapter 2 – Computer Software A. Choose the correct answer.

1. c 2. d 3. a 4. b 5. d


1. Programs 2. Suite 3. Memory 4. Programming Language 5. General Purpose


1. True (√) 2. False (×) 3. True (√) 4. False (×) 5. True (√)


1. A program is a set of instructions arranged in a logical sequence. Different programs together make a

software and a package of software is called suite.

2. The four programming languages are C, C++, Java and Python.

3. Operating system: Windows, Linux Application software: MS Word, Adobe Photoshop

Utility software: McAfee Antivirus, Backup-Restore

4. Defragmenter: The process of speeding up file access and to make more space for storing files is called

defragmentation and the utility is called defragmenter.

Backup and Restore: To avoid data loss due to any reason (system crash, physical damage, virus) we

regularly keep a backup copy of our data which can be restored as and when required.

5. General purpose software are designed to address the requirements of a major field such as publishing,

database, spreadsheets etc. while customized software caters to the specific requirements of a customer such

as a school, shop, home business. General purpose software are useful for different firms and businesses

whole customized software for one customer may not be useful for another.

IT SKILLZ

Page | 27

Chapter 3 – Advanced Features of Word Processor - 1 A. Choose the correct answer.

1. b 2. a 3. d 4. a 5. a


1. Page setup 2. Custom margins 3. Letter 4. Insert 5. Superscript


1. Some common page layout options are margins, orientation, size and columns.

2. The steps to setup page margins as 1.5" are:

1. Page Setup group > Layout tab > Margins drop-down.

2. Select Custom Margins...

3. In the Page Setup dialog box, go to the Margins tab.

4. In Margins section, set the Top, Bottom, left and Right margins as 1.5".

5. Click OK button.

3. If the page’s width is more than its height then it is in landscape orientation (horizontal). If page’s height

is more than its width then it is in portrait orientation (vertical).

4. Contents in header and footer are displayed on all pages automatically without having to mention them

manually on each page. Hence, they are useful in inserting information like image of school logo, titles, page

numbers, dates, company name etc.

5. Replace option replaces the currently found (highlighted) text. Replace All option replaces all the

instances of the text found. Find Next option jumps to any next instance of the text found.



E. Write the steps of the following:

1. To set two columns in the document, in Columns drop-down in Page Setup group under Layout tab select

option Two.

2. To display page number in header except the first page, under Design tab, select the option Different First

Page.

3. Apply subscript in some chemical equations, select the text or letter that needs to be in subscript and press

Ctrl + = or select Subscript option in Font group under Home tab.

Chapter 4 – Advanced Features of Word Processor - 2 A. Choose the correct answer.

1. a 2. a 3. d 4. b 5. c

IT SKILLZ

Page | 28


1. Draw text box 2. Shading 3. Callouts 4. 3-D Rotation 5. Ruler tab


1. Page border tab allows setting the page border style, width, colour etc. while Shading tab allows to apply a

background colour or patterns behind the text.

2. To set shape outline to red colour, select the shape > Go to Format tab > Shape Styles group > Shape

Outline drop-down > Select red colour.

3. The tabs that can be set on a page are left, right and center.


1. False (×) 2. False (×) 3. True (√) 4. False (×) 5. True (√)

Chapter 5 – MS PowerPoint: Formatting Presentation A. Choose the correct answer.

1. a 2. c 3. c 4. b


1. Theme 2. Center 3. Hide background graphics 4. Bullets 5. Vertical alignment


1. Design themes are preformatted themes for slide design such as colours, text fonts, background styles etc.

A theme can be applied to give the slides a consistent look.

2. To change the background of a slide, first go to the desired slide. On the Design tab, in the Customize

group, click on the Format Background button. In the Format Background pane select the required colour

from the Color grid.

3. In justified alignment text is spread uniformly so that every line of the text is at equal distance from the

left and right margin. In center alignment, text is aligned exactly in the center of the page or text holder.

4. To insert a picture on a slide:

1. Go to Insert tab, in the Images group, click on the Picture button.

2. In the Insert Picture dialog box, locate and select the picture that you want to insert.

3. Click on the Insert button.


1. True (√) 2. True (√) 3. True (√) 4. False (×) 5. True (√)

IT SKILLZ

Page | 29

Chapter 6 – Introduction to Scratch A. Choose the correct answer.

1. a 2. c 3. d 4. a 5. b


1. Duplicating 2. Event 3. Instruction 4. Pen down 5. Motion


1. True (√) 2. True (√) 3. False (×) 4. False (×) 5. True (√)


1. Step is a well-defined and doable part of problem solving. Steps are the actions we take to complete a

task. We need to think stepwise to solve any problem or to perform a task successfully.

2. Writing and arranging instructions in a program is called programming. Programs are written to solve any

problem or to get any task done by the computer.

3. The logical set of instructions is called a program. To run all the instructions, we just need to run that

program on the computer.

4. In the kids, Scratch develops the ability to think creatively, make decisions reasonably, plan for problem

solving and communicate ideas.

5. a. Add a new sprite on stage: 1. Above the Sprites palette, click on Sprites from library icon. Sprites

library will be displayed where sprites are organized in various categories.

2. Double click on the desired sprite. (We can select the sprite and click on OK button also).

b. Duplicate a sprite: Right click on the desired sprite and select duplicate option.

c. Delete a sprite: Right click on the desired sprite and select delete option.

Chapter 7 – Internet Services A. Choose the correct answer.

1. c 2. b 3. c 4. d 5. b 6. c


1. Hyperlinks 2. 4G 3. ISP 4. Trash 5. Blogger


1. True (√) 2. False (×) 3. False (×) 4. True (√) 5. True (√)


1. Hardware and software required to access Internet are - a telephone or cable line, a modem and a web

browser such as Internet Explorer or Chrome.

2. A company that provides the access to internet is called Internet Service Provider (ISP). Access is

provided through a modem that connects your computer with the service providers internet server. Some of

the commonly used Internet connectivities are Dial-up, 3G/4G, Cable internet and WiFi.

IT SKILLZ

Page | 30

3. Replying a mail means the message is a response that goes back to the sender of the mail. Forwarding a

mail means sending the mail from someone to others.

4. Facebook is free and the most popular social website that allows people to register for free and interact

with each other. You can send the friend requests to other people to become online friends.

Some important features of Facebook are given here.

Wall: Your own profile page is called Wall. What ever you post, goes to your wall. Other people can also

post at your wall or comment on your posts.

Pages: You can create pages on various topics and invite people to visit.

Events: You can create events and send invites to people.

Photo Albums: You can upload and organise the pictures and videos in albums.

News Feed: In the middle of your wall status updates of other people are displayed.

Privacy Settings: Facebook has excellent security options which allow you to setup secured access to your

content.

Profile picture and Cover Picture: On your wall, you can setup a small profile picture and in the background,

a large cover picture.

Chapter 8 – GIMP Basics A. Choose the correct answer.

1. c 2. b 3. a 4. d 5. a


1. Toolbox 2. Templates 3. Shift 4. Flattening


1. False (×) 2. True (√) 3. False (×) 4. True (√)

D. Answer the following questions briefly.

1. Pencil tool is used to draw freehand figures. Bucket Fill tool is used to fill colours and patterns in a

drawing.

2. Subtract selection mode removes he newly selected area from the previous selection while intersect mode

keeps the selected area crated by the overlapping of the selections.

3. Hiding a layer makes the layer invisible. It is useful to focus on the layers you work presently. Locking a

layer makes the layer un-editable. Changes cannot be made on the locked layer.

Chapter 9 – Animation Basics A. Choose the correct answer.

1. b 2. c 3. a 4. d

IT SKILLZ

Page | 31


1. Animation 2. Panel 3. Control 4. 12


1. An animation is the simulation of movement created by displaying a series of pictures or frames. For

example, cartoons.

2. The Timeline is the area where we organize and control time-based animation in Flash. It contains

animation frames in a sequence.

3. Flash window contains Timeline, Toolbox, Stage, Property Inspector and Library panel.

4. An animation is composed of multiple frames. Any frame that defines a new movement across the frames

is called Keyframe. For example, to show a jumping ball, one keyframe will show the ball on ground, the

other keyframe will show the ball in mid air and the yet another keyframe may show the ball higher up in the

air.

IT SKILLZ

Page | 32

Class 6

SYLLABUS

Term – I

1. Computers: Categories and Languages

2. File Management: Organisation of Data

3. Word Processor: Tabular Presentation

4. Word Processor: Mail Merge

Term - II

5. Presentation: Visual Effects

6. Game Creation in Scratch

7. HTML: An Introduction

8. Internet: Online Surfing


9. Animation, Morphing and Sound

Exercises

Chapter 1 – Computers: Categories and Languages A. Choose the correct answer.

1. b 2. d 3. b 4. a 5. a


1. 1G, 4G 2. Servers 3. Micro computers 4. 0s and 1s, 4G 5. Compiler



D. Give 2 examples of the following computer generations.

1G: UNIVAC, ENIAC

2G: IBM 1401, PDP 1

IT SKILLZ

Page | 33

3G: IBM 360, PDP 8

4G: IBM-PC, APPLE-MACINTOSH

E. Answer the following questions.

1. 1G: Vacuum tubes

2G: Transistors

3G: Integrated circuits

4G: Microprocessor

5G: Artificial Intelligence

2. i. First generation:

a. The first generation computers used the vacuum tubes.

b. It was expensive, consumed large amount of electricity and generated a lot of heat.

ii. Second generation:

a. Transistors replaced vacuum tubes in the second generation of computers.

b. It was smaller, faster, cheaper, energy- efficient and reliable than the 1G computers.

iii. Third generation:

a. Transistors were miniaturized and placed on silicon chips, called Integrated Circuit (IC), which

increased the speed and efficiency of the computers.

b. 3G computers had keyboards, monitors and Operating System to run run different applications

simultaneously.

iv. Fourth generation:

a. The microprocessor is the basic component of 4G computers, as thousands of ICs are built into a

single silicon chip called Very Large Scale Integration (VLSI).

b. The computers can be placed on small tables and can be networked.

v. Fifth generation:

a. Ultra LSI technology takes over from VLSI.

b. 5G computers will be able to process massive batches of data at a very high speed.

3. i. Super computer

a. These computers use very high level of technology.

b. They have very high memory capacity.

ii. Mainframe

a. Smaller in size than the super computer.

b. Large memory capacity.

IT SKILLZ

Page | 34

iii. Mini

a. Higher processing speed than lower category computer but slower than super computer and

mainframe computer.

b. They are expensive and larger than microcomputers.

iv. Micro

a. These are smaller than mini computers.

b. These are high speed computers.

F. Match the following.

1. d 2. b 3. a 4. C

Chapter 2 – File Management – Organisation of Data A. Choose the correct answer.

1. a 2. c 3. b 4. c 5. d


1. Secondary 2. P* 3. P?? 4. Document 5. Virtual desktops


1. Copying a file means making a copy of the file and place it in another location while moving a file means

changing the location of the original file.

2. In search box, type H???

3. Operating system associates a file type with a program by the secondary name or extension of the file. For

example, myfile.txt file will open in a text editor and myfile.jpg will open in an image editing program.

4. By default, there is one desktop visible. Windows 10 allows adding more desktops. These additional

desktops are called virtual desktops which can be deleted later. Main desktop cannot be deleted.


1. False (×) 2. True (√) 3. False (×) 4. False (×) 5. True (√)

E. Write the steps to do the following.

1. Open This PC > Select the D: drive in Navigation pane. > Locate your file > Click on the file and press

Ctrl + X > Select the G: drive and press Ctrl+V.

2. Open Recycle Bin from the Desktop > Locate the file > Right click on the file and select Restore option.

3. Press Window key + X > In the menu, select Task Manager option > In Task Manager window, go to

Processes tab > Select the desired program and click on End Task button.

4. Right click on the Taskbar and select Show windows side by side option.

IT SKILLZ

Page | 35

Chapter 3 – Word Processor: Tabular Presentation A. Choose the correct answer.

1. b 2. d 3. c 4. d 5. b


1. Rows, columns 2. Using Grid option 3. Row 4. Column

C. Match the following.

1. b 2. c 3. a 4. e 5. f 6. d


1. True (√) 2. True (√) 3. True (√) 4. False (×) 5. True (√)


1. Tables is used to present the data in the form of rows and columns. Ros are horizontal and columns are

vertical. Data is placed in the cells made by the intersection of rows and columns.

2. a. A row is the horizontal series of cells.

b. A columns is a vertical series of cells.

c. A Cell is made of the intersection of a row and column.

3. Shift + Delete

F. Write the steps for the following.

1. To merge the cells: 1. Select the cells that you want to merge.

2. Click on the Layout tab.

3. In the Merge group, click on the Merge Cells button.

2. To split a cell: 1. Click in the cell that you want to split.

2. Click on the Layout tab.

3. In the Merge group, click on the Split Cells button. The Split Cells dialog

box appears.

4. Enter the number of columns and rows into which you want to split the

selected cell.

5. Click on OK button.

Chapter 4 – Word Processor: Mail Merge A. Choose the correct answer.

1. a 2. c 3. d 4. d


1. Data Source 2. Merge Field 3. Next Record, Previous Record 4. Merged document

IT SKILLZ

Page | 36


1. Mail merge tool is used to create a document for multiple recipients. All the variable information can be

inserted at once to generate multiple documents. This way a lot of time and hard work is saved.

2. i. Data Source: - It contains recipients’ details that is to be merged with the main document.

ii. Main Document: - It is a document which has the common data that needs to be sent to multiple

recipients.

3. Steps to insert merge fields in the document are:

i. Put cursor on the main document where you want to merge a field. On Mailings tab, in Write and Insert

Fields section, click on Insert Merge Field button, a list of fields from selected data source appears.

ii. Click on a field to merge. Repeat this process till you merge all the fields.

4. Steps to view merged data are:

i. Click on Preview Result button in Preview Results section on Mailings tab.

ii. To view next or previous data click on Next Record or Previous Record buttons.

Chapter 5 – Presentation: Visual Effects A. Choose the correct answer.

1. c 2. c 3. c 4. a 5. d

B. Fill in the Blanks

1. Normal 2. Start with Previous 3. Action 4. Title and Content 5. Playback


1. Slide Master view enables you to modify the slide layout and appearance of the slides in the presentation.

Slide Sorter View shows all the slides in thumbnail form. It helps in applying transition effects and design

changes to the whole presentation at once. This view also helps in changing the sequence of the slides.

2. In Exit type of animation, an object disappears or goes away from the slide with some animation effect.

Entrance type of animation is the animation effect with which an object appears on or enters the slide.

3. The special effect with which current slide is replaced by the next slide on the screen is called slide

transition.

4. Action buttons are the shapes which can be added to the slide. Clicking on the action button leads to some

task executed like going to another slide, playing a sound or running another application.

Chapter 6 – Game Creation in Scratch A. Choose the correct answer.

1. d 2. b 3. a 4. c 5. b 6. b

IT SKILLZ

Page | 37

B. Fill in the blank.

1. Animation 2. Library 3. Looks 4. Variable 5. answer


1. A block is like an instruction in Blocks library used to create the script. A sprite is the character that

makes the animation. Script is created for the sprite.

2. Drag-drop Move block move ___ steps in the script editor and set its value to 100.

3. if-then block is used when no alternative action has to be taken if the condition with if block returns false.

In -f-else block, if condition returns true then if block executes otherwise else block executes.

4. Reiteration means executing one or more blocks repeatedly. repeat and forever are two loop blocks in

Scratch.

5. A variable is the storehouse of value in Scratch. To create a variable: In Scripts tab > Data Category >

click Make a Variable. In the dialog box, give variable name and click OK.

Chapter 7 – HTML: An Introduction A. Choose the correct answer.

1. d 2. d (None of these) 3. c 4. d 5. a


1. Head, Body 2. Empty 3. Pre 4. Entity 5. 7


1. Empty element: In HTML, elements that have only opening tag are called empty tags. There is no closing

tag. These tags do not act on blocks of text.

For example: <hr>, 

Container element: In HTML, elements that include both the start tag and end tag are called container tag.

They hold or contain the text between the two tags (opening and closing).

For example, <body> text being formatted or defined</body>

2. i. Size: Set the size of the font. There are accepted values between 1 (the smallest) and 7 (the biggest). The

standard value of a text is 3.

ii. Color: You can set any font colour as per the requirement using the colour attributes. You can specify the

colour that you want by either the colour name or hexadecimal code for that colour.

iii. Face: Font face attribute is used to change the font style of the text. You can choose any font which is

installed on your computer. The default font face is ‘Times New Roman’.

3. 32 = 9 H2O


1. False (×) 2. False (×) 3. True (√) 4. False (×) 5. False (×)

IT SKILLZ

Page | 38


Column-I Column-II

1. - g

2. - f

3. - c

4. - d

5. - e

6. - b

7. - a

Chapter 8 – Internet: Online Surfing A. Choose the correct answer.

1. b 2. d 3. b 4. a 5. c


1. Wordpress 2. Podcast 3. Weak 4. Sheets 5. C2B


1. Four best practices for online safety are:

1. Be discreet: Never share your personal information with everyone.

2. Safe downloading: Talk to your parents and teachers before downloading any software or game.

3. Personal photos: Never share photos of yourself and family members with strangers or even

friends whom you cannot trust.

4. Anti-virus: Always keep a good anti-virus software installed on the computer. Ask your parents to

run anti-virus regularly.

2. Any sort of threat or harassment over internet is the act of cyber bullying. For example, messages in bad

taste and intention, online mockery in friend groups or circles, stalking someone's online profile etc. Two

ways to handle cyber bullying are:

1. Children should inform their elders about any incident that sounds nasty even remotely.

2. Children are advised to block such intruders immediately and never entertain them.

3. E-commerce refers to the purchase and sale of goods and/or services by business firms and consumers via

electronic channels online. It has four types such as Business-to-business, Business-to-Consumer,

Consumer-to-Consumer and Consumer-to-business.

4. The correct sequence of steps in online shopping is: 4 > 1 > 3 > 5 > 2



IT SKILLZ

Page | 39

Chapter 9 – Animation, Morphing and Sound A. Choose the correct answer.

1. b 2. c 3. d 4. a


1. Shape tween 2. Instance 3. Morphing 4. Sound


1. A symbol is a complete object in itself. It could be a button, movie, graphic or animation. A copy of any

symbol used in animation is called instance.

2. Without sound the animation looks lifeless. Sound adds soul to the animation and it looks more real.

3. Changing a shape into another one is called morphing. It is achieved by applying Shape tween in which one

shape changes into another.

IT SKILLZ

Page | 40

Class 7

SYLLABUS

Term - I

1. Computer: Hardware Components

2. Number System: An Introduction

3. Computer Viruses

4. Ethics and Safety Measures in Computing

5. Introduction to Spreadsheets

Term - II

6. MS Excel: Working with Worksheets

7. Database Management System

8. Working with MS Access

9. Lists and Images in HTML

10. Tables, Hyperlinks and Forms in HTML


11. Drawing Tools and Layers in Flash

12. Photoshop: Quick Introduction

Exercises

Chapter 1 – Computer: Hardware Components A. Choose the correct answer.

1. a 2. c 3. c 4. a 5. d


1. Wireless 2. Mouse 3. DMP 4. QR Code Scanner 5. Alternate, Direct


1. True (√) 2. True (√) 3. False (×) 4. True (√) 5. True (√)

IT SKILLZ

Page | 41


1. Peripheral input device: Scanner, web cam Peripheral output device: Printer, Plotter

2. Buses are found on motherboard and carry data from one device to another. System unit is the cabinet inside

which mother board in main devices are enclosed. Motherboard is a large circuit board to which main computer

devices like RAM, ROM, CPU etc. are connected.

3. A port is a channel to connect peripheral devices like printers and scanner with the computer. These ports

are usually found at the back of the system unit. Most popular type of port is Universal Serial Bus (USB) port

which can connect any modern device like printer, pen drive, keyboard, mouse etc. Network port connect a

computer to the network by network cable. Serial ports connect monitor etc. Parallel ports connect printers

etc. USB ports connect USB devices.

4. RAM: Store user’s working data and running programs.

Printer: Prints out user’s work in the form of various types of documents.

Plotter: Prints designs and maps.

USB Port: Connects modern device like printer, pen drive, keyboard, mouse, smart phone etc. with the

computer.

QR Code Scanner: Quick Response code (QR Code) scanner reads a matrix or pattern of dots. Handheld

devices also have QR Code scanning apps. You will find these codes printed on most of the products such as

books and house hold objects.

Chapter 2 – Number System: An Introduction A. Choose the correct answer.

1. b 2. c 3. a 4. c


1. 10 2. 15 3. 0 with carry 1 4. 2 5. Decimal


1. True (√) 2. False (×) 3. False (×) 4. False (×) 5. True (√)


1. Refer to page 22 and 24 Headings Binary Number System, Decimal Number System, Octal Number

System and Hexadecimal Number System.

2. Various number systems are useful in specifying various computer designs. This is the reason we have

different number systems. They also help us in converting values of one number system to another. Most

suitable number system for computers is binary number system.

3. Refer to the examples on pages 22 and 23.

4. Binary number system has only two digits 0 and 1 while hexadecimal number system has 16 digits – 0 to

9 and A to F. Example: Decimal equivalent of 8 is 1000 while number 15 in hexadecimal is represented by

letter F.

IT SKILLZ

Page | 42

5. Computers interpret values as presence (1) or absence (0) of electrical pulse. These are two possible states

of bit hence binary number system is most suitable for computers. A set of 8 bits make a byte and so on.

6. a. 010001111

b. 1011101

c. 10101010

d. 1001000

e. 110000100011

f. 10000001

g. 1101

7. a. 01001

b. 011011

c. 10000000

d. 0110101000110

Chapter 4 – Computer Viruses A. Choose the correct answer.

1. d 2. b 3. d 4. c 5. d


1. Virus 2. Boot sector 3. Stealth 4. Worms 5. Spyware


1. False (×) 2. True (√) 3. True (√) 4. False (×)


1. A computer virus is a harmful program which attaches itself with the computer files and infects them. It is

capable of making its copies. Harms caused by viruses are denying access to data, corrupting files and

deleting data.

2. i. Computer starts up slowly and/or works slower than earlier.

ii. Computer suddenly hangs or crashes and needs to be restarted abnormally.

iii. Unwanted pop-ups and notifications appear which were not there earlier.

3. i. Install an effective spyware detecting software.

ii. Keep your operating system and browser updated.

iii. Check if any unnecessary software is being installed.

4. An anti-virus detects viruses by their signature or behaviour. A virus signature is the unique structure of a

virus program which anti-viruses are aware of. Anti-viruses have a list of known virus signatures with which

they can identify the possible virus. That is why anti-viruses need regular updates.

IT SKILLZ

Page | 43

Chapter 4 – Ethics and Safety Measures in Computing A. Choose the correct answer.

1. a 2. c 3. d 4. b 5. a


1. Virus 2. Firewall 3. Spyware 4. Phishing 5. Padlock




1. Trojan is a program promoted as useful program but once installed it harms the computer. A worm slows

down the computer and replicates itself from one computer to other over a network.

2. Phishing: Fraudulently acquiring sensitive information from the users by impersonating trusted websites

like banks and e-commerce merchants etc. is called Phishing. Phishers target the details like pins, passwords

and answers to security questions. Phishing occurs generally in the form of an email or through a legitimate

sounding phone call.

Pharming: When website's traffic is redirected to another unauthorized fake URL then it is called pharming.

Hackers somehow get access to the website's servers and manipulate the configuration files which identify

the server as host website on Internet.

Protection: i. Install anti-phishing software.

ii. Never give away any sensitive information related to finance and security like pins, passwords, bank

balance, transaction details, identification numbers etc. in reply to undesired emails and never on phone.

3. i. Children must know that their parents and teachers are always available for them when they face such

problem.

ii. Children must know that no matters what, parents and teachers are their first support.

iii. Children should inform their elders about any incident that sounds nasty even remotely.

iv. Children must know the fact that cyber bullies are not capable to do any harm and they can never carry

out their claims of harming someone.

v. Children are advised to block such intruders immediately and never entertain them.

4. A firewall is a security combination of hardware and software that is used to protect a server and network

resources from unauthorized access and intrusion.Firewall checks the incoming data packets over the

networks and filters out which do not have suitable and sufficient permission to access the network. This

way an extra level of protection is created right at the gates of the network.

5. Windows updates and update of your browser fills any security holes and bugs which hackers can use to

access your computer. Do not install undesired utilities or plugins in your browser.

IT SKILLZ

Page | 44

Chapter 5 – Introduction to Spreadsheets A. Choose the correct answer.

1. a 2. c 3. b 4. d 5. d


1. 1048576 2. Active Cell 3. Formula Bar 4. Shift + Spacebar 5. Ctrl + Spacebar


1. True (√) 2. True (√) 3. True (√) 4. True (√) 5. True (√)


1. In Excel, numbers and calculations are managed efficiently. Data can easily be created, analyzed and

maintained.

2. i) Press Windows + R key and type ‘excel’ in the dialog box. ii) Click on OK button.

3. Quick Access toolbar, Ribbon, Cell Name box, Active Cell, Formula bar, Rows, Columns, Sheet tab and

Status bar.

4. a) Formula bar: It displays the data and formula entered in an active cell. It can also be used for

entering and editing data.

b) Workbook: An Excel file is known as a workbook. It can hold many worksheets.

c) Worksheet: A worksheet is a collection of cells in the form of rows and columns.

d) Cell reference: It is column letter and the row number that identifies a single cell.

e) Active cell: It is the current cell in a worksheet. It is displayed with bold border.


Column-I Column-II

1 - e

2 - d

3 - b

4 - a

5 - c

Chapter 6 – MS Excel: Working with Worksheet A. Choose the correct answer.

1. a 2. d 3. c 4. a 5. a


1. Shift cells down 2. Entire Row 3. Row, column 4. 12.75 5. 255


1. True (√) 2. True (√) 3. True (√) 4. False (×) 5. True (√) 6. False (×)


1. Copying refers to duplicating the data (text, numbers and formulae in the context of MS Excel), while

moving refers to move the data from its current location to another location.

2. As the name suggests, it is a tool that is used to fill a predefined series of data in adjacent cells quickly.

This can be easily done by dragging the fill handle of the cell.

3. i) Shift cells right: It shifts existing cells to the right to make a room for the blank

cells.

ii) Shift cells down: It instructs Excel to shift existing cells down.

iii) Entire row: It inserts complete row in the cell range above the selected cells (row).

IT SKILLZ

Page | 45

iv) Entire column: It inserts complete column in the cell range to the left of the selected cells

(column).

4. Undo command reverses the last action while Redo command reverses the Undo command.

5. To insert a cell/row/column,

i) Select the row/column header and press Ctrl + plus (+) to insert a row/column.

ii) Select the cell, above/left to which you want to add a cell, and press Ctrl + plus (+).

The Insert dialog box appears. Select the required option.


Column-I Column-II

1 - d

2 - a

3 - e

4 - b

5 - c

Chapter 7 – Database Management System A. Choose the correct answer.

1. a 2. c 3. b 4. a 5. c


1. Data 2. .accdb, .mdb 3. Files 4. Fields 5. Field


1. True (√) 2. True (√) 3. False (×) 4. True (√) 5. False (×)


1. Data are raw pieces of values which alone do not make any sense. For example, Anu, 12. Data pieces are

logically related together to make meaningful information. For example, Anu is 12 years old.

2. DBMS is a collection of programs that enables users to create, maintain database and control all the

access to the database.

3. A table stores the data in the form of horizontal rows (records) and vertical columns (fields).A query is

used to extract information from one or more tables.

4. Primary key identifies a record uniquely in a table. That is why, primary key cannot store duplicate or null

values.

5. Foreign key in one table has a matching primary key value in its parent table. For example, in parent table

STUDENT, under the primary key field admission_no has a value A001. In child table MARKS, the stuent

of same admission_no may have several records of different exams taken by him.

6. Refer to page number 90.

IT SKILLZ

Page | 46

Chapter 8 – Working with MS Access A. Choose the correct answer.

1. d 2. c 3. b 4. d 5. d


1. Numeric 2. One 3. Sort A to Z 4. * 5. Relationship


1. True (√) 2. False (×) 3. True (√) 4. True (√) 5. False (×)


1. Sorting means to arrange the records in a particular order depending on one or more fields while filtering

means displaying records that match with a given criteria.

2. One to one, many to one, many to many.

3. Referential integrity ensures that correct data is maintained in the database by checking that every foreign

key should have at least one matching record in parent table.

4. Relationship between the tables helps in maintaining correct data (referential integrity) and to extract

desired information (query) from multiple tables.

Chapter 8 – Lists and Images in HTML A. Choose the correct answer.

1. b 2. a 3. c 4. d 5. d


1. <li> 2. Src 3. Height, Width 4. <ol> 5. Left, Right


1. Ordered list is also known as numbered list (which uses an ordering system e.g., numbers, letters, etc.).

By default it starts with 1.

While, an unordered list is a bulleted list. Unordered lists simply have a plain bullet point for each item in

the list.

2. Nested list means a list inside another list. We can create an ordered list inside another unordered list or an

unordered list inside another ordered list.

For example, <ol type= “1”>

<li>Punjab</li>

<ul> <li>Khanna</li>

<li>Mansa</li>

</ul>

IT SKILLZ

Page | 47

<li>Haryana</li>

<ul> <li>Sonepat</li>

<li>Faridabad</li>

</ul>

</ol>

3. In HTML, images are defined with the <img> tag. Src attribute is used with this tag to define the path of

the image.

Example: <img src="D:\images\logo.jpg">

6. <marquee> tag is used to set a scrolling text or image. ‘Behavior’ attribute is used to set the value which

shows how the content should scroll. Example, <marquee behavior="scroll"> ... </marquee>

Chapter 10 – Tables, Hyperlinks and Forms in HTML


1. d 2. a 3. a 4. b


1. Body 2. Colspan 3. Internal 4. Forms


1. False (×) 2. True (√) 3. False (×) 4. True (√)


1. Rowspan attribute is used to merge two or more rows.

2. Radio button is used to accept one of multiple choices from user in a form. It is created by setting type

property of input tag to radio. Checkboxes are used to accept multiple selections from the user in a form.

They are created by setting type property of input tag to checkbox.

3. Internal hyperlink works on the concept of Name and Href attributes of Anchor (<A>) tag. Name

attribute is used to give a unique name to the part of content which is to be displayed when hyperlink is

clicked. In the part of content which needs to work as internal hyperlink, Href attribute is given the same

value that was set in the name of the linked content.

<A href=“mypara”> Click here to go to internal link</A>

<A name=“mypara”> This is the linked content somewhere in the same file.</A>

4. An HTML form is a section of a document containing normal content, markup, special elements

called controls (checkboxes, radio buttons, menus, etc.), to get inputs from the user.

Chapter 11 – Drawing Tools and Layers in Flash A. Choose the correct answer.

1. b 2. d 3. c 4. d 5. d

IT SKILLZ

Page | 48


1. Toolbox 2. Oval, Shift 3. Layers 4. Timeline


1. The Line tool is used to draw straight lines while Pencil tool is used to draw freehand shapes. Both the

tools use some common settings like stroke colour, thickness etc.

2. A complex animation can be easily managed using layers by keeping various animation objects and

symbols in separate layers. We can work with one object in a layer at a time without affecting rest of the

parts of animation. To rename a layer, double click on the desired layer name in the timeline, type the new

name and press Enter key.

3. The sequence of layers in an animation can be changed by dragging the desired layer with mouse and

shifting it above or below the other layer.

Chapter 12 – Photoshop: Quick Introduction A. Choose the correct answer.

1. d 2. b 3. d 4. a


1. Option 2. Text 3. Rectangular marquee 4. Tolerance

C. Name the tools for the following:

1. Foreground color in Toolbox 2. Text Tool 3. Pencil Tool 4. Magic Wand Tool

IT SKILLZ

Page | 49

Class 8

SYLLABUS

Term – I

1. Operating System: Roles and Functions

2. Spreadsheets: Functions and Formulas

3. MS Excel: Presenting Data in Charts

4. Algorithm and Flowchart

Term - II

5. Program Coding: Level – 1

6. Program Coding: Level – 2

7. App Development

8. Network Concepts


9. Image Processing, Layers and Filters

10. Artificial Intelligence

11. A Tryst with Python

Exercises

Chapter 1 – Operating System: Roles and Function A. Choose the correct answer.

1. c 2. a 3. d 4. b 5. a


1. Taskbar 2. System tray 3. Title bar 4. Quick Launch Icons 5. Desktop

IT SKILLZ

Page | 50


1. True (√) 2. True (√) 3. False (×) 4. False (×) 5. True (√)


1. Character User Interface of Command Line Interface allows typing the commands and submitting them to

the computer to execute while graphical user interface provides suitable graphics like menus, icons,

windows etc. with which user can interact using mouse.

To work with CUI, we need to learn the commands and remember their correct usage. Incorrect

command shows an error message as a hint to the user to correct the mistake. In case of GUI, it is not

necessary to remember the commands since all the options are available in menus, toolbars and icons which

can be easily explored with mouse. CUI is difficult to learn and work with as compared to graphical user

interface.

2. The advantages of GUI are:

1. A GUI is graphical, so it is easier for the user to learn and use.

2. User does not need to remember the commands and their usage.

3. GUI is intuitive that is it gives visual and audio hints for user's guidance such as sounds denoting

something went wrong or blinking window or icon that needs attention.

4. GUI is customizable, so users can change its look and colour theme as they like.

3. Quick Launch bar: This is the set of icons of those programs which are launched with just a single click

on their icon. Icons of the programs needed frequently are set in Quick Launch bar.

Start Button: Start button is found on the extreme left end of the Taskbar. Clicking on this button opens up

Start Menu with the list of recent programs, various standard choices like Control Panel; Devices and

Printers etc. It also shows options to shutdown and restart the computer.

Notification Area: This area is also called System Tray. It shows the details of tasks and programs running in

the background such as antivirus, any updates etc. Clock is also shown in System Tray clicking on which

pops up Calendar also. Other common icons in System Tray are Network connection, Speaker, Language

etc.

4. The 3 important tasks of an Operating System are:

1. File system management – keeping track of all the files and folders.

2. Network management – communicating with other computers and devices over a network.

3. User interface – helps user to work on the computer and perform various tasks.

E. Match the Type of Operating System with its definition.

1d, 2c, 3a, 4b.

Chapter 2 – Spreadsheets: Functions and Formulas A. Choose the correct answer.

1. b 2. c 3. d 4. c 5. b

IT SKILLZ

Page | 51


1. Logical 2. Relational 3. NOT 4. Today() 5. Paste Values


1. False (×) 2. True (√) 3. True (√) 4. True (√) 5. True (√)


1. Relative referencing: A5 * 2

Absolute referencing: $A$5 * 2

Mixed referencing: $A5 * 2 OR A$5 * 2

2. A set of adjacent cells is called a range. It may be a vertical range across rows (A1:A5), horizontal range

across columns (A1:D1) or across rows and columns (A1:D5). In Excel, a range can be given a name called

range name. Such range names can be used in formulas and functions instead of specific cell addresses.

3. 1. Functions are in-built in Excel while formula are defined by user as per their requirements.

2. Formulas take arguments while functions make use of arithmetic operators.

4. AND() evaluates multiple conditions and returns true only if all the conditions are true while OR()

evaluates multiple conditions and returns true if any of the given conditions is true. It returns false only if all

the conditions are false. For example, AND(A1=10, B1=5) will return true of A1 has value 10 as well as B1

has value 5 exactly. OR(A1=15, B1=6) will return true if either A1 has value 15 or B1 has value 6.

Chapter 3 – MS Excel: Presenting Data with Charts A. Choose the correct answer.

1. c 2. b 3. d 4. d 5. d


1. Chart 2. Bar chart 3. F11 4. Analyse 5. Pie Chart


1. True (√) 2. False (×) 3. True (√) 4. True (√) 5. True (√)


1. The 2 major benefits of the charts are:

1. We can easily understand the data values.

2. We can analyse the data easily for further planning.

2. A chart or graph is a graphical form of data. With charts, the data can be presented in pictorial or

graphical form in different ways. Some common chart types are Column chart, Bar chart, Pie chart, Area

chart, Line chart etc.

3. The steps to create a chart are:

1. Select the cell range you want to chart (including column titles).

IT SKILLZ

Page | 52

2. Under Insert tab, in Charts group, click on desired chart type.

3. Select the chart sub-type from the drop-down list.

4. The steps to change the chart type are:

1. Select the chart on the worksheet.

2. Click on Design tab.

3. In Type group, click on Change Chart Type button. The Change Chart Type dialog box appears.

4. In All Charts tab, select the new chart type in left pane and its sub-type in the right pane.

5. Click on OK button.

5. The steps to customize the axis are:

1. Right-click on the value axis and select Format Axis option from the menu.

2. In the Format Axis pane, in the Axis Options category, click on Axis Options sub-category.

3. Make suitable changes in the options such as minimum and maximum bounds, major and minor

units, Axis value etc.

E. Match the Chart type in column A with its correct use in Column B.

1d, 2e, 3b, 4c, 5a

Chapter 4 – Algorithm and Flowchart A. Choose the correct answer.

1. b 2. b 3. a 4. c


1. Relational data model 2. Primary key 3. Schools, Colleges 4. Database

5. Hierachical


1. A flowchart is a graphical representation of steps of an algorithm. The advantages of a flowchart are:

1. Flowcharts are an easier way to depict the logic of the program.

2. Flowcharts, being graphical, help greatly in problem analysis.

3. Flowcharts of any program are good for documentation and later reference.

4. A flowchart helps in debugging process (to remove errors).

2. The advantages of Algorithm are:

1. It is the set of steps arranged in a logical sequence as a solution to a given problem.

2. It makes it easier to create the graphical representation of the program flow called flowchart.

3. It is in human language (English in our case) hence easy to understand.

4. It is easy to find logical errors since every step has its own logical sequence.

IT SKILLZ

Page | 53


1e, 2c, 3d, 4b, 5a

Chapter 5 – Program Coding: Level 1 A. Choose the correct answer.

1. c 2. b 3. d 4. a 5. d


1. .java, .class 2. Instance, blueprint 3. Inheritance 4. // 5. Polymorphism


1. False (×) 2. True (√) 3. True (√) 4. True (√) 5. True (√)


1. Class: A class defines the properties and behaviour of the objects. Objects of similar properties and

behaviour belong to the same class. For example, all the vehicles can be kept under a class: Vehicle. Once

class is defined, as many objects of that class can be created. In coding, properties are implemented by

member variables and behaviour is implemented by member functions or methods. A Java class looks like

this:

class vehicle

{

float price; //member variable

String registration_number; //member variable

public void setValues() //method

{

}

Public void showValues() //method

{

}

}

Object: An object is an instance of its class. As many objects as required can be created of a class. In coding,

objects are created in the memory and each object has its own set of member variables. For example,

vehicle v1 = new vehicle();

vehicle v2 = new vehicle();

Here, v1 and v2 are the objects of same class vehicle.

2. Abstraction and Encapsulation: Tendency to look for what is necessary is called abstraction. For example,

an adult will look in a watch if it tells the correct time and fits into the budget while a teenager will look for

IT SKILLZ

Page | 54

style and more trendy features in it.So, the two people look for different details in the same object! This is

abstraction – we see what we want to see.

Encapsulation means to hide unnecessary details. Hence, encapsulation is a tool to implement abstraction.

The service providers hide the functions and features which users are not supposed to see and expose only

those features which are necessary. For example, when we make a call on our smartphone, we need to dial

the number or select the contact to call and talk. Smartphone provides the necessary features to do that

exactly. This is encapsulation.

3. Please refer to pages 61and 62.

4. Arithmetic Operators: Arithmetic operators perform arithmetic operations on the values. These operators

return the type of values which they are working upon. For example, 10 + 3.2 will return 13.2 which is float

type or double type while 10 + 3 will return numeric or integer value. Addition operator + adds the two

values while % (modulus) operator returns the remainder of the division fir example, 13/3 will return 1.

Relational Operators: Relational or comparison operators compare two operands and return true or false. For

example, < (smaller than) operator will return true if first value is smaller or less than the second. If variable

a has value 10 then a<20 will return true. >= (greater than or equal to) operator will return true if first value

is equal or more than the second. If variable a has value 10 then a>=20 will return false while a>=5 will

return true.

5. main() function holds the arguments passed to it in a String type of array by some name. Array is a set of

same type of values in a sequence starting from position 0. For example,

public static void main(String argv[])

{

System.out.println(argv[0]) //displays first argument

System.out.println(argv[3]) //displays fourth argument

}

Chapter 6 – Program Coding - 2 A. Choose the correct answer.

1. c 2. a 3. b 4. d 5. a


1. else 2. Binary, unary 3. if 4. default 5. continue


1. True (√) 2. False (×) 3. True (√) 4. False (×) 5. False (×)

D. What will be the output of the following Java codes?

1. If number entered by the user is zero: It's zero

If number is divisible by 2: Even number

Otherwise: Odd number

2. 1 1 2 3 5 8 13 21

IT SKILLZ

Page | 55

3. No output since there is no print statement encountered. E will match case ‘E’, then program control drops

down to case ‘I’ where break is encountered and program control exits switch-case block.

4. 4 5 6…….. infinitely (value of variable a is 25 and increasing thereafter by 1 so it will remain > 0 always

keeping the condition true always.)

5. Until 0 is entered by the user, the sum of all the numbers will be calculated by the loop and finally it will

be displayed.


1. break terminates the loop or switch-case block and brings the control out of it. Any statements after the

block execute then. Any statements after break do not execute.

continue re-executes the loop from the beginning. It is useful when we need to run the loop again before it

completes all tasks within it.

2. do-while loop executes first and then condition is evaluated hence it runs at least once even if condition is

false even for the first time. while loop may execute zero times if the condition is false even for the first time

because in while, condition is evaluated before the loop can execute.

3. break brings the program control out of the switch block. If no break is used when a match is found then

all the other cases below the matched case will also execute. This may lead to undesired output sometimes.

Chapter 7 – App Development A. Choose the correct answer.

1. a 2. a 3. d 4. C 5. d


1. Categories 2. B2B 3. Installation 4. MIT 5. Viewer

C. Answer the following questions:

1. 5 features/ benefits of apps are:

i. Apps are easy to download and install on the device.

ii. Apps are mostly free and very lightweight (on memory and processor).

iii. Apps are generally not bound with license restrictions as software.

iv. App is an interface between the online services provided by the business and the customer.

v. Apps are a great way for businesses to reach their customers with lesser expenses and time.

2. Features of Hybrid apps:

1. Hybrid apps demonstrate the features of both native and web apps.

2. They provide certain important features even if device is not connected with the Internet.

3. They are integrated with the operating system of the device as well as the web-based services.

4. Hybrid apps store some content locally while rest of the content is stored on web server.

3. Gaming apps: Candy Crush, Temple Run

IT SKILLZ

Page | 56

Business apps: Amazon, OLX

Lifestyle apps: Tinder, Around me

Entertainment apps: Netflix, Amazon Prime

4. To install a Google android app from Google Play Store:

1. Open Google Play Store App. You can also go to play.google.com.

2. Search the desired app by typing its full or partial name in search bar at the top.

3. Select the app once it is found by touching its icon.

If app is already installed then it may show Update button.

If app is not free then click on item's price and complete the payment steps.

4. Touch on Install button. App will begin downloading. After a short while it will install.

5. App Inventor interface has following 2 parts:

Designer: It allows creating the graphical layout of the app. In designer we can add various

components and set their properties to create the user interface of the app.

Blocks: It provides various programming blocks to add interactivity to the app. Here, we can create

scripts for the app to add desired functionalities.

Chapter 8 – Network Concepts A. Choose the correct answer.

1. a 2. b 3. c 4. d (remove NOT) 5. d


1. WWW 2. URL 3. Hotspot 4. Star 5. Protocol


1. True (√) 2. False (×) 3. False (×) 4. True (√)


1.

TOPOLOGY ADVANTAGE DISADVANTAGE

BUS Requires less cable length. Main cable break brings down entire network.

STAR Computers can be connected easily. More cable length is required.

TREE Expanding the network is easier. Comparatively difficult to configure.

2. Bridge: Connects two networks working on the same protocol.

Switch: Is like an advanced bridge which supports heavy data traffic and higher performance.

Router: Connects multiple networks and efficiently handles data transfers among them.

Gateway: A gateway connects two networks together that may work on different protocols.

IT SKILLZ

Page | 57

3. The technology that allows access to software, storage devices, servers and other services & infrastructure

over Internet is called cloud computing. Examples: Microsoft Azure, Amazon Web Services, Google Cloud

Platform. Cloud computing has following benefits:

1. Businesses need not to install software and hardware infrastructure completely.

2. Business need to pay only for the usage of the services subscribed.

3. No need to worry about malware threats and software updates.

4. Hybrid Cloud can be used for both type of interactions - B2B (Business to Business) i.e. private and B2C

( Business to Consumer). This deployment method is called hybrid cloud as the computing resources are

bound together by different clouds.

5. In SaaS or software as a service, applications are hosted by service providers and made available to

customers over a network (internet).

PaaS (Platform as a Service) provides a platform and environment to developers to build applications and

services.

6. The features of web-based drives are:

1. A lot of free space.

2. User friendly.

3. Always get an updated version of services.

4. Automatic data backup.

5. Antivirus, malware and spam security.

6. 24 hours uptime and technical support.

7. Permission based security setup

8. Authorised account access

9. Content sharing

Chapter 9 – Image Processing, Layers and Filters A. Choose the correct answer.

1. b 2. a 3. a 4. c 5. a


1. Healing brush tool 2. Patch 3. Clone stamp 4. Dodge 5. Filters


1. Retouching images means making corrections in the images and restoring them to look more appealing.

Photoshop provides various image retouching tools to remove old marks, pixel correction, copying areas of

images, sharpening and softening (blurring) pixel, mixing (smudging) colours and saturating or desaturating

colours.

2. The steps to use Healing Brush tool are:

1. In the toolbox, select the Healing Brush tool.

2. Set brush size and style in the Options bar. Select required Mode as Replace.

3. Alt+click in a good region of the image which you want to apply to heal.

IT SKILLZ

Page | 58

4. Click and apply healing on the desired regions of the image.

3. The Blur tool is used to selectively blur areas of an image.mix colours in an image. The steps to use Blur

tool are:

1. In the toolbox, select the Blur tool.

2. Choose brush size, style and strength (intensity of the tool)in the Options bar.

3. Click and drag the mouse on the image.

4. To create a new layer:

1. From the Layer menu, select New → Layer.

2. In the New Layer dialog box, type the desired name in the Name text box.

3. Click on OK button. The new layer appears on the layers palette.

5. The steps to apply a filter are:

1. Select the area and complete layer to be filtered.

2. Click on the Filters menu and select any option.

3. If a dialog box opens, enter values or select options and then click on OK button.

Chapter 10 – Artificial Intelligence A. Choose the correct answer.

1. c 2. b 3. d 4. c


1. Habits 2. Reason 3. Machine 4. Inductive


1. False (×) 2. True (√) 3. True (√) 4. True (√)

Chapter 11 – A Tryst with Python A. Choose the correct answer.

1. c 2. a 3. d 4. c 5. C 6. b


1. 1 2. 0 3. Script (change String to Script) 4. # 5. len()


1. True (√) 2. False (×) 3. False (×) 4. True (√) 5. True (√)

it skillz - it-skillz.pdf · it skillz series of books is the offering from edusoft which is based...

Documents