• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  23. 23
  24. 24
  25. 25
  26. 26
  27. 27
  28. 28
  29. 29
  30. 30
  31. 31
  32. 32
  33. 33
  34. 34
  35. 35
  36. 36
  • Level: GCSE
  • Subject: ICT
  • Word count: 3469

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

Extracts from this document...


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.


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.


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

    For example, computers are addictive but are less distractive as you can seclude yourself from them if you don't want to be distracted from doing something. While you can seclude yourself from a DS, the ability to just take it out and play it anywhere can become tempting and make you stop what you're doing and play the DS instead.

  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 Database Project ICT

    First, we go into design view, which is documented prior, and you will be returned with a screen like this: We then change the height of the boxes to make them uniform: In addition, the width of the boxes covers the page so they should be shortened to look aesthetically


    Testing Plan Opening the system Test and data used Purpose for test Expected Result Results after testing 1. Open system and enter correct password To see if system accepts correct password Should allow user to access the system 2. Open system and enter incorrect password To see if system denies incorrect password Should not allow access 3.

  1. GCSE Excel Project ICT

    appears around the cell which is referenced to in =IF(D4>0,VLOOKUP($D$4,Shells,2),""). In addition, whenever a reference (usually a cell reference) is preceded by '$' signs, it means that the cell encapsulated within them is locked and if the figure or the formula is moved the reference cell remains the same.

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

    Agree Strongly Agree Neither Agree or Disagree Disagree Strongly Disagree Advantages of questionnaires Disadvantages of questionnaire Cheap and quick to conduct compared to other methods. Does not take so long because Fixed response questions mean that answers can be quickly and accurately analysed on the computer.

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