GARDEN HIGH SCHOOL
CLASS VIII
Annual Examination 2018
Computer Science (Theory)
Time: 2 hours Full Marks: 80
This Question Paper has three printed pages.
Answers must be written in the script/s provided. You will not be allowed to write for the
first 15 minutes. This time must be spent in reading the Question Paper.
The time given at the head of this Paper is the time allowed for writing answers.
This Paper is divided into two sections.
Answer all the questions of Section A and any five of Section B.
Maximum marks for a question or parts of a question are given in brackets [ ].
SECTION A (30 marks)
Answer all the questions.
1. Fill in the blanks: [15]
(a) A _______ is a device that connects dissimilar networks.
(b) The _______ is a method used on the Internet to access the hypertext files.
(c) An _______ is a network, based on Internet technology that exists exclusively within
an organization.
(d) _______ refers to the amount of data that a signal or circuit can carry.
(e) A _______ is a group of discrete electronic units that are transmitted in rapid
succession.
(f) A _______ is a program that searches through a database of web pages for a
particular information.
(g) The _______ provides a simple, standardized way for users to access mail boxes
and download messages to their computers.
(h) The _______ defines a method for transferring files from one computer to another
over a network.
(i) In MS Excel, a _______ refers to a small black square at the corner of a selected
cell or range of cells.
(j) A _______ refers to a group of contiguous cells in a worksheet.
(2)
(k) Comments can be inserted in a cell by using the _______ tab → _______ group
→ _______ command.
(l) The address of a cell at the 20th column and 30th row is _______ .
(m) The _______ refers to the area of a chart where the data is plotted.
2. Define: [5 × 2 = 10]
(a) Gridlines (c) Web crawler (e) Server
(b) Formula (d) WWW
3. Convert: [2 × 2½ = 5]
(a) (110110)2 → ( )10 (b) (8102)10 → ( )8
SECTION B (50 marks)
Answer any five questions.
4. (a) With the help of an example, discuss the concept of mixed referencing in
MS Excel. [5]
(b) Write a program in BASIC, using the nested FOR....NEXT loop, to print the following
pattern: [5]
1357
357
57
7
5. (a) Discuss the attributes of the World Wide Web. [5]
(b) Write a program in BASIC to input a string in uppercase and form a new string by
concatenating the characters at the odd positions. Print the new string in
lowercase. [5]
6. (a) What are the three main platforms available under a broadband service? [6]
(b) Write a program in BASIC to generate the following series: [4]
1, 2, 4, 7, 11, 16
(3)
7. (a) Write a short note on the functioning of the Internet. [4]
(b) Write a program in BASIC to input the values of X and n and find the sum of the
following series: [6]
3 n
S =X + X + ...... + X
3! n!
8. (a) What are the two ways of saving a chart in MS Excel? [4]
(b) Write a program in BASIC to input a sentence and print the first character of every
word in it. [6]
9. Write a program to print the name, age, distance travelled and fare of each of the 50
passengers of a transport company, based on the following criteria: [10]
Age (in years) Distance (in km) Fare (`) / km
less than 10 – Nil
< 10 5
10 – 20 10 – 100 15
> 100 20
< 10 10
21 – 60 10 – 100 20
>100 25
< 10 3
more than 60 10 – 100 10
> 100 15