Information technology class a regular class mid semester examination

1.

1. 
   Explain microsoft access database.
   
2. 
   Whats the way to link the exploit data into access database:
   
3. 
   Explain super key and state its main differences from candidate key.
   
4. 
   What are the various types of relation but mean different data?
   
5. 
   Explain the term SQL?
   

fi) what is the role of WHERE clause in MS ACCESS

2)explain information technology

b)describe the impact of information technology management functions.

c) explain two roles of the information technology manager as the following;

i)user

iii)evaluator, of information systems

d)describe three social and three business implication of information technology

EXCEL

1. 
   Explain VLOOKUP in common terms.
   
2. 
   What is the order of operations used in excel formulas?
   
3. 
   Explain two limitations of VLOOKUP.
   
4. 
   Explain spreadsheet application
   

ii)how do you lock a worksheet to prevent from editing it

5. 
   Explain the use of comments how do you add comments to a cell in Microsoft
   

SUBSTTUTE ()

CONNTA()

COUNTIFS()

3. INSTRUCTION : Kindly write an algorithm and draw a flowchart to solve the following problems;

1. 
   Read the marks of 3 students for 3 courses. Calculate the average marks for both the students. Check the average with the below table and calculate the CGPA according to the formula
   

B. To find the visa processing fee for tourists according to the following calculations :

Read the number of days, type of visa and age tourist.

Age	No. of days	Visa Type	Fee Calculation
>40	10	Tourist	No. of days*GHC1.5
>40	30	Visit	No. of days * GHC2
<40	30	Any	No. of days * GHC 0.5

C. To accept 3 details of a students – Reg. No. , GPA , IELTS score. Based on the following conditions, print whether the student gets sponsorship for higher studies;

F. Find the smallest amongst 3 numbers