IGNOU MFN-10
- Understanding Computer Applications,
Latest Solved Assignment
(July 2023 - January 2024)

1. Create new MS Word document on topic ‘Nutritional deficiency diseases in India’ consisting of 3 pages. Your document should be prepared with given specifications:

I. Font-typeface- Times New Roman
II. Font size-12
III. Font Colour- Headings in black colour and text in blue colour
IV. Headings should be bold and underline
V. Text of document should be center alignment
VI. Spacing-Double spaced
VII. Margins-Top-2inch, Bottom-2.5inch
VIII. Create table((minimum rows-6, coloumns-3) with fixed column width

Take a printout of document and submit along with the assignment. Write the steps involved to create the above document

2. Suppose you are a class teacher of class V. Create a worksheet using excel to maintain the monthly test report of your class. Your excel sheet should have different columns depicting the Serial number, Name of the Student, Roll number, Attendance, Marks of different subjects in different columns like Marks of English, Hindi, Maths, Science and Social Science. Total students in your class should be 40. Put in the required data for the respective columns in 40 rows. Also, write step-by-step procedure to perform the following activities in your answer sheet and take a printout of excel worksheet and attach with the assignment.

Your worksheet should contain the following:
i. Find average attendance per month
ii. Automatically find which student got highest marks overall
iii. Create chart for marks obtained by students
iv. Use formula to find sum and average attendance of students.

3. a) Define ergonomics. List some points you should consider while working on computer in order to remain healthy.
b) Why Control Panel is important? Explain.
c) Define Network and elaborate its type in detail.
d) How audio/video can be incorporated in a slide? Explain.

4. a. List and explain editing features of MS-word.

b. What is Microsoft PowerPoint? Discuss its uses in education and research.
c. Define alignment? Describe various alignments you can use in MS-word.
d. What is modem?
e. Enlist various Windows Applications and describe their features briefly.

5. Differentiate between the following terms:

i) Page margins and scaling
ii) Command Line Interface and Graphical User Interface
iii) Paint and Paint 3D
iv) Notepad and WordPad
v) URL and FTP

1. Create a MS Power point presentation on “Environmental Pollution”, consisting of about 10-12 slides. Take a printout of these slides and submit along with the assignment. Write the steps involved to create the above power point. It should involve the following activities:

i) It should have a master slide with a title
ii) Insert header and footer in all slides except master
iii) Show some data using a chart or graph
iv) Include smart art in one of the slides
v) Insert picture in one of the slides

2. Create a worksheet using excel having different columns depicting the Serial Number, Name of the Student, Height, Weight and Age of the 40 students in class 1. Put in the required data for the respective columns in 40 rows. Also, write step-by-step procedure to perform the following activities in your answer sheet and take a printout of excel worksheet and attach with the assignment. Your worksheet should contain the following:

i) Coding of male (M) and female (F) and calculate the number of males and number of females by giving formula in the cell.
ii) Calculate BMI of each student by putting formula for BMI.
iii) Create three categories of students falling in underweight, normal and overweight according to WHO, 2004.
iv) Find out sum of the number of students falling in each category of BMI and
v ) Average BMI of whole class.

3. a) Illustrate the main parts and functions of a computer.
b) Briefly describe the internet tools and discuss how to use the internet.

4. Explain the following term with the help of an example/diagram, if needed:

a. Disk defragmenter
b. Hard disk
c. Title bar
d. Ergonomics
e. Data Processing Cycle
f. Device driver
g. Thesaurus
h. Ribbon
i. Carpal tunnel syndrome
j. Macro
k. Mail Merge
l. Scan Disk
m. Character map
n. Database
o. Email Etiquette

5. Differentiate between the following terms:

i) Hardware and Software
ii) Folder and File
iii) LAN and WAN
iv) AutoText and AutoCorrect
v) Formula and Function