COMPUTERIZATION OF NOMINAL ROLL

SECTION A

COMPUTERIZATION OF NOMINAL ROLL

 

INTRODUCTION

Nominal Roll provides a “SNAPS HOT” of individual service of displaying a range of information on each person, gathered from service record, every organisation deal with one form of nominal roll system or the other.

It is a record keeping and control defrauded by deficiencies such as data redundancy inconsistency, insecurity and ineffective sharing of data.

Organisation have various form of nominal roll, for manufacturing, merchandized or for provision of services, and these organisation are required to adopt contemporary nominal roll system which is the use of a computer.

Computerization of nominal roll system differs in nature according to the type of organisation, if property operated and manage it will have the capacity of storing data.

This research was conducted on the basis of the above mentioned to find out that the extent of computerized nominal roll system is to implement in organisation and for the effectiveness of the system.

 

DATA COLLECTION

        These data where collected through personal interview with the managing director of AKBC. The following are the data collected from AKBC.

  • Staff identification
  • First name
  • Date of Birth
  • Sex
  • Department
  • Grade level and rank

TYPICAL DATABASE OBJECT IN ACCESS

 

TABLE DESIGN

A table is a collection of data about a specific topic. Table organizes dat column (called field) and rows (called records). This has to do with creation of bank end.

 

A table contains information about person working in an organisation. It contains staff identification number, first name, middle name, surname, sex, date of birth, date of first appointment, rank, department and basic salary. The system developed is made up of a table called Table in Data View. The clip of the table is of shown below

STAFF PERSONAL INFORMATION TABLE DATASHEET VIEW

 

 

STAFF PERSONAL INFORMATION TABLE IN DESIGN VIEW

Queries

Queries is one of the component or object of a data base window that one can to view, change and analyse data in different ways. It is a request for information sent to the database. This request is made using either structured query language (SQL), or Query by example gride (QBE grid). The system developed is made up of a table called Select Queries in Design View. The clip of the table is of shown below.

 

SELECT QUERY IN DESIGN VIEW

 

 

 

 

QUERY IN DATASHEET VIWE SHOWING ALL MALE STAFF

 

Forms Design

This is the graphical representation of data, it is used in entering and retrieving of data. The system developed is made up of a table called Staff Information Form in Form View. The clip of the table is of shown below.

 

STAFF INFORMATION FORM IN FORM VIEW

 

MACRO DESIGN

Macro can be defined as a list of actions that can be applied to an object in the Database, be it a form, command bottom, report, etc, that will respond to contain events. The system developed is made up of a table called Macro Opening a Report. The clip of the table is of shown below.

 

 

 

 

 

 

MACRO OPENING A REPORT

 

 

REPORT GENERATION

A report is an effective way to present data in a printed format. . The system developed is made up of a table called Staff Record Report in Print Preview. The clip of the table is of shown below

 

 

 

 

 

STAFF RECORD REPORT IN PRINT PREVIEW

 

 

 

CONCLUSION

Computerization of staff, records create awareness to the management of AKBC, Udoudoma Avenue, Uyo, on the need to computerize the staff, personal information.

Finally, this study has shown some benefits one will derive in using computerized system.

 

SECTION B

 

GRAPHICAL REPRESENTATION IN MICROSOFT, EXCEL

 

INTRODUCTION

Electronic spreadsheet is a computer application package or software primarily designed to perform all kinds of tasks related to  financial analysis, statistical analysis, scientific and mathematical analysis and computation. Besides being used for calculations, electronic spreadsheets also make use of different functions to arrange and analyze data in any way you require. We can think of a spreadsheet as a large sheet consisting of several rows and columns into which data is entered.

 

  1. A Pie Chart: shows the proportional size of items that make up a data series to the sum of the items

 

  1. Line graph: A line chart shows trends in data at equal         intervals.

 

iii.     Area Chart: An area chart emphasizes the magnitude of change overtime. By displaying the sum of the plotted values, an area chart also shows the relationship of parts to a whole.

  1. Column Chart: A column chart shows data change over a period of time or illustrates comparisons among items.

 

 

Doughnut Chart:

 

 

TABLE SHOWING THE PERFOMANCE OF IMFI STUDENT IN SELECTED COURSES
               
STUDENT NAME   EXCEL WORD NSPP ACCESSS P.MAKER

INTERNET

Effiong Blessing   45 34 56 34 67 56
Anthony Inyene   67 67 45 56 87 89
Joshua Brown   90 87 90 78 45 34
Akanimo Okon   46 90 67 90 89 69
Sunday Idaresit   56 56 46 45 54 90
Ann William   79 23 89 67 60 34

 

Students Name Excel Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3

 

 

Students Name Word Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3

 

Students Name
MSPP Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3
Students Name Access Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3

 

 

Students Name P. Maker Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3

 

Students Name Internet Total Credit Total Credit Total credit Average G.P G.P.A.
    Point Unit      
Effiong Blessing 2 12 18 216 36 2
Anthony Inyene 4 23 18 414 69 3.8
Joshua Brown 5 22 18 396 66 3.7
Akanimo Okon 2 25 18 450 75 4.2
Sunday Idaresit 3 18 18 324 54 3
Ann Willaim 5 18 18 324 54 3

 

Where Total Credit Point             =      Sum ( 1 + 0.3)

G.P. = Total Credit Point – Total Credit Unit

Average G. P. = Average (GP/6) Number of courses)

GPA  = Average GP

Total Credit Unit

Grade Letter Assumption Credit Point   Courses Credit Unit
0 < 39 = F 0 Excel 3

 

40< 44 = E 1 Word 3

 

45< 49 = D 2 MSPP 3

 

50< 59 = C 3 Access

 

3

 

60< 69 = B 4 P. Maker

 

3

 

70<100 = A 5 Internet

 

3

 

 

 

 

 

 

 

Total Credit Unit 18