INDEX

[Link]. Problem Statement Page No. Date Signature

1. To explore system settings- 10 Dec 21

Personalization, System, Devices, Apps,
Network and Internet
2. To explore Windows Explorer 14 Dec 21
functionalities like, create, rename, move,
delete folder and files etc.
3. Create a Document containing text that 28 Dec 21
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.
4. Create a document containing computers 30 Dec 21
basic including advantages, disadvantages
using header, footer, indentation etc.
5. Insert a 7-column,6-row table to create a
calendar for the current month.

a. Enter the names of 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.

6. Create a table in MS-Word with the 31st Dec

following entries [Link], 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.

7. Write 10 mathematics equations. 3rd Jan

8. What is computer? List its advantages and 7th Jan 22

disadvantages and apply the following:

b. Bullets on Advantages
c. Numbering on Disadvantages
d. Shade the definition of Computer
and Highlight the word Computer
e. Format the definition to Cambria
Font Style and 14 Size
f. Apply Format Painter on
Advantages to make it same as
definition
g. Clear the formatting of Definition
h. Increase the space between lines
and make line spacing 1.5.
i. Increase the space between
characters and make it 2 pts.
j. Strike through the first
disadvantage.
k. 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
l. Double Underline all the Headings
 m. Display Hidden Characters

9. Create a document containing brief 8 Jan 22

introduction of IITM, Vision, Mission and
Courses Offered and perform the
following:

a. Insert a Cover Page

b. Insert Page Break before Vision,
Mission and Courses Offered.
c. Drop Cap First Letter of all the
Explanations.
d. Insert Date and Time at the starting
of the Document.
e. Set margins of all sides to 1.25
each.
f. Arrange the document in both
orientations.
g. Divide the courses offered in 2
Columns.
h. Insert Line Numbers.
i. Insert a Foot note for IIT at first
page
j. Insert an end note for address on
first Page

10. Use smart art and create organization charts

11. Create a 5-page document containing pages

like Introduction to Computers, Block
Diagram, Applications, Input-Output
Devices and Assignments done. Use
hyperlinks. Insert Bookmarks.

12. Create your resume using basic formatting

features such as: tables, bullets, wordart etc.

13. Send the Bithday Party Invitation Card to 5

different people using Mail Merge. Add
Pictures/Clip art to birthday card.

14. Create your own marksheet using

formatting features.
15. Create a chart and show the product price
comparison between 2015, 2016, and 2017.

16. Create a spreadsheet of the purchases made

by a customer in a super mart having the
following fields:

● [Link]
● Product ID
● Product Name
● Product type(food, clothes, toys
etc)
● Quantity
● Price per unit

Note: All the field names should be bold

and underlined.
Also Insert Borders to the spreadsheet.
For the spreadsheet created above, find the
total bill, using the auto sum facility of Ms
Excel.

17. Create a spreadsheet having fields: as Roll

No, Student Name, Subject1, Subject 2,
Subject 3,Subject 4, Subject 5 . Now design
a student performance report using
Conditional formatting in M.S. Excel the
following specifications:

• Greater than
• Less than
• Equal to
• Between
• Data bar
 • Color Scales

Also perform wrap text on Name,

orientation on all the headings and merge
cells operation.

18. Create a record of ten students consisting

of [Link], name, course and marks in two
subjects(M1,M2),total and percentage and
perform the following operations:

• Sort the records in ascending

order of marks M1
• Sort the record according to
descending order of names
• Round off percentage to one
decimal place
• Convert the percentage in text
• Apply filter on course field

19. 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

20. 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

21. Create the Pivot Chart for the sales of

Computer Hardware of KCL Pvt. Ltd for 3
Years.

22. 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

23. Create a record of BBA(1ST Sem)

consisting of the following fields:
• [Link]
• Name
• Date of birth
• Age
• Marks
• Remarks
For the above record, apply data validation
and freeze panes.
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.

24. 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’

25. Perform and analyse the following

mathematical functions:

Sum Abs cos

roman subtotal Product
mod tan Round
power floor Roundup
square root ceiling Trunk
sin

26. Perform and analyse the following text

functions:

left replace right

find mid
concatenate

search upper proper

text lower
trim

clean

27. Display current Date & Time

Display Dos Version and C Drive Volume
Create a directory by your Course Name
Create two semester Directories in Course
Directory
Create 5 subject directories in both sub-
directories
Create a file in one Subject Directory
Display the contents of the file
Display Complete tree of Course Directory
Remove second semester sub-directory
Display all the directories in C Drive
Copy the file from one subdirectory to
another subdirectory
Rename the copied file
Delete the file in one Subdirectory
Clear the screen
Go to D/E Drive
28. Create three file in course directory( 2
Docx and 1 txt)
List all the directories with 6 characters
List all the files in course directory
Display word Documents only
Rename the txt file to doxc File
Delete all the docx files
Find the files starting with D
Find the files ending with I
Find the files having A at any location
Copy all the docx file in another folder
Display the system Path

29. Create a folder with your name

Create a file with 15 names(include spaces
in between)
Create 2 files with same content in another
folder
Display the content of first file using more
command
Show the memory Utilization
Copy the contents of your name folder to
another folder
Move the word files to your name folder
Compare the contents of files in your name
folder
Sort the first file in ascending as well as
descending order
Find the letter “m” in first File
Make the file hidden and then unhide the
same file
Create a macro to display directories
Display already created Macros
Open the file to edit the content
Exit Ms-DOS

30. Create a presentation on Types of Memory

and Apply the following

a) Insert a blank slide and draw

memory classification using
Organization Chart
b) Compare RAM & ROM using
Comparison Layout
c) Insert hyperlinks on the types of
Memory that opens new slides for
 it.

31. Create a presentation on types of Operating

Systems and apply the following:

a) Apply any one theme

b) Apply the animation effects
c) Change transition speed to slow.
d) Apply automatic time duration to all
Slides

32. Create a presentation on Components of

Computer System and perform the
following:

a) Apply Rehearse Timing

b) Apply the different slide show
options
c) Protect the presentation to restrict
unauthorized access.

33. Create a presentation showing use of Photo

Album

34. Create a presentation to show the use of

Motion Path by moving any object