BAIC — Calicut University B.C.A Honours Programme Scheme and Syllabus | BAIC

Course Outcomes (CO): Page 229 of 241 2. Understanding of Basic Mathematical and Statistical Concepts Course Summary After completing the course, students have a solid foundation in data analysis using spreadsheets, empowering them to analyze data with confidence, derive meaningful insights, and communicate their findings effectively to stakeholders. CO CO Statement Cognitive Level* Knowledge Category# Evaluation Tools used CO1 Students will demonstrate proficiency in managing spreadsheets, including creating, formatting, and manipulating data within workbooks. They will be able to effectively navigate the spreadsheet interface and utilize toolbars.

Ap P Instructor-Create Exams or Quiz CO2 Learners will understand the importance of data organization and cleansing in spreadsheets. They will be able to import, export, filter, sort, validate, and remove duplicates from datasets. Students will develop skills to ensure data integrity and consistency, enhancing their ability to work with clean and organized datasets. U C Discussions and Quizzes CO3 Participants will acquire advanced data analysis skills like pivot tables, what-if analysis, and goal seek. They will be able to apply various spreadsheet functions and tools to perform complex calculations, analyze trends, and make informed decisions based on data analysis.

An P Instructor created exams or Home assignments CO4 Students will gain proficiency in data visualization techniques using spreadsheets. They will be able to create a variety of charts, design pivot charts, and dashboards for effective data analysis. C P Discussions, Quizzes CO5 Learners will be able to implement form controls for interactive data manipulation in their visualizations, enhancing their ability to present and explore data dynamically.

Ap P Viva Voce Observation of practical skills CO6 Learners will develop skills in advanced features of spreadsheets such as macros, protecting data sheets and workbooks, utilizing split, freeze, and hide options C P Instructor Created -Exams, Assignments