Docstoc

Chapter 4

Document Sample
Chapter 4 Powered By Docstoc
					                                                 SAK3002 – IT and Its Applications




                4
            Chapter
               APPLICATION
                SOFTWARE

Chapter 4         SAK3002 – Information Technology and Its Application
                                                                   SAK3002 – IT and Its Applications


 Objectives of this chapter:
    You can…

    Identify the types of application software




    Explain how to work with application software




    Explain ways software is distributed




Chapter 4                           SAK3002 – Information Technology and Its Application
                                                     SAK3002 – IT and Its Applications


 Overview

           This chapter covers
            Introduction
            Word Processing Software
            Spreadsheet Software
            Presentation Software
            Database Software
            Graphics and multimedia software
            Other software
Chapter 4             SAK3002 – Information Technology and Its Application
                                           SAK3002 – IT and Its Applications




            4.1 Introduction




Chapter 4   SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Introduction
       What is application software?



            Programs designed to make users more productive and/or assist
            them with personal tasks




Chapter 4                  SAK3002 – Information Technology and Its Application
                                                                 SAK3002 – IT and Its Applications


 Introduction (cont’d)
        How do you start an application?
           From the desktop, click the Start button, point to All Programs, and
            click the name of the application
           The program’s instructions load into memory




                                                                                         Application




                   Start button                          All Programs

Chapter 4                         SAK3002 – Information Technology and Its Application
                                            SAK3002 – IT and Its Applications


 Introduction (cont’d)




Chapter 4    SAK3002 – Information Technology and Its Application
                                                           SAK3002 – IT and Its Applications


 Introduction (cont’d)
        How is software distributed?

           Packaged software, mass-produced
           Custom software, performs functions specific to a business or
            industry
           Open source software, provided for use, modification, and
            redistribution
           Shareware, copyrighted software that is distributed free for trial
            period
           Freeware, copyrighted software provided at no cost
           Public-domain software, freeware with no copyright restrictions
           Pirated Software, software obtained illegally


Chapter 4                   SAK3002 – Information Technology and Its Application
                                                              SAK3002 – IT and Its Applications


 Introduction (cont’d)
               Common Features of Software
                 User interface - the user-controllable display screen that allows you to
                  communicate, or interact, with the computer
                 A User can interact with the display screen using a keyboard or a
                  mouse


               The GUI
                 Graphical user interface (GUI) - allows users to use a mouse or
                  keyboard strokes to select icons and commands from menus
                 The three features of GUI are desktop, icons, and menus




Chapter 4                      SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Introduction (cont’d)
           Window
           A rectangular area of the screen that displays a program, data, and/or
            information




                  Menu Bar




Chapter 4                     SAK3002 – Information Technology and Its Application
                                                              SAK3002 – IT and Its Applications


 Introduction (cont’d)
           Dialog box
            A window that provides information, presents available options, or requests
             a response




Chapter 4                      SAK3002 – Information Technology and Its Application
                                                        SAK3002 – IT and Its Applications


 Introduction (cont’d)

        The Help Command
          Help command - a
           command generating a
           table of contents, an
           index, and a search
           feature that can help
           you locate answers




Chapter 4                SAK3002 – Information Technology and Its Application
                                                               SAK3002 – IT and Its Applications


 Introduction (cont’d)
               Software Suite
                 Individual applications share a common program code
                 Popular office suites offer a word processor, spreadsheet, database, presentation,
                  and other programs
                               Microsoft Office                   WordPerfect          Lotus
                                                                  Office 12            SmartSuite
Word processing                Microsoft Word                     WordPerfect          Word Pro
Spreadsheet                    Microsoft Excel                    Quattro Pro          Lotus 1-2-3
Database                       Microsoft Access                   Paradox              Lotus Approach
Presentation                   Microsoft PowerPoint               Corel                Freelance
Graphics                                                          Presentations        Graphics
Personal information           Microsoft Outlook                  Corel Central        Lotus Organizer
managers

Chapter 4                       SAK3002 – Information Technology and Its Application
                                                 SAK3002 – IT and Its Applications




            4.2 Word Processing Software




Chapter 4         SAK3002 – Information Technology and Its Application
                                                           SAK3002 – IT and Its Applications


 Word Processing
       What is word processing software?
           Allows users to create and
            manipulate text and graphics

           This process includes editing, deleting
            and printing the text and multimedia resources
               Clip art is a collection
                of graphics
                that you can
                insert in
                documents




