Docsity
Docsity
Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity

Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan

Guidelines and tips
Guidelines and tips
Sell on Docsity
Sell on Docsity
Docsity AI
Docsity AI
Log inSign up

Prepare for your exams

Study with the several resources on Docsity

Find documents

Prepare for your exams with the study notes shared by other students like you on Docsity

Search for your university

Find the specific documents for your university's exams

Docsity AINEW

Summarize your documents, ask them questions, convert them into quizzes and concept maps

Explore questions

Clear up your doubts by reading the answers to questions asked by your fellow students

Earn points to download

Earn points by helping other students or get them with a premium plan

Share documents
download point icon20 Points

For each uploaded document

Answer questions
download point icon5 Points

For each given answer (max 1 per day)

All the ways to get free points
Get points immediately

Choose a premium plan with all the points you need

Study Opportunities

Choose your next study program

Get in touch with the best universities in the world. Search through thousands of universities and official partners

Community

Ask the community

Ask the community for help and clear up your study doubts

Free resources

Our save-the-student-ebooks!

Download our free guides on studying techniques, anxiety management strategies, and thesis advice from Docsity tutors

Information Technology File, Study Guides, Projects, Research of Business Management and Analysis

Business Management and Analysis

Various Assignments related Microsoft Word and Microsoft Excel.

Typology: Study Guides, Projects, Research

2020/2021

Available from 10/09/2022

yuktha-garg
yuktha-garg 🇮🇳

2 documents

1 / 41

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
1
S.No Name of Practical Page No. Remarks
1
Create a Document containing text that should be properly aligned
with proper format. Use the “Replace All” option in Find and
Replace to replace each instance of some word . Save and Protect
your document.
11
2 List down different components of computer along with their
functionality & then sort its sequence & apply at least 5 different
styles.
15
3 Create a document containing computers basic including
advantages, disadvantages using header, footer, indentation etc.
17
4 Create an invitation card for the fresher’s party using the clip art
facility of MS-Word
21
5 Create the Block diagram of Computer using drawing facility of MS
Word
24
6 Insert a 7-column, 6-row table to create a calendar for the current
month.
a. Enter the names of the days of the week in the first row of
the table.
b. Centre the day names horizontally and vertically.
c. Change the font and font size as desired.
d. Insert a row at the top of the table.
e. Merge the cells in the row and enter the current month
and year using a large font size.
f. Shade the row.
g. Enter and right-align the dates for the month in the
appropriate cells of the table.
h. Change the outside border to a more decorativ e border.
Identify two important dates in the calendar and shade
them.
26
7 Create a table in MS-Word with the following entries S.No, PID,
PName, Price per Unit, No of Units and Total Cost and apply the
following operations on it
1) Calculate the Product in Total Cost Column.
2) Calculate the total cost of all the products.
3) Count the no of items (apply function on PID).
4) Find the minimum price per unit.
5) Find the maximum No of units.
30
8 Create a 5-page document containing pages like Introduction to
Computers, Block Diagram, Applications, Input-Output Devices and
Assignments done. Use hyperlinks. Insert Bookmarks.
32
9 Write 10 mathematics equations. 36
10 Create the resume using the resume Template facility and write
down the steps for the same
37
pf3
pf4
pf5
pf8
pf9
pfa
pfd
pfe
pff
pf12
pf13
pf14
pf15
pf16
pf17
pf18
pf19
pf1a
pf1b
pf1c
pf1d
pf1e
pf1f
pf20
pf21
pf22
pf23
pf24
pf25
pf26
pf27
pf28
pf29

Partial preview of the text

Download Information Technology File and more Study Guides, Projects, Research Business Management and Analysis in PDF only on Docsity!

S.No Name of Practical Page No. Remarks (^1) Create a Document containing text that should be properly aligned with proper format. Use the “Replace All” option in Find and Replace to replace each instance of some word. Save and Protect your document.

2 List down different components of computer along with their functionality & then sort its sequence & apply at least 5 different styles.

3 Create a document containing computers basic including advantages, disadvantages using header, footer, indentation etc.

4 Create an invitation card for the fresher’s party using the clip art facility of MS-Word

5 Create the Block diagram of Computer using drawing facility of MS Word

6 Insert a 7-column, 6-row table to create a calendar for the current month.

a. Enter the names of the days of the week in the first row of

the table.

b. Centre the day names horizontally and vertically.

c. Change the font and font size as desired.

