Page 1011 - SUBSEC October 2017_Neat

Problem-Solving and Programming

This assignment should use Pascal or VBA code. If VBA code is being used, then it should be a part of
the spreadsheet workbook. Examples include but are not limited to:

Pascal:

(a) prompting for data entry with appropriate validation with suitable messages output to the
user; and,

(b) input of data to variables and required calculations.

VBA code:

(a) prompting for data entry to a sheet with appropriate validation with suitable messages
output to the user; and,

(b) input of data to specific cells and calculations performed using functions or formulas by
clicking the command button.

The code should be limited to:

(a) Input of values or sets of text.

(b) Output of results or messages.

(c) Conditional branching (if-then; if-then-else, or case).

(d) Iterations/Looping (for, repeat, or while).

Examples may involve basic use of a formula or single function (such as Sum, PMT, Vlookup).

The problem-solving section must be submitted as a PDF document.

Requirements Guidelines

Cover sheet The information supplied here is essential since it is used
to associate the submission with a particular candidate.

Problem definition Students should provide the statement of the problem, that
part of the problem that was chosen for coding in the
spreadsheet.

Algorithm Students are expected to include flowcharts or pseudocode
for the segment of code that will be written.

Source code A copy of the VBA or Pascal code.

Trace Table using test data In situations where output is relevant, students are required
to supply the test data that produced the output. This
information would be necessary to determine whether the
tasks have been performed correctly.

CXC 30/G/SYLL 17 34