• 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. Peer reviewed

    information systems assignment 2

    4 star(s)

    and analyzed to find different patterns, relationships and correlations between statistical information. Using computers to access databases it is easier to collect information and data which can then be analysed systematically, this uses advanced techniques to search for relationships. Solutions are then found to certain problems which occur.

  2. Computing Project

    Loans Overdue Form - I will test whether the button for retrieving the list of all the overdue loans works and whether this can be printed. Testing Form Description of test Test Data Used Expected outcome Actual Outcome Page of Report 1 Username and Password Form Setting up a username

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

  2. Smart Card System

    This last option can be particularly useful if the programmer want to achieve a greater understanding of the byte codes used by the Java interpreter. 5.2.5 Header File Generator Because Java is a new language and must fit in a world dominated by C and C++, included in Java is

  1. With diagrams compare and contrast the relative advantages and disadvantages of digital transmission over ...

    Coax has two conductors: an outer braided cylindrical one surrounding an inner solid or stranded core. The two conductors that are separated by a dielectrics, insulating material and the cable has an outer protective sheath. This construction is electrically designed to minimize signal interference and attenuation, and in this regard coax is far superior to twisted pair.

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

    I rejected my second data file because if the user used AND, OR or LIKE I their search, there would be a big list say if the user chose to search by Walsall or Tottenham so it would take longer for the user to access a specific customers data.

  1. Computing Project

    be careful and keep the laptop besides him at all times or lock it in a glove compartment. When the instructor goes home he can either take it with him and store it at home carefully or leave it at the office in a safe place.

  2. Describe the functions of each section within the shops and Head Office, paying particular ...

    by barcode scanner * numerical code keyed in using a keypad * quantity keyed in by till operator * credit card yes/no keyed in The processing and calculations required * look up item in computer * display item name and price on screen * multiply price by quantity * if

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