• 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


    * It is very time consuming, especially the calculation of percentages attained in marked worked and grades obtained overall. * As the names of students are not in order she finds it difficult to find the student to record a mark.

  2. GCSE Calculator Project

    The fact that you have taken the trouble to program a box which records your calculations comes very handy as sometimes I forget what calculations I have already done. The display box is very large, again much better than the Microsoft version because I usually have to squint my eyes to look at the numbers on the screen.

  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. This project is designed to help non-computerized library to easily keep track of their ...

    the library to buy books, if a member wanted a book that the library didn't have then the librarian could put that certain book in the next stock list of books sent off to the supplier of the books. So what would happen is that the pupil or teacher would

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

    data type, which is text, including the telephone number, the reason for this is because the numeric data type will not allow a leading zero as text data type will. On members id the data type is autonumber, which is a numeric number automatically, generate by the system and the

  2. Computer project Alevels

    E.g.: MCP1234 FIRST_NAME Text LAST_NAME Text INITIALS Text ADDRESS1 Text ADDRESS2 Text ADDRESS3 Text TELNO Text !\(999") "000\-0000;0;_ DOB Date/Time 99/99/0000;0;_ CIVIL Text "Married" Or "Single" Text you entered is incorrect! Please enter either Married or Single. SEX Text "Male" Or "Female" Text you entered is incorrect!

  1. Ict Powerpoint Coursework

    with ease I have successfully added hyperlink buttons on every page to navigate around the PowerPoint Presentation with ease. The hyperlink buttons on every page include a forward button to go to the next slide , a previous button to go to the previous slide and finally a home button

  2. Database Coursework

    This is incredibly fast; it is one of the fastest processors. The price of this processor is approximately between �800-�3000. This is very expensive, but if you're looking to save money on a processor, then it's very likely that the one you get for lower prices are slow.

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