Capabilities of Software

1
Capabilities of Software
2
Common Office Applications

• Word Processing
• Spreadsheets
• DTP
• Presentation
• Graphics
• Databases

For further research

• HTML Editing
• Web Browsing
• Email
• Diary

3
Word Processors 1

• Common Word Processors
• Microsoft Word
• OpenOffice.org Writer
• AbiWord (Free!)
• Common Applications
• Letters
• Memo
• Theses
• Reports
• Mail Merge

4
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

5
Spreadsheets 1

• Common Spreadsheets
• Microsoft Excel
• OpenOffice.org Calc
• Minitab (Scientific)
• Common Applications
• Graphs
• Data Modelling
• Forecasting
• Data Pattern Analysis

6
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?)

7
Desktop Publishing (DTP) 1

• Common DTP Software
• Quark
• Microsoft Publisher
• Serif
• Common Applications
• Newspapers/magazines
• Brochures
• Invitations
• Business Cards
• Posters
• Menus

8
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

9
Presentation Software 1

• Common Presentation Software
• Microsoft PowerPoint
• OpenOffice.org Impress
• Apple Keynote
• Common Applications
• Widely used in business
• and schools
• Death by PowerPoint!!!

10
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

11
Graphics 1

• Common Graphics Software
• Adobe Photoshop
• Macromedia Fireworks
• GIMP (Free open-source)
• Common Applications
• Logos
• Books and magazines
• Product packaging

12
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

13
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)

14
Further Research/Tasks

• Investigate ONE of the applications on slide 1
  paying particular attention to the common
  features youd expect to find