SQLAlchemy- STEP 2

 

  • Use Flask to create your routes.

Routes

  • /
    • Home page.
    • List all routes that are available.
  • /api/v1.0/precipitation
    • Convert the query results to a dictionary using date as the key and prcp as the value.
    • Return the JSON representation of your dictionary.
  • /api/v1.0/stations
    • Return a JSON list of stations from the dataset.
  • /api/v1.0/tobs
    • Query the dates and temperature observations of the most active station for the last year of data.
    • Return a JSON list of temperature observations (TOBS) for the previous year.
  • /api/v1.0/ and /api/v1.0//
    • Return a JSON list of the minimum temperature, the average temperature, and the max temperature for a given start or start-end range.
    • When given the start only, calculate TMIN, TAVG, and TMAX for all dates greater than and equal to the start date.
    • When given the start and the end date, calculate the TMIN, TAVG, and TMAX for dates between the start and end date inclusive.

Hints

  • You will need to join the station and measurement tables for some of the queries.
  • Use Flask jsonify to convert your API data into a valid JSON response object.

Temperature Analysis I

  • Hawaii is reputed to enjoy mild weather all year. Is there a meaningful difference between the temperature in, for example, June and December?
  • You may either use SQLAlchemy or pandas’s read_csv() to perform this portion.
  • Identify the average temperature in June at all stations across all available years in the dataset. Do the same for December temperature.
  • Use the t-test to determine whether the difference in the means, if any, is statistically significant. Will you use a paired t-test, or an unpaired t-test? Why?

Temperature Analysis II

  • The starter notebook contains a function called calc_temps that will accept a start date and end date in the format %Y-%m-%d. The function will return the minimum, average, and maximum temperatures for that range of dates.
  • Use the calc_temps function to calculate the min, avg, and max temperatures for your trip using the matching dates from the previous year (i.e., use “2017-01-01” if your trip start date was “2018-01-01”).
  • Plot the min, avg, and max temperature from your previous query as a bar chart.
    • Use the average temperature as the bar height.
    • Use the peak-to-peak (TMAX-TMIN) value as the y error bar (YERR).

 

Daily Rainfall Average

  • Calculate the rainfall per weather station using the previous year’s matching dates.
  • Calculate the daily normals. Normals are the averages for the min, avg, and max temperatures.
  • You are provided with a function called daily_normals that will calculate the daily normals for a specific date. This date string will be in the format %m-%d. Be sure to use all historic TOBS that match that date string.
  • Create a list of dates for your trip in the format %m-%d. Use the daily_normals function to calculate the normals for each date string and append the results to a list.
  • Load the list of daily normals into a Pandas DataFrame and set the index equal to the date.
  • Use Pandas to plot an area plot (stacked=False) for the daily normals.

Excel, statistics, pivot tables, V-Loopup, correlation tables, box plots

 

Crosstabs

Using the Supermarket data set, create crosstabs for Marital Status and Annual Income expressing the counts as percentages. Then, create a stacked 2D column chart. (Select the crosstab table and insert stacked 2D column chart). If you need to swap the x and y values, then right click on the chart, click select data, and switch row/column).

Box Plots

Using the Supermarket data set, create a box plots of Annual Income and Revenue. Which of the following income brackets appears to have the least variation in revenue (purchase amounts)?

Correlations

Using the Beta Employees data set, create a table of correlations between the variables Age, Prior Experience, Beta Experience, Education, and Annual Salary. (Look at Figure 3.18 in the example 3-3 document in Module 5 (Attached Image file for illustration purposes only). It shows a table of correlations like what you would need to produce. The bottom of the table shows the formula you would use to calculate the correlations for each cell.)

Pivot

Using the Supermarket data set, create a pivot table to find how many units were sold in total in the non-consumable category.

Complete explanation via a word document and completed Excel files using the given datasets and worked solutions in separate tabs on each applicable dataset file. Visual image instruction preferred

Cloud Computing, Cybersecurity

Propose and defend a topic for your final project(Types of cloud computing services).  Write  500 words or more explaining why this topic is important for your peers to understand. Be focused and specific. Look into the general topic provided in the list in this folder to find something new and interesting to write about. You should do a deep dive into a topic.

You MUST make a statement saying exactly what your topic is. 

Use at least five sources. Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources.

Copying without attribution or the use of spinbot or other word substitution software will result in a grade of 0. 

focus on the social and organizational issues

Discussion: This week we focus on the social and organizational issues that exist with better understanding why changes occurs.  This week discuss the phases of change noted in the Linear Development in Learning Approaches section in the Information Technology and Organizational Learning text.

Your response should be 250-300 words.  Respond to two postings provided by your classmates.

Practical Connection Assignment

 

Practical Connection Assignment
At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where you will demonstrate how this course research has connected and put into practice within your own career.

Assignment: 
Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:
Provide a 500 word (or 2 pages double spaced) minimum reflection. 
Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited. 
Share a personal connection that identifies specific knowledge and theories from this course. 
Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.  
You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

Google Forms

Your company is looking for a market area for a new product/location. Your assignment is to develop, disseminate, and collect data for a survey on a topic of your choice. Assess your data and determine what the data tells you about your company/product/new location.

You are required to use Google Doc’s Form application and obtain at least 20 survey responses.

You will prepare a professional looking, written report that discusses the goals of your survey, your responses, and how this information can be useful.

You are required to do a data analysis of responses received in the survey and add it to your paper.

You are also to include the actual responses from the Form’s generator (graphic/spreadsheet).

You will attach a copy of your report to this assignment link for grading.

Your name MUST be at the top of the paper. 

Proper grammar, spelling, and sentence structure are required.

The submission should be no more than 3 pages in length.

Case Study III: Testing the Security of the Dental Office

For this case study, you will use the network design you created for the Case Study I assignment in Module 3 and your corresponding networking security strategy from the Case Study II assignment in Module 5. As the network designer, you are required to identify approaches to test the security strength of the network. Closely review the list of security measures proposed in the plan and identify the strategies through which all those security measures can be broken or compromised.

Discussion forum on chapter readings

Required text book:

Gaur, N., Desrosiers, L., Novotny, L., Ramakrishna, V., O’Dowd, A. & Baset, S. (2018). Hands-On Blockchain with Hyperledger: Building decentralized application with Hyperledger Fabric and Composer. Packt Publishing. 

Chapter-11: Hyperledger Fabric Security 

This chapter reading introduced an overview of blockchain security. 

Discussion Topic:

1.choose a security threat from Chapter 11. Then describe the impact of the chosen threat if it would be realized in a blockchain environment, and what you can do to mitigate the threat. 

2.Then think of three questions you’d like to ask other students. The questions should be taken from Chapter 11. You’re not trying to test each other, but you are trying to start a discussion.

Write 2pages document