d. Insert a row at the top of the table.

e. Merge the cells in the row and enter the current month

and year using a large font size.

f. Shade the row.

g. Enter and right-align the dates for the month in the

appropriate cells of the table.

h. Change the outside border to a more decorative border.

Identify two important dates in the calendar and shade them.

7 Create a table in MS-Word with the following entries S.No, PID, PName, Price per Unit, No of Units and Total Cost and apply the following operations on it

  1. Calculate the Product in Total Cost Column.
  2. Calculate the total cost of all the products.
  3. Count the no of items (apply function on PID).
  4. Find the minimum price per unit.
  5. Find the maximum No of units.

8 Create a 5-page document containing pages like Introduction to Computers, Block Diagram, Applications, Input-Output Devices and Assignments done. Use hyperlinks. Insert Bookmarks.

9 Write 10 mathematics equations. 36 10 Create the resume using the resume Template facility and write down the steps for the same

11 Make a table of contents for the 5 page Document created in Assignment 8

12 Send the Fresher’s Party Invitation Card created above to 5 different People using Mail Merge. Write steps corresponding to it

13 Count the number of characters (with & without space), word, pages, paragraph, and lines using word count facility of M.S. Word

14 Create a macro using Keyboard .Write steps of the same 45 15 Check the spelling and grammar in an existing document and it should be properly aligned with proper format

16 What is computer? List its advantages and disadvantages and apply the following:

a. Bullets on Advantages

b. Numbering on Disadvantages

c. Shade the definition of Computer and Highlight the word

Computer

d. Format the definition to Cambria Font Style and 14 Size

e. Apply Format Painter on Advantages to make it same as

definition

f. Clear the formatting of Definition

g. Increase the space between lines and make line spacing

h. Increase the space between characters and make it 2 pts.

i. Strike through the first disadvantage.

j. Change the cases as follows:

  1. Heading of Definition-Uppercase
  2. Heading of Advantages- Lowercase
  3. Heading of Disadvantages- Toggle Case
  4. Definition- Sentence Case
  5. Advantages- Capitalize each word

k. Double Underline all the Headings

l. Display Hidden Characters

17 Create a document containing brief introduction of IITM, Vision, Mission and Courses Offered and perform the following:

i. Insert a Cover Page

j. Insert Page Break before Vision, Mission and Courses

Offered.

k. Drop Cap First Letter of all the Explanations.

l. Insert Date and Time at the starting of the Document.

m. Set margins of all sides to 1.25 each.

n. Arrange the document in both orientations.

o. Divide the courses offered in 2 Columns.

p. Insert Line Numbers.

q. Insert a Foot note for IIT at first page

r. Insert an end note for address on first Page

22 Create a spreadsheet for Student Performance Report of 2 students containing date of exam, day of Exam, Subject and Marks ● Fill Date and day using Fill Series Facility. Also create the Column Chart for above and apply:  Chart title  Axis  Fill Color  Border color  Shape effects  Size

23 Draw the Line Chart and Pie Chart for the sales report of the ABC Pvt. Ltd of 5 Products for last 3 years in M.S. Excel and explore the following properties : ● Legend ● Data Label ● Axes ● Gridlines

24 Create the Pivot Chart for the sales of Computer Hardware of KCL Pvt. Ltd for 3 Years. 25 Create a Bar graph for 5 states for 3 years depicting the literacy rate. For the graph created above perform the following

  • Switch Row/column,
  • Change it to column chart 26 Create the student grade (Roll No, Name, Percentage), Assign Grades (A (>90), B(>75), C(>50) & D) using IF and IF Else condition in M.S. Excel. ● Now using the conditional formatting fill the A grade as -pink, B grade as blue, C grade as yellow and D grade as Red. ● Also Split the roll No in 4 parts (Roll No, Batch, course, year) and Name in 2 parts (First and Last Name) and remove duplicate course 27 Create a record of Bank consisting of the following columns:
  • Customer id
  • Customer Name
  • Principle Deposited
  • Rate of Interest
  • Time Now for the above table (i) Find the interest earned by each customer. Each customer must earn minimum interest of Rs5000, by changing the value of time period for which money must be deposited (ii) Change the minimum interest to Rs 10000 by changing the value of Principle. (iii) Apply Freeze Panes

