PRACTICAL FILE

ON
IT APPLICATIONS IN BUSINESS

GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY

In partial fulfilment of the requirement for the award of the

degree of

BACHELOR OF BUSINESS ADMINISTRATION

Batch 2023 – 2026

SUBMITTED BY: SUBMITTED TO:

Tushti Malhotra Dr. Shailendra Kumar
Enrolment NO.: 75450601723 (Asst. Prof)

NEW DELHI INSTITUTE OF MANAGEMENT

61A, TUGHLAKABAD, NEW DELHI-62
 ACKNOWLEDGEMENT

We need a person to guide us, Concentration, dedication and application are

necessary but not sufficient to achieve any goal. There must be awarded by
proper guidance, assistance and co-operation of any senior person to make it
enable.

Gratitude is short lived but when put in black and white; one hopes it to enjoy a
longer life. Many people have given their valuable time and ideas and
assistance. I cannot forget the whole hearted support, which has given me as an
expert and learned supervision of Dr Shailendra Kumar (Asst. Prof., IT).

Lastly, I thank all those, who have, directly or indirectly, helped me in

completion of project report.

Tushti Malhotra
BBA (1st Sem)
 CERTIFICATE

This is to certify that Tushti Malhotra pursuing BBA (Gen) from NEW DELHI
INSTITUTE OF MANAGEMENT has completed this file under my
supervision and guidance. He has taken care of all necessary aspects and shown
interest and utmost sincerity during the completion of the practical file to my
full satisfaction.

I certify that the practical is up to my expectation and as per the guidance laid
down by GURU GOBIND SINGH INDRAPRASTHA UNIVERSITY.

Dr. Shailendra Kumar

Assistant Professor
(Information Technology)
 PRACTICAL INDEX
Introduction of MS Word and its features

DBMS

Cloud computing

1. Prepare Resume
2. Time –Table For BBA First semester
3. What is Mail Merge explain practically
4. Write complain letter
5. Prepare Calendar for 2024 JAN Month.
6. Write the Steps For A5B7and X6+Y6 = 0

Section B( MS Excel)
Introduction of MS Excel and its features

Different function of Excel

Pivot table with example

Introduction of Excel (Row & Columns and Functions)

Prepare a Marks list for 40 students and find percentage, grade through nested if
Condition?

Find The net salary

Prepare a sales report of the following automobile companies.

Draw a column chart between:

 Company & product differentiation

 Company & cost leadership.

Draw a Bar chart between:

 Company & sales volume.

Section C( MS Power point)

Introduction of MS Power Point and its features

“Introduction of OSI model”.

Introduction to Ms word and its features.
Microsoft word is a word processor software developed by Microsoft in 1983. It is the most
commonly used word processor software. It is used to create professional quality documents,
letters, reports, resumes, etc and also allows you to edit or modify your new or existing
document. The file saved in Ms Word has .docx extension. It is a component of the Microsoft
Office suite, but you can buy it separately and is available for both Windows and macOS.
The latest version of Ms Word is 2019.

Features:

 Fast Typing: Text in a word processor becomes fast since there is no associated
mechanical carriage movement.
 Editing functions: Any type of correction (insert, delete, change, etc.) can be easily
done as and on demand.
 Permanent storage: Documents can be stored indefinitely. The saved document can
be called up at any time.
 Formatting functions: Entered text can be created in any form and style (bold, italic,
underline, different fonts, etc.). Graphics Provides the ability to insert drawings into
documents, making them more useful.
 OLE (Object Linking and Embedding): OLE is a program integration technology
used to exchange information between programs about objects. Objects are entities
stored as graphs, equations, video clips, audio clips, images, and so on.
 Alignment: You can align your text as you like, for example, left, right, or centered.
You can even make a box set, i.e, aligned from both sides.
 Delete errors: You can remove a word, line, or paragraph from a stroke, and the rest
of the subject will appear automatically.
 Line Spacing: You can set the line spacing from one to nine according to your
preference.
 Move-in Cursor: You can move the cursor from one word to another or from one
paragraph to another as needed.
 Naming a Document: You can name a document and retrieve it from your hard drive
at any time for editing, updating, correction, and even for printing.
 Page break: You can set a page break at any point in the text so that the next page is
printed when printing.
 Search and Replace: You can search for a specific word in the entire document and
replace it with another word.
 Thesaurus: you can exchange a word with one of its synonyms. This way you can
avoid the repetition of a single word in a document and add beauty to the language.
 Indentation: Refers to the space between the text boundaries and the margins of the
page. There are three types of indents: positive, negative, and hanging.
 Header and footer: A header or footer is text or a graphic, such as a page number, a
date, or a company logo, that is typically printed at the top or bottom of each page of a
document.
  Page orientation: Refers to whether the text is printed lengthways or across. Above
