• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 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...

Introduction

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.

Middle

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.

Conclusion

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

  2. The aim of my project is to make the task of the allocation of ...

    To do this we simply hold the shift button and click on the AF and AG bars and drag them to the appropriate size. The highlighted cells have incorrect decimal places, which means that the pence in the price will not be displayed correctly.

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

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

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

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

    On the other hand I feel that for people who are colour blind having colour would be useless and an unnecessary expenditure. Printing in colour would also cost more as the cartridges are more expensive than that of a black and white printer.

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

    Step 14 After that, I then added conditional formatting to my worksheet. This allows the teacher to see at a glance if the class is doing well, and the students who need help, due to the colour of the cell e.g.

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