AQA GCSE ICT Specification B
GCSE ICT COURSEWORK Help Guide (Excel Edition)
Tom Walford Last update: September 2009
RBCS ICT Department
Contents Description of the task to be attempted ..................................................................................................................... 3 Initial Problem Definition ................................................................................................................................................ 3 Background to the company ........................................................................................................................................... 3 Details of the task to be attempted ................................................................................................................................ 4 Analysis ...................................................................................................................................................................... 5 The Current System ........................................................................................................................................................ 5 Input, Output and Processing Requirements.................................................................................................................. 6 Possible Solutions ........................................................................................................................................................... 7 Specification ............................................................................................................................................................... 8 System Overview ............................................................................................................................................................ 8
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 2 of 12
RBCS ICT Department
Description of the task to be attempted
The aim of this section is to give the reader some background information about the company you are building a system for, what they do, why they have a problem and a brief description of what you have been asked to do. To get maximum marks you must produce a description that is concise and clear and shows a good understanding of what is involved within the problem. To get any more than one mark the description should provide sufficient detail to provide a clear indication of the problem, in both depth and extent, which you have chosen to solve.
Initial Problem Definition Problem Statement Write a one or two sentence statement detailing, in very general terms, what the problem is.
The problems faced by the company What the problems are?
Why they are a problem… Write down the details of the problem being faced by the “third party” you are working for. You should focus on the problems caused to the business by the use of an archaic paper based system and the implications to the business if they were to continue using it.
In this section it might be useful to look at the following: http://www.teach-ict.com/gcse/theory/infosystems/miniweb/index.htm
Other Information You should also talk about the complexity of the problem and the extent of it (ie how difficult would the problem be to solve with an estimate of how long it might take)
Background to the company Company name and location
What is the name of the company? You should also give its full postal address and contact details.
Business Contact
Who is your contact at the company?
Nature of business
What is the nature of the business? What type of business is it? What is the scale of the business? PLEASE BE AWARE THAT YOU SHOULD BE BUILDING A SYSTEM FOR A SMALL COMPANY (MAX THREE EMPLOYEES!!!!!)
Intended market
Who do they supply their product / service to?
Staffing Structure
What are the names of the staff at the company? If it makes sense to, you should also show a hierarchical diagram of the staffing structure
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 3 of 12
RBCS ICT Department
Details of the task to be attempted To complete all the sections below, you should pay attention to the headings in this document. You might also want to look at http://www.teach-ict.com/gcse/theory/syslifecycle/miniweb/index.htm. Please bear in mind that, as this is the very first section in the whole coursework document and you have not actually done anything yet, it should all be written in the future tense. Analysis
In each cell of the table you should write what you WILL do when you complete this section...
Specification Design Implementation (Development of System) Testing Evaluation User Documentation
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 4 of 12
RBCS ICT Department
Analysis
In this section you take an in-depth look at the current system employed by the company, before looking at what they want out of the new system. You will also have to look at different ways of solving the problem using a variety of different types of application software (eg spreadsheet and databases) To get the full 3 marks available you need to demonstrate a clear understanding and analysis of what is involved within the problem, an insight into the possible methods that could be employed in its solution and reasons for the chosen method of solution.
The Current System Construct either a numbered list or a flowchart that details HOW the current system operates (ie what happens when a customer rings up to place an order?) Then, using text boxes and arrows, highlight the areas of the system that are causing concern and say why.
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 5 of 12
RBCS ICT Department
Input, Output and Processing Requirements For each output required by the system you should complete one of the following tables (with its own heading in Heading Style 3):
Output Name Information on Output What information is required on the output itself
Inputs Required
Processing Required
Any data that will be entered into the system either during its development or in its daily use
Anything that needs to be done to the input data to create the output data.
eg
eg eg
Company Name, Logo and Address Customer Title, Initial and Surname Customer Address Date of Booking Type of Booking
Company Name, Logo and Address Customer Title Customer First Name Customer Address When they want the booking
Find all the details relating to a particular job. Net Cost = Sum of all components VAT = Net Cost x 17.5% Gross Cost = Net Cost + VAT
etc… etc ...
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
etc..
Page 6 of 12
RBCS ICT Department
Possible Solutions For each of the three possibilities listed below: Research the feasibility of implementing the solution in this way Write down the pros and cons of using each solution Find possible software options and costs.
Solution 1 – New Paper Based Solution Pros
Cons
Software Options
Solution 2 – Spreadsheet Based Solution Pros
Cons
Software Options
Solution 3 – Database Software Solution Pros
Cons
Software Options
Final Choice of Solution. Write down a DETAILED statement as to why your client have chosen option 2. You should focus on
A comparison of the pros and cons The available software Your skill in using the available software Any costs involved
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 7 of 12
RBCS ICT Department
Specification System Overview Number of total users of the system
How many users will ever use the system?
Maximum number of concurrent users
How many users will use the system at once?
ICT Skills of end users
What are the ICT skills of the people who will use the system?
Hardware constraints
Does the company already own a computer? If so, what is the specification? Will the new system have to work with it, or will it be replaced?
Software constraints
If the company owns a computer, it will have some software installed on it. Again, list what it is and whether the new system will have to be compatible with it.
Business rules
Does the company have any rules that the system will have to adhere to (eg: there is a minimum labour charge of £40)
Technical support requirements
How will the new system be supported? Who is in charge of maintaining it?
Data security details
How will the data be kept secure (both from theft and corruption)
Physical security
How will the hardware be kept secure?
Deliverables
What will be delivered to the company?
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 8 of 12
RBCS ICT Department
Operational Scenario Once you have had a fictitious chat with the end user you should be able to complete this section, which will form the basis for your design of the database and of the user interface. What you need to write here is, from the user’s perspective, what they would expect to experience whilst using the new system. There will be a number of different scenarios that the system will be expected to cope with during its lifespan; you should list as many as possible... For example: “When we first load the system we would like …” “We would like a screen where we can enter all the information we need to about an order. Once it has been entered we would like to be able to …” “If a customer loses his original receipt the system should ...”
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 9 of 12
RBCS ICT Department
Evaluation Criteria Criterion Number
Criterion
Justification
1. 2. These are the criteria by which you will judge your system to be a success or not. Each individual criterion will need to be justified as to why it is important that you check it later on! Remember that your reasons must be centred on the needs of the end user. The sorts of things that you need to check are:
Is everything that should be on a report / form on it? Do all the validation checks function as expected? Do all the navigation buttons work? Do the correct prices come up when different options are selected? Are calculations performed correctly? If the database needs to be filtered – do the filters work?
GCSE Coursework 2011 Cohort - Help Guide - Working Copy (Revision 12)
Page 10 of 12