Teacher’s Manual

Originally published by © HarperCollinsPublishers Ltd 2018

© Sunrise Publications
First Edition 2023
For sale in Pakistan only

All rights reserved. No part of this publication may be reproduced or

transmitted in any form or by any means, electronic or mechanical,
including photocopying, recording or duplications in any information
storage and retrieval system.

ISBN: 978 969 505 693 6

Printed in Pakistan at
Quick Process, Karachi.

Head Office: C-20 Sector 31-A, Mehran Town Extension, Korangi Township, Karachi 74900
Tel: 021-3511 2867-69 Fax: 021-3511 2871
Branch Offices: Islamabad, Lahore, Faisalabad, and Multan

Email: pma@cyber.net.pk Website: www.pma.com.pk

 Preface
COMPUTERS TODAY is a series of eight books for Classes 1 to 8 plus the Teacher’s Manual
1 to 8. This series conforms to the requirements of the Curriculum Framework. Based on
Windows 10 and MS Office 2019, this course introduces students to the latest interface and
the associated features. The progression of the series ensures that the pedagogical needs of
the students are met.
Key features of the Coursebooks:
• Word Web explains the difficult words.
• You Should Know gives interesting facts about the topic.
• Quick Way highlights all the important keyboard shortcuts for the menu commands.
• Exercise at the end of each chapter reinforces the understanding of the topic.
• Research Project integrates Computer Science with other subjects.
• Challenge Yourself is based on logical reasoning and information technology for classes
3 to 8.
All the books in this series have sections that can be considered for assessments.
The teacher’s manuals for Computers Today series are planned to assist teachers in multiple
ways. Our objective is to comfortably fit this programme into the teacher’s teaching goals. By
using the most up-to-date textbook available and a mix of ideas, we hope that students will
discover the importance of learning computer science from early stages.
A detailed overview of the key features of the teacher’s manual and a concise period plan are
given in the pages that follow.
Key features of the Teacher’s Manual:
•  Period Plan has a comprehensive table that acts as a suggested guideline for the allocation
of theory and practical periods for each topic in the session.
• Lesson Plans can be used to reinforce critical thinking and real-life applications of the
concepts in students. These are given for each chapter and they act as a springboard of
ideas. The lesson plans include:
° Interesting teaching activities given against each topic
° Well defined learning outcomes listed along with the teaching activities so that the aim
of teaching through each activity is clear
° Carefully mapped projects and suggested assessments for each pedagogical level to
enable students to explore additional features of the software applications taught
° Additional Teacher’s Notes enables the teachers to pick additional topics/references
while teaching in the classroom
• Answers to coursebook questions have answers for the coursebook questions
• An additional set of test papers and worksheets with answer keys for each chapter to
ease off the checking and the evaluation process.
To meet all the learning objectives and to provide a holistic form of imparting education,
the questions in various sections are based on the Bloom’s Taxonomy. This ensures that the
concept understanding is tested at six different levels, namely Knowledge, Comprehension,
Application, Analysis, Synthesis and Evaluation.
Here is the suggestive period plan for Grade 7.

Period Plan

Chapter No. Chapter Name Theory Practical Total Periods

1. Computer Fundamentals 2 0 2

2. Advanced Features of MS Word 2019 4 4 8

3. Enhancing Presentations 5 4 9

Editing and Formatting Cell Contents

4. 6 5 11
in MS Excel 2019
Formulas and Functions in MS Excel
5. 5 4 9
2019

6. Internet for Connecting with People 2 1 3

7. More About PYTHON -I 7 7 14

8. Introduction to Windows Movie Maker 4 4 8

All this material is prepared with an intention to help the teachers get the most out of their
class time. Each section in the teacher’s manuals is prepared with the perspective of delivering
it as an incredible teaching tool and resource.
We welcome constructive feedback and suggestions to improve these books in the subsequent
editions.
Dear teachers,

By now you very well know that it has been a constant effort of Collins/Sunrise Publications to
familiarize and equip students with the latest trends in computer technology. We have given
all the important information in our coursebooks that the students should explore and learn.
The initiative to give the latest Challenge Yourself, in the coursebooks and teacher’s manuals,
was the first step to let the children prepare through this for competitive exams in its entirety.
While we understand the limited time that all of you have for the completion of course
curriculum; the inquisitive minds are always on a look-out for some food for substance! It is
for this reason that we are giving additional links as recommended by Microsoft for additional
training material on MS Office for the students:
http://www.microsoft.com/en-us/education/students/resources
The teachers who want to give extra training to the students on various Microsoft topics can
follow the link given below:
http://www.microsoft.com/en-us/education
Both the links would give learning a new dimension by giving extra practice to the students.
The links given here are an add-on to the general curriculum followed across various boards.
It is completely at your discretion to share it with the students or follow the link while doing
classroom training.
We hope together we can empower the young minds to write their own success stories!

Publisher
 Contents
1. Lesson Plans 7
2. Answers to All Coursebook Questions 15
Chapter 1 (Computer Fundamentals)15
Chapter 2 (Advanced Features of MS Word 2019)15
Chapter 3 (Enhancing Presentations)16
Chapter 4 (Editing and Formatting Cell Contents in MS Excel 2019)17
Chapter 5 (Formulas and Functions in MS Excel 2019)18
Chapter 6 (Internet for Connecting with People)18
Chapter 7 (More About PYTHON -I)19
Chapter 8 (Introduction to Windows Movie Maker)19
Worksheet and Projects – 120
Worksheet and Projects – 221
Assessment 122
Assessment 223
Revision Questions24
3. Test Papers 28
Test Paper 128
Answers (Test Paper 1)29
Test Paper 229
Answers (Test Paper 2)30
Test Paper 331
Answers (Test Paper 3)32
Test Paper 433
Answers (Test Paper 4)34
Test Paper 535
Answers (Test Paper 5)35
Test Paper 636
Answers (Test Paper 6)37
Test Paper 738
Answers (Test Paper 7)39
Test Paper 841
Answers (Test Paper 8)42
4. Worksheets 43
Worksheet 143
Answers (Worksheet 1)44
Worksheet 244
Answers (Worksheet 2)45
Worksheet 346
Answers (Worksheet 3)47
Worksheet 447
Answers (Worksheet 4)48
Worksheet 548
Answers (Worksheet 5)49
Worksheet 650
Answers (Worksheet 6)51
Worksheet 751
Answers (Worksheet 7)52
Worksheet 852
Answers (Worksheet 8)53
5. Challenge Yourself 54
 Lesson Plans
Chapter 1 Periods
Topics Result
Computer Fundamentals Theory Practical
Topic: Computer system
1. The teacher can divide the class
into groups with 2-3 students
in each group and allocate each
group any of the topics covered
in the chapter, that is, types of
computers, based on technology
and purpose. Each group
Students should be should prepare a PowerPoint
able to: presentation of about 3-4 This activity
  (i) classify minutes on the topic allocated will help
Objectives

computers by to them. The teacher should students to

technology. encourage students to make a familiarize
2 0
presentation that is interesting themselves
(ii) classify the with the
computers by and at the same time gives
proper information. Students computer and
purpose. its types.
may use the Internet to gather
more information.
  Note: This activity can be used
for group assessment.
2. A quiz can be held in the class.
Two students can volunteer from
each row. With the help of chits
students can create questions
for the quiz.
Theory
Assessments

1. Oral or written test to judge the knowledge of students on types of computers based on
technology and purpose. The teacher may ask features of each of the computer type.
2. Objective-type suggestive questions are given in the book (Exercise, Worksheets, Assessments
and Revision Questions).
Teacher’s Notes Projects

Give each student a topic to make a chart on any of the topics covered in the chapter. The best
chart on each topic can be put on the class display board.
Note: This can be used for individual assessment.

Teachers can use images or PowerPoint presentations to help students appreciate the various
categories of computers.

7
 Chapter 2 Periods
Advanced Features of Topics Result
Theory Practical
MS Word 2019
The students should Topic: Mail Merge
be able to know: Pin-up board activity: The teacher
This activity
 (i) what is Mail may distribute blank strips of paper
will help
Merge and how to students. She can then call each
students to
do we use it. student, ask him/her to write one step
familiarize
(ii) how to start Mail each for the process of Mail Merge in
themselves
Merge. continuation to the previous step and
with the
then pin it up on the pin-up board. The
(iii) how to create a complete
Objectives

students can also be asked to encrypt

data source. process of
and print the documents.
(iv) how to add 4 4 using Mail
Note: This activity can be used for Merge feature
Merge fields
individual assessment. of MS Word
to the main
document. 2019 and also
understand
(v) how to merge
about
main document
encrypting and
and the data.
printing the
(vi) how to encrypt documents.
and print the
documents.
Theory
1. Oral or written test to explain the process of Mail Merge and its use. The teacher may give a
sequenced incomplete procedure and ask students to fill in the missing statements.
Assessments

2. Objective-type suggestive questions are given in the book (Exercise, Worksheets, Assessments
and Revision Questions).
Practical
In the practical lab, students can work in pairs and each pair can be asked to create an invitation
for the annual day function of your school. Also, create a data source and then merge the two. The
students can also be asked to encrypt and print the documents.
Note: This activity can be used for group assessment.
Projects

Students should make a chart on the entire process of Mail Merge.

Note: This can also be used for individual assessment.
Teacher’s Notes

Show sample examples of Mail Merge to make students conversant with the process so that they
have a thorough understanding of how the information is being used from the data source in the
main document to produce the merged document.

8
 Chapter 3 Periods
Topics Result
Enhancing Presentations Theory Practical
 opic: Adding hyperlinks in a
T This activity
Students should be presentation and printing a will help
able to: presentation students to
(i) add hyperlinks The teacher may divide the class familiarize
in PowerPoint into rows. The rows can be named themselves
presentation. as adding hyperlinks, printing with adding
the presentation and viewing the hyperlinks in a
(ii) print a 2 2
presentation. The teacher can then presentation
presentation. and also
ask three members of each team
(iii) understand to come and explain the steps to printing a
Objectives

different add their respective features into presentation

views of MS a presentation. using MS
PowerPoint. PowerPoint
2019.
Topic: Adding audio and video in a This activity will
presentation help students
The students should The teacher may divide the class to familiarize
be able to: into two groups. The groups can themselves with
(i) use audio be named as Audio and Video. The 3 2 adding audio
and video in a teacher can then ask four members and video in
presentation. of each team to come and explain MS PowerPoint
the steps to add their respective 2019
features into a presentation. presentation.
Theory
1. Oral or written test to explain various features that can enhance PowerPoint presentations.
2. Objective-type suggestive questions are given in the book (Exercise, Worksheets, Assessments
Assessments

and Revision Questions).

Practical
In the practical lab, two students can be made to sit on one machine. The teacher can give a task,
for example, inserting hyperlinks, audio and video. The team which successfully completes the
task in the least amount of time wins.
Note: This activity can be used for group assessment.
Projects

Students should make a presentation on any topic allotted and present it in the class.
Note: This can be used for individual assessment.

Discussion Ideas
(a) The teacher should explain that the slides should be balanced and should preferably follow
Teacher’s Notes

a consistent style. Too many effects or unnecessary use of audio-video files in the same
presentation can give it a clumsy look.
Additional Material
(a) The teacher should demonstrate the use of hyperlinks, differences while viewing the
presentation in different views, insertion of audio-video files and printing the presentation.
(b) The teacher should explain various views covered in the chapter.
(c) Students should be allowed to print a presentation.

9
 Chapter 4 Periods
Editing and Formatting Topics Result
Cell Contents in MS Theory Practical
Excel 2019
1. Topic: Selection of cells and
editing the cell contents and
Students should This activity will
formatting the cells
be able to know help students
how to: 1. A class discussion on what is editing to familiarize
and why do we need to learn editing of themselves
(i) select cells.
cell contents. The teacher can award with editing
(ii) edit cell points to students for citing various 3 3
cell contents
contents. situations where editing is required. in a worksheet
(iii) align text. Students may mention various and change
(iv) change text situations where editing is required like formatting of the
orientation. spelling mistake in their names, wrong cells.
marks, wrong roll number, etc.
Objectives

Students should 2. Topic: Various formatting options

be able to learn Two groups of students can be made.
how to: One group can be asked to write the
(i) do text steps of formatting the date, time, color
formatting. and set cell styles. The other group This activity will
(ii) do number is assigned the task to do text and help students
formatting. number formatting. Whichever group to familiarize
will take less time will win. 3 2 themselves
(iii) do date/time
with various
formatting.
formatting
(iv) do border options.
formatting.
(v) do color
formatting.
(vi) set cell styles.
Theory
Assessments

Objective-type suggestive questions are given in the book (Exercise, Worksheets, Assessments
and Revision Questions).
Practical
Each student can be given a format of a worksheet to be created. The student who completes first
will be the winner.
Students can be divided in groups based on their roll numbers, houses, etc. Thereafter, each
Projects

group can be allocated with a topic related to an excel sheet. Fixed time is given to each group to
create a spreadsheet. The spreadsheet created by each group can then be discussed in the class.
Note: This can be used as a group activity for assessment.
Discussion Ideas
Teacher’s Notes

(a)  Discuss the benefits of formatting the cell contents.

(b)  Also, discuss about the need to edit the cell contents.
Additional Material
(a) The students should be asked to create worksheets using all the features that they have learnt.
(b)  They should also use all the possible methods to perform any particular task.

10
 Chapter 5 Periods
