WESTERN
Business and Technical Education Division
OFFICE SYSTEMS
TECHNOLOGY
COURSE SYLLABUS
COURSE NUMBER: BCIS 1513
COURSE TITLE: Intro to Spreadsheets
CREDIT HOURS: 3 credit hours.
PREREQUISITE: Fundamental knowledge of Business Math and/or Accounting; Keyboarding
COREQUISITES: None
CATALOG DESCRIPTION:
A study of spreadsheet design and application, focusing on the use of spreadsheets to prepare reports and analyze data, including charts. Introduction to spreadheet commands and capabilities. (LAS)
TEXTBOOK: Illustrated Series, Microsoft Excel 2002, Complete Edition, Elizabeth Eisner Reding and Lynn Wermers. Course Technology ,
2002.
SUPPLIES: Two 3 ½" double-sided, high density diskettes
One binder and dividers
LEARNING OUTCOMES:
After completing this course, the student should be able to:
1.0 Launch the spreadsheet software, maneuver the cursor within a window, and manipulate a window.
2.0 Create and edit basic business worksheets and charts.
3.0 Using the software to performing calculations.
COURSE REQUIREMENTS:
See instructor information sheet for specific course requirements.
METHOD OF EVALUATION:
See instructor information sheet for specific course requirements.
ATTENDANCE POLICY:
Regular attendance in class is crucial for success. Students are expected to attend each class. Each absence from class will adversely affect a student's grade for the course. Individual instructors are responsible for developing specific policies (see instructor information sheet). Please see the instructor regarding anticipated absences or conflicts due to college sponsored activities.
ACADEMIC ETHICS:
All work is expected to be your own. If unethical behavior is detected, ALL parties involved will be denied points for that homework or exam. The questioned material and a report of the ethics violation will be submitted to the department chair for further action as deemed necessary by the department chair.
COURSE COMPETENCIES:
1.0 Getting Started with Excel 2002.
2.0 Building and Editing Worksheets
3.0 Formatting a Worksheet
4.0 Working with Charts
5.0 Working with Formulas and Functions
6.0 Managing Workbooks and Preparing Them for the Web
7.0 Automating Worksheet Tasks
8.0 Using Lists