INDEX

Sr. Title Page

No. No.

SECTION- A
MS- WORD
1. Text Manipulation: Write a paragraph about your institution and Change the
font size and type, Spell check, Aligning and justification of Text

2. Bio data: Prepare a Bio-data.

3. Find and Replace: Write a paragraph about yourself and do the following. Find
and Replace - Use Numbering Bullets, Footer and Headers.

4. Tables and manipulation: Creation, Insertion, Deletion (Columns and Rows).

Create a mark sheet.
5. Mail Merge: Prepare an invitation to invite your friends to your birthday party.
Prepare at least five letters.

SECTION- B
MS- EXCEL

6. Data sorting-Ascending and Descending (both numbers and alphabets)

7. Mark list preparation for a student.
8. Individual Pay Bill preparation.
9. Invoice Report preparation.
10. Drawing Graphs. Take your own table

SECTION- C
MS- POWER POINT PRESENTATION
11. Create a slide show presentation for a seminar
12. Preparation of Organization Charts
 SECTION- A
MS- WORD
Q.1. Text Manipulation: Write a paragraph about your institution and Change the font size
and type, Spell check, Aligning and justification of Text

ANS-
My institution, VEER BAHADUR SINGH PURVANCHAL UNVERSITY (A state run university
stablished on 2nd Octobere 1987), is a leading academic institution that offers a wide range of undergraduate
and graduate programs. Our faculty comprises experts in their respective fields who are committed to
providing students with a rigorous and engaging education. With state-of-the-art facilities and a vibrant
campus community, VEER BAHADUR SINGH PURVANCHAL UNVERSITY, is dedicated to fostering
an environment of intellectual curiosity and academic excellence.

My university in located in Jaunpur, a historical and beautiful city of Uttar Pradesh.

To manipulate the text in Microsoft Word,

we can use several tools to improve its presentation and readability.

Firstly, we can change the font size and type to make the text more visually appealing. We can do
this by selecting the text and then clicking on the "Font" option in the "Home" tab. From there, we can
choose the font type and size that we prefer.

Next,

we can spell-check the paragraph to ensure that there are no spelling errors. This can be done by clicking on
the "Review" tab and then selecting "Spelling & Grammar." The software will then scan the text and
highlight any spelling or grammatical errors, allowing us to make necessary corrections.

To align the text, we can use the "Alignment" option in the "Paragraph" section of the "Home" tab. This
will allow us to align the text to the left, center, or right of the page. We can also justify the text, which
will distribute the text evenly between the margins.

By using these text manipulation tools in Microsoft Word, we can improve the presentation and readability
of our written work.
 Q.2. Bio data: Prepare a Bio-data.

BIO DATA

Name : UGRASEN YADAV

Father’s Name : RAMJANM YADAV
Date of Birth : 25/03/2000
Address : Village and Post - Sonadih
Dist. – Ballia, Pin code – 221715

Mobile No. : 9997232397

Email Id : [email protected]
Gender : Male
Marital Status : Unmarried
Category : General
Religion : Hindu
Nationality : Indian
Language known : Hindi, English, Sanskrit, Bhojpuri and Russian
Educational Qualification :
Examination Board / University Year of Passing Percentage Stream
High School UP Board 2017 71.5 Science
Intermediate UP Board 2019 79.4 Mathematics
Graduation VBSPU Jaunpur 2022 73.5 BCA

Hobbies : cooking. Reading books, planting, singing song, planting, and physical exercise.
Declaration : I hereby declare that all the information provided here is true to the best of my
knowledge.
Date : Signature:
 Q.3. Find and Replace: Write a paragraph about yourself and do the following. Find and
Replace - Use Numbering Bullets, Footer and Headers.

Objective:

To demonstrate the use of Find and Replace feature in MS Word to format a personal paragraph with
numbering bullets, header, and footer.

Task:

1. Open Microsoft Word and create a new document.

2. Type a brief paragraph about yourself. Include information such as your name, where you are from,
your interests, and your goals.
3. Use the Find and Replace feature to replace all instances of “I” with your name in the paragraph.
4. Use the numbering bullets feature to add numbers to the beginning of each sentence in the paragraph.
5. Create a header that includes your name and the date.
6. Create a footer that includes the page number.

