BIO 200

Take a moment to review the details of this assignment below and gather any necessary files. Once you’re ready to submit your assignment, move on to Step 2.

Assessment Description

The purpose of this assignment is to articulate how various industries use the Internet and cloud computing resources in business operations and to establish a competitive advantage.

Part 1

Conduct research about the use of the Internet and cloud computing in a business sector related to your field of study.

Create a PowerPoint presentation with a minimum of eight slides that summarizes your findings. The presentation should address the following:

1. Describe the business sector.

2. Provide specific examples of how the industry is utilizing the Internet and cloud computing resources in business operations.

3. Explain how the use of Internet and cloud computing resources has helped the company gain competitive advantage by providing a specific example.

4. Discuss specific technology disruptors the industry/business sector has seen in the last 1-3 years.

5. Discuss how the industry/business sector is changing as a result of the use of Internet and cloud computing resources.

6. Include a reference slide at the end of the presentation.

Part 2

Practice delivering your PowerPoint presentation. Using Loom, record your delivery of the PowerPoint presentation. Refer to the topic Resources for additional guidance on recording your presentation with Loom. Employ the following public speaking strategies:

1. Speak slowly and clearly.

2. Make eye contact.

3. Present yourself in a professional manner.

4. Make sure that you are visible in the Loom bubble on the same screen with the PowerPoint slides.

General Requirements

Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

Submit the PowerPoint presentation file with the link to the Loom video presentation as the last reference in the references list slide. Do not try to upload the video file: It will be too big and will not upload. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

Rubric

Collapse All RubricCollapse All

collapse 

Use of Excel for Organizing

 assessment

Use of Excel for Organizing

12 points

Criteria Description

Use of Excel for Organizing

5. 5: Excellent

12 points

Directions for use of Excel for organizing are completed.

4. 4: Good

10.2 points

Directions for use of Excel for organizing are mostly completed.

3. 3: Satisfactory

9 points

Directions for use of Excel for organizing are somewhat completed.

2. 2: Less Than Satisfactory

7.8 points

Few directions for use of Excel for organizing are completed.

1. 1: Unsatisfactory

0 points

Directions for use of Excel for organizing are not completed.

collapse 

Use of Formulas in Excel

 assessment

Use of Formulas in Excel

15 points

Criteria Description
Use of Formulas in Excel
5. 5: Excellent
15 points

Directions for use of formulas in Excel are completed.

4. 4: Good

12.75 points

Directions for use of formulas in Excel are mostly completed.

3. 3: Satisfactory

11.25 points

Directions for use of formulas in Excel are somewhat completed.

2. 2: Less Than Satisfactory

9.75 points

Few directions for use of formulas in Excel are completed.

1. 1: Unsatisfactory
0 points

Directions for use of formulas in Excel are not completed.

collapse 

Use of Complex Formulas in Excel

 assessment

Use of Complex Formulas in Excel

6 points

Criteria Description
Use of Complex Formulas in Excel
5. 5: Excellent
6 points

Directions for use of complex formulas in Excel are completed.

4. 4: Good

5.1 points

Directions for use of complex formulas in Excel are mostly completed.

3. 3: Satisfactory

4.5 points

Directions for use of complex formulas in Excel are somewhat completed.

2. 2: Less Than Satisfactory

3.9 points

Few directions for use of complex formulas in Excel are completed.

1. 1: Unsatisfactory
0 points

Directions for use of complex formulas in Excel are not completed.

collapse 

Use of Excel to Create Graphs

 assessment

Use of Excel to Create Graphs

12 points
Criteria Description
Use of Excel to Create Graphs
5. 5: Excellent
12 points

Directions for use of Excel to create graphs are completed.

4. 4: Good
10.2 points

Directions for use of Excel to create graphs are mostly completed.

3. 3: Satisfactory
9 points

Directions for use of Excel to create graphs are somewhat completed.

2. 2: Less Than Satisfactory
7.8 points

Few directions for use of Excel to create graphs are completed.

1. 1: Unsatisfactory
0 points

Directions for use of Excel to create graphs are not completed.

collapse 

Use of Excel for Aesthetics

 assessment

Use of Excel for Aesthetics

15 points
Criteria Description
Use of Excel for Aesthetics
5. 5: Excellent
15 points

Directions for use of Excel for aesthetics are completed.

4. 4: Good
12.75 points

Directions for use of Excel for aesthetics are mostly completed.

3. 3: Satisfactory
11.25 points

Directions for use of Excel for aesthetics are somewhat completed.

2. 2: Less Than Satisfactory
9.75 points

