Foundation of Information Technology
Sample Summative
Assessment - Term II
(Code No: 165)
Class IX
Max
Time: 3 hours Max Marks: 90
SECTION
A
|
1
|
Rimika
wants to ensure that there is consistency in design and color in the
presentation that she is making. What should she do to achieve this?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
2
|
Nilesh
Aiyar is interested in storing his salary details and he also wants to
perform some calculations and analysis. Which Office application, will you
suggest Nilesh should use for this purpose?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
3
|
Technoware
Systems wants to train its sales personnel so that they can create a
slideshow for their customers showing the product range offered by the
company. State two features of presentation software that will make the
presentation interesting.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
4
|
Slide
Transition and Custom animations are two options available in Presentation
Tools. Which of these options helps you to include special effects on various
text boxes and images during designing a slide?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
5
|
Kanan wants to see all the slides in her presentation
simultaneously. Suggest which view she should use to see all the slides
simultaneously.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
6
|
Out
of the following external file(s), which one(s) will help you include sound
in your presentation?
JPEG,
WAV, GIF, BMP, MP3
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
7
|
The
formula in cell A2 is =B2+C3. On copying this formula to
cell C2, what will the formula be?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
8
|
What
will be the cell address of the cell formed by the intersection of the ninth
column and the eighth row?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
9
|
Give
an example of mixed referencing with respect to spreadsheet software.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
10
|
Solil
Harrit wants to insert graphics objects in his presentation. Give him names
of two graphics objects which he can insert in his presentation.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
11
|
What
extra hardware is required for adding and testing narration in a presentation
Tool?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
12
|
Out
of the following list pick out the option(s) that is not a type of
Plagiarism:
Adding
New Content, Potluck Paper, Ghost Writer, Photocopy
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
13
|
In
Spreadsheet software, what is the column immediately next to column “Z”?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
14
|
What
is the default extension of a workbook created using a spreadsheet package?
Give your answer with reference to any one spreadsheet package.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
15
|
If
the values in the cells is as given A1 = 5, A2 = 10, A3 = 15 then to continue
the series up to A20 which feature can we use?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
16
|
Kunal
has stored the formula =MIN(C1:C5) in cell C6. How will the formula change
when copied to cell D6.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
17
|
Anurag
is interested in developing content for world wide web using programming and
development tools. Suggest an appropriate career for him.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
18
|
Kadambari
wants to book an airline ticket. Can you tell why should she book the ticket
using internet?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
19
|
Write
appropriate formula for calculating percentage of marks of a student. Marks
obtained are given in the cell D8 and Maximum Marks are given in the cell D2.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
20
|
Irene
doesn’t know the how to move from one slide to the next in a slide show. Tell
two methods do to so?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
21
|
Keerit
doesn’t know the meaning of handouts. Explain the meaning of handouts to him.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
22
|
Anahita
wants to reorganize the slides in her presentation. Which view can she use to
reorganize the slides?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
23
|
How
would you refer to the range starting from 1st column, 1st row and
spread till 4th column and 5th row.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
24
|
Reena
wants to give her audience a paper copy of her presentation. What should she
create and print?
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
25
|
Three
types of masters exist in presentation software; two of them are slide master
and notes master. Which is the third master?
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
26
|
In
which view can we apply animation on the text or objects.
|
1
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
27
|
Define
the terms Plagiarism and Intellectual Property Rights.
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
28
|
Kamini
wants to change the background color of a slide. Help her by telling her
steps to do so.
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
29
|
Carefully read the news articles given below. What
has the writer of the second article done? What should be done to avoid such
a situation?
Daily News, August 26, 1997: Sheep rearing (original)
“The sheep was put on its back and pinned it
between the workers legs. Then, reaching for his clippers, he went to work.”
Network News, December 16, 2010:Ladakh Sheep rearing
“With a little persuasion, the worker pulled
the sheep onto its back and pinned it between his legs. Then, reaching for
his clippers, he went to work.”
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
30
|
Define
the following terms:
i)
Hacking
ii) Piracy
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
31
|
From the following list identify the features which are
available in both Presentation Tool and Spreadsheet Software:
i)
Spell Check facility
ii)
Header and Footer
iii)
Adding Watermarks/Backgrounds
iv)
Macros
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
32
|
Tarini
Fancy Inc. is planning to connect all computers in their
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
33
|
From
the following techniques which one is suitable for maintaining data integrity
and which one is suitable for ensuring security of information?
·
Data
encryption and Password protection
·
Backing
up data regularly
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
34
|
Jayant
Dhal has created a bar chart in the spreadsheet tool, now he is making a
presentation; he wants the same bar chart to be included in one of the slide
of the presentation. Suggest two ways to him for the same. Also tell the
difference between the two.
|
2
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
35
|
Margaret
Baxter has written a letter which she wants to send to 4 banks.
|
5
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
12/23, Nehru Place
New Delhi
12-March-2011
Dear <title>
<surname><Address line>
I am Margaret Baxter, the
general manager of the “Technological solutions LTD” and the holder of the current
account number <account_no>. I would like ask you to send me the
statement of the account for the last 3 months. I need to present this
statement to the tax authorities next week. I request you to kindly send the
statement at the earliest.
In reference to the above, I
would like to point out that I need the statement from 01.05.10 until
01.08.10.
A prompt reply will be highly
appreciated.
Thanking in advance,
Margaret
Baxter
(General
Manager)
“Technological
solutions LTD”
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
(i)
Margaret wants to send the letter with same content to 4 banks
with similar request. The addresses of all such banks along with
corresponding account numbers are stored in a separate document. Name the
feature which will help Margaret achieve the same.
(ii)
Name the two files that Margaret has to use to be able to send
letters to all the banks.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
(iii)
Identify the placeholders/merge fields in the given document.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
(iv)
Margaret wants to keep a record of all the changes/ corrections
that she makes in this document. Name the feature used to achieve the same.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
36
|
Name and explain any 5
components of a chart in a spreadsheet package. 5
|
5
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
37
|
Give the following answers with respect to spreadsheet:
(i) Cell A1 contains
the number 20 and B1 contains 3. What will be the contents of cell C1, if the
formula =A1+B1*2^3 is entered in cell C1?
(ii) The contents of
Cell A1, B1, C1 and D1 are 10, -20, 30 & -40 respectively. What will be
the value displayed in cell E1 which contains the formula =MIN(A1:D1)
(iii) Cell D3 contains
the formula =$B$3+C3 and this formula is
copied to cell E3, what will be the copied formula in cell E3?
(iv) Cell D3 contains
the formula =$B3 + C3 and this formula is
copied to cell E3, what will be the copied formula in cell E3?
(v) Cell D3 contains
the formula =$B3 + C$3 and this formula is
copied to cell E4, what will be the copied formula in cell E4?
|
5
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
38
|
Neel has recently joined an insurance company as Marketing
Executive. She is making a presentation on the company in which she wants to
incorporate the following features:
i)
Add the company’s logo (stored as a file on her computer) on the
first slide.
ii)
Add the name of the company on the top of each slide.
iii)
Add a movie clip in the 5th slide.
iv)
Connect Slide 4 to Slide 9 directly.
v)
Add slide numbers automatically at the bottom of each page.
Write
commands/features of presentation package using which she can achieve this.
|
5
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
39
|
Tariq
Fashions maintain their employee salary details in a spreadsheet as shown
below. A sample data of 7 employees is shown below. Write steps for the
operations (i) to (v) and answer the questions (vi) to (viii) based on the
spreadsheet given below along with the relevant cell address:
|
10
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
(i) To calculate the DA as 25 %
of BASIC+HRA for each employee and display in column D.
(ii) To calculate the NETSALARY as
BASIC+HRA+DA–PF for each employee and display in column F.
(iii) To find the maximum NETSALARY
and display in cell F9.
(iv) To count the number of
employees and display in cell B10.
(v) The Manager wants to know how
many employees from the above data are eligible for bonus. The criteria being
that the employees having a net salary greater than 75000 are not eligible
for bonus. Write the formula the Manager should use for achieving the same
and display the number of employees in cell F10.
(vi) The manager inserts a column
for S.No. in the above spreadsheet. Which feature will help him automate the
typing of sequential numbers in this column?
(vii) The manager wants to
graphically represent a comparative analysis of the salaries of employees.
Suggest the most suitable chart type for achieving the same.
(viii) If the Basic salary of an
employee changes, will the manager have to redo all the calculations for that
particular employee? Explain.
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
SECTION
B (MCQ)
40. Great
Bazaar has employed Yunus Kumar to manage and maintain their networking
architecture and wide area connectivity. Which of these best describes his job
profile
a)
Networking Engineer
b) Database
Analyst
c) Web
Designer
d) Programmer
41. Sumriddhi
is logging in to her gmail account and one of her friends is trying to peep in
and figure out her password. Which of the following issues is being infringed?
a.
Plagiarism
b.
Privacy
c.
Intellectual Rights
d.
None of the above
42. The
double arrow 
at the right end of a toolbar means _____.
at the right end of a toolbar means _____.
a) You
can drag the toolbar from here to make it float
b) The
Help button is hidden to the right
c) The
toolbar is floating.
d)
There are hidden buttons.
43. In a
presentation, Sachin has to change all occurrences of the word ‘Calcutta’ with
‘Kolkata’. Which one of the following options is most appropriate to do the
task:
a) Copy
& Paste
b) Find
& Replace
c) Cut
& paste
d) All
of the above
44. Members
of ‘Nibbles & Bytes’, the computer club of a school wants to prepare and
print Participation Certificate for all the participants in their annual
interschool symposium using a spreadsheet, where the details of the
participating students along with the events and schools are entered. Which of
the following office techniques is most appropriate to get the desired results:
a) Copy
& Paste
b) Find
& Replace
c) Mail
Merge
d) Cut
& Paste
45. Rehman
is making his Science Project Presentation on ‘Force and Motion’ using a
presentation software. He wants to add the phrase ‘Force and Motion
Presentation’ at the bottom of each page. Which option should he use:
a)
Footer
b) Header
c) Watermark
d) Bullets
46. A
student wants to create a ‘Digital Story Teller’ on the famous storyline
‘Rabbit & the Tortoise’. He has downloaded some images of Rabbit, Tortoise
and forest. He wants to add background music, voice over and animation. Which
one of the office tool he should use:
a) Word
Processing Software
b) Presentation
Software
c)
Spreadsheet Software
d) Database
Management System
47. Spell
Check will find errors in which of the following?
a) It
in a beautiful, sunny day.
b) It
is a beautiful sunny.
c)
It
isa beautiful, sunny day.
d) Is a
beautiful sunny day.
48. Ananya
wants to create a new slide show with the current slides but presented in a
different order. Which feature can she use to achieve the same.
a) Rehearsal
b)
Custom
Slide show
c)
Slide Show Setup
d) Slide
Show View
49. Vanya
has made a presentation on ‘Global Warming’. She wants to progress her slide
show automatically while she speaks on the topic in the class. Which of the
following features should she use to deliver her presentation:
a) Custom
Animation
b) Rehearse
Timing
c) Slide
Transition
d) Either
(a) or (b)
50. Computer
Teacher of ‘Shanti
Education School
a) Word
Processing Software
b) Presentation
Software
c) Spreadsheet
Software
d) Database
Management System
51. Why
does the SUM function in B6 show an error?
(i)
Manual calculation is turned on and the cell has
not been re-calculated.
(ii)
Someone has keyed the number 0 into B7.
(iii)
The
function contains a circular reference.
(iv)
The function is still being edited so hasn't
calculated a result yet.
52. In a
Spreadsheet, the following reference changes rows and columns automatically
when it is copied to a new cell:
(v)
Relative Reference
(vi)
Absolute Reference
(vii)
Mixed Reference
(viii)
All of the above
53. Numbers
entered into a cell are automatically _____
a) Left-aligned.
b)
Right-aligned.
c) Center-aligned.
d) Justified.
54. Chhaya
writes a really good essay on ‘Global Warming’ for her class. Her teacher
encourages her to submit it to a journal for publication and it gets accepted.
Who would own the copyright?
a) Teacher
b) School
c)
Chhaya
d) The
Publication that printed her essay
55. Sam
Niza, who was born in 1995, is thinking of a password for her online bank
account. Which one of the following you would suggest for strengthening the
security of her account:
a) sam95
b) a99p54c66
c) samniza1995
d)
sam1995
56. Which
of the following is not a transition effect
a) Box
in
b) Venetian
Blinds
c) Cover
down
d)
Slide
sorter
57. If
A1:A5 contain the numbers 16,10,3,25 and 6 then =Average(A1:A5;60) will display
a) 16
b) 25
c) 20
d) 18
Marking
Scheme
Foundation of Information
Technology
Sample Summative Assessment -
Term II
(Code No: 165)
Class IX
|
1
|
She
should create her presentation using some suitable template.
OR
She
should use master slides.
1 mark for any correct answer.
|
|
2
|
Spreadsheet.
1 mark for correct answer.
|
|
3
|
Custom
animation and slide transition. (OR any other features)
½ mark
for mentioning each feature.
|
|
4
|
Custom
animation.
1 mark for correct answer.
|
|
5
|
Slide sorter view.
1 mark for correct answer.
|
|
6
|
WAV
and MP3
½ mark
for mentioning each file type.
|
|
7
|
=D2+E3
1 mark for correct answer.
|
|
8
|
I8
1 mark for correct answer.
|
|
9
|
A$1
(OR any other correct example)
1 mark for correct example.
|
|
10
|
Pictures
and Autoshapes.
½ mark for each correct graphics object name.
|
|
11
|
Mike
and Speakers
½ mark for each correct hardware name.
|
|
12
|
Adding
New Content
1 mark for correct answer.
|
|
13
|
AA
1 mark for correct answer.
|
|
14
|
.ods
(OR .xls OR .xlsx OR any other correct extension.)
1 mark for correct answer.
|
|
15
|
Fill
Handle.
1 mark for correct answer.
|
|
16
|
=MIN(D1:D5)
1 mark for correct answer.
|
|
17
|
Web
Developer.
1 mark for correct answer.
|
|
18
|
It
will save her time. (Or any other relevant advantage)
1 mark for correct answer.
|
|
19
|
=D8/D2*100
(Or any other correct formula)
1 mark for correct answer.
|
|
20
|
(i)
Using
cursor control keys
(ii)
Using
mouse click
½ mark each for any two correct methods.
|
|
21
|
Handouts
are printouts of slides of a presentation. Usually these slides are small
sized versions of the slides printed multiple slides per page.
½ mark each for mentioning ‘small size’ and ‘multiple
slides per page’.
(Marks are to be awarded only if complete answer
makes sense)
|
|
22
|
Slide
Sorter View.
1
mark correct answer.
|
|
23
|
A1:D5
1
mark correct answer.
|
|
24
|
Handouts.
1
mark correct answer.
|
|
25
|
Handout
Master. (Or Handouts Master)
1
mark for correct answer.
|
|
26
|
Normal
View.
1
mark for correct answer.
|
|
27
|
Plagiarism
is the act of copying someone else’s intellectual word, fully or partially,
and presenting it as the original work of the copier.
Intellectual
property right is the right given to the creator of any intellectual content
like book, article, design etc. over the use of his creation.
1
mark for each correct answer.
|
|
28
|
Follow these steps
1.
Choose Format à Page.
2.
On the Background
tab page, select a background color.
1 mark for each correct step.
(Steps should be in the correct sequence)
|
|
29
|
Writer
of the second article has done plagiarism.
To
avoid such a situation, the writer of the second article must have taken
permission from the copyright holder of the first article and must have
mentioned the source of information in his article.
1 mark for the term ‘plagiarism’. 1 mark for
steps to avoid such a situation.
|
|
30
|
Hacking:
Unauthorised access to someone’s computer/network/website for malicious
purpose is called hacking.
Piracy:
Unauthorised duplication of software is called piracy. Piracy also includes
use of pirated software.
1 mark for each correct definition.
|
|
31
|
(i)
Header and Footer
(ii)
Macros
1 mark for each correct option.
|
|
32
|
Ethernet
cable.
LAN
will be formed as the area covered is limited to a building.
½ mark for correct cable type.
½ mark for LAN and 1 mark for justification.
|
|
33
|
·
Data
encryption and Password protection for ensuring security of information
·
Backing
up data regularly for maintaining data integrity
1
mark for each correct option.
|
|
34
|
Linking
and Embedding are the two ways.
After
embedding, any change on the chart in the spreadsheet will not have any
effect on the presentation. After Linking, any change on the chart in the
spreadsheet will be reflected in the presentation also.
1 mark for mentioning Linking and Embedding.
1 mark for clearly stating difference between
Linking and Embedding.
|
|
35
|
Margaret
Baxter has written a letter which she wants to send to 4 banks.
(i)
Mail
Merge
(ii)
Main
Document and Data Source
(iii) Placeholders/Mergefields in
the above document are:
<title>,
<surname>, <Address line>, <account_no>
(iv)
Review
1 mark for mentioning Mail Merge.
½ mark each for mentioning Main Document and
Data Source.
½ mark for each placeholder.
1 mark for mentioning ‘Review’.
|
|
36
|
(i) Chart Title: This is the
title of the chart which is used to give an idea about what the chart
represents.
(ii) Axes Titles: These are the
titles given to the axes of the chart.
(iii) Chart Area: This is the area
of a chart including all its components like titles and legends etc.
(iv) Data Series: This is the set
of values for which the chart is plotted.
(v) Legend: Legend is a small
component of the chart which tells the meaning of different
bards/columns/lines/points of a chart.
1 mark for each any 5 correct components of a
chart.
|
|
37
|
(i)
44
(ii)
40
(iii)
$B$3 + D3
(iv)
$B3 + D3
(v)
$B4 + D$3
1 mark for each correct answer.
|
|
38
|
i)
Insert
the picture by following the command Insert à Picture à From File and then choosing the
appropriate file.
ii)
Add
the name of the company in the master slide.
iii)
Insert
the movie clip by following the command Insert à Movie and Sound and choose the appropriate
movie clip.
iv)
In
the 4th slide she can insert hyperlink to the 9th
slide.
v)
By
inserting page number in the footer.
1 mark for each correct answer.
|
|
39
|
(i)
Insert
the formula =(B2+C2)*25% in the cell D2 and copy it in the cells D3 to D8.
1 mark for each correct formula. 1 Mark for
mentioning formula copy.
(ii)
Insert
the formula =SUM(B2:E2) in the cell F2 and copy it in the cells F3 to F8.
1 mark for each correct formula. 1 Mark for
mentioning formula copy.
(iii)
Insert
the formula =MAX(F2:F8) in the cell F9.
(iv)
Insert
the formula =COUNT(B2:B8) in the cell B10.
(v)
Insert
the formula =COUNTIF(F2:F8;”<=75000”) in the cell F10.
(vi)
Autofill
(vii)
Column
Chart (Or Bar Chart)
(viii)
No.
A spreadsheet package automatically recalculates the formulae whenever there
is any change in the spreadsheet data.
1 mark for each correct answer from (iii) to
(viii).
|
SECTION B (MCQ)
|
40. a)
|
41. b)
|
42. d)
|
43. b)
|
44. c)
|
45. a)
|
|
46. b)
|
47. c)
|
48. b)
|
49. b)
|
50. c)
|
51. c)
|
|
52. a)
|
53. b)
|
54. c)
or d)
|
55. a)
|
56. d)
|
57. c)
|
