Tuesday 21st January


I’m back, I’m very excited as over the next week I will be working on a brand new project, I won’t be covering reception, writing up data entries or even doing some admin I am doing something more media based and I am super excited to get started!! This for me is my dream I cannot wait once I have graduated to be able to apply for jobs, a job position that will be all mine and 100% media industry based… Eeeekk! 

Anyway back to my project, I asked if I could come in for a maximum of 10 days so that I could pass my module at university called Creative Industries & Professional Practice. This good thing about this module is that its practical which makes a change as my course is 100% theory based, I prefer doing practical projects myself as it takes me back to the days of when I was studying for my photography A-Level and that consisted purely of workbooks. This module has 3 assessments an essay which I achieved 67 marks on (3 marks away from a first), blog & project and a portfolio which we must complete, I haven’t announced it yet but I will be starting a new blog solely for this module as it is compulsory that we do so and will update you with a link if you are interested in subscribing to it as I might keep it as for when I am employed.  

For my project my placement have given me the task to look at a magazine for a pre-pitch that they have coming up. This task is huge to do in two weeks as editor 1 said in the email that she briefed me in. However what I need to do in the following two weeks is to analyse every inch of this magazine feature by feature and say how it can be improved,  put all of my research and improvements into a KeyNote document where all the content I upload has to be written imagining that the future client is in front of me and I am handing them this pitch idea last but not least to show why my placement should be chosen to re-brand their magazine over other companies.

Some pointers to get me started from editor 1 were:
– Get a clear idea of who they are and what they do. Who is the audience for the magazine? What do they want to read about? What are they interested in? What is the role of the magazine?
– Critique the website, magazine, social media, any other channels you find. How do these work together?
– Pull together some topical editorial ideas for the magazine
– Any other content channels that you think would work for them? Blog, newsletters etc? Do they have any ‘competitors’ and are they doing anything innovative?

This magazine was previously in a newsletter format but has now changed back to a magazine, writing up initial research was the hardest as I found it very stressful to get a great deal done on the first day in order to show something to editor 1 so that I can discuss my progress. After lunch I started off with opening KeyNote and creating slides with appropriate headings from the brief that I had such as Target Audience, Social Media, editorial ideas, website etc. After that I had an outline of what research went where so that I could fill in each slide as I went along. I also asked editor 2 for some advice as I found this task slightly hard to get my head around and I didn’t have a clue if I was doing it right to be honest. Editor 2 suggested to make up an imaginary target first and suggested that once you have your target audience the rest is easy to tackle. She gave me pointers to look at their interests, other magazines that they may read and to look through those for inspiration too and to look at ABC figures. For those of you that don’t know what ABC is they are the independently audited sales figure for all recognised publications in the UK. By using the ABC figure, you can quickly establish how much the advertising will cost per 1,000 readers.

I then followed her advice and began to construct my target audience, the thing I was finding the trickiest of today was getting inside my audiences head so that I could understand what they would like, as I’m only 22 I have a mind of socialising, exploring, going out, working towards my dream and being a complete social media addict. Whereas my target audience for this magazine was 55+ an age gap of  33 years and above who obviously would clash with those of a young mind. It was very challenging for me to think as an older person and trying to look at things with their perspective. What editor 2 told me to bear in mind is that 50 is the new milestone and that young content can also be applied to an older age such as a 30 year old may love reading about different recipes and cakes in magazines but to remember a woman in her 50’s may enjoy the same thing as well. 

I’m also very grateful to have this opportunity, although it is my first day of the project and I am finding it very hard  I’m grateful to see how hard the working environment can be on a daily basis and for showing me the reality of what to expect in the future… creative industries are hard to get into and hard to work in people should be aware of this as standards are set high! 

See you tomorrow day 2 of my project awaits… 

Also posted in http://lifeisfunbeingme.wordpress.com/


Friday 30th August

As usual no two days are the same at my work placement, I got in and completely forgot it was flexi Friday so at home I was taking my time this morning in terms of getting ready. As the PA was slightly late I helped out the receptionist with some errands to use time wisely I filled up the coffee jars, counted the competitions and put the magazines away in the magazine cupboard.

Today task was seeing what happens with all the data that I worked on when typing up all those competition entries a few weeks ago. It was quite exciting for me because it feels like next time I can fully finish the job. What happens is I type up the competition entries by writing the person’s name, their house number and postcode, followed by their magazine subscription number and filling in which competitions they answer. When the document is finally finished, the next step is to open Key Note…

