ST.

ANDREWS INSTITUTE
OF TECHNOLOGY & MANAGEMENT

Gurgaon Delhi (NCR).

Approved by AICTE, Govt. of India, New Delhi
Affiliated to Maharshi Dayanand University
‘A’ Grade State University, accredited by NAAC
Session: 2022-2023

Bachelor of Business Administration

A Practical File
Computer Fundamentals
Subject Code: BBAN-104

Submitted To: Submitted by:

Ms. Harsh a Harsh Raj
(Assistant Professor) BBA 1st Semester
Roll No.: 208102
[Link] INSTITUTE OF TECHNOLOGY &
MANAGEMENT

List of Practical

S.
Name Sign
No.

Procedure to create a resume using MS-Office Word.

01

02 Procedure to create a Cover Page of a Project Report.

03 Procedure to create a Mail Merge Letter.

Procedure to create a Macro for inserting a picture and Formatting the
04 text.

Procedure to create a worksheet with 4 columns. Enter 10 records and

05
find the sum of all columns in MS Office Excel.

Procedure to create a Report containing the pay details of the Employee

06 using MS-Office Excel.

Procedure to create a Student result sheet using MS-Office Excel.

07

Procedure to create a Simple Bar chart to highlight the sales of a

08 company.

09 Procedure to create a Pie Chart for a sample data and give legends.

10 Procedure to create a simple presentation using PowerPoint.

 Practical-1
Procedure to create a Resume using MS-Word.
Procedure:
1. Click on start button – MS-Word – File – New – Blank Document.
2. Go to the insert – Shapes – Line - Change colour of shapes, click on the shapes – format –
shape styles - Theme styles.
3. Write Name, Contact No and Email over the line shape centre alignment (Ctrl + E) and
right align (Ctrl + R).
4. Make Heading Career Objectives, Educational Profile, Skills, Personal Details, Date, Place
and Signature.
 Harsh Raj
+918709193754
hraj7415@[Link]

Career Objectives:
I want to become a H.R Manager. Human Resource Management Professional seeks an
opportunity where experience in staffing, employee relations, project management, and
superior communication skills will enhance overall strategic plan and direction of an
organization. Desire an HR coordinator position to put my experience and knowledge of
negotiation.

Educational Profile:
Examination Degree Institution Board Passing Year Percentage

St. Andrews Institute MDU Pursuing -

BBA of technology and
Management Delhi-
NCR.
Mother Teresa CBSE 2018 79%
XII
Vidyapati School
St. Michael’s School. ICSE 2016 85%
X

Skills:
 Leadership quality.
 Good Knowledge of MS-Word, MS-Excel, PowerPoint.
 Goal-oriented person.
 Creative and hard working person.
 Problem-solving abilities.
Personal Details:
Father’s Name: Mahesh Kumar.
Mother’s Name: Mrs. Seema Bharti.
D.O.B: November 1, 2000.
Address: Mujjafarpur, Bihar
Nationality: Indian
Religion: Hindu
Email: hraj7415@[Link]
Contact NO.: +91-8709193754
Gender: Male
Marital Status: Unmarried

Date: 10/10/2022
Place:Bihar (Harsh Raj)
 Practical-2
Procedure to create a Cover Page.
Procedure:
1. Click on start button – MSWord – File – New – Blank document.
2. Go to the insert – Shapes – flow chart – Documents. Change color of shapes, click on the
shapes – format – shape styles –Theme styles or shape fill.
3. Write Collage Name under that shape using center alignment (Ctrl
+ E) and right align (Ctrl + R).
4. To draw another shape, go to the insert – Shapes – Lines – curve.
Change color of shapes, click on the shapes – format – shape
Styles – Theme styles or shape fill.
5. put any picture or 3D picture, Go to the insert – picture – online
Picture – write picture name – click picture – click insert or go to
The insert – 3D Models – write model name – click model – click
Insert. Fix the picture or rotate the model as we wish to put or
Rotate.
6. Write the Admission open, Year in the middle of the page using
Centre alignment (Ctrl + E)
7. For the same shape follow the same step as given above i.e. B&D.
Then rotate the shape by putting the cursor at the rotate point of
The shape.
8. At the last, write the Address, Contact no. & Email id on the
Bottom of the page.
St. Andrews Institute of technology &
management

Admission open 2023

Address: Haily Mandi Rd, Khurrampur, Farukh Nagar, Haryana 122506
Phone: 085059 37772, Email: saitm@[Link]
 Practical-3
Procedure to create a Mail Merge Letter.
Procedure:
1. Click on start button – MS Word – File – New – Blank document.
2. Type your letter which you want to send to the multiple addresses.
3. Open MS Excel, Click on start button – MS Excel – File – New – Blank work book, create
the list of the name of the members (First name, last name, address, mob. no., email id) and
save it to the desktop.
4. In MS-Word, go to Mailings – Start Mail Merge – Step by step mail merge wizard… -
Mail Merge –click next : Starting Document -Next: Select Recipients – next: write your letter
– select date source – desktop – select file – open – click ok – again click ok.
5. Then in Mail Merge tool bar click Insert Merge fields wherever
Needed (First name, last name, address, mob. no., email id)
6. If you want to change the field names then click Customize - Select the Field – Rename –
Click ok.
7. Then finally in the mail Merge tool bar click merge to New
Document – All – Ok – Save the file (next: preview your letters –next: Complete the merge).
 OUTPUT

