1 | P a g e

Information & Communication Technology Centre

University of Kelaniya – Sri Lanka

Academic Year 2012/2013- First Semester

No of Pages: 16 Time: 03 hours

Student No:

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

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

Part-I

Underline the most suitable answer

1) Check the odd term out

a. Internet

b. Linux

c. Unix

d. Windows

e. MS DOS

2) Derive the Boolean expression for the logic circuit shown below:

a. 𝑋 = 𝐴 + 𝐵 + 𝐶 b. 𝑋 = (𝐴. 𝐵) + 𝐶

c. 𝑋 = 𝐴 + 𝐵. 𝐶

d. 𝑋 = 𝐴. (𝐵 + 𝐶)

e. 𝑋 = (𝐴 + 𝐵). 𝐶

Subject Introduction Word Excel Access PowerPoint Internet & E-

mail

kb

Marks

/ /

EXAM

INFORMATION TECHNOLOGY – COMP 13014 24th June 2014

2 | P a g e

3) Which of the following statements is true?

a. Minicomputer works faster than Microcomputer

b. Microcomputer works faster than Minicomputer

c. Speeds of both the computers are same

d. The speeds of both these computers cannot be compared with the speed of an

advanced computer

e. All of the above

4) An octal number 2378 is equal to the binary number

a. 0100111112

b. 0101110112

c. 0111011012

d. 0110000012

e. 1110011002

5) A computer program that converts assembly language to machine language is

a. Compiler

b. Interpreter

c. Assembler

d. Comparator

e. None of the above

6) Which kind of devices allows the user to add components and capabilities to a

computer system?

a. System boards

b. Storage devices

c. Input devices

d. Output devices

e. Expansion slots

7) Microprocessor was introduced in which generation of computer?

a. First Generation

b. Second Generation

c. Third Generation

d. Fourth Generation

e. Both a and b

8) Microsoft Word is an example of

a. An operating system

b. Processing Device

c. Application Software

d. An input Device

e. System Software

9) The symbol shown in the figure in flow chart represents

a. Input /Output

b. Decision

c. Termination

d. In-connector

e. Out-connector

3 | P a g e

10) The sum of two hexadecimal numbers 23D16 and 9AA16 is in hexadecimal.

a. BE716

b. BE516

c. BF616

d. AF716

e. None of the above

[4 x 10 Marks]

Part-II

Answer all questions.

1) Use truth tables to verify the following Boolean expressions.

a. (𝑥 + 𝑦)′= 𝑥′. 𝑦′ b. (𝑥.𝑦)′ = (𝑥′ + 𝑦′) c. (A + B). C = A . C + B. C

2) Draw the circuit diagram of Boolean expression, 𝐸 = �̅�. 𝐵 + 𝐵. (𝐶̅ + 𝐷) and draw the

corresponding truth table. 3) Get the addition of 1011102 + C6E16 and convert the answer into octal.

4) Write pseudo code to display the maximum of two numbers.

5) Draw a flowchart to find the sum of the first 50 natural numbers.

[5 x 12 Marks]

4 | P a g e

Q-02 : WORD (Time : 20 Minutes) You are supposed to create a word processing file using Word 2013, according to the instructions given below. 1) Open a new Word file and create the document given below. [2 Marks] 2) Save the document as W<Your Student Number> in your exam drive.

(e.g.: WAA-2012-0001) [3 Marks] 3) Insert the “logo.jpg” image given in the Resources directory. [5 Marks] 4) Insert the date and set it to be updated automatically. [5 Marks] 5) Prepare the letter with following formatting.

a) Font: Arial

b) Font size: 11pt [10 Marks]

6) Insert the table and make the table heading Bold. [5 Marks]

7) Insert suitable SmartArt inside the table. Font size for SmartArt headings should be

19pt and Font size for SmartArt content should be 8pt. [10 Marks]

8) Apply the page border with 3pt. [3 Marks]

9) Apply the watermark with the text, “Important Notice”. [5 Marks]

10) Type the company name and address as the footer. [7 Marks]

11) After mail merge, text inside the brackets must be changed as the following data;

[15 Marks]

12) Save the data source as “Customer Details”. [5 Marks]

13) Save two word files as follows.

a) After adding fields to the letter before merge in the same file, W<Your Student Number>

b) After being merged – as “Reminders” [5 Marks]

Title First_Name Last_Name Company City Amount Date Mr. Asanga Perera ABC

Transport Colombo 8 LKR.

240,000.00 2014.05.20

Mrs. Nayana Gamage Gamage and Sons

Kandy LKR. 500,000.00

2014.05.11

Miss. Dulanjali Silva Kelaniyawatta Estate

Kurunegala LKR. 380,000.00

2014.05.15

Mr. Sampath Wijesiri Wijesiri Motors

Negombo LKR. 132,000.00

2014.04.22

5 | P a g e

6 | P a g e

Q-03 : EXCEL (Time : 40 Minutes) You are supposed to create a spreadsheet using Excel 2013, by following the instructions given below.

