B.Sc. (Data Science) Office Tools for Data Scientists Syllabus - Mumbai University
This is the FY BSc Data Science syllabus under NEP 2020, in force from the academic year 2024-25. The University still sets the earlier Choice Based papers alongside it for ATKT candidates, so check which scheme your exam form names before you revise.
Loading syllabus...
Syllabus for Office Tools for Data Scientists
Module I
- 1. Introduction to Data Tools: The Software Is Easy to Use, The Software Is Available from Anywhere, The Software Is Updated Regularly, Why Data Analysis (Data Science) at All? Where to Get Data. 2. Importing Data: Excel, Excel Analysis ToolPak, OpenOffice, Import into R and Rattle, Import into RStudio, Rattle Import, Import into KNIME, Stoplight Approach. 3. Statistical Tests: Descriptive Statistics, Excel, OpenOffice, RStudio/Rattle, KNIME, Cumulative Probability Charts, Excel, OpenOffice, R/RStudio/Rattle, KNIME, T-Test (Parametric), Excel, OpenOffice, R/RStudio/Rattle, KNIME.
Module II
- 1. More Statistical Tests: Correlation, Excel, OpenOffice, RStudio/Rattle, KNIME, Regression, Excel, OpenOffice, RStudio/Rattle, KNIME, Confidence Interval, Excel, OpenOffice, RStudio/Rattle, KNIME, Random Sampling, Excel, OpenOffice, RStudio/Rattle, KNIME. 2. Statistical Methods for Specific Tools: Power, R/RStudio/Rattle, F- Test, Excel, R/RStudio/Rattle, KNIME, Multiple Regression/Correlation, Excel, OpenOffice, R/RStudio/Rattle, KNIME, Benford’s Law, Rattle, Lift, KNIME, Wordcloud, R/RStudio, KNIME, Filtering, Excel, OpenOffice, RStudio/Rattle, KNIME. 3. Additional Data: Packages, Analysis ToolPak, Exercise – Tornado and the States, Solution, Pairing Exercise. 10 Online References: 1. https://www.w3schools.com/EXCEL/index.php 2. https://www.w3schools.com/r/default.asp 3. https://www.knime.com/ 11 Reference Books 1. Data Science Tools, by Christopher Greco, MERCURY LEARNING, 1 st Edition, 2019 2. R for Data Science, by Hadley Wickham, Garrett Grolemund, O'Reilly, 1 st Edition, 2016 3. DATA SCIENCE with KNIME, by Dr Nickholas Anting, NASPSOFT, 1st Edition, 2022 4. Beginning OpenOffice Calc, by Jacek Artymiak, Apress, 2011 12 Internal Continuous Semester End Examination: 60% Assessment: 40% 13 Continuous Evaluation Format of Question Paper: External through: Examination (30 Marks)– 1 hr duration Class test of 1 of 15 marks Class test of 2 of 15 marks Average of the two: 15 marks Quizzes/ Presentations/ Assignments: 5 marks Total: 20 marks 14 Format of Question Paper: (Semester End Examination : 30 Marks. Duration:1 hour) Q1: Attempt any two (out of four) from Module 1 (15 marks) Q2: Attempt any two (out of four) from Module 2 (15 marks)
Online References
- 1 https://www.w3schools.com/EXCEL/index.php
- 2 https://www.w3schools.com/r/default.asp
- 3 https://www.knime.com/
- 1 Data Science Tools, by Christopher Greco, MERCURY LEARNING, 1 st Edition, 2019
- 2 R for Data Science, by Hadley Wickham, Garrett Grolemund, O'Reilly, 1 st Edition, 2016
- 3 DATA SCIENCE with KNIME, by Dr Nickholas Anting, NASPSOFT, 1st Edition, 2022
- 4 Beginning OpenOffice Calc, by Jacek Artymiak, Apress, 2011
Reproduced from the University of Mumbai syllabus for B.Sc. (Data Science) under NEP 2020, in force from the academic year 2024-25. Wording is as printed in that syllabus. Module numbering is as printed there too.
The complete syllabus
This subject is cut from the University circular for its year. Open a document here if you want the whole thing rather than a single subject.