Applications: Spreadsheet

Specialty programs

Small business/home office

Professional

Levels of Software

"Desktop publishing" covers a wide range of activities and difficulty levels:

Create for commercial printing - magazine, company annual report, newspaper, book, full-color advertising.

Use a wizard or template to create a brochure, business card, or ad and print on your own printer.

Make your own greeting cards, calendars, or labels.
Print T-shirts.

Major players in the desktop publishing game include Microsoft Publisher, Corel Ventura, QuarkXpress, and several Adobe products - PageMaker, FrameMaker, InDesign.

Purpose:	To prepare documents with graphics with precise control of the layout
Major Advantages:	Ability to place text and graphics precisely on page Ability to chain sections together like newspaper columns Advanced tools for professional work

Features/Terms:

Layout -	Arrangemnet of text and graphics
Clip art -	Pre-drawn pictures to add to page
WYSIWYG -	What You See Is What You Get pronounced " wiz-e-wig " How page displays on screen is the same as how it prints. In the olden days programs did not have a print preview at all. A bit later they had one but it might not actually print quite like what you saw on the screen.
separations-	For full color in high quality printing, the paper goes through the printing press 4 times, once for each of the colors cyan, magenta, yellow, and black (CMYK color system). The print shop must create separate versions of your document, called separations, for each color.

A spreadsheet is the application of choice for most documents that organize numbers, like budgets, financial statements, grade sheets, and sales records. A spreadsheet can perform simple and very complex calculations on the numbers you enter in rows and columns.

Examples of spreadsheet programs: MS Excel, Lotus 1-2-3, Quattro Pro, and Open Office Calc.

Purpose:	Organizing numbers
Major Advantages:	Can calculate for you using formulas Auto-update of related numbers when data changes Can display data in charts

Features/Terms:

rows & columns	Creates a grid
cell	Intersection of row and column. Can contain text or numbers or a formula.
formula	Calculates value to put in cell, like a total, an average, interest amount, etc.	=SUM(C21:C45) =Average(B3:W394) =0.095*LoanTotal
chart	Graphical representation of the data

Дата добавления: 2014-12-23