Integrated Applications

School District: Valdez City Schools

Course Description: This one-semester class is designed to provide students with enhanced word processing, spreadsheet, and database skills along with speed and accuracy development. Students will learn and integrate advanced features of Microsoft Word, Excel, and Access
Level:	10-12 grade	Credit/Length:	.5 credit/1 semester
Prerequisite:	Basic Applications	Dual Credit	CIOS V230A Word Processing II (2 cr) CIOS V235A Spreadsheets II (2 cr) CIOS V140A Databases I (1 cr)
Program:	Business Education	Tech Prep	yes no
Career Cluster Area:	Business and Administrative Services
Pathway:	Business, Management, and Technology
Occupational Skills Standards/Sources of Supporting Elements:
ISS Occupational Standards NBEA Information Systems Standards CSS Occupational Standards NBEA Communication Systems Standards CDS Occupational Standards NBEA Career Development Standards NETS National Educational Technology Standards for Students MSWE Microsoft Office User Specialist (MOUS) Microsoftâ Word 2000 Expert Exam MSWC Microsoft Office User Specialist (MOUS) Microsoftâ Word 2000 Core Exam MSAC Microsoft Office User Specialist (MOUS) Microsoftâ Access 2000 Core Exam
Eligibility for Nationally Recognized Skill Certificate(s)/State License:				None known at this time

Course Outline:

· Business Document Formatting

· Business Document Writing

· Advanced Word Processing

· Advanced Spreadsheet

· Intermediate Database

· Integration of Word Processing and Spreadsheets

· Career Research

· Encourage Career and Technical Student Organization (CTSO) Involvement

Alaska Content

Standards

Alaska Performance

Standards

Performance Standards

(Learner Outcomes)

Assessment

Alaska Employability

Standards

Occupational Skills

Standards

Alaska Cultural

Standards

All Aspects of

Industry

TA 1-4

Complete a five-minute timed writing with five or less errors.

5-min timing

A 1-2

A 6

ISS VI

NETS 1

Technical

TA 1-4

R4.4

R4.6

W4.3

W4.5

Compose and produce a variety of business letters, memorandums, and reports, using correct style, format, and content.

Document Production

A 1-2

A 4

CSS B

CSS C

NETS 1

Technical

TA 1-4

TLW demonstrate correct use of pictures and charts in word processing applications.

Document Production

A 1-2

MSWC 6

MSWE 4

NETS 1

Technical

TA 1-4

TLW demonstrate correct use of table formats.

Document Production

A 1-2

MSWC 5

MSWE 3

NETS 1

D 5

E 7

Technical

TA 1-4

R4.6

TLW review and apply effective use of Help files

Demonstration

A 1-2

NETS 1

Technical

TA 1-4

R4.6

TLW review and apply correct use of mail merge.

Document Production

A 1-2

MSWE 5

NETS 1

Technical

TA 1-4

R4.6

TLW demonstrate correct use of advanced word processing features.

Document Production

A 1-2

MSWE 6

NETS 1

D 5

E 7

Technical

TA 1-4

R4.6

TLW demonstrate correct use of collaborating with workgroups.

Document Production

A 1-2

MSWE 7

NETS 1

Technical

TA 1-4

MA 4

R.4.1

TLW demonstrate correct use of formulas and functions.

Document Production

A 1-2

CS II-III

ISS VII

MSEC 6

NETS 1

Technical

TA 1-4

R.4.1

TLW demonstrate correct use of importing and exporting data.

Document Production

NETS 1

MSEE 1

Technical

TA 1-4

R.4.1

TLW demonstrate correct use of macros.

Document Production

A 1-2

NETS 1

MSEE 8

Technical

TA 1-4

R.4.1

TLW demonstrate correct use of auditing a worksheet.

Document Production

A 1-2

NETS 1

MSEE9

Technical

R4.6

MA3.4.1

Navigate and create databases.

Performance Assessment, Functional Database

ISS IV

MSAC 5

NETS 1

Technical

R4.6

MA3.4.1

Build and modify database tables.

Performance Assessment, Functional Database

ISS IV

MSAC 7

NETS 1

Technical

R4.6

MA3.4.1

Build and modify database forms

Performance Assessment, Functional Database

ISS IV

MSAC 7

NETS 1

Technical

TA 1-4

Integrate word processing, spreadsheet, and databases

Document Production

A 1-2

MSWE 1

NETS 1

Technical

TE 7

TE 8

TB 1-3

TA 1-4

W4.5

R4.4

Research current technology trends.

Document Production

A 1-2

A 6

NETS 1

NETS 2

NETS 5

Technical

TA1-4

TB1-3

TD1-3

R4.6

W4.4

MC1.4.1

ME1.4.2

Research and plan for careers.

Document Production

E.A.1

E.A.3

E.B.1-5

CDS 1-V

NETS 1-4

Technical

Labor

Recommended Resources: (Textbooks, equipment, reference materials, supplies)

Alaska Content Standards http://www.eed.state.ak.us/contentstandards/home.html (12/30/03)

Alaska Employability Standards http://www.eed.state.ak.us/qschools/Employability_Standards.html (12/30/03)

Alaska Reading, Writing and Math Standards http://www.eed.state.ak.us/tls/PerformanceStandards/ (12/30/03)

All Aspects of Industry http://www.lx.org/iwe/Resources/All_Aspects.doc (12/30/03)

Business Professionals of America Competitive Events http://www.bpa.org/events/wasp.html (12/30/03)

Cultural Standards for Students http://www.ankn.uaf.edu/stustan.html (12/30/03)

NBEA-National Business Education Association (National Business Standards) www.nbea.org (ã1995)

Ambrose, Ann & Jones, Dorothy. Small Business Institute Advanced Simulation. South-Western Educational Publishing. 1999.

Flynn, Meredith & Rutkkosky, Nita. Advanced Microsoft Office Expert Certification Benchmark Series. EMC Paradigm. 2000.

Parsons, June Jamrich & Dan Oja. Computer Concepts. International Publishing Company, 5th. 2002. (Chapter 4, File Management, Virus Protection, and Backup)

Stiegler, C.B. Fun & Games International. South-Western Publishing Co. 1995.

VanHuss, Susie H. Basic Letter and Memo Writing, 4^th Ed. South-Western Educational Publishing. 1998. (Chapters 4-6).

VHS Course Pages
PWSCC Course Pages
Personal Web page
VCS Web Page
Teacher Resources