• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design-ICT Modelling CW

Extracts from this document...


Design I have completed my analysis of the current system; therefore I will be interviewing, observing and identifying the user requirements. In addition, the success criteria have been successfully accomplished. These steps will help me with the design of my new system before it is implemented: Worksheets: Most of the system will be based around worksheets. Here is a list of the ones that I will produce. * Main Menu - This will be the menu giving access to all the worksheets stored in the system. * Ordering- This worksheet will be the most frequently used one because it is where customers choose the halls, the decorators, caterers, music artists, venues, bars. They want to buy as well as give their personal details and available budget. This worksheet will also give the individual costs of each item available for purchase and allow calculations to be made by the spreadsheet based on the products that are chosen. ...read more.


These will be used to give the profits made by the business every month so they know how they are progressing as a business. Macros: The macros will be used to navigate between different worksheets can be done faster if buttons are formed within every worksheet. These buttons will be the names of every worksheet so the user can click on the name of the worksheet to open it up instantly without having to open up a list of all worksheets as they will already be listed. Algorithms: Many calculations need to be made by the spreadsheet and this is only possible when formulae are programmed into cells. Formulae are needed because without them, the staff would need to make every calculation themselves which would take a lot of time. Therefore, formulae are the solution to this problem as they work out the calculations. Testing: Once the new spreadsheet system has been made and everyone is pleased with the worksheets, graphs, macros and formulae created, I will need to test my new system in order to check whether it accomplishes all the success criteria given. ...read more.


the following processes: * Search for the Venue, decorator, caterer and music artist available * Calculate total prices and recalculate when the booking is changed * Increasing the quantity of the Venue, decorator, caterer and music artist available * Collecting information and calculating the profits based on the number of sales and costs. Outputs The system should be able toproduce a number of outputs from this information: * An invoice for every sale which the company keeps. This invoice should give the name of the customer, the customer's contact number or address and the bookings made and total price of the booking sold as well as the date of the sale. * A receipt after a booking is made to give to the customer. * Graphs showing profit made at different times so my client is aware of how the business is progressing. * Reports showing models that have been newly bought venues or contract with new decorator, caterer and music artists Hierarchy Flowchart ?? ?? ?? ?? Jayprashant Jeyachandran 11R ...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. Different types of technology How I use ICT at home and at school

    Add this to the price you paid at the start to purchase the television and the amount of times it's kept on and it'll drain a lot of money. This is quite bad for me as I'm quite addicted to television and often live it on for quite a bit.

  2. Database Design Guideline

    ? ? ? Criteria: "male" "plastic surgeon/cosmetic surgery" Or: ward doctor ? "orange" o Query 6 Table Used Doctor and Patient Query Criteria I want to see how many patients a particular doctor treats, by looking at the doctor ID.

  1. Database design.

    Entity types - VIDEO STORE Unnormalised Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone (Video_name, category, cert, rental_price, date_out, date_returned, video_copies)) 1NF Remove repeating groups Customer (Customer_ID, Customer_surname, Customer_firstname, customer_street, customer_town, customer_postocde, customer_phone, Video_ID) Video (Video_ID, Video_name, Video_category, Video_cert, Video_rental_price, date_out, date_returned video_copies)

  2. Critical evaluation of my design - MillionAir.

    Computerized system. A system which is made up of computer input, and that is it, it has no manual input at all. I have used a computer to make my logo, database and documentation, more useful, authentic and more professional. In addition, my computerized system has simplified life in the office so much more for the users.

  1. AQA ICT Modelling Coursework

    * Whilst both the office and filing cabinet are locked, the company still feels that more protection the manager of each gym every night would mean that someone is always looking after the data. * There are currently no backup copies of the data, if there was a fire, all the data would be lost.

  2. Database CW

    Queries can be made to search for data meeting a certain criteria. Forms and reports can be prepared almost instantly. Files can be linked together so that if one file is updated the other files dependant on that file will also automatically be updated.

  1. System requirements analysis

    LCD's stand for liquid crystal displays and it is made up of two polarizing transparent panels and a liquid crystal surface sandwiched in between. Voltage is applied to certain areas, causing the crystal to turn dark. A light source behind the panel transmits through transparent crystals and is mostly blocked by dark crystals.

  2. a level ict project

    every week, or in special circumstances, for example, there is a significant in take of data into the system. Furthermore, the backup copy will be stored of site, so that if there's a natural disaster affecting the main site, the backup copy will remain.

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