100 Top Tips: Microsoft Excel
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
30 October 2024
For my latest article for the BBC, I researched green software, which is software that makes efficient use of energy and hardware.
I have a keen interest in tech sustainability (see my previous articles on reducing website carbon emissions, digital product passports, and hard drive recycling). I have noticed the impact that software has on the life of hardware. I have an iPad Mini that works beautifully, except that the OS can't be updated now and so some apps refuse to run. It's becoming gradually unuseable as software support fades away, even though the hardware could last a lot longer.
The Green Software Foundation has created the Software Carbon Intensity (SCI) specification, which helps to measure the carbon footprint of software. You take the energy consumed by the software (in kilowatt hours), multiply it by the amount of carbon emitted by your energy source (in CO2 per kilowatt hour), and add the carbon emitted through the hardware the software is running on.
In this way, the equation counts the carbon emitted as the software runs, and the carbon resulting from the lifecycle of end-user devices too. There are several ways you can drive down carbon emissions, reflected in the SCI score. You can:
Importantly, you cannot game the SCI score by using carbon offsets. The score only goes down when your software's carbon intensity goes down.
The SCI calculation works on a unit scale like per user or per minute. “If your company’s doing well, it’s selling more of what you’re creating and your carbon emissions are increasing,” says Asim Hussain, executive director, Green Software Foundation. “What you need is a rate. If you’re [a video conferencing company] during Covid, your emissions would’ve shot up, but your carbon per minute should be going down year by year. That’s what you should focus on as a software team.”
Calculating the SCI necessarily requires estimation. How accurate is it? “I don’t agree that there’s a number that’s correct,” says Hussain. “When organisations are revealing numbers, they’re not counting carbon molecules in the atmosphere. They’re using their own models, which have their own assumptions baked into them. But if you’re fully transparent, you can’t be accused of greenwashing.”
To dig deeper into the issues, I took the Green Software Foundation's free short course on green software, which provides an excellent introduction.
Read my article on the BBC website: The green software that could make big carbon savings.
This is an important and interesting topic, so I hope to have an opportunity to write about it again in the future. Subscribe to my occasional newsletter for updates on all my writing and creative projects, including any future pieces about green software.
Permanent link for this post | Blog Home | Website Home | Email feedback
10 October 2024
I was fascinated to discover how being a police officer, astrophysicist or arts graduate helps to build a solid foundation for a career in cybersecurity.
For my latest article for the BBC's Technology of Business site, I interviewed people who had changed from markedly different careers into cybersecurity. The common thread was how valuable skills from other careers are in cybersecurity. That could be the ability to assess risk learned on the beat in Scotland, the skills to process huge amounts of data learned while studying galaxies, or the attention to detail developed in a personal assistant role.
With a shortage of four million cybersecurity professionals worldwide, the Chartered Institute of Information Security (CIISec) is advising companies to hire based on skills. “A lot of security is about people, process and technology," says Amanda Finch, chief executive, CIISec. "When we do our survey of the skills we’re short of each year, technical skills come out lower than communication, analytical and problem-solving skills.”
Some companies clearly are hiring for transferable skills: 41% of companies are trying to switch non-technical people into cyber-security roles within the company, and 39% of new cyber-security employees came from a non-IT role.
Together with my previous article on getting into tech without a degree, I hope my new article on cybersecurity careers will inspire readers to consider tech careers, whatever their past experience.
Permanent link for this post | Blog Home | Website Home | Email feedback
© Sean McManus. All rights reserved.
Visit www.sean.co.uk for free chapters from Sean's coding books (including Mission Python, Scratch Programming in Easy Steps and Coder Academy) and more!
Power up your Microsoft Excel skills with this powerful pocket-sized book of tips that will save you time and help you learn more from your spreadsheets.
This book, now fully updated for Scratch 3, will take you from the basics of the Scratch language into the depths of its more advanced features. A great way to start programming.
Code a space adventure game in this Python programming book published by No Starch Press.
Discover how to make 3D games, create mazes, build a drum machine, make a game with cartoon animals and more!
Set up your Raspberry Pi, then learn how to use the Linux command line, Scratch, Python, Sonic Pi, Minecraft and electronics projects with it.
In this entertaining techno-thriller, Sean McManus takes a slice through the music industry: from the boardroom to the stage; from the studio to the record fair.