Information technology class a regular class mid semester examination



Download 16.59 Kb.
Date29.04.2021
Size16.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?

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


  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

i)state 3 advantages of spreadsheet application

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



  1. 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;


  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.
Download 16.59 Kb.

Share with your friends:




The database is protected by copyright ©ininet.org 2020
send message

    Main page