OTEC 153 Spreadsheets provides students with a working knowledge of electronic spreadsheets using Microsoft Excel. Students will learn how to design, create, modify, and present professional-looking spreadsheets for use in today's workplace. Exercises include using formulas and built-in functions to solve mathematical problems. Students will also learn how to illustrate and present spreadsheet data in graphic form.
Accessibility Services Notice
Students who would like an academic accommodation and who have a documented disability should contact Accessibility Services, if they have not already done so.Course Details| Total number of weeks | 8 |
|---|
| Total Credits | 1.50 |
|---|
| Total Hours | 45 |
|---|
Typical hours per week breakdown| Other | 45 |
|---|
Learning Outcomes
Upon successful completion of this course, the learner will be able to:
- plan, create, modify and present spreadsheets;
- organize, edit, format and enhance data in spreadsheets to achieve business standards;
- use formulas and built-in functions appropriately and correctly to solve problems and critically assess the results;
- plan, organize, create and present spreadsheet data in graphic form;
- design efficient spreadsheets capable of answering ‘what if’ questions to solve business problems;
- create and utilize financial functions including the PMT function;
- create data tables and amortization schedules;
- effectively consolidate multiple sheets and workbooks; and
- create, sort, and query tables.
Grading Table
Academic and Career
See the Academic Calendar for General Information including how to withdraw from course(s) and other regulations.
Disclaimer
Information contained in this course outline is correct at the time of publication. Content of the course is revised on an ongoing basis to ensure relevance to changing educational, employment and market needs. The instructor will endeavor to provide notice of changes to students as soon as possible. The instructor reserves the right to add or delete material from courses.