Once Key Note is opened, I started with the usual steps of opening up the inspector, colour pallet and font. I then, (with the help of the PA assisting me and showing me how to do it as it was my first time doing this assignment.) started to compose the presentation of what the stats revealed from the competition entries to then show the client of the magazine. What I had to do with the Excel document was calculate the % of how many entered what competition. Below is a diagram of one I have made up to show you the process of what I learnt…

Table 1 Friday 30th August

To calculate the amount of people who entered a competition is you have to use a sum called COUNTIF as shown in the diagram below…

Table 2 Friday 30th August

What you do is choose a cell where you want the sum to by totaled (as seen above) click = enter =COUNTIF(Click cell where the first entry is:Cell where the last entry is,”Word you want counted” Then click Enter and it will calculate it for you


A quick way to add them all up to see how many people entered which competition simply highlight and drag to the last column as shown below and let go and it will have calculated the formula for each column.

Table 3 Friday 30th AugustHowever once you have let go it the rest of the columns will look like this…

Table 4 Friday 30th August

This is because the formula is not calculating the right column, such as in my first diagram it is still counting for the word dog. To change this simply click on the cell and change the word “Dog” to the correct word i.e the next column for it to count how many people preferred “Cats” instead.

Table 5 Friday 30th August

Once you have done this you are then ready to calculate the percentage for the whole competition. To calculate the percentage…
Firstly, where you can see the Total in the diagram you need to add up all of the totals in a separate cell to do this you need to click = in a cell & add all of the cells up. Make sure to include the plus sign in between each cell number as shown below…

Table 6 Friday 30th August

Secondly, you then need to make a row for where you percentages will go, then start dividing the answer with the total of entries that there were such as in my example the formula will be =B14/I14 (Note: / means dividing in Excel) do the same for each column remember to have to substitute the first part of the equation only such as C14, D14 etc… 

Table 8 Friday 30th August

Once you have done that you will notice that all the numbers have been worked out as decimals, as shown below….

Table 9 Friday 30th August

To convert them into percentages:
-Click onto the decimal cell
-Right click
-Click Format
-Click Number
-Click Percentage 
-Decimal places 0
-Click Ok

Table 10 Friday 30th August

Once you have done this you will then have all the data you need to then start converting into tables for the Key Note document. 

One thing that you need to be careful with is sometimes when you put in a formula you may see the words but the formula might not pick them up this is because if you have wrote the word “Cat ” and put in the formula to search for “Cat” the search won’t pick it up so what you need to do to fix this is to click Apple + F  The following will come up…

Friday 30th August Find & Replace

Click on the Replace tab and find the word “Cat ” & replace with “Cat”. When recalculating the formula it will then calculate it correctly. 

Another tip, the PA taught me to put in colour the different sums that you have to calculate so it’s easier for you to read when looking back for the answer. A tip that the PA taught me is to put the $ sign in between the the letter & number of the cell and you will find that it doesn’t make the cell move.

After I had calculated the % of how many people preferred which competition to enter, I then made a slide on Key Note remembering to apply F.A.C.E (Font, Alignment  Consistency & Engagement) (I’m not able to show you the steps for Key Note as I don’t have it installed on my computer) for each competition and made a table so that for the client it’s visually easier to see the differences in percentages.

Today was packed with learning about how to make more use of Excel, I learnt some more keyboard short cuts such as….
Apple + F = Find
$ = It doesn’t make the cell move
E = Sum   = Sigma/Sum

What I find is sometimes I reflect over what I did at placement and I am so grateful for the PA asking me to come in and do something which could take someone who has more experience and knows what there doing 30 minutes whereas it takes me a whole working day, yet she still assists me if I’m stuck or don’t understand something at all to pause her busy working day and help me through it. 

The PA also said to me it would be useful if I made a Word document of the experience I have with them so that for them it’s handy to know what I can and can’t do so I’m going to be working on that. I now won’t be posting until after the 12th September as i’m going on holiday on the 3rd Eeeekkk

See you soon. X

Also posted in http://lifeisfunbeingme.wordpress.com/

Thursday 22nd August

Today I was only in for half a day, as I had some family stuff to do in the morning. Once I got into the office, I finished collecting the updates from the editors so that I could update the keynote document. I must have gone over this document a million times, to make sure it was perfect.

After making sure the font colour was the same colour, I did the same with the dimensions of the images and that everything was aligned. Once I did that the PA suggested to print out the document and to look at it in from a hard copy form as sometimes you pick up on details that you don’t see in the screen. Some of the slides I rearranged the composition as I didn’t like the way it looked as it appeared to make the slide look messy.

This week has been really good for me in the sense that I have learnt something new and can add something extra onto my CV. By using keynote I learnt the importance of F.A.C.E Font, Alignment, Consistency, Engagement when making a presentation. This week really tested my knowledge on everything that I have learnt in media at college & university. I think I dealt with this week very professionally especially as I had never used this software before and put to use everything I had learnt about media language. I am proud of myself to say that the PA was happy and impressed with the work that I had done and hopefully I will be able to use keynote a lot more. I am definitely going to be using this software a lot more next year at university for assignments that requires presenting your work in front of the class.

I then wrote out my invoice for this weeks hours, I’m also very excited as next week I will be working with another magazine… eeekkk even more experience as well as doing something different. See you then! 

Also posted in http://lifeisfunbeingme.wordpress.com/

Tuesday 20th August

Today was amazing, I love going into work placement and not knowing what to expect out of the day… once I got in I waited for the PA to arrive. She then introduced me to using KeyNote. She asked me if I have ever used this software, I replied with, ‘No.’

I would like to state that I am really good with picking up on new things, I have never understood people that give up on the first obstacle. Such as KeyNote seemed similar in ways to Photoshop and InDesign, so I used my knowledge I have from them to apply it to using KeyNote. It’s all about trial and error when learning to use new software’s, it’s about familiarising yourself with where everything is before starting to use it. 

The PA explained to me how she used it so as soon as she opens KeyNote she opens up the inspector which is just the Tool box that has everything inside, followed by opening up the colour pallet and the font. 

Today’s task was to fix the business credentials PowerPoint showed to future clients. To me it’s such an achievement to know that I am going to be working on this and to know that the finished version will completed by me. 

To start off, I opened all the information all the editors passed onto the PA which she then passed on to me and pasted the information to the relevant slide and made sure that they were all up to date. After I did that it was time for lunch, I was a bit slow to start off with clicking onto the KeyNote finding the right slide pasting the information and going back onto the emails. I even learnt what A ZIP file is when attached into an email. This is when files are compressed/squashed in so that when you download it, it creates a slide with all the relevant information inside such as Word Docs, PDFs & Images.

After Lunch I started to construct the presentation, I never realised how much work it is, from now on at university I am going to put in twice as much effort as a good presentation can make all the difference to aiding you with the point that you are trying to get across.

I had to make sure that Large, medium & small images were all the same size whether it was the height or width so that the presentation had consistency throughout (see F.A.C.E below.) I made sure every picture had the same shadow density, the font had the same colour and density, every piece of text was aligned to the same X,Y co-ordinates throughout and so on. Whenever I made a mistake or seen room for improvement on a slide I then had to go to the beginning and make the same change to every slide.

I even learnt how to edit a picture (crop) on Keynote which is called ‘Mask.’ I also learnt how to fix a picture that has a transparent background by putting a white sheet underneath so when looking at the image, it’s easier to engage with. 

It’s strange but in an 8 hour working day you can learn tonnes!! I managed to pick up on Keyboard shortcut’s such as:
Apple + I = Italics
Apple, ALT + C = Copy Font Style
Apple + A = Select All
Apple, ALT + V = Paste Font Style Copied

I learnt what the concept of F.A.C.E means:
(This concept needs to be shown throughout the slides for a good presentation.)

I also learnt new terminology such as Widow Words & NB = Note Bene. Widow Words are when a paragraph is finished with one word and it’s left on it’s own whereas NB (it’s Latin) simply means To Note.

I’ll be completely honest, I felt a bit stressed when working on this presentation as I had never used this software before and I am still a work experience girl working with a company who has a certain standard that they all aim to, including me when I’m there.

I’m proud of myself that I managed to get 90% of this presentation done which to me was such an achievement as I had never used this software until 8 hours ago BUT let’s be honest after spending 7 hours straight on it I was bound to learn a lot.

See you tomorrow!

Also posted in http://lifeisfunbeingme.wordpress.com/