MFN-10 2023-24 SOLVED ASSIGNMENT

Description

ASSIGNMENT 6
TMA-6
Understanding Computer Applications
Course Code: MFN-010
Assignment Code: MFN-010/AST-6/TMA/23-24
Last Date of Submission: 15thMarch 2024
Maximum Marks: 100
This assignment is based on Units 1 -14 of the MFN-010 Course.
There are five questions. Answer all questions.
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.
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(1)
(12)
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.
(5)+(3)
(3)
(3)
(3)
(3)
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.
(5)
(5)
(5)
(5)
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.
(2+4)
(2+4)
(2+5)
(2)
(3+6)
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