Information Infrastructure

Do some Internet research on big data best practices. How are businesses managing their growing volumes of data and using the data that they are amassing for competitive advantage? 

 

Total word count must be 250 to 300 words in your posting. (20 points)

Do not cut and paste, please post original work.

Please provide references for your original postings in APA format.

Computer Science CSS 215

 

Instructions

Read the information below, then complete the designated tasks with your team.

Millennium Health

Doctor Johnson and Doctor Diaz recently decided that their practice needs a modern information system to support its business and health information management needs. The new system would replace a mix of paper-based and legacy systems. Dr. Johnson asked you to design an information system that could support the clinic’s current operations and future growth.

In your first meeting, Dr. Johnson provided an overview of the clinic’s business processes and staff members. He described the staff as follows:

  • Sheila Logan, office manager.
  • Support staff reporting to Sheila are:
    • Fred Brown — human resources and employee benefits.
    • Ricky Flemming reports directly to Fred and works with payroll, tax reporting, and profit distribution among the associates.
    • Aisha Fox is responsible for the maintenance of patient medical records.
    • Zane Ricardo handles accounts receivables.
    • Deb Baldwin is the insurance billing specialist.
    • Min-ji Park is responsible for managing appointments. Her duties include reminder calls to patients and preparing daily appointment lists.
    • Clare Kline is concerned primarily with ordering and organizing office and medical supplies.

After studying this information, you start to prepare for your next meeting with Dr. Johnson.

Tasks:

  1. Use the background information to create a business profile for Millennium Health. The profile should include an organization chart of the office staff. You can create the chart using Microsoft Word or a similar program, or you can draw it by hand. In Word, click the Insert tab on the Ribbon, then Smart Art, then Organization Chart.
  2. Identify six business processes that Millennium Health performs and explain who has primary responsibility for each process.
  3. Describe the systems development method you plan to use and explain the pros and cons of using this method.
  4. At the bottom of the document, list team members and explain each member’s contribution to the above tasks.  If you worked together on all tasks, then list the date and time of the meeting, how you met (Zoom, etc.), and the review process of the final document.  

SECURITY POLICY & STANDARTS

A fundamental component of internal control is the separation of duties for high-risk transactions. The underlying separation of duties concept is that no individual should be able to execute a high-risk transaction, conceal errors, or commit fraud in the normal course of their duties.

You can apply separation of duties at either a transactional or an organizational level. For example, payroll has access to employee financial records, but only payroll managers can approve raises.

Answer the following question(s):

  1. How do you define a high-risk transaction?
  2. If you were a security professional in a company, what are four roles (two sets of two related roles) you would separate and why?

Q1

Argue the need for adaptive vs dedicated mobile websites.

Requirements:

1 page with a minimum of 2 peer-reviewed references.

Calculations

 

Topic 9 Assignment to Turn In – Calculus Chapter 2

Section 2.3:  Complete problems 40 and 55. 

Section 2.4: Complete problem 80.

Section 2.5: Complete problems 56 and 92.  

Explain your answers. Show all of your work.  You may type in Word using Equation Editor or write neatly by hand and upload as a PDF.  Include copies of any graphs you make, whether by hand or using graphing software

FRAUD DETECTION SYSTEM USING MACHINE LEARNING

our chosen project subject is ”  FRAUD DETECTION SYSTEM USING
MACHINE LEARNING “

write a brief proposal (at most one-page, 12-point font, single spacing, 1 inch margins) that describes the idea for a project, the work you intend to perform, and all the people involved in the project (4 people). In particular, it should identify the project type, the problem you plan to address, the motivation for why you find the problem important or interesting, any previous work you already know about, and a rough tentative approach to solving the problem (if applicable) . 

 —————————————————————————————————————————————–

In the group project, each group (three to four students) will focus on a topic and comes with a research/technical paper by the end of the semester. The topic should be on any specific security topic, but the expectation is to define a specific problem for in-depth investigation, coming up with a new solution (conceptual or practical application) and compare with similar other approaches extensively. 

Your research project paper must include at least 15 articles from IEEE or ACM digital library and should follow IEEE format.

A good resource to search for journal and conference papers: https://scholar.google.com/

There are various types of projects you can consider:

  1. The project may be very practical in terms of applying techniques you have learned in the course to a real problem such as classification of email messages
  2. The project may involve designing or adapting existing algorithms to a novel class of problems. For example, how might we solve multiple related classification tasks? How can we improve document clustering by designing a new clustering metric?
  3. The project may consist of a theoretical analysis of a method we have discussed. For example, this may be in terms of complexity, convergence, etc.
  4. The project can be a theoretical or more applied survey of a branch of machine learning that we didn’t go through in detail. For example, you may write about the use of machine learning in different domains.

The requirement of the research project is to conduct machine learning techniques using a Weka package or other available programs. You can use any packages or any programming language.

Data can be collected from public domains or from your company.

Cloud Computing

 Chapter 6 topics:

  • Define and describe a SAN.
  • Define and describe NAS.
  • Describe how cloud-based data storage works.
  • Assume that you must select a cloud-based data storage solution for your company. List the factors you would consider when selecting a vendor.

 Chapter 7 topics:

  • Define collaboration.
  • Define and describe 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.

Exp19_Excel_Ch05_Cap_Apartments

 

#Exp19 Excel Ch05 Cap Apartments  