Formulas and Functions in Topics Result
MS Excel 2019 Theory Practical
Topic: Understanding cell range
references and formulas
Students should be The teacher can have a screenshot
of an Excel sheet with some This activity
able to: will help
data. Thereafter, she/he can call
(i) understand students one by one and ask students to
cell and range them to use the text and number familiarize
2 2
references. formulas covered in the chapter themselves
(ii) learn to use to display certain output. with cell range
formulas — text references and
The same activity can be carried formulas.
and numeric. out in the practical lab also.
Note: This activity can be used for
Objectives

individual assessment.
Topic: Understanding error results
and using in-built functions
The teacher should form teams with
Students should be This activity
5-6 students in each team. She/he
able to: will help
may allocate each team one of the
(i) understand some functions covered in the chapter, say students to
error results. familiarize
one team is named sum(), another
themselves
(ii) learn the avg(), AutoSum feature and so on. 3 2
with
AutoSum feature. The teacher can display an Excel understanding
(iii) learn to use sheet and then ask questions related
error results
functions in to various functions. Similarly, the
and using in-
Excel 2019. teacher can also explain the error
built functions.
results to the students.
Note: This activity can be used for
group assessment.
Theory
1. Oral or written tests to evaluate students knowledge on the use of formulas and functions,
Assessments

error results and AutoSum feature in MS Excel 2019.

2. Objective-type suggestive questions are given in the book (Exercise, worksheets, assessments
and revision questions).
Practical
In the practical period, the teacher can ask the steps to use formulas and functions in MS Excel 2019.
Projects

Each student can be asked to prepare a PowerPoint presentation on Function Library of

MS Excel 2019.
Note: This can be used for individual assessment.

Discussion Ideas
Teacher’s Notes

(a) Discuss the benefits of using formulas and functions.

(b) Demonstrate with examples how formula errors can be rectified.
Additional Material
Students should be asked to create worksheets using all the features that they have learnt. They
can be given real-life situations to apply the various formulas and functions that they have learnt.

11
 Chapter 6 Periods
Internet for Connecting Topics Result
Theory Practical
with People
Topic: Services that the Internet
offers
1. The teacher may divide the class
into teams with 3-4 students
in each team. Each team is
allocated one topic covered in the This activity will
chapter. Each team then creates help students
Students should be to familiarize
able to learn about: a PowerPoint presentation on
the given topic and presents it in themselves
  (i) social the class. with the latest
networking. terminology
Note: This activity can be used
Objectives

(ii) instant related to

for group assessment.
messaging. the Internet
2. The teacher can ask each 2 1
(iii) understand like social
student to write two questions networking,
about chat on a piece of paper, fold it and
rooms, instant
put it in a box. Thereafter, each messaging,
newsgroups, student is called, asked to pick
blogs and chat rooms,
a chit and answer the questions newsgroups,
e-greetings. written on the chit. If the blogs and
questions repeat, he/she should e-greetings.
pick another chit. Alternatively,
a quiz can also be organized in
the class.
Note: This activity can be used
for individual assessment.
Theory
Assessments

1. Oral or written test to explain the ways of connecting with people around the world using the
Internet. The teacher may ask features, examples or benefits of any of the topics covered in the
chapter.
2. Objective-type suggestive questions are given in the book (Exercise, Worksheets, Assessments
and Revision Questions).
Projects

Students should make a presentation/chart on any of the topics covered in the chapter.
Note: This can also be used for individual assessment.
Teacher’s Notes

The teacher must discuss about online safety and netiquette. The students should be made aware
of the online privacy issues and the dangers of befriending strangers, especially when using social
networking sites. Also, demonstrate the use of some other websites encouraging students to
navigate the websites themselves.

12
 Chapter 7 Periods
Topics Result
More About PYTHON-I Theory Practical
Topic: Control structures and
Looping statements
The teacher can divide the class into
(i) Work with groups with 3-4 students in each This activity
variables and group. Each team can be allocated will help
constants of a type of variable. Thereafter, students to
PYTHON
Objectives

she/he can identify. The team should familiarize

(ii) Learn PYTHON write the variable using allocated to themselves
data types and 7 7 with the data
them. One member from each team
operators should come and write example variable and
(ii) Work with input on the board. After one round, the operator
functions of teacher should change the type of covered in the
PYTHON data structure allocated to each chapter.
team.
Note: This activity can be used for
group assessment.

Theory
1. Oral or written tests to evaluate students knowledge on various data types and operators
covered in the chapter.
Assessments

2. Objective-type suggestive questions are given in the book (Exercise, worksheets, assessments
and revision questions).

Practical
In the practical period, the teacher can perform the same activity where students make the
program on the system and show the output to the teacher.
Projects

Each student can be asked to prepare a short PowerPoint presentation on operators and input
functions in PYTHON.
Note: This can be used for individual assessment.
Teacher’s Notes

Discussion Ideas
(a)  Discuss the importance of using operator and input statements.
(b)  Demonstrate the use of all the input statements covered in the chapter giving different
examples.

13
 Chapter 8 Periods
Introduction to Windows Topics Result
Movie Maker Theory Practical
Students should be Topic: Creating movies using Windows
able to: Movie Maker
(i) start Windows 1. The teacher may make chits with the
Movie Maker. names of the components of Windows
(ii) know the Movie Maker 2012 interface. Each
components student should be called and asked to This activity
of Windows pick up a chit and answer the question will help
Movie Maker related to the component on the chit. students to
interface. The questions may be asked by the familiarize
(iii) create a teacher or by his/her fellow classmates. themselves
with the
Objectives

movie: Note: This activity can be used for

Windows
• adding and individual assessment.
4 4 Movie
removing 2. This activity can be done in the practical Maker
video clips/ lab. The teacher may copy a few video interface
photographs. clips and photographs on the desktop and also
• creating of each team of two students should encourage
titles and be sitting on one computer. Thereafter, them to
credits. she/he may ask them to first add create
• saving and a definite number of video clips/ movies.
playing a photographs, then add titles, credits
movie. and captions and finally save and play
the movie.
(iv) know about
transitions in a Note: This activity can be used for group
movie. assessment.

Theory
1. Oral or written tests to evaluate students knowledge on Windows Movie Maker interface and
the steps to create a movie in Windows Movie Maker 2012. The teacher may ask questions on
Assessments

any of the components, features, steps, etc. from the topics covered in the chapter.
2. Objective-type suggestive questions are given in the book (Exercise, worksheets, assessments
and revision questions).
Practical
In the practical period, the teacher can ask the steps to create a movie using Windows Movie
Maker and also ask about the various components of the interface.
Projects

Each student should be asked to prepare a PowerPoint presentation on creating a movie in

Windows Movie Maker. Students should show a step-by-step approach in their presentations.
Note: This activity can be used for individual assessment.
The teacher may start the chapter with the basic concepts of movies, that is, multiple pictures
or audio-video frames joined in a sequence. Thereafter, she/he may introduce Windows Movie
Teacher’s Notes

Maker to students as the simplest movie making software and explain each topic covered in the
chapter. Teacher may adopt the following methodologies:
• Conduct team-based and individual short activities/assignments for the reinforcement of the
concept taught.
• A PowerPoint presentation showing screenshots of Windows Movie Maker 2012 interface and
its components. The slide show should also show the steps to add videos, titles, credits and
captions and how to save a movie.

14
 Answers to All
Coursebook Questions

CHAPTER 1 (COMPUTER FUNDAMENTALS)

A 1. technique 2. size 3. application 4. Supercomputers 5. Specific purpose

B 1. True 2. False 3. False 4. True 5. False
C (a) (iii) (b) (iv) (c) (v) (d) (ii) (e) (i)
D 1.  Mobile computer is a type of microcomputer.
2. Supercomputers are the biggest, most powerful and expensive computers available today. They can
process trillions of instructions per second. These are used for specialized applications that require a
lot of mathematical calculations such as weather forecasting and nuclear energy research etc.
For example: Cray-1, Deep Blue
3. Hybrid computers: These computers work both on analog and digital signals. These computers can
effectively process the input and the output in both the variants. These computers are best suited for
simulators where the calculations and operations can be performed by the digital component and
changeable quantities can be measured using the analog component.
4. Mainframes computers: Mainframes are huge and very powerful computers. They can handle
thousands of users at a time. Mainframe computers are very expensive. They are used in large
organizations such as railway stations, banks and hospitals.
5. Embedded computers: These are special purpose computers. These are designed to do a dedicated
task. These can perform only pre-defined tasks. Therefore, these computers are enclosed in special
devices meant for real-time applications. For example, the ATM machines have special purpose
computer specifically designed to deposit and withdraw money.

CHAPTER 2 (ADVANCED FEATURES OF MS WORD 2019)

A 1.  Data source 2.  merge fields 3.  selecting a starting document
4.  selecting the recipients 5.  password
B 1.  True 2.  False 3.  True 4.  False 5.  False
C 1. Steps for inserting a merge field in the main document:
• When you come to the section where you want to insert data from the data source, click on More
Items in the Mail Merge task pane.
• This will open the Insert Merge Field dialog box.
• Select the file you want to use and click on Insert to add the merge field where your cursor is located.
• Type your document adding merge fields at suitable places until the document is finished.
2. Creating a new address list:
• Select Type a new list and click on Create to open the New Address List dialog box.
• In the New Address list dialog box, click Customize Columns to open the Customize Address List
dialog box.
• We can Rename/Delete any of the field by selecting it and clicking on Rename/Delete. Click OK
once the necessary changes are made.
• A new address list is ready showing only the fields that you have selected.

15
 • Use the New Entry button to enter new recipients. When you have entered the names of all the
intended recipients, click OK.
• This opens the Save Address List dialog box which allows you to save the list you just created
at the desired location. Choose a suitable file name and click on Save to open the Mail Merge
Recipients window.
• The Mail Merge Recipients window allows you to see and edit the data you have already entered
and to select individual recipients. When satisfied with the selection, click OK to close the window.
D 1. We use mail merge when we need to send personalized documents to a group of people without
having to type each document separately. Mail Merge allows us to create documents such that each
document has similar information, but some content is unique.
2. The Mail Merge process has the following four parts:
• Setting up the main document
• Creating data source and connecting the document to the data source
• Adding placeholders, called mail merge fields to the document
• Previewing and completing the merge
3. The main document contains the text and graphics that are the same in each version of the merged
document whereas a data source is a file that contains the list of data to be merged into the document.
4. Encrypting the documents means to protect the document from unauthorized users. MS Word
2010 provides you the feature to secure your documents with a password. Once your document is
encrypted, you can access your file only through the password.
5.  Steps to print the document:
• Open the document that you want to print and click the File tab.
• Click Print option from the menu.
• The right column of the screen gives you the preview of the document.
• The middle column gives various options for printing. Choose the desired option.
• The Printer list box gives the list of all printers installed on your computer. Select the desired printer.
• Click Print button to print the document.

CHAPTER 3 (ENHANCING PRESENTATIONS)

A 1. (d) 2. (d) 3. (d) 4. (b) 5. (d)

B 1. grayscale 2. Esc 3. Format 4. ClipArt Audio 5. Slide Sorter
C 1. True 2. False 3. False 4. False 5. False
D 1.  The different views that are available in MS PowerPoint are:
• Normal View
• Slide Sorter View
• Slide Show View
2.  Steps to link an image to an email address within the presentation are:
• Select the image on which you want to create the link.
• Click Hyperlink option on the Insert tab.
• Click E-Mail Address button in the Link to section.
• Type the e-mail address and subject in the specified textboxes.
• Click OK button.

16
 3.  Steps to insert a video in presentation:
• From the Insert tab, click the Video drop-down arrow in the Media group and select Video from File.
• The Insert Video dialog box appears. Navigate to the folder containing the video file and click to
select it. Click Insert to insert the video clip.
4.  Steps to print a MS PowerPoint presentation:
• C
 lick Print option from the File menu. The Print dialog box appears with a preview of the current
slide.
• Choose the number of copies you want to print.
• I n the settings section, specify the slides to be printed. Also choose, whether you want to print the
complete slide on a single page or notes pages or outline view.
• If you want handouts, then specify the number of slides to be printed per page.
• Specify whether you want to print in Grayscale, Pure Black and White or Color.
• Click on Print button on the top left corner of the Print dialog box.
5.  Steps to insert an audio in a presentation:
• From the Insert tab, click the Audio drop-down arrow in the Media group and select Audio from File.
• Select the desired audio file. Then click Insert.
• This places a sound icon on your slide. You can drag the sound icon and place it wherever you want.

CHAPTER 4 (EDITING AND FORMATTING CELL CONTENTS IN MS EXCEL 2019)

A 1. (d) 2. (c) 3. (a) 4. (a) 5. (c)

B 1. Formula 2. Wrap Text 3. Ctrl+A 4. orientation 5. indentation
C 1. True 2. False 3. False 4. True 5. True
D (a) (iii) (b) (v) (c) (i) (d) (ii) (e) (iv)
Steps
E 1.  to partially edit the contents of the cell:
• Click the Formula Bar or double-click on the cell where modification is to be done.
• Enter the contents either in the Formula Bar or in the cell.
• Press Enter key or Enter button on the Formula Bar.
Steps to do color formatting:
2. 
• Select the cell for which you want to format the color.
• Click Home tab and in the Font group of buttons click the arrow next to Fill Color. A grid of colours
appears.
• If you want more range of colours, then click on More Colors.
• Click on the desired colour and the text colour in the selected cell will change.
Steps to format date and time:
3. 
• Select the cell having date or time content.
• Click the arrow next to Number Format and choose either of the date options: Short Date and Long
Date.
• If you want to format the time in hour:minutes:seconds format, click the Time option.
4. Text formatting allows us to change the font of the text. Font is the style, size and colour in which the
text is written. Text can be emphasized using Bold, Italic and Underline features.
5. Wrap Text feature allows you to fit all the content visible within the same cell. It is done by displaying
the long text in multiple lines whereas Merge & Center feature makes the long text merge with the
adjacent cells and form one large cell. The text is then placed in the center of merged cells.
17
 CHAPTER 5 (FORMULAS AND FUNCTIONS IN MS EXCEL 2019)

