##11

Theory 10Theory 10

Unit 10Unit 10

Application Application SoftwareSoftware

##22

Theory 10Theory 10

Application SoftwareApplication Software

•Get SoftwareGet Software• Install SoftwareInstall Software•Software VersionSoftware Version•Bundled SoftwareBundled Software•Getting HelpGetting Help

##33

Theory 10Theory 10

Software CategoriesSoftware Categories

•Word ProcessorWord Processor•SpreadsheetSpreadsheet•DatabaseDatabase•Presentation GraphicsPresentation Graphics•“Suite”“Suite”

##44

Theory 10Theory 10

Word ProcessorWord Processor

##55

Theory 10Theory 10

Word Process. FunctionsWord Process. Functions

•DocumentsDocuments•TablesTables•Mail MergeMail Merge•(many possibilities)(many possibilities)

##66

Theory 10Theory 10

Word Processing BasicsWord Processing Basics

•ScrollScroll•Word WrapWord Wrap•Insertion PointInsertion Point•Select TextSelect Text

##77

Theory 10Theory 10

Edit a DocumentEdit a Document

•Edit TextEdit Text•Search & ReplaceSearch & Replace•Spelling & GrammarSpelling & Grammar•ThesaurusThesaurus

##88

Theory 10Theory 10

FontFont

•TypefaceTypeface•Type SizeType Size•Type StyleType Style

##99

Theory 10Theory 10

Format a ParagraphFormat a Paragraph

•Line SpacingLine Spacing•TabsTabs•ListList•Text AlignmentText Alignment

##1010

Theory 10Theory 10

Format a PageFormat a Page

•MarginMargin•Header & FooterHeader & Footer•Footnote & EndnoteFootnote & Endnote•Page NumberPage Number

##1111

Theory 10Theory 10

SpreadsheetSpreadsheet

##1212

Theory 10Theory 10

Purpose of SpreadsheetPurpose of Spreadsheet

•Manage FinancesManage Finances•Manage Data in a ListManage Data in a List

•Contents:Contents:–Spreadsheet NumbersSpreadsheet Numbers–Charts (graphs)Charts (graphs)

##1313

Theory 10Theory 10

Spreadsheet UnitsSpreadsheet Units

•Row (##s)Row (##s)•Column (letters)Column (letters)• Intersection = CellIntersection = Cell•Cell Reference (A1)Cell Reference (A1)

##1414

Theory 10Theory 10

FormattingFormatting

•FontFont•Number AppearanceNumber Appearance•Row/Column sizeRow/Column size•Borders, Shading, ColorBorders, Shading, Color•Data AlignmentData Alignment

##1515

Theory 10Theory 10

Spreadsheet HelpersSpreadsheet Helpers

•Automatic RecalculationAutomatic Recalculation•Parentheses for formulaParentheses for formula•Complete a seriesComplete a series•Functions (sum, min, Functions (sum, min,

max, many more)max, many more)

##1616

Theory 10Theory 10

Parts of a ChartParts of a Chart

• Chart TitleChart Title• Data SeriesData Series• Y-Axis TitleY-Axis Title• X-Axis TitleX-Axis Title• LegendLegend

0

10

20

30

40

50

1st

Qtr

2nd

Qtr

3rd

Qtr

4th

Qtr

West

North

##1717

Theory 10Theory 10

DatabaseDatabase

##1818

Theory 10Theory 10

Database ApplicationsDatabase Applications

•Store DataStore Data•Create ReportsCreate Reports•Analyze DataAnalyze Data

##1919

Theory 10Theory 10

Types of DatabasesTypes of Databases

•Flat File DatabaseFlat File Database•Relational DatabaseRelational Database

##2020

Theory 10Theory 10

Database StructureDatabase Structure

•Field (column)Field (column)•Record (row)Record (row)•Table (related subject)Table (related subject)

##2121

Theory 10Theory 10

Ways to Manage InfoWays to Manage Info

•SortSort•FindFind•QueryQuery

##2222

Theory 10Theory 10

Database ChoicesDatabase Choices

•TableTable•QueryQuery•FormForm•ReportReport•(Advanced)(Advanced)

##2323

Theory 10Theory 10

Presentation Presentation GraphicsGraphics

##2424

Theory 10Theory 10

Purpose of GraphicsPurpose of Graphics

•Overhead transparenciesOverhead transparencies•On-screen displayOn-screen display•Slides for other usesSlides for other uses•Export to the Web (new)Export to the Web (new)

##2525

Theory 10Theory 10

View OptionsView Options

•SlidesSlides•OutlineOutline•Slide SorterSlide Sorter•Speaker NotesSpeaker Notes

##2626

Theory 10Theory 10

View/Print OptionsView/Print Options

•SlidesSlides•OutlineOutline•Slide SorterSlide Sorter•Speaker NotesSpeaker Notes•Audience NotesAudience Notes

##2727

Theory 10Theory 10

Screen DesignScreen Design

• TextText• GraphicsGraphics• SoundSound• VideoVideo

• Hypertext Hypertext links (new)links (new)

• SpreadsheetSpreadsheet

• AnimationAnimation• TransitionsTransitions

##2828

Theory 10Theory 10

““Suite”Suite”

##2929

Theory 10Theory 10

Application SuitesApplication Suites

•Word Processing ProgramWord Processing Program•Spreadsheet ProgramSpreadsheet Program•Database ProgramDatabase Program•Presentation ProgramPresentation Program

##3030

Theory 10Theory 10

Application SuiteApplication Suite

•AdvantagesAdvantages–CostCost–Easy to UseEasy to Use

•DisadvantagesDisadvantages

##3131

Theory 10Theory 10

Popular SuitesPopular Suites

•Microsoft OfficeMicrosoft Office•Corel WordPerfect SuiteCorel WordPerfect Suite•Lotus SmartSuiteLotus SmartSuite

(“Pro” includes database (“Pro” includes database program)program)