Transcript Computer Literacy for IC3 Unit 1, Chapter 2 Identifying Computer

Computer Literacy for
3
IC
Unit 1: Computing Fundamentals
Chapter 4:
Identifying Software and
Hardware Interaction and
Types of Software
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
1
Learning Targets
Unit 1, Chapter 4
16. I can identify hardware and software
interaction
17. I can identify the steps of the development
process
18. I can identify issues related to software
distribution, updates, and upgrades
19. I can identify fundamental word processing
concepts and uses
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
2
Learning Targets Continued
Unit 1, Chapter 4 (continued)
20. I can identify fundamental spreadsheet
concepts, processes, and uses
21. I can identify fundamental presentation
software concepts and uses
22. I can identify fundamental database concepts
and uses
23. I can identify fundamental graphic and
multimedia concepts and uses
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
3
Learning Targets Continued
Unit 1, Chapter 4 (continued)
24. I can identify other types of software and their
uses
25. I can identify how to select software
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
4
Basic Word Processing Concepts
1. Input is received
2. Stored in RAM
• Document manipulated within capabilities of program
• Format - bold, italics, font color, etc.
• Input graphics
• Ideal for editing
3. Displayed on the screen
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
5
Word Processing Documents
• From memos and letters to entire books
• Can utilize advanced features
•
•
•
•
Index
Table of Contents
Save as a Web page
Graphics
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
6
Spreadsheet Concepts
• Display numbers in various ways
• Formulas
• Calculations based on values in other cells
• Worksheet – single table of cells
• Workbook – collection of worksheets
• Layout
• Columns – Letters
• Rows – Numbers
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
7
Keeping It Straight
• Columns – Letters
• Are like the porch columns on
the front of a house…they go
up and down
• Rows – Numbers
• Are like you read the rows in a
book…from left to right
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
8
Spreadsheet Basics
• Cell – intersection of a
column and row
• Formulas
• Algebraic or mathematic
equation
• In Excel, start with “=”
(equal sign)
• Functions
• Predefined equations
• Functions can be a formula
or part of a formula
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
9
Spreadsheet Processes
Variety of features
• Charts – pie, bar, scatter plot
• Data analysis
• Sorting and filtering
• What-If analysis
• Crunch values in equation
to get desired results
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
10
Spreadsheet Documents
• Possible uses
•
•
•
•
•
P&L (profit & loss statement)
Investment tracking
Expense reports
Grade book
Budget
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
11
Presentation Software Concepts
• Visual aids
• Graphics
• Clip art and digital pictures
• Charts
• Text
• Titles
• Bulleted lists
• Animation
• Holds audience attention
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
12
Presentation Basics
• Slides
• Image composed of text, graphics, etc.
• Slide show
Slide thumbnails
Current slide
• Group of slides
• Extra features
• Speaker notes
• Displayed on screen
• Student handouts
• Printouts
» Slide miniatures
Slide notes
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
13
Presentation Documents
• Possible uses
• Educational presentation
• Display at trade shows
• Interactive Web pages
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
14
Database Concepts
• Database
• A collection of organized
data
• Stores huge amounts of
information
• Used in the retail sales
environment
• Inventory system
• Point of sale
Tables in
Access
Field
Record
• Considered more difficult
for beginners
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
15
Database Basics
• Tables
• Fields
• Records
• Keys
• Queries – filter the data
• Ask a question of the data
• Forms – input, edit, and view data
• Reports – view the data
• On screen or printed
• Database management system (DBMS)
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
16
Database Documents
• Possible uses
• Customer records
• Inventory system
• Bill payment tracking
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
17
Database Memory Issues
Database programs use RAM differently
• Store only active record in RAM
• Automatically saves
• Saves a record when moving to the next record
• Power failure
• Loss of current record, not all records
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
18
Questions?
© 2010 Pearson Education, Inc. | Publishing as Prentice Hall.
19