IGNOU MFN-10 Understanding Computer Applications - Latest Solved Assignment

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

i) Font-typeface- Arial
ii) Font size-12
iii) Font Colour- Title in red colour, headings in black colour and text in green colour
iv) Title should be bold and in capitals
v) Headings should be in italics and underline
vi) Text of document should be in center alignment
vii) Spacing-Double spaced
viii) Margins-Top-2 inch, Bottom-2.5inch
ix) Page numbers at the bottom centre of each page
x) Create table (rows-6, coloumns-3) with fixed column width

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

2. Create a worksheet using excel having different columns depicting the Serial Number, Name of the subject, Age (years), Height (cm) and Weight (kg) of 20 adults in your neighbourhood. Put in the required data for the respective columns in 20 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 the average age of the males and females.
ii) Create a new column after variable weight. The variable name of this new column will be BMI. Calculate BMI of each adult by putting formula for BMI.
iii) Create four categories of adults falling in underweight, normal and overweight and obese according to WHO criteria.
iv) Find out sum of the number of adults falling in the four categories of BMI. Depict this data in a bar char.
v ) Average BMI of all adults

3. a) What are the different features/operation of MS-Outlook express
b) Explain the data processing functions of the computer with an illustration.

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

a. Computer virus
b. Pivot tables
c. Macros in Excel
d. Ergonomics
e. Screenshot
f. Microsoft Power point
g. Thesaurus
h. Mail merge
i. Auto Text feature
j. Indenting text
k. Web layout view
l. Quick access toolbar
m. LAN
n. Notepad
o. Toolbar

5. Differentiate between the following terms:

i) Disk fragmenter and Disk clean up
ii) Main memory and Auxillary memory
iii) System software and Application software
iv) AutoText and Auto Correct
v) File and Folder

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