• 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

In the spreadsheet I am going to design I am going to use the following 'Source Data'. The data to go into the catalogue has been supplied by the company.

Extracts from this document...


Design Plan In the spreadsheet I am going to design I am going to use the following 'Source Data'. The data to go into the catalogue has been supplied by the company. The data to be used is written below: The information in the table will be displayed on four different spreadsheets but they will be used in different contexts. On one of the screens it will be displayed as it is above, as a simple list of options. On other screens it will be used as a form of stock control, an order form and as a list on an invoice. Another function that I will use on some of my spreadsheets is the AutoSum. This will be used to add up the price of all of the items odered on the Order form. In the workbook I am going to create I will use macros to make the user interaction to a minimal. This means that there is less chance of human error in the calculations that have to be done and that it is easier for the operator to use. All of the macros will be controlled by the buttons that they will be attached to. The only button that will create an 'hard copy' output will be the Print Invoive button. ...read more.


When I started to employ the idea of using forms I came across a problem. The program would not run the macro for the data entry form. I overcame this problem by not selecting the header of the page. This allowed the macro to run. Stock Chart: as instructed I have included a chart that is linked to the stock levels. The columns of the chart adjust according to the values on the stock worksheet. (See example on Appendix 3) The Link Between The Chart And Sheet: for the example of the linked stock graph see Appendix 3. Functions used: in this spreadsheet I use the following functions that are supported: Function Purpose Data Protection This is used to stop unauthorised people accessing and changing any of the prices on the Catalogue worksheet VLOOKUP This is used to import information from one worksheet to another. f function This is used in conjunction with the VLOOKUP so that information is only imported if criteria are met. Macro's These are used to make the program as easy to use as possible. They are used to complete the order and move from page to page. Buttons These are used to initiate the macros. ...read more.


M12 �7.25 1 �7.25 Mitre Elite football (Size 5) M11 �7.25 1 �7.25 Mitre Futebol de Salao M03 �13.00 1 �13.00 Mitre indoor M16 �11.50 1 �11.50 Mitre Indoor 18 M04 �11.50 1 �11.50 Mitre Lite Soccer skill ball M06 �10.50 1 �10.50 Mitre multiplex M17 �21.00 1 �21.00 Mitre Soft touch football M18 �2.95 1 �2.95 Mitre supernova M14 �5.50 1 �5.50 Mitre tactic M13 �5.50 1 �5.50 Total �119.80 To Mark Hancock From GNVQ Sports Catalogue 30 Orchard Way Brook Lane Ind Estate North Bradley Westbury Wiltshire Wiltshire BA14 0SU BA14 0DJ 4. Stock Control Most of the stock in this program is automated. This includes the updating of the stock once an order is placed. Another way of seeing the company stock is to view the 'Stock Graph'. Pressing the button that is situated on the 'Home' page easily does this. This function also allows the user to easily produce a hard copy of the stock situation. The only thing that needs to be done manually is the replenishment of the stock. This is easily done by pressing the 'Replenish Stock' button. 5. Closing the Program To log off of the program simply return to the 'Home' page and use the cross button in the top right hand corner of the window. ...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. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    You enter them in the form of wage types in the basic pay (0008) infotype. * Recurring payments and deductions Recurring payments and deductions are paid or retained with fixed frequency. The system determined the payments using factors such as overtime, leave or substitutions.

  2. Form and Function In Design Technology

    Fourth Generation Computers (1971 - present) After the integrated circuits, the only place to go was down - in size, that is. Large scale integration could fit hundreds of components onto one chip this led to very large scale integration in the 1980's allowing thousands of components to be fitted

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

    order so it will satisfy all users, especially the users that only buy CDs at a certain price. Customer Information Structure 1 Design View Datasheet View Structure 2 Design View Datasheet View Structure 3 Design View Datasheet View Customer Information Structure 1 This is not the best database design structure

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

    I will use this interview method, as I will be able to extract large amounts of information from a single interview. I will not be using questioners because there is only one member of staff and I feel that interviews on the whole will be more productive.

  1. Evalutation of a Spreadsheet

    This is a big improvement to the old system. Editing the data is difficult - with the old system if any amendments need making to the data this is more difficult to do. This is because you would need to cross out the data and re-write it.

  2. Unit 6 - Advanced Spreadsheet Skills

    2.4 Research and development: This department liaise with the external consultants in order to perform there tasks theses companies are Raven Associates Business Systems analysts Ltd and the Web Development Team, TDS. The team comprises of Barry and four others.

  1. Security Issues of E-Commerce

    But how many other methods are needed to make the e-commerce transactions safe? Quite a few, they shall be explained in more detail below. The data protection act This is where information on individuals must be kept completely confidential and can only be used for the intentions it was gathered for.

  2. Firewall Protection

    computer, but many users do not set a password for their user on Windows, or set a trivial password. Older versions of Win95 had file and print sharing over NetBIOS enabled by default. On Win98, and WinMe it was disabled by default, but many technicians, when they set a home

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