BUS 215 112A
HOSTOS COMMUNITY COLLEGE
BUSINESS DEPARTMENT
BUSINESS & ACCOUNTING UNIT
COURSE SYLLABUS
COURSE INFORMATION:
INSTRUCTOR: Prof. George Cheng
COURSE NAME: Business Applications Using Excel
COURSE NUMBER BUS 215
COURSE SECTION 112A
CREDITS 3.0 crs. – 3.0 hours lecture
OFFICE PHONE #: (718) 518 6521
E-MAIL: GCHENG@HOSTOS.CUNY.EDU
OFFICE HOURS: Tuesday & Thursday 7AM-8 AM & 12:30 PM-1:30 PM, Friday 7AM-8 AM & 10:45 AM-11:45AM, and by appointment
Final Exam Date: Friday, December 19, 2014
COURSE DESCRIPTION
Students will gain detailed knowledge of various electronic spreadsheet technologies that will allow them to perform organization and analysis of a variety of business, personal and organizational tasks. Advance spreadsheet techniques such as formatting, formulas, graphs, macros, and database capabilities and management are taught. Students will use logical decision-making and effective data display to design charts, use data tables and Excel scenarios, enhance decision making with Solver, and troubleshoot workbooks. Through completion of a semester project, the student will learn the practical uses and applications of electronic spreadsheets for business management functions by building various financial scenarios of a corporation.
PRE/CO-REQUISITE
OT 103 or Permission of the Business Department Chairperson or BUS & ACC
Unit Coordinator.
STUDENT LEARNING OUTCOMES
Upon completion of the course, students will be able to demonstrate by means of homework assignments, team projects, lab assignments, exams, and a final exam that they have met the following learning outcomes:
Identify the various elements of an Excel workbook
Apply predesigned formatting to cells in a workbook
Implement basic file management techniques.
Use the Help feature
Develop formulas using Excel
Implement Excel features to create, enhance, and control the formatting of a worksheet
Move
BUSINESS DEPARTMENT
BUSINESS & ACCOUNTING UNIT
COURSE SYLLABUS
COURSE INFORMATION:
INSTRUCTOR: Prof. George Cheng
COURSE NAME: Business Applications Using Excel
COURSE NUMBER BUS 215
COURSE SECTION 112A
CREDITS 3.0 crs. – 3.0 hours lecture
OFFICE PHONE #: (718) 518 6521
E-MAIL: GCHENG@HOSTOS.CUNY.EDU
OFFICE HOURS: Tuesday & Thursday 7AM-8 AM & 12:30 PM-1:30 PM, Friday 7AM-8 AM & 10:45 AM-11:45AM, and by appointment
Final Exam Date: Friday, December 19, 2014
COURSE DESCRIPTION
Students will gain detailed knowledge of various electronic spreadsheet technologies that will allow them to perform organization and analysis of a variety of business, personal and organizational tasks. Advance spreadsheet techniques such as formatting, formulas, graphs, macros, and database capabilities and management are taught. Students will use logical decision-making and effective data display to design charts, use data tables and Excel scenarios, enhance decision making with Solver, and troubleshoot workbooks. Through completion of a semester project, the student will learn the practical uses and applications of electronic spreadsheets for business management functions by building various financial scenarios of a corporation.
PRE/CO-REQUISITE
OT 103 or Permission of the Business Department Chairperson or BUS & ACC
Unit Coordinator.
STUDENT LEARNING OUTCOMES
Upon completion of the course, students will be able to demonstrate by means of homework assignments, team projects, lab assignments, exams, and a final exam that they have met the following learning outcomes:
Identify the various elements of an Excel workbook
Apply predesigned formatting to cells in a workbook
Implement basic file management techniques.
Use the Help feature
Develop formulas using Excel
Implement Excel features to create, enhance, and control the formatting of a worksheet
Move