I/BCA/103P Student's Copy
Professional Course Examination, November 2018
1st Semester
BACHELOR OF COMPUTER APPLICATIONS
Course BCA-103P
PC Application and Internet Technology
Practical
Revised
Full Marks 75
Time 3 hours
The figures in the margin indicate full marks for the questions
SECTION—A
Answer any two questions
1. Using MS-DOS in any hard drive partition other than drive, perform
the following
Create directory called "MZU". 1
Create subdirectory "BA", "BSc", "BCA", "BCom". 1
Create one file (Arts.txt) in BA directory. 1
Copy Arts.txt into BCA directory and rename that file with
"Computer.txt". 1
Create file (Science.txt) in BSc directory. 1
Move "Science.txt" into BCom directory. 1
/364 1 Contd.
Create a batch file exam.bat and—
list the content of a current drive;
display the current date;
display the volume of the current drive. 4
2. Create your college timetable in MS-Word for 6 subjects for 5 days with
1 hour duration and also include lunch interval 30 minutes. Apply font
styling, colors and border. 10
3. Design at least 10 slides presentation for "About Our College" in Microsoft
PowerPoint. Use transition effect and custom animations wherever
necessary. 10
SECTION—B
Answer any two questions
4. By using mail merge, prepare the following certificate and print individual
personalized to 10 students. The fields to be merging should include
Name, Father's Name, DOB, Roll No, Regn No and Division 15
I/BCA/103P 2 Contd.
This is to certify that
son/daughter of Shri/Smt <<Father's Name>>
born on
duly passed the Bachelor of Computer
Application held in the year 2018
under Roll No. <<Roll
Registration No. <<Regn
and was placed in <<Division>>
CERTIFICATE
5. Write the HTML code for the following table with some text in each cell 15
6. Prepare the Result Sheet in MS-Excel for the following
MARKSHEET
Roll
No.
Name of
Student
BCA
101
BCA
102
BCA
103
BCA
104
BCA
105
BCA
103(P)
BCA
105(P)
Total Grade Rank
1 Liana 67 83 79 80 89 78 85
2 Kima 52 46 54 46 85 48 71
3 John-a 32 78 56 52 46 56 46
4 Biaka 56 84 56 45 84 42 52
5 Siama 75 60 57 74 75 64 82
6 Muani 45 12 13 16 72 19 18
7 Sangi 56 33 86 78 23 45 75
8 Chhantea 45 36 56 59 25 48 74
9 Thari 75 85 92 80 75 71 76
10 Vala 15 39 66 23 65 47 72
Calculate the following problems by using FORMULA
Total Marks obtained by each student 1
Percentage (Full Marks for each paper is 100 marks, i.e., Total Full
Marks is 700 marks) 2
I/BCA/103P 3 Contd.
Grade should be calculated based on the following criteria 2
Percentage Grade
Less than 40% F
and D
and C
and B
A
Sort the Result in order of Merit and give Rank. 2
Count the number of students—
who pass in Distinction;
who pass in First Division;
who are fail. 6
Display MIN and MAX marks in order to Total. 2
SECTION—C
7. Viva voce. 15
8. Record book. 10