Compare and analyze how Confidentiality and Integrity affect IT organization security posture

Exp19_Access_Ch08_Cap – Performance 1.0

Project Description:

You have been asked to modify an Employees database that tracks employee data, company locations, and performance and bonus information.You will import a spreadsheet from Excel and a text file into the database.You will add a Hyperlink field that will store a URL for each city where the company has a location.You will also add an Attachment field that will store employee photos.You will then use imported data to enhance a query in the database, create a report, and then export it to a PDF document.

Start Access. Open the downloaded   Access file named Exp19_Access_Ch8_Cap_Performance.accdb. Grader has automatically added   your last name to the beginning of the filename. Save the file to the   location where you are storing your files.

Create   a new table in the database by importing the downloaded workbook named a08c2Location.xlsx. Use the first row   of the worksheet as column headings, set LocationID as the primary key, and   import the table as Location.   Accept all other default options. Do not save the import steps.

Create   a table in the database by importing the downloaded text file named a08c2Titles.txt. Use the first row of   the file as field names, TitleID as the primary key, and name the table Titles. Accept all other default options. Do   not save the import steps.

In   the Employees table, add an Attachment field named Photo as the last field. Save the table.

Add   the downloaded image file KFleming.jpg   for EmployeeID 3 to the Employees table.

Add   the downloaded image file PBrumbaugh.jpg   for EmployeeID 17 to the table. Close the table.

In   the Location table, add a Hyperlink field named CityInfo   as the last field. Save the table.

Add   the URL http://en.wikipedia.org/wiki/Atlanta   as the CityInfo value for Atlanta in the Location table.

Add   the URL http://en.wikipedia.org/wiki/Pittsburgh as   the CityInfo value for Pittsburgh. Close the table.

Add   the Location and Titles tables to the Relationships window. Join Location and   Employees by their common field, enforcing referential integrity. Join Titles   and Employees by their common field, enforcing referential integrity.

Open   the Performance query in Design view (right-click the query in the Navigation   Pane, and select Design View). Add the newly imported Titles table to the   query window. Drag and drop the Title field from the Titles table over the   Performance field in the query design grid so that it is placed to the left   of the Performance field. The query calculates raises for the employees based   on data in the Titles table.

Add   the Photo field from the Employees table to the last position in the query.   Run the query.

Set   the criteria in the query so that only employees on probation will display   and then run the query. Note that these employees will receive no bonus.   Modify the criteria to display employees who are not on probation. Employees   whose performance is good or excellent will receive a bonus. Run, save, and   then close the query.

Create   a simple report based on the Performance query. In Layout view, delete the   Probation and PercentIncrease fields. Adjust the column widths so that they   all fit within the page, but the data is still visible.

In   Design view, move the page numbering control to the left so that its right   edge is just inside the 7.5-inch mark on the horizontal ruler. Drag the right   edge of the report to the left so that it is just inside the 8-inch mark on   the ruler. View the report in Print Preview; the report should consist of two   pages.

Modify   the report title as Performance Reviews   and delete the logo to the left of the title.

Save   the report as Employees in Good   Standing   and close the report. Export the report as a PDF document using the same name   and publish the report. Open the report in your reader program and close the   report. Do not save the export steps.

Open   the Performance query in Design view. Add the newly imported Location table   to the query window. Drag and drop the Location field from the Location table   over the LastName field in the query design grid so that it is in the first   field position. Sort the records by Location in ascending order. Run, save,   and then close the query.

Close   all database objects. Close the database and then exit Access. Submit the   database as directed.

 What are the probabilistic constructs of Bayesian Probabilistic Theory 

 Complete this assignment in no more than 4 short paragraphs.

State your opinion on the impact of automation on the workforce. In other words, do you think automation will eliminate jobs OR automation will not, in the long run, eliminate jobs? Support your opinion by referencing your readings. In either case hypothesize how the scenario you support will affect a global economy. 

• Summarize the argument that automation will replace the human workforce using the article Prepare Your Workforce for the Automation Age*. You must use at least one short quotation. Include a citation and bibliography in APA style. You are required to create your citation(s) and bibliography using the Word references tool. Videos are provided on your Unit 02 page to help you with citations and bibliography. 

  *Knoess, C., Harbour, R., & Scemama, S. (2016). Prepare Your Workforce for the Automation Age. Harvard Business Review, 2-5. Retrieved February 11, 2017, from Harvard Business Re: https://hbr.org/2016/11/prepare-your-workforce-for-the-automation-age

OR 

