Category: Internet technology (IT)

Overview
Now that you have been assigned a role on the team, it is your responsi

Overview
Now that you have been assigned a role on the team, it is your responsibility to make the Project Manager aware of the knowledge, skills, and abilities you bring.
Locate a job posting on indeed.com, glassdoor.com, monster.com, or other job boards and read the description of the position. This can be the same one you identified in the discussion for this week. What skills do they specifically call for in your area of expertise? These should sound familiar. This will give you an idea of what real employers are looking for now in your discipline.
Take some time to review previous assignments submitted during your time at Strayer or even deliverables you may have submitted while on the job during your time at Strayer, focusing specifically on the pieces that relate to your area of study. Take notes as you review to use to inform your assignment submission.
Instructions
Use the provided Word Document Template Download Word Document Templateto prepare a 1–3 page memo to the Project Manager showcasing the knowledge, skills, and abilities you are bringing to the team. Be sure to provide the following:
A high-level overview of the key requirements and duties of the job you have just taken with the new company. This can be taken from the job posting you identified in the discussion for this week. The overview you provide should be consistent with what is emphasized in the job posting.
A URL to the job posting for your position. Be sure that this is a persistent link and a current posting-not one you have used in a previous assignment. Again, this can be the same one you posted as part of the discussion for this week.
Explanation of why you are a good fit for this project. You can expand on what you submitted in the discussion for this week. This is your opportunity to reference specific experiences that make you uniquely qualified for this role on the team. Be sure you also include an explanation of why those experiences are relevant to the position.
A list of any certifications you have. If none, list any specific accomplishments you have achieved relevant to the project or that would demonstrate the skills that certification might demonstrate. Be sure to include a brief explanation of why the certification or accomplishment is relevant to the job and/or your role in the project.
Write the memo as if you are responding to questions from the PM on what they can expect from you on the project.
Note: My role is Cybersecurity Analyst

Week 2 Discussion – Looking at Job Postings
Please respond to the following in a

Week 2 Discussion – Looking at Job Postings
Please respond to the following in a substantive post (3-4 paragraphs):
Research job postings in your area of concentration for your degree, and identify one job that interest you. Copy and paste the link to the job posting. Make sure it is a persistent link that the reader can just click to be taken to the actual posting.
In 1-2 paragraphs, describe the requirements for the job you found and talk about the knowledge, skills, and abilities you already have that you could use to get the job and what you need to add to your resume or practice before you qualify for the job.
Discuss the role certification plays in your job search or quest for promotion. If your company closed or downsized and you suddenly found yourself without a job, what certifications would you need to get a comparable job?
Please respond substantively to at least one other post (1-2 paragraphs each post). Choose to respond to those who have few or no responses, as well as interesting conversations you want to join. Remember to get in early in the week for your initial post and then come back a few other times during the week for the best experience.
Note: My major is BSIT with a concentration in Cybersecurity. Please look for a remote job posting as a Cybersecurity analyst

In this week’s interactive assignment, you will add to your concept map
that you

In this week’s interactive assignment, you will add to your concept map
that you started in Week 1 and further illustrate and make connections
among the concepts of software development and requirements engineering.
This week’s section of the concept map is focused on software development and requirements engineering.
In your concept map, illustrate different software development methods,
and explain the processes used for real-life software development and
software requirements engineering. Be sure to label each component, and
describe the function of each.
In addition to your concept map, you will write a paper in which you will
Summarize the Scrum sprint cycle in the context of agile project management.
Explain agile development techniques, including the Extreme Programming (XP) process and user stories.
Specify practical concerns with agile methods.
Describe the fundamental requirements in scaling agile methods to integrate with plan-driven methods.
Describe the concepts of user and systems requirements.
Describe how they need to be documented differently.
Explain the differences between functional and non-functional requirements.
List the main activities for requirements elicitation, analysis, and validation.
Discuss the relationship among these activities.
Your paper must be a minimum of 600 words.
Attach your presentation concept map and paper in your initial post. In
addition, provide a brief summary of the alignment between your concept
map and elements within your paper. If you choose to utilize a web-based
presentation software, include the URL of your presentation in your
post.

Create and submit a rough draft of your research paper. Be sure to properly form

