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

    setting up a divert/forwarding address at the post office of all the victims post, and by requesting documentation from the credit reference agencies and government departments. * Shoulder Surfing The criminal will watch over the shoulder of the victim. Examples are watching whilst the victim is completing an application form

  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. Computer Architecture

    (0) (1) B1 B2 B3 B4 ______________ (0)(0)(1) C3 C2 C1 (1)(0)(1)(1)(0) O S4 S3 S2 S1 Example 3 Binary 1001+ 1001 ______ 1111 The following equation should look like this (0) (1) (1) (0) A1 A2 A3 A4 + (1)

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

    This computer design is such that the user uses a list box to enter in the weight therefore the use would not enter in 1.5. Length 25 is allowed as it is within the boundaries and the total dimensions are also within the boundaries.

  1. What is transaction processing?

    processing software are placed on the market, as well as the overall cost of the software and possibility of upgrading the PC. Overall on this application the advantages over weigh the disadvantages and it is felt that this program is an essential item of the business community.

  2. Smart Card System

    This may be done to reduce network traffic on each subnetwork, or to make the internetwork more manageable as a whole. 1.3 Network Protocol in LAN Most LANs connect workstations and personal computers. Each node (individual computer) in a LAN has its own CPU with which it executes programs, but

  1. ICT Sample Work Welcome Centre Requirements

    Tony sometimes has to handwrite quotations too for the same reasons. Scope The scope for this task is to find a way of entering booking details for conferences, and to create a quotation for that conference. Creating invoices will not be included in this task.

  2. ICT Sample Work India Red

    The form should have data validation and should be a GUI reduce data entry mistakes and reduce the amount of typing. * Each of the data entry should have India Red's log and in terms of the colours/interface it should have India Red's colour black background and red text.

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