Transcript Chapter 4
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 Chapter 4 Introduction Word Processing Software Spreadsheet Software Presentation Software Database Software Graphics and multimedia software Other software 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 Chapter 4 All Programs 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? Chapter 4 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 SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Introduction (cont’d) Common Features of Software The GUI Chapter 4 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 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 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) Chapter 4 Dialog box A window that provides information, presents available options, or requests a response 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 Office 12 Lotus SmartSuite Word processing Microsoft Word WordPerfect Word Pro Spreadsheet Microsoft Excel Quattro Pro Lotus 1-2-3 Database Microsoft Access Paradox Lotus Approach Presentation Graphics Microsoft PowerPoint Corel Presentations Freelance Graphics Personal information managers Microsoft Outlook Corel Central Lotus Organizer 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 Chapter 4 Clip art is a collection of graphics that you can insert in documents SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Word Processing (cont’d) AutoCorrect Columns AutoFormat Grammar Checker Ink Input Macros Popular word processing features Reading Layout Mail Merge Smart Tags Tracking Changes Chapter 4 Collaboration Tables Research Templates Voice Recognition Thesaurus Web Page Development 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? Chapter 4 Columns identified by letters Rows identified by numbers A cell is the intersection of a column and row SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Spreadsheet Function Chapter 4 A predefined formula that performs common calculations =B10+B11+B12+B13+B14 =SUM(B10:B14) SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Spreadsheet software (cont’d) Chapter 4 Charting Allows you to display spreadsheet data in graphical form SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Spreadsheet software (cont’d) There are 4 types of charts: i. Column Chart ii. Bar Chart iii. Suitable for time series data Pie Chart Chapter 4 Not suitable for time-based data. Best used for comparison purposes Line Chart iv. Used to show changes in time and widely known as the time series Widely used to show percentages 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 Chapter 4 Used to create visual aids for presentations A presentation is sometimes called a slide show Example: Microsoft PowerPoint SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Presentation software (cont’d) Chapter 4 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 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 ii. Outline view iii. Allow speaker notes to be added at each slide Master Chapter 4 Display graphical images of each slides and allow users to change the position of the slides Notes view v. Display all text only Slide sorter view iv. View the slides one by one – users may add or edit slide All presentation software must have the basic components of the slide 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) Chapter 4 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 SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Database Software (cont’d) Types of database software: Dekstop Database i. Network Database ii. Chapter 4 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 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 SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Database Software (cont’d) Benefits of databases: i. ii. iii. iv. v. Chapter 4 Avoid data redundancy Data integration Data security Data independence Data maintenance SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Database Software (cont’d) The parts of a database Chapter 4 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 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 Chapter 4 Column (field) - example: the person’s last name SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Database Software (cont’d) Chapter 4 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 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? Chapter 4 Software that used to manipulate images, audio and video. 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: Chapter 4 Microsoft Paint Corel’s Paint Shop Pro SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Graphics and Multimedia Software Professional photo editing software Chapter 4 Allows users to customize digital photographs Save images in a variety of file formats Example: Adobe Photoshop, Adobe Ilustrator SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Graphics and Multimedia Software Video and audio editing software Chapter 4 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 SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Graphics and Multimedia Software Multimedia authoring software Chapter 4 Allows you to combine text, graphics, audio, video, and animation in an interactive application Example Macromedia Flash Macromedia Director 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 Chapter 4 Allows you to plan, schedule, track, and analyze the events, resources, and costs of a project SAK3002 – Information Technology and Its Application SAK3002 – IT and Its Applications Other Software (cont’d) Accounting software Chapter 4 Helps companies record and report their financial transactions 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 video audio Chapter 4 graphical images animation organize manage maintain SAK3002 – Information Technology and Its Application Web pages and/or Web sites SAK3002 – IT and Its Applications End of Chapter 4 Chapter 4 SAK3002 – Information Technology and Its Application