Unit 6 Computer Concepts
Function
A built-in preset formula
Database
A collection of data that may be stored on one or more digital devices
Office Suite
A collection of programs that typically include word processing, spreadsheet, and presentation modules
Software License
A legal contract that defines the ways a computer program may be used
Spelling Dictionary
A list of correctly spelled words stored in a data file
Product Activation
A means of protecting software from illegal copying by requiring a product key or activation key before the software can be used
Software Upgrade
A new Version/Edition of a software product
Value
A number that you want to use in a calculation
Relative Reference
A reference that can be changed from B3 to B4
Disk Partition
A section of a hard disk drive that is treated as a seperate storage unit
Font
A set of letters that share a unified design
Service Pack
A set of updates
Software Update
A small section of a program code that replaces part of the software currently installed
Uninstall Utility
Deletes a software's files from various folders on your computer's hard disk
Thin Client
Depends substantially on processing and storage provided by a remote computer
Portable Software
Designed for PCs and runs from removable storage (USBs, removable hard disk, etc.)
Mobile App
Designed for a handheld device, generally small, focused applications sold through an online app store
DOS (Disk Operating System)
Designed to run on early PC's with Intel or Intel compatible microprocessors
Word Wrap
Determines how your text flows from line to line by automatically moving words down to the next line as you reach the right margin
Demoware
Distributed for free, often pre-installed to your device and usually limited in some way until you pay
Automatic Recalculation
Ensures that the results in every cell are accurate for the information currently entered in the worksheet
Single-User License
Limits use to one person at a time
Open Source
Makes un-compiled program instructions available to programmers who want to mod and improve software
Rooting
Making unauthorized mods to any mobile device to overcome limitations imposed by mobile service providers
Spelling Checker
Marks misspelled words in a document
Point Size
Measurement of text size. One point is approximately 1/72 of an inch
Android
Mobile operating system, open sourced under Google
Absolute Reference
Never changes when you insert rows, or copy or move formulas
Public Domain Software
Not protected by copyright due to expired license or the author made it public
Word Processing Software
Produces documents, including reports, letters, memos, papers, and book manuscripts
Kernel
Provides essential operating system services, such as customization services and file access
Cell References
Refers to a cell
Web Application
Software that is accessed with a Web browser
Productivity Software
Software that offers features that really help get work done
Hash Value
A unique number derived from encoding one or more data sets. (Names, serial numbers, validation codes, etc.)
Mobile Operating System
Accommodates 1 user at a time, provides connectivity to wireless local area networks
Desktop Operating System
Accommodates 1 user at a time, supports multiple accounts, includes file management tools, run more than one app at a time
Server Operating System
Accommodates multiple simultaneous users, includes sophisticated network management and security tools
Processes
Activities that compete for the attention of the device's microprocessor
Commercial Software
Adhere closely to limits of copyright law, though some may be downloadable to multiple devices
Multithreading
Allows multiple commands (threads) to run simultaneously
Virtual Machine (VM)
Allows one computer to simulate the hardware and software of another
Site License
Allows software to be used on all computers at a specific location
Multiple-User License
Allows the allocated number of copies to be used simultaniously
Jailbreak
An unauthorized change in a device's software
Readability Formula
Analyzes the reading level of your document
EULAS (End User License Agreement)
Another term for software license
What-If Analysis
Answer questions such as "What if I get an A on my next two economic exams? What if I get only Bs?"
Label
Any text used to describe data
OS X
Apple operating system for Mac's
Worksheet
Based on a grid of columns and rows
Cell
Can contain a value, label, or formula
Resource Fork
Companion file that stores information about the data in the Data Fork
Executable File
Contains a computer program that is carried out step-by-step within the microprocessor
Directory
Contains a list of a storage device's files
DMG
Contains the main APP file for the software, may also contain a Read Me or other files used by an application
Freeware
Copyright software that is available for free
Shareware
Copyrighted software marketed under a try-before-you-buy policy
Search and Replace
Feature that finds mistakes that you habitually make in your writing
Chrome OS
Google operating system
Setup Program
Guides you through the installation process
Database Software
Helps you enter, find, organize, update, and report information stored in a database
Thesaurus
Helps you find a synonym for a word so that you can make your writing more varied and interesting
Record
Holds data for a single entity
Buffers
Holds data temporarily until the destination device is ready to accept it
Field
Holds one item of data relevant to a record
Device Letter
Identifies storage devices
Pirated Software
Illegal copies of software (Made against copyright law)
Paragraph Style
Includes the alignment of text within the margins and the space between each line of text
User Interface
Includes the visual experience and also the keyboard, mouse, mic, or touchscreen that collects commands
Local Application
Installed on a computer's Hard Disk
Microsoft Windows
Installed on more than 80% of the world's personal computers
Style
Lets you apply several font and paragraph characteristics with a single click
BSD (Berkeley Software Distribution) License
License for a server operating system
Multitasking
Provides process and memory management services that allow two or more tasks, jobs, or programs to run simultaneously
Spreadsheet Software
Provides tools to create electronic spreadsheets
Grammar Checker
Reads through your document and points out potential grammatical trouble spots (Incomplete sentences, run-on sentences, etc.)
Module
Refers to a component
Resources
Refers to any component that is required to perform work
Paragraph Alignment
Refers to the horizontal position of text
Page Layout
Refers to the physical position of each element on a page
GPL (General Public License)
Requires derivative works to be licensed
Proprietary Software
Restrictions on its use that are delineated by copyright, patients, or license agreements
Data Fork
Similar to files, contains Data
File-Naming Conventions
Specific rules for file naming
System Requirements
Specify the Operating System and the minimum hardware capacities necessary for a software product to work properly
Presentation Software
Supplies the tools for combining data into a series of electronic slides that can be shown on a screen or projector
Application Extension
Support modules that come in additional files required for Windows application software
Multiprocessing
Supports a division of labor among all the processing units
Formula
Tells the microprocessor how to use the contents of cells in calculations
Fully Justified
Text is aligned evenly on both the right and left margins
Footer
Text that you specify to automatically appear in the bottom margin of every page
Header
Text that you specify to automatically appear in the top margin of every page
Root Directory
The main directory of a storage device
iOS
The operating system for Apple smart devices, based of the OS X system
Forked
The source code is developed and updated on two different paths by separate organizations
Leading
The vertical spacing lines between lines of text
Document Formatting
The way that all elements in a document (text, pics, etc.) are arranged on the page
Spreadsheet
Uses rows and columns of numbers to create a model or representation of a real situation
Memory Leak
When an application requests information but never releases it
