• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  • Level: GCSE
  • Subject: ICT
  • Word count: 3109

Simpson &Co. estate agents - designing a computer based system

Extracts from this document...

Introduction

ANALYSIS Background info. Simpson &Co. estate agents are located in Brent. They have made a publicity deal with Flancrust Enterprises, another newly formed Business. Simpson and Co. Are known for their good service to the public and want to start branches all over Brent, however they do not have a system enabling them to record ever changing details of large numbers of customers. Identify the Problem Estate Agents have to sell the right houses to the right customer. They need to know what type of house the customer wants and the features it must have. Estate Agents need to price every house and have a record of all the prices. They must be able to change the prices as they go up and down all the time. Estate agents also need to have a record of the customer's details and the type of house he/she requires. That way the estate agent can call the customer if a house with all the required features becomes available Currently Simpson & Co. is using a manual System for recording these details. They record all the customer details in one book and the details of the houses in another. The disadvantages of this system are: * There is only one copy of each book so a lot of problems will arise if it is misplaced. * Since everything is written by hand, the text could be illegible. * Once written the content of the books cannot be easily varied. * When details change, the database would be invalid * Handwriting all the details can be time consuming. * The files and books take space to store * It is difficult to find a particular piece of information without looking through all the files. * It is difficult to make copies of the files for both the estate agents and each customer. * It is difficult to have a wide range of advertising methods Using a computer would solve many of the problems above because: * A computer can store a lot of information. ...read more.

Middle

From estate agents) * What data do you keep about the customers and houses * How they are finding their current system * How they alter information * How they collect in formation * How they use data * How they advertise * How they involve customers * Do they have to restrict data Different methods could have been used to collect this information. Letters could have been written to each of the two different users. The letters could have either been formal or casual, containing a polite introduction and questions similar to the ones from the questionnaire. (Because the information required is exactly the same either way.) The letters would be mailed and the users would have to send a letter replying with their answers. An estate agent and a customer could have been interviewed. I could have actually met with them and asked them the questions and received their first answers directly. The advantages of the questionnaire * The people whom they were sent to do not have to make the effort to write a whole letter * The questions will be clear so that people can under stand it * Since gaps have been left for the answers, all of the questions are likely to have been answered * Filling in the questionnaire is the least time consuming method The disadvantages: * The questionnaire may accidentally get classed as junk mail * The users may forget to post it Advantages of a letter * It is very personalised, is unlikely to be classed as junk mail. * It can be very polite when asking for information The Disadvantages * Not all the questions may be answered * It is time consuming to write * The users may forget to post it * The questions might not seem very clear. The advantages of interviews * You can explain any questions to the people you'll be interviewing * You will get their responses to all the questions * It is easy for the ...read more.

Conclusion

* We will describe to the customer what the hardware is that we will use. * We will design two different forms and choose the more efficient one and state why it was chosen * The key features of the solution will be discussed including the advantages and the disadvantages * We will design a form mail merge letter. * We will write a test plan with a test and the expected results Implementation * We will enter data in to a database, which will be created. Any modifications will be noted down * The test plan made earlier will be carried out. * The results will be explained with screen prints as proof of testing. * Several queries will be used to find the records * We do a mail merge using the system * We will produce a report * We will write a user guide about the key features, hardware, software required and how to use the system as well as trouble shooting * The user guide will be given to someone to test the system a questionnaire will be given to him or her. * The field design will be explained and the changes made due to testing will also be discussed * The main feature of the software used to make input and output formats will be described. We will justify the changes to the formats due to testing Evaluation * The design brief will be copied and pasted. We will check that the system meets all the requirements and the needs of the users. * We will describe the methods of testing used and the results of the testing and the comments of the person who tested it. * We will explain the changes we made to the system due to the testing * We will describe the limitations and suggest any possible improvements * We will discuss the used software and how easy it was to use. 1 Amodini Palipane 8B.1 ...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. System requirements analysis

    HP Business Inkjet 2800 Printer, set-up roadmap, 4 ink cartridges [black (26 ml), colour (28 ml)], 4 print heads, getting started guide, power cord, driver CD HP Jet direct (EIO) internal print servers, HP Jet direct external print servers, HP Jet direct 802.11b wireless (EIO)

  2. Creating a computer system for a video rental shop

    Excel has disadvantages as well as advantages, these include: - * If you change the name of a page after making a macro it can't find the correct page because it has changed names. This means you then have to go into Visual Basic and manually change the name of the page on the actual piece of code.

  1. Creating a computer system.

    It is very simple to use as well. I must also comment on the approach and whether things were done efficiently. I have received feed back from my company, after giving questionnaires and observing Mr. and Mrs. Bains (see appendix).

  2. Smarts Leisure Park Database Booking System

    Process 3 - produce a report on all of the cancellations that have happened over a period of time or generally for internal use. This is the process which will show all of the cancellations in the past month or week to the manager.

  1. Database design.

    I could get my customers in order of their surnames by alphabetical order or the video ID in numeric order. In order to create a query you go to new and then highlight the simple query wizard and click ok.

  2. Database Coursework Identify the User's Needs. I have been asked to create a game ...

    Then the member takes the game away and plays it. When someone returns the game they give it to the employee/manager. He/she then searches through the green cards to find the find the matching card. Then the employee/manager removes the details of the loan by scribbling it out or by using tippex.

  1. Benefits of using my IT system in the Travel Agents.

    your screen could freeze and due to this you can lose all of your previous work. An extra advantage is that you can present your work in a more professional manner. An additional disadvantage of using a computer is that it runs through electricity and the bad thing about using

  2. Planning a system to handle school records.

    ? Can be used for templates ? Can sort data ? Can perform complex searches automatically ? Offers good automation features ? Supports User Interface/Menu ? Cannot produce graphs ? Can only perform limited calculations ? Complex to develop and maintain After comparing the different applications I could use to create a robust solution to the problem

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