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

To start my project I have chosen that I would do a spreadsheet for a games rental shop. This shop would be renting out games for people to borrow over a period of 3 nights

Extracts from this document...


Spreadsheet coursework By saad ijaz Caterham high school Centre no. 13321 Candidate no. 0199 Rent it!!!!!! Games rental To start my project I have chosen that I would do a spreadsheet for a games rental shop. This shop would be renting out games for people to borrow over a period of 3 nights. If the games are brought back later than the due in date then there will be a fine of �1 every night. I think choosing to do a games rental shop is quite a good choice because it would involve lots of calculations. I think that excel would be very suitable software to use for this games shop as it would give me all the calculations and results and graphs. I am going to have a stock sheet on excel and another sheet which involves the sales and late charges. I will be calculating things such as adding up sales and late charges and adding up. Excel is the best program to calculate because I would be using its features to calculate. Using formulas you can calculate the whole database in a second. These are the sorts of calculations that we can get from excel: * Average sales per week * Most rented game * Adding up the number of rentals in a week * Working out the profit * Fine charges etc. ...read more.


When you enter the data in flexi data you have to fill in a form. Then I copied and pasted into excel. I need quite a few different types of data. For example the most common used would be text. It will be used in the stock, customer names, and other customer details. The most important one however would be codes and serial no. for my stock. These codes represent the type of game that it is. So a sports game would start with 3 and every time a customer is looking for a sports game you would look in the 3 column and find the game the customer needs. The serial number however is an individual number given to each game in stock. The problem that excel solves is that it holds all the stock information. It calculates the prices for the rented out games and it would also calculate the fine charges for the late games brought back. Customers would be fined �1.00 for every night they keep the game Overdue. On sheet 2 there is all the information about the business and how the whole week has gone showing results and profits earned by late charges. There are lots of copies for one game and since they all have to be returned one day by the customer there is a serial number to see which customer took out which copy. ...read more.


So if any customer has a late fee to pay or hasn't returned a due in game then the shop owner would have to go through this: Flowchart next page------------->>>>>>>>>>>> No Yes In this part of the project I have now created my spreadsheet here I will show what changes and testing were done to the spreadsheet and how I managed to get my final implement. The main change that I gave to my spreadsheet was unique stock names. As I mentioned in my analysis that I will keep the stock name the same but a unique serial number. However I found out that when Vlookup was used to get data from one sheet to the other the data was not shown uniquely. Below is an example of what happened. A very important part of the spreadsheet is validation. This was also part of my testing. To test my spreadsheet I tied to enter an anomaly data into a validated cell and see what message appears. How ever the most use of validation in my spreadsheet was a dropdown list. Here is what I had done. Finally my main part of implementation is the testing and user responses. I tested my spreadsheet as mentioned above by using validation. Below are a couple of more examples of testing. Testing continued testing if a macro works. That button took me to this screen so my test was successful. ...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 Software 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 Software essays

  1. Design a spreadsheet that can be used by a school tuck shop.

    expenditure product type product name number sold last week number in stock from last week crisps walkers ready salted walkers smokey bacon chocolate bar dream whisper aero snickers mars bar kit kat twix sweets skittles original polos original refresher bar sour skittles drinks pepsi bottled fanta bottled bottled water number

  2. Planning a spreadsheet database for a gun shop.

    You can write on paper and store the paper in a safe place so you don't lose it, which can be used as a backup. Chosen solutions: Although there are a many different ways of solving the problem like calculating everything by hand this obviously needs to be replaced using a better system.

  1. Documentation of a database for a sports centre.

    This makes up background details and important information on the member. I have chosen to use data types as it will validate information that has been inputted. In this case, for contact number the data type is text as numbers include "0".

  2. Designing a leaflet to advertise an electronics shop.

    Microsoft office 2010 because it's the best software and it includes all Microsoft products. * Microsoft publisher for the leaflet. Data collection: Mr Smart, the manager of the shop will be assisting me with all the information that is required to do my job.

  1. Database design for a games shop.

    because only one person works at the shop at a time hence the reason they can't leave the shop unattended . Resultantly they are losing out on potential profit. At the moment MR. Walcott and Ben records all the data on a scrap piece of paper so when a customer

  2. Appropriate Software To do this project I am going to use excel because ...

    Colour printers themselves are quite expensive and having a black and white one would cost less. In conclusion I think a colour printer would be the best option as it offers certain aspects which are extremely useful to the spreadsheet.

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    Unfortunately, it will only let you have up to three conditions, but in my circumstance I only wanted to have three conditions, so this was not a problem. I added more conditional formatting through-out my spreadsheet, changing each one to suit shown in the steps above, but making sure I

  2. Powerpoint review project

    Presentation graphics uses colours and drawings to get the attention of the audience. People use custom animations to make entrances and exits to slides effective to any object. Slide transitions are used to make your timing and how you want to go to the next slide by clicking or running automatically.

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