Table of Contents
-
Course Contents
Faculty Resources
Module 1: Intro to Computers
- Why It Matters: Intro to Computers
- Introduction to Operating Systems
- Identifying Your Operating System (OS)
- Introduction to Terminology and Shortcuts
- Common Terminology
- Keyboard Shortcuts
- Introduction to Finding Programs and Files
- Start Menu
- Creating Files and Folders
- Organizing Files and Folders
- Deleting Files and Folders
- Introduction to Snips and Screenshots
- Snips and Screenshots
- Putting It Together: Intro to Computers
- Assignment: Download Files
- Assignment: Identify Your OS
- Assignment: Empty the Recycle Bin
- Discussion: Writing Professionally
Module 2: Internet Research
- Why It Matters: Internet Research
- Introduction to Using and Searching the Internet
- Internet Browsers
- Basic Browser Tools
- Introduction to Basic Searches
- Web Searching
- Identifying Search Results
- Opening Search Results
- Introduction to Advanced Searches
- Adjusting Search Parameters
- Image Searches
- Putting It Together: Internet Research
- Assignment: Search the Internet
- Discussion: Search Results
Module 3: Microsoft Word, part 1
- Why It Matters: Microsoft Word, part 1
- Introduction to Using Word
- Creating a New Blank Document and Finding Your Way Around
- Saving Files
- File Extensions
- Introduction to Basic Text Formatting
- Selecting and Moving Text
- Bold, Italics, Underline
- Fonts
- Alignment, Justification, and Indentation
- Line and Paragraph Spacing
- Introduction to Lists
- Lists
- Putting It Together: Microsoft Word, part 1
- Assignment: Create Basic Document
- Discussion: Paragraph Styles
Module 4: Microsoft Word, part 2
- Why It Matters: Microsoft Word, part 2
- Introduction to Advanced File Creation and Text Formatting
- Creating a New Document from a Template
- Text Effects
- Introduction to Workspace Tools
- Spell Check and Dictionaries
- Find and Replace
- Introduction to Page Layout
- Tab Stops
- Columns
- Headers and Footers
- Introduction to Text Boxes
- Text Boxes
- Putting It Together: Microsoft Word, part 2
- Assignment: Edit a Newsletter
- Discussion: Cover Pages
Module 5: Microsoft Word, part 3
- Why It Matters: Microsoft Word, part 3
- Introduction to Tables
- Creating Tables
- Converting Text to a Table
- Formatting Tables
- Introduction to Images
- Adding Images
- Text Wrap
- Introduction to Hyperlinks
- Hyperlinks
- Introduction to Watermarks
- Watermarks
- Putting It Together: Microsoft Word, part 3
- Assignment: Create Document with Tables and Images
- Discussion: Advanced Shortcuts
Module 6: Microsoft Excel, part 1
- Why It Matters: Microsoft Excel, part 1
- Introduction to Using Excel
- Creating a New Workbook
- Entering Data
- Introduction to Basic Formatting and Layout
- Table Styles
- Cell Styles
- Cell Format
- Comma Styles
- Rearranging Tables
- Changing Width of Columns and Rows
- Introduction to Automating Data Entry
- Flash Fill
- SUM Data
- Putting It Together: Microsoft Excel, part 1
- Assignment: Organize Sales Data
- Discussion: Merging and Centering Cells
Module 7: Microsoft Excel, part 2
- Why It Matters: Microsoft Excel, part 2
- Introduction to Creating Complex Workbooks
- Creating a Workbook with Multiple Worksheets
- Introduction to Using Excel for Data Analysis
- Sorting Data
- Filtering Data
- Functions
- Introduction to Charts and Sparklines
- Clustered Column Charts
- Chart Types
- Sparklines
- Introduction to More Formatting and Layout
- Conditional Formatting
- Viewing a Worksheet
- Putting It Together: Microsoft Excel, part 2
- Assignment: Analyze Yearly Trends
- Discussion: Hard Return within a Cell
Module 8: Microsoft PowerPoint, part 1
- Why It Matters: Microsoft PowerPoint, part 1
- Introduction to Using PowerPoint
- Editing a Presentation
- Organizing Slides
- Views
- Introduction to Objects in PowerPoint
- Text Boxes
- Headers and Footers
- Introduction to Design Elements
- Themes
- Transition Effects
- Putting It Together: Microsoft PowerPoint, part 1
- Assignment: Present Sales Information
- Discussion: Images within Text
Module 9: Microsoft PowerPoint, part 2
- Why It Matters: Microsoft PowerPoint, part 2
- Introduction to Creating Presentations
- New Presentations
- Introduction to Images and Art
- Images and Clip Art
- SmartArt
- Introduction to Videos and Arranged Objects
- Videos
- Arranging Objects
- Putting It Together: Microsoft PowerPoint, part 2
- Assignment: Create a New Presentation
- Discussion: Infographics and Custom Shapes
Module 10: Integration
- Why It Matters: Integration
- Introduction to Using Word with Excel and PowerPoint
- Customized Word Templates
- Excel Table in Word Document
- Excel Chart in Word Document
- PowerPoint in Word Document
- Icons in Word
- Introduction to Using PowerPoint with Excel
- Customized PowerPoint Templates
- Excel Table in PowerPoint
- Excel Chart in PowerPoint
- Introduction to Using Internet Tools with Microsoft Office
- Internet and Excel
- Internet and Word
- Internet and PowerPoint
- Introduction to Videos in PowerPoint
- Inserting Videos in PowerPoint
- Embedding Videos in PowerPoint
- Uploading Videos in PowerPoint
- Putting It Together: Integration
- Discussion: Audio Integration
- Assignment: Use Mail Merge
Resources: Capstone Assignment
-
