• 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


    If anyone attempts to make a change or to unprotect the Database, Access will ask for a password. Part 3 - Design Initial Designs I have enclosed a design of the database Medical History Last Check up Prescriptions Subscribed Title Surname Other names Date of Birth Gender Address - 1st

  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. My database is on a video rental shop.

    - table customer Field Name Description 1 Customer ID Text, field size 50, required 2 Customer name Text, field size 50, required 3 Customer surname Text, field size 50, 4 DOB Text, field size 50,required 567 Address Postcode Phone Text, field size 150,required Text, field size 50, Text, field size

  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. In the following report, I will describe, using screenshots, the advanced features of Microsoft ...

    problems that Sainsbury's Pharmacy Personnel Department were having in relation to payroll and recruitment. Payslips were being prepared for employees of the pharmacy by the Pharmacy Payroll staff in the Personnel Department by hand.

  1. Documentation of a database for a sports centre.

    Add New Member On click New form appears in order to create a new member. Membership Types On click Opens the different types of memberships available to members. Delete Member On click Take you to the spreadsheet and allows you to delete a member.

  2. spreadsheet project

    Why should you use ICT? This table shows the advantages and disadvantages of using a computer to design a spreadsheet. The main advantages of using the computer is that it is much quicker and easier to design spreadsheets, it is also much easier to distribute via email and other appliances.

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