Monthly Archives: June 2023

May you please check my work to see that it’s okay? 

250 words+

1. Suppose you never learn database and have no idea about database, as you need to manage your data, what will you do? 

2. Why shall we use Database Systems? Is it a must or a good way/idea to manage/handle data?

 differences between and advantages of MAC, DAC, and RBAC.

 Assessment Description

Implement a security framework to identify and close gaps between an organization’s current cybersecurity status and its target (future) cybersecurity status. Make sure to align to an appropriate regulation (e.g., PCI DSS, HIPAA, SOX, GLBA). In CYB-650, the NIST Cybersecurity Framework was utilized, and therefore it cannot be utilized for this assignment.

Develop a report that addresses the following:

Organizational Objectives and Priorities

1. Current Framework Compliance Status: Describe the current cybersecurity environment, such as processes, information, and systems directly involved in the delivery of services. Describe the current risk management practices, threat environment, legal and regulatory requirements, business/mission objectives, and organizational constraints using the framework identified. Include a diagram related to the common workflow of information and decisions at the major levels within the organization.
2. Future Cybersecurity Policy Implementations: Describe the critical cybersecurity needs that should be in place to ensure compliance with the appropriate regulation (e.g., PCI DSS, HIPAA, SOX, GLBA) and then prioritize organizational efforts, business needs, and outcomes.

Operational Compliance and Risk Assessment