Instructions:

1. Open Microsoft Word on your computer.

2. Click on “New Blank Document” to create a new document.
3. Type a brief paragraph about yourself. Use the following as a guide: “My name is UGRASEN
YADAV. I am from Ballia I am interested in reading and studing. My goal is to Politician.”
4. Use the Find and Replace feature to replace all instances of “I” with your name. a. Press Ctrl + H on
your keyboard or click on “Replace” in the “Editing” group on the “Home” tab. b. In the “Find and
Replace” dialog box, type “I” in the “Find what” field and your name in the “Replace with” field. c.
Click on “Replace All” to replace all instances of “I” with your name.
5. Use the numbering bullets feature to add numbers to the beginning of each sentence in the paragraph.
a. Select the entire paragraph by clicking and dragging your mouse over the text. b. Click on the
“Numbering” button in the “Paragraph” group on the “Home” tab. This will add a number to the
beginning of each sentence.
6. Create a header that includes your name and the date. a. Click on the “Insert” tab. b. Click on the
“Header” button and select a pre-designed header or select “Edit Header” to create your own. c. Type
your name and the date in the header. d. Close the header by double-clicking outside of it.
7. Create a footer that includes the page number. a. Click on the “Insert” tab. b. Click on the “Footer”
button and select a pre-designed footer or select “Edit Footer” to create your own. c. Click on the
“Page Number” button in the “Header & Footer” group on the “Design” tab and select a page number
style. d. Close the footer by double-clicking outside of it.
 Q.4. Tables and manipulation: Creation, Insertion, Deletion (Columns and Rows). Create a
mark sheet.

Introduction:

Tables are an essential element of any document that requires organizing data or presenting information in
a structured manner. MS Word offers several features to create, insert, and delete tables, and manipulate them
according to specific requirements. This assignment will cover the basics of creating, inserting, and deleting
columns and rows in a table and demonstrate how to create a mark sheet.

Creating a table:

To create a table in MS Word, follow these steps:

1. Place the cursor where you want to insert the table.

2. Select the “Insert” tab from the ribbon.
3. Click on the “Table” option and select the number of rows and columns you need.
4. The table will be inserted into the document, and you can start entering data.

Inserting rows and columns:

To insert rows or columns in an existing table, follow these steps:

1. Place the cursor where you want to insert the row or column.
2. Select the “Layout” tab from the ribbon.
3. To insert a row, click on “Insert Above” or “Insert Below” depending on where you want to insert
the new row.
4. To insert a column, click on “Insert Left” or “Insert Right” depending on where you want to insert
the new column.
5. The new row or column will be inserted, and you can start entering data.

Deleting rows and columns:

To delete rows or columns in an existing table, follow these steps:

1. Select the row or column you want to delete by clicking on the corresponding row or column header.
2. Select the “Layout” tab from the ribbon.
3. To delete a row, click on “Delete Row.”
4. To delete a column, click on “Delete Column.”
5. The selected row or column will be deleted.
Creating a mark sheet:

To create a mark sheet in MS Word, follow these steps:

1. Create a new document and insert a table with six columns and the required number of rows.
2. The first column should contain the name of the student, and the remaining five columns should be
for each subject’s marks.
3. Insert the appropriate column and row headings.
4. Enter the student’s name and their corresponding marks in each subject.
5. Use the “Merge Cells” option to merge the cells in the first row to create a heading for the table.
6. Use the “Borders” option to create borders around the table and adjust the cell width and height to
align the content.
7. To calculate the total marks and percentage, insert a new row at the end of the table.
8. Enter the formula to calculate the total marks in the corresponding cells.
9. Enter the formula to calculate the percentage by dividing the total marks by the total marks possible
and multiplying the result by 100.
10. Format the cells containing the total marks and percentage as “Bold” and adjust their alignment and
formatting as needed.
 POINEER INSTITUTE OF COMPTER
Belthara Road, Ballia, Uttar Pradesh
Portal code: 221715
Mobile: 9997232397, 6386616136

Academic Transcript
1st Semester Examination

Student ID PU19/490 Letter Grade Marks Interval Grade Point

