This week we learned about security culture and how to promote it within organizations.

It’s important that all employees are aware of common security risks and treat security seriously. The majority of cyberattacks aim to exploit human weaknesses with methods like phishing.

For this reason, people are most often the weakest link in an organization’s security defenses.

Scenario

• Employees at SilverCorp are increasingly using their own personal devices for company work.
   
• Specifically, over half of all employees check their work email and communications via Slack on their personal mobile phones.
   
• Another 25% of employees are doing other work-related activities using work accounts and work-related applications on their personal phone.
   
• Allowing sensitive work information to be shared on employees’ personal devices has a number of security implications.
   
• You must research these security risks and use the security culture framework to develop a plan to mitigate the concerns.
   

Instructions

Compose the answers to the following four steps on Word Document.

Step 1: Measure and Set Goals

Answer the following questions:

1. Using outside research, indicate the potential security risks of allowing employees to access work information on their personal devices. Identify at least three potential attacks that can be carried out.
    
2. Based on the above scenario, what is the preferred employee behavior?
    
   • For example, if employees were downloading suspicious email attachments, the preferred behavior would be that employees only download attachments from trusted sources.
3. What methods would you use to measure how often employees are currently not behaving according to the preferred behavior?
    
   • For example, conduct a survey to see how often people download email attachments from unknown senders.
4. What is the goal that you would like the organization to reach regarding this behavior?
    
   • For example, to have less than 5% of employees downloading suspicious email attachments.

Step 2: Involve the Right People

Now that you have a goal in mind, who needs to be involved?

• Indicate at least five employees or departments that need to be involved. For each person or department, indicate in 2-3 sentences what their role and responsibilities will be.

Step 3: Training Plan

Training is part of any security culture framework plan. How will you train your employees on this security concern? In one page, indicate the following:

• How frequently will you run training? What format will it take? (i.e. in-person, online, a combination of both)
   
• What topics will you cover in your training and why? (This should be the bulk of the deliverable.)
   
• After you’ve run your training, how will you measure its effectiveness?
   

This portion will require additional outside research on the topic so that you can lay out a clear and thorough training agenda.

Chapter 13: Procurement ManagementChapter 14: Quality PlanningInitial Postings: Read and reflect on the assigned readings for the week. Then post what you thought was the most important concept(s), method(s), term(s), and/or any other thing that you felt was worthy of your understanding in each assigned textbook chapter.Your initial post should be based upon the assigned reading for the week, so the textbook should be a source listed in your reference section and cited within the body of the text. Other sources are not required but feel free to use them if they aid in your discussion.Also, provide a graduate-level response to each of the following questions:

1.  In addition to cost, what factors should be considered in selecting a building contractor? What can go wrong if the lowest bid is selected and nothing else is considered? 
2. What is the difference between an RFP and an RFQ? Give two specific examples where an RFQ could be used and two specific examples where it is more likely that the organization will go with an RFP. (Use examples NOT from your textbook.)

[Your post must be substantive and demonstrate insight gained from the course material. Postings must be in the student’s own words – do not provide quotes!]  [Your initial post should be at least 450+ words and in APA format (including Times New Roman with font size 12 and double spaced). Post the actual body of your paper in the discussion thread then attach a Word version of the paper for APA review]

Text-

Title: Project Management 

Subtitle: https://opentextbc.ca/projectmanagement/ 

ISBN: 978-1-77420-013-1 

Authors: Adrienne Watt 

Publisher: BCcampus 

Publication Date: August 14, 2014 

Edition: 2nd Edition

  

Chapter 3 Running Case Portfolio

Summary:To apply all acquired knowledge in the last Project Assignments to create a Database Scheme. For this project, the ERD is provided to you.Deliverables:

• SQL Script with your name as follows: YourLastName_Project_Ph3.sql.
• MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.
• ZIP file to include the two files mentioned above.

Required Software:

• MySQL DBMS by Oracle. MySQL Community Server and MySQL Workbench.
• Follow Step 1-3 for your Course Project Phase phase 1, to install the required software components.

Lab Steps:Step 1: Analyze the ERD for a student information system provided below. Be alert for the specifications provided for: 1) Entities, 2) Attributes, 3) Primary Key, and 4) Relationships.  You will need to have a clear understanding for these components to create your database using MySQL. Step 2: Create a New Database in MySQL, Produce SQL File, Drop Table

