Major Assignment 3 Excel Grading Sheet“Rubric Category(% weighting for assignment)” Requirements for full credit (optional for student use) Did you meet the requirements? Possible Points Your Points % Score for Rubric Category“Project Budget(15%)” You have entered your full name in the field provided. (Note that entering your name on this sheet is required in order to complete the assignment.) 2You have listed at least 8 budget items total with at least 1 item in each category. 8You have entered the number of times purchased and purchase amount for each item, and at least 3 items are purchased more than once. 8Your Total Cost for each item is a formula multiplying the number of times purchased by the purchase amount, using appropriate cell references. 8Your Subtotal formulas are correct for each of your 4 sections. 8You have explicitly formatted your Cost Per Purchase, Total Cost, and Subtotal cells to display as Currency with the $ sign and 2 decimal places of precision. (1/2 point each) 6Subtotals 40 0 0.00%“Budget Summary and Analysis(11%)” You have transferred your Subtotals from the Budget to the Summary and Analysis section, using formulas with cell references. 8Your Budget Total is correctly calculated from your Subtotals as a formula using cell references. 2Your Percentages are formulas that correctly calculate your Budget Total from your Subtotals, using cell references. 8All cells are formatted as Currency showing the $ symbol and with 2 decimal places of precision. 9Subtotals 27 0 0.00%“CPI Values, Slope, Y-Intercept, and Cost Projection(16%)” Your month and year entries are correct following the first (generated) values. 8Your CPI values are correct for the months and years given. 5Your slope and y-intercept formulas are correct and use the appropriate Excel functions. 4The year number to use for your CPI projection is correct, and you have brought your 5-year budget forward using an Excel formula with appropriate cell reference. 4Your formulas to calculate the projected CPI value, 5-year inflation rate, and 5-year budget projection are correct. 6Your formatting is correct for all cells: your CPI values are formatted as number with 3 decimals of precision; your 5-year inflation rate is formatted as a percentage with 2 decimal places; and your 5-year budget and budget projection are formatted as currency with the $ symbol and 2 decimal places. 12Subtotals 39 0 0.00%“Funding – Inputs(5%)” Your interest rates correctly match the corresonding entries from the table for the years and months given. 6Your 5-year projected budget total is brought forward from the Project Budget and Projection sheet, using an Excel formula. 2Your interest rates are formatted as percentages with 2 decimals and your budget total is formatted as currency using the $ symbol and 2 decimal places. 4Subtotals 12 0 0.00%“Sponsorship, Fundraising, and Loan Payment Calculations(12%)” For your Sponsorship calculation, your number of compoundings and time inputs are correct, and your principal amount and 5-year sponsorship amount are correct Excel formulas using appropriate cell references. 7For your Fundraising calculation, your number of compoundings and time inputs are correct, and your 5-year fundraising total calculation is a correct Excel formula using appropriate cell references. 5For your Loan calculation, your number of payments and time inputs are correct, and your additional amount and monthly payment calculations are correct Excel formulas using appropriate cell references. 7All cells with dollar amounts are explicitly formatted as Currency using the $ symbol and with 2 decimal places. 11Subtotals 30 0 0.00%
Your Title Here (should capture the essence of your project)
Your name
MAT-144
The date you most recently edited your write-up
[A note about grading for this write-up: Although you may cross-reference points between sections, the questions from each section must be answered in that section to get credit for your response. The amount of credit you receive will depend on how thoroughly you have considered your implementation: you should attempt to write so that a reasonable reader would need to ask few or no follow-up questions to clarify your overall objective, people you will help, assistance provided, project management, timeline, assessment procedures, ethics and CWV analysis, and reflections. Write-ups that leave many questions unanswered or with significant gaps will earn less credit.]
Whom will you help? (You must change this section title to summarize its contents)
In this section, you must address the following questions:
What characterizes the group? What is their economic status? What mix of ages and genders are they? Etc.
Where do the people live? At a specific location or in various locations? In what part(s) of town?
How will you decide what kind of assistance and how much assistance to provide to whom? For example, does the assistance provided change based on age, gender, family grouping, etc.?
How will you approach people to offer help?
How will you keep track of whom you are helping?
What assistance will you provide? (You must change this section title to summarize its contents)
In this section, you must address the following questions:
What specific assistance will you bring to the people who need it (goods, services, training, cash assistance, etc.)? (Here, a response like “cash payments of $50 per person per week” is better than “cash payments”)
How and where will you provide the assistance? Will you maintain a location for people to come to? Will you visit people where they are? Will you provide transportation if needed (or if that’s part of your service)? Etc.
What kinds of skills are needed to provide this assistance? What special training or certification (if any) is required?
How will this assistance help people in the short run? That is, how might people be better off immediately because of the assistance you provide?
How will this assistance help people in the long run? That is, how might the assistance you provide have lasting effects, even if it is time-limited?
How will you track and document the process by which you are providing assistance?
Project Management
In this section, you must address the following questions:
Where will central operations for your project be? Will you rent a location, look for a donated location, or work in a distributed way (say from people’s houses)?
What documentation will you need to generate and maintain for the project, and how will you ensure the security and confidentiality of that documentation?
How will you coordinate volunteer efforts, and what will volunteers do? How will you screen volunteers? How many volunteers do you expect to have?
First Half of the Project
In this section, you must address the following questions:
What are the starting and ending dates of your project? (These should be 5 years in the future and run for the 12 weeks of your project.)
How many weeks will you need to start up your project before beginning to provide your project assistance? What will you need to accomplish during these weeks? How would you prove to an outside person (e.g., an auditor) that everything is in place to proceed with your program?
In the remaining weeks of the first half of your project, how many people do you expect to be able to assist, and in what ways? Provide evidence that the volunteers and time available are sufficient to achieve this goal.
Second Half of the Project
In this section, you must address the following questions:
How many weeks of operations will you have before starting to wrap up your project? During this time, how many additional people do you expect to be able to assist, and in what ways? Again, provide evidence that you have enough people power to achieve your objective here.
In the remaining weeks, what steps will you take to wrap up your project? What records will you retain, and how will you archive those? What steps are required to finalize any location-related expenses?
How will you conclude relationships with people you are assisting? What additional sources of support can you direct them to after your project is complete?
Project Evaluation
In this section, you must address the following questions:
If you had to determine immediately after the end of your project whether your assistance had helped, how would you do that? What kind of metric or metrics could you use to determine whether a particular individual had been helped? What questions would you need to ask to determine this?
Similarly, how could you determine, 3 months after the end of your project, whether your project assistance was still having an effect? How would you get back in touch with people you had helped? What characteristics of their condition could you measure to determine whether any positive impact from your assistance still remained?
What else might you need to know before your project starts in order to evaluate success after the project ends?
Ethics and Christian Worldview Analysis
In this section, you must address the following questions:
How does your project demonstrate the Judeo-Islamic-Christian ideal of loving your neighbor as yourself? What other religious and/or ethical principles does your project strive to exemplify or realize?
How are the people you propose to help different from you, and how might you structure your project to help bridge differences and lead to increased mutual understanding and respect?
How does your project further the goal of affording human value and dignity to all people?
Summary and Reflections
In this section, you must address the following questions:
Whom did you contact to learn about needs in your local community? What input did they provide to direct your investigation?
What other local needs did you consider? What was compelling to you about the one you chose?
For the assistance you plan to provide, what other avenues are there for people to receive that assistance? How likely is it that it will be available to them?
What other factors (legal, political, social, etc.) that were not considered as a part of this presentation might you need to investigate if you were actually to implement a project such as this one?
References
Overview:
You and some of your friends want to travel to another country to provide aid in the form of a mission trip. You have been chosen as the team leader, and your job is to provide a plan for the trip, including a financial plan. This is a big job, and you want to do it right, so you and your team have agreed that the trip will take place 5 years from now.
Requirements for the trip:
Who: You and 5-10 other individuals will travel to provide aid.
When: 5 years in the future. The trip will last 2-4 weeks. This is not a large scale, so you should think carefully about what you can accomplish with a team of this size and time frame.
What: This trip’s main purpose will be to fill some sort of tangible need to improve the day-to-day life of the people you meet. Therefore, your first job will be to decide what your team has to offer and to find a location where there is a need for your talents. You should think about what you can do to alleviate human suffering by working in an area of education, health care, basic supplies (such as clothing or home goods), housing, food or clean water, or work to repair the local environment. If you want to include evangelism as a secondary goal, that is fine, but the criteria you will be graded on is how you make a difference in the day-to-day lives of the people you work with.
Where: You will travel overseas. To keep your project manageable, you must choose one of the locations on the Country List, which is included as an attachment to this assignment. Because of the size of the team and your time frame, you should narrow down your area within the country to fit your project. For example, you can’t expect to provide vaccines to the entire country of Brazil, but you could reasonably expect to provide this service to a small town in the country. So you will need to find an area within your chosen country to focus on. The people that you serve in this area are members of your target population.
Requirements for the assignment:
This assignment will have two parts.
Part 1: You create a PowerPoint presentation describing the trip and explaining why the specific country has been chosen. The presentation should have a minimum of eight slides – a title slide, one for each category below, and a reference slide. All important information should be on the face of the slides but you can submit speaker notes for greater detail. In addition, you will need a minimum of three scholarly resources (see the resource list below for ideas) and the presentation should address the following areas:
An overview of your purpose for the project: Where are going, and what service will you be providing? Remember, evangelism cannot be the sole purpose of your trip or even the primary purpose.
Cultural and social aspects of the country and its population that led you to choose this area of the world.
How your choice of project works toward fulfillment of the Judeo-Christian-Islamic ideal to love your neighbor as yourself: How does your personal worldview and the possible worldviews of your target population influence your plans for the trip?
Information about your target population: Who are you planning to serve? How does this population compare to the population of the country as a whole? You will also need to do a calculation to project either the general or the target population in 5 years in the spreadsheet but it does not need to be discussed in the presentation. The World Factbook provides population growth data to help you here.
Information about the economic situation in your country and how your project will improve this.
Possible concerns that you need to keep in mind to keep your team and your target population safe. This could be safety from violence or from health problems (for example, will your team need inoculations to travel to the country).
Part 2: A financial plan for your trip, which you will include in the provided Excel spreadsheet. Your financial plan needs to include the following information:
A list of expenses for all members of your trip. This must include the following:Travel expenses, such as plane or bus fare, passports/visas, local travel within the country. Plane fare can be in U.S. dollars, but the local travel will need to be in the local currency of the country you visit.
Lodging expenses. If you plan to camp, you will include expenses for your camping gear. If you are planning to stay with a host church or host family, you should research the cost of lodging in your target area and provide a per diem donation that is commensurate with the local lodging rates. This will be in the local currency.
Food expenses while you are overseas. Again, if you are being fed by local residents, you will research the approximate cost to feed your group and provide a per diem donation to cover expenses. One way to do this is to research cost of living in your country to find out what a local family would expect to budget to pay for food. Again, these costs will be in the local currency.
Supplies for your project. Provide at least four items that you will need to complete your project. Depending on the nature of your project, these might be in U.S. dollars, or in the local currency, or they may be a mix.
For your expenses that are given in the local currency, a conversion to U.S. dollars.
For each expense, you will use the CPI data from the Bureau of Labor Statistics to calculate your estimated expense 5 years in the future.
A grand total of all projected expenses 5 years from now.
Funding sources for your trip.Sponsorship: You are going to assume that you can find a sponsor who can provide 30% of your grand total of all expenses for seed money, and you will invest that money in a savings account for the next 5 years. Research current savings rates and calculate what this amount will grow to over the next 5 years.
Savings: Your team will work on various fundraisers to save for the trip, and you estimate that you can raise $100 a month every month over the next 5 years, which you will also put into a savings account. Using the savings rates you found in part a., calculate what these regular savings amounts will grow to over the next 5 years.
Loan: If your sponsorship and savings totals do not cover your expenses, then you will need to take out a loan for the remainder of your expenses. Even if your sponsorship and savings total do cover all expenses, then you will take out a $10,000 loan for an additional emergency cushion. Research loan rates from two banks, and calculate the monthly payment, total that you pay back to the bank and total interest you will pay for each loan. You will indicate in the spreadsheet which of the two loans is a better choice for you and your reasons why.
Resources
You should plan to use the following resources to help you with your plan. You can also use other resources, but at a minimum, you will need the Excel Budget Spreadsheet, BLS CPI data, and CIA World Factbook. Additionally, your paper requires three scholarly sources.
Country list.docx: Includes the list of countries you are allowed to choose from for this project, along with some important facts about the country’s make up.
Bureau of Labor Statistics Consumer Price Data information: gov/cgi-bin/surveymost?cu”>https://data.bls.gov/cgi-bin/surveymost?cu which is the same as on Worksheet 2.
CIA World Fact Book: You must use this source. You will find that it contains a wealth of demographic, economic, and cultural information about your country. https://www.cia.gov/library/publications/the-world-factbook/
U.S. Department of State website: This site will give you important information about your country, as well as information about travel overseas. https://travel.state.gov/content/travel/en/international-travel/International-Travel-Country-Information-Pages.html
Excel Budget Spreadsheet: Attached to the assignment directions, and provides a compact way to explain your budget and funding.
Your course textbook
GCU Library
Tips and formulas:
This assignment uses a rubric. Please be sure to look at the grading criteria and point values for each area of the rubric to see how you will be graded on this assignment.
Compound interest formula (also called the Lump Sum Investment formula) formatted for EXCEL: A = P * ((1 + r/n)^(n * t).
A is the accrued amount after t years that the principal, P, grows to at interest rate, r%, compounded n times each year.
Regular payments formula (also called the Savings Plan formula) formatted for EXCEL: A = PMT * ((1 + r/n)^(n * t)-1)/(r/n).
A is the accrued amount after t years of making regular payments, PMT, into an account at interest rate, r%, compounded n times each year.
Loan payment formula formatted for EXCEL: PMT = P * (r/n)/(1 – (1 + r/n)^(-n*t)).
PMT is the payment required to pay off a loan of $P at interest rate, r%, compounded n times per year for t years.
Percent change IR = (new CPI – old CPI)/old CPI where IR is inflation rate.
Get professional assignment help cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why choose our academic writing service?
Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently
Get Professional Assignment Help Cheaply
Are you busy and do not have time to handle your assignment? Are you scared that your paper will not make the grade? Do you have responsibilities that may hinder you from turning in your assignment on time? Are you tired and can barely handle your assignment? Are your grades inconsistent?
Whichever your reason may is, it is valid! You can get professional academic help from our service at affordable rates. We have a team of professional academic writers who can handle all your assignments.
Our essay writers are graduates with diplomas, bachelor’s, masters, Ph.D., and doctorate degrees in various subjects. The minimum requirement to be an essay writer with our essay writing service is to have a college diploma. When assigning your order, we match the paper subject with the area of specialization of the writer.
Why Choose Our Academic Writing Service?
Plagiarism free papers
Timely delivery
Any deadline
Skilled, Experienced Native English Writers
Subject-relevant academic writer
Adherence to paper instructions
Ability to tackle bulk assignments
Reasonable prices
24/7 Customer Support
Get superb grades consistently
How It Works
1. Place an order
You fill all the paper instructions in the order form. Make sure you include all the helpful materials so that our academic writers can deliver the perfect paper. It will also help to eliminate unnecessary revisions.
2. Pay for the order
Proceed to pay for the paper so that it can be assigned to one of our expert academic writers. The paper subject is matched with the writer’s area of specialization.
3. Track the progress
You communicate with the writer and know about the progress of the paper. The client can ask the writer for drafts of the paper. The client can upload extra material and include additional instructions from the lecturer. Receive a paper.
4. Download the paper
The paper is sent to your email and uploaded to your personal account. You also get a plagiarism report attached to your paper.
PLACE THIS ORDER OR A SIMILAR ORDER WITH Essay fount TODAY AND GET AN AMAZING DISCOUNT
The post Excel Grading Sheet appeared first on Essay fount.
What Students Are Saying About Us
.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"
.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."
"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"
