• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  30. 30
    30

Introduction to spreadsheets

Extracts from this document...

Introduction

Introduction to spreadsheets For my spreadsheets I am going to make a spreadsheet program that can keep and work out what is in stock and help Mr. Smith put stock on offer to pull in more customers. User requirements Mr. Smith is an owner of a small Pc shop based in Woolwich town center. He has a lot of stock going in but not much going out so he wanted to put stock on offer but does not no how to do this. He wants a program that can keep records of all of his stock and automatically put it on offer. A way to look at the spec of the products. He also wants and checkout on this program to offer his customers a new way of payment. I am going to make a program for Mr. Smith that can keep a record of his stock and help work out what stock o put on offer, a new checkout system will also be made. I am going to use some of the flowing controls o help build my program * Logic formulas/formulas * Marcos * List boxes, command buttons, ECT. This is a screenshot of the main menu of the shop computer. It is basic and easy to use. Main Menu What I used on the main menu? * Marcos * Buttons * VB code * Word art The buttons I have made here wete with the control tool box. I then added Marcos to make them change work sheets. How I made the Marco - I went on the forms by right clicking on the on the tool bar and clicking on forms. I then clicked on the button and lay it out on the worksheet, the Marco popup come up select the Marco you have made then button then click ok which will make that button act when ever you click that button. ...read more.

Middle

It did show me to the different CPUs that we have. 3 Hard disk - Button Clicking on the button To see if it shows the Hard disks that we have. It did show me to the different Hard disks that we have. 4 3d FX card - Button Clicking on the button To see if it shows the 3d FX card s that we have. It did show me to the different 3d FX card s that we have. 5 Soundcard - Button Clicking on the button To see if it shows the Soundcard s that we have. It did show me to the different Soundcards that we have. 6 Cases - Button Clicking on the button To see if it shows the Cases that we have. It did show me to the different Cases that we have. 7 Text box After clicking the button the text in the textbox will change to the different products The text was not showing the first time but it was a typo. After that text box was working fine. 8 Images box After clicking the button the image in the image box will change to the different products The images were showing but when I mover them the images were not coming up this is because the images are no longer there. Once I put them back they were working again. 9 Main Menu - Button Clicking on the button To see if it takes me to the Main Menu page. It did take me to Main Menu page. 10 Checkouts - Button Clicking on the button It did take me to checkouts page. Test No. Purpose of test Method of testing and test data Expected result of test and result Testing the formulas and macros on the entry spread sheet Checkouts:- 1 Main Menu - Button Clicking on the button To see if it takes me to the Main Menu page. ...read more.

Conclusion

In order to use this fetcher the customer has to be a member of the listed online banks other wise run the transaction through the old way. Once the online transaction has been complete click on the send button and the money will be sent to your account. (See image above) Once you have click on the send and got the conformation message you now may click on to the main menu button (See image below) Once back on the main menu click on Sales/stock button this will load up the sales and stock figures. (See image below) Once the Sales\Stock page has loaded you will be able to see all the products that are in stock. You will be able to add in stock and see products that should be on offer. This is done by do a few steps and a bit of information that you will need to enter. Step 1 - You will need to get a product that is not already on the program. Step 2 - You now have to enter the name of the product Step 3 - Now enter the total amount that was sent to the warehouse Step 4 - Enter the amount that was sent to your store Step 5 - Enter the price that the product is being sold at Step 6 - You do not need to enter any think on the offer price cell the computer will do it for you Step 7 - Enter how much of the product you have sold since the last stock check Step 8 - The rest of the cells will be filled in by the computer With the information now on the sheet you will be able to work out if the price needs to be changed or the product needs to be put on offer. (See image below) The image below shows the formulas used in the stocks program it shows how the computer will calculate the prices. This is the end of the guide if you require any further help please vast are website http.\\www.stockcontroal.com ...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

    An introduction to Identity Theft

    4 star(s)

    * Spoof Letters, Telephone Calls, Faxes and Callers at your Home. These types of methods for obtaining the victims personal information are diverse in nature but will typically inform the victim that he/she has come into money via one of a number of sources, e.g.

  2. Visual basic

    wins", vbOKOnly, "The End" Timer2.Enabled = False lösch p2p = p2p + 1 Timer2.Enabled = True End If If O1.Visible = True And O5.Visible = True And O9.Visible = True Then MsgBox "Player O wins", vbOKOnly, "The End" Timer2.Enabled = False lösch p2p = p2p + 1 Timer2.Enabled = True

  1. ICT Sample Work Welcome Centre Requirements

    * Search for and display information entered automatically, so that the user does not have to keep flicking between different screens to remind themselves of prices or what they have previously entered. * Automatically calculate certain fields to save time and to reduce data input.

  2. Smart Card System

    The sequence of sending a data packet transmission is requested be an end node and controlled by the repeater. When a data packet transmission is about to occur: If an end node has a data packet ready to send, it transmits either a Request_Normal or Request_high control signal.

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

    It is also possible to buy off the shelf solutions to this product order system. These packages are complex and contain everything needed to implement straight away. These packages have been written by highly skilled individuals and have been tested and updated using the well know evolutionary model by which

  2. Computer Architecture

    SRAM does not need refreshing because it operates on the principle of moving current that is switched in one of two directions rather than a storage cell that holds a charge in place. If the computer processor can find the data it needs for its next operation in cache memory,

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

    This is what I am expecting: I am expecting that when the home page for example it loaded up the text will be positioned directly below each image with the correct text there. How I am going to test this: The way in which I will test this is by

  2. ICT Sample Work India Red

    The VAT will obviously be added as a percentage. PROCESSING REQUIREMENTS Quotation The main output requirements are quotation really, because there needs to be a paper copy as well as on screen. This will be based on the customer orders taken. The quotation will be used by the parties, "India Red" and also the customer.

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