Assignment Code: MFN-010/AST-6/TMA/22-23

Course Code: MFN-010

Assignment Name: Understanding Computer Applications

Year: 2022-2023

Verification Status: Verified by Professor

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) PowerPoint File is provided along with the assignment

i) It should have a master slide with a title

By customizing slide masters, you can create precisely the presentation design and layouts you need. If you want a section of your presentation to look different from the rest of the slides, with its own layouts, create an additional slide master for that section.

Add an additional slide master to a presentation

Click VIEW > Slide Master.

On the SLIDE MASTER tab, do one of the following:

In the Edit Theme group, click Themes, and then under Built-in, select a theme that you want the additional slide master to adhere to.

In the Edit Master group, click Insert Slide Master. Note that, if you use this procedure, the slide master appears without theme color and effects.

ii) Insert header and footer in all slides except master

Click INSERT > Header & Footer. On the Slide tab, check Footer. In the box below Footer, type the text that you want, such as the presentation title. Check Date and time to add that to your slides.

iii) Show some data using a chart or graph

To create a simple chart from scratch in PowerPoint, click Insert > Chart and pick the chart you want. ... Click Insert > Chart. ... Click the chart type and then double-click the chart you want.. In the worksheet that appears, replace the placeholder data with your own information. When you insert a chart, small buttons appear next to its upper-right corner. Use the Chart Elements Chart Elements button button to show, hide, or format things like axis titles or data labels. Or use the Chart Styles Customize the Look of Your Chart button button to quickly change the color or style of the chart. When you’ve finished, close the worksheet.

iv) Include smart art in one of the slides

Select your text.

Select Home > Convert to SmartArt.

Select More SmartArt Graphics and then select Picture.

Select the SmartArt you want and select OK.

To insert a picture, select the picture icon, go to where your picture is located, and then select it.

Select Insert.

v) Insert picture in one of the slides

Click where you want to insert the picture on the slide.

On the Insert tab, in the Images group, click Pictures and then click This Device.

In the dialog box that opens, browse to the picture that you want to insert, click that picture, and then click Insert.

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:

Excel file is given along with this assignment

i) Coding of male (M) and female (F) and calculate the number of males and number of females by giving formula in the cell.

1. Added data M and F for gender as a column.

2. Used the following formula to calculate the number of Females =COUNTIF(F1:F41,"=F")

3. Hence total females are 19 and the remainder of 21 are males.

ii) Calculate BMI of each student by putting formula for BMI.

1. Added column and called it BMI

2. Used the following formula to calculate BMI: =D2/C2^2*10

3. BMIs are visible in the ranges of 14-26

iii) Create three categories of students falling in underweight, normal and overweight according to WHO, 2004.

1. Added three columns as required. Category 1, 2 and 3.

2. As per WHO, Less than 18.5 is underweight, hence used formula =IF(G3<18.5,"Underweight","") to calculate this automatically.

3. Produced other two categories similarly with the logic 18.5-24.9 is healthy and 25+ is overweight.

iv) Find out sum of the number of students falling in each category of BMI and

1. Added a table

2. Inserted a totals row

3. used sum function to get totals of 21, 17, and 2 in Categories 1,2 and 3 respectively.

v ) Average BMI of whole class.

1. In totals row, click on Average in the BMI column

2. Average BMI is 18.22

3. a) Illustrate the main parts and functions of a computer. (10)

Ans) A computer includes four major components that are meant to carry out the four essential tasks listed below.

Inputting

Users must enter their data into the computer for computation to take place. An input device, such as a keyboard or mouse, is used to enter the data. An example of an input device that takes data and converts it into electronic signals is a keyboard. For instance, when we press the letter A on the keyboard, the computer receives the electronic code that represents it. Input of data into the computer is thus possible via the keyboard. Other types of input devices include a mouse and a scanner.

Processing

Processing is the term used to describe the computations and other operations a computer carries out on data. Data is processed by the computer in accordance with a set of guidelines known as a programme. The processor, a crucial component of a computer, does processing.

