• 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
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26

Produce a fully functional and well documented spreadsheet that solves a problem.

Extracts from this document...


"Online Direct Computers" ASSIGNMENT TASK For this task we were asked to produce a fully functional and well documented spreadsheet that solves a problem. A SUMMARY OF "ONLINE DIRECT COMPUTERS" The company sells to small corner shops in the east midlands. All the sales to shops are currently recorded on an order form that will be processed in the company's main office. They use calculators to find out the total cost. They have a total of four company reps that they use to deliver orders and take new orders if required. Each of the rep carries a number of documents including order forms and a catalogue including a price list. The current system used to take orders can no longer handle the increasing quantity of trade and a new system is required. The company decided to solve this problem by giving each rep a laptop computer. A package will be installed into the laptops to process the data. The company will require the following features in the package: * An automated order form to replace the current one. * A database containing each item of stock. * A facility to update the sales sheet. * A summary sheet to raise the stock order from the warehouse so they can be delivered on the next round. * A total sales sheet so it is possible to view any commission earned by the rep. * A home page that can be used to navigate to the other pages. * An option to print so there is hard evidence of the documents. CURRENT METHODS USED * All of the sales to the shops are manually recorded on an order form that is processed in the main office. * The reps use calculators to calculate the costs. * The reps carry catalogues containing all the products available along with price lists. * The order forms are separate sheets. ...read more.


I will test: * Product information * Customer details * Sales representative names Invalid Data Testing-I will deliberately input some invalid data into some of the cells to see whether the error messages, that I created, appear. Specification test- I will compare my original specification to with my finished package. This will tell me whether the package will be able to do the job the user requires. Continuous Testing PAGE FUNCTION TEST OUTCOME PASS/FAIL Front Page Order Form Click on button Brings up Order Form Front Page Customer Details Click on button Brings up Customer Details Front Page Stock list Click on button Brings up Stock list Front Page Save Click on button Saves spreadsheet Order form Sales person drop down list Select name from list Shows name in cell Order form Main Menu Click on button Goes back to main menu Order form Refresh Click on button Resets the page Order form Save Click on button Saves spreadsheet Order form Print order form Click on button Prints order form Order form Stock code Enter stock code Shows details in order form Order form Company name Type in company name Shows Details for that company Customer Details Main Menu Click on button Goes back to main menu Stock List Main Menu Click on button Goes back to main menu Testing Data Cell Ref Input/output Test Data Manual Calc. Check Order form 20A Stock code 1000 20B Description Network card 20C Stock and Model No 3c 509B Combo ISA 20D Price 35 20E Quantity 2 20F Cost + VAT 94 20A Stock code 1001 20B Description Network card 20C Stock and Model No 3c 905TX PCI 20D Price 35 20E Quantity 2 20F Cost + VAT 82.25 20A Stock code 1002 20B Description Network card 20C Stock and Model No 3C 900 TPO PCI 20D Price 25 20E Quantity 2 20F Cost + VAT 58.75 20A Stock code 1003 20B Description Network card 20C Stock and Model No DE 220 PCT COMBO 20D Price 8 ...read more.


If letters are typed in by accident an error message with appear. Specification Test Original Specification Comments Target Met Front Page This sheet will link up with the rest of the sheets in the spreadsheet so users can search it easily. I have created a front page that links up all of the pages in the database. Order form This sheet will be used when customers want to order products from the company. Information to go into the order form will include: * Date of order * Time of order * Sales persons name * Customer name and Address * Customer contact numbers * Name of product * Description * Price * Stock number * Quantity * Total cost Date and time of order have been added into order form using the formula =NOW() The sales person names have been inserted into a drop down list that can be selected. There is space in a box at the top of the form for the customer name. This automatically there address and contact numbers. There is a box on the order form for stock codes to be typed in. This automatically brings up details including a total cost. Print out form This sheet will be identical to the order form and will show what the customers have ordered. There will be a print option so the customers have a receipt for what they have bought. I have included an option on the order form to print so customers will have a receipt of what they have bought. Stock and price list This sheet will show all the products available from the company along with a price list I have produced a list of all the products available from online direct computers Address Sheet This will include contact details for all the customers I have produced a list of all the customers and there contact details. Examples of the sheets Montsaye College AVCE ICT Unit Three Spreadsheet Assignment __________________________________________________________________________ __________________________________________________________________________ Chris Blundell 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 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. Smart Card System

    There is still one DLL on top, but there is another layer below, and a standard service provider interface, both of which add flexibility. WinSock 2 adopts the Windows Open Systems Architecture (WOSA) model, which separates the API from the protocol service provider.

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

    I followed the wizard and created four database design structures. I also explained and criticised each one. I then chose the best database design structure that I thought was most suitable to the task. Finally I printed all the structures on a Lexmark Z31 color jetprinter.

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

    Shop Information Required * Product bar code or numerical code if bar code unreadable * Quantity bought * If sale is to be paid by credit card * If paying by cash the Amount to be tendered From where this is obtained and how it is captured * product code

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

    improvements are made to solve pervious problem which have been discovered by the vast array of users. These improvements are released in the form of updates and patches. Because this type of package has a very high reliability and a wide tried and tested audience, it would make sense to

  1. Evalutation of a Spreadsheet

    This would make it much easier to analyse the phone sales. The minimum, maximum, average are also useful features you can use within a spreadsheet to calculate the minimum sales, maximum sales, and average sales. This can be useful because it will give the manager a clear image of weak sales and maximum sales.

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

    mistakes Test Six - Do the Pages Load Up Within 5s I am testing the loading time of the pages on my website. I am going to test a number of pages and time how long it takes for them to load.

  1. Explain the different techniques of gathering information to answer an IT Technical problem or ...

    if not then you could research the error code then find out how it may be resolved. Certain computer messages would appear as in perhaps to tell you about an update, an error, a task which you are meant to complete for your computer system as in backups.

  2. Unit 6 - Advanced Spreadsheet Skills

    The team comprises of Barry and four others. They are also responsible for the development of new ideas and products. 2.5 Accounts and Finance This department handles all the financial aspects of the company. This includes sales, invoices and payroll. They use a mixture of both computer based and paper based systems however they wish this to be

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