Information & Communication Technology Centre

University of Kelaniya – Sri LankaAcademic Year 2013/2014- First Semester

No of Pages: 15 Time: 02 12

hours

Student No:

SubjectIntroducti

onWord Excel Access

PowerPoint

Internet& E-mail

KBMarks

Student Name: …………………………………………………………………………………………………………….

Q-01: INTRODUCTION TO COMPUTERS (Time: 25 Minutes)

Part AUnderline the most suitable answer

1. The basic operations performed by a computer are

a. Arithmetic operation b. Logical operation c. Storage and relative

d. Input and outpute. All the above

f.

2. Integrated Circuits (ICs) are related to which generation of computers?

a. First generation b. Second generation c. Third generation

d. Fourth generatione. Fifth generation

f.3. Software in computer

a. Enhances the capabilities of the hardware machine

b. Increase the speed of central processing unit

1 | P a g e

EXAM

COMPUTER LITERACY – COMP 1301222nd June 2015

/ /

c. Increase the speed of hard disk

d. Answer A and B.e. None of above.

f.4. The difference between RAM and storage memory is, that RAM Is

_____ and storage memory is ____

a. Temporary, permanent

b. Permanent, temporary

c. Slow, fast

d. Answer A and Ce. All of above

f.5. Which of the following statement is false?

a. Mechanical analog computers have existed for thousands of years b. There are mechanical analog computers and electronic

analog Computers. c. All electronic computers are digital computers d. Answer A and Be. All of above are false

g.6. Operating system, editors, and debuggers comes under?

a. System Software b. Application

Software

c. Utilitiesd. BIOS e. None of the above

f.

7.8. The output quality of a printer is measured by

a. Dots per sq. inch b. Dots per inch c. Dots printed unit

time

d. Dots per unit e. Dots printed inch

f.9. ASCII stands for

a. American Stable Code for International Interchange b. American Standard Case for Institutional Interchange c. American Standard Code for Information Interchange d. American Standard Code for Interchange Informatione. American Standard Codes for Input Informationg.

10. An example for customized software?

a. Coral Drawb. Photoshop c. VB. Net

d. Inventory Systeme. MS word

f.

2 | P a g e

11. Which of the following devices have a limitation that we can only store information to it but cannot erase or modify it?

a. Floppy Disk b. Hard Disk c. Tape Drive

d. CDROMe. Pen Drive

f. [4x10 Marks]

g.h.

i.j.

k.

l. Part Bm.

n. Write your answers to following questionso.

1. Define Application Software.p.

q. ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

2. Define Read only Memory (ROM).r.s. …………………………………………………………………………

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

t.3. Writes three Advantages and disadvantages using computers.

u.v. Advantagesw. …………………………………………………………………………

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

3 | P a g e

……………………………………………………………………………………………………………………………………………………

x.y. Disadvantagesz. …………………………………………………………………………

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

aa.4. Write short notes.

ab.ac.BIOSad. …………………………………………………………………

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ae. Half duplex data transmissionaf. …………………………………………………………………………

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ag. Compare USB port and PS/2 portah. …………………………………………………………………

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

ai.5. What is Programming Language? Give 02 examples

aj.ak. …………………………………………………………………

…………………………………………………………………………

4 | P a g e

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

al. [5x12 Marks]

am.an.ao.

ap.aq.ar.as.at.au.av.aw.ax.ay.az.ba.bb.bc.bd.be.bf.bg.bh.bi.bj.bk.bl.bm.bn.bo.bp.bq.br.bs.bt. Q-02: MS WORD (Time: 25 Minutes)bu.bv. You are supposed to create a following

poster using MS Word, according to the instruction given below.

5 | P a g e

1. Open a new MS Word file and create the Poster given below. Use Font face as Cambria. You have to insert the images given in the “Resources” Directory. [05 Marks]

2. Save the document as W< Your Student No.>in your exam drive. bw. (eg: WAA-2015-001) [05 Marks]

3. Select the heading “Tourism Industry in Sri Lanka” and format it as follows.Choose any suitable WordArt for that.Font size: 36bx. Font Color: Blue, Accent 5Choose the effect as follows.Drawing tools -> WordArt Styles -> Text Effects -> Transform ->Warp

by. [15 marks]

4. Insert the Tourism_Campaign.jpg & Tourism.jpg image given in the “Resources” directory & choose Suitable picture style.

[10marks]

5. Insert the following table & use Suitable table style. The text inside the tables should be format asFont size: 12 Font Color: BlackTable headings should be bold. [15 marks]