1) Create a blank workbook in Excel 2013 and save it as "E<Your StudentNo>" in your exam drive. (e.g:EAA-2012-0001) [5 Marks]

2) Rename the first worksheet as Pizza. [5 Marks] 3) Using Instructions given below, insert following data and format them as shown in

the following figure.

a. Necessary cells should be merged. b. Appropriate fields should be bold. c. Apply necessary Cell Alignments and Cell borders as shown above d. Apply a suitable Data Validation Criteria to Size field. (hint: Insert through a

list) e. Format the columns as shown below

f. Apply Conditional Formatting to Size and New Price Fields as follows.

i. Size: Highlight the cells which contain the text “Medium”, Green Fill with

Dark Green Text

7 | P a g e

ii. New Price: Icon Sets

[28 Marks]

4) Complete the Discounted Price, New Price and Deliverable fields a. Discounted Price

Use IF Function and Absolute Cell References

=IF(D7=$B$22,E7*$C$22,IF(D7=$B$23,……

Discounted Price = Price*Discount [10 Marks]

b. New Price

New Price = Price – Discounted Price [4 Marks]

c. Deliverable

Use Concatenate Function to each Pizza Type separately as follows

[8 Marks]

d. Apply suitable Excel Functions to fill the following

i. Obtain the Total New Price of Pizza in which Item ID > PZ-300

ii. Average New Price of Large Pizza

iii. Number of Pizza which have the Discount < 90 rupees

[12 Marks]

5) Filter the records which satisfy Discounted Price < 90 AND New Price >550

using Advanced Filter.

[8 Marks]

Icon Value

>= 1000

>= 600

< 600

8 | P a g e

6) Insert a Pivot Table to display Average of Price, Discounted Price and New Price

in a new sheet and rename it as Pivot Table (Set the Grand Total into 2 Decimal

places)

[8 Marks]

7) Select necessary fields & insert a Line chart and customize it as shown below

[12 Marks]

9 | P a g e

Q-04 : ACCESS (Time : 40 Minutes) You are supposed to create the following Database using Access 2013, according

to the instructions given below

1) Create blank database called “A<Your Student Number>”. (e.g.: APS-2012-001) and

save it in your Exam driver. [5 Marks]

2) Create Following tables according to the given instructions

a) Table 01 : Vehicle_Specification [5 Marks]

Car ID Brand Name VIN Description Year Car - 001 Mitsubishi MIH-099 Mitsubishi Lancer 2014 Car - 002 Toyota NKE-165 Toyota Axio 2013 Car - 003 Honda GP1-000 Honda FIT 2010 Car - 004 Toyota AVU-065 Toyota Harrier 2012 Car - 005 Toyota NZT-260 Toyota Allion 2013 Car - 006 Nissan ZEO-000 Nissan LEAF 2014 Car - 007 Honda RU3-000 Honda VEZEL 2013

i) Use suitable Data type and Field size to the fields. [3 Marks]

ii) Select a suitable field as the Primary Key. [2 Marks]

iii) Set Input Mask Property to the Car ID and VIN fields. [4 Marks]

iv) Use lookup wizard to the Brand Name field. [2 Marks]

v) Validate and format the Year field only to add year between 2009 and 2015.

Set validation text as “You must enter year from 2009 to 2015.” [4 Marks]

b) Table 02 : Vehicle_Price [5 Marks]

VIN Cost (Million) Tax (%) Total Cost AVU-065 3.8 2.3 LKR. 8.74 M GP1-000 2.9 1.1 LKR. 3.19 M MIH-099 4.5 1.5 LKR. 6.75 M NKE-165 3.9 1.3 LKR. 5.07 M NZT-260 4.1 1.2 LKR. 4.92 M RU3-000 4.2 1.4 LKR. 5.88 M ZEO-000 2.8 1 LKR. 2.80 M

i) Use suitable Data types and Field sizes to the fields. [3 Marks]

ii) Select a suitable field as the Primary Key. [2 Marks]

iii) Set Input Mask Property to the VIN field. [2 Marks]

iv) You must use calculated data type for Total Cost field. Total cost = [Cost(Million)]*[Tax(%)] [4 Marks]

v) Apply suitable format to Total Cost field. [2 Marks]

3) Create Relation between two tables. [10 Marks]

4) Create a form named as Specification form and customize the form as follows: [7 Marks]

10 | P a g e

a) Use Car ID, Brand Name, VIN, Description, Year, Total Cost fields in this form

[2 Marks]

i) Apply “Slice theme” to the form design. [2 Marks]

ii) Add Next and previous button and logo as in the preview. [4 Marks]

iii) In the footer type “LudmaX International (Pvt) Ltd” and set title as “Vehicle

Specification Details”. [2 Marks]

5) Create query called “Specifications Query” to display Car ID, Brand Name, VIN,

Year, Total Cost, Description which are belong to Toyota or Honda and Total Cost

greater than 5 Million. [20 Marks]

6) Create report called “Vehicle_Details_Report” to display Brand Name, VIN,

