SEE 2081 Computer Marking Scheme

SEE 2081(2025)
Optional II - कम्प्युटर बिज्ञान
Marking Scheme
Q.No. Answer Marks
Group 'A' (10 marks)
1 a. Telecommunication is the transmission of information over a distance using electronic means like phones, radio, or the internet. (or any other satisfactory answer) 1
b. Radio Broadcasting, Newspaper (or any other satisfactory answer) 1
c. Design View and Datasheet View. 1
d. The maximum number of characters allowed for a field name is 64 characters 1
e. KILL "filename" 1
f. int, char (or any other correct keywords) 1
2. a. Search Engines 1
b. . Digital footprint 1
3. a. UPS – Uninterruptible Power Supply 1
b. VR – Virtual Reality 1
Group 'B' (24 marks)
4. a.
Guided MediaUnguided Media
i. Transmission occurs through a physical medium. i. Transmission occurs without a physical medium, using waves.
ii. Uses cables like twisted pair, coaxial, and fiber optic. ii. Uses wireless signals like radio waves, microwaves, and infrared.
(or any other satisfactory answer)
2
b. Cyber law refers to the legal regulations that govern the use of the internet, computers, and digital communication to protect individuals, organizations, and governments from cyber crimes such as hacking, fraud, and data breaches. Do and Don't - Respect others' privacy by keeping their personal information confidential. - Do not engage in cyberbullying or spread false information online. (or any other satisfactory answer) 2
c. Antivirus software is a program designed to detect, prevent, and remove malicious software such as viruses, worms, trojans, and spyware from a computer system. Examples of Antivirus Software: i. Windows Defender ii. Avast Antivirus (or any other satisfactory answer) 2
d. E-commerce is gaining popularity over traditional commerce due to its convenience and efficiency. Here are two key reasons: i. 24/7 Availability: Unlike traditional stores with fixed hours, e-commerce platforms operate 24/7, allowing customers to shop anytime from anywhere. ii. Wider Reach and Cost Efficiency: E-commerce enables businesses to reach a global audience with lower operating costs compared to maintaining physical stores. (or any other satisfactory answer) 2
e. E-Governance refers to the use of information and communication technology by the government to provide services, exchange information, and improve efficiency, transparency, and citizen participation in governance. Two Examples of E-Governance Services in Nepal: Nagarik App, Online Tax Payment System. (or any other satisfactory answer) 2
f. A database is an organized collection of data that allows users to store, retrieve, manage, and manipulate information efficiently. It is used to handle large amounts of structured data for various applications. Two Data Types Used in MS Access: Text (Short Text), Number. (or any other satisfactory answer) 2
g. Field: A field is a single column in a table that stores a specific type of data. Example "Name," "Age," and "Address" are fields in a student database. Record: A record is a complete set of related data stored in a row of a table. A single student's details, such as "John, 12, New York," form a record. (or any other satisfactory answer 2
h. A report in a Database Management System is a formatted and organized way of displaying data from a database, usually for analysis, decision-making, or printing purposes. Better Data Presentation: Reports allow users to view data in a structured and readable format. Easy Analysis and Decision-Making: Reports help in summarizing large amounts of data, making it easier for businesses and organizations to make informed decisions. (or any other satisfactory answer) 2
i. A query is a request for data retrieval, modification, or manipulation from a database. It helps users filter, sort, and analyze data efficiently. Different Types of Action Queries: - Append Query - Update Query - Delete Query - Make Table Query 2
5
Dry Run Table:
Iteration c(Index) MID$(T$,C,1) D$
1st 1 C C
2nd 3 M M
3rd 5 U U
4th 7 E E
Final Output is : C M U E
2
6 REM to add record in an existing file. OPEN "student.dat" FOR APPEND AS #2 TOP: INPUT "Enter Name, Class and Roll No."; SName$, C, RN WRITE #2, SNames$, C, RN INPUT "More records";Y$ IF UCASE$(Y$)="Y" THEN GOTO TOP CLOSE #2 END Note: (PRINT #2 is also ok) 2
7 (a) PRINT "Number of vowels: "; count (W$) (b) LEN(A$), MID$(A$, I, 1) 2
Group 'C' (16 marks)
8 (i) (1503)8=(343)16 (ii) (101000101)2=(505)8 (iii (10001)2 (iv) Q=(0110)2 and R=(11)2 4
9a DECLARE FUNCTION Perimeter (L, B) DECLARE SUB Volume (L, B, H) CLS INPUT "Enter length of the room: "; L INPUT "Enter breadth of the room: "; B INPUT "Enter height of the room: "; H PRINT "Perimeter of the room: "; Perimeter (L, B) CALL Volume (L, B, H) END FUNCTION Perimeter (L, B) Perimeter = 2 * (L + B) END FUNCTION SUB Volume (L, B, H) V = L * B * H PRINT "Volume of the room: "; V END SUB (or any other correct coding) 4
9b CLS OPEN "std.dat" FOR INPUT AS #1 PRINT "Students scoring more than 40 in Computer:" PRINT "Name", "Roll No.", "English", "Nepali", "Maths", "Computer" DO WHILE NOT EOF(1) INPUT #1, Name$, Roll, Eng, Nep, Math, Comp IF Comp > 40 THEN PRINT Name$, Roll, Eng, Nep, Math, Comp END IF LOOP CLOSE #1 END (or any other correct coding) 4
10 Find the GREATER number #include <stdio.h> #include <conio.h> int main () { int a,b; printf ("Type first number "); scanf ("%d",&a); printf ("Type second number "); scanf ("%d",&b); if (a>b) { printf ("Greater number is %d ",a); }else{ printf ("Greater number is %d ",b); } getch (); return 0; }
OR
#include <stdio.h> int main ( ) { int i, term = 5; printf("Series: "); for (i = 1; i <= 15; i++) { printf("%d", term); if (i < 15) { printf(", "); } term += 5; } printf(" \n "); return 0; } (or any other correct coding)
4