S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE
Model Practical Question issued by CDC
External Practical Examination
F.M: 25  P.M: 10  TIME: 1hr

Group  A
MS-Access (10 Marks)

1.(a) Create a table of student having following structure (2)

 Field Name Data type Regnum Number (PK) Name Text Address Text DOB Date/Time Tel-number Text

(c) Make a query show1 that displays all the records whose address is Patan.          (2)
(d) Make a query show2 that displays DOB greater than or equal to 10/08/1990.  (2)
(e) Prepare a Form Wizard using above table. (2)

Group B
QBasic (15 Marks)

2.   (a) Write a program to calculate the perimeter  of a rectangle using SUB….END SUB.   (3)
(b) Write a program to find out the average of given two numbers by using keyboard FUNCTION…END FUNCTION.  (3)
(c) Write a program to find the sum of natural number from 1 to 100 using SUB …END SUB.   (3)
(d) Write a program to store students name, age and address in a sequential data file person.dat.   (3)
(e) Display all the records of person.dat stored in 2 (d).   (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE
Set- B
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

Q. 1. a. Create a data file Employee.MDB and create a table Emp1 under the database with the following structure: (2)

 Field Name Data type Name Text Address Text Ph-no Text Marital Status Yes/No Salary Number

b) Add five records in the Emp1 table.  (2)
c) Prepare a query to display all the married staffs.  (2)
d) Prepare a query to display all the employees whose salary is more than 5000.  (2)
e) Prepare the report of 1(c). (2)

Group B
QBASIC Programming (15 Marks)

2.    a)    Write a program using SUB..END SUB to calculate the volume of cuboids. [Hint: V= L3]   (3)
b)    Write a program using SUB.. END SUB to display the following series 1, 4, 9, 16 up to 10th terms. (3)
c)    Write a program using FUNCTION.. END FUNCTION to check a number whether it is prime or composite.  (3)
d)    Write a program to create a data file Stu.dat to store the Name, Roll, Address and Email of the students.    (3)
e)    Write a program to display all the records whose name starts with A from the data file created in question 2 (d).    (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- C
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

Q. 1. a. Create a database Emprec.mdb and construct a table Geninfo with the following fields: (2)

 Field Name Data type Ecode Number (PK) Ename Text Epost Text Dateofjoin Date/Time Salary Currency

b) Add any five records in the table.  (2)
c) Create a form including all the fields to perform data entry in future.  (2)
d)  Create a query to list all the records including the fields: Ecode, Ename and Salary having more than 10,000. (2)
e)  Create an update query to increase salary by 25% for the records having Epost as Assistant. (2)

Group B
QBASIC Programming (15 Marks)

