- Our College
- Academics
- Student Services
- Public Reports
- Forum
- Library
- Quick Access
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:
3) COURSE STUDENT LEARNING OUTCOMES (CSLOs) (General): The student will be able to:
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