Create and submit a rough draft of your research paper. Be sure to properly format your paper and include citations, using APA formatting guidelines.
As you are exploring different ideas for your paper, note the research paper will require you to submit 5-7 double-spaced, typed pages regarding a topic identified in the textbook or another topic relative to this course.
Please refer to the attachments above for research paper writing tips and resources. It is important that you follow those guidelines and site your references throughout your paper and at the end of the paper.
Upon completion, upload your research paper for grading. There are many resources in the APUS online library. Click the Library link in the classroom to view the library.
Turnitin is used to assess the originality of your work–you want to have less than 15% originality.

This assignment will be submitted to Turnitin™.
Create and submit a rough draft

This assignment will be submitted to Turnitin™.
Create and submit a rough draft of your research paper. Be sure to properly format your paper and include citations, using APA formatting guidelines.
As you are exploring different ideas for your paper, note the research paper will require you to submit 5-7 double-spaced, typed pages regarding a topic identified in the textbook or another topic relative to this course.  See the attached Proposal and Outline for necessary references.

MS Excel Pivot Table Reveiw
ISA235: IT & the INTELLIGENT ENTERPRISE
MS Excel Piv

MS Excel Pivot Table Reveiw
ISA235: IT & the INTELLIGENT ENTERPRISE
MS Excel Pivot Table Review
Pivot tables allow you to perform “cross-tab” analysis on data in MS Excel spreadsheets. Cross tabulations are functions performed on aggregated data grouped in different ways, e.g. sales by division by salesperson and date or sales by division by product.
REFERENCES: Again, you should begin this assignment by blowing the dust off of your excel pivot table skills. You can refer back to your material from CSE 148 and here are some additional sites that are solid references. 
Pivot Table Intro: https://www.youtube.com/watch?v=BkmxrvIfDGALinks to an external site.
Grouping by dates: https://www.youtube.com/watch?v=24jr3ZUbQS4Links to an external site.
More advanced grouping: https://www.youtube.com/watch?v=St2zFwmwVEELinks to an external site.
REQUIRED: For each of the spreadsheets included below, use pivot tables to analyze the data and answer the related questions. Prepare an MS Word Document with your responses and upload this document to the appropriate Assignment in Canvas. If needed, please use the tutorial materials at the bottom of this page. 
Part A. Using spreadsheet “EGPC Sales Rep Expenses”
EGPC Sales Rep Expenses.xlsxDownload EGPC Sales Rep Expenses.xlsx
Which division does not have any expenses for the SU position?
Which position has the highest expenses for the following areas:
meals
phone
hotel
What is the grand total amount spent on gas?
What does each division spend on airfare?
Which division spends the most (and what is the amount) on miscellaneous expenses?
What is the total ending mileage for all sales rep cars for each division?
Which position had the highest and lowest ending mileage?
What is the average miscellaneous expense for division 4 and position S1?
Which sales rep in division 1 had the highest miscellaneous expense?
Which sales rep in position S2 had the most airfare?
Part B. Use spreadsheet “FriendsInNeed”
FriendsInNeedDonors.xlsDownload FriendsInNeedDonors.xls
There is a formatting error in the spreadsheet that needs to be fixed, what is it and how can you fix it?
Here is the fixed spreadsheet, what is fixed? FriendsInNeedDonors-Revised.xlsDownload FriendsInNeedDonors-Revised.xls
Which TCode had the largest single donation and what was the amount?
Which TCode had the most donations and how many?
Which TCode had the largest (and smallest) total donations and what was the total?
Which TCode had the highest average value donation and what was the average?
Which month had the highest number of donations?
Which month had the highest value of donations?
What was the amount donated to TCode 3 in February?
Which donor gave the most number of times?
What months did they give in?
Part C. Use spreadsheet “KleinTrainingSurvey” (assume 1 is bad, and 5 is good)
KleinTrainingSurvey.xls Download KleinTrainingSurvey.xls(NOTE: you need to combine the data)
Using Q4, give a ranked list of our courses using the average scores from the best to worst (and the averages).
For Q8, which location had the highest average?
For Q9, which location had the highest average for course RTS1?
For Q5, which instructor had the highest average score overall?
For Q3, which instructor had the highest average score at location 2 for course RTS3?
Which course at which location had the largest average class size?
Part D. Use “Koko’s Client and Pet Data”
KoKo’s Client and Pet Data.xlsDownload KoKo’s Client and Pet Data.xls
Which walktime in August has the highest average price?
Which walker has the highest average price during walktime 4? Overall?
How many walks were scheduled for walker W004 during walktime 5 in August? In November?
Excel Pivot Table Tutorial: 
Warm-Up: PivotTableWarm-Up.xlsx Download PivotTableWarm-Up.xlsxincludes WarmUp data tab and Solution tab. The solution tab includes a pivot table that uses the warm-up data to show top category by month.  
Overview of PivotTable.pdf Download Overview of PivotTable.pdf 
https://support.microsoft.com/en-us/office/create-a-pivottable-to-analyze-worksheet-data-a9a84538-bfe9-40a9-a8e9-f99134456576  

