W5 February 9 ✓

Main

Agenda

Save Link on Your Phone

Highlighting Transcript Text

Notes as Shortcuts to Video Clips

Slack and the Canvas

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

Data Analytics

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.

Example

Review Last Exercise

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

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

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

   

   Background Color

   

   Text Color

   

   Bold
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).

Format as Currency

Decrease Decimal Places

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.

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

✔️ Individual Deliverable: Submit a Shareable Link to Your Spreadsheet

Password Protected Form

---

Review the Pacing with the Coursera coursework

Robotics

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?

---

✔️ Team Deliverable: Completed Challenge