Touchstone 4: Analyzing Your Personal Finances

SCENARIO: Three months have passed since you created your first financial plan (i.e., the Unit 2 Touchstone). In that time, your budget has gone through some changes. The good news is that your income has increased because of your strong performance at work. However, health care and miscellaneous costs have gone up along with your earnings. You will need to reallocate your monthly budget based on these changes to see how you’re progressing toward your original savings goal.

While you appreciate numbers and figures, you also know that a strong financial analysis needs visual information. As part of your progress check, you’ve committed to creating a set of graphs that you can share with your financial advisor.

ASSIGNMENT: This assignment has two parts. In part 1, you will analyze personal finance data based on the scenario described above. You’ll use your problem solving and agility skills to balance three monthly budgets, and you’ll use your technology skill to graph the spending allocations in each of them. Finally, you’ll sharpen all three skills as you calculate and graph the progress you’re making toward your original savings goal.

In part 2, you will answer reflection questions about the decisions you made, identify how to create more savings opportunities, and make predictions about life and economic impacts that could affect the future of your plan.

For this assignment, you will:

  • Create three monthly budgets and perform a personal financial analysis using Microsoft Excel.
  • Summarize changes in expenditures between budgets.
  • Show the results of the analysis using appropriate graphs in Excel.
  • Explain how the graph types you have selected will help your financial advisor understand the data.
  • Discuss the results of the financial analysis including savings achievements, future budget modifications, and life impacts that could derail the budget in the coming year.
  • Reflect on what the analysis might reasonably look like in one year, accounting for economic factors such as inflation and the consumer price index.

 

A. Assignment Guidelines

DIRECTIONS: Refer to the lists below throughout the assignment. Do not submit your Touchstone until it meets these guidelines.

1. Analyzing Your Personal Finances

❒ Have you populated the tables for Month 1, Month 2, and Month 3 with your budgeting information?❒ Have you verified that all amounts are displayed on a monthly (not annual) basis?❒ Have you verified that the sum of your expenditures (including savings) equals your employment income?❒ Have you populated the Savings Progress table?❒ Have you selected the most effective graph type for each of your data sets?❒ Have you left all predetermined formulas intact?

2. Reflection Questions

❒ Have you directly answered each question that was asked?❒ Have you provided sufficient evidence to support each of your answers?❒ Have you made clear and logical connections between your conclusions and the data used in the financial analysis?❒ Have you leveraged content from the course tutorials about economic factors?❒ Have you included sufficient detail in your answers?

 

Sheet1

