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

    * The homepage must have the same house style as the other documents * This will be a lot quicker and simpler as you just use the one document to open all the other related documents. Alternative Possible Solutions A non ICT solution for the letter is that you could

  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

    As you can see, the addition in the formula states a specific sheet and cell (a cell on sheet1). This is to prevent confusion within the formula with the cell B16 on the current sheet (sheet7). With this addition in place, the sheet should look like this: Printouts of each report, with screenshots of each worksheet and showing formulas used.

  1. 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.

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

    The results depend on how skilful the interviewer is. The interviewer can be very bias the three main problems are that the interviewer can often give clues like frowning that could influence them. The interviewer could follow up information they believe is more relevant. Or if there was more than one interviewer than it could mean that there was more than one bias.

  1. Design an advertisement or a web site for the cinema. Your advertisement or web ...

    a block of text, or the review and a graphic into a table with two cells, giving a simple and easy reading review page. Data needed by the system The data needed by the Web page system, will be information such as film times, ticket prices, certificates of films, and corresponding pictures for the review of the film.

  2. a level ict project

    Now the table is in second normal form, as no column that is not part of the primary key is dependant on only part of the primary key. 3rd Normal Form After the reviewing the current table the vehicle name and customer name aren't dependant on the Job ID.

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