CMSY 206 Expert Spreadsheets Concepts

After successful completion of this course, the student will be able to use spreadsheet program(s) to design and implement advanced workbook structure and workbook review concepts. Included skills are constructing custom data using advanced formats and layouts, formulae, charts, and tables.

Credits

1

Prerequisite

CMSY 117

Hours Weekly

1

Course Objectives

1. Design and implement workbook structure and workbook review concepts.
2. Construct custom data and utilize them in advanced formats and layouts.
3. Devise advanced formulae, incorporating data analytics and Business Intelligence.
4. Formulate and manage advanced charts and print tables.

Course Objectives

1. Design and implement workbook structure and workbook review concepts.

   This objective is a course Goal Only

   Learning Activity Artifact

   • Other (please fill out box below)
   • project based

   Procedure for Assessing Student Learning

   • Other (please fill out box below)
   • project-based assessment
2. Construct custom data and utilize them in advanced formats and layouts.

   This objective is a course Goal Only

   Learning Activity Artifact

   • Other (please fill out box below)
   • project-based

   Procedure for Assessing Student Learning

   • Other (please fill out box below)
   • project-based assessment
3. Devise advanced formulae, incorporating data analytics and Business Intelligence.

   This objective is a course Goal Only

   Learning Activity Artifact

   • Other (please fill out box below)
   • project-based

   Procedure for Assessing Student Learning

   • Other (please fill out box below)
   • project-based assessment
4. Formulate and manage advanced charts and print tables.

   This objective is a course Goal Only

   Learning Activity Artifact

   • Other (please fill out box below)
   • project-based

   Procedure for Assessing Student Learning

   • Other (please fill out box below)
   • project-based assessment