28 Create a record of BBA(1ST Sem) consisting of the following fields:

  • S.no
  • Name
  • Date of birth
  • Age
  • Marks
  • Remarks For the above record, apply data validation. For the records above, protect your worksheet by providing password
  • Hide/unhide cells.
  • Allow users to select columns
  • Allow users to sort cells
  • Don’t allow users to delete cells
  • Don’t allow users to format cells. 29 Create a record of 25 students having fields: Enrolment no, Name, Age and Aggregate Marks. Now perform the following: Sort the details of student on the basis of name. Filter all the students where age is > 20. Filter all students where name begins with ‘a’. 30 Perform and analyse the following mathematical functions: Sum, Abs, Subtotal, Product, Mode, Tan Round, Power, Floor, Roundup, Square root, Ceiling Trunk, sin, roman 31 Perform and analyse the following text functions:  Left, replace, text  Right, find, replace  Mid, concatenate, search  Upper, proper, exact  Lower, trim, clean 32 Perform and analyse the following Date and Time functions:
  1. Date, now
  2. Day, second
  3. Hour, year
  4. Minute, workday
  5. Month, week number

ASSIGNMENT :

Q. Create a document containing text that should be properly aligned

with proper format. Use the ‘replace all’ option in Find & Replace to

replace each instance of some word. Save and protect your document.

 Steps:

  1. Create document
  2. Go to home tab
  3. Select “ find & replace” option
  4. Write the word in “find what” and “replace with”
  5. Click the “replace all” option
  6. Then click ‘office button’ and then click ‘save as’.
  7. Then click on ‘tools’ and select ‘general options’
  8. Enter ‘password to open’ and ‘password to modify’.
  9. Then click ‘OK’.

ASSIGNMENT: 3

Q. Create a document containing computer basics including

advantages, disadvantages using header, footer, indentation.

 Options of Header

 Options of Footer

 After Header is applied

 After Footer is applied

 Steps to create Document:

1) Create a Word document

2) Click on Insert Tab

3) Click on “Header” to create a Header

4) Click on “Footer” to create a Footer

ASSIGNMENT: 4

 Steps how to create:

  1. Create a Word document
  2. Click on insert tab
  3. Click on ‘word art’ to apply an art to your Heading
  4. Click on ‘page colour’ to apply colour on the page
  5. The click on ‘page border’ to apply border to your document
  6. From the insert option select shape of your choice to make your card attractive
  7. Write VENUE, DATE & TIME

ASSIGNMENT: 5

Q. Create the Block diagram of Computer using drawing facility of

MS-Word.

 Steps to create document:

1. Create a document

2. Make shapes using shapes tools’

3. Right click on the shapes to add text

4. Select all and right click and then click on grouping option

ASSIGNMENT: 6

 Steps to create a Calendar:

  1. Create a Word document
  2. Click on insert tab
  3. Then click on ‘table’
  4. A Dialogue box will appear
  5. Select the number of rows and columns to create a table
    1. Add dates and days to the columns
  6. Add an additional column at the top and merge it to write the month and year
    1. Shade the row
  7. Enter and right align the dates for the month in the appropriate cells of the table
  8. Change the outside border. Identify two important dates in the calendar and shade them.

ASSIGNMENT: 7

Q. Create a table in MS-Word with the following entries S.No, PID,

PName, Price per Unit, No of Units and Total Cost and apply the

following operations on it.

1. Calculate the Product in Total Cost Column.

2. Calculate the total cost of all the products.

3. Count the no of items (apply function on PID).

4. Find the minimum price per unit.

5. Find the maximum No of units.

 Steps to create document:

1. Go to ‘insert’ tab. Click on table option to create a table.

2. Put the data on the table.

3. Then go on ‘layout’ tab.

4. Click on formulae and then find out minimum in P1 and

P3.

5. Then find out maximum in P2 & P5.

6. Now find the sum of total cost obtained.

7. Now in layout tab click on convert to text option.

8. Select tab and press okay.

 Steps to create a document:-

  1. Open word document
  2. Create five word document
  3. Create an additional word document for hyperlink
  4. Select the content
  5. Open insert tab
  6. Click on hyperlink
  7. Select those word documents one by one to create hyperlink.
  8. Create a new word document.
  9. Go to ‘insert’ tab. Click on bookmark option.
  10. Select the page or text you want to bookmark. Then click ‘add’.

ASSIGNMENT: 9

Q. Write 10 mathematical equations.

 Steps to create equations:

1. Create a word document.

2. Go to insert tab.

3. Click on ‘equation’ options to create equations.