1. Cybersecurity Risk Assessment: Describe the likelihood of risks occurring and the resulting impact. Identify threats to, and vulnerabilities of, those systems and assets. Express risks both internally and externally. Determine the acceptable level of risk (risk tolerance). Describe the response to the risk. Describe how identified risks are managed and resolved. Include an Organizational Risk Assessment Chart.
2. Privacy Risk Management: Describe how the business is integrating privacy laws and regulations, prioritizing, and measuring progress.
3. Compliance Gaps: Describe the type of audits that should be performed in order to keep a consistent measure of risk. Determine what type of gap analysis should be performed in order to properly identify the security elements and variables within the environment that pose the most risk. Formulate a cybersecurity governance strategy that establishes mitigation plans to achieve security objectives.
4. Web Portal Diagram: Create a web portal data flow diagram of the hypothetical organization’s operational environment using Visio or similar diagramming software. Within the web portal data flow diagram, students will show how the web portal is compliant. The web portal data flow diagram must: a) Display the organization’s technical requirements (related and unrelated applications, services, and links); b) display the compliance of associated servers, routers, access-control components, data storage, internal and external data communication, data backup, e-mail servers, and so forth; c) identify related systems and assets, regulatory requirements, and overall risk approach; and d) demonstrate each IT task to the next as aligned to regulations/compliance (e.g., start with the user logging in, and then go through each step and how it is validated.

APA style is not required, but solid academic writing is expected.

Refer to “CYB-690 Cybersecurity Framework Scoring Guide,” prior to beginning the assignment to become familiar with the expectations for successful completion.

Exp19_Excel_Ch09_Cap_Housecleaning_Service 

Exp19 Excel Ch09 Cap Housecleaning Service 

Excel Chapter 9 Capstone – Housecleaning Service

Project Description:

You manage a housecleaning service. As manager, you schedule the cleaners with clients, provide cleaning supplies, and insure the cleaners. You pay the cleaners for their time and mileage reimbursement. You set up a monthly workbook with one worksheet per week to enter the dates, mileage to each house, and start and stop times. You then calculate the hours worked. You are ready to calculate weekly totals and the monthly totals.

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

The title and column labels in   the Week 1 worksheet are formatted with cell styles. You want to apply this   formatting.
 

  Group the Week 1, Week 2, Week 3, and Week 4 worksheets. Select the range   A1:B1 on Week 1 and fill formats only across the other weekly worksheets.

Now you want to fill the   formatting and contents to the other worksheets.
 

  With the four weekly worksheets still grouped, select the range A11:E11 and fill   both content and formatting across the other weekly worksheets.

You want to unlock the   data-entry cells on the weekly worksheets.
 

  With the worksheets still grouped, select the range A12:D40 and unlock the   cells.

You want to create a data   validation rule to control data entry.
 

  Ungroup the weekly sheets, select the range D12:D40 in the Week 1 sheet, and   then create a data validation rule with these specifications:
  • Allow Time greater than cell C12.
  • Enter the input message title: End Time.
  • Enter the input message: Enter the end time. (including the period).
  • Select the Stop error alert style.
  • Enter the error alert title: Incorrect End Time.
  • Enter the error message: The end time must be later than the start time. (including the period).

You want to duplicate the data   validation rule on the other worksheets.
 

  Select the range D12:D40 (if needed) and click Copy. Click the Week 2 sheet   tab and group Week 2, Week 3, and Week 4 sheets. Select the range D12:D40,   click the Paste arrow on the Home tab, select Paste Special, click Validation   in the Paste Special dialog box, and then click OK. Ungroup the sheets.
 

  Note: Paste Special validation is not available on Excel for Mac. Excel for   Mac users need to repeat Step 5 to create validations on the Week 2, Week 3,   and Week 4 worksheets.

Display the Week 2 sheet and   insert a split bar between rows 22 and 23.

Although the data validation   will prevent future errors in data entry, it did not correct errors in the   existing data.
 

  Display the Week 1 sheet. Circle invalid data to identify cells containing   invalid end times. Display the Month sheet. In cells H4 and H5, indicate the   name of the cells (e.g., A1) that contained the errors (do not enter a   formula). Display the Week 1 sheet again. Change the first incorrect end time   to 11:00   AM. Change the   second end time to 4:15 PM.

The hourly rate you charge   clients, the hourly wage you pay your housecleaners, and the mileage   allowance are stored in a separate workbook. You will create links to those   inputs to perform calculations in the weekly worksheets.
 

  Open Exp19_Excel_Ch09_Cap_HouseInput.xlsx.   Arrange the two open workbooks vertically to display both workbooks at the   same time. Display the Exp_Excel_Ch09_Cap_HouseCleaners   workbook and group the four weekly worksheets. In cell B5, multiply the Total   Hours that is stored in cell B4 by the Customer Cost per Hour that is stored   in cell B3 in the Exp_Excel_Ch09_CapHouseInput   workbook.

In cell B6, multiply the Total   Hours that is stored in cell B4 by the Cleaner’s Pay per Hour that is stored   in cell B4 in the Exp_Excel_Ch09_Cap_HouseInput   workbook.

In cell B7, multiply the Mileage   that is stored in cell B3 by the Cleaner’s Mileage Reimbursement that is   stored in cell B5 in the Exp_Excel_Ch09_CapHouseInput   workbook.
 

  Ungroup the worksheets, close Exp19_Excel_Ch09_Cap_HouseInput,   and maximize Exp19_Excel_Ch09_Cap_HouseCleaners.

The Month worksheet was created   to calculate the totals for the month. You will insert functions with 3-D   references to add data from each worksheet.
 

  Display the Month worksheet. In cell B3, insert a SUM function that uses a   3-D reference to add the mileage from the four weekly worksheets.

Copy the function from cell B3   to the range B4:B8. Use the Auto Fill button to Fill Without Formatting to   preserve the original formatting in the range.

Now you are ready to calculate   the weekly charge for Week 1.
 

  In cell E3 in the Month worksheet, create a formula with a 3-D reference to   display the contents of cell B5 from the Week 1 worksheet.

You are ready to enter similar   formulas with 3-D references to display the total weekly charges for the   other three weeks.
 

  In cell E4 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 2 worksheet.
 

  In cell E5 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 3 worksheet.
 

  In cell E6 in the Month worksheet, insert a formula with a 3-D reference to   display the contents of cell B5 from the Week 4 worksheet.

You want to create hyperlinks   from the Month sheet to the cells containing the total weekly client charge   for each week.
 

  In cell D3 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 1 sheet. Include   the ScreenTip text: Total client charges for Week 1 (no period).
 

Now you will insert hyperlinks   to the second weekly worksheet.
 

  In cell D4 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 2 sheet. Include   the ScreenTip text: Total client charges for Week 2 (no period).

Now you will insert hyperlinks   to the third weekly worksheet.
 

  In cell D5 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 3 sheet. Include   the ScreenTip text: Total client charges for Week 3 (no period).

You are ready to insert the last   hyperlink.
 

  In cell D6 in the Month worksheet, insert a hyperlink that links to cell B5 in the Week 4 sheet. Include the ScreenTip text: Total client   charges for Week 4   (no period).

Create a footer on all   worksheets with your name on the left side, the sheet name code in the   center, and the file name code on the right side. 

Protect each worksheet so that   others can select the default cells but not make any changes.

Mark the Workbook as Final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

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

Executive Program Practical Connection Assignment – 100 points

Executive Program Practical Connection Assignment – 100 points

At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines and communities, linking research with practice and knowledge with ethical decision-making. This assignment is a written assignment where students will demonstrate how this course research has connected and put into practice within their own career.

Assignment:
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. 

 Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

· Share a personal connection that identifies specific knowledge and theories from this course.

· As this is a personal reflection, no citation from any reference will be accepted (Turnit percentage will be reflected in your grade as no reference at all should be included

· Include three main parts:

o In your own words, summarize the course content in the first third

o In your own words, summarize how is this relevant to your pass and current work/experience in the second third

o In the last third, summarize in your own words how will knowledge in this course, help you in enhancing your skills and profile.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.   You cannot submit a previous assignment that was written for another class.  This assignment will be checked by Safeassign for Plagiarism.

Assignment 1: 

Please refer to the “DM.zip” file (includes previously done homework) to complete this assignment.

Write a brief (1 to 2page) reflection paper on your experience in the course and primary lessons learned, including how you might apply the lessons to your professional activities.

You can use Data Mining topics. 

Requirements:

o ****Separate word document for each assignment****

o Provide a 1-2 page minimum reflection.

o Use of proper APA formatting and citations. 

o Share a personal connection that identifies specific knowledge and theories from this course. 

o Demonstrate a connection to your current work environment. 

o You should NOT, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.  

o No plagiarized content please! Attach a plagiarized report.

o Check for spelling and grammar mistakes!

o $5 max. Please bid if you agree.

Module 05 Content

1. Create a risk assessment plan for your company and do a thorough risk assessment analysis. Assess the ramifications of the risks you identify and make recommendations to mitigate those risks.

   Your assignment should meet the following requirements:

   • 6-8 pages long, not including the cover page and reference page.
   • Conform to APA Style.
   • For your final project, you will compile all of the weekly deliverables from Modules 02-04 and submit as a final project. Be sure to include your risk assessment plan in this final deliverable.

     Compile your deliverables into a paper with the following sections (Hint: make these your level 1 heading per APA format, remembering the title of the paper is your heading for your introduction):

   • Introduction
   • IT Governance and Risk Control Plan
   • Business Continuity and Service Level Agreements
   • Risk Status Report
   • IT Audit Process
   • Risk Assessment Plan and Analysis
   • Conclusion
   • After compiling the weekly deliverables, condense the information into a paper 8-10 pages long, and keep only the most substantial information.

     Your assignment should meet the following requirements:

   • Be 8-10 pages long, not including the cover page and reference page.
   • Conform to APA Style.
   • Support your answers with at least six current scholarly journal articles (not more than five years old). The Rasmussen Library is a great place to find resources.
   • Be clearly and well-written, concise, and logical, using excellent grammar and style techniques. You are being graded in part on the quality of your writing. If you need assistance with your writing style and APA format, start with the Writing and APA guides at the Rasmussen Library.

Welcome to The Knowledge House 2021 Innovation Fellowship 

Pre-work for the Web Development track!

The following prework is meant to assess your ability to learn new concepts

quickly and apply them to problems you may not have seen before.

Assignment 1:

Make your computer shout you out!

Now write a script where you initialize a javascript variable that can NOT be

changed

This solution and all other solution files should be saved in the pre-work directory

you will create:

assignment_1.js

Assignment 2:

Make your computer shout you out!

//Programming a computer seems complicated but in reality, it is just learning the commands

//your computer understands so you can make it do what you want it to do. The material does this

//to is data, that can be numbers, strings (sets of characters enclosed in “”), or a boolean which

//represents true and false, 0 or 1.

//In order for your computer to show text on a screen you must tell it what you want it to say with a

//console.log statement

//Ex1:

console.log(“Hello World”)

//Output would be: Hello World

// you can also capture strings and number and save them under names called variables:

var greeting = “Hello World”

console.log(greeting)

//Output would be: Hello World

//Ex 2

//You can also take words user’s input (or from other sources) and sub them into your string

//in the below example we have a variable that will save a users input for their favorite food:

fav_food = prompt(“What is your favorite food?”)

console.log( “My favorite food is ” + fav_food)

//OUTPUT:

//”What is your favorite food?: Burgers”

//My favorite food is Burgers

Now write a script where your computer asks you for your name and then shouts you

out

This solution should be saved in the pre-work directory you created earlier in the

file:

assignment_2.js

ASSIGNMENT 3

Simple Math:

Initialize two variables containing integers, multiply them, saving the result to a

third variable. Once done print the variable to the screen.

This solution should be saved in the pre-work directory you created earlier in the

file:

assignment_3.js

ASSIGNMENT 4

Math and evaluation

//Programming uses numbers, but thankfully you don’t need to be a math genius to program.

//Programming can be used to evaluate mathematical statements, you can also compare numbers to each-other

//Ex1:

4+4

//Output: 8

//Ex2:

17<3

//OUTPUT: False

//We can also place a condition on the result of such a test:

//Ex2

var example = 7;

if (example > 8){

print “over”

};

else{

print “under”

};

//OUTPUT: under

//You can do this to compare numbers to each-other

//Lastly we have arrays and loops, a array is just a collection of strings, numbers, or other pieces of data

var nums = [1,14,32,5,7]

console.log(nums.length;) //output is 5

//here we have a array of numbers we can write a for loop to array them out for us,

//Here we are setting the variable i to act as a placeholder for the item in the array we are printing

//i++ shows that after each run of the loop i is increased by 1, until i is greater than the length of the

//array

for(var i=0; i

console.log(i)

};

//Output:

//1

Now create a loop that compares the array of numbers provided for the number 25,

console log over if it is over and under if it is under

over_under_array = [1,45,32,21,5,17,43,93]

This solution should be saved in your pre-work directory you created earlier in the

file:

assignment_4.js

ASSIGNMENT 5

Loops part 2:

var array = [1,45,32,21,5,17,43,93];

Given the above array, create a loop that goes through each array item, multiplies

it by 7 and then prints the result to the screen.

This solution should be saved in your pre-work directory your created earlier in the

file:

assignment_5.js

ASSIGNMENT 6

Given the below array, create a function which loops through each name, comparing

the length of each to determine the longest name, save that name to the variable

longest_name. Return longest_name to the another variable called answer and log the

answer variable to the screen.

var array = [ Retta, Vern, Marica, Cyrus,  Linette, Curt, Nichole, Jesica, Wynell, Michaele ]

This solution should be saved in your pre-work directory your created earlier in the

file:

Assignment_6.js

ASSIGNMENT 7

Indexing

//all strings and arrays have individual characters and items respectfully represented by an index number

//this starts at 0, and can be accessed in bracket notation

var thing = “car”

thing[0]//c

thing[2]//r

array = [“one”,2,”3hree”]

array[2] // 3hree

//print both arrays and then return the even one and print it again.

Create a function that takes the below array of names, and separates them into two

arrays one of the names with an even number of letters and one with an odd number of

letters.

Then take the first letter of each of the names in the even array and make it the

letter “b”, take the last letter in each of the names in the odd array and make them

a “c”

Print both arrays and then return the even one to a variable named even_array and

print it again.

var names_array = [“bob”,”jimmy”,”max b”, “bernie”, “jordan”, “future hendrix”]

This solution should be saved in your pre-work directory your created earlier in the

file:

assignment_7.js

FINAL ASSIGNMENT:

Save all your solutions files in a folder called TKH_Prework

Now that all your solutions are saved to their files, your last step is to sign up

for and create a prework repo on Github.

Once the repo is created click on upload an existing file and select all your

solution files.

Once this is done, commit “Prework submitted” and upload them.

TO SUBMIT:

Draft an email to [email protected]

In the email subject line write “Full Name – Web Development”

Link the repo you created in the last step

Locate a current news article that deals with either network security, cybersecurity, or computer security.

(250 word and attach References)