Roll No. 22001312059 A+ 90-100 5
Name Ugrasen Yadav A 80-89 4
Class MCA (1st) B+ 70-79 3
Session 2022-2023 B 60-69 2
C+ 50-59 1
C 40-49 0

S.N. Subject Full Examination Total Letter Grade

Marks 1st 2nd 3rd
CT Marks Grade Point
1 HINDI 100 24 24 25 25 98 A+ 5
2 ENGLISH-1 100 23 25 21 25 93 A+ 5
3 ENGLISH-2 100 23 24 23 25 95 A+ 5
4 MATHS 100 23 21 23 25 92 A+ 5
5 SOCIAL SCIENCE 100 24 25 25 25 99 A+ 5
6 SCIENCE 100 22 24 24 25 95 A+ 5
7 DRAWING 100 24 25 25 25 99 A+ 5
8 OPT. MATHS 100 23 25 23 25 96 A+ 5

Grade Point Average 5

Letter Grade A+
Total Marks with Fraction 767/800

Remarks: To make your document look professionally produced, word provides header, footer, cover page, and text
box designs that complement each other, For example, you can add a matching cover page, header, and sidebar. Click
insert and then choose the elements you want for the different galleries.

Parents Signature Class Teacher Authorized Signature Principal

Conclusion:

Tables are an essential part of any document that requires organizing data or presenting information in a
structured manner. MS Word offers several features to create, insert, and delete tables, and manipulate them
according to specific requirements. This assignment has covered the basics of creating, inserting, and deleting
columns and rows in a table and demonstrated how to create a mark sheet. With practice, you can create
professional-looking tables and documents that are easy to read and understand.

Q.5. Tables and manipulation: Creation, Insertion, Deletion (Columns and Rows). Create a
mark sheet.

Objective: In this assignment, you will learn how to use the Mail Merge feature in MS Word
to create personalized invitations for a birthday party. You will prepare at least five letters to
invite your friends to your birthday party.

Instructions:

1. Open a new document in MS Word and click on the "Mailings" tab in the ribbon.
2. Click on the "Start Mail Merge" button and select "Letters" from the drop-down menu.
3. Click on the "Select Recipients" button and choose "Type a New List" from the drop-
down menu. Enter the names and addresses of your friends in the appropriate fields.
4. Click on the "Edit Recipient List" button to make any necessary changes or additions
to the list.
5. Click on the "Insert Merge Field" button and choose the fields you want to include in
your invitation, such as "First Name," "Last Name," "Address," and "Date."
6. Compose your invitation letter, including all the necessary details such as the date,
time, and location of the party, as well as any special instructions or requests.
7. Preview your letter by clicking on the "Preview Results" button. Make any necessary
changes or corrections.
8. Click on the "Finish & Merge" button and choose "Print Documents" from the drop-
down menu. Select the appropriate printer and options, and click "OK" to print your
invitations.
9. Repeat the above steps to create at least five letters, each personalized for a different
recipient.
10. Mail or deliver your invitations to your friends and wait for their RSVPs .
 SECTION- B
MS- WORD
Q.6. Data sorting-Ascending and Descending (both numbers and alphabets).

Data Sorting in MS Excel

Objective: To learn how to sort data in ascending and descending order in MS Excel.

Software Required: MS Excel

Instructions:

1. Open MS Excel and create a new workbook.

2. Enter the following data in cells A1 to C7:

Name Age Gender

Alice 22 F

Bob 35 M

Carol 28 F

David 19 M
Name Age Gender

Emily 42 F

Fred 31 M

Gabrielle 26 F

3. To sort the data by name in alphabetical order, select the entire table.
4. Click on the "Data" tab in the ribbon at the top of the screen.
5. In the "Sort & Filter" section, click on the "Sort A to Z" button. This will sort the data in ascending
alphabetical order by the values in the Name column.
6. To sort the data by age in ascending numerical order, select the entire table.
7. Click on the "Data" tab in the ribbon at the top of the screen.
8. In the "Sort & Filter" section, click on the "Sort Smallest to Largest" button. This will sort the data in
ascending numerical order by the values in the Age column.
9. To sort the data by gender in descending order, select the entire table.
10. Click on the "Data" tab in the ribbon at the top of the screen.
11. In the "Sort & Filter" section, click on the "Sort Z to A" button. This will sort the data in descending
order by the values in the Gender column.

