S.

NO TOPIC PAGE SIGNATURE

NO.
1 INTRODUCTION
TO OS
2 INTRODUCTION
TO MS WORD
3 TO WORK
WITH MACROS
4 TO WORK
WITH
BOOKMARK
5 TO WORK
WITH
MAILMERGE
6 INTRODUCTION
TO MS EXCEL
7 Preapare an excel
sheet wit mail
merge
8 To work with
What if Analysis
Tool
9 Introduction To
MS PowerPoinT
10 Present a
Presentation In
POWER POINT
PRACTICLE - 1
INTRODUCTION TO OS:
An operating system (OS) is a crucial piece of software that manages computer
hardware and provides services for computer programs. It acts as an
intermediary between the hardware and the user applications, ensuring efficient
and organized utilization of resources.

The following is a brief introduction to the key functions and components

of an operating system:
Resource Management:
Processor Management: The OS allocates CPU time to different programs,
ensuring fair and efficient execution.
Memory Management: It manages the computer's memory, allocating and
deallocating space for programs and data.
File System Management: The OS organizes and controls access to files on
storage devices.
Process Management:
Process Scheduling: The OS determines the order in which processes run,
optimizing CPU utilization and responsiveness.
Interprocess Communication (IPC): It facilitates communication and data
exchange between different processes.
Device Management:
I/O (Input/Output) Management: The OS controls communication between
the computer and its peripherals, such as keyboards, printers, and storage
devices.
Device Drivers: These are specialized programs that enable the OS to
communicate with specific hardware devices.
User Interface:
Command-Line Interface (CLI): Users interact with the OS by entering text
commands.
Graphical User Interface (GUI): OS provides a visual interface with icons,
windows, and menus for user interaction.
Security and Protection:
User Authentication: The OS ensures that only authorized users can access the
system.
Access Control: It manages permissions and restricts access to files and
resources.
Encryption: Some OSs provide features to secure data through encryption.
File System:
File Organization: The OS manages how data is stored, organized, and
retrieved on storage devices.
PRACTICLE - 2
INTRODUCTION TO MS WORD:
Microsoft Word is a widely used word processing application developed by
Microsoft. It is a part of the Microsoft Office suite of productivity software.
Word is designed to help users create, edit, format, and print documents,
ranging from simple letters and memos to complex reports and manuscripts.

Here's an introduction to some of the key features and functions of

Microsoft Word:
Word Processing:
Document Creation: Word allows users to create new documents from scratch
or use templates for common document types.
Text Editing: Users can enter, edit, and format text using a variety of fonts,
styles, and formatting options.
Formatting Tools:
Font and Paragraph Formatting: Word provides extensive options for
formatting text, including font type, size, color, and paragraph alignment.
Styles and Themes: Users can apply predefined styles and themes to maintain a
consistent look throughout a document.
Page Layout:
Margins and Orientation: Users can set page margins, adjust page orientation
(portrait or landscape), and control page size.
Headers and Footers: Word allows the inclusion of headers and footers for
information that appears at the top or bottom of each page.
Graphics and Multimedia:
Inserting Images: Users can easily insert images, illustrations, and other
graphics into their documents.
SmartArt and Charts: Word supports the creation of visual elements like
SmartArt diagrams and charts.
Tables and Columns:
Table Creation: Word allows the creation and formatting of tables for
organizing and presenting data.
Columns: Users can divide a page into multiple columns for a newspaper-like
layout.
Review and Collaboration:
Spell Check and Grammar Check: Word includes proofing tools to help users
check for spelling and grammar errors.
Track Changes: Users can track changes made to a document, making
collaboration and reviewing easier.
Document Management:
Saving and Opening Documents: Word supports various file formats, and users
can save documents in formats compatible with different versions of Word.
Document Properties: Users can add metadata and properties to documents for
better organization and identification.
Mail Merge:
Mail Merge Functionality: Word allows users to create personalized
documents by merging a document with a data source, such as a spreadsheet.
Integration with Other Office Applications:
Integration with Excel and PowerPoint: Word seamlessly integrates with other
Microsoft Office applications for enhanced productivity.

