Agenda

Reflections and Personal Updates

1. What have you done/learned? Recall last week and anything since then.

2. What are you doing/learning next? Take a quick look ahead in the program and consider your personal goals.

3. What roadblocks do you have? Explain anything that may be hindering your progress.

Optional Individual Deliverable: Share anything new you have learned on Slack that may help others.

Breakout into Data Analytics and Robotics

Spreadsheets: Functions and Formulas

Exercise

In this exercise we will practice how to make simple calculations and use functions in spreadsheets to make processing easier. We will continue to use the Google sheet of movie data we created in the last exercise.

Review Last Exercise

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

Using a Formula to Generate a New Column of Data - Profit

1. In the column to the right of the genres_description column label the column profit for calculating profit.

2. In the first cell below the profit label, enter a formula for calculating the profit. =F2-E2 This formula simply subtracts the movie budget from the revenue.

3. Copy that formula for all rows in our movie table. It is likely that Google Sheets offered to do this for you by asking your approval. If not, you can select the cell you want to copy and drag the corner down to the bottom of the column to quickly fill the rest of the table. There is also a double-click trick you can use.

4. That's it. Do a quick check to verify that the calculation is working as you expect on several movies. What other calculations do you think might be useful?

Using a Function to Calculate Averages

1. To the right of our table create a label in cell K1 by entering All Movies Vote Average

2. In the cell below our label, K2, enter the following function to calculate the average vote for the whole movie dataset: =AVERAGE(C:C) There are several ways to do this that we will cover in the demonstration.

3. Let's say we want to find the average vote for all drama movies. Create another label in L1 and enter All Dramas Vote Average.

4. In the cell below this label, L2, enter the following function to calculate the average vote for all the dramas in our movie dataset. =AVERAGEIF(H:H,"*Drama*",C:C) The H:H directs the functions to search the genres_description column to look for any movies containing the word "Drama" in the genre. It then averages the vote_average column, C:C, for matching movies. The * is a wildcard that allows the function to accept the word "Drama" even if there is text before or after the word.

5. That's it. Now consider how you would calculate the average for comedies or how you migh find the total revenue for action movies. Discuss how you might do that.

Review

Pacing with the Coursera coursework

Reference

Working with Patterns / Looping and Logic

Demo

Initializing the Set Up: An Index Variable with Starting Point

1. Manager > Variables

2. Discuss Data Types

3. Add a Name and Value (int i = 0)

4. Add a "Set" Node

5. Edit the Set Node - Select Variables > ADD Expression (var_i = 0)

6. OK ... out

7. Add a Point for our Home Point and Set the Position

8. Note: Can use Point Manager > Overwrite New Pose to this Point

Adding a Conditional If Statement

1. Add an "If" node

2. Select Variables and Add (+) an Expression

3. Build expression var_i < 5

4. OK ... out

Display var_x Value and Increment var_i by 1

1. Add a Display node to the Yes path of If node

2. Edit Display to

   • Title: "Index Value"

   • Content: var_i

3. Add a Set node to increment var_i by 1 (var_i =+ 1)

Add the Movement and Set Up Loops

1. Add a Move node

   • Set Y to 50 mm

   • Base is current robot base

2. Loop from the Move node to the If node

3. Loop the If no path back to our initializing Set node

Challenge

1. In groups discuss how you would create a flow to increment upwards 8 times by 25mm then loop to the beginning.

2. Program the cobot flow, step-run the flow, and run the flow from the start.

3. Discuss questions and possible adaptions to techniques.

Challenge Bonus

1. In groups discuss how you would create a flow to move through a checkerboard pattern row by row with the robot arm.

2. Draw the logical flow on paper.

3. Discuss questions and possible adaptions to techniques.

Welcome! This week we will discuss an innovator's journey, get started with the core tools for the program, and begin to imagine how data and automation may intersect your future. Let's go!

Agenda

Summary of the Industry Connect Program

• The Team, the Objectives, and the Schedule

• About Data

• About Robotics

• Connecting to Industry

Get Started with the Tools

• Coursera (For Data Track)

Individual Deliverable: Verify successful enrollment in first data course on Coursera.

A Look to Next Week

Vision to Action

• Anticipating your future

• Growth mindset

• Developing a personal vision

An Innovator's Journey

• Problem Solving and Innovation

• The steps in the journey

• Some examples

• Group discussion: Imagine the journey of an inspirational person or product.

Agenda

Let's hit the ground running! This week we will get into our groove with training. Let's go!

Slack Setup

We will use Slack for online messaging. "Slack organizes conversations into channels, where everyone can come together in one place to share ideas, make decisions and move work forward. It helps teams operate faster and stay in sync, wherever they are." --slack.com

Use slack to:

