W7 February 23 ✓ | Industry Connect

Agenda

During Lunch
- Techpoint Xplore Program (https://youtu.be/nDRxF7g1VGU)
- Indy Modern Apprenticeship (https://youtu.be/4GF1o0jLYWw)
Recognize Perfect Attendance
Explain Upcoming Incentives
- Data Analytics
  - Complete First Two Coursera Courses by March 8 👕
  - Complete the Full Google Data Analytics Cert and Capstone by July 12 💻
- Robotics
  - Pass Cobot Programming Level 1 Challenge and Quiz by March 8 👕
  - Complete the Full LaunchBoard Cobot Certification by July 12 🎁
Computer Checkout Policies
⭐ Sign Up / Apply ⭐
- https://indymodernapprenticeship.com/
- https://www.techpointyouth.org/xplore/

Data Analytics

We will focus on Coursera today by discussing strategies and making progress.

Notes and preparing for challenges (quizzes).
Use these summaries for first two courses if you would like.
Completing the challenges — "open book" and retries.
Set short sprint goals.
⭐ Get the first module (week 1) complete to build momentum. ⭐

Robotics

See the Robotics tab for today's challenge.

Adapting a Flow with a Vacuum Gripper Loop

Demos

Quick demo of the vacuum gripper attachment. It can be controlled much like the finger gripper.
Demo of the flow that individually picks tiles placed in a row and drops each in a cup.
Demo of how to modify the flow to adapt to different positions of the cup and tiles.

Screen Images for Reference

Challenge

In this challenge we will use a programmed loop to place objects in a container. Your challenge will be to adapt the program to changing conditions.

Modify the "hover" point node to a position above the first tile in the row.
Modify the set point node that increments the position in each cycle of the loop.
Modify the point node to a position above the cup.
Play the flow to test your modifications.
Edit as needed.

Spreadsheets: Summary Tables with Functions

Exercise

In this exercise we will create and format two tables which will provide summary statistics for the movie data. This will build off of the Google sheet of movie data we created in the last exercise.

Review Last Exercise

Open your spreadsheet from the last exercise and review we accomplished.
Continue to use your spreadsheet for this exercise. If you missed the last exercise and need to jump into this one, use this link below and make a copy of the template spreadsheet. 🔗 Spreadsheet 3 Exercise

Create a Summary Table of Statistics for All Movies

Before you begin, make sure your graphs from the previous exercises are NOT in columns K-Q. If they are obstructing any of the those columns, move them over to the right past column Q.
Starting in column K5, build the 2 table structures below:
- The top table will contain the statistics for all movies. Add the Title in cell K5 - Table 1: Summary Statistics for All Movies.
- The bottom table contains the statistics for only Drama and Action movies. Add the Title in cell K12 - Table 2: Summary Statistics for each Movie Genre.
- Highlight the table headers in K6:P6 and K13:P13 and fill the cells in light blue

Now let's start filling in the table with the statistics for All Movies:
- In field M7 calculate the Average (all data) for budget using the formula: =average(E:E)
- In field M8 calculate the Average (no 0's) for budget using the formula: =averageif(E:E, ">0")
- In field M9 calculate the Min (no 0's) for budget using the formula: =minifs(E:E, E:E, ">0")
- In field M10 calculate the Max for budget using the formula: =max(E:E)
- Highlight and copy the cells (Edit > Copy) of all the calculations you just generated for budget(M7:M10)
- Paste the formulas in the Revenue, Runtime, and Profit columns by highlighting cells N7-P10 and pasting (Edit > Paste). Change the columns in the formulas to match the column in the table header. So for example you would change =average(E:E) to =average(I:I) for Profit.
Observe the difference between the Average (all data) and Average (no 0's) values. Why do we remove the 0's from the averages and minimum values? Which do you think is more accurate? Why?
Now let's fill in the Table 2 for movie genres Drama and Action:
- In field M14 calculate the Average (no 0's) budget for Drama movies only using the formula: =averageifs(E:E, E:E, ">0", H:H, "*Drama*").
- Can you do the same calculation for Action movies only in cell M15? Hint: Copy the formula first. Where have you seen this before? It should be familiar because we did this in week 3's assignment!
- Now complete Table 2 by copying and pasting the formulas to the other cells and changing the column references to reflect the table headers. Hint: For revenue change E:E which references the budget column to F:F.
- CHALLENGE: Can you create the same summary statistics for the genres Comedy and Thriller?