Information Technology and Organizational Learning: Two pages write up

Explain the five key lessons and note the importance of each key lesson from chapter 1.  Also, note why is it important to understand these basic concepts. 

Note why the IT organizational structure is an important concept to understand.  Also, note the role of IT in the overall business strategy.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

CIS275, Lab Week 6,

USE IMDB    — ensures correct database is active

GO

PRINT ‘|—‘ + REPLICATE(‘+—-‘,15) + ‘|’

PRINT ‘Read the questions below and insert your queries where prompted.  When  you are finished,

you should be able to run the file as a script to execute all answers sequentially (without errors!)’ + CHAR(10)

PRINT ‘Queries should be well-formatted.  SQL is not case-sensitive, but it is good form to

capitalize keywords and table names; you should also put each projected column on its own line

and use indentation for neatness.  Example:

   SELECT Name,

          CustomerID

   FROM   CUSTOMER

   WHERE  CustomerID < 106;

All SQL statements should end in a semicolon.  Whatever format you choose for your queries, make

sure that it is readable and consistent.’ + CHAR(10)

PRINT ‘Be sure to remove the double-dash comment indicator when you insert your code!’;

PRINT ‘|—‘ + REPLICATE(‘+—-‘,15) + ‘|’ + CHAR(10) + CHAR(10)

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 1  [3pts possible]:

Write the query to display the name and year of birth for all people born after 1980, who have

directed at least one show (i.e. those who appear at least once in the title_directors table).

Limit results to those who have died (who have a value in the deathYear column).

Columns to display:    name_basics.primaryName, name_basics.birthYear

Format name_basics.primaryName as 25 characters wide and sort in descending order by birth year.

Correct results will have 50 rows and will look like this:

Name                      birthYear

————————- ———–

Anthony Conti             2000

Amanda Todd               1996

Daniel W. Ridge           1996

Nick Louvel               1981

Seth Gimlan               1981

Shane Ballard             1981

‘ + CHAR(10)

— [Insert your code here]

GO

PRINT ‘CIS2275, Lab Week 6, Question 2  [3pts possible]:

Show every genre of television show which has had at least one title with 200 episodes.

i.e. limit results to the titleType ”tvEpisode” in the title_basics table, and to titles

containing a row in the title_episode table with episodeNumber 200.

Columns to display:    title_genre.genre

Display only genre name sorted 15 characters wide, and eliminate duplicate values.

Correct results will have 26 rows and will look like this:

Genre

—————

Action

Adult

Adventure

Talk-Show

Thriller

War

‘ + CHAR(10)

GO

— [Insert your code here]

GO

PRINT ‘CIS2275, Lab Week 6, Question 3  [3pts possible]:

Write a common table expression to identify the WORST shows: join title_basics against title_ratings

and limit your results to those with an averageRating value equal to 1.  Project the title,

type, and startYear from title_basics; and label your CTE as BADSHOWS.

In the main query, show a breakdown of BADSHOWS grouped by type, along with the total number of

rows for each (i.e. GROUP BY titleType)

Columns to display:    titleType, COUNT(*)

Sort results in descending order by COUNT(*).

Correct results will have 10 rows and will look like this:

titleType    TOTAL_BAD_SHOWS

———— —————

tvEpisode    314

video        74

tvMiniSeries 7

tvShort      2

videoGame    2

‘ + CHAR(10)

GO

— [Insert your code here]

GO

PRINT ‘CIS2275, Lab Week 6, Question 4  [3pts possible]:

Identify the least popular professions.  Show each profession value from the name_profession table,

along with the total number of matching rows (GROUP BY profession).  Use the HAVING clause to limit

your results to professions with less than 1,000 rows.

Columns to display:    name_profession.profession, COUNT(*)

Correct results will have 3 rows formatted nicely:

Profession                     TOTAL_PEOPLE

—————————— ————

electrical_department          1

production_department          1

script_department              1

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 5  [3pts possible]:

Use the query from #4 above to display the names of all people belonging to these professions.

Use the previous query as a subquery in the WHERE clause here to limit the results.

Columns to display:    name_basics.primaryName, name_profession.profession

Sort results in descending order by primaryName.

Correct results will have 3 rows formatted nicely:

Name                 Profession

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

Leonardo Aquilini    production_department         

Eddie A. Reid IV     electrical_department         

Andrea Devaux        script_department             

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 6  [3pts possible]:

Show the name of every writer, along with the total number of titles they”ve written (i.e. rows in the 

title_writers table).  Limit results to those who have written between 5,000 and 10,000 titles (inclusive).

