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 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.
- A Pie Chart: shows the proportional size of items that make up a data series to the sum of the items
- 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.
- 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 |