IE330 1. Mid-Term –Final: May 7th 12:20 PM – 02:10 PM (EST) 2. Log in to CANVAS and Zoom (https://psu.zoom.us/j/638824972) 10 minutes before the exam 3. This exam is a close book, close note exam. 4. Prepare one calculator (Cell phones and Graphical calculators are not allowed.) 5. Prepare few scratch paper 6. After the exam, you have to scan your scratch paper to one pdf file and upload it to Canvas by May 7th, 3:00 PM (EST). You will get 0 points for the Final if you don't submit your scratch paper. 7. All the questions are based upon in class discussion, class handouts, homework assignments and reading materials. 8. The formula sheet will provide the method or formula but will not specify its name. Topics: o Midterm 1 & II o Performance Evaluation ▪ Measures for Regression ▪ Measures for Classification • ROC & AUC o Database & SQL ▪ SQL syntax SELECT (DISTINCT) FROM
WHERE AND/OR IN IS (NOT) NULL LIKE GROUP BY HAVING ORDER BY DESC/ASC ▪ JOIN • INNER JOIN • LEFT JOIN ▪ Nested SQL