CA-105 Data Analysis Using Spreadsheet

GENERAL INFORMATION:

Course number and title : CA105 Data Analysis using Spreadsheet

Campus : National

Initiator: Marlene M. Mangonon

Date: September 1, 2018

Course description

The course focuses on the use of advanced functionalities of Spreadsheet to create and analyze data. It introduces student the use of the advanced functions such as financial functions, logical functions, lookup or reference functions, statistical functions and some information functions that are significant to manipulating and analyzing data and information. The student learns to generate reports such as tables, worksheets, and charts.

COURSE HOURS/CREDITS:

Hours per Week

No. of Weeks

Total Hours

Semester Credits

Lecture

x

x

=

Laboratory

x

x

=

Lecture/ Lab

3

x

16

x

48/16

=

3

Workshop

x

x

=

Total Semester

Credits

3












PURPOSE OF COURSE:

[ ] Degree requirement

[X] Degree elective

[ ] Certificate

[ ] Other

PREREQUISITES: CA100 Computer Literacy

PSLOS OF OTHER PROGRAMS THIS COURSE MEETS:

PSLO#

Program

CC Chair signature: _____________________________ Date recommended: __________

VPIA signature: __________________________________Date approved:_______________

1) INSTITUTIONAL STUDENT LEARNING OUTCOMES

[ ]

1. Effective oral communication: capacity to deliver prepared, purposeful presentations designed to increase knowledge, to foster understanding, or to promote change in the listeners’ attitudes, values, beliefs, or behaviors.

[ ]

2. Effective written communication: development and expression of ideas in writing through work in many genres andstyles, utilizing different writing technologies, and mixing texts, data, and images through iterative experiences across the curriculum.

[ ]

3. Critical thinking: a habit of mind characterized by the comprehensive exploration of issues, ideas, artifacts, and events before accepting or formulating an opinion or conclusion.

[X ]

4. Problem solving: capacity to design, evaluate, and implement a strategy to answer an open-ended question or achieve a desired goal.

[ ]

5. Intercultural knowledge and competence: a set of cognitive, affective, and behavioral skills and characteristics that support effective and appropriate interaction in a variety of cultural contexts.

[ ]

6. Information literacy: the ability to know when there is a need for information, to be able to identify, locate, evaluate, and effectively and responsibly use and share that information for the problem at hand.

[X ]

7. Foundations and skills for life-long learning : purposeful learning activity, undertaken on an ongoing basis with the aim of improving knowledge, skills, and competence.

[ ]

8. Quantitative Reasoning: ability to reason and solve quantitative problems from a wide array of authentic contexts and everyday life situations; comprehends and can create sophisticated arguments supported by quantitative evidence and can clearly communicate those arguments in a variety of formats.

2) PROGRAM STUDENT LEARNING OUTCOMES (PSLOs): 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; and

  5. Demonstrate the ability to adapt to latest technologies using their foundation knowledge and skills from CIS.

3) COURSE STUDENT LEARNING OUTCOMES (CSLOs) (General): The student will be able to:

  1. Demonstrate basic skills in calculating data with formulas and functions;

  2. Demonstrate basic skills in analyzing and charting financial data;

  3. Demonstrate basic skills in analyzing data with PivotTable and PivotCharts.

  4. Demonstrate basic skills in using financial tools and advanced functions; and

  5. Demonstrate basic skills in generating reports with analyzed data.

4) COURSE STUDENT LEARNING OUTCOMES (CSLOs) (Specific): The student will be able to:

CSLO (General) 1: Demonstrate basic skills in calculating data with formulas and functions.

Student Learning Outcome (specific)

ISLO

PSLO

Assessment Strategies

1.1. Create formulas.

7

3

To assess CSLO_1.1, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in calculating data by creating formulas.

1.2. Use functions.

7

3

To assess CSLO_1.2, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in calculating data by using spreadsheet functions.

1.3. Perform a what-if analysis.

7

3

To assess CSLO_1.3, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in calculating data by performing a what-if analysis.

1.4. Use relative and absolute cell references.

7

3

To assess CSLO_1.4, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in calculating data by using relative and absolute cell references.

1.5. Use Quick Analysis tool.

7

3

To assess CSLO_1.5, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in calculating data by using Quick Analysis tool.

CSLO (General) 2: Demonstrate basic skills in analyzing and charting financial data.