Description, Year, Total Cost and view by Vehicle_Specification table. Report

should be grouped according to the Brand Name and sort the record by Total cost

to the Descending order. Layout should be stepped and orientation should be

Landscape.

[10 Marks]

11 | P a g e

Q-05 : POWERPOINT (Time : 20 Minutes)

You are supposed to create a presentation file using Power Point 2013, according to the instructions mentioned below.

1) Create a presentation with four blank slides. Add appropriate layouts to each slide. Save the file as P<Your Student Number> in your exam drive. (Ex: PAA-2012-0001) [5 Marks]

2) You can find necessary pictures inside the “Resources folder”. 3) Use “Organic” Theme to all the slides. [5 Marks] 4) Apply slide Transition for all the slides. Use following guidelines.

a. Transition – Window b. Timing – 00.05 [5 Marks]

5) Create a Custom slide show as “WCY 2014” to preview only 1st, 3rd and 4th slides. [5 Marks]

6) Create Hyperlink to 1st slide by an action button to go to the www.wcy2014.com [5 Marks]

7) Insert an Action button to 3rd slide to link 1st slide. [5 Marks] 8) Hide 2nd slide from the Slide Show. [5 Marks] 9) Insert the slide numbers and your student number as the footer except first slide.

[5 Marks] 10) Design all slides as shown below. [60 Marks]

Slide 01

Order Effects

Type Sub Type Start Effect Option

Title Entrance Float in On click By Letter

Picture(left) Entrance Grow & Turn After Previous

Picture(right) Exit Wheel With Previous Action Button Emphasis Spin On click

12 | P a g e

Slide 02

Slide 03

Order Effects

Type Sub Type Start

Title Entrance Random Bars On click

Smart Art Emphasis Teeter After Previous

Order Effects

Type Sub Type Start

Title Emphasis Spin On click

List Exit Disappear After Previous

Action Button Emphasis Darken After Previous

13 | P a g e

Slide 04

Order Effects

Type Sub Type Start

Smart Art Motion Path Circle On Click

Table Exit Split After Previous

Chart Emphasis Pulse With Previous

14 | P a g e

Q-06 : Internet & E-mail (Time : 30 Minutes)

Part – I Underline the most suitable answer

1) To join the Internet, the computer has to be connected to a

a. Internet architecture board

b. Internet society

c. Internet service provider

d. Main Office

e. none of the above

2) Which protocol assigns IP address to the client connected in the Internet?

a. DHCP

b. IP

c. TCP

d. RPC

e. none of the above

3) _________ is an access channel for computers to exchange information

a. Socket

b. Port

c. Gateways

d. Protocol

e. Keyboard

4) Which is the fastest port for data transfer

a. USB

b. Serial

c. Parallel

d. Straight-through

e. Fire wire

5) Default port for HTTP

a. 23

b. 20

c. 80

d. 110

e. 1

6) In HTTPS ‘S’ stands for

a. Simple

b. Secured

c. Server

d. Serial

e. None of the above

7) Which is a search engine

a. AltaVista

b. Google

c. Facebook

d. Yahoo

e. Bing

8) Which is/are the threats for Internet users

a. Viruses

b. Worms

c. Trojan horses

d. All of them

e. None of them

15 | P a g e

9) The system that translates an IP Address into a name easy to remember is the

a. Packet switching domain system

b. Domain name system

c. Domain

d. Domain numbering system

e. Login information system

10) In the e-mail address bowles@sou.edu, “bowles” is the

a. Password

b. Server Name

c. Username

d. Client Computer

e. Host Computer

11) The _____ tag defines an image in an HTML page

a. <imge>

b. <pic>

c. <img>

d. <a href>

e. <br>

12) What is the correct HTML code for creating a hyperlink?

a. <a name=””>A</a>

b. <a>B</a>

c. <a href=”http://www.example.com”>example</a>

d. <a url=”http://www.example.com”>example</a>

e. <a src=”http://www.example.com”>example</a>

13) What is the preferred way for adding a background color in HTML?

a. <body background=”yellow”>

b. <background>yellow</background>

c. <body style=”background-color: yellow”>

d. <body color=”yellow”>

e. <body background-color=”yellow”>

14) What tag is used to make a number list?

a. <ul>

b. <list>

c. <ol>

d. <dl>

e. <nl>

15) HTML tags are used to describe document …………

a. Definition

b. Content

c. Language

d. Style

e. None of the above

[4 x 15 Marks]

Part – II 1) Download the Following picture and save it in your exam drive and save as

“Adventure.jpg”(hint: Adventure Photos)

2) Design following web page using HTML according to the instructions given below.

a. Save your HTML document save it as “I<Your Student No>.html” (e.g.: IAA-

2012-0001.html) in your exam drive.

b. Insert title as “Information System”.

c. Create link to “ICT Centre” to go to http://www.kln.ac.lk/units/ictc(It should be

an unordered list)

d. You must insert a Table, apply lists, text and password fields and Login button at

appropriate places in the page.

[40 Marks]