LISTER EDUCATIONAL INSTITUTE
INFORMATION TECHNOLOGY CLASS A REGULAR CLASS
MID SEMESTER EXAMINATION
1.

Explain microsoft access database.

Whats the way to link the exploit data into access database:

Explain super key and state its main differences from candidate key.

What are the various types of relation but mean different data?

Explain the term SQL?
i)give four advantages of 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

Explain VLOOKUP in common terms.

What is the order of operations used in excel formulas?

Explain two limitations of VLOOKUP.

Explain spreadsheet application
i)state 3 advantages of spreadsheet application
ii)how do you lock a worksheet to prevent from editing it

Explain the use of comments how do you add comments to a cell in Microsoft
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;

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

810

3.5

67.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.
Share with your friends: 