A 1. (a) 2. (b) 3. (c) 4. (b) 5. (b)

B 1. = 2. Enter 3. & 4. Home     5. Functions
C 1. False 2. True 3. False 4. False 5. True
D (a) (iv) (b) (i) (c) (v) (d) (iii) (e) (ii)
E 1. We can enter a formula for a specified set of values by typing equal to (=) sign in the formula bar or in
the cell where you want the result to be displayed followed by the formula. For example, if we want to
calculate the sum of numbers in the cells B1, B2, B3 and B4 then we need to follow the following steps:
• S
 tep 1: Click the cell in which we want the sum to be displayed. Take it as B5 in this case. You will
see B5 in the name box.
• S
 tep 2: Type the formula beginning with an equal to (=) sign. As we type the formula in the cell, it is
also seen in the Formula Bar.
• Step 3: Click or press the Enter key. The result will be displayed in the cell B5.
2. Excel gives us an advantage of auto editing a result. As we change the data in the cells with the input
values, the result automatically changes in the cell where formula was entered.
3. Strings are the text values that are a set of characters on which we cannot perform arithmetic
operations such as addition, subtraction, multiplication, etc.
4. If we see a couple of ‘#’ in a cell, it means the column is not wide enough to display the resultant
number. It is not considered as a formula error. In this case, increase the width of the column so that
the complete number is displayed.
5. The AutoSum feature is one of the most commonly used features of MS Excel. It automatically adds
the numbers in the selected range of cells. It can also be used to find the average, maximum value,
minimum value, etc. for the selected range of cells.

CHAPTER 6 (INTERNET FOR CONNECTING WITH PEOPLE)

A 1. Facebook 2. Twitter 3. Instant Messaging 4. chatroom 5. newsgroup

B 1. False 2. False 3. True 4. True 5. False
C (a) (iv) (b) (iii) (c) (ii) (d) (v) (e) (i)
D 1. Blog originally came from the word weblog or a web blog. A blog is a website which has posts. The
most recent entries usually appear first and the oldest entries appear last. A user can use a blog to
write about any particular topic that fascinates him or about any particular area of interest. A blog is
updated frequently and regularly. This makes a blog somewhat like a journal or a diary.
2. The social networking websites are the websites that serve as an online community of Internet users.
A social networking service allows people, who share interests or real-life connections, to build social
networks or social relations It consists of a representation of each user’s information, his social links
and a variety of additional services. The three examples of social networking websites are:
• My Space
• Facebook
• Twitter
3. A newsgroup is an online discussion group where information about a particular topic is exchanged.
It is a source of both information and communication. In a newsgroup, messages are posted on a
bulletin board where any member of a newsgroup can read and respond to them.
4. A chat room is an online web service in which two or more users can send messages to each other.
Generally, a chat room consist of people with common interest. The chat may be text-based,
voice-based or video-based.
18
 CHAPTER 7 (MORE ABOUT PYTHON -I)

A 1. constant 2. Tuples 3. variable 4. Logical 5. ( [ ] ).

B 1. Function 2. variable 3. Prompt 4. Logical 5. Dictionary
C 1. False 2. False (List ) 3. True 4. False 5. False (friend= ‘Best’ )
D 1. ( ) 2. INPUT 3. ** 4. 2 5. empty list.
E 1. Operators are used to perform different operations on the variable created. These operations can be
the mathematical calculations, comparison and logical operations.
2. Lists in Python can be created by just placing the sequence inside the square brackets [ ].
Steps to create list:
• First Initialise the list. • Then append each number to the list.
• And in Last Print out the list.
3. A Python variable name must follow the given rules for naming:
• The first character must be a letter, A through Z (uppercase or lowercase letters may be used) or
underscore character
• There should not be any space in between any two characters
• Variable name cannot start with numbers
• Variables are case- sensitive (Result, result and RESULT are three different variables)
• Variable Name cannot be reserved word (Python Keyword)
• It should not contain any special character like @, &, % etc.
4. What is the difference between lists and tuples.
Lists are enclosed in square brackets ([ and]) and tuples in parentheses (( and )).
The difference between the two is that we cannot change the elements of a tuple once it is
assigned whereas we can change the elements of a list.

ACTIVITY
Answer
A. # Display average and percentage of any five subjects
print(‘Enter marks of five subjects: ‘)
Subject1=float(input())
Subject2=float(input())
Subject3=float(input())
Subject4=float(input())
Subject5=float(input())
total = Subject1 + Subject2 + Subject3 + Subject4 + Subject5 ;
average = total/5.0;
percentage = (total / 500) * 100;
print(‘Total marks = ‘, total)
print(‘Average marks = ‘, average)
print(‘Percentage = ‘, percentage)

19
 B. # Multiplication
num1 = int(input(“Enter first number “))
num2 = int(input(“Enter second number “))
result = num1 * num2
print(“Sum is”, result)

C. # Create a List of 5 float numbers

floatNumbers = []
n = int(input(“Enter the list size : “))
for i in range(0, n):
print(“Enter number at location”, i, “:”)
item = float(input())
floatNumbers.append(item)
print(“User List is “, floatNumbers)

CHAPTER 8 (INTRODUCTION TO WINDOWS MOVIE MAKER)

A 1. (d) 2. (a) 3. (a)

4. (c) 5. (d) 6. (c)
B 1. Windows Movie Maker Interface 2. Seek Bar 3. Spacebar
4. Duration List Box 5. Video Tools Edit
C 1. True 2. True 3. False 4. False 5. False
D 1. Storyboard 2. Storyboard 3. Playback Control
4. F11 5. Mounting area
E 1. The main components of Windows Movie Maker User Interface are Movie Maker Icon, Title Bar,
Ribbon, Storyboard, Monitor and Status bar.
2. Steps to create a movie:
1.  Add videos and photos
2.  Add titles and credits
3.  Save the movie
3. Steps to save the movie as a project:
1. Click Movie Maker icon and select Save project as option from the drop-down menu. The Save
Project dialog box appears.
2.  Select the folder in which you want to save the movie project.
3. Specify the name of the file and click Save button. The movie project with the extension .wlmp is
saved.
4. Steps to add music file to the project:
1.  On the Storyboard, click on any clip.
2.  Click on the arrow below Add Music icon on the Home tab.
3. From the drop-down menu, select Add music option under the Add music from PC category of
commands. The Add Music dialog box appears.

20
 4. Browse and select the desired music file and click the Open button. The selected music file is added
to the entire movie. You will see that the audio track appears just below the movie clips on the
Storyboard.

WORKSHEET AND PROJECTS — 1

A 1. (d) 2. (b) 3. (a) 4. (b) 5. (a)

B 1. Microcomputers 2. .mdb 3. Encryption 4.  Wrap Text 5.  Slide Show
C 1. False 2. True 3. True 4. True 5. False
D Step 1:  Step 2: Step 3:

Step 4: Step 5: Step 6:

E 1. Steps to apply cell styling feature in MS Excel

1.  Select the cell or range of cells on which you want to apply the style. Click Home tab.
2.  From the Styles group of buttons click the Cell Styles button. The cell styling pattern is displayed.
3.  Click the desired pattern and it will be applied on the selected cells.
Steps to insert an audio to your presentation
2.
1.  From the Insert tab, click the Audio drop-down arrow in the Media group and select Audio from File.
2.  Select the desired audio file. Then click Insert.
3.  This places a sound icon on your slide. You can drag the sound icon and place it wherever you want.
3. Steps to add currency symbol in the cell
1.  Enter the number in the cell.
2.  Click the Number format button. A drop-down list box will appear.
3.  Click Accounting from the list box. A currency symbol is added to the number.
4. To change the currency symbol, click the arrow near Accounting Number Format button. Select the
desired currency from the list box.

21
 4. Steps to add hyperlinks to your presentation
1.  Select the text or image you want to make a hyperlink.
2.  On the Insert tab, select Hyperlink command from Links group of buttons.
3.  The Insert Hyperlink dialog box appears.
4. If you had selected any text on the slide it will be displayed in Text to display text box; otherwise
<Selection in the document> will be displayed.
5. For linking the selected text or image, follow any of the following steps:
a. The Current Folder button is selected and so the files and folders in the current folder are
displayed. Select any file from this list that you want to link to.
b. Click Browsed Pages button, if you want to link the text or image to any of the browsed pages from
the list.
c.  Click Recent Files button and click any of the files from the list.
d.  You can also type the address of any web page/website that you want to link in the Address text
box.
6.  Click OK. The text or image you selected will be hyperlinked.
F 1.  The categories of computer based on purpose are:
• General purpose computers
• Specific purpose computers
2. We need to encrypt documents to protect it from unauthorized users. MS Word 2019 provides feature
to secure document from unauthorized users. To do this, follow the steps given below:
• Click the File tab. The Backstage view opens.
• The Protect Document section gives you the current default permissions of your file i.e. ‘Anyone
can open, copy, and change any part of this document’. To protect your document with a password
click Protect Document button.
• From the pop up menu select Encrypt with Password option.
• The Encrypt Password dialog box appears. Type your password. You will see that the password is
hidden. That means you will not be able to see the characters that you are typing.
• Click OK button.
• The Confirm Password dialog box appears. Re-enter the same password and click OK.
• Save the file to make the applied password effective.
3.  The five options that are available while printing the documents in MS Word 2019 are:
• Copies: Through this option you can set the number of copies to be printed.
• Print All Pages: By default, MS Word prints all the pages of the document. In case you want to
print the specific pages of the document, then specify the page numbers in the Pages option.
• Print One Side: By default, MS Word prints on one side of the document only but you can print on
both sides of the page through this option.
• Collated: Through this option you can have multiple copies in collated or uncollated manner.
• Orientation: Select this option to print in Portrait or Landscape orientation.
4.  Steps to insert a video file in presentation:
• From the Insert tab, click the Video drop-down arrow in the Media group and select Video from File.
• The Insert Video dialog box appears. Navigate to the folder containing the video file and click to
select it. Click Insert to insert the video clip.

22
 Analog Computers: These computers do not use the binary digits for processing the information.
5. 
They use continuous values from signals to process the information.
 igital Computers: These work on digital signals. These computers can effectively process the input
D
and output in digital form only.
6. Merging the text makes the long text merge with the adjacent cells forming one large cell while
wrapping the text allows you to make all the content visible in the same cell.

WORKSHEET AND PROJECTS — 2

A 
1. (a) 2. (a) 3. (a) 4. (c) 5. (a)
B 1. Loop 2. Ctrl+C 3. Social Networking 4. AutoSum 5. wlmp
C 1. False 2. False 3. False 4. False 5. True
D 1. 50
60
70
2. Depends on value of num 1 and num 2. Assuming different values of num 1 and num 2 as 5, 6
respectively.
E 1. (a) def pattern(n):
k = 2*n -2
for i in range(n,-1,-1):
for j in range(k,0,-1):
print(end=” “)
k = k +1
for j in range(0, i+1):
print(“*”, end=” “)
print(“\r”)
(b) rows = 5
for row in range(1, rows+1):
for column in range(1, row + 1):
print(column, end=” “)
print(“”)
Function Library: The functions are present in the Function Library group of buttons on the
3. 
Formula tab. Through this button we can browse and select the required formulas. The various
categories available are:
•  Recently Used •  Financial •  Logical •  Text
•  Date and time •  Lookup & reference •  Math & Trig •  More Functions
4. The two features present in the Alignment group of buttons are:
• Vertical Alignment: For vertical alignment of data in the cells, there are three buttons – Top Align,
Middle Align and Bottom Align.
• Horizontal Alignment: For horizontal alignment of text in the cells, there are three buttons – Align
Text Left, Center and Align Text Right.

23
 5. The storyboard is used to add, view and rearrange the sequence of clips and/or photographs in your
movie. It is also called the mounting area.

ASSESSMENT — 1

A 
1. (c) 2. (a) 3. (d) 4. (a) 5. (c) 6. (b)
B 
1. True 2. False 3. True 4. False 5. False
C 1. Active Cell and Formula Bar: The currently selected cell is known as active cell while formula bar is
used for partial modification of the cell contents.
2. Live Preview lets us view how the content will look with different paste options before we actually
paste it while Slide Sorter view gives a sequenced view of all the slides in the presentation in
thumbnail form.
3. Undo action is used to cancel the effects of previous action performed while Redo is used to cancel
the effects of Undo action.
4. Supercomputers are the biggest, most powerful and expensive computers available today. They can
process trillions of instructions per second. Minicomputers can handle approximately 500 users
at a time. These are commonly used in small organizations where data is shared between various
departments.
5. Indentation is the distance between the margin and the data in the cell while alignment is the position
of the data in the cell with respect to the boundary of the cell.
D 1. Steps to delete a password:
• From the File tab, select Protect Document option.
• From the pop up menu select Encrypt with Password option.
• Select and delete the typed password.
• Click OK and save the file.
2. Formatting: The changing of presentation and appearance of the data on a page without changing the
data values is known as formatting.
3. Hyperlink: A hyperlink is a coloured and underlined text or an image that when clicked opens another
web page, file or any other application. We can add hyperlink to a presentation using following steps:
• Select the text or image you want to make a hyperlink.
• On the Insert tab, select Hyperlink command from the Link groups of buttons.
• The Insert hyperlink dialog box appears.
• If you had selected any text on the slide it will be displayed in the Text to display box.
• On the left side of the dialog box, under Link to section, Existing File or Web Page button is
selected. For linking the selected text or image choose any of the option from the Current Folder
button, Browsed Pages or Recent Files button.
• Click OK.
4. Classification of Computers: The functions and the processing capacity of computers depend upon
their sizes and the techniques used. On the basis of technology used, computers can be classified
as digital, analog and hybrid computers. On the basis of purpose, the computers can be classified as
general purpose or specific purpose computers.
5. Steps to add video to a presentation:
• From the Insert tab, click the Video drop-down arrow in the Media group and select Video from File.
• The Insert Video dialog box appears. Navigate to the folder containing the video file and click to
select it. Click Insert to insert the video clip.

