BCA 212 - Intro Computer Business Appl

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, footers, page breaks, and section breaks.
   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, PMT, 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
   9. Filter and Sort data
   10. Create PivotTables and PivotCharts
   11. Use Subtotals, groups, and outlines
   12. Create and format a variety of chart styles including column, bar, pie, line, waterfall, combination, funnel, sunburst, 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. Import 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
11. Use collaboration and communication software
    1. Use collaboration and communication software terminology
    2. Navigate the Teams interface
    3. Use Teams communication tools
    4. Create channels
    5. Manage meetings, including scheduling, joining, and recording
    6. Share files, pictures, or link
    7. Make a call within the software
    8. Use Teams collaboration features
12. Use cloud-based storage software
    1. Explain SharePoint
    2. Use SharePoint to store, search, share and organize documents within a centralized location that is accessible from any device
    3. Manage permissions to control who can access information
    4. Share documents with team members, commenting on content and tracking changes made to documents
    5. Compare SharePoint and OneDrive
13. Use note-taking software
    1. Explain the core organization system of OneNote
    2. Create a virtual notebook
    3. Create tabs to organize notes into separate notebooks
    4. Use sections to categorize different topics
    5. Embed files into the OneNote pages
    6. Add images, drawings, tables, and clip content from websites
    7. Utilize basic formatting tools to enhance the notes
    8. Share notebooks with others