SOLVED COMPUTER SCIENCE PRE-SEND UP Exam-2080 Gauri Shankar Secondary School Nisdi-4, Mityal, Palpa

 

PRE-SEND UP Exam-2080

Gauri Shankar Secondary School Nisdi-4, Mityal, Palpa

Grade:-10 (SEE)

Subject:- Computer Science

FM:-50

Time:- 2 Hrs.

Attempt all questions

 

Group-A (Very Short Questions-10 Marks)

 

1) Answer the following questions in very short. (6×1=6)

 

a) Define E-mail address.

Ans:

 An email address is a unique identifier used for sending and receiving electronic messages over the internet.

b) What is the vision of IT Policy of Nepal 2072?

Ans: The vision of IT Policy of Nepal 2072 is to transform Nepal into information and knowledge based society and economy.

 

c) What is the default size of number field in MS-Access?

Ans: The default size of number field in MS-Access is Long Integer

 

d) Write two examples of primary key fields.

Ans: Any two examples of primary key fields are SEE Registration Number and Roll Number

 

e) What is the function of SQR in Q-Basic?

Ans: The function of SQR in Q-Basic us to calculate the square root of a given number.

 

f) Write the name of unary operators used in C-Language.

Ans: The name of unary operators used in C-Language are ++ (increment) and - - (decrement)

 

2) Write appropriate technical term of the following.(2×1=2)

 

a) Paying money in E-Commerce using internet. Online Payment

 

b) A main computer in the computer network. Server

 

3. Write the full forms of the following: (2×1=2)

 

a) HEVC - High Efficiency Video Coding

 

b) VOLTE - Voice over Long Term Evolution

 

Group-B (Short Questions -24 Marks)

 

4) (Answer the following questions in short. 9×2=18

 

a) Define fiber optic cable. Write any two connectors used in it.

Fiber optics cable is one of the costlier cables used in data communication which uses light to carry a data signal through the cable.

The connectors used in fiber optics are ST Connector (Straight Tip) and FC Connector (Ferrule Connector)

 

b) Define digital Citizenship. Write any two elements of it.

Digital citizenship refers to the responsible and ethical use of technology and the internet which involves understanding, practicing, and promoting appropriate behavior when using digital tools and resources.

Any two elements of it are:

lDigital Access: The state of full electronic participation in society

l Digital Commerce: The act of promoting the purchase of goods through electronic means

 

c) Write the difference between E-Commerce and M-Commerce.

 

The difference between E-Commerce and M-Commerce are:

M-Commerce	E-Commerce
Mobile Commerce in short it is called as m-commerce.	Electronic Commerce in short it is called as e-commerce.
M-commerce activities are performed with the help of mobile devices like smartphones, tablets, PDA’s (Personal Digital Assistant) etc.	E-commerce activities are performed with the help of desktop computers and laptops.
M-commerce is conducted using mobile devices such as smartphones and tablets.	E-commerce is conducted using desktop or laptop computers.
Examples of M-commerce includes mobile banking like paytm, in-app purchasing Amazon mobile app.	Examples of E-commerce includes Amazon, Flipkart, Quikr, Olx websites.

 

d) What is meant by password? Write the rules to be followed while creating the password?

A password is a string of characters including letters, digits, or other symbols which confirms the identity of a user.

The rules to be followed while creating the password are:

l Don't use easily guessable the name of a pet, child, family member, birthdays, birthplace, name of a favourite holiday.

l Mix characters, numbers and symbols. Also, mix small and capital letters.

 

e) What is E-Government? Write any two website URL of government of Nepal.

E-Governent is a set of services provided by the government to public via electronic media especially using Internet.

Any two website URL of government of Nepal

https://moecdc.gov.np/ and https://www.nepal.gov.np/

 

f) What is Database? Give any two examples of DBMS.

A collection of systematically organized inter-related data is called a database. The purpose of data base is to store, organize and retrieve data.

Any two examples of DBMS are: MS-Access, Oracle

 

g) What is foreign key? Why is it important to specify primary key in data base?

A foreign key in MS Access is a field that establishes a relationship between two tables by referencing the primary key of another table. it important to specify primary key in data base to reduces and control duplication of record in a table and sets the relationship between tables

 

h) What is filtering? List any two advantages of data sorting.

Filtering is the process of viewing required record of a table that matches the specifies criteria.

Any two advantages of data sorting are:

·       Sorting helps to organize data and make it easier to find and retrieve specific information.

·       Sorting can save time and improve efficiency by allowing users to quickly access the data they need.

 

i) Define query. List the types of it.

Query is an object of database that is used to view, retrieve, change and analyze records from a table or multiple linked tables based on specified condition.

Its types are select query and action query.

Select query is a type of query which is used to select and display the relevant data from the database.

Action query is a query that makes changes to or removes many records in just one operation.

 

5) Write down the output of the given program. Show with dry run in table.) 2

DECLARE FUNCTION Interest (p,t,r)

CLS

LET p= 500

LET t=3

