Lesson 7 Software Fundamentals - Woodlawn Middle School

natureplaygroundΤεχνίτη Νοημοσύνη και Ρομποτική

14 Νοε 2013 (πριν από 3 χρόνια και 10 μήνες)

87 εμφανίσεις

1

Lesson 7


Software

Fundamentals

High School Credit


Lesson 7

High School Credit

Business Computer Applications

2

2

2

Objectives:

Students will be able to:

1.
Identify the fundamental concepts of word
-
processing software.

2.
Identify the fundamental concepts of
spreadsheet software.

3.
Identify the fundamental concepts of
presentation software.

4.
Identify the fundamental concepts of
database software.


Lesson 7

High School Credit

Business Computer Applications

3

3

3

Objectives (continued)


Identify the fundamental concepts of
graphics and multimedia software.


Identify the fundamental concepts of
education and entertainment software.


Identify the types and purposes of utility
programs.


Identify other types of miscellaneous
software programs.


Lesson 7

High School Credit

Business Computer Applications

Vocabulary

1.
bitmapped
graphics

2.
cell

3.
database

4.
datasheet

5.
field

6.
multimedia

7.
object

1.
object linking and
embedding (OLE)

2.
presentation
software

3.
primary key

4.
query

5.
record

4

4

4


Lesson 7

High School Credit

Business Computer Applications

Vocabulary (continued)

1.
spreadsheet

2.
table

3.
text editor

4.
utility program

5.
vector graphics


1.
word
-
processing
software

2.
workbook

3.
worksheet

5

5

5


Lesson 7

High School Credit

Business Computer Applications

6

6

6

Introduction


Symbolically speaking, application software sits
on top of system software because it cannot run
without the operating system and system
utilities.


You can purchase application software as
individual programs or as a suite.


A suite generally contains the following four
types of programs: word processing,
spreadsheets, presentations, and databases.


Lesson 7

High School Credit

Business Computer Applications

Word
-
Processing Programs


You use word
-
processing
software, like
Microsoft Office
Word, to create,
edit, and print
documents and
then save the
documents
electronically.



7

7

7


Lesson 7

High School Credit

Business Computer Applications

Word
-
Processing Programs
(continued)


Word processors that support the basic
features generally are called text editors.


Microsoft Word provides options that you can
adjust and configure to suit your working
style. To display the Word Options dialog
box, click the Office button and then click the
Word Options button at the bottom of the
menu.

8

8

8


Lesson 7

High School Credit

Business Computer Applications

Spreadsheet Concepts


A spreadsheet is a
row
-
and
-
column
arrangement of data.


You use electronic
spreadsheet software,
like Microsoft Office
Excel, to evaluate,
calculate, manipulate,
analyze, and present
numeric data.

9

9

9


Lesson 7

High School Credit

Business Computer Applications

Spreadsheet Concepts (continued)


The rows and columns can contain text, formulas,
and numbers (values).


The grid in Excel is referred to as a worksheet (or
spreadsheet).


An Excel file is called a workbook.


A cell is the intersection of a column and a row.


Each cell has a name, called the cell reference (for
example, A1).

10

10

10


Lesson 7

High School Credit

Business Computer Applications

Spreadsheet Concepts (continued)


You can use formatting to emphasize specific entries, enhance
the appearance of the spreadsheet, and make the information
easier to read and understand.

11

11

11


Lesson 7

High School Credit

Business Computer Applications

Presentation Concepts


Presentation
software, like
Microsoft Office
PowerPoint, is a
computer program
you use to organize
and present
information,
normally in the form
of a slide show.

12

12

12


Lesson 7

High School Credit

Business Computer Applications

Presentation Concepts (continued)


Microsoft PowerPoint comes with themes

predesigned sets of
fonts, colors, lines, fill effects, and other formatting.

13

13

13


Lesson 7

High School Credit

Business Computer Applications

Presentation Concepts (continued)


Effective Presentation Guidelines:


You can use presentation tools to make any
presentation more effective and interesting, but don’t
get carried away with sounds, animation, and clip art.


Before you create a presentation, plan and outline the
message that you want to communicate.


Consider your audience and determine the
presentation’s purpose, the location in which it will be
given, and the equipment you will need.

14

14

14


Lesson 7

High School Credit

Business Computer Applications

Database Concepts


Effective information management is the core of a
successful business or organization and is important
in your personal life.


Database Software Defined:


A database is a collection of related information
organized in a manner that allows for rapid search
and retrieval.


A database management system (DBMS) is a
software program that is used to create, maintain, and
provide controlled access to data.

15

15

15


Lesson 7

High School Credit

Business Computer Applications

Database Concepts (continued)


Database Structure:


A table is composed of columns and rows, referred to as fields
and records in Access.


The primary key, which is assigned to a field, uniquely identifies
each record in a table.


Using the data stored in the table, you can use Access to create
the following objects: queries, forms, and reports.

16

16

16


Lesson 7

High School Credit

Business Computer Applications

Database Concepts (continued)


Creating a Table:


