IT Application In Business Practical File

SUBMITTED BY:
Name: Parth Garg
Enrolment No.
50715901724
IT Application in Business

BBA, Semester 1, section B

BATCH 2024-2027

RUKMINI DEVI INSTITUTE OF ADVANCED STUDIES

An ISO 9001:2015 Certified Institute

NAAC Accredited: A+ Grade (2

nd Cycle), Category A+ Institution (by

SFRC, Govt. of NCT Delhi(Approved by AICTE, HRD Ministry, Govt. of

India) Affiliated to GGSIPU, Delhi 2A & 2B, Madhuban Chowk, Outer
Ring Road, Phase-1, Delhi-110085
 Table Of Contents

1. MS-DOS

2. MS-Word

3. MS-Excel

4. MS-PowerPoint
 ITBL – 111 1

MS - DOS

Question-1

A) To create two new subdirectories labelled BBA Morning shift and BBA Evening
shift in the C:\Work directory in the command prompt, follow these steps:
1. Open Command Prompt.

2. Navigate to the C:\Work directory.

3. To create the BBA Morning shift subdirectory, type the following command and press
Enter:
- md BBA_Morning_shift

4. To create the BBA Evening shift subdirectory, type the following command and
press Enter: - md BBA_Evening_shift

5. To check whether the subdirectory has been created, enter dir command

B) To create two subdirectories labelled NAME and SUBJECTS in the BBA Morning shift
directory, you can use the following steps:

Parth Garg
50715901724
 ITBL – 111 2

1. Open a terminal window.

2. Navigate to the BBA Morning shift directory using the cd command.

3. Create the NAME subdirectory using the md command. For example, to create the
NAME subdirectory, you would type the following command:

- md NAME

4. Create the SUBJECTS subdirectory using the md command. For example, to create the
SUBJECTS subdirectory, you would type the following command:

- md SUBJECT

C) To create two subdirectories labelled ROLL_NUMBER and PHONE NUMBER in the

BBA Eventig shift directory, you can use the following steps:

1. Open a terminal window.

2. Navigate to the BBA Evening shift directory using the cd command. 3. Create the ROLL
NUMBER subdirectory using the md command. For example, to create the
ROLL_NUMBER subdirectory, you would type the following command:

md ROLL_NUMBER

Parth Garg
50715901724
 ITBL – 111 3

4. Create the PHONE_NUMBER subdirectory using the md command. For example, to

create the PHONE_NUMBER subdirectory, you would type the following command:

md PHONE_NUMBER

Question 2

Internal Commands

1. dir – Displays the list of files and directories in current directory

Significance: The dir command is one of the most commonly used internal commands, as it
allows users to quickly view the contents of a directory. This can be useful for a variety of
tasks, such as finding a specific file, checking the size of a directory, or verifying that a file
was copied or created successfully.

2. cd – Change Directory Parth Garg

50715901724
 ITBL – 111 4

Significance: The ed command is another essential internal command, as it allows users to

navigate the file system. This is necessary for performing a variety of tasks, such as
opening files, running programs, and saving data.

3. copy con- allows the creation of a file through the command line

Significance: The copy con command is a powerful tool for managing files and directories.
It can be used to copy files to share files with others, or to move files to a new location.

4. ren - Rename a file or directory.

Significance: This command is used to rename the files or dir. Can be used for correcting
names etc

5. exit – Exits the command prompt

Significance: The exist command is used to close the command prompt and return to
window desktop.

External Command

Parth Garg
50715901724
 ITBL – 111 5

1. remove – Format a disk or dive

Significance: The format command is used to prepare a disk or drive for use, This is
necessary for new disks and drives as well as for disks that have been reformatted

1. chkdsk – Checks a disk or drive for errors

Significance: The chkdsk command can be used to identify and repair errors on disks or
drives. This can help to prevent data loss and corruption

Parth Garg
50715901724
 ITBL – 111 6

2. defrag- Defragments a disk or drive

Significance: The defrag command recognized the files on a disk or drive to improve
performance. This can be useful for disks and drives that are frequently fragmented, such as
those that are used to store a lot of small files

3. ping – Tests network connectivity to remote host

