1 / 10

Spread sheet Evidence!

Spread sheet Evidence!. This is how I completed the spread sheet showing the membership fees.

bjorn
Télécharger la présentation

Spread sheet Evidence!

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Spread sheet Evidence!

  2. This is how I completed the spread sheet showing the membership fees.

  3. We used lots of different formulas to make the spread sheet work. To find the numbers for the spread sheet, we used to the numbers on the spread sheet the exam board had given us and we were then able to use different formulas to make the spread sheet work.

  4. Cell formatting Cell formatting is when I had to change the format of the cell for example from a number into a currency or when we changed the colours on our spread sheet to make them follow our colour scheme. We also changed the colour of the font, cells and the font and font size To change the number into a currency, we had to go to the top of excel and change the drop down menu from general to currency To change the colour of specific cells, we had to select the cell we wanted to change then go to the top of the document and go onto the paint tool and select the colour we wanted to use.

  5. 3D referencing 3D referencing allows us to get information from one spread sheet to another so that we have the exact number and we can be sure that the numbers are the same.

  6. Formulae Using formulae makes it easier and quicker to add, multiply, subtract etc… This also means that the cells are joint together so that if one number was to change, the others connected to it would also change which ensures us that the equations and new numbers are correct

  7. Next we started to find other memberships for adopting animals by researching different site that gave us costs for teen and child memberships in order to change the “DEFICIT” to “SURPLUS” Firstly, I created a table so I could put my research into it and present it clearly knowing the different prices of the different memberships. By creating the table, it is clear what the organisation is called, the type of organisation, the link to the site, the type of membership it is and the fee that is charged

  8. Next, I had to research different sites in order to fill out my table. I went onto the internet and searched for The first website I found was ‘Marwell Wildlife’

  9. I did this with all the websites that I found and completed the table From this information I am able to see that the prices are high and that the fees being charged yearly. I then dived each fee by 12 so that I was able to find the price for the membership yearly. However, the prices were still too low and when I put them into my spread sheet, the total was still deficit., because of this I then had to make up my own fees so they were higher and then also had to change the fees of platinum, gold and silver.

  10. I used various different numbers in order to find a total that was the nearest to zero. I was able to change the costs of Platinum

More Related