Topic 6 DQ 1 & 2

Hello
I load the guideline paper, please read and answer DQ 1 and DQ 2 This course is about Mathematics Modeling.

Excel Reflection

6. Write a typed, double-spaced reflection paper (minimum one page). Remember that we are looking for
responses that are backed by values that support your statements. The explanations should be clear to a broad
audience. Do NOT use cell references in your paper. The paper must include the following information:
 Your name, course name and project name.
 An introductory paragraph explaining the purpose of this project.
 For the first paragraph of the main body, write an explanation of how the final grade is calculated and
how Excel is used in this process. Analyze and reflect on the results for the student data provided. What
is the final course score you determined based on the initial data provided? What letter grade is this?
 For the second paragraph of the main body, reflect on the second scenario of the spreadsheet.
Could the student receive the next higher letter grade by improving any individual score from any
category? If it is possible, what was the minimum new score that would achieve an increase of a letter
grade for her course grade? If that is not possible, explain why.
 For the third paragraph of the main body, reflect on the third and fourth scenarios. What
happened to the student’s final course scores? If the student did not turn in the last two homework
assignments and the last project? If the student received perfect scores on all of the quizzes?
 For the fourth paragraph of the main body, reflect on the last scenario. How would the student’s
grade be impacted by weighing tests more heavily? Quantify your answer. Would this be a
good change to make?
 For the conclusion, reflect on the results of your project. What have you learned from doing this
project? How will Excel help to determine YOUR grade? How could you use Excel in the future?
Math 123 Quantitative Reasoning Project 1 Fall, 2022
Before you turn in your project, your project should check to make sure that you:
 Contain a paper that is well organized and in paragraph form (not just bulleted answers!), with an introduction,
main body, and conclusion.
 Contain a paper that is clear to someone who is not familiar with the project. Do not assume that you are writing
this to your instructor, make sure everyone can understand your statements.
 Give specific values; quantify statements.
 Provide support for your statements; explain how values were found and justify statements.
 Provide a workbook with at least five spreadsheets using the original grade values given below.
 Use appropriate representations (tables, color, formatting) that will help the reader understand the project.
 Project should make use of Excel functions.
 Project should be your original work. Copying someone else’s work is cheating. Sharing your work with
someone else is cheating.
These instructions cover the MINIMUM expectations of this project. Students are encouraged to be creative.
When you are done check for the final list, submit both an Excel and Word file
in the Project 1 assignment.

Scenario 2: b.

Scenario 1: A. Saving money at the grocery store by using unit pricing.
a. Toilet paper A is 6 mega rolls for $4.59.
b. Toilet paper B is 12 mega rolls for $9.02.
Scenario 2: B. Choosing a gym membership that fits my budget and lifestyle.
a. Gym A has a monthly payment of $50.
b. Gym B has a cost of $10 per visit.

What is being done to help protect machu picchu?