OUTPUT
To,
Harsh Kumar
Bihar
XXXXXX
Harsh 123@[Link]
Dear Harsh Kumar,
This is ABC, wishing you very happy Holi. Enjoy Holi with your friends and family safely
and securely.
Thankyou.
To,
Sonu Raj
Haryana
XXXXXX
Sonu123@[Link]
Dear Sonu Raj,
This is ABC, wishing you very happy Holi. Enjoy Holi with your friends and family safely
and securely.
Thankyou.
 Practical-4
Procedure to create a Macro for inserting a picture and formatting the
text.
Procedure:
1. Open MS Office - MS Word – File – New.
2. Go to Tool – Macro - Record new Macro - Give the macro name.
3. Go to insert – Picture - from File - browse for the required picture - click Insert.
4. Type some text – Select it by holding shift Key and right/left arrow Keys - change the font
size, color and style by the standard tool bar.
5. Go to Tool- Macro - click Stop recording.
6. Open a new File go to – Tool – Macro - Select the macro name which u have Created-
click Run.
 OUTPUT

Golden Temple.
 Practical-5
Procedure to create a worksheet with 4 columns. Enter 10 records and find
the sum of all columns in MS Office Excel.
Procedure:
1. Open MS Office - MS Excel – File – New.
2. Select 4 column and 3 rows at the centre of the beginning - right click - Format cells - click
select the alignment tab - tick Merge cells option – ok - Type the Heading.
3. Enter the 4 columns Heading and 10 row heading by clicking the cursor on to the
particular cell.
4. Enter the data for the 4 columns.
5. Select the first column whole data, except the heading and click ∑ (auto sum) in the
standard tool bar - this will add the column’s data and places the result at the end.
6. Repeat the same for remaining 3 columns.
OUTPUT
 Practical-6
Procedure to create a Report containing the pay details of the Employee
using MS-Office Excel.
Procedure:
1. Click on start button – MS-Excel – File – New - Blank workbook.
2. Select few columns and few rows at the centre of the beginning – Home – Merge & centre
– Type the Heading.
3. Enter the column Headings. Enter the data of following columns
Manually [Link]. Name, Employee Id, Basic, DA, HRA, CCA (100 for
All the employee), Gross, GPF, KGID, Total Deduction and net Salary.
4. Enter the following formula to calculate the respective values:
DA (60% of BASIC) = E7*0.6
HRA (7.5% of BASIC) = E7*0.075
Gross = SUM (E7:H7) or D6+E6+F6+G6
GPF (7% of BASIC) = E7*0.07
KGID (8% of BASIC) = E7*0.08
Total Deduction = SUM (J7:K7) or J7+K7
Net Salary = I7-L7

5. After Writing each formula select the cell and drag to the entire column to apply.
OUTPUT
 Practical-7
Procedure to create a Student result sheet using MS-Office Excel.
Procedure:
1. Click on start button – MS-Excel – File – New – Blank workbook.
2. Select few columns and few rows at the centre of the beginning –
Home – Merge & centre – type the heading.
3. Enter the column Headings. Enter the data of following columns
Manually [Link], Roll. No., Name, BO, BM, BC, FA, CF, MEBD, Total,
%age, Result.
4. Enter the following formula to calculate the respective values.
Total = SUM (D7:I7)
Percentage = J7/6
Result = IF (AND (D7>=35, E7>=35, F7>=35, G7>=35, H7>=35, I7>=35),
”PASS”,”FAIL”)
5. After Writing each formula select the cell and drag to the entire
Column to apply.
OUTPUT
 Practical-8
Procedure to create a Simple Bar chart to highlight the sales of a company.
Procedure:
1. Click on start button – MS-Excel – File – New – Blank workbook.
2. Select few column and few rows at the centre of the beginning – Home – Merge & centre –
type the heading.
3. Enter the column Heading and row heading. Enter the data in each Column (Period,
Product1, Product2, Product3, and Product4).
4. Select the complete row and column data including the header.
5. Go to Insert – Chart – Bars chart – Select the Chart type – Select the
Type – Next – under Title give the Heading at Chart title – Finish.
OUTPUT
 Practical-9
Procedure to create a Pie Chart for a sample data and give legends.
Procedure:
1. Click on start button – MS-Excel – File – New –Blank work book.
2. Select few column and few rows at the centre of the beginning – Home – Merge & centre –
type the heading.
3. Enter the column Heading. Enter the data in each Column (S. No., Expenses and Amount).
4. Select the complete row and column data including the header.
5. Go to Insert – Chart – Pie – Select the Chart Type – Next – under title give the Heading at
Chart title – Finish.
OUTPUT
 Practical-10
Procedure to create a simple presentation using PowerPoint.
Procedure:
1. Click on start button – MS-PowerPoint – File – New – Blank presentation.
2. Click the Other Task Panes drop down menu – tick Slide Layout – Select the Layout you
want.
3. Click the Other Task Panes drop down menu – tick Slide Design –
Select the Design of your choice.
4. Click on the slide to type the text – align the text using standard tool bar.
5. In order to insert new slide – go to insert – New Slide – Type your text.
6. Each slide may have the different slide layouts depending on the
Content.
7. After creating all the slides – By holding Ctrl key select all the slides – go to Slide show –
Slide transition – the transition – select speed to minimum – tick Automatically after and
enter the time of interval for each slide to appear in slide show – Click Apply to all the slide.
8. You can also use Custom animation to apply animation to the
Text/Content, for that select the object – go to Slide Show – Custom
Animation – click add effect – choose the style.
9. Finally go to Slide Show – view Show.
OUTPUT