• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  • Level: GCSE
  • Subject: ICT
  • Word count: 4782

GCSE IT Coursework

Extracts from this document...


Coursework Section A: Introduction D & D newsagents are locally run newsagents situated in Sturry, It is run by Andy Farham. He recently took over the business from Colin Mills. The business is purely local and deals with many customers. The current system involves manual records of stock, revenue and expenditure, and employment records. D & D newsagent employs three shop workers, including the owner. And D & D also employs ten paper boys/girls. The records for wages is filed on a piece of paper, and often the paper goes missing and Andy Farham relies on the employees remember how much they are paid. The main problems of the paper filing system that he uses at the moment are that- * The system takes up more room than an IT based system * The paper filing system is unable to search for specific data as quickly as an IT based system. For instance if the user wanted to search for the age of the customer, to see if they are old enough to buy alcohol, then for a paper filing you would need to search through the entire filing cabinet, and then search the paper sheet for the data, whereas the IT system can simply search for the data that is required. * You cannot verify or validate the data that is entered, whereas I will be creating a database for this shop to make the business more efficient. In this database I will use * Stock Levels i.e. How many of product "X" is left * Income, how much the business is making * Expenditure, i.e. how much money is spent on things such as stock and staff wages. * Records of paper delivery customers, i.e. Address', names, payment records etc * Staff Details, address, name etc * Magazine subscription records * Details of Regular Customers, what products they buy. The reason that I will design a database is that it will improve the efficiency of the business and the convenience. ...read more.


* They will need a barcode scanner as it is a shop that sells items with barcodes on them so it will save time because the staff won't need to remember all the prices of all the products on sale. * I also suggested a swipe card reader after asking them if they had many people asking to pay by credit card as it becomes inconvenient for the customer if they have any other form of payment. * For the specification of the computer, I will use an Intel Celeron 2.0Ghz processor, will use this because it is a good cheap processor, it will run any program, and will not need to be replaced soon. * I will use 128mb of R.A.M, this is because it is very cheap, and is enough memory to run Microsoft Office and Windows XP. * The hard drive will be 60 GB, this is because it will give lots of storage, enough to handle the operating system, and other software that they need. And have lots of space left over. * The operating system will be windows XP, this is because they will need a stable operating system, and XP is the most stable windows operating system. It also has better security than the other operating systems. And will be compatible with more programs. * I will put a DVD/CD combo drive, this so that they can back-up the data on the hard drive to CDs and DVDs, this will mean that they shouldn't lose any data * A keyboard to enter text, e.g. surname * Mouse to select items in the system forms, e.g. Drop down boxes for product selected. Section E (ii): Software My system will need to be able to search for customer and stock records; it should also be able to use validation checks and verification checks. Another feature the software needs is to be able to design front end forms to capture data, and the ability to create relationships between two databases. ...read more.


* It uses validation checks to check the data entered is within a sensible range. And if it can use verification checks to check that the data entered is the correct kind. * The security is improved, instead of data being held on sheets of paper in an accessible cabinet, the data can be stored and protected by passwords, so confidential data such as people's address. Since the information is kept in one place, it can be more secure. * The user now has the ability to modify the data held in the database, in case customers move or change details, if a customer changes their address, then it can be easily edited to update the data. I if were to make 3 improvements to my database I would password my database to improve the integrity, and because it can store information on customers that people apart from the user is not allowed to see, I would set a minimum length for the password to be, to improve the integrity of the database. I would link it to the internet to allow people to find out information on stock, and what information is held on them in the database, this means that the stock listing of the shop will be available on the internet, which will be useful for the customers, as they can see what they can buy without leaving the house, it also means that they can update the information held on them, i.e. if they move address, they can send an email to the owner of the shop, with the change of details. I would also include a keyboard with hotkeys to input data into drop down boxes, as this will decrease the time needed to enter lots of data. It would also prevent RSI, because the user is using the keyboard less, and doesn't need to press as many keys. ?? ?? ?? ?? Ryan Bebbington GCSE Coursework Page 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related GCSE ICT Systems and Application essays

  1. GCSE Database Project ICT

    2 CPU 6300 @ 1.86GHz (2 CPUs) Memory: 4066MB RAM Hard Drive: 200 GB Total Video Card: NVIDIA GeForce 7300 SE Monitor: SyncMaster 911N/920N/920Nx, SyncMaster Magic CX918N Sound Card: Realtek HD Audio output Speakers/Headphones: Realtek HD audio Keyboard: Terminal Server Keyboard Driver Mouse: Terminal Server Mouse Driver Operating System: Windows XP Home Edition (5.1, Build 2600)


    I will validate all cells, into which marks are inputted as these needs to be as correct as possible. Format checks will be used on cell so that the user inputs the information in the correct format, if the user input the wrong format the spreadsheet would tell the user to correct the mistake.

  1. Data Validation and Verification

    In this case the data would also be input directly into the system. When a new patient comes depending on how busy the surgery will depend what data entry method I would use. If it were busy then I would issue the person a paper-based copy of the Patients form for them to fill out.

  2. Creating a computer system for a video rental shop

    So the member table is normalised to 1FNF To check for the 2 NF. We found that every non-key attribute is functionally dependent on the unique identifier (Member ID). So if we No the member ID, we can determine first name, second name, address and telephone number.

  1. ICT Report 2b: ICT in Organisations

    The me mory is stored as digitally encoded data. Typical data capacity is between 10 and 40GB. However, in the Boots R&D Department, their computers have a minimum of 60GB memory in their hard drives. It is essential that Boots have a large memory capacity as the research they put

  2. GCSE Excel Project ICT

    Now the OS cell (B16:D16 (merged)) this has multiple values but it is not important enough to have a separate sheet, so a drop-down box will be created. We select B16 and, under the data validation tab, we are brought to this pop-up box: As we wish for this cell to be a 'drop down' box

  1. I will design a new video database for the video shop that will also ...

    on the actual database so it doesn't become too full and confusing. The system will have a large memory capacity as the video shop has to keep records of a large number of customers. Any documentation that is needed for the system will also be created, such as a user-guide and a technical manual.

  2. Planning a system to handle school records.

    Grade boundaries Examination department Personal interview, questionnaire Hardware need: The hardware I need to use with includes a PC with normal RAM and Hard Drive (calculations in Excel do not require great processor speed), Peripheral devices: Key board, Mouse, Scanner, Monitor and Printer.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work