BOARD OF STUDIES 

Chairman-     Mr. Prakash Joseph(Head, Department of Computer Science)

Members-      Dr. Ojus Thomas Lee (HOD, Dept. of CS, College of Engineering, Kidangoor)

Mr. Sunil K. Joseph (Asst. Prof. Department of Computer Science)

Mr. Arun K. Abraham (Asst. Prof. Department of Computer Science)

INTRODUCTION

The Value-Added Courses aims to provide additional learner centric graded skill oriented technical training, with the primary objective of improving the employability skills of students

AIM OF THE PROGRAMME

The aim of the course Introduction to Data Analytics Using Excel is to equip learners with foundational skills in data analysis, enabling them to effectively organize, analyze, and visualize data using Excel's powerful tools and functions.

ELIGIBILITYFORADMISSIONS

All UG and PG students from various departments of the college. The number of intakes to the course is limited. The course can be offered only if there are at least 5 students opting for it.

MEDIUM OF INSTRUCTION: English.

DURATION OF THE COURSE

The duration of value-added course is 30 hours (including the hours of final examination) of which 15hrs theory and 15hrs for laboratory/demonstration/experimental activities and the course can have a maximum of three hours a day.

The value-added course will be a blend of theory classes / experimental learning / project- based learning / assignments / activity-based learning.

COURSEOBJECTIVES

• To familiarize students with the Excel interface and essential functions for managing and analyzing data.
• To develop proficiency in cleaning, formatting, and preparing data for analysis using Excel tools.
• To enable students to apply basic statistical and logical functions for data analysis.
• To introduce techniques for visualizing data through charts, graphs, and conditional formatting in Excel.
• To empower students to use advanced Excel features, such as pivot tables and data validation, for in-depth data insights.

COURSE OUT COMES(Cos)

Upon successful completion of the course Introduction to Data Analytics Using Excel, students will be able to:

• Demonstrate proficiency in Excel's interface and essential features for data management and analysis.
• Clean, organize, and format data to prepare datasets for effective analysis.
• Apply fundamental Excel functions and formulas to calculate, summarize, and manipulate data.
• Visualize data using charts and graphs to identify patterns, trends, and insights.
• Use advanced Excel tools such as conditional formatting, pivot tables, and macros to perform comprehensive data analysis tasks.

EVALUATION

• The value-added courses shall be evaluated through an examination at the end of the
• The duration of examination is two
• A committee consisting of the Head of the Department, the course coordinator and a senior faculty member nominated by the Head of the department shall monitor the evaluation process.
• The list of students along with the marks and the grades earned may be forwarded to the Principal/Chief Superintendent of Examinations.
• The Dept. course coordinator is responsible for maintaining and processing the record with regard to the course, assessment marks and results.
• Certificates will be issued to those students with 75% attendance, timely submission of assignment and project and a minimum of 40% marks in the qualifying
• The total marks of the examination shall be 100 

  Components of Evaluation	Marks
  Attendance	10
  Assignment/Seminar	10
  Project & Viva	30 (20+10)
  External Examination	50
  Total	100

   

  Pattern of questions Paper

  Sl.No.	Pattern	Marks	Choice of questions	Total marks
  1	Short Answer/problem type	2	5/7	10
  2	Short essay/problem	5	4/6	20
  3	Essay/problem	10	2/4	20
  Total				50

  Grading Pattern

  Grades are given on a 7-points scale based on the total percentage of marks,(ISA+ESA)as given below: