The Design - From a given specification for a multiple form program, develop a visual language program
computer science
Description
|
Assessor |
Martin
Rowe |
Diploma |
Computing |
Subject |
Programming |
|||
|
Unit |
Programming
User Interfaces |
Code |
CBK957 |
Credits |
6 |
|||
|
Task
Title |
Database
and Program |
Task no. for
unit |
2 of 3 |
|||||
|
Date
set |
w/c 02/12/19 |
Submission date |
w/c 06/01/20 |
Draft Deadline |
w/c 16/12/19 |
|||
|
Task |
Form of Assessment |
|
1 – The Design - From a given specification for a multiple
form program, develop a visual language program (5.1a, 5.1b, 5.1c and 5.1d) Page 3 |
Program code |
|
2 – Implementation - Use a visual programming language to
write a program which involves standard basic commands (3.2a, 3.2e, 3.2g and
3.2h) Page 4 |
Program code |
|
3 – Dealing with errors and Debugging - analyse
and respond appropriately to error messages and explain and make appropriate
use of debugging tools (4.1a, 4.1b, 4.2a, 4.2b and 4.2c) Page 5 |
Screenshots and descriptions |
|
4 – Testing - from a given
specification for a multiple form program, develop a visual language program
that includes test run results (5.1e) Page 5 |
Written evaluation |
|
5 – Evaluate the program in terms of
defects, limitations, possible amendments and working practice experience
(5.2a, 5.2b, 5.2c and 5.2d) Page 5 |
Written evaluation |
|
Guidance Notes: See Week by week summaries on Moodle
for references back to supporting worksheets and tasks that we’ve done in
class |
|
Assessment
To achieve a Pass grade the
submission must meet all the Assessment Criteria below. If all the Assessment
Criteria are met, your submission will be assessed for higher grades
against the identified Grade Descriptor components. If all the Assessment Criteria are not
met then you will be offered a resubmission within a short deadline set by your
tutor. If your second submission, within the designated short period meets the
Assessment Criteria it becomes eligible for assessment for the higher grades.
|
Assessment Criteria |
|
|
3.2 |
Use a
visual programming language to write a program which involves standard basic
commands to cover the following functions: a)
Transferring between forms e) Modules g) Clipboard h) Linking to databases |
|
4.1 |
Analyse and
respond appropriately to these error message: a) Run time
errors b) Compile-time
errors |
|
4.2 |
Explain and
make appropriate use of the following debugging tools: a) Break
points b) Watches c) Single
stepping |
|
5.1 |
From a
given specification for a multiple form program, develop a visual language
program that includes: a) Form
designs – showing controls, objects and any additional features b) Pseudo code
for any subroutine logic c) Top-down
design where appropriate d) Test
schedules e) Test run
results |
|
5.2 |
Evaluate
the program in terms of: a)
Defects b)
Limitations c)
Possible
amendments d)
Working practice experience |
|
GD No. |
Merit Grade descriptor component |
Distinction Grade descriptor
component |
|
3 |
The
student’s work demonstrates
appropriate skills with very good levels of consistency and
accuracy |
The
student’s work demonstrates appropriate skills with excellent levels
of consistency and accuracy |
|
5 |
The
student’s work show very good command of format, structure and syntax |
The
student’s work show excellent command of format, structure and syntax |
|
7 |
The
student's work taken as a whole, demonstrates a very good response to
the demands of the assignment |
The student's work taken as a
whole, demonstrates an excellent
response to the demands of the assignment |
|
This task |
All |
|
BACKGROUND
A
program is required to be designed and created that will allow information of
one of the categories from Appendix A to be entered and displayed by using
multiple forms.
The
program is required to link to a Microsoft Access database and should allow for
products to be added, viewed, amended or deleted.
A
suitable primary key needs to be assigned in the table.
The
program must contain a login screen (username and password) to provide
authorised access to Add, View, Amend and Delete product information. The program must make use of a separate form
for Add / Amend and a separate form to display all product information by using
a grid view and system date.
TASK 1 – The Design
Task 1A– Form Designs
5.1 From a given specification for a multiple form program,
develop a visual language program that includes:
(5.1a - Form designs – showing controls, objects and any
additional features)
Select
one of the program specifications from Appendix A and design a number of forms
that could be used to provide the following functionality:
- A login screen that
will require a valid username and password to be entered. If the incorrect username / password is
entered more than 3 times, the program should automatically close.
- Allow products to be
added, amended and deleted.
- Display all product
information in a Data Grid
- The form or forms
that will be used to add, amend or delete must contain the username of the
person who has logged in by copying the username from the login screen
text box to a label on the other form or forms by using the clipboard.
Each
of the form designs must be annotated to identify type of controls and objects
and the names you intend to use for each one.
Task 1B – Pseudo Code
