Opportunity Junction :: Contra Costa County

Hard skills training is a twelve-week curriculum that covers basic to advanced computer skills, business writing and other essential work place skills, including:

Computer Basics: Participants learn to work with a mouse, manipulate drop down menus, create and save files, and store and manage files with Windows Explorer.
Keyboarding: Participants learn proper typing form, including 10-key and traditional keyboarding. Minimum required speeds are 35 words per minute on the alpha-keyboard and 200 numbers per minute on the 10-key.
Word Processing: Participants learn basic and advanced features of Microsoft Word, including:
1. Manipulating fonts (style, size, character spacing);
2. Setting margins and working with tabs;
3. Inserting symbols, applying borders, shading and colors, working with bullets, numbering and outlines;
4. Creating and modifying headers, footers and footnotes, and creating columns;
5. Using spelling, grammar and thesaurus features;
6. Copying, cutting and pasting text, printing with varying paper orientations and sizes, including labels and envelopes; and
7. Creating a document using a template, and creating, formatting, and manipulating tables, charts and graphs.
Spreadsheets: Participants learn basic and advanced features of Microsoft Excel, including:
1. Creating, spacing and printing a workbook with multiple worksheets, formatting with the Format Painter;
2. Changing column and row height/width, formatting cells and data in cells;
3. Inserting/deleting rows and columns, sorting information;
4. Finding/replacing data, using templates;
5. Working with AutoSum, writing formulas with mathematical operators and functions, using absolute and mixed cell references; and
6. Linking cells between worksheets, creating charts and changing data within charts.
Presentation Software: Participants are taught how to use presentation software to enhance an oral presentation, as well as the mechanics of creating a PowerPoint presentation:
1. Creating slides and using templates;
2. Animating text and objects and adding graphics and cartoons;
3. Adding sound effects;
4. Using charts and embedded objects.
Database Management: Participants learn basic and intermediate features of Microsoft Access, including:
1. Creating a database with a wizard, adding, deleting and editing records and fields;
2. Exporting data to Excel and Word, merging Access data with a Word document;
3. Importing and linking data to a new table, using the Office clipboard;
4. Designing and establishing query criteria, sorting fields in a query, creating a calculated field, using filters; and
5. Creating a primary key, creating a one-to-many relationship, specifying referential integrity, displaying related records in a sub-datasheet and creating a database table using the wizard.
Bookkeeping: Participants learn how to use Intuit QuickBooks to:
1. Create invoices;
2. Apply payments;
3. Prepare deposits;
4. Input accounts payable and pay bills; and
5. Generate financial statements.
Internet Applications: Participants learn to browse the Web, create web pages, establish an email account, insert hyperlinks into pages, attach files to email, conduct basic web research, and download files.
Shared Applications: Participants learn how to use Microsoft Organizational Chart, Microsoft Graph, Microsoft Draw, Clip Art, and skills such as copying and pasting information from one program to another and other features shared by the Microsoft Office suite of programs.
Business Writing: Participants learn basic punctuation, grammar, spelling, sentence structure, and writing formats such as business letters, memos, essays and resumes.