24
 6. The different viewing options present in MS PowerPoint 2019 are:
• Normal View: This is the default view where you can create and edit slides.
• Slide Sorter View: This view gives you a sequenced view of all the slides in the presentation in
thumbnail form.
• Slide Show View: This view is used to deliver the presentation as you want the audience to see.

ASSESSMENT — 2

A 1. (c) 2. (b) 3. (c) 4. (b) 5. (a) 6. (a)

B 1. Chris Dewolfe and Tom Anderson 2.  Windows Movie Maker 3.  Jack Dorsey
4.  online chat 5.  LEN( ) 6.  Tuples
C 1.  Varied 2.  Business and advertising 3.  Computers and technology
4. Miscellaneous
D 1. While…Wend loop executes only if the condition given after the WHILE keyword evaluates to True while
Do…While is executed as long as the condition is True.
2. Initialization is the value from where the loop starts while termination is the value at which the loop ends.
3. Title is the text that gets added before the selected item in a new frame before the selected frame
whereas caption is the text that is displayed over the selected video or photograph frame.
4. LEN is a text function which displays the number of characters in a cell while LCM is to calculate the
Least Common Multiple of two or more integers in mathematics.
5. Instant Messaging is a type of online chat that allows us to communicate with people through text
messaging while microblogging is a blogging in which short messages are posted.
E 1. Autosum feature adds the numbers in the selected range of cells.
2. e-greetings: e-greetings are the cards specially designed for a happy or a festive occasion to be
sent online
3. The monitor is used to preview individual photographs, video clips, titles and credits or an entire
movie project.
4. Looping statements: It means repeated execution of statement or a set of statements.
5. Control structures: Control structures are the structures that allow the programmer to determine
whether or not specific statements will be executed.
F 1. num = int(input(“Enter a number: “))
mod = num % 2
if mod > 0:
print(“This is an odd number.”)
else:
print(“This is an even number.”)
OUTPUT : Enter a number: 8
This is an even number.
2. The following precautions should be taken while chatting on the Internet:
• Check the terms and conditions and privacy policy of the chat service provider before opening
an account.
• Use decent language while chatting.
• Do not reveal your contact number, address or any other personal information in a chat room.

25
 • Do not make friends with strangers.
• Inform your parents if someone is sending offensive messages.
3. When the movie project that you are working on is saved as a movie, it is saved in a video format.
that can run on any media player like Windows Media Player, VLC Media Player, etc. You cannot make
further modifications in a file that is saved in any video format. Such a process is called rendering a
movie.
To render the movie, follow the steps given below:
1. Click the Windows Movie Maker icon.
2. Click Save movie option and from the sub menu select Recommended for this project option. The
Save Movie dialog box appears.
3. Specify the folder where you want to save the movie.
4. Specify the name of the file in the File name text box.
5. Select the type of video format in which you want to save the movie. The default format of the
movie is .mpeg-4.
6. The Movie Maker progress bar appears that shows the status of the movie being saved or
rendered.
7. Once the movie is saved, a dialog box stating that the video file is created is displayed.
8. Click the Play button in the dialog box to view the movie in any of the media players.

REVISION QUESTIONS

A 1. (d) 2. (a) 3. (b) 4. (b)  5. (a)

6. (c) 7. (d) 8. (c) 9. (a) 10. (b)
B 1.  News 2. dedicated computers 3. Mail Merge  4. .pptx
5. partial modification 6. Home  7. 1
8.  vertically, horizontally 9.  Wrap text 10.  indentation
C 1.  False 2. False 3. False 4. False  5. False
6. True 7. False 8. True 9. False 10. False
D 1. Concatenation 2. Functions 3. blog 4. BreakFree  5. Constant
E 1. # a list of numbers
numbers = [11, 22, 33, 100, 200, 300]
# prints 11
print(numbers[0])
# prints 300
print(numbers[5])
OUTPUT:
11
300
ENDIF
END
2. Steps to print a presentation:
• Click Print option from the File menu. The Print dialog box appears with a preview of the current
slide.

26
 • Choose the number of copies you want to print.
• In the settings section, specify the slides to be printed. Also choose, whether you want to print the
complete slide on a single page or notes pages or outline view.
• If you want handouts, then specify the number of slides to be printed per page.
• Specify whether you want to print in Grayscale, Pure Black and White or Color.
• Click on Print button on the top left corner of the Print dialog box.
3. Steps to do text formatting in MS Excel:
• Select the cell for which you want to format the font.
• Click Home tab and in the Font group of buttons, click the arrow next to Font type. The drop-down
list appears. Click the font you want to apply.
• Click the arrow next to Font size. Different sizes appear in the list box.
• Click the desired font size.
• Click the arrow next to Font Color and choose desired colour.
4. Steps to compose letters using Mail merge:
• On the Mailings tab in the Start Mail Merge group, click Start Mail Merge.
• With letters selected, click Next: Starting Document.
• Select use Current Document.
• Select Type a New List and add all the fields with the help of table given.
• Use New Entry button to enter the new recipients.
• Click OK.
• This opens the Save Address List dialog box. Choose a file name and Save the list.
• In the Mail Merge Task pane select the option Use an existing list.
• Type the letter. Click on More items in the Merge task pane.
• This will open Insert Merge field dialog box.
• Select the field you want to use and click on Insert to add merge field where your cursor is located.
• Type the letter adding merge fields at suitable places until the letter is finished.
• Click on Preview your letters.
• After previewing letters click on Complete the merge.
5. To add transition effects:
• Select the video clip or picture before which you want to insert the transition effect.
• From the Animations tab, select the desired transition from the Transitions gallery. The selected
transition will be applied.
F 1. Auto Sum feature: It is one of the most commonly used feature of MS Excel. It automatically adds
the numbers in the selected range of cells. It can also be used to find the average, maximum value,
minimum value, etc.
2. The movie can be saved in two ways - As a Project or As a Movie. When the movie is saved as a project,
it is saved with the extension .wlmp. This movie project saved can be opened in Windows Movie Maker
2012 for any additions and modifications. But when the movie project is saved as a movie, it is saved
in a video format that can run on any media player. You cannot make any further changes in a file that
is saved in video format. This is known as rendering a movie.
3. The different views that are available in MS PowerPoint 2010 to view a presentation are:
• Normal View
• Slide Sorter View
• Slide Show View
27
 4. Steps to do number formatting:
• Click on Number Format button in the Number group of buttons on the Home tab that helps to
choose how the values in the cell are to be displayed.
• Select a cell.
• Click desired option from the list box.
5. Steps to find the LCM of two numbers in MS Excel:
• Type the numbers in required cell range.
• Select the cell where you want to display the LCM.
• Click Math & Trig button from Function Library group of buttons on the Formulas tab. A list of
function appears.
• Select LCM option from the drop-down list. The Function Arguments dialog box appears.
• Type the cell numbers in the Number1, Number2, Number3 and so on. The result is displayed on
the right side of the text boxes itself.
• Click OK.
6. Social Networking: A social networking service allows people, who share interests or real-life
connections, to build social networks or social relations. It consists of a representation of each user’s
information, his social links and a variety of additional services. For online social networking, websites
are commonly used. These are known as social networking websites which serve as online community
users.
7. Twitter: Twitter is an online social networking service that allows its users to send and read short text
messages of maximum 140 characters which are called tweets. Twitter was created in 2006 by Jack
Dorsey. Twitter is now one of the 10 most-visited websites and has been described as the ‘SMS of the
Internet’.
8. Comparison operators
Comparison operators are used to do the comparison of the values and return a value either True or
False depending on the result of the comparison.

Operator Description Example Answer Operator Description Example Answer

x=5 x = 9
> Greater than y = 4 True
== Equals to y=3 False
print (x == y) print (x > y)

x=8 x = 7
!= Not Equal to y=3 True <= Less than or y = 3 False
print (x! = y) equal to print (x <= y)
x=6 x = 9
< Less than y = 3 False >= Greater than y = 3 True
print (x < y) or equal to print (x >= y)

9. Steps to apply borders to selected cells:

• Select the cells.
• Click the Home tab. In the Font group of buttons, click the arrow next to the Border button. A
Border drop-down menu appears.
• Choose the desired option.
• Click OK.
10. Steps to format Date and Time in MS Excel:
• Select the cell having date or time content.
• Click the arrow next to Number Format and choose either of the Date options: Short Date or Long Date.
• If you want to format time in hour:minutes:seconds format, click the Time option.
28
 Test Papers
TEST PAPER 1

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which of these is an example of minicomputer?
(a) PDAs (b) PSPs (c) CrayXT53 (d) CDC 160A
2. Which is the first supercomputer built in India?
(a) Deep Blue (b) Param 8000 (c) Cray-1 (d) CrayXT53
3.  _____________ is CPU on a single chip.
(a) Minicomputers (b) Microcomputers (c) Mainframes (d) Microprocessor
4. Which of these executes many programs simultaneously?
(a) Minicomputers (b) Microcomputers (c) Mainframes (d) Microprocessor
5. Which of these are also known as special purpose computers?
(a) Embedded (b) Supercomputers (c) Mainframes (d) Microcomputers
B Fill in the blanks using the following words. (5 marks)

Deep Blue continuous expensive powerful Microcomputers

1. are small computers which use a microprocessor.

2. Mainframe computers are very  .
3. The supercomputer named was the first machine to defeat the world chess champion.
4. Analog computers use values from signals to process information.
5. Mainframes are huge and very computers.
C Answer the following questions. (10 marks)
1. How computers are classified based on technology?
2. On which type of data Digital computers operates?
3. Where mainframe computers are used?
4. Why microcomputers are referred to as Personal Computers?
5. How digital computers are classified?
D Answer the following questions in detail. (20 marks)
1. Explain hybrid computers.
2. For what purpose general computers are used?
3. Explain in detail supercomputers.
4. For what purpose specific purpose computers are used?
5. Explain the classification of computers based on type of application.
E Project Work  (10 marks)
1. Make a comparison chart for all types of computers.
2. Collect pictures of various computers. Make a report on it mentioning their types, the year in which
they were built and the person(s) who built it.
29
 ANSWERS (TEST PAPER 1)

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

B 1. Microcomputers 2. expensive 3. Deep Blue 4. continuous 5. powerful
C 1. Computers can be classified as following based on technology:
• 
Digital Computers     •  Analog Computers     •  Hybrid Computers
2. Digital computers operates on all types of data using only two digits: 0 and 1.
3. Mainframe computers are generally used in large organizations such as railway stations, banks and
hospitals.
4. Microcomputers are also referred to as Personal Computers as they are used by one person at a time.
These include both desktops and portable computers such as laptops, notebooks, tablets, etc.
5. Digital computers are classified into five categories:
• 
Microcomputers •  Minicomputers • 
Mainframes
• 
Supercomputers •  Embedded computers
D Hybrid Computers: These computers work on both — digital and analog signals. These computers
1. 
can effectively process the input and output in both the variants. These computers are best suited
for simulators where the calculations and operations can be performed by the digital component and
changeable quantities can be measured using the analog component.
2. General purpose computers are meant to meet the requirements of various purposes. These are
used at shops for printing the bills, managing the inventories, preparing sales reports and uploading
product information.
3. Supercomputers are the biggest, most powerful and expensive computers available today. They
can process trillions of instructions per second. A supercomputer aims at executing few programs
as fast as possible. These are used for specialized applications that require a lot of mathematical
calculations such as weather forecasting and nuclear energy research.
4. Specific purpose computers are meant to do specific tasks only. The instructions for completing
the task are permanently stored in the computer’s memory. These computers can be of any size
depending on the application for which they are designed. These are also known as special purpose
or dedicated computers.
5. Based on the type of application computers can be classified as:
• 
General purpose computers •  Specific purpose computers

TEST PAPER 2

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which file contains the information to be merged into the document?
(a)  Address File (b)  Data Source (c)  Merge File (d)  Mail File
2. Which feature of MS Word helps us to send personalized document to a group of people?
(a) Mail Merge (b) Macros (c) Text Wrapping (d) Mail Send
3. Which button is used to enter new recipients?
(a) New (b) New Entry (c) New Address (d) New List
4. What is the extension for the address files of Mail Merge?
(a) .xlsx (b) .wrd (c) .ppt (d) .mdb
5. Which of these is a personal email manager from Microsoft?
(a) Microsoft Excel (b) Microsoft Word (c) Mail Domain (d) Microsoft Outlook
30
B Fill in the blanks using the following words. (5 marks)

previewed selecting merged unique Letters