RESUME:
RESUME
MANNAN SHARMA

B.C.A. Ist Year

☎+919806253117

@ [email protected]

EDUCATION QUALIFICATION

10th PASS OUT FROM C.B.S.E. BOARD IN MATHS,HINDI,ENGLISH,SOCIAL STUDIES,SCIENCE.

12th PASS OUT FROM ARTS IN ECONOMICS,ENGLISH,POLITICAL SCIENCE,HISTORY AND PHYSICAL

EDUCATION.

 HAVE EFFICIENT AND EFFECTIVE KNOWLEDGE IN THE FIELD OF POLITICS AND ECONOMICS.
 WELL KNOWN ABOUT THE LACKINGS IN THESE FIELDS WHICH ARE TILL NOW KNOWN TO ME.

PROFESSIONAL QUALIFICATION

 BASIC KNOWLEDGE OF COMPUTER

WORKING EXPERIENCE

 FRESHER

PERSONAL PROFILE

 DATE OF BIRTH – 8th FEBRUARY,2005

 LANGUAGES KNOWN – HINDI & ENGLISH
 NATIONALITY – INDIAN
 HOBBIES – TECHNOPHILE

DATE – SEPTEMBER Ist ,2023

PLACE – VAISH COLLEGE OF ENGINEERING

PRACTICLE - 3
TO WORK WITH MACROS:
Working with macros in Microsoft Word allows you to automate repetitive
tasks by recording a series of actions or by writing custom code. Macros can be
particularly useful for streamlining processes and increasing efficiency.

Here's a basic guide on how to work with macros in Microsoft Word:

Recording a Macro:
Enable Developer Tab:
Open Microsoft Word.
Go to "File" > "Options."
In the Word Options dialog, select "Customize Ribbon."
Check the "Developer" option in the right column.
Click "OK" to enable the Developer tab.
Record a Macro:
Click on the "Developer" tab.
In the "Code" group, click on "Record Macro."
In the "Record Macro" dialog:
Enter a name for your macro.
Choose where to store the macro (in the document, template, or all documents).
Optionally, assign a shortcut key.
Click "OK" to start recording.
Perform Actions:
Perform the actions you want to record in the document.
Stop Recording:
Click on the "Developer" tab.
In the "Code" group, click on "Stop Recording."
Running a Macro:
Open the Developer Tab:
If it's not already open, go to "File" > "Options" > "Customize Ribbon" and
make sure the "Developer" option is selected.
Run a Macro:
Click on the "Developer" tab.
In the "Code" group, click on "Macros."
Select the macro you want to run.
Click "Run."
Editing a Macro:
Open the Developer Tab:
If it's not already open, go to "File" > "Options" > "Customize Ribbon" and
make sure the "Developer" option is selected.
Edit a Macro:
Click on the "Developer" tab.
In the "Code" group, click on "Macros."
Select the macro you want to edit.
Click "Edit."
Modify the Code:
The Visual Basic for Applications (VBA) editor will open.
Modify the code as needed.
Close the editor when you're done.
Assigning a Macro to a Button (Optional):
Open the Developer Tab:
If it's not already open, go to "File" > "Options" > "Customize Ribbon" and
make sure the "Developer" option is selected.
Insert a Button:
Click on the "Developer" tab.
In the "Controls" group, click on "Insert."
Under "Form Controls," choose "Button (Form Control)."
Draw the button on your document.
Assign the Macro:
In the "Assign Macro" dialog, select the macro you want to assign.
Click "OK."
Run the Macro:
Click on the button to run the assigned macro.
PRACTICLE - 4
TO WORK WITH BOOKMARKS:
Bookmarks in Microsoft Word are useful for marking specific locations or
content within a document, making it easy to navigate or reference specific
points.

