Untitled Presentation

Multiple Choice

Why is data science important in today's digital world?

• It helps in making better decisions using data

• It is only used for entertainment

• It is not relevant to businesses

• It is only about programming

Open Ended

How can Excel be used to verify the accuracy of data ranges and formats before making predictions?

Multiple Choice

Which of the following is NOT a correct step when verifying data in Excel for prediction purposes?

• Ensuring that rainfall values are recorded as decimal numbers

• Making sure the number of negative events is not possible

• Verifying that each cell has a recorded value

• Using only positive numbers in all cells

Multiple Select

Which of the following are correct objectives of the lesson?

• Knowing the nature of prediction and expectation

• Knowing types of prediction charts and their advantages

• Knowing the confidence interval

• Learning how to code in Excel

Multiple Choice

What is the main topic of the lesson according to the lesson data and objectives?

• Predicting using Excel

• Data visualization

• Mathematical operations

• Programming basics

Fill in the Blanks

Fill in the blank: Prediction is the process of building future

based on previous data.

Open Ended

Explain the difference between prediction and expectation as described in the lesson.

Multiple Choice

What is the difference between 'prediction', 'expectation', and 'guess' as described in the lesson?

• Prediction is more general and based on previous data, expectation is based on reading and context, and guess is an attempt based on speculation.

• Prediction is always correct, expectation is always wrong, and guess is random.

• Prediction and expectation are the same, guess is different.

• Prediction is based on feelings, expectation is based on facts, guess is based on luck.

Multiple Select

Which of the following are steps involved in analyzing sales data to make predictions?

• Identify the data to be analyzed

• Use information technology tools to create predictions

• Determine the time series to predict

• Express data using charts

Open Ended

Explain how analyzing sales data can help in making predictions. Use examples from the steps shown in the images.

Open Ended

From the images in front of you, deduce the types of prediction charts!

Fill in the Blanks

The two main types of prediction charts shown in the lesson are ___ and ___ charts.

Multiple Choice

Which type of chart is best used to show changes over time using a series of connected data points?

• Bar chart

• Pie chart

• Line chart

• Scatter plot

Multiple Choice

What kind of data is most suitable for a vertical bar chart?

• Continuous time-based data

• Categorical data from surveys

• Geographical data

• Temperature readings

Multiple Choice

After studying the types of charts, classify the following feature: 'Helps in studying patterns over a long period of time.' Is it a feature of a line chart or a vertical bar chart?

• Line chart

• Vertical bar chart

• Both

• Neither

Open Ended

Describe a scenario where using a line chart would be more beneficial than a vertical bar chart. Justify your answer.

Open Ended

Explain one advantage of using a line chart over a vertical bar chart when analyzing data trends.

Open Ended

Why do you think the teacher asked you to review the test paper and then told you the grade was 14.50? What do you expect the teacher to do next and why?

Multiple Choice

Which of the following best describes a confidence interval?

• It is a single value that represents the true measurement.

• It is a range that reflects uncertainty in predictions.

• It is always an exact value measured in research.

• It is a value that never changes.

Fill in the Blanks

A confidence interval is determined by joining the

and the highest confidence value.

Multiple Select

Select all statements that are true about the confidence interval as described in the lesson.

• It provides a range of expected values.

• It is used to interpret prediction errors.

• It always gives the exact value.

• It is based on estimated values, not true values.

Open Ended

Explain what a 95% confidence interval means in statistics.

Open Ended

Define prediction and confidence interval.

Multiple Select

Which of the following are advantages of using a line graph?

• Helps in studying patterns over a long period of time

• Summarizes a large amount of data

• Makes statistical trends easier to observe

• Suitable for data with more than 100 points

Multiple Choice

Which of the following is NOT a method for data validation in Excel, as discussed in the previous lesson?

• Checking range validity

• Checking format validity

• Checking type validity

• Creating charts

Open Ended

What are some ways you can use Excel for prediction in data science?