“How did you ever do without it?” asked the original ad for VisiCalc, itself the original spreadsheet app. Yet in 1979, that answer was more than self explanatory. Businesses the world over crunched numbers and kept their finances accounted on ledger paper—and spreadsheet software was a $99.95 tool for a $1,298 computer that few knew how to use. They’d get along just fine without VisiCalc—or so it’d be easy to think.
Today you can hardly get through a day without using dozens of programs. An alarm clock to wake you up, a fitness app to pace your workout, maps and transit and taxi apps to get you to work, news and music apps to hasten the trip—and that’s before you start a day’s work.
You already know the core apps, the Alarm and Browser and Calendars of the app store. But what about CRM and ERPs, product and project management tools, eCommerce and ePos software? You know how to write your own notes and chat with your friends, but where would a team write notes and collaborate?
Here’s a glossary to help—the terms you should be familiar with when talking about software with anyone.
The Six Types of Software
Using the bash command in Terminal to solve math—the simplest of software
This is software. Simple software, sure, but software that computed 12¹² far faster than I ever could on my own. Calculations like this were all an Apple II could do out of the box—and that’s what started the personal computing revolution. For software doesn’t have to be that smart—as Steve Jobs once described, computers simply take very simple instructions, do them insanely fast, and we think it’s magic.
Software. Program. Application. App. The same definition applies to all: a software program is “a series of coded software instructions to control the operation of a computer or other machine” according to the Oxford Dictionary. Your news app is software—it has instructions to connect to a news server, copy the newest articles, and present them on your screen. Spotify and Netflix? Yup, software that has instructions to stream media to your computer. Scripts—the bits of code that, say, tell your computer to dim your screen at 8PM—are software. Excel and Mathematica and Photoshop and AutoCAD are software—they have instructions to organize data and crunch numbers and tweak photos and draw blueprints. The latter might be more what we think of as software, but the former, simpler apps are as much software as the latter will ever be.
Web apps blurred the lines. Surely you can’t have software in a browser. Then 1995 came and proved them wrong with the first web apps, online maps and wikis and eCommerce tools that did as much as their traditional counterparts. Smartphones and tablets brought back the same debate—you can’t have real software and do real work on a touchscreen. But you can, we do.
Wikipedia lists three core types of software:
- System software, the operating system (Windows, iOS, Android, macOS, Linux, and so on) and utilities that run your device and make your computer function.
- Application software, the vast majority of software, what Wikipedia calls “the general designation of computer programs for performing tasks.” When you buy a new app, most of the time, it’s application software.
- Computer programming tools, including compilers, are what turns code into application software. These are often hidden from view, but they’re a crucial part of bringing new software to your devices.
From that stems the vast world of software we know and love. But the classifications don’t end there. The App Store offers 26 categories of software. Google Play, 22. Zapier’s business software focused Zapbook, 58.
And yet, you could summarize all of those down to 6 simple software categories—the broad categories of application software.
Software is best known for creating things (Apple Pages pictured)
Say software, and this is what people think of, the apps that help you make things. Photo and drawing tools to create art. Document and writing apps to build documents. Audio and video software to record and remix and release. Coding editors to keep the cycle going and build the next big thing.
AutoCAD and Adobe Creative Cloud, Microsoft Office and most other tools creative professional and engineers use. Code editors like Sublime Text, integrated development environments (or IDEs) like Visual Studio, and the computer programming tools like
gcc that compile code into new software—all the tools developers user to run the app economy. These are the programs that make the headlines.
Apps that connect us are why we carry computers in our pockets (Gmail pictured)
The software we open most often, though, might be communication software, the apps that connect us to each other. Email started it all with its quick electronic messages between university mainframe computers, before anyone could reasonably expect to own a computer, let alone carry one in their pocket.
Email turned to chat, which turned to social media—while Skype and FaceTime finally fulfilled the video phone dream. Every time you check Facebook, txt your friend group, and email your boss, it’s communication software that sends your messages back and forth.
Reading the news or binging a series? Yup, still software. (Spotify pictured)
Here there be dragons—and explosions, and symphonies, and silence. Here’s where the debate over what is software rears its head. But eBook readers, PDF viewers, news apps, media players are software too. Games fit here too; you might build something in the game, but for the most part you’re consuming an experience someone designed.
They’re perhaps not the software that fills most of your business day, but the are the software people will use to enjoy the things you build in creation apps.
Then, there’s a tricky app: The web browser. It’s by definition a viewer, a consumption app, something to view HTML code others created. Yet it can also run browser-based web apps today, making it another way to use each category of software. It’s today’s operating system (the code that runs your computer itself), in a way.
The software of movies—and real science (WolframAlpha pictured)
Want to map the human genome, chart a path to Mars, outbuild the Burj Khalifa, or automate a car? Computation software is what you’ll need. That’s where it all started—computers, after all, are machines to compute numbers. It’s in deep scientific research where the limits of silicon brains are tested, where they live their most meaningful lives. This is where machine learning and AI, tech’s favorite buzzwords, come into play.
Your computer is more than ready to do amazing things—and it’s competition software like Mathematica and R that make the magic.
You need software to keep your computer running, too. (macOS Disk Utility pictured)
File sync apps. FTP. Antivirus. That one app you installed to fix that rare problem you had last year. Backup tools. WinZIP. Search tools, and Google itself. The software that keeps your software humming away.
These apps aren’t fun, and they don’t feel very useful (except for Google), but they tie the loose ends together. They’re the software you have to use. They sometimes are system software, sometimes are application software, but their core purpose is to perform core tasks for your computer.
Database Interface Software
At work? There’s a good chance you’re using a database app. (MeisterTask pictured)
Then there’s everything else, all variations on the same thing. These are the apps that fill 90% of the categories in the App Store, the software that makes the business world go ’round.
It all starts with a database, “a structured set of data held in a computer.” Want to manage tasks, contacts, projects, sales, inventory, finances, rocketship tickets? You’ll need a database to store that data.
Add a form to enter the data, and a viewer to, well, view the data, and you’ve got a database powered app.
At their very simplest, most apps that store data fit this mold, everything from your notes and contacts app to a CRM or ERP system. They’re essentially different ways of storing and viewing data, with little tweaks to fit a specific workflow.
So that simplifies things. With those six core types of software in mind, you can figure out how almost any app works.
But you got to work, and you’ve been asked to use content from a DAM to fill out a LMS—and you wonder if your coffee’s kicked in yet or if your boss is talking nonsense. Nope. You just need a few more categories—1 to be precise—to navigate your way around the world of business software. Each starts out with consumer software, tools you likely already know, with bullet points to point out the main sub-categories and popular apps in those, and then digs deeper into the more professional subcategories of those same apps.
The 14 Core Categories of Business Software
Email apps are the original way to communicate digitally (Microsoft Outlook pictured)
Email’s the original way to communicate on computers, with a legacy stretching back over five decades. It’s simple and free as consumers, something we seldom think much about. Yet it takes a wide range of software to fill your inbox each morning.
The email apps most of us use—Apple Mail, Outlook, and more—are actually email clients or mail user agents (MUA). They’re apps to receive email, let you view and organize messages, and let you send emails through your message sending agent (MSA)—a service like Gmail, Outlook.com, or Exchange server that does the heavy lifting of actually sending your messages themselves. It gets even more complicated beyond that, with a message transfer agent routing the message and a message delivery agent putting the message in your recipient’s inbox.
What’s important is that it works. Almost magically, you can send and receive email with anyone else on earth, no matter which email client or sending service they use.
- Email Client (Apple Mail, Outlook): the standard mail apps used to view, organize, and create email messages.
- Email Server (Gmail, Exchange): the email service that runs on a server or web app, which sends and receives your email messages and often filters for spam or to organize messages.
Team email inboxes and customer support software let entire companies share one inbox (Zendesk pictured)
Your email client is perfect for personal messages, but frustrating if you need to share email. When someone emails your whole team, they have to send the message to everyone, or you have to forward the message to your colleagues.
That’s why many people have two inboxes at work. Their email client keeps their personal messages. Then, a team inbox app lets your whole company share one email address, perhaps
email@example.com. They look much like an email client, only this time, anyone in your team can see and reply to the messages in the inbox.
- Team Inbox (Hiver, Front, shared folders in Exchange): a shared email client app that lets multiple users share the same email inbox, typically with separate signatures per user so recipients know who on the team replied to the email.
- Customer Support or Help Desk Software or Ticketing System (Zendesk, Help Scout): advanced team inbox apps that include extra tools for documentation, standard email replies, and customer info that help your team respond to support tickets and emails requesting help. These apps also often include chat apps to talk to customers in real-time.
Send emails to multiple people at once, automatically, with email marketing software (MailChimp pictured)
Your email client only lets you email a few people at once; Gmail, for instance, lets you include 500 people in an email’s
BCC fields total. When you need to email someone, your email client is perfect. When you need to email all your customers, you need something else.
The simplest are email newsletter apps designed to send one email to a list. Say you want to let customers know when you release a new product. You’ll ask people to subscribe to a list, add that list of email addresses to an email newsletter app, and then use that app to design and send one email to everyone once.
As your company grows, you’ll want to personalize things, perhaps sending a different email to those who bought one product versus another. Maybe you need to send onboarding emails, or want to share tips with trial users to persuade them to buy your product? A marketing automation platform that sends drip emails will do the trick. It lets you design an email or set of emails that it then sends to each new person you add to your list automatically.
Your company will also need to send out routine emails often from your own apps: Receipts, thank you emails, notification alerts, and more. For those, you’ll use a transactional email service. It’s like the email server that handles your personal emails on steroids. There’s often no interface to see or send messages; instead, you’ll use an API (application programming interface) or its SMTP (simple mail transfer protocol) server to send messages in bulk from your internal software.
- Email Newsletter Software (MailChimp, Aweber): a tool to send bulk emails to a list of subscribers.
- Marketing Automation Platform (ConvertKit, ActiveCampaign): a tool to send a drip or scheduled set of emails to new people as they’re added to a list, typically to onboard new customers or send marketing messages.
- Transactional Email Service (Amazon AWS, Mailgun): a service to send bulk messages for businesses, often used to send receipts, notifications, and other automated email messages.
Chat apps are how we stay in touch with each other (Apple iMessage pictured)
Soon after email came chat, first as quick messages in Terminal to other users of the same computer in universities and companies. By the time personal computers and internet connections landed in our homes and offices, chat or IM—often using American’s internet provider AOL’s AIM software—was the quick, real-time counterpart to email.
Email’s for long messages that aren’t as time sensitive, the new paper letter. Chat’s the new phone call, quick short messages that have become the main way many of us communicate today.
- Chat or Instant Message (IM) (iMessage, Messenger): software to talk in real-time with others, in one-on-one conversations by default though often also with groups. Popular chat apps today often also include bots and other services to book reservations and purchase products through chat.
- SMS (short message service): individual 160 character messages sent through cell phone services. Often used for notifications or for chat without using an internet connection.
Team chat tools are an increasingly popular way to talk at work instead of using email (Slack pictured)
Chat’s not just for fun. What started out as AIM and turned into Facebook Messenger and iMessage are equally useful at work, only in slightly different software. Ever since Slack was released in late 2013, team chat apps have become the more popular way to at work. But Slack was far from the first team chat app; IRC or internet relay chat has been a popular way to talk to groups of people online for decades. You can even use the same technology with your customers, using live chat tools to solve issues and close sales without waiting on back-and-forth email conversations.
- Team Chat or Group Chat (Slack, Google Hangouts, IRC): software to chat with with an entire team together. Unlike IM software, team chat software is designed to chat with large groups by default, with every new group conversation being visible to anyone on the team. Often also includes individual one-to-one chat called direct messages (DM), and private group chats for smaller teams.
- Live Chat (Olark, Intercom): software to chat with customers and people outside your business. All chat apps are designed for live or real-time conversations, but software that’s branded as live chat is typically designed for support and sales teams to chat with potential or existing customers. Customers will start the chat conversation, and like a help desk app, your team will all see each conversation and can help reply to customers together with a chat conversation.
- Transactional Messaging or Programmable SMS or Push Notifications (Twilio, Amazon SNS): much like transactional email apps, these tools use the same technology as SMS or team chat apps to send automated SMS, chat, or push notification messages to your customers. You could tie them in with a live chat service to reply in real-time, or you could use them more like a drip email service to send messages to potential or new customers.
The office phone’s not dead—it just moved to your computer (Dialpad pictured)
If the telegraph brought us chat and email, the phone did one better. It managed to keep the same name while morphing into new technologies. We’re far from sending voice through sparks on copper wire—but the same ideas of dialing a number and talking to someone else still work the same. Only this time, there’s a lot more software in-between.
Truth be told, anytime you make any phone call on a modern phone, it’s software dialing the number, routing the call, removing background noise, and more. Then there are fancier phone apps. Your smartphone’s built-in Wi-Fi calling—or services like FaceTime and Google Hangouts—do away with normal phone numbers and make calls just another digital communication. Those same tools work at work, so you can talk through problems and accept office calls from anywhere with an internet connection.
- Voice Over Internet Protocol (VoIP) (Skype, Vonage): software to make calls over the internet, from simple one-to-one call apps like FaceTime Audio and your phone carrier’s Wi-Fi calling to the advanced phone systems below.
- Virtual Phone Systems or Private Branch Exchange (PBX) (Dialpad, RingCentral): tools to route an entire company’s calls through software. Instead of a switchboard, these software let people call one number and enter an extension or ask for a person or department, and then route the call to the right person.
- Cloud Communications Platforms or Phone APIs (Twilio, Nexmo): service to build phone features into your software, often to make automated phone calls or let you build a virtual phone system into your software.
- Fax Software (HelloFax, Windows Fax and Scan): similar to email software for the original electronic mail system, fax software lets you send and receive traditional faxes from your computer, using a web service or a phone modem to send and receive the fax data—either way, via the traditional phone network.
Video Calls and Chat
Video conferencing apps help remote teams work together (Zoom pictured)
Video phone calls were the original future, one of the earliest promises of how tech would make our lives better. And now, they’re so commonplace, you likely have a half-dozen apps on your phone that could make video calls.
When you need to make a video call at work, though, you might still need something new. Basic consumer-focused video call apps typically let you talk to one other person—plenty to add video to your standard phone calls. Need a team of fifty to gather around a virtual table and talk through problems? You’ll need a video conference tool that can handle the load. Then, slightly confusingly, web conference tools are designed for even larger audiences—they’re video conferences with only video from the speaker, streamed to hundreds or thousands of viewers for an online conference or lecture.
- Video Calls or Videotelephony (FaceTime, Messenger): the simplest apps for video calls, typically designed for one-to-one calls with full-screen video of the person you called.
- Video Conferencing (Google Hangouts, GoToMeeting): advanced video call software designed for 2+ participants, often showing a video of the current speaker or live videos of everyone in the call. These apps typically include a text chat to share links and notes, along with screensharing tools to show a presentation.
- Webinar or Web Conferencing (WebEx, Livestream): software to stream a video call to a large number of viewers. Instead of showing the video of everyone on the call, web conferences are often one way, showing only the speaker’s video, presentation, and/or screen—with text chat for viewer participation.
Social media isn’t just for fun—it’s an important way to market your products, too (Buffer pictured)
Phone calls are typically private, as are individual emails. Chat expands things to groups, with everyone in a friend circle or professional team talking together. Social networks take things to the next stage. They’re much like a public email or long-form chat room where everyone shares their own thoughts—and today are the way many of us stay in touch with the people we know. These tools, too, are software—software you’ll use at work, spuriously to check Facebook during a quick break, or professionally to perhaps share your newest products online.
- Social Networks (Facebook, Twitter): software to let users share updates, photos, and videos about their life, and follow friends and brands to see updates that they post.
- Social Media Management (Hootsuite, Buffer): software to help companies use social networks professionally, typically designed to combine multiple social networks into one interface and let users schedule posts in advance.
- Blogs (WordPress, Medium): specialized content management system built to publish new content in reverse chronological order, almost an early long-form social network with only approved contributors.
Your computer can make sure you don’t lose track of time (Google Calendar pictured)
There’s stuff to do, and not nearly enough time to do it all. A paper calendar on the wall isn’t nearly enough to manage your schedule today when people are booking appointments with you at all hours. Calendar apps help make sure you don’t forget what’s coming up next—and the best newer calendar tools can help people book appointments only when you’re actually free. It’s how to avoid those endless Would this time work? emails.
- Calendar Apps (Google Calendar, Apple Calendar): database apps that list events and appointments and show them on a calendar interface, often with a simple to-do list to track tasks.
- Time Tracking (Harvest, Toggl): advanced timer apps to log time spent on work projects, often with tools to turn tracked time into invoices. Variants include pomodoro apps to remind you to take breaks during the work day, and personal analytics software like RescueTime that tracks every task you do on a computer throughout the day.
- Appointment Scheduling Software (Acuity Scheduling, Calendly): specialized calendar apps combined with a form where clients and colleagues can book an appointment with you at a time your calendar lists you are free, often with payment processing integration to book paid appointments.
- Event Management Software (Eventbrite, Meetup): specialized appointment scheduling software for meetings with large groups of people, typically with options to reserve seats and purchase tickets to the event.
You’ll meet more people than you can remember—so let your computer remember for you (HubSpot CRM pictured)
Your email app would be far less useful without the handy sidekick it usually comes with: a contacts app. That’s why few of us remember phone numbers and addresses today. It’s easier just to tap Bob’s name on your phone than to remember his number.
That problem’s only worse at work—which is where CRM apps come on. They’re contact apps on steroids, designed to keep track of everyone you meet, what you said to them, and how they’re related to other people you’ve met.
- Address Book (Google Contact, Contacts): database software to store contact information, typically with tools to sync with social networks or to scan business cards.
- CRM (Customer Relationship Management) (Salesforce, SugarCRM): advanced contact apps built around managing the relationships between contacts and companies, often with project management-style features to track potential deals and client projects. Specialized versions include Patient Data Management Systems (PDMS) for healthcare, Supplier Relationship Management (SRM) and Supply Chain Management (SCM) for manufacturing, and more. Often tied to ERP or Back Office software to link customer data to other parts of the business.
- HR (Human Resources) or Human Capital Management (HCR) Software (BambooHR, SAP HCM): specialized CRM software to manage a company’s employees with contact, compensation, management structure, and other important data.
Need to write something down—and print it out? These are the apps for you. (Microsoft Word Pictured)
Odds are, a document app was one of the first computer programs you ever used. Software like Microsoft Word is ubiquitous everyone from schools to boardrooms, used to write simple documents and polished thesis alike. And its text editor and publishing relatives let you put your ideas down on digital paper and create something new—or just turn your computer into a fancier typewriter.
- Text Editor (Notepad, iA Writer): software for writing plain text without formatting, much like a typewriter would have offered before computers. You can write, edit, and view text—but cannot add any formatting beyond typing special characters.
- Word Processors (Microsoft Word, Google Docs): software to make formatted documents, typically designed around a standard paper-sized document. Word processors today let you design most standard documents quickly with formatting and graphics tools, along with writing aids including spelling and grammar checks and auto-correct. And their newest versions work online so you can edit documents collaboratively.
- Outline Apps and Mind Mapping Software (OmniOutliner, MindManager): specialized word processors built around listing ideas and organizing them into an outline, typically with options to collapse sub-points and notes to see the larger structure. Often include mind mapping tools as well to visualize the outline ideas graphically instead of in a list of text.
- Writing Apps (Scrivener, Ulysses): word processors designed for writing longform works that often span multiple documents. They’re almost more similar to the notes apps below, but with a stronger focus on text formatting and organization, and are the software most used by authors and journalists for longer writing tasks.
- Desktop Publishing Software (Microsoft Publisher, Adobe InDesign): a mix between word processors and creative software, these apps help you lay out text and graphic elements on a page. Typically used to design banners, brochures, books, and other text documents that need more formatting than a word processor offers.
Word processor files and text documents are easy to lose—so a notes app helps you catalog them (Evernote pictured)
Here’s where we finally meet databases (though some earlier mentions including email apps include a database to store your messages, too). Take a word processor, add a database, and voilà: You’ve got a notes app.
Notes apps come in all shapes and sizes, for personal and public use alike. You might use one to store your thoughts and ideas, the things more likely to get lost if you just saved them on a random Word file. In your team, you’ll use them to share ideas and teach customers how to use your products. You could always go back to a standard word processor, but the search and organization features the database adds makes your digital text that much more valuable. And at last your text isn’t tied to a fake A4 sheet of paper.
- Note Taking Apps or Bucket apps (Evernote, OneNote): simple text editor or word processor apps combined with a database to store all of your notes—along with photos, recordings, and related files—in one place that’s easy to search through. You can throw anything in them and still find it easily, leading to the nickname bucket app.
- Knowledge Base (KB) or Help Documentation (Intercom, Zendesk): a public notes app designed to show information and instructions about a product online. The notes are written by your team, then your customers can read and search through them online from your documentation website. Often included as part of email customer support software.
- Intranet or Knowledge Management Software (Confluence, Microsoft Sharepoint): notes apps designed for teams, these tools help you list best practices, internal process workflows, HR guidelines, and other important internal company information.
A content management system helps you organize your public writing—or could be an advanced notes app (WordPress pictured)
The original word processors were designed to make documents that you’d print on paper. That was the primary goal. Today, you’re far more likely to share your document online, and you need a new word processor to make that possible.
Content management systems are notes apps for the web. They’re database-powered software that help you write blog posts and webpages, and also make it easier to manage them. Or, opt for a wiki, and let the entire world help you write your website.
- Content Management System (CMS) (WordPress, Drupal): a database powered document tool—somewhat like a more advanced notes app, typically to run a website. CMS typically help you organize content with categories and tags and publish it on a public website. Instead of writing individual HTML pages for a site, the CMS turns your website into an app where it’s easy to add and edit posts and pages.
- Wiki (MediaWiki, PBworks): a content management system where any reader can edit the text of any document or add a new one; from a Hawaiian word meaning quick. One of the first web apps was a wiki—WikiWikiWeb—and decades later MediaWiki powers Wikipedia, the world’s largest encyclopedia. Often used internally as knowledge management software.
- Learning Management System (LMS) (Moodle, Teachable): a specialized content management system for education, LMS include standard content tools to add lessons and lectures, along with tools to manage students and track their progress through a course.
Files and folders are still pretty important (Box pictured)
Countless apps have promised to replace files, with databases storing all our data and making it easier to find things. And they have, for some things—there are no reason to keep contacts and notes on individual files when you could use an address book or notes app instead. For many other things, especially larger projects like long-form documents, videos, and graphics design work, traditional files still reign supreme.
Your computer’s file manager app is enough for your personal files. At work, though, you’ll need a wide range of file tools to share data and get the files you need in the places they should be.
- File Manager Application (Windows Explorer, macOS Finder): the software typically built into a computer’s operating system to manage files on the computer’s storage. Traditionally uses folders to organize files; today you can use tags and other metadata (or details about the files) to sort and group files.
- File Sharing or File Synchronization (Dropbox, Box): similar to an online file manager, file sharing apps sync files and folders to an online storage service (often called the “cloud”), your other devices, and devices of friends and colleagues you’ve shared files with.
- Cloud Storage (Amazon S3, Google Cloud Storage): simplified online storage, cloud storage services are built to save files online without the sync or sharing features of a file sharing app. They’re best for archiving your company’s data—think of them as external hard drives you access online.
- File Archiver or Compression Software (WinZip, ImageOptim): software to shrink a file’s size and make it take up less storage space, either by saving the files in a compressed ZIP folder, or by optimizing the file’s format (typically with image, video, and audio formats to decrease file size at a small loss of quality).
- File Format Conversion (CloudConvert, Handbrake): software to convert a file from one format to another, typically specialized on one type of file (say to convert a Word document to PDF, or a WAV audio file to MP3). It’s the software you want if you have a file that won’t work with your software.
- FTP (File Transfer Protocol) or File Transfer Software (Transmit, Cyberduck): tools to copy files between computers, typically used to upload files to a server. Traditionally used with FTP or SFTP, today’s file transfer apps often work with file sharing and cloud storage services as a more powerful file explorer that works with both local and remote files.
- Backup Software (Time Machine, Backblaze): software to store a separate copy of your files on an external hard drive or cloud storage, typically with versions of each change to a file, to restore your data if your computer or hard disk fails.
- Media Player or Media Library or File Viewer (Apple Preview, Spotify, Netflix): a broad category of software to view and playback files, often with a library to organize and select files to view. Everything from basic playback tools like VLC or iTunes to modern streaming services like Netflix and Spotify—or the Word and AutoCAD Viewer apps to preview specific files and eBook apps like Kindle and iBooks—all perform the same job: showing files that were created in other apps.
Forms and surveys let you quickly gather data and see what people think (Wufoo pictured)
You need info. These apps are the way to get it—and organize it, and draw conclusions from it. You’ll start with a form or one of its many variants to gather data, a database or spreadsheet to store it, and then will dig through the data to find trends and learn from it.
In many ways, these apps are the core of every database-powered app. Take an address book. You have a form to enter an address, a database to store it, and a viewer to see all the addresses in the database. You could use these apps to build your own apps—without coding. It all starts with some way to gather data.
- Form Builder (Wufoo, Typeform): software to gather data, typically with a variety of field types to build forms that can gather detailed info including files and images.
- Survey Software (SurveyMonkey, SPSS): specialized form software built for asking survey questions, often with built-in questions to help you remove bias from answers.
- Poll App (Polldaddy, Twitter Polls): a survey with a single, multiple-choice question for a quick way to get feedback on a single item.
- Remote Data Collection (Device Magic, Fulcrum): form software designed to work on mobile devices even when offline to gather data from job sites, often with mobile focused features for geolocation, barcode scanning, and signatures. You’ll also find specialized software for each of these tasks, with dedicated barcode scanners, photo apps, weather monitors, and more that gather data from a sensor and store it on your computer.
- Analytics Software or Monitoring Software (Google Analytics, Pingdom): software that watches your application or equipment for data—website visitors, reliability statistics, even temperature or air pollution monitoring.
- Scanner Software (Prizmo, Windows Fax and Scan): software to gather data from paper documents by scanning or taking a picture of the document, typically with OCR (optical character recognition) to recognize text and enable copying text from the document.
- Dictation Software (Dragon NaturallySpeaking, Google Docs Voice Typing): an alternative to your keyboard, dictation software recognizes your voice and types out what you say for an easier way to input data to your computer; typically built into newer computer and mobile device operating systems.
Data Storage and Manipulation Software
Use a database or spreadsheet to store and organize your data (Airtable pictured)
Once you’ve gathered your data, it’s time to store it and put it to work. Most form software and data gathering tools include a simple way to view your data. For more power, though, you’ll want to store the data in a spreadsheet or database where you can sort and organize the info, crunch numbers, build charts and diagrams, and figure out what everything means. Maybe you’ll want a dashboard to visualize it and build reports, or will need computing and big data software to turn the data into action.
- Spreadsheet Software (Excel, Google Sheets): a special document laid out in a grid, designed to calculate values. Similar to a document app, they’re the direct replacement of paper ledgers used for decades to list sales and do accounting by hand. Spreadsheet software adds smarts to it, with functions to automatically compute values and format text. They’re how you’ll use your form data, most likely.
- Database Management System (DBMS) (MySQL, Microsoft SQL Server): software to manage databases, or structured sets of data. These tools include the databases that power many of the CRM, CRM, and other database-powered software, and can also be used to store and sort data on their own.
- Database Application Builder (Airtable, Microsoft Access): simplified database software built around a form to gather data, a spreadsheet-like database to organize data, and charts or tables to view data. These tools make it easy to build your own basic database-powered software without coding.
- Dashboards or Visualization Software (PowerBI, Cyfe): similar to the charts and diagram tools built into spreadsheet apps, these tools let you create visual representations of your data often in a dedicated screen or report to easily see trends.
- Computation or Numerical Analysis Software (Mathematica, R): the software that makes the
computer real, these tools let you solve math, find trends in data, and do advanced scientific research.
- Big Data or Data Mining or Machine Learning (OpenRefine, BigML): a broad category of software designed to organize, store, sort, and find trends from large datasets—similar to tools a spreadsheet would offer, only for far larger sets of data than Excel could handle.
Here’s where Computer Science and Liberal Arts meet (Adobe Photoshop pictured)
Design software—the tools that bring electronic music, animated films, Photoshopped images, and the intricate icons on your phone’s home screen—are technology at its most creative. People have painted murals and composed symphonies for generations. Computers revolutionized it, letting you compose and listen to your symphony at the same time, or animate your concept art into lifelike video. These are the tools you’re most likely to see showcased whenever a new computer is released—they look good.
- Image Editor or Graphics Editor (Adobe Photoshop, GIMP): raster graphics (or pixel-based graphics) software to create and edit traditional photographs and images.
- Photo Processor or Image Organizer (Adobe Lightroom, Apple Photos): software designed to emulate a photography darkroom with tools to adjust brightness and color in RAW photographs along with library tools to organize photos.
- Vector Graphics Software (Sketch, Adobe Illustrator): graphics design software that uses vectors or points on an x/y axis to define shapes, which lets graphics be enlarged without loss in quality. Typically used for icons, digital painting, and illustration.
- CAD (Computer Aided Design) (AutoCAD, Google SketchUp): tools to design 2D layouts and blueprints or 3D models for architecture, manufacturing, and digital graphics for animation. Often used for CAM (Computer Aided Manufacturing—or the older term CAD/CAM) with CNC (computer numerical control) software to control 3D printers, milling machines, lathes, and other manufacturing equipment to turn the designs into finished products.
- Computer Graphics Software or Animation Software (Maya, Blender): software to build 3D models and use CAD designs in digital graphics, and to animate those models and graphics for game and movie production. Simpler software in this category like After Effects and Apple Motion are designed solely for adding smaller animations and effects to video footage.
- Video Editing Software (Adobe Premiere, Final Cut Pro): software to edit and combine video clips into a finished clip or movie with audio and text credits. Often used in combination with computer graphics or animation software to add effects, and file conversion and compression apps to export the finished work—and may include screen recording tools to capture video directly from a computer.
- Digital Audio Workstation (Adobe Audition, Audacity): software to record and edit sound, often with an interface that looks similar to a physical soundboard. Often used with synthesizers to generate sounds digitally.
- Music Composition or Notation Software (Finale, Noteflight): document editor software designed specifically to write sheet music digitally.
Software to build software (Apple Xcode pictured)
Want to build new software? These are the tools you need. For web apps and simpler software, a code editor on its own might be enough—or perhaps an automation tool that lets you accomplish the same tasks without making a new program. Or, to make the next breakout App Store hit, an IDE puts all the tools you need in one place to code, design, and ship your new app.
- Code Editors (Sublime Text, Notepad++): specialized text editors with extra features to aid in software development. Code editors are focused on plain text without formatting, but add in tools to auto-complete standard coding syntax and search options that can look through multiple documents at once.
- Compiler (gcc, Visual Basic): utility software that turns source code into machine code to create applications.
- IDE (Integrated Development Editor) (Visual Studio, Xcode): software that includes a code editor, design tools to build an interface, and compliers to create completed software all in one package.
- Virtual Machine (VM) (VMware, VirtualBox): software that emulates a computer so you can run another operating system at the same time as your computer’s main operating system, typically to test software.
- Automation or Integration or Workflow Software (Zapier, macOS Automator): tools to connect other applications and automatically perform tasks on your behalf. When used inside chat apps, often referred to as bots.
Selling products? You need software to run your store, even if it isn’t online (Shopify pictured)
Software lets you build great new things—and also can help you sell them. Few stores today run without software: software to manage inventory, order products from suppliers, and help customers checkout their purchases. And if you want to sell online, your entire business will be powered by software, with a website and eCommerce software to list your products and handle sales from customers around the world.
- Point of Sale (POS) Software (Square, SAP for Retail): software to scan barcodes, calculate order totals, process payments, print receipts, and other retail related tasks. Specialized versions include POS software for restaurant orders, hotel reception and booking, self-checkout systems, and more.
- eCommerce Platform (Shopify, WooCommerce): POS software for online sales, typical built around a CMS to add marketing content for products, an online shopping cart where customers can place orders, and inventory systems that automatically adjust stock as orders are placed.
- Online Marketplace (eBay, Amazon Vendor): specialized eCommerce platforms built to hold products from a wide range of vendors, with similar features for sellers but less features—with the benefit of a larger potential customer base. Some such as Etsy include social networking features for customers to follow stores and get updates about new products.
- Order Fulfillment Software or Supply Chain Management Software (SAP, ShipStation): software to manage inventory of products to be sold and shipped, or parts to be assembled into products. Similar to a CRM or project management software, built around product development and sales.
When spreadsheets aren’t enough, accounting software helps keep finances in order (QuickBooks Online pictured)
Spreadsheets were called the original “killer app” for PCs, as they were the main reason many businesses decided to buy computers in the first place. That was often because spreadsheets helped accounting work so much, they more than paid for themselves. Today, you could still use a spreadsheet to keep a personal budget—but for anything more advanced, you’ll likely used a database-powered accounting tool that’s built to help you track income and expenses down to the last penny.
- Payment Processor (Stripe, PayPal): software to accept credit card and other payment info from customers and accept money on your behalf. Typically used with eCommerce or invoicing software. Variants include subscription software to bill customers on a regular basis.
- Invoice Builder or Proposal Software (Wave, FreshBooks): document editors designed to quickly create proposals or invoices for work you’ve performed, often with payment processor integrations to get paid directly.
- Finance Management Software (Quicken, Mint): consumer software to import bank info and manage your personal finances. Variants include tax preparation software like TurboTax with specialized forms to manage your broad finances and file your tax return.
- Accounting Software (QuickBooks, Xero): professional finance software with a database to record details about every financial transaction, often with accounting tools including double-digit accounting, inventory tracking, bill payment, and invoice tools.
Task apps come in many variations, but all are designed to help you get things done (Todoist pictured)
You could write down the things you need to do on a piece of paper, or use a text editor or word processor to list them. A notes app might work a bit better, with a database to organize those documents of tasks.
Or, just use a to-do list. Essentially a simple notes app just for tasks—with a database to store everything and a note that’s focused on the title for each task—to-do list apps make sure nothing falls through the cracks. Then as your workload grows, you can upgrade to increasingly powerful project tools to give your tasks a workflow and keep your entire company pushing towards the same direction.
- To-Do List Apps (Todoist, Asana): a cross between a text editor, calendar, and database, these apps list tasks you need to do and typically show them on the date they need completed.
- Project Management Software (Trello, Basecamp): advanced to-do list apps for teamwork, project management tools typically organize tasks into a list, kanban, or scrum workflow, schedule tasks on a calendar or gantt chart, and let you assign tasks to others on a team.
- Product Management Software (Aha!, ProdPad): software to manage your entire company’s direction, one step removed from standard project management. Project management software organizes to-dos into workflows; product management does the same to projects, helping teams plan the big picture of their product development and business growth.
- Process Management Software (KiSSFLOW, Process Street): similar to project management software for routine work, these tools list tasks in order they should be completed to be re-done in a checklist every time that project is started.
- ERP (Enterprise Resource Planning) or Back Office Software (SAP, Sage): a cross between a CRM and project management software, ERP helps you plan your company’s resources, scheduling when team members and equipment are free for work and ensuring everything is in place to do the work your team needs to do. Specialized versions included inventory control systems, warehouse management systems, and more.
All Software is Related
Learning how to use a new program can be overwhelming, even scary when you’ve never seen it before. The good thing is, there are few new things under the sun—and that new program you’ve been asked to learn is likely much like something you’ve already used before.
A CRM—or patient and client management software—is only slightly more difficult to use than an address book. ERP is at its basics is pretty similar to a project management app plus a a CRM—and a project management app is just a more advanced to-do list. CAD/CAM software is similar enough to drawing software, which itself is Microsoft Paint for real work.
It’s not a perfect comparison, but it’s enough to get you started. Figure out the next closest app, and you’ll feel at home pretty quickly. Then build your skills up from there.
And next time you need a new app, think through the other, simpler software that could perform the same task. You might not need the new tool after all—or at least you’ll have an easier time choosing the new software.