Data Fellowship – BCS Level 4 Certificate in Data Analysis Tools


, , ,

I know that I haven’t posted into my blog in a while. Mainly because I have been busy with my Data Fellowship and a few other things. Recently I have been studying for todays exam “BCS Level 4 Certificate in Data Analysis Tools” – QAN 603/0824/2.

The ability to still take exams at home (under exam conditions), is a bit more relaxing than having to take a journey to get to an exam centre, but still just as unnerving as you complete and press the end exam button awaiting the mark. The ability to take exams at home, still under the same conditions with cameras on and screen shared does open the ability to obtain qualifications up to more people and fit them in better around a normal working day.

The objectives of this part of the course/exam are:

  • Explain the purpose and outputs of data integration activities
  • Explain how data from multiple sources can be integrated to provide a unified view of the data
  • Describe how programming languages for statistical computing (SQL) can be applied to data integration activities, improving speed and data quality for analysis
  • Explain how to take account of data quality when preparing data for analysis, improving quality, accuracy and usefulness
  • Explain the nature and challenges of data volumes being processed through integration activities and how a programming approach can improve this
  • Understand testing requirements to ensure that unified data sets are correct, complete and up to date
  • Explain the capabilities (speed, cost, function) of statistical programming languages and software tools, when manipulating, processing and cleaning data and the tools required to solve analysis issues
  • Explain how statistical programming languages are used in preparing data for analysis and within analysis projects

Source: Syllabus

Exam passed and now on with the final submission of my Project Portfolio and Synopsis Project.

Using the best of the Q Continuum



Everyone should have heard of / used the term IQ in relation to Intellectual Quotient or EQ in relation to a person’s Emotional Quotient Which is measured using a standardised set of tests to measure human intelligence. A Quotient is the degree or amount of something.

If you were looking for something on the new series of Picard and Q sorry, however I am looking forward to watching it. The use of Q (Quotient) today can now be used to measure a range of things from Body to Managerial and there is a Q for most of the letters in the alphabet. Below are some of the key ones to be aware of

AQ – Adversity Quotient is used to show the ability of a person to deal with adversities in their life.

BQ – Body Quotient is used to show your whole-body health.

CQ – Cultural Quotient is used to show and improve effectiveness in culturally diverse situations.

CQ – Curiosity Quotient is used to show how powerfully motivated someone is to learn about a personally interesting subject.

DQ – Decency Quotient is used to show how a leader has the genuine desire to do the right thing and wants something positive for everyone. Ensuring everyone feels respected and valued.

EQ – Emotional Quotient is used to show the ability to perceive, use, understand, manage, and handle emotions.

IQ – Intellectual Quotient is used to show a person’s intelligence using a standardised set of tests.

MQ – Moral Quotient is used to show understand right from wrong and to behave based on the value that is believed to be right.

PQ – Physical Quotient is used to show self-awareness and how well attuned you are to your physical wellbeing.

SQ – Spiritual Quotient is used to indicate spiritual parallels with IQ and EQ

There are many others, some not as mainstream within people’s knowledge. There are many articles around each of the Quotients and which make a rounded person. For me its all of them:

AQ + BQ + CQ + DQ + EQ + IQ + MQ + PQ + SQ = Well Rounded Person

Below are 5 Self Reflection questions to ask yourself

  • After reading the list above how many of these are you aware of?
  • Which of these do you use today?
  • Which will you use going forward?
  • Which is your strongest quotient?
  • How will you bring all your quotients up and be aware of them?

Importance of Regular Screen Breaks


I can remember sitting in class and hearing the teacher saying “Hemingway! Stop day dreaming and looking out of the window!”. Forward many 10’s of years to the weekend just gone and my optometrist saying, “Mr Hemingway, You need to look out of the window more!”

Sitting in front of a computer screen all day has caught up with me. Especially driven in recent times with video calls.

So why look out of the window more, Meibomian Gland Dysfunction (MGD) is when the eyelid glands don’t produce enough oil to stop the watery layer of the tears from drying out. You don’t blink as much when your looking at the screen for a long time. There are a lot of other factors that can play into or cause MGD, however screen time is the most likely for me.

I have a mild case which is treatable with a warm flannel or warmed Eye Bag and some gentle massaging eyelid to help release the tears as its been caught early enough. If left and nothing done could become more serious in time.

The exercise I was given is a 20:20:20 – look out of the window every 20 minutes at something more than 20 yards away and blinking 20 times.

Taking regular breaks is a must, even if to look out of the window regularly.

A timer on the desk now counts every 20 mins so I can get a reminder when head down in a screen concentrating.

