Thursday, 7 August 2008

Presenting data - incorporating MS Excel charts

Apologies to anyone who may read this blog, I haven't updated it for absolutely ages!

During my hiatus, I have not only been to Glastonbury and had a marvellous time, but I have also been busy writing up my MSc dissertation (honest).

Now as most people probably do, I am using MS Word (for OS X) to write up my findings and a lot of the data that I have collected has been input into MS Excel. From that data I managed to create some very pretty charts, of the bar and pie variety. Whey hey!

I have 2 problems using MS Excel. One is that I find the Help rather unhelpful. The other issue is that I find interaction between 2 Office products to be less than intuitive at times. I spent ages saving my charts and cutting and pasting them into my Word doc but this did not work as the images were all wrong and you couldn't read the data.
I then thought 'ah ha, you have to insert an Object! ' Lo and behold there was indeed an option to insert an Excel Chart. Did this work then? Well no. I concede that I may have done this all wrong but the only thing I managed to do was create an Excel icon that linked to the entire Excel file. It did not insert the individual chart that I needed.

It turns out that what you need to do (having created and saved your chart in Excel) is to Copy it and then use Paste Special in Word. This then gives you a load of useful options such as linking to the originating chart so that when data is updated in Excel, it automatically updates in Word too. The chart will then be pasted where you need it and it renders much more clearly doing it this way.
So please, if you are trying to insert a chart or a table of data into Word from Excel, use Paste Special!
I found this rather marvellous advice by searching on Google and following some search results to a couple of training tips from academic institutions on how to do this.

Tuesday, 15 April 2008

Benefits of tai chi

I have recently started to go to tai chi classes and I have to say that I really enjoy it and and I feel that it has great benefits.
My class is made up of a small mixed bunch of people of all different ages and backgrounds and it has a very amicable, relaxed atmosphere.
Tai Chi is a very gentle form of exercise which is beneficial even for people suffering from chronic conditions such as heart disease and arthritis, however you do feel after a class that you have strengthened and stretched the old muscles and the breathing technique is great not only for relaxing, but I have found it useful for other sports too such as swimming.
Aside from the physical benefits, I find the Qi Gong very relaxing indeed and I always come out of a class feeling both very relaxed and like I have really toned up!

Eeey Aye, Eey Aye, Eey Aye Oh.....

... up the Premier League we go (and not before time!)
I don't know how or why things have just clicked in place with Newcastle United since my last blog entry about them (despite my friend, a Fulham fan, claiming lucky charm status after seeing Birmingham City v NUFC) , but we are now playing some good, solid, attractive football which has been a pleasure to watch. Obafemi Martins has been so fast, composed, and threatening; Michael Owen has been back to his old form and Viduka has made some great contributions. One of my most impressive players this season though has been Habib Beye, a very solid, pacy defender who can pass a ball very well and isn't scared to have a pop. I never thought I'd say this, but thank you, Sam Allardyce.
Long may our current good form continue, especially against the great Unwashed in Sunday's derby game.
Howay the Lads!

To Glastonbury or not to Glastonbury? That is the question

And the answer from my point of view is 'of course I'm still going!'
Don't get me wrong, I can see people's reason's for not going, such as they can't face that much mud again, the headliners are at best uninspired, the ticket system is a mess and it is expensive, BUT I love Glastonbury for all the other mad smaller stages and the overall creativity of the place.
My 2 favourite gigs last year were Neville Staple in the Dance tent and Dreadzone in the Glade. Oh and Iggy and the Stooges were just brilliant on the Other Stage. Combine this with the Greenfields, a laid back and happy atmosphere, bumping into someone you haven't seen for 15 years in a tea tent, and having a tequila slammer served by a full-on Moulin Rouge tart, and I'll be back again. Well that and the fact that we get to spend a whole 5 days with a large Geordie encampment. We're up to 44 in numbers this year. Yep, 44 AND pear cider!

benefits of seeing your dissertation tutor

As I'm sure I have already mentioned, it can be a rather lonely process doing your Masters degree dissertation by distance learning. It is also hard to keep up momentum sometimes, so I found it really beneficial going to see my tutor last week.
We discussed my dissertation in general and talked through a particular issue that I have at the moment. I came out of our meeting feeling confident and in full control of my dissertation again, with a good plan of action.
Thank you!

Long time, no blog!

Sorry everyone / World,
It's been ages since I last blogged and time just speeds past at the moment. So much has happened too; I've got some more work done on my dissertation, Newcastle United are on a winning streak, Glastonbury didn't sell out and I've discovered Tai Chi. Phew!

Friday, 14 March 2008

Designing interview schedules and questionnaires - great resources

Many of my fellow students and I are starting to prepare for the 'hands on' elements of our research where we will be conducting interviews and / or questionnaires with a wide range of people.

Designing a good interview schedule and questionnaire is a fine art, and I found this fantastic website from Professor T.D . Wilson on this very subject. Here, Professor Wilson outlines the benefits and pitfalls of various types and approaches to interviews and techniques, and there are some really practical tips too. I have found this a most useful resource.

In the meantime, it's a while since I wrote about Newcastle United. What can you say? We continue to walk a relegation tight rope and we don't instil a great degree of belief in the fact that we can turn this around.
My top tip is that 4-5-1 just doesn't work; stop it right now! If Chelsea couldn't effectively play with Drogba in this formation we certainly can't, especially with one of the shortest teams in the premiership.
I'm off to see the Lads on Monday, v Birmingham City and as usual they will receive great support from our travelling fans. I just hope that the potential absence of James Milner won't impact too heavily on the team as I view him as a key player. Player 4.4.2 though, perhaps bringing in Shola to complement Owen and / or Martins, and we could do this you know. Now is the time to turn it around Lads.
Howay, you can do it!