|
Apr 18, 2024
|
|
|
|
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
- Demonstrate understanding of the worksheet.
- Practice how to open, save, close and retrieve worksheet.
- Enter text and numbers.
- Select a range.
- Use editing procedures.
- Apply formulas with correct cell references.
- Use relative cell references.
- Use absolute cell references.
- Use time-saving techniques.
- Copy formulas with the fill handle.
- Use AutoSum, AutoFit, AutoCalculate and Styles.
- Use Find and Replace.
- Format a Worksheet.
- Select different font and type size.
- Change width of columns and height of rows.
- Demonstrate text attributes.
- Apply colors, patterns, and borders.
- Utilize spell-check.
- Activate the spelling checker.
- Use the spelling dialog box.
- Choose apporpriate actions needed to print a report.
- List steps needed to print.
- Show procedure for previewing.
- Outline the available options when printing.
- Choose appropriate print options.
- Apply charting using charting tools.
- Create a column chart and bar chart.
- Create a pie chart.
- Add data labels.
- Annotate and draw on a chart.
- Create sparklines.
- Move an embedded chart to a sheet.
- Add chart elements.
- Format a chart.
- Use Chart Styles.
- Work with formulas and functions.
- Create formulas with operators.
- Use functions - SUM, AVERAGE, MAXIMUM, MINIMUM, COUNT, COUNTA
- Build a conditional formula with the IF function.
- Use OR and NOT logical functions.
- Use VLookup and HLookup functions.
- Round a value using a function.
- Construct formulas with named ranges.
- Use a table to manipulate and analyze data.
- Sort table data.
- Filter table data.
- Summarize data.
- Find and replace table data.
- Extract table data.
- Use Advanced Filter.
- Manage Workbook Data.
- Freeze columns and rows.
- Insert headers and footers.
- Rename and move a worksheet.
- Save workbooks in different file formats.
- Save custom views of a worksheet.
- Add worksheet backgrounds.
- Group worksheets.
- Consolidate data using 3-D references.
Add to Portfolio (opens a new window)
|
|