Develop and manage complex multi-media documents spreadsheet

Assignment Help Management Information Sys
Reference no: EM131221989

Mini-Case Study

Upton, Martin, Ulysses, & Clapper (MMCU) is a medium-sized financial analysis firm specializing in conducting independent economic and market assessments for banks, insurance companies, mortgage lenders, and government regulatory agencies. MMCU also provides independent verification and validation (IV&V) services for assessments and reports that were developed internally by these entities. The firm is highly respected for its unbiased, politically neutral, objective, and accurate financial/economic products and services.

You are a Senior IT Specialist & Systems Analyst at MMCU. One of your responsibilities is to identify and recommend computer equipment for technology refreshes and new initiatives. The Senior Manager, Revolving Debt Analysis (RDA) has come to you because it is time for a technology refresh and there is a new initiative to conduct more complex, national-level analysis of credit card fraud, default, and write-off data. Specifically, banks, credit card companies, and some law enforcement entities want to see if this analysis will assist in targeting identity thieves.

The Senior Manager explains that RDA will need to refresh 35 desktop personal computers (PC). The new PCs will need to run complex calculations based on statistical models that use large amounts of data. Due to the unique nature of the datasets, data models, queries, formulas and equations and the individuality of the financial analysts and economists (many hold a PhD), the actual compute power needs to be in the desktop machine. Your task is to assess and identify the hardware needed that will allow the financial analysts and economists (collectively the users) to complete their work. The Senior Manager, RDA provided a table of requirements (see below), which shows the activities and software the PC hardware needs to support.

Table of Requirements

ID

Attribute

Type

Comments

RDA001

Windows 10 Professional(64bit)

Software

Used as standard operating system

RDA002

MS Office Professional Plus 2013

Software

Used to create documents, presentations, complex workbooks/spreadsheets, and to develop local datasets and databases.  Daily activities involve using:

  • Access
  • Excel
  • Word
  • PowerPoint
  • Outlook
  • OneNote
  • Publisher
  • Lync

RDA003

Adobe Acrobat X Suite

Software

Used to create PDF documents; combine audio, video, and presentation slide; develop media from multiple types of input; and create interactive documents and presentations.

RDA004

SAS 9.4

Software

Used for financial, fraud, and related data analytics work.

RDA005

MatLab R2014b

Software

User for programming and algorithm development, data analysis and visualization, and numeric computations.

RDA006

Stata 13 (Stata/MP) for Windows

Software

Used for forecast, multiple mixed-effect and linear models, linear and non-linear combinations, generalized predictions, and statistical and data tests.

RDA007

R for Windows

Software

Used for data manipulation, calculation and graphical display.

RDA008

MS Outlook 2013

Software

Used to connect with MS Exchange for emails, calendar, contact lists, address books, and reminders.

RDA009

McAfee Endpoint Protection - Advanced Suite

Software

Used for antivirus, firewall, email and data protection.

RDA010

Connect to network data marts, data warehouse, databases, and datasets

Activity

Analysts and economists need to conduct data mining, compile and analyze data, and produce complex reports.

RDA011

Participate in online, real time conferences and training

Activity

Used for professional development and gather information on market trends.

RDA012

Write complex queries to run jobs and calculations on local and server based datasets and databases

Activity

This is a regular and normal work activity for this organization's users.

 

Once started, some jobs may take hours to complete.

RDA013

Create, edit, and manage audio and video files

Activity

This is a regular and normal work activity for this organization's users.

RDA014

Import, edit and manage digital photos

Activity

This is a regular and normal work activity for this organization's users.

RDA015

Create local datasets and databases

Activity

This is a regular and normal work activity for this organization's users.

RDA016

Develop and manage complex multi-media documents, spreadsheets, and presentations

Activity

This is a regular and normal work activity for this organization's users.

RDA017

Consolidate complex multi-media documents, spreadsheets, and presentations to develop interactive Web-based reports

Activity

This is a regular and normal work activity for this organization's users.

The Assignment& Deliverable

This is an individual assignment. You must work on your own.

The assignment is to analyze the mini-case and table of requirements to assess and identify the hardware needed that will allow the financial analysts and economists (collectively the users) to complete their work. The focus must be on the internal hardware components (motherboard, CPU, RAM, bus, hard drive, connectors & ports, etc.). Do not simply visit a PC/Workstation manufacturer's site (Dell, HP, etc.) and select a machine. This will not be successful. You must identify each component; determine its size, capacity, speed, etc.; and show how each requirement will be met.

The deliverable is an MS Word document based on the template embedded in this document.(I HAVE ATTACHED THE TEMPLETE YOU WILL BE USING) The audience for the deliverable is the Senior Manager, RDA; other RDA managers and supervisors; and selected RDA users. The expectation is RDA will be able use the report and work with Procurement to develop a Request for Quotation (RFQ).

Here is what you need to do:

1. Click on icon to launch the template and save it to your desktop.

2. Please do not deviate from the formatting contained in the report template.

