Course Development Guide

May 1, 2008

Course Title

Fundamentals Admin. Technologies II

Course Description

This course builds on the Fundamentals of Administrative Technology skills and will provide students with the ability to utilize, analyze and manipulate data through a database application. The integration of multiple applications will build critical thinking skills as students utilize the appropriate applications needed to complete case projects.

Contact

Gina Hubbard
405-743-5117
ghubb@okcareertech.org

OCAS Codes OHLAP Credit Course Length Prerequisites
8407
Yes
120 Hours

The 120 hours is based on a Carnegie unit, which accounts for 175 forty-five (45) minute class periods per school year.

Administrative Technologies

Knowledge and Skills

Microsoft Access Fundamentals--50 hours

Automation and Integration

Data Manipulation

Database Concepts

Database Planning and Design

Forms and Data Input

Multi-User Issues

Reports and Data Input

User Interface and Application Refinement

VBA

Presentation Fundamentals--20 hours

Creating Presentations

  • Identify the different views of a presentation.

  • Describe the different uses for different views.

  • Demonstrate how to change slide and handout orientation.

  • Describe how to Open, Edit, Close, Print, and Save presentations.

  • Use AutoContent and the AutoContent Wizard.

  • Understand how to use Slide Design Templates.

  • Apply slide show transitions, backgrounds, animation schemes and text formatting.

  • Identify pointer options when viewing a presentation.

Help & Research

  • Identify how to set up your Office Assistant to show the Tip of the Day at startup.

  • Know the meaning of the various help and research icons (images).

Menu Bar

  • Understand linking to an Excel spreadsheet.

  • Insert an Excel data range as a link.

  • Utilize spell check for acronyms in a presentation.

  • Apply animation to an object using the menu bar.

Slide Setup & Presentation

  • Insert HTML signatures on slides.

  • Insert/edit slide numbers on presentations.

  • Utilize placeholders to insert text.

  • Apply various layouts to slides.

  • Troubleshoot image use in presentations.

  • Utilize headers and footers to insert information.

  • Apply text formatting options and their icons.

Slide Show Enhancements/Changes

  • Discuss the purpose of Custom Shows.

  • Identify the groups of Animation Schemes available and the colors utilized to make up the schemes.

  • Apply animation to slides.

  • Quickly and efficiently change from one slide show to another.

  • Adjust the speed of slide transitions.

  • Apply voice recordings to presentations.

Editing Text/Objects

  • Demonstrate how to manipulate objects.

  • Demonstrate how to increase the text size on bulleted lists and manipulate the order of bulleted items.

  • Describe how to add and move text.

  • Identify how to find, replace, and review text and fonts.

  • Demonstrate how to move/copy/cut/paste/paste special and utilize shortcut keys to perform tasks.

  • Describe how to modify text size, alignment, spacing, and color.

  • Explain implications to color and formatting when importing from presentation to presentation.

  • Send items from a slide to another application and from another application to a presentation slide.

  • Convert from one type of chart to another.

  • Format text within object.

  • Insert charts into existing slides.

Managing & Delivering a Presentation

  • Discuss the package for CD utility features and limitations.

  • Preview and publish a presentation on the Web.

  • Manage file size for emailing large presentations.

  • Export PowerPoint outlines to other applications.

  • Utilize a PowerPoint presentation to create a Word document.

  • Place an HTML signature on every slide.

Publishing Presentation Documents

  • Identify the maximum number of slides per page when printing handouts.

  • Demonstrate the different page presentation options.

  • Print presentations for various uses:  overhead transparencies, handouts, speaker notes, etc.

  • Align and edit objects, graphics, and text on a slide.

  • Add page numbers to slides.

  • Insert photos into a slide presentation.

  • Utilize drawing tools to create and share drawn objects.

Task Pane

  • Identify which task pane enables you to access Animation schemes.

  • Determine how to access the Office Clipboard and understand the purpose and limitations of the feature.

  • Demonstrate how to create a duplicate presentation.

  • Utilize the short cut key to access the Office Clipboard.

Workgroup Colllaboration

  • Demonstrate how add and reveal comments in a presentation.

  • Describe how to compare and merge presentations.

  • Identify Shared Workspace icons.

  • Utilize the reviewing toolbar and web toolbar features.

  • Identify the difference in original and reviewed versions of a presentation.

Integration – 40 hours

  • Create a memorandum in with an embedded worksheet or graph.

  • Create database data and merge into a word processing document ot create letters, labels, and envelopes.

  • Export data from one application to another.

  • Sort database data in a spreadsheet.

  • Create and link word procesing data into a spreadsheet worksheet.

  • Edit an embedded worksheet.

  • Integrate database, spreadsheet, and word processing documents into presentation software.

  • Utilizing queries,  sort data for specific records in a database and merge into a letter or report.

  • Create, link, and embed spreadsheet charts to word processing documents.

  • Link data between a spreadsheet worksheet and a database table.

  • Ceate and copy a database table into a word processing document.

  • Update linked data and view linked data as an icon.

Brainbench:

http://www.brainbench.com

Career Cluster Resources for Business, Magagement and Administration:

http://www.careerclusters.org/resources/ClusterDocuments/badocuments/BAFinal.pdf

Accountability Measures, Assessments, or Evaluation Procedures

Required Brainbench Certifications (or equivalent industry certifications):

http://www.okcareertech.org/certify/

 Recommended Additional Competency Testing:

Industry Alignments

Brainbench or Microsoft Office Specialist

Curriculum Resources

    Crowley, New Perspectives on Integrating Office XP—Essentials, Southwestern,                     2002 ISBN #0-619-16163-9.

    DDC Learning Microsoft Access

    DDC Learning Microsoft Office--Deluxe Edition

    Integrated Business Projects, Thomson-Southwestern Publishing.

    Integrated Computer Projects, EMC Paradigm Publishing.

    Microsoft Office Projects, Illustrated Series, Course Technology.

    Microsoft Office Applications, Advanced, Pasework& Pasework,
        Course Technology, Course Technology, Thomson Learning.

    Office XP Core---Hinkle, Cain, Marple, and Stewart--A Professional Approach,                     Glencoe ISBN #0-07-825299-7.

    Office XP Core—Hinkle, Cain, Marple, and Stewart—A Professional Approach,                      Glencoe ISBN #0-07-825299-7.

    Microsoft Office XP—Pasewark—Course Technology.

    New Perspectives on Microsoft Office XP—Course Technology.

    Shelly Cashman Series, Course Technology.
        Microsoft Word Comprehensive Concepts and Techniques
        Microsoft Excel Comprehensive Concepts and Techniques
        Microsoft PowerPoint Comprehensive Concepts and Techniques
        Microsoft Windows XP Comprehensive Concepts and Techniques

This Course Found In These Career Majors

Cluster: Business, Management and Administration

Pathway: Business Financial Management & Accounting
Career Major: Billing Clerk
Career Major: Payroll Accounting Clerk
Career Major: Accounts Payable Clerk
Career Major: Full Charge Bookkeeper
Pathway: Administrative & Information Support

Cluster: Finance

Pathway: Financial & Investment Planning