WAEC SSCE - Computer Studies - 2019 (Practical)

Detalhes da Resposta

To create a table named "tbl-Employee" in a database application package, you would need to use a database management system and write a SQL (Structured Query Language) script to create the table and specify the fields. The fields you need to include are: "Employee Name", "Department", "Assumption Date", "Address", and "Designation".

Here's an example of the SQL script to create the table:

CREATE TABLE tbl-Employee (
  EmployeeName varchar(50),
  Department varchar(50),
  AssumptionDate date,
  Address varchar(100),
  Designation varchar(50)
);

Next, you can insert the data into the table using the following SQL script:

INSERT INTO tbl-Employee (EmployeeName, Department, AssumptionDate, Address, Designation)
VALUES
  ('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');

To sort the data by the "Assumption Date" field from oldest to newest, you can use the following SQL script:

SELECT * FROM tbl-Employee
ORDER BY AssumptionDate ASC;

For the report, you can use a reporting tool or generate a SQL script to format the data into a tabular, landscape report. You can add your full name and index number as a label on the report by including it as a header or footer in the report.

Finally, you can save the report as "rpt-Employee" and print it for submission to your supervisor.

Detalhes da Resposta

Test of Practical Knowledge: one-week expenses spreadsheet

The steps below use Microsoft Excel; any spreadsheet package follows the same idea. A sample table is shown so the layout and formulas are clear.

1. Title and headings

• In cell A1 type: My One Week Expenses On Five Items.
• In row 2 type the headings across the columns: A2 = ITEM, B2 = 1ST DAY, C2 = 2ND DAY, D2 = 3RD DAY, E2 = 4TH DAY, F2 = 5TH DAY, G2 = 6TH DAY, H2 = 7TH DAY, I2 = TOTAL N.

2. Items and amounts

• In column A, from A3 to A7, list five items (choose your own). Enter the amount spent on each item for each day in the day columns. A worked example:

3. Totals using formulas/functions

• Total for each item (row) in column I, e.g. in I3 type =SUM(B3:H3) and copy down to I7.
• Total for each day (column), in row 8, e.g. in B8 type =SUM(B3:B7) and copy across to H8.
• Grand total in I8: =SUM(B3:H7) or =SUM(I3:I7).

4. Borders, footer, formula display

• Select the table and apply All Borders (Home → Borders).
• Insert → Header & Footer → type your full name and index number in the footer.
• Below the table, type the formulas used, enclosed in quotes, e.g. the formula in I8 = "=SUM(B3:H7)" and the formula summing B3 to H3 = "=SUM(B3:H3)".

5. Save, print, submit

• Save the file with your full name in the folder created on the desktop, then print and submit to the supervisor.

Detalhes da Resposta

To create a visiting card for a system administrator of a software company, we need to use a word processing application package. Follow the steps below:

1. Open the word processing application package and create a new document.
2. Set the page size to 3.5" x 2".
3. Set the background color to grayscale and highlight the card with a gray color at 25%.
4. Apply a shadow style to the card.
5. Type the title "Visitor" in uppercase, using Georgia font type and font size of 10pt.
6. Add two lines to separate the Office and Residential address. Then, using Cambria font type, set the font size to 7pt and spacing to 1.15.
7. Copy the card three times on the same page.
8. Insert a footer with your full name and index number.
9. Save your work with your full name in a folder created on the desktop.
10. Print your work and submit it to the supervisor.

By following these steps, we can create a visiting card for a system administrator of a software company using a word processing application package.