| 9a. Catalog Description: |
| Provides a thorough study of spreadsheet operation and enables the student to use the spreadsheet to perform mathematical computations and analysis. Students will create graphic representations of the information contained in a spreadsheet, perform list management routines, use functions, perform "what if" analysis, customize toolbars and menus, and create macros using Visual Basic for Applications. |
| 9b. Other Catalog information: |
| None |
| |
| 10. Student Performance Objectives: |
As a result of successful completion of this course, a student will be able to:
1. Create a workable spreadsheet to solve a complex business-related problem
2. Construct proper spreadsheet formulas to provide automatic recalculation of variable data.
3. Select appropriate graphic charts to provide reliable analytic analysis.
4. Analyze and select from available functions that will assist in solving a problem.
5. Describe the purposes and uses of various spreadsheet commands.
6. Demonstrate the use of "what-if" analysis in solving business-related problems.
7. Demonstrate the creation of macros to automate various spreadsheet routines.
8. Demonstrate the ability to transfer data between and among other software programs, such as word processing, databases, and other spreadsheets.
9. Analyze a complex spreadsheet-related problem and explain how to solve the problem.
10. Develop web pages using Excel; create Hyperlinks and Hypertext cells. |
| |
| 11. Methods of Evaluating Student Achievement: |
1. Written examinations that require the student to demonstrate knowledge of Microsoft Excel and its problem-solving features.
2. Hands-on examinations that require the student to demonstrate problem-solving techniques involving critical thinking.
3. Lab assignments requiring the students to demonstrate proficiency utilizing various Microsoft Excel routines with increasing complexity as the term progresses. |
| |
| 12. Student Assignments (Homework): |
| |
| a. Required Reading Assignments: |
| Approximately 30-40 pages per week |
| |
| b. Required Writing Assignments: |
| Reading assignments from computer magazines |
| |
| c. Other (Terms projects, research papers, portfolios, etc.) |
| None |
| |
| 13. Course Content Outline: |
Students will be required to analyze, evaluate, compare, and contrast the following concepts, characteristics, and techniques.
I. Introduction to Electronic Spreadsheets
A. Definition and role in problem solving
B. Worksheet and Workbook navigation
C. Data entry and modification
II. Operation of Excel Spreadsheet
A. Building Formulas
B. Editing the Worksheet
C. Using toolbar and menus
D. Formatting Test and Value Cells
E. Built-in Worksheet Functions
F. Printing worksheets and workbooks
III. Charting
A. Creation of Spreadsheet Charts and Graphics
B. Printing of Spreadsheet Graphics
C. Selecting the appropriate chart type
D. Formatting charts
IV. What-If Spreadsheet Analysis
A. Worksheets as Analysis Tools
B. Analyzing Data Distributions
V. Advanced Data Management using Excel
A. Database/List Management routines
B. Queries
C. Data extracts
D. Pivot Tables
E. Other database routines
VI. Creating and Using Macros Using Visual Basic for Applications
A. Creating and modifying
B. Debugging macros
C. Customizing macros
D. Solving special problems
VII. Data Transfer Techniques
A. Dynamic linking
B. Object linking and embedding
C. Exchanging data between word processors, databases, and other spreadsheets
D. Importing and exporting data
VIII. Advanced Applications
A. Decision making
B. Problem solving techniques
C. Critical analysis using spreadsheets
D. Solving complex business-related problems
E. Working with multiple workbooks
F. Data consolidation techniques
IX. Using Excel with the Internet
A. Using Hypertext and Hyperlinks
B. Creating Web pages using Excel
X. Customizing toolbars, icons, and menus
A. Creating and modifying toolbars
B. Using the button editor
C. Building user interfaces with menus
D. Attaching macros to toolbars and menus |
| |
| 14a. All textbooks, resources and other materials used in this course are: |
| College level
|
| |
| 14b. EXAMPLE texts, reading and resources:
|
Robert T. Grauer and Maryann Barber. Excel 2003. Comprensive Edition
Pwarson-Prentice Hall, 2003
|
