VIDYASAGAR UNIVERSITY

DEPARTMENT OF BACHELOR OF COMPUTER

APPLICATION

PC SOFTWARE LAB
CODE : BCAMI01

REGISTRATION NO - VU231211344

ROLL :

no :

FIRST SEMESTER

SESSION : 2023 - 2024

 Rahul Ghorai
Software Devloper

Education
Turka High School (H:S)
27-4-2010 to 27-2-2022
i am from Turka high school (H:S) , 66% marks
CONTACT on madhyamik exam and 76% marks obtain on
higher secondary exam.

+91 9547697185 Kharagpur College

17-8-2022 to 27-3027
rahulghorai9547@gmail.com
Now i am 1st year student and am i try to give
rahulghoraiportfolio.com my best.

Working Experience
LANGUAGES
Proficient Vision Solutions pvt. Ltd.
 Bengali Testing engineers
 Hindi i was a mid level software testing engieers in this
 English company during 3 months.
 Odia
Beyondetch Private Limited
Image processing
HOBBIS i was work by private last two year and one
month i am achieve a award best employee of
 Writing the month .
 Reading
 Communicating to others
 Traveling Skills
 Outdoor game
typing 70%

Others Skill 83%

1. There are five Employes in a organization whos name,Designation,Day of joining(D.O.J) and basic pay are as follows.

EMP. NAME DESG D.O.J BASIC PAY

J.Nandi Managar 10/15/2002 25000

A.Pal Accountent 5/22/2005 16000

K.Das Cashier 06-08-2008 12000

S.Das Staff 09-07-2000 7500
A.Biswas Pion 01-03-2010 6500

Others information are :-

A. DA : 60% Of Basic
B. HRA : 15% Of Basic + DA for all Employs
C. MA: 10% Of Basic for all Employs
D. P TAX : 200 Per month all types of employes

*Prepare a salary sheet for the current month in 'MS EXCEL' and Show the net pay of all employes in a pi diagram

Salary sheet for the current month 29-2-2024

EMP. NAME DESG D.O.J BASIC PAY DA HRA MA Gross pay P. TAX NET PAY
J.Nandi Managar 10/15/2002 25000 15000 6000 2500 48500 200 48300
A.Pal Accountent 5/22/2005 16000 9600 3840 1600 31040 200 30840
K.Das Cashier 06-08-2008 12000 7200 2880 1200 23280 200 23080
S.Das Staff 09-07-2000 7500 4500 1800 750 14550 200 14350
A.Biswas Pion 01-03-2010 6500 3900 1560 650 12610 200 12410

*Pi Diagram

NET PAY
12410

14350
48300

23080

30840

1 2 3 4 5
 Sales and Profit Report-First Quarter 2024

No City Jan Feb Mar Average Maximum

C001 Delhi ₹ 22,000.00 ₹ 15,000.00 ₹ 29,000.00 ? ?
C002 Kolkata ₹ 42,000.00 ₹ 20,000.00 ₹ 34,000.00 ? ?
? Mumbai ₹ 12,000.00 ₹ 31,000.00 ₹ 45,000.00 ? ?
? Patna ₹ 18,000.00 ₹ 43,000.00 ₹ 26,000.00 ? ?
? Ranchi ₹ 35,000.00 ₹ 13,000.00 ₹ 23,000.00 ? ?

Total Sales ? ? ?
Cost ₹ 83,000.00 ₹ 89,000.00 ₹ 47,000.00
Profit ? ? ?
Bonus ? ? ?

Total Sales Gretar than 30000 ? ? ?

Total Sales Gretar than 30000 ? ? ?

a. Create the worksheet shown above.

b. Set the Text alignment, Columns width and height appropriately.
c. Use Autofill to put the series Numers into cells A5:A7.
d. Formet cells Fill C3:g7, c8:e11,c13:e13 to include sign with two decimal places
e. Find the Average sales and Maximum Sales of each city.
f. Find the total Sales for each month
g. Calculate the profit for each month, where profit= Total-Cost.
h. Calculate the 10% Bonus, which is 10% of the profit
i. Find the total sales for each month; only for sales greater than 30000.
j. Find the No of sales for each moth; only for greater than 30000
k. Create the following charts.

Maximum SALES AND PROFIT REPORT

₹ 60,000.00
Delhi ₹ 40,000.00
₹ 20,000.00
18% 15% Kolkata ₹ 0.00
22% Mumbai
22%
Patna
23%
Ranchi Jan Feb Mar