Conclusion:

Sorting data in MS Excel is a simple process that can help you quickly and easily organize and analyze your
data. By following the steps outlined in this assignment, you should now be able to sort your data in both
ascending and descending order, by both numerical and alphabetical values.

Q.7. Mark list preparation for a student.

Objective: The objective of this assignment is to prepare a mark list for a student using
Microsoft Excel.
Scenario:

Suppose you have been given the task of preparing a mark list for a student. The student has
appeared for four exams, and you need to calculate the total marks obtained and the
percentage of marks obtained in each exam.

Instructions:

Step 1: Open a new Excel spreadsheet and name the first sheet "Mark List."

Step 2: Enter the student's details, such as name, roll number, class, and section in the first
few rows of the sheet.

Step 3: Create four columns for the four exams - Exam 1, Exam 2, Exam 3, and Exam 4.

Step 4: Enter the maximum marks for each exam in the row below the exam name.

Step 5: Enter the marks obtained by the student in each exam in the rows below the maximum
marks.

Step 6: Create a fifth column for Total Marks. In this column, add the marks obtained by the
student in each exam using the SUM function.

Step 7: Create a sixth column for Percentage. In this column, calculate the percentage of
marks obtained by the student in each exam using the formula: (Total Marks Obtained /
Maximum Marks) * 100.

Step 8: Add the formulas for Total Marks and Percentage to the respective cells for all
students.

Step 9: Use conditional formatting to highlight the cells where the percentage obtained by the
student is less than 40%.

Step 10: Save the spreadsheet and print a copy of the mark list.
 HIGH SCHOOL MARK SHEET- 2015
Roll n. 22001312059
UGRASEN
Name
YADAV
Birth date 15-03-2000
School
G. M. A. M. I C BELTHARA ROAD
name
Obt
Subject I II III Practical Total/Division
Marks D/F
Hindi 75 15 12 44 440 Total
English 42 36 78 d firstdiv Division

Match 56 38 94 d pass Pass/fail

Scince 65 5 10 80 d With Grase

So.Scince 75 75 d 73.33333333 Parcentage

Drawing 69 69 Withgrase marks

Q.8. Mark list preparation for a student.

Objective:

The objective of this assignment is to create an Excel sheet for individual pay bill preparation for employees,
which includes details such as employee name, designation, number of days worked, basic pay, allowances,
deductions, and net pay.

Steps to follow:

Step 1: Create a new Excel sheet and name it "Payroll".

Step 2: In the first row of the sheet, create column headings for the following details: Employee Name,
Designation, Number of Days Worked, Basic Pay, Allowances, Deductions, and Net Pay.

Step 3: In the second row, create cells for the corresponding details. For example, in the cell under Employee
Name, write the name of the employee.
Step 4: In the third row, create cells for the basic details of each employee, such as their name, designation,
and the number of days they have worked.

Step 5: In the fourth row, create cells for the basic pay, allowances, deductions, and net pay for each
employee.

Step 6: Create a formula to calculate the basic pay for each employee. The basic pay is calculated as the
number of days worked multiplied by the daily rate of pay. For example, if the daily rate of pay is $50 and
an employee has worked for 20 days, the basic pay will be 20 x 50 = $1000.

Step 7: Create cells for allowances such as house rent allowance, medical allowance, and travel allowance.
For each allowance, enter the corresponding amount.

Step 8: Create cells for deductions such as tax, social security, and other deductions. For each deduction,
enter the corresponding amount.

Step 9: Create a formula to calculate the net pay for each employee. The net pay is calculated as the basic
pay plus allowances minus deductions. For example, if an employee's basic pay is $1000, allowances total
$300, and deductions total $200, the net pay will be 1000 + 300 - 200 = $1100.

Step 10: Once you have completed the details for one employee, copy the same formula to all other employee
rows.

Step 11: Save the Excel sheet and print a hard copy for record-keeping.

Conclusion:

