# Information technology class a regular class mid semester examination

 Date 29.04.2021 Size 16.59 Kb.

LISTER EDUCATIONAL INSTITUTE

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

ii)designer

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.

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

ii) explain the following functions in excel

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

[ CGPA = (Average*Grade point)/3]. Display the CGPA of both the students

 Average Grade Point 8-10 3.5 6-7.9 3 4.5 – 5.9 2.5 <4 2

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;

 GPA IELTS SPONSORSHIP Higher than or equal to 4 Higher than or equal to 6 Yes Less than 4 Less than 6 No

F. Find the smallest amongst 3 numbers

G. Check whether 2 numbers are equal. If they are equal , find the square of the number . Otherwise , find the cube of the number.