All our Essay orders are Original, and are written from scratch. Try us today at 30% off

CE 112 Mt. Hood Community College Engineering Worksheet

Want answers to the assignment Below?

Text or Whatsapp Olivia at +1 (307) 209-4351


 

CE 112 Homework 1 (due Jan. 22 @ 11:59 PM to Canvas Dropbox) Winter 2022 Instructions ● ● ● ● The due date for this assignment is Saturday, January 22 11:59 PM PST. Submit your Excel worksheet with clearly named tabs and formatting applied for all problems. For problems 1 and 2, you may find the FE Reference Handbook helpful. For your own free PDF copy, see: https://ncees.org/ncees-publishes-new-version-of-fe-reference-handbook/ Not that to complete this assignment it is expected that you use Excel 2019. Older versions of Excel or Excel for Mac may lack some of the functionality required to complete the assignment. Problem 1 (10 points, 2 points per answer) Create an Excel workbook. Label a worksheet “Problem 1”. Insert a scan of your handwritten calculations or typeset them in Excel. Do not use the built-in Excel conversion function for this problem. Convert the values below to the units indicated by using the unit fractions / unit calculation method. Remember to report the correct number of significant figures. a. b. c. d. e. 900 N to lbf 110 kPa to psi 9.81 m/s2 to ft/s2 1500 kg/m3 to lbm/ft3 450 Watts/m2 to BTU/ft2/day Note: lbm = pound mass; lbf = pound force. An example of the unit fractions/unit cancellation method see: Introduction to Unit Conversion Problem 2 (5 points, 0.5 point per answer) In the same Excel workbook, create a new worksheet and label it “Problem 2”. Convert the quantities below to the units shown. First attempt to use the CONVERT function. If CONVERT does not work, identify either a different function or series of formulas that may be used to accomplish the conversion. Within the Excel spreadsheet, organize your calculations in a Given/Find/Solution format. Present your final conversion in a table format. Use Excel formatting tools to create a document that is easy to review. a. b. c. d. e. f. g. h. i. j. CE 112 2 cm to m 40 m3 to ft3 3800 N to lbf 400 kPa to psi 50 m/s to mph 2 acre to ft2 3.74 rad to decimal degrees 9.81 m/s2 to ft/s2 2000 kg/m3 to lbm/ft3 102 kip to lbf 1 of 3 CE 112 Homework 1 (due Jan. 22 @ 11:59 PM to Canvas Dropbox) Winter 2022 Problem 3 (5 points, 1 point per answer) In the same Excel workbook, create a new worksheet and label it “Problem 3”. Create a spreadsheet that calculates the volume (in m3) of a rectangular prism based on its height, width, and length for the 5 prisms described in the table below. Organize your calculations in a Given/Find/Solution format. Present your final answers in a table format and be sure to format the results in appropriate significant figures. Height Width Length mm mm mm A 750 115 1250 B 500 500 500 C 125 200 2000 D 1000 550 25.0 E 200 50 200 Prism Problem 4 (10 points) In the same Excel workbook, create a new worksheet and label it “Problem 4”. Create a spreadsheet that calculates the estimated total cost to complete sidewalk repairs. The existing sidewalk is removed and a new sidewalk is installed as summarized in the table below: Sidewalk Section Length (ft) A B C D E 50 25 100 110 30 The following are variable inputs: ● ● ● ● ● Removal of existing sidewalk, $4 per square foot. Labor to install new concrete, $5 per square foot. Material cost of concrete, $300 per cubic yard. Depth of new concrete for the sidewalk, 4 inches. Width of sidewalk, 5 feet. Note that concrete can only be purchased in full cubic yards (e.g., 2 cubic yards). Setup your spreadsheet so that you can change the variables and the total cost estimate will change. Format your spreadsheet so that the variable cell inputs are clear to a user (i.e., color or shade them) and be sure to label the units of all inputs and outputs. CE 112 2 of 3 CE 112 Homework 1 (due Jan. 22 @ 11:59 PM to Canvas Dropbox) Winter 2022 Problem 5 (10 points + 2 bonus points) In the same Excel workbook, create a new worksheet and label it “Problem 5”. Download the spreadsheet “highway_data (217NB 4-2019).xlsx”. Copy and paste these data into your worksheet “Problem 5”. Insert a few rows at the top of the worksheet to present your final answers to questions 1-4 in a table formatted to appropriate significant digits. Analysis to complete: 1. Find and use the Excel functions that will allow you to complete the values in the columns labeled “hour” and “dayofweek” in the table by extracting this information from the “starttime” column. 2. Apply conditional formatting to the day of the week column so you can see weekdays and weekends clearly. 3. Explore options for conditional formatting of the speed_mph column lets you see when the lowest speeds are occurring (days and times). Questions to answer: 1. Generally, what is your observation about when lowest speeds are occurring? 2. What is the average speed at this location? 3. How many observations are blank for the speed_mph, volume, and occupancy columns? 4. BONUS 2 pts – The data rows are in 15-minute intervals. Information is recorded every 20 seconds so the “countreadings” c
The post CE 112 Mt. Hood Community College Engineering Worksheet first appeared on Assignment writing service.

Testimonials

Best

They look cool and trustworthy enough to me. I gather they made discounts as their prices are quite affordable if...

Mh! not bad…

The worst part ever was to find my deadline postponed for 1 hour ! They couldn`t finish the essay within...

Best Service

The book review I asked for is so amazing! Endless thanks to your team for completing my review and for...

No Complaints So far Guys

Yeah …I really like all the discounts that they offer, the prices are very flexible. Plus they have different promotions...

Great Job

Great job! Those were you, guys, who made my coursework perfect in time according to all my requirements. I will...

Comes through every time

I have used this website for many times, and each time they found perfect writers for me and they produce...

CLICK HERE  To order your paper

About Scholarfront Essay writing service

We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.

How It Works

To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Are there Discounts?

All new clients are eligible for upto 20% off in their first Order. Our payment method is safe and secure.

 CLICK HERE to Order Your Assignment

 

ORDER WITH 15% DISCOUNT

Let your paper be done by an expert

Custom Essay Writing Service

Our custom essay writing service has already gained a positive reputation in this business field. Understandably so, all custom papers produced by our academic writers are individually crafted from scratch and written according to all your instructions and requirements. We offer Havard, APA, MLA, or Chicago style papers in more than 70 disciplines. With our writing service, you can get quality custom essays, as well as a dissertation, a research paper, or term papers for an affordable price. Any paper will be written on time for a cheap price.

Professional Essay writing service

When professional help in completing any kind of homework is all you need, scholarfront.com is the right place to get it. We guarantee you help in all kinds of academia, including essay, coursework, research, or term paper help etc., it is no problem for us. With our cheap essay writing service, you can be sure to get credible academic aid for a reasonable price, as the name of our website suggests. For years, we have been providing online custom writing assistance to students from countries all over the world, including the United States, Canada, the United Kingdom, Australia, Italy, New Zealand, China, and Japan.