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
standard statementCourse Details| Total number of weeks | 8 |
|---|
| Total Credits | |
|---|
| Total Hours | 45 |
|---|
Typical hours per week breakdown| Other | 45 |
|---|
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
standard statement