|
"The man who knows it all has lots to learn" -
Unknown
Objective
The purpose of this assignment is threefold. First, you will get to practice
your skills in developing simple engineering spreadsheets. Second, you will be
introduced to Excel's graphing and charting capabilities. And finally, you get
an opportunity to compute your current grade in the class. Submit your Parts 1-3
Excel file to the Assignment link in Canvas. For Part 4, you may develop a
spreadsheet (the preferred method) or compute your current grade by hand on
engineering paper and then upload the file to Dropbox.
You must hand in a copy of the
cover sheet
for the assignment and printouts of your Excel spreadsheet for Parts 1-3,
and your calulations for your current class grade (may also be in a
spreadsheet format). Also, you must submit your
Excel spreadsheet for Parts 1-3.
Part 1: This part of the assignment has two basic steps.
Step 1 involves accessing information from the Internet, and Step 2 deals with
spreadsheet graphs. The sample output shows the basic spreadsheet layout you
should achieve. Use the data you find on the web.
- This assignment's data can be found on the
following web pages:
Top 300 Female First Names or the
Top
300 Male First Names. Please write down the top ten first names and
their percentages. You may want to browse the
list for your name and add it to the top ten.
- 2. Create a spreadsheet table showing the ten (or eleven) first names and
their percentages. The column of names should be left justified, and the
column of numeric data (i.e., percentages) and its heading should be center
justified. The numbers should appear with a percentage sign and precisely
three digits after the decimal point. Use the data in your table to construct
a bar chart. The chart should have titles (e.g., Most Common Female Names).
The bars should be labeled with the first names. The vertical axis should show
the percentages (any number of digits after the decimal point). Note the
following sample output.
Part 2: The life expectancy in the United States is relatively high (78 years for
males and 82.5 for females). The life expectancy is significantly different in
other countries. There are three basic steps to Part Two. Step 1 involves
accessing information from the internet, Step 2 deals with spreadsheet graphs,
and Step 3 involves using the built-in functions of your spreadsheet program.
The sample output shows the basic spreadsheet layout you should achieve. Do
not use the data in the sample output; use the data you find online.
- The Central Intelligence Agency provides an excellent unclassified
overview of countries
around the world. Examine their information about Brazil,
Nigeria,
Norway,
Japan, and one more country of your choice. Write down the male and female life expectancies for
these five countries. Since the individual country data files are fairly large, you may not want to print
them. Scroll down to the Life Expectancy at Birth section. You can use your web browser's slider bar or the PgUp and PgDn keys to
move up and down in a file. You can also use the browser's Edit/Find feature to search for
"expectancy."
- Create a spreadsheet table with the life expectancies for the five
countries. The column of country names should be left justified, and the two
columns of numeric data and their headings should be center justified.
- Construct a paired bar chart showing the male and female life expectancies.
The chart should have a title (e.g., Life Expectancy). The horizontal axis
must be labeled with the country names (or abbreviations). A legend indicating
gender must also be included. The vertical axis should show the years. As
before, use the data found on the web, not the sample data shown below.
Part 3: Develop a graph of the relationship between
compressive failure stress and w/c. Use the data below from the CIVL 1101 lab (mix 1-2-2).
Part 4: Compute your current grade in the
class using the information in the
class syllabus.
Part 5: Read Chapter 7 in the
Strategies for Creative Problem Solving by Fogler and LeBlanc
|