Creating a table is the first step in a three
-
step
process and adding fields is the second step.
The third step is to populate or add records to
the table.


Access contains two basic views for working
with tables

Design view and Datasheet view.


17

17

17


Lesson 7

High School Credit

Business Computer Applications

Database Concepts (continued)


Forms:


A form provides a convenient way to enter
and view records in a table.


Queries:


A query enables you to locate records that
match specified criteria by providing a way for
you to ask a question about the information
stored in a database table or tables.

18

18

18


Lesson 7

High School Credit

Business Computer Applications

Database Concepts (continued)


Reports:


A report is a database object that allows you
to organize, summarize, and print all or a
portion of the data in a database.


Online Databases:


Many Internet
-
based databases are dynamic
and provide the capability for the user to
change the content and products frequently.

19

19

19


Lesson 7

High School Credit

Business Computer Applications

Graphics and Multimedia
Programs Concepts


You use graphics and multimedia programs to
create a variety of illustrations and animation.

20

20

20


Lesson 7

High School Credit

Business Computer Applications

Graphics and Multimedia
Programs Concepts (continued)


Drawing Programs:


A drawing program is a graphics program that
is used for creating illustrations.


The image is saved in a vector graphics
format. This allows all individual parts of the
picture to be moved, isolated, and scaled
independently of the other parts.

21

21

21


Lesson 7

High School Credit

Business Computer Applications

Graphics and Multimedia
Programs Concepts (continued)


Paint Programs:


A paint program allows
the user to simulate
painting on the computer
through the use of a
graphics tablet or a
mouse.



Images are created with a matrix of picture
elements (pixels) and are generated as
bitmapped graphics.

22

22

22


Lesson 7

High School Credit

Business Computer Applications

Graphics and Multimedia
Programs Concepts (continued)


Photo/Image Manipulation Programs:


You use digital editing software to edit images,
photos, and logos.


Animation Programs:


You use animation software to create moving images
and 3D graphics.


Multimedia Programs:


Multimedia is defined as the use of text, graphics,
audio, and video in some combination to create an
effective means of communication and interaction.

23

23

23


Lesson 7

High School Credit

Business Computer Applications


Educational and software programs are available for
both children and adults. The following describes this
type of software:


Computer
-
based training (CBT):
Web based and/or
computer
-
based training programs


Computer games:
Single
-
user and multiuser games;
combines an educational component with a game format


Audio and video:
Software applications used to play audio
and video; Media Player is bundled with Windows


Virtual reality:
A technology that lets users interact with a
computer
-
simulated environment

Education and Entertainment
Programs

24


Lesson 7

High School Credit

Business Computer Applications


Utility Programs


Utility programs help you perform computer
housekeeping chores. Some examples are:


File compression programs


Antivirus, antiadware, and antispyware programs


Defragmentation


Backup program


Single
-
purpose tools and accessories

25

25

25


Lesson 7

High School Credit

Business Computer Applications

Miscellaneous Software


Financial and
accounting
programs


Electronic mail


Chat, messaging,
and instant
messaging software


Web browser


Computer
-
aided
design (CAD)


Project management


Groupware


Web conferencing


Integrated programs


Specialized software


In addition to the software programs, there are other
types of software available:

26


Lesson 7

High School Credit

Business Computer Applications

Miscellaneous Software
(continued)


Selecting Software:


Select a product that is appropriate for the task.


Software Integration:


An object is the data or information that you want to
share between the programs.


You can insert objects from one Office document into
another Office document by copying and pasting,
embedding, and linking.

27

27

27


Lesson 7

High School Credit

Business Computer Applications

28

28

Summary

In this lesson, you learned:


How to use word
-
processing software to create, edit,
and print documents and then save the documents
electronically. When creating a document, you can
easily correct errors and modify data.


A spreadsheet is a row
-
and
-
column arrangement of
data. You use electronic spreadsheet software to
evaluate, calculate, manipulate, analyze, and
present numeric data. Calculations are updated
automatically.

28


Lesson 7

High School Credit

Business Computer Applications

29

29

Summary (continued)


A database is a collection of related information
organized in a manner that provides for rapid search
and retrieval. You use database software to create,
maintain, and provide controlled access to data.


A database can consist of one table or a collection of
tables, which are composed of columns and rows,
referred to as fields and records. The primary key,
which is assigned to a field, uniquely identifies each
record in a table. You can also create queries, forms,
and reports using database software.

29


Lesson 7

High School Credit

Business Computer Applications

30

30

Summary (continued)


How to use graphics and multimedia
programs to create a variety of illustrations
and animation. Most graphics applications fall
into one of two main categories: vector or
bitmap graphics.


Educational programs include computer
-
based training, computer games, audio and
video software, and virtual reality programs.

30


Lesson 7

High School Credit

Business Computer Applications

31

31

Summary (continued)


Utility programs help you perform computer
housekeeping chores such as managing the
computer’s resources and managing files.


Miscellaneous software includes programs
such as e
-
mail applications, Web browsers,
and project management software.

31