APPLICATION SOFTWARE
SOFTWARE
- SYSTEM SOFTWARE
- APPLICATION SOFTWARE - Basic Application n Specialized Application
COMMON FEATURES
User Interface
Most have graphical user interfaces (GUI) that display icons.
Windows
Rectangular areas that can contain documents, programs, n messages.
Menus
Presents commands listed on the menu bar.
Dialog Box
Provides additional information or requests user input.
Toolbars
Contain buttons for quick access 2 commonly used command.
The interface of 2007 Microsoft Office designed to make easy to find n application features:
Ribbons
Replaces menus and toolbars use tabs to organize commands.
Contextual Tabs
Automatically appear when needed.
Galleries
Replace many dialog boxes with visual presentations of potential results
Speech Recognition
Some applications support speech recognition by allowing voice input.
WORD PROCESSSOR
W.P allow to create, edit, save and print text based document. (e.g: newsletter, web pages)
FEATURES
Word wrap – basic features that automatically move the insertion point to the next line.
Editing features:
Thesaurus
Provides synonyms, antonyms n related words.
Find N Replaces
Locates( finds), removes, and inserts (replaces) another words.
Spelling and Grammar Checkers
Automatically locate misspelled words and grammatical problems.
Formatting Features:
Font
Design of characters. Font size is the height of characters.
Characters Effects
Include bold, italic, shadow and colors.
Bulleted and Numbered lists
Used to present sequences of topics or step.
SPREADSHEET
-organize, analyze, and graph numeric data.
FEATURES
Principal spreadsheet features:
Workbook Files
Consist of one or more related worksheet.
Worksheets (spreadsheets or sheets)
Rectangular grids of rows and column.
Rows – numbers
Column – letters
Cells
Formed by the intersection of a row and column. Used to hold text and numeric entries.
Text Entries (labels)
Provide structure and numeric entries can be numbers or formulas.
Formulas
Instructions for calculations. Functions are prewritten formulas.
Range
Series of cells.
Analytical graphs (charts)
Represent data visually.
Recalculations
Occurs whenever a value changes in one cell that affects another cells.
What-if analysis
Process of observing the effect of changing one or more values.
DATABASE MANAGEMENT SYSTEMS
Database – collection of related data.(entering, editing and retrieving data)
Database management system (DBMS) – database manager
FEATURES
Relational database
Organizes data into related tables.
Tables
Have rows(records) and columns ( fields)
Sort
Tool to rearrange records using a particular field.
Query
Questions or request for specific data contained in a database.
Forms
Used to enter new records or edit existing records.
Reports
are printed output in a variety of forms.
PRESENTATION GRAPHICS
Presentation graphics combine a variety of visual objects to create attractive, visually interesting presentation.
FEATURES
Slides
Individual page of screen of a presentation.
AutoContent wizard
Steps you through the process of creating a presentation.
Design Templates
Professionally selected combination of color schemes, slide layouts, and special effects.
Master Slide
Does not appear in presentation, control format and placement all of slides in a presentation.
INTEGRATED PACKAGES ( home software )
Single program that provides the functionality of several application packages.
Characteristic:
>Function that typically include word processor, spreadsheet, database manager and more. Each function is not as extensive or powerful as a single function application program.
>Less expensive than purchasing several individual application program.
>Simple to use and switch between functions.
>opular with home users who are willing to sacrifice some advanced features for cost and simplicity.
SOFTWARE SUITES
Collection of individual application packages sold together.
Productivity suites ( business suites )
Professional grade application programs.
Personal Suites ( home suites)
Personal software application or programs intended for home use.
Specialized Suites
Focus on specific applications such as graphics.
Utility suites
Variety of programs designed to make computing easier and safer.
CAREER IN IT
COMPUTER TRAINERS instruct new users on the latest software or hardware. Teaching degree is preferred and experience with latest software or hardware is essential.