This is an excel problem. Only the items highlighted in red is needed, so a flow
ID: 3599829 • Letter: T
Question
This is an excel problem. Only the items highlighted in red is needed, so a flowchart, excel results, another flowchart and another excel results. I. Background Getting a computer to do a complex calculation or to make a decision based on data is great, but doesn't go much beyond what a person is capable of doing. The computer might be able to do it faster than a person, but the gain in speed is not significant. The real power of the computer is its ability to perform a repetitive task with great speed and accuracy. Once we understand how to harness this ability, the computer moves beyond a simple calculator to an incredibly versatile tool. In this lab, you will be creating iterative solutions to three different problems. For each problem, you will need to create a flowchart do depict how you would solve it using repetition and simulate several rounds of iteration using Excel. II. Application 1: Processing Data A second application for repetition is the processing of large amounts of data. With the vast number of sensors used in current systems (your phone likely has at least 5-front camera, back camera, microphone, accelerometer, GPS), the amount of data generated is astronomical. It would be impossible person to sift through all of that data to make any meaningful conclusions. However, a computer can very quickly and easily process vast amounts of data and calculate different statistical values to help someone interpret the data. In this problem, you will simulate processing a set of yearly temperature data to determine whether the Earth is indeed warming. for a Inputs Set of temperature data Outputs: Number of years the average temperature increased Number of years the average temperature decreased Number of years the average temperature remained steady Maximum average temperature Minimum average temperature Processing Repeatedly process each temperature data point and determine whether the temperature increased or decreased and whether the temperature is currently the maximum temperature or the minimum temperature o The current temperature is potentially the maximumExplanation / Answer
Option 1 - Embed the Flowchart
When you embed an Excel file in Word or PowerPoint it appears as a resizable image, but you can double-click to edit it. To embed the flowchart, follow these steps:
Save and close the Excel file containing the flowchart. The sheet containing the flowchart needs to be the active sheet, and the flowchart should be scrolled into view.
In Word or PowerPoint:
Select the location for the flowchart to be placed.
On the Insert tab, click Object. (Use the Insert menu in Word 2003 and older versions.)
Select "Create from file" and use browse button to locate the Excel file.
When you click OK, the Excel file will be embedded in the document.
Click and drag the edge of the embedded object frame to resize as needed.
Should You "Link to File"?
Recommended answer: No.
If you link to file:
You cannot scroll or resize the visible worksheet range. This is a significant problem if you need to adjust the viewable portion of the embedded flowchart.
Despite the linking implication, changes to the original Excel file are not automatically updated in the Word document. You must right-click on the embedded object and select Update Link from the pop-up menu to force a refresh.
Adjusting the View
In the flowchart view needs to be adjusted:
Double-click the embedded Excel file to activate it.
Scroll the flowchart into view as desired.
While still active, click and drag the edge border to resize the visible worksheet range.
Editing Embedded Flowcharts
If you double-click the embedded object, you have full access to all of Excel's tools - including the FlowBreeze features.
Option 2 - Copy and Paste into an Office Document
Click Select Shapes > Select All from the FlowBreeze toolbar.
Use the normal Copy function. (In Excel 2010 and later, do not use the Copy Picture tool. It will not give us the Paste Special option we need in the next step.)
In the target file, click Paste Special and select the "Picture (Enhanced Metafile)" option. Metafiles are a special type of image that render the text clearly when resized.
Option 3 - Export Flowchart as Image
The last option is to use the Export as Picture tool, and then to insert the image file into the target document. But if you need to resize the image in the target document, Option 2 provides a better image format for rendering legible text.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.