• 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
  • Level: GCSE
  • Subject: ICT
  • Word count: 1706

For my project I am going to do a spreadsheet on a shop that sells things like CD's, dvd's and video games.

Extracts from this document...


GCSE Coursework for <<Tim Vague >> Project Title: <<Spreadsheet Project>> Black writing is the headings that you must use for your write up. Red writing is here to advise you and so can be deleted if you are certain that you have fulfilled the requirement. 1) Identify 1a) Background to the problem and end user For my project I am going to do a spreadsheet on a shop that sells things like CD's, dvd's and video games. I will use the spreadsheet to keep track of what the shop buys and sells and what sort of profit they make. The shop is an online shop so I may have to do things like sort out the deliveries of the items to people's homes. The shop is losing track of all their money, like how much they are spending and the profit they are making. This is why I am doing this spreadsheet. One sheet will be on what the shop spends their money on and what they buy and stuff, another sheet will be what they sell these items for and the profit they are making. I might have to store addresses for the deliveries and match the addresses with the membership number, this is for the deliveries of the items. ...read more.


It will be the cell number of the amount the item was sold for, minus the cell number of the amount the item was bought for and then equals. This will calculate the profit per item. Total profit - I will do the same as above but instead, in the cell which will have the total profit in, it will have a different formula in. It will have all the cell numbers of the profit per item added together and then equals. This will calculate the total profit made. 2e) Forms of output The data that is going to be output by the program is : Profit per Item Total Profit Stock left over Tax on each item Total Tax 2f) Back-up strategy There are quite a few ways to back up our work and data. These include : Floppy Disk - 1.44 Mb Zip Disk - 100/200 Mb CD-RW - 650-720 Mb DVD-ROM - 2-3 GB Tape 2g) Security strategy To keep the data safe I will need to set-up a password system, which has a back up system, and can only be accessed by certain users who the password will be given to. 2h) Need for updates The system would need to be updated weekly probably. ...read more.


sequence of development * Go through work and annotate by underlining and explaining any errors or problems * If your work has changed since your final design explain why you had to change it Printout of any further developments you did (and may have even failed at) - need to be annotated Final printout of system 4b) Evidence of testing (and correcting) of system Annotate testing to show how the expected and actual results compare. Provide proof where possible by using screen shots Even if your corrections don't work, make sure that you provide evidence of you trying to correct them and the problems/error messages that you encountered. 5) Evaluate 5a) Original objectives I think I met all of my objectives. I kept track of the financial details of my shop. I kept track of how much money I have spent, how much I have received and the profit made. I have calculated how many items were sold. I have stored members and regular customer's addresses. 5b) User feedback on system See Questionnaire 5c) Further improvements Respond to the comments made by your end user - whether you disagree or agree with them. If you have disagreed with the comments made by your end user then you also need to find at least a couple of improvements that would make your system better. Page 1 ...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. ICT Project 1A

    I then changed this so that it was more suited for my styled website; here is what will be used in my website. Tokio hotel are a German rock band formed officially in 2001 under the name 'Devilish.' The band consists of 4 highly talented boys, Bill, Tom, Georg and Gustav.


    Do you analyse your students performance ---------------------------------------------------------------------- 6. What problems are you facing with your current system? ------------------------------------------------------------------------ ------------------------------------------------------------------------- ------------------------------------------------------------------------- ------------------------------------------------------------------------- 7. How would you want your current system to be improved? ------------------------------------------------------------------------- ------------------------------------------------------------------------- ------------------------------------------------------------------------- ------------------------------------------------------------------------- 8. What do you think is the major failings in your current system?

  1. Creating a computer system for a video rental shop

    It is a hardware component, which act upon instructions to process, input and output information. It determines the speed of the computer, and the software that can run on the computer. A P3 1GHz processor can handle multimedia applications, it will suit the leisure centre as they will not require extensive applications.

  2. GCSE Excel Project ICT

    Alternative methods of output considered Display (on Screen) There are many alternate methods of how the data on screen can be displayed to the user and the secondary user (the customer). The information can be displayed on screen, e.g. the user makes his order and saves it on the computer so that Alex can view later.

  1. ICT Coursework (MarcoS)

    Have a look at the picture below to have a better understanding of the process: This is in the Loss worksheet. This is in the Profit & Loss worksheet. Profit & Loss * In the Profit & Loss page there will be all the incoming and loss registered by the

  2. Database design.

    Number Number 11 No Table Video Entity Types Description Data type Length Key Validation Input Masks Combo box Video_ID ID Number Number 4 Primary >9999< No Video_Name The Name of the film Text 25 >C<???????????????????????? No Video_Category The Category Thriller,horrer,Romantic Text 20 Yes Video_Cert The certificate U,12A,PG,15,18 Text 20 Yes

  1. Database Analysis and Database Design Project - DVD library for moving images.

    The files could be found more easily. MOVING IMAGES DATABASE DESIGN ENTITY RELATIONSHIP DIAGRAMS - CONCEPTUAL MODEL As we can see on the conceptual model below, there is a M:N relationship, a database cannot be create when there is a M:N relationship. ENTITY RELATIONSHIP DIAGRAM - LOGICAL MODEL On the logical model below, we can see that the M:N relationship is no longer on our diagram.

  2. Computer project Alevels

    The entry must be 6 characters long. The first letter must be the letter M, the second letter must be C, and the third letter must be D followed by 3 numbers. E.g.: MCD123 FEES Currency NO OF APP Number PAYMENTS Currency MONTH Text Table - Patient's Details Field Name

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