Significance: The ping command is a network utility to test network connectivity and
measure network performace.

4. Ipconfig: Displays all the current TCP/IP network configuration values.

Parth Garg
50715901724
 ITBL – 111 7

Significance: The ipconfig command can be used to troubleshoot network problems, verify
network settings, and obtain IP address information

Steps
Here are the specific steps for executing each of the commands mentioned above:
Internal Commands-

● dir: To execute the dir command, simply type dir and press Enter.
● cd: To execute the cd command, type cd followed by the name of the direct
want to change to. For example, to change to the C:\Windows directory, you would
type cd C:\Windows and press

Enter.

● copy con: To execute the copy con command, type copy con followed by th
the file you want to copy. For example, to copy the README.txt file, you would type
copy con README.txt and press Enter, then press Ctrl Z, then press enter again.

● ren: To execute the ren command, type ren followed by the name of the file
to rename and the new name you want to give it. For example, to rename the
README.txt file to NewREADME.txt, you would type ren README.txt
NewREADME.txt and press
Enter.

● exit: To execute the exit command, simply type exit and press enter.

External Commands-

Parth Garg
50715901724
 ITBL – 111 8

● format: To execute the format command, type format followed by the drive letter of
the disk or drive you want to format. For example, to format the D: drive, you would
type format D: and press Enter.

● chkdsk: To execute the chkdsk command, type chkdsk followed by the drive letter of
the disk or drive you want to check. For example, to check the C: drive, you would
type chkdsk C: and press Enter.

● defrag: To execute the defrag commnd, type defrag followed by the drive letter of the
disk or drive you want to defragment. For example, to defragment the C: drive, you
would type defrag C: and press Enter.

● ping: To execute the ping command, type ping followed by the IP address or domain
name of the remote host you want to test network connectivity to. For example, to test
network connectivity to Google, you would type ping google.com and press Enter.

● ipconfig: To execute the ipconfig command, simply type ipconfig and press Enter.

Parth Garg
50715901724
 ITBL – 111 9

MS-WORD
Question no. 3 :
You are represented as an employee in an MNC where you have to prepare an image-
based document in the form of a letterhead.

1. Insert a picture in a word document

2. Use this picture as a watermark

3.Use SmartArt to create an organization chart for the same MNC.

Take screenshot of each step and include it in your practical file. Mention all the steps
in support of your answer. Relate all the points mentioned above and create suitable
output accordingly. (K3 level)

1. Insert a picture in a word document

step1)

In the ribbon bar at the top, go to the "Insert" tab. In the "Illustrations" group, you'll find
the "Pictures" option. Click on it.

Parth Garg
50715901724
 ITBL – 111 10

step2)

A file dialog will appear. Navigate to the location of the picture you want to insert,
select it, and click “Insert”.

Final Output:

The picture will be inserted into your document at the cursor's location .You can then
resize, move, and format the picture as needed.
Parth Garg
50715901724
 ITBL – 111 11

2. Use this picture as a watermark

step1)

In the ribbon bar at the top, go to the "Design" tab.

step2)

Click on the "Watermark" option. Choose the option custom watermark for customize
your watermark.

Parth Garg
50715901724
 ITBL – 111 12

step3)

Customize your watermark by choosing picture watermark and text watermark. We can
add any picture by selecting picture watermark. For text watermark first select
language. Add text , font ,size, colour and layout. Then click to “Apply”.

Final Output:

Your document will now have the selected picture as a watermark, and it will appear
behind the text.

Parth Garg
50715901724
 ITBL – 111 13

3.Use SmartArt to create an organization chart for the same MNC.

Step1)

In the ribbon bar at the top, go to the "Insert" tab.

Step2)

In the "Illustrations" group, you'll find the "SmartArt" option. Click on it.

Parth Garg
50715901724
 ITBL – 111 14

Step3)

Insert a SmartArt graphic to visually communicate information. Select any SmartArt

graphics range from list , process, hierarchy and many more. Then Click “ok”.

Step4)

In the SmartArt Graphic dialog box, choose the "Hierarchy" category from the left
pane. Click on ‘Text’ and write relevant text.

Parth Garg
50715901724
 ITBL – 111 15

Final Output:

