• 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

    playing with friends and family with WiFi * Provides a lot of family fun * Lots of fun applications on the DSi * Camera brings a whole new aspect to the things you can do Summary of disadvantages * Games can get quite expensive * Addictive to play, especially due

  2. GCSE Excel Project ICT

    However, in the price for the Wi-Fi the nested IF covers two cells: which causes a slight change in the formula: =IF(B19="Yes",IF(E19="502.2gb","�50",IF(E19="502.2bg","�55","�0")),"") Here the main cell is the cell B19 this is where the customer wishes to choose to have Wi-Fi or not, if the cell does not contain 'Yes' then it doesn't bother continuing and returns a null value.

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

    The reason people feel how they do can be explored rather than just collecting specific information. A tape recorder can because, which means that the information can be referred back to when analysing the data. The results depend on how skilful the interviewer is.

  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. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    I then created the main page, a very simple page, as outlined in Appendix 1, or the web page research. I then, very briefly explained the ticket prices, Standard Luxury and disabled, giving prices for each. The last page I created was the Latest film reviews, where I simply entered

  2. a level ict project

    The employee ID and Job ID are primary keys which eliminate redundancies allowing records to be uniquely identified. 2nd Normal Form To get into 2nd normal form I required a 3rd table that links the entities in the employee and garage job tables.

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