1. Make effective use of the Excel basic command menus.
2. Apply at least six elementary functions and four advanced functions.
3. Apply and use relative and absolute cell addressing.
4. Apply a minimum of six cell formats.
5. Apply proper design techniques to simple and multi-component
6. Make effective use of all the data transfer features provided in Excel
7. Design, prepare, and utilize a database in Excel.
8. Identify and use the data commands, logic operators and graphics
capabilities of Excel.
9. Create at least 4 kinds of graphics.
10. Solve problems using moderately complex criteria using relational
and logic operations.
1. Introduction to Excel
a. Worksheet compnents
b. Rows, columns, cells, cell addressing
c. Types of data-numbers, labels, formulas, functions
d. Moving about the worksheet
e. Editing the contents of a cell
2. Basic commands and concepts
a. The Excel menu system - access and use
b. Creating formulas - operators, design, implementation
- Copy, Cut, Paste
- Formatting, Alignment
- Insertion and deletion of rows and columns
- Setting column width
d. File handling:
- Save as...
- Print range
- Page setup
- Print dialog
f. Cell addressing - Relative, Absolute, Range Names
- Statistical - SUM, AVERAGE, MIN, MAX, COUNT
- Logical - IF
- Data reference - VLOOKUP,HLOOKUP
- Date and Time - NOW, DATE, DATEVALUE
h. Worksheet design
- General concepts and requirements
- Multi-component, relational conditions
3. a. Advanced functions
- Math - ABS, INT. EXP, SQRT, ROUND
- Financial - PMT
- Data reference - CHOOSE
b. - Database Design
- Database functions - DSUM, DCOUNT, DAVG
- Database manipulation
- Use and design
d. Advanced data commands
- Data tables
- Data distribution
- Data fill
- Data parse
e. Advanced file operations
- File import and export
- File linking
- File merging
|Writing: Assessment tools that demonstrate writing skill and/or require students to select, organize and explain ideas in writing.||Writing
0 - 0%
|This is a degree applicable course but assessment tools based on writing are not included because problem solving assessments and skill demonstrations are more appropriate for this course.
|Problem solving: Assessment tools, other than exams, that demonstrate competence in computational or non-computational problem solving skills.||Problem Solving
20 - 60%
|Homework problems, Field work, Lab reports, Quizzes, Exams||
|Skill Demonstrations: All skill-based and physical demonstrations used for assessment purposes including skill performance exams.||Skill Demonstrations
10 - 20%
|Class performances, Field work, Performance exams||
|Exams: All forms of formal testing, other than skill performance exams.||Exams
20 - 30%
|Multiple choice, True/false, Matching items, Completion, SHORT ANSWER||
|Other: Includes any assessment tools that do not logically fit into the above categories.||Other Category
0 - 0%
Cobb, Douglas, and Allan McGuffey, Microsoft Excel 3 Companion
Microsoft Press, 1991