MAT 143 Project: Conquering Quantity – Raiders of Machu Picchu
Machu Picchu is a fifteenth-century Incan ruin located in the Andes near the Peruvian city of Cuzco. As one of the few well-preserved pre-Columbian ruins, Machu Picchu was named a UNESCO World Heritage Site in 1983. Today, Machu Picchu is one of the most visited tourist destinations in Peru; but it has only been widely known for about one-hundred years. Hiram Bingham, one of the earliest visitors to the site, is often credited as the scientific discoverer of the Machu Picchu. He returned to Yale University from several archaeological visits to the site with bones and other artifacts over which there is still on ongoing dispute between the Peruvian government and the university. Bingham is often cited as the inspiration for Indiana Jones, and like the fictional scientist, Bingham may be seen as more of a tomb raider than an archaeologist.
In this project, you will plan a vacation to Cuzco, Peru to hike the Inca Trail and visit Machu Picchu. You will do basic unit conversions using dimensional analysis, use estimation to allot your budget, and learn about Peru. Toward the end of the process, you will also consider what it means to be a responsible visitor rather than a raider of Machu Picchu. Grab your trusty fedora and army surplus bag and hit the road.
YOUR ITINERARY
Day One: Fly to Cuzco, Peru.
Day Two: Enjoy Cuzco. Plan an activity in the city such as visiting a museum, shopping, or visiting a nearby archeological site.
Days Three through Six: Hike the Inca Trail and visit Machu Picchu.
Day Seven: Fly home.
To celebrate your college graduation, you plan to save $3000 to take a special vacation to Peru. In this part of the project, you will need to do some research to allocate funds for the different aspects of your trip. You will need to use a website such as Travelocity.com or expedia.com to estimate how much airfare will cost. You may use Travelocity, Expedia, or a travel guide from the library to estimate costs of staying in hotels or hostels, day trips around Cuzco, and the cost of hiking the Inca Trail. Travel guides can also help you decide how much you need to set aside for food and souvenirs. You might also take a look at the Explore By Yourself website: https://www.explorebyyourself.com/en/peru/ Once you have completed your research, fill in the Vacation Table and use it to total your costs. Remember, you only have an allowance of $3000, so plan wisely.
Air fare
Hotel
Tour Fees
Total
2. You will need to convert US dollars into Peruvian currency for use during your trip. You can use the site http://www.xe.com to answer questions (a) and (b).
(a) What is the currency used in Peru?
(b) What is the exchange rate between Peruvian currency and US dollars?
(c) Use dimensional analysis and your answer to part (b) to convert your US cash allowance into Peruvian currency.
3. Write your answers to the following questions in complete sentences. You will find www.timeanddate.com/worldclock/difference.html helpful.
(a) In which time zone is Cuzco, Peru located?
(b) Does Peru observe Daylight Savings Time?
(c) You are traveling in May. By how many hours does the time in Cuzco differ from North Carolina?
4. How long is the Inca Trail in kilometers? Given that 1 mile = 1.61 kilometers, how long is the Inca Trail in miles? Use dimensional analysis and show your work.
5. The first day of the hike, you cover 12 kilometers in 6 hours. What was your average walking speed in miles per hour? Use dimensional analysis and show your work.
6. Using the average walking speed and the length of the Inca Trail calculated in the previous problems, how long should it take you to walk to Machu Picchu? Use dimensional analysis and show your work.
7. What is the highest peak in North Carolina? How tall is it in feet? Write your answer in a complete sentence.
8. How tall, in meters, is the highest peak on the Inca Trail? Write your answer in a complete sentence.
9. Given 1 foot = 0.30 meters, use dimensional analysis to convert the height of the tallest peak on the Inca Trail to feet. Show your work.
10. Suppose you are taking your vacation in May. What is the average daytime temperature in degrees Celsius on the Inca Trail during that month?
11. Peru measures temperatures in the Celsius scale, while the United States records temperatures in degrees Fahrenheit. Convert the average temperature on the Inca Trail into degrees Fahrenheit given that F= 9/5 C+32.
12. How does the temperature in North Carolina compare with the temperature in Cuzco, Peru during May?
13. During your journey, you develop an abscessed tooth and have to visit the dentist. You are prescribed an antibiotic with a dosage of 7.5 mg/kg every six hours. If you weigh 120 pounds and the antibiotic comes in 250 mg tablets, how many tablets should you take each day? Use dimensional analysis and show your work.
14. If you need to take the pills for five days, how many tablets should the pharmacist give you when she fills your prescription?
Many places like Machu Picchu where no-one lives have large numbers of visitors. Those people affect the place they are visiting, and the more of them there are, the greater the effects of their presence will be. In the next several questions, we’ll examine just how many people visit Machu Picchu each day, consider their effect on the site, and contemplate how to be responsible visitors rather than raiders.
15. Machu Picchu currently has about 18000 visitors daily. The area of Machu Picchu is about 13 km2. Calculate the daily visitor density, or how crowded Machu Picchu is, in daily visitors per square mile. Use dimensional analysis and show your work.
16. Carrboro is the most densely populated town in North Carolina. Go to ZipAtlas http://zipatlas.com/us/nc/city-comparison/population-density.htm and look up the population density of Carrboro in people per square mile. How does this compare with the daily visitor density you calculated for Machu Picchu? Write your answer in complete sentences.
17. The many visitors to Machu Picchu are affecting the environment and people who live near the site. What is being done to help protect Machu Picchu? What is being done to help the people who live in the nearby towns? How can you be a responsible traveler during your visit? Read the following articles and write a paragraph to answer these questions.
Can We Protect Machu Picchu? (n.d.). Retrieved March 27, 2015, from http://www.ethicaltraveler.org/2011/10/can-we-protect-machu-picchu/
Saving Machu Picchu (n.d.). Retrieved June 28, 2020 from https://www.smithsonianmag.com/travel/saving-machu-picchu-153497816

When you have answered all parts of the assignment, save the template with your completed responses as a word document titled: your name_ mat110_week_7_assignment and submit it in blackboard in week 7.

Every day we are in situations where we need to apply math skills to solve problems. Being proficient with arithmetic and algebra can help you make decisions that could help you save money, maximize your time, and live a more productive life. For this assignment, we will assess your ability to use basic arithmetic and algebra to solve real-world quantitative problems.
Instructions
Use of the provided assignment template is required.
Week 7 Assignment Template [DOCX]
Note: This assignment does not require research, but if you choose to use information from a source, be sure to cite it. To help make sure you are properly citing your sources, please review the Strayer Writing Standards . When you have answered all parts of the assignment, save the template with your completed responses as a Word document titled: Your Name_ MAT110_Week_7_Assignment and submit it in Blackboard in Week 7.
Course Outcome
Use basic arithmetic and algebra to solve real-world quantitative problems
Interactive Assignment Walkthrough
If you’d like to work on your assignment while watching the video, click on the interactive video below. As you watch the video, you’ll be able to answer the questions along the way. After you have answered each of the questions and reach the end of the video, you will then download a Word document with your answers. Then you will submit your completed document to Blackboard for grading.