Sales and Profit Report-First Quarter 2024

No City Jan Feb Mar Average Maximum

C001 Delhi ₹ 22,000.00 ₹ 15,000.00 ₹ 29,000.00 ₹ 22,000.00 ₹ 29,000.00
C002 Kolkata ₹ 42,000.00 ₹ 20,000.00 ₹ 34,000.00 ₹ 32,000.00 ₹ 42,000.00
C003 Mumbai ₹ 12,000.00 ₹ 31,000.00 ₹ 45,000.00 ₹ 29,333.33 ₹ 45,000.00
C004 Patna ₹ 18,000.00 ₹ 43,000.00 ₹ 26,000.00 ₹ 29,000.00 ₹ 43,000.00
C005 Ranchi ₹ 35,000.00 ₹ 13,000.00 ₹ 23,000.00 ₹ 23,666.67 ₹ 35,000.00

Total Sales ₹ 1,29,000.00 ₹ 1,22,000.00 ₹ 1,57,000.00

Cost ₹ 83,000.00 ₹ 89,000.00 ₹ 47,000.00
Profit ₹ 46,000.00 ₹ 33,000.00 ₹ 1,10,000.00
Bonus ₹ 4,600.00 ₹ 3,300.00 ₹ 11,000.00

Total Sales Gretar than 30000 ₹ 77,000.00 ₹ 74,000.00 ₹ 79,000.00

Total Sales Gretar than 30000 2 2 2

Maximum SALES AND PROFIT REPORT

₹ 60,000.00
Delhi ₹ 40,000.00
₹ 20,000.00
18% 15% Kolkata ₹ 0.00
22% Mumbai
22%
Patna
23%
Ranchi Jan Feb Mar
1. Suppose you want to able a house building loan in the month of january 2020 amount rs. 2,00,000.The rate of interest 9% per annum and repayment term is 20 years
under monthly installment basis payable at the end of is month. The first payments to be made at the end of february 2020. find the amount of monthly installment
first 6 months, analysis the principal and interest element of the above monthly installment using - MS EXCEL .

Loan Amount ₹ 2,00,000

Interest 9%
Year 20

HOUSE BUILDING LOAN CALCULATION

Sl_No MONTH INSTALLMENTPRINCIPAL INTEREST TOTAL
1 January ₹ 1,799.45 ₹ 299.45 ₹ 1,500.00 ₹ 1,799.45
2 February ₹ 1,799.45 ₹ 301.70 ₹ 1,497.75 ₹ 1,799.45
3 March ₹ 1,799.45 ₹ 303.96 ₹ 1,495.49 ₹ 1,799.45
4 April ₹ 1,799.45 ₹ 306.24 ₹ 1,493.21 ₹ 1,799.45
5 May ₹ 1,799.45 ₹ 308.54 ₹ 1,490.91 ₹ 1,799.45
6 June ₹ 1,799.45 ₹ 310.85 ₹ 1,488.60 ₹ 1,799.45
1. Create a database named “School.mdb” and Perform the following tasks :

A. Create a table named “student info” having following table structure

Field Name Data Type Description

Class Number
Section Text
Roll No Number
Name Text 40 Characters Long
Status Lookup wizard Two value : “senior”,”junior”
Photo OLE Object Photo of students
DOB Date/time Date of Birth of students
Remarks Memo

B. Fill at least 5 records.

class section Roll_No Name Status photo DOB Remarks

10 A 1 Rahul Ghorai senior 27-04-2005 VERY GOOD
STUDENT
10 A 2 Subham Ghorai Junior 28-05-2004 EXCELLENT
10 B 4 Adwaitya Das senior 29-09-2003 GOOD
10 A 5 Pratima Das Junior 20-03-2006 OUTSTANDING
10 B 8 Soma Das senior 20-04-2004 VERY EXCELLENT

C. Prepare a query to display records and Name should be ascending order .

class section Roll_No Name Status photo DOB Remarks

10 B 4 Adwaitya Das senior 29-09-2003 GOOD

10 A 5 Pratima Das Junior 20-03-2006 OUTSTANDING
10 A 1 Rahul Ghorai senior 27-04-2005 VERY GOOD STUDENT
10 B 8 Soma Das senior 20-04-2004 VERY EXCELLENT

10 A 2 Subham Ghorai Junior 28-05-2004 EXCELLENT

D. Prepare a query named “senior” to display records including fields name,class,