• Create a new Database, as you did in your Course Project Phase 1 deliverable and you already created a database using the MySQL DBMS.  Reference the attached video (Course Project Ph1 Video.mp4), for a demonstration to create a new Database using MySQL. This video was initially presented to you for phase 2 of your project.  Also, reference the supplemental text: Available for Free download as part of our UC Library.  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill. ISBN: 978-0-07-160550-2.  Link to UC Library: http://search.ebscohost.com/login.aspx?direct=true&AuthType=shib&db=nlebk&AN=291311&site=eds-live&ebv=EB&ppid=pp_ii
• Utilize the SQL dialect you learned so far in this course for MySQL.  Use the file supplemental textbook:  MySQL Database Usage & Administration. (2010). By Vaswani, Vikram. McGraw Hill, as supplement your knowledge of the MySQL dialect. 
• Create your SCRIPT file to be named: YourLastName_Project_Ph3.sql.

Step 3: Include the following commands at the tops of your scripts:

• SET FOREIGN_KEY_CHECKS=0;
• DROP TABLE IF EXISTS STUDENT;
• DROP TABLE IF EXISTS CAMPUS;
• DROP TABLE IF EXISTS ROOM;
• DROP TABLE IF EXISTS COURSE;
• DROP TABLE IF EXISTS INSTRUCTOR;
• DROP TABLE IF EXISTS APPROVED_INSTRUCTOR;
• DROP TABLE IF EXISTS CLASS;
• DROP TABLE IF EXISTS STUDENT_GRADE;
• SET FOREIGN_KEY_CHECKS=1;

Step 4: Create Tables in your database

• Create a new Table for each of the entities provided to you in the ERD diagram in Step 1.
• Add a column to represent each attribute addressed in the ERD diagram in Step 1.
• Designate Primary Key, as noted in the ERD diagram in Step 1.
• Designate a Foreign Key relationship between the tables, as noted in the ERD diagram in Step 1.
• Enable referential integrity on the relationships, as needed.
• Enable cascade updates as needed on the relationships.

Step 5: Designate Data Types. Update the data type as needed to enforce the domain constrain of the data. This needs to be completed for every column for all tables.

• Dates: they should have a date data designation type.
• Surrogate keys: shall be auto-numbered
• Character type: shall have a character data designation type.

Step 6: Column Constraints Designation.

• Grade designation must be of one of these values as follows: A, B, C, D, E, F, W, E (E=enrolled, and W = withdrawn).
• Student’s first and last names are not to be designated as NULL.
• Course Credit hours shall be BETWEEN one and four.
• The instructor first and last name must NOT be NULL
• Course name designation has to be UNIQUE and must not be NULL type.

Step 7: Data Table Addition

• Use the INSERT operator to add minimum 2-3 rows of data per each database.
• You are free to use any values you might like for each of the columns.
• NOTE/ Reminder: you are required to add data to the parent table prior to adding any data to child tables, as referential integrity is enabled.

Step 8: Executing your SCRIPT

• Must incorporate the COMMIT command at the end of your Script
• Must incorporate the SHOW TABLES command, to display the table you created. At the end of the script created.
• Must incorporate the SELECT statement to show data allocated for each table. This would be added at the end of the script.
• EXECUTE your SCRIPT.
• Copy and paste your OUTPUT into your MS Word file as follows: YourLastName_Project_Ph3_Output.doc

Step 9: Upload your work

• Upload ZIP file to include the two files as follows: 1) SQL Script with your name as follows: YourLastName_Project_Ph3.sql, and 2) MS Word Document with your OUTPUT, named as follows: YourLastName_Project_Ph3_Output.doc.

Rubric:

• Tables Created: create a table for each entity as noted in the ERD diagram in Step 1. 5 points
• Columns Created: create a column for each attribute as noted the ERD diagram in Step 1. 5 points
• Primary Key designation: primary key addressed for all tables with unique constraints specified as column properties. 5 points
• Data Types: Addressed for each attribute. Should include: 1) Date data type incorporated, 2) Surrogate Key Automated, 3) Numeric data shall be numeric type, 4) Character data shall have a character type. 5 points
• Relationships Created, as noted in the ERD diagram in STEP 1. Relationships shall be enabled for referential integrity and cascade updates. 10 points.
• Data Added per row: 5 rows of data for each table. 10 points
• Column Constraints Added: As noted in the description for the project. Checked by adding rows with invalid values. Should take into consideration constraints as follows: 1) student name cannot be NULL, 2) course credit hours are restricted to allocations between 1-4, 3) course name is unique and NOT NULL, 4) instructor last name and first name can NOT be NULL, and 5) grade restrictions to the following values: A,B,C,D,F,I,W, E. 10 points

