COMPLETE SEE COMPUTER SCIENCE MANUAL 2082
Sunday, October 5, 2025
Wednesday, October 1, 2025
SOLVED PABSON Kathmandu – Mid Terminal Examination 2082 – COMPUTER SCIENCE – SET B
SOLVED PABSON Kathmandu – Mid Terminal Examination 2082 – COMPUTER
SCIENCE – SET B
Attempt
all questions.
Group ‘A'(10 Marks)
1. Answer the following questions
in one sentence: (6´1=6)
a) Name any two connectors used in computer
network.
BNC and RJ-45
connectors are the any two connectors used in computer network
b) List any two examples of power protection
device.
Any two
examples of power protection device are volt guard and UPS
c) What is social media?
Social media
is an online platform that allows people to share information, ideas, and
communicate with others.
d) Write any two application of Artificial
Intelligence.
Any two
applications of Artificial Intelligence are speech recognition and self-driving
cars.
e) What is database?
A database is
an organized collection of data that can be easily accessed, managed, and
updated.
f) What is actual parameter in QBASIC?
An actual
parameter in QBASIC is the real value or variable passed to a subroutine or
function when it is called.
2. Write appropriate technical
term for the following: (2´1=2)
a)
A network device that connects
dissimilar networks with different protocols. Gateway
b)
A system of paying for goods and
services through an electronic medium. Online payment
3. Write the full form of the following: (2´1=2)
a)
Wi-Fi → Wireless Fidelity
b) G2C → Government to Citizen
Group ‘B' (24 Marks)
4. Answer the following questions: (9´2=18)
a)
What is communication? List the three
basic elements of any communication system.
The process of sending and receiving data
and information between two or more than two people is known as communication.
Three basic elements are: Sender, Medium,
Receiver.
b) What is digital footprint?
A digital footprint is the trail of data and information left behind by
an individual's online activities which includes social media posts, website
visits, online purchases, and other digital engagements
c)
What is biometrics? What does biometrics
use for user authentication?
Biometric is a technology that uses unique
physical or behavioral characteristics, such as fingerprints, facial
recognition, or voice patterns, to identify and authenticate individuals.
It uses fingerprints, face recognition,
iris patterns, or voice recognition for user authentication.
d) Mention any one advantage and disadvantage of
e-commerce.
Advantage:
E-commerce allows to shop 24/7 from anywhere with an internet connection.
Disadvantage:
Risk of online fraud and security issues.
e) What are the goals of E-Government?
The goals of E-Government are:
v Citizens can access government services and information
conveniently from anywhere.
v Reduces paperwork and manual processes, saving time and
resources.
v Promote transparency by making government actions and
decisions visible to the public.
f) What is record? Why is primary key necessary
in record?
A record is a
row in a table which contains information about single items in a database.
Record is complete set of information.
A primary key
is necessary in a database record because it reduce and control
duplication of the record in a table, sets the relationship between tables and
identifies each record of a table uniquely.
g) Differentiate between sorting and filtering.
|
Sorting |
Filtering |
|
The process of arranging all
the records in a table either ascending or descending order based on field or
fields is known as sorting. |
Filtering is the process of
viewing required record of a table that matches the specifies criteria. |
|
Sorting affects the entire
dataset. |
Filtering only affects the data
that is displayed. |
h) What is query? Mention the different types of
action query.
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.
Types of
action queries:
1. Update
Query
2. Delete
Query
3. Append
Query
4. Make-Table
Query
i)
What is report? Why it is important?
Report is one
of the MS-Access database objects used to present information in an effective
and organized format that is ready for printing.
It is important because it summarizes
information for decision-making, analysis, and sharing results.
5. Write
down the output of the given program. (Show with dry run in table. (2)
DECLARE SUB TEST(S$ )
CLS
E$ ="
PABSON"
CALL TEST (E$)
END
SUB TEST (S$)
FOR I = 1 to
LEN (S$)
IF i MOD 2 < > 0 THEN
EE$ = EE$+LCASE$(MID$(S$,I,1))
ELSE
EE$=EE$+UCASE$(MID$(S$,I,1))
END IF
NEXT I
PRINT EE$
END SUB
Dry Run Table
|
E$ |
S$ |
I
= 1 to LEN (S$) |
IF
i MOD 2 < > 0? |
Yes EE$
= EE$+LCASE$(MID$(S$,I,1)) |
No EE$=EE$+UCASE$(MID$(S$,I,1)) |
PRINT
EE$ |
|
PABSON |
PABSON |
1 to 6 yes |
1 mod 2<>0 1=0 Yes |
p |
|
|
|
|
|
2 to 6 yes |
2 mod 2=0 0=0 no |
|
A |
|
|
|
|
3 to 6 yes |
3 mod 2=0 1=0 yes |
b |
|
|
|
|
|
4 to 6 yes |
4 mod 2=0 0=0 no |
|
S |
|
|
|
|
5 to 6 yes |
5 mod 2=0 1=0 yes |
o |
|
|
|
|
|
6 to 6 yes |
6 mod 2=0 0=0 no |
|
N |
|
|
|
|
7 to 6 no Loop exits |
|
|
|
pAbSoN |
The Output of the program:
pAbSoN
6. Re-write the given program
after correcting the bugs: (2)
REM To check the supplied no. is odd or even
DECLARE FUNCTION Check$ (X)
CLS
ACCEPT “ANY NUMBER:”; N
CALL Check$ (X)
END
SUB Check$ (N)
Y=2
R= Y MOD N
IF R=0 THEN
C$= “EVEN”
ELSE
C$= “ODD”
END
C$=Check$
END FUNCTION
Debugged Program
REM To check the supplied number is odd or even
DECLARE FUNCTION Check$ (X)
CLS
INPUT "ANY
NUMBER: "; N
PRINT Check$(N)
END
FUNCTION Check$ (X)
Y = 2
R = X MOD Y
IF R = 0 THEN
Check$ = "EVEN"
ELSE
Check$ = "ODD"
END IF
END FUNCTION
7. Study the following program and answer the given questions: (2´1=2)
DECLARE SUB
TEST (B$)
CLS
INPUT W$
CALL TEST (W$)
END
SUB TEST (B$)
FOR I =1 To LEN (B$)
PRINT RIGHT$(B$), i)
NEXT I
END SUB
Questions:
a)
Write the name of two built in functions
used in the above program.
The name of two built in functions used in
the above program are LEN( ) and RIGHT$( ).
b) List the formal parameters of the above
program.
The formal parameters of the above program
is B$.
Group
‘C’ (16 Marks)
8. Convert / Calculate as per the instruction: (4´1= 4)
i) (231)8
= (?)10 ii)
(1D3)16 = (?)2
iii) (111001
- 11) + 111001 iv)(101101 ÷ 110)
9. Answer the following. (4´2= 8)
a) WAP
to calculate area of rectangle using SUB…. END SUB and
area
of circle using FUNCTION…. END Function. ‘
REM Area of Rectangle using SUB
DECLARE SUB AOR (L, B)
DECLARE FUNCTION AOC (R)
CLS
INPUT "Enter Length of Rectangle:
"; L
INPUT "Enter Breadth of Rectangle:
"; B
INPUT "Enter Radius of Circle: "; R
CALL AOR(L, B)
PRINT "Area of Circle = "; AOC(R)
END
SUB AOR (L, B)
A =
L * B
PRINT "Area of Rectangle = "; A
END SUB
FUNCTION AOC (R)
AOC
= 22/7 * R ^ 2
END FUNCTION
b) Write
a program to ask a number and check it is exactly divisible by 4 and 6 using
SUB……END SUB.
REM Check divisibility by 4 and 6
DECLARE SUB Check (N)
CLS
INPUT "Enter any number: "; N
CALL Check(N)
END
SUB Check (N)
IF
N MOD 4 = 0 AND N MOD 6 = 0 THEN
PRINT N; " is divisible by both 4 and 6"
ELSE
PRINT N; " is NOT divisible by both 4 and 6"
END
IF
END SUB
10. WAP
to find sum of digits of a number using SUB….END SUB. (4)
[Hint:
456: 4+5+6=15]
REM Sum of
digits using SUB
DECLARE SUB
Sum (N)
CLS
INPUT
"Enter a number: "; N
CALL Sum(N)
END
SUB Sum (N)
S = 0
WHILE N <> 0
R = N MOD 10
S = S + R
N = N \ 10
WEND
PRINT "Sum of digits = "; S
END SUB
.
or
Write a program in QBASIC to display sum of
first 10 natural numbers using FUNCTION…. END
FUNCTION.
REM Sum of first 10 natural numbers using FUNCTION
DECLARE FUNCTION Sum()
CLS
PRINT "Sum of first 10 natural numbers = "; Sum
END
FUNCTION Sum()
S = 0
FOR I = 1 TO 10
S = S + I
NEXT I
Sum = S
END FUNCTION
?ÿ@
SOLVED PABSON Kathmandu MID Term Exam 2082 Computer Science – SET A
SOLVED PABSON Kathmandu MID Term Exam 2082 Computer Science – SET A
Attempt
all questions.
Group 'A'(10 Marks)
1. Answer
the following questions in one sentence: (6x1=6)
a) What is computer network?
Computer
network is a group of two or more computers and devices connected to each other
through wired or wireless media to exchange data and information and share
hardware, software and other resources.
b) What do you mean by computer security?
Computer security refers to the
protection of computer systems, networks, and data from unauthorized access,
theft, damage, or disruption.
c) What is M-Commerce?
M-commerce
refers to the buying and selling of goods and services through mobile devices
like smartphones and tablets.
d) What is caption in MS-Access?
Caption is a
field property which gives alternative name given for any field.
e) Which data type is suitable for storing date
of birth in MS-Access?
Date/Time is
suitable for storing date of birth in MS-Access.
f)
Which command is used to call function
module in modular programming approach?
Function
module is called inside an expression or assign its result to a variable.
2. Write
appropriate technical term for the following: (2x1=2)
a)
A wireless technology that connects
electronics devices while they are close to each other. Bluetooth
b) The
process of sending data from your device to the internet or a remote server.
Uploading
3. Write the full form of the following: (2x1=2)
a) VOIP
– Voice Over Internet Protocol
b) G2B – Government to Business
Group 'B' (24 Marks)
4. Answer
the following questions: (9x2=18)
a) Differentiate between hub and switch.
|
Hub |
Switch |
|
It transmits data slower than switch. |
It transmits data faster than hub. |
|
It broadcasts the information packets to all computer connected network. |
It transfers packets to only those selected computers connected in
network. |
b) What is ICT? Write any two application of ICT.
ICT (Information and Communication Technology)
refers to the use of computers, the internet, and other digital tools to
manage, communicate, and share information.
Any two
application of ICT are:
Education
(E-learning): ICT is used for online classes, digital libraries, and
virtual learning.
Health
(Telemedicine): ICT is applied in remote health services, online
consultation, and sharing medical records.
c)
What is Internet of Things (IoT) and how
does it impact in everyday life?
Internet of
Things (IoT) refers to a network of interconnected physical devices that can
collect and exchange data over the internet without requiring human
intervention.
In daily life,
IoT helps in smart homes (automatic lights and security), healthcare (wearable
health trackers), and transportation (GPS-enabled smart vehicles). Thus, IoT
makes life easier, safer, and more efficient.
d) Write any two safety measures for online
payment.
Any two safety measures for online payment
are:
Use strong and unique passwords for
online accounts.
Avoid making payments on public Wi-Fi
networks.
e)
What is cloud computing? Write its types.
Its
types are:
Private
cloud, public cloud and hybrid cloud.
f) What is RDBMS? List few examples of it.
RDBMS is a
type of DBMS that uses a relational model to organize and manage data, allowing
users to easily retrieve and manipulate it.
Examples
of RDBMS:
·
MySQL
·
Oracle Database
·
PostgreSQL
·
MS Access
g) Define validation rule and validation text in
MS-Access?
Validation
Text is a field property which displays an error message that appears if the
data entered is invalid according to the specified validation rule.
h)
What are the differences between a
SELECT query and UPDATE query?
|
Select Query |
Update Query |
|
- A select query is the most
common category which is used to extract specific information from one or
more tables in a database. - The Select query is used to
select data from a database. |
- Update query is a type of
action query which makes global changes to a group of records in one or more
tables. - The Update query is used to
update existing records in a table. |
i) What is form? Why it is important?
Form is one
of the MS-Access database objects which provides graphical interface to view,
modify and add data in a table or multiple linked tables.
It is
important because it provides an easy-to-use interface for data entry and
manipulation, improving data accuracy and completeness. Forms can include
validation rules to ensure data quality and prevent errors.
5. Write down the output of the given program. (Show
with dry run in table). (2)
DECLARE
SUB PATT(S$)
CLS
S$=”DEVELOPER”
CALL
PATT(S$)
END
SUB
PATT(S$)
C=LEN(S$)
I=10
FOR
J=1 TO I STEP 2
PRINT
TAB (I); MID$ (S$,J,C)
C=C-2
I=I+1
NEXT
J
END
SUB
Dry
Run Table
|
J |
C (before print) |
I (tab position) |
MID$(S$, J, C) |
Printed Output |
|
1 |
9 |
10 |
DEVELOPER |
(tab 10) DEVELOPER |
|
3 |
7 |
11 |
VELOPER |
(tab 11) VELOPER |
|
5 |
5 |
12 |
LOPE |
(tab 12) LOPE |
|
7 |
3 |
13 |
PER |
(tab 13) PER |
|
9 |
1 |
14 |
R |
(tab 14) R |
The
output of the program is
DEVELOPER
VELOPER
LOPE
PER
R
6. Re-write
the given program after correcting the bugs: (2)
REM To check the greatest number.
DECLARE GREAT SUB (a, b, c)
ACCEPT a, b, c
CALL GREAT (a, b, c)
TERMINATE
SUB GREAT (a, b, c)
IF a>b or a>c THEN G=a
ELSEIF b>a AND b>c THEN
G=b
ELSE
G=c
END IF
PRINT G; “The greatest number is:”; G
END SUB
Debugged Program
REM To check the greatest number
DECLARE SUB GREAT (a, b, c)
CLS
INPUT a, b, c
CALL GREAT (a, b, c)
END
SUB GREAT (a, b, c)
IF
a > b AND a > c THEN
G = a
ELSEIF b > a AND b > c THEN
G = b
ELSE
G = c
END
IF
PRINT "The greatest number is: "; G
END SUB
7. Study
the following program and answer the given questions: (2)
DECLARE FUNCTION
count(B$)
INPUT
"Enter a word; W$
C=count(W$)
PRINT C
END
FUNCTION
count(B$)
FOR I =1 To LEN (B$)
X$=MID$(B$,I,1)
IF
UCASE$(X$)="A" THEN
X=X+1
ENDIF
NEXT I
count=X
END FUNCTION
Questions:
a)
What are the library functions used in the above program?
The library functions are: LEN() , MID$()
and UCASE$() \
b) Write the
use of variable "C" in line 3 in above program.
Variable C
stores the number of occurrences of the letter ‘A’ in the given word, which is
returned by the function.
[i.e.
C=count(W$)]
Group
'C' (16 Marks)
8. Convert / Calculate as per the instruction: (4
x 1=4)
i) (251)8
= (?)10 ii)
(5D3)16 = (?)2
iii) (111001 -
111) + 111001 iv) (101111 ÷
111)
9. Answer the following. (4x2=
8)
a) WAP
in QBASIC that ask length, breadth and height of room and calculate its
perimeter and volume. Create using SUB…. END SUB to calculate volume and
perimeter using FUNCTION…. END
Function. [Hint: Volume=LxBxH and perimeter=2[LxB]
REM Program to
calculate Volume and Perimeter of a Room
DECLARE SUB
Volume(L, B, H)
DECLARE FUNCTION
Perimeter(L, B)
CLS
INPUT "Enter
Length of room: ", L
INPUT "Enter
Breadth of room: ", B
INPUT "Enter
Height of room: ", H
CALL Volume(L, B,
H)
PRINT
"Perimeter of room = "; Perimeter(L, B)
END
SUB Volume(L, B,
H)
V = L * B * H
PRINT "Volume of room = "; V
END SUB
FUNCTION
Perimeter(L, B)
Perimeter = 2 * (L + B)
END FUNCTION
b) Write a program to ask a number and check it is exactly
divisible by 3 and 5 or not using
SUB……END SUB.
REM Program to check divisibility by 3 and 5
DECLARE SUB CheckDiv(N)
CLS
INPUT "Enter a number: ", N
CALL CheckDiv(N)
END
SUB CheckDiv(N)
IF
N MOD 3 = 0 AND N MOD 5 = 0 THEN
PRINT N; " is divisible by both 3 and 5."
ELSE
PRINT N; " is NOT divisible by both 3 and 5."
END
IF
END SUB
10. WAP to find sum of digits of a number using
SUB….END SUB. (4) [Hint:
123: 1+2+3=6]
REM Program
to find sum of digits of a number
DECLARE SUB
SumDigits(N)
CLS
INPUT
"Enter a number: ", N
CALL
SumDigits(N)
END
SUB
SumDigits(N)
S = 0
WHILE N > 0
R = N MOD 10
S = S + R
N = N \ 10
WEND
PRINT "Sum of digits = "; S
END SUB
or
Write a program using function module to
get the name of a user and print it in reverse order.
REM Program to reverse a name using FUNCTION
DECLARE FUNCTION RevName$(N$)
CLS
INPUT "Enter your name: ", N$
PRINT "Name in reverse: "; RevName$(N$)
END
FUNCTION RevName$(N$)
FOR I = LEN(N$) TO 1 STEP -1
R$ = R$ + MID$(N$, I, 1)
NEXT I
RevName$ = R$
END FUNCTION
?ÿ@
Subscribe to:
Comments (Atom)