MBOSE Class 11 Question Paper 2022 for Computer Technique (Practical)

(8) Total No. of Printed Pages – 8

(iv) Use the relevant formula to calculate the total HS/XI/V/CT/Pr/Paper-I/22
marks of ‘Rupa’ (Index No.-1001) and copy the
formula to the relevant cells. 4 2022
(v) Use the relevant formula to calculate the average COMPUTER FUNDAMENTALS,
marks of ‘Rupa’ (Index No.- 1001) and copy the OPERATING SYSTEMS AND UTILITIES
formula to the relevant cells. 4
COMPUTER TECHNIQUE ( Paper – I )
(vi) Format the “Average” column with two decimal
places. 2 ( VOCATIONAL STREAM )
(vii) Use the relevant formula to find the rank of ( Practical )
‘Rupa’ (Index No.-1001) and copy the formula to
the relevant cells. 5 Full Marks : 100
Time : 4 hours
5. Viva-voce. 15
The figures in the margin indicate full marks for the questions

SECTION – I
 ( Marks : 25 )

MS PowerPoint

1. Make four slides containing the following text
respectively and save the presentation as holidays.

(i) The first slide is a Title Only Slide. Select the
appropriate layout and enter the title: Cook
Family Cruises. 2
(ii) Add a small blue rectangle at the top left of this
slide. 2
(iii) Change the font colour for the whole title to red,
and apply a text shadow effect just to the word
Cruises. 2

HS/XI/V/CT/Pr/Paper-I/22 HS/XI/V/CT/Pr/Paper-I/22

(6) (3)

b. Create a main document with the following SECTION – II
content. Save the document as results.doc: 15 ( Marks : 35 )
To MS WORD
<Title> <Firstname> <Lastname>
<City> (Answer ANY ONE, either Q. No. 2 or Q. No. 3)

2. Open a new MS Word file and type the following text
Dear<Title> <Lastname>,
given in the box below. Save the document as <Your
Index Number>_W01. 5
We are glad to announce to you the results of
the “Presentation Contest” held on the 5th Academy award
February, 2022. Congratulations! You have won
the <Prize>prize. The Academy Awards, informally known as The
Oscars ®, are a set of awards given annually for
The award given to you will be a certificate and a excellence of cinematic achievements. The Oscar
cash prize of <Amount>. statuette is officially named the Academy Award of
Merit and is one of nine types of Academy Awards.
You are invited to especially attend the Awards The Academy Awards ceremony is also the oldest award
ceremony in the media; its equivalents, the Grammy
Presentation Night which will be on the 6th
Awards (for music), Emmy Awards (for television), and
March, 2022. Details of timing and venue will be
Tony Awards (for theatre) are modeled after the
made known to you in a later communication. Academy.

Regards Current special categories

Academy Honorary Award: since 1929
Organizing Committee
Academy Scientific and Technical Award: since 1931

Gordon E. Sawyer Award: since 1981
c. Create a form letter with the given Main
Document format and the data source where the i. Change the layout of the page as given below. 2
details must be merged from the data source file >Page size:A4 (8.27"11 .69" ) >Page orientation:
data1.doc. Save the merged file as merged1.doc. 10 Landscape

HS/XI/V/CT/Pr/Paper-I/22 HS/XI/V/CT/Pr/Paper-I/22

(4) (5)

ii. Change the page margins as follows: 2 vii. At the end of the bulleted list create the table
shown below: 8
> T o p : 1.25" > B o t t o m : 1.25" > R i g h t : 1.25"
>Left:1.25" Ceremony Date Best Picture Winner Venue
1st Academy Award 16th May 1929 Wings Hollywood Roosevelt
2nd Academy Award 3rd April 1930 The Broadway Melody Ambassador Hotel
iii. Format the entire document as given below. 2
>Line spacing:1.15" >Font: Times New Roman viii. Enter “Award Ceremonies” text as the heading
of the table and format it to get the following
>Font size: 14 >Align: Justify output using a Wordart. (Font: Arial Black, Front
size: 16, Align: Center). 5

