Computer Test- Chapter 3

Web authoring programs

even without knowledge of HTML, you can create simple web pages using a word processing package like Microsoft word. more specialized and powerful programs are called---- & are typically used to create sophisticated commercial sites. also know as WEB PAGE EDITORS and HTML EDITORS, these programs provide support for website design and HTML coding. Some web authoring programs are WYSIWYG (what you see is what you get) EDITORS.

IT

information technology

User interface

is the portion of the application that allows you to control and to interact with the program.

types of word processors-

most common- Microsoft word- Corel wordperfect, apple pages, open office writer, google docs

Spreadsheets

organize, analyze, and graph numeric data such as budgets and financial reports. Once used exclusively by accountants, spreadsheets, are widely used by nearly every profession. Marketing professionals analyze sale trends. Financial analysts evaluate and graph stock market trends. Students and teachers record grades and calculate grade point averages. The most widely used spreadsheet program is Microsoft Excel.

Ribbons

replace menus and toolbars by organizing commonly used commands into a set of tabs.

System Software

works with end users, application software, and computer hardware to handle the majority of technical details.

Presentation graphics

Are programs that combine a variety of visual objects to create attractive, visually interesting presentations. Research shows that people learn better when info is presented visually. - 3 widely used presentation graphic programs are Microsoft power point, OpenOffice impress, and apple keynote.

Application software

Can be described as end user software and is used to accomplished a variety of tasks. Can be divided into 3 categories-

Window

Simply a rectangular area that can contain a document, program, or message. (Don't confuse the term window with the various versions of Microsofts windows operating systems which are programs.)

Pointer

The mouse controls the pointer on the screen that is used to select items such as icons.

software engineer

analyze users needs and create application software. software engineers typically have experience in programming but focus on the design and development of programs using the principles of mathematics and engineering. employers typically look for software engineers with good communication and analytic skills.

Tabs

are used to divide to divide the ribbon into major activity areas. Each tab is then organized into GROUPS that contain related items.

Office suites or office software suites and productivity suites

contain general purpose application programs that are typically used in a business situation. Productivity suites commonly include a word processor, spreadsheet, database manager, and a presentation application.

Word processors

create text-base documents and are one of the most flexible and widely used software tools.

The 3 categories of application software-

1. General-purpose applications- includes word processing programs, spreadsheets, presentation graphics, and database management systems. 2. Specialized applications- includes thousands of other programs that tend to be more narrowly focused and used in specific disciplines and occupations. 3. Mobile apps- add on features or programs typically designed for smart phones and tablets.

GUI

GRAPHIC USER INTERFACE- Almost all applications use a mouse and a graphical user interface (GUI) that displays graphical elements called ICONS to represent familiar objects.

Animations

Multimedia elements are added to individual pages to enhance interest and interactivity. one multimedia element found on many websites it moving graphics called---

Creating a database-

Primary key-the unique employee identification number. Fields- given field names that are displayed at the top of each table. Table- make up the basic structure of a relational database with columns containing field data and rows containing record info. record- contains info about an employee form- like printed paper forms and should be designed to be easy to use and read.

Common features-

Spell checker alignment fonts & font sizes character effects

Database

a collection of related data. it is the electronic equivalent of a file cabinet.

Software suite

a collection of separate application programs bundled together and made available as a group. 4 types of suites are office suites, cloud suites, specialized suites, and utility suites.

Database management system (DBMS) or Database manager

a program that sets up, or structures, a database. It also provides tools to enter, edit, and retrieve data from the database. All kinds of individuals use databases, from hospital administrators recording patient information to police officers checking criminal histories. College and universities use databases to keep records on their students, instructors, and courses. Organizations of all types maintain employee databases. Two widely used database management systems designed for personal computers are Microsoft access and open office base.

Mobile apps or mobile applications

add on programs for a variety of mobile devices including smartphones and tablets. Sometimes referred to simply as APPS, mobile apps have been widely used for years. the traditional applications include address books, to do lists, alarms, and message lists. with the intro of smartphones tablets and wireless connections to the internet, mobile capabilities have exploded, now any number of apps are available.