• Summarize the argument that automation may not adversely affect the human workforce based on two articles Robots and Automation May Not Take Your Desk Job After All** and Automation Can Actually Create More Jobs.*** You must use at least one short quotation. Include a citation and bibliography in APA style. You are required to create your citation(s) and bibliography using the Word references tool. Videos are provided on your Unit 02 page to help you with citations and bibliography. 

**Finnigan, D. (2016). Robots and Automation May Not Take Your Desk Job After All. Harvard Business Review, 2-4.

***Mims, C. (2016, December 11). Automation Can Actually Create More Jobs. Wall Street Journal, pp. 1-2.

Structure your writing like this:

1. State your opinion
2. Support your opinion with paraphrases and at least one quotation with appropriate citations in APA style
3. Transition to a description of the counter arguments (for example, “Even though I believe X, some experts believe…”) and include at least one quotation with appropriate citations in APA style
4. Explain why you think the counter-arguments are wrong 
5. In a brief conclusion, restate or modify your opinion and refer to your first post in Unit 01. Do you think your future or current job is safe? 
6. Include citations and a bibliography in APA style

two projects, more information please see files

Week 1 discussion 

Respond to DQ for Week 1:

The system development life cycle (SDLC) is the overall process of developing software. Please describe the process and compare and contrast the SDLC with all 7 known software development methodologies available today. You may use a table for characterizing each of the development models and list advantages and disadvantages for each one. Use citations and references

Review the Rubric for Discussions in the announcement section.

Not more than 350 words total.

 Please read the attached document and provide a brief detailed response to each comment. The attached document will provide the requirements.

Overview: To avoid issues with self-plagiarism, you will focus on a “mock” dissertation topic to guide your work in professional writing. This “mock” dissertation topic CANNOT be used as your exact dissertation topic. However, it should be viewed as your practice round of setting up a study and learning the steps involved in building a high-quality dissertation.  In the discussion this week, you will indicate the topic you have chosen, the research question(s) you will use to explore the topic, and provide coaching to other classmates on their research questions.

As a reminder, here are the choices for your “mock” dissertation topic.

Students must choose from the listed topics of their school/program:

• IT Students: 
  • Enhancing Cyber Security In Healthcare -With The Help Of Machine Learning
  • Using Data Science Techniques To Enhance Data Security

Directions:

1. View the rubric to make sure you understand the expectations of this assignment. 
2. Create a discussion thread to include the following:
3. A brief discussion of the “mock” dissertation topic you chose and why.
4. The research question(s) you will use to employ to explore the topic.
5. A brief discussion of how you plan to design your study to answer the research questions from #3.
6. Reply to one other classmate (someone that does not already have a reply). Therefore, no two people should respond to one person.  In your reply, you should include: 
   1. General feedback on their topic and why/how it might be research worthy.
   2. General feedback on their research question(s) and why/how they might be answerable with research.
   3. Any additional commentary or coaching you think would benefit them as they progress with their “mock” dissertation topic.

Write a shell script, change-lines, which will substitute a string for a replacement string for each occurrence of the string in files specified.
The original file will be saved, with the same filename with the .keep extension unless the -n option is present.
 

You may use a temporary file for this script.
 

Remember the search string and or the replacement string can have special characters in them, so you must use proper quoting techniques.
 

The script will use following options:
 

the option -s “string” for the search strings
the option -r “string” for the replacement string
the -n option to prevent a backup file from being created
the -h option to print a usage statement and exit
The script will exit with an error status and print an error message:
if the -s option is not present.
if the -r option is not present.
if the string is not specified with the -s option
if the string is not specified with the -r option
if there are any other options specified
if there are no input files specified
if the input file cannot be read by the current process
if the input file cannot be written by the current process
if you cannot create the backup file.
Here is the usage statement for the script:
change-lines [-n] -s search string -r replace string files …
-n do not backup the original file
-s search string the search for this string
-r replace string replace the search string with this string
-h print this message
Examples:
 

prompt> change-lines -s foobar -r FooBar *.c
This script will edit all the files *.c, and each occurrence of foobar it will be replaced by FooBar it will be replaced by FooBar.
Each file will be backed up.
 

prompt> change-lines -s “SHELL IS NOT FUN” -r “SHELL PROGRAMING IS A LOT OF FUN” /tmp/file1.txt
 

This script will edit all the file /tmp/file1.txt , and each occurrence of SHELL IS NOT FUN will replaced by the text,
SHELL PROGRAMMING IS A LOT OF FUN. A backup file /tmp/file1.txt.keep will be created.

Write a 6-8 page paper (deliverable length does not include the title and reference pages)

• What is the basis for the protection of freedom of expression in the United States, and what types of expression are not protected under the law?
• What are some key federal laws that affect online freedom of expression, and how do they impact organizations?
• What important freedom of expression issues relate to the use of information technology?