• Ask questions about the data analytics and robotics training

• Ask questions about career and college options

• Share interesting things you find related to STEM

Individual Deliverable: Say hello to the group in Slack and add a profile photo .

Breakout into Data Analytics and Robotics

Spreadsheets: Working with CSV Files & Creating Charts

Exercise

Today we are going to do a very common and incredibly useful task for data analysts -- import a CSV file into a spreadsheet and create charts. This also aligns with the Google Data Analytics Certificate coursework.

Video Intro and Demo >

Preparing the Movie Data

1. Create a new Google Sheets file on Google Drive

2. Download our movies dataset (CSV) and import it into your Google Sheet.

3. Review the column names and data.

Creating a Bar Chart

1. Create a bar chart of the top ten movies displaying the budget.

2. Format the budget column in dollars.

3. Format the chart with a clear title and axis label.

4. Review the chart. Does the data tell a story or raise any questions?

Creating a Scatterplot

1. Create a scatterplot comparing the revenue and vote_count.

2. Format revenue column in dollars.

3. Format the chart with a clear title and axes labels.

4. Review the chart. Does the data tell a story or raise any questions?

Creating a Histogram

1. Create a histogram of the runtime for all of the movies.

2. Format the chart with a clear title and axes labels.

3. Review the chart. Does the data tell a story or raise any questions?

4. Arrange the three charts for easy viewing.

Review the Pacing with the Coursera coursework

Thinking in 3D / Point to Point Movement

Intro to the Cobot

Demo

1. Robot startup.

2. TM Flow Project Interface

3. Robot Stick

4. Safety Review

Creating a Point-to-Point Flow

Demo

1. 3D coordinate system.

2. Creating point nodes.

3. Step running the flow.

4. Playing the flow from start.

Challenge

1. In groups discuss how you would create a flow to trace the challenge pattern with the robot arm.

2. Each group will program the cobot flow to trace the challenge pattern, step-run the flow, and run the flow from the start.

3. Discuss questions and possible adaptions to techniques.

Using Move Nodes

Demo

• Creating move nodes.

Challenge

1. In groups discuss how you would create a flow to maneuver the in-and-out challenge with the robot arm.

2. Each group will program the cobot flow to maneuver the in-and-out challenge, step-run the flow, and run the flow from the start.

3. Discuss questions and possible adaptions to techniques.

Agenda

Quick Discussion

• Industry Connect 2024 Web Link on Phone (QR Code above)

• Slack and the Slack Canvas

• How to Use Notes Feature on Coursera

• Review the Program Format

  • Data Analytics

    • Friday Skills Sessions (Spreadsheets and SQL)

    • Coursera Courses (8) for Google Data Analytics Professional Certificate

  • Robotics

    • Friday Robot Lab Work

    • Research and Design work (Starting Feb 23)

• Consider Your Learning Strategy for Completing Coursera Content

Breakout into Data Analytics and Robotics

Spreadsheets: Formatting

Exercise

In this exercise we will format our table to improve readability and highlight important data. This will build off of the Google sheet of movie data we created in the last exercise.

Review Last Exercise

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

Basic Formatting

1. Select the column names at the top of the spreadsheet, cells A1:I1. Format names with a blue background and white bold text.

   • Select the paint can icon and choose a dark blue color for the background.

   • Select the text icon ("A") and choose white for the text.

   • Select the Bold icon ("B") to emphasize the text
2. Select the budget, revenue, and profit columns and format as currency by selecting the $ icon. Then round to the nearest dollar by reducing the decimal places. Find the button below in the toolbar and click it 2 times to remove the cents from the dollar amount.

3. Decrease the decimals in the vote averages you generated from last week. Select the values of All Movies Vote Average and All Drama Vote Average. Round the values to the nearest decimal point (see 2. above).

Conditional Formatting

1. Select profit column. Let's color-code this column so that any movies that lost money are highlighted in red and any movies that made at least $1 billion are highlighted in green. Select Format > Conditional Formatting in the top menu bar.

2. For movies that made at least $1 billion dollars, change the format rules in the side panel as shown below. Select Done when you are finished.

1. Click on +Add another Rule in the side panel. For movies that lost $, change the format rules as shown below. Select Done when you are finished.

Which movie has the highest profit? Lowest?

Review the Pacing with the Coursera coursework

Precision and Repeatability / Grabbing and Releasing Objects

Demo

Initializing the Set Up (Basic)

1. Add a Home Point: Add a Point Node and set the point position for our home point. Center it at a high level above the working surface.

Move Towards and Grab the Test Object

1. Move to Position Above Object: Add a Point Node above the object such that the gripper is positioned to drop downward to grab the object.

2. Move into a "Grabbing" Position: Add another Point Node or a Move Node that brings the gripper down into a position for grabbing the object.

