Fall Semester 2026 UNISA Assignment: Automation and Data Analysis
(AIN3701) – Fully Solved Assignment with Step-by-Step Answers,
Marking-Guideline Alignment & Exam-Focused Study Guide (Updated 2026
Edition)
,Question 1:
Which of the following programming languages is most commonly used for data
analysis?
A. Java
B. Python
C. C++
D. Ruby
Correct Option: B. Python
Rationale: Python is widely used for data analysis due to its easy-to-read syntax,
extensive libraries (such as Pandas, NumPy, and Matplotlib), and strong community
support.
Question 2:
What is the primary purpose of automation in data analysis?
A. To increase manual labor
B. To decrease the accuracy of data interpretation
C. To streamline and enhance the efficiency of tasks
D. To gather data without any tools
Correct Option: C. To streamline and enhance the efficiency of tasks
Rationale: Automation aims to improve efficiency by minimizing manual interventions,
thus allowing for quicker and more accurate data processing.
Question 3:
Which data visualization tool is best suited for creating interactive dashboards?
A. Excel
B. Tableau
C. Microsoft Word
D. Notepad
Correct Option: B. Tableau
Rationale: Tableau is designed specifically for data visualization and creating
interactive dashboards, making it the preferred choice for analysts.
Question 4:
In data analysis, what is the term used for cleaning and organizing raw data?
, A. Data Mining
B. Data Transformation
C. Data Wrangling
D. Data Entry
Correct Option: C. Data Wrangling
Rationale: Data wrangling refers to the process of cleaning and organizing raw data into
a more usable format for analysis.
Question 5:
What does the term "Big Data" refer to?
A. Data that is too complex to handle
B. Data stored in databases
C. Large volumes of data that can be analyzed for insights
D. Data managed by IT departments
Correct Option: C. Large volumes of data that can be analyzed for insights
Rationale: Big Data refers to extremely large datasets that can be analyzed to reveal
patterns, trends, and associations, especially relating to human behavior and
interactions.
Question 6:
Which of the following is a popular library for data manipulation and analysis in Python?
A. NumPy
B. Pandas
C. Scikit-learn
D. Matplotlib
Correct Option: B. Pandas
Rationale: Pandas is a powerful data manipulation and analysis library for Python,
providing data structures like DataFrames.
Question 7:
What is the purpose of an ETL process in data analysis?
A. To enhance user interface
B. To extract, transform, and load data
C. To encrypt data
D. To visualize data
(AIN3701) – Fully Solved Assignment with Step-by-Step Answers,
Marking-Guideline Alignment & Exam-Focused Study Guide (Updated 2026
Edition)
,Question 1:
Which of the following programming languages is most commonly used for data
analysis?
A. Java
B. Python
C. C++
D. Ruby
Correct Option: B. Python
Rationale: Python is widely used for data analysis due to its easy-to-read syntax,
extensive libraries (such as Pandas, NumPy, and Matplotlib), and strong community
support.
Question 2:
What is the primary purpose of automation in data analysis?
A. To increase manual labor
B. To decrease the accuracy of data interpretation
C. To streamline and enhance the efficiency of tasks
D. To gather data without any tools
Correct Option: C. To streamline and enhance the efficiency of tasks
Rationale: Automation aims to improve efficiency by minimizing manual interventions,
thus allowing for quicker and more accurate data processing.
Question 3:
Which data visualization tool is best suited for creating interactive dashboards?
A. Excel
B. Tableau
C. Microsoft Word
D. Notepad
Correct Option: B. Tableau
Rationale: Tableau is designed specifically for data visualization and creating
interactive dashboards, making it the preferred choice for analysts.
Question 4:
In data analysis, what is the term used for cleaning and organizing raw data?
, A. Data Mining
B. Data Transformation
C. Data Wrangling
D. Data Entry
Correct Option: C. Data Wrangling
Rationale: Data wrangling refers to the process of cleaning and organizing raw data into
a more usable format for analysis.
Question 5:
What does the term "Big Data" refer to?
A. Data that is too complex to handle
B. Data stored in databases
C. Large volumes of data that can be analyzed for insights
D. Data managed by IT departments
Correct Option: C. Large volumes of data that can be analyzed for insights
Rationale: Big Data refers to extremely large datasets that can be analyzed to reveal
patterns, trends, and associations, especially relating to human behavior and
interactions.
Question 6:
Which of the following is a popular library for data manipulation and analysis in Python?
A. NumPy
B. Pandas
C. Scikit-learn
D. Matplotlib
Correct Option: B. Pandas
Rationale: Pandas is a powerful data manipulation and analysis library for Python,
providing data structures like DataFrames.
Question 7:
What is the purpose of an ETL process in data analysis?
A. To enhance user interface
B. To extract, transform, and load data
C. To encrypt data
D. To visualize data
