Buy Guided BUSI 201 Group Project Part 1

Buy Guided BUSI 201 Group Project Part 1

Your pastor has learned that you are taking a course in which you are learning about Excel. He has asked your team for assistance in developing a budget for the church using Excel. He would like a budget that will not only list out the basic expenses of the church but will also allow for some advanced analysis.

Requirements:

  1. Budget (Relevant chapters – Excel 1–4, 6)
    1. Using Excel, create a budget for a church with an appealing format that will identify the income/expenses of the church. This can be a yearly budget or a monthly budget (or both).
    2. Include relevant categories, formulas, and appropriate formatting choices.
    3. Include at least 1 nested function in your spreadsheet.
    4. Do not use a template. Start from a new, blank workbook.
    5. Name this spreadsheet Budget.
  2. Chart (Relevant chapters – Excel 5, 7)
    1. Develop a chart related to the budget information.
    2. Format the chart effectively so that it is easy to read and understand and uses an appropriate chart type.
    3. Name this spreadsheet Chart.
  3. Purchase (Relevant chapters – Excel 3, 6, 8)
    1. On its own spreadsheet, consider a large purchase that the church wishes to make (e.g. a new vehicle, a building, land, etc.).
    2. Create a plan for this purchase that incorporates the following: several options for purchase, the PMT or other financial function, What-If Analyses including a Data Table, and a Scenario Summary created using the Scenario Manager that will analyze variables of your choosing.
    3. Name this spreadsheet Purchase.
  4. Members (Relevant chapters – Excel 5, 6, 8)
    1. On a new spreadsheet, create a listing of at least 50 church members and their information. This can include basic demographic fields such as name, address, small group membership, etc.
    2. Convert the data to an Excel table and apply appropriate sorting and filtering. Create a Pivot Table from this information that will emphasize data of your choosing.
    3. Name these spreadsheet Members.

Things to consider:

  1. Do the requirements need to be completed in a specific order? For example, #4 does not rely on #1–3. However, the budget does need to be completed before a chart is created from the budget data.
  2. Have you completed the assignments for the relevant chapters? This knowledge will be necessary to be successful.
  3. What is the weight of each section in the grading rubric? Focus attention on items worth more points.
  4. Are the sections equal? It will take much longer to create and format a budget than it will to create a chart.
  5. When you are finished, check your work against the grading rubric. Have you forgotten any graded components?

Want Assistance with the Projects?

Students in the State can get professional online class assistance by getting Exam Done. Assignments, discussions, quizzes, and tests are all covered by our online class help service. To assist our students, we have hired knowledgeable subject matter experts. Therefore, whether you are having difficulty with a task or want to complete your quiz, we have your back. Our online class assistants work on your project all day, every day, and solve all of your problems. Additionally, our online class service is affordable. Take advantage of our online class assistance right away to get started on the path to the grades you want!

 


Live in United States (US)
Live in Pakistan
The exam online at home is taken by professionals with extreme low pricing plans.

150+

Qualified Tutors

Get Started
Buy Guided BUSI 201 Group Project Part 1 $3.99
  • 298 Downloads
  • 3.1k Views


Pay Someone To Do Your Online Test, Online Quiz, Courses, Online Exam, and Online Classes! Enroll Now