Skip to main content

2024:MDC:CSC1FM105:Data Analysis and Visualisation Through Spread sheets

Updated 01 Sep 2024
Lessons 6
Language English ‎(en)‎
Skill Level Beginner

Course Overview

Course Summary

This course provides a comprehensive introduction to Spreadsheets, focusing on understanding formulas, functions, data organization, analysis techniques, and data visualization. Participants will gain skills in spreadsheet management, data cleansing, analysis, and visualization using Excel's various tools and features.

Course Outcomes (CO):

  • Learners will understand the importance of data organization and cleansing in Excel. 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 data sets.

  • Students will gain proficiency in data visualization techniques using Excel. They will be able to create table,a variety of charts, design pivot charts, dashboards for effective data analysis. Additionally, learners will be able to implement form controls for interactive data manipulation  in their visualizations

Course Content

Loading...

Enrolment options

Course Summary

This course provides a comprehensive introduction to Spreadsheets, focusing on understanding formulas, functions, data organization, analysis techniques, and data visualization. Participants will gain skills in spreadsheet management, data cleansing, analysis, and visualization using Excel's various tools and features.

Course Outcomes (CO):

  • Learners will understand the importance of data organization and cleansing in Excel. 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 data sets.

  • Students will gain proficiency in data visualization techniques using Excel. They will be able to create table,a variety of charts, design pivot charts, dashboards for effective data analysis. Additionally, learners will be able to implement form controls for interactive data manipulation  in their visualizations

Skill Level: Beginner
Guests cannot access this course. Please log in.

Related Courses

Course Outcome: ● To apply knowledge acquired through curriculum in practical problem solving ● To develop creative thinking in finding viable solutions to real life problems ● To foster innovation in design of products, processes or systems

7 Lessons
Updated: Sep 2024
31 Enrolled

  Electromagnetic Theory covers the coordinate systems, basic principles of electromagnetism,  electrostatics, magnetic fields of steady currents, motional e.m.f. and electromagnetic induction, Maxwell's equations, propagation and radiation of electromagnetic waves, electric and magnetic properties of matter, and conservation laws.

5 Lessons
Updated: Sep 2024
30 Enrolled
5 Lessons
Updated: Sep 2024
204 Enrolled
1 Lessons
Updated: Sep 2024
204 Enrolled

Latest Courses

5 Lessons
Updated: Oct 2024
3 Lessons
Updated: Sep 2024
208 Enrolled

Course Outcome: ● To apply knowledge acquired through curriculum in practical problem solving ● To develop creative thinking in finding viable solutions to real life problems ● To foster innovation in design of products, processes or systems

7 Lessons
Updated: Sep 2024
31 Enrolled

  Electromagnetic Theory covers the coordinate systems, basic principles of electromagnetism,  electrostatics, magnetic fields of steady currents, motional e.m.f. and electromagnetic induction, Maxwell's equations, propagation and radiation of electromagnetic waves, electric and magnetic properties of matter, and conservation laws.

5 Lessons
Updated: Sep 2024
30 Enrolled
loader image