Computer Fundamentals, MS Office and Internet & Web Technology (Open Course), Semester 5 2018-21, Model Examination, January 2021

 

COMPUTER FUNDAMENTALS, MS OFFICE AND INTERNET & WEB TECHNOLOGY

Total : 80 marks                                                                    Time: 3 hours

Section A

Answer any 10 questions. Each question carries 2 marks.

1. Expand ENIAC.

ENIAC, in full Electronic Numerical Integrator and Computer, the first programmable general-purpose electronic digital computer

2. Define a workstation?

Workstation, a high-performance computer system that is basically designed for a single user and has advanced graphics capabilities, large storage capacity, and a powerful microprocessor (central processing unit)

3. List out 2 functions of an OS.

Following are some of important functions of an operating System.

• Memory Management.
• Processor Management.

 

4. Define E-Mail.

electronic mail, e-mail or email is information stored on a computer that is exchanged between two users over telecommunications. More plainly, e-mail is a message that may contain text, files, images, or other attachments sent through a network to a specified individual or group of individuals

5. Illustrate Client Server Communication.

The client-server characteristic describes the relationship of cooperating programs in an application. ... Client software can also communicate with server software within the same computer. Communication between servers, such as to synchronize data, is sometimes called inter-server or server-to-server communication

 

6. Recall the usage of Macros.

 macro is used to automate a task that you perform repeatedly or on a regular basis. It is a series of commands and actions that can be stored and run whenever you need to perform the task. You can record or build a macro and then run it to automatically repeat that series of steps or actions.

 

7. Briefly explain the usage of Protect function.

Before you send a Microsoft Word document to another person for their comments, you can make use of a feature called Document protection. When you protect a document, the only changes that can be made to it are Tracked changes and Comments.

8. Illustrate the use of title bar.

At the top of every window is the title bar, which displays the name of the application. It also has buttons that are clicked to minimize and restore the window and exit the application (see Win Minimize windows). When a window is selected, its title bar changes color and becomes the "active" window. Windows Title Bars.

9. Classify the different types of layouts.

      Types of  Slide layout. ...

·         Table of content Slide Layout. ...

·         Simple Text Content Slide layout. ...

·         Two Text Content Slide layout. ...

·         Content Slide layout [Text + Picture] ...

·         Content Slide layout [Texts + Pictures] ...

·         Impact Message Slide Layout.

 

10. Demonstrate the use of templates.

   A template is a predesigned document you can use to create documents quickly without having to think about formatting. With a template, many of the larger document design decisions such as margin size, font style and size, and spacing are predetermined.

11.  List out the steps to add sound clip.

     In Normal view, click the slide that you want to add a sound to. On the Insert tab, in the Media group, click the arrow under Audio. In the list, click Audio from file or Clip Art audio, locate and select the audio clip that you want, and then click Insert. The audio icon and controls appear on the slide.

12. What happens when you delete a file.

       When you "delete" a file, it gets moved to the trash or recycle bin in your operating system. Essentially, you're only removing the map to the data not the data itself while also giving the operating system permission to overwrite that area of the hard drive

   

                                                                                    (10 x 2 = 20 Marks)

 

Section B

Answer any 6 questions. Each question carries 5 marks.

13. Illustrate the working of a computer with a neat diagram.

The 5 different parts of a computer—taking a look under the hood

ALU

CPU

MEMORY

INPUT UNIT

OUTPUT UNIT 

14. Compare LAN and WAN.

LAN and WAN

A LAN (local area network) is a group of computers and network devices connected together, usually within the same building. ... A WAN connects several LANs, and may be limited to an enterprise (a corporation or an organization) or accessible to the public. The technology is high speed and relatively expensivE

 

15. Briefly explain the possibilities of URLs.

      A Uniform Resource Locator (URL), colloquially termed a web address,is a reference to a web resource that specifies its location on a computer network and a mechanism for retrieving it. A URL is a specific type of Uniform Resource Identifier (URI)

 

16. Discuss about IP Addressing.

An IP address is an address used in order to uniquely identify a device on an IP network. The address is made up of 32 binary bits, which can be divisible into a network portion and host portion with the help of a subnet mask.

17. List out the types of text formatting functions.

bold

italics

underline

 

 

18. Briefly explain the use of borders and shading.

      Borders are rules you can add to any or all of the four sides of a paragraph. Shading is the color or artistic design you use as background for a paragraph. Borders and shading are formatting tools for enhancing text, paragraphs, table cells or frames.

19.  Demonstrate the commands in the font group.

  Decrease Font Size – Used to decrease font types in excel. 

