W7 February 23 ✓
Agenda
During Lunch
Techpoint Xplore Program (https://youtu.be/nDRxF7g1VGU)
Indy Modern Apprenticeship (https://youtu.be/4GF1o0jLYWw)
Recognize Perfect Attendance
Computer Checkout Policies
⭐ Sign Up / Apply ⭐
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.
⭐ Get the first module (week 1) complete to build momentum. ⭐
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.
Modify the "hover" point node to a position above the first tile in the row.
Modify the set point node that increments the position in each cycle of the loop.
Modify the point node to a position above the cup.
Play the flow to test your modifications.
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
Open your spreadsheet from the last exercise and review we accomplished.
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 3 Exercise
Create a Summary Table of Statistics for All Movies
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.
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:P6andK13:P13and fill the cells in light blue
Now let's start filling in the table with the statistics for All Movies:
In field
M7calculate the Average (all data) forbudgetusing the formula:=average(E:E)In field
M8calculate the Average (no 0's) forbudgetusing the formula:=averageif(E:E, ">0")In field
M9calculate the Min (no 0's) forbudgetusing the formula:=minifs(E:E, E:E, ">0")In field
M10calculate the Max forbudgetusing 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, andProfitcolumns by highlighting cellsN7-P10and 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)forProfit.
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?
Now let's fill in the Table 2 for movie genres Drama and Action:
In field
M14calculate the Average (no 0's)budgetfor 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
revenuechangeE:Ewhich references thebudgetcolumn toF:F.CHALLENGE: Can you create the same summary statistics for the genres Comedy and Thriller?
✔️ Individual Deliverable: TBD.
Review the Pacing with the Coursera coursework
Last updated