SA235: IT & the Intelligent Enterprise
SQL Review Assignment – Data Access & Bus

SA235: IT & the Intelligent Enterprise
SQL Review Assignment – Data Access & Business Decisions: SQL and Northwinds
REQUIRED: 
For each of the questions below, use our Oracle server and the Northwinds database to write SQL queries to help find the answer. Create a word document (or use the notepad app) to that includes all of your SQL used to answer each question and a copy (partial if appropriate) of the results of your queries (cut and paste). Include a short explanation if the results are not clear. This data model represents a database on our Oracle server called “Northwinds”. So, the “customers” table is “Northwinds.customers” on the server.  If you want to know how to create and access the Oracle server, please see the links at the bottom of this page. The SQL tutorial materials (in particular, SQL-WarmUp-Tutorial.pptx
) are also included to help you complete this assignment.   
Replace the ids in the same report with the company name and employee name.
Show how many shipments went to each of the two locations in each year.
Show how many shipments to each location in each year and the average freight cost by year. Order by location and year.
Show the total sales amount for each order and contact name for the company placing the order.
List all suppliers (by name) that supply more than 3 products. Include the number of products and order the list in alphabetical order by company name.
How much did each customer buy (in dollars) in 2020? (display the company name and sort from most to least).

The assignment is a memo focused on migrating to Linux Ubuntu.
no minimum or max

The assignment is a memo focused on migrating to Linux Ubuntu.
no minimum or max page requirement. 
All the questions just need to be answered appropriately and in a bulleted format.
Cite at least 2 sources in APA. 

Identify and discuss the skills needed for an IT project manager who is managing

Identify and discuss the skills needed for an IT project manager who is managing the development of a software application. Be sure to include leadership skills. Justify your response.

Instructions
Applied Supercomputing Users (ASU) Inc. is at a cross-roads as an

Instructions
Applied Supercomputing Users (ASU) Inc. is at a cross-roads as an
organization, their physical infrastructure is getting close to the end
of its life and they have ever-growing capacity needs.  The Chief
Technology Officer (CTO) has determined that he wants ASU Inc. to
leverage AWS for their infrastructure and phase out their physical
infrastructure.
Your role in this project is as a technology consultant that ASU Inc.
has hired in order to create a proof of concept that cloud technology
will be a viable replacement from the aspects of both computing and
cost.  The following deliverables are have been requested by the CTO:
Cloud Migration Justification
The first deliverable will be a 600-800 word justification for the
migration to the cloud from ASU Inc’s physical infrastructure.  In your
justification, you will need to cover the final concepts:
An overview of the one year and three year costs of AWS for the following resources:
20 database (Microsoft SQL) Windows servers with 64GB of RAM and 4 CPU cores each (to replace their database cluster)
200 non-database Linux servers with 8GB of RAM and 2 CPU cores each (To replace their current server farm)
25 TB of S3 storage (For application storage)
10 TB of EBS storage (For OS storage)
Make sure to include a screenshot of the “calculations page” of the AWS.calculator EC2 cost report
An explanation for how ASU Inc. can minimize its costs when using the AWS platform
Some examples may include Reserved Instances, Instance Sizing, different types of storage and compute!
An explanation of the process for migrating ASU Inc. from an internal infrastructure to AWS
This will require some research! There are a lot of great
resources available on the internet for this and the textbook goes into
it as well. You have flexibility here, the same kind of flexibility and
adaptability is required when performing this type of task!
Deliverables
Submit the justification as a Word of PDF file named Final Project Justification – Lastname and Final Project POC – Lastname. Your deliverable must use APAv7 format and use 5 references, one of which must be from this courses Kale textbook.