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

GCSE IT Coursework

Extracts from this document...

Introduction

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.

Middle

* 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.

Conclusion

* 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. ICT PROJECT

    This is stored a range named Form. This range is used as the fill range for the combo box for form when entering new student details. Gender Range The range contains M and F. The range is named Gender. It is used as a fill range for the combo box when entering new student details, which will enable the user to select a new student gender.

  2. Creating a computer system for a video rental shop

    To check for the 3NF, It shows that all non-key attributes are mutually independent The second Table is video table. It contains: Video ID Title Publisher Year of publication ISBN number Author name All the attributes values are atomic, therefore it is normalised to the 1NF To check for the 2 NF.

  1. ICT Report 2b: ICT in Organisations

    be replaced, unless you buy more expensive CD-RW discs that can be rewritten as the name implies meaning it can be used as a storage device repeatedly rather than just once. Anyway, Boots use it a storage device in exactly the same fashion as a USB flash drive in that

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

    * User-friendly: Once program is set up, does not require extensive expertise to use * Cross-functional: Data doesn't need to be translated from another program: Can use same spreadsheet for payroll management, accounting, reporting to sponsors, reporting to volunteers. Disadvantages * Unwieldy: As more people and information are added, the document expands across the screen.

  1. Database Analysis and Database Design Project - DVD library for moving images.

    DATABASE SCHEME UNF MEMBERS: (MEMBER_ID , TITLE, F_NAME, M_NAME, L_NAME, ADDRESS, COUNTY, POST_CODE CONTACT_#, DATE_JOINING, EXPIRED_DATE) DVDs: (DVD_ID, DVD_TITLE, DIRECTOR, ACTOR, , PRODUCER) 1NF MEMBERS: (MEMBER_ID , TITLE, F_NAME, M_NAME, L_NAME, ADDRESS, COUNTY, POST_CODE CONTACT_#, DATE_JOINING, EXPIRED_DATE) DVDs: (DVD_ID, DVD_TITLE, DIRECTOR, CATEGORY_DESCRIPTION, RATING, PRODUCER)

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    This means that when they do bring it back we have a big fine for them. Possible Solutions Non ICT Solution 1. A non ICT solution for making sure that people don't steal the games is that you could use a stronger more efficient glue to stick the envelopes.

  1. The impact of ICT on a person with special/particular needs

    her to actually have and maintain a job, which Sarah views as very important as it is one of her only chances to feel as though she's doing something productive * Allows Sarah to be part of at least one community which makes her feel like she belongs * While

  2. Computer project Alevels

    You can also create a table by clicking on "Create table by using wizard". Here you can follow the wizard and create the table. Or else you can "Create table by entering data", here the data can automatically added to a table that has been already created by the system.

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