Jun 27, 2019  
2018-2019 Course Catalog 
    
2018-2019 Course Catalog [ARCHIVED CATALOG]

[Add to Portfolio]

BCA 146 - Basic Spreadsheets

Credits: 1
Lecture Hours: 0
Lab Hours: 2
Practicum Hours: 0
Work Experience: 0
Course Type: Voc/Tech
Introduce Microsoft Excel to perform numeric calculations and format data by working with basic formulas; students are introduced to special features including charts, conditional formatting, 3-D references, and linking data between workbooks,  Many functions are introduced including VLOOKUP, PMT, AND, OR, SUMIF, IF, DCOUNT, DAVERAGE. 
Competencies
  1. Demonstrate understanding of the worksheet.
    1. Practice how to open, save, close and retrieve worksheet.
    2. Enter text and numbers.
    3. Select a range.
    4. Use editing procedures.
  2. Apply formulas with correct cell references.
    1. Use relative cell references.
    2. Use absolute cell references.
  3. Use time-saving techniques.
    1. Copy formulas with the fill handle.
    2. Use AutoSum, AutoFit, AutoCalculate and Styles.
    3. Use Find and Replace.
  4. Format a Worksheet.
    1. Select different font and type size.
    2. Change width of columns and height of rows.
    3. Demonstrate text attributes.
    4. Apply colors, patterns, and borders.
  5. Utilize spell-check.
    1. Activate the spelling checker.
    2. Use the spelling dialog box.
  6. Choose apporpriate actions needed to print a report.
    1. List steps needed to print.
    2. Show procedure for previewing.
    3. Outline the available options when printing.
    4. Choose appropriate print options.
  7. Apply charting using charting tools.
    1. Create a column chart and bar chart.
    2. Create a pie chart.
    3. Add data labels.
    4. Annotate and draw on a chart.
    5. Create sparklines.
    6. Move an embedded chart to a sheet.
    7. Add chart elements.
    8. Format a chart.
    9. Use Chart Styles.
  8. Work with formulas and functions.
    1. Create formulas with operators.
    2. Use functions - SUM, AVERAGE, MAXIMUM, MINIMUM, COUNT, COUNTA
    3. Build a conditional formula with the IF function.
    4. Use OR and NOT logical functions.
    5. Use VLookup and HLookup functions.
    6. Round a value using a function.
    7. Construct formulas with named ranges.
  9. Use a table to manipulate and analyze data.
    1. Sort table data.
    2. Filter table data.
    3. Summarize data.
    4. Find and replace table data.
    5. Extract table data.
    6. Use Advanced Filter.
  10. Manage Workbook Data.
    1. Freeze columns and rows.
    2. Insert headers and footers.
    3. Rename and move a worksheet.
    4. Save workbooks in different file formats.
    5. Save custom views of a worksheet.
    6. Add worksheet backgrounds.
    7. Group worksheets.
    8. Consolidate data using 3-D references.



[Add to Portfolio]