The purpose of this assignment is to develop students’ proficiency in using
MS Excel for advanced data analysis and decision-making in
engineering and technical contexts. Through hands-on experience with real-world
datasets, students will learn to analyze and visualize data, clean and filter
large datasets, and apply statistical tools to draw meaningful conclusions. By
focusing on tasks such as assessing the strength of spot welds and analyzing
weather data, students will enhance their ability to interpret technical data,
utilize MS Excel’s DataAnalysisToolPak, and make
evidence-based recommendations. This assignment prepares students to handle
complex data challenges, reinforcing their analytical skills and their capacity
to make informed decisions in professional engineering environments.
Guidelines
This assignment has two tasks worth 5 points each.
Read each task carefully. You are responsible for following all instructions
within each task. The table above lists everything you need to submit.
When your work is complete, confirm your deliverables are submitted to
Gradescope.
Late submissions will be accepted up to 24 hours after the due date. There is
a 25% penalty for late submissions.
Unless mentioned otherwise, for all programming tasks (Python or
MATLAB), team and individual, you will be generating a flowchart.
Accessing Gradescope for the first time in ENGR 133?
Log into Brightspace and open your ENGR 133 course.
Click Content from the black menu ribbon at the top of the page.
Click Welcome to ENGR 133 from the Table of Contents in the left sidebar.
Click the link titled Click here to access Gradescope.
Select the assignment you are ready to submit.
Opening Gradescope through Brightspace will auto-enroll you in the Gradescope
course for your section. You can access Gradescope through Brightspace
throughout the semester.
You can resubmit to Gradescope as many times as you need. Only your final
submission is graded.
If you cannot copy-paste into Gradescope, then you may need to refresh or
update your browser. Use a search engine to find a solution for your specific
browser.
You may seek help on individual tasks from classmates, the instructional team,
or others but the work that you submit should always be your own.
If you collaborate with others and use information developed together or by
someone else, ALWAYS document and reference that material.