ECON1010 Taking Charge of Your Economic Future Name:
Unit 4 Touchstone Template Date:
MONTH 1 BUDGET MONTH 2 BUDGET MONTH 3 BUDGET SAVINGS PROGRESS
Amount Percent Amount Percent Amount Percent
Income 100% Income $0 100% Income $0 100% Monthly Savings Cumulative Savings $ to Reach Goal
Expenditure Expenditure Expenditure Month 1 $0
Housing Housing Housing Month 2 $0
Food Food Food Month 3 $0
Transportation Transportation Transportation
Education Education Education
Utilities Utilities Utilities
Taxes Taxes Taxes
Health Care Health Care $400 Health Care $400 Note:
Family Care Family Care Family Care To increase the height of a row, hover over the bottom border of that row in the far left margin until your cursor becomes and up-down arrow. Then click and drag the bottom border to the desired row height. If you make an error, you can use the shortcut Ctrl + Z to undo it.
Miscellaneous Miscellaneous Miscellaneous $100
Savings Savings Savings
Total Total Total
PART 1: ANALYZING YOUR PERSONAL FINANCES PART 2: REFLECTION QUESTIONS
SCENARIO: Your monthly budget is going through some changes over the next three months. The good news is that your income has increased because of your strong performance at work. However, health care and miscellaneous costs have also gone up. You will need to reallocate your monthly budget based on these changes. The changes are represented by embedded formulas in the MONTHLY BUDGET tables above, located inside the shaded cells. QUESTION 1: In step 4 and step 6, you created several graphs. Explain the reasons for the graph types that you selected. How will the graphs you created help readers understand the financial data? Your Answer (150 words or less):
STEP 1: Enter the previous values you obtained from the Unit 2 Touchstone into the MONTH 1 BUDGET. Important: Before you do, be sure to divide each dollar amount by 12. Remember, the Unit 2 Touchstone was an annual basis while this Touchstone is a monthly basis. If you no longer have the previous values, create new ones. Remember to start by entering your income and be sure the MONTH 1 BUDGET balances. QUESTION 2: Explain the results of your financial analysis in steps 1-6 in terms of the following: • Overall progress toward your savings goals • Changes you might make to the budget to improve progress in the coming months • Economic or life impacts that may affect your budget in the future Your Answer (150 words or less):
STEP 2: Now create your MONTH 2 BUDGET and your MONTH 3 BUDGET above. Do not change the predetermined costs for Health Care in the second month or Miscellaneous in the third month. Do not modify the income in either month. Remember that your monthly income must equal your monthly expenditures (including savings). Look ahead to step 3 to see how you can use formulas for proper balancing. QUESTION 3: Assume that your income continues to grow, but consumer prices also rise due to inflation. Determine how economic factors like these might affect your financial analysis one year from now: A. What economic trends might you need to account for when making a one-year projection? B. How might you plan for unexpected expenses when making a one-year projection? Your Answer (150 words or less): A. B.
STEP 3: Your MONTH 2 BUDGET and your MONTH 3 BUDGET may or may not be balanced. To check, do the following: • Enter a formula to calculate your total expenditures. Adjust your expenditures until the total equals your monthly income. • Next, enter formulas in the percent column to calculate each expenditure as a percentage of the total expenditure.
STEP 4: Using the tools in Excel, make a graph for each of the three budgets to show your spending allocation. You may use a pie chart, column chart, bar chart, or some other graph type. Review the tutorial in Unit 1 called Data Visualization if you need a refresher on graphing. If your embedded graphs block your view, move them off the work area, either downward or to the right.
STEP 5: Fill in the table for SAVINGS PROGRESS located at the top right of this spreadsheet: • Enter your monthly savings from steps 1-4. The cumulative savings column will calculate automatically. • Recall your total savings goal from the Unit 2 Touchstone. In the last column, record how much more money you need to save in order to reach your goal. • If you can’t recall your savings goal, create a new one so you’re able to complete the table.
STEP 6: Using the tools in Excel, make a graph that shows your incremental progress toward your savings goal based on the data in the SAVINGS PROGRESS table: • Select a graph type that best illustrates your progress. Move the graph off the work area if it obstructs your view. • Finally, using steps 1-6 as a reference, complete the REFLECTION QUESTIONS on the right side of this spreadsheet.

HIS World Civilization Discussions

 

Discussion Reply

Topic 1: Law Code of Hammurabi

