Design-ICT Modelling CW Essay Example for Free

Design-ICT Modelling CW EssayI do completed my analysis of the new system therefore I allow for be interviewing, observing and identifying the subroutiner requirements. In addition, the success criteria have been successfully accomplished. These steps pass on help me with the design of my new system before it is implementedWorksheets about of the system will be establish around break awaysheets. 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, euphony artists, venues, bars. They want to buy as well as lapse their personal details and forthcoming budget. This worksheet will also give the idiosyncratic costs of each item obtainable for purchase and allow calculations to be made by the spreadsheet establish on the products that are chosen.* Venue s This will intro details of all the unlike venues available that are available in different areas in London* Decorators- This will display details of all the different decorating companies available with the different designs available and at the different prices.* Caterers This will display details of all the different caterers lodge available with what food types are available.* Music Artist- This will display details of the different music artist available and the types of music they play and how much they will charge.* Drinks (Bar)- This will display details of all the different the drink the bar sells and how much they will cost.Graphs and chartsThe new system will be used to display the results of the calculations it get throughs in an easy-to-read format. This is why graphs and charts will motive to be made. They will be used to show the piece of troths in every month and the amount spent on refurbishing the venues and the bars. These will be used to give the profits made by the business every month so they know how they are progressing as a business.MacrosThe macros will be used to navigate between different worksheets can be through 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.AlgorithmsMany calculations take 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.TestingOnce 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.User certificateWhen the new spreadsheet system has been implemented, successfully tested and I am sure that it works, I will need to create a user guide that will make it easier for the staff at JJ party planners to use the new system. The user guide will include instructions on how to program certain cells with formulae for fashioning calculations and how to select items and change them according to a given budget. It will also come with a proficient guide to help with troubleshooting in case the users face technical difficulties with the system.EvaluationThe last thing I will do will be to evaluate the system by checking how it works according to my specifications.InputsThese are the inputs that need to be put into the system for it to work* Customers name, date of birth, spoken language and contact number* Venue, decorator, caterer and music artist wanted , budget* Date of bookingProcessesThe system should be able to produce the outputs by carryin g out 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.OutputsThe system should be able toproduce a number of outputs from this information* An billhook for every sale which the company keeps. This invoice should give the name of the customer, the customers 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