the printed side is called PORTRAIT and the side printed across is called
LANDSCAPE.
 Spell Checker: Not only can it check spelling mistakes, but it can also suggest
possible alternatives for misspelled words.
 Mail Merge: This is a function that allows you to print a large number of
letters/documents with more or less similar texts. Below this, the same letter of
invitation must be sent to the guests, only the name and address are changed.

DBMS (Database Management System)

A Database Management System (DBMS) is a software system that is designed to manage

and organize data in a structured manner. It allows users to create, modify, and query a
database, as well as manage the security and access controls for that database.

Key Features of DBMS

 Data modelling: A DBMS provides tools for creating and modifying data models,
which define the structure and relationships of the data in a database.
 Data storage and retrieval: A DBMS is responsible for storing and retrieving data
from the database, and can provide various methods for searching and querying the
data.
 Concurrency control: A DBMS provides mechanisms for controlling concurrent
access to the database, to ensure that multiple users can access the data without
conflicting with each other.
 Data integrity and security: A DBMS provides tools for enforcing data integrity and
security constraints, such as constraints on the values of data and access controls that
restrict who can access the data.
 Backup and recovery: A DBMS provides mechanisms for backing up and
recovering the data in the event of a system failure.
 DBMS can be classified into two types: Relational Database Management System
(RDBMS) and Non-Relational Database Management System (NoSQL or Non-SQL)
 RDBMS: Data is organized in the form of tables and each table has a set of rows and
columns. The data are related to each other through primary and foreign keys.
 NoSQL: Data is organized in the form of key-value pairs, documents, graphs, or
column-based. These are designed to handle large-scale, high-performance scenarios.

A database is a collection of interrelated data which helps in the efficient retrieval, insertion,
and deletion of data from the database and organizes the data in the form of tables, views,
schemas, reports, etc. For Example, a university database organizes the data about students,
faculty, admin staff, etc. which helps in the efficient retrieval, insertion, and deletion of data
from it.
 Cloud computing

Cloud computing means storing and accessing the data and programs on remote servers that
are hosted on the internet instead of the computer’s hard drive or local server. Cloud
computing is also referred to as Internet-based computing, it is a technology where the
resource is provided as a service through the Internet to the user. The data which is stored can
be files, images, documents, or any other storable document.

 Some operations which can be performed with cloud computing are –

 Storage, backup, and recovery of data
 Delivery of software on demand
 Development of new applications and services
 Streaming videos and audio
 Resume
Tushti Malhotra

Civil Lines, Delhi - 54

tushtimalhotra.stxaviersdelhi@gmail

