Using a word Processing application package, create a vising card for a system administrator of a software company using the following specifications:
(a) Size of the card is 3.5" x 2", (b) Office and Residential Address separated by a line; (C) the card should be copied m three places on the same page: (d) note that.
(i) the background colour must be grey scale: (ii) the card should be in shadow style, (iii) titlte "Visitor"
Uppercase
Highlight-gray-25%
Font size - 10 pt.
Font type - Georgia:
(iv) Office Address and Residential Address - 1.15 spacing
Font Type-Cambria
Font Size - 7 pt.
(e) Insert a tooter and type in your full name and index number.
(f) Save your work with your full name in the folder created on the desktop.
(g) Print your work and submit to the Supervisor.
Use a spreadsheet application to do the following. (a) In cell A1, type "My One Week Expenses On Five items".
(b) In row 2, type column-by-column the following: "ITEM", 1ST DAY, "2ND DAY, "3RD DAY", *4TH DAY, "5THDAY", "6TH DAY" and "7TH DAY".
(c) In column A, starting from A3 to A7, List the items you spent money on.
(d) Enter the amount spent on each item for each day in their respective columns.
Note: select your own items and the amount spent.
(e) In cells 12 and A8. type "TOTAL N".
(f) Using formula/function compute the total expenses for each day and for each item.
(g) Create borders around the table.
(h) Insert a footer and type in your full name and index number. (i) Below the table, type in the formula that was used:
(i) in cell 18: (ii) for summing from B3 to H3.
Note: Enclose your formula in quotes ave your work with your full name in the folder created on the desktop.
(k) Print your work and submit to the supervisor.
As a database administrator for a company, create a table named tbl-Employee in a database application package containing the fields:
"Employee Name", "Department", "Assumption Date", Address and "Designation".
(a) Enter the data as shown in the table tbl-Employee
tbl-Employee
|
Employee Name |
Department | Assumption Date | Address | Designation |
|
Kate Willikie |
General Office | 03/08/18 | 3 Lagos Crescent | Secretary |
|
James Elliot |
Security | 27/11/10 | 2 Cocoa House Villa. | CSO |
|
Paul Akinson |
Admin | 03/11/12 | 12 Millo Avenue |
HRM |
|
Abdul Kaduna |
Registry | 05/06/16 | 2 Park Lane Rd |
Clerk |
|
David Madu |
Management | 22/03/94 | 34 Lakeside |
MD |
(b)Sort the data using the Assumption date from oldest to newest.
(c) Create a report in tabular, landscape using the tbl-Employee table.
(d) Insert your full name and index number as a label on the report.
(e) Save the report as rpt-Employee.
(f) Print your work and submit to the supervisor.
