• 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)(0) C3 C2 C1 (0)(1)(1)(1)(1) O S4 S3 S2 S1 Example 4 Binary 0111+ 1101 ______ 10100 The following equation should look like this (0) (1) (1) (1) A1 A2 A3 A4 + (1)

  2. What is transaction processing?

    Email The expansion of the World Wide Web and it popularity has become an essential part of the business community today. Within this area the development of electronic communication has become one of the most essential forms of sending information between staff and companies.

  1. Smart Card System

    it is also able to access data and devices anywhere on the LAN. This means that many users can share expensive devices, such as laser printers, as well as data. Users can also use the LAN to communicate with each other, by sending e-mail or engaging in chat sessions.

  2. ICT Sample Work Welcome Centre Requirements

    Creating invoices will not be included in this task. Also, to simplify the task, we will focus on commercial customers only and not charity customers, as the prices are all different. DETAILS OF CLIENT, USER(S) AND AUDIENCE (IF APPLICABLE) IDENTIFICATION OF THE CLIENT The client for this project is Tony Williams, who is the General Manager of the Welcome Centre.

  1. ICT Sample Work India Red

    What data needs to be stored? Customer Information: (Company name and address, contact details, etc) Food Menu Details: (What food, how many servings, etc,) CLIENT REQUIREMENTS After the initial first interview with Tom and identifying his main problem he currently has with orders and quotation, we established a new solution which was based on the requirements.

  2. I have been given the task of creating a system for a hospital to ...

    The speed is one of the major factors, but must create a system that does not take up vast amounts of memory. Costs: The initial starting out costs will be the machine purchase, and basic unit for it to go on (unless already owned).

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