Write as per the context.

Question no. 4:

You are represented as a manager of a restaurant; make a feedback form

mentioning 10 questions at least. (K3 Level)

Note: It must include:

• Restaurant name, Address including city, postal code

• Phone number, email/website URL
• Background image

Parth Garg
50715901724
 ITBL – 111 16

Step1)

In the ribbon bar at the top, go to the "Design" tab. In the "Page Background" group,
you'll find the "Page Borders" option. Click on it.

Step2)

A box “Borders and shading” is open. Select the style , colour ,width ,or art(if needed).
Then click “ok”.

Parth Garg
50715901724
 ITBL – 111 17

Step3)

Now, boarder is shown.

Final Output (Feedback form)

Parth Garg
50715901724
 ITBL – 111 18

Question no. 5:

Write a letter on behalf of “Your Name” company to the customers to

tell about upcoming offers or to inform them about some changes in
business context. Use mail-merge feature of MS-word and apply the
following: (K3 Level)

• First prepare data (save as BBA) in word or separate excel for mail merge
(maximum 10 lines)
• Add a minimum 3 recipients that will be used for mail merging process
• Insert fields from your document (name : BBA) in a sample email
• Preview and finish the mail merge
• Save your mail merge

Step1)

First prepare data excel for mail merge.

Parth Garg
50715901724
 ITBL – 111 19

Step2)

In the ribbon bar at the top, go to the "Mailings" tab.

Step3)

Select “Start Mail merge” option. Then select “Step-by-step mail merge Wizard”
option.
Parth Garg
50715901724
 ITBL – 111 20

Step4)

Start following the steps shown on the bottom right of the

screen.

Parth Garg
50715901724
 ITBL – 111 21

Step5)

Browse your file BBA that you have to merge.

Parth Garg
50715901724
 ITBL – 111 22

Step 6)

“Select table” box is opened, then click on “ok”.

Step7)

“Mail merge Recipients” tab is shown, then click on “ok”.

Parth Garg
50715901724
 ITBL – 111 23

Step8)

Write your letter and move forward

Parth Garg
50715901724
 ITBL – 111 24

Step9)

Now click on “OK” button in merge to new document tab.

Your Mail been merged now.

Parth Garg
50715901724
 ITBL – 111 25

Final Output

Dear User,

Ridhi

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Dear User,

Drishti

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Parth Garg
50715901724
 ITBL – 111 26

Dear User,

Abhi

12

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Dear User,

Virat

15

16

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Parth Garg
50715901724
 ITBL – 111 27

Dear User,

Aryan

19

16

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Dear User,

Riya

20

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Parth Garg
50715901724
 ITBL – 111 28

Dear User,

Esha

11

16

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Dear User,

Nishtha

10

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Parth Garg
50715901724
 ITBL – 111 29

Dear User,

Aanya

18

15

Your marks for TS 1 have been uploaded on the website. So, kindly acknowledge the
marks.

Kindly ignore if already acknowledged.

Thank You

Question 6

Prepare a newsletter (having 2 pages at least) for RDIAS activities to the previous month.

NOTE: Use pictures in your task. Identify the activities according to the academic
schedule/planner of the institute and identify suitable elements to use for a newsletter. (K3
level)

Parth Garg
50715901724
 ITBL – 111 30

RDIAS NEWSLETTER

TOP NEWS

MY STORY: Motivation
Panel Discussion by
Women Entrepreneurs
________________________
Alumn i Club present
Alumni talk-1, Kshitij

Parth Garg
50715901724
ITBL – 111 31

Parth Garg
50715901724
 ITBL – 111 32

MS-Excel
Question no7.

Make a salary sheet (including HRA, DA and other factors) of employees working in a
big MNC. Mention all the steps in detailed form. Apply all the relevant factors
regarding this. (K3 LEVEL)

Step1)

Enter the name and basic salary of employes.

Step 2)

For calculating, HRA the formula applied “=D2*0.15” and then drag the formula down
to apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 33

Step3)

For calculating, DA the formula applied “=D2*0.1” and then drag the formula down to
apply it to other cells.

Step4)

For calculating, FA the formula applied “=D2*0.12” and then drag the formula down to
apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 34

