|
|
OFFICE USER SPECIALIST
1 & 2
| Performance
Task/
Assessments
|
Standards
& Competencies
(Exploratory = pre-industry content standard
Preparatory = industry standard)
|
Essential
Academic Learning Requirements/GLEs
Benchmark
3
Washington State Goals 1 & 2 |
| Unit
1: Career Research and Foundation
|
·
Read,
write, define, understand and use computer terminology
·
Read,
interpret, and follow documentation concerning the care and operation
of software and hardware
·
Identify and demonstrate
the use of computer peripherals including printers, input devices, and
storage devices, utilizing written and electronic references
·
Demonstrate appropriate
file management techniques
·
Evaluate several occupational
interests, based on various criteria (e.g., education requirements,
starting salaries, and career ladder opportunities
·
Relate the importance
of education to meeting identified goals
·
Describe benefits of participating
in school and community activities
·
Describe techniques for
eliminating gender bias and stereotyping
·
Formulate strategies for
working effectively with coworkers of varying age groups, cultures,
and mental or physical abilities
·
Describe ways tasks and
the workplace environment can be structured to accommodate the diverse
needs of workers
|
Reading
3.2.2 Apply understanding of complex
information to perform a task
Writing
3.5 Publish—select a publishing form
and produce a completed writing project to share with chosen audience
|
| Unit
2: Word Processing--Core
Students will demonstrate efficient
use of word processing software by
·
Working with text, paragraphs,
pictures, columns, tables and charts
·
Managing Files
Assessment through SAM Microsoft Specialist Core
Exam
|
·
Create,
edit, format, save, and print document
·
Use
automatic text features, find and replace, and proofing tools
·
Use
templates, styles, outlines, headers and footers
·
Create
and format letters, envelopes and labels, tables and columns
·
Control
pagination
|
Writing
1.3.
Apply writing conventions
2.3 Write in a variety of forms
4.1 Assess
own strengths and needs for improvement. Analyze effectiveness
of own writing and set goals for improvement
4.2 Seek and offer feedback
|
| Unit
3: Word Processing-–Expert
Students
will demonstrate efficient use of word processing software by
·
Customizing paragraphs,
tables
·
Utilize mail merge
·
Creating and modifying
graphs
·
Customizing Word
·
Workgroup Collaboration
Assessment through SAM Microsoft
Specialist Expert Exam
Unit 3: Word Processing--Expert
|
·
Sort
paragraphs in lists and tables
·
Create,
format, and apply document sections, paragraph styles and special characters
·
Create
and update document macros, indexes and tables of contents, figures,
and authorities
·
Create
cross-references, document versions and help protect documents
·
Add
and revise endnotes and footnotes
·
Create
and manage master documents and subdocuments
·
Move
within documents
·
Create
and modify forms using various form controls and prepare forms for distribution
·
Create
and modify Excel data in tables
·
Perform
calculations in Word tables
·
Create,
modify, align text and position graphics
·
Customize
menus and toolbars
·
Track,
accept, and reject changes to documents
·
Insert
and modify hyperlinks to other documents and Web pages
·
Create
and edit Web documents in Word
·
Define
and modify default file locations for workgroup templates
·
Attach
digital signatures to documents
·
Merge
letters and labels with a Word, Excel, or Access data source
|
Writing
1.3. Apply writing conventions. Know and apply correct spelling, grammar,
sentence structure, punctuation, and capitalization
2.1 Write for different audiences
2.3 Write in a variety of forms, including narratives, journals, poems, essays,
stories, research reports, and technical writing
3.4. Edit—use resources to correct spelling, punctuation, grammar, and usage
4.1 Assess
own strengths and needs for improvement. Analyze effectiveness
of own writing and set goals for improvement
4.2 Seek and offer feedback
|
| Unit
4: Spreadsheet–Core
Students
will demonstrate efficient use of spreadsheet software by
·
Working with cells, cell
data, formulas and functions
·
Working with files and
workbooks
·
Formatting, modifying
and printing worksheets, charts and workbooks
·
Creating and Revising
Formulas and graphics
·
Page Setup and Printing
·
Using Charts and Objects
Assessment through SAM Microsoft
Specialist Core Exam.
|
·
Create,
modify, format and print worksheets and charts
·
Insert,
delete, revise and move cells and cell data (text, numbers and formulas)
·
Find
and replace cell data and formats and check spelling
·
Work
with a subset of data by filtering lists
·
Work
with basic formulas and functions
·
Use
multiple worksheets and automated tools to format worksheets
·
Manage
workbook files and folders
·
Create
workbooks using templates
·
Save
and share workbooks using different names and file formats
·
Apply
and modify cell formats, styles and autoformats
·
Modify
Page Setup option, names and positions for worksheets
·
Use
3-D references and advance functions and formatting features
·
Use
statistical, date and time, financial, and logical functions in formulas
·
Create,
modify, position, and print charts and graphics
·
Use
special format and print options
·
Manipulate
the screen display and view and edit comments
·
Automate
excel and protect worksheet data
·
Convert
worksheets into Web pages and create hyperlinks
|
Reading
3.2.2 Apply understanding of complex
information, including functional documents, to perform a task
Math
2.1.1 Analyze a situation to define a problem
2.2.1 Apply strategies, concepts, and procedures to devise a plan to solve
the problem
2.2.2 Apply mathematical tools to solve the problem
|
| Unit
5: Spreadsheet – Expert
Students
will demonstrate efficient use of spreadsheet software by
·
Importing and Exporting
Data
·
Managing Workbooks
·
Formatting Numbers
·
Working with Ranges
·
Customizing Excel
·
Auditing Worksheet
·
Summarizing and Analyzing
Data
·
Workgroup Collaboration
Assessment through SAM Microsoft Specialist Expert
Exam
|
§
Import and export
data to Excel
§
Publish worksheets and
workbooks to the Web
§
Create, edit, and apply
templates and macros
§
Use data consolidation
and audit formulas
§
Create and apply custom
number formats and conditional formats
§
Use named ranges, lookup
and reference functions
§
Customize toolbars and
menus and define/apply filters
§
Locate and resolve errors
§
Add group and outline
criteria to ranges
§
Use data validation and
merge workbooks
§
Retrieve external data
and create queries
§
Create Extensible Markup
Language (XML) Web queries
§
Create a Microsoft PivotTable®,
Microsoft PivotChart®, and PivotTable/PivotChart Reports
§
Forecast values with what-if
analysis
§
Create and display scenarios
§
Modify passwords, protections,
and properties
|
Reading
2.3.4 Synthesize information from a variety of sources
Communication
3.2 Work cooperatively as a member of a group
Math
2.2.1 Apply strategies, concepts, and procedures to devise a plan to solve
the problem
2.2.2 Apply mathematical tools to solve the problem
|
| Unit
6: Presentations
Students
will demonstrate efficient use of electronic presentation software by
·
Creating, customizing
and modifying a presentation
·
Working with text and
visual elements
·
Delivering a presentation
·
Managing files
·
Integrating with other
software packages
Assessment through SAM Microsoft Office User Specialist
Exam
|
·
Create
and modify presentations (manually and using automated tools)
·
Add
and delete slides from presentations and deliver presentations
·
Modify
headers and footers in the Slide Master
·
Insert, format, and modify
text and add links to presentations
·
Add tables, charts, clip
art, and bitmap images to slides
·
Customize slide backgrounds,
formats and templates
·
Add OfficeArt Elements
to slides
·
Apply custom formats to
tables, presentations, animation schemes and slide transitions
·
Manage a Slide Master
·
Rehearse timing and rearrange
slides and add sound and video to slides
·
Preview and print slides,
outlines, handouts, and speaker notes
·
Export a presentation
as an outline and set up slide shows
·
Publish presentations
to the Web and use Pack and Go
|
Communication
2.1. Communicate clearly to a range of audiences
for different purposes
Art
3.1 Use the arts to express and present ideas and feelings
3.2 Use the arts to communicate for a specific
purpose
|
| Unit
7: Database
Students
will demonstrate efficient use of database software by:
·
Planning, designing and
creating databases
·
Creating and modifying
databases, tables and forms
·
Creating and modifying
queries
·
Viewing and organizing
information
·
Defining relationships
·
Producing reports
·
Integrating with other
applications
Assessment through SAM
Microsoft Office User Specialist
Exam
|
·
Create,
design and format databases
·
Open
database objects in multiple views
·
Create
queries and modify selected queries
·
Enter,
edit, sort delete and filter records
·
Create and work with tables,
queries, forms and reports
·
Create, modify and print
tables, forms and reports
·
Modify field properties
and form properties
·
Add calculated controls
to reports
·
Work with charts, filters
and relationships
·
Maintain data integrity
·
Add calculated fields
to select queries
·
Use advanced form, report
and query features
·
Create one-to-many relationships
·
Enforce referential integrity
·
Work with macros
·
Import and export data
to Access
|
Reading
1.2.2 Apply strategies to comprehend words and ideas
Science
1.2 Recognize the components, structure,
and organization of systems and the interconnections within and among
them
Math
2.2.1 Apply strategies, concepts, and procedures to devise a plan to solve
the problem
|
| Unit
8: Email Software
Students
will demonstrate efficient use of email software by
·
Creating,
viewing and managing messages.
·
Using
calendar features for time management
·
Creating,
using and maintaining contact lists
·
Creating,
using and maintaining task lists and notes pages
·
Integrating office applications
with outlook components
|
·
Read,
compose, send, display and print email
·
Insert signatures and
attachments
·
Use mail features, address
book and mail templates
·
Customize menu, task bars
and other Outlook components
·
Search and move messages
between folders
·
Save messages in alternate
file formats
·
Use categories to manage
messages
·
Set message options
·
Navigate, print and configure
calendar
·
Add appointments, meetings,
and events to the Outlook calendar
·
Apply conditional formats
to the Outlook calendar
·
Respond to meeting requests
and use categories to manage appointments
·
Print calendars and save
calendar as a web page
·
Using categories and outlook
help
·
Create, edit, organize
and sort contacts and tasks
·
Link contacts to activities
and journal entries
·
Modify task organization
and Task view
·
Accept, decline, or delegate
tasks
·
Create, organize, customize,
and modify notes
·
Create and use office
documents within outlook
|
Writing
1.2. Use style appropriate to the audience and purpose. Use voice, word choice, and sentence fluency for
intended style and audience
Communication
2.1. Communicate clearly to a range of audiences for different purposes
|
|
