Assignment Details

Assignment Description

This week, you will identify which components and interfaces will be included in the System Integration Project, and you will discuss the advantages and disadvantages specific to your project.

You are now progressing with laying out the framework for your System Integration Project. It is important that you identify and develop requirements for all of the major components and interfaces that should be included in this project.

Assignment Guidelines

For this week’s assignment, you will be developing the Requirements Specification for this integration. You should use all of the tools available to you to elicit requirements (such as one-on-one interviews with all major stakeholders, surveys, artifact reviews, joint requirement specification meetings, and so forth).

• New Content (Week 2) 
  • Requirements Specification
    • Describe the process you used to elicit the requirements.
    • List of all of the stakeholders and their roles.
    • Describe of all components and interfaces, including a schematic that depicts them (such as the various layers of integration).
    • Provide detailed and measurable functional requirements.
    • Provide detailed and measurable nonfunctional requirements.
    • List assumptions for the scope of the project.
    • Discuss the pros and cons of proceeding with the project while giving consideration to the requirements you have defined.
• Make sure that the document is in APA format.
• Submit the document for grading.

Question #1. Go to the Website https://toxtown.nlm.nih.gov/sources-of-exposure

Then, on the Sources of Exposure section. There, you would be able to see the source of exposures. Pick one Sources of Exposure the most interest to you and click on the link to open the interactive reference. Choose a location and provide a review of the different type of environmental concerns and chemical contaminants. Note: Be sure to explain the source of chemical exposure, as well as any strategies to minimize or eliminate exposure.

Question #2. Go to the Website       https://www.epa.gov/superfund/search-superfund-sites-where-you-live Links to an external site.   Links to an external site.and and then select Virginia. Choose one of the Superfund sites on the list and provide a brief summary of the site. Discuss any noted community involvement in the discovery or cleanup of the site. Note: Be sure to include a discussion of remediation strategies, as well as the current stage of cleanup at the site.

HINT : Go this website
https://www.epa.gov/superfund/search-superfund-sites-where-you-live

and then select Virginia

 The challenge of this game is to collect as many as flower with the vase (catcher). Flowers fall down from the top of the screen and user will move the vase and collects flowers. In the above figure the dashed line arrows show possible movement directions of the components. In the game no dashed line will be shown. The game scene runs in gravity. The flower will be left from randomly chosen X points (Y is fix) from the top. User can swipe vase only to the right and/or left to collect them. Once the vase touches a flower, then a score is made, and that particular flower disappears with a sound (for example, http://soundbible.com/1536-Stapler.html). User will be granted 60 sec to collect as much as flowers. On the top-right corner of the game, show the remain time and score. Make sure that not many flowers will release at the same time. You may adapt a strategy to release flowers in a discrete way, such as one flower will be release every 2 – 5 seconds from random coordinates. Make sure that flower and vase sprites are not so small and/or big. A typical size for a flower is 64×64, and for vase image is 100×100. Game ends after 60 seconds, shows the score and a restart button a new game. 

Topic( Minimum 300 words):

–  What is the impact of rapid environmental changes on organizations? 

– Minimum two references. 

There should be no plagiarism. Attach a plagiarism report with 0 % similarity index.

ITEC 630
Information Systems Analysis, Modeling, and Design
Individual Project Assignment
Purpose
The purpose of the individual system analysis and design project is to demonstrate student’s ability to
apply the knowledge learned in this course to a real-world project.
Topics Suggestions
1. The system analysis and design project must be realistic and it will be done using techniques covered
in this course. The list of topics suggested for this project is as follows:
a) Ticket purchase system (airline, train, cruise, concert, or others)
b) Internet shopping sites (clothing, shoes, books, music, or others)
c) Local real estate agency system
d) Rental system (car, video, or others)
e) Warehouse management system
f) Student record system
g) Banking system
h) Insurance purchase system (life, medical, homeowner, or others)
i) Credit card management system
j) Library circulation system
2. The above list is meant to be suggestive and if you have an idea about a specific topic, please consult
with your instructor early to determine if it is suitable for the course.
3. You have to select and submit the project topic for instructor’s approval by the end of Week 2.

Project Deliverables
The project requires students to perform three phases: (a) requirements analysis, (b) system and database
design, and (c) a project plan. Note that in the phase 3, students are required to use the MS Project
software for their project schedule.
The deadline for the Individual Project can be found in the schedule section of the class syllabus.
The following layout format covering a title page and all three phases is recommended for the project.
Title page (project name, author, and date)
Phase 1: Requirement analysis
A. Problem definition
B. Issues
C. Objectives
D. Requirements
E. Constraints
F. Description of the proposed system
G. Logical model design
1. Data flow diagrams
 Context diagram
 Diagram 0
o Diagram 1 (Diagram 1 is optional)
 Descriptions of processes in each diagram
2. Descriptions of outputs/inputs/performance/security or controls
H. Specific requirements, if any (interface, operational, resource, performance, etc.)
Phase 2: System and database design
A. User interface
Design an overall user interface consisting of screens, commands, controls, and features to
enable users to use the system.
1. How data will be input to the system?
 The physical layout for each input
 The input design and procedures
