It’s easy to get smarter about your money when you have a head start.  

In this assignment, you will use Excel to create a household budget to help maintain control over your finances and see how your money is being used.

Conduct a short internet job search for the type of position you will be applying for once you have completed your education. Consider your work experience in this search. For example, if you have no experience in field, please search for entry level positions or the type of position someone with your background could reasonably qualify for. Look for three positions that include wage/salary information. Once you have found 3 job ads that include salary information, determine the average starting salary and use this as the basis for your household budget.
Create an Excel spreadsheet of your own design to breakdown your household budget. List monthly expenses and monthly income. You will need to list your expenses for 12 months (so you should have columns for each month).  Remember your expenses are not always the same every month (for instance your electric bill could fluctuate based on how hot it is). Be sure to format the expenses and income as currency using one of the formatting options in Excel. Do NOT use an online template. The designs must be easy and logical to read.  You should start from a blank, clean, Excel document. 

Requirements of the assignment

• Title your spreadsheet with a meaningful title, in bold, at least 16 point size, centered above your spreadsheet content and is centered over more than 3 columns. Use “Merge & Center” provided in Excel. The rest of the document should be in 12 point font.  All data that represents money is formatted as currency. 
• Write your job title and the city and state you will live in
• Include 3 job titles, locations, and starting salaries from the job search you performed.  Find the average starting salary (using the AVERAGE function) Calculate and label your monthly income by dividing the annual income cell (reference the cell) by 12. Please make sure that your salary realistically and accurately matches your skill set (for instance, you will not start an engineering job making 90,000 a year).
• Include at least 8 expense items such as electricity, telephone, gas, groceries, rent/mortgage, car payment, student loan payments, credit card payments, entertainment allowance, clothing allowance, etc.
• Make all negative numbers appear in red using automatic formatting or conditional formatting provided in Excel. Choosing RED as the choice for the font color is not correct. Apply this formatting to the entire worksheet.  You must have a negative somewhere in your calculations
• For the following items, you MUST use an Excel function. You cannot calculate the values and enter a number. Excel functions include SUM, AVERAGE, MIN, MAX, etc. You must choose the correct Excel function and then use it properly to get full credit.
  • Using an Excel function, calculate the average of each type of expense category for the months you have listed. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
  • Calculate a subtotal for each expense category, using a function provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
  • Calculate a subtotal for each month, then a grand total of all the months, using functions provided in Excel. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
  • Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income.  Use an absolute reference to reference the cell of the monthly income. You must select the right function, such as SUM or AVERAGE, and then use the function correctly in the cell you have selected. Be sure to label the row or column (note this will depend on how you set up your budget sheet).
• Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the monthly totals you have calculated to create your pie chart.  Put the pie chart on its own worksheet labeled “Chart”.  Please note, the chart values should be from the budget page of the worksheet.  Do not copy the values into the new worksheet.
• Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as ##### so make sure your columns are of the correct width for the data.
• Check your spelling
• Create a footer displaying the filename. 
• Save your completed file with the filename formatted as Excel_Budget_yourfirstname_yourlastname.xls. An Excel document should be uploaded to D2L.

I have included two (2) example budgets for you to review, Budget Example 1, Budget Exampe 2.  These are from students from another section of this course.  These are meant to be guides and not exemplars. Please note, even though these are PDFs, you are expected to upload a XLS.

Assignment Content

1. Create and compile the following:
   • A 175- to 350-word Executive Summary of the completed project using Microsoft® Word
   • A 10- to 12-slide Microsoft® PowerPoint® presentation with speaker notes to present the Request for Proposal (RFP) and recommendations to the CEO
   • A final copy of your IT Infrastructure Review and Upgrade Recommendations (a single document that combines all the work completed each week)
   • Verify your summary includes the following:
   • A list of business and functional requirements, such as business intelligence, data management, and security
   • The recommendations must be justified in the context of the stated requirements and include new and emerging technologies, such as cloud computing, SaaS, IaaS, virtualization, and Big Data
   • Ensure that references are cited and that the paper follows APA formatting guidelines.

https://enterprisersproject.com/article/2018/6/10-ted-talks-sharpen-your-communication-skills?page=0%2C0

 BASED ON TED TALK ON BELOW LINK

Follow this link to access an article  from The Enterprisers Project.  Each student will select a Ted Talk.   Then, watch the Ted Talk and take good notes. 

Answer the following quetions: 

1.  Identify the specific Ted talk
2.  What is the overall theme of the Ted Talk?
3.  What key points of the Ted Talk are important to consider as related to organizational communication?
4.  Based on what you have learned in the class, how does the Ted Talk align with organizational communication theory?

APA FORMAT 300 words and REFERENCES AND CITATIONS 

The acceptance of Bring Your Own Device into corporate environments and government environments has created a unique business challenge that must be solved.  This challenge is based on the fact that the IT asset is owned by the employee.  

Discuss two of the most interesting elements commonly addressed in a Bring Your Own Device (BYOD) policy definition (from pages 129 – 131 from the book Fundamentals of Information Systems Security 3rd Edition).   Mention why they are interesting to you.   

Instructions

Each Research Paper: Topic Proposal and Outline must include the following 3 items:

1. A brief (at least 3–4 bullets with 1–2 sentences per bullet) overview of the research topics of your paper – you will need to address these in the Research Paper:  This will be titled “Research Objectives”.

2. A list of at least 3 questions (in a numbered list) you intend your research to ask and hopefully answer. These must be questions that will require you to draw conclusions from your research. These must not be questions to answer your research objectives. This section will be titled “Questions.”

3. At least 3 initial research sources, 1 of which is an academic journal or other peer-reviewed source. These should match APA formatting of sources.

Example formats for Topic Outlines (an example, not a template):

Research Objectives

· Briefly describe the overall concept of system integration.

· Discuss the traditional approach of big-bang integration including the major advantages and disadvantages of this approach.

· Discuss the traditional approaches of top-down and bottom-up integration and their major advantages and disadvantages.

· Discuss the traditional approach of mixed integration, combining the desirable advantages from the top-down and bottom-up integration approaches.

Questions

1. Why is system integration an important step in the software development process?

2. Why has big-bang integration not survived as a useful testing method?

3. Why have top-down and bottom-up integration not been replaced by more modern methods?

4. Why would you use mixed integration all the time rather than sometimes using top-down and bottom-up integration exclusively?

References

1. Herath, T., & Rao, H. (2012). Encouraging information security behaviors in the best organizations: Role of penalties, pressures, and potential effectiveness. Descision Support Systems, 47(2), 154-165.

2. Testing Computer Software, 2nd Edition, by Cem Kaner

3. Anderson, R. (2008). Security Engineering: A Guide to Building Dependable Distributed Systems (2nd ed.). Cambridge, MA: Wiley.