PC SOFTWARE – MS OFFICE (PRACTICAL)
MS OFFICE WORD
Ex. No. 1
Type a passage (A4 Page, Times New Roman Font Style, 12 Font Size). Save your
document in a specified location. Say, D:\BBA\MSOffice\.docx). Save the same file with
other name in different location using Save As dialogue box and also open and view the
document saved.
Aim:
To Type a passage (A4 Page, Times New Roman Font Style, 12 Font Size). Save your
document in a specified location. Say, D:\BBA\MSOffice\.docx). Save the same file with other
name in different location using Save As dialogue box and also open and view the document
saved.
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office Word Blank Document.
3. Type a passage with Times New Roman Font Style and 12 Font Size.
4. To change the page size, Layout Size Select A4 Size.
5. To save a document, click File Save Select D Drive RIGHT CLICK New
Folder. Rename folder as BBA, RIGHT CLICK Rename. Inside the folder
BBA, RIGHT CLICK New Folder. Rename folder as MS Office, RIGHT
CLICK Rename. Give File name “Ex1” and save as type “Word Document”.
Click Save.
6. To save the same document in different location, Click Save As Select Location
Give File Name and Save as Type Click Save.
7. To open the document, Click File Open Select the document from the location
Double Click the Document.
8. Stop the Process.
Ex. No. 2
Type a simple matter, check spelling and grammar (Use Auto Correct and Auto Text
Features), Bullets and Numbering list items, align the text to left, right, justify and Centre.
Aim:
To type a simple matter and check the spelling and grammar. Add Bullets and
Numbering using the icons. Align the content using the icons.
Algorithm:
1. Start the process.
2. Type the content in a document.
3. For Spelling and Grammar Check, Click Review Spelling & Grammar.
4. For AutoCorrect, Click File Options Proofing AutoCorrect Options
Enable Replace Test as you Type Give the word in Replace and With Options
Click Add Ok.
5. For AutoText, Click Insert Quick Parts AutoText Type the contents in
dialogue box Click Ok.
6. For Bullets or Numbering, Home Paragraph Bullets or Numbering Select
the format.
7. For Alignment, Home Paragraph Alignment Icons Select Left, Right,
Centered or Justify.
8. Save the Document.
9. Stop the process.
Ex. No. 3
Prepare a neatly aligned, error free document, add Header and Footer, also perform find
and replace operation and define bookmarks.
Aim:
To prepare a neatly aligned document. To add Header and Footer also to perform find and
replace operation.
Algorithm:
1. Start the process.
2. Type a document with neat alignment.
3. For Header, Click Insert Header Select the format or Edit Header Add the
Content relevant to the document.
4. For Footer, Click Insert Footer Select the format or Edit Footer Add the
Content.
5. For Find and Replace, Click Home Replace Give the Content in “Find what”
and “Replace with” Click Replace all.
6. For Bookmarks, Click Insert Links Bookmark. Under Bookmark name, type
a name and click Add. Click Ctrl+G to open the Go To tab in the Find and
Replace box. Under Go to what, click Bookmark. Select the bookmark name, and
then click Go To.
7. Save the Document.
8. Stop the Process.
Ex. No. 4
Write any 10 Management Quotes and the change the Font Style, Color, Size of each
sentence. Make each one different than previous and next.
Aim:
To change the font style, color and size of each sentences.
Algorithm:
1. Start the process.
2. Type a document with 10 different Management Quotes.
3. For Font Style, Home Font Style or Ctrl+Shift+F Select the Style.
4. For Font Size, Home Font Size or Ctrl+Shift+P Select the Size.
5. For Font Color, Home Font Color Select the Color.
6. Save the Document.
7. Stop the Process.
Ex. No. 5
Prepare a Job Application letter enclosing your bio-data (with neat alignment and using
tab setting).
Aim:
To prepare a Job Application letter along with Bio-data using tab setting.
Algorithm:
1. Start the process.
2. Prepare a Job Application Letter and resume with Neat Alignment and Content.
3. For Resume template, All Programs MS Office MS Office Word Select any
one Resume Template.
4. Save the Document.
5. Stop the process.
Ex. No. 6
Take a Double Column Newspaper and Design or create similar paragraph style in the
word document.
Aim:
To design a Double Column Newspaper.
Algorithm:
1. Start the process.
2. For Double Column Newspaper, Click Layout Columns Select Two.
3. Type the News for One Page along with Relevant Images.
4. Save the Document.
5. Stop the Process
Ex. No. 7
Design a eBook Cover Pages/ Magazine/ Books Front/Back Page using Cover Page option
in Insert Menu. You can assume your college or department in-house magazines.
Aim:
To design a Cover Page for Department Magazine.
Algorithm:
1. Start the process.
2. For Cover Page designing, Insert Cover Page Select the design.
3. Add the Content related to Department Magazine.
4. Save the Document.
5. Stop the Process
Ex. No. 8
Create Business Cards using Shapes, text and colors. Assume your own company and
simply try out a logo too for the same.
Aim:
To design a Business Card.
Algorithm:
1. Start the Process.
2. For Shapes, click Insert Shapes Select any one design Drag the Mouse.
3. Add the content for the Business Card.
4. Save the document.
5. Stop the Process.
Ex. No. 9
Use smart art and create organization charts with at least 3 levels.
Aim:
To create an Organization Chart using Smart Art.
Algorithm:
1. Start the process.
2. Click Insert Smart Art Hierarchy Select 3 level chart.
3. Add the organization hierarchy from top level management to low level management.
4. To add box, Select the box Add Shape Select where you want to add.
5. Save the document
6. Stop the process.
Ex. No. 10
Make books content page or index page (first line indent, hanging indent and the perfect
use of ruler bar.
Aim:
To design an Index Page.
Algorithm:
1. Start the Process.
2. Design an Index Page using the ruler.
3. To enable rules, Click View Ruler.
4. Design and save the document.
5. Stop the process.
Ex. No. 11
Insert Image into the shape. Type a title for the page and apply styles to the same.
Aim:
To insert Image into the Shape.
Algorithm:
1. Start the Process.
2. For Shapes, click Insert Shapes Select any one design Drag the Mouse.
3. Select the Shape Right Click Add Text Insert Picture Select the
picture Click Ok.
4. Give the title relevant to the picture.
5. Save the document.
6. Stop the Process.
Ex. No. 12
Write at least dozen mathematical/statistical formulae known to you and key the same in
MS Word.
Aim:
To create mathematical/statistical formulae in MS Word.
Algorithm:
1. Start the process.
2. For Formula, Click Insert Symbols Equation Select the Structure and type
the equation.
3. Type at least 12 Mathematical/Statistical Formulae.
4. Save the document.
5. Stop the Process.
Ex. No. 13
Type at least one A4 Page with relevant matter to demonstrate superscript and subscript,
special characters (Such as temp ⁰C, rupee symbol, Etc.)
Aim:
To demonstrate Superscript, Subscript and Special Characters.
Algorithm:
1. Start the Process.
2. Type the content with Superscript, Subscript and Special Characters.
3. For Superscript, Home Click the icon X2.
4. For Subscript, Home Click the icon X2.
5. For Special Characters, Click Insert Symbols Symbol.
6. Save the document.
7. Stop the process.
Ex No. 14
Type at least two page of A4 page in 12 size font. Select a sentence in the same and bring
the same in the text box. Place the text box inside the text and wrap the main text around
the text box.
Aim:
To insert text box within the text.
Algorithm:
1. Start the process
2. Type a two-page content in A4 Page with 12 Font Size.
3. To insert Text Box, Click Insert Text Box Select the Design.
4. Copy a sentence from text and paste inside the Text Box.
5. Save the document.
6. Stop the process.
Ex. No. 15
Create a table in MS Excel with an Address (List containing Designation, Name of the
Company, Address, Place, PIN). Let it have ten addresses. Use this list for mail merges in
a letter developed using MS Word.
Aim:
To develop letter using Mail Merge.
Algorithm:
1. Start the Process.
2. Create an Address Database in MS Excel with the fields Designation, Name of the
Company, Address, Place and PIN.
3. Type a Letter.
4. For mail merge, Mailings Select Recipient Use an Existing List Select the
Address Database.
5. To insert fields in To Address, Click Mailings Insert Merge Field.
6. Click Finish & Merge to develop letter with 10 addresses given in the Excel.
7. Save the document.
8. Stop the Process.
MS OFFICE POWERPOINT
Ex. No. 1
Have a PowerPoint presentation for a seminar which you are handling for your
classmates.
Aim:
To prepare PowerPoint Presentation for a seminar
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office PowerPoint.
3. To insert New Slide, Click Home New Slide Select Type of the Slide.
4. To changed Design of the Slides, Click Design Select the Design.
5. Enter the Content for Seminar.
6. Save the PowerPoint.
7. Stop the Process.
Ex. No. 2
Design an advertisement campaign with minimum three slides.
Aim:
To design a Presentation for an Advertisement Campaign.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office PowerPoint.
3. To insert New Slide, Click Home New Slide Select Type of the Slide.
4. To changed Design of the Slides, Click Design Select the Design.
5. Enter the content about 3 Slides for Advertisement Campaign.
6. Save the PowerPoint.
7. Stop the Process.
Ex. No. 3
Prepare a power point presentation with at least three slides for Department inaugural
function
Aim:
To prepare a PowerPoint Presentation for Department Inaugural Function.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office PowerPoint.
3. To insert New Slide, Click Home New Slide Select Type of the Slide.
4. To changed Design of the Slides, Click Design Select the Design.
5. Enter the Content about Department Activities for Department Inaugural Function.
6. Save the PowerPoint.
7. Stop the Process.
Ex. No. 4
Prepare slides with various features such as charts from Excel, clip arts from hard disc,
and animated themes to demonstrate your expertise in using various features included in
MS PowerPoint.
Aim:
To insert Excel, Clip Arts and Animation in PowerPoint.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office PowerPoint.
3. To insert New Slide, Click Home New Slide Select Type of the Slide.
4. To changed Design of the Slides, Click Design Select the Design.
5. To insert Charts from Excel, Click Insert Object Select Create from File
Browse Select the Excel File from the Location Enable Link Click Ok.
6. To insert Clip Art, Click Insert Pictures Online Pictures Select the Picture
Insert.
7. For Animation, Click Animation Select the type of Animation for the objects.
8. Save the PowerPoint.
9. Stop the Process.
MS OFFICE EXCEL
Ex. No. 1
Create an excel worksheet containing monthly Sales Details of five companies.
Aim:
To create an excel worksheet containing Monthly Sales Details of Five Companies.
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office Excel.
3. Create an excel containing monthly sales details of five companies.
4. Calculate the Annual Sales of all the companies.
5. Save the Workbook
6. Stop the process.
Ex. No. 2
Prepare a list of students with their marks out of 1200. Find the percentage. Count how
many scored more than 60%. Also count the number of students secured between 50%
and 60% and create a chart to depict clearly.
Aim:
To find the percentage and count the number of students secured more than 60% and
between 50% and 60% using the students mark statement out of 1200. To create a chart to
depict clearly.
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office Excel.
3. Prepare a Students Mark Statement out of 1200 marks.
4. Find the total using the formula, Sum(). Example - =Sum(D2:I2).
5. Find the percentage using the formula, =Total/1200*100.
6. Count the number of students scored more than 60% using the formula,
=countif(K2:K21, “>60”).
7. Count the number of students scored marks between 50% and 60% using the formula,
=countifs(K2:K21, “>50”, K2:K21, “<60”).
8. To create a chart, Select the table, Click Insert Chart Select the type of Chart.
9. Save the Workbook.
10. Stop the process.
Ex. No. 3
Enter the name, relationship and date of birth of your family members and relatives in a
MS Excel worksheet. Calculate their age as of today and arrange them either in
descending or ascending order. (ensure to have at least ten entries). Assuming their weight
(kg) and height (cm), find out their BMI by using formula.
Aim:
To calculate age and BMI.
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office Excel.
3. Enter the name, relationship and date of birth of your family members in Excel Sheet.
4. To calculate their age as of today using the formula, =datedif(DOB, Today(), “Y”).
5. To calculate BMI using the formula, Height/Weight2.
6. Save the Workbook.
7. Stop the process.
Ex. No. 4
Create a table of your friends with their mobile number and mail id. Also add their date
of birth. Find out the number of days left to celebrate their birthday and arrange their
names in this order. Create a pie chart indicating the number of birth days in each month.
Aim:
To find number of days left to celebrate birthday.
Algorithm:
1. Start the process.
2. Click All Program MS Office MS Office Excel.
3. Enter the name, mobile number, mail address and DoB of your friends.
4. To calculate number of days left to celebrate their birthday, enter todays date and next
birthday of your friend, =datedif(todays date, next birthday, “d”).
5. Count the number of members celebrating birthday month wise, select the table and
create a pie chart.
6. Save the Workbook.
7. Stop the process.
MS OFFICE ACCESS
Ex. No. 1
Use simple commands to perform sorting on name, designation, department and mobile
number of employee’s database and Address printing using label format.
Aim:
To create Employee’s Database and Address Printing using Label format.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office Access Enter File name Select
the Location Click Create.
3. Create a table for Employees Database in design view.
4. For Address Printing using Label format, Click Labels Select the format for Label
Click Next Place the fields as per Address Format Click Next Click
Finish.
5. Save the Database.
6. Stop the process.
Ex. No. 2
Create an Access database named Student_Records.accdb. Assume the required data.
Open the Students table in datasheet view and enter the new students either by navigating
to the empty field or using the 'New record' button.
Aim:
To create Students Database.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office Access Enter File name Select
the Location Click Create.
3. Create a table for Student Database in design view.
4. Enter the Students Details in Datasheet View.
5. Save the Database.
6. Stop the process.
Ex. No. 3
Create a form to enter inventory related data of a supermarket and generate stock
report at the end of the day.
Aim:
To create form and generate stock report at the end of the day.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office Access Enter File name Select
the Location Click Create.
3. Create a table for Inventory Data in design view.
4. To create a form, Click Form Wizard Enter the fields Click Next Select the
form design Click Next Click Finish.
5. Enter the data using form.
6. To generate a report, click Report Wizard Enter the fields Click Next Select
the Report design Click Next Click Finish.
7. Save the Database.
8. Stop the Process.
Ex. No. 4
Create an Address Database of the companies in your area. Design a form to enter new
data into the database.
Aim:
To create form for Companies Database.
Algorithm:
1. Start the Process.
2. Click All Program MS Office MS Office Access Enter File name Select
the Location Click Create.
3. Create a table for Company Data in design view.
4. To create a form, Click Form Wizard Enter the fields Click Next Select the
form design Click Next Click Finish.
5. Enter the data using form.
6. Save the Database.
7. Stop the Process.