Step5)

For calculating, Gross salary the formula applied “=SUM(D2:G2)” and then drag the
formula down to apply it to other cells.

Step6)

For calculating, PF the formula applied “=D2*0.02” and then drag the formula down to
apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 35

Step7)

For calculating, EPF the formula applied “=D2*0.1” and then drag the formula down to
apply it to other cells.

Step8)

Enter over time of the employes.

Parth Garg
50715901724
 ITBL – 111 36

Step9)

For calculating, TOTAL SALARY the formula applied “=SUM(H2:K2)” and then drag
the formula down to apply it to other cells.

Final Output

Parth Garg
50715901724
 ITBL – 111 37

Question no8.

Make a result analysis (12th class result) of 10 students from your class using MS
Excel. Make a Table for this. Explain all steps involved in this. (K2 LEVEL)

Question no9.

Use conditional statements (if-else etc.) to show the status whether pass or fail. Also
mention different grades or CGPA accordingly using formulation. (K3 LEVEL)

Step1)

Enter name and subject marks of each student in column.

Parth Garg
50715901724
 ITBL – 111 38

Step2)

Enter total marks of students.

Step3)

For calculating, OBTAINED MARKS the formula applied “=SUM(B2:F2)” and then
drag the formula down to apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 39

Step4)

For calculating, PERCENTAGE the formula applied “=H3*100/G3” and then drag the
formula down to apply it to other cells.

Step5)

For calculating, AVERAGE the formula applied “=AVERAGE(B2:F2)” and then drag
the formula down to apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 40

Step6)

For calculating, STATUS the formula applied “=IF(H2>0.56*G2,”PASS”,”FAIL”)” and

then drag the formula down to apply it to other cells.

Step7)

For calculating, GRADE the formula applied

“=IF(H2>0.8*G2,"A",IF(H2>0.6*G2,"B","C"))” and then drag the formula down to
apply it to other cells.

Parth Garg
50715901724
 ITBL – 111 41

Final Output

Ques 10) With the given data show relative reference and absolute reference. (K3 level)

Parth Garg
50715901724
 ITBL – 111 42

Question no. 11

Make a balance sheet of the expenditure (including Loss, profit, loss and profit
percentages, estimated sales, actual sales, revenue etc.) of a sales based company,
consider the name of the company: YOUR NAME. Mention all the steps in detailed
form. Apply all the relevant factors regarding this. (K3 LEVEL)

Item Amount

Assets

Cash $114,000.00

Inventory $70,000.00

Total Assets $184,000.00

Liabilities and
Equity
Accounts $70,000.00
Payable

Parth Garg
50715901724
 ITBL – 111 43

Taxes Payable $7,200.00

Shareholder
Equity
Common $10,000.00
Stock
Retained $16,800.00
Earnings
Total $184,000.00
Liabilities and
Equity

Steps-

Gather data: The first step is to gather all of the necessary data, such as sales figures, cost of
goods sold, operating expenses, and taxes.
Calculate revenue: Revenue is calculated by multiplying the actual sales by the markup
percentage.
Calculate gross profit: Gross profit is calculated by subtracting the cost of goods sold from
revenue.
Calculate operating expenses: Operating expenses are subtracted from gross profit to arrive at
profit before tax.
Calculate taxes: Taxes are calculated by multiplying profit before tax by the tax rate.
Calculate net income: Net income is calculated by subtracting taxes from profit before tax.
Calculate profit and loss percentages: Profit percentage is calculated by dividing net income by
revenue and multiplying by 100. Loss percentage is calculated by subtracting profit percentage
from 100. Prepare the balance sheet: The balance sheet lists the company's assets, liabilities,
and shareholder equity at a specific point in time.

Parth Garg
50715901724
 ITBL – 111 44

Question no. 12

Using Data Validation fix the format of data with a data format.

Step1)

Enter name of seller and amount of collected in excel.

Parth Garg
50715901724
 ITBL – 111 45

Step2)

Go to Data tab then select data validation option. Drag the mouse and select all names
of seller. Write validation criteria as shown in above photo.

Step3)

As we convert Naresh into number 12 then press enter

Parth Garg
50715901724
 ITBL – 111 46