LET r=15

LET ans =interest(p,t,r)

PRINT "The interest="; ans

END

 

FUNCTION Interest (p,t,r)

I=(p*t*r)/100

Interest=l

END FUNCTION

 

Dry Run Table

p	t	r	ans =interest(p,t,r)	PRINT ”The interest=”;ans	I=(p*t*r)/100	Interest=l
500	3	15	Ans=225	The interest=225	(500*3*15)/100 =225	Interest=225

The output of the program is:

The interest=225

 

6) Re-write the given program after correcting the bugs.2

REM to store record in data file

CLS

OPEN "info.dat" FOR INPUT AS #1

DO

INPUT "Enter Name, Address and Class"; N$,A,C

INPUT #1,N$,A,C

INPUT "Do you want to continue";Y$

WHILE UCASE$(Y$) = "Y"

CLOSE "info.dat"

END

Debugged Program

REM to store record in data file

CLS

OPEN "info.dat" FOR OUTPUT AS #1

DO

INPUT "Enter Name, Address and Class"; N$,A$,C

WRITE #1,N$,A$,C

INPUT "Do you want to continue";Y$

LOOP WHILE UCASE$(Y$) = "Y"

CLOSE #1

END

7) Study the following program and answer the following questions. (2×1=2)

 

DECLARE FUNCTION prod(x,y)

CLS

INPUT "Enter first number" ;x

INPUT "Enter second number" ;y

PRINT "The product of two number is" ;prod(x,y)

END

 

FUNCTION prod(x,y)

P=x*y

Prod=p

END FUNCTION

 

List the numerical variables used in above program.

The numerical variables used in above program are: x, y and p

 

List the local variables used in above program.

The local variables used in above program are: x, y and p.

 

Group-C (Long Questions-16 Marks)

8) Convert or Calculate as per the instructions: (4×1=4)

 

 

i) (11101010101)2= (?)16

 

Convert every 4 binary digits (from bit) to hex digit (see conversion table below):

11101010101

= 111 0101 0101

0111= 7

0101 = 5

0101 = 5

= 755

(11101010101)2= (755)16

 

ii) (555)8=(?)10

 

555

= (5 × 8²) + (5 × 8¹) + (5 × 8⁰)

=5x64+5x8+5x1

= 365

(555)8=(365)10

 

iii) (11110)2 + (1100)2-(1000)2

 

	1	1	1	1	0
	+	1	1	0	0
1	0	1	0	1	0
	-	1	0	0	0
1	0	0	0	1	0

 

(11110)2 + (1100)2-(1000)2 = (100010)2

 

iv) (10110)2÷(101)2

 

101)	1	0	1	1	0	(100
-	1	0	1
	0	0	0	1	0
			-	0	0
				1	0

 

Q=100

R=10

 

9. a) Write a program in Q-BASIC that asks first term, common Difference and No. of terms of a arithmetic series and calculate its general term and sum. Create a Function procedure to calculate general term and sub procedure to calculate sum.                4

 [Hint:- tn = a+[(n-1)xd] and Sn = n/2 [2a+(n-1)xd]

 

DECLARE FUNCTION GTE(A,D,N)

DECLARE SUB SUM(A,D,N)

CLS

INPUT “Enter first Term”; A

INPUT “Common Difference”; D

INPUT “No. of Terms”; N

PRINT “General Term=”; GTE(A,D,N)

CALL SUM(A, D, N)

END

FUNCTION GTE(A, D, N)

GTE=A+((N-1)*D)

END FUNCTION

 

SUB SUM(A, D, N)

S=N/2*(2*A+(N-1)*D)

PRINT “SUM=”; S

END SUB

 

b) A sequential data file called "RECORD.DAT" has stored data under the field heading Roll No., Name, Gender, English, Nepali, Maths and computer. Write a program to display all the information of those students whose gender is 'F' and obtained marks in computer more than 90.)

 

OPEN “RECORD.DAT” FOR INPUT AS #1

CLS

WHILE NOT EOF(1)

INPUT #1, R, N$, G$, E, N, M, C

IF UCASE$(G$)=”F” AND C>90 THEN

PRINT R; N$; G$; E; N; M; C

END IF

WEND

CLOSE #1

END

 

 

 

10) Write a C Program that takes principal, rate and time PTR as input and it calculate the simple interest.) 4

 

#include<stdio.h>

#include<conio.h>

int main()

{

float p, t, r, i;

printf("Enter principal: ");

scanf("%f", &p);

printf("Enter time: ");

scanf("%f", &t);

printf("Enter rate: ");

scanf("%f", &r);

i = (p*t*r)/100;

printf("Simple Interest = %.2f", i);

return 0;

}

 

 

 

Write a program in C-Language to display first 10 natural numbers.

 

#include<stdio.h>

#include<conio.h>

int main()

{

int i;

i=1;

while(i<=10)

{

    printf("%d \n", i);

    i++;

}

return 0;

}

 

 

 

 

 

 

Best of Luck