1 / 75

By Sandy Merheb

Project Log. By Sandy Merheb. Friday 14 th September 2012. In today’s lesson we began to look at the new project we were going to begin and we had to create a mind map of the different tasks we had to do within the project and the deadlines we had and how many lessons we have to do each task.

raymond-anderson
Download Presentation

By Sandy Merheb

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. Project Log By Sandy Merheb

  2. Friday 14th September 2012 • In today’s lesson we began to look at the new project we were going to begin and we had to create a mind map of the different tasks we had to do within the project and the deadlines we had and how many lessons we have to do each task.

  3. Wednesday 19th September 2012 • In todays lesson we began to do our initial plan. We had to write down all the tasks we had to do and we had to type the dates each task was going to be started and when the planned end date is and whether we did it in class or at home or both and the contingency time as well.

  4. Wednesday 3rd October 2012 In todays lesson I had to go over my initial plan and check that all my dates were put in and that I had to save it as ‘on-going plan’ so then throughout the course I can make changes to it and adjust the dates

  5. Friday 12th October 2012 In todays lesson we began our Wild care database. I used the DIDA website to give me the codes for the database and then we had to write in the field names and data types and field in the validation rules. I created a database and I put all the appropriate field names and there relevant data type. These field names were provided on the Dida website.

  6. I then changed the field sixe because there is too much capacity and it doesn’t need that much and so we reduce it because the data isn't that much. For some of the field names like ‘Group’ Status’ and threat’ I did look up wizard for these 3 field names because each one has certain data so this means I can put the data that is required for that field name and a drop down box will come up and the right one can be selected

  7. When I click on the lookup wizard I press ‘I will type in the values that I want’ which then allows me to type in the data that will come up for the field name in a drop down box

  8. Then I type in the data that will be put on the drop down box Then I labelled what I want for my lookup field.

  9. Then we had to type in a validation rule so people can only type in the data we want, the acceptable data we don’t want them to write any random thing we can only have the genres that are acceptable. The validation text shows that the data inserted is wrong and says what the right data that should be inserted should be.

  10. The field name is ‘Name of species’ and the relevant data type is ‘text’ I changed the field size from 255 to 45 because then we have extra that doesn’t need to be used in the database, when you reduce it there wont be a lot of data.

  11. I reduced the field size to 25 because I know that the data will only be bird/insect or Mammal or fish or reptile/amphibian so I know that 25 is enough otherwise there’s too much capacity The field name is ‘Group’ and the relevant data type is text The validation rule is so that people can only enter the data that is required and if not then the validation text will come up asking to enter the correct data

  12. Wednesday 17th October 2012

  13. When I have pressed the external data and pressed text file this will come up and I browse where the data is I want to import. This is where I got my data from, Resources/ ICT/Mrs Hidson/11IOTA. Then you click Append a copy of the records to the table, so that the data is imported into the Field names you had put. And it doesn’t import onto another database. The data will come up then I press finish or next but I pressed finish and eventually the data will come onto the database that I had set up for the data to be imported in. When you have pressed finish then the data will come up in the table I had made and each data will go under each field name. IMPORTING DATA

  14. Wednesday 7th November 2012 In todays lesson we started our data entry form, we had to create a data entry form and make it look more appealing so I changed the font, colour and I added the Wild care Trust logo. I then added the 3 new endangered animals to the form and I made sure that ‘threat’ and ‘Status’ and ‘Group’ had an arrow so that the person can see the other options, I had to add buttons and had to make sure that I had the codes for ‘Threat’ and ‘Status’ so that they know what each code stands for.

  15. Data Entry Form

  16. I have added my 3 different species into my data To create my buttons I clicked on ‘Create’ and then clicked on the button shaped and then I created a button for saved records and add records and quit app these three buttons are at the bottom of my data type form

  17. I then created a Form for my Wildcare Trust database. We had to make it colourful and I used my colour scheme in my form. I changed the colour the font the size and the background colour. I had inserted the codes in my data entry form so that the user can see what each of the letter in the code mean

  18. I had to insert two tables with the different codes for the threat and status, I had to make two tables on word and then had to save them as an image and then insert them into the database, so that the person knows what each code means in the database.

  19. I added the Wild care Trust logo to my form because I think it represents the data well and I think that it shows what the data is going to be used for I changed the title and I made it look more appealing by changing the font and before it didn’t say anything about the project and I had to change the title I made sure that the drop down boxes are there because the person has to know what other options there are for each and the codes is there to help show what each code is used for I made sure that there are buttons so that it is easier for the user to access the data

  20. Friday 30th November 2012 • In todays lesson I had to check over my database and my evidence to check that I had met all the criteria and I had to make some changes and make sure that I had all the things that was needed in the data entry form and in my database to ensure that I can get full marks for it, I also got feedback from my peers to see what I needed to include.

  21. Wednesday 19th December 2012 In todays lesson we started and completed our spread sheets ’12 Month Cash Forecast For WildCare 2013.

  22. This is the information that I have to insert into the spread sheet. I have to make sure that the information that I insert is correct and that I make sure that the data is put into the correct months.

  23. To find out the total cost of the platinum membership you multiply the number and the cost and I did that by seeing the what square the number was and pressed =B5*C5 which was the square where the cost was and that’s how I got the total of platinum memberships

  24. Instead of typing in each multiplication for each membership I go to the side of the box with total amount for platinum and then I scroll it all the way down to the total of the wildcare Kids and then all the total amounts will come up for each memberships.

  25. From this data I can insert all the correct information into the correct cells throughout the spreadsheet. For the first half of the spread sheet I need to put the data for the ‘Memberships(Jan Only)’ and ‘Research grants(Jan Only) and ‘Adoptions (monthly)’ and then I worked out the total for each and then the total for the whole month.

  26. The membership is for only January so therefore so I went to the total membership fees and inserted it into the January cell because on the data it says (Jan only) so the rest of the month wont have any money to get the value of £0.00 I dragged it along until the total and this showed that in all the other months it had no value and the total was added up. To get the total in the cell where January is and typed in =D10 which is the cell where the total is.

  27. I had to find the data for research grants so that I could insert it into the cell and that is only applied for in January so the other months have no value so when I drag it along the values for every month and the values will be ‘£0.00’ because the research grants only apply for January.

  28. Friday 11thJanuary 2013 For adoption months I have to see from the data what the adoptions is then I have to insert it into each month. The quickest way for me to do that is to put the amount into January and drag it along throughout the cells and the values will come up in all the months and in the total cell and the total of all the months for Adoptions will total up. I had to type into the January cell for adoptions‘ =‘ and then click on the data that was for adoptions monthly and then had to click on and press enter then it will come up and then I have to click on the space where it shows the formula and press F4.I had to do absolute cell referencing this means that it copies along all the cells the same data from the first cell which means that all the rest of the cells won’t have the £0.00 value in it.

  29. To find out the total income for each month I typed into the cell for total income for January =SUM(B14:B17) which will add up all the Memberships, research grants and adoptions. Then I dragged it along all the cells for Total Income and that gives me the Total Income for all the months and their totals

  30. To work out the salaries for each month, I had to check the costs data to see what the salaries was for each month which is 29250 for each month and then I had to do absolute cell referencing this means that it copies along all the cells the same data from the first cell which means that all the rest of the cells won’t have the £0.00 value in it. T o do this I had to press the ‘=‘ and then click on the data where salaries and that would insert the data and then I press F4 so that would then make a copy of the same thing in all the cells.

  31. For the Administration Costs I could see that the data that had to be inserted into the cell was 6490 and then to out that into the cell I have to press ‘=‘ and then enter and that would insert the data into the January column and to copy that into the other months I have to absolute cell reference which then meant I had to press F4 into the formula box and this would then mean it would copy the data to all the months and it wont give a £0.00 value like it would if I had dragged it along.

  32. For the rent I checked on the cost as it says that the data for that is 12876 and only applies for the months January, April, July and October. I did absolute cell referencing which then allowed me to copy the cost into each month. I did this by clicking into the January box and pressing ‘=‘ and then going onto the costs data and clicking on the relevant data which is Rent and then press F4 which will then allow me to copy the data into each month without the value being £0.00.

  33. Wednesday 16thJanuary 2013 For utilities I have to go onto the cost sheet and then see the cost for utilities and its ‘985’ and then I go onto the January cell and press ‘=‘ and click onto the cost and press Enter then the cost will come up in January. I then had to do absolute cell referencing this then allows me to copy the cost into all the cells in the row without the value turning to £0.00

  34. From the cost sheet I can see that the cost for food is 1200 and so therefore to insert this into the cell for January and to copy this into the other months and to do this I had to use absolute cell referencing, to do that I had to press ‘=‘ in the January cell and then I had to go onto the cost sheet and press the food cost and to copy this value of ‘1200’ I had to press F4 in the formula box and this will then allow me to copy the same value to all the months.

  35. For the veterinary cost I know that the cost for it 5000 I know this from the cost sheet. The veterinary cost is for all of the months so therefore I have to have the same value for each of the months. To make sure that the value is copied into each of the months I have to do absolute cell referencing, this ensures that the value is copied into each of the cells for each month. To do this I have to press ‘=‘

  36. For the publicity I could see that from the costs sheet that the publicity costs ‘1500’ so I had to make sure that this value is inserted into each cell for each month. I have to make sure that the value of 1500 is repeated in all of the cells so I have to copy it into each cell without the value changing to ‘0’ so to make sure that the value is correct in each cell I have to do absolute referencing. I had to press ‘=‘ in the cell of the month of January and then clicked on the value of publicity on the cost sheet and then F4 on the formula box so this made sure that the value is copied into each cell correctly so then you drag the value along the cells and this will ensure that the value is the same.

  37. The Total Outgoings is the total of each of the months and all total paid for each of the months and when the first month’s total outgoings is done then by dragging the black cross along the other cells then it’s the other outgoings for the other months.

  38. Friday 25th January 2013 This is my research table to show other organisations and the different prices they have for different people and it varies with each organisation. The three I chose were WWF, Marwell Wildlife and ZSL.

  39. WWF is a website to allow people to be able to adopt animals for a minimum of £3 a month, it also has a club for children aged 7-11 years to join and its only for£3 a month and £1.50 if adopting an animal.

  40. In the Marwell wildlife organisation it also allows people to adopt an animal. The have a annual membership which they allow people to join and the costs are quite high for all of the ages for an adult the price for a membership is £56 and for a child between the ages of 3-16 the price is £36 so the cost for a membership at Marwell is quite expensive than the membership at WWF.

  41. In the ZSL the membership prices are good for example the family 1 with one adult and up to 5 children is only £169 its quite a good price for a family. For Family two 2 adults and 5children is £244 which also a reasonable price for a family membership. From my three organisations ZSL is the only organisation that offers a family membership at a reasonable price. For children from ages 3-15 the membership costs £66.25 and under 3’s have a free membership.

  42. Wednesday 30th January 2013 For my first proposal I inserted the values of the membership prices of WWF and it shows that it doesn’t work because the teens price is higher than the Platinum and Gold and Silver and also they are in deficit and they wouldn’t be able to pay for Administration

  43. Goal Seek I pressed on the cell I want to make the value I needed it to be and so I pressed on the Net Cash Flow For the value put ‘0’ this is because I am trying to make the Net Cash Flow closest to zero and putting the value zero it will change the prices of the membership so that the New Cash Flow changes to ‘0’ By changing the cell I have to choose one of the membership prices that I want to change so that the Net Cash flow value can be the closest to 0

More Related