The central processing unit (CPU), where the real processing happens, houses the processor as well as many other components. The Control Unit and Arithmetic Logic Unit make up the CPU. The instructions that the central processor receives from the memory are what regulate it. Until a task is finished, the CPU retrieves and executes each of these instructions individually. Each instruction instructs the CPU on what to do (add, divide, move, and compare), as well as where to locate the data to be processed in the memory. The primary CPU is extremely quick, processing one billion instructions or more every second. The Pentium 4 is a 1.5 GHz CPU that is currently in use. It means that this CPU is capable of doing a straightforward addition in 1/1.5*109 seconds.

Outputting

The user-friendly version of the processed information is printed by the computer. Using an output device, such as a printer or monitor, the data is printed, displayed, or reported. Output devices transform data from the computer's electronic form into a format that people can use readily.

Storing

The data or instructions are saved by the computer on various storage media for later usage and retrieval. The term "memory" is widely used to describe the storage spaces. A computer's memory is where information and programmes are kept. There are two sorts of memory. One intended for long-term storage, or auxiliary memory, and the other intended for short-term storage, or main memory. Below is a discussion of both.

Main memory - Data and instructions are temporarily stored in main memory. Internal Memory is another name for this memory, which is typically not isolated from the computer. It is necessary to store data and instructions in main memory from which they can be retrieved by the central processing unit to process results. RAM, or random access memory, is another name for this memory. The primary memory is built with speed in mind. Its volatile ness is a very significant feature.

Auxiliary memory - Programs and data that must be utilised repeatedly are stored in auxiliary or secondary memory. This memory is also known as external memory because it is regularly taken out from the computer. Hard discs and floppy discs.

Auxiliary storage is used to store programmes and data that the computer won't immediately need because of its poor pace. When necessary, the data and programmes are subsequently copied into main memory, which is faster. The nature of this memory is non-volatile.

b) Briefly describe the internet tools and discuss how to use the internet. (10)

Ans) In addition to the usual data transport, the internet may and does offer a wide range of other services. These features include Gopher, Chat, Email, and News Groups.

Chat: Chatting is the term used to describe communication between two or more individuals over the Internet that mimics face-to-face conversation.

E-mail: Emailing is the act of sending a message to another user over the Internet so that the recipient can read it later, as opposed to immediately. The exchange of computer-stored communications via telecommunication is known as e-mail (or electronic mail). (While some spell it email, we favour the more common spelling of e-mail.) Non-text tiles, such graphic pictures and music files, can also be transmitted as attachments using binary streams. The most widely used application of the Internet was and continues to be e-mail. E-mail accounts for a sizable portion of all Internet traffic. Both individual recipients and lists of recipients can receive emails.

News Groups: News Groups are specialised groups of people who frequently communicate with one another using the channels in order to have conversations about specialised subjects. For instance, there might be a newsgroup for those who want to garden, are interested in ETs, etc.

Gopher: It is a search tool that facilitates finding information on the Internet about any topic at all.

World Wide Web (WWW): The collection of web pages accessible through the Internet is known as the World Wide Web (WWW).

Uniform Resource Locator (URL): For Uniform Resource Locator, it is known. The Uniform Resource Locator is a special address that each web page on the Internet has. we must be aware of a document's Uniform Resource Locator in order to locate it on the World Wide Web (URL).

Web Browser: An application programme called a web browser enables us to access websites. Internet Explorer is the browser that comes with Windows. We may also have access to browsers from other sources, such as Netscape Navigator.

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

a. Disk defragmenter

Ans) The hard disc is where files and folders are saved when we install software or create them. It is possible that these files are divided into numerous segments before being stored, rather than being kept in a single sequence. This is due to the possibility that the file is too large to fit in a single available hard disc space.

A utility called Disk Defragmenter rearranges all of we files. Depicts the fragmentation of a disc. All of the files are rearranged such that they are all saved in the same order.

b. Hard disk

Ans) hard disk, also called hard disk drive or hard drive, magnetic storage medium for a computer. Hard disks are flat circular plates made of aluminium or glass and coated with a magnetic material. Hard disks for personal computers can store terabytes (trillions of bytes) of information.

c. Title bar

Ans) The title bar, which is often a dark blue strip at the top of every window, shows the name of the programme (such as notepad, word, etc.) that is now open in that window. A few (usually three) buttons are also present in the right-hand corner of the title bar. The buttons are labelled minimise, maximise, and close, accordingly. A window can be made as tiny as possible using the minimise button, expanded with the maximise button, and closed using the close button.

