• 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. Different ways of data capture

    *Faulty connection between hardware could mean characters are transmitted incorrectly. VERIFICATION AND VALIDATION VALIDATION CHAECK: Validation is making sure info is inputted sensibly/realistically and not necasarrily correct. USED TO DECREASE DATA ENTRY ERRORS Presence check - Certain fields must be present/filled in. Format Check - Code has a set format.

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

    Access is more usable than both Excel and Pascal and the end users will find the system easier to use as the system will save time by cutting out repetitive tasks and will give them quick access to the information they need.

  1. Security Issues of E-Commerce

    Pharming can either exploit the home user or a shabby DNS server setup; this is the most common type. Cross Site scripting is another problem that was listed above, cross site scripting involves the use of malicious code placed in to a web age and typically involves HTML coding although this isn't a stringent rule.

  2. Smart Card System

    This would allow the same software to execute without change on a heterogeneous set of devices. However, java did not become a success. Instead, it was a explosive growth of the World Wide Web and the Internet that caused the Java to receive so much attention.

  1. CP3 - Proposed Solution to a Realistic Problem - Apartment Administration software

    user is taken too is the main menu form, which will look like below. * Describe, including sketches of screen layouts, what the user/operator will see when working the system. This is the customer management form, where new customers are added, existing customers are edited or deleted.

  2. Computer Aided Design Package

    This would effectively mean making a new computer rather than upgrading it, so just constructing a new computer would be a more cost effective way of proceeding. For that reason it would be better to keep these computers for administration purposes they are currently being used for, this would allow

  1. Robot Prototype design principles.

    The problem with dismissing windows is a prime example of inconsistency in CStar. The challenge in applying the consistency principle lies in making decisions about what ``typical'' tool users will judge to be similar, and what they will judge to be different.

  2. Data Modelling & Data Structures.

    The top node is called the root node The bottom node are called leaf (Terminal nodes) and the nodes are connected by branches. Shown below is an example of a tree structure showing how a record in a employee file may have the structure shown below.

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