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.