Here's a guide on how to work with bookmarks in Word:

Creating Bookmarks:
Select Text:
Highlight the text or position the cursor at the location you want to bookmark.
Insert a Bookmark:
Go to the "Insert" tab on the Ribbon.
In the "Links" group, click on "Bookmark."
In the "Bookmark" dialog box, enter a name for your bookmark (no spaces
allowed).
Click "Add."
Click "Close" to exit the dialog.
Navigating to Bookmarks:
Go to the "Insert" Tab:
To jump to a bookmark, go to the "Insert" tab on the Ribbon.
Click on "Bookmark":
In the "Links" group, click on "Bookmark."

Select the Bookmark:

In the "Bookmark" dialog box, you'll see a list of existing bookmarks. Select the
one you want to navigate to.
Click "Go To."
Use Hyperlinks:
You can also create hyperlinks that point to bookmarks. Select the text or object
you want to turn into a hyperlink.
Right-click and choose "Hyperlink" from the context menu.
In the "Insert Hyperlink" dialog, choose "Place in This Document" on the left.
Select the bookmark you want to link to.
Click "OK" to create the hyperlink.
Editing or Deleting Bookmarks:
Go to the "Insert" Tab:
To manage bookmarks, go to the "Insert" tab on the Ribbon.
Click on "Bookmark":
In the "Links" group, click on "Bookmark."
Select a Bookmark:
In the "Bookmark" dialog box, select the bookmark you want to edit or delete.
Edit or Delete:
To edit, change the bookmark name and click "Add" (it will overwrite the
existing bookmark).
To delete, click "Delete."
Click "Close" when you're done.
PRACTICLE - 5
TO WORK WITH MAILMERGE:
Mail Merge in Microsoft Word is a powerful feature that allows you to create
personalized documents, such as letters, envelopes, labels, or emails, by
merging a main document (template) with a data source. The data source can be
a Microsoft Excel spreadsheet, a Microsoft Access database, or even a list

created within W ord itself.

Here's a step-by-step guide on how to work with Mail Merge in Microsoft