2. a)   Write a program using FUNCTION..END FUNCTION to calculate and return area of circle. (3)
b)    Write a program to print square root of a number using SUB procedure (3)
c)    Write a program to print sum of natural numbers from 1 to 10 using SUB.. END SUB   (3)
d)    A sequential data file Record.dat contains several records having fields: NAME, ADDRESS, AGE and TELEPHONE NUMBER. Write a program to add more records to the file at the end of at the file. (3)
e)    Write a program to count the number of records having the AGE greater than 70 in the file RECORD.DAT created in question 2 d. (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- D

F.M: 25  P.M: 10  TIME: 1hr.
Group A
MS-Access (10 Marks)

Q. 1. a. Create a database named Student.mdb and a table Marks with the following structure: (2)

 Field Name Data type Symbol_no Number (PK) Fname Text DOB Date/Time English Number Nepali Number

b)  Add any five records in the above table.  (2)
c)  Create a query to display all the records with the fields: Symbol_no, FName and DOB.  (2)
d)  Prepare an update query to increase the marks of Nepali of all the students by 5%. (2)
e)  Prepare a report on the basis of the query created on the question number 1(c).      (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program using FUNCTION..END FUNCTION to get a number from the user and print the number in reverse order.  (3)
b) Write a program using SUB.. END SUB to display first thirteen odd numbers.  (3)
c) Write a program using SUB.. END SUB to print the sum of first nineteen even numbers. (3)
d) Write a program to create sequential data file to store Name, Age, Passport number and Nationality of users. (3)
e) Write a program to display the content of the sequential data file created in question 2 (d).  (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- E
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

Q. 1. a. Create a database named Salary.mdb and a table named Employee with the following structure: (2)

 Field Name Data type Serialno Number (PK) Name Text Basic Currency (Basic salary) PF Currency (10% of basic salary) Gross Currency

b.    Create a form excluding PF and Gross fields and add any five records using the form. (2)
c.     Create an update query to fill the data in PF and Gross fields. PF is 10 % of basic salary and Gross is the sum of Basic salary and PF.    (2)
d.    Create a query to display all the records with the following fields: Name, Basic and PF. (2)
e.    Prepare an update query to increase the Basic of the entire employees by 2000.  (2)
Or
Prepare a report containing Name, Basic, PF and Gross fields.  (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program using FUNCTION..END FUNCTION to get a word from the user and then print the word in reverse order. (3)
b) Write a program using SUB ..END SUB statement to display 2, 2, 4, 6, 10, .. up to 10th  terms.  (3)
c) Write a program using SUB.. END SUB to print the area of rectangle. (3)
d) Write a program to create a sequential data file to store Name, Age, Phone Number and Address of the users. (3)
e) Write a program to display the contents of the sequential data file created in question 2 (d). (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- F
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a table Student having following structure: (2)

 Field Name Data type Roll Number (PK) Name Text Address Text Gender Yes/no DOB Date/Time

b) Add five records in the table. (2)
c) Make a query ‘Disp’ to display all the records in ascending order by their names.(2)
d) Create a query to display all the records having the Roll no greater than 3. (2)
e)  Create a report including all the fields using wizard. (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program to calculate and print total surface area of a box using SUB..END SUB statement.Hint:A=(LB+BH+LH)]  (3)
b) Write a program to print the following series of numbers using SUB.. END SUB statement: 1, 2, 3, 5, … up to 13th terms.      (3)
c) Write a program to find out the cube root of an input number using FUNCTION.. END FUNCTION.  (3)
d) Write a program to store employees’ Name, Address, Telno, Age and Service Year in a sequential data file Emprec.dat.        (3)
e) Write a program to display all the records having age greater than 60 and Service Year greater than or equal to 20 from the data file created in question 2 (d).   (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- G
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a table Employee having following structure: (2)

 Field Name Data type Regnum Number (PK) Name Text Gender Text DOB Date/Time Salary Text

c) Make a query ‘Q1’ to show all the records whose gender is True (or Yes).  (2)
d) Make a query ‘Q2’ to increase salary (Update salary) by 2000.                   (2)
e)  Using a wizard prepare a report to show Name, Gender, and Salary fields data only. (2)

Group B
QBASIC Programming (15 Marks)

2.  a) Write a program to calculate perimeter of rectangle using FUNCTION..END FUNCTION.   (3)
b) Write a program to generate the following sequence using SUB.. END SUB 6, 66, 666, … up to 5th terms. (3)
c) Using SUB..END SUB, Write a program to count numbers of vowels in a given word.                  (3)
d) Write a program to store teachers Name, his/her teaching subject and mobile number in a sequential data file Teacher.dat.     (3)
e) Write a program to display all the records of Teacher.dat file created in question 2 (d).         (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- H
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a database named ‘Student.mdb’ and a table named “Marks” with the following structure: (2)

 Field Name Data type Rollno Number (PK) Fname Text Sname Text DOB Date/Time Computer Number Maths Number

b) Add any five records in the above table. (2)
c) Create a query to display all the records with fields: Roll No, Fname and DOB. (2)
d) Prepare an update query to increase the marks of Computer subject of all the students by 10%.  (2)
e)  Prepare a report containing Roll No, FName, Computer and Maths fields.  (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program that asks radius of a circle and displays area of a circle using SUB procedure.  (3)
b) Write a program to find out whether the input number is odd or even using SUB.. END SUB .   (3)
c) Write a program using FUNCTION.. END FUNCTION to reverse and display the string.         (3)
d) Create a sequential data file Marks.dat to store students Name and marks in English, Math and Computer subjects.  (3)
e) Write a program to display the records of file created in question 2 (d) whose marks in English is greater than 60.  (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- I
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a database named Hospital.mdb and a table named Patient of the following structure:   (2)

 Field Name Data type Patient_ID Number (PK) Name Text Address Text DOB Date/Time Married Yes/no

b) Define primary key to field named Patient_ID and add any five records in the table.  (2)
c) Create a query married to display records of married patients only.  (2)
d) Create a form and add two records in the above table.                       (2)
e)  Create a report using the query married created in 2(c).                  (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program to calculate the perimeter of a rectangle using SUB.. END SUB.    (3)
b) Write a program to find average of given three numbers using FUNCTION.procedure.  (3)
c) Write a program to print a multiplication table of any number using SUB.. END SUB.   (3)
d) Write a program to create a data file Sales.dat to store the Sales ID, Product, Price and quantity as long as user wishes.   (3)
e) Write a program to display only those records of data file created in question 2 (d) whose price is greater than 50.   (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- J
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a database named Student.mdb and a table named Book using the following structure: (2)

 Field Name Data type Book_ID Number (PK) Book_name Text Author Text Edition Text Price Currency

b) Add any five records in the above table.      (2)
c) Create a query Qlibrary to display all those records having Book_name Computer.   (2)
d) Create a query List to display all those books whose price is greater than 175. (2)
e)  Create a form to add two more records.   (2)

