Industry Connect
  • Industry Connect
  • Team
  • Automation Lab
    • Proposed Automation Lab
  • Founding Cohort
    • Program Details
    • Program Tech Skills Schedule
    • Google Data Analytics Pacing
    • Kaggle Tutorial Pathway & Pacing
    • Weekly Sessions
      • W1 January 12 ✓
      • W2 January 19 ×
      • W3 January 26 ✓
      • W4 February 2 ✓
      • W5 February 9 ✓
      • W6 February 16 ×
      • W7 February 23 ✓
      • W8 March 1 ✓
      • W9 March 8 ✓
      • W10 March 15 ✓
      • W11 March 22 ×
      • W12 March 29 ×
      • W13 April 5 ✓
      • W14 April 12 ✓
      • W15 April 19 ✓
      • W16 April 26 ✓
      • W17 May 3 ✓
      • W18 May 10 ✓
      • W19 May 17 ✓
    • Projects
      • Data Analytics Project
      • Cobot Project
    • Reference
      • Cobot Reference
      • Files
      • Your Learning Strategy
Powered by GitBook
  1. Founding Cohort
  2. Weekly Sessions

W7 February 23 ✓

Last updated 1 year ago

Agenda

  • During Lunch

    • Techpoint Xplore Program ()

    • Indy Modern Apprenticeship ()

  • Recognize Perfect Attendance

  • Explain Upcoming Incentives

    • Data Analytics

      • Complete First Two Coursera Courses by

      • Complete the Full Google Data Analytics Cert and Capstone by

    • 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

Data Analytics

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

  • Notes and preparing for challenges (quizzes).

  • Completing the challenges — "open book" and retries.

  • Set short sprint goals.


Robotics

See the Robotics tab for today's challenge.

Adapting a Flow with a Vacuum Gripper Loop

Demos

  • 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.

  1. Modify the "hover" point node to a position above the first tile in the row.

  2. Modify the set point node that increments the position in each cycle of the loop.

  3. Modify the point node to a position above the cup.

  4. Play the flow to test your modifications.

  5. Edit as needed.

Spreadsheets: Summary Tables with Functions

Exercise

Review Last Exercise

  1. Open your spreadsheet from the last exercise and review we accomplished.

Create a Summary Table of Statistics for All Movies

  1. 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.

  2. 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

  1. 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?

  2. 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?


Use for first two courses if you would like.

Get the first module (week 1) complete to build momentum.

Quick demo of the . It can be controlled much like the .

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 .

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.

Individual Deliverable: TBD.

Review the

⭐
⭐
✔️
👕
💻
👕
🎁
⭐
⭐
https://youtu.be/nDRxF7g1VGU
https://youtu.be/4GF1o0jLYWw
March 8
July 12
https://indymodernapprenticeship.com/
https://www.techpointyouth.org/xplore/
these summaries
vacuum gripper attachment
finger gripper
last exercise
🔗
Spreadsheet 3 Exercise
Pacing with the Coursera coursework