Werecat System Consultants

SMART Skills Assessment Guidelines

Competency Level	Description	Computer OperationsÖ	Microsoft Word*	Microsoft Excel*	Microsoft PowerPoint*	Microsoft Access*
	Obtain basic computer hardware knowledge, as well as software basics. Many computer users will be a Novice with regards to a particular software application, but not “know” the hardware basics.	Desktop/Windows concepts Hard disk vs. Floppy disk Network (LAN) vs. stand-alone RAM vs. ROM Using the Mouse Virus concepts	All Windows functions Cut, copy and Paste Find and Replace Font formatting Headers and Footers Page Setup Print Preview Printing Refresh Screen Spell & grammar check Typing Undo and Redo Zoom	All Windows functions Cut, copy, paste and delete cells Data Entry Find and Replace Font formatting Headers and Footers Page Setup Print Preview Printing Refresh Screen Selecting Cells, Rows, Columns Spell & grammar check Undo and Redo Zoom	All Windows functions Cut, copy, paste and delete (slides and other) Find and Replace Font formatting Headers and Footers Page Setup Print Preview Printing Refresh Screen Spell & grammar check Typing Undo and Redo Zoom	All Windows functions Cut, copy and Paste Data Entry Find and Replace Font formatting Page Header/ Footer Page Setup Print Preview Printing Refresh Screen Spell & grammar check Undo and Redo Zoom

Competency Level	Description	Computer Operations	Microsoft Word	Microsoft Excel	Microsoft PowerPoint	Microsoft Access
	Complete “basic” computer training; comprehending “desktop” environment and accessories and controls. Perform routine software tasks with ease. Most users will quickly diverge and develop different skill levels in different applications (secretaries will become proficient at word processing, clerks will become proficient at spreadsheets) but each platform has its own purpose and skills should be broadly developed to maximize user effectiveness.	Accessories File management/ navigation Save vs. Save As Desktop/ Windows navigation Multi-tasking Control Panel settings Print Queues Virus checking Document Recovery Clipboard Cut vs. Copy vs. Delete vs. Move When to use: Word processing, spreadsheet, publishing software Selecting alternate printers	Borders and Shading Bullets and Numbering Changing menu display options GoTo Other character formatting Page Numbers Paragraph formatting Print Options Ruler formatting Symbols Tables Tabs Thesaurus Toolbars Views	Changing menu display options Cut, copy, paste and delete columns and rows Format Cells GoTo Inserting Cells, Rows, Columns, Worksheets Page Numbers Print Options Setting Header Rows Thesaurus Toolbars Views	Alignment Borders and Shading Bullets and Numbering Changing menu display options Inserting Slides Inserting objects on slides Line spacing Masters (Slide, Title, Handout, Notes) Page Numbers Print Options Ruler Formatting Symbols Tabs Tables Thesaurus Toolbars View Slide Show Views	Create New Database Date and Time Delete Design View Field List Format Cells Formulas Freeze Columns Functions Layout Preview Navigate Database Objects Page Numbers Set Column Width Set Row Height Show/Hide Columns Show/Hide Grid Show/Hide Toolbox Snap to Grid Startup Toolbars

Competency Level	Description	Computer Operations	Microsoft Word	Microsoft Excel	Microsoft PowerPoint	Microsoft Access
	Proficiency with the most useful software tools. Fully able to utilize macros, styles, templates created to automate routine tasks. Each item listed must be fully mastered; it is not enough to “know of ” the feature; rather users must be able to effectively create documents with the feature, as well as edit documents created by other users (who may or may not have used the feature correctly).		Envelopes and labels Field codes Macros Mail merge documents Page Breaks Section Breaks Section formatting Sorting Styles Templates	Copy, delete or move sheets Data Manipulation Filter Format Columns Format Rows Format Sheet Functions Macros Page Breaks Symbols Sorting Styles Templates	Color Scheme Converting other documents to PowerPoint Expand Slide GoTo Layout Guides Macros Replace Fonts Slide Formatting Slide Layout Slide Miniature Speaker Notes Templates	Aligning Items Apply Filter Arranging Objects AutoFormat Define Relationships Filter Records Graphics Labeling fields Lookup Column Navigate Views Remove Filter Rename Column (Field) Rename Database Items Ruler Formatting Set Defaults Sort Records

Competency Level	Description	Computer Operations	Microsoft Word	Microsoft Excel	Microsoft PowerPoint	Microsoft Access
	Utilizing the advanced tool set, including document navigation techniques, automating reference document tasks, and security. Users will be easily working in various platforms; creating charts in Excel, complex tables in Word, presentation materials in PowerPoint and storing data in Access databases.		AutoCorrect AutoText Bookmarks Footnotes, Captions, Indexes and Tables Graphics Paste Special Password protection Redlining changes	Auditing Data AutoCorrect Charts Conditional Formatting Get External Data Graphics Group and Outline Labeling Data Naming Data Paste Special Protection Subtotals	AutoCorrect Comments Graphics Paste Special Password protection Slide Show Setup	AutoCorrect AutoForm AutoReport Compact Database Converting Database Create Shortcut Database Splitter Icon Management Inserting Objects Macros Report Header/ Footer Sizing Objects Spacing Objects Tab Order View Multiple Pages

Competency Level	Description	Computer Operations	Microsoft Word	Microsoft Excel	Microsoft PowerPoint	Microsoft Access
	Software maintenance and customization, as well as base level programming skills. Users will be able to transfer skills learned in the Microsoft products listed to any other software of the same type (i.e., Word skills will transfer to WordPerfect, Excel skills will transfer to Lotus 123, PowerPoint skills will transfer to Harvard Graphics). Master Users know the “shape” of the software.		AutoFormat Customizing Links Online forms Tool options	AutoFormat Consolidate Data Customizing Data Tables Data Validation Goal Seek Online forms Pivot Table Report Redlining changes Save Workspace Scenarios Share Workbook Text to Columns Tool options	Animation Customizing Links Narration Pack and Go Slide Show Timings Slide Transition Style Checker Tool options	Add-In Manager Analyzer Changing Form Objects Export Database Form Header/ Footer Get External Data Linked Table Manager Options Repair Database Replication Security Set Password Switchboard Manager User and Group Permissions View Code

---

Ö Prerequisite to specific software skills. Skill levels are independent of each other for each individual software.

* Specific software listed is primarily for reference purposes. Most of the features/tools listed have comparable functions in all software of the same category (i.e., Word vs. WordPerfect or Excel vs. Lotus 123).

* Specific software listed is primarily for reference purposes. Most of the features/tools listed have comparable functions in all software of the same category (i.e., Word vs. WordPerfect or Excel vs. Lotus 123).

* Specific software listed is primarily for reference purposes. Most of the features/tools listed have comparable functions in all software of the same category (i.e., Word vs. WordPerfect or Excel vs. Lotus 123).

* Specific software listed is primarily for reference purposes. Most of the features/tools listed have comparable functions in all software of the same category (i.e., Word vs. WordPerfect or Excel vs. Lotus 123).

---