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