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

(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.

use microsoft power point application to create the presentation on the topic computer systems

[a]    use title slide and type  computer systems with font type arial black and size 44 points

[b]     use title and content layout slide and type the following passage with font type:

            [i] title in algerian and size 40 points ;

            [ii] content in times new roman and size 30 points.

passage: Definition of computer

A computer is a device that accepts information in the form of digitized data and manipulates it for some results based on a program or sequence of instructions on how the data is to be processed

[c]   Insert next slide and type the following using the same font type and size as in (b)

CLASSIFICATION OF COMPUTERS

i By type, ii  By Size: iii By Purpose: iv By Generation.

[d] insert next slide and type the following using the same font type and size in 1b

CLASSIFICATION BY TYPE

Digital Computer, Analogue Computer, Hybrid Computer. (Note: use bullet list for the items)

(e) Insert next slide and type the following using the same font type and size as in 1 (b).Mini
Computer, Mainframe Computer, (Note: use a different list type for the Micro Computer, Super Computer items)

CLASSIFICATION BY GENERATION
First Generation eg UNIVAC
Second Generation eg HAVARD MARKII
Third Generation eg IBM 360
Fourth Generation eg Microcomputer (Note: use a different list type for the items)

(g) Using Footer tool, insert your full name and index number with font size of 14 points and bold.
(h) Save your work in the folder created on the desktop using your full name as the file name.
        [i]  Print your work and submit to the supervisor.

2. Daniel James and three of his friends came up with the idea of starting a travel agency for college students in Nigeria. They invested sixty thousand naira each and started their dream company, SUMMER BREAK
TRAVELS INC.
As sales continued to grow, the management of Summer Break Travels Inc. realised they need a better tracking system for First Quarter
Sales.
Prepare a First Quarter Sales Worksheet that shows the sales for the first quarter using the details in the table  below

                                                                                               Markerting outlets[#]

[a]   (a) Using function or fomula, compute the total:
         [i] sales at each marketing outlet; (ii)
         [ii] amount of money made for each vacation place. (Note: create another column "total")

(b)     Format the table using the instruction below: ) the title "Summer Break  Travels, Inc.

          First Quarter Sales" should be Bold and in Upper Case;

         (ii) fill the table with white background 1 darker-25"

[c]      Create two charts for the first quarter sales: )

            [i] a pie chart stating the most effective sales method;

            [ii] a bar chart stating the most popular vacation place.
[d]        Type in the formula used in calculating total for each location below your table

            (enclosed in"")

[e]        Save, print out your work and submit to the supervisor.