|
|
|
May 05, 2024
|
|
Catalog 2020-2021 [ARCHIVED CATALOG]
|
BTE 212 Excel II5 credits
This course covers in-depth theory and application of spreadsheets. Topics include macros, databases, what-if analysis, pivot tables, import/export, advanced formulas and creating and managing files.
Prerequisites: BTE 112 and MATH 087 (or equivalent placement scores for MATH 098 or higher)
Course Outcomes
Upon successful completion of this course students will be able to:
- Work quickly and accurately in a spreadsheet application
- Demonstrate proficiency in creating, modifying, and enhancing worksheets
- Use advanced formula writing, functions, and templates
- Solve problems and analyze data in business-related areas
- Audit work
- Create, modify, format, save, and print databases
- Import and export data
- Gather data and generate charts
Program Outcomes
This course teaches to the following program outcomes:
- be prepared for entry-level positions as a business support professional
- carry out office administration procedures and management support using office technology
- use Microsoft Office software to produce complex integrated documents and spreadsheets
Total Hours: 60 Theory (Lecture) Hours: 40 Guided Practice (Lab or Clinical) Hours: 20
|
|
|
