WAEC SSCE - Computer Studies - 2021 (Essay)

QBASIC program to grade a score as "Poor" or "Satisfactory"

The program keeps asking for a score. If the score entered is less than zero, it stops immediately. Otherwise it prints "Poor" for a score below 50 and "Satisfactory" for a score of 50 or above.

REM Program to grade scores
CLS
DO
    INPUT "Enter a score (negative to stop): ", SCORE
    IF SCORE < 0 THEN
        EXIT DO
    END IF
    IF SCORE < 50 THEN
        PRINT "Poor"
    ELSE
        PRINT "Satisfactory"
    END IF
LOOP
END

How it works:

• The DO ... LOOP repeats so that many scores can be graded one after another.
• INPUT reads a score from the keyboard.
• If SCORE < 0, the EXIT DO statement ends the loop and the program stops.
• The IF ... ELSE statement tests the score: below 50 prints Poor; equal to or above 50 prints Satisfactory (since 50% is the boundary and belongs to Satisfactory).

Alternative using GOTO (also acceptable):

CLS
Start:
INPUT "Enter a score: ", SCORE
IF SCORE < 0 THEN END
IF SCORE < 50 THEN PRINT "Poor" ELSE PRINT "Satisfactory"
GOTO Start

(a) What are "Reports" in a database system?

A report is a database object used to organise, summarise and present data from one or more tables or queries in a formatted, printable layout. Reports are designed mainly for output: they allow the user to arrange records neatly, group and sort them, perform calculations such as totals and averages, and produce professional printed documents such as invoices, result sheets or mailing lists.

(b) Four ways in which reports can be viewed in a database management system (MS Access):

1. Report View - shows the finished report on screen as a continuous view.
2. Print Preview - shows exactly how the report will look when printed, page by page.
3. Layout View - shows the report with live data while allowing you to adjust the design and column widths.
4. Design View - shows the underlying structure (sections such as header, detail and footer) for detailed editing of the report.

(c) Steps to print a report in MS Access:

1. Open the database and, in the Navigation Pane, locate and open (or select) the report you want to print.
2. Switch to Print Preview to confirm the layout, page size and orientation are correct.
3. Click the File tab (or the Office/Backstage button) and choose Print.
4. In the Print dialog box, select the correct printer and set the options (number of copies, page range).
5. Click OK (or Print) to send the report to the printer, then collect the printout.

(a)(i) Universal Serial Bus (USB):

Universal Serial Bus (USB) is a standard plug-and-play interface used to connect a computer to peripheral devices such as keyboards, mice, printers, scanners, flash drives, cameras and mobile phones for communication, data transfer and power supply.

(a)(ii) Benefits of USB connection:

• It supports plug-and-play; connected devices are automatically detected and configured.
• It allows data transfer and can also supply low-voltage power to devices through the same cable.

(b) Identification and category of storage devices:

Universal Serial Bus (USB) is a standard plug-and-play interface used to connect a computer to peripheral devices such as keyboards, mice, printers, scanners, flash drives, cameras and mobile phones for communication, data transfer and power supply.

(a)(ii) Benefits of USB connection:

• It supports plug-and-play; connected devices are automatically detected and configured.
• It allows data transfer and can also supply low-voltage power to devices through the same cable.

(b) Identification and category of storage devices:

Oké

Oké

Weet je het zeker?

Wilt u doorgaan met deze actie?