#Exp19_Excel_Ch05_Cap_Apartments

Project Description:

You manage several apartment complexes in Phoenix, Arizona. You  created a dataset that lists details for each apartment complex, such as  apartment number, including number of bedrooms, whether the unit is  rented or vacant, the last remodel date, rent, and deposits. You will  use the datasets to aggregate data to analyze the apartments at the  complexes.

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

Before subtotalling the data,   you need to sort the data.
 

  Select the Summary sheet. Sort the data by Apartment Complex in  alphabetical   order and further sort it by # Bed (the number of  bedrooms) from smallest to   largest.

You want to use the Subtotal   feature to display the average total deposit by number of bedrooms for each   apartment complex.
 

  Use the Subtotal feature to insert subtotal rows by Apartment  Complex to   calculate the average Total Deposit. Add a second subtotal  (without removing   the first subtotal) by # Bed to calculate the  average Total Deposit by the   number of bedrooms.

Use the outline symbols to   display only the subtotal rows. Create  an automatic outline and collapse the   outline above Total Deposit.

You want to create a PivotTable to determine the total monthly rental   revenue for occupied apartments.
 

  Display the Rentals sheet and create a blank PivotTable on a new  worksheet to   the left of the Rentals sheet. Change the name of the  worksheet to Rental Revenue. Name   the PivotTable Rental Revenue

Display the Apartment Complex and # Bed fields in Rows and the Rental   Price field as Values.

Format the Sum of Rental Price   for Accounting Number Format with zero decimal places and enter the custom   name Total   Rent Collected.

Select the Occupied field for   the filter and set the filter to Yes to display data for occupied apartments.

You want to calculate the total   monthly rental revenue if the rates increase by 5% for the occupied   apartments.
 

  Insert a calculated field to multiply the Rental Price by 1.05. Change the name to New Rental   Revenue. Apply   Accounting Number Format with zero decimal places.

Select the range B3:C3 and apply   these formats: wrap text, Align Right horizontal alignment, and 30 row height. Select column B and   set 9.29 column width. Select column C   and set 14.43 column   width.

Apply Light Orange, Pivot Style   Medium 10 to the PivotTable and display banded rows.

Insert a slicer for # Bed so that you can filter the dataset by    number of bedrooms. Change the slicer caption to # of Bedrooms. 

Change the slicer height to 1.4 inches and width to 1.75 inches. Apply Light Orange,   Slicer Style Light 2. Cut the slicer and paste it in cell E2.

Insert a timeline for the Last   Remodel field. Change the time  period to YEARS. Apply Light Orange, Timeline   Style Light 2. Change  the timeline height to 1.4 inches and with to 3.75 inches. 

The Databases sheet contains two   tables. You will create a relationship between those tables.
 

  Display the Databases sheet. Create a relationship between the  APARTMENTS   table using the Code field and the COMPLEX table using the  Code field.

You want to create a PivotTable   from the related tables.
 

  Create a PivotTable using the data model on a new sheet. Change the sheet   name to Bedrooms.   Name the PivotTable BedroomData.

Select the Apartment Name field   from the COMPLEX table for Rows,  the # Bed field for Columns, and the # Bed   field as Values. This will  display the number of apartments with the   specified number of bedrooms  per apartment complex. Display the values as a percentage   of row  totals.

Create a Clustered Column   PivotChart. Cut the chart and paste it in cell A13 using the Destination   Theme.

Select the 3-bedroom data series   and apply the Black, Text 1,  Lighter 50% solid fill color. Apply Black, Text   1 font color to the  vertical axis and category axis. Change the chart height   to 3 inches  and the   width to 5 inches, if necessary. Hide the field buttons in the  PivotChart.

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

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

Discussion

Discussion1:

According to your readings, cloud computing represents one of the most significant paradigms shifts in information technology (IT) history, due to an extension of sharing an application-hosting provider that has been around for many years, and was common in highly regulated vertical industries like banks and health care institutions.  The author’s knowledge from their research continue to assert that, the impetus behind cloud computing lies on the idea that it provides economies of scale by spreading costs across many client organizations and pooling computing resources while matching client computing needs to consumption in a flexible, real-time version. 

Identify the issues and risks that pose concern to organizations storing data in the cloud –  briefly support your discussion.

Please make your initial post and two response posts substantive. A substantive post will do at least two of the following:

  • Ask an interesting, thoughtful question pertaining to the topic
  • Answer a question (in detail) posted by another student or the instructor
  • Provide extensive additional information on the topic
  • Explain, define, or analyze the topic in detail
  • Share an applicable personal experience
  • Provide an outside source (for example, an article from the UC Library) that applies to the topic, along with additional information about the topic or the source (please cite properly in APA)
  • Make an argument concerning the topic.

At least one scholarly source should be used in the initial discussion thread. Be sure to use information from your readings and other sources from the UC Library. Use proper citations and references in your post.

Discussion2:

This is a required assignment worth 50 points (50-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. 

. Use only 50-words max per topic to discuss and present your answer.  

The discussion questions this week are from Chapter’s 6 & 7  (Jamsa, 2013).

  • Describe how cloud-based data storage works.
  • Many users do not yet feel comfortable storing data within the cloud. Discuss some steps you can take to reduce their concerns.
  • List the pros and cons of cloud-based data storage.
  • List the pros and cons of a cloud-based database.