iv. Select the heading “Academy award” and format
ix. Insert a new row just below the last row of the
it as given below. 2+1=3 table and enter the following information into
>Font color: blue >Style: Bold and underline the new row: 4
>Align: Center >ceremony: 84th Academy Award
>Change all the letters to UPPERCASE >date: 24th February 2012
>best picture winner: The Artist
>venue: Dolby Theatre
v. Format the heading “Current special categories”
with Style: Heading 2. 1
3. a. Create the following data source as given and
save it as data1.doc. 10
vi. Create a bulleted list for the last 3 lines of text Title First Name Last Name City Prize Amount
given under “Current special categories” and Dr. Anand Bakshi Lucknow Third 50,000.00
format it as follows. 3
Prof. Parkash Mishra Cuttack First 1,00,000.00
 Academy Honorary Award: since 1929 Mr. Ashok Gehlot Delhi Fourth 25,000.00
 Academy Scientific and Technical Award: Dr. John Lyngdoh Shillong Second 75,000.00
since 1931 Dr. Anita Bareh Jowai Fifth 10,000.00
 Gordon E. Sawyer Award: since 1981

HS/XI/V/CT/Pr/Paper-I/22 HS/XI/V/CT/Pr/Paper-I/22

(2) (7)

(iv) Insert a second slide to the presentation, selecting SECTION – III
a layout appropriate for a series of bullet points,
and using the title: Our Itinerary. Enter the ( Marks : 25 )
following text: 4 MS Excel
(a) Canary Islands 4. a. Create a blank workbook in MS Excel and save it
as “<Your Roll no>_E01”. Then perform the
(b) Mediterranean
following exercises as mentioned below:
(c) Greek Islands A B C D E F G H I
1 Mark College
(v) Change the line spacing for these bullet points 2 Mark sheet for A/L Biology - Class A
to 2 lines. 1 3 Index No. Name Physics Chemistrv Biology English Total Average Rank
4 1001 Rupa 65 78 56 45
(vi) Increase the font size of the word Itinerary in
5 1002 Ajay 53 85 88 78
the title. 1
6 1003 Robert 45 96 ab 98

(vii) Add a footer with your Roll No and the text: Cruise 7 1004 James 78 76 76 65
Information so they both appear on every slide, 8 1005 Sanjay 23 ab 74 36
and number all the slides. 2 9 1006 Anita 78 32 64 52

(viii) Insert a third slide, which is to be a graph. Use (i) Create a table with 7 rows and 9 columns in the
the title Our Market Share. Use the following cell range A3:19, as shown in Figure above. You
data to produce a pie chart: Cook 54%; Jackson have to bold and center the heading of each
28%; Wilson12%; Bennett5%. 8 column. 3
(ii) Insert a title “Anne College” and a sub title “Mark
(ix) On the third slide, insert an image suitable for
sheet for A/L Biology - Class A”, by centering it
the topic of holidays from an image library. with the table, making the text bold, and
Reduce the size of the image and place it where changing the font size 16 for main title and 14
it will not interfere with text. 2 for subtitle. 3

(x) Add a 4th slide containing nothing but the text: (iii) Enter the data given under the columns, “Index
Travel with us for less!! 1 No”, “Name”, “Physics”, “Chemistry”, “Biology”,
and “English”. 4

HS/XI/V/CT/Pr/Paper-I/22 HS/XI/V/CT/Pr/Paper-I/22

Total No. of Printed Pages ––3

HS/XI/V/CT/Pr/Paper-II/22

2022

COMPUTER PROGRAMMING IN C
COMPUTER TECHNIQUE ( Paper – II )
( Vocational Stream )
( Practical Examination )

Full Marks : 100
Time : 4 hours

Answer ONE question from each Group

Group – A

1. A file named DATA contains a series of
integer numbers. Code a program to read
these numbers and then write all ‘odd’
numbers to a file to be called ODD and all
‘even’ numbers to a file to be called EVEN.
40

2. Write a program that would sort a list of
names in alphabetical order. Illustrate
example or sample data to show the output.
40

HS/XI/V/CT/Pr/Paper-II/22 (Turn Over)

(2) (3)

