Terms in this set (20)
Types of software
A group of programs that coordinate and control the resources and operations of a computer system.
computer software created to allow the user to perform a specific job or task
software used to perform maintenance jobs
Examples of systems software is
operating software e.g. Windows 8, Linux, iOS
Examples of application software is
-General purpose programs like word processing, spreadsheets, databases, presentations, publishing, email, video editing etc
Examples of utility software is
virus checking, firewalls, disk fragmentation, etc
Vlookup function is used to
searches for values in a column or row of a spreadsheet list or table
The IF statement is used to
An IF statement checks to see if a statement is true or false and then does one of ... =IF(Condition check,Do this if true, Do this if false).
Process of comparing data with a set of rules or values to find out if the data is correct.
Macros provide an ideal way to save time on predictable, repetitive tasks as well as standardize document formats
With a Macro you can
Apply style and formatting.
Manipulate data and text.
Communicate with data sources (database, text files, etc.).
Create entirely new documents.
Any combination, in any order, of any of the above.
Graphs organize data into a picture that can be analyzed.
Online payment methods are
• Amazon Checkout
• (RBS) WorldPay
• SagePay Go
• Third Party Payment (Service /
• Bank transfer / Account transfer
• E-voucher / (gift) voucher
An area where icons are provided as shortcuts to program tasks/sections
open source software
Software that is available to download free of charge e.g. OpenOffice.org which is a suite of applications
Also known as Software as a service (SaaS), is accessed via a web browser rather than being installed on the users computer
Locally installed software
Software which is installed on the user's computer
Advantage of opensource software
Can be shared/uploaded
Free (to download)
The (source) code is available /
Can be edited / adapted
Advantage of hosted software
(Sometimes) cheaper (than locally installed software)
Work/data) backed up
Can access from anywhere with a connection
Possibility of collaborative working
No need for (on-site) support (e.g. less time to install /maintain)
Less/no local storage required