WJEC - A2 ICT
  • Home
    • Messages
    • About the course
    • Timetables
    • Term dates
    • Important dates
    • Useful links
  • Exam
    • Exam Theory
  • Tests
    • Test: Networks
    • Test: the Internet
    • Test: HCIs
    • Test: Working with ICT
    • Test: ICT Security Policies
    • Test: Database Systems
    • Test: Management of Change
    • Test: MIS
    • Test: SDLC
  • Coursework
    • Coursework
    • Rules
    • User Requirements
    • Design Specification
    • Implementation
    • Testing
    • User Documentation
    • Evaluation
  • Progress
    • Option B Progress>
      • Marks - User Requirements
      • Marks - Design Specification
      • Marks - Implementation
      • Marks - Testing
      • Marks - User Documentation
      • Marks - Evaluation
      • Total Marks
    • Option C Progress>
      • Marks - User Requirements
      • Marks - Design Specification
      • Marks - Implementation
      • Marks - Testing
      • Marks - User Documentation
      • Marks - Evaluation
      • Total Marks
  • Careers
    • Careers in ICT and Computing
    • Computer Forensics
    • Cyber Security
    • Network Manager
    • Information Systems Manager
    • Computer Games Designer
    • Computer Aided Design (CAD)

ii)    Design Specification [24 marks]

You will have to produce designs for:

-    inputs
-    user interface
-    queries
-    outputs
-    processes

It is your responsibility to make sure that you complete all of the work below.

Click here to see this checklist in Microsoft Word.

Data Dictionary [4 marks]

1 mark for producing a table showing fieldname and data type for at least three tables
1 mark for the design of the format of the data in each table

Normalisation [2 marks]

Diagram or tables showing normalised tables
1 mark for normalised form of tables
1 mark identifying primary key and foreign keys

Design of validation techniques [1 mark]

1 mark for a validation technique (eg length, range, input mask)
1 mark for a different validation technique

Validations should include clear and useful error messages with no spelling or grammatical mistakes

Design of security/password protection techniques [1 mark]

1 mark for the techniques used - a flowchart or pseudo code or list

Design of user interface [1 mark]

Design of user-friendly, menu driven, front end interface (hand drawn or DTP design)
Note: this is pre-implementation so no screenshots of forms can be counted as design

Design of on screen data entry forms [3 marks]

These designs should be hand drawn or DTP design

1 mark    design of at least two forms

1 mark    design of a form with a subform

1 mark    this mark is for quality and detail:
                 -    The names of all fields and sample data should be shown
                 -    Any special features on the form
                 -    How it matches house style

Note: this is pre-implementation so no screenshots of forms can be counted as design

Design of queries [6 marks]

-    There must be six separate queries for six distinctive reasons
-    You cannot double up by saying a single query using a parameter counts as two marks

2 marks     for two single table queries - each must have realistic reasons for each query, not just describing what the
                    query does and not just to display certain fields
            
                    The field name logical operator and search criteria must be clearly shown in the design

1 mark       for a multiple table query using relational links

                    Important: if you use these to create the calculated field, you must then produce a separate calculation 
                    in the report or form

1 mark       for a multiple table query using relational links with search criteria

                    A realistic reason for the search must be stated in the design
                    The fieldnames, logical operator and criteria must be clearly shown in the design

1 mark       for a parameter query

                    You must design the statements they will ask as well as give the reason for the search and
                    the criteria needed for it

1 mark       for an Append or Delete or Update query

                    You must identify what the client wants to search and why they want the data

Design of outputs [2 marks]

1 mark        Design of report

                    There must be a realistic reason why the organisation wants these reports. In addition, you must:
                    -    clearly display fields and contain reasonable detail
                    -    detail the data and the tables or queries needed
                    -    allow for suitable original headers and footers
                    -    have sorted and grouped data

1 mark        Design of a calculation, totals or statistical field

Design of processes [3 marks]

2 marks    for the creation of at least two simple Visual Basic code procedures

                   Code, pseudo code or flowcharts are acceptable methods of design

                   Examples could be:
                        -    code for own validation procedures
                        -    toggle buttons to hide data
                        -    username and password routine code
                        -    own calculations routines written in Visual Basic and different from others in this section

                  These procedures must not be macros
                   They must not be too simple, eg using =Now() in a text box

1 mark      Design at least one calculation in a query or a form           
Powered by Create your own unique website with customizable templates.