Understanding Computer Applications
MFN 010 Solved Free Assignment 2023
IGNOU MFN 010 Solved Free Assignment January 2023
Q 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
Ans. To create a MS PowerPoint presentation on “Environmental Pollution”, follow the steps below: MFN 010 Solved Free Assignment 2023
1. Open Microsoft PowerPoint on your computer and click on “Blank Presentation”.
2. Select a suitable theme for your presentation from the Design tab.
3. Create a master slide with a title that clearly reflects the topic of your presentation. This will be the first slide and should introduce your topic and set the tone for the rest of the presentation.
4. Insert header and footer in all slides except the master slide. This can be done by clicking on the “Insert” tab, selecting “Header & Footer” and then adding the desired text or image.
5. Create a slide that shows some data using a chart or graph. This can be done by selecting “Insert” and then selecting “Chart” or “Graph”. Choose the appropriate type of chart or graph for your data and then input the data.
6. Include smart art in one of the slides to visually communicate key points. This can be done by clicking on the “SmartArt” option in the “Insert” tab, selecting the appropriate diagram, and inputting the necessary information.
7. Insert a picture in one of the slides to add visual interest. This can be done by selecting “Insert” and then selecting “Picture”. Choose the appropriate picture for the slide and then resize or position it as needed.
8. Create additional slides to include key information about environmental pollution. Make sure to include relevant facts and statistics.
9. Add transitions between slides to create a smooth flow. This can be done by selecting “Transitions” and then choosing the desired transition effect.
10. Add animations to make the presentation more engaging. This can be done by selecting “Animations” and then selecting the desired animation effect.
11. Finally, preview the presentation and make any necessary edits before saving and printing it out. MFN 010 Solved Free Assignment 2023
Your presentation could include the following slides:
➛. Introduction slide with a title and an image related to environmental pollution.
➛. Slide with information about different types of environmental pollution (air, water, noise, etc.).
➛. Slide with statistics about the impact of environmental pollution on human health.
➛. Slide with information about the impact of environmental pollution on wildlife.
➛. Slide with a chart showing the sources of environmental pollution.
➛. Slide with information about ways to reduce environmental pollution.
➛. Slide with information about environmental regulations and policies.
➛. Slide with a picture of a polluted environment to illustrate the seriousness of the problem. MFN 010 Solved Free Assignment 2023
➛. Slide with smart art showing the causes and effects of environmental pollution.
➛. Conclusion slide with a summary of the main points and a call to action for the audience to take steps to reduce environmental pollution.
Q 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
v ) Average BMI of whole class. MFN 010 Solved Free Assignment 2023
Ans. To create an Excel worksheet with columns for Serial Number, Name of Student, Height, Weight, and Age of 40 students in class 1, follow the steps below:
➛ Open Microsoft Excel on your computer and create a new worksheet.
➛ In row 1, create headers for the five columns: Serial Number, Name of Student, Height, Weight, and Age.
➛ In rows 2 to 41, input the required data for the respective columns in 40 rows.
➛ To code male (M) and female (F) for each student, add a new column next to the Age column and label it “Gender”. MFN 010 Solved Free Assignment 2023
➛ In the Gender column, enter “M” for male students and “F” for female students.
➛ To calculate the number of males and number of females, add two new cells below the Gender column and label them “Number of Males” and “Number of Females”.
➛ In the Number of Males cell, type the following formula: =COUNTIF(E2:E41,”M”) where E2:E41 is the range of cells containing gender codes for all students.
➛ In the Number of Females cell, type the following formula: =COUNTIF(E2:E41,”F”) where E2:E41 is the range of cells containing gender codes for all students.
➛ To calculate BMI of each student, add a new column next to the Age column and label it “BMI”.
➛ In the first cell of the BMI column (B2), type the following formula: =C2/(D2*D2) where C2 is the weight of the first student and D2 is the height of the first student.
➛ Copy the formula to all cells in the BMI column (B3 to B41) to calculate BMI for all students.
➛ To create three categories of students falling under underweight, normal, and overweight according to WHO, 2004, add a new column next to the BMI column and label it “BMI Category”. MFN 010 Solved Free Assignment 2023
➛ In the first cell of the BMI Category column (C2), type the following formula: =IF(B2<18.5,”Underweight”,IF(B2<25,”Normal”,”Overweight”)) where B2 is the BMI of the first student.
➛ Copy the formula to all cells in the BMI Category column (C3 to C41) to categorize all students based on their BMI.
➛ To find out the sum of the number of students falling in each category of BMI, add three new cells below the BMI Category column and label them “Underweight”, “Normal”, and “Overweight”.
➛ In the Underweight cell, type the following formula: =COUNTIF(C2:C41,”Underweight”) where C2:C41 is the range of cells containing BMI categories for all students.
➛ In the Normal cell, type the following formula: =COUNTIF(C2:C41,”Normal”) where C2:C41 is the range of cells containing BMI categories for all students.
➛ In the Overweight cell, type the following formula: =COUNTIF(C2:C41,”Overweight”) where C2:C41 is the range of cells containing BMI categories for all students. MFN 010 Solved Free Assignment 2023
➛ To find the average BMI of the whole class, add a new cell below the Overweight cell and label it “Average BMI”.
➛ In the Average BMI cell, type the following formula: =AVERAGE(B2:B41) where B2:B41 is the range of cells containing BMI for all students.
➛ Print out the Excel worksheet, making sure that all columns and rows are visible, and attach it to your assignment.
Q 3. a) Illustrate the main parts and functions of a computer.
Ans. A computer is a complex electronic device that performs a variety of functions, from basic arithmetic operations to complex data processing and visualization.
Generally speaking, a computer consists of four main parts: input devices, output devices, a central processing unit (CPU), and storage devices.
Input devices allow users to enter data into the computer system. Some examples of input devices include keyboards, mice, touchpads, scanners, and microphones.
These devices convert the user’s input into electronic signals that can be processed by the computer. MFN 010 Solved Free Assignment 2023
Output devices, on the other hand, allow the computer to display or communicate the processed data to the user.
Examples of output devices include monitors, printers, projectors, and speakers. These devices convert the electronic signals from the computer into a format that can be understood by humans.
The CPU is the brain of the computer, responsible for executing the instructions that tell the computer what to do. It consists of a control unit, an arithmetic logic unit, and a set of registers.
The control unit retrieves instructions from memory and directs the operation of the other parts of the CPU, while the arithmetic logic unit performs arithmetic and logic operations on data.
Registers are small, high-speed memory units that store data and instructions that the CPU is currently working with. MFN 010 Solved Free Assignment 2023
Finally, storage devices allow the computer to store data and programs for later use. There are two main types of storage devices: primary storage and secondary storage.
Primary storage, also known as random-access memory (RAM), is temporary storage that the CPU can access quickly.
Secondary storage, such as hard drives, solid-state drives, and external storage devices, provides long-term storage for data and programs that the computer can access more slowly.
In addition to these four main parts, there are several other components that are essential for the proper functioning of a computer.
For example, a motherboard connects all of the parts of the computer together and provides communication pathways between them.
Power supplies provide the necessary electrical power for the computer to function, while cooling systems such as fans and heat sinks help regulate the temperature of the computer’s components. MFN 010 Solved Free Assignment 2023
In terms of function, computers can perform a wide range of tasks, depending on the software and hardware installed.
Some common functions include word processing, web browsing, email communication, data entry and storage, video and image editing, gaming, and scientific simulations.
To perform these functions, the computer relies on software programs that are designed to perform specific tasks, and the hardware components that provide the necessary processing power and storage capacity.
Overall, computers are complex devices that rely on a variety of components and technologies to function. MFN 010 Solved Free Assignment 2023
By understanding the main parts and functions of a computer, users can better appreciate the capabilities and limitations of these powerful machines.
b) Briefly describe the internet tools and discuss how to use the internet.
Ans. The internet is a vast network of interconnected devices that allows users to share information, communicate, and access a wide variety of resources.
There are many internet tools available that allow users to take advantage of these capabilities.
Some of the most commonly used internet tools include web browsers, search engines, email clients, social media platforms, and cloud storage services.
Web browsers are software applications that allow users to access and view websites on the internet. Some popular web browsers include Google Chrome, Mozilla Firefox, and Microsoft Edge. MFN 010 Solved Free Assignment 2023
To use a web browser, simply open the program and enter a website address or search term in the address bar. The browser will then connect to the website and display its content.
Search engines are another important internet tool that allow users to find information on the web.
Popular search engines include Google, Bing, and Yahoo. To use a search engine, simply enter a keyword or phrase in the search box and press enter. The search engine will then return a list of results related to the search query.
Email clients are software applications that allow users to send and receive email messages. MFN 010 Solved Free Assignment 2023
Some popular email clients include Gmail, Microsoft Outlook, and Yahoo Mail. To use an email client, simply create an account and log in.
From there, you can compose and send email messages to other users, as well as receive and read messages sent to you.
Social media platforms are online communities that allow users to connect with others and share information.
Some popular social media platforms include Facebook, Twitter, and Instagram. To use a social media platform, simply create an account and log in.
From there, you can connect with friends and family, share photos and videos, and stay up to date with news and trends. MFN 010 Solved Free Assignment 2023
Cloud storage services are online storage solutions that allow users to store and access files from anywhere with an internet connection.
Some popular cloud storage services include Google Drive, Dropbox, and OneDrive. To use a cloud storage service, simply create an account and log in.
From there, you can upload and access files from any device with an internet connection.
To use the internet effectively, it is important to have a basic understanding of how it works and how to navigate it safely. Some tips for using the internet safely include:
➛1. Use strong and unique passwords for all online accounts
➛2. Avoid clicking on suspicious links or downloading unknown files
➛3. Be wary of sharing personal information online
➛4. Keep software and security settings up to date
➛5. Use a reputable antivirus program to protect against malware and other threats.
In summary, the internet offers a wide variety of tools and resources that can be used for communication, information sharing, and productivity.
By understanding how to use these tools safely and effectively, users can take full advantage of the internet’s capabilities and enhance their online experience.
Q 4. Explain the following term with the help of an example/diagram, if needed:
a. Disk defragmenter
b. Hard disk
c. Title bar
e. Data Processing Cycle
f. Device driver
i. Carpal tunnel syndrome
Ans. a. Disk defragmenter: MFN 010 Solved Free Assignment 2023
A disk defragmenter is a software tool that reorganizes the data on a hard disk, making it more efficient and faster to access.
It works by rearranging the fragmented files and storing them in contiguous blocks on the disk. This process helps to improve the overall performance of the computer.
When you save a file on your computer, the data is often broken up into small fragments and stored in different locations on the hard disk.
Over time, as you create and delete files, these fragments become scattered, which can slow down your computer’s performance.
Running a disk defragmenter tool can help to reorganize the data on your hard disk, making it faster and more efficient to access.
b. Hard disk: MFN 010 Solved Free Assignment 2023
A hard disk, also known as a hard drive, is a non-volatile storage device that stores and retrieves digital data using one or more rigid rapidly rotating disks (platters) coated with magnetic material.
The data is read from and written to the disk by a read/write head that moves back and forth over the surface of the disk.
The hard disk is a common storage device found in computers, laptops, and servers. It is used to store the operating system, software applications, documents, photos, videos, and other files. MFN 010 Solved Free Assignment 2023
A typical hard disk drive can store several terabytes of data, making it an essential component for many computing applications.
c. Title bar:
The title bar is a graphical element at the top of a window that displays the name of the window and other information, such as the program name, document name, and version number. It also provides buttons to minimize, maximize, and close the window.
In a web browser, the title bar displays the name of the webpage you are currently viewing. In a word processor, the title bar displays the name of the document you are working on. MFN 010 Solved Free Assignment 2023
The title bar is a standard element in most graphical user interfaces and provides a quick way to identify and manage multiple windows on a computer screen.
Ergonomics is the scientific study of designing equipment, devices, and systems that fit the human body’s physical and cognitive capabilities.
It aims to optimize productivity and reduce the risk of injury or strain to the user.
Example: MFN 010 Solved Free Assignment 2023
Ergonomics can be applied to the design of a computer keyboard and mouse. An ergonomic keyboard is designed to reduce the strain on the hands and wrists when typing, while an ergonomic mouse is designed to reduce the strain on the hand and fingers when using the mouse.
By using ergonomic equipment, users can work more comfortably and efficiently, reducing the risk of repetitive strain injuries.
e. Data Processing Cycle:
The data processing cycle is a series of steps that are followed in the processing of data, including data input, data processing, data storage, and data output.
The cycle is a continuous process, and each step depends on the output of the previous step.
Example: MFN 010 Solved Free Assignment 2023
The data processing cycle is used in many applications, such as online banking, inventory management, and payroll processing.
In online banking, the cycle starts with the input of user data, such as a username and password.
The data is then processed by the system to validate the user’s identity and retrieve account information.
The information is stored in a database for future use and displayed to the user as output. MFN 010 Solved Free Assignment 2023
f. Device driver:
A device driver is a software component that allows an operating system to interact with hardware devices like printers, scanners, and graphics cards.
It acts as a bridge between the hardware and software, translating instructions from the operating system into commands that the hardware can understand.
For example, when you connect a new printer to your computer, you need to install the device driver to enable the computer to communicate with the printer.
g. Thesaurus: MFN 010 Solved Free Assignment 2023
A thesaurus is a reference book or software tool that provides synonyms and antonyms for words. It helps writers to find alternative words and avoid repetition in their writing.
For example, if you are writing a paper and want to find a synonym for the word “happy,” you can look it up in a thesaurus and find words like “joyful,” “content,” and “pleased.”
Ribbon is a graphical user interface element that displays commands and options in a series of tabs on the top of an application window.
It was introduced in Microsoft Office 2007 and has since become a popular interface design pattern. MFN 010 Solved Free Assignment 2023
The ribbon is designed to make it easier for users to find and use the features they need.
For example, the ribbon in Microsoft Word includes tabs for “Home,” “Insert,” “Page Layout,” “References,” “Mailings,” “Review,” and “View.”
i. Carpal tunnel syndrome:
Carpal tunnel syndrome is a medical condition that occurs when the median nerve, which runs from the forearm into the hand, is compressed at the wrist.
It can cause numbness, tingling, and weakness in the hand and wrist. The condition is often caused by repetitive motions of the hand and wrist, such as typing or using a mouse for long periods. MFN 010 Solved Free Assignment 2023
For example, people who work on computers for extended periods of time are at higher risk of developing carpal tunnel syndrome.
A macro is a series of commands or instructions that can be recorded and played back later to automate repetitive tasks.
Macros are commonly used in spreadsheet programs like Microsoft Excel to perform calculations or formatting operations on a large number of cells.
For example, you can create a macro to add up the values in a specific range of cells, apply a specific formatting style to a group of cells, or sort a table based on specific criteria. MFN 010 Solved Free Assignment 2023
k. Mail Merge:
Mail merge is a feature in word processing software that allows users to create form letters, mailing labels, and envelopes by merging a document template with a list of names and addresses.
For example, you can use mail merge to send personalized letters or emails to a large number of recipients, with each letter or email containing specific information for the recipient. MFN 010 Solved Free Assignment 2023
l. Scan Disk:
Scan Disk is a utility program in Microsoft Windows that scans a hard drive for errors and bad sectors and fixes them.
It is used to check the file system and data integrity of a hard drive and can help to prevent data loss and system crashes.
For example, if you suspect that your computer’s hard drive has been damaged or has bad sectors, you can run Scan Disk to identify and repair the problem.
M. Character Map: MFN 010 Solved Free Assignment 2023
Character Map is a utility program in Microsoft Windows that allows users to view and insert special characters and symbols that are not available on the keyboard.
For example, if you want to insert the copyright symbol (©) or the registered trademark symbol (®) into a document, you can use Character Map to find and insert these symbols.
A database is a collection of data that is organized in a specific way to allow for efficient storage, retrieval, and management of information.
Databases can be used for a wide variety of applications, such as managing customer information, tracking inventory, or analyzing financial data.
For example, a business may use a database to keep track of customer orders and payments, or a library may use a database to manage its book collection.
O. Email Etiquette: MFN 010 Solved Free Assignment 2023
Email etiquette refers to the customary rules and guidelines for communicating effectively and professionally via email.
It includes guidelines for things like subject lines, email structure, tone, and grammar.
For example, some common email etiquette rules include using a clear and concise subject line, avoiding all caps and excessive punctuation, and proofreading the email before sending it.
Proper email etiquette can help to ensure that your message is clear, professional, and well-received by the recipient. MFN 010 Solved Free Assignment 2023
Q 5. Differentiate between the following terms:
i) Hardware and Software
Ans. i) Hardware and Software:
Hardware refers to the physical components of a computer system, such as the keyboard, mouse, monitor, and motherboard.
Software, on the other hand, refers to the programs, applications, and instructions that tell the hardware what to do.
In simple terms, hardware is the physical equipment, and software is the set of instructions that operate the hardware.
ii) Folder and File:
A folder is a container that holds files or other folders, and it is used to organize and store files on a computer system. MFN 010 Solved Free Assignment 2023
A file, on the other hand, is a collection of data that is stored on a computer system and is identified by a unique name and location.
In other words, a file is a digital document or piece of information, while a folder is a container that holds files.
iii) LAN and WAN:
LAN stands for Local Area Network and refers to a computer network that connects devices within a limited geographic area, such as a building or campus.
WAN stands for Wide Area Network and refers to a computer network that connects devices across a large geographic area, such as a city or country.
The main difference between the two is the size of the area they cover and the type of devices they connect. MFN 010 Solved Free Assignment 2023
iv) AutoText and AutoCorrect:
AutoText and AutoCorrect are features in word processing software that automate text entry and correct spelling and grammar errors.
Autotext is a shortcut that allows users to insert frequently used words, phrases, or paragraphs into a document with a single keystroke.
AutoCorrect, on the other hand, automatically corrects common spelling and grammar mistakes as the user types.
The main difference between the two is that AutoText inserts text, while AutoCorrect corrects text. MFN 010 Solved Free Assignment 2023
v) Formula and Function:
A formula is a mathematical equation or expression used in spreadsheet software to perform calculations or manipulate data.
A function, on the other hand, is a predefined formula that performs a specific task or operation.
Functions can be used to perform complex calculations or operations, such as finding the average or maximum value in a range of cells.
The main difference between the two is that a formula is a user-created equation, while a function is a pre-built, ready-to-use formula.