Level 28 Level 30
Level 29

Application Software


79 words 0 ignored

Ready to learn       Ready to review

Ignore words

Check the boxes below to ignore/unignore words, then click save at the bottom. Ignored words will never appear in any learning session.

All None

Ignore?
Application software
consists of programs designed to make users more productive and/or assist with personal tasks
System Software
Programs that control or maintain the operations of a computer and its devices.
Business software
is application software that assists people while performing business activities
Word processing software
allows users to create and manipulate documents
Clip Art
graphic image that can be inserted into documents.
Spreadsheet software
allows users to organize data in rows and columns and perform calculations
Charting
depicts data in a spreadsheet in graphical form
database
A collection of data organized in a manner that allows access, retrieval, and use of that data.
Database Software
A collection of information organized in such a way that a computer program can quickly select desired pieces of data. You can think of a database as an electronic filing system.
Presentation software
allows users to create visual aids for presentations to communicate ideas, messages, and other information to a group
Note taking software
is application software that enables users to enter typed text, handwritten comments, drawings, or sketches anywhere on a page
Software suite
is a collection of individual programs available together as a unit
Personal information manager
is application software that includes appointment calendar, address book, and notepad
Project management software
allows a user to plan, schedule, track, and analyze the events, resources, and costs of a project
Accounting software
helps companies record and report their financial transactions
Database management system
a system software component that manages and controls one or more databases
Features of DBMS
Check for inconsistencies in data
Benefits of databases
Can easily search for data and manipulate it to form new data.
Queries
A query is a search - queries allow data to be manipulated to produce new information.
Validation
4th step of requirements gathering
Examples of validation checks
Format, length, Type, Presence, Range, Lookup
Verification
are we building the model right?
Examples of verification
Proof reading, Double entry. Check digit.
Pivot table
Produces a user friendly summary of a large amount of data in a spread sheet.
Mail Merge
Sends identical standard letters to a number of people. Each letter is personalised with the recipients personal details.
macro
A __________ is a series of instructions that can be grouped together as a single command and are often used to automate a complex set of tasks or a repeated series of tasks.
Template
A document which will hold standard information and formatting to be used repeatedly.
Formulae
Allows calculations to be performed automatically - usually in spread sheets.
Lookup Tables
Allow functions such as Vlookup and HLookup to take a value entered and then search a table to find the corresponding output. I.e you have 45% so get a grade E.
IF function
returns a value to the cell depending on the value in a related cell. standard If gives two possible outputs - true of false.
Nested IF
Like an if but if false will look at other alternatives.
Relative cell referencing
if a formula is replicate the formula will change depending on where it is copied to.
Absolute cell referencing
If a formula is replicated the formula will stay the same.
Distribution list
Allows an e-mail to be sent to a group of people.
online banking
Offers access to account balances and provides bill payment services
Menu
A dropdown list or table that contains exacutable options
scrolling
Process of moving different portions of a document on the screen into view
edit
Make changes to a document's existing content
command
A single __________ in Windows represents a collection of data, files, and instructions with a specific purpose while it is running.
reference
Software that provides valuable and thorough information for all individuals
wordwrap
Allows users to type words in a paragraph continually
pointer
Small symbol displayed on the screen that moves as you move the mouse
CBT
Students learn by using and completing exercises with instructional software (computer-based training)
Desktop
A personal computer that rests on a desks. It is not portable.
File
A collection of related data stored on a lasting
Open Source
Proprietary software that includes source codes, so programmers can modify and improve it. Do not confuse this with public domain software, which is available to the public with no restrictions.
font
a set of type characters of a particular design and size.
DTP
Software that enables professional designers to create sophisticated documents (desktop publishing)
Record
A collection of fields that appear as a row in a database or table.
Cell
A single "box" in a spreadsheet. Rows are horizontal, columns are vertical, ranges are clusters, and values are dates entered into cells.
footer
Text that appears at the bottom of each page
custom
Software that performs functions specific to a business or industry
PIM
Application software that helps users organize personal information
formula
a mathematical expression that solves a problem for adding, subtracting, multiplying, dividing or averaging.
paint
Software that allows users to draw pictures with various on-screen tools
photo editing
Software that allows users to edit digital photos
personal finance
Simplified accounting software for home users
pasting
Process of transferring an item from a clipboard to a specific location in a document
Educational
offers exciting, challenging avenues for formal and informal teaching and learning. It contains thousands of tutorials from learning how to fly airplanes to learning how to cook a meal. For example: Digital-Tutor, Linda.com
video
consists of full-motion images that are played back at various speeds
slideshow
Presentation displayed on a large monitor or on a projection screen
word processor
Allows users to create/manipulate documents containing mostly text and sometimes graphics
import
Bring in graphics into a slide
Field
A column in a table.
header
Text that appears at the top of each page
button
an image with a word that is a hyperlink
legal
Software that assists in the preparation of legal documents
online help
Electronic equivalent of a user manual
window
Rectangular area of the screen that displays data and information
packaged
Mass-produced, copyrighted retail software
CAD
Computer Aided Design - Software generates three dimensional diagrams from a set of given input data.
dialog box
Window that provides information, presents available options, or requests a response
freeware
Copyrighted software provided at no cost by an individual or a company
title bar
Horizontal space containing the window's name
filters
Designed to enhance audio quality
shareware
Copyrighted software that is distributed at no cost for a trial period
WBT
Type of CBT (computer-based training) that uses Internet technology
distance learning
The delivery of education at one location while the learning takes place elsewhere
click
Pressing and releasing a mouse button