2. How data will be output from the system?
 The physical layout for each output
 The output design and procedures

B. Data design
Develop a plan for data organization, storage, updating, and retrieval.
1. Database design
 Database tables with their attributes should be presented
 Primary key(s) should be identified in each table, if any
 Three steps of normalization should be included.
2. Entity-relationship diagrams
3. Data file storage and access
C. System architecture
Determine the architecture of the system as Web-based interface, client/server architecture,
Internet/Intranet interface, network configuration, etc.
Phase 3: Project plan
A list of tasks or activities needed for implementing the proposed system
Estimating completion time and costs
A project schedule for performing those activities (Gantt charts or PERT charts)
Note that there is no other required software package except the MS Project software in this ITEC-630
course. As a result, you are only required to use the MS Project software to handle the scheduling part of
the project and for other parts, you can use any word editing software or any drawing tools software.

1.2 

Because of the housing bubble, many houses are now selling for much less than their selling price just two to three years ago. There is evidence that homeowners with virtually identical houses tend to ask for more if they paid more for the house. What fallacy are they making?

Discussion 2.1

Children in poor neighborhoods have bleak outlooks on life and do not see much gain to studying. A recent experiment is paying children in poor neighborhoods $100 for each “A” they earn in a six-week grade reporting cycle. How does this affect the children’s behavior?

Discussion 2.2

Probably the most important source of capital is human capital. For example, most medical doctors spend years learning to practice medicine. Doctors are willing to make large investments in their human capital because they expect to be compensated for doing so when they begin work. In Canada, the government nationalized the health-care system and reduced doctors’ compensation. Is this a form of post-investment hold-up?

Exp19_Excel_Ch10_ML1_Dow_Jones

You are an intern for Hicks Financial, a small trading company  located in Toledo, Ohio. Your intern supervisor wants you to create a  report that details all trades made in February using current pricing  information from the Dow Jones Index. To complete the task, you will  import and shape data using Power Query. Then you will create data  connections and visualizations of the data.

Use   Get & Transform tools to import and transform Table 0 located in the file   e10m1Index.txt. Split the company column using space as the delimiter at the   left-most occurrence. Rename the respective columns Symbol and Company. Remove the columns Change, %Change, and   Volume. Name the table Dow and load it to the existing worksheet.
   Hint: Get Data is located on the Data tab in the Get & Transform Data   group.

Name the worksheet Current_Price.
   Hint: Double-click the worksheet tab to edit the sheet name.

Use Power Query to import trade   data located in the workbook Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv.    Before loading the data, if necessary use the Power Query Editor to  remove   the columns that contain NULL values. Split the company column  using the left   most space as the delimiter and rename the respective  columns Symbol and Company Name.
   Hint: Get Data is located on the Data tab in the Get & Transform  Data   group. Click Edit on the Import window to load the Power Query  Editor. 

Rename the worksheet Trades.
   Hint: Double click the worksheet tab to edit the sheet name.

Add the Dow table and the Exp19_Excel_Ch10_GRADER_ML1-TradeInfo   table to the Data Model.
   Hint: Manage Data Model is located on the Data tab in the Data Tools group.

Use Power Pivot to create the   following relationship:
 

  Table
Exp19_Excel_Ch10_GRADER_ML1-TradeInfo
 

  Field
Symbol
 

  Table
Dow
 

  Field
Symbol
 

  Hint: Relationships is located on the Data tab in the Data Tools group.

Use Power Pivot to create a   PivotTable with the  EXP19_Excel_Ch110_GRADER_ML1_TradeInfo Date field as a   Filter, Last  Price as a value, and the Dow table Company Name as Rows.
 

  Hint: Power Pivot is an Excel add-in that must be loaded. Power  Pivot can be   loaded by accessing COM add-ins in Excel options. Once  loaded, the Power   Pivot tab is located on the Office ribbon.

Create a Clustered Column   PivotChart based on the PivotTable that compares the trading price of Apple   and Coca-Cola stocks.
 

  Hint: PivotChart is located on the Analyze tab in the Tools group.

Add the chart title Trading   Comparison,   apply Accounting Number Format to cells C4:C5, and name the worksheet Price_Comparison.
   Hint: Chart elements can be added or edited on the Design tab in the Chart   Layouts group. 

Delete Sheet 1, if necessary.
 

  Hint: Delete is located on the Home tab in the Cells group.

The convenience and availability of cloud services has seen a dramatic increase in business functionality being shifted from local servers to the cloud. Even our biometrics may be stored in the cloud.Assume your employer has signed up with a global authentication provider that stores user fingerprints in the users’ global identity accounts. Users can then use their biometric fingerprint from the cloud service to access websites rather than storing the fingerprint locally on their mobile device or computer.In theory, if an attacker gains access to your fingerprints (whether stored locally or in the cloud), they could compromise any of your online accounts that accept your fingerprints.Answer the following question(s):