Word:
Step 1: Open Microsoft Word and Start Mail Merge
Open Microsoft Word:
Launch Microsoft Word on your computer.
Select Mailings Tab:
Go to the "Mailings" tab on the Ribbon.
Start Mail Merge:
Click on the "Start Mail Merge" button and choose the type of document you
want to create (e.g., Letters, Envelopes, Labels).
Step 2: Select Recipients
Select Recipients:
Click on the "Select Recipients" button in the Mailings tab.
Choose a Data Source:
Choose the type of data source you have (e.g., Use an Existing List, Select from
Outlook Contacts, Type a New List).
If you're using an existing list, browse and select your data source file.
If you're typing a new list, enter the data directly into the Mail Merge Recipients
dialog.
Step 3: Insert Merge Fields
Insert Merge Field:
Click on the "Insert Merge Field" button in the Mailings tab.
Choose Fields:
Select the fields from your data source that you want to include in your
document.
These fields will be replaced with actual data when you complete the merge.
Insert More Fields:
Repeat the process to insert additional merge fields as needed.
Step 4: Preview the Document
Preview Results:
Click on the "Preview Results" button in the Mailings tab.
This allows you to see how the document will look with actual data.
Navigate Records:
Use the arrows to navigate through different records in the data source and
preview how the document changes.
Step 5: Complete the Merge
Finish & Merge:
Once you're satisfied with the preview, click on the "Finish & Merge" button.
Choose Merge Options:
Choose "Print Documents" or "Send Email."
If you're printing, you can choose to print all documents or a specific range.
If you're sending emails, you'll need to configure your email settings.
Complete the Merge:
Follow the prompts to complete the merge process.
If you're printing, Word will generate a new document with merged
information.
If you're sending emails, Word will prompt you to complete the merge and send
the emails.
PRACTICLE - 6
INTRODUCTION TO MS EXCEL:
Microsoft Excel is a powerful spreadsheet application developed by Microsoft.
It is a part of the Microsoft Office suite of productivity software and is widely
used for various purposes, including data analysis, calculation, visualization,
and reporting. Excel provides a grid interface called a worksheet, where data is
organized into rows and columns.
Here's an introduction to some key features and functions of Microsoft
Excel:
Worksheets and Workbooks:
Worksheet: A single sheet within Excel where you can enter and manipulate
data. It consists of cells organized in rows and columns.
Workbook: A collection of one or more worksheets. When you open Excel, a
new workbook is created, and you can add or remove sheets as needed.
Cells, Rows, and Columns:
Cell: The intersection of a row and a column. Each cell can contain data,
formulas, or functions.
Row: A horizontal collection of cells identified by numbers (1, 2, 3, ...).
Column: A vertical collection of cells identified by letters (A, B, C, ...).
Data Entry and Formatting:
Entering Data: You can type text, numbers, or dates directly into cells.
Formatting Cells: Excel provides a wide range of formatting options, including
font styles, colors, cell borders, and number formats.
Formulas and Functions:
Formulas: Excel allows you to perform calculations using formulas. Formulas
start with an equal sign (=) and can include mathematical operations, cell
references, and functions.
Functions: Excel has a vast library of built-in functions that perform specific
calculations or operations. Examples include SUM, AVERAGE, IF,
VLOOKUP, and many more.
Data Analysis and Visualization:
Charts and Graphs: Excel enables you to create various types of charts and
graphs to visualize data trends and patterns.
Filtering and Sorting: You can easily filter and sort data to analyze specific
subsets of information.
PivotTables: PivotTables are powerful tools for summarizing and analyzing
large datasets.
Data Import and Export:
Importing Data: Excel allows you to import data from external sources, such
as databases, text files, and web data.
Exporting Data: You can save Excel files in various formats and export data to
other applications.
Collaboration and Sharing:
Comments: Users can add comments to cells for collaboration and
communication.
Sharing and Collaboration: Excel supports real-time collaboration through
cloud services like Microsoft 365, allowing multiple users to work on a
document simultaneously.
Macros and Automation:
Macros: Excel allows you to automate repetitive tasks using macros, which are
recorded sequences of actions or custom scripts written in Visual Basic for
Applications (VBA).
Conditional Formatting:
Conditional Formatting: You can apply formatting rules based on cell values,
making it easier to highlight important information.
Security and Protection:
Password Protection: Excel provides options to password-protect worksheets
and workbooks for security.
PRACTICLE-7
Preapare an excel sheet with mail merge:

WHAT ARE CHARTS IN MS EXCEL

A chart is a visual representation of data in the form of bars, lines, pies and so much more. Displaying
the data in an organized way helps the team to come up with business decisions faster. Charts help us
to summarize a relationship between the numerical values, business patterns, trends that might go
unnoticed if there were just numerical values used to represent them.

COMPONENTS OF CHARTS IN MS EXCEL

 Vertical/Value Axis – It has the data series representing values. There are two vertical
axes in the above graph i.e. one for income and the other for profit percentage. This is so
because if we tried plotting the profit and income on one axis, the profit line might not even
be visible.

 Horizontal/Category Axis – This represents the category for each data entry. In above
example, it is month.

 Legends – A chart with two data series ( profit % and income ) is appropriate but for that
excel assigns a different color scheme to both of them that are called legends.

 Chart Title – The name can be used to imply to the worker that what type of information