6. Insert the given shape & format it as, Shape Fill: Gold, Accent 4 Text Fill: BlackFont Size: 14 [15 marks]

7. Use the given bullet for the list. (Hint : Use Text Boxes)

Font Size: 12 [10 marks]

8. The text “Wonder of Asia” & the images should be in footer. Images are given in the “Resources” Directory. Font Size: 12 Style: Bold, Italic & Underline

[15 marks]

9. Insert a text Watermark.Text: Come & See Font: Calibri

6 | P a g e

Font Color: Orange Layout: Diagonal [10 marks]

bz.

7 | P a g e

8 | P a g e

ca. Q-03:MS EXCEL (Time: 25 Minutes)cb.

cc. You are supposed to create an Excel file using Excel2013, according to the instructions given below.1. Open a new Excel file and create the workbook given below and save

it as E<Your Student Number> in your exam drive. (eg: EAA-2015-001) [02 Marks]

cd.2. Rename the worksheet into “Sale Price”.

[03 Marks]ce.3. Create a table with data as shown in (Figure 1). Appropriate fields

should be Bold and necessary “Cell Alignments”, “Borders” and“Merge Cells” should be applied as the figure given below.

[15 Marks]4. Format the title “SENARATHNA (PVT) LTD” as follows,

i. Font Face - Comic Sans MSii. Font Size - 24

5. Word Art - Fill- Red, Accent 2, Outline- Accent 2 [04 Marks]

cf.

cg.ch. Figure 1

ci.6. Discount should be given 10% for each item. According to that, use

the following formula to calculate the “Discount” Column.cj.

ck. Discount = Unit Price * 0.1 [05 Marks]

cl.7. Use the following formula to calculate the “Price” Column.

cm.

9 | P a g e

cn. Price = Unit Price – Discount [05 Marks]

co.cp.cq.

8. Use the following formula to calculate the “Sale Price” Column.cr. Sale Price = Price * Quantity

[05 Marks]cs.

9. Fill the “Sale Rate” Column using Excel Functions, under the following conditions.

Hint: IF Functioni. If Sale Price >= 100000, Sale Rate should be “Best

Sale”ii. Otherwise Sale Rate should be “Worst Sale” [15

Marks]ct.

10. Format entire “Item Code” and “Unit Price” as below. [15 Marks]

cu.

cv.I

cw.Unit

Price

cx.0

cy. Rs. 3,500.00

cz.0

da.Rs.

2,500.00

db.

11. Using suitable Excel Functions, find values for follow; [10 Marks]

10 | P a g e

dc.dd.

de.12. Sort “Sale

Price” Column into Largest to Smallest.

[03 Marks]

13. Use Conditional Formatting

and add Data Bars (anyGradient Fill) to

represent the values inside “Discou nt” Column.

[03 Marks]14. Select suitable

columns and draw a Piechart as below. Insert aChart Title, Legendand Data Labels.

[15 Marks]

11 | P a g e

a. Total SalePrice

b.

c. Minimum SalePrice

d.

e. NumberofItems

f.

df.

31500

45000

39375

180000

209250

Sale Prices of Items

Rice Cooker

Kettle

Iron

Blender

Filter

dg.

dh. Q-04: MS ACCESS (Time: 25 Minutes)di.

1. Create a database for National Academy, to store Class Timetable. Save it as A<Your Student No>in your exam drive. (eg: AAA-2015-0001)

a) Select appropriate field as the primary key.b) Select applicable data types, Field sizes and Formats.c) Use Lookup Wizard for Subject Field.d) Make appropriate input mask for Teacher ID and, Teacher

name Field.e) Use appropriate format for Date and Time Field.

dj.[60 Marks]

dk.

12 | P a g e

dl.2. Create a Form to show all fields in the Database (Layout should be

columnar) and name it as “Teachers form”. dm. [20

Marks]

dn.

do.3. Create a Report including all fields and name it as “Train

Report” This should be grouped by “Subject” and sort according toascending order by “ Date”; Page orientation should be“Portrait”& layout should be “Stepped”

dp.dq. [20 Marks]

dr.

ds.dt.du.dv.dw.dx.dy.dz.ea.eb. Q-05: MS POWERPOINT (Time: 25

Minutes)ec. You are supposed to create a presentation

using PowerPoint 2013, according to the instructions given below.

1. Save it as P<Your Student no.> in your exam drive. (eg: PAA-2015-0001)

ed. [05 marks]

2. Images can be found in the "Resources" directory. 3. Insert slide numbers to all slides except on the title slide.

