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

GCSE ICT Coursework Booklet

Extracts from this document...


2 0 0 6 "MUSIC SHOP" SOUND ADVICE Contents Contents 2 Situation - P1 3 Problem - P1 4 Brief - P1 4 Analysis+Research-P1+P12 5 The Shop Layout: 5 Dis/Advantages of using ICT - P1 6 Dis/Advantages of using ICT - P1 7 ADVANTAGES: 7 DISADVANTAGES: 7 User requirements - P2 8 Diagram of information flow - P2 9 Specification - P2 9 Specification - P2 10 System requirements - P3 11 Hardware 11 Input devices 11 Output devices 12 Software Required 13 Training Required 14 Diagram of system links - P3 15 Social, moral + cultural issues - P7 16 Social Issues 16 Moral Issues 17 Cultural Issues 18 Identification of task subsystems - P4 19 Examples of work completed in the main applications 20 Microsoft Word 20 Microsoft Excel 21 Microsoft PowerPoint 22 Microsoft Access 23 Situation 25 Problem 25 Brief, Analysis and Research 26 1. For the DATABASE 26 2. For the SPREADSHEET 30 3. For the WEBSITE 35 4. For the Advertisement 40 Time Management Table 43 Database 45 Spreadsheet 47 Spreadsheet 48 Website 52 Mail Merged Letters 56 Advertisement 59 Supporting Work/Communications 60 Evaluation tests - TPT3 + P11 62 Negative Results 62 Effectiveness report - TPT3 + P6 + P11 63 Note Play- TPT Work Produced 64 Database 64 Correspondence 64 Spreadsheet 64 Website 64 Independent working 65 Planning 65 Additional information 65 Situation - P1 The shop is situated in West Street in the prosperous city of Chichester. The shop is situated next to Costa Coffee and Waterston's book shop. It is a busy city on the south coast. Two music shops already exist in Chichester, HMV and MVC. The name of the shop is Sound Advice(tm). It is a small independent business. The shop is small and has little colour on the front. The sign is printed in white on to a black background. The layout of the shop is simple yet effective with three aisles in the centre of the store. ...read more.


4. Create charts for quick visual analysis. Microsoft PowerPoint Website 1. Import Sound Advice logo for each web page to keep the overall look the same. 2. Select general colour scheme and design to increase visual appeal and uniformity. 3. Create necessary buttons to make the site easy to navigate. 4. Create hyperlinks between different pages to make navigation possible. Microsoft Access Customer details database 1. Create a table using Design View and select the fields for recording all the required customer details. 2. Create an easy-to-use form using the Access Wizard for entering customer details. 3. Create a customer interests table using Design View. 4. Create a Relationship to cross-reference customers and interests. 5. Design a Query using the Wizard, and run the query to find out which customers have specific interests in a certain product type. Examples of work completed in the main applications Microsoft Word 200 innocent people die as troops open fire on crowds by Sam Taylor, St. Petersburg correspondent St. Petersburg is a city in shock. It is nearly two months since Sunday 22nd January when the soldiers of the Imperial Guard opened fire on a crowd of 150,000 demonstrators, including women and children, outside Tsar Nicolas II's Winter Palace, killing 40 people. And the bloodshed didn't end there, as clashes continued throughout the day. The final death toll has been estimated at about 200 people. A wedge seems to have been driven between the tsar, once known as the Father of the Nation, and the people. The leader of the demonstrators, Father Georgi Gapon, has written "We no longer have a tsar. Today a river of blood divides him from the Russian people." Background to the Massacre Things have been going wrong in Russia for some time. One of the main problems has been the disastrous war with Japan, which has seen humiliating military defeats, the worst being the destruction of the Russian fleet in the naval battle in the Gulf of Tsushima. ...read more.


The mistakes were found and the buttons were hyperlinked to the correct page numbers. 8. The test proved that the mail merge function failed due to incorrect fields being inserted. The mistakes were found and the correct fields were inserted and the mail merge functioned correctly. Effectiveness report - TPT3 + P6 + P11 Specification Point Application Task Rating Comments 1 MS Word Mail merge letter Word was more than adequate for creating a letter in a simple style with the Note Play logo and the shop's uniform font for the mail merge letter. 2 MS Publisher Advertisement Creating the advertisement in Publisher was effective as the result was eye-catching. Whilst a package such as Quark might have introduced more complex images and colouring, it would involve more investment in staff training and might not be worthwhile. 3 MS Excel Financial Control The Excel sheet was easy to set up and the Summary sheet which included weekly round-up statistics and charts made it simple for staff to gain a quick overview of the state of the business. 4 MS Powerpoint Website The overall look of the website was good, but to produce a more professional Java-enabled website with it would have been better to use MS Frontpage or Dreamweaver. 5 MS Access Customer Details The Access database met all the requirements for storing customer contact details and their interests. It also fulfilled all the criteria for providing data for the mail merge. 6 MS Word/Paint Design Store Logo The logo design was basic and perhaps not very eye-catching or memorable to customers. It might have been better to use a package such as Quark to make a more sophisticated and colourful logo. Rating Key: = Poor = Average = Good Note Play- TPT Work Produced Database In my TPT I created a database using Microsoft Access to store the contact details and interests of customers that had registered on the website or purchased items in the shop. Access was also chosen because it can be used in conjunction with Microsoft Word for sending out letters using the mail merge function. ...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. The Advantages of Using ICT Over Manual Meethods. Using Paint and Access.

    sending them to a college you can make a pay for an expert staff to come in and teach them. The Third way is that if you have 7+ employees then you have a separate training department and do a test at the end and whoever passes the test them make them be your employees.

  2. Financial Model to help organise the year eleven prom

    have to be solved * The Task to be done (see Task to be done pg1) that concern the spreadsheet itself need to be completed How I can do this? My first chance would be to view the "problems" and "task to be done".

  1. Different types of technology How I use ICT at home and at school

    needing to get off my lazy ass or do something silly like actively participating in 'real life'. Who needs that when you have the vast internet, right? Wrong, perhaps you need a reality check and see how unattractive you look building up those rolls around your stomach and sitting in

  2. Mayhem Manor Project - ICT

    Also, it has other types of rides written on the left side, so people can have a look on them easily. Additionally, on the top of the page, we can see a very colourful and fast-rotating big wheel, which urges people to try it out as soon as possible.

  1. GCSE Database Project ICT

    Mail Merge, Excel will be used for accountancy as it uses the spreadsheet format. In addition, an Internet Connection will be required to enable the secretary to use DENlist, which is an Internet-based network, which shares other Dentist's patient's files (in general, this does not give detailed information about the patients).

  2. Health and Safety Issues in ICT

    concentrates activity on one hand and on one or two fingers, which makes aches and pain in the fingers, hands, wrists, arms or shoulders more likely.


    It then updates the chart data and adds the suitable titles for the x-axis, y-axis and the chart title This is the pivot table by gender The pivot chart by gender All Student When the macro button for all student chart is pressed, the macro goes to the chart pivot

  2. Creating a computer system for a video rental shop

    Reports are produced for all reserved and overdue videos. Member details information The purpose of the system * Information about Members, videos, borrowing, borrowing line and reservation information will be stored in five separate files. * Allows entry of information via data entry screens about members, videos and borrowing or reserving * Allows the updating and the deletion of

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