• 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

    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.

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

    Not only am I skipping sleep but also to do something pointless. Summary of advantages * Newer models are physically adapted to be more comfortable and efficient * Portable * Allows you to play all types of games * Educational in some purposes * Entertaining to all age groups *

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

    People can often change their mind on a topic once the interview has started and they may change their behaviour. Sometimes people ask questions back. the interviewer must not answer the questions as it can change peoples minds or opinions on a subject.


    I can also monitor that the macro doesn't work just for one value and then not another. The last test I will do is to let my user use the new system, by doing this it will help to see if I have achieved the user requirement and also whether the objective of the system has been met.

  1. GCSE Calculator Project

    I will also need to purchase something which I can save my work on to and also which is easy to transfer. For this I will be purchasing a memory stick. To check that the calculator is working, I will do the same calculations on another calculator just to check that everything is working properly.

  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. Database design.

    that is used in this database is to show each of the single databases in tabular form; Table Entity Types Description Data type Length Key Validation Input Masks Combo box Costumer_ID Unique number Number 6 Primary No Customer_First_Name Customers first name.

  2. Database Analysis and Database Design Project - DVD library for moving images.

    from the system > Add new customer This user requirement has been met by creating a form on the main menu called new customer, this form will allow the user to enter the information of new customers and the information is then store into the system on the members table.

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