Oct 15, 2024  
2024-2025 Course Catalog 
    
2024-2025 Course Catalog
Add to Portfolio (opens a new window)

BCA 212 - Intro Computer Business Appl

Credits: 3
Lecture Hours: 2
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
In a Windows environment, the focus of this course is to use hardware and software as business productivity tools. Training includes a hands-on introduction to computer applications vital in business and industry. The course covers computer terminology, operating system, email, and internet and focuses on software business applications including word processing, spreadsheet, database, and presentation software.
Competencies
 

  1. Discuss a network
  2. Use an operating system
    1. Perform basic mouse operations
    2. Perform changing features on windows: open, minimize, maximize, restore, move, size, scroll, and close
    3. Use menus, toolbars, dialog boxes, scroll bars, and online Help
  3. Use file management
    1. Display drive and folder contents
    2. Discuss file management
    3. Copy, move, rename, and delete folders.
    4. Create folders and subfolders
    5. Search for files, folders, and programs
  4. Use email and calendar management programs
    1. Use file attachments
    2. Use folders to organize email messages
    3. Practice calendar management
    4. Create contacts and meeting invitations
  5. Evaluate common features of business application software
    1. Identify screen elements
    2. Select the application software appropriate for specific tasks
  6. Use a word processing application
    1. Create, edit, save, print, close, and open documents
    2. Use editing and proofreading tools including layout options
    3. Use character and paragraph formatting features such as alignment, line spacing, shading, bullets, borders, font effects, and cut/copy/paste
    4. Utilize page setup options such as customize margins, set and edit tabs, use indents
    5. Insert page numbers, headers, and footers
    6. Format text with columns and tables
    7. Insert and enhance pictures, SmartArt, and shapes
  7. Create worksheets using a spreadsheet application
    1. Build, edit, save, open, close, and print a worksheet
    2. Copy, move, rename, and delete worksheets
    3. Use formulas, what-if analysis, named ranges, and functions in worksheets including SUM, MIN, MAX, AVERAGE, COUNT, IF, SUMIF, COUNTIF, LOOKUP, and 3D References
    4. Perform relative, absolute, and mixed cell referencing
    5. Use built-in features including fill handle, AutoCalculate, Range Finder, and data series
    6. Apply formats in the worksheets
    7. Apply conditional formatting
    8. Create an Excel table, sort, use AutoFilter, create PivotTables and PivotCharts
    9. Use Subtotals, groups, and outlines
    10. Create and format a variety of chart styles including column, bar, pie, waterfall, combination, and sparklines
  8. Utilize a database application
    1. Explain database terminology
    2. Build, edit, save, open, close, and print a database table
    3. Use Datasheet view and Design view to create tables
    4. Create database queries using sort, AND, OR, Totals, parameters, wildcards, and calculated fields
    5. Change database structure and format
    6. Create relationship between tables, and apply referential integrity to tables
    7. Discuss advantages of using forms and reports
    8. Share data from other software applications to the database application
  9. Create a presentation application
    1. Apply principles and techniques of presentation software
    2. Create, edit, save, open, close, and print a presentation
    3. Work with slides, layouts, placeholders, and text
    4. Add, edit, and enhance slides using different layouts, designs, and backgrounds
    5. Add shapes and pictures to slides
    6. Apply transitions, effects, and animations
    7. Insert objects into a presentation
    8. Use Slide Master view
    9. Use slide show tools
    10. Prepare slide outline, notes page, and audience handouts
    11. Create charts, SmartArt, and tables
  10. Integrate word processing, spreadsheet, database, and presentation applications
    1. Use embed and link in the integration process
    2. Utilize import and export features

Competencies Revised Date: AY2023



Add to Portfolio (opens a new window)