PROGRAM FLYER

Computer Education

Material Fee: None

Day Classes:
Monday – Friday
1st Period: 8:20am – 10:20am
2nd Period: 10:30 am – 12:30 pm

Evening Classes:
Tuesday, Wednesday Thursday 5:30 pm – 8:30 pm

Programs Offered

* Indicates Articulation with Bakersfield College

Click below for more information:

Introduction to Computers

Computer Basics

Logging In, Using the Mouse, Launching Programs
Organizing Documents and Folders
Adjust Computer Settings

Browsing the Web

Locating and Downloading Information Online
Bookmarking Webpages

Microsoft Word Basics

Create, Open, Save and Print Documents
Format Text and Images
Spell Check + Find and Replace

Microsoft Outlook

Sending and Receiving Email Messages with Attachments
Store and Access Contact Information
Add Appointments and Meetings to Your Calendar

Introduction to Microsoft Word

Business Letters

Line Spacing
Bulleted and Numbered Lists
Printing, Saving, and Creating Documents and PDF's

Tables and Resumes

Rows
Columns
Table Styles

Promotional Brochures

Pictures and Textboxes
WordArt
SmartArt
Page Backgrounds

Mail Merge

Letters
Envelopes
Labels

Business Reports

Headers, Footers, and Captions
Footnotes, Endnotes, and Citations
Bibliographies, Tables of Content and Tables of Figures

Newsletters

Columns and Sections
Design Themes
Page Parts and Style Sets

Advanced Microsoft Word

Large Documents

Symbols
Navigation
Custom Styles

Collaborating and Combining Documents

Cross-References
Indexes and Concordances
Text and Table Captions

Sharing and Securing Content

Reviewing, Tracking, and Comparing Documents

Document Inspection, Passwords, and Digital Signatures

Personalizing Word

AutoCorrect, AutoFormat
Custom Word Options
Custom Word Properties

Integrating Word with Excel, PowerPoint, and the Web

Embedding and Linking Spreadsheet and Presentation Objects
Mail Merge and Creating Web Pages
Modifying PDF's

Introduction to Microsoft Excel

Sreadsheet Basics

Entering and Editing Data
Formatting Data
Using AutoFill

Creating Formulas

Use formulas to perform calculations
Use 3D Cell References
Using Function Formuls (SUM, MIN, MAX, AVERAGE)
Naming Cells and Ranges

Inserting Charts and Media

Creating Column, Bar, Pie, and Area Charts
Adding Chart Elements such as Data Labels and Titles
Inserting Pictures, ClipArt, and Watermarks

Organizing Large Worksheets

Using Templates
Adding Headers, Footers, Page Breaks, Titles and Columns
Working with Tables, Data Validation, and IF Functions

Workbook Formatting

Formatting with Themes
Custom Cell Formatting
Applying Workbook Themes and Quick Styles

Advanced Microsoft Excel

Functions and Formatting

Working with Conditional Formatting
Inserting Date Functions and Formatting
Creating Custom Formats

Financial Fnctions and What-If Analysis

Using Data Analysis Tools and Solver
Using Scenario Manager and Using Data Tables

Text Functions, Conditional Functions, and Formula Auditing

Using Flash Fill and the CONCATENATE Function
Tracing Formulas
Tracing Dependents

Lookup Functions and Outlines

Using Quick Analysis
Using the Outline Feature
Creating Groups Manually and Displaying Subtotals

Working with Tables

Understanding Structured References and Formulas
Using SUBTOTAL to Calculate Filtered Lists
Creating Sparklines in Cells

PivotTables and PivotCharts

Creating and Formatting PivotTables and PivotCharts
Filtering and Editing PivotTable Calculations
Wokbook

Microsoft PowerPoint

Creating and Deliverting Presentations

Adding Slides and Deleting Slides
Adjusting Layouts and Applying Themes
Running Slide Shows

Adding Graphics and Animation

Adding Pictures and Shapes
Applying Slide Transitions
Applying Animations and Sound Effects

Inserting Charts, Tables, and SmartArt

Inserting Excel Charts
Organizing Information in Tables
Adding SmartArt Infographics

Adding Audio and Video Multimedia

Inserting Music and Narration
Inserting and Trimming Videos
Rehearse Slide Timings

Introduction to Microsoft Access

Building Databases

Creating Tables and Modifying Properties
Add and Delete Records
Sort and Filter Records

Querying Databases

Wildcards and Date Criteria
Calculated Queries
Select, Unmatched, Duplicate Queries

Relational Databases

Adding Lookup Fields
Enforcing Referential Integrity

Forms and Reports

Adding and Deleting Controls
Applying Themes and Personal Customizations
Designing and Printing Reports

Advanced Microsoft Access

Refining Table Design

Create and Modify Database Relationships
Enhance Datasheets and Field Properties

Customizing Input Forms

Creating Complex Forms
Adding Calculations
Creating Pop-Up Forms

Creating Complex Queries

Parameter, Action, Append, Update and Delete Queries
Multi-Table Reports Based on Queries
Calculated Fields and Totals

Customizing Reports

Creating Subreports
Customizing Controls
Analyzing Report Performance

Database Interface and Startup Options

Customizing the Navigation Pane
Add Command Buttons
Setting Startup Options

Importing and Exporting Data

Integrating Word and Excel
Adding Hyperlinks
Publishing to the Web

Microsoft Office*

This six-week, managed enrollment course will provide you with knowledge and skills to create professional business letters, memorandums, and press releases, apply basic formatting to text, create tables and formulas, spreadsheets, SmartArt, transitions, and animations, media such as pictures and video, new databases, set up tables in design view, sort and filter records, create and run queries, create simple forms and reports, and work with relationships. It includes all of the curriculum from the Introduction to Word, Introduction to Excel, Introduction to Access, and PowerPoint class. This course is articulated with Bakersfield College.

Adobe Photoshop

Cropping and Straightening Images
Modifying Canvas Size, Color Mode, and Bit Depth
Adjusting Color and Tone
Using Generative AI to Generate, Enhance Restore Images
Selecting, Resizing, and Moving Objects on the Artboard
Adding Typography Including Text on a Path, Warped Text, and Paragraphs
Arranging, Masking, and Flattening Layers
Adding Applying Adjustment Layers and Layer Effects
Drawing Vector Shapes and Paths
Applying Smart Filters
Painting Artwork with a Variety of Brushes
Using Adobe Camera RAW to Retouch, Process and Synchronize Photographs
Using Puppet Warp to Reshape Images
Work effectively in Adobe Bridge

Adobe Illustrator

Navigate, Rename, Reorder, and Resize Artboards
Select, Group, Align, and Distribute Objects
Create, Edit and Blend Colors and Shapes
Convert Images into Editable Vector Art Using Image Trace
Create and Combine Custom Shapes Using the Shape Builder Tool and Pathfinder Panel
Create and Organize Custom Artwork Using Rulers and Guides to Organize
Join and Edit Paths with the Curvature Tool
Apply a Variety of Stroke Styles
Draw, Edit, and Curve Lines and Anchor Points Using the Pen Tool
Enhance Artwork Using Live Paint, Generative Recolor, and Appearance Attributes
Create Typographic Design Including Columns of Text, Text on a Path, Warped Text, Glyphs, and Paragraph Styles
Create, Rearrange, Lock, Search, Filter, and Apply Clipping Masks to Layers and Sublayers
Apply Gradients, Blends, and Patterns

Apps for Business Workshops