Repairing Mobiles just got easier


How many people drop a mobile and crack the screen every day? In 2017 O2 reported that around 7.5 million people have a broken screen. Today I suspect that this is a lot higher today.

Screens are one of the most the in demand repairs that are carried out today. In some cases the phone can only be repaired by a manufacturer or authorised repairer. Cost is always a factor and some look for cheaper options or the ability to repair it themselves.

The ability to purchase spare parts for mobiles has been available for a long time from online places like eBay and manufacturers have found ways to stop the home repair and unauthorised repair markets such as by adding in device ID’s onto each hardware component and tying these to the main board so it stops working once you swap a part out.

Things are changing with Apple now announcing the ability to soon purchase spares from Apple Repair Shops with 200 parts available for the iPhone 12 and 13.

This is a great move towards the goals of sustainability as devices will be able to be repaired more easily and the broken parts can be returned to Apple as stated in their announcement – “Following the repair, customers who return their used part for recycling will receive credit toward their purchase.”

Online forums and videos have made repairing devices easier as you can follow a set of instructions or watch someone else doing it. An example of a repair video Apple Broke iPhone 13 Screen Repairs.

The better part is that the parts can come with a manual to help you repair, which will provide an official way to do this.

With the drive to be more sustainable and pressure mounting on recycling techniques and sending items to land fill companies are providing better ways at recycling. The Royal Mint is building a smart phone recycling centre to extract metals such as gold from phones.

It would be good to see other manufacturers allowing the ability to repair devices by providing spares.

So is it easier to repair a phone? It will be easier to obtain parts and instructions, however repairing a phone is still a challenge due to the many connectors and cables between the boards and components together. Care is needed if undertaking this as you may cause other damage during the process.

Further Reading

Looking at upcycling a mobile phone

Social Engineering on Social Media



Opening my social feeds this morning for a quick browse over a cup of coffee and some toast, it doesn’t take long of scrolling down to find a post asking “What was the first car you owned? No Lying <laughing emoji>”. This post has 61k likes, 959k Comments and 8.4k shares and was only posted on 9th August. And people wonder why they get hacked.

Password systems for a long time have used a similar set of questions as they are usually easy to answer and remember, because they were life events. Questions such as:

  • What is your mother’s maiden name?
  • What is the name of your first pet?
  • What was your first car?
  • What elementary school did you attend?
  • What is the name of the town where you were born?

These types of social engineering data gathering posts are nothing new, but it would seem that people do not understand the greater risks around answering them.

With the large amount of data appearing on the dark web for usernames and a persons details (even if they don’t contain passwords) matching this data with the answers from social posts such as the one above gives a potential hacker more information about you. They now have the ability to reset your password using the answers you have provided to the security questions and take control of your accounts.

How many of you reading this post have answered the question similar to “What elementary school did you attend” or anything to do with education, but forgot that the same information is already lurking in your LinkedIn profile?

One way to check if your in any data on the dark web is to check using your email address at a service such as

If you see a family member or friend post these types of questions on social media, it may be worth a conversation with them to advise of the dangers of such posts and the consequences of social engineering.

Tips to stay safe

Here are some tips for staying safe with your identity.

  • Don’t answer these types of posts on social media, even if its a friend who has posted it.
  • Check your not using an answer to a security question that is already in your social profile.
  • Use fictitious information instead of real information, but something you can remember.
  • Treat these answers like passwords and think about adding complexity to them.
  • Use two factor authentication where it is available on a system.

Further Reading

BCS Fellows Technical Advisory Group (F-TAG)



I am both excited and honoured at the opportunity to be part of the first cohort for the BCS F-TAG (Fellows Technical Advisory Group). Looking forward to participating and helping to lead bringing my experience and knowledge as part of this group.

Aim of the F-TAG

BCS’ Fellows Technical Advisory Group (F-TAG) is a diverse selection of experts who will distil insights on cutting edge technologies to benefit the entire BCS membership, the wider industry and ‘UK plc’; F-TAG complements the work of existing boards and groups. Source.

F-TAG is made up of 25 BCS Fellows selected from diverse demographic and professional backgrounds; their expertise ranges from software testing to smart homes. Source.

Find out more at :

F-TAG Members:

Online Meetings – Be yourself!

Over the past year and a bit the world was forced online more that it was before and meetings in the most case became video calls. Some loved it and excelled, some we okay and some shy’d away from the camera completely for a number of reasons.

