Page 1010 - SUBSEC October 2017_Neat

Web Page Design

This assignment should be limited to one web page that is designed using a word processor or a free
online web service. Students can insert screenshots or create the design of the web page at the end of
the word-processed document. Alternatively, they can use the last page in their word-processed
document to paste the link to the online web page. Only the candidate number placed near the top of
the page should be used as a form of identification for the web page.

The web page should contain at minimum:

(a) a logo depicting the concept of the project;

(b) defined areas on the page for navigational links and content; and,

(c) at minimum two hyperlinks of the following:

 link to a location within the web page;

 link to an email address;

 link to another web page (which may or may not exist); and,

 link to user-created files.

Spreadsheet

This assignment should be saved as one workbook (comprising two or more worksheets). The tasks
should be limited to:

(a) a maximum of TWO major tasks (for example, create the spreadsheet; modify the spreadsheet)
consisting of no more than THREE requirements (for example, sorting of data and use of
functions and formulas on data); and,

(b) the creation of no more than TWO types of charts.

Database Management

This assignment should be saved as one database file. The tasks should be limited to no more than:

(a) THREE tables or files.

(b) TWO queries (using criteria from one table, and more than one table).

(c) ONE calculation within queries.

(d) ONE form, showing a main and sub-form and VBA control button (for example, to search for
a record, or to move to the next or previous record).

(e) ONE report, with grouping and sorting involving TWO or THREE tables.

CXC 30/G/SYLL 17 33