Columns to display:    name_basics.primaryName, COUNT(*)

Sort results in descending order by primaryName.

Correct results will have 9 rows formatted nicely. You”re on your own to find out which rows they are.

———————————————————————————————-

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 7  [3pts possible]:

Show the actor and character names for everyone who has performed the same role in more than one

show with the title ”Battlestar Galactica”.  i.e. identify the combination of (primaryName, characters)

which occurs in the title_principals table more than once for matching titles.

Columns to display:    name_basics.primaryName, title_principals.characters, COUNT(*)

Sort results in ascending order by primaryName.

Correct results will have 4 rows formatted nicely.  Hope you get the same ones I got.

———————————————————————————————-

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 8  [3pts possible]:

Identify the names of people who have directed more than five highest-rated shows (i.e. title_ratings.averageRating = 10).

For each of these people, display their names and the total number of shows they have written.

Columns to display:    name_basics.primaryName, COUNT(*)

Sort results in descending order by primaryName.

This time you”re on your own to also see how big the result set is (Hint: it is somewhere between 5 and 25).

———————————————————————————————-

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 9  [3pts possible]:

Display the title and running time for all TV specials ( titleType = ”tvSpecial” ) from 1982; if the run time is

NULL, substitute zero.

Columns to display:    title_basics.primaryTitle, title_basics.runtimeMinutes

Sort in descending numerical order by the resulting calculated run time value.

———————————————————————————————-

‘ + CHAR(10)

— [Insert your code here]

GO

GO

PRINT ‘CIS2275, Lab Week 6, Question 10  [3pts possible]:

Identify every movie from 1913 (startYear = 1913, titleType = ”movie”); limit your results to those with a non-NULL value

in the runtimeMinutescolumn.  For each movie, display the primaryTitle and the averageRating value from the title_ratings table.

Use DENSE_RANK() to display the rank based on averageRating (label this RATINGRANK), and also the rank based on runtimeMinutes

(label this LENGTHRANK).  Both of these should be based on an asecending sort order.

Columns to display:    title_basics.primaryTitle, title_ratings.averageRating,

                       RATINGRANK, LENGTHRANK

Sort results in ascending order by primaryTitle.

———————————————————————————————-

‘ + CHAR(10)

— [Insert your code here]

GO

GO

————————————————————————————-

— This is an anonymous program block. DO NOT CHANGE OR DELETE.

————————————————————————————-

BEGIN

    PRINT ‘|—‘ + REPLICATE(‘+—-‘,15) + ‘|’;

    PRINT ‘ End of CIS275 Lab Week 6’ + REPLICATE(‘ ‘,50) + CONVERT(CHAR(12),GETDATE(),101);

    PRINT ‘|—‘ + REPLICATE(‘+—-‘,15) + ‘|’;

END;

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

advantages and disadvantages of having interactivity in data visualizations?

Q 1: What are the advantages and disadvantages of having interactivity in data visualizations?  Provide at least three advantages and three disadvantages.  Why do you consider each an advantage and disadvantage? – 1-2pages.

Q2: For this discussion, please use your weekly readings to compose a response to the following prompt/question(s):

 

Graph 2 (You must select a different graph than one that you have previously discussed)

 

Select a data presentation from chapter 6 of the text (Grey Section).

 

Answer the following:

 

What is the visual that you selected?

What is the purpose of the visual?

What kind of data should be compiled in the selected visual?

What kinds of data should not be compiled in the selected visual?

How can you avoid making the visual misleading? – 1-2 pages.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

How IT professionals and especially leaders must transform their thinking to adapt to the constantly changing organizational climate.

