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.

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

PSLO#

Program

[ ]

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.

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.