Chapter 4                   SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Word Processing (cont’d)
                AutoCorrect              AutoFormat                    Collaboration

                            Grammar
      Columns                                             Ink Input                  Macros
                            Checker
               Popular word processing features
                                            Reading
                Mail Merge                                                 Research
                                            Layout

    Smart Tags                 Tables                    Templates                  Thesaurus

                 Tracking                 Voice                         Web Page
                 Changes                Recognition                    Development
Chapter 4                    SAK3002 – Information Technology and Its Application
                                             SAK3002 – IT and Its Applications




            4.3 Spreadsheet Software




Chapter 4     SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Spreadsheet software
           What is spreadsheet software?

           Organizes data in rows and columns
           Performs calculations and
            recalculates when data changes




                          = A1+B2 (*C12)               = D1+E2 (*F12)



                                      = SUM (C12:Y12)



Chapter 4                  SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Spreadsheet software (cont’d)
       How is spreadsheet organized?
           Columns identified by letters
           Rows identified by numbers
           A cell is the intersection of a column
            and row




Chapter 4                     SAK3002 – Information Technology and Its Application
                                                       SAK3002 – IT and Its Applications


 Spreadsheet
       Function

           A predefined formula
            that performs
            common calculations
            =B10+B11+B12+B13+B14
            =SUM(B10:B14)




Chapter 4               SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Spreadsheet software (cont’d)
           Charting
           Allows you to display
            spreadsheet data in
            graphical form




Chapter 4                    SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Spreadsheet software (cont’d)
                There are 4 types of charts:
            i.     Column Chart
                      Used to show changes in time and widely known as the
                       time series
            ii.    Bar Chart
                      Not suitable for time-based data. Best used for
                       comparison purposes
            iii.   Line Chart
                      Suitable for time series data
            iv.    Pie Chart
                      Widely used to show percentages

Chapter 4                     SAK3002 – Information Technology and Its Application
                                           SAK3002 – IT and Its Applications




Chapter 4   SAK3002 – Information Technology and Its Application
                                              SAK3002 – IT and Its Applications




            4.4 Presentation Software




Chapter 4      SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Presentation software
        Presentation graphics software

           Used to create visual aids for presentations
           A presentation is sometimes
            called a slide show
           Example: Microsoft PowerPoint




Chapter 4                    SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Presentation software (cont’d)
                Presentation-graphics programs offer templates to
                 help organize presentations
                Templates are of two types:
                   Design templates - offer formats, layouts, background
                    patterns, and color schemes that can apply to general
                    forms of content material
                   Content templates - offer formats for specific subjects




Chapter 4                  SAK3002 – Information Technology and Its Application
                                                                 SAK3002 – IT and Its Applications


 Presentation software (cont’d)
                    Graphical presentation program allow users to view
                     the presentation in variety of forms:
                i.     Slide view
                          View the slides one by one – users may add or edit slide
                ii.    Outline view
                          Display all text only
                iii.   Slide sorter view
                          Display graphical images of each slides and allow users to change the
                           position of the slides
                iv.    Notes view
                          Allow speaker notes to be added at each slide
                v.     Master
                          All presentation software must have the basic components of the slide

Chapter 4                         SAK3002 – Information Technology and Its Application
                                             SAK3002 – IT and Its Applications




            4.5 Database Software




Chapter 4     SAK3002 – Information Technology and Its Application
                                                    SAK3002 – IT and Its Applications


 Database Software
       Database software


            Allows you to create
             and manage data



                                              Add, change, delete,
                                             sort, and retrieve data


Chapter 4            SAK3002 – Information Technology and Its Application
                                                        SAK3002 – IT and Its Applications


 Database Software (cont’d)
               Essential to manage a large amount of data, for
                easy, direct access, to avoid data redundancy and
                to save time. Examples are: Lotus Notes, Dbase,
                Microsoft Access and Paradox
               Database - a collection of interrelated files
               Database software - a program that sets up and
                controls the structure of a database and access to
                the data