By following these simple steps, you can create an Excel sheet for individual pay bill preparation, which can
be used to calculate the basic pay, allowances, deductions, and net pay for each employee. This sheet will
save time and ensure accuracy in the calculation of employee pay, making the payroll process efficient and
error-free.

Q.9. Invoice Report preparation.

Objective:

The objective of this assignment is to develop a comprehensive and professional invoice report using
Microsoft Excel. The report should be well-formatted, easy to read, and accurately represent the information
presented.
Requirements: You are required to prepare an invoice report for a fictional company, XYZ Inc., which
provides consulting services to various clients. The report should include the following information:

1. Invoice Number: A unique identifier assigned to each invoice.

2. Client Name: The name of the client receiving the consulting services.
3. Invoice Date: The date when the invoice was generated.
4. Due Date: The date by which the payment is expected.
5. Description of Services: A detailed description of the consulting services provided.
6. Quantity: The number of hours or days worked by the consultant.
7. Rate: The hourly or daily rate charged for the consulting services.
8. Total: The total amount charged for the consulting services.

Instructions:

1. Open a new Excel workbook and create a new sheet for the invoice report.
2. Set up the columns with the following headings: Invoice Number, Client Name, Invoice Date, Due
Date, Description of Services, Quantity, Rate, Total.
3. Enter the data for each invoice in the corresponding cells. Make sure to include at least 10 invoices.
4. Format the cells to display the data in a professional and easy-to-read manner. Use appropriate
number formatting for the amounts.
5. Add a row at the bottom of the report to display the total amount charged for all invoices.
6. Add conditional formatting to highlight any overdue invoices. Use a red font or background to make
it stand out.
7. Create a chart to display the total amount charged for each client.
8. Add a header and footer to the report with the company name, page numbers, and date.
9. Save the workbook with a meaningful name, such as "XYZ Inc. Invoice Report".
10. Print the report on a single page, making sure that the content is well-organized and easy to read.

Q.10. Drawing Graphs. Take your own table

Objective: The objective of this assignment is to help students learn how to draw graphs in MS Excel using a
sample data table.

Table of Contents:

1. Introduction
2. Data Table
3. Bar Chart
4. Line Chart
5. Pie Chart
6. Conclusion
 7. Introduction: MS Excel is a powerful tool for data analysis and visualization. One of its main features is the
ability to create graphs that visually represent data. In this assignment, we will explore how to create three
different types of graphs: bar charts, line charts, and pie charts.
8. Data Table: We will use the following sample data table to create the graphs: Bar Chart: A bar chart is a
graphical representation of data that uses bars to compare values. To create a bar chart in MS Excel, follow
these steps:

HIGH SCHOOL MARK SHEET- 2015

Roll n. 22001312059
UGRASEN
Name
YADAV
Birth date 15-03-2000
School
G. M. A. M. I C BELTHARA ROAD
name
Obt
Subject I II III Practical Total/Division
Marks D/F
Hindi 75 15 12 44 440 Total
English 42 36 78 d firstdiv Division

Match 56 38 94 d pass Pass/fail

Scince 65 5 10 80 d With Grase

So.Scince 75 75 d 73.33333333 Parcentage

Drawing 69 69 Withgrase marks

 I

69 75

42
75

56
65

Hindi English Match Scince So.Scince Drawing

3. Select the data table.

4. Go to the Insert tab and click on the Bar Chart icon.
5. Select the type of bar chart you want to create.
6. Customize the chart as per your requirement.
7. Line Chart: A line chart is a graphical representation of data that displays information as a series of data
points connected by straight lines. To create a line chart in MS Excel, follow these steps:
8. Select the data table.
9. Go to the Insert tab and click on the Line Chart icon.
10. Select the type of line chart you want to create.
11. Customize the chart as per your requirement.
12. Pie Chart: A pie chart is a graphical representation of data that displays information as a circle divided
into slices to illustrate numerical proportion. To create a pie chart in MS Excel, follow these steps:
13. Select the data table.
14. Go to the Insert tab and click on the Pie Chart icon.
15. Select the type of pie chart you want to create.
16. Customize the chart as per your requirement.
17. Conclusion: MS Excel is an excellent tool for data analysis and visualization. Creating graphs in Excel is
easy and can provide valuable insights into your data. By following the steps outlined in this assignment,
you should be able to create different types of graphs to represent your data visually.
 SECTION- C
