• 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
  31. 31
    31
  32. 32
    32
  33. 33
    33
  34. 34
    34
  35. 35
    35
  36. 36
    36
  • Level: GCSE
  • Subject: ICT
  • Word count: 3469

Producing documents for a company. Spreadsheet, Invoice and Website.

Extracts from this document...

Introduction

19 April Spreadsheet Coursework [Type the document subtitle] [Pick the date] Write up Identify Royal optical are based on 80 Fire roads Birmingham since 1998.the companies main function is to sell eye care products and eye surgeries and provide eye tests. The company is steady growing and we have around 100-200 employees. Our current head office is based in Birmingham city centre, our target group is adults and pensioners as well as workers. Our business is on local level because it is hard compete on the national level, and our small business compared to national level businesses. My company has been growing from a very small company with only few services and few employees and all the company's documentation has been done by hand and its product lists and statics and all calculation had also been done by hand. The company had a very successfully business in more than 3 years and we have started to grow. Our services have increased in counts and we have started to employee many more employees. Our business has been growing in all aspects. I have been asked to do spreadsheet to royal optical by the manager Mr Glasses, My company's problems are that documents are not up date and needs to be redone. Because of new services and new directions such as eye surgeries and new products, as well as new employee. Because of the company's new services and direction, the company had a replacement (bigger facilities) to keep on with the demand. The manager has decided to give the company a new start( relaunch). The companies' manager and the employees is the real user and it is he who ordered to update and redo most of the documents. The estimated time I got to get this project finished is approximately 4-7 weeks. Statement of the current problems "The company is currently facing difficulties with doing invoices to current customers. ...read more.

Middle

It must include logo It must include company name It must include information about the receiver and date and invoice specification Comparison When I compared the different solution to this project a looked at how well they meet the User Requirements and the Disadvantages to that certain application. I also compared this in the tables above and it was obvious that the spreadsheet was the best solution. It did cover all the user requirements and it had many advantages and few disadvantages. The spreadsheet was far better than all other solutions. And I have chosen to apply spreadsheet as the solution to the company's problems. This system is used by hundreds of companies to keep calculations and make invoices, and it's secure. This gives me a further reason to apply the spreadsheet as a solution to the company's problems. ANALYSE Hardware: * Intel(r) Viiv(tm) Core(tm) 2 Duo E6320 Processor (2,6 GHz,1,700MHz,32MB cache) * Genuine Windows Vista(tm) Home Premium - English * 2048MB 667MHz Dual Channel DDR2 SDRAM [2x1024] * HP(tm) 24" Black Wide Flat Panel (E207WFP) * 500GB Serial ATA RAID 0 Stripe [2x160GB 7200rpm drives with DataBurst(tm) cache] * 16X DVD+/-RW Drive * 256MB nVidia(tm) GeForce 8600GTS graphics card * Printer * Ink (colures) * Keyboard-mouse This high performance workstation has the ability to design, edit and make the DTP with ease. The Computer contains the new Intel Core 2 Duo technology which acts as 2 processors which will allow the computer to maintain many programs and applications without being under hardly any strain. To backup this high performance technology it comes with Windows Vista Home Premium. It also comes with 2 Gigabytes (2048Mb) of memory. This will allow the computer to run many programs/applications without struggling. The 500GB Hard Drive will allow the company to store a lot of information and many other types of files such as movies, music and photos. ...read more.

Conclusion

2.my discount in Cell E36 is too small , my current discount is 10%.I want to change it to 15%. I will high light Cell E36 and change the formula from (=IF(ISBLANK(E35),"",IF(E35>120,E35*0.1,)) ) to =IF(ISBLANK(E35),"",IF(E35>120,E35*0.15,)) Evaluation Objectives Achieved Justification * It must have colour and text The finished invoice has colours and it has text as well * It must be user-friendly The finished invoice uses many different features that makes it user friendly such as Vlook up's , Lists , and automatic cell options. The finished invoice has also a price and product lists * Products and services for sale must be found easily The finished invoice has a price and product lists which is easy to use. * It must use Vlook up(s) The finished invoice a use Vlook up in 3 different cells, these Cells also uses IF functions. * It must include logo The Invoice Has the company logo in colour at the top of the invoice * It must include company name The Invoice Has the company name in colour at the top of the invoice * include information about the receiver and so on The invoice has a text box with information about the receiver * Do mathematical operations The finished invoice does all of the mathematical operation required . User Feedback Dear database Designer, I am very impressed with the Invoice you have designed for My Company at Fire roads Birmingham. I am very ecstatic that you were able to get all our product details in so easily and I'm so happy that it is so easy to use it will be very easy to update it. I will bring in great revenue.. However I found that some of the information you have put into the Invoice is quite un necessary so I would like to see less information that is useless. Please could you fix these problems and give me the updated Invoice, and I hope I will be able to successfully use it. Everything else on the Invoice is absolutely fabulous. Thank You Mr Carrot . ?? ?? ?? ?? 2 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Marked by a teacher

    Planning- design a memo, letter and webpage for Capital FM.

    4 star(s)

    There will be two buttons and one will link to the memo and one to the homepage. * All the end user needs to do is click one of the buttons and it will open the document selected. * There also must be a picture of the document it is opening next to the button.

  2. Marked by a teacher

    Evaluation of my ICT Database, Spreadsheet and Newsletter

    3 star(s)

    The searches would be very useful to a working company as it would be much quicker to fin d a holiday to a certain specification. I also did advanced search to find specific words to do with my holiday. Reports My report was organised into the type of country, then the destination.

  1. Different types of technology How I use ICT at home and at school

    Touch screen adds interactivity to games, something not done before wide scale * Has many different purposes not related to just gaming * Allows you connect to the internet via WiFi * Used for social activities as well as personal entertainment i.e.

  2. Evaluation of my website creation project

    I felt it would be more appropriate to appeal to a wider audience by including two aircraft that were very different. This would then, hopefully appeal to more people. I still included 5 facts about the aircraft such as capacity and weight.

  1. GCSE Excel Project ICT

    After =G4+G7+G10+G13+G16+G19 has been inserted the sheet should look like this: This sheet is completed in the context of construction, bar the insertion of a button to the final invoice page and naming cell range A3:G19, 'FinalTBL'. The final table looks like this: On sheet7, the only thing that is

  2. GCSE Calculator Project

    6. It will be able have to be able to be simple to understand. 7. To insert a maximise button. 8. Change the font colour because some people are colour blind. 9. To make the calculator easy to read. Analysis Hardware The hardware that I will use is a computer monitor, mouse and a keyboard to input the information.

  1. Explain the difference between primary and secondary sources of data, with examples.

    No interviewer bias is involved because there is no interviewer present. The only person there could be there would be the person handing out the questionnaire. Analysing the results on a large scale might be very time consuming and could be out of date when the results are ready.

  2. ICT PROJECT

    Uncheck the gridlines, row and column headings, sheet tabs, scroll bars Uncheck the formula bar and status bar and click ok Select A1 'mcrAuto_Close' Click tool, options Uncheck the gridlines, row and column headings, sheet tabs, scroll bars Uncheck the formula bar and status bar and click ok Select A1

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