• 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. The aim of my project is to make the task of the allocation of ...

    All other aspects are protected. In the event of a change in billing or cost to put on a show the user must simply click on Tools | Protection | Unprotect Sheet. After this has been done it will allow the user to edit it.

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

  1. Database design for a games shop.

    This is the ideal solution for MR. Walcott's problem. Database is the fastest and most efficient option available to me. He can easily search his system by simply entering the name of the customer or the name of the game and see how long it's been loaned or who has got it.

  2. What is a computer registry?

    The maximum size of a key name is 255 characters. Collapse this tableExpand this table Folder/predefined key Description HKEY_CURRENT_USER Contains the root of the configuration information for the user who is currently logged on. The user's folders, screen colors, and Control Panel settings are stored here.

  1. Reviewing different multimedia presentations.

    This is a good feature because it enables you to contact the people who crated this Multimedia Presentation if you want to as this is an adverting Multimedia Presentation. 2. Not so good features of the multimedia product: The first not so good feature is that there are no animations

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

    To do this I followed these steps: 1) High-light the text you want to sort. 3) Click on "data" which is displayed in the top toolbar. 4) Then decide how you want your data to be sorted, either in ascending or descending order and which column you want to sort by.

  1. AQA GCSE ICT Specification B

    The database must be called 'Ducks System'. This makes the database more professional, and helps the user find it quickly on the desktop page. 3. Every button should work Having buttons that do not work would clutter the page and confuse the user.

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

    Input: This rough information is refined later in the following bullet points. * How many sheets should be there on the menu? * How many dishes should be there on the menu? * Prices for the dishes. * Picture to make it look attractive.

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