1. Is the storage of biometric data safer locally or in the cloud? Why?
2. If an attacker has your fingerprints, could multifactor authentication (MFA) still prevent the attacker from gaining access to your accounts? Why or why not?

Fully address the questions in this discussion; provide valid rationale or a citation for your choices; and respond to at least two other students’ views.Initial post should be at least 350 words in length. Each reply post should be at least 150 words in length.

Comparative Web Analysis writing for sites. 

#Exp19_Excel_Ch03_CapAssessment_Movies

#Exp19 Excel Ch03 CapAssessment Movies

Project Description:

You are an assistant manager at Premiere Movie Source, an online  company that enables customers to download movies for a fee. You need to  track movie download sales by genre. You gathered the data for April  2021 and organized it in an Excel workbook. You are ready to create  charts to help represent the data so that you can make a presentation to  your manager later this week.

Steps to Perform:

Step

Instructions

Points    Possible

1

Start   Excel. Download and open the file named Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Grader has automatically added your last name to the beginning of the   filename.

0

2

You want to create a pie chart to show the   percentage each category contributes to the monthly movie downloads.
 

  Select the ranges A5:A10 and F5:F10. Create a pie chart and move it to a   chart sheet named April Pie Chart.

6

3

The   chart needs a descriptive title that is easy to read.
 

  Type April   2021 Downloads by Genre as the chart title, apply bold, 18 pt font size, and Black, Text   1 font color.

5

4

Percentage and category data labels will provide   identification information for the pie chart.
 

  Add category and percentage data labels in the Inside End position.  Remove   value data labels and the legend. Apply 14 pt font size and  Black, Text 1   font color.

5

5

You   want to focus on the comedy movies by exploding it and changing its fill   color.
 

  Explode the Comedy slice by 7% and apply Dark Red fill color.
 

4

6

A best practice is to include Alt Text for   accessibility compliance.
 

  Add Alt Text: The pie chart shows percentage of downloads by genre   for April 2021.   (including the period)

2

7

Next   you want to create a combo chart to depict the monthly totals and percentages   by category.
 

  Display the Data sheet, select the ranges A4:A10 and F4:G10, and  then create   a Clustered Column – Line on Secondary Axis combo chart.

4

8

You want to position the chart below the data   source.
 

  Cut the chart and paste it in cell A13. Change the height to 3.5″ and the width to 6″.

5

9

Change   the combo chart title to April 2021 Downloads. Apply Black, Text 1 font color to the chart   title.

3

10

Axis titles will help distinguish the number and   percentage of downloads.
 

  Add a primary value axis title and type Number of Downloads. Add a secondary value axis   title and type Percentage of Monthly Downloads. Apply Black, Text 1 font color   to both value axis titles.

6

11

Now   that you added an axis title for each vertical axis, you can  remove the   legend and format the secondary value axis to display whole  percentages.
 

  Remove the legend for the combo chart. Display 0 decimal places for the   secondary value axis.
 

1

12

You want to add some color to the plot area for the   combo chart.
 

  Apply Light Gradient – Accent 1 gradient fill color for the plot area.

5

13

A best   practice is to include Alt Text for accessibility compliance.
 

  Add Alt Text: The combo chart shows the number and percentage of   downloads by genre for April 2021. (including the period).

2

14

To provide a visual summary of the weekly totals   for each genre, you will insert sparklines.
 

  Select the range B5:E11. Insert Line Sparklines in the range H5:H11. Apply   Black, Sparkline Style Dark #4

10

15

Displaying   the markers helps identify the specific points on the  sparklines. You will   also change the high point to a different color  to stand out.
 

  Show the high point and markers for the sparklines. Change the high point   marker color to Red.

5

16

Your last major task is to create a bar chart for   weekly downloads.
 

  Select the range A4:E10. Create a stacked bar chart. Move the chart to new   chart sheet. Type Weekly Downloads for the sheet name. Apply Style 8 chart style.

14

17

Add a   chart title above the bar chart and type April 2021 Weekly Downloads by Genre. 

4

18

Increasing the font size will make the chart   elements easier to read.
 

  Apply 11 pt font size to the category axis, value axis, and the legend for   the bar chart.

6

19

Because   the largest value is less than 9,000, you can reduce the  maximum bound in the   chart. In addition, you want to display the  category labels in the same order   that they are in the worksheet.
 

  Change the maximum bounds for the value axis to 9000 and set the Major Units to 500  for the bar chart. Use the Axis   Options to format the category axis  so that the category labels are in   reverse order in the bar chart.

5

20

Although the bar chart displays major gridlines,   minor gridlines could improve the appearance.
 

  Add primary minor vertical gridlines to the bar chart.

0

21

A best   practice is to include Alt Text for accessibility compliance for the bar   chart.
 

  Add Alt Text: The stacked bar chart shows downloads by each week for   each genre.   (including the period).

4

22

Insert a footer with Exploring Series on the left,  the sheet name   code in the center, and the file name code on the right  on all the sheets.   Change to Normal view.

4

23

Save   and close Exp19_Excel_Ch03_CapAssessment_Movies.xlsx.   Exit Excel. Submit the file as directed.

0