So not everyone wants to be in front of a camera and not everyone has a film studio set up and is broadcasting from their kitchen table – That’s okay. You use what you have to do the best that you can do. So what can you do to help yourself look better on the calls.

Be Yourself!

Most importantly is Be Yourself.

Relax. You are not presenting the news or interviewing a top senior official (Unless you actually are of course).

Be confident and have a positive mindset.

If you are camera shy, consider joining on camera to do the introductions, then turn the camera off.

Meetings will have a bigger impact when your on camera as your audience can see your reactions and expressions just as though you are in a face to face meeting.

Contribute to the call. Don’t forget to contribute to the call. That’s why your there.

Treat each call as a face to face meeting, it is but using video instead.

Reduce any distractions so you concentrate on the call in hand.


Try not to sit with a window directly behind you, especially with the sun shining as this produces a halo effect around you which does not look good to others on the call.

If you can’t move and don’t have blinds or curtains, then consider bring some light in front of you to counter balance the light behind you. You will need to do this even if you are using an in call backdrop.

Search for “led video light” on somewhere like Amazon for some good options. It doesn’t have to be expensive.

If you are using your phone to make calls, consider an “LED Selfie Light Stand”.


Knowing where your camera is on your device is important, it can make the difference between the audience looking up your nose and seeing your face at a good level.

Clean the lens. It can make a big difference, especially if you are using a phone.

If you are using a laptop and have an external keyboard and mouse, consider using a laptop stand to raise the camera or even an external camera on a stand to get a better shot.

If you are using a mobile, consider getting a stand for it if inside so you can keep the camera steady.


Also knowing where your microphone is on your device is and setting its sensitivity can ensure that you are heard okay and reduces any other background noises in your environment. Headsets with mics often have a mic set to only pick up the wearers voice only.

If you have an external mic, consider a windshield or pop shield to help reduce background noises.

This can mostly be controlled via your operating system device settings or for external mics and headsets the appropriate software/drivers may have options.

Remember your microphone has a mute option in the video calls.


Software in devices is very good at stopping feedback where you hear yourself speak on a call and the microphone is picking that up and replaying in over the top. Some people prefer to use an headset with inbuilt mic so they only hear the call in the environment you are in.


Most of the main video calling platforms now have the ability to place backgrounds behind you so the audience can’t see the area that you are calling from.

When using these it is important to remember that the software is using your camera to cut around your image and display the background behind you, so if you want to show something on camera, it may struggle and you may have to turn off your background to do this.

Test it out

Once you have a set up you are comfortable, test it out. There are options on most of the video calling platforms to do this, or set up a call with a colleague or friend to test out the set up and get some feedback.


Dr Lucy Rogers has produced a set of videos that were for her students, but would help anyone looking for some advice.

Speaking to an Online Audience – Tech

Speaking to an Online Audience – Voice

Speaking to an Online Audience – Content

Speaking to an Online Audience – You!

Data Fellowship – BCS Level 4 Diploma in Data Analysis Concepts


, , ,

As part of my Data Fellowship that I am currently taking, today I sat the first exam for “BCS Level 4 Diploma in Data Analysis Concepts” – QAN 603/0823/0.

The last exam that I took was in an examination centre where you turn up and sit at an already configured computer. This time I sat the exam at home in my dining room with camera and microphones on. Special software ensuring that my only windows open are the exam and meeting room with the invigilator watching me.

Sitting down getting ready for the exam, I hit that unfortunate moment of your laptop is about to reboot and install an operating system upgrade. Great timing! Just enough time to get another device loaded with the right software and logins to the required pages. Not a good start to entering an exam for the mindset, but all went well in the end.

Study for this stage of the Data Fellowship has been part of the apprenticeship course and objectives. For me it was a cementing of the concepts and bringing some areas up to date.

Objectives are: Demonstrate knowledge and understanding of Data Analysis and its underlying architecture, principles, and techniques. Key areas are:

  1. Explore the different types of data, including open and public data, administrative data, and research data
  2. Understand the data lifecycle
  3. Illustrate the differences between structured and unstructured data
  4. Understand the importance of clearly defining customer requirements for data analysis
  5. Understand the quality issues that can arise with data and how to avoid and/or resolve these
  6. Explore the steps involved in carrying out routine data analysis tasks
  7. Understand the range of data protection and legal issues
  8. Explore the fundamentals of data structures
  9. Explore the database system design, implementation, and maintenance
  10. Understands the organisation’s data architecture
  11. Understands the importance of the domain context for data analytics

Source: Syllabus

Exam passed and certificate issued. Now on with the next learning/revision for the BCS Level 4 Certificate in Data Analysis Tools.

