Lab 1 | him325 | DeVry University

MATH325_week_1_lab_instructions.docx

MATH325 Lab 1

Excel Orientation and Set-Up

Data Analysis with Comprehensive Statistics Software

Task: Set-up to get hands-on practice

Classes that use Microsoft Excel are designed to provide hands-on practice as a key part of the learning experience.

Follow the instructions below access Microsoft Excel.

1. For PC and Mac:

· Login to the student portal (http://my.devry.edu) from a web browser on your PC or Mac.

· Click the envelope found at the top of the page near your name to access your student email account.

· You will automatically be redirected to your student email account using Outlook.

· To access your subscription, click on the Office 365 button in the upper left-hand corner.

· To begin the installation of Office, click the Install Office button and follow the on-screen instructions.

2. For iOS and Android:

· Download from your app store:

· Windows (Links to an external site.)

· iPhone & iPad (Links to an external site.)

· Android (Links to an external site.)

· Sign in using your school credentials for full editing capability (Please note that you will be prompted to enter your school email address and then sign-in using your normal credentials).

Contact the Help Desk immediately with any questions or issues that arise.

Once you are able to access the software go to Files area in your course shell, in the Health Care Statistics & Research folder, to download the HealthCareData.xlsx file needed for the labs. You are now ready to open Excel and work with the data sets.

Introductory Excel Overview

Open Excel and review various menus and reports through the tutorial.

Launch the following videos from Microsoft to walk you through Excel:

https://support.microsoft.com/en-us/office/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57?ui=en-us&rs=en-us&ad=us

Follow along these short videos (~1 minute) and try the steps suggested in the videos:

· What is Excel?

· Create a workbook

· Insert or delete a worksheet

· Move or copy worksheets

· Fill data automatically

· Create a drop-down list

Continue on to Rows & Columns:

In these short videos, follow along and practice how to:

· Insert or delete rows or columns

· Change the column width and row height

· Freeze columns or rows

· Hide or unhide columns

· Split data into different columns

· Combine data

For additional instruction, continue to work through the Cells, Formatting, and Formulas and Functions video sets.

Once you have a basic understanding of introductory Excel, let’s look at how we can use excel for statistics.

Load the Analysis ToolPak into Excel

Check out the Data tab on the toolbar:

If you do not see Analysis TookPak, click on File Options:

This opens up the following window:

3.

2.

1.

Click on:

1. Add-ins, which is located towards the bottom of the left-hand column; then,

2. Analysis ToolPak;

3. Under Manage: Excell Add-ins, click Go.

In the Add-ins menu, select Analysis ToolPak, and click OK.

You should now have an Analysis area under your Data tab in Excel:

The Analysis ToolPak can be used to work through complex data analysis. Click on the following link for more information: https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

Read through the ANOVA and Regression areas found in the link above:

Deliverables

Once you have watched the introductory Excel videos, and read over the ANOVA and Regression areas (found in the links above), submit a 1 page summary of navigational challenges and issues you had in set-up, as well as, what you liked or what excited you about learning Microsoft Excel .

This summary should be in submitted into Week1: Lab.

Page 7

image1.PNG

image2.png

image3.png

image4.PNG

image5.PNG

image6.PNG

image7.png

image8.PNG

LabOverview.docx

Lab Overview

Scenario/Summary

The software used for the course's Lab Activities is Microsoft Excel. Microsoft Excel is a software program using spreadsheets to organize numbers and data for analysis using formulas and functions. Tedious calculations can be done using Microsoft Excel, freeing up students to focus on statistical concepts.

Uses:

With Microsoft Excel, you can generate decision-making information quickly by using powerful statistics, understanding and effectively presenting your results with high-quality tabular and graphical output, and sharing your results with others via using a variety of reporting methods. Results from your data analysis enable you to make smarter decisions more quickly by uncovering key facts, patterns, and trends.

In your professional life, you can use Microsoft Excel in a variety of areas, including

· survey and market research and direct marketing;

· academia;

· administrative research, human resources, and resource planning;

· medical, scientific, clinical, and social science research;

· planning and forecasting;

· quality improvement;

· reporting and ad hoc decision making; and

· enterprise-level analytic application development.

In this class, we will be using Microsoft Excel for the analytical process - planning, data collecting, data access, data management and preparation, data analysis, reporting, and deployment. Customers use Excel to anticipate change, manage both daily operations and special initiatives more effectively, and realize positive, measurable benefits. By incorporating predictive analytics into their daily operations, they become predictive enterprises - able to direct and automate decisions to meet business goals and achieve measurable competitive advantage.

What Does Predictive Analytics Do?

Predictive analytics informs and directs decision making by applying a combination of advanced analytics and decision optimization to an organization's enterprise data, with the objective of improving business processes to meet specific organization goals.

Predictive analytics offers numerous advantages for organizations recognizing the inherent value locked within their existing enterprise data. Strategically, predictive analytics provides a quantitative foundation for rapidly identifying, objectively evaluating, and confidently pursuing new market opportunities. Tactically, predictive analytics identifies precisely whom to target, how to reach them, when to make contact, and what messages should be communicated. Organizations incorporating predictive analytics into their daily operations in this way improve their business processes, enhancing decision making and gaining the ability to direct, optimize, and automate decisions, on demand, to meet defined business goals. Through predictive analytics, they not only better manage the present, but also increase the probability of future success.

Week1Lab.docx

Week 1: Lab

Learn how to use the Microsoft Excel and complete Lab 1. A complete set of instructions can be found in the Lab Overview for this week.

Rubric

Week 1 Lab

Week 1 Lab

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeOne (1) page summary of navigational challenges and issues you had in set-up.

10 to >0.0 pts

Full Marks

0 pts

No Marks

10 pts

This criterion is linked to a Learning OutcomeWhat you liked or what excited you about learning Microsoft Excel.

10 to >0.0 pts

Full Marks

0 pts

No Marks

10 pts

Total Points: 20

MATH325_week_1_lab_instructions.docx

MATH325 Lab 1

Excel Orientation and Set-Up

Data Analysis with Comprehensive Statistics Software

Task: Set-up to get hands-on practice

Classes that use Microsoft Excel are designed to provide hands-on practice as a key part of the learning experience.

Follow the instructions below access Microsoft Excel.

1. For PC and Mac:

· Login to the student portal (http://my.devry.edu) from a web browser on your PC or Mac.

· Click the envelope found at the top of the page near your name to access your student email account.

· You will automatically be redirected to your student email account using Outlook.

· To access your subscription, click on the Office 365 button in the upper left-hand corner.

· To begin the installation of Office, click the Install Office button and follow the on-screen instructions.

2. For iOS and Android:

· Download from your app store:

· Windows (Links to an external site.)

· iPhone & iPad (Links to an external site.)

· Android (Links to an external site.)

· Sign in using your school credentials for full editing capability (Please note that you will be prompted to enter your school email address and then sign-in using your normal credentials).

Contact the Help Desk immediately with any questions or issues that arise.

Once you are able to access the software go to Files area in your course shell, in the Health Care Statistics & Research folder, to download the HealthCareData.xlsx file needed for the labs. You are now ready to open Excel and work with the data sets.

Introductory Excel Overview

Open Excel and review various menus and reports through the tutorial.

Launch the following videos from Microsoft to walk you through Excel:

https://support.microsoft.com/en-us/office/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57?ui=en-us&rs=en-us&ad=us

Follow along these short videos (~1 minute) and try the steps suggested in the videos:

· What is Excel?

· Create a workbook

· Insert or delete a worksheet

· Move or copy worksheets

· Fill data automatically

· Create a drop-down list

Continue on to Rows & Columns:

In these short videos, follow along and practice how to:

· Insert or delete rows or columns

· Change the column width and row height

· Freeze columns or rows

· Hide or unhide columns

· Split data into different columns

· Combine data

For additional instruction, continue to work through the Cells, Formatting, and Formulas and Functions video sets.

Once you have a basic understanding of introductory Excel, let’s look at how we can use excel for statistics.

Load the Analysis ToolPak into Excel

Check out the Data tab on the toolbar:

If you do not see Analysis TookPak, click on File Options:

This opens up the following window:

3.

2.

1.

Click on:

1. Add-ins, which is located towards the bottom of the left-hand column; then,

2. Analysis ToolPak;

3. Under Manage: Excell Add-ins, click Go.

In the Add-ins menu, select Analysis ToolPak, and click OK.

You should now have an Analysis area under your Data tab in Excel:

The Analysis ToolPak can be used to work through complex data analysis. Click on the following link for more information: https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

Read through the ANOVA and Regression areas found in the link above:

Deliverables

Once you have watched the introductory Excel videos, and read over the ANOVA and Regression areas (found in the links above), submit a 1 page summary of navigational challenges and issues you had in set-up, as well as, what you liked or what excited you about learning Microsoft Excel .

This summary should be in submitted into Week1: Lab.

Page 7

image1.PNG

image2.png

image3.png

image4.PNG

image5.PNG

image6.PNG

image7.png

image8.PNG

LabOverview.docx

Lab Overview

Scenario/Summary

The software used for the course's Lab Activities is Microsoft Excel. Microsoft Excel is a software program using spreadsheets to organize numbers and data for analysis using formulas and functions. Tedious calculations can be done using Microsoft Excel, freeing up students to focus on statistical concepts.

Uses:

With Microsoft Excel, you can generate decision-making information quickly by using powerful statistics, understanding and effectively presenting your results with high-quality tabular and graphical output, and sharing your results with others via using a variety of reporting methods. Results from your data analysis enable you to make smarter decisions more quickly by uncovering key facts, patterns, and trends.

In your professional life, you can use Microsoft Excel in a variety of areas, including

· survey and market research and direct marketing;

· academia;

· administrative research, human resources, and resource planning;

· medical, scientific, clinical, and social science research;

· planning and forecasting;

· quality improvement;

· reporting and ad hoc decision making; and

· enterprise-level analytic application development.

In this class, we will be using Microsoft Excel for the analytical process - planning, data collecting, data access, data management and preparation, data analysis, reporting, and deployment. Customers use Excel to anticipate change, manage both daily operations and special initiatives more effectively, and realize positive, measurable benefits. By incorporating predictive analytics into their daily operations, they become predictive enterprises - able to direct and automate decisions to meet business goals and achieve measurable competitive advantage.

What Does Predictive Analytics Do?

Predictive analytics informs and directs decision making by applying a combination of advanced analytics and decision optimization to an organization's enterprise data, with the objective of improving business processes to meet specific organization goals.

Predictive analytics offers numerous advantages for organizations recognizing the inherent value locked within their existing enterprise data. Strategically, predictive analytics provides a quantitative foundation for rapidly identifying, objectively evaluating, and confidently pursuing new market opportunities. Tactically, predictive analytics identifies precisely whom to target, how to reach them, when to make contact, and what messages should be communicated. Organizations incorporating predictive analytics into their daily operations in this way improve their business processes, enhancing decision making and gaining the ability to direct, optimize, and automate decisions, on demand, to meet defined business goals. Through predictive analytics, they not only better manage the present, but also increase the probability of future success.

Week1Lab.docx

Week 1: Lab

Learn how to use the Microsoft Excel and complete Lab 1. A complete set of instructions can be found in the Lab Overview for this week.

Rubric

Week 1 Lab

Week 1 Lab

Criteria

Ratings

Pts

This criterion is linked to a Learning OutcomeOne (1) page summary of navigational challenges and issues you had in set-up.

10 to >0.0 pts

Full Marks

0 pts

No Marks

10 pts

This criterion is linked to a Learning OutcomeWhat you liked or what excited you about learning Microsoft Excel.

10 to >0.0 pts

Full Marks

0 pts

No Marks

10 pts

Total Points: 20

MATH325_week_1_lab_instructions.docx

MATH325 Lab 1

Excel Orientation and Set-Up

Data Analysis with Comprehensive Statistics Software

Task: Set-up to get hands-on practice

Classes that use Microsoft Excel are designed to provide hands-on practice as a key part of the learning experience.

Follow the instructions below access Microsoft Excel.

1. For PC and Mac:

· Login to the student portal (http://my.devry.edu) from a web browser on your PC or Mac.

· Click the envelope found at the top of the page near your name to access your student email account.

· You will automatically be redirected to your student email account using Outlook.

· To access your subscription, click on the Office 365 button in the upper left-hand corner.

· To begin the installation of Office, click the Install Office button and follow the on-screen instructions.

2. For iOS and Android:

· Download from your app store:

· Windows (Links to an external site.)

· iPhone & iPad (Links to an external site.)

· Android (Links to an external site.)

· Sign in using your school credentials for full editing capability (Please note that you will be prompted to enter your school email address and then sign-in using your normal credentials).

Contact the Help Desk immediately with any questions or issues that arise.

Once you are able to access the software go to Files area in your course shell, in the Health Care Statistics & Research folder, to download the HealthCareData.xlsx file needed for the labs. You are now ready to open Excel and work with the data sets.

Introductory Excel Overview

Open Excel and review various menus and reports through the tutorial.

Launch the following videos from Microsoft to walk you through Excel:

https://support.microsoft.com/en-us/office/video-what-is-excel-842fb550-07cb-42d1-9a9f-c55789efed57?ui=en-us&rs=en-us&ad=us

Follow along these short videos (~1 minute) and try the steps suggested in the videos:

· What is Excel?

· Create a workbook

· Insert or delete a worksheet

· Move or copy worksheets

· Fill data automatically

· Create a drop-down list

Continue on to Rows & Columns:

In these short videos, follow along and practice how to:

· Insert or delete rows or columns

· Change the column width and row height

· Freeze columns or rows

· Hide or unhide columns

· Split data into different columns

· Combine data

For additional instruction, continue to work through the Cells, Formatting, and Formulas and Functions video sets.

Once you have a basic understanding of introductory Excel, let’s look at how we can use excel for statistics.

Load the Analysis ToolPak into Excel

Check out the Data tab on the toolbar:

If you do not see Analysis TookPak, click on File Options:

This opens up the following window:

3.

2.

1.

Click on:

1. Add-ins, which is located towards the bottom of the left-hand column; then,

2. Analysis ToolPak;

3. Under Manage: Excell Add-ins, click Go.

In the Add-ins menu, select Analysis ToolPak, and click OK.

You should now have an Analysis area under your Data tab in Excel:

The Analysis ToolPak can be used to work through complex data analysis. Click on the following link for more information: https://support.microsoft.com/en-us/office/use-the-analysis-toolpak-to-perform-complex-data-analysis-6c67ccf0-f4a9-487c-8dec-bdb5a2cefab6

Read through the ANOVA and Regression areas found in the link above:

Deliverables

Once you have watched the introductory Excel videos, and read over the ANOVA and Regression areas (found in the links above), submit a 1 page summary of navigational challenges and issues you had in set-up, as well as, what you liked or what excited you about learning Microsoft Excel .