Enter Name Here (Enter Candidate Number Here)..=__=’’ GCSE ICT (O) Coursework
AQA GCSE ICT
Specification B
Title of Project
[Note that this can be in the form of a logo]
* Name: Gary Wong `
Candidate Number: [Enter Number Here>O<’’]
Centre Number: 56400
=____=’’
Contents
Operational Scenario
Description of the task to be attempted
Initial Problem Definition
The first problem is the importing of new football items.
The second is to get close to the fashion.
To solve the problem of old fashioned
Background to the company
I am going to do a business of a football shop in London. It will sell different types of footballs, football boots, football shirts and other things related in football.
My shop is intending to sell the newest items to teenagers.
All the staff will have some training programs.
Details of the current system
It is a famous shop in London Central. There are 23 stores all around London.
Only 10 stores can pay with credit cards.
When customers spend £30 in any of our stores, they will get a discount of 10%.
Analysis of the current system
The importing of clothing are too slow at the moment, especially jeans.
Install credit card systems to every store. ‘computerised system’
Details of the task to be attempted
Using excel spreadsheet to enter the information, print receipts and number of stock.
Description of the task to be attempted.
Description
This is a football shop which sells any items that is related to football. Customers come in shop with a specific amount of budget and requirements depending the type of football items. The shop assistance will then tries his/her best to match the requirements. The customers normally ...
This is a preview of the whole essay
The importing of clothing are too slow at the moment, especially jeans.
Install credit card systems to every store. ‘computerised system’
Details of the task to be attempted
Using excel spreadsheet to enter the information, print receipts and number of stock.
Description of the task to be attempted.
Description
This is a football shop which sells any items that is related to football. Customers come in shop with a specific amount of budget and requirements depending the type of football items. The shop assistance will then tries his/her best to match the requirements. The customers normally requires a quote so that they can consider the price and compare it to other shops in the area. The shop assistance will look up the prices of different component types and add them up to make sure it remains under budget. Often the customers might decide to change some components to a cheaper one or a better one, so the shop assistance has to look up the prices and recalculate the quote. This is very time consuming. Customers may have walked out of the shop fed up with waiting and he has consuming. The shop assistance has made mistakes with the calculations in the past and he has lost valuable revenue, there are data validations in the system, this will stop any wrong input data.
Analysis
Results of discussion with user
Output Requirements
Shop name/ Address of the shop/ Telephone
Customer Name (First/Surname)
Membership No.
Products Bought
Delivery Cost
Discount
Total cost/Change
Cash/Credit card
Input Requirements
Pre-Programmed Data
Shop name/ Address of the shop/ Telephone
Customer Name (First/Surname)
Delivery Cost
Discount
Total cost/Change
Data Entered by User
Membership No.
Products Bought
Cash/Credit card
Possible Solutions
Solution 1 – New Paper Based Solution
A printed form with different columns and space for calculations and price lists.
In the form there could be set prices and the items wanted by the customers.
The problem is when the price changes, we will need to change the price and reprint a new form.
This is the cheapest solution, but it is easy to lose the paper and may be errors on the sheet of paper.
Solution 2 – Spreadsheet Based Solution
Using excel spreadsheet to do all the calculations, type in formulas and equations to calculate the price.
This is a quicker solution which does not need to use much time. This method can also reduce the risk of human calculation errors, but could still enter the wrong data and make the total wrong. For example you entered the number of items wrong.
Solution 3 – Bespoke Software Solution
Setting up a system which fits my requirement.
The only problem of the system is just too expensive.
It is a very efficient system, it will work out the total or items of the customer itself.
The system could generate automatically and invoice will be printed.
Final Choice of Solution.
I have chosen the third solution. Although it is a very expensive system, but it can work out the sums or total of items accurately. It can solve all the problems which the first and second solutions cannot. I have chosen the third solution over the second solution is because it is a quicker method for customers. It will also look neater and better than solution one as it is using computer rather than a sheet of paper.
Specification of Solution
System Overview
Number of total users of the system
Total users of the system is four.
Maximum number of concurrent users
It can just be one using each time.
ICT Skills of end users
Close down system and exit system.
Hardware constraints
Black and white printer to a colour printer.
Software constraints
Latest copy of Office and the system.
Security requirements (both physical and data related)
Use password and username to log in.
Create a personal account for every staff.
Business rules to be adhered too (e.g. maximum allowable budget)
We need a lot of money, we need to save money. We will also use our skills to make money e.g. fixing the computer.
Technical support requirements
Using new software to work the system.
Staff will help customers.
Backup details
Store the information and save a copy.
Deliverables (what will actually be provided? – e.g. manual, discs)
Providing good services
Evaluation Criteria
Design of the ICT System
System Navigation
System Tasks
- Go to the whole system
- Go to main menu
- Choose one of the following options
- Sales
- Components
- Invoice
- Display the ‘SALES’ sheet
- Enter customer name and details (Membership No.=)
- Enter customer telephone number and mobile phone number
- Enter budget
- Balance calculate
- Enter items bought
- Enter quantity
- Enter delivery cost
- Enter cash, credit card or cheque
- Enter discount
- Enter paid
- Check entered details
- Print invoice
- Save the sales
- Go back to sales page
Screen Designs
Quote page
Screen Designs
Main menu
Screen Designs
Components page
Implementation
Hardware and Software Required
Hardware Required
It can either be a laptop or a desktop.
The company will need the following:
A PC, with a flat screen.
CD-Rom or DVD Drive.
Keyboard and Microsoft mouse.
Colour laser Printer or ink jet printer.
A CD burner drive.
Software Required
The desktop will need the following requirements:
Operating system: Microsoft Windows XP with Service Pack.
Installed with Microsoft Excel, Microsoft Word, Microsoft Outlook
Windows Server XP
Service Pack 3.(SP3)
Intel Pentium 233-MHz or faster professor.
128MB or greater; optional installation files cache. Requires an additional 200MB of available of available hard-disk space; optional installation of Business Contact Manager for Outlook 2003 requires an additional 190 MB of available hard-disk space.
Justification of Hardware Choices
Colour laser Printer.
To print some high quality of
invoice and paper.
Internet requires dial-up or broadband Internet access.
Local or distance charges may apply.
PC with 300 high professor speed, 233 MHz minimum required
Intel Pentium or Celeron
128 megabytes of RAM
1.5 gigabytes of available hard disk drive space.
Super VGA(800x600) or higher resolution video adapter and monitor.
Printer: to print quotes and invoices.
A laser jet or ink jet is cheaper and do not cost a lot to run.
TO backup all the sales, we will need a CD burner drive.
They have more space than a floppy disk.
Justification of Software Choices
Need to have a copy of Microsoft Word, Excel, Outlook.
Excel has a combo box to make choices, it can limit the choices that can be chosen.
Also drop down list, you can choose from the drop down easily.
Macros, data validation, protection, formula.
Data collection, data capture and input
Data verification and/or validation
Data and/or program structures
INDEX FUNCTION(D11:D26) ,When an item is selected, it will show the price in the PRICE column.(B11:B26)
It depends on the quantity and calculates the discount and gives the total.
Quantity (Enter) Each items 0.05 discount (E11:E26)
Brand name Time and date now. (NOW function)
Name, telephone number, member no., mobile phone number.
Entered different customer.(B3:B6)
Output format
Invoice page., receipt print out.
Testing
Evaluation Criteria
[Copy the table from the Specification Section in here]
Test Plan
Norm = Normal Data
Ext = Extreme Data
Inv = Invalid Data
Test Data set 1
Testing Against The Test Plan 1
I typed in the wrong data accidentally.
As follows.[typed in 999. I set the budget to at least 1000.]
Because 999 is under 1000, so data validation shows up an alert message.
Quote from data validation message.
“The value you entered is not valid. A user has restricted values that can be entered into this cell.”
Testing Against The Test Plan 2
Typed in the wrong section that doesn’t need to be changed.
Typed in the number 2..which have been accidentally typed in.
Quote from data validation message.
“The value you entered is not valid. A user has restricted values that can be entered into this cell.”
Further on testing
Scenario..~
Ricky is a keen footballer and has a budget of $2000 to spend on some new football items. Ricky’s primary needs is the best football boots, as he believes that good football boots can make him a better footballer, then good football team shirts, then football shin pads, then some football socks.
Select most expensive football boots.
Select most expensive football team shirts.
Select most expensive football shin pads.
Select cheapest football socks.
Put in $2000 as a budget (that’s what Ricky wants.)
This selection has gone over budget. The change has highlighted red.
Remodel using a cheaper selection.
Evaluation
Evaluation of the system produced
Possible Refinements
User guide
- Select football shop.exl in my documents
- Double click
- System will open
System first page
Generating a quote
1. Enter customer budget in cell B28.
2. Select components
3. Frame in dropdown in cell B11-B14.(football boots)
4. Frame in dropdown in cell B18.(team shirts)
5. Frame in dropdown in cell B21.(socks)
6. Frame in dropdown in cell B24.(shin pads)
7. Select quantity for each one.
8. the total will appear at the end of each item.
9. select delivery cost.
10. net cost will appear in B36.
11. gross total will appear in B38.
12. select paying method in B39.
13. put in paid money in F34.
14. give the changes appear in F35.
Completing Customer details.
- Type in Customer name in cell B3.
- Type in membership number in cell B4.
- Type in telephone number and mobile number in cell B6 and B7.
- Choose if they want to delivery service.
- Press print invoice button, quote will print twice, one for the customer, one for backup purposes.
New Customer
To reuse the model simply repeat the steps above with the new customer requirements.
Updating components
Go to components sheets.
To add a new components type in descriptions at the blank entry in the appropriate column and the price in the next column.
For example a new frame must go on cell ______ with the price in______/
Close down system
- Go to file pull down menu
- Select exit
- When prompted whether to save choose yes.
Technical Aspects
Formulas.. as follows..
Change discount
=Cell E11 (0.05 change to 0.1)
Total
=Column D * Column C * Column E.
133712.doc (Revision 102) Monday, 07 May 2007 Page of
