Week 22 Unit 3

This week i have completed

Week 21 Unit 3

Since I've finished all of part 2, I have had to re-visit part 1 and actually update my managing storage section which I have spent this week completing fully. I have taken print screens of my folders and files and the back up that I have been keeping on ispace. I have also been explaining how this is an effective way of managing storage.

Week 20 Unit 3

FINALLY HALF TERM!

and I have also almost completed my controlled assessment! I have completed the last part of my evaluation which is of others and have discussed how my system could have been impacted if I worked with others. The evidence for this also will be provided in my check-list (my second method to track my progress). 

Week 19 unit 3

This week I have managed to complete my self-evaluation of my work and have evaluated all my milestones and described the strengths and weaknesses of my work. I have successfully completed this and that to in a lot of depth. I will provide evidence of this on my check-list.

Week 18 Unit 3

2f Report
This week I have completed my report that I have produced for the head teacher of Valentines high school to make them aware of the results I have gathered and how I have planned to organise the prom as the prom organiser. To complete this task, I had used a presentation (on Microsoft Powerpoint) as this was one of the most appropriate software available to me.





Milestone 1 (formal representation): I have ensured that the presentation of this report that I am creating is formal by using my language appropriately. I have attempted to use faultless grammar and accurate spelling to ensure it is formal which I believe I have achieved.

Milestone 2 (discussing results): I personally think that I have met this milestone and completed it successfully because I have explained what I have found out and then thoroughly explained the purpose of doing it and how it was done. I have also made it sufficiently detailed where possible as shown on the example on the image below. This is shows evidence of my thoroughly described results.

Milestone 3 (add a conclusion): I have also completed this task which was to add a conclusion onto my report as a brief overview of what has been said. Some of which I have created is exemplified below; the conclusions for some sections show here. I didn't face any difficulties here as I was only simplifying what I wrote on the other slide.

 Milestone 4 (navigation): I think I had completed this very effectively. As my report was in the form of a power-point presentation, I chose to add hyperlinks to screenshots of every slide and add them on a contents page so the user could press on the slide they wanted to view through the hyperlink. The contents page for my report is illustrated on the on this entry.

Week 17 Unit 3

This week I have worked on the modelling section of my controlled assessment. This is where I had to create a model identifying the different costs and analysing my use of "what-if" questions.

Milestone 1 (identify costs): this was the first milestone that I had to complete whereby I was made to identify the different costs that are involved within the prom. This includes the hall costs, food costs, entertainment costs that I have successfully recognised as shown on the screenshot on the left. (The titles for each sector are the costs that are involved).

Milestone 2 (Produce a model): I have successfully completed this milestone also which is evidently represented by the screenshot which shows this model that I have created. Using this model, I have come to an overall cost after considering the different costs involved. The overall cost I have come to is £34.44 which is less than the overall cost I was meant to keep it at (which was £35). I have done this by adding different types of validations such as drop down lists and IF statements which have thoroughly been described under 2d modelling with data. To work out the overall cost I have used a combination of formulae throughout which involved a number of mathematical operations such as adding, multiplying (for when I worked out the total cost of each sub section) and division when I worked out the individual cost per person. These formulae and IF statements are represented on this screenshot above as further evidence. Some formulae took me some time to work out as I had to be very careful and think about it especially with the IF statements where I got confused. I resolved this by thoroughly checking my statements for mistakes.

Milestone 3 (investigating ways to keep overall cost at certain level): in my case I had attempted to keep the overall cost at £35 per person which I have achieved in my model. The three ways that I though this could be achieved is by first of all a cheaper venue type/increasing number of students and encouraging them or even changing the meal type etc. I have met this requirement also.

Milestone 4 (interpret results): I have also met this as I had explained and had completed an analysis on my "what if" questions.

Week 16 Unit 3

This week I have fully completed my select information section of the controlled assessment where I have created the queries and the reports that accompany them. I have formatted these reports and have finished my format information section for the formatting that has been used in 2a and 2b.

2b Select information

milestone 1 (create a relational database): I have successfully achieved this as stated once before. I didn't face any difficulties here and I had linked them so that data redundancy hadn't occured. The evidence for this is shown below which shows the records linked.

 

Milestone 2 (decide what information the prom organiser will require): I have also achieved this milestone also as shown from the mind map I created - illustrated on the screenshot towards the right.
 At this point, I did face a few difficulties as I was uncertain on the data was was needed in my letter and whether I missed any out so I used the help sheets that were provided to me.

2c Format information

 Milestone 1 (format of page layout (portfolio): I have completed and achieved this milestone by explaining how I have formatted my general page layout; in this case with a landscape orientation etc. The evidence on the left shows evidence.







Milestone 2 (format of text): the screenshot shown on the right shows evidence that I have explained how I have formatted my text. I have provided an explanation as to how it is suitable also. I have spoken about the text alignment, the text fill, text style, font, size etc.


Milestone 3 (formatting parts of the database and powerpoint):  The evidence shown on the left shows that I have formatted my powerpoint and database. This screenshot only shows some parts of what I have completed. I didn't face any difficulties here.

 Milestones 4 (explain why I have used this way of formatting): the screenshot on the left shows the table that i had produced with a column that discussed how suitable the method that I used was. This fulfilled the milestone and completed it.