Course Number and Title:
OAT 152 Excel
Campus Location
- Dover
- Georgetown
- Wilmington
- Stanton
Prerequisites
Prerequisite: SSC 100 or concurrent
Course Credits and Hours
3 credit(s)
2 lecture hours/week
2 lab hours/week
Course Description
This course provides a comprehensive examination of spreadsheet skills, building from essential concepts to more advanced applications. This course develops technical expertise and strengthen problem-solving abilities through hands-on, project-based learning. The course emphasizes leveraging spreadsheet software to analyze and present data to support informed decision-making.
Core Course Performance Objectives (CCPOs)
Create spreadsheets using formulas, functions, and formatting techniques. (CCC 2, 6; PGC 2 ,3, 5)
Manage multi-sheet workbooks for efficient data integration, security, and functionality. (CCC 2 ,3; PGC 3, 5)
Summarize, analyze, and visualize data. (CCC 1, 2, 4, 6; PGC 1, 2, 3, 4, 5)
Conduct an analysis based on a business problem. (CCC 1, 2, 3, 4, 5, 6; PGC 1, 2, 3, 4, 5)
See Core Curriculum Competencies and Program Graduate Competencies at the end of the syllabus. CCPOs are linked to every competency they develop.
Measurable Performance Objectives (MPOs)
Upon completion of this course, the student will:
Create spreadsheets using formulas, functions, and formatting techniques.
Explain how to navigate a workbook and its essential components.
Construct and modify formulas and functions.
Develop spreadsheets from a blank workbook or a template.
Format data and worksheets to enhance readability.
Structure workbooks logically using organizational and editing techniques.
Correct common spreadsheet errors to ensure data accuracy.
Manage multi-sheet workbooks for efficient data integration, security, and functionality.
Import, export, and link data to integrate external data sources.
Implement security measures to protect the integrity and confidentiality of workbook data.
Manage grouped worksheets to optimize data management and efficiency.
Consolidate data from multiple worksheets for analysis and reporting.
Construct data tables, subtotals, groups, and outlines, to organize information for effective analysis.
Apply data validation techniques to reduce data entry errors.
Prepare summaries, subsets, and visualizations of data.
Create data visualizations by developing and editing charts and applying conditional formatting.
Apply filtering and sorting techniques to extract relevant information.
Summarize and visualize data using pivot tables and pivot charts.
Conduct an analysis based on a business problem.
Identify the key components of a business problem and define specific objectives for analysis.
Select appropriate analytical methods and tools to address a business problem.
Analyze the data to identify patterns and trends.
Present findings and recommendations.
Evaluate how changes in different inputs affect outcome.
Evaluation Criteria/Policies
The grade will be determined using the Delaware Tech grading system:
| 90-100 |
= |
A |
| 80-89 |
= |
B |
| 70-79 |
= |
C |
| 0-69 |
= |
F |
Students should refer to the
Catalog/Student Handbook for information on the Academic Standing Policy, the Academic Integrity Policy, Student Rights and Responsibilities, and other policies relevant to their academic progress.
Final Course Grade
Calculated using the following weighted average
Evaluation Measure | Percentage of final grade |
Summative Assessments |
- Simulation Exams (10-12) (equally weighted)
| 20% |
- Application Based Project (12-16) (equally weighted)
| 35% |
- Industry Recognized Certification Exam
| 10% |
Formative Assessments |
The course will contain various formative assessments including but not limited to: | 35% |
TOTAL | 100% |
Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major)
1. Integrate professional, ethical, and legal standards into business decision-making.
2. Apply foundational business concepts that lead to strategic thinking and the ability to analyze complex problems.
3. Use professional and technology based skills that are relevant to the dynamic business environment.
4. Employ effective communication skills and collaboration strategies to promote positive organizational outcomes.
5. Apply skills necessary to analyze and interpret business and financial data for decision-making purposes.
Core Curriculum Competencies (CCCs are the competencies every graduate will develop)
- Apply clear and effective communication skills.
- Use critical thinking to solve problems.
- Collaborate to achieve a common goal.
- Demonstrate professional and ethical conduct.
- Use information literacy for effective vocational and/or academic research.
- Apply quantitative reasoning and/or scientific inquiry to solve practical problems.
Students in Need of Accommodations Due to a Disability
We value all individuals and provide an inclusive environment that fosters equity and student success. The College is committed to providing reasonable accommodations for students with disabilities. Students are encouraged to schedule an appointment with the campus Disabilities Support Counselor to request an accommodation needed due to a disability. The College's policy on accommodations for persons with disabilities can be found in the College's Guide to Requesting Academic Accommodations and/or Auxiliary Aids Students may also access the Guide and contact information for Disabilities Support Counselors through the Student Resources web page under Disabilities Support Services, or visit the campus Advising Center.