Question 1 Report

INSTRUCTIONS: (a) Sort the table on SURNAME and FIRST NAME in ascending order.

(b) Delete the record for employee 279.

(c) Create a report from the table and name it SALARY. The header of the report should read "EMPLOYEE SALARY".

(d) Format:

(i) the column headings of the report with font size 14pt and bold;

(ii) the other inputs with, font size 12pt.

(e) Apply border line.

(f) Insert your full name and index number.

(g) Print and submit to the supervisor

Answer

Word Processing Package

View Answer

Question 2 Report

Insert a:

(i) new column with the heading "Name" between the first and second columns;

(ii) title "Students' Scores in Computer Studies" above the table.

(c) Beginning from the first cell under column heading "Name" to the sixth cell, type the following: Adedigba Eze, Balango Ngozi, Agbelero Cynthia, Okeowo Sulkite, Okonia Ifedola and Umaru Edonk.

(d) If "W/score" stands for weighted score, calculate:

(i) weighted score for each term given that weighted score comprises 20%, 30% and 50% of raw scores for first, second and third terms respectively;

(ii) total weighted score for the three terms.

(e) Insert your full name and index number as a footer.

(f) Save with your index number in the folder created.

(g) Print and submit to the supervisor

Answer

Test of Practical Knowledge: preparing the students' scores table in a spreadsheet

(b)(i) Insert a new "Name" column between the first and second columns

Right-click the header of the current second column and choose Insert. A blank column appears; type the heading Name in its top cell.

(b)(ii) Insert a title above the table

Right-click the first row and choose Insert to add a blank row above the table. Select the cells that span the full width of the table, click Merge & Center, and type Students' Scores in Computer Studies.

(c) Enter the six names

From the first cell under the "Name" heading downwards, type the names in order: Adedigba Eze, Balango Ngozi, Agbelero Cynthia, Okeowo Sulkite, Okonia Ifedola, Umaru Edonk.

(d)(i) Weighted score for each student

The weighted score gives 20% to the first term, 30% to the second term and 50% to the third term. If the first-, second- and third-term raw scores for the first student are in cells C3, D3 and E3, click the W/score cell for that student and type:

\[ \text{=(C3*20\%)+(D3*30\%)+(E3*50\%)} \]

which is the same as =(C3*0.2)+(D3*0.3)+(E3*0.5). Press Enter, then drag the fill handle down to copy the formula for all six students.

(d)(ii) Total weighted score for the three terms

In the cell below the last weighted score (if the weighted scores are in F3:F8) type:

\[ \text{=SUM(F3:F8)} \]

and press Enter to obtain the total.

(e) Footer

Click Insert → Header & Footer, click in the footer area and type your full name and index number.

(f) Save

Click File → Save As, open the folder you created, type your index number as the file name and click Save.

(g) Print

Click File → Print, select the printer, print the work and submit the printout to the supervisor.

Read lesson note on Spreadsheet (WAEC)

Read lesson note on Spreadsheet Package (JAMB)

Answer Details

Test of Practical Knowledge: preparing the students' scores table in a spreadsheet

(b)(i) Insert a new "Name" column between the first and second columns

Right-click the header of the current second column and choose Insert. A blank column appears; type the heading Name in its top cell.

(b)(ii) Insert a title above the table

Right-click the first row and choose Insert to add a blank row above the table. Select the cells that span the full width of the table, click Merge & Center, and type Students' Scores in Computer Studies.

(c) Enter the six names

From the first cell under the "Name" heading downwards, type the names in order: Adedigba Eze, Balango Ngozi, Agbelero Cynthia, Okeowo Sulkite, Okonia Ifedola, Umaru Edonk.

(d)(i) Weighted score for each student

The weighted score gives 20% to the first term, 30% to the second term and 50% to the third term. If the first-, second- and third-term raw scores for the first student are in cells C3, D3 and E3, click the W/score cell for that student and type:

\[ \text{=(C3*20\%)+(D3*30\%)+(E3*50\%)} \]

which is the same as =(C3*0.2)+(D3*0.3)+(E3*0.5). Press Enter, then drag the fill handle down to copy the formula for all six students.

(d)(ii) Total weighted score for the three terms

In the cell below the last weighted score (if the weighted scores are in F3:F8) type:

\[ \text{=SUM(F3:F8)} \]

and press Enter to obtain the total.

(e) Footer

Click Insert → Header & Footer, click in the footer area and type your full name and index number.

(f) Save

Click File → Save As, open the folder you created, type your index number as the file name and click Save.

(g) Print

Click File → Print, select the printer, print the work and submit the printout to the supervisor.

Read lesson note on Spreadsheet (WAEC)

Read lesson note on Spreadsheet Package (JAMB)

Spreadsheet

Spreadsheet Package

View Answer

Question 3 Report

You have been tasked to give a presentation to an audience on the topic "Computer Networks".

Use the 2 layout below to create slides using Microsoft PowerPoint.

(a) SLIDE 1

LOCAL AREA NETWORK

A computer network located on user's premises

A network in which a set of devices are connected together for communication

SLIDE 2

WIDE AREA NETWORK

A network of geographically dispersed telecommunication devices

The network may be private or public-shared.

SLIDE 3

ADVANTAGES OF NETWORKS

(i) Resource sharing (ii) Enhanced connectivity (ii) Enhanced communication

SLIDE 4

DISADVANTAGES OF NETWORKS

(i) Security concerns (ii) Virus attacks (iii) Network failure

(b)

INSTRUCTIONS:

(i) The font size of the heading should be 36pt and bold, font style Calibri.

(ii) The font size of the text in the body should be 32pt, font style Calibri.

(iii) Apply bullet numbering where necessary.

(iv) Format the slides using any background of your choice

(v) Insert your full name and index number as footer.

(vi) Save your work as Networks and print all the sides on a single sheet.

(vii) Submit the printout to the supervisor.

Answer

Answer Details

```html Computer Networks Presentation Instructions

Producing the Presentation in Microsoft PowerPoint

Create a four-slide Microsoft PowerPoint presentation on the topic Computer Networks. Enter the text for each slide exactly as provided in the question, using the specified two-layout design. Apply clear, consistent formatting to all slides so that the presentation is easy to read and professional in appearance.

Slide 1 title: LOCAL AREA NETWORK

Slide 1 Content

A computer network located on a user’s premises.
A network in which computers are connected within a small geographical area.
Examples include a school computer laboratory, office building, home, or business premises.

Use a title-and-content layout for Slide 1. Insert a suitable diagram or image showing computers connected to a central network device such as a switch or router.

Suggested LAN Diagram

Example of devices connected in a Local Area Network.

Formatting Requirements

Use a consistent theme, font style, and colour scheme throughout the presentation.
Use large, readable headings and concise bullet points.
Apply appropriate slide layouts, such as Title Slide, Title and Content, or Two Content.
Insert suitable graphics, diagrams, or SmartArt where required.
Ensure that text, images, and diagrams are properly aligned on each slide.
Save the completed presentation with an appropriate file name.

```

Read lesson note on Computer Maintenance (JAMB)

Computer Maintenance

View Answer






Press & Hold to Drag Around
Click Here to Close

WAEC SSCE - Computer Studies - 2018 (Practical)

Producing the Presentation in Microsoft PowerPoint

Slide 1 Content

Suggested LAN Diagram

Formatting Requirements

Producing the Presentation in Microsoft PowerPoint

Slide 1 Content

Suggested LAN Diagram

Formatting Requirements