3. Follow the content instructions in the various sections of the document to complete your work.

4. All narrative content must be single spaced, Arial 12 point.

5. All table content must be single spaced, Arial 10 point.

6. Review and use the Evaluation & Scoring Rubric below to ensure the report contains an appropriate level of information.

7. External research and a References page are required.

a. You must use of at least three (3) external sources. This is in addition to any course materials from assigned readings and videos.

b. You should use scholarly, vendor, and industry materials.

c. Do not simply copy and paste information from the Web or copy information from the readings or other sources.

d. Provide the appropriate APA formatted citationson the References page to avoid the perception of plagiarism. This includes citing all external sources including the vendor Web sites, assigned readings and videos, the mini case, and other sources, as appropriate.

e. Wiki sites such as Wikipedia and authorless sites/blogs are NOT acceptable references.

f. If you are not familiar with the APA style and citations, there are also several links under Webliography that can assist you.

g. MS Word has a Citations & Bibliography feature located under the References tab. Select APA in the Style field and use the Manage Sources feature and MS Word will properly format the citations for you. When ready use the Bibliography drop down to insert citations.

h. At all costs, avoid any hint or perception of plagiarism.

8. Be sure to check for spelling, grammar and format errors prior to submitting the report. These are all items that will be evaluated and scored.

Attachment:- hardware_evaluation_report_template.rar

Reference no: EM131221989

Questions Cloud

Cause of the seizure was not determined : After testing was performed, the cause of the seizure was not determined, as the physician stated the patient did not have epilepsy. What is the principal diagnoses?
List two skus that were purchased most frequently together : List the two SKUs that were purchased most frequently together. List the three SKUs that were purchased most frequently together. List the four SKUs that were purchased most frequently together.
Define and apply social contract theory : Define and apply social contract theory. Is it appropriate for organizations like the one in the video to use a U.S. law (Fair Labor Standards Act of 1938) to offer low wages for its disabled workers? Why or why not?
Has the crisis worsened or eased : Has the crisis worsened or eased? Has it affected other European or non-European economies? - Have events followed the typical pattern of financial crises?
Develop and manage complex multi-media documents spreadsheet : Provide the appropriate APA formatted citationson the References page to avoid the perception of plagiarism. This includes citing all external sources including the vendor Web sites, assigned readings and videos, the mini case, and other sources,..
Derive an efficient method for computing ranking cube : Extend your framework to handle more advanced measures. One such example could be as follows. Consider an organization donation database, where donors are grouped by "age," "income," and other attributes. Interesting questions include: "Which age ..
Roles and interrelationships among physicians : Given the roles and interrelationships among physicians, nurses, and other health service professionals, distinguish the health information management profession.
Discuss how dollarization might have changed : some economists advised Argentina to dollarize, that is, to eliminate the peso and use the U.S. dollar as its currency. - Discuss how dollarization might have changed.
Effort to stabilize the process : In an effort to stabilize the process, there was some discussion about "those 3 machines."These 3 machines have an 'apparent' effect on the material thickness (measured prior to plating).

Reviews

Write a Review

Management Information Sys Questions & Answers

  Chris and pat aquino want you to begin creation of a secure

chris and pat aquino want you to begin creation of a secure yet user-friendly interface for the buysell database. they

  How you use collaborative knowledge-sharing in mis class

Explain how you use collaborative knowledge-sharing in your MIS class. Differentiate between techniques that are sponsored by your professor and techniques that you and your classmates have evolved on your own.

  Backdoor accessaccess controls are good things and should

backdoor accessaccess controls are good things and should be secure but programmers continually add backdoor access to

  Analysis of a company proposal for a performance management

analysis of a company proposal for a performance management systemthis week you will start working on your final

  Describe the major components of it infrastructure

Describe the major components of IT infrastructure and What types of relationships are possible in a relational database? Describe and give an example of each

  Explain the purpose of a university security policy

Explain the purpose of a university security policy and indicate the major reasons why they are necessary. Provide your opinion as to whether a university security policy is more or less important to have than a business security policy

  Develop a three-level wbs

The project is to build an Under Armour store at an overseas location in an US base in Kadena, Japan. Develop a three-level WBS (project level, milestone level, and task level)

  Efficiencies between operating departments

Would implementing an enterprise resource planning system help streamline operations and achieve efficiencies between operating departments? What major concerns need to be addressed

  Healthcare key informaitonhow have various branches of the

healthcare key informaitonhow have various branches of the government influence the way we run our health facilities

  Definitions of cyber terrorism

From the second e-Activity, among the three (3) definitions of cyber terrorism, give your opinion as to the one (1) definition that is the most accurate with regard to information security and infrastructure protection

  Develop redesigned processes along with new flowcharts

Propose some process improvements to the flowcharts, and develop redesigned processes along with new flowcharts. How will your suggestions address the sources of dissatisfaction that customers cited?

  Cad technology versus drafting techniqueswhat kind of

cad technology versus drafting techniqueswhat kind of benefits are marine companies achieving by using cad technology

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd