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

    The metropolitan police report an incidence of members of the homeless community being paid upwards of �5 per useful document obtained by bin raiding. * Obtaining your useful documents The criminal can obtain the victims documents via burglary, by

  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 means no switch or light is active. The first line of inputs for this study will always be A4,A3,A2,A1 The second line of inputs for this study will always be B4,B3,B2,B1 these two numbers will be added together Then it is a long underscore followed by Carrys C3,C2,C1 directly

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

    the correct data which should be displayed. Once the query has run it comes out will the following result which when checked with the data sheets shows that the results are correct and the query works. To see if the query still worked when I typed in only 'Gemm' the results were the same as before.

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

    I expect that each of my selected browsers will load my website fine and all images and text will load correctly. Test One - Hyperlinks This is what I am testing: Do the product links on the website all work correctly.

  2. ICT Sample Work Welcome Centre Requirements

    The solution for this task will need to meet Tony's requirements. IDENTIFICATION OF THE USER(S) The users of this solution will be the Tony Williams (the client), as well as Anita Fox and Chris Ruck. Anita and Chris are also responsible for entering details of customer bookings into the diary, and producing quotations and invoices for them.

  1. ICT Sample Work India Red

    Calculation (Unique) Quotation No. (Last quotation number +1) Date Calculation (Present Date) Quotation Date = Present/Today's Date Lookup previous order and current order from different forms. Lookup customer details, food details from previously stored orders and redisplay the found data on new even data entry form. Automatic calculation of prices.

  2. Unit 6 - Advanced Spreadsheet Skills

    The charts and graphs must be fit for purpose with the correct titles and axis used, it must be consistent with the company colours and theme.. This department employs 5 staff members. 2.6 Sales/Call Centre: This department has been created recently to deal with the increase in sales they deal

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