Assignment # 1 Introduction to Excel Modeling Expectations: 1. Complete reading the Excel handout material (Introduction to Excel Part-I), then make a list of the tools in Excel you found to be useful (at least ten tools). 2. Submit a technical report to describe the overall modeling solution process to solve the attached External Problem. 3. Remember to use the Presentation Sandwich (Introduction, main body, discussion, ..) and to follow the necessary format for all modeling assignments (see the First day materials and the Presentation of Technical Work Expectations). The main body "model" should at least includes: • Problem definition (this include the given information and data as well as the requirements and objective of the problem), • Assumptions • Heuristics • Modeling steps and description (equations, algorithms, sketches, etc), • Model implementation and results (calculations, excel sheet, numbers, graphs, resulted relations. etc), • Result discussion and evaluation (interpretations, justifications, comparisons, validation, calibration. etc). 4. Attach checklist to the front of the report. Go through all requirements mentioned in the checklist to make sure that you have completed the assignment properly. Write down any exciting features you may have completed on your own in the relevant item of the checklist.

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question
External Problem
Figure 1 shows, three types of swimming pool, they have a rectangular, circular, and elliptic cross
sectional area. The depth of swimming pools is h₁ ..
b
a
☺
D
m
Calculate the followings:-
i) The volume and capacity of rectangular swimming pool ( a= 7.5 m, b= 15 m ) at different
heights
vi) The pressure of water on the wall of swimming pools for different heights.
h₁= 1m+increment <=3.5 m
assume increment=10 cm.
n
ii) The volume and capacity of circular swimming pool (D=10 m) at different heights
iii) The volume and capacity of elliptic swimming pool (m=15m, n= 10 m) at different
heights
v) Show answers of (i) (ii) and (iii) in one graph.
vi) Show answers (iii) and (vi) in one graph.
vii) Discuss each graph, in (v) and (iv), and give clear conclusions.
Transcribed Image Text:External Problem Figure 1 shows, three types of swimming pool, they have a rectangular, circular, and elliptic cross sectional area. The depth of swimming pools is h₁ .. b a ☺ D m Calculate the followings:- i) The volume and capacity of rectangular swimming pool ( a= 7.5 m, b= 15 m ) at different heights vi) The pressure of water on the wall of swimming pools for different heights. h₁= 1m+increment <=3.5 m assume increment=10 cm. n ii) The volume and capacity of circular swimming pool (D=10 m) at different heights iii) The volume and capacity of elliptic swimming pool (m=15m, n= 10 m) at different heights v) Show answers of (i) (ii) and (iii) in one graph. vi) Show answers (iii) and (vi) in one graph. vii) Discuss each graph, in (v) and (iv), and give clear conclusions.
Assignment # 1
Introduction to Excel Modeling
Expectations:
1. Complete reading the Excel handout material (Introduction to Excel Part-I), then make a list of the
tools in Excel you found to be useful (at least ten tools).
2. Submit a technical report to describe the overall modeling solution process to solve the attached
External Problem.
3. Remember to use the Presentation Sandwich (Introduction, main body, discussion, ..) and to
follow the necessary format for all modeling assignments (see the First day materials and the
Presentation of Technical Work Expectations). The main body "model" should at least includes:
• Problem definition (this include the given information and data as well as the requirements
and objective of the problem),
• Assumptions
• Heuristics
• Modeling steps and description (equations, algorithms, sketches, etc),
• Model implementation and results (calculations, excel sheet, numbers, graphs, resulted
relations. etc),
• Result discussion and evaluation (interpretations, justifications, comparisons, validation,
calibration. etc).
4. Attach checklist to the front of the report. Go through all requirements mentioned in the
checklist to make sure that you have completed the assignment properly. Write down any exciting
features you may have completed on your own in the relevant item of the checklist.
Transcribed Image Text:Assignment # 1 Introduction to Excel Modeling Expectations: 1. Complete reading the Excel handout material (Introduction to Excel Part-I), then make a list of the tools in Excel you found to be useful (at least ten tools). 2. Submit a technical report to describe the overall modeling solution process to solve the attached External Problem. 3. Remember to use the Presentation Sandwich (Introduction, main body, discussion, ..) and to follow the necessary format for all modeling assignments (see the First day materials and the Presentation of Technical Work Expectations). The main body "model" should at least includes: • Problem definition (this include the given information and data as well as the requirements and objective of the problem), • Assumptions • Heuristics • Modeling steps and description (equations, algorithms, sketches, etc), • Model implementation and results (calculations, excel sheet, numbers, graphs, resulted relations. etc), • Result discussion and evaluation (interpretations, justifications, comparisons, validation, calibration. etc). 4. Attach checklist to the front of the report. Go through all requirements mentioned in the checklist to make sure that you have completed the assignment properly. Write down any exciting features you may have completed on your own in the relevant item of the checklist.
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY