ENGR1121 – Computing in Mechanical Engineering
Lab Problem Solving I
Lab due: end of lab
Total points: 20
Labs are to be individual work. You may use the textbook, Excel’s help, and your notes. Lab work will be
graded during lab time and working results must be shown to the lab instructor by the end of the scheduled
lab time. All Excel Spreadsheets must be completed and submitted in accordance with the Computing
Assignment Format. Submit an electronic copy of your lab work to the appropriate Dropbox Folder in GSU’s
Folio by the end of lab. No hard copy needed unless specifically requested by the instructor.
Grading
Each problem will be graded according to: problem design (identifying inputs/givens, process, and outputs;
algorithm) and program style (headers and comments, variable names, proper formatted input and output
including units) 25%, and program correctness 75%.
Lab Work
Create an Excel Spreadsheet to do each of the following problems from the textbook.
Name the Excel Spreadsheet using the following naming scheme: lastnamelab1.xlsx
Create a new Worksheet within the Spreadsheet for each problem.
Name the Worksheet using the following naming scheme: Problem 1 or Problem 2.3 and so on
1. (10 points) The maximum daily temperature (in F) for New York City and Anchorage, Alaska during the
month of January 2001 are given (data from the U.S. National Oceanic Atmospheric Administration). Write
a program to answer the following:
a. Calculate the average temperature for the month in each city.
b. How many days was the temperature below the average in each city?
c. How many days, and which dates in the month, was the temperature in Anchorage higher than the
temperature in New York?
d. How many days, and which dates in the month, was the temperature the same in both cities?
e. How many days, and which dates in the month, was the temperature in both cities above freezing
(above 32 F)?
2. (10 points) The velocity, as function of time of a particle that moves along a straight line, is given in the
equations below:
𝟏𝟏. 𝟒𝟒𝟒𝟒 𝒇𝒇𝒇𝒇𝒇𝒇 𝟎𝟎 ≤ 𝒕𝒕 ≤ 𝟏𝟏𝟏𝟏 𝒔𝒔
⎧
𝝅𝝅
⎪
⎪𝟏𝟏𝟏𝟏 + 𝟓𝟓𝟓𝟓𝟓𝟓𝟓𝟓 � (𝒕𝒕 − 𝟏𝟏𝟏𝟏)� 𝒇𝒇𝒇𝒇𝒇𝒇 𝟏𝟏𝟏𝟏 ≤ 𝒕𝒕 ≤ 𝟐𝟐𝟐𝟐 𝒔𝒔
𝟏𝟏𝟏𝟏
𝒗𝒗(𝒕𝒕) =
𝟗𝟗 𝒇𝒇𝒇𝒇𝒇𝒇 𝟐𝟐𝟐𝟐 ≤ 𝒕𝒕 ≤ 𝟑𝟑𝟑𝟑 𝒔𝒔
⎨
⎪
𝟗𝟗
⎪
𝟗𝟗 − (𝒕𝒕 − 𝟑𝟑𝟑𝟑) 𝒇𝒇𝒇𝒇𝒇𝒇 𝟑𝟑𝟑𝟑 ≤ 𝒕𝒕 ≤ 𝟒𝟒𝟒𝟒 𝒔𝒔
⎩
𝟓𝟓
Create a data set for time from 0 to 40 s with the corresponding velocity in m/s and plot the x-y graph with
a smooth curve through the data.
1
Instructor: Dr. Priya Goeser
Lab Problem Solving I
of 1
Report
Tell us what’s wrong with it:
Thanks, got it!
We will moderate it soon!
Struggling with your assignment and deadlines?
Let EduBirdie's experts assist you 24/7! Simply submit a form and tell us what you need help with.
Free up your schedule!
Our EduBirdie Experts Are Here for You 24/7! Just fill out a form and let us know how we can assist you.
Take 5 seconds to unlock
Enter your email below and get instant access to your document