W4 February 2 ✓

Main

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

Data Analytics

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.

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. 🔗 Google Sheet with Starter Movie Dataset

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.

✔️ Individual Deliverable: Link to your Google Sheet.

Password Protected Form

---

Review

Pacing with the Coursera coursework

Reference

Google Sheets function list - Google Docs Editors Help

Robotics

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.

---

✔️ Individual Deliverable: Reflection on exercises.

Password Protected Form