Data science foundation with MS-Exel

-
Course Objectives:
Introduce basic data science concepts through Excel.

Build skills in data cleaning, visualization, and statistical analysis.

Apply Excel functions for real-world datasets.

Perform decision-making using Excel tools like pivot tables, charts, and solver.

Module 1: Introduction to Data Science and Excel (Week 1)
What is Data Science?

Role of Excel in Data Science

Interface overview

Types of data (structured/unstructured)

Data types and formats in Excel

Activities: Practice formatting, entering data, and using basic functions.

Module 2: Data Cleaning and Preprocessing (Week 2)
Removing duplicates, missing values, outliers

Text to Columns, Find & Replace, Data Validation

Logical functions: IF, AND, OR, NOT

Activities: Clean a raw dataset and generate summary reports.

Module 3: Exploratory Data Analysis (Week 3)
Descriptive statistics: Mean, Median, Mode, Std Dev

Sorting, Filtering, Conditional Formatting

Frequency tables and cross-tabulations

Activities: Use =AVERAGE(), =STDEV(), etc., on a student or sales dataset.


Module 4: Data Visualization with Excel (Week 4)
Creating Charts: Bar, Line, Pie, Scatter

Dynamic charts with filters

Chart customization and best practices

Activities: Visualize trends in data using multiple chart types.


Module 5: Statistical Analysis (Week 5)
Correlation and Regression (using Data Analysis Toolpak)

Hypothesis Testing: t-test, Chi-square test

Analyzing relationships in data

Activities: Use Toolpak to run statistical tests on sample datasets.

Module 6: Predictive Tools and Decision-Making (Week 6)
What-If Analysis

Goal Seek and Scenario Manager

Introduction to Solver for optimization

Activities: Optimize resource allocation using Solver.

Module 7: Pivot Tables and Dashboards (Week 7)
Creating and modifying Pivot Tables

Pivot Charts

Building simple dashboards in Excel

Activities: Summarize data and present interactive insights.


Module 8: Mini Project and Presentation (Week 8)
Analyze a dataset of choice (e.g., health, education, business)

Apply learned techniques

Present findings using visuals and insights

Deliverable: 5-slide presentation and Excel file with analysis.

Assessment:
Weekly quizzes

Practical assignments

Final project report and presentation.

Comments

Post a Comment

Popular posts from this blog

UGC guidelines for undergraduate internship

-
The University Grants Commission (UGC) has issued guidelines to promote internships for undergraduate students under the National Education Policy (NEP) 2020, aiming to enhance employability, skill development, and experiential learning. Here are the key points of the UGC Guidelines for Undergraduate Internship: 1. Duration and Credit Allocation Internships are mandatory and should be a part of the undergraduate curriculum. Minimum duration: 8–10 weeks (approx. 2–3 months). Internships carry 2 to 4 credits, depending on the duration and effort. 2. Types of Internships Research internships with faculty or institutions. Industry internships in private or public sectors. Social or community engagement internships (NGOs, Panchayats, local bodies). Entrepreneurial internships or field-based projects. 3. Implementation Framework Institutions must have an Internship Cell. A mentor or faculty guide must supervise the internship. MOUs with industries or organizations are encouraged. 4. Assessme...
Read more

6-months course on Foundation of School psychology

-
School psychology is a specialized field that combines psychology, education, and child development to support the academic, social, and emotional well-being of students. School psychologists work with students, teachers, parents, and other school professionals to create a supportive and inclusive learning environment. This course provides an overview of the principles, theories, and practices of school psychology. Students will learn about the historical and philosophical foundations of school psychology, as well as the key concepts and methods used in the field. Topics will include: Throughout the course, students will engage in discussions, readings, and activities designed to promote critical thinking, problem-solving, and professional growth. By the end of the course, students will have a comprehensive understanding of the field of school psychology and be prepared to apply this knowledge in real-world settings. Registration : click here Course Outcomes: By the end of this course,...
Read more

Therapeutic postulates of Rabindrik Psychotherapy

-
1. Consciousness is free floating ‌2. It is unbound. ‌3. Do not label rather understand other's consciousness. ‌4. Consciousness is composed of three layers Murta, Raga and Saraswat. ‌5. Experience of Consciousness is like a journey from incomplete to complete across three layers. ‌6. Man is pursuer of newness. ‌7.Man is pursuer of completeness. ‌8. Searching newness makes man incomplete that acts as the driver to find out completeness. ‌9. Incomplete to complete is a cyclic process. ‌10. Image characteristics change across layers of consciousness. ‌11. Man has power to customise environment for change in consciousness layers. ‌12. Incoming images  are changed when it came out from saraswat layer. ‌13. Murta image has structure but no affect or emotion. ‌14. Raga layer based image is affected by emotion. ‌15. Saraswat image indicates harmony of object and environment. ‌16. Incom...
Read more