Home >Computer Science >Programme

CERCS002: Data Analysis Using MS Excel

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