MySQL

Create a simple PHP login page which will allow to create a new username and password and then log in as that username and password.  

Submit:  1. SQL script to create table that will store usernames and passwords 

2. PHP script with embedded SQL performing the task above

Paper on Sql Injection

 

Write an essay discussing sqlmap, an automated tool for sql injection and database takeover in 500 words or more. Why do we need an automated tool for sql injection? 

Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. 

Write in essay format not in outline, bulleted, numbered or other list format.  

Use the five paragraph format. Each paragraph must have at least five sentences. 

Include an interesting meaningful title.

Include at least one quote from each of 3 different articles. Use the Research Databases available from the Danforth Library, not Google.    P lace the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be one  full sentence (no more, no less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas. Each quote must be cited in-line and at the end. 

Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations). Write in essay format not in bulleted, numbered or other list format. 

It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your submission Do not use spinbot or other word replacement software. Proof read your work or have it edited. Find something interesting and/or relevant to your work to write about.  Please do not submit attachments unless requested.

Week 7 Discussion and Assignement

Discussion:
This week we focus on some additional terms for IT users.  This week lets discuss what a community of practice is.   Why are they important and how can they impact the culture within an organization?

Exercise:

1. What privacy concerns could be raised by collaborative technologies such as Waze?

2.  Write up an example of how IoT might provide a business with a competitive advantage.

Chapter 11:
Review the employment challenge in the digital era (as well as the entire chapter).  Reflect on the various challenges are present in the digital era.  Will things get better or more complicated as times goes on?  Explain.  What are some methods to assimilate new generations into the workforce to think about competitive advantage? 

create a tikz graphs based on attached pictures

create a tikz based on attached pictures.

 Make sure all the content is in one tikzpicture environment.  Do
         not create more than one tikzpicture environment.
         b. Do not use section heading (section{…}) for any text.

1.a: The black words and red words in the green box should be aligned:
         one red symbol under each word, you can use a tabular environment for
         this.  Same for the last box with black and blue text.
        .

1.b:  The three boxes in the bottom row should still be aligned in one row.

2: The “axis labels” (search/discover/structured data/etc) should be
         where they are in the original picture.  And the labels should be in
         one node (Search (goal-oriented) in one node, Discover (opportunistic)
         in another node, etc)

online discussion

 

There are many ways to misrepresent data through visualizations of data. There are a variety of websites that exist solely to put these types of graphics on display, to discredit otherwise somewhat credible sources. Leo (2019), an employee of The Economist, wrote an article about the mistakes found within the magazine she works for. Misrepresentations were the topic of Sosulski (2016) in her blog. This is discussed in the course textbook, as well (Kirk, 2016, p. 305).

After reading through these references use the data attached to this forum to create two visualizations in R depicting the same information. In one, create a subtle misrepresentation of the data. In the other remove the misrepresentation. Add static images of the two visualizations to your post. Provide your interpretations of each visualization along with the programming code you used to create the plots. Do not attach anything to the forum: insert images as shown and enter the programming code in your post.

When adding images to the discussion board, select the plus sign in the toolbar, then choose the image from your files.

 

This is the data to use for this post: Country_Data.csv

Before plotting, you must subset, group, or summarize this data into a much smaller set of points. Include your programming code for all programming work. It would be more likely that one would win a multi-million dollar lottery than plot the same information the same exact way. However, if you have, you will need to repost and make your post unique. The first post to provide the content does not need to change.

References

Kirk, A. (2016). Data visualisation: A handbook for data driven design. Sage.

Leo, S. (2019, May 27). Mistakes, we’ve drawn a few: Learning from our errors in data visualization. The Economist. https://medium.economist.com/mistakes-weve-drawn-a-few-8cdd8a42d368

Sosulski, K. (2016, January). Top 5 visualization errors [Blog]. http://www.kristensosulski.com/2016/01/top-5-data-visualization-errors/

Considerations for every forum:

Remember your initial post on the main topic must be posted by Wednesday 11:59 PM (EST). Your 2 following posts, discussing and interacting with peers’ posts must be completed by Sunday at 11:59 PM (EST). 

Your initial post should include your references, thoroughly present your ideas, and provide evidence to support those ideas.  A quality peer response post is more than stating, “I agree with you.” State why you agree with your classmate’s post. Use the purpose of the forum is to generate discussion. 

No credit will be earned for posts that are disrespectful or not on the topic of the forum.

An example post:

The factual and misrepresented plots in this post are under the context that the visualizations represent the strength of the economy in five Asian countries: Japan, Israel, and Singapore, South Korea, and Oman. The gross domestic product is the amount of product throughput. GDP per capita is the manner in which the health of the economy can be represented.

The visual is provided to access the following research question:

How does the health of the economy between five Asian countries: Japan, Israel, and Singapore, South Korea, and Oman, compare from 1952 to 2011?

gdpPerCapitaGDP

The plot titled with “GDP per Capita” is the true representation of economic health over the years of the presented countries. Japan consistently has seen the best economic health of the depicted countries. Singapore and South Korea both have large increases over the years, accelerating faster than the other countries in economic health. Oman saw significant growth in the years between 1960 and 1970, but the growth tapered off. All of the countries saw an increase in health over the provided time frame, per this dataset. Israel saw growth, but not as much as the other countries.

The plot titled without “per capita” is only GDP and does not actually represent economic health. Without acknowledging the number of persons the GDP represents, Japan is still the leading country over the time frame and within the scope of this dataset. Singapore’s metrics depict some of the larger issues of representing the GDP without considering the population. Instead of Singapore’s metrics depicting significant growth and having a level of health competitive with Japan in the true representation, Singapore has the fourth-smallest GDP. It indicates that Singapore’s economy is one of the least healthy amongst the five countries.

