### 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**](https://docs.launchboard.app/industry-connect-2024/founding-cohort/reference/your-learning-strategy) for Completing Coursera Content
***
### **Breakout into Data Analytics and Robotics**
{% endtab %}
{% tab title="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](https://docs.launchboard.app/industry-connect-2024/founding-cohort/w4-february-2#data-analytics).
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. :link: [Spreadsheet 2 Exercise](https://docs.google.com/spreadsheets/d/1WamOLjdxlzueuSfIJB9GHu6EfaWJfMjTRxuz5gTTFbs/edit?usp=sharing)
#### 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?
\
:heavy\_check\_mark: **Individual Deliverable: Submit a Shareable Link to Your Spreadsheet**
{% embed url="" %}
***
### Review the [Pacing with the Coursera coursework](https://docs.launchboard.app/industry-connect-2024/founding-cohort/google-data-analytics-pacing)
{% endtab %}
{% tab title="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?
***
:heavy\_check\_mark: **Team Deliverable: Completed Challenge**
{% endtab %}
{% endtabs %}
