10106126Software Capstone
Course Information
Description
Apply knowledge learned in previous courses using Microsoft Word, Excel, PowerPoint, Access, and Outlook. Apply industry-standard formats to business letters, reports, and publications. Manage information, apply critical-thinking skills, research topics, and compose a variety of integrated business documents, spreadsheets, databases, and presentations. 
Total Credits
3
Course Competencies
  1. Prepare a full-block letter
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    include all full-block letter parts
    model the full-block letter format example provided
    proofread and edit the document so it contains no errors
    define inclusive language
    explain the importance of inclusive language
    apply inclusive language
    include special letter parts as indicated in the assignment instructions

  2. Prepare a modified-block letter
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    include all modified-block letter parts
    model the modified-block letter format example provided
    proofread and edit the document so it contains no errors
    apply inclusive language
    include special letter parts as indicated in the assignment instructions

  3. Prepare a multiple-page letter
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    include all letter parts, particularly the header on the second and subsequent pages of the letter
    model the two-page letter format example provided
    proofread and edit the document so it contains no errors
    identify different types of inclusive language.
    apply inclusive language
    include special letter parts as indicated in the assignment instructions

  4. Prepare letters using mail merge
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word and Microsoft Outlook
    in submitted files as specified in the assignments
    Criteria
    create a complete, correct mail merged document or email message
    create a main document containing boilerplate text and merge fields that are connected to the data source
    discuss the impact of language on people
    proofread and edit the document so it contains no errors
    apply inclusive language

  5. Prepare newsletters, brochures, or other desktop publishing documents
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    create documents that include graphic features
    model the format examples provided
    proofread and edit the document so it contains no errors
    apply inclusive language
    incorporate special instructions that have been given

  6. Prepare tables
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    create a table of at least three columns and four rows
    create a table with a main heading
    create a table with attributes such as bold and italic font
    demonstrate proper alignment within tables and on the page
    incorporate a table into a full-block style letter
    models the table format example provided
    identify different types of inclusive language
    proofread and edit the document so it contains no errors
    apply inclusive language
    assignment incorporates special instructions that have been given

  7. Prepare protected, fillable forms
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Word
    in submitted files as specified in the assignments
    Criteria
    create fillable forms that include content control fields
    protect fillable forms
    model format example provided
    proofread and edit the document so it contains no errors
    assignment includes special instructions that have been given

  8. Revise documents
    Assessment Strategies
    by submitting mailable documents with all revisions applied
    by submitting documents in an acceptable format
    by submitting documents according to written directions
    Criteria
    apply proofreader marks to revised documents
    apply correct document formatting
    apply inclusive language
    include special instructions that have been given

  9. Create and maintain Access databases
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Access
    in submitted files as specified in the assignments
    Criteria
    build a database that includes tables with fields
    create relationships between tables
    create forms and reports
    create queries
    apply advanced tools to build queries
    apply advanced tools to enhance table design

  10. Create spreadsheets with Excel
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft Excel
    in submitted files as specified in the assignments
    Criteria
    apply formatting to Excel spreadsheets
    perform calculations with formulas and functions
    analyze and chart financial data
    generate reports from multiple worksheets and workbooks
    manage data while using data tools
    summarize data with PivotTables and PivotCharts

  11. Create presentations with PowerPoint
    Assessment Strategies
    actual performance of the skills
    using a computer and Microsoft PowerPoint
    in submitted files as specified in the assignments
    Criteria
    add media and special effects
    apply advanced formatting
    apply advanced animations
    prepare a presentation for distribution
    integrate PowerPoint with other programs