• 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)

    The greater the interaction between the computer and the user, the greater the benefit is that can be obtained from building a quick system and letting the user play with it. Systems with little user interaction, such as batch processing or systems that mostly do calculations benefit little from prototyping.

  2. Peer reviewed

    information systems assignment 2

    4 star(s)

    The uses of a Hierarchical database are such things as a family tree, or a windows flat file system Advantages The advantages of a Hierarchical database are, * Navigation, the navigating around the database is very quick. * Easy to understand, this makes it good as it is easy to

  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. Today's competitive global business environment, understanding and managing enterprise wide information is crucial for ...

    This scheme protects the data from electromagnetic emanations. This is done by either shielding or by using a conduit. * Room shielding - is done by spraying a conductive material in the computer room. This material reduces the number of signals being transmitted, or it completely confines the signals to the computer rooms.

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

    Twisted pair can be used for analogue signalling (e.g. voice), but it is mostly used with digital signalling in computer networks. Repeaters (digital signalling) are required every 2-3 km; amplifiers (analogue signalling) every 5-6 km. The twisted pairs are commonly used for 10 Mbps Ethernet systems; 100 Mbps Ethernet is possible for distances up to 330 feet.

  2. I have been given the task to design a database for a company called ...

    customer's forename, businesses name which the customer comes from as well as the business town, postcode, contact number, email address, street and street number. * Data on the parcels destination, which will include, Destination ID, the recipient's company, address, town, county and postcode.

  1. Computing Project

    Availability (AvailableSlots, NextLessonBooked) RECORD STRUCTURE Instructor Field name Data type Size format Description AvailableSlots Date/time, Date time Shows what dates and times are available NextLessonBooked Date/time, Date time Name of student and the day, date and time of their next lesson Student Field name Data type Size/format Description Student name

  2. Future Developments in ICT

    This interesting development has a significant drawback. Simply measuring the electron spin, will change it and force it to exist as only one value, effectively transforming the million dollar quantum computer back into the standard run of the mill binary based system.

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