the chart displays.
PRACTICLE - 8
To work with What if Analysis Tool:
Consolidation Data Tool :
Consolidating data in Excel involves combining information from multiple
worksheets or ranges into a single summary worksheet. This can be particularly
useful when you have data spread across different sheets or workbooks and
want to create a unified view for analysis or reporting purposes.
Consolidate Function:
The Consolidate function in Excel allows you to combine data from multiple
ranges into a summary range.
You can choose data, various consolidation methods, including sum, average,
count, etc., depending on the type of data you're working with.
This method is ideal for summarizing data that's arranged in a consistent format
across the different sheets or ranges
Steps to Consolidate Data:
1. Select the sheet where the consolidated data will be placed.
2. Click the cell in the worksheet where you want to place the consolidated data.
3. Click the Data tab on the ribbon.
4. Click the Consolidate Data button in the Data Tools group.
Now, Consolidate dialog box appears. Here you can choose what you
want to do with the data, like find the sum, count, or average.
 5. Select a function from the list. If source data is in a different
workbook,
click Browse to locate the file and click OK.
6. Click the Collpase Dialog Box button.

7. Navigate to the worksheet with the set of data to be consolidated.

8. Select the data you want to include in the consolidation.
9. Click the Expand Dialog Box button.
10. After Browse.. and selecting the sheet or whether you want to add the data .
11. Click the relevant labels that you want to add onto
12. Hit OK, and you are Set To Go .
13. Here, is the merged final data below:
PRACTICLE – 9
Introduction To MS PowerPoint:
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.

WHAT IS POWERPOINT USED FOR?

Microsoft PowerPoint or MS PowerPoint is useful in; Creating Presentation,

where one can add animation, photos, videos, and sound effects making it more
readable. Under this article, we will study in detail Microsoft PowerPoint, the
features and functions of PowerPoint presentation, followed by a layout on how
to work with MS PowerPoint, with the advantages and more.

What is a PowerPoint Presentation?

The demand Microsoft PowerPoint is great presentation software designed by

Microsoft sometimes abbreviated as PP or PPT. PowerPoint is well utilized to
create a slideshow of valuable information through charts, and images for a
presentation. It is commonly practiced in business and school presentations.

1. It is an absolute presentation graphics package that gives you everything

needed to create a professional-looking presentation. PowerPoint offers
word processing, drawing, outlining, graphing, and presentation
management tools.

2. PowerPoint was developed by Dennis Austin and Thomas Rudkin at a

software company named Forethought Inc. It was thought to be identified
as Presenter, but due to trademark issues was renamed PowerPoint in
1987.

3. The first iteration of PowerPoint was released collectively with Windows

3.0 in 1990.

4. The initial version of PowerPoint only allowed slide progression in one

direction i.e forward and the amount of customization was somewhat
limited.
 5. Progressively, with every version, the program was more creative and
more interactive. Numerous other characteristics were also added in
PowerPoint in the later versions which massively increased and use of
this MS Office program.

6. The default file extension of a PowerPoint presentation is “ppt”.

7. It is a presentation-based program comprising slides that use graphics,

videos, and other features to make a presentation more interactive and
interesting.

Features Of MS PowerPoint

MS PowerPoint is an application that allows users to create slides and runs a

slideshow.

Home: Firstly, in PowerPoint, there are slides. Users need to add content to
them to make a presentation. From the Home menu, users can add new slides,
decide their sequence, layout, design & other word processing functions like
font change, size change, etc. PowerPoint layout is used to change the layout of
the current slide.

Insert: From the Insert menu, the user can add media like pictures, symbols,
audio, video, header, footer, shapes, etc. to the slides to enhance the user’s
presentation.

Design: The design menu offers the user with ready-made templates &
background designs for slides that make the presentation look very attractive.

Slideshow: Finally, from the Slideshow menu, the user can view the final form
of the slideshow. Users can start the slideshow from the first slide or the slide
that users are editing. They can also set display time for each slide from the
‘Slideshow’ menu.

Animations: During the slide show, the slides emerge on the screen one after the
other. In case, one desires to add some animations to how a slide displays itself,
they can refer to the “Animations” category.

Review tab: The various tools that one can use under this tab are; Spelling,
Research, Thesaurus, Translate, Language. The Research button aids in online
research in books and Internet resources about a subject or topic you are
working on.