Chapter 4                SAK3002 – Information Technology and Its Application
                                                                 SAK3002 – IT and Its Applications


 Database Software (cont’d)
                 Types of database software:

            i.         Dekstop Database
                        For individual use
                        Usage is limited to 5 to 10 users at a time
                        The database functionality is limited as compare to a network databse
                        The data security system is limited especially in locking the database
                        Examples of databases are Microsoft Access, and Microsoft Visual FoxPro

            ii.        Network Database
                        For both individual and corporate use
                        Support bigger number of users that is exceeding 100 users depending on
                         the database brand
                        Moreo funtionalities provided
                        Information access and retrieval is faster
                        Higher security system
                        Examples are Oracle, Microsoft SQL Server, and Dbase


Chapter 4                         SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Database Software (cont’d)
                 Benefits of databases:

            i.      Avoid data redundancy
            ii.     Data integration
            iii.    Data security
            iv.     Data independence
            v.      Data maintenance




Chapter 4                    SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Database Software (cont’d)
       The parts of a database

           A table contains records
           A record is a row in a
            table that contains
            information about a
            given person, product,
            object, or event
           A field is a column in
            a table that contains
            a specific category of
            data within a record




Chapter 4                    SAK3002 – Information Technology and Its Application
                                                         SAK3002 – IT and Its Applications


 Database Software (cont’d)
             How a relational database is organized:
               Tables of rows and columns
               Row (record) - example: a person’s address



               Column (field) - example: the person’s last name




Chapter 4                 SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Database Software (cont’d)
             How various records can be linked:
               Key field - a field that is used to sort data
               Primary key - holds a unique value for each record
               Foreign key - used to cross-reference data among
                relational tables




Chapter 4                  SAK3002 – Information Technology and Its Application
                                                    SAK3002 – IT and Its Applications




            4.7 Graphics and Multimedia Software




Chapter 4            SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Graphics and Multimedia Software
               What is graphics and Multimedia Software?

                 Software that used to manipulate images, audio and
                  video.




Chapter 4                  SAK3002 – Information Technology and Its Application
                                                                SAK3002 – IT and Its Applications


 Graphics and Multimedia Software
        Paint/image editing software
           Used to create and
            modify graphical
            images
           Sometimes called
            illustration
            software
           Example:
               Microsoft Paint
               Corel’s Paint Shop Pro




Chapter 4                        SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Graphics and Multimedia Software
        Professional photo editing software
           Allows users to customize digital photographs
           Save images in a variety of file formats
           Example: Adobe Photoshop, Adobe Ilustrator




Chapter 4                     SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Graphics and Multimedia Software
     Video and audio editing software
           Video editing software allows you to modify a segment of a video, called a
            clip
           Audio editing software allows you to modify audio clips
           Example: Adobe Premier, Cakewalk Sonar, Cubase etc




Chapter 4                     SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Graphics and Multimedia Software
        Multimedia authoring software

           Allows you to combine
            text, graphics, audio,
            video, and animation
            in an interactive
            application
           Example
                Macromedia Flash
                Macromedia Director




Chapter 4                    SAK3002 – Information Technology and Its Application
                                               SAK3002 – IT and Its Applications




            4.7 Some other Software




Chapter 4       SAK3002 – Information Technology and Its Application
                                                            SAK3002 – IT and Its Applications


 Other Software (cont’d)
        Note taking software

           Enables users to enter typed text,
            handwritten comments, drawings,
            or sketches anywhere on the page

           Notes are organized like a
            notebook




Chapter 4                    SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Other Software (cont’d)
        Project management software
           Allows you to plan, schedule,
            track, and analyze the events,
            resources, and costs of a
            project




Chapter 4                     SAK3002 – Information Technology and Its Application
                                                          SAK3002 – IT and Its Applications


 Other Software (cont’d)
        Accounting software
           Helps companies record and
            report their financial
            transactions




Chapter 4                  SAK3002 – Information Technology and Its Application
                                                             SAK3002 – IT and Its Applications


 Other Software (cont’d)
           Web page authoring software
           Helps users of all skill levels to create Web pages
                 Some application software programs include Web page
                  authoring programs




                            graphical
                video
                             images          organize                                Web pages
                                               manage                                 and/or
                audio      animation             maintain                            Web sites




Chapter 4                     SAK3002 – Information Technology and Its Application
                                           SAK3002 – IT and Its Applications




            End of Chapter 4




Chapter 4   SAK3002 – Information Technology and Its Application

				
DOCUMENT INFO