Are you patching your network devices at home?


There is nothing more annoying when your working on your computer and that popup appears saying “Reboot Now to complete the patch”. Thankfully some vendors have got wise to this over the years and have added changes to update at reboot/shutdown or allow to to choose a time. Annoying as it is, these patches are important and should not be ignored or delayed too long before applying.

Padlock Gates

When you think about patching/upgrading what do you think of?

  • PC/Laptop/Tablet
  • Mobile
  • Network

The typical focus of home users is around the end device we use rather than the other parts of the homes IT infrastructure.

A lot of home users these days rely on service provided network equipment such as routers from their internet service provider, but are these kept up to date? A recent study by Which found that millions of routers are not updated to the latest patches or had weak passwords and providers have been stated that they monitor and update their routers.

If you have your own router on the end of a connection, time to check when it was last updated. If its a managed device you can usually log in to it and check the last patch applied date. Is it being updated?

A recent discovery of FragAttacks (attacks that exploit security vulnerabilities that affect Wi-Fi devices) have shown that it is possible to steal data from any WiFi network that’s not patched, however its not an easy attack to recreate and vendors have been issuing patches to protect against this. This highlights the need for patching and updates to not just your end user device, but network devices as well.

As per a previous blog post – Good practices to adopt are

  • Check the manufactures website for firmware or driver updates on a regular basis – All devices within the home
  • If the device software allows a check to be made for updates on a regular basis make use of the tool
  • Use strong passwords
  • Change any default passwords
  • Don’t use the same password on different systems
  • Use passwords on your video calls
  • Use a VPN if working from home
  • Turn on two factor authentication on applications that allow it
  • Use Anti-virus and malware apps

If this is all second nature to you that’s great, however it may not be to others. Reach out to your family and friends and talk them through what they need to do so it becomes second nature to them.

You are only secure as your last update/patch!

Further Reading

Looking at upcycling a mobile phone


Across the modern developed world, there are draws of old mobile devices in peoples houses and offices that are no longer used or in fashion. In some cases they are very old devices and in others the pull of the latest model has drawn the user to the new version or the software has stopped working on the older version.

By 2024 Statsia states there will be around 17.72 billion mobile devices operating in the world. That’s a lot of devices!

I will hazard a guess here and say there will also be a very high figure around the amount that will be still sat in desk draws.

Before I get onto upcycling I need to cover two areas – Recycling and Keeping up with the Neighbours


With the many recycling programs that vendors are putting in place the number of mobiles left outside of these programs is high. Mainly due to age of the mobile and damage to the device which makes it not worth anything for a person to send their phones in (main damage being to the screen). Yes I have a couple of these from family members that I need to get recycled.

“Smartphones are made up of around 30 elements, including copper, gold and silver for wiring and lithium and cobalt in the battery” Source :

There should be a bigger push to get these devices recycled to help reduce the impact on the earth and increase our sustainability. The main rewards for recycling a phone are for those that are mainly intact and hold some resale value. Once a phone has been dropped and damaged, to some its a thing that no longer holds value and therefore ends in the draw or hopefully not the bin.

There are some things that need to happen for users to help adopt this strategy:

  • Greater publicity around the value of the old phones
  • Guaranteed security of the destruction of data on the phone
  • Giving the user something back for recycling

Keeping up with the Neighbours

With new phones/models being produced each year how often do you hear things like:

  • “Oh the latest XYZ phone is out – I must get that!”
  • “Well I have a bit of damage on this phone so Ill get a new one as its coming out”
  • “We will no longer support that operating system version past dd/mm/yyyy”
  • “The cost of repair is quite high, its more economical to get a new one”
  • “Ohhh Shiny!!!”
  • “<Insert your own here>”
  • etc.etc.


Having had an android based phone for a number of years, I have been keeping an eye on what Samsung have been proposing since 2017 – Galaxy upcycling. However I haven’t heard much until recently with Samsung announcing the use of old mobiles being used with SmartThings Labs.

Reusing my old mobile devices as part of my home automation system to provide a number of screens and control points around the house appeals to me as I’m sure it would for lots of other people.

Rather than phasing out devices with operating systems that no longer work, having an option to reuse the device with a different operating system (changed) so it can operate as part of a home automation system would have massive appeal to the market and help drive the sustainability agenda. Okay, reduce the functionality of the phone to help secure it, but lets keep these devices useful with some code.

Okay so my screen may have a crack in it, but a screen protector over that and put into a cradle on the wall suits me fine.

So whats next? Dig out my old device, put some power in it and see what I can do with Home Automation.