Question Paper
BCA 3rd Sem Basics of data science using excel
📅 2025🎓 3rd Sem✍️ by Admin
🤖 AI Solved Important Questions (Click to Reveal)
Examination Details
Course: Basics of Data Science Using Excel.
Total Marks: 50.
Time Allotted: Three hours.
Instructions: Students must attempt five questions in total. Question No. 1 is compulsory, and students must select exactly one question from each of the four units. All questions carry equal marks.
Syllabus Coverage
Compulsory Question: Covers the use of the Count function, data validation, differences between simple and multiple regression, histogram usage, and the purpose of Chi-square tests.
Unit I: Focuses on the importance and applications of data science, basic mathematical functions in Excel, data sorting techniques (ascending/descending), and applying conditional formatting to datasets.
Unit II: Addresses the 'Text-to-Columns' feature for splitting data, steps for creating bar charts, and the benefits and limitations of importing/exporting data across CSV, TXT, and Excel formats.
Unit III: Requires explanations of standard deviation versus variance, the concept of hypothesis testing in inferential statistics, and simple linear regression including its equation, assumptions, and application in Excel.
Unit IV: Examines the features of the Excel Data Analysis ToolPak and the process of creating, customizing, and interpreting PivotTables for data analysis.
📤
Help Your Community!
Do you have papers from other years? Upload them to help your juniors.
Upload My Papers