MS- POWER POINT PRESENTATION
Q.11. Create a slide show presentation for a seminar

as s m ter

Name N

e t
Computer is electronic device system which is combination of

as s the hardware and software and it is used for performing

calculation at a very high speed also can handle other various
task.

m ter es m ter
. Supercomputer
. Mainframe computer
. Minicomputer
. orkstation
. PC Personal Computer

2
 t r ess t t e

Input unit

utput unit

Control unit

Arithmetic logic
unit
Memory

4
 ta a a
e es
ta e es it is a part of physical
e uipment that uses digital data. Commonly
used in the workplace for tasks like word
processing.

a e es it is a combination of both
analog machine and analog media that can
together measure, record, reproduce, receive
continuous information.

Central Processing Unit C.P.U

ar are Input devices e.g. keyboard,

mouse
m ter
utput devices e.g.
monitor, printer

Storage devices e.g. hard drive

6
 te t
It is a processing software developed by Microsoft.
First released on ctober th, , under the
name Multi tool word for enix system.
e t
Microsoft ord is word processing software
program
ord Processing is the use of computer software to
enter and edit text.

It is use to create new documents,

open existing documents, saving
new updated document, page setup,
print preview and other important
functions relating to your document
and its properties

8
 t e

It contains commands relating to

handling of information within a file
like cut, copy, paste, undo andredo. It
has commands you need for moving,
locating and modifying.
Shortcut keys:
Ctrl + x for Cut
Ctrl + c for Copy
Ctrl + v for Paste

It includes shapes, diagrams,

flowcharts, curves, lines and word art.
ra e ou can change and enhance these
objects.

10
 s e

It includes language, word count,

speech, letters and mailing, macro,
customi e and more. The spelling
and grammar commands checks the
spelling and grammar of the
worksheet.

11

a er er
Steps for Mail Merger:
Click edit individual letter.
In the merge to new document dialog box,
select the records that you want to merge.
Click ok.
Scroll to the information that you want to
edit, and then make changes.
Print or save the document just as you would
any regular document.

12
 References
This tab lets you add references to a document and then create a
bibliography at the end of the text. References are a footnote that
you can add to your document.

Put your cursor at the end of the text you want to cite.
o to references style, and choose a citation style.
Select Insert citation.
Choose Add New Source and fill out the information about your source.

13

Q.11. Preparation of Organization Charts

Introduction: Organizational charts are an essential tool for any organization that helps to
illustrate the hierarchy and relationships between different departments, positions, and
employees. In this assignment, we will explore how to create an effective organizational chart
using MS PowerPoint.

Objectives:

• Understand the importance of organizational charts

• Learn the different types of organizational charts
• Learn how to create an organizational chart using MS PowerPoint
• Learn how to customize the chart to suit your organization's needs
 • Learn how to update the chart as the organization evolves

Body:

I. Importance of Organizational Charts A. Definition and purpose of organizational charts B.

Benefits of using organizational charts in an organization C. Key elements of a good
organizational chart

II. Types of Organizational Charts A. Hierarchical Organizational Charts B. Matrix

Organizational Charts C. Flat Organizational Charts D. Team-Based Organizational Charts

III. Creating an Organizational Chart in MS PowerPoint A. Inserting SmartArt graphics B.

Adding and formatting shapes C. Adding text and images D. Customizing the chart layout
and design E. Adding animation and transition effects

IV. Customizing the Chart to Suit Your Organization's Needs A. Adding additional elements
to the chart B. Rearranging the chart elements C. Adding or removing layers D. Changing
colors, fonts, and styles

V. Updating the Chart as the Organization Evolves A. Adding new employees or departments
B. Removing employees or departments C. Moving employees or departments within the
chart D. Changing job titles or positions

Conclusion:

In conclusion, creating effective organizational charts using MS PowerPoint is an important

skill for any organization. By understanding the importance of organizational charts, learning
the different types of organizational charts, and mastering the creation and customization of
charts using MS PowerPoint, organizations can effectively communicate their structure and
hierarchy, enhance their decision-making process, and improve overall productivity.