BCA-145: Spreadsheets

School
Business, Entrepreneurship, & Professional Development
Department
Business Software Applications
Academic Level
Undergraduate
Course Subject
Computer Applications
Course Number
145
Course Title
Spreadsheets
Credit Hours
3.00
Instructor Contact Hours Per Semester
47.00 (for 15-week classes)
Student Contact Hours Per Semester
47.00 (for 15-week classes)
Grading Method
A-E
Pre-requisites
BCA-140 with a C grade or better OR CIS-100 with a C grade or better AND ENG-081 eligible
Co-requisites
Catalog Course Description

Covers the essential features of Microsoft Excel and spreadsheets to prepare and format worksheets. Examines how to insert formulas and functions, create charts and diagrams, insert graphical elements, create and modify tables, perform advanced formatting and functions, track changes, protect and share worksheets, import and export data, and interpret and integrate data.

Goals, Topics, and Objectives

Core Course Topics

Upon successful completion of this course, students should be able to:

  1. Worksheet Preparation.
    1. Create, open, save, and edit worksheets.
    2. Use the auto sum feature.
    3. Use the fill handle to copy formulas.
    4. Select cells.
    5. Apply basic formatting.
    6. Use the help feature.
  2. Formulas.
    1. Develop formulas with mathematical operators.*
    2. Insert formulas using functions.
    3. Use relative, absolute, and mixed cell references.*
  3. Formatting.
    1. Change column width and row height.
    2. Merge and split cells.
    3. Insert and delete cells, rows, and columns.
    4. Apply a theme.
    5. Format numbers.
    6. Use the format painter.
    7. Hide and unhide columns and/or rows.
  4. Enhancements.
    1. Insert headers and footers.
    2. Customize a print job.
    3. Use spell check.
    4. Use find and replace.
    5. Sort and filter data.
  5. Data Manipulation.
    1. Cut, copy, and paste cell content.
    2. Manage worksheets.
    3. Manage windows.
    4. Move data.
  6. Workbook Maintenance.
    1. Manage worksheets and windows.
    2. Create, rename, copy, and delete a folder.
    3. Display a quick list.
    4. Copy a worksheet to another workbook.
    5. Define, apply, copy, and remove a style.
    6. Insert and use a hyperlink.
  7. Charts.
    1. Create, edit, and print a chart.
    2. Change the formatting and layout.
  8. Worksheet Customization.
    1. Insert symbols.
    2. Insert, format, size, and move an image.
    3. Draw and format a text box.
    4. Insert SmartArt.
    5. Create and modify WordArt.
  9. Advanced Formatting.
    1. Create, edit, and delete conditional formatting.
    2. Use special number formatting.
    3. Create a custom number format.
  10. Advanced Functions.
    1. Name ranges.
    2. Use statistical, math, lookup, financial, and logical functions.*
  11. Tables and Data.
    1. Create and modify tables.
    2. Sort and filter tables.
    3. Use data tools.
    4. Group and ungroup data.
  12. Data Summarization.
    1. Summarize data in multiple worksheets.
    2. Use the consolidate feature.
    3. Create a PivotTable and PivotChart.
    4. Use sparklines.
  13. Data Analysis.
    1. Use the paste special feature.
    2. Apply, edit, delete, and compile a scenario.*
    3. Perform what-if analyses.
    4. Use auditing tools.
  14. Worksheet Protection and Sharing.
    1. Manage comments.
    2. Share a workbook.
    3. Protect and unprotect worksheets.
    4. Protect and unprotect the structure of a worksheet.
    5. Track changes.
  15. Macros and Customization.
    1. Save, run, edit, and manage macros.*
    2. Customize the Quick Access toolbar.
    3. Print workbooks to the recent list.
    4. Create, save, and use custom templates.
  16. Data Distribution.
    1. Import and export data.
    2. Prepare a workbook for distribution.
    3. Publish a workbook in PDF, XPS, or HTML format.

Assessment and Requirements

Assessment of Academic Achievement

Students will be assessed through tests, quizzes, homework, and/or class participation.

Credit for Prior College-Level Learning

Options for Credit for Prior College-Level Learning
Other

Approval Dates

Effective Term
Fall 2015
ILT Approval Date
08/26/2015
Curriculum Committee Approval Date
10/05/2015