OAT 152 Excel

This course covers the fundamental concepts of spreadsheet skills necessary to be successful within an organization. The emphasis is on technical knowledge and reinforcement of problem-solving abilities through project-based learning.

Credits

3

Cross Listed Courses

Eff term 200001 Equiv course CIS 112 Equiv start/end 199401-999999

Prerequisite

Prerequisite: SSC 100 or concurrent

See Course Syllabus

Course Number and Title:

OAT 152 Excel

Campus Location

  • Dover
  • Georgetown
  • Stanton
  • Wilmington

Effective Date

2022-51

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 covers the fundamental concepts of spreadsheet skills necessary to be successful within an organization. The emphasis is on technical knowledge and reinforcement of problem-solving abilities through project-based learning.

Required Text(s)

Obtain current textbook information by viewing the campus bookstore - https://www.dtcc.edu/bookstores online or visit a campus bookstore. Check your course schedule for the course number and section.

Core Course Performance Objectives (CCPOs)

  1. Plan, design, and create spreadsheets using complex formulas and functions. (CCC 2, 6; PGC 1, 2, 3, 4)
  2. Prepare and manage multiple-sheet workbooks. (CCC 2, 6; PGC 1, 2, 3)
  3. Summarize and analyze data. (CCC 2, 6; PGC 1, 3, 4)
  4. Demonstrate critical thinking and problem solving skills. (CCC 2, 3, 4, 6; PGC 1, 3)

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:

  1. Plan, design, and create spreadsheets using complex formulas and functions.
    1. Identify, describe, and use formulas and functions.
    2. Develop a spreadsheet using templates.
    3. Format data.
    4. Format worksheets.
  2. Prepare and manage multiple-sheet workbooks.
    1. Import/export data and/or files.
    2. Convert file formats.
    3. Ensure a workbook's confidentiality.
    4. Group and ungroup worksheets.
    5. Use the consolidate data function.
    6. Add worksheet pages and names.
    7. Copy, delete, move, and edit data.
    8. Automate worksheets using macros and other tools.
  3. Summarize and analyze data.
    1. Use forecasting and other data tools to evaluate information.
    2. Reorganize and/or summarize/display data using Excel features, including charts.
    3. Filter and/or sort data.
  4. Demonstrate critical thinking and problem solving skills.
    1. Identify errors and correct them.
    2. Modify formulas.
    3. Create and edit charts.
    4. Create data tables.
    5. Analyze data and scenarios.

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: Simulation Exams (10-12)

20%

Summative: Application Based Project (12-16)

35%

Formative: Quizzes/Assignments

35%

Summative: Industry Recognized Certification Exam

10%

TOTAL

100%

Program Graduate Competencies (PGCs are the competencies every graduate will develop specific to his or her major)

OATAASOAT

  1. Produce the documents necessary for a functioning business office.
  2. Demonstrate accurate and efficient keyboarding skills.
  3. Integrate office-related skills to function in a professional manner within the workplace.
  4. Use diverse research methods and information sources to complete a variety of business documents.

Core Curriculum Competencies (CCCs are the competencies every graduate will develop)

  1. Apply clear and effective communication skills.
  2. Use critical thinking to solve problems.
  3. Collaborate to achieve a common goal.
  4. Demonstrate professional and ethical conduct.
  5. Use information literacy for effective vocational and/or academic research.
  6. 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.

Minimum Technology Requirements

Minimum technology requirements for online, hybrid, video conferencing and web conferencing courses.