[03 marks] 4. Add the "parallax" theme to all slides. [02

marks] 5. Apply the slide Transition to all slides according to the following list.

ee. Effect: origami ef. Duration: 04.00 second eg. Advance Slide: On Mouse click

[05 marks]6. Customize your slides as follows.

eh.

13 | P a g e

ei. Slide 1

ej.a. Insert the background picture and customize the transparency.

[03 marks]b. Insert the given image from resources Folder.

[02 marks]c. Use crop to shape option to get the the shape of the image.

[02 marks]d. Add Title as “Brief Introduction to India”. [03

marks]e. Use the suitable color and size. [05

marks]f. Apply the following animations.

[05marks]

ek. Order

el. Effectsem.T

en.S

eo.T

ep. Title eq. Entrance er.B

es. With previous

et. Image eu. Emphasis ev.S

ew. On click

ex.

ey. Slide 2

14 | P a g e

ez.fa.

a. Title of the slide “Culture” and put it into a shape. [02 marks]

i. Font: Times new romanii. Font Size: 40iii. Font color: Purple [05

marks]b. Insert the picture SmartArt. [03 marks]c. Fill it by images which are in the resources folder and name them as

showi. Font: Corbel (body)ii. Font size: 24 [10 marks]

d. Insert the action button move to next slide [05 marks]

e. Apply the following animations. [10 marks]

15 | P a g e

g. Order

h. Effectsi.

Tj.

Sk.

T

l. Shape m. Exit n.

Do. On click

p. Smart Art

q. Emphasis r.

Cs. On click

u. Exit v.

Sw. On click

fb.

fc.

fd.

fe.

ff. Slide 3

fg.

a. Title of the slide “Population” [05 marks]

i. Font type : Times New romanii. Font size : 40iii. Font Color : purple

b. Add given paragraph. [05 marks]i. Font type : Times New roman

ii. Font size : 40iii. Font Color : black

fh.c. Add given table [05 marks]

i. Use suitable style for the tableii. Font type of content : Times new romaniii. Font size: 11 [05

marks]fi.

16 | P a g e

d. Apply the following animations.

fj. [10 marks]

fk.

fl. Q-06: INTERNET & E-MAIL (Time: 25 Minutes)

fm.fn. Part – A

fo. Underline the most suitable answer.

1 The first part of a complete URL is the __________ needed to access the web resource.

a Nameb countryc address

d protocole location

f2 Software, such as Explorer and Firefox, are referred to as

a utility softwareb system softwarec programming tool

d file management softwaree web browser software

f3 Saving a file from the Internet onto your computer is called

a downloadingb storingc upgrading

d transferringe uploading

f4 A word in a web page that, when clicked, opens another document.

17 | P a g e

x. Order

y. Effectsz.

Taa.

Sab.

T

ac. title ad. Entrance ae.

Faf. With previous

ag. paragraph

ah. Entrance ai.

Waj. With previous

ak. Table al. Entrance am.

Pan. With previous

a anchorb hyperlinkc url

d inserte reference

f5 In a ________ network, all devices are connected to a device called a

hub and communicate through it.

a meshb starc bus

d treee ring

f6 Half-finished email messages are stored in:

a Draft boxb Send boxc Inbox

d Chat boxe Outbox

f7 What is the correct IP address

a 172.16.1.9b 255.0.21.153.1c 65.0.3

d 555.22.180.10e 11.AA.212.56.123

f

8 HTML language is used for

a Displaying a web pageb Creating a Web pagec Creating videos

d Creating a documente Formatting a document

9 The Internet is

a A collection of Routers and few Computers

b also known as Intranetc Only the World Wide Web

d A global Network of Networks

e Connection between two computers

f

10 How to send the word document through e-mail

a As carbon copyb As a subjectc As an attachment

d As blind carbon copye As a hard copy

18 | P a g e

f [10x4 marks]

g Part- Bh

1. State the different between internet and intranet.2. What is LAN, WAN, MAN Describe them briefly. 3. Briefly describe the search engine by giving 2 examples.4. What is the main purpose of a firewall?

[5 x4marks ]

i

j

k

l

m

n

o

p

q

r

s

t

u

v

w

x

y Part -C

1. Search following image using search engine and save it as “Eiffel_Tower.jpg”

z

aa

ab

ac

ad

ae

af

ag [15 Marks]

2. Browse following web page using www.army.lk and Save it as I<Your Student No > in your exam drive (eg: IAA-2015-0001)

ah

ai

aj [25 Marks]