Step4)

As this value doesn’t match the data validation restrictions defined for this cell.

Step5)

Now, we select salary and write data validation criteria.

Parth Garg
50715901724
 ITBL – 111 47

Step6)

As this value doesn’t match the data validation restrictions defined for this cell.

Question no. 13

Below is the raw data for the Pivot Table practice.

● Perform statistics measure in pivot table .(Sum, Count, Average)

● Modify the Pivot table as per the requirement . Drag “Maintenance Deposit” into
“values” area
● Grouping the Fields in the Pivot table.

Parth Garg
50715901724
 ITBL – 111 48

SUM;

Drag the “Block Name” to “Rows” and “Sum of Final Product Value” to “Values” field

Parth Garg
50715901724
 ITBL – 111 49

COUNT:
Let us count the number of flats for different blocks by changing the value field settings in
Excel PivotTable to count as below:

Then, click on “Value Field Settings.”

A dialog box appears. Select “Count” from “Summarize value field by.”

Parth Garg
50715901724
 ITBL – 111 50

Then the PivotTable looks like as given below:

Parth Garg
50715901724
 ITBL – 111 51

From the above tables, we can see how to change the field settings to count. Here, we can note
that we got the highest number of flats in the “Rainbow” block and “Strawberry” block
compared to other blocks. In total, we got 79 flats in this project.

AVERAGE:

In the PivotTable practice exercise example, we will find out the average price of the flat in
each block by changing the value field settings from “Count” to “Average.”

Then, PivotTable changes from “Count” to “Average,” as given below:

Parth Garg
50715901724
 ITBL – 111 52

From the above PivotTable example, we can see that we got the average flat price in each
block. The “Donald” block got the highest average flat price among other blocks.

Parth Garg
50715901724
 ITBL – 111 53

MS POWERPOINT

Q14 Make a photo album in a PowerPoint presentation. Include all the steps in the file.

Note: Select the animation tool in your presentation.

Step1- open MS power point.

Step2- To create a photo album download the photos you want to make a photo album
of.
Step3- Now go to insert tab.

Step4 – click on photo album.

Parth Garg
50715901724
 ITBL – 111 54

Step5- a dialogue box appears.

Step6- Insert the pictures from the device.

Parth Garg
50715901724
 ITBL – 111 55

Your pictures are inserted.

Step7 To apply animations on your photo album, Go to animation tab different type of
Animations will be seen.

Now your animations are added.

Parth Garg
50715901724
 ITBL – 111 56

Your Photo album is created.

After completion it will look like-

NOTE- the numbers 1 and 2 shows how many animations you have applied.

Parth Garg
50715901724
ITBL – 111 57

Parth Garg
50715901724
 ITBL – 111 58

Your Photo Album is created.

Q2 From a business-marketing point of view, you have to prepare a presentation as a

supplier of keyboards; the
company name is “KEY keyboards and computer accessories”.

Include all the steps in the file.

Note: Select the animation tool in your presentation.

Step1- open MS PowerPoint.

Step2- select the slide design you want to have, with the help of design tab.

Step3- select the desired slide you want to apply from the home tab.

Parth Garg
50715901724
 ITBL – 111 59

Step4- Different types of slides, are visible.

Step5- Type the desired text in the slides.

Step6- To apply animations on your photo album, Go to animation tab different type of
Animations will be seen.

Parth Garg
50715901724
 ITBL – 111 60

Now your animations are added.

Your presentation is now complete.

After completion your presentation will look like-:

Parth Garg
50715901724
 ITBL – 111 61

Your presentation is created.

Note- The numbers show the different types of animation we have applied.

Parth Garg
50715901724
 ITBL – 111 62

Question 15

From a business-marketing point of view, you have to prepare a presentation as a supplier

of keyboards; the company name is “KEY keyboards and computer accessories”.

Include all the steps in the file.

Note: Select the animation tool in your presentation.

Parth Garg
50715901724
ITBL – 111 63

Parth Garg
50715901724
ITBL – 111 64

Parth Garg
50715901724
 ITBL – 111 65

MADE BY
PARTH GARG
ITBL – 111 66

Ridhi Joshi
02915901723