3. Grab the Object: Add a Grip Node to grip the object.

4. Evaluate Precision: Evaluate how well the gripping motion worked. Does it produce a firm grip on the object? Did the grip action cause the object to move or shift unnecessarily? Refine the flow if needed.

Move the Object to the Destination and Release It

1. Move object up: Add a Point Node or a Move Node that brings the object up to clear any constraints (like a containing box).

2. Move Object to Point Above Destination: Add another Point Node or a Move Node that moves the object above the destination, clear of any obstacles etc.

3. Move into a "Releasing" Position: Add another Point Node or a Move Node that brings the gripper down into a position for releasing the object.

4. Release the Object: Add a Release Node to release the object.

5. Evaluate Precision: Evaluate how well the release motion worked. Does it position the object accurately? Did the release action cause the object to move or shift unnecessarily? Refine the flow if needed.

Loop Back to Home Point

1. Loop to the Home Point: Use a Goto Node to return the flow to our home point.

Challenge

1. In groups discuss how you will program a flow to grab and move an object similar to the demo.

2. Program the cobot flow, step-run the flow, and run the flow from the start.

3. Discuss questions and possible adaptions to techniques. How easy would it be to adapt your flow to work with different starting and ending positions?

Agenda

• During Lunch: Custom GPT Demo with Audio

• Review Progress on Coursera and Summer Opportunities

• Breakouts into Data Analytics and Robotics

SQL: SELECT, FROM, ORDER BY

Exercise

Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.

Demo: SELECT, FROM, ORDER BY, ASC, DESC

Practice: Constructing SQL Statements

Construct the appropriate SQL statements to satisfy each of the following requests. Use the to test your statements.

1. List all movies in the movies table. Include all columns.

2. List all movies, but include only title and year columns.

3. List all movies by ascending year. Include all columns.

4. List all movies by descending vote_count. Include only title and vote_count columns.

Demonstrate your executed SQL statements with an instructor.

Continue work on the Data Analytics Certificate on Coursera ()

Using Cobot Vision to Recognize and Pick Objects

Demo

We will demonstrate how to define a visual servoing job to a cobot flow to recognize the position of objects. This will create a base that we can use to then pick up the object and move to another location. We will also use a subflow to separate functions.

Challenge

Work in small groups to modify the demo flow.

• Create a new visual servoing job that picks up a different object. This will require learning the new pattern to match

• Update the point node to position the cobot vacuum gripper above the object.

• If needed, adjust the move node to grip the object.

• Test your updated flow.

Agenda

• Updates and Important Housekeeping

  • New Kaggle pathway for data analytics.

  • Absent Last Week? Complete the Survey: T-shirt Sizes and Summer Plans

  • Apply for Techpoint Xplore Program

• Data Students Complete the data analytics exercise (more SQL) then continue progress on Coursera or Kaggle

• Robotics Students

  • Didn't Pass the Badge Quiz Last Week?: You can still do it. Review and

  • Cobot training: Working with Pallets and Bin Boxes

SQL: Functions and GROUP BY

Exercise

Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.

Demo

COUNT, SUM, AVG, GROUP BY

Constructing SQL Statements

Construct the appropriate SQL statements to satisfy each of the following requests. Use the to test your statements.

1. Determine the number of movies released by year. Order by year.

2. Determine the total number of votes collected (vote_count) for all thriller movies by year. Order by year.

3. Determine the total revenue for adventure movies by year. Order by descending total revenue.

4. Determine the average of the vote_average for all comedies by year. Order by descending vote average.

5. Determine the average profit for adventure movies by year. Remember that profit is calculated as (revenue - budget). Remove revenue and budget values that are < 0. Order by descending profit.

Review the

Working with Pallets

Demo

Challenge

Agenda

Updates

• Review Progress and Accomplishments

  • Be sure to complete Coursera courses in order. See the #pacing-schedule.
• Review Objectives for April and May

  • Google Data Analytics Pathway

  • Kaggle pathway

  • Robotics

Today

• Data Students Focus on making progress on Coursera.

• Robotics Students

Focus on Coursera Progress

Badge Testing

Experimentation

While others are re-testing, small groups can experiment with the cobot. You have had a good amount of experience with the cobot. So, it is a good time to do a little experimenting on any curiosities you have about the robot functionality.

Agenda

Progress and Updates

Progress

• Coursera Course 1 Complete: Amare, Khyjah, Jaianna

• Cobot: Monty, Caleb, Davion, Johnathan, Jaianna

• Kaggle Progress : Greg

Updates

• ROCK Summer Counselors (more info on April 26)

• Paid Summer Micro-Internships (June 10 - 21, 4 hours a day)

• Any other news?

Tasks

