• 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. GCSE Excel Project ICT

    calibrations: Font: Calibri Font Style: Regular Size: 36pt Colour: Black (RGB #000000) Example Text The Background will be a neutral colour suggested by the user: Aqua. Aqua Properties: R=51 G=204 B=204 Creating a blue/green colour. The button labelled 'Let's Go!'

  2. Video Rental Shop I.T. System

    Operating systems basically keep the smooth running of your computer and it also controls basic inputs and outputs like the movement of the mouse.

  1. ICT Developments

    If the workers have no connection to any sort of ICT then the consequences they might face are that they will not be able to make good designs and will not be able to show their work from home. Entertainment and Leisure The positive effects are that children and teenagers can watch films from home.

  2. a level ict project

    This function will prove imperative when entering important information e.g. bank account details and passwords. Providing the advanced features of the database software is exploited a successful interface can be displayed, activities the system and user need to perform can be done by selecting the appropriate icon.

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

    Other types of software were considered. A database was considered because they can hold large amounts of data but it was decided that a spreadsheet would be more appropriate for several reasons: > Formulae can be entered and the results of changing both data and formulae can be seen instantly.

  2. 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.

  1. Ict Unit 2b

    Also known as IEEE 1394, FireWire was invented by Apple Computer but is now commonly used with Windows-based PCs as well. Whipps Cross Hospital need Firewire because it's faster way to transfer data from cameras and videos. Software > Microsoft Office is a suite of productivity programs created by Microsoft and developed for Microsoft Windows and Apple Macintosh operating systems.

  2. Moviezone video rental system.

    I have asked Hollywood Video Rental if he thinks this is a good idea and he agrees with me. He has also suggested that it might be a good idea if the new system could be used by his customers to choose records for their own discos.

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