Group–B
4. The minimum criteria for admission to a
3. A certain Grade of steel is graded certain college are as follows: 40
according to the following conditions: 40
(a) Marks in Mathematics >= 65
(i) Hardness must be greater than 50
(b) Marks in Physics >= 65
(ii) Carbon content must be less than 0.7 (c) Marks in Chemistry >= 50

(iii) Tensile strength must be greater than (d) Total of all the three subjects >= 200
5600. Or
Total in Mathematics and Physics>= 150
The Grades is 10 if all the three
conditions are met Write a program to input the name of a
Grade is 9 if conditions (i) and (ii) are candidate of marks obtained in all the
met three subjects and determine whether he
or she is eligible for admission or not.
Grade is 8 if conditions (ii) and (iii)
are met 5. Internal Assessments. 10
Grade is 7 if conditions (i) and (iii) are
met 6. Viva-Voce. 10

Grade is 6 if only one condition is met

Grade is 5 if none of the conditions
are met
Write a program, which will require the
user to give value of hardness, Carbon
content and tensile strength of the steel
under consideration and output the grade
of the steel.

HS/XI/V/CT/Pr/Paper-II/22 (Continued) HS/XI/V/CT/Pr/Paper-II/22

(4) Total No. of Printed Pages ––4
HS/XI/V/CT/Pr/Paper-III/22
Tabe–1

Field Name Type (Size) Remarks 2022
CUST_ID Character(50) Customer Identity, Primary Key
DATABASE MANAGEMENT SYSTEM (Using Foxpro)
CUST_NAME Character(40) Customer Name
COMPUTER TECHNIQUE ( Paper – III )
CUST_ADD Character(60) Address of Customer
( Vocational Stream )
MOB_NO Integer(10) Mobile Number for Communication
E_MAIL Character(25) e-mail identity of customer Full Marks : 100
Time : 4 hours
4. Viva-voce 10
( Practical Examination )
5. Practical Copy evaluation 10
SECTION – I
Marks : 50


ANSWER ALL THE QUESTIONS
1. Create a database file STUDENT.DBF which have
following Field Structure: 15

Field Name Type Width
NAME CHARACTER 25
ENGLISH NUMERIC 3
ELECTIVE-I NUMERIC 3
ELECTIVE-2 NUMERIC 3
ELECTIVE-3 NUMERIC 3

HS/XI/V/CT/Pr/Paper-III/22 HS/XI/V/CT/Pr/Paper-III/22

(2) (3)

Add the following records into the Database file:- Following validation must be done to input data’s:
Record English Computer
5  5  25
Name Maths
No. App. (a) All addresses must be stored in Upper case Letter.
1 Ajay 17 86 90
(b) The Roll Number must be in the following form:
2 Zubian 78 92 98
(i) The first digit is character followed by zeroes
3 Rohan 69 93 95
and numbers, e.g. R0001, R0002,.....etc.
4 Sumit 77 91 96 (ii) If the Roll Number entered by the user are
not in the above (i) following form, then
5 Vijay 71 77 98
necessary Error Messages should be
6 John 74 94 80 displayed on the bottom of the screen.

7 Raman 94 88 75 (c) Town should be in Upper case, lower case or
special symbol can be entered.
Perform the following queries on the database file
mentioned above- (d) The Pin Code should be in six digit length,
additional digit cannot be entered.
(a) Display all the English Marks whose Marks are
more than 90. (e) The Birth date should be in dd-mm-yyyy format.
(b) Display the list of Name which starts with The students to be entered are not less than 5
alphabet ‘R’. years of age and not more than 18 years old.

[Write the required commands of Foxpro..] 5 + 5 = 10
SECTION – II

2. The GARDEN SCHOOL wants to prepare a student ( Marks : 50 )
Information file. The following data are to be recorded
for each student: 3. Consider the following CUSTOMER.DBF database file
and write a user-friendly program to ADD and DELETE
Name, Class, Roll No., Date of Birth, Address record from the Database. Display a MENU followed
(Includes–Place, Town, State Pin code, Phone No.) by appropriate error messages. 30

HS/XI/V/CT/Pr/Paper-III/22 HS/XI/V/CT/Pr/Paper-III/22