Objective: Seeking a challenging position at ABS company where my skills in [Key Skill
#1], [Key Skill #2], and [Key Skill #3] can contribute to the company's success. Eager to
apply my expertise in [Relevant Experience] and passion for [Specific Interest or Industry] to
drive innovation and exceed performance goals.

Education:

Degree Earned: Bacholar of Business Administration

College: NDIM, Delhi

Work Experience: HR, XYZ company, Delhi

Skill: Programming languages, software, project management

References: Dr. Shailender Yadav

Time Table for BBA SEM – 1

Time /Class Monday Tuesday Wednesday Thursday Friday

1st Class Business Business Business Information Business
10 – 10. 45 Maths Economic Maths Technology Economic
2nd Class Financial MPOB Financial Financial Information
10:45 – 11:20 Accounting Accounting Accounting Technology
3rd Class Business Entrepreneurial Business Entrepreneurial Business
11:20 – 12:00 Economics Mindset Maths Mindset Maths
Break
12 - 1
4th Class Information Business Business MPOB Financial
1 – 1:45 Technology Maths Economic Accounting
 Mail Merge

Mail merge consists of combining mail and letters and pre-addressed envelopes or mailing
labels for mass mailings from a form letter. This feature is usually employed in a word
processing document which contains fixed text and variables.

Step wise explanation:

Step1: Write a message

Step 2: Go to mailing on the toolbar and start mail merge.

Step 3 – Select Recipients The recipients can come from either an existing Excel file, an
Access table or you can create a new list in Word.

Step 4: Write the letter

Step 5: Preview Mail

Step 6: Complete the merge

Results:
 Complain Letter

Subject: Urgent: Complaint Regarding Recent Product Purchase

Dear Customer Support Team,

I hope this email finds you well. My name is Tushti Malhotra, and I am writing to express my
dissatisfaction and frustration with a recent product purchase I made from your company.

I purchased a laptop from your online store with the order number 00000. While I initially
had high expectations based on the product description and reviews, I am disappointed to
report that the product I received does not meet the advertised standards.

I have attached pictures of the defective product for your reference. The issues I've
encountered not only fall short of my expectations but also pose a significant inconvenience.

I understand that no product is perfect, and occasional defects can occur. However, I believe
the extent of the issues with my purchase goes beyond reasonable expectations. I would
appreciate it if you could investigate this matter promptly and provide a resolution at the
earliest convenience.

As a loyal customer, I have always valued the quality of your products and the excellent
customer service that your brand is known for. Therefore, I trust that you will address this
matter with the urgency and attention it deserves.

I kindly request the following actions to be taken:

1. A thorough investigation into the quality control process for the laptop.
2. Replacement of the defective product with a fully functional one.
3. Clear communication regarding the steps being taken to prevent such issues in the
future.

I understand that mistakes happen, and I believe in your commitment to customer

satisfaction. I appreciate your attention to this matter and look forward to a swift resolution.

Thank you for your understanding and cooperation.

Sincerely,

Tushti Malhotra, tushtimalhotra.stxaviersdelhi@gmail.com

 Calendar for January, 2024
Monday Tuesday Wednesda Thursday Friday Saturday Sunday
y
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31

Write the Steps for A5B7and X6+Y6 = 0

1. Select Insert > Equation or press Alt + =.

2. To create your own, select Design > Equation > Ink Equation.
3. Use your finger, stylus, or mouse to write your equation.
4. Select Insert to bring your equation into the file.
 Introduction to Excel and its features

Excel is a spreadsheet program from Microsoft and a component of its Office product group
for business applications. Microsoft Excel enables users to format, organize and calculate
data in a spreadsheet.

By organizing data using software like Excel, data analysts and other users can make
information easier to view as data is added or changed. Excel contains a large number of
boxes called cells that are ordered in rows and columns. Data is placed in these cells.

Excel’s Rows and Columns are like the building blocks of your spreadsheet. Each cell, range
of cells, or table in Excel is made up of these rows and columns. There are 16,384 columns
and 1,048,576 rows in a single Excel worksheet. It’s like a huge grid where you can place
your data.

Functions are predefined formulas in Excel. They eliminate laborious manual entry of
formulas while giving them human-friendly names. For example: =SUM(A1:A3). The
function sums all the values from A1 to A3.

Features of MS Excel

Ribbon: The Ribbon in MS-Excel is the topmost row of tabs that provide the user with
different facilities/functionalities.

Home Tab: It provides the basic facilities like changing the font, size of text, editing the cells
in the spreadsheet, autosum, etc.

Insert Tab: It provides the facilities like inserting tables, pivot tables, images, clip art, charts,
links, etc.

Page layout: It provides all the facilities related to the spreadsheet-like margins, orientation,
height, width, background etc. The worksheet appearance will be the same in the hard copy
as well.
Formulas: It is a package of different in-built formulas/functions which can be used by user
just by selecting the cell or range of cells for values.

Data: The Data Tab helps to perform different operations on a vast set of data like analysis
through what-if analysis tools and many other data analysis tools, removing duplicate data,
transpose the row and column, etc. It also helps to access data(s) from different sources as
well, such as from Ms-Access, from web, etc.

Review: This tab provides the facility of thesaurus, checking spellings, translating the text,
and helps to protect and share the worksheet and workbook.

View: It contains the commands to manage the view of the workbook, show/hide ruler,
gridlines, etc, freezing panes, and adding macros.
 Excel functions

1. SUM: The SUM function is the first must-know formula in Excel. It usually aggregates
values from a selection of columns or rows from your selected range.

=SUM(number1, [number2], …)

Example:

=SUM(B2:G2) – A simple selection that sums the values of a row.

=SUM(A2:A8) – A simple selection that sums the values of a column.

=SUM(A2:A7, A9, A12:A15) – A sophisticated collection that sums values from range A2 to
A7, skips A8, adds A9, jumps A10 and A11, then finally adds from A12 to A15.

=SUM(A2:A8)/20 – Shows you can also turn your function into a formula.

2. AVERAGE: The AVERAGE function should remind you of simple averages of data, such
as the average number of shareholders in a given shareholding pool.

=AVERAGE(number1, [number2], …)

Example: =AVERAGE(B2:B11) – Shows a simple average, also similar to

(SUM(B2:B11)/10)
3. COUNT: The COUNT function counts all cells in a given range that contain only numeric
values.

=COUNT(value1, [value2], …)

Example:

COUNT(A:A) – Counts all values that are numerical in A column. However, you must adjust
the range inside the formula to count rows.

COUNT(A1:C1) – Now it can count rows.

4. COUNTA: Like the COUNT function, COUNTA counts all cells in a given rage.
However, it counts all cells regardless of type. That is, unlike COUNT that only counts
numerics, it also counts dates, times, strings, logical values, errors, empty string, or text.

=COUNTA(value1, [value2], …)

Example:
COUNTA(C2:C13) – Counts rows 2 to 13 in column C regardless of type. However, like
COUNT, you can’t use the same formula to count rows. You must make an adjustment to the
selection inside the brackets – for example, COUNTA(C2:H2) will count columns C to H

5. IF: The IF function is often used when you want to sort your data according to a given
logic. The best part of the IF formula is that you can embed formulas and functions in it.

=IF(logical_test, [value_if_true], [value_if_false])

Example:

=IF(C2<D3,“TRUE”,”FALSE”) – Checks if the value at C3 is less than the value at D3. If

the logic is true, let the cell value be TRUE, otherwise, FALSE

=IF(SUM(C1:C10) > SUM(D1:D10), SUM(C1:C10), SUM(D1:D10)) – An example of a

complex IF statement. First, it sums C1 to C10 and D1 to D10, then it compares the sum. If
the sum of C1 to C10 is greater than the sum of D1 to D10, then it makes the value of a cell
equal to the sum of C1 to C10.
6. TRIM: The TRIM function makes sure your functions do not return errors due to extra
spaces in your data. It ensures that all empty spaces are eliminated. Unlike other functions
that can operate on a range of cells, TRIM only operates on a single cell. Therefore, it comes
with the downside of adding duplicated data to your spreadsheet.

=TRIM(text)

Example:

TRIM(A2) – Removes empty spaces in the value in cell A2.

7. MAX & MIN: The MAX and MIN functions help in finding the maximum number and the
minimum number in a range of values.

=MIN(number1, [number2], …)

Example:

=MIN(B2:C11) – Finds the minimum number between column B from B2 and column C
from C2 to row 11 in both columns B and C.

=MAX(number1, [number2], …)

Example:

=MAX(B2:C11) – Similarly, it finds the maximum number between column B from B2 and
column C from C2 to row 11 in both columns B and C.
 Explain pivot table with example.

A pivot table is a powerful data summarization tool that can automatically sort, count, and
sum up data stored in tables and display the summarized data. Pivot tables are useful to
quickly create crosstabs (a process or function that combines and/or summarizes data from
one or more sources into a concise format for analysis or reporting) to display the joint
distribution of two or more variables.

Three key reasons for organizing data into a pivot table are:

 To summarize the data contained in a lengthy list into a compact format.

 To find relationships within the data that are otherwise hard to see because of the
amount of detail.
 To organize the data into a format that’s easy to read

Introduction of Excel (rows and Columns and functions)

MS Excel, a powerful spreadsheet software, utilizes this grid-like structure to organize and
analyse data effectively. Rows, represented by horizontal divisions, traverse the spreadsheet
from top to bottom, while columns, represented by vertical divisions, extend from left to
right. Excel represents datasets in a tabular format. In this tabular format. These tables
comprise Row and Column. We need rows and columns to define the location of the data in
the spreadsheet. The article covers Row and Column in Excel

Prepare a Marks list for 40 students and find percentage, grade through
nested if Condition?
Step 1:Marks of 40 students

Step 2:Total of all subject marks

Step3:Condition If to calculate the Grade. =IF(I3>85,"A",IF(I3<85,"B"))

Step4:To count Grade(=COUNTIF(J3:J42,M3))
Find The net salary on the basis of Following data
Prepare a sales report of the following automobile companies.
 Introduction of Ms PowerPoint and its features

MS PowerPoint is a program that is covered in the Microsoft Office suite and is bundled
unitedly with Word, Excel, and other office productivity tools. Microsoft PowerPoint is a
powerful slide show presentation program. MS PowerPoint applies slides to communicate
information rich in multimedia

Features of MS PowerPoint

PowerPoint Design Ideas: It can be found in the “Design” tab in the PowerPoint Ribbon. You
can choose the desired design for your PPT.

Animations: MS PowerPoint animations helps you to emphasize certain points of your

present There are primarily 3 categories of animations in PPT.

 Entrance Animation
 Emphasis Animation
 Exit Animations

Each animation category gives you a list of additional options to choose from.

Slide Transitions: While animation allows you to animate elements within your slide,
transitions allows you to change how slides change from one to another. This can have a
remarkable impact on a slide’s first impressions. Some of the most important transitions are:

 Cut
 Reveal
 Shapes
 Uncover
 Wipe

Images: There are two main ways of adding images. You could either add an image from
your Personal Computer or you can embed an image from the internet.

Merge Shapes: MS PPT allows you to merge shapes. This is because you might not always
have the exact shape that you are looking for.

Videos: Videos can be easily added from the storage on your Personal Computer. Videos can
also be selected from the internet.

Icons: With the feature to add icons into your presentations, it just gives you some freedom to
add a personal touch to the presentation
Make a Power point presentation Topic on “Introduction of OSI model”.