• 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. Infernowear is a new company run by a self-employed creative designer aiming to producing ...

    On my system there are way to many text fields to list each individual test result here. I will show an example of one of these tests below so you can see the result. The test below tests to see whether a letter can be entered into a numerical text box.

  2. Computer Architecture

    Clock Rate The clock rate is the speed at which a processor clock oscillates constantly from a one to a zero, this is measured in hertz. The clock rates speed is determined by an oscillator crystal and amplifier circuit inside a clock generator circuit.

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

    factory for the business but I need something to support the business rather than our current phone call ordering services as that would drain a lot of time and money due to the larger number of employee's needed. Ben Allington - Well there is a number of solutions that face

  2. ICT Sample Work Welcome Centre Requirements

    He is also very hands-on in his role, and he will support his staff with serving and room set-up when required. There are several other employees. Chris Ruck is the Assistant Manager of the complex, who takes bookings, sets up for conferences, and also types up quotations and invoices.

  1. ICT Sample Work India Red

    The cost is minimised because there is no need for any extra software. The navigation, formatting and actual interface will be easy to make. SECTION 2: TESTING FOR WELCOME CENTRE Test Data - Add Quotation Screen Field/ Validation Normal Data Extreme Data (if applicable)

  2. Unit 6 - Advanced Spreadsheet Skills

    The have to keep in contact with the buying department to inform them what produce is available and in return the department will provide a delivery date for the products to be collected. 4. Customers: The customers were originally mainly locals however it has grown to encompass primary schools, care homes, local shops and supermarkets in the area.

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