section,roll no,status ,photo and value of “status” field must be senior.

class section Roll_No Name Status photo DOB Remarks

10 A 1 Rahul Ghorai senior 27-04-2005 VERY
GOOD
STUDENT
10 B 4 Adwaitya Das senior 29-09-2003 GOOD
10 B 8 Soma Das senior 20-04-2004 VERY
EXCELLENT
E. Prepare a form of above query “senior”.

F. Prepare a Report of all the fields of above table.

2. Create a database named “Library.mdb” and Perform the following tasks :

A. Create table named “Book “ having following structure.

Field Name Field Data Type Description

Book_id Text Primary key.Book
identification number
B_name Text Book name
W_name Text Writer’s name
Pyear Date/time Published year
Pname Text Publisher name
Price Currency Purchased price
P_date Date/time Purchased date
Remark Memo comments

C. Add at least 5 records.

book_id b_name w_name p_year p_name price p_date Remark

1 c language Ajjay Mittal 02-03-1970 kolkata annanda ₹ 550.00 02-03-2020 nice
2 AEC Irfan Ali 03-04-2003 orisa publisher ₹ 201.00 02-05-2020 outstanding
3 ENVS Sk Sarju Alam 05-06-2001 madrasha ₹ 580.00 04-05-2020 very good
publisher
4 basic prabhat Ganguly 02-04-2003 nabanita ₹ 400.00 03-05-2021 excellent
account publisher
5 web design nabarul khan 03-04-2022 pankaj publisher ₹ 630.00 03-04-2023 no one book
in the libray

B. Prepare a query to display only records including book name,writers name

and publication name. save the query named “q_book”.

b_name w_name p_name

c language Ajjay Mittal kolkata
annanda
AEC Irfan Ali orisa publisher
ENVS Sk Sarju Alam madrasha
publisher
basic account prabhat nabanita
Ganguly publisher
web design nabarul khan pankaj
publisher
 E. Prepare a query to display all records based on price which is more than Rs.500 .

book_id b_name w_name p_year p_name price p_date Remark

1 c language Ajjay Mittal 02-03-1970 kolkata ₹ 550.00 02-03-2020 nice
annanda
3 ENVS Sk Sarju 05-06-2001 madrasha ₹ 580.00 04-05-2020 very good
Alam publisher
5 web design nabarul 03-04-2022 pankaj ₹ 630.00 03-04-2023 no one book
khan publisher in the libray

D. Prepare a form based on table.

F. Prepare a Report on the basis of “q_book”.

3. Create a database named “Nepal .mdb” to store information about its staffs and
do the following tasks :

A. Create a table named “staffinfo” having following table structure .

Field Name Field Data Type Description

Sid Autonumber Primary key.Staff identification
number
Department Text Department like teller dept,
Administrative dept, marketing
dept
Sname Text Staff name
Address Text Address of staff
SPhone Text Staff phone
Post Text Like Junior teller,casher
,accountant ,manager etc.
Doj Date/time Date of joined
Sdob Date/time Date of joined

B. Create a form on basis of “staffinfo” table and save as “entryform” .

C. Fill the Five records using the “entryform” .

S_ID Department S_name Address S_phone post doj s_dob

3 teller Rahul Ghorai shyam sundar 95954769718 casher 23-04-2000 02-03-2009
pur,turka 5
kashba
4 store dept Subham Ramchanra 8167485647 senior 02-04-2002 02-04-2010
Ghorai Pur
5 loan dept Pratima Das panicha 67457647 Manager 03-04-2004 02-03-2020
6 marketing Nabanita Das ramchandra 2345678976 teller 02-05-2020 02-03-202
dept pur,turkav
7 store dept Chandrasekh Shyam 9547697185 Accountent 25-02-2024 27-04-2005
ar Ajad sundar
pur,turka
kashba,danta
n
8 loan dept Shehasish Medinipur 646846484 teller 25-02-2024 21-03-2003
Pandab

D. Create a query named “depinfo” to display records only including departmet

Name, staff name.

Department S_name
teller Rahul Ghorai
store dept Subham
Ghorai
loan dept Pratima Das
marketing Nabanita Das
dept
store dept Chandrasekhar
Ajad
loan dept Shehasish
Pandab

E. Create a query named “post” to display staff name, post, department and phone
number whose post “teller” or “casher”.

S_name post Department

Rahul Ghorai casher teller
Shehasish teller loan dept
Pandab
F. Prepare a report based on query named “depinfo”.