Chapter 10 – Review the section on the IT leader in the digital transformation era.  Note how IT professionals and especially leaders must transform their thinking to adapt to the constantly changing organizational climate.  What are some methods or resources leaders can utilize to enhance their change attitude?

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Natural Language Processing (NLP)_Task_Jupyter_Notebook

 INTRODUCTION TO THE TASK!   
 This Capstone Project is about a basic form of Natural Language Processing (NLP) called Sentiment Analysis. For this task, you are required to use two different neural networks in Keras to try and classify a book review as either positive or negative, and report on which network type worked better. For example, consider the review, “This book is not very good.” This text ends with the words “very good” which indicates a very positive sentiment, but it is negated because it is preceded by the word “not”, so the text should be classified as having a negative sentiment. We need to teach our neural network to recognise this distinction and be able to classify the review correctly. This problem can be broken down into the following steps:   
 Get the dataset 2. Preprocessing the Data   3. Build the Model   4. Train the model   5. Test the Model   6. Predict Something    
 We will be working with real-world data in this task.   
 GET THE DATASET   
 For this task, we will be using a small portion of the Multi-Domain Sentiment Dataset, which contains product reviews from Amazon. The full dataset contains reviews for products under the categories: kitchen, books, DVDs, and electronics, but we will only be looking at reviews for the book category.   
 We have two files, positive.txt and negative.txt, containing the reviews. Each review is associated with a number of fields. The only field we are interested in is the “title” field, which contains the title of the review. We are going to use this title to predict the sentiment of the review. We could have used the review text itself, however, as this is a lot longer than the title, this is a much harder task.   
 For example, a review title might be “Horrible book”, whilst the review text might be “This book was horrible. If it was possible to rate it lower than one star I would have.”   
 Both the review title and the review text have the same sentiment — the title is just much more concise, which makes this task easier.   
 While some sentiments are easy to classify, like “don’t buy this horrible book”, others are less straightforward, like “’run don’t walk to buy this book”. The latter is hard to classify because it contains the word “don’t”, which might be seen as an indication that this is a negative review, whereas actually, it is a positive one (the reviewer is suggesting that you should go as fast as you can to get the book). Thus, sentiment analysis is not always straightforward — some samples will be easy to classify, while others will not.   
 Some code is already included in the notebook associated with this task to start you off, which loads the relevant part of the data (the review heading) and performs some preliminary preprocessing to remove strange characters.   
 It also is necessary to create a vocabulary (called a text corpus) — words which our neural network will know and to “tokenise” the input. If we have a review, such as “a good book”, it is necessary to turn this into a form that a computer can understand. First, each word in the dataset is mapped to a unique number in the vocabulary. A word tokeniser will then take a sentence like this and convert it to a sequence of numbers, which map to the relevant words in the vocabulary.   
 Eg: “a good book” becomes an array of numbers: [1, 12, 3]. This mapping means that “a” is the first word in the vocabulary, “good” is the twelfth and “book” is the third. This mapping depends on the dataset supplied to the tokeniser.   
 The code for tokenisation is already included, but it is important that you understand what it does.
 PREPROCESSING THE DATA   
 n order to feed this data into our network, all input reviews must have the same length. Since the reviews differ heavily in terms of lengths, we either need to trim or pad the reviews so that they are the same length. For this task, we will set the length of reviews to the mean length, which is around 4 words. If reviews are shorter than 4 words we will need to pad them with zeros, if they are longer than 4 words we will trim them to this length by cutting off any words after this. Keras offers a set of preprocessing routines that can do this for us. In order to pad our reviews, we will need to use the pad_sequences function   
 BUILD THE MODEL   
 In the task today you will need to build a recurrent neural network to classify sentiment. The network will need to start with a special layer which will assist with text classification through a process called embedding.   
 Word embedding is a class of approaches for representing words and documents using dense vectors where a vector represents the projection of the word into a continuous vector space (Brownlee, 2017).   
 The position of a word within the vector space is learned from the text and is based on the words that surround the word when it is used. The position of a word in the learned vector space is referred to as its embedding.   
 Keras offers an embedding layer, used for neural networks on text data, and requires that the input data be integer encoded, so each word is represented by a unique integer (Brownlee, 2017). We have already achieved this format through tokenisation.   
 The embedding layer is trained as a part of the neural network and will learn to map words with similar semantic meanings to similar embedding-vectors. It is initialised with random weights and will learn an embedding for all of the words in the training dataset (Brownlee, 2017).   
 The Embedding layer is defined as the first hidden layer of a network. It must have three arguments (Keras Team, 2020):   
 ● input_dim: This is the size of the vocabulary in the text data. For example, if your data is integer encoded to values between 0-5000, then the size of the vocabulary would be 5001 words.   
 ● output_dim: This is the size of the vector space in which words will be embedded. It defines the size of the output vectors from this layer for each word. For example, it could be 32 or 100 or even larger. This is a hyper-parameter that needs to be tuned — test different values for your problem.   
 ● input_length: This is the length of input sequences, as you would define for any input layer of a Keras model. For example, if all of your input documents are comprised of 4 words, this would be 4. This is the length which we padded/trimmed the inputs to during pre-processing.
  Build a neural network, as outlined below.   
 ● A recurrent neural network. This type of network is commonly used in NLP. This network should       have the following architecture:   
 Embedding layer   SpatialDropout1D(0.2)   BatchNormalization()   LSTM(32)   Dense(2, activation=’softmax’)
 TRAIN AND TUNE THE MODEL   
 You are now ready to train your model. Remember to compile your model by specifying the loss function and optimizer we want to use while training, as well as any evaluation metrics we’d like to measure — set the optimizer to ‘adam’ and the loss function to ‘binary_crossentropy’.   
 Once compiled, you can start the training process. Note that there are two important training parameters that we have to specify, namely batch size and the number of training epochs. Together with our model architecture, these parameters determine the total training time.   
 For the network:   ● Set the number of epochs to train for to 5 and batch size to 10.   ● Tune the output_dim hyper-parameter of the embedding layer. Try values: 10, 25, 50 and 100. Report on the performance metrics for each value.   ● Select the output_dim which gives the best performance on the test set and plot a graph of both the accuracy and loss of the model while training. Use these graphs to determine the point at which the model starts to overfit or if it has not yet converged. Identify a more optimal number of epochs to train for.   ● You can also try tuning other metrics — such as batch size — to get the best possible performance.   ● Report on the performance metrics of the final model.   
 MAKING PREDICTIONS   
 Finally, we would like to be able to use our model to predict something. To do this, we need to translate the sentence into the relevant integers and pad as necessary. This will allow us to put it into our model and see whether it predicts if we will like or dislike the book. A small selection of samples has been provided to get you going — you are welcome to add to this.   
 
 
 
 
 
 Compulsory Task   
 A notebook is associated with this task, which contains some useful functions/code to get you started.   
 Follow these steps:   
 ● Use the provided files positive.txt and negative.txt and follow the above steps to train a recurrent neural network. Your goal is to classify the sentiment of book reviews as positive or negative.   
 ● Note: Some blocks of code are labelled do not modify — make sure that the code in these blocks is left alone, or else you will encounter issues. Do read through it and see if you can follow what it does.   
 ● When complete, create basic point form summary of file file in which you describe your project in detail.   

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Intro to Networking: Assignment 1

