Computer Science

 

Required Resources

The following resources will be used to complete your assignment:

  • Microsoft Excel

You will analyze the data you collected and provided in your assignment last week. As you are working on each of the steps below, think about the analysis that you will provide to the research team. Follow the steps below to complete this analysis.

  1. Copy the file you created in week 5 and rename the new one “YourName_COMP150_W6_Assignment”.
  2. Open the file and duplicate the sheet where the initial table and data were created
  3. Rename the new sheet as “sorting & filters” and move it to the right of the original sheet
    1. Make the data look professional by using formatting options such as borders and table styles to place the data into a table.
    2. Select one of the text-based data columns such as names, cities, or addresses and sort the data by Z to A.
    3. Create a custom filter to any part of the data except where you did the sort. For example, if you sorted by the patient’s name, then filter another set of data.
  4. Duplicate the original sheet again and rename it as “conditional formatting”. Move it right after the “sorting & filters” sheet.
    1. Implement conditional formatting to any of the number-based data sets. For example, showing higher numbers in green, while showing lower numbers in red.
    2. Add an IF function and apply it to the entire set. For example, you could create a function that says if x number is higher than x number, then you are at risk. The purpose is to show how an IF function works so creativity is permitted in how you use the function.
  5. Use the “conditional formatting” sheet to create a pivot table.
    1. The pivot table needs to be on its own sheet.
    2. The pivot table needs to be meaningful so make sure to select data that will make it clear for your analysis.
    3. The pivot table should have data selected on the columns, rows, and values fields. Make sure to consider the data when adding the selection of the value
  6. Create a minimum of two charts. Make sure to select the right chart that explains your analysis. Each chart should be on its own sheet and should have a title. Make sure the purpose of the chart is self-explanatory just by looking at it.
  7. Update the documentation sheet
    1. Update the date.
    2. Add all the new rows for the sheets created.
    3. Provide a brief written analysis for each of the new sheets. Explain what you want the research team to learn about each sheet.
  8. Review all the sheets to ensure it looks professional. Try to keep the same style, colors, and formatting, Make sure the file is named “YourName_COMP150_W6_Assignment” and submit the file.

Grading

This activity will be graded based on the Week 6 Assignment rubric.

Course Outcomes (CO): 4

Due Date: By 11:59 p.m. MT on Sunday

 

Textbook Reading

Below you will find the textbook reading for the week. Remember to complete your reading by Wednesday to be prepared for the week!

Microsoft Office 2016 at work for dummies (Links to an external site.)

  • Sorting & Filtering – Chapter 10
  • Quick Analysis Tool – Chapter 8
  • Conditional Formatting – Chapter 9
  • IF Function – Chapter 8
  • Pivot Tables (Links to an external site.)
  • Charts – Chapter 11
  • Cell borders, shading, and formatting – Chapter 9

Week 2 Discussion Due TONIGHT

 For  this discussion, you will need to address all the tasks below and be  sure to participate fully by responding to your classmates as well.  Citations should be used to support your analysis and references should  be included in APA format. Before you begin, be sure to review the Discussion Question Guidelines!  

Now that you have been introduced to some advanced features in  Microsoft Word, you will teach the class an advanced skill in it. In  this discussion, select at least one advanced feature of Microsoft Word  and, using your own words (no copying and pasting) and examples, teach  your classmates this skill. Check the posts on the discussion board to  choose something no one else has shared yet!

In your discussions with your classmates, see if you can follow their directions or offer any help to problems they had.

You can also offer any help with challenges your classmates have shared.

By Thursday, December 10, 2020, make your initial  post to the Discussion Area. After you post your initial submission, be  sure to respond to at least two of your classmates, and to the professor  when appropriate, by Monday, December 14,2020, on at least two different days of the week.  /content/enforced/71846-17093625/Week_Two_Discussion_Question1.pptx  

3 page essay

 

Researchers of five European universities have developed a cloud-computing program that allows robots connected to the Internet direct access to the powerful computational, storage and communications infrastructure of modern data centers for robotics tasks and robot learning

What does this mean for security?

Will Robots Run Security soon?

How will this impact Cloud Technology jobs? 

Additional resources should also be considered.

Use APA for referencing.

https://www.securitymagazine.com/articles/84122-cloud-platform-could-lead-to-faster-smarter-robots

Computer science

-What do you understand by ‘Database’?
-Define DBMS
-Define RDBMS.
-Enlist the advantages of DBMS
-What do you understand by Data Redundancy?
-What are the various types of relationships in Database? Define them

Project Assignment:

 

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

  • What are the key elements of a multilayer process for managing security vulnerabilities based on the concept of reasonable assurance?
  • What actions must be taken in response to a security incident?
  • What is computer forensics, and what role does it play in responding to a computer incident?

Provide three articles to substantiate the above three questions.

Using the APA format provide a citation for each of the articles you read

Suggestion: Use a search engine (Google) and keywords

Cloud Computing

Discuss in 500 words or more  federated architecture in cloud systems. Remember that this is a cloud class not a database class.

A hybrid threat is mixed-variety or a complex threat.

A hybrid threat is mixed-variety or a complex threat. Use the current readings, the Web, IT magazines, the CU digital library, and/or other reliable resources and research complex threat platforms like TDSS, Zeus, Zbot, etc. Discuss your findings and overall thoughts.

350 words with citations. 

No plagiarism

Week 6 Discussion

 

This is a required assignment worth 20 points (20-points/1000-points). Assignment must be submitted by the due date. No late assignments are allowed. Please discuss the following topics and provide substantive comments to at least two other posts.

Select from the following list four (4) topics and discuss. Use only 50-words max per topic to discuss and present your answer.  The discussion questions this week are from Chapter 7 (Jamsa, 2013).

Chapter 7 topics:

  • Define collaboration.
  • Define and describe the cloud-based collaboration.
  • The CIO of Ace Accounting Services suggests that the company can save considerable money using VoIP for phone calls. Define and describe VoIP. Then present three companies that provide VoIP offerings. Compare and contrast each company’s offering. Also, discuss whether or not you agree with the CIO and justify why.
  • List the questions one should consider when evaluating a cloud-based collaborative solution.

NOTE: You are required to use at least two-peer reviewed sources (besides your textbook) to answer the above questions.  The initial post is due by Wednesday at 11:59 pm ET.  You must engage on at least three separate days (by Wednesday for the first post and two additional days of peer engagement).  Do not wait until Sunday to engage with peers, this should be an active conversation with your peers.  When replying to peers be sure to engage with substantial posts that add to the conversation.

Benefits and Drawbacks

Discuss in 500 words, why institutions might be reluctant to move their IT to the cloud. Consider a specific industry like education, medicine, military, etc. 

Use at least three sources  Include at least 3 quotes from your sources enclosed in quotation marks and cited in-line by reference to your reference list.  Example: “words you copied” (citation) These quotes should be one full sentence not altered or paraphrased. Cite your sources using APA format. Use the quotes in your paragraphs.  Stand-alone quotes will not count toward the 3 required quotes. 

 

Write in essay format, not in bulleted, numbered, or other list formats. 

Do not use attachments as a submission.