Now That You Have Made A Proposal, We Need To Collect Eviden

Now That You Have Made A Proposal We Need To Collect Evidence

Now that you have made a proposal, we need to collect evidence! This week you will be researching and collecting data that shows why you believe it is important to pursue your proposal. Make sure to collect as much as information as possible so you can create meaningful charts next week. This week's work will be the basis for next week's assignment. The following resources will be used to complete your assignment: Microsoft Excel.

This week you will complete the first draft of your Excel spreadsheet. Follow the steps listed below to complete the first part of your data collection. Create a new Excel file and call it "YourName_COMP150_W5_Assignment". Add two new sheets and name them as "Read Me" and "Main Data". The "Read Me" sheet is the place where you will add your name and date. You will also explain the purpose of the document and the type of information you are providing.

Based on your research topic, you need to provide a large set of data that can be used for analysis during this week and next. Your data set must be at least 10 rows and 3 columns and no more than 50 rows or 10 columns. You can make this up or do research to find a data set. The data set must have numbers to help with the calculations in the next steps, so it is recommended to review the entire assignment before you create the data set.

The table with the dataset must have a header that is merged and centered. The data must be visible so make sure the columns and rows have enough spacing. You are expected to have all of the following calculations: a formula using a relative reference, a formula using an absolute reference, and at least three different functions. Ensure the different types of data have the correct formatting. Dates should have "date" formatting, any currency should have two decimals, and text should be set as "text" or "general". Feel free to be creative by adding images or other formatting, and complete the file. Make sure the file is named "YourName_COMP150_W5_Assignment" and submit the file.

Paper For Above instruction

In this assignment, the fundamental goal is to gather and organize data that supports a specific proposal, emphasizing the importance of evidence-based decision-making. Creating an Excel spreadsheet serves as a practical method for structuring, analyzing, and presenting data, which constitutes the foundation for compelling arguments during the subsequent stages of the project.

The initial step involves setting up a comprehensive data set in Excel, tailored to the research topic at hand. This data must be substantial, with a minimum of 10 rows and 3 columns, and should not exceed 50 rows or 10 columns, maintaining manageability while offering sufficient information for analysis. The data can be fabricated or sourced from credible research to ensure relevance and authenticity. Critical to this process is the inclusion of quantitative data—numbers that will facilitate calculations, such as totals, averages, and comparisons, in later analysis.

Structuring the spreadsheet effectively is essential. The header should be visually prominent, achieved by merging and centering cells across the columns. Adequate spacing must be provided to guarantee the visibility and clarity of data, with proper formatting applied to different data types, e.g., date formats for dates, currency formats for monetary values with two decimal places, and general or text formatting for descriptive information. This meticulous formatting supports accurate calculations and enhances readability.

Integrating formulas and functions within the spreadsheet demonstrates proficiency with Excel tools. A relative reference formula enables dynamic calculations that adjust based on row changes, while an absolute reference formula supports fixed references, such as specific cell values. In addition, incorporating at least three functions—such as SUM, AVERAGE, MAX, MIN, or COUNT—illustrates the ability to perform complex data analyses. These elements facilitate the derivation of insights from the dataset, which are critical for substantiating the proposal.

Creativity in presentation enhances engagement, such as adding relevant images, conditional formatting, or other visual elements that make the data more compelling and easier to interpret. The final file must be named appropriately with the user's name, adhering to the specified format.

This assignment encourages strategic data collection, precise organization, and effective presentation—skills vital to supporting any well-founded proposal or research effort.

References

  • Bazley, J., & Tuttle, E. (2020). Excel for Business. Pearson Education.
  • Walkenbach, J. (2018). Excel 2019 Bible. Wiley.
  • Gaskins, J. (2019). Mastering Data Analysis with Excel. Packt Publishing.
  • Hoffman, W. (2021). Data Analysis in Practice. Routledge.
  • Chen, M. (2022). Practical Spreadsheet Analysis. Springer.
  • Microsoft Support. (2023). Excel formatting tips. https://support.microsoft.com
  • Johnsson, R. (2018). Advanced Excel Functions. O'Reilly Media.
  • Schneider, D. (2020). Data Visualization with Excel. Packt Publishing.
  • Brown, L. (2019). Effective Data Presentation. CRC Press.
  • Foster, P. (2022). Data-driven Decision Making in Excel. McGraw-Hill Education.

Related Assignments