• Discuss Linked In Profiles and Accomplishments
• Review Instructions for Data Project and Cobot Project

• Data Students 1) Continue progress on Coursera and 2) complete data project survey.

• Robotics Students

  1) Practice upcoming "Cobot Programmer Badge" challenge and 2) complete cobot project survey.

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.

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.

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

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

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?

Review the Pacing with the Coursera coursework

Agenda

• Please fill this form out with contact info, even if not applying for micro-internships! Summer Micro-Internships, AI, and Contact Info: https://form.jotform.com/241304162709046

  • We still strongly encourage you to apply for the micro-internships.

  • We will continue to support you through the summer learning.

  • We want to give you premium-level access to AI tools.

  • We want to be able to deliver things to you as needed -- like t-shirts when they are finished.

• Data Analytics: Continue work on data analytics courses. Links and pacing guide ->

• Make LinkedIn profile updates, as needed

Agenda

• Attendance Awards

• Data Analytics

  • Work on Data Analytics Course Progress

  • Questions and work on Data Project

  • Optional Resource for preparing for Coursera Courses https://docs.idew.org/gda-cohort-1/a801YJyWh1IWZBYOdSXN/

• Summer Opportunities

  • Complete the Industry Connect Survey for Summer Micro-Internships

  • ROCK Summer Counselors Opportunity Application: https://www.surveymonkey.com/r/JJ5KZYF Job description below.

• LinkedIn Profile Updates, as needed

• Robotics

  • Collaboratively Work on Challenge

Agenda

• During Lunch Review Coursera course structure, pacing, and incentives

• Survey: T-shirt Sizes and Summer Plans https://form.jotform.com/240674228249057

• Data Students Complete the data analytics exercise

• Robotics Students Review the concepts for the Cobot Node Novice badge and complete the assessment

• Data Students Continue Progress on Coursera

SQL: WHERE, LIKE, LIMIT

Exercise

Today we will continue to use Structured Query Language (SQL) to pull data from a movie database. This time we will learn basic filtering techniques.

Demo

WHERE, LIKE, LIMIT

Constructing SQL Statements

Construct the appropriate SQL statements to satisfy each of the following requests. Use the LaunchBoard SQL Lab to test your statements.

1. List movies since the year 2000 in ascending alphabetical order. Include title and year columns.

2. List all movies containing the string "night" anywhere in the title. Include the title and year columns.

3. List movies before 2000 ordered by ascending vote_average. Show only the top 30. Include all columns.

Demonstrate your executed SQL statements with an instructor.

Continue work on the Data Analytics Certificate on Coursera (Pacing)

Cobot Node Novice Assessment

Today you will demonstrate your understanding of the cobot concepts we have applied in the program to date to earn the Cobot Node Novice badge.

Review

Assessment

Agenda

Progress and Updates

• Progress Dashboard

• ROCK Summer Counselors (more info on April 26)

• Paid Summer Micro-Internships (June 10 - 21, 4 hours a day)

• Any other news?

Tasks

• LinkedIn Presence (Example Post)

  • Photos

  • Profiles & Accomplishments

• Data Project

  • Data Uploaded to the SQL Lab -> Practice SQL to Spreadsheet Chart

  • Complete data project survey if needed.

• Data Students: Continue progress on Coursera or Kaggle

• Cobot Project: complete cobot project survey.

• Cobot Students: Demonstrate "Cobot Programmer Badge" challenge.

Agenda

Progress and Updates

• Progress Dashboard

• Reminder: Paid Summer Micro-Internships Opportunity (June 10 - 21, ~4 hours a day)

• Any interest in further cobot training this summer?

• Any other news?

• ROCK Summer Counselors Opportunity

  • Application: https://www.surveymonkey.com/r/JJ5KZYF

  • Job description below:

Tasks

• LinkedIn Presence (Example Post)

  • Photos

  • Profiles & Accomplishments

• Data Project: Data Uploaded to the SQL Lab and video demonstration added to instructions.

• Data Students: Continue progress on Coursera or Kaggle

• Cobot Project: Form teams, discuss project challenge, and complete cobot project survey.

• Cobot Students: If needed, demonstrate "Cobot Programmer Badge" challenge or review the slides from March 15 and complete the assessment for the "Cobot Node Novice Badge"

Agenda

• Attendance Awards

• Cobot Badge Certificates

• Summer Micro-Internships, AI, and Contact Info: ★ APPLY NOW

• Data Analytics

  • Work on Data Analytics Course Progress

  • Questions and work on Data Project

  • Optional Resource for preparing for Coursera Courses https://docs.idew.org/gda-cohort-1/a801YJyWh1IWZBYOdSXN/

• LinkedIn Profile Updates, as needed

• Robotics: Jenga Challenge