d. Ergonomics

Ans) Ergonomics (or human factors) is the scientific discipline concerned with the understanding of interactions among humans and other elements of a system, and the profession that applies theory, principles, data and methods to design in order to optimize human well-being and overall system performance.

e. Data Processing Cycle

Ans) Data Input- the collected data is converted into machine-readable form by an input device, and send into the machine. Processing is the transformation of the input data to a more meaningful form (information) in the CPU. Output is the production of the required information, which may be input in future.

f. Device driver

Ans) A device driver is a particular form of software application that allows one hardware device (such as a personal computer) to interact with another hardware device (such as a printer). A device driver may also be called a software driver.

g. Thesaurus

Ans) A thesaurus (plural thesauri or thesauruses) or synonym dictionary is a reference work for finding synonyms and sometimes antonyms of words. They are often used by writers to help find the best word to express an idea: ...to find the word, or words, by which [an] idea may be most fitly and aptly expressed.

h. Ribbon

Ans) n computer interface design, a ribbon is a graphical control element in the form of a set of toolbars placed on several tabs. The typical structure of a ribbon includes large, tabbed toolbars, filled with graphical buttons and other graphical control elements, grouped by functionality. Such ribbons use tabs to expose different sets of controls, eliminating the need for numerous parallel toolbars. Contextual tabs are tabs that appear only when the user needs them.

i. Carpal tunnel syndrome

Ans) Repetitive motions such as using a computer mouse and typing on a keyboard can cause carpal tunnel syndrome. The way an individual places their hands on a keyboard or computer mouse, positioning the wrists and fingers in one way for long periods of time, can lead to compression on the median nerve

j. Macro

Ans) Macros are sequences of events (such as keystrokes, mouse clicks, and delays) that can be played back to help with repetitive tasks. They can also be used to replay sequences that are long or difficult to run. we can assign a macro recorded in Microsoft Mouse and Keyboard Center to a key or a mouse button.

k. Mail Merge

Ans) Mail merge lets we create a batch of documents that are personalized for each recipient. For example, a form letter might be personalized to address each recipient by name. A data source, like a list, spreadsheet, or database, is associated with the document.

l. Scan Disk

Ans) ScanDisk is a DOS utility application used to check and correct errors on hard and floppy disks.

m. Ergonomics

Ans) The study of the workplace and its surroundings in order to increase productivity is known as ergonomics.

n. Database

Ans) A database is a particular kind of file that is intended to contain data about each employee of a company, such as name, address, phone number, city, and country.

o. Email Etiquette

Ans) Etiquette is crucial in real life, and it is equally crucial online. Sometimes they are referred regarded as "Netiquette," but when they apply only to emails, they are called "Email Etiquette."

5. Differentiate between the following terms: (10)

i) Hardware and Software

Ans) Difference between the hardware and software as following table:

iv) AutoText and AutoCorrect

Ans) Comparison between auto text and auto correct as follows:

1. AutoCorrect is available in other applications. AutoText is available only within Word (and Outlook e-mail if Word is one’s e-mail editor). Therefore, AutoCorrect is more useful for content such as  company name, which will be used in multiple programs.

2. AutoText can replace an abbreviation with any content, including pictures, text with complex formatting, even tables. AutoText can contain anything can do in Word. Therefore, within Word, AutoText can often be more flexible and powerful.

3. AutoText does not replace the abbreviation automatically must instruct Word to replace by pressing F3. Therefore, can use real words and abbreviations for AutoText entries—they will not be mistakenly replaced.

4. AutoText entries can also be printed out, delegated between templates, and easily copied to other templates or other users.

v) Formula and Function

Ans) Difference between formula and function as follows:

1. To modify things, a function can be modified as per the developer’s requirement but the formula cannot be updated like this. One can use formula only in times of need.

2. A function can be used as a formula but formula cannot be used as a function.

3. The user can use a formula to do simple calculations manually but in the case of using a function, it’s not so easy to work out complex calculations using a function.

4. In excel there is no structure or syntax of formula but functions do have a syntax.

5. Every function has its own pre-designed parameters basis through which a function executes results. A formula can never have pre-defined parameters.