This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with societal values. You’ll apply statistical time series modeling techniques to identify patterns and develop time-dependent demand models. You’ll practice organizing and delivering a presentation to senior decision-makers. The PowerPoint presentation includes an audio component in addition to speaker notes.

Resource: Microsoft Excel®, DAT565_v3_Wk6_Data_File

Scenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time-consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid.

You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city.

Instructions: Work with the provided Excel database. This database has the following columns:

• LotCode: A unique code that identifies the parking lot
• LotCapacity: A number with the respective parking lot capacity
• LotOccupancy: A number with the current number of cars in the parking lot
• TimeStamp: A day/time combination indicating the moment when occupancy was measured
• Day: The day of the week corresponding to the TimeStamp
• Insert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%).
• Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected?
• Using the OccupancyRate and LotCode columns, construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates? Are some parking lots more frequented than others? Is this what you expected?
• Select any 2 parking lots. For each one, prepare a scatter plot showing the occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time-dependent? If so, which times seem to experience the highest occupancy rates? Is this what you expected?

Presentation:

Create a 10- to 12-slide presentation with speaker notes and audio. Your audience is the City Council members who are responsible for deciding whether the city invests in resources to set in motion the smart parking space app.

Complete the following in your presentation:

• Outline the rationale and goals of the project.
• Utilize boxplots showing the occupancy rates for each day of the week. Include your interpretation of the results.
• Utilize box plots showing the occupancy rates for each parking lot. Include your interpretation of the results.
• Provide scatter plots showing occupancy rate against the time of day of your selected four parking lots. Include your interpretation of the results.
• Make a recommendation about continuing with the implementation of this project.

ESSAY TOPIC

When you’re a single mother, you often do things a little differently as you support yourself, your child, and your loved ones. For this scholarship application, we want to hear how you make it work.

If you’re a single mother in school, how do you juggle caring for your little one with pursuing a degree and everything else you do? How do you make ends meet financially? Have you thought about dropping out? What keeps you motivated to complete your degree? What do you find most challenging about the experience? What do you find most rewarding about the experience? What are your favorite moments with your little one?

If you’re the child or loved one of a single mother, how has this changed your life? What is your relationship to them? How does having a single mother or being close to a single mother affect your day-to-day and the way you think about your future?

We also want to hear about your dreams. Where do you see yourself in the future? What is your dream career? What are you doing right now to get there? How would winning the scholarship help you achieve your goals?

The purpose of this assignment is to execute key steps in the mobile app planning and design process and to explain how mobile technology and apps can be used to drive business results and create competitive advantage.

Part 1 – Review How to Build a Mobile App Requirements Document

Before working on the assignment, review the “How to Build a Mobile App Requirements Document,” https://clearbridgemobile.com/how-to-build-a-mobil… located in the study materials, to learn the process of designing a mobile app. The PowerPoint presentation you will create for this assignment should include the following:

1. Business requirements, mobile app objectives, and product vision statement.
2. Target audience and user journey.
3. List of features.
4. Monetization model.
5. Product and technical specification.
6. Platforms for which the app is being developed.
7. Maintenance and upgrade requirements.
8. Dependencies, assumptions, constraints, and submission.
9. Explanation of how the app could create a competitive advantage for the organization.
10. Discussion on how tenets of servant leadership and conscious capitalism can be applied to the project to use business as a force for good to improve society and help communities prosper.
11. Documentation of sources: correct citation of research references in APA reference format.

Part 2 – Choosing a Sustainable Development Goal

One of the key principles of the Colangelo College of Business is that business is a force for good to improve society and help communities prosper. For this assignment, consider the GCU’s “Statement on the Integration of Faith and Work,” https://www.gcu.edu/sites/default/files/media/Docu… located in the study materials, and the tenets of servant leadership, conscious capitalism, and the sustainable development goals described in “Measuring Progress Towards the Sustainable Development Goals,” also located in the study materials.

Select a sustainable development goal from the list of sustainable development goals located in the study materials. Choose a goal that you would like to promote. Here is the list of sustainable development goals:

1. End poverty in all its forms everywhere.
2. End hunger, achieve food security and improved nutrition, and promote sustainable agriculture.
3. Ensure healthy lives and promote well-being for all at all ages.
4. Ensure inclusive and quality education for all and promote lifelong learning.
5. Achieve gender equality and empower all women and girls.
6. Ensure access to water and sanitation for all.
7. Ensure access to affordable, reliable, sustainable and modern energy for all.
8. Promote inclusive and sustainable economic growth, employment, and decent work for all.
9. Build resilient infrastructure, promote sustainable industrialization, and foster innovation.
10. Reduce inequality within and among countries.
11. Make cities inclusive, safe, resilient, and sustainable.
12. Ensure sustainable consumption and production patterns.
13. Take urgent action to combat climate change and its effects.
14. Conserve and sustainably use the oceans, seas, and marine resources.
15. Sustainably manage forests, combat desertification, halt and reverse land degradation, and halt biodiversity loss.
16. Promote just, peaceful, and inclusive societies.
17. Revitalize the global partnership for sustainable development.

Part 3 – Creating the PowerPoint Presentation

Imagine that your company is partnering with the United Nations to plan and design a mobile app as part of an initiative to fundraise and increase awareness about your selected sustainable development goal.

Create a PowerPoint presentation (10 slides minimum) that includes the following:

1. Outlines the development plan and design specifics of the mobile app.
2. Explains how the app can be used to drive business results and create business as a force for good.
3. Includes speaker notes to provide details about the content of each slide.
4. Includes discussion of the importance of business being a force for good to improve society and help communities prosper.
5. Includes how the tenets of servant leadership and conscious capitalism can be applied to the project to ensure this is appropriate.

Submit the Microsoft PowerPoint presentation file only. Do not submit any other file format, such as an Adobe PDF file, or you will not earn full credit.

Refer to the resource, “Creating Effective PowerPoint Presentations,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

General Requirements

While APA style is not required for the body of this assignment, solid academic writing is expected, and documentation of sources should be presented using APA formatting guidelines, which can be found in the APA Style Guide, located in the Student Success Center.

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

I don’t understand this question and need help to study.

Is due process required prior to an afterschool detention? Why or why not? You must support your position with examples from case law, the U.S. Constitution, or other readings.