The programming used in R to subset, create, and save the plots:

# make two plots of the same information - one misrepresenting the data and one that does not
# use Country_Data.csv data
# plots based on the assumption the information is provided to represent the health of the countries' economy compared to other countries
# August 2020
# Dr. McClure



library(tidyverse)
library(funModeling)

library(ggthemes)

—————– Coding removed due to issues with students reposting the example post in prior courses —————–
You are required to post your code on the discussion, despite the removal in this example.

Your peers and I should be able to copy and paste your code into RStudio to render your graphics.

——————————————————————————————————————————————–

# save each plot with a transparent background in the archive image folder 
ggsave(filename = "PerCapita.png",
      plot = p1,
      bg = "transparent",
      path = "./code archive/_images")
ggsave(filename = "GDP.png", 
      plot = p2,
      bg = "transparent",

Building an AI machine/Deep learning application

Part 1 –

Following is the link of the Project 

1. Iris Data Set

24 Ultimate Data Science (Machine Learning) Projects to Boost Your Knowledge and Skills (& Can be Accessed Freely)

Run the code several times and show the intended output…you also need to EXPLAIN the output…

You will also need to provide output for the following:

Python file containing your code…

Dimensions of the data…

Sample of the data…

Statistical summary of the data…

Class distribution…

One univariate and one multivariate diagram…

Decision Tree…explain the best depth and why?…

Results of training and new data, 80%-20% split…

Accuracy report…what is it telling us?…

Confusion matrix…what is it telling us?…

Classification report…what is it telling us?…

Results of training and new data, 50%-50% split…

Accuracy report…what is it telling us?…

Confusion matrix…what is it telling us?…

Classification report…what is it telling us?…

Part 2 – Updated Code…

Now that you have a working base of code, let’s apply it to a “real world” scenario…

Find an article or video that shows a potentially SIMILAR usage of the application you created in Part 1…

Update the original application so that it “works” for the NEW application…

In this “Movie Recommendation” project, you might find an article on “book recommendations” …you would then update the original program to handle the new scenario…

YOU MUST UPDATE THE ORIGINAL CODE…do not provide entirely new code base.

Run the code several times and show the intended output…you also need to EXPLAIN the output…

You will also need to provide the same output for THIS application, as you did for the ORIGINAL application…specifically:

Python file containing your code…

Dimensions of the data…

Sample of the data…

Statistical summary of the data…

Class distribution…

One univariate and one multivariate diagram…

Decision Tree…explain the best depth and why?…

Results of training and new data, 80%-20% split…

Accuracy report…what is it telling us?…

Confusion matrix…what is it telling us?…

Classification report…what is it telling us?…

Results of training and new data, 50%-50% split…

Accuracy report…what is it telling us?…

Confusion matrix…what is it telling us?…

Classification report…what is it telling us?…

Methods of Analysis

 Have you ever felt that there is a disconnect between scholarly research and practical application? While this research took place quite a while ago, Parnin and Orso (2011) identified that in thirty years of scholarly research on debugging programming code there were five research papers that included participants to test the theories.

Think about that for a minute. How do you generate research results, without analysis? What constitutes testing the results?

  • For this week’s discussion find a scholarly research article available in the University of the Cumberlands’ library and less than 10 years old.
  • The article you identify must include research that is practically applicable. (The research article must not be theoretical in nature.)
  • The research must include everything you would need in order to repeat the research.
  • The research must include testing the research with participants, other than the authors of the article. For example, the five research articles Parnin and Orso (2011) identify in their research. The participants do not need to be people; they could be parts, equipment, or products.

Once you find this scholarly research article discuss the following in your post:

  • Briefly identify the objective of the research in the selected article.
  • How was the data tested? What are the assumptions of this test? Is that information in the article? Were there enough participants to make the results meaningful?
  • What about this research separates it from research that does not include participants?
  • In the context of the research article, did the use of participants reduce or increase the generalizability when compared to theoretical research? Is that good or bad? Why or why not?

Data Analysis

https://lionbridge.ai/datasets/10-open-datasets-for-linear-regression/
– https://careerfoundry.com/en/blog/data-analytics/where-to-find-free-datasets/
OR ANY REPUTABLE SOURCE OF DATA.
Write a 2 page (minimum) paper.  In the paper, define the problem that you are analyzing.  What is the question that you want to be answered from the data?  What is your hypothesis?
25%:  Analysis of the dataset (explain the data and also perform a statistical analysis).  Speak to which features you kept and why. 
25%: Use the techniques learned in this class and discover at least 1 “AHA” in the data.  By that, I mean that I expect you to discover a relationship between two variables or an INSIGHT into the data.  Explain your findings.
25%: Define which visualization(s) you choose to use and why you chose them.  I expect the visualizations to be professional and readable by themselves without references to anything else.  (I am not going to be looking through your data to try to understand your visual).  Attach your visuals to the end of the document.  Create a Tableau Story that combines your visuals and provide the link to it in the document.
15%: Summarize your work from a social or business perspective.  Why is this important?  How could this insight be used to make a difference?
CITE YOUR SOURCES and add them to the end of your paper.  (I recommend citefast.com.  You can cite all of your sources there and export to word and just add it to the end of your paper.)
In summary – you will turn in:
A 2-page Analysis
A page (or 2) of Visualizations
A list of your sources/references