{"id":15840,"date":"2024-03-17T19:18:05","date_gmt":"2024-03-17T19:18:05","guid":{"rendered":"https:\/\/www.writemyessays.app\/blog\/questions\/idella-jacksons-household-budget-as-a-nurse-in-nursing-informatics-specialists\/"},"modified":"2024-03-17T19:18:05","modified_gmt":"2024-03-17T19:18:05","slug":"idella-jacksons-household-budget-as-a-nurse-in-nursing-informatics-specialists","status":"publish","type":"questions","link":"https:\/\/www.writemyessays.app\/blog\/questions\/idella-jacksons-household-budget-as-a-nurse-in-nursing-informatics-specialists\/","title":{"rendered":"IDELLA JACKSON\u2019S HOUSEHOLD BUDGET AS A NURSE IN  NURSING INFORMATICS SPECIALISTS"},"content":{"rendered":"<p style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: 15.6933px; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">It&#8217;s easy to get smarter about your money when you have a head start.&nbsp;<\/span><\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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.<br style=\"cursor: auto; color: inherit;\"><br style=\"cursor: auto; color: inherit;\"><br style=\"cursor: auto; color: inherit;\"><\/span><\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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 the 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.<\/span><br style=\"cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><\/span><\/p>\n<p style=\"margin: 0.5em 0px 1em; font-size: 19px; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Please<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">use the attached Starter File<\/strong><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span>and create an Excel spreadsheet to break down 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).&nbsp; 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.<span style=\"cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">Do NOT use any type of template<\/strong><\/span><strong style=\"font-weight: bold; cursor: auto; color: inherit;\">.<\/strong><span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span>Remember, I&#8217;m not looking for format creativity. I am looking for the correct use of Formulas and Functions. Your Workbook should have the Budget numbers on one Worksheet (named Budget) and a Chart\/Graph on another (named Chart). The attached PDF solution file is an example of what your submission should resemble.<\/span><\/p>\n<p style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\"><strong style=\"font-weight: bold; cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\"><span style=\"cursor: auto; color: inherit;\">Requirements of the assignment<\/span><\/span><\/strong><\/span><\/p>\n<ul style=\"margin: 0in 0px; font-size: 19px; cursor: auto; color: inherit;\">\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Title your spreadsheet with a meaningful title, in bold, at least 16 point size, centered above your spreadsheet content, and centered over more than 3 columns. Use &#8220;Merge &amp; Center&#8221; provided in Excel. The rest of the document should be in 12-point font.&nbsp; All data that represents money is formatted as currency.<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Write your job title and the city and state you will live in<\/span><\/li>\n<li style=\"margin: 0in 0in 12pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Include 3 job titles, locations, and starting salaries from the job search you performed. Calculate the average starting salary numbers using the AVERAGE function. If your research shows a Monthly salary, calculate the yearly. If your research shows a Yearly salary, calculate the monthly. Please ensure that your salary realistically and accurately matches your skill set (for instance, you will not start an engineering job making 90,000 a year).<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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.<\/span><\/li>\n<li style=\"margin: 0in 0in 12pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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 number somewhere in your calculations.&nbsp;<\/span><\/li>\n<li style=\"margin: 0in 0in 12pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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.<\/span><\/li>\n<ul style=\"margin: 0in 0px; cursor: auto; color: inherit;\">\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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).<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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).<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">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).<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Calculate your monthly income after expenses. For each month, subtract the monthly expenses from the monthly income.&nbsp; Use an absolute reference to reference the cell of the average 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).<\/span><\/li>\n<\/ul>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Include a pie chart to display the breakdown of expenses. Use the expense categories you have listed and the average monthly totals you have calculated to create your pie chart. Put the pie chart on its own worksheet labeled &#8220;Chart.\u201d&nbsp; Please note the chart values should be from the Budget worksheet. Do not copy the values you wish to plot into the Chart worksheet. Even though this would be an acceptable approach in real life, I want to see if you can plot non-contiguous data.<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Make sure your spreadsheet is clearly organized and well formatted. For example, no values should display as #####, so make sure your columns have the correct width for the data.<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Check your spelling<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Create a footer displaying the filename.<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">Save your completed file with the filename formatted as<span style=\"cursor: auto; color: inherit;\">&nbsp;<\/span><b style=\"font-weight: bold; cursor: auto; color: inherit;\">Excel_Budget_yourfirstname_yourlastname.xlsx<\/b>. An Excel document must be uploaded to D2L.<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">I include the information of what the charts should have on it please use the same information I put on the paper.&nbsp;<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">I also included the example of how the charts should look<\/span><\/li>\n<li style=\"margin: 0in 0in 8pt; font-size: 11pt; line-height: normal; cursor: auto; color: inherit;\"><span style=\"font-size: 12pt; cursor: auto; color: inherit;\">please follow these exact information if you have any questions feel free to contact me<\/span><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>It&#8217;s easy to get smarter about your money when you have a head start.&nbsp; 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 [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":[],"disciplines":[181],"paper_types":[],"tagged":[],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/15840"}],"collection":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions"}],"about":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/types\/questions"}],"author":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/comments?post=15840"}],"version-history":[{"count":0,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/questions\/15840\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/media?parent=15840"}],"wp:term":[{"taxonomy":"disciplines","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/disciplines?post=15840"},{"taxonomy":"paper_types","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/paper_types?post=15840"},{"taxonomy":"tagged","embeddable":true,"href":"https:\/\/www.writemyessays.app\/blog\/wp-json\/wp\/v2\/tagged?post=15840"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}