• 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. Creating a computer system for a video rental shop

    Customers are automatically numbered. For this reason automatic incrementation is used. This form will be accessed from the editing form, which is reached from the main form. There will be a button to add customers and delete customers and also a find button.

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

    He/she looks through every card starting at the back of the box. He/she will flick through the cards at the back looking and checking if any games are overdue e.g. back yesterday or back today etc. Once that card is taken out it is then placed into an overdue box.

  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. Research for a database for a travel agents.

    The database has things like name, town, address, telephone numbers, date of birth, gender postcode and other few things. The database makes things easier and quicker now. This was done by putting queries, forms and a switchboard. Tasks To do my task I have broke the task into the following five parts: 1.

  1. Planning a system to handle school records.

    Good formatting features ? Can be used for templates ? Can sort and search data ? Large range of formulas for performing complex calculations ? Can produce graphs ? Good for large computations ? Offers good automation features ? Supports User Interface/Menu ? Relatively easy to develop and maintain ?

  2. Designing an IT system for an A level Student.

    voice conversation Digital Camera Used to take images John can take pictures on his camera, and send it to his computer USB Used to store folders, programs and files. John can backup his work on to the USB and ensures that he has more than one copy of his work

  1. In this (2b) report I am going to investigate software application, Input and Output ...

    And the disadvantages which Sainsbury found are: an external mouse requires space, making it nearly impossible to use on an airplane. A mechanical mouse needs to be cleaned regularly or it will get clogged with lint and dust. The cord on most mice can get hung up and drag, making the mouse difficult to use.

  2. mail merge

    Software The first software I will be using the software Microsoft access and the facility I will be using is called mail merge. I will be putting in all the information and also filtering, the next software I will use is called Microsoft word to write down my report and

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