Getting Started

Introduction
Organizing and Saving Your Project Files
​Download and Unzipping Student Files
Your Clients
Curriculum Guide

Microsoft Word

1.1 Ranch Services
​       Creating Your First Document
1.2 Mission Statement
       Customizing Views
1.3 Fall Soccer Registration*
​       Creating a Poster
1.4 Who's Your Owner
      Working with Headers and Footers
1.5 The Daily Grind*
      Creating Lists
1.6 Safety First
       Formatting lists
1.7 Your New Best Friend*
       Inspecting a Document
1.8 Camps and Clinics Announcement*
       Working with Text Boxes
1.9 Raffle Contest Letter
       Creating a Block Style Letter
1.10 Homesick Hound Letter
       formatting a Block Style Letter
1.11 Wi-Fi Access Sign
       Designing a Sign
​1.12 The Barkery Grand Opening
       Designing an Advertisement
1.13 Client Agreement
       Working with Signature Lines
1.14 Concussion Report (SKIP)
​       Creating an MLA Style Report
1.15 Pet Adoption Report (SKIP)
       Formatting an MLA Style Report
1.16 Customer Loyalty Card
       Working with SmartArt
1.17 Liability Waiver
       Working with Footnotes and Endnotes
1.18 Training Certificate
       Using Templates
1.19 Puppy Profile Form
       Working with Page Breaks
1.20 What's Brewin'?
       Creating a Newsletter
1.21 Fundraising Steps
       Creating a Memo
1.22 Common Issues Memo
       Formatting a Memo
1.23 Soccer Player Registration
       Formatting a Table of Contents
1.24 Everything You Need to Know
​       Working with Bookmarks

​
Review and Practice


​

Microsoft Excel

 2.1 Our Pack (2 days)*
       Creating Your First Workbook
2.2 Equipment List (2 days)
       Working with Named Ranges and Views
2.3 Player 411 (2 days)
       Printing Part of a Worksheet
2.4 Daycare Daily Schedule (3 days)* DO LATER IN QUARTER
       Working with Cells
2.5 House Music Playlist (2 days)*
       Working with Multiple Worksheets
2.6 Pack It Up (2 days)* SKIP
       Viewing Data
2.7 Accounts Receivable Journal 
      Formatting Data
2.8 Customer Order Form
       Working with Text Boxes, Images & Shapes
2.9 Doggie Report Card*
        Modifying Page Setup
2.10 Checkbook Register
       Displaying Formulas
2.11 Projected Gross Sales
       Creating Tables
2.12 Expense Reports
       Performing Calculations Using SUM
2.13 Referee Referral (Skip or Save for later)
       Formatting Text
2.14 Doggie Data
       Importing Data
2.15 Supplier Database (3 Days)
       Working with Page Breaks & Themes
2.16 Order History
       Performing More Calculations
2.17 How Are We Doing? (SKIP? DIFFICULT!)
        Performing Logical Operations
2.18 Doggie Drive
       Outlining Data
2.19 Trophy Order Form
        Inspecting Workbooks
2.20 Daily Sales Record
       Applying Conditional Formatting
2.21 Sales Forecast
       Creating Charts
2.22 Building Occupancy Trends
       Inserting Sparklines
2.23 Combination Meal Nutrition
       Analyzing Data
2.24 Profit and Loss Budget
       Formatting Charts
2.25 Tournament Standings
       Modifying Charts

Microsoft PowerPoint

  3.1 Meet Our Breeds (1 Day)
       Creating Your First Presentation
3.2 Event Schedule (2 Days)
       Formatting Text
3.3 Nutrition Class (1 Day)
       Applying Transitions
3.4 Let's Go Outside
        Printing a Presentation
3.5 App Design (2 Days)
       Creating a Wireframe Presentation
3.6 Sports Complex Map (3 Days)
       Working with Images
3.7 Agility Course Design
       Applying Animation
3.8 Make Your Own Hot Cocoa bar
       Formatting SmartArt
3.9 Be Careful (3 Days)
       Printing Notes and handouts
3.10 Puppy Cam (no video) (SKIP)
       Working with Comments
3.11 Pastry Chef Profile
       Saving a Presentation As a Video
3.12 Entrepreneurship Expo (no video)
       Presenting a Slide Show
3.13 Fitness Class Schedule (no video)
       Creating Tables
3.14 Menu (no video)
       Rehearsing a Presentation
3.15 Pet Care Check (no video)
       Modifying Slide Order
3.16 Latte Art (no video)
       Working with multiple Presentations
3.17 Trampoline Park Investors (no video)
       Formatting the Slide Masters
3.18 Franchise Pitch (no video)
​       Using Templates
3.19 Name That Coffee (no video)
       Formatting Charts