• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20
  21. 21
  22. 22
  • Level: GCSE
  • Subject: ICT
  • Word count: 4549

This project involves creating a system based on a problem identified in a specific business. I have selected a video store, for which I shall produce a system to help it to organise some aspects which the business finds difficult to handle.

Extracts from this document...


Introduction IT Coursework: Project 2 This project involves creating a system based on a problem identified in a specific business. I have selected a video store, for which I shall produce a system to help it to organise some aspects which the business finds difficult to handle. My task is to choose two aspects from a variety of choices and implement the steps required to build a system for those aspects. Therefore I must collect data regarding those aspects and identify a problem with handling them manually, so that the system has a determined purpose. To produce a system, a common procedure is usually followed. They are summarised by 5 headings. The following information cover the major steps followed whilst constructing a system: * Analysis: 1. Problem identification 2. Data collection methods 3. User requirements 4. Identification of inputs, outputs and processing * Design: 1. Designs for the data structure 2. Designs for user interface 3. Designs of the output formats 4. Software and hardware requirements * Implementation: 1. Implementation of data structure 2. Implementation of input and output formats 3. Combination of software features 4. Production of a user guide * Testing: 1. Description of testing 2. Description of results * Evaluation To help me along my task, I have decided to produce a detailed plan which basically captures all the above tasks but places them in time slots to meet the time limit assigned. Plan Task Time Deliverable delivered 1. Produce a plan Week 2 1. Plan 2. Complete analysis phase: 2. Introduction identify aspects for which a system is to be made 3. Interview results do interview with the owner of the video-rental store and find Week4 1. User requirements out the necessary information(i.e. attributes, user requirements 2. Problem identification. problem identification) 3. Identification of inputs, outputs and identify input, output and processing processing. 3. Complete design phase: Week 6 1. ...read more.


However there must be a procedure to get from the inputs to the required outputs and a form in which the outputs are presented to the user so that he/she may verbally or in any other way give the information desired to the customer. The way I shall do this is by using Queries from Microsoft Access, rather than using any other software for various reasons (mentioned in the Design Phase comparing the software with other alternatives). Queries allows the user to input the information gained from the customer or any other source, select the wanted criterion and thus get final results in table form. The steps taken to get from the inputs to the outputs (i.e. using Query) is known as process. The business, alternatively, occasionally may require some information about their customers. Therefore I shall input some business queries also and get some outputs just as a means of testing the system. Data Collection Sheet Videocassette Details: Source Data Internet (www.Blockbuster.com) Title, price, theme, cast and catalogue of videocassettes other info., age rating Made up Quantity Reference number Title Price (for renting for one day) Theme Other Information Age rating Cast Quantity 1 Seabiscuit �2.00 Drama None PG Tobey Maguire, Jeff Bridges, Chris Cooper 20 2 Freaky Friday �1.50 Comedy, Fantasy Adult Situations PG Jamie Lee Curtis, Lindsay Lohan, Mark Harmon 20 3 Bad Boys 2 �2.00 Action, comedy None 15 Martin Lawrence, Will Smith, Jordi Moll� 20 4 How to deal �2.00 Comedy Drama Adult language 12 Mandy Moore, Allison Janney, Trent Ford 20 5 Anger Management �1.50 Comedy Adult humour 12 Adam Sandler, Jack Nicholson, Marisa Tomei 20 6 Charlies Angels �2.00 Action, comedy Violence 12 Cameron Diaz, Drew Barrymore, Lucy Liu 20 7 Shrek 2 �2.00 Fantasy None U Mike Myers, Julie Andrews, John Lithgow 20 8 Alien �1.50 Science fiction Graphic violence 18 Tom Skerritt, Sigourney Weaver, Yaphet Kotto 20 9 The Grinch �2.00 Comedy Adult humour PG Jim Carrey, Jeffrey Tambor, Christine Baranski 20 10 The Sixth ...read more.


A form is easier and nicer to look at. * Query: the replies to questions are displayed in a certain form. The table My table will look like a simple grid: The following are sketches of what the actual one would look like (done in Paint). Videocassettes: Customers: Forms When making a form there is a series of choices given by the form wizard leading to a final design. They are described as follows: 1. Layout * Tabular * Columnar * Datasheet * Justified Do not apply to * Pivot table * Pivot chart 2. Style: * Blends * Blueprint * Expedition * Industrial * International * Rice paper * Sandstone * Standard * Stone * Sumi Painting 3. Features: * Record navigation * Record operations * Form operations * Report operations * Application * Miscellaneous I have decided to have the same layout, style and features in both the forms so that the task is kept constant. For the designs I will just show the customer form as an example rather that showing both. 1. Choice of Layout (either tabular, columnar or datasheet): The following are sketches of what the actual one would look like (done in Paint). Columnar: Tabular: Datasheet: I have chosen columnar for the following reasons: * Columnar shows only one record at a time which is easier and nicer to look at * The other layouts are almost identical to the table so there wouldn't really be much of a difference if the other layouts were used. 2. Style: Most of the styles are either plain or have a single colour with varying textures. I do not think this would be suitable because a single colour isn't very attractive. However the style named "International" is very attractive because it shows the picture of the globe in different colours which I prefer. 3. Features: There are many features which can be placed besides the form. The table shows the features I wish to place and why: Feature IT Coursework ...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. Peer reviewed

    Using and Searching The Internet - I will be searching for help with my ...

    3 star(s)

    Which search provided the most useful information?: Bing provided the most websites, but this may mean that Google provided the most accurate results.

  2. GCSE Excel Project ICT

    The backup file, which is to be copied increases in size every time a customer saves, the file increase is approximately 200kb a time, I theory if 20 customers a day were to use it the file size will approximately be Security strategy (e.g.

  1. ICT Project - Statement of the Problem

    to problems such as over booking and bookings being lost With the restaurant expanding as fast as it is me and Mrs Elone have both agreed that that the best thing to do is create a data base system for restaurant so that data retrieval would be made be a

  2. Video Rental Shop I.T. System

    �1000-1500 is a good choice, as a very good spec computer can be purchased for well in that price range. Purchasing the computer would seem like an expensive venture, but it will certainly be for the best. Barry could get rid of some staff as he said before and also it would stop customer delays.

  1. a level ict project

    Minimal training is required to maintain and operate the system, since easy to follow wizards are supplied, which provide instructions on how to make tables, field names and their types, etc. Plus, the querying function is an essential tool when searching the database using filters, criteria can be inputted and the database will immediately provide relevant results.

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

    Lighthouse design's Quantrix is a powerful new multi-dimensional spreadsheet solution for NEXTSTEP. For enterprises driven by spreadsheets, from simple budgets to complex forecasts and financial planning' This software is not appropriate for my project as it costs a lot of money.

  1. Creating a computer system for a video rental shop

    Objectives for the New Systems Qualitative 1. Data entry should be as intuitive as possible. 2. The input screens should explain themselves. 3. Data entry should be quick. 4. The mechanics of the application chosen should not be apparent to the user. 5. A main menu should be loaded automatically when the database is loaded, and the whole system should be menu driven.

  2. ICT - Business use.

    job', which is to work out the budget and then to transfer the data to Microsoft Word to produce the reports. I think this is the most efficient way of doing this project, because it will satisfy the needs of the potential users and I'll prove it at the end.

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