Part 2: – 

Project Implementation –
Report 2 Contents:  
1) Project goals. 

2) Database description: A general description of the database, what data is stored in the database.
How the database will benefit the users. 

3) Data model & design:
Completed ER/EER diagram, 5 tables minimum (8 tables in case the group has 2
members)
-MUST use https://www.draw.io to draw the ER diagram, and then take a
snapshot.
-Include a snapshot of the diagram in the report. 

– Business rules.
-Data dictionary: For each one of the tables, list columns, data types, column restrictions,
column descriptions. 

4) Implementation:
-Use MySQL Server and MySQL Workbench to create the database/tables.
-Include a snapshot of the SQL code in your report
-Populate the each table with a minimum of 20 rows of sample data. Make sure the
entered data is descriptive (not just random numbers and letters.
– Include a snapshot of the SQL code in your report.
– Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For
each query, provide the following in Report 2:
–  Snapshot of the code and the output in the report.  
– In about 2 lines, explain what the query returns.
Queries:
– 1 trivial query. Simple select with ordering.
– 2 medium difficulty queries. Queries that use composite condition for selection,
computations, aggregate function and grouping.  
– 1 query that uses subquery.
– 2 queries that uses join (1 inner join, 1 left or right outer join).
– 1 view (query must use join – hint: you can use one of the queries from the
previous question).
– 1 query that uses union.
– 1 custom stored function.
-1 custom stored procedure. 

Part 3: Presentation  
1. Create a PowerPoint presentation of your project, the presentation should contain the
following:
• Project description
• Project goals.
• ER diagram (same ER in Report 2).
• Ten snapshots of the queries with their output and a little bit of description on what
does each query do.
• Note: Even if you are working in a group of two, you only need to include 10 queries
in the presentation.
• Project difficulties.

 

  Exp19_Excel_Ch10_HOEAssessment_Pledge_Drive

  

Project Description:

You are a volunteer for Health Right, a nonprofit company that provides free physical fitness classes to schools that do not have a physical education facility. As part of your duties, you generate weekly reports that detail donation pledge calls placed, as well as pledge dollars received. You also maintain pledge drive agent personal information and manage the thank-you gifts agents receive for volunteering their time. This week you have decided to overhaul your report by updating agent contact information, importing data previously stored outside your old report, implementing a PivotTable using Power Pivot, and utilize Power-Add-Ins to edit and visualize the week’s data.

     

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

 

Use Get & Transform (Power   Query) to load the file e10c2VolunteerInfo.csv   in the Power Query Editor. Use the Power Query Editor to split column D into   three separate columns for City, State, and Zip using comma as the delimiter.   Edit the city.state.zip1 column heading to City, city.state.zip2 to State, and city.state.zip3 to Zip then load the data to the   existing worksheet.

 

Rename the worksheet Volunteer   Information.

 

Set the External Data Range   Properties to Refresh data when opening the file.

 

Use Get & Transfrom (Power   Query) to load the Pledge table from xml file e10c2Rewards.xml into a new worksheet. Be sure to add the   information to the data model.

 

Rename the worksheet Rewards.

 

Apply Accounting Number Format   to the dollar amounts imported into column A.

 

Use Get & Transform (Power   Query) to load the Contacts table from the file e10c2Contacts.accdb in the Power Query Editor. Use the Power   Query Editor to remove the Income and Dependents fields then load the data in   a new worksheet. 

 

Rename the worksheet Pledge Leads.

 

Use Power Pivot to import the   Transactions table from the Access database e10c1PledgeDollars.accdb into a PivotTable. Place the PivotTable   on a new worksheet named Pledge Dollars. Add the Date field to the Filters area, add   Operator_ID to the Rows area, and add Pledge_Amount to the Values area. Save   the workbook.

 

Create a relationship between   the Operator_ID in the Transactions table and the Operator_ID in the   Volunteer Information worksheet.

 

Insert a 3D Map (Power Map)   using the Volunteer Information zip code (Zip) as the location dimension,   Pledge_Amount as the height dimension, and Operator_ID as the category   dimension. Zoom the plot area as needed to display results.

 

Save and close the file. Submit Exp19_Excel_Ch10_HOEAssessment – PledgeDrive.xlsx   as directed.

 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.  

 

https://owl.purdue.edu/owl/general_writing/visual_rhetoric/data_visualization/index.html

and

https://owl.purdue.edu/owl/general_writing/visual_rhetoric/data_visualization/activity.html

Review the 2 links above.

Respond with an example of your choice that illustrates the 3Es of visualization (effective, ethical, and efficient) as outlined in the materials. Include the graphic in your response.

Explain the reasons for your choice. Also discuss other options you discarded. Your original analysis must be substantive and represent at least 50% of your response.

Note:  Please perform your own research and refrain from copying visualizations from sites where the author has already chosen a visualization and discussed it from this perspective.

I have matlab code (motion_fusion.m). This is the main file. All the codes are written but need to correct them.

I have some helper function as well. (they are .m files, you can find those in main file, motion_fusion.m )

I also have some data to load in main file.

I am looking for someone to correct the code and run the code. 

  

Your completed assignment should be saved as Word document and submitted to your WebTycho assignment area no later than the due date listed in the syllabus. Your document should be neat, well-written with minimal grammatical and spelling errors. Your name should be clearly listed on the first page along with the class/section, professor and due date. Your document should contain page numbers at the bottom of each page. Single or double space line formatting is acceptable. 

You should name the file yournamehw4.docx (or yournamehw4.doc). So if my name was Julie Smith, I would name my document juliesmithhw4.docx. 

An example HW4.doc template file containing the required sections is included in the available resources. You should use this document to start your writing and fill in all of the details required. 

Final Project- (30%)
Your final project will be to analyze, design, and document a simple program that utilizes a good design process and incorporates sequential, selection and repetitive programming statements as well as at least one function call and the use of at least one array.  The specific problem you need to solve for the final project is:  Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas. 

Final Project Deliverables:
There are two deliveries for this project. The first delivery is the project plan which provides your problem statements, problem analysis, and how it will comply with the project specifications. The project plan is worth 10% of your grade. The final delivery will be your completed project design along with your code comments and comprehensive test plan. The final delivery is worth 20% of your grade. 

Your project plan is due in week 7 by midnight EST, on the specific date posted in the class schedule. The final delivery is due no later than the last day of class. Your instructor’s policy on late projects applies to this project. 

Example Project Plan and Final Project template files, containing the required sections are included in the available resources. You should use this document to start your writing and fill in all of the details required. 

Format: 

Project plan format and length: 

The documentation describing your analysis and test plan should be written using Microsoft Word. The font size should be 12 point. The page margins should be 1 inch. The paragraphs should be formatted with double line or single line spacing. Any figures, tables, equations should be neatly labeled. All references should use APA style.  

Final Project Grading:
This activity is awarded 30% of the total grade in the course. The project elements are assessed as follows: 

1. Problem definition: Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas.

 A. Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section. 

Note: Your Design, code comments and test cases will be submitted next week.

Problem Statement:

Design a program that will allow a user to Input a list of your family members along with their age and state where they reside. Determine and print the average age of your family and print the names of anyone who live in Texas. Family contains ten members. 

Problem Analysis – Following the directions in the assignment, clearly write up your problem analysis in this section. 

• The program is to calculate the total      average of the family age wise and determine their location with only      printing out those members that are from Texas. The program will take      inputs from the user who will input the name, age and location of each      family member. The program will take the years of all members entered and      add them all together and then take the total of members entered (10) and      divide the total coming up with the average age. The program will also      calculate and identify each state of each person entered and using the      defined input identifies those people from Texas and prints their names      out only. The output of the program is three fold. The total average age      of all family entries, identify who is from Texas and print their name      out.

· Required input – Name of person

· Required input – Age of person

· Required input – State of where person came from

· Required output – average age of all persons entered

· Required output – printed name of person(s) from Texas ONLY

a. The program will take inputs and calculate the average of all of the ages entered, identify which persons are from Texas and print their name out.

b. An array will be used to hold the data for calculating who comes from Texas

c. The program will do the following:

i. Declare name, age and state arrays for those members

ii. Array will be up to the user entered values.

iii. It will take user input for name age and state in a loop

iv. It will calculate average age and identify who live in Texas 

v. Final function will print out average age, identify people’s names from Texas and print it out. 

For this program, user will be asked for name, age and state of their family members, one by one, until the user decides to stop entering this information. To achieve the given task (printing average family age and identifying residents of Texas), following modules need to be created:

– Main module: This module will be the one running on program startup. It will be responsible to get user input and call appropriate modules to calculate and display average family age and display family members those are residents of Texas

– calcAverageAge module: This module will take family ages as input and count of family members as input and calculate and display average family age. This module will be called from within Main module.

– printTexans module: This module will take family names as input and will print names of the family members from Texas. This module will be called from main module.