(D1 Reply #1)

The code was written by King Hammurabi around 1750 BCE, a time when civilization was growing and changing rapidly (Jarus, 2022). A civilization under this dynamic prompted leaders who oversee these citizens, needed to take specific measures that would maintain peace and order in their community. Thus, the creation and implementation of the code of Hammurabi and its 282 laws.

 

The code and its laws were written in a cause-effect format. Each law was written in such a way that it gave clear description on the consequences that would happen should certain applicable acts and events take place and/or are committed. To point out, this format is also what this code is known for, “an eye for an eye”. The laws written in this code pioneered the concepts of being “guilty until proven innocent” and “retaliatory justice” (Andrews, 2018), which are still being used in modern law. Taking this concept into consideration, it made sense why the first few laws discussed the consequences of false accusation and the inability to prove a crime. If the claim cannot be proven or is proven to be false, then the punishment cannot take place. The rest of the laws went into specific punishments against known crimes such as theft, adultery, murder, etc.

 

One of the major concerns in these laws were how most of the punishments in them result to harsh penalties that inflict physical damage to the convicted, with some laws going straight for the extreme punishment of death. The harshness  of the punishments implies how these laws were made to ensure that its citizens would follow it, even if it meant that they follow them out of fear. Laws were supposedly made to maintain peace and order, but these laws seemed to have been made to benefit people who belong in a better half of the society than the other.

 

Sources:

 

Jarus, O. (2022).  Code of hammurabi: Ancient babylonian laws. Live Science.  https://www.livescience.com/39393-code-of-hammurabi.html

 

Andrews, E. (2018).  8 things you may know know about hammurabi’s code. History.  https://www.history.com/news/8-things-you-may-not-know-about-hammurabis-code

Reply to Thread

 

 

Hammurabi the king and ruler of Babylon, he started his rain in 1792 BC ruling for 43 years. Some may call Hammurabi the founder of rules due to his idea of bringing most of the cities of Mesopotamia under one law with one set of rules being his. This can definitely be seen as a positive thing seeing as how before that each of the cities had their own set of rules and laws that people would unconsciously break and get in trouble for just for simply not knowing they even existed. Hammurabi created the Hammurabi’s code which were a set of laws adding up to a total of 282 and was written on an 8 foot stone stab. The main idea of the stone stab was to make sure everyone knew what the laws were and what the punishment for breaking them would be.

How is the Code organized?

The Code was organized by individual rights, property rights, trade, family offenses, and labor matters.

Why do you think some laws are first?

Thinking back to the stone stab, I would presume it’d only makes sense to put the most important laws first due to perhaps people not reading the full thing or getting lost in the middle somewhere. If the more important laws are places first they can be easier to see by the eye and therefor remembered more often making it more than likely not broken as likely as other laws.

What do the laws tell you about the nature of early urban life?

The laws tell me that urban life was still underdeveloped yet at the same time shows proof of evolving. To explain, there were a lot of laws that were unjust, and the whole “eye for an eye” being taken very much literally makes it that much worse. Sure that can work, but in very few cases would that be helpful because now a lot of innocent people are being taken advantage of and one is too many as is. Now going on to the  evolving point, these set of laws had the right idea when they were founded, they wanted to bring everyone together under one set of rules that sets aside all confusion and excuses of crimes, In return you get a more structured and all in all successful society. Later on they do develop into laws we see today and become the “founding idea” if you will.

What seem to be major concerns?

Once again the major concern I saw was the eye for an eye part of the structure of the law being taken literal. The example of used of the house that the builder built getting destroyed and killing the son of the home owner due to supposed unproven a job done incorrectly therefor giving the homeowner permission to kill the builder’s son is a perfect example of my point. No where in that story is there any justice for anyone, all this does is kill off a young kid’s future that has done nothing wrong his whole life over an angry, lost, unrational decision of a father who lost his son.

Do the laws seem just? Why or why not?

A simple answer to this is no, at least in today’s society’s standards. However if we truly give it a moment’s thought and think about how the lifestyle was in the urban life, these set of laws and rules were as just as they could of been. It was definitely and improvement of the chaos spread among the people and the confusion that was there none stop, these laws helped bring order and a decent amount of justice. One can even say they had their heart in the right place but could not yet bring them to their full potential.

 

Topic 2: Classical Greece

 

Classical Greece

Who do you think were the intended audiences of Pericles’ Funeral Oration and Xenophon’s description of the Spartan state?

Xenophon’s portrayal of the Spartan state and Pericles’ Funeral Oration may have been intended for two different audiences. The Athenians heard Pericles’ Funeral Oration amid the Peloponnesian War to honor the dead soldiers and feel pride in their democratic government (Fordham University, 2019a). In contrast, Xenophon, an Athenian military historian, commended the Spartan administration and military training system in his book The Polity of the Spartans.

How might their purpose and intended audience affect their tone?

The tone of each exertion may have been altered by the context in which it was made. The purpose of Pericles’ speech was to build enthusiasm and instill trust in Athenian democracy. Therefore, he focused on the positive aspects of Athenian society while glossing over its flaws. However, the work of Xenophon was written in praise of the Spartan system, and as such, it gave a favorable portrayal of Spartan culture and administration.

Can we take these accounts at face value? Why or why not?

Since both books were written several decades after the events discussed, they might have been influenced by prejudices and contain inaccuracies. Though they shed light on the worldviews of ancient Athenians and Spartans, they should not be accepted as accounts of face value (Fordham University, 2019b). Additional analysis and research of many primary and secondary sources are required to grasp the represented civilizations.

What else would you like to know from the author?

Additionally, I would like to hear from the documents authors about their inspirations for composing the works, where they found their material, and how much governmental, social, and cultural issues of the present day played a role in shaping the content of their writing. The author’s biographies, histories, and cultural settings are all things I am curious about learning more about.

References

Fordham University. (2019a).  Thucydides (c.460/455-c.399 BCE): Pericles’ Funeral Oration from the Peloponnesian War (Book 2.34-46). Fordham.edu; Paul Halsall.  https://sourcebooks.fordham.edu/ancient/pericles-funeralspeech.asp

Fordham University. (2019b).  Xenophon (c.428-c.354 BCE): The Polity of the Spartans, c. 375 BCE. Fordham.edu; Paul Halsall.  https://sourcebooks.fordham.edu/ancient/xeno-sparta1.asp

 

 

Who do you think were the intended audiences of Pericles’ Funeral Oration and Xenophon’s description of the Spartan state?

I believe that Pericle’s Funeral Oration was intended not only for the family members who had lost a loved one on the battlefield, but also for the entire state to hear. It is a mourning speech to pay respect to the ones who have died for the people. This speech goes on the lift up the spirits and motivate the troops that still have to go into battle. Pericles goes on to say that the lives of these men will not be taking in vain and that comfort is needed, not condolences. Xenophon’s description of the spartan state was designed to inform any type of audience that wanted to learn about how Lycurgos raised and trained the spartan men. This passage goes on to explain what an average life would look like in order for a spartan boy to earn his rite of passage into adulthood.

 

How might their purpose and intended audience affect their tone?

Since Pericles knew that he would be talking to people that were sad and mourning, I believe that he delivered this speech with a more comfort but still passionate tone. He had to let the audience know that he cared but he also wanted to motivate them. Xenophon’s tone was more of a neutral and informative tone. This passage was not a speech or sermon, this passage was just more of an informative article.

 

Can we take these accounts at face value? Why or why not?

Since none of us were there during this time, I don’t think that we can these accounts at face value. The truth is that we can only assume from what we read and I don’t believe that is enough.

 

What else would you like to know from the author?

I would like to know what their thoughts are on all of this. Do they feel the same way? Would they have answered these discussion questions the same way I did?

 

References:

Reilly, K. (2022). The Human Journey: A Concise Introduction to World History, Prehistory to 1450 (2nd ed.). Rowman & Littlefield Publishers.

Thucydides (c.460/455-c.399 BCE): Pericles’ Funeral Oration from the Peloponnesian War (c. 430 BCE) –  http://sourcebooks.fordham.edu/Halsall/ancient/pericles-funeralspeech.asp

Xenophon (c.428-c.354 BCE): The Polity of the Spartans, c. 375 BCE –  http://sourcebooks.fordham.edu/Halsall/ancient/xeno-sparta1.asp

How has the Internet altered the way in which newspapers present news

PROJECT 4: FINAL EXAM

Include References to all answers

ESSAY QUESTIONS 1. How has the Internet altered the way in which newspapers present news? How are print newspapers responding to the decline of subscribers and the rise of online readers? Support your discussion with reliable sources.

<Type your answer here>

 

2. How has Digital Media influenced (or changed) the field of education? Include a historical (before and after the digital media) and global perspective (include discussion of the US and at least two additional countries). Include whether the change has been positive, negative, or both. Support your discussion with reliable data.

<Type your answer here>

 

3. How has “fake news” come to exist and spread so rapidly? Why do you think this happens? How is “fake news” harmful? What are the long- and short-term effects and consequences of being a consumer of “fake news”? How does it affect each of us? How can we, as consumers and sharers of news, learn to identify potential “fake news” stories? Support your discussion with reliable sources.

<Type your answer here>

4. Define the digital divide, discuss how pervasive it is (include reliable statistics), and list three examples of how it negatively impacts society. Provide two examples of how the digital divide can be closed. Support your discussion with reliable sources.

 

<Type your answer here>

 

5. How has Digital Media influenced (or changed) children of this generation? How are their lives different than ours? Include a historical (before and after the digital media) and global perspective (include discussion of the US and at least two additional countries). Include whether the change has been positive, negative, or both. Support your discussion with reliable sources.

<Type your answer here>

 

6. How has Digital Media influenced (or changed) the field of e-commerce? Include a historical (before and after the digital media) and global perspective (include discussion of the US and at least two additional countries). Support your discussion with reliable sources.

<Type your answer here>

 

7. How has Digital Media influenced (or changed) the culture? Include a historical (before and after the digital media) and global perspective (include discussion of the US and at least two additional countries). Include whether the change has been positive, negative, or both. Support your discussion with reliable data. Support your discussion with reliable sources. <Type your answer here>

 

8. Discuss how social media is used in Presidential Elections in terms of communicating with voters, fundraising, and campaign organizing. Discuss how databases of political information can be used to help voters make decisions on candidates and issues. Support your discussion with reliable sources.

<Type your answer here>

SWK-204- Social Work Research

 

Lesson 12 Discussion-1

How would you build a positive relationship with your research participants?  Do you feel these relationships would make a difference in your outcomes? (300 Words)

Lesson 12 Discussion-2

What social work issues could be studied using a qualitative research design? Why would this research method work best to study these topics? (300 Words)

 

 

 

Lesson 12 Assignment

Pick a social work topic and develop seven qualitative interview questions to gather more information from your participants in a study.  Attach interview questions and explain why you picked these questions and what information you wanted to gather . (1 Page).

 

Lesson 13 Discussion

Would your behaviors change if you were being observed?  Give some examples of activities and any experiences you have had with others observing you. (300 Words)

 

Lesson 13 Assignment

Write at least one to two-page paper using APA format, cite references and submit a reference page.

Observe someone doing an activity without telling them you are observing them.  Write down your findings. Then observe them again doing the same activity after informing them that you are watching them. Write down your findings.  Then compare the data from both observations.  Identify and define how their behaviors changed in each observation.  Address whether the knowledge of being observed made a difference in their behaviors and how they changed.  Submit your findings from both observations with your assignment. . (2 Page).

correlational study

Design a correlational study, groups will need two variables with at least five sets of data. between these two variables: time spent playing video games and aggression.

Then in 500-750 words, do the following:

1. Create a hypothesis for the group’s study. Consider the hypothesis and how the group will define operationally and measure the variables.

2. Describe how the group will obtain a random sample of participants.

3. Assume the study produces a correlation of .56 between the variables. Analyze three possible causal reasons for the relationship.

4. Submit an SPSS output for the correlational study.

Use two to four scholarly resources to support your explanations.

Prepare this assignment according to the guidelines found in the APA Style Guide, located in the Student Success Center. An abstract is not required.

This assignment uses a rubric. Please review the rubric prior to beginning the assignment to become familiar with the expectations for successful completion.

You are required to submit this assignment to LopesWrite. A link to the LopesWrite technical support articles is located in Class Resources if you need assistance.

 

Typing Template for APA Papers: A Sample of Proper Formatting for APA Style

 

Student A. Sample

College Name,

Course Number: Course Title

Instructor’s Name

Running head: ASSIGNMENT TITLE HERE

 

 

1

 

Assignment Due Date

Typing Template for APA Papers: A Sample of Proper Formatting for APA Style

This is an electronic template for papers written according to the style of the American Psychological Association (APA, 2020) as outlined in the seventh edition of the Publication Manual of the American Psychological Association. The purpose of the template is to help students set the margins and spacing. Margins are set at 1 inch for top, bottom, left, and right. The text is left-justified only; that means the left margin is straight, but the right margin is ragged. Each paragraph is indented 0.5 inch. It is best to use the tab key to indent, or set a first-line indent in the paragraph settings. The line spacing is double throughout the paper, even on the reference page. One space is used after punctuation at the end of sentences. The font style used in this template is Times New Roman and the font size is 12 point. This font and size is required for GCU papers.

The Section Heading

The heading above would be used if you want to have your paper divided into sections based on content. This is a Level 1 heading, and it is centered and bolded, and the initial word and each word of four or more letters is capitalized. The heading should be a short descriptor of the section. Note that not all papers will have headings or subheadings in them. Papers for beginning undergraduate courses (100 or 200 level) will generally not need headings beyond Level 1. The paper title serves as the heading for the first paragraph of the paper, so “Introduction” is not used as a heading.

Subsection Heading

The subheading above would be used if there are several sections within the topic labeled in a first level heading. This is a Level 2 heading, and it is flush left and bolded, and the initial word and each word of four or more letters is capitalized.

Subsection Heading

APA dictates that you should avoid having only one subsection heading and subsection within a section. In other words, use at least two subheadings under a main heading, or do not use any at all. Headings are used in order, so a paper must use Level 1 before using Level 2. Do not adjust spacing to change where on the page a heading falls, even if it would be the last line on a page.

The Title Page

When you are ready to write, and after having read these instructions completely, you can delete these directions and start typing. The formatting should stay the same. You will also need to change the items on the title page. Fill in your own title, name, course, college, instructor, and date. List the college to which the course belongs, such as College of Theology, College of Business, or College of Humanities and Social Sciences. GCU uses three letters and numbers with a hyphen for course numbers, such as CWV-101 or UNV-104. The date should be written as Month Day, Year. Spell out the month name.

Formatting References and Citations

APA Style includes rules for citing resources. The Publication Manual (APA, 2020) also discusses the desired tone of writing, grammar, punctuation, formatting for numbers, and a variety of other important topics. Although APA Style rules are used in this template, the purpose of the template is only to demonstrate spacing and the general parts of the paper. GCU has prepared an APA Style Guide available in the Student Success Center and on the GCU Library’s Citing Sources in APA guide (https://libguides.gcu.edu/APA) for help in correctly formatting according to APA Style.

The reference list should appear at the end of a paper. It provides the information necessary for a reader to locate and retrieve any source you cite in the body of the paper. Each source you cite in the paper must appear in your reference list; likewise, each entry in the reference list must be cited in your text. A sample reference page is included below. This page includes examples of how to format different reference types. The first reference is to a webpage without a clear date, which is common with organizational websites (American Nurses Association, n.d.). Next is the Publication Manual referred to throughout this template (APA, 2020). Notice that the manual reference includes the DOI number, even though this is a print book, as the DOI was listed on book, and does not include a publisher name since the publisher is also the author. A journal article reference will also often include a DOI, and as this article has four authors, only the first would appear in the in-text citation (Copeland et al., 2013). Government publications like the Treatment Improvement Protocol series documents from the Center for Substance Abuse Treatment (2014) are another common source found online. A book without a DOI is the last example (Holland & Forrest, 2017).

References

American Nurses Association. (n.d.). Scope of practice. https://www.nursingworld.org/practice-policy/scope-of-practice/

American Psychological Association. (2020). Publication manual of the American Psychological Association (7th ed.). https://doi.org/10.1037/0000165-000

Center for Substance Abuse Treatment. (2014). Improving cultural competence (HHS Publication No. 14-4849). U.S. Department of Health and Human Services, Substance Abuse and Mental Health Services Administration. https://www.ncbi.nlm.nih.gov/books/NBK248428/

Copeland, T., Henderson, B., Mayer, B., & Nicholson, S. (2013). Three different paths for tabletop gaming in school libraries. Library Trends, 61(4), 825–835. https://doi.org/10.1353/lib.2013.0018

Holland, R. A., & Forrest, B. K. (2017). Good arguments: Making your case in writing and public speaking. Baker Academic.