Welcome to COMP 1020 - Spreadsheet Fundamentals with Excel! This website is designed to keep you informed about the schedule of the course.
Meeting Time and Place
| Time: | T 8:45 - 9:40 a.m. |
| Location: | Art & Communication C142 |
Instructor
| Name: | Dr. Barry Wittman |
| E-mail: | wittman1@otterbein.edu |
| Office: | Art & Communication C123 |
| Phone: | (614) 823-2944 |
| Office Hours: |
MWF 9:00 – 10:15 a.m. MWF 1:45 – 2:45 p.m. (in C142) W 4:00 – 5:00 p.m. TR 10:00 – 11:30 a.m. TR 2:00 – 4:00 p.m. and by appointment |
Text Book
|
Alex Scott |
 |
Course Catalog Description
A hands-on introduction to spreadsheet concepts and Microsoft Excel. Completion of web-based training exercises as well as independently-produced projects.
For official course syllabus, please click here.
Student Learning Outcomes
By the end of the course, students will be able to:
- Create multi-page Excel spreadsheets
- Apply Excel functions effectively and correctly
- Create formulas containing cell references
- Use relative and absolute references to cells on multiple worksheets
- Apply formatting techniques to effectively visualize cell data
- Use charting techniques to effectively visualize spreadsheet information
- Create and work with tables
- Use conditional cell formatting
- Perform what-if analysis