Bold – Used to make the text bold in excel.

 Italic – Used to make the text italic in excel. 

Underline – Used to underline the text 

20. How would you create a slide show?

    To start a slide show:

Select the Slide Show view command at the bottom of the PowerPoint window to begin a presentation from the current slide. Go to the Slide Show tab on the Ribbon to access even more options. From here, you can start the presentation from the current slide and access advanced presentation options

21.  Illustrate the working of rehearsal timing.

       Rehearse timing is a feature which allows one to record the time of slide preparation. It automatically records the time and present the slides in the orderly manner and keep them on screen for the set time. The rehearse time provide an advantage to record audio with each presentation slide

(6 x 5 = 30 Marks)

 

Section C

Answer any 2 questions. It carries 15 marks.

22. Compare Internet with intranet.

.

Internet:

Internet is used to connect different network of computers simultaneously. It is a public network therefore anyone can access the internet. In internet, there are multiple users and it provides unlimited number of information to the users.

Intranet:

Intranet is the type of internet which is used by privately. It is a private network therefore anyone can’t access intranet. In intranet, there are limited number of users and it provides limited number of information to its users.

Now, we shall see the difference between internet and intranet:

S.NO	Internet	Intranet
1.	Internet is used to connect different network of computers simultaneously.	Intranet is owned by private firms.
2.	In internet, there are multiple users.	In intranet, there are limited users.
3.	Internet is unsafe.	Intranet is safe.
4.	In internet, There are more number of visitors.	In intranet, There are less number of visitors.
5.	Internet is a public network.	Intranet is a private network.
6.	Anyone can access Internet.	In this, anyone can’t access the Intranet.
7.	Internet provides unlimited information.	Intranet provides limited information.

 

23. Elaborate the working of Mail merge.

       Mail Merge is most often used to print or email form letters to multiple recipients. Using Mail Merge, you can easily customize form letters for individual recipients. Mail merge is also used to create envelopes or labels in bulk.

This feature works the same in all modern versions of Microsoft Word: 2010, 2013, and 2016.

1. In a blank Microsoft Word document, click on the Mailings tab, and in the Start Mail Merge group, click Start Mail Merge.
2. Select your document type. In this demo we will select Letters
3. Select the starting document. In this demo we will use the current (blank) document. Select Use the current document and then click
4. Select recipients. In this demo we will create a new list, so select Type a new list
5. Create a list by adding data in the New Address List dialog box and clicking OK
6. Selecting Edit recipient list opens up the Mail Merge Recipients dialog box, where you can edit the list and select or unselect records. Click OK to accept the list as is

7.  Write the letter and add custom fields.

• Click Address block to add the recipients' addresses at the top of the document

8. In the Insert Address Block dialog box, check or uncheck boxes and select options on the left until the address appears the way you want it to

9.click Greeting line... to enter a greeting

10. In the Insert Greeting Line dialog box, choose the greeting line format by clicking the drop-down arrows and selecting the options of your choice, 

11. Preview your letter

12.Click Print to print your letters or Edit individual letters to further personalize some or all of the letters

 

24. Explain E- Mail.

Electronic mail (e-mail) is a computer-based application for the exchange of messages between users. A worldwide e-mail network allows people to exchange e-mail messages very quickly. E-mail is the electronic equivalent of a letter, but with advantages in timeliness and flexibility. While a letter will take from one day to a couple of weeks to be delivered, an e-mail is delivered to the intended recipient's mailbox almost instantaneously, usually in the multiple-second to subminute range. This is the case whether the e-mail is exchanged between people on the same floor of a business, or between friends at opposite points on the globe. This article provides a comprehensive, intermediate-level overview of e-mail, including its main functions, historical and current architectures, key standards, supporting infrastructure, and contemporary and future issues.

 Briefly explain advantages and disadvantages.

25. Elaborate the user interface components of MS Power point.    

  The PowerPoint window contains many elements that are similar to other Microsoft Office programs. These elements include the Office button, Quick Access toolbar, Title bar, Tabs, scroll bars and a Status bar. Quick access toolbar contains buttons for commonly-used commands

 Features of MS Powerpoint

• Customize Color Schemes.
• Add Animation effects.
• Use the Slide, Notes and Handout Masters.
• Create, Edit and Import Charts.
• Create and Edit Tables.
• Manage Hyperlinks.
• Create Custom Shows.
• Export Outlines & Presentation Slides to Word.

Components: -

1. Office button
2. Ribbon
3. Tab
4. Quick access toolbar
5. Title bar
6. Group categories
7. Dialogue box launcher
8. View buttons
9. Contextual tabs

 

(2 x 15 = 30 Marks)