Few directions for use of Excel for aesthetics are completed.

1. 1: Unsatisfactory
0 points

Directions for use of Excel for aesthetics are not completed.

Exam

Instructions

” by 7

Excel Proficiency Assignment

Use the instructions below to complete the assignment.

Use of Excel for Organizing

Change the name of the “Dataset” worksheet to “Excel Proficiency Exam”

Insert a new column between Column A and Column B

Split the single column A data into two separate columns

Add a new heading name to these columns, “Last Name” and “First Name”

Format Column C, D, E, and G for currency

Format Column F for percentages

Use of Formulas in Excel

Create a formula in Column E to Add Columns C and D

Label Column G “Taxes Paid”

Create a formula in Column G to Multiply Column E and F

Label Column H “Net Pay”

Create a formula in column H to subtract G from E

Insert a new column between Column E and Column F

Label the new column F “Average Daily Wage Rate”

Create a formula in the new column F to divide “

Total Weekly Wages

Merge cells K1 and L1 and name the cell “Employee Averages”

In column K, under the heading, copy the heading titles from C1:I1 to K2:K8. Use a formula to link the cells.

Create a formula in column L that calculates the averages for each matching category in K2:K8

Use of Complex Formulas in Excel

In cell K25, create a heading titled, “Thunder Occurrences”

In cell K26, create a formula that counts the number times “Thunder” occurs in the columns containing “Names”

Use of Excel to Create Graphs

Using data in the average table, create a pie chart that compares the amount of average weekday wages to the average weekend wages

Change the chart title to, “Weekday & Weekend Wage Comparison”

Position the chart so that it is placed between K10-L23

Use of Excel for Aesthetics

Change the font for your entire workbook to 12pt Arial

Widen or shrink all columns to the exact size of the words in the heading

Wrap text in headings with three or more words so that are no more than 3 words per line

Center the entire data set

Sort the entire data set according to last name

Add all borders to the entire data set along with the Employee Averages and Thunder Occurrences data set

Add a thick outside border to the first row of headings including the Employee Averages and Thunder Occurrences headings

Italicize and bold the text in the headings along with the Employee Averages and Thunder Occurrences headings

Add a Light Gray Background to all headings including Employee Averages and Thunder Occurrences

Insert an image of any GCU logo under the number of “Thunder Occurrences”

DataSet

Total Weekly Wages

800 1400

0.15

680 300

500 400

0

400 500

850 875

0.25

100 800

0.25

0.30

775

0.26

0.22

0.34

0.25

100 800

775

0.34

0.30

0.31

400 500 0.20

386 963 0.25

0.35

0.28

404 0.29

0.25

0.25

0.25

0.20

0.33

0.34

0.25

0.26

325 450 0.20

0.15

0.31

0.22

Weekday Wages	Weekend Wages	Tax Bracket
Doe,John				500				400				0.20
Lauterborn,Teresa		325		450									0.25
Williams,Anna				800		1400			0.22
Smith,Jane			0.30
Escobar,Tianna	475	731		0.33
Miranda,Isabelle	409	789			0.31
Thunder,Devin		850		875			0.15
Boscot,Kyra		680		300
Thunder,Kyra	0.14
Riley,Albert	0.13
Fink,Thunder			775			100	0.12
Garza,Tracey	0.18
Newert,Devin	0.19
Walker,Isabelle	740	678			0.26
Wells,Jane	715	449
Belanger,Anna	0.23
Rhodes,Kara	322		386
Anderson,Steven	273	738
Doe,Campbell	1000	0.10
Escobar,James	548		404
Adrian,Jacob	249	947				0.34
Martinez,Megan	326	982
Miranda,Brandon	532	589
Smith,Kelly	288		963
Williams,Ashley		0.35
Fisher,Kathryn	555		0.28
Barnes,Sean	320	462		0.29
Harper,Joshua	771	892
Avery,Chelsey	547	733
Pews,Kimberly	587	737
Lutz,Latrisha
Johnson,Bridget
Ellerman,Elizabeth	609	978
Slater,Jeffrey	592	822
Stover,Charlene	538
Kaiser,Melinda	204	577
St Louis,Peter	388	687
Molina,Christine	523	930
Harris,Robert	253	595	0.21
Craven,Mary Kate	495	406
Young,Nicole	627	513
Barraza,Warner	486	893
Taylor,Jonathan	714	602
Young,Samuel	758	439
Weiser,Ashley
Powell,Tamara	364	999
Davis,Michelle	695	828
Salinas,Thunder	460	942