Data Analytics Using Excel detailed Syllabus for Printing Technology (PN), K scheme PDF has been taken from the MSBTE official website and presented for the diploma students. For Subject Code, Subject Name, Lectures, Tutorial, Practical/Drawing, Credits, Theory (Max & Min) Marks, Practical (Max & Min) Marks, Total Marks, and other information, do visit full semester subjects post given below.
For all other MSBTE Printing Technology 4th Sem K Scheme Syllabus PDF, do visit MSBTE Printing Technology 4th Sem K Scheme Syllabus PDF Subjects. The detailed Syllabus for data analytics using excel is as follows.
Rationale
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier.
.
Course Outcomes:
Students will be able to achieve & demonstrate the following COs on completion of course based learning
- Classify data collected in business processes.
- Apply statistical tools to process data.
- Test hypothesis in business problems.
- Analyse data with Excel and spreadsheet tools.
- Elaborate applications of data analytics in printing.
Unit I
Introduction to Data Analytics 1.1 Understanding Data Analytics : Definition and importance of data analytics, Role of data analytics in decision-making 1.2 Basics of Excel for Data Analytics: Overview of Excel interface, Excel functions and formulas for data manipulation, Data importing and exporting in Excel 1.3 Types of Data and Data Formats: Categorical vs. numerical data, Data formats (text, numbers, dates) 1.4 Data Cleaning and Preprocessing: Identifying and handling missing data, Removing duplicates, Dealing with outliers
Suggested Learning Pedagogie
Lecture Usin Chalk-Board Presentation Demonstrati
Unit II
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Unit III
Inferential Statistics 3.1 Probability Basics: Probability concepts, Probability distributions. 3.2 Sampling Techniques : Simple random sampling, stratified sampling, Understanding the sampling process. 3.3 Hypothesis Testing : Null and alternative hypotheses, conducting t-tests and chi-square tests in Excel. 3.4 Correlation and Regression Analysis: Understanding correlation, Simple linear regression in Excel.
Suggested Learning Pedagogie
Lecture Usin Chalk-Board Hands-on Presentation
Unit IV
Data Analysis Tools in Excel 4.1 Excel Data Analysis ToolPak: Overview and installation, Using the Analysis ToolPak for statistical analysis 4.2 Solver Tool in Excel : Introduction to Solver, Optimization problems using Solver
Suggested Learning Pedagogie
Lecture Usin Chalk-Board Presentation Hands-on
Unit V
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
List of Experiments:
- *Create a simple dataset and Importing external data into Excel 2 CO
- *Identify and handle missing data and removing duplicates using Excel 2 CO
- *Cleaning data using Excel functions. 2 CO
- *Create basic charts (bar chart, pie chart) for visual representation 2 CO
- *Create Pivot Tables to summarize data 2 CO
- Use Pivot Charts to visualize data trends. 2 CO
- *Create histograms, scatter plots. 2 CO
- Format and enhance charts for better presentation. 2 CO
- Conduct t-tests and chi-square tests in Excel 2 CO
- Calculate correlation coefficients. 2 CO
- *Enabling and using the Excel Data Analysis ToolPak. 2 CO
- Create dynamic dashboards in Excel 2 CO
- Apply various statistical tools for analysis. 2 CO
- *Analyze real-world datasets from various industries. 2 CO
- Import and export data between Excel and other analytics tools 2 CO
Self Learning
Micro Project
- Exploring Data Types and Cleaning: Create a simple dataset with both categorical and numerical data in Ex Import external data with missing values and duplicates. Identify and handle missing data, remove duplicates, a ensure data accuracy. Present the cleaned dataset using basic charts (e.g., bar chart, pie chart).
- Descriptive Statistics in Excel: Create a dataset with numerical values. Calculate and interpret measures of tendency (mean, median, mode). Determine measures of dispersion (range, variance, standard deviation). Visua the dataset using Excel charts, emphasizing key statistical measures.
- Real-world Data Analysis: Choose a real-world dataset from various industries (e.g., finance, healthcare). I and clean the dataset in Excel. Utilize PivotTables and Pivot Charts to summarize and visualize key trends. Dra insights and solve practical problems, presenting findings in a report.
Assignment
- Decision-Making Report: Analyze a hypothetical business situation. Utilize Excel analytics tools to make d driven decisions. Present the decision-making process and outcomes in a structured report.
- Future Trends in Data Analytics: Research and summarize advanced analytics techniques, such as machine learning and predictive analytics. Explore the role of artificial intelligence in shaping the future of data analytic Reflect on the evolving role of Excel in future data analytics developments.
- Explore the integration of Excel with other tools and platforms: Export data from Excel to other analytics to platforms. Import data into Excel from external sources. Highlight the importance of data interchangeability fo comprehensive analytics.
Seminar and Workshop
- Participate in seminars and workshops on topic related to Data Analytics.
Laboratory Equipment
For the complete Syllabus, results, class timetable, and many other features kindly download the iStudy App
It is a lightweight, easy to use, no images, and no pdfs platform to make students’s lives easier..
Learning Materials
- Foster Provost and Tom Fawcett Data Science for Business O’Reilly Media ISBN-13: 978 1449361327
- Anil Maheshwari Data Analytics Made Accessible Pearson ISBN-13: 9781292097180
- Elliot Bendoly Excel Basics to Blackbelt: An Accelerated Guide to Decision Support Designs Cambridge University Press IS 13: 978-0521898018
- Peter Bruce and Andrew Bruce Practical Statistics for Data Scientists: 50 Essential Concepts O’Reilly Media ISBN-13: 978 1491952962
Learning Websites
- https://www.kaggle.com/ Kaggle is a platform that offers a variety of datasets and competitio It’s a great place for students to practice data analytics skills using E and other tools. The community and forums provide valuable insigh and collaboration opportunities.
- https://learn.microsoft.com/en-us/ Microsoft Learn provides free, interactive learning paths and modul The “Excel Fundamentals” and “Data Analysis with Excel” module helpful for mastering Excel analytics.
- https://www.analyticsvidhya.com/ Analytics Vidhya is a platform that offers a variety of tutorials, artic and online courses on data science, machine learning, and analytics. a great resource for learning practical applications.
- https://www.exceltip.com/ Excel Tip is a platform offering a variety of Excel tips, tutorials, an resources. It covers a wide range of topics suitable for beginners to advanced Excel users.
- https://www.excelsuperstar.org/ Excel Superstar is an Indian platform dedicated to Excel tutorials an resources. It covers a wide range of topics from basic functions to advanced data analysis.
For detail Syllabus of all other subjects of Printing Technology, K scheme do visit Printing Technology 4th Sem Syllabus for K scheme.
For all Printing Technology results, visit MSBTE Printing Technology all semester results direct links.