W10 March 15 ✓

Main

Agenda

• Updates and Important Housekeeping

  • New Kaggle pathway for data analytics. More Info >

  • Absent Last Week? Complete the Survey: T-shirt Sizes and Summer Plans https://form.jotform.com/240674228249057

  • Apply for Techpoint Xplore Program ⌛ https://techpoint.org/xplore-students/

• Data Students Complete the data analytics exercise (more SQL) then continue progress on Coursera or Kaggle

• Robotics Students

  • Didn't Pass the Badge Quiz Last Week?: You can still do it. Review the slides from last week and complete the assessment 🚀

  • Cobot training: Working with Pallets and Bin Boxes

Data Analytics

SQL: Functions and GROUP BY

Exercise

Today we will use Structured Query Language (SQL) to pull data from a movie database. SQL, like spreadsheets, is an indispensable tool for data analysts.

Demo

COUNT, SUM, AVG, GROUP BY

Constructing SQL Statements

Construct the appropriate SQL statements to satisfy each of the following requests. Use the LaunchBoard SQL Lab to test your statements.

1. Determine the number of movies released by year. Order by year.

2. Determine the total number of votes collected (vote_count) for all thriller movies by year. Order by year.

3. Determine the total revenue for adventure movies by year. Order by descending total revenue.

4. Determine the average of the vote_average for all comedies by year. Order by descending vote average.

5. Determine the average profit for adventure movies by year. Remember that profit is calculated as (revenue - budget). Remove revenue and budget values that are < 0. Order by descending profit.

---

Review the Pacing with the Coursera coursework

Robotics

Working with Pallets

Demo

---

Challenge

✅ Every student will position and program the cobot to cycle through positions of a pallet (or bin box) using the Pallet node.