CA-105 Data Analysis Using Spreadsheet

Course Description:

This course provides basic through advanced computer concepts with an emphasis on both the personal computer and enterprise computing. Topics include hardware, application and system software, the Internet and World Wide Web, communications, e-commerce, societal issues, database management, systems analysis and design, programming, information systems, career opportunities, certifications in the computer field, and computer trends.
A. PROGRAM LEARNING OUTCOMES (PLOs):
The student will be able to:
  1. Demonstrate an in-depth understanding of technical concepts and ethical issues pertaining to information systems
  2. Demonstrate theoretical knowledge and practical skills in the management and strategic use of information systems and technology.
  3. Demonstrate proficiency in the use of different software applications significant to manipulating and analyzing information as well as generating and presenting reports in the various functional areas of business.
  4. Demonstrate solid foundation skills in database design and management, web engineering, programming, and networking
  5. Demonstrate the ability to adapt to latest technologies using their foundation knowledge and skills from CIS.
B. STUDENT LEARNING OUTCOMES (SLOs): - GENERAL
The student will be able to:
  1. Explain and demonstrate how to create and format a workbook and work with formulas, functions, and graphics.
  2. Explain and demonstrate PivotTables and PivotCharts, advanced formulas and functions and how to manage multiple worksheets.
  3. Explain and demonstrate advanced techniques, such as financial and what-if analyses, external data usage, and Visual Basic Application integration.
SLO PLO 1 PLO 2 PLO 3 PLO 4 PLO 5
1 ID ID ID
2 ID ID ID
3 ID ID ID

I = Introduced D = Demonstrated M = Mastered

C. STUDENT LEARNING OUTCOMES (SLOs):- SPECIFIC
The student will be able to:

General SLO 1. Explain and demonstrate how to create and format a workbook and work with formulas, functions, and graphics.

Student Learning Outcomes Assessment Strategies
1.1 Format text, number, and dates in workbook using accounting, fraction, and scientific formats; create a custom format; use AutoFormat Homework and/or class quizzes and/or exams.
1.2 Apply conditional formatting, styles, data, and chart formats Homework and/or class quizzes and/or exams.
1.3 Describe and demonstrate the various ways to print a worksheet and explain advance printing features. Homework and/or class quizzes and/or exams.
1.4 Create and use a list using features such as viewing, sorting, and printing records specified in a search or filter. Homework and/or class quizzes and/or exams

General SLO 2. The student will be able to explain and demonstrate PivotTables and PivotCharts, advanced formulas and functions and how to manage multiple worksheets.

Student Learning Outcomes Assessment Strategies
2.1 Demonstrate how to use a list to find specific records using AutoFilter. Homework and/or class quizzes and/or exams.
2.2 Explain and demonstrate how to use data analysis tools using scenarios, auditing features, PivotTables and PivotCharts, goal seek, and solver features to find unknown values. Homework and/or class quizzes and/or exams.
2.3 Create and use macros and explain macros as time-saving feature. Homework and/or class quizzes and/or exams.
2.4 Describe and demonstrate various methods of exchanging information with other programs, such as the import and export function, and publishing worksheets in HTML format web accessibility. Homework and/or class quizzes and/or exams.
2.5 Demonstrate how to create and save a template, open and use the template, and use some of the templates built into spreadsheet program. Homework and/or class quizzes and/or exams.
2.6 Demonstrate how to name ranges, copy and move data between worksheets, copy entire worksheet, and create and save a workspace. Homework and/or class quizzes and/or exams.
2.7 Perform data consolidation. Homework and/or class quizzes and/or exams.

General SLO 3. The student will be able to explain and demonstrate techniques, such as financial and what-if analyses, external data usage, and Visual Basic application integration.

Student Learning Outcomes Assessment Strategies
3.1 Create and use a shared worksheet, merge data in shared workbooks, track changes, and add password protection to a workbook Homework and/or class quizzes and/or exams.
3.2 Describe features in an electronic spreadsheet that control how summary data is displayed, such as adding subtotals to column(s) and row(s) of data and grouping data for easier viewing. Homework and/or class quizzes and/or exams.
3.3 Apply the advanced features that are available in the electronic spreadsheet to look up information and return a value to a cell, such as the extensive markup language, XML. Homework and/or class quizzes and/or exams.
3.4 Write, debug, and execute advanced macro functions using Visual Basic Application (VBA) programming language. Homework and/or class quizzes and/or exams.
D. COURSE CONTENT
  1. Making the Worksheet Useful
  2. Applying Advance Formats to Worksheets and Charts
  3. Working with Multiple Worksheets
  4. Working with Worksheet Charts
  5. Printing Workbooks
  6. Using Lists
  7. Filtering and Extracting Data
  8. Working with Analysis Tools and PivotTables
  9. Creating Macros and Menus
  10. Importing and Exporting Data
  11. Using Template and Protection
  12. Working with Multiple Worksheets and Workbooks
  13. Working with Shared Workbooks
  14. Using Outlines
  15. Using Advanced Excel Tools
  16. Data Analysis Programming
E. METHODS OF INSTRUCTION
  1. PowerPoint Presentations/Lectures
  2. Hands-on exercises/activities
  3. Individual Projects
F. REQURIED TEXT(S) AND COURSE MATERIALS
Parsons, June Jamrich., Dan Oja, Roy Ageloff & Patrick Carey. Microsoft Office: Excel 2007 Premium Video Edition Comprehensive. USA: Course Technology, Cengage Learning, 2011. (or most recent edition).
G. REFERENCE MATERIALS
None
H. INSTRUCTIONAL COSTS
None
I. EVALUATION
None
J. CREDIT BY EXAMINATION
None

This website and all COM-FSM Internet based services are best viewed with Firefox 3.0 or better.
© Copyright 2014 College of Micronesia-FSM | Site Disclaimer
P. O. Box 159, Kolonia, Pohnpei, 96941 - (691) 320-2480
College of Micronesia-FSM is accredited by the Accrediting Commission for Community and Junior Colleges,
Western Association of Schools and Colleges, 10 Commercial Bldv., Suite 204, Novato, CA 94949, (415) 506-0234,
an institutional accrediting body recognized by the Council for Higher Education Accreditation and the U.S. Department of Education.
Additional information about accreditation, including the filing of complaints against member institutions, can be found at: www.accjc.org

feedback