Training Manuals

Brushing up after a workshop or practicing on your own? All of the Software Training for Students manuals and class files are available to use outside the classroom as well. Not all workshops have a manual and/or files associated with them, but all of our current material is available for you to browse for free.

Access 1

Topics covered:

  1. Database Concepts
  2. Importing and Exporting Data
  3. Manipulating Tables
  4. Conclusion
  5. Appendix A: Tips for Creating Databases
  6. Appendix B: Referential Integrity

Access 2

Topics covered:

  1. Editing Relationships
  2. Queries
  3. Forms
  4. Reports

Audacity

Topics covered:

  1. Navigating the Workspace
  2. Basic Audio Editing
  3. Audio Effects
  4. Saving and Exporting

Comic Life

Topics covered:

  1. Create a Comic
  2. Menu and Preferences
  3. Workspace Elements
  4. The Inspector
  5. Saving and Exporting

CSS 1

Topics covered:

  1. Basic CSS Structure
  2. Setting up a Workspace
  3. Implementing CSS
  4. Properties and Values
  5. Selectors
  6. Positioning
  7. Custom Fonts
  8. Further Resources

Excel 1

Topics covered:

  1. Navigating the Excel Environment
  2. Entering and Editing Data
  3. Using Formulas and Functions
  4. Basic Charts
  5. Importing Data
  6. Viewing, Sorting, & Filtering Data
  7. Saving and Printing

Excel 2: Analysis

Topics covered:

  1. Input Tables
  2. Subtotal
  3. Goal Seek
  4. Solver
  5. Analysis ToolPak

Excel 2: Functions

Topics covered:

  1. Workbooks, Worksheets, and Linking
  2. Data
  3. Logical Functions
  4. Lookup, Array, and Summary Functions
  5. Text Formatting
  6. Formulas Tab

Excel 3: Macros and VBA

Topics covered:

  1. Macros
  2. VBA and the Visual Basic Editor
  3. Recording Macros
  4. VBA: The Basics
  5. VBA: Variables, Objects, and While
  6. VBA: If
  7. VBA: For
  8. VBA: Select-Case
  9. VBA: Debugging Our Macro

HTML

Topics covered:

  1. Web Technology Overview
  2. Basic HTML Syntax
  3. Getting Started
  4. Document Setup
  5. Formatting Text
  6. Document Structure
  7. Lists and Tables
  8. Links
  9. Pages
  10. Images
  11. Classes and IDs
  12. CSS Preview
  13. Quick Reference

Illustrator 1

Topics covered:

  1. The Illustrator Interface
  2. Navigating the Workspace
  3. Working with Shapes
  4. Creating the Star Icon
  5. Creating the Atom Icon
  6. Combining Shapes with Pathfinder
  7. Drawing with the Pen Tool
  8. Creating the Leaf Icon
  9. Gradients and Effects
  10. Effects
  11. Working with Type
  12. Saving/Exporting Final Artwork
  13. Essential Keyboard Shortcuts

iMovie

Topics covered:

  1. Copyright and Fair Use
  2. iMovie Interface
  3. Basic Editing
  4. Advanced Etiing Tools
  5. Content Library: Music, Titles, Transitions
  6. Movie Trailers
  7. Saving and Exporting

InDesign 1

Topics covered:

  1. Page Layout in Adobe InDesign
  2. Understanding the Workspace
  3. Navigating the Workspace
  4. Planning the Document
  5. Working with Shapes
  6. Working with Layers
  7. Working with Text
  8. Working with Graphics and Images
  9. Master Pages
  10. Extra: Create a Cover Page
  11. Saving, Exporting & Packaging

JavaScript 1

Topics covered:

  1. Introduction to JavaScript
  2. JavaScript Basics
  3. ToDo List Web Application
  4. Variables, Functions, Objects, and the DOM
  5. ToDo List Web App Continued
  6. Documentation
  7. Conclusion

Photoshop 1

Topics covered:

  1. Photoshop Interface
  2. Navigating the Workspace
  3. Resizing, Cropping, and History States
  4. Basic Image Adjustments
  5. Image Retouching
  6. Brush and Type Tools
  7. Creating a Poster
  8. The Layers Panel
  9. Adding Shapes and T ext
  10. Saving and Exporting
  11. Next Steps
  12. Digital Image Glossary

Photoshop 2: Effects and Filters

Topics covered:

  1. Graphics Molding
  2. Lighting Effects
  3. Content-Aware
  4. Advanced Warping
  5. Photographic Blur Gallery
  6. Blending Modes
  7. Optional: Actions
  8. Optional: Batch Processing
  9. Blending Modes Glossary

Photoshop 2: Portrait Retouching and Color Correction

Topics covered:

  1. Color Correction
  2. Layer Masks
  3. Balancing Skin Tone
  4. Healing Tools for Retouching
  5. Colorizing Black and White Photos
  6. Beauty Enhancements
  7. Final Words

PowerPoint

Topics covered:

  1. Slideshow Basics
  2. Building Slideshows
  3. Automated Content
  4. PowerPoint as a Design Tool
  5. Exporting Content

Premiere Pro

Topics covered:

  1. Interface and Navigation
  2. Importing and Organizing Media
  3. The Timeline
  4. Edits and Tools
  5. Titles and Transitions
  6. Exporting
  7. Appendix

Prezi

Topics covered:

  1. Creating a Prezi Account
  2. Creating a New Prezi
  3. Adding Content
  4. Paths and Animations
  5. Presenting Your Prezi
  6. Additional Information

Python 1

Topics covered:

  1. Simple Data Types
  2. Sequence Data Types
  3. Creating Runnable Scripts
  4. Functions
  5. Standard Library

Tableau

Topics covered:

  1. Connecting to Data
  2. Creating Visualizations with Worksheets
  3. Combining Worksheets with a Dashboard
  4. Publishing

WordPress 1

Topics covered:

  1. Creating an Account
  2. Interface
  3. Stats
  4. Publish
  5. Personalize
  6. Configure
  7. Conclusion