MAHENDRA MUNI

SARASWATI SISHU VIDYA MANDIR

Senior Secondary (+2) School

Project File
Submitted by
Name :-
Roll No : -
Class : - Xth -
Subject :- Computer (Practical)
Subject Code: 402
Submitted to

Sir Gautam Kumar

Department of Computer
MMSSVM
 Acknowledgement

I thank my Computer Science teacher Sir Gautam Kumar

for guidance and support. I also thank my Principal Mr.
Madan Mohan Mishra. I would also like to thank my parents
and my friends for helping me during the course of this
project.
Finally, I would like to thank CBSE for giving me this
opportunity to undertake this project.

2
 Certificate
This is to certify that ____________ of class Tenth
(Xth)- Roll no:-___, Mahendra Muni Saraswati
Shishu Vidya Mandir, Madhupur (Deoghar) has
successfully completed her project in computer
practicals as prescribed by CBSE in the year 2025-26.

Date : / / 2025

Signature of Examiner

________________

3
 Index

Acknowledgement 2
Certificate 3

MS Word (Page: 6-11)

1. Create bill............................................................. 6-7
2. Generations of computers...................................... 8
3. Application for 3-day leave.................................... 9
4. Create tables with tabs........................................... 10-11

MS Excel (Page: 12-20)

5. The Sales Report ................................................. 13-14
6. Pie Chart.............................................................. 15
7. Bar Chart............................................................. 16-17
8. Employee Spreadsheet..........................................18-19
9. Sri Lanka Cricket Players .................................... 20

MS Access (Page: 21-21)

10. Database of employee.........................................21

4
MS-Word

5
1.) Create a word Processor file that prints a bill of items as bought
in a gift shop named “GIFT CORNER”.
The Bill should have :
 Welcome image should be on the Top.
 A watermark
 Font should be decorative
 Customer name
 Mode of Payment
 Date of Purchased
 Items Purchased with Price and Discount

Name of Item Price of Item Discount Final Price

Diamond 27000 10 % 26730
Pendant
Gold Earrings 18000 7% 16740
Case 500 - 500
Total 43970

6
7
2.) Using the Smart Art of MS –word create a chart on the generations
of Computer.

8
 3.) You are Abhinav/Anu of class X. Using the Word
Processing Software write an application to the school
principal for three days leave.(Using paragraph
spacing as 1.5 and all use all required alignment )

The Principal,
Mahendra Muni Saraswati
Shishu Vidya Mandir
Madhupur (Deoghar)

Subject: Application for three days leave

Sir/ Ma’am
This is to inform you that I, _____________, of class X would not
be able to attend the school for three days with effect from
20/01/2021 to 22/01/2021 in order to attend a family function.

Kindly grant me three days leave for the same.

Thanking you
Yours faithfully
____________

9
4. Create a word document and enter some information related
to your friends, separated the information with tabs. Now
convert the text to the table format. Make the table look
beautiful.

10
[Link]. Name Phone No. Email Id
1. Sourav 9902762523 sourav990@[Link]

2. Rahul 9806423789 rahul980@[Link]

3. Amit 7890542579 amit789@[Link]

4. Prem 9872906427 prem980@[Link]

5. Rohit 7568953673 rohit756@[Link]

11
MS-Excel

12
 The Sales Report
5. Write the data given below using the Spreadsheet
Software. Name the sheet1 tab as Data
a) Title Column should be left align, year, Genre sales unit
rental unit should be center align.
b) The row height should be 18.5
c) Sort the whole data in the ascending order of unit sales.
d) Create the bar chart for the following data.
e) Using the conditional formatting color as follows :
f) Red color for those records that was launched before 2010.
g) Green color for those records that was launched after 2010.
h) Yellow for 2010.

Title Year Genre 2016 Unit 2016 Unit

Sales Rentals
The Artist 2011 Drama 5 20
Argo 2012 Drama 15 150
Mutiny on the Bounty 1935 Drama 3 2
Oliver! 1968 Musical 20 200
In the Heat of the Night 1967 Drama 4 10
The Sting 1973 Comedy 8 15
The Godfather 1972 Drama 15 40

13
 Chart Title

100%

80%

60%

40%

20%

0%
Drama Drama Drama Comedy Drama Drama Musical
1935 1967 2011 1973 2012 1972 1968
Mutiny on In the heat of The Artist The Sting Argo The Oliver!
the Bounty the Night Godfather

2016 Unit Sales 2016 Unit Rentals

Chart: 01 Bar Chart of given Data

14
6. Here is the data of a survey regarding favorite food
conducted among 45 students of a class. Draw a pie chart for
this data.
Food Item Number of students
Pizza 15
Dosa 6
Noodles 9
Burger 10
Soup 5

NUMBER OF STUDENT

Soup
11%
Pizza
34%
Burger
22%

Dosa
Noodles 13%
20%

15
7. The table given below shows the number of visitors to
different stalls at a funfair event.
A. Calculate the total number of visitors per day.
B. Compute the total number of visitors and their avg across
four days for each stalls.
C. Draw a Bar graph for the data.

STALLS DAY 1 DAY 2 DAY 3 DAY 4

SHOOTING A BALLOON 20 25 30 35
THROWING A RING 30 40 50 45
MAGIC SHOW 25 30 30 35
JUGGLING 30 35 40 60
DOG SHOW 10 15 20 25
FACE PAINITNG 20 25 30 20

16
 Chart Title
250

200

150

100

50

0
SHOOTING A THROWING A MAGIC SHOW JUGGLING DOG SHOW FACE PAINITNG Total
BALLOON RING

Day 1 Day 2 Day 3 Day 4 Total Average

17
8. Tariq Fashions maintains their employee salary details in a
spreadsheet as shown below. Fill the blanks using the Excel
formulae.
1) To Calculate the DA as 25% of BASIC +HRA for each employee
and display in column D.
2) To calculate the NETSALARY as BASIC +HRA +DA –PF for
each employee and display in column E.
3) To find the Maximum Net Salary and Display in Cell F9.
4) To count the number of employees and display in cell B10.
5) The manager inserts a column for [Link] in the above
spreadsheet. Which feature will help him to do the same?
6) If the Basic Salary of an employee changes, will the manager
have to redo all the Calculations for the particular employee?
Explain.

18
19
9. Given below a screenshot for Sri Lanka’s Cricket Player’s. You
have to create the same spreadsheet and calculate the total score
and Strike rate for the all players.(Mention all the required formulae)

 Formula for total score is by adding all score

 For strike rate is total score/ balls faced *100
 Using freeze pane option ,Freeze the first two crickets’ record.(row 4
and 5)

20
10. Create a PowerPoint Presentation on any one of the following topic:
 Cyber Security
 National Integration
 Introduce any new software

21
11. Create a table in a database to design and enter the details
of employees of an organization.

22