Student Learning Outcome (specific)

ISLO

PSLO

Assessment Strategies

2.1. Select a data source.

7, 4

3

To assess CSLO_2.1, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in analyzing financial data by selecting a data source.

2.2. Perform What-If Analysis.

7, 4

3

To assess CSLO_2.2, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in analyzing financial data by performing What-If-Analysis.

2.3. Create an embedded chart.

7, 4

3

To assess CSLO_2.3, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in charting financial data by creating an embedded chart.

CSLO (General) 3: Demonstrate basic skills in analyzing data with PivotTable and PivotCharts.

Student Learning Outcome (specific)

3.1. Plan a structured range of data.

7, 4

3

To assess CSLO_3.1, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in analyzing data by planning a structured range of data.

3.2. Create a PivotTable.

7, 4

3

To assess CSLO_3.2, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in analyzing data by creating a PivotTable.

3.3. Create a PivotChart.

7, 4

3

To assess CSLO_3.3, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in analyzing data by creating a PivotChart.

CSLO (General) 4: Demonstrate basic skills in using financial tools and advanced functions.

Student Learning Outcome (specific)

ISLO

PSLO

Assessment Strategies

4.1. Use Logical functions.

7, 4

3

To assess CSLO_4.1, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in using financial tools and advanced functions by using Logical functions.

4.2. Use structured references to create formulas in tables.

7, 4

3

To assess CSLO_4.2, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in using financial tools and advanced functions by using structured references to create formulas in tables.

4.3. Create nested IFs.

7, 4

3

To assess CSLO_4.3, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in using financial tools and advanced functions by creating nested IFs.

4.4. Use Lookup and Reference functions.

7, 4

3

To assess CSLO_4.4, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in using financial tools and advanced functions by Lookup and Reference functions.

4.5. Use COUNTIF, SUMIF, AND AVERAGEIF functions to summarize data conditionally.

7, 4

3

To assess CSLO_4.5, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in using financial tools and advanced functions by using COUNTIF, SUMIF, AND AVERAGEIF functions to summarize data conditionally.

CSLO (General) 5: Demonstrate basic skills in generating reports with analyzed data.

Student Learning Outcome (specific)

ISLO

PSLO

5.1. Create data tables.

7, 4*

3

To assess CSLO_5.1, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in generating reports by creating data tables.

5.2. Create a two-variable data table.

7, 4*

3

To assess CSLO_5.2, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in generating reports with What-If analyses by creating a two-data table.

5.3. Develop financial scenarios with the Scenario Manager.

7, 4*

3

To assess CSLO_5.3, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in generating reports with What-If analyses by developing financial scenarios with the Scenario Manager.

5.4. Create a scenario summary report.

7, 4*

3

To assess CSLO_5.4, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in generating reports with What-If analyses by creating a scenario summary report.

5.5. Create a solver answer report.

7, 4*

3

To assess CSLO_5.5, the instructor will use a hands-on case project with a grading rubric. The student will demonstrate basic skills in generating reports with What-If analyses by creating a solver answer report.

5) COURSE CONTENT:

1. Formulas and Functions

2. Charting Data

3. Financial tools and advanced functions

4. Tables, PivotTables, and PivotCharts

5. What-If Analyses

6) METHOD(S) OF INSTRUCTION:

[X] Lecture [ ] Cooperative learning groups

[X] Laboratory [X] In-class exercises

[X] Audio visual [X] Demonstrations

[X] Other – LMS Learning Management System (MindTap)

7) REQUIRED TEXT(S) AND COURSE MATERIALS:

June Jamrich Parsons; Dan Oja; Patrick Carey; Carol DesJardins (2016). New Perspectives Microsoft® Office 365 & Excel 2016: Comprehensive, 1st Edition, Cengage Learning, ISBN-10: 1-305-88040-4, ISBN-13: 978-1-305-88040-5

8) REFERENCE MATERIALS:

None

9) INSTRUCTIONAL COSTS:

None

10) EVALUATION:

The summative evaluation will be based on hands-on projects, midterm exam, and final exam.

11) CREDIT BY EXAMINATION:

None

This website and all COM-FSM Internet based services are best viewed with Firefox 3.0 or better.
© Copyright 2020 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, 428 J Street., Suite 400 Sacramento, CA 95814, (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