Maxen Computer Education

DOEACC NIELIT O Level A1 R3 July 2008 Question Answer Sample Model Paper Solutions

Ans. 6(b)

Multimedia: Multimedia is media that utilizes a combination of different content forms. The term can be used as a noun (a medium with multiple content forms) or as an adjective describing a medium as having multiple content forms. The term is used in contrast to media which only utilize traditional forms of printed or hand-produced text and still graphics. In general, multimedia includes a combination of text, audio, still images, animation, video, and interactivity content forms.

Multimedia is usually recorded and played, displayed or accessed by information content processing devices, such as computerized and electronic device, but can also be part of a live performance. Multimedia (as an adjective) also describes electronic media devices used to store and experience multimedia content. Multimedia is similar to traditional mixed media in fine art, but with a broader scope. The term “rich media” is synonymous for interactive multimedia. Hypermedia can be considered one particular multimedia application.

Much of the electronic old and new media utilized by commercial artists is multimedia. Exciting presentations are used to grab and keep attention in advertising. Industrial, business to business, and interoffice communications are often developed by creative services firms for advanced multimedia presentations beyond simple side shows to sell ideas or liven-up training. Commercial multimedia developers may be hired to design for governmental services and nonprofit services applications as well.

Ans. 6(C)

Functional Units Of A Computer System: Digital computer systems consist of three distinct units. These units are as follows:

  • Input unit
  • Central Processing unit
  • Output Unit

These units are interconnected by electrical cables to permit communication between them. This allows the computer to function as a system.

Input Unit: A computer must receive both data and program statements to function properly and and be able to solve problems. The method of feeding data and programs to a computer is accomplished by an input device. Computer input devices read data from a source, such as magnetic disks, and translate that data into electronic impulses for transfer into the CPU. Some typical input devices are a keybaord, a mouse, or a scanner.

Central Processing Unit: The brain of a computer system is the central processing unit (CPU), The CPU processes data transferred to it from one of the various input devices. It then transfers either an intermediate or final result of the CPU to one or more output devices. A central control section and work areas are required to perform calculations or manipulate data. The CPU is the computing center of the system. It consists of a control section, an arithmetic-logic section and an internal storage section (main memory). Each section within the CPU serves a specific function and has a particular relationship with the other sections within the CPU.

Control Section: The control section directs the flow of traffic (operations) and data. It also maintains order within the computer. The control section selects one program statement at a time from the program storage area, interprets the statement, and sends the appropriate electronic impulses to the arihetic-logic and storage sections so they can carry out the instuctions. The control section does not perform actual processing operations on the data. The control section instructs the the input device on when to start and stop receiving data from the output storage area.

Arithmetic-logic Section: The arithmetic logic section performs arithmetic operations, such as addition, subtraction, multiplication, and division. Throughinternal logic capability, it tests various conditions encountered during processing and takes action based on the result. As indicated by the solid arrows in figure 3-1, data flows between the arithmetic-logic section and the internal storage section during processing. Specifically, data is transferred as needed from the storage section to the arithmetic-logic section, processed, and returned to internal storage. At no time does processing take place in the storage section. Data maybe transferred back and forth between these two sections several times before processing is completed. The results are then transferred from internal storage to an output device.

Internal Storage Section: The internal storage section is sometimes called primary storage, main storage, or main memory, because this section functions similar to our own human memory.

Output Unit: As program statements and data are received by the CPU from an input device, the results of the processed data are sent from the CPU to an OUT   put device. These results are transferred from the output storage area onto an output medium, such as a floppy disk, hard drive, video display, printer, and so on.

Central Processing Unit
Central Processing Unit

Ans. 7(a)

  1. MACRO is an action or a set of actions that you can use to automate tasks. Macros are recorded in the Visual Basic for Applications programming language.
Create a macro

Record a macro

2. Set the security Level to Medium or Low.

3. On the Tools menu, point to Macro, and then click Record New Macro.

4. In the Macro name box, enter a name for the Notes

·         The first character of the macro name must be letter. Other characters can be letters, numbers, or underscore characters. Spaces are not allowed in a macro name; an undersore character works well as a word separator.

·         Do not use a macro name that is also a cell reference or you can get an error message that the macro name is not valid.

5. If you want to run the macro by pressing a keyboard shortcut key (shortcut key: A function key or key combination, such as F5 or CTRL + A, that you use to carry out a menu command. In contrast, an access key is a key combination, such as ALT + F, that moves the focus to a menu, command, or control.), enter a letter in the Shortcut key box. You can use CTRL + letter (for lowercase letters) or CTRL + SHIFT + letter (for uppercase letters), where letter is any letter key on the keyboard. The shortcut key letter you use cannot be a number or is any letter key on the keyboard. The shortcut key letter you use cannot be a number or special character such as @ or #.

6. In the Store macro in box, click the location where you want to store the macro. If you want a macro to be available whenever you use Excel, select Personal Macro Workbook.

7. If you want to include a description of the macro, type it in the Description box.

8. Click OK.

9. If you want the macro to run relative to the position of the active cell, record it using relative cell references. On the Stop Recording Toolbar, click Relative Reference so that it is selected. Excel will continue to record macros with relative references until you quit Excel or until you clik Relative Reference again, so that it is not selected.

10. Carry out the actions you want to record.

11. On the Stop Recording toolbar, click Stop Recording

Automatic macros. Such as Auto _ Activate, are designed to run when you start Microsoft Excel.


Leave a Comment