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

Specification for an ICT system for a DJ

Extracts from this document...

Introduction

Let me introduce you to a DJ company based in Walsall, West Midlands. The DJ company is called B-Loud Entertainments and has provided a service of musical entertainment for many years. The Company has several arms to the corporation. 1. We offer a service of a full Dj setup upon which the DJ will play and mix the music. 2. We also hire out equipment for personal parties for people who wish to operate the equipment themselves. 3. We also offer dancing performers and various instruments players. 4. We also have a full team of electrical engineers who repair and service DJ equipment. The manager of the DJ set up section is having problems keeping track of all the bookings he has received with the current paper based system. This has resulted in the DJ turning up late for bookings and has lost the company a lot of business. The business cannot function efficiently until this problem has been solved. He has approached the I.T specialists of the business to provide an effective solution to record all the bookings and relevant details to that booking. The manager of the DJ setup wants an automated invoice procedure. Details of the booking must be easily retrievable to enable discussion between DJ and customer. Payment terms will need to be worked out with accuracy and must take in account any discounts. ...read more.

Middle

Limitations and constrains With many systems there will always be limitations and it is vital that these are identified in order to create a suitable spreadsheet for this project. Software limitations might occur when compared to the paper based system- * Information concerning customers within the spreadsheet could get lost if the computer system goes down and recent data isn't backed up, * Paper based systems are quicker to access whereas with the spreadsheet system you have to log onto the computer. Apart from this there are no other major software limitations. Hardware A standard computer is made up of several different components. There are many components which operate in order to provide input, processing and output information. The main hardware which will be used in conjunction with my spreadsheet system are as following- * Keyboard * Mouse * Printer * Monitor End user requirements * The system has to be user friendly and be able to input data efficiently * There has to be a macro button which allows a printout of the invoice * The solution should be created on Microsoft excel * For each booking the system should show: Date of booking Venue of the booking Proposed deposit and payment, also should indicate whether the deposit has been paid Name and general details of customer. * The new system should require only basic I.T skills and users should be able to learn how to use it quickly. ...read more.

Conclusion

Apart from this there are no other major software limitations. Hardware A standard computer is made up of several different components. There are many components which operate in order to provide input, processing and output information. The main hardware which will be used in conjunction with my spreadsheet system are as following- * Keyboard * Mouse * Printer * Monitor The Solution The Main Tasks To design this system accurately and efficiently I have divided the task into smaller more manageable sub-tasks. These sub tasks include: * Create a list of the DJ equipment alongside price for each piece of equipment. * Create a form type spreadsheet in which the details for each booking will be entered. * A separate spreadsheet should list the personal and relevant details of each client so that information on the customer can be retrieved easily. * A main menu will be created from which the user can easily navigate and access the system. * The system will need to be protected so that data can be viewed and changed by certain users only. This means that certain cells will need to be locked so that the data within them cannot be edited by unauthorised personnel. * The system will need to be as automated as possible so that the user can use the system easily. To achieve this macros will have to be included in order to crate shortcuts to produce outputs e.g printouts and invoices. ...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. GCSE Excel Project ICT

    Proposed solution The software I am going to use, to solve the issues stated prior, is going to be Microsoft Excel as it has an easy spreadsheet format, where data can be entered and manipulated to your will. The system will be based on a multipage form, which is linked from the main page, which contains the customer's choices.

  2. a level ict project

    A Graphical User Interface (GUI) would be most preferable; windows will contain information relevant to one particular task, enabling the user to multi task with numerous different windows simultaneously. Icons (pictures) will symbolise commands, for example, clicking on one may bring up a customer data entry form.

  1. Spreadsheet Project - computer system for a video hire shop.

    When I set up the monthly income sheet, I needed the formulae to calculate total income for each transaction type. This involved using the formulae SUMIF. I needed to look at the Help section on Excel several times before I perfected the formulae.

  2. System requirements analysis

    (=CONCATENATE (C1019, D1019)]. 8 Appointments page: protection sheet/ locked and unlocked cells. You cannot alter data on booking software Says that you cannot modify the worksheet, it is protected and is therefore read-only pass 4.2 Test feedback and actions required (A02.29) * Where our system has failed a test, you should explain in

  1. Creating a computer system for a video rental shop

    This will help to prevent data entry errors or syntax errors and acts as a form of validation. Safety Back up recommendations To insure the safety of the database I would suggest daily back ups are made so that if the system for some reason looses its integrity, the company will have a recent back up to fall back on.

  2. The impact of ICT on a person with special/particular needs

    She can give them face-to-face progress on how she's doing and how she's coping with everything and any problems she's facing. This is not just very important to her family but also gives an emotional protection and reinforcement to Sarah as she cannot actually travel and see her family or friends much.

  1. Creating a computer system.

    > The user will click on a button to enter customer details. A form will appear and when the customer enters their details, they will be added in the invoice. > If the customer is a current customer, then they will enter their ID into the form and when they

  2. Design specification for an IT system for Harry's Dog Kennel business.

    , a spreadsheet software (Excel) and Word .A search engine for carrying out research .A security network. Success criteria The success criteria is what is needed for a successful solution: * Must include a range of software features including : * Data Integration across and/or within different software applications *

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