Group B
QBASIC Programming (15 Marks)

2. a) Write a program using SUB.. END SUB to get any tow values from the user and print their sum.     (3)
b) Write a program using FUNCTION.. END FUNCTION to get any three values from user and print the largest value.    (3)
c) Write a program using FUNCTION..END FUNCTION to find the sum of the digits of a number supplied by the user.   (3)
d) Write a program to create a data file Student.dat to store Name, Date of Birth and address of students.  (3)
e) Write a program to display the content of the data file created in question 2 (d) whose marks in English is greater than 60.  (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- K
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a table in MS-Access having following structure: (2)

 Field Name Data type Id Number (PK) Name Text Post Text Salary Currency Extra Memo

b) Add any five records. (2)
c) Make a query Q1 that displays all the records whose Post is officer.     (2)
d) Make a query Q2 that increases the salary of every employee by 3000 in the table.   (2)
e)  Prepare a report using the above table (use wizard to prepare a report). (2)

Group B
QBASIC Programming (15 Marks)

2.  a) Write a program to calculate product of two numbers using SUB..END SUB..  (3)
b) Using SUB..END SUB, write a program to find the distance travelled by a body. [Hint: S = ut+1/2 at2 ]  (3)
c) Using FUNCTION.. END FUNCTION, write a program to reverse a given word.(3)
d) Write a program to store students Name, address and age in a sequential data file std.txt.  (3)
e) Write a program to display all the records of std.txt sequential data file of 2 (d).     (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- L
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a database file Student.mdb with table named records with the following fields: (2)

 Field Name Data type Roll Number (PK) Fname Text Lname Text Gender Yes/no English Number Nepali Number Science Number

b) Enter any five records. (2)
c) Prepare a query  to increase the marks of Nepali by 10.  (2)
d) Create a query to calculate the sum of marks obtained in English, Nepali and Science.   (2)
e)  Prepare a report on the basis of query created on 1 (d).   (2)

Group B
QBASIC Programming (15 Marks)

2. a)   Write a program to print the perimeter of the circle using a function module. [Hint: Perimeter of Circle = 2πR]   (3)
b)  Write a program to generate the following series using a sub procedure: 1, 1, 2, 3, 5, 8, 13, 21, … up to 10th terms. (3)
c)   Write a program to print sum of 10 given numbers using a sub procedure. (3)
d)  Write a program to create a sequential data file STAFF.DAT to store Name, Gender, Age, and Salary of employees.  (3)
e)  Write a program to display all the records whose salary is greater than 5000 of STAFF.DAT file created in question number 2 (d). (3)

S.E.E PRACTICAL MODEL QUESTIONS OF COMPUTER SCIENCE

Set- M
F.M: 25  P.M: 10  TIME: 1hr.

Group A
MS-Access (10 Marks)

1. a. Create a database with the following structure and save it under suitable name: (2)

 Field Name Data type Roll Number (PK) Name Text DOB Data/Time English Number Nepali Number Science Number

b)  Add any five records in the table.  (2)
c)  Create a query to display name, English and Nepali fields.(2)
d)  Create an update query to increase the marks of Nepali subject by 5% to every student.  (2)
e)  Prepare a report consisting of Roll, Name, DOB and Nepali fields. (2)

Group B
QBASIC Programming (15 Marks)

2. a)  Write a program using function module to get the name of a user and print it in reverse order. (3)
b)  Write a program using SUB..END SUB to calculate average of two numbers.   (3)
c)  Write a program to get a number from a user and then print the sum of the digits of the number using function module.     (3)
d)  Write a program to create a sequential data file to store Name, age and address of users.  (3)
e)  Write a program to count the total number of people whose age is above 18 stored in the data file created in question number 2 (d).  (3)