Application Software and Productivity Tools

Application software is any program designed to perform a specific task for the user. It sits on top of the operating system — the operating system manages the hardware, and the application uses that hardware to do something useful.

There are many categories of application software, and the exam expects you to recognise them.

Productivity software is the most common. This includes tools you use to create and edit documents, spreadsheets, presentations, and databases. The classic example is Microsoft Office — Word for documents, Excel for spreadsheets, PowerPoint for presentations, Access for databases. Google Workspace (formerly G Suite) is the cloud-based equivalent: Google Docs, Sheets, and Slides. These tools let you write a letter, build a budget, or design a slide deck for a meeting.

Business software covers a huge range of specialised applications. Accounting software like QuickBooks or Xero manages invoices, expenses, and payroll. Customer Relationship Management (CRM) software like Salesforce tracks interactions with customers and leads. Enterprise Resource Planning (ERP) software like SAP integrates all departments — finance, HR, supply chain — into one system. These aren’t things you typically install on your home computer, but they are vital in an office.

Communication software includes everything from email clients (Microsoft Outlook, Gmail) to instant messaging apps (Slack, Microsoft Teams) to video conferencing (Zoom, Skype). These applications let people talk, share files, and collaborate in real time.

Graphics and media software is for creating or editing images, audio, and video. Adobe Photoshop is for photo editing, Adobe Premiere Pro is for video editing, and Audacity is for audio recording. Even simpler tools like Microsoft Paint or the Photos app on Windows count here.

Web browsers like Chrome, Firefox, Safari, and Edge are a special category. They are applications that let you access the internet — they interpret HTML and display web pages. The exam often tests whether you know that a browser is an application, not part of the operating system.

Utility software is a mixed bag. It includes antivirus programs (Norton, McAfee), disk cleanup tools, file compression software (WinZip, 7-Zip), and backup software. Utilities don’t create content — they maintain the system.

Specialised software exists for almost any profession. Architects use AutoCAD for drafting. Doctors use electronic health record (EHR) systems like Epic. Graphic designers use Adobe Illustrator. The list is endless.

How does it work in practice? When you double-click an icon, the operating system loads the application’s code into the computer’s RAM (Random Access Memory). The CPU (Central Processing Unit) then executes that code. The application might create files (like a .docx document) that are saved to the hard drive or SSD (Solid State Drive). When you close the application, it is removed from RAM, freeing up memory for other tasks.

Why does this exist? Before application software, computers ran only one program at a time using punch cards. Modern application software made it possible for anyone — not just programmers — to use a computer productively. You don’t need to know code to write a report; you just open a word processor and type.

The exam tests your ability to match an application type to its use case. For example, if a question says ‘you need to create a chart from sales data’, the correct answer is a spreadsheet application, not a word processor.

Imagine you work for a small marketing agency called Bright Ideas. You have five employees, a handful of clients, and a growing list of projects. As the only IT-support person (your boss asked you to ‘help with the computers’), you need to set up the right application software for the team.

Step 1: Identify the core need. The team needs to write proposals, create budgets, and design client presentations. You install Microsoft 365 — specifically Word, Excel, and PowerPoint. You set up a shared folder on OneDrive so everyone can access the latest version of a document.

Step 2: Communication. The team works remotely two days a week. You set up Microsoft Teams for instant messaging, video calls, and file sharing. You also configure Outlook for email and calendar sharing.

Step 3: Project management. A client wants weekly status reports. You introduce Trello, a project management application, to track tasks. Each project becomes a board, each task becomes a card. The team updates cards as they complete work.

Step 4: Accounting. The owner handles invoices using QuickBooks Online. You ensure it is installed on her laptop and connected to the company bank account. She uses it to send invoices, track payments, and prepare for tax season.

Step 5: Graphics. A designer needs to edit images for a social media campaign. You install Adobe Photoshop on her workstation. She also uses Canva — a simpler web-based application — for quick graphics.

Step 6: Security. You install antivirus software (Bitdefender) on every machine. You also set up backup software (Backblaze) that automatically copies files to the cloud every night.

Step 7: Troubleshooting. An employee complains that Excel crashes when opening a large spreadsheet. You check the application’s memory usage in Task Manager and realise the computer only has 8 GB of RAM. You advise upgrading to 16 GB. The problem is not the software — it is the hardware limit.

As an IT professional, you don’t just install software. You evaluate which applications the business needs, licences them properly, ensure compatibility with existing systems, train users, and troubleshoot issues. You also manage updates — a vulnerability in an application can be a security risk. For example, if Adobe Reader has a known flaw, you must update it across all machines to prevent malware infections.

A key task is managing software licences. Each application has an End User Licence Agreement (EULA) that defines how it can be used. Some are ‘per-device’ (one licence per computer), others are ‘per-user’ (one licence per person). Exceeding the licence terms can get the company sued. You keep a spreadsheet tracking which applications are installed on which machines and whether the licences are current.

Another real-world task is application virtualisation. Sometimes you need an older version of an application that doesn’t run on Windows 11. You might use a tool like Microsoft App-V to run it in a virtual environment, isolating it from the rest of the system. This is an advanced skill, but the exam may ask you to recognise that some applications require compatibility settings or virtual machines to run.

Finally, you perform application lifecycle management. When a new version of an application is released, you test it on a non-production machine (‘sandbox’). If it works, you schedule a rollout. When an application is no longer supported (like Windows 7’s built-in games), you plan its removal and replacement. This ensures the business is never running outdated, vulnerable software.