Intermediate Spreadsheets using Excel

Course Number:
CAS 270
Transcript Title:
Intermediate Spreadsheets using Excel
Created:
Aug 08, 2022
Updated:
Jun 29, 2023
Total Credits:
3
Lecture Hours:
10
Lecture / Lab Hours:
40
Lab Hours:
0
Satisfies Cultural Literacy requirement:
No
Satisfies General Education requirement:
No
Grading Options
A-F, P/NP, Audit
Default Grading Options
A-F
Repeats available for credit:
0
Prerequisites

CAS 170 or instructor permission

Course Description

Introduces advanced spreadsheet features in the design and create accurate, professional worksheets for use in business and industry. Includes financial, logical, statistical, lookup, and database functions; pivot tables; "what-if" analysis with data tables; importing data; complex graphs; macros; and solver features. Focuses on ways to ensure accuracy including proofreading techniques and critical thinking to determine what data to present and how to present it. Prerequisite: CAS 170 or instructor permission. Audit available.

Course Outcomes

Upon successful completion of this course, student will be able to:

  1. Use critical thinking, problem-solving, and decision making skills to independently design and create complex spreadsheets following current professional and/or industry standards.
  2. Perform intermediate formatting, functions and formula operations in designing and creating complex spreadsheets.
  3. Demonstrate working knowledge of organizing, linking and displaying large amounts of complex data in single and multiple spreadsheets.
  4. Create complex spreadsheets using formatting, clip art and integrating outside information to enhance ideas complex spreadsheets.

Suggested Outcome Assessment Strategies

Assessment may include:  Projects with original work, reflection journals, group discussions, open ended assessment, objective tests on basic document functions.

Course Activities and Design

The determination of teaching strategies used in the delivery of outcomes is generally left to the discretion of the instructor. Here are some strategies that you might consider when designing your course: lecture, small group/forum discussion, flipped classroom, dyads, oral presentation, role play, simulation scenarios, group projects, service learning projects, hands-on lab, peer review/workshops, cooperative learning (jigsaw, fishbowl), inquiry based instruction, differentiated instruction (learning centers), graphic organizers, etc.

Course Content

Themes, Concepts, Issues

  • Communicate effectively using appropriate spreadsheet vocabulary.
  • Use critical thinking, problem-solving, and decision-making skills in developing the spreadsheet design for various business problems.
  • Proofread for accuracy in the entry of data and creation of formulas.
  • Assess the document for readability.
  • Make effective use of the advanced tools available in spreadsheet programs.
  • Integrate the use of spreadsheets with other applications including the Internet.

Competencies, Skills

Students will develop proficiency through reinforcement and assessment on the following skills:
  • Create formulas using relative, absolute, and mixed references.
  • Plan, create, modify, and enhance the appearance of charts.
  • Produce and execute macros.
  • Create databases and use data forms, conditional formatting, sorting, filtering, and extracting features.
  • Use PivotTables and PivotChart to summarize data in databases.
  • Generate Web pages from spreadsheets and hyperlink to other documents.
  • Use lookup functions in worksheets.
  • Import data into Excel from text files, databases, and the World Wide Web.
  • Design professional spreadsheets based on analyzing needs and data.
Students will be familiar with the following skills:
  • Nested If statements
  • Naming cells
  • Validation
  • Logical and financial functions
  • Protection features
  • One-and two-variable data tables
  • Auditing tools
  • Visual Basic
  • Customizing the Excel toolbar
  • Solver and scenario manage