130 likes | 252 Views
Capabilities of Software. Common Office Applications. Word Processing Spreadsheets DTP Presentation Graphics Databases. For further research. HTML Editing Web Browsing Email Diary. Word Processors 1. Common Word Processors Microsoft Word OpenOffice.org Writer AbiWord (Free!)
E N D
Common Office Applications • Word Processing • Spreadsheets • DTP • Presentation • Graphics • Databases For further research • HTML Editing • Web Browsing • Email • Diary
Word Processors 1 • Common Word Processors • Microsoft Word • OpenOffice.org Writer • AbiWord (Free!) • Common Applications • Letters • Memo • Theses • Reports • Mail Merge
Word Processors 2 • Some Common Features • Spelling & grammar checking (including auto correction) • Text formatting – can change font, size and emphasis (e.g. bold or italic). • Find and Replace. • Insert, delete, overwrite text • Tables • Automatic table of contents/index • Import files such as images and other text files, charts etc. • Mail merge documents to create standard letters from an address list. • Templates and styles
Common Spreadsheets Microsoft Excel OpenOffice.org Calc Minitab (Scientific) Common Applications Graphs Data Modelling Forecasting Data Pattern Analysis Spreadsheets 1
Spreadsheets 2 • Some Common Features • Rows and Columns • Charts and graphs • Import and Export facilities • Functions ( and formulae) • Pivot tables • Macros • Form controls • Worksheets/workbooks • Sorting/filtering data • Relative and absolute formulae • Goal seeking (What if?)
Desktop Publishing (DTP) 1 • Common DTP Software • Quark • Microsoft Publisher • Serif • Common Applications • Newspapers/magazines • Brochures • Invitations • Business Cards • Posters • Menus
Desktop Publishing (DTP) 2 • Some Common Features • Text editing • Import and export facilities • Gridlines to position objects • Working area off the page • Wizards and templates • Text formatting around images and objects • Creation of booklets • Tables and columns
Common Presentation Software Microsoft PowerPoint OpenOffice.org Impress Apple Keynote Common Applications Widely used in business… …and schools Death by PowerPoint!!! Presentation Software 1
Presentation Software 2 • Some Common Features • Master slides • Clipart/pictures • Slide transition • Automated use (kiosk application) • Styles and templates • Animation effects • Standalone use • Import and export facilities(sound, video etc.) • Web integration
Graphics 1 • Common Graphics Software • Adobe Photoshop • Macromedia Fireworks • GIMP (Free open-source) • Common Applications • Logos • Books and magazines • Product packaging
Graphics 2 • Some Common features • Integration with hardware – cameras, scanners, etc • Resize of image • Change colour depth • Graphics tools – brush, line, colour, fill, etc • Layering of images • Transparency • Masking parts of the image • Useful Link • http://en.wikipedia.org/wiki/Digital_image_editing
Databases • Some Common Features Databases are covered as a separate topic (11.3) but… • Search and sort data • Import/Export • Forms • Macros • Reports • Calculations on data • Validation routines • Programming capability • Wizards • Graphs (other analysis tools)