Sample Questions

1.        

a.       What is a computer?

                                    (10 marks)                                                                                                      

b.       What are basic the Functionalities of a computer?

(20 marks)

c.       Write five computer components. Identify with its functionality and write the corresponding functionality.

(30 marks)

d.       What is meant by computer classification? How do you classify?  Explain with at least five examples.       (30 marks)

e.       What are the characteristics of a computer? Give 3 examples.

(10 marks)

 

2.        

a.       Explain Data, Information and Knowledge

(45 marks)

b.       What is a computer Virus?

(25 marks)

c.       What is a number system?

(30 marks)

 

3.        

a.       What is an OS and give examples of  3 familiar OS

(40 marks)

b.       What are the functions of OS?

(30 marks)

c.       What are views of operating system and explain?

(30 marks)

 

4.        

a.       What is an application program?

(20 marks)

b.       List three types of application software. Give an Example for each category.

(30 marks)

c.        Your manager asks to select suitable software for a certain task. Why might you choose to use general-purpose software instead of bespoke software? Why might not suitable?

(50 marks)

 

 

 

 

5.        

a.       What is Excel and explain what you can do with that.

(25 marks)

b.       What are MS Access and its basic Object types?

(25 marks)

c.       Your immediate manager asked to collect some data of the people in the crew. Data might include name, department, rank etc. You need make a report. You have Excel and Access. What would be your choice of software? Discuss with your rational.

(50 marks)

 

 

Practical Test

 

Use below scenario for both Access and Excel.

 

Create a Table name “Person” with fields “id, age,firstName, lastName,”.

Enter below values with correspond fields in a suitable manner.

 {39, Amal, Perera }

{25, Alex, Norr }

{18, Eranda, Fernandus }

 

You can create any amount of data inside table

 

1.       Access

a.       Create Person table

b.       Enter above data

c.       Create a form to enter  data

d.       Create a report to get the person names age is greater than 20.

e.       Make sure to save file with name “Person”

2.       Excel -

a.       Create a table

b.       Enter above data

c.       Sort the table with each field. Keep table sorted ascending order based on age. You need show sorting in each field.

d.       Save your file with name “Person” in Excel 97-2003 workbook format.

You need to show steps, formulas in below.

e.       Create a date filed with value “2020-May-25”. You can select any format

f.        Extract year, month, day components

g.       Create a time component with “06:45:17”. You can select any format.

h.       Extract hour, minute and second from above.

i.         Add 2 minutes to above and show the value. Need to use formula.

Excel - sample tute

1.       Create Excel

2.       Add values to cell as a table

3.       Save in different formats

4.       Create a Table

5.       Sort table

6.       Reference values from a different sheet

7.       Add chart

8.       Load data from different files

9.       Formulas – create own formulas

10.   Functions

a.       Date and time Functions

                                                               i.      06-12-2016       

                                                             ii.      Take YEAR,MONTH,DAY () functions

1.       Need date to be in correct format

2.       Else won’t work

                                                           iii.      Add number of days  à Cell value +5

                                                           iv.      Add number of Years, Months, days to date . Use DATE() function

1.       =DATE(YEAR(B14)+4,MONTH(B14)+5,DAY(B14)+3)

                                                             v.      Get current date

1.       Now()

                                                           vi.      Get components of time HOUR(),MINUTE(), SECOND()

                                                          vii.      Add hour, minute, second to date or time. Use TIME() function

1.       TIME(HOUR(B24)+2,MINUTE(B24)+2,SECOND(B24+3))

11.   Print file – collate

a.       How you print , when you print few sets.

b.       Eg: let’s say you print 4 sets.

                                                               i.      Whether one after the other set or

                                                             ii.      Print page 1, 4 times and page 2 four times….. like that

12.   String manipulations

a.       Concatenate two strings , with &

b.       Extract left most , Right most characters LEFT(cell, number), RIGHT(..)

c.       From middle , =MID(E37,2,5) – get a range of 5 characters starting from position 2

d.       Get  length, =LEN(E37)

e.       Find the position of a string =FIND("Th",E37)

f.        Substitute =SUBSTITUTE(E37,"Tharindu","Jones")

13.   Stat functions

a.       AVERAGE, AVERAGEOF, Median,MODE, Std deviation (stddev(),

b.       min, max, large small

 

 https://www.excel-easy.com/functions.html

Sample Questions

 

Introduction to Computers

1.       What is a computer ?

2.       What are the Functionalities of a computer ?

3.       What is meant by Computer classification ? How do you classify ?  Explain with examples

4.       What are the Characteristics of  a Computer ?

5.       Explain Data, Information and Knowledge

6.       What is a computer Virus ?

7.       What is an OS and give examples of  3 familiar OS

8.       What are the functions of OS ?

9.       What are views of operating system and explain ?

10.   What is an application program and explain with classifications

11.   What is Excel and explain what you can do with that

12.   What is MSAccess and it’s Object types ?

13.   What is a number system ?

14.   Convert Below decimal values to binary, Octal, and HexaDecimal

a.       9

b.       100

c.       25

d.       72

 

15.   Convert below binary values to Octal

a.       10001

b.       11010

c.       12010

16.   What is Logic gate and list down basic logic gates.

17.   Write truth tables for the gates AND , XOR for two inputs. Take inputs as A and B

A	B	output
0	0	0
0	1	1
1	0	1
1	1	1

 

A	B	output
0	0	0
0	1	0
1	0	0
1	1	1

 

 

18.   Identify the gates below with respect to truth table

19.   List three basic types of Networks

20.   What is OSI model and which layer is responsible for Network ?

21.   Is LAN is faster than WAN ? Comment

22.   What is a network Topology ?

23.   List down 3 basic topologies with diagrams

24.   What is Internet ?

25.   What is the common protocols used in Internet. What’s the common name use for that

26.   What do you understand with HTTPS. Explain

27.   What is an email and list 3 advantages ?