1. The information in each document comes from entries in the data source.
2. A data source is a file that contains the information to be into a document.
3. Each copy of the document can be before printing or emailing the whole set.
4. is the default document.
5. We can rename any of the files by it and clicking on Rename.
C Answer the following questions. (10 marks)
1. What do you mean adding placeholders?
2. What does the main document contain?
3. How do we select the recipients?
4. Do we need to type each document separately for each recipient in Mail Merge?
5. Can we preview the whole document before sending it?
D Answer the following questions in detail. (20 marks)
1. Why do we use Mail Merge?
2. List the steps to create data source.
3. List the various options that are available for printing.
4. List the steps for encrypting the documents.
5. What are the general steps of Mail Merge?
E Project Work (10 marks)
1. Use Mail Merge feature to invite all the students of your class for the “Annual Function” of your
school. The invitation should include:
•  Main body of the text •  Name and address of each student
2. Create a Mail Merge document inviting your friends for your birthday party.
List all the steps.

ANSWERS (TEST PAPER 2)

A 1. (b) 2. (a) 3. (b) 4. (d) 5. (d)

B 1. unique 2. merged 3. previewed 4. Letters 5. selecting
C 1. Adding placeholders refers to adding the reserved places/locations in the document which are filled
with information from the data file when the Mail Merge is performed.
2. The main document contains the text and graphics that are same in each version of the merged
document.
3. We can select recipients either from an existing list or from the MS Outlook contacts or we can
create a new list.
4. No, there is no need to type each document separately in Mail Merge.
5. Yes, we can preview the whole document before sending it.
D 1. We use Mail Merge when we need to send personalized documents to a group of people without
having to type each document separately. Mail Merge allows us to create documents such that each
document has similar information, but some content is unique.

31
 Steps to create data source:
2.
•  Select Type a new list or click on Create to open the New Address List.
• In the New Address List dialog box, click Customize Columns to open the Customize Address
List dialog box.
•  Any of the field shown in above step can be renamed or deleted.
•  Click OK when you have made the necessary changes.
•  Only the fields which we have selected will be shown in the New Address List dialog box.
3. The various options that are available for printing documents are:
• Copies • Print All Pages • Print One Side • Collated
• Orientation • Paper Size • Margin
Steps for encrypting the documents:
4.
•  Click the File tab. The Backstage view opens.
• The Protect Document section gives us the current default permissions of file. To protect
document with a password, click Protect Document button.
• From the pop up menu select Encrypt with Password option.
• The Encrypt Password dialog box appears. Type your password.
•  Click OK button.
•  The Confirm Password dialog box appears. Re-enter the same password and click OK.
•  Save the file to make the applied password effective.
5. The Mail Merge process has the following four parts:
•  Setting up the main document
•  Creating data source and connecting the document to the data source
•  Adding placeholders, called mail merge fields, to the document
•  Previewing and completing the merge

TEST PAPER 3

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which of the following is an option for inserting sound clips?
(a) Clip Art Audio (b) Record (c) Sound (d) Video
2. Which is the default view to create and edit slides?
(a) Normal (b) Slide Sorter (c) Slide Show (d) Edit Show
3. Which button should be pressed to see the slide preview of the current slide?
(a) View (b) Playback (c) Preview (d) Insert
4. _____________ group is present in the Insert tab.
(a) Link (b) Text (c) Styles (d) Media
5. Which button should be pressed to remove a hyperlink?
(a)  Delete Hyperlink (b)  Edit Hyperlink (c)  Copy Hyperlink (d)  Remove Hyperlink
B Fill in the blanks using the following words. (5 marks)
sound Slide Show presentation views sequence

1. A helps you depict your ideas through a series of slides.

2. PowerPoint allows you to add to your presentation.
3. In Slide Sorter View, all the slides are numbered in  .
4. The view occupies full computer screen.
5. To create a good presentation, various are available in MS PowerPoint 2010.
32
C Answer the following questions. (10 marks)
1. What do you mean Hyperlink?
2. Can we link text or an image to an email address in the presentation?
3. What are the three commonly used views for presentation?
4. What are the options for printing the presentation?
5. Which options are used to enhance and add effects to the video file selected?
D Answer the following questions in detail. (20 marks)
1. List the steps to print a presentation.
2. Explain Slide Show View in detail.
3. What do you mean by Normal View?
4. What do you mean by hyperlink? How can you add hyperlink to a presentation?
5. What are the steps to add video to a presentation?
E Project Work (10 marks)
1. Make a PowerPoint Presentation on “My Class”. Include photographs and achievements of different
students. Also make a video featuring various students of your class and insert it in the presentation.
2. Make a PowerPoint presentation on “Advantages of Using Microsoft Tools”.

ANSWERS (TEST PAPER 3)

A 1. (a) 2. (a) 3. (c) 4. (d) 5. (d)

B 1. presentation 2. sound 3. sequence 4.  Slide Show 5. views
C 1. A hyperlink is a coloured and underlined text or an image which when clicked opens another file, web
page, image or any other application.
2. Yes we can link text or an image to an email address in a presentation.
3. The three commonly used views are:
•  Normal View •  Slide Sorter View •  Slide Show View
4. The following options come while printing the presentation:
• Entire presentation  • Specific slides  • Handouts  • Notes pages  • Outline pages
5. Contextual tabs Format and Playback that open under Video tools are used to enhance and add
effects to the video file selected.
D 1. Steps to print a presentation:
• Click Print option from the File menu. The Print dialog box appears with a preview of the current slide.
•  Choose the number of copies you want to print.
• In the settings section, specify the slides to be printed. Also choose, whether you want to print the
complete slide on a single page or notes pages or outline view.
• If you want handouts, then specify the number of slides to be printed per page.
• Specify whether you want to print in Grayscale, Pure Black and White or Color.
• Click on Print button on the top left corner of the Print dialog box.
Slide Show View: This view is used to deliver the presentation as you want the audience to see. The
2. 
Slide Show view occupies full computer screen. The graphics, text, timings, movies, audio, transition
and other animation effects can be seen while running the presentation in Slide Show view. You use
this view to project the presentation on a large screen.
Normal View: This is the default view where you create and edit slides. The screen in this view is
3. 
divided into two parts. On the left, there is a Slides tab from where you can move across the slides.
On the right is the main working area, where you can insert text, images, pictures, hyperlinks, etc.
33
 Hyperlink: A hyperlink is a coloured and underlined text or an image that when clicked opens
4. 
another web page, file or any other application. We can add hyperlink to a presentation using
following steps:
•  Select the text or image you want to make a hyperlink.
• On the Insert tab, select Hyperlink command from the Link groups of buttons.
•  The Insert hyperlink dialog box appears.
• If you had selected any text on the slide it will be displayed in the Text to display box.
• On the left side of the dialog box, under Link to section, Existing File or Web Page button is
selected. For linking the selected text or image choose any of the option from the Current Folder
button, Browsed Pages, Recent Files button.
•  Click OK.
Steps to insert a video file in presentation:
5.
• From the Insert tab, click the Video drop-down arrow in the Media group and select Video from File.
• The Insert Video dialog box appears. Navigate to the folder containing the video file and click to
select it. Click Insert to insert the video clip.

TEST PAPER 4

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which of the following is the keyboard shortcut to undo an action?
(a) Ctrl+Z (b) Ctrl+C (c) Ctrl+V (d) Ctrl+Y
2. Which key is used to select multiple range of cells?
(a) Ctrl (b) Shift (c) Alt (d) Tab
3. Which of the following is used to select entire worksheet?
(a) Ctrl+C (b) Ctrl+A (c) Ctrl+V (d) Ctrl+Y
4. Which key is pressed for partial modification of cells?
(a) F1 (b) F2 (c) F3 (d) F4
5. Which of the following is the keyboard shortcut to redo an action?
(a) Ctrl+Z (b) Ctrl+C (c) Ctrl+V (d) Ctrl+Y
B Fill in the blanks using the following words. (5 marks)

Wrap text      Font      Live Preview      mistakenly      rotation

1. is a new feature available in MS Excel 2019.

2. Orientation refers to the of the text in a desired angle.
3. Redo command is used to redo an action that is done.
4. allows to fit all the content visible within the same cell.
5. is the style, size and colour in which the text is written.
C Answer the following questions.  (10 marks)
1. What are the two ways of editing cell contents?
2. What do you mean by Formatting? In which tab are formatting commands located?
3. What is Alignment?
4. How can we do number formatting?
5. Name two features that make long text visible in the same cell.

34
D Answer the following questions in detail. (20 marks)
1. Explain the default mode of editing cell contents.
2. Explain the drag and drop method to move the data.
3. Name the options present in Orientation.
4. What are the steps to emphasize the cell contents?
5. Explain Merge and Center feature.
E Project Work (10 marks)
1. Create an Excel Sheet for 10 students of your class entering their names, roll numbers,
and marks in five subjects. Also, calculate the total marks and the percentage.
2. Make an Excel chart showing “Events to be held in cultural fest” in your school. Mention the name of the
Incharge for each event, time, date and venue. Use all formatting features to make it more interesting.

ANSWERS (TEST PAPER 4)

A 1. (a) 2. (a) 3. (b) 4. (b) 5. (d)

B 1. Live Preview 2.  rotation 3.  mistakenly 4.  Wrap text 5.  Font
C 1. The two ways of editing cell contents are:
• Overwriting • Partial Modification
Formatting: The presentation and appearance of the data on a page without changing the data
2. 
values is known as formatting. All formatting commands are available in the Home tab.
Alignment: The position of the data in the cell with respect to the boundary of the cell is known as
3. 
alignment of the text. It can be done horizontally or vertically.
4. Number formatting can be done by changing the number of decimals, adding commas and adding a
percent sign.
5. The two features that allow the long text visible in same cell are:
•  Wrap Text •  Merge and Center
Overwriting: Overwriting is the default mode of editing the cell contents. To edit a cell by overwriting
D 1. 
select it either by clicking on it or using the arrow keys on the keyboard and type in the new content.
Press the Enter key on the keyboard or click the Enter button in the Formula bar.
Drag-and-Drop Method: Position the cursor on the boundary of the selected range of cells that
2. 
you want to move. When the cursor changes to a cross shape, drag the data to the desired location
while holding the left mouse button. You will see the data is moved when you release the left mouse
button. This is called the drag-and-drop method.
The options present in orientation are:
3.
•  Angle Counterclockwise •  Vertical Text •  Rotate Text down
•  Angle Clockwise •  Rotate Text Up
Steps for emphasizing the cell contents:
4.
•  Select the data you want to emphasize.
• Click Home tab and from the Font group of buttons click Bold, Italic or Underline button.
• Depending on the button you click, the respective effect will be applied to the contents of the cell.
• You can also choose from different Underline options from Underline or Double Underline.
Merge and Center Feature: This is another feature that makes the long text merge with the
5. 
adjacent cells and form one large cell. The text is then placed in the centre of the merged cells.
Select the entire range of cells where the text extends and then click Merge & Center. This feature is
used to create labels that spans multiple columns.

35
 TEST PAPER 5

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. How many columns does MS Excel 2019 has?
(a) 16,384 (b) 16,386 (c) 16,385 (d) 16,387
2. What is the process of joining one string with another called?
(a) Ampersand (b) Joining (c) Adding (d) Concatenation
3. Which of the following operator has the highest order of precedence?
(a) ^ (b) / (c) * (d)  +
4. What is the shortcut key to enter or modify a formula in the cell?
(a) F1 (b) F2 (c) F3 (d)  F4
5. What is the shortcut key for AutoSum?
(a) Ctrl+= (b) Alt+= (c) Shift+= (d)  Delete+=
B Fill in the blanks using the following words. (5 marks)

predefined    characters    Formula    double    Joining    operations

1. The functions are present in the Function library group of buttons on the tab.
2. LEN is a text function which displays the number of in a cell.
3. of strings is called concatenation.
4. Functions are formulas to perform certain  .
5. The string values are always entered in quotes.
C Answer the following questions. (10 marks)
1. What do you mean by a formula?
2. What is the use of Today function?
3. What are the options provided by AutoSum drop-down menu?
4. Define a string. Which operator is used to join two strings?
5. Are formulas in MS Excel case sensitive?
D Answer the following questions in detail. (20 marks)
1. What are the constituents of a formula?
2. Explain ‘Entering a cell reference by pointing’.
3. What points should be kept in mind while creating numeric formulas?
4. What do you mean by AutoSum feature? Name any three options of AutoSum.
5. List six formula buttons of Functions Library along with their functions.
E Project Work  (10 marks)
1. Explore Function Library of MS Excel 2019.
2. Create a worksheet for the timetable of your class using the maximum functions. The timetable
should include the teacher’s name, period start and end time.

ANSWERS (TEST PAPER 5)

A 1. (a) 2. (d) 3. (a) 4. (b) 5. (b)

B 1. Formula 2. characters 3. Joining 4.  predefined, operations 5. double

36
C 1. A formula is a collection of cell references, constant values, operators and functions in a cell that
results in a new value.
2. Today is a Date & Time function that displays the current date.
3. The options provided by the AutoSum drop-down menu are:
• Sum • Average • Count Numbers • Max • Min
4. String is a set of characters on which we cannot do mathematical operations such as subtraction,
multiplication, etc. In Excel, two strings are joined using ‘&’ operator.
5. No, formulas in MS Excel are not case sensitive.
D 1. A formula in MS Excel always starts with an equal to (=) sign followed by one or more following
constituents:
• Cell addresses or range references — A4, D7:D10
• Constant values — Numeric (520, 70.5) and text (‘Morning and evening’)
• Mathematical operators — /, +, −, *
• Brackets — ( )
• Functions — Sum, Average, Max, etc.
2. While writing a formula in MS Excel we can click on cells instead of typing the cell addresses.
An animated border appears around the selected cell and ‘Point’ is displayed on the Status Bar.
This method is called entering a cell reference by pointing.
3. Following points should be kept in mind while creating numeric formulas:
• The evaluation is always carried out from left to right.
• The order of precedence of arithmetic operators is:
 ^   /, *   +, −
