Course Name |
Data Analysis Using Microsoft Excel |
Course Code |
CERCS002 |
Year |
2017-18 |
Course Designer |
Mrs. Beena Cherian |
Couse Duration |
30 Hrs |
Course Schedule |
June to September |
Maximum Students Intake |
60 Students |
1. COURSE LEVEL
Foundational, skill-oriented certificate programme.
2. PREREQUISITE
To ensure success, students should be familiar with using personal computers, and should have experience using a keyboard and mouse. No prior knowledge of Programming language is required.
3. COURSE INTAKE & ADMISSION
Maximum 60 students will be given admission to the course based on First-Come-First-Serve basis. All the students of the MAMO College are eligible for free enrolment for the course. The enrolment notification will be issued for the course well in advance of the commencement of the course.
4. COURSE COORDINATOR
Ms. Beena Cherian, Department of Computer Science
5. COURSE PREAMBLE
MS-Excel is a Windows based application package. It is quite useful in entering, editing, analysis and storing of data. Arithmetic operations with numerical data such as addition, subtraction, multiplication and division can also be done with Excel. You can sort the numbers/characters according to some given criteria (like ascending, descending etc.)and solve simple financial, mathematical and statistical formulas. After successful completion of this session, participants can expect to have the skills required to work efficiently in an existing worksheet and to also create new worksheets from a template and from scratch.
6. DURATION
Total Duration: 30 Hrs. [Contact Hrs. 8 Hrs. Lab Hours: 8 Hrs. Course Woks: 7 and Assessment Works: 7]
7. CURRICULUM FOCUS
Enhance the employability of the learners through curriculum enrichment for additional skill development.
8. COURSE OBJECTIVES
Learners are expected to
(a) Understanding the basic concepts of a spreadsheet.
(b) Set pages and their printing
(c) Modify a worksheet
(d) Enter and edit data in a worksheet
(e) Work on keyboard shortcuts
9. SKILL EXPECTED
On the successful completion of the course, learners will be able to:
(a) Create a new document according to the requirement.
(b) Perform various editing and formatting methodologies.
10. COURSE OUTCOMES
Upon the successful completion of the course, learners will be able to:
CO No |
Course Outcome(CO) |
Skill/Knowledge Attainment Level Based on Revised Bloom’s Taxonomy |
CO1 |
Teach students to identify spreadsheet processing terminology and concepts. |
Understand |
CO2 |
Create a spread sheet according to the requirement. |
Apply |
CO3 |
Format and edit the cell and cell contents |
Analyze |
CO4 |
Develop or formulate new spread sheet presentations that adapt to a given case. |
Create |