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, 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