• If two operators have the same precedence, Excel evaluates from left to right.
• Any operation given in brackets will always be evaluated first.
4. AutoSum feature is one of the most commonly used features of MS Excel. It automatically adds the
numbers in the selected range of cells. Other than addition, the AutoSum feature can also be used to
find the average, maximum value, minimum value, etc.
The following are the AutoSum functions:
• Sum • Average • Count numbers • Max • Min
5. The various categories of Formula buttons present in Function Library are:
• Recently Used: provides a list of recently used functions
• Financial: provides a list of financial functions to choose from
• Logical: gives a list of logical buttons such as AND, OR, NOT, etc.
• Text: gives a list of text functions such as LEN
• Date & Time: gives a list of date & time function
• Lookup & Reference: gives a list of lookup and reference functions

TEST PAPER 6

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. In which year was Facebook launched?
(a) 2003 (b) 2004 (c) 2005 (d) 2006
2. What is the maximum character limit for a tweet?
(a) 120 (b) 140 (c) 160 (d) 180
37
 3. Which of these is described as the “SMS of the Internet”?
(a) MySpace (b) Gmail (c) Facebook (d) Twitter
4. Which of the following is not a newsgroup?
(a) Rec (b) Soc (c) Mec (d) Talk
5. The word Blog originates from which word?
(a) Web (b) V Blog (c) We Blog (d) Web Log
B Fill in the blanks using the following words. (5 marks)

BBS website video-based Chris DeWolfe communication

1. MySpace was founded in 2003 by and Tom Anderson.

2. A newsgroup is a source of both information and  .
3. was one of the first attempts to share information using the Internet.
4. A chat may be text-based, voice-based or  .
5. A blog is a which has posts.
C Answer the following questions. (10 marks)
1. What do you mean by tweets?
2. What is a chat window?
3. Who created Talkomatic?
4. What do you mean by newsgroups?
5. How is instant messaging helpful to us?
D Answer the following questions in detail. (20 marks)
1. List five features of Instant Messaging.
2. How is social networking useful to us?
3. How is newsgroup helpful to us?
4. What is the difference between Facebook and Twitter?
5. What do you mean by blogs? Who is a blogger?
E Project Work (10 marks)
1. Make a list of social networking websites which your family members are using.
Also, make a list mentioning the purpose of each website.
2. Make a list of “Precautions to be taken while using Chat Rooms”.

ANSWERS (TEST PAPER 6)

A 1. (b) 2. (b) 3. (d) 4. (c) 5. (d)

B 1. Chris DeWolfe 2. communication 3. BBS 4. video-based 5. website
C 1. Twitter is an online social networking service that allows its users to send and read short messages
which are called tweets.
2. A small window which is visible to both sender and receiver where they can send or receive messages
is called as chat window.
3. Talkomatic was created by Doug Brown and David R. Woolley.
4. A newsgroup is an online discussion group where information about a particular topic is exchanged.
5. Instant messaging is a type of online chat that allows us to communicate with people through text
messaging.
38
D
1. The features of instant messaging are:
•  Web Links: Share hyperlinks to your favourite websites
•  Video: Send and view windows, chat face-to-face with friends
•  Images: Share and view the image stored on your friend’s computer
•  Sounds: Play audio for your friends
•  Files: Send files as attachments directly to your friends
2. Social networking allows people, who share interests or real-life connections, to build social networks
or social relations. A social networking service consists of a representation of each user’s information,
his social links and a variety of additional services.
3. A newsgroup is an online discussion group where information about a particular topic is exchanged.
It is a source of both information and communication. In a newsgroup, messages are posted on a
bulletin board where any member of newsgroup can read and respond to them. To view and post
messages to the newsgroup, you need a newsreader. A newsreader is a program that runs on your
computer and connects you to a news server on the Internet.
4. Facebook was founded on 4 February 2004 by Mark Zuckerberg. Users need to register before using
the website. A registered user may create a personal profile, add other users as friends, exchange
messages and receive automatic notifications.
Twitter is an online social networking service that allows its users to send and read short text
messages of maximum 140 characters which are called tweets.
5. Blog originally came from the word ‘weblog’ or ‘web blog’. A blog is a website which has posts. The most
recent entries usually appear first and the oldest entries appear last. A user can use a blog to write
about any particular area of interest or any topic. The person who writes a blog is called a blogger.

TEST PAPER 7

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which of the following is used to keep a track of the number of times a loop is executed?
(a)  Track Variable (b)  Number Variable (c)  Loop Variable (d)  Control Variable
2. Which of the following is used to break the endless loop?
(a) Shift+Break (b) Alt+Break (c) Ctrl+Break (d) Del+Break
3. What is the default value to read LISTS in Python?
(a) 0 (b) 1 (c) −1 (d)  2
4. Which of these commands does not work with WHILE…WEND loop?
(a) Exit (b) Print (c) Cls (d) Var=10
5. How many components of loop are there?
(a) One (b) Two (c) Three (d) Four
B Fill in the blanks using the following words. (5 marks)

optional    terminates    repeated    forward    endless    backward

1. Looping means execution of a statement or a set of statements.

2. A loop must move either or .
3. The loop when the terminating condition is reached.
4. The index or step value is for FOR...NEXT loop.
5. If a loop does not terminate it is an loop.
39
 C Answer the following questions. (10 marks)
1. What do you mean by initialization and termination of loop?
2. Define looping.
3. Write down the syntax for input.
4. What does Step Up/Down specifies?
5. What is EXIT command used for?
D Answer the following questions in detail. (20 marks)
1. Write a program to print all odd numbers from 1 to 100 in PYTHON.
2. List all the components of python Tuples.
3. Write a program to print first 10 multiples of 10 in PYTHON.
4. Write a program in python to find the largest number among three number.
5. Write a program to print the table of 9 using python.
E Project Work (10 marks)
1. Write a program which displays the following output:
*
**
***
****
*****
2. Write a program to display all prime numbers from 1 to 100.

ANSWERS (TEST PAPER 7)

A 1. (d) 2. (c) 3. (a) 4. (a) 5. (d)

B 1. repeated 2. forward, backward 3. terminates 4. optional 5.  endless
C 1. Initialization is the value from where the loop starts and termination is the value at which the loop ends.
2. Looping means repeated execution of a statement or a set of statements.
Syntax for Input:
3.
Input ([ PROMPT])
4. Step Up/Down specifies how the loop execution moves forward or backward.
5. The EXIT command is used to stop the execution of FOR...NEXT, DO WHILE...LOOP, DO UNTIL...LOOP
statements.
D 1. # Python program to print odd Numbers in given range
start, end = 1, 100
# iterating each number in list
for num in range(start, end + 1):
# checking condition
if num % 2 != 0:
print(num, end = “ “)
2. 1. Empty Tuple 2. Tuple having integer
3. mixed datatypes in Tuple 4. Nested tuple
5. Duplicate value in Tuple 6. Accessing Tuple elements using indexing

40
 3. MULTIPLE =10
   DO WHILE MULTIPLE <= 100
  PRINT MULTIPLE
  MULTIPLE= MULTIPLE+10
LOOP
4. Write a program in PYTHON to find the largest number among three numbers.:
# Python program to find the largest number among the three input numbers
# change the values of num1, num2 and num3
# for a different result
num1 = 10
num2 = 14
num3 = 12
# uncomment following lines to take three numbers from user
#num1 = float(input(“Enter first number: “))
#num2 = float(input(“Enter second number: “))
#num3 = float(input(“Enter third number: “))
if (num1 >= num2) and (num1 >= num3):
largest = num1
elif (num2 >= num1) and (num2 >= num3):
largest = num2
else:
largest = num3
print(“The largest number is”, largest)

5. # Python Program to Print Multiplication Table of a Number

num = int(input(“Enter the number: “))
print(“Multiplication Table of”, num)
for i in range(1, 11):
print(num,”X”,i,”=”,num * i)

41
 TEST PAPER 8

NOTE: Attempt all questions. All questions are compulsory.

A Choose the correct option for each of the following. (5 marks)
1. Which of the following is not a component of Windows Movie Maker User Interface?
(a) Storyboard (b) Keyboard (c) Monitor (d) Status Bar
2. What is the shortcut key to have a full screen preview of the movie project?
(a) F9 (b) F10 (c) F11 (d) F12
3. Which of these can be placed only at the end of the movie?
(a) Titles (b) Caption (c) Heading (d) Credits
4. Which of these is not an option provided by Windows Movie Maker for adding the credits?
(a) Credits (b) Director (c) Caption (d) Location
5. What is the extension of the movie when it is saved as a project?
(a) .wlmp (b)  .wlpm (c) 
.lwpm (d) 
.wmp
B Fill in the blanks using the following words. (5 marks)

overlaying     playback     succession     Storyboard     Streamlined

1. Many single pictures run in in a movie.

2. Titles can be added a particular clip or photograph.
3. The is used to add and view the sequence of clips and/or photographs in the movie.
4. Windows Movie Maker is a video-editing application.
5. The Control buttons help us to navigate through the movie project.
C Answer the following questions. (10 marks)
1. What is a movie project?
2. List the components of Windows Movie Maker User Interface.
3. What is the format for displaying the duration of the movie?
4. Name the other name for Storyboard.
5. Name some audio and video formats that Windows Movie Maker support.
D Answer the following questions in detail. (20 marks)
1. List the steps to add videos or photos.
2. Explain in detail the buttons present in Add group of buttons in the Home tab.
3. How can we remove some portion of the video clip?
4. How can we save movie as a project?
5. What are the steps to add credits to the movie?
E Project Work (10 marks)
1. Collect your family pictures and make a beautiful movie ‘My Family’.
2. Find out the list of all the software that are used for movie making and compare them.

42
 ANSWERS (TEST PAPER 8)

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

B 1. succession 2. overlaying 3. Storyboard 4.  Streamlined 5.  playback
C 1. A movie project is a file that contains information about the arrangement of various pictures,
videos/audio clips and effects used to make a movie.
2. The components of Windows Movie Maker User Interface are:
•  Movie Maker Icon •  Title Bar and Ribbon •  Storyboard •  Monitor •  Status Bar
3. The time format for the duration of the movie is hours:minutes:seconds:hundredths of a second
(h:mm:ss:hs).
4. The other name for Storyboard is Mounting Area.
5. Windows Movie Maker supports almost all video formats, that is, MOV, MPEG-4, WMV, etc. and audio
formats, that is, .wav, .au, .mp3, etc.
D 1. Steps to add videos or photos:
• Click Add videos and photos button from the Home tab or from the Storyboard. The Add Videos
and Photos dialog box appears.
•  Select the drive and folder where the video/picture is stored.
•  Select the video or picture from the displayed list.
•  Click the Open button.
2. These are the three buttons present in the Add group of buttons on the Home tab:
Titles: Adds a new title before the selected item in a new frame before the selected frame
• 
Caption: Adds text that is displayed over the selected video or photograph frame
• 
Credits: Adds new frame containing blank credits
• 
Steps to remove some portion of the video clip:
3.
• Click at the position from where you want to start the selection. The cursor will appear before the
selected clip.
•  Right-click and select Set start point option from the drop-down menu.
•  Video Clip will start from this point. All the previous clips will be removed from the Storyboard.
• Similarly, right-click at any point on the video clip and select Set End Point option. Movie will end
at this point.
Steps to save movie as a project:
4.
• Click Movie Maker icon and select Save project as option from the drop-down menu. The Save
Project dialog box appears.
•  Select the folder in which you want to save the movie project.
• Specify the name of the file and click the Save button. The movie project file is saved with an
extension .wlmp.
Steps to add credits in a movie: Credits are always added at the end of the movie.
5.
• Click the arrow next to the Credit command in the Add group of buttons on the Home tab.
The drop-down menu appears.
•  The options available for adding credits are as follows:
   Credits     Starring   Soundtrack   Director     Location
• Select the desired option and type the text on the monitor. The same text appears below the
respective credit frame on the Storyboard.
•  The desired text effects can be included from the Text Tools Format tab.
•  The Credit frame is added at the end of the movie.

43
 Worksheets
WORKSHEET 1

A Search the following words in the wordsearch. (5 marks)

DIGITAL    SUPERCOMPUTER    ANALOG    HYBRID    EMBEDDED

R D I G I T A L R T I N G
G E X U N R N E B I C I H
C P F O R M A T T I N G A
D F I E S U L E N N A E R
S U P E R C O M P U T E R
G R T C O E G B L L R W W
W M E C E S N E E H E E A
D U R M T U E D N R T E R
Y L I N Y M X D I G I P E
F A N S M E E E A N Z E V
Z P H Y B R I D T I G N S
B Who am I? (5 marks)
(a) I am used for processing the information.
(b) I am also known as personal computers.
(c) I am the biggest and most expensive computers available today.
(d) I use continuous values from signals to process information.
(e) I am used in traffic light controlling system.
C Unjumble the words to fill in the blanks. (10 marks)
(a) computers are often enclosed in special devices meant for real-time applications.
(MEEBDEDD)
(b) Minicomputers are than microcomputers. (ERGARL)
(c) Specific purpose computers are meant to do specific only. (KSAST)
(d) Analog computers do not use the digits for processing the information. (IBANRY)
(e) Mainframes can handle thousands of at a time. (SURES)

44
 ANSWERS (WORKSHEET 1)

A
DIGITAL    SUPERCOMPUTER    ANALOG    HYBRID    EMBEDDED

