• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Information technology - Company systems.

Extracts from this document...


Project Introduction I have selected an end user for my project. The Parker family own a string of stationery shops which have been very successful. However, the Parker family noticed that their selection of 'post-it' notes has become very successful and is the best seller for the company. The Parker family's son, James, has decided to run a separate company, specialising in 'post-it' notes. The company will need to buy and sell goods and must have a fully functional system from which to direct operations. Currently the system is stored on file, which is on paper and not very convenient for a large company. The company is run from the main offices of his parents company and therefore will need to be on computer to take up less space. The system will need to be able to: * Have a catalogue of goods available. * Buy and sell goods. * Process delivery requests quickly and easily. * Produce a bill / receipt for the customer. * Keep a list of all stock levels. * Keep a list of all previous customers. ...read more.


So I would need the system to be as simple as possible!" Spreadsheet Design Below is a list of the spreadsheets that I intend on using along with a brief description of what they will contain and the function it will have within the system itself. Order Form The order form will be used by the company to process the orders which the customer can place. It will have spaces for name & address, Product name & number, cost, quantity & total. As these cells are filled in the sub-total cell will calculate the sub-total of the order without the postage & packaging added on. The total cell will then work out the total cost of the order, including costs for postage & packaging. Previous Orders This sheet will save all the orders from customers which have been processed using the 'Order Form' ad save them in a separate sheet incase any orders should be queried. Countries This sheet contains a list of all the countries to which the 'Post-it' people will deliver. Catalogue The catalogue sheet will have a list of products which the customer can order, along with the price of the product including size's large & small. ...read more.


Name Of Column / Section Data Description & format Comments Example Name The name of the customer. Text Mrs Banks Street The street at which the customer lives Text / Number Carleton Road City / Town The city / town at which the customer lives. Text Pontefract Postcode The customers postcode Text / Number WS4 RF6 Country The country in which the customer has residence Text England Invoice Total The total for the order. Currency � �99.90 Countries Name Of Column / Section Data Description & format Comments Example Country The name of the country Text England P&P The cost of Postage & packaging (percentage) Text / Number 10% Exchange rate The exchange rate of that country to pounds (�) Text 1.23 Symbol The countries currency symbol Text / Number EU - Euro Catalogue Name of column / section Data description & format Comments Example Code A number which identifies the product. Number maximum of 3 numbers. 2 Item When the code is entered the item will appear here. Text Red (Small) Cost / Price When the code is entered the cost of the product will appear here. Currency in � �9.99 Chris Blackwell ICT Coursework 12D ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science 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 AS and A Level Computer Science essays

  1. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    Rapid Application Development was a software development methodology introduced in the 1990s and presented in book form by information technology guru James Martin. A reaction to the then well-established methodologies which emphasised careful and prolonged requirements gathering before the actual software development began; Rapid Application Development encouraged the creation of

  2. Peer reviewed

    information systems assignment 2

    4 star(s)

    * Efficiently holds and handles large amounts of data. * Normalisation, this means that all data is normalised so it is not duplicated resulting in only single occurrence of data being shown. * Values are atomic * Each row and column are unique * Column values are of the same

  1. Computing Project

    and password 'Admin662' 'Xaverian' Username and Password Saved As expected 2 Username and Password Form Username and Password fields left blank 'No Username' 'No Password' Error message should pop up As expected 3 Login Form When an authorised user logs on 'Admin662' 'Xaverian' Main menu should open up As expected

  2. Form and Function In Design Technology

    were characterized by the fact that operating instructions were made-to-order for the specific task for which the computer was to be used. Each computer had a different binary-coded program called a machine language that told it how to operate. This made the computer difficult to program and limited its versatility and speed.

  1. System I designed in order to produce a promotion package for her newly formed ...

    of CD's left in stock and the Title is in ascending order, which is easier for the user to find the CD that they are specifically looking for. Design Structure 2 This is a good database design structure because it has two extra fields.

  2. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    After this the orders will be delivered the same as before via the standard postal service. Before I break this interview down into simple objectives I will first find out what computer system and software Mr Hull has. Because he is also a freelance creative designer I presume that he

  1. AS ICT Corsework - Mr Brookes K-Fit Ltd

    The opening hours will no longer apply for orders so it will be possible to take orders through the night ready to be processed the following day. The end user has minimal effort therefore the option of ordering via the website will be much more appealing.

  2. Future Developments in ICT

    This high level of parallelism allows many calculations to be performed at once, dramatically increasing computational throughput: A 30-qubit quantum computer would equal the processing power of a conventional computer that could run at 10 teraflops.

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