Submit these answers as a single Word document. APA style with references. 100% original work. no plagiarism.

Answer the following questions:

1. Map the layers of the TCP/IP model to the OSI model

2. Each layer of OSI has a body/group that is responsible for the standards, please name them

3. Describe the progression through the OSI model of the following:

  – A web browser request and connection to www.cnn.com

  – An email being sent from Outlook on a Windows machine from your APUS email account to [email protected]

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

SOFTWARE MANAGEMENT -4

1. Using Microsoft Project, add a project start time of 0 (or January 1) and a required project completion time of 180 days, calculate the ES, EF, LS, and LF times and total slack for each activity. If your calculations result in a project schedule with negative total slack, revise the project scope, activity estimated durations, and/or sequence or dependent relationships among activities to arrive at an acceptable baseline schedule for completing the project within 180 days. Describe the revisions you made.

Responses could be presented in a network diagram or in the schedule table format. The project should finish in 180 days. If the original plan is not completed by 180 days, the responses should describe what tasks were revised to meet the required completion date.

2. Determine the critical path and identify the activities that make up the critical path.

Responses can be presented in a list of activity names, highlighted in the network diagram, or highlighted in the schedule table.

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

SOFTWARE – ASSIG

 

Why is project scope management so challenging in IT projects? And What suggestions do you have for preventing scope creep in projects? Go to following PMI site  and review top 5 causes of Scope Creep for more information.

https://www.pmi.org/learning/library/top-five-causes-scope-creep-6675

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Physical Science -4

 Question #1. Watch the video titled “Video Tour of the Electromagnetic Spectrum” (5 min 03 s). Be prepared to discuss.
Video Source: NASA. (2012, June 20). Video Tour of the Electromagnetic Spectrum [Video file]. Retrieved from . 

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now

Software System Design feb 3

In the folder, CS 620 Software Systems Design – Power Points, you will see a document called “NCCA Write Up”…for this assignment, you are to read the document carefully and create a CONTEXT DFD…make sure you review what a Context DFD diagram is…

Take your time…do this a piece at a time…remember, this is an ITERATIVE process…so making changes is to be expected…

REMEMBER: YOU MUST USE THE NOTATION WE USED IN CLASS…I WILL NOT ACCEPT ANY OTHER NOTATION!…

Needs help with similar assignment?

We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper

Get Answer Over WhatsApp Order Paper Now