R D I G I T A L R T I N G
G E X U N R N E B I C I H
C P F O R M A T T I N G A
D F I E S U L E N N A E R
S U P E R C O M P U T E R
G R T C O E G B L L R W W
W M E C E S N E E H E E A
D U R M T U E D N R T E R
Y L I N Y M X D I G I P E
F A N S M E E E A N Z E V
Z P H Y B R I D T I G N S

B (a) Microprocessor (b) Microcomputers (c) Supercomputers

(d)  Analog computers (e)  Specific Purpose computers
C (a) Embedded (b) larger (c) tasks (d) binary (e) users

WORKSHEET 2

A Search the following words in the table. (5 marks)

PLACEHOLDER PREVIEW DATA MERGED RECIPIENT

X S L I N E R V A M S
P R O N E D U R E I M
F D A S S D I R D R E
P L A C E H O L D E R
R R O T O G A H L C G
E O O T A O T E L I E
V C I D E H Y A T P D
I M N E I R A D H I C
E E N D N O T E M E Z
W S M J D R O R T N D
P A S T A R T R A T Z

45
 B Who am I? (5 marks)
(a)  I contain the text and graphics that are the same in each version of the merged document.
(b) I help to send personalized documents to a group of people without having to type each
document separately.
(c)  I am the default location for saving the address list.
(d)  I contain the information to be merged into document.
(e)  I am an extension of address files of Mail Merge.
C Unjumble the words to fill in the blanks. (10 marks)
(a) When performing the Mail Merge, each letter generated is addressed to each
____________. (CPIREEIETN)
(b) Protecting documents from unauthorized users with ______________ is known as encryption.
(SASPWDOR)
(c)  In the menu that appears, ________ is the default document. (TRSELTE)
(d)  Microsoft __________ is a personal email manager from Microsoft. (KOLOUTO)
(e)  We can ________ the Mail Merge before sending it. (ERPVWEI)

ANSWERS (WORKSHEET 2)

A
PLACEHOLDER PREVIEW DATA MERGED RECIPIENT

X S L I N E R V A M S
P R O N E D U R E I M
F D A S S D I R D R E
P L A C E H O L D E R
R R O T O G A H L C G
E O O T A O T E L I E
V C I D E H Y A T P D
I M N E I R A D H I C
E E N D N O T E M E Z
W S M J D R O R T N D
P A S T A R T R A T Z

B (a)  Main document

(b)  Mail Merge
(c)  My Documents\My Data Sources
(d)  Data source
(e) .mdb
C (a) recipient (b) password (c) Letters (d) Outlook (e) preview

46
 WORKSHEET 3

A Search the following words in the wordsearch. (5 marks)

HYPERLINK AUDIO VIDEO PRINT POWERPOINT

X S L I A E R V A M S
P R O N E U U R E T M
F D A S H D D R N R E
P L A C Y H O I D E R
R R O T P G O H O C G
N O O T E P T E E I E
T C I D R H Y A D P D
N M N E L R A D I I C
I E W D I O T E V E Z
R O M J N R O R T N D
P A S T K R T R A T Z

B Who am I? (5 marks)

(a) I am a coloured and underlined text or an image which when clicked opens another file, web page or
an application.
(b)  I occupy the full computer screen.
(c)  I am the button to be clicked to delete hyperlink.
(d)  I allow to add audio and videos to your presentation.
(e)  I am the key used to exit Slide Show view.

C Unjumble the words to fill in the blanks. (10 marks)

(a) To create a good ____________, various views are available in MS PowerPoint 2010. (REPESNATNOIT)
(b) Slide Show View is used to ____________ the presentation as you want the audience to see.
(EDILVRE)
(c)  If you had selected any text on the slide, it will be displayed in Text to ____________ box. (ISDALPY)
(d) You can link an e-mail address to any text or image in a presentation using ____________.
(YHERPNKILS)
(e)  PowerPoint allows you to add ____________ to your presentation. (UOSDN)

47
 ANSWERS (WORKSHEET 3)

A
HYPERLINK AUDIO VIDEO PRINT POWERPOINT

X S L I A E R V A M S
P R O N E U U R E T M
F D A S H D D R N R E
P L A C Y H O I D E R
R R O T P G O H O C G
N O O T E P T E E I E
T C I D R H Y A D P D
N M N E L R A D I I C
I E W D I O T E V E Z
R O M J N R O R T N D
P A S T K R T R A T Z

B (a)  Hyperlink (b)  Slide Show View (c)  Remove Hyperlink (d)  MS PowerPoint 2019 (e)  Esc key
C (a) presentation (b) deliver (c) display (d) hyperlinks (e) sound

WORKSHEET 4

A Search the following words in the wordsearch. (5 marks)

OVERWRITING     INSERT     ALIGNMENT     EXCEL     ORIENTATION

P A L I G N M E N T A
A U N R N E B I C I H
D S O F T W A R S N A
T T M M E R N U P E M
O V E R W R I T I N G
X C O M P I N E W W L
I X C V B J S L J U G
T M T I E T E X C E L
R N T E T E R K E P S
A S T V F I T W Z E A
O R I E N T A T I O N
B Who am I? (5 marks)
(a) I am the list created as per the requirement to enter items that are frequently typed in worksheets.
(b) I decrease the margin between border and text in the cell.
(c) I am the keyboard shortcut to select an entire worksheet.
(d) I am the distance between the margin and the data in the cell.
(e) I am the key needed to be hold to select first and last row simultaneously.

48
C Unjumble the words to fill in the blanks. (10 marks)
(a) Live is a new feature available in MS Excel 2019. (IRPEVWE)
(b) Redo command can be used to redo an action that was mistakenly . (NDEUON)
(c) Press F2 for partial of cells. (FCTNOIMDOIAI)
(d) Wrap text is done by the long text in multiple lines. (NGYLIPDSIA)
(e) The currently selected cell is known as cell. (TEVICA)

ANSWERS (WORKSHEET 4)

A
OVERWRITING     INSERT     ALIGNMENT     EXCEL     ORIENTATION

P A L I G N M E N T A
A U N R N E B I C I H
D S O F T W A R S N A
T T M M E R N U P E M
O V E R W R I T I N G
X C O M P I N E W W L
I X C V B J S L J U G
T M T I E T E X C E L
R N T E T E R K E P S
A S T V F I T W Z E A
O R I E N T A T I O N

B (a) Autofill (b) Decrease Indent (c) Ctrl+A (d) Indentation (e) Shift key

C (a) Preview (b) undone (c) modification (d) displaying (e) active

WORKSHEET 5

A Search the following words in the wordsearch. (5 marks)

FORMULA   AUTOSUM   CONCATENATION   STRING   FUNCTIONS

K L H S T B I E R V J M A
G S X U N R N E B I C I H
C P S S O A T W A R E N A
D F F T S U E R N N A E R
C O N C A T E N A T I O N
G R Z C O O R I L E R W W
W M Z C E S R I Y H E E A
D U A M T U E T N R T E R
Y L D N Y M T E P G I P E
F A H S M J E R A W Z E V
Z P C R F U N C T I O N S 49
 B Who am I? (5 marks)
(a) I calculate the Least Common Multiple of two or more integers.
(b) I am the shortcut key for AutoSum.
(c) I am an arithmetic operator which has the highest order of precedence.
(d) I display the number of characters in a cell.
(e) I am the operator which is used to concatenate two strings.

C Unjumble the words to fill in the blanks. (10 marks)

(a) A formula results in a new value from an _________ range of values. (NGXISEIT)
(b) The _______ values are always entered in double quotes. (GRISTN)
(c) The shortcut key can only be used for adding ___________ cells. (TCENDJAA)
(d) To give a range of non-adjacent cells in a formula, separate each cell address by a _______. (MCOMA)
(e) Joining of strings is called ______________. (NOCACETANNTOI)

ANSWERS (WORKSHEET 5)

A
FORMULA   AUTOSUM   CONCATENATION   STRING   FUNCTIONS

K L H S T B I E R V J M A
G S X U N R N E B I C I H
C P S S O A T W A R E N A
D F F T S U E R N N A E R
C O N C A T E N A T I O N
G R Z C O O R I L E R W W
W M Z C E S R I Y H E E A
D U A M T U E T N R T E R
Y L D N Y M T E P G I P E
F A H S M J E R A W Z E V
Z P C R F U N C T I O N S

B (a) LCM function (b) Alt+= (c) ^ (d) LEN function (e) &
C (a) existing (b) string (c) adjacent (d) comma (e) concatenation

50
 WORKSHEET 6

A Search the following words in the wordsearch. (5 marks)

FACEBOOK BLOG TWITTER MYSPACE SKYPE

C O L U M M S V A M F
P R F N E Y U R E I I
L D A S S S I K D R L
P L C C E P K L D E E
R R E T O A A Y L C T
E O B T B C T E P I A
V C O K E E Y A T E B
B L O G B B O N H I C
E O K O N O T E M E Z
W S M J W R O R T N D
P A S T W I T T E R Z

B Who am I? (5 marks)

(a)  I allow users to read and send tweets.
(b)  I was founded by Mark Zuckerberg in 2004.
(c)  I am a small window in which both sender and receiver messages are visible.
(d)  I am an online video-sharing website owned by Google in 2006.
(e)  I originally came from the word ‘weblog’.

C Unjumble the words to fill in the blanks. (10 marks)

(a)  There are several _________ through which we can send e-greeting cards. (STSEIWBE)
(b) The act of writing, posting or maintaining a blog is called ___________. (GNGGLOBI)
(c)  A newsgroup is a source of both ____________ and communication. (TONIAMRNIFO)
(d)  Use ________ language while chatting. (EDECTN)
(e)  When it comes to ________ networking, websites are commonly used. (CILASO)

51
 ANSWERS (WORKSHEET 6)

A
FACEBOOK BLOG TWITTER MYSPACE SKYPE

C O L U M M S V A M F
P R F N E Y U R E I I
L D A S S S I K D R L
P L C C E P K L D E E
R R E T O A A Y L C T
E O B T B C T E P I A
V C O K E E Y A T E B
B L O G B B O N H I C
E O K O N O T E M E Z
W S M J W R O R T N D
P A S T W I T T E R Z

B (a) Twitter (b) Facebook (c) chat window (d) YouTube (e) Blog

C (a) websites (b) blogging (c) information (d) decent (e) social

WORKSHEET 7

A Search the following words in the wordsearch. (5 marks)

LOOPING    INITIALIZATION    TERMINATION    VARIABLE    EXIT

B V L H S T B S O R T I N G T
V G A X U N G N E B I C I H E
X C P R O N M A T T I N G A R
S F Q E I S Q F W E V W R W M
D C O P C A T E N A T I O N I
F G O T C O B R I L L R W W N
W O M E C E S L I E H E E A A
L D U R M T U E E N R E X I T
X Y L I N Y M X E I G I P E I
Z F A N S M E E R A N Z E V O
C I N I T I A L I Z A T I O N
B Who am I? (5 marks)
(a) I am the keyboard shortcut to end an endless loop.
(b) I am used to keep a track of number of times the loop is executed.
(c) I am the value from where the loop starts.
(d) I am the value at which the loop ends.
(e) I stop the termination of loop before the termination condition is reached.

52
C Unjumble the words to fill in the blanks. (10 marks)
(a) Body of the loop refers to the _______________ that are to be executed repeatedly. (TSAETMNEST)
(b) The DO UNTIL...LOOP is executed till the condition is __________. (ESLFA)
(c) If the loop does not terminate, it is called an ___________ loop. (DENSLES)
(d) _________ rounds the result down to the nearest whole number in Python(NOISVID-OOLRF)
(e) Looping means _____________ execution of a statement or a set of statements. (ERPAEDTE)

ANSWERS (WORKSHEET 7)

A
LOOPING    INITIALIZATION    TERMINATION    VARIABLE    EXIT

B V L H S T B S O R T I N G T
V G A X U N G N E B I C I H E
X C P R O N M A T T I N G A R
S F Q E I S Q F W E V W R W M
D C O P C A T E N A T I O N I
F G O T C O B R I L L R W W N
W O M E C E S L I E H E E A A
L D U R M T U E E N R E X I T
X Y L I N Y M X E I G I P E I
Z F A N S M E E R A N Z E V O
C I N I T I A L I Z A T I O N

B (a) Ctrl+Break (b) Control Variable (c) Initialization (d) Termination (e) Exit command

C (a) statements (b) false (c) endless (d) floor division (e) repeated

WORKSHEET 8

A Search the following words in the wordsearch. (5 marks)

STORYBOARD    MOVIE    MONITOR    TIMER    PREVIEW

E V L H S T B S O R T F
L G A X U N G N H D I C
E C P R T I T L R T I V
M F Q E I M M A A E V S
E C O P C A O E D A T F
N R O T C B V N I L L D
T E M E Y E I L I E H X
S M U R M T E E E T R S
X I O I N Y M X E I O A
Z T A N S M E E R A N R
S I N I P R E V I E W F 53
 B Who am I? (5 marks)

(a) I help to navigate through the movie project.

(b) I am also known as Mounting Area.

(c) I am used to preview the movie in full screen.

(d) I am used to check the progress of the movie.

(e) I am a software which is used to import, capture, add and edit audio or video content to
create movies.

C Unjumble the words to fill in the blanks. (10 marks)

(a) The Status Bar displays __________ of the current movie project. (NRFIOAMNOTI)

(b) The __________ contains various tabs like Home, Animations, Visual Effects, etc. (BRBINO)
(c) The _______ Maker icon is present on the extreme left of the ribbon. (IVOME)

(d) When ___________ pictures and audio-video clips are joined together, we get a movie. (LMUITELP)

