Jan 15, 2021  
2016-2017 Catalog 
    
2016-2017 Catalog [PAST CATALOG]

CTA 110 - Personal Computer Office Suite Applications

4 credit hours - Four hours of lecture and directed laboratory weekly; one term.
(formerly CSI 121 - Personal Computer Office Suite Applications)

Learn office suite software using Microsoft Office. Acquire hands-on experience with the Internet and Web, word processing, spreadsheet, database management and presentation graphics, satisfying computing needs in a range of applications. Integrate data among the different software applications in the suite. Lab fee $25.

Note: Users with no prior software applications experience are encouraged to take one of the following before taking this course: CTA 100  or CTA 103 .

Course Outcomes
Upon successful completion of this course, students will be able to:
 

  • Introduction to Microsoft Office
    • Describe the Office  applications
    • Start an Office  application
    • Use the Ribbon, dialog boxes, and task panes
    • Use menus, context menus, and shortcut keys
    • Use Backstage view
    • Open, close, and save files
    • Navigate a document
    • Enter, edit, and format text
    • Select, copy, and move text
    • Undo and redo changes
    • Specify document properties
    • Print a document
    • Use Office  Help
    • Exit an Office application
  • Word: Create and Edit a Document
    • Develop a document
    • Identify “best practices” when developing a document
    • Insert and delete text and blank lines
    • Use spelling and grammar checking
    • Use AutoCorrect
    • Cut and copy text
    • Change fonts and type sizes
    • Bold and color text
    • Change alignment
    • Insert and size pictures
    • Print a document
    • Use a template
  • Word: Revise and Refine a Document
    • Use the Spelling and Grammar tool and the Thesaurus
    • Work with multiple documents
    • Control document paging
    • Find and replace text
    • Insert the current date
    • Change indents, line spacing, and margins
    • Create a tabbed table
    • Create web pages
    • Add color highlighting and underlines
    • Create numbered and bulleted lists
    • Create and use Building Blocks
    • Insert and modify a shape
    • Add a page border
    • Secure content and share documents
    • Prepare and print envelopes
  • Word: Create Reports and Tables
    • Apply and customize quick styles
    • Navigate by browsing headings and pages
    • Create a cover page
    • Apply and customize document themes
    • Create and update a table of contents, table of figures, and an index
    • Add citations and create a bibliography
    • Add footnotes, captions, and cross-references
    • Wrap text around graphics
    • Create and format a simple table
    • Add headers, footers, and page numbers
    • Evaluate existing Word documents using your checklist
  • Excel: Create and Edit a Worksheet
    • Identify some “best practices” to use when developing Excel spreadsheets
    • Create a new worksheet
    • Enter and edit data
    • Modify column widths and row heights
    • Use proofing tools
    • Copy and paste cell contents
    • Create formulas
    • Insert and delete rows and columns
    • Format cells and cell content
    • Hide and unhide rows and columns
    • Create a basic chart
    • Format values as a date
    • Preview and print a worksheet
    • Display and print formulas
    • Change worksheet orientation and scale content
  • Excel: Enhance a Worksheet with Graphics and Charts
    • Apply and customize themes
    • Use cell styles
    • Insert and size a graphic
    • Create a chart
    • Move, size, and format a chart
    • Change the type of chart
    • Create, explode, and rotate a pie chart
    • Apply patterns and color to a chart
    • Document a workbook
    • Size and align a sheet on a page
    • Add predefined headers and footers
  • Excel: Managing and Analyzing a Workbook
    • Use absolute references
    • Copy, move, name, and delete sheets
    • Use AutoFill
    • Reference multiple sheets
    • Use Find and Replace
    • Zoom the worksheet
    • Split windows and freeze panes
    • Use what-if analysis and Goal Seek
    • Create Sparklines
    • Control page breaks
    • Add custom headers and footers
    • Print selected sheets and areas
    • Evaluate existing Excel spreadsheets
  • Access: Create a Database
    • Plan, create, and modify a database
    • Create and save a table structure
    • Define field names, data types, field properties, and primary key fields
    • Enter and edit data
    • Add attachments
    • Change view
    • Adjust column widths
    • Use the Best Fit feature
    • Navigate among records
    • Add, copy, and move fields
    • Add and delete records
    • Document a database
    • Preview and print a table
    • Change page orientation
    • Close and open a table and database
  • Access: Querying Tables and Create Reports
    • Evaluate table design
    • Modify relationships
    • Enforce referential integrity
    • Create and modify a simple query
    • Query two tables
    • Filter a query
    • Find unmatched and duplicate records
    • Create a parameter query
    • Create reports from tables and queries
    • Display a Totals row
    • Modify a report design
    • Select, move, and size controls
    • Change page margins
    • Preview and print a report
    • Compact and back up a database
    • Integrate Access tables into Word documents and Excel spreadsheets
  • PowerPoint: Create a Presentation
    • Use a template to create a presentation
    • View and edit a presentation
    • Copy and move selections
    • Move, copy, and delete slides
    • Move, demote, and promote items
    • Use a numbered list
    • Check spelling
    • Size and move placeholders
    • Change fonts and formatting
    • Insert and modify clip art
    • Run a slide show
    • Document a file
    • Preview and print a presentation
    • Identify some “best practices” to use when developing PowerPoint presentations
  • PowerPoint: Revise and Refine a Presentation
    • Find and replace text
    • Create and enhance a table
    • Insert pictures
    • Modify graphic objects
    • Create and enhance shapes
    • Create a text box
    • Change the theme
    • Modify slide masters
    • Add animation, sound, and transitions
    • Control a slide show
    • Add speaker notes
    • Add and hide slide footers
    • Customize print settings
  • Integrate Office Applications
    • Copy and paste text between applications
    • Paste, embed, and link Excel charts in Word
    • Copy text from Excel and Word into a PowerPoint presentation
    • Embed tables from Word into a PowerPoint presentation
    • Link charts from Excel into a PowerPoint presentation
Core Competencies