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

W5 February 9 ✓

Last updated 1 year ago

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)


Breakout into Data Analytics and Robotics

Spreadsheets: Formatting

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?


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?


Consider for Completing Coursera Content

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 .

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: Submit a Shareable Link to Your Spreadsheet

Review the

Team Deliverable: Completed Challenge

✔️
✔️
Your Learning Strategy
🔗
Spreadsheet 2 Exercise
Pacing with the Coursera coursework
Password Protected Form
Logo
the last exercise
Save Link on Your Phone
Highlighting Transcript Text
Notes as Shortcuts to Video Clips
Slack and the Canvas
Example
Background Color
Text Color
Bold
Format as Currency
Decrease Decimal Places