(e) Through the ____________, you can also view the video effects. (YRTOSRDOAB)

ANSWERS (WORKSHEET 8)

A
STORYBOARD    MOVIE    MONITOR    TIMER    PREVIEW

E V L H S T B S O R T F
L G A X U N G N H D I C
E C P R T I T L R T I V
M F Q E I M M A A E V S
E C O P C A O E D A T F
N R O T C B V N I L L D
T E M E Y E I L I E H X
S M U R M T E E E T R S
X I O I N Y M X E I O A
Z T A N S M E E R A N R
S I N I P R E V I E W F

B (a)  Playback Control buttons (b)  Storyboard (c)  Preview Full Screen button
(d)  Seek Bar (e)  Windows Movie Maker
C (a) information (b) ribbon (c) Movie (d) multiple (e) Storyboard

54
CHALLENGE YOURSELF
 Challenge Yourself

1. Find the missing number, if a certain rule is followed A. 5

in all the three gures. B. 3
C. 2
7 2 9 1 5 –2
D. 1
42 3 18 2 ? –3
5. How many 5's are there in the following number
A. –30
sequence which are immediately preceded by 7 and
B. 13
immediately followed by 6?
C. 18
755945764598756764325678
D. 30
A. One
2. There is a de nite relationship between gures 1 and B. Two
2. Establish a similar relationship between gures 3
C. Three
and 4 by selecting a suitable gure from the options
D. Four
that would replace the (?) in gure 4.
6. Select the gure from the options which satis es
the same conditions of placement of the dot as in
Fig. (X).

A.

B.

A.

C.

B.
D.

3. If '+' is written as 'divided by', ' ' is written as

'added to', '×' is written as 'subtracted from' and ' ' C.
is written as 'multiplied by', then what is the value of
24 12 18 + 9 ?
A. –25 D.
B. 0.72
C. 15.30
D. 290 7. Select the correct mirror image of the given combination
of letters/numbers from the options, if the mirror is
4. Which number is on the face opposite to 4, if the
placed vertically to the left.
the different positions of a dice are as shown in the
gures given below?
A.
B.
C.
D.
8. In a certain code, FIRE is written as QHOE and word can be formed, then give 'Y' as the answer.
MOVE is written as ZMWE, then the code for the A. A
word OVER is _______.
B. E
A. MWED C. X
B. MWEO D. Y
C. MWOE
10. Pointing towards a person, a man said to a woman,
D. MWZO
"His mother is the only daughter of your father." How
9. If it is possible to make only one meaningful word is the woman related to that person?
with the second, the third, the sixth and the eighth A. Daughter
letters of the word FRAGMENT, using each letter only
B. Sister
once, then which of the following will be the third
C. Mother
letter of that word? If no such word can be formed,
then give 'X' as the answer and if more than one such D. Wife

COMPUTERS AND INFORMATION TECHNOLOGY

11. In ______ architecture each computer has equivalent

capabilities and responsibilities and files that can be
C.
shared amongst all the computers.
A. Peer-to-Peer
D. All of these
B. Client-Server
C. Dual Server 14. You want to play sound when you hover your mouse
over an image during the slide show. Which of the
D. Server based
following options would you select for this purpose
12. Which of the following options of Control Panel in in MS-PowerPoint 2019?
Windows 10, allows you to change the settings to open
A.
an item by single click instead of double click?

B.
A.

C.
B.
D.

C.
15. What does the underlined word as shown here represents
in MS-Word 2010?

D.

13. Which of the following devices fall into the category

A. A link to an image is created with the help of
of mobile computing devices?
option.

A. B. A link to an image is created with the help of

option.
C. A link to an image is created with the help of
B. option.
D. None of these
16. Which of the following is NOT an antivirus 21. Given image shows a retailer tracking the information
program? of the items with the help of the devices that she has
worn in her eyes, head, ngers and wrist. Which of
A. Kaspersky
the following types of network is shown here?
B. AVG
C. Avira A. MAN
D. Doomsday B. BAN
C. WAN
17. Which of the following statements is INCORRECT
D. Nanoscale
about optical disc?
A. It is a secondary storage device. 22. A __________ is a group of software les that enables
B. Contents of a CD-ROM disk can be erased and the hardware device to communicate with computer's
operating system.
written on it multiple times.
C. It uses laser beam technology to read and write A. Internal Modem
data. B. Device Allocator
D. It does not have a mechanical read inbuilt write C. Device Driver
head to read or write the data. D. Register

18. What would the output of Step 2 and Step 3 23. Which of the following screen modes can be used
respectively, when you perform the given steps in for text in QBASIC?
MS-Excel 2019? A. SCREEN 0
Step 1 : Enter a value 25 in a cell. B. SCREEN 1
C. SCREEN 2
Step 2 : Click on the icon numbered as 1 in the given
D. All of these
snapshot.
Step 3 : Click on the icon numbered as 2 in the given 24. Which of the following statements is CORRECT?
snapshot. A. A machine language is a high level programming
Respective outputs are separated by comma(,) language.
A. 2500%, 25.00 B. Machine language code varies with the computer
2500
B. %, 25.00 used.
100 C. First generation computers were inexpensive and
C. 25.00%, 2.5
supported multi-tasking.
D. 2500%, 0.25 1 2
D. Assembly language is a machine-independent high
19. Which of the following options would let you change level programming language.
the style set of your document from Word 2010 to 25. A specially designed webpage that brings information
Word 2003 in MS-Word 2010? together from diverse sources in a uniform way is called
a web portal. Which of the following options offers
A.
web portal services?

B. A.

B.
C. C.

D. All of these
D.
26. How many times will the given code be executed in
Python?
20. You can show laser pointer during slide show by
LET i = 1
holding _____ key and pressing the _____ mouse
FOR J = i TO 1
button in MS-PowerPoint 2019. PRINT "TEST"
NEXT J
A. , left B. , left
A. In nite times
B. 0
C. , left D. , left C. 1
D. 2
27. _____ is a fash memory based direct access storage 31. What would be the output of following program, if user
device. has entered Trisha for INPUT prompt in Python?

A. 1: INPUT A$
2: GOTO 4
3: PRINT "You are at statement 4",A$
B. 4: PRINT "You are at statement 5",A$
A. You are at statement 4 Trisha
You are at statement 5 Trisha
B. You are at statement 4 Trisha
C.
C. You are at statement 5 Trisha
D. ERROR
D.
32. In the given image, data is transmitting from single
28. Identify the following. location to multiple locations. It is a type of _____.

– They are the most powerful and expensive

computers used primarily for processing complex
scienti c applications.
– They use multiprocessing and parallel processing
technologies to solve complex problems.
– Their speed is measured in tera ops or peta ops.
A. Minicomputers
B. Microcomputers
C. Supercomputers A. Point-to-Multipoint communication
D. Workstations B. Telephony-to-Point communication
C. Antenna Array communication
29. Match the computing machines given in Column-I D. Multipoint-to-Multipoint communication
with their descriptions given in Column-II.
33. Which of the following options rotate the normal text
Column-I Column-II
(as shown in Text-1) to counter clockwise direction
(a) ENIAC (i) Vacuum tube based
(as shown in Text-2) in MS-Excel 2019?
electronic computer
A B C
(b) Tabulating Machine (ii) A manually operated 1 National Cyber Olympiad
calculating device 2
(c) Napier's Bones (iii) Invented by Herman 3
Hollerith for data Text-1
processing
A. (a)-(iii), (b)-(ii), (c)-(i)
A B C
B. (a)-(ii), (b)-(iii), (c)-(i)
C. (a)-(i), (b)-(iii), (c)-(ii)
ad
l
na

er

1
pi
io

yb

D. (a)-(i), (b)-(ii), (c)-(iii)

at

ly
C
N

2
30. Favicon stands for favorite icon that represents a tiny 3
version of a company or website’s logo and are most Text-2
often found in address bar or in list of bookmarks
in a web browser. Which of the following is the A.
favicon used for Google search engine released on
1st September, 2015? B.

A. B.
C.

C. D.
D.
34. The icon shown here is used to _____________ in 38. In MS-PowerPoint 2019, _______.
MS-PowerPoint 2019. A. You cannot rename a slide master
B. You cannot add an animation effect to a blank
slide
C. You cannot add a transition effect to a blank
A. Insert a bulleted list slide
B. Insert the slide number D. You cannot insert a hyperlink to a picture in the
C. Add an action to the selected object same presentation
D. Insert decorative art in your presentation
39. Match the storage devices given in Column-I with the
35. Identify the following. purpose they can be used for given in Column-II.
– A device that is used for creating high quality Column-I Column-II
graphics, tables and diagrams.
– It uses ink pens or ink jets to create high quality (a) (i) Mass distribution of
graphics on paper or any other material. pre-recorded software
– They are commonly used for printing designs of programs
car parts, machinery, etc.
(b) (ii) Store digital information
A. in smartp hone s a nd
tablets
(c) (iii) E l e c t r o m e c h a n i c a l
B. magnetic disk used for
storing and retrieving
digital information in
C. computers
A. (a)–(i), (b)–(ii), (c)–(iii)
B. (a)–(iii), (b)–(ii), (c)–(i)
D. C. (a)–(ii), (b)–(iii), (c)–(i)
D. (a)–(iii), (b)–(i), (c)–(ii)

36. The given image is of a new type of bar codes in 40. Consider the cell A1 has a value 400.45. What would
square shape that can store enormous amount of be displayed in the cell when you click on button
data. Such type of codes can be read and scanned by in MS-Excel 2010?
smartphones easily. Identify it.
A. 400.5
B. 400.4
C. 4004.5
D. 4004.50
A. Quick Response Code
B. Quick Scanner Code 41. Given image shows two wireless devices with a wall
between them. Which of the following technologies
C. OMR Code
will be used by these devices for communication or
D. MICR Code
exchanging data?
37. Which of the following statements holds true about Data
the given icon with respect to MS-Word 2010?

Statement 1 : It lets you create and print labels. Laptop Wall Tablet
Statement 2 : It allows you to add greeting line to your Data
document. A. Bluetooth
A. Only Statement 1 B. Wi-fi
B. Only Statement 2 C. Infrared
C. Both Statement 1 and Statement 2 D. Both A and B
D. Neither Statement 1 nor Statement 2
42. Select the INCORRECT match. 44. You have a presentation of 40 slides and now you
A. 1 Exabyte – 210
× 2 Terabytes
10 want to make 4 different slide shows of it. Which of
B. 1 Petabyte – 210 × 210 × 210 Megabytes the following options would you select to do so in
MS-PowerPoint 2019?
C. 1 Gigabyte – 210 × 210 Bytes
D. 1 Kilobyte – 210 Bytes
A.
43. Which of the following devices can be used to
select keys from a picture of on-screen keyboard in
B.
Windows 7?

A. C.

D.

B.
45. Which of the following communication protocols adds
the security capabilities to standard HTTP protocol
for secure communication over a computer network
C. by providing authentication of the visited website?
A. HTTPS B. HTTPT
D. All of these C. HTTPST D. HTTPSS

ACHIEVERS SECTION

46. Identify the following. A. The preview of the selected style will show in the
– It is a utility software that examines computer les work area.
to look for known viruses by matching de nitions B. The preview of all the styles will be shown in the
from virus dictionary.
Styles task pane itself.
– It identi es suspicious behavior from a computer
program which might indicate infection. C. The preview of the selected style will show in a
separate window.
A. B. D. A new document containing the view of the current
document will be created and the preview will be
C. D. shown in new document.

48. Computer Language Translators is a computer program

47. Given below is the Styles task pane of MS-Word 2010. that converts instructions written in a given computer
What happens when you check the “Show Preview” language to another. Which of the following options
option available in this pane? would replace the '?' in the given diagram that represents
the working of Computer Language Translator?
Source code (High
level Language)

Computer Language
Translator

A. Machine code B. Alphabet code

C. Text code D. Linker code
49. Which of the following options would produce the D. INPUT "Enter a number", num
same output as the code given below will produce in IF num = 5 THEN PRINT "Number is 5" AND
Python? OR PRINT "Done"
INPUT "Enter a number", num
IF num = 5 THEN PRINT "Number is 5" 50. Identify the following.
PRINT "Done" – It is a wireless transmission channel used for long
A. INPUT "Enter a number", num distances.
IF num = 5 THEN PRINT "Number is 5" : ? "Done" – It allows signals to pass through thick objects such
B. INPUT "Enter a number", num as non-metallic substances.
IF num == 5 THEN PRINT "Number is 5" – It is used in communication satellites, radars,
END IF computer networks, etc.
PRINT "Done" A. Wi-Fi
C. INPUT "Enter a number", num B. Infrared
IF num is 5 THEN PRINT "Number is 5" ELSE C. Microwaves
PRINT "Done" D. Radio waves

SPACE FOR ROUGH WORK

1. (D) 2. (C) 3. (D) 4. (D) 5. (A) 6. (B) 7. (A)

8. (B) 9. (D) 10. (C) 11. (A) 12. (A) 13. (D) 14. (D)
15. (A) 16. (D) 17. (B) 18. (A) 19. (A) 20. (C) 21. (B)
22. (C) 23. (D) 24. (B) 25. (D) 26. (C) 27. (D) 28. (C)
29. (C) 30. (B) 31. (A) 32. (A) 33. (A) 34. (B) 35. (D)
36. (A) 37. (A) 38. (B) 39. (D) 40. (A) 41. (D) 42. (C)
43. (D) 44. (D) 45. (A) 46. (A) 47. (B) 48. (A) 49. (A)
50. (D)
NOTES

63
 NOTES

64
NOTES

65