DAD 220 5-2 Activity Desharnais
docx
keyboard_arrow_up
School
Northeast Community College *
*We aren’t endorsed by this school
Course
CYBER SECU
Subject
Mechanical Engineering
Date
Feb 20, 2024
Type
docx
Pages
3
Uploaded by ChefSardinePerson542
DAD 220 Analysis and Summary Template
Replace the bracketed text in this template with your responses and any supporting screenshots. Then submit it to the Module Five Activity for grading and feedback. Rename this document by adding your last name to the file name before you submit. 1.
Analyze the data
you’ve been provided with to identify themes
:
a.
Which parts are being replaced most? The parts being replaced the most are battery replacements.
b.
Is there a region of the country that experiences more part failures and replacements than others?
i.
Identify region:
1.
The Midwest Region has the most repairs at 1300.
ii.
How might the fleet maintenance team use the information to update its maintenance schedule? 1.
They could use this information to determine how many people and supplies are needed for the region. As well as what the most likely type of repairs will be.
c.
Which parts are being replaced most due to corrosion or rust?
1.
Fender Replacement is being done the most at 270 Repairs.
d.
Which parts are being replaced most because of mechanical failure or accident, like a flat tire or rock through the windshield?
i.
Tire replacements are being replaced most of the time due to accidents.
2.
Write a summary of your analysis
that
takes the information from Step 1 and presents it in a way that nontechnical stakeholders can understand.
Based on the analysis of the provided data, the most frequently replaced part in the fleet is the battery. In terms of region, the Midwest experiences the highest number of repairs, with a total of 1300. This information can help the fleet maintenance team allocate appropriate resources and supplies to the region. When it comes to parts replaced due to corrosion or rust, fender replacements top the list at 270 repairs. On the other hand, tire replacements are most required due to accidents, such as flat tires or objects damaging windshields.
3.
Outline the approach
that you took to conduct the analysis. a.
What queries did you use to identify trends or themes in the data?
To identify trends and themes in the data, I used queries to filter and sort the dataset based on specific criteria. For example, I queried the data to identify the most frequently replaced parts, regions with the highest repair counts, parts replaced due to corrosion or rust, and parts replaced due to mechanical failure or accidents. These queries allowed me to
extract relevant information from the dataset and identify patterns and themes. b.
What are the benefits of using these queries to retrieve the information in a way that allows you to provide valuable information to your stakeholders?
i.
Using queries to retrieve information provides several benefits. First, it allows for efficient and targeted analysis by filtering the data based on specific criteria. This helps in identifying trends and patterns quickly. Second, queries enable the extraction of valuable insights from large datasets, providing stakeholders with actionable information. By using queries, stakeholders can easily access and understand relevant information without getting overwhelmed by the entire dataset. This approach ensures that non-technical stakeholders can make informed decisions based on the analysis presented to them.
4.
Explain how the functions in the analysis tool allowed you to organize the data and retrieve records quickly.
a.
The analysis tool provided functions that allowed me to organize and retrieve data quickly. Functions like filtering, sorting, and aggregating helped me organize the data based on specific criteria. For example, I could filter the dataset to only show repairs related to parts replacements. This enabled me to focus on the relevant records and extract the necessary information efficiently. Additionally, functions for calculating counts and totals helped in summarizing the data, providing a quick overview of the most common repairs or regions with the highest repair counts. Overall, these functions streamlined the analysis process and facilitated quick retrieval of records based on the desired criteria.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
Astronomy Question:
Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used
In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)
arrow_forward
LESSON: AUTODESK AUTOCAD
Choose from the choices:
arrow_forward
You are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:
arrow_forward
Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example
Thank you.
arrow_forward
Directions: modify the standard SolidWorks ANSI B Landscape layout for your own engineering
consulting company. Include a logo, change the legal notice, and make other changes as you see fit.
Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions.
Usual DRAWN BY.
Deliverable: screenshot of your personalized layout/template without any drawings on it.
arrow_forward
Hello. I just want to make sure the answers I chosen on the image attached are correct because I am unsure.
arrow_forward
I need answers to problems 7, 8, and 9.
NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.
arrow_forward
I need answers to questions 1, 2, and 3 pertaining to the print provided.
Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.
arrow_forward
I need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.
arrow_forward
Put together a short presentation (pitch) for a mechanical engineering student, emphasizing his period of the course (10th) and his most significant achievements such as his change from the naval to mechanical course, the learning of programming languages focused on data analysis (Python and SQL), since the engineering course does not explore these skills, and the improvement of Excel with the VBA language.
arrow_forward
This is Mechanical Engineering. Please answer with clear work and answers. Thank you
arrow_forward
You are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture
fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates
implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial
weight bearing activities.
Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to
verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into
solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending
test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the
yield stress for the Ti-6Al-4V…
arrow_forward
I need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.
arrow_forward
This is Mechanical Engineering. Please answer with clear work and answers. Thank you
arrow_forward
Please show work in a handwritten format.
Don't use chatgpt.
Mechanics of materials/design.
arrow_forward
I need answers for problems 13, 14, and 15 pertaining to the print provided.
NOTE: If you refuse to answers all 3 parts and insist on wasting my question by breaking down 1 simple question into 3 parts, then just leave it for someone else to answer. Thank you.
arrow_forward
I asked for problems 6 and 7 to be answered, but I did not get a properly structured answered as the example shows on problem number 1. Here is the link to the questions I already had answered, could you please rewrite the answer so its properly answered as the example shows (Problem 1)?
https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
arrow_forward
Help!!! Answer all parts correctly!! Please
arrow_forward
I need problems 6 and 7 solved.
I got it solved on 2 different occasions and it is not worded correctly.
NOTE: Problem 1 is an example of how it should be answered. Below are 2 seperate links to same question asked and once again it was not answered correctly. 1. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/cadc3f7b-2c2f-4471-842b-5a84bf505857
2. https://www.bartleby.com/questions-and-answers/it-vivch-print-reading-for-industry-228-class-date-name-review-activity-112-for-each-local-note-or-c/bd5390f0-3eb6-41ff-81e2-8675809dfab1
arrow_forward
Please answer the 4th question
arrow_forward
I need parts 3 and 4 answered pertaining to the print provided.
I asked this question previously on here and I received the wrong answers to the 2 parts Im asking about, so I am reposting the question again to have another tutor answer it.
Part 3: I need to tell what was ommited.
Part 4: I need to tell what the triangle equals? Lower right or J1 zone has the answer.
arrow_forward
I need parts 8, 9, and 10 answered. Number 1 is an example of how it should be answered.
NOTE: Read the instructions, no where does it say any drawing is required. It is really frustrating when I wait all this time for an answer to a question and some tutor does even read the instructions and just declines it...its ridicilous.
arrow_forward
This is the complete question and not a writing assignment. Make sure for this problem you list the following:
a. Known: State briefly what is known about the problem.
b. Schematic: Draw a schematic of the physical system or control volume.
c. Assumptions: List all necessary assumptions used to complete the problem.
d. Properties: Identify the source of property values not given to you in the problem.
e. Find: State what must be found.
f. Analysis: Start your analysis with any necessary equations. Develop your analysis as completely as possible before inserting values and performing the calculations. Draw a box around your answers and include units and follow an appropriate number of significant figures.
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9780190698614/9780190698614_smallCoverImage.gif)
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134319650/9780134319650_smallCoverImage.gif)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259822674/9781259822674_smallCoverImage.gif)
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118170519/9781118170519_smallCoverImage.gif)
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093347/9781337093347_smallCoverImage.gif)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118807330/9781118807330_smallCoverImage.gif)
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY
Related Questions
- Astronomy Question: Read the questions slowly and answer with precise and long details about each of the questions. Answer correctly and follow my guidelines for a long and wonderful review after results. Your target/main observable galaxy is the whirlpool galaxy. Target: Whirlpool Galaxy Object Type: Galaxy Distance: 37 million light-years Constellation: Canes Venatici. DO NOT COPY AND PASTE OTHER WORK OR THINGS FROM THE INTERNET, use your own words.Provide refernces if used In 500 words, please explain the relevance of this object to the physics course material in university andits importance to astronomy. (Some question you may seek to answer are: What beyond the objectitself is learned by studying this class of objects? What sorts of telescopes and observations would beneeded for more detailed, broader reaching studies of this source and objects of its nature?)arrow_forwardLESSON: AUTODESK AUTOCAD Choose from the choices:arrow_forwardYou are assigned as the head of the engineering team to work on selecting the right-sized blower that will go on your new line of hybrid vehicles.The fan circulates the warm air on the inside of the windshield to stop condensation of water vapor and allow for maximum visibility during wintertime (see images). You have been provided with some info. and are asked to pick from the bottom table, the right model number(s) that will satisfy the requirement. Your car is equipped with a fan blower setting that allow you to choose between speeds 0, 1,2 and 3. Variation of the convection heat transfer coefficient is dependent upon multiple factors, including the size and the blower configuration.You can only use the following parameters:arrow_forward
- Please make the charts for the questions. Please refer to Successful Project Management (7th Edition). Attached is the example Thank you.arrow_forwardDirections: modify the standard SolidWorks ANSI B Landscape layout for your own engineering consulting company. Include a logo, change the legal notice, and make other changes as you see fit. Be creative! Save this as a SolidWorks drawing layout template and use in subsequent submissions. Usual DRAWN BY. Deliverable: screenshot of your personalized layout/template without any drawings on it.arrow_forwardHello. I just want to make sure the answers I chosen on the image attached are correct because I am unsure.arrow_forward
- I need answers to problems 7, 8, and 9. NOTE: Please stop wasting my time and yours by rejecting my question because it DOES NOT REQUIRE YOU TO DRAW anything at all. They are simple questions pertaining to the print provided. READ THE INSTRUCTIONS of the assignment before you just reject it for a FALSE reason or leave it for someone to answer that actually wants to do their job. Thanks.arrow_forwardI need answers to questions 1, 2, and 3 pertaining to the print provided. Note: A tutor keeps putting 1 question into 3 parts and wasted so many of my questions. Never had a issue before until now, please allow a different tutor to answer because I was told I am allowed 3 of these questions.arrow_forwardI need help solving these 3 simple parts, if you can not answer all 3 parts then please leave it for another tutor, thank you.arrow_forward
- Put together a short presentation (pitch) for a mechanical engineering student, emphasizing his period of the course (10th) and his most significant achievements such as his change from the naval to mechanical course, the learning of programming languages focused on data analysis (Python and SQL), since the engineering course does not explore these skills, and the improvement of Excel with the VBA language.arrow_forwardThis is Mechanical Engineering. Please answer with clear work and answers. Thank youarrow_forwardYou are a biomedical engineer working for a small orthopaedic firm that fabricates rectangular shaped fracture fixation plates from titanium alloy (model = "Ti Fix-It") materials. A recent clinical report documents some problems with the plates implanted into fractured limbs. Specifically, some plates have become permanently bent while patients are in rehab and doing partial weight bearing activities. Your boss asks you to review the technical report that was generated by the previous test engineer (whose job you now have!) and used to verify the design. The brief report states the following... "Ti Fix-It plates were manufactured from Ti-6Al-4V (grade 5) and machined into solid 150 mm long beams with a 4 mm thick and 15 mm wide cross section. Each Ti Fix-It plate was loaded in equilibrium in a 4-point bending test (set-up configuration is provided in drawing below), with an applied load of 1000N. The maximum stress in this set-up was less than the yield stress for the Ti-6Al-4V…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Elements Of ElectromagneticsMechanical EngineeringISBN:9780190698614Author:Sadiku, Matthew N. O.Publisher:Oxford University PressMechanics of Materials (10th Edition)Mechanical EngineeringISBN:9780134319650Author:Russell C. HibbelerPublisher:PEARSONThermodynamics: An Engineering ApproachMechanical EngineeringISBN:9781259822674Author:Yunus A. Cengel Dr., Michael A. BolesPublisher:McGraw-Hill Education
- Control Systems EngineeringMechanical EngineeringISBN:9781118170519Author:Norman S. NisePublisher:WILEYMechanics of Materials (MindTap Course List)Mechanical EngineeringISBN:9781337093347Author:Barry J. Goodno, James M. GerePublisher:Cengage LearningEngineering Mechanics: StaticsMechanical EngineeringISBN:9781118807330Author:James L. Meriam, L. G. Kraige, J. N. BoltonPublisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9780190698614/9780190698614_smallCoverImage.gif)
Elements Of Electromagnetics
Mechanical Engineering
ISBN:9780190698614
Author:Sadiku, Matthew N. O.
Publisher:Oxford University Press
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134319650/9780134319650_smallCoverImage.gif)
Mechanics of Materials (10th Edition)
Mechanical Engineering
ISBN:9780134319650
Author:Russell C. Hibbeler
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259822674/9781259822674_smallCoverImage.gif)
Thermodynamics: An Engineering Approach
Mechanical Engineering
ISBN:9781259822674
Author:Yunus A. Cengel Dr., Michael A. Boles
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118170519/9781118170519_smallCoverImage.gif)
Control Systems Engineering
Mechanical Engineering
ISBN:9781118170519
Author:Norman S. Nise
Publisher:WILEY
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337093347/9781337093347_smallCoverImage.gif)
Mechanics of Materials (MindTap Course List)
Mechanical Engineering
ISBN:9781337093347
Author:Barry J. Goodno, James M. Gere
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781118807330/9781118807330_smallCoverImage.gif)
Engineering Mechanics: Statics
Mechanical Engineering
ISBN:9781118807330
Author:James L. Meriam, L. G. Kraige, J. N. Bolton
Publisher:WILEY