• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 2402

I am going to design a spreadsheet model for a painting company which will allow them to find out how much it will cost to paint the inside of a house.

Extracts from this document...


Painting a house Choice of problem I am going to design a spreadsheet model for a painting company which will allow them to find out how much it will cost to paint the inside of a house (excluding ceilings and floors), of a certain size and with a certain colour and finish of paint and a certain amount of workers involved. This would help the person in charge to show clients the price of what they want in a quicker way. It would also help him to decide if the price is acceptable, and if not he could then just change around a few inputs immediately. Description of problem I have decided to design a spreadsheet model for a painting company because the problem that they have now is it takes a long time and mistakes are easily made when they are estimating the cost of large paint jobs with a pen and paper. Another major problem is that as the information is not stored safely it is easily lost which wastes a lot of time. My solution is going to target the task of estimating the costs of large paint jobs with a good and easy to use spreadsheet model. The spreadsheet model will contain useful information for the company. The spreadsheet model will be able to have data added and changed to it and will also be able to be printed out to help customers. ...read more.


The spreadsheet model will also enable Mr.Sheen to change any output he does not feel is reasonable by simply changing the appropriate inputs. It will merely take a few seconds, as the outputs will be connected to the inputs by formulas. The costs of developing the spreadsheet will be explained in the resources. My evaluation will be based firstly on whether it works properly, secondly that it is faster at finding the cost of painting a wall of a certain size in a certain colour and finish than the current system and thirdly whether the shop assistants and owners find it easy and efficient to use. Design of solution After carrying out my investigation and analysing the results, and seeing how information is currently collected and used, I have decided that my model will be one that when a certain length and height is entered, the area, tins of paint required, total cost and how much and how long it will take a certain amount of painters to paint the wall will all be automatically worked out. First I will design the model, then I will test it to make sure that everything is running smoothly. After that is complete I will write up user and technical documentations, which will teach the staff how to use the model. To save time for the user, my model will show the cost of five different finishes of paint at for two different makes of paint the same time. ...read more.


Now I will be describing the software that the company needs to be able to run the spreadsheet model. First they will need an operating system to be able to use the computer, but this usually comes with the computer so it does not need to be purchased. I would recommend the use of an up to date operating system such as Windows 2000 or Windows Millennium but we will be using Windows 98. Then they will obviously need Microsoft Excel to be able to make spreadsheet models. I would recommend a new version of Excel, such as Excel 2000, seeing as this has the most features and functions which can be used to enhance the spreadsheet, but this usually comes installed on the operating system. They could also have Microsoft Word if they chose so, to write up reports or other information concerning jobs, etc. Again I would recommend a new version of Word, such as Word 2000, seeing as it is the most updated version and has most new features, but again this usually comes installed on the operating system. All the hardware and software needed to make the spreadsheet will cost around �1000- �1200 but seeing as the company does not have that kind of money at the moment the computer they will be using has been loaned to them by a family member of an employee. ...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 Software 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 Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    Then press Ctrl+C or right click and press copy. Then go to you next spreadsheet. Make cell A1 active and select paste from the edit menu or click Ctrl+P. You should now have a copy of the spreadsheet layout within this spreadsheet. The next thing to do is to link the first two columns to the previous spreadsheet so

  2. Database design for a games shop.

    He can print it out the report easily. After considering everything, I have chosen Microsoft database as a solution, simply because it is the most reliable and best option available to me. This will be my system. User requirements: After having a meeting with MR.

  1. What is a computer registry?

    This key is sometimes abbreviated as "HKCR." Starting with Windows 2000, this information is stored under both the HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER keys. The HKEY_LOCAL_MACHINE\Software\Classes key contains default settings that can apply to all users on the local computer. The HKEY_CURRENT_USER\Software\Classes key contains settings that override the default settings and apply only to the interactive user.

  2. Reviewing different multimedia presentations.

    The second not so good feature is the fact that there are no sound effects at all with this Multimedia Presentation so once again it makes the Multimedia Presentation boring. The is a not so good feature as it shows a lack of effort put towards making this Multimedia Presentation

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    I chose to include test results from 3 terms; once I had inserted the test results, I decided to work out the overall percentage from the 3 tests. I knew that to calculate the overall percentage I must add the test scores up and divide by the collective amount all 3 tests were out of.

  2. AQA GCSE ICT Specification B

    This simplifies the process of creating and shipping an order. 7. Each page must display the company's logo This adds to the professional look, and helps customers recognise information. 8. The 'Sales Summary' page must display an 'Enter Two Dates' box before opening This allows a user to find all sales records between two dates.

  1. Publisher. My fathers friends name is Mr. Hussaini, as his restaurant has just opened ...

    Like putting the whole menu on an A4 Portrait. These types of menus are good for in-house use but not for outside since they are big and difficult to hold. 2. Using a single sheet of paper and printing the menu on both sides in order to save paper, but this will make the menu to complicated to understand.

  2. Database analysis of 'a video lending library'.

    Make 3 tables and reports called 'customers', 'video' and 'issue and return'. 13. Set a database password so as to make the content inside secure. Task 2: Analysis Software: There are two different database packages that are available to me.

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