Sample Paper for ICSE Class 8 Computer Studies

i. 3

Exp. Activities in an algorithm should be clearly defined so that the desired output can come after an algorithm is executed.

ii. 1

Exp: The (=) Function adds a formula to the current cell. Click the icon and then enter the formula in the input line.

iii. 1

Exp. Column chart is used for data that shows trends over time. It is a best chart that has relatively small number of data points.

iv. 3

Exp. The three algorithm constructs are input/output, decision and terminator. Algorithm is a set of steps for solving any logical or mathematical problem.

v. 1

Exp. There are three referencing styles in a worksheet – relative, absolute and mixed. Absolute referencing is opposite of relative referencing. Here, dollar sign ($) is placed before each letter and number in an absolute reference.

vi. 4

Exp. In multi-user operating system, more than one user can use the same computer at a time. Linux, UNIX and Microsoft Windows 2000 are few examples of multi-user operating system.

vii. 1

Exp. Activities in an algorithm should be clearly defined which means activities should not be ambiguous.

viii. 3

Exp. Single-user operating system supports only one user at a time. The most popular single user operating systems are Microsoft Windows 3.1, Microsoft Windows 95 and Microsoft DOS.

ix. 2

Exp. Literals are the constants which gives the exact representation of data. They remains fixed throughout the execution of the program.

x. 2

Exp. In graphical user operating systems, the commands were replaced by graphic symbols. The user can easily interact with the computer system with the help of graphics and icons.

a) Graphical User Interface

b) Booting

c) 3

d)graphical

e) Mixed

f)Field

g)derived

h)Interpreter

i)Functions

j) multiprocessing

a) T

b) T

c) F

d) T

e) F

f) T

g) T

h) F

i) T

j) F

a) MS-DOS is CUI based operating system.

b) Each step of an algorithm must be precisely defined.

c) Interpreter converts source program into object program one line at a time.

d) 1. Primitive data type
2. Derived/Reference Data type

e) The Min() returns the lowest value among the specified cells in the active cell.

a)

The functions of an Operating System are:-

• It coordinates different hardware and software components of a computer system.
• It supervises the various activities of a computer system and enables the computer to function in an efficient manner
• It helps in the smooth functioning of various peripherals.
• It helps the user to execute the programs for proper results.
• It determines the order and time to be allowed for each application.

b)

Integer Literal: The numbers which are represented without using decimal points are called integer literals.

Real Literals: These are also called floating-point constants. They represent numbers with decimal point.

Character Literals: The constants which are alphanumeric in nature are called character literal.

String Literal: String is a set of alphanumeric characters. A group of characters enclosed within a pair of opening and closing double quotes

a) Cell reference is the cell address in a formula. There are three types of cell references.

1. Relative Reference: When we create any formula, references to a cell are usually based on its relative position. When we copy a formula from one cell to another, the cell reference changes automatically.

2. Absolute Reference: When we don’t want to change the address of a cell while copying the formula to the other cell, we use absolute reference. For this, we use the ‘$’ sign before the column character and row number, e.g., $A$1.

3. Mixed Reference: It is a combination of relative and absolute references. In this, either the row or the column has to remain fixed, e.g., $A1 or A$1.

b) Rules for naming a variable are listed below:-

• A variable may have any number of characters.
• It may contain alphabets, digits and underscore.
• The underscore can be applied in between the characters to increase the length of a variable name.
• Variable names should be meaningful to easily depict the logic.

a) The steps to develop an algorithm are:-

• Begin the algorithm with the word ‘Start’.
• Give a number to each instruction.
• Write each instruction in a separate line.
• Each instruction should be written in simple English.
• The algorithm should finish with the word ‘Stop’.

b) The steps to create chart in MS Excel are:-

1. Select the contents of the worksheet.
2. Click the ‘Insert’ button from the ribbon area.
3. Select and click the type of chart from the Charts area.
4. It will show the different types of column charts. By default, the ‘2-D Column’ chart is selected.
5. Select the specific option from the 2-D Column chart.the chart based on the selected range of data will be displayed on the screen.

a) In multiprogramming system, two or more independent programs can be executed by the same computer with optimum utilization of the main memory of the system. Multiprogramming means executing more than one program.

In multiprogramming, when one program is waiting for I/O transfer, there is another program ready to utilize the CPU. Thus, it is possible for several users to share the execution time of the CPU ina sequence.

b) The various components of spreadsheets are as follows:

1. Worksheet: It is a grid of cells made up of horizontal rows and columns. It consists of 65,536 rows and 256 columns.
2. Row: Each row in Excel is identified by a specific number, which runs vertically at the left side of the worksheet. This number is known as a row header.
3. Column: Each column in Excel is identified by a specific letter, which runs horizontally at the top of the worksheet. This letter is known as a column header.
4. Cells: It is the intersection of a row and a column in worksheet. It is used to store data such as text, numbers, formulas, functions, etc.
5. Cell Pointer: Cell pointer is a cell boundary that specifies which cell is active at that moment.
6. Formula bar: It is located to the right of the name box. This bar displays the information entered or being entered as we type in the active cell.

a)

b) Key points of an algorithm are listed here-

• An algorithm is ‘A sequence of activities to be processed for getting desired output from a given input.’
• The desired output should come after the algorithm is executed.
• An algorithm should always run up to finite times.
• Activities in an algorithm should be clearly defined which means activities should not be ambiguous.