What Can You Do?: Boys Girls
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View What Can You Do?: Boys Girls as PDF for free.
More details
- Words: 966
- Pages: 31
WHAT CAN YOU DO?
BOYS
&
GIRLS
APPLICATION SOFTWARE
… consists of programs (set of command) that perform specific tasks for a users.
TOPIC REVIEW USER
SYSTEM SOFTWARE (operating system)
COMPUTER’S HARDWARE
APPLICATION SOFTWARE
THE USED OF APPLICATION SOFTWARE Is used for a variety of reasons: – As a productivity/business tool – To assist with graphics and multimedia projects – To support household activities, for personal business, or for education – To facilitate communications.
TYPES OF APPLICATION SOFTWARE
ORD PROCESSING SOFTWARE
PROGRAMS
Microsoft Word Sun StarOffice Writer Corel WordPerfect
RESENTATION SOFTWARE
Microsoft Excel Sun StarOffice Calc Corel Quattro Pro Microsoft PowerPoint Sun StarOffice impress Corel Presentations
RAPHIC SOFTWARE
Paint Adobe Photoshop CorelDRAW
PREADSHEET SOFTWARE
WORD PROCESSING SOFTWARE
DEFINITION
…software that allows to create document and manipulate documents containing mostly text and sometimes graphics.
INTERFACES
USAGE
• Also known as word processor. • Usage : develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
FEATURES
• capability of changing : – changing the shape characters – changing size of characters in headlines and headings – changing color of characters – organizing text into newspaper-style columns
FEATURES (cont.)
• Clip Art : collection of drawings, diagrams, maps, and photographs that you can insert into documents • create and modify documents – size and margin.
FEATURES (cont.)
• Wordwrap : allows users to type words in a paragraph continually without pressing the ENTER key at the end of each line. • Scrolling : process of moving different portions of the document on the screen into view.
FEATURES (cont.)
• can change what have written - insert, delete, or rearrange words, sentences, paragraphs, or entire sections.
FEATURES (cont.) • find or search : allows to locate all occurrences of certain character, word, or phrase. This feature is combination with • replace : combination with find/search - allows to substitute existing characters or words with new ones.
FEATURES (cont.)
•
automatically corrects errors.
•
spelling checker : which reviews the spelling of individual words, section of a document, or the entire document.
•
header : text that appears at the top of each page, and footer : text that appears at the bottom of each page.
SPREADSHEET SOFTWARE
DEFINITION
… software that allows users to organize data in rows and columns and perform calculations on the data.
INTERFACES
USAGE
• organize and present non-financial data, as well as financial data.
FEATURES A. Spreadsheet Organization • •
255 individual worksheet 256 columns • • •
•
in vertical one or more letters identify each column letters begin with A and end with IV
65,536 rows • • •
in horizontal number identifies each row 1 and end with 65,536
FEATURES (cont.) A. Spreadsheet Organization (cont..) •
Cell : the intersection of a column and row. • • •
16 million cells - (256 rows x 65,536 columns). Cell B6 - the intersection of column B and row 6 Cells may contain three types of data: labels, values, and formulas.
FEATURES (cont.) B. Calculations • • •
Many of the worksheet cells contain a number that can be used in a calculation, called a value. Other cells, however, contain formulas that generate values. A function is a predefined formula that performs common calculations such as adding the values in a group of cells or generating a value such as the time or date.
FEATURES (cont.) C. Recalculation • Easier and faster. • Changes updated automatically and instantaneously. • Valuable budgeting, forecasting, and decision making tool. • what-if analysis feature : can change certain values in a spreadsheet to reveal the effects of those changes.
FEATURES (cont.) D. Charting • •
depicts the data in graphical form. Three chart types 1. line charts 2. column charts 3. pie charts
ACTIVITIES
MIX & MATCH
USE R
SYSTEM SOFTWARE (Operating System)
COMPUTE R’S HARDWAR E
APPLICATION SOFTWARE … consists of programs (set of command) that perform specific tasks for a users.
ORD PROCESSING
Usage •
To develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
Features
Definition •
Software that allows to create document and manipulate documents containing mostly text and sometimes graphics.
Changing and organizing text and character Clip Art Create and modify documents – size and margin Wordwrap Scrolling
Program Microsoft Word
Insert, delete, or rearrange words, sentences, paragraphs, or entire sections Find or Search, and replace
Sun StarOffice Writer Corel WordPerfect
Spelling checker Header and footer
PREADSHEET SOFTWARE
Usage •
To organize and present nonfinancial data, as well as financial data.
Features A Spreadsheet Organization •255 Worksheets •256 Columns
Definition •
Software that allows users to organize data in rows and columns and perform calculations on the data.
•65,536 Rows •(256 x 65,536) Cells B Calculations C Recalculation
Program D Charting
Microsoft Excel
•
Line Charts
Sun StarOffice Calc
•
Column Charts
Corel Quattro Pro
•
Pie Charts
CONCLUSION
APPLICATION SOFTWARE … consists of programs (set of command) that perform specific tasks for a users. TYPE
WORD PROCESSING
SPREADSHEET
Definition • allows to create document and
• allows users to organize data in rows and columns and perform calculations on the data.
Program • Microsoft Word
• Microsoft Excel • Sun StarOffice Calc • Corel Quattro Pro
manipulate documents containing mostly text and sometimes graphics
• Sun StarOffice Writer • Corel WordPerfect
Usage
• develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
Features • Clip Art • • • •
Wordwrap Find or Search, and replace Spelling checker etc
• organize and present non-financial data, as well as financial data.
• • • •
Spreadsheet Organization Calculations Recalculation Charting
THANK YOU for your attention But remember ! we will continue with two more types of application software in the next class
BOYS
&
GIRLS
APPLICATION SOFTWARE
… consists of programs (set of command) that perform specific tasks for a users.
TOPIC REVIEW USER
SYSTEM SOFTWARE (operating system)
COMPUTER’S HARDWARE
APPLICATION SOFTWARE
THE USED OF APPLICATION SOFTWARE Is used for a variety of reasons: – As a productivity/business tool – To assist with graphics and multimedia projects – To support household activities, for personal business, or for education – To facilitate communications.
TYPES OF APPLICATION SOFTWARE
ORD PROCESSING SOFTWARE
PROGRAMS
Microsoft Word Sun StarOffice Writer Corel WordPerfect
RESENTATION SOFTWARE
Microsoft Excel Sun StarOffice Calc Corel Quattro Pro Microsoft PowerPoint Sun StarOffice impress Corel Presentations
RAPHIC SOFTWARE
Paint Adobe Photoshop CorelDRAW
PREADSHEET SOFTWARE
WORD PROCESSING SOFTWARE
DEFINITION
…software that allows to create document and manipulate documents containing mostly text and sometimes graphics.
INTERFACES
USAGE
• Also known as word processor. • Usage : develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
FEATURES
• capability of changing : – changing the shape characters – changing size of characters in headlines and headings – changing color of characters – organizing text into newspaper-style columns
FEATURES (cont.)
• Clip Art : collection of drawings, diagrams, maps, and photographs that you can insert into documents • create and modify documents – size and margin.
FEATURES (cont.)
• Wordwrap : allows users to type words in a paragraph continually without pressing the ENTER key at the end of each line. • Scrolling : process of moving different portions of the document on the screen into view.
FEATURES (cont.)
• can change what have written - insert, delete, or rearrange words, sentences, paragraphs, or entire sections.
FEATURES (cont.) • find or search : allows to locate all occurrences of certain character, word, or phrase. This feature is combination with • replace : combination with find/search - allows to substitute existing characters or words with new ones.
FEATURES (cont.)
•
automatically corrects errors.
•
spelling checker : which reviews the spelling of individual words, section of a document, or the entire document.
•
header : text that appears at the top of each page, and footer : text that appears at the bottom of each page.
SPREADSHEET SOFTWARE
DEFINITION
… software that allows users to organize data in rows and columns and perform calculations on the data.
INTERFACES
USAGE
• organize and present non-financial data, as well as financial data.
FEATURES A. Spreadsheet Organization • •
255 individual worksheet 256 columns • • •
•
in vertical one or more letters identify each column letters begin with A and end with IV
65,536 rows • • •
in horizontal number identifies each row 1 and end with 65,536
FEATURES (cont.) A. Spreadsheet Organization (cont..) •
Cell : the intersection of a column and row. • • •
16 million cells - (256 rows x 65,536 columns). Cell B6 - the intersection of column B and row 6 Cells may contain three types of data: labels, values, and formulas.
FEATURES (cont.) B. Calculations • • •
Many of the worksheet cells contain a number that can be used in a calculation, called a value. Other cells, however, contain formulas that generate values. A function is a predefined formula that performs common calculations such as adding the values in a group of cells or generating a value such as the time or date.
FEATURES (cont.) C. Recalculation • Easier and faster. • Changes updated automatically and instantaneously. • Valuable budgeting, forecasting, and decision making tool. • what-if analysis feature : can change certain values in a spreadsheet to reveal the effects of those changes.
FEATURES (cont.) D. Charting • •
depicts the data in graphical form. Three chart types 1. line charts 2. column charts 3. pie charts
ACTIVITIES
MIX & MATCH
USE R
SYSTEM SOFTWARE (Operating System)
COMPUTE R’S HARDWAR E
APPLICATION SOFTWARE … consists of programs (set of command) that perform specific tasks for a users.
ORD PROCESSING
Usage •
To develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
Features
Definition •
Software that allows to create document and manipulate documents containing mostly text and sometimes graphics.
Changing and organizing text and character Clip Art Create and modify documents – size and margin Wordwrap Scrolling
Program Microsoft Word
Insert, delete, or rearrange words, sentences, paragraphs, or entire sections Find or Search, and replace
Sun StarOffice Writer Corel WordPerfect
Spelling checker Header and footer
PREADSHEET SOFTWARE
Usage •
To organize and present nonfinancial data, as well as financial data.
Features A Spreadsheet Organization •255 Worksheets •256 Columns
Definition •
Software that allows users to organize data in rows and columns and perform calculations on the data.
•65,536 Rows •(256 x 65,536) Cells B Calculations C Recalculation
Program D Charting
Microsoft Excel
•
Line Charts
Sun StarOffice Calc
•
Column Charts
Corel Quattro Pro
•
Pie Charts
CONCLUSION
APPLICATION SOFTWARE … consists of programs (set of command) that perform specific tasks for a users. TYPE
WORD PROCESSING
SPREADSHEET
Definition • allows to create document and
• allows users to organize data in rows and columns and perform calculations on the data.
Program • Microsoft Word
• Microsoft Excel • Sun StarOffice Calc • Corel Quattro Pro
manipulate documents containing mostly text and sometimes graphics
• Sun StarOffice Writer • Corel WordPerfect
Usage
• develop documents such as letters, memos, reports, fax cover sheets, mailing labels, newsletters, and web pages.
Features • Clip Art • • • •
Wordwrap Find or Search, and replace Spelling checker etc
• organize and present non-financial data, as well as financial data.
• • • •
Spreadsheet Organization Calculations Recalculation Charting
THANK YOU for your attention But remember ! we will continue with two more types of application software in the next class
Related Documents
What Can You Do?: Boys Girls
June 2020 13
What Do You Do
May 2020 43
You Can Do
June 2020 10
What Can You Do-disaster Guide
November 2019 52
What Can We Do
November 2019 60
What Can I Do
November 2019 60More Documents from ""
Picture 1 Picture 2 Picture 3
June 2020 8
Input Devices-ict
June 2020 11
Data Manipulation-ict
June 2020 12
Network Topology-ict
June 2020 16
Induksi-comp Sys
June 2020 10