All posts by : chebby

1.Define the role of the Systems Analysts versus the Business Analyst.
2. Define the Systems Development Life Cycle.
3. Define the concept of Organizations as Systems.
4. What is a Systems Perspective?
5. Describe the Organizational Levels of Management.
6. Define the major roles within an Information Technology department and
    which ones have Direct Interaction with Customers. 

 You are an intern for Hicks Financial, a small trading company located in Toledo, Ohio. Your intern supervisor wants you to create a report that details all trades made in February using current pricing information from the Dow Jones Index. To complete the task, you will import and shape data using Power Query. Then you will create data connections and visualizations of the data.

Use   Get & Transform tools to import and transform Table 0 located in the file   e10m1Index.txt. Split the company column using space as the delimiter at the   left-most occurrence. Rename the respective columns Symbol and Company. Remove the columns Change, %Change, and   Volume. Name the table Dow and load it to the existing worksheet.
  Hint: Get Data is located on the Data tab in the Get & Transform Data   group.

Name the worksheet Current_Price.
  Hint: Double-click the worksheet tab to edit the sheet name.

Use Power Query to import trade   data located in the workbook Exp19_Excel_Ch10_GRADER_ML1-TradeInfo.csv.   Before loading the data, if necessary use the Power Query Editor to remove   the columns that contain NULL values. Split the company column using the left   most space as the delimiter and rename the respective columns Symbol and Company Name.
  Hint: Get Data is located on the Data tab in the Get & Transform Data   group. Click Edit on the Import window to load the Power Query Editor. 

Rename the worksheet Trades.
  Hint: Double click the worksheet tab to edit the sheet name.

Add the Dow table and the Exp19_Excel_Ch10_GRADER_ML1-TradeInfo   table to the Data Model.
  Hint: Manage Data Model is located on the Data tab in the Data Tools group.

Use Power Pivot to create the   following relationship:
 

  Table
Exp19_Excel_Ch10_GRADER_ML1-TradeInfo
 

  Field
Symbol
 

  Table
Dow
 

  Field
Symbol
 

  Hint: Relationships is located on the Data tab in the Data Tools group.

Use Power Pivot to create a   PivotTable with the EXP19_Excel_Ch110_GRADER_ML1_TradeInfo Date field as a   Filter, Last Price as a value, and the Dow table Company Name as Rows.
 

  Hint: Power Pivot is an Excel add-in that must be loaded. Power Pivot can be   loaded by accessing COM add-ins in Excel options. Once loaded, the Power   Pivot tab is located on the Office ribbon.

Create a Clustered Column   PivotChart based on the PivotTable that compares the trading price of Apple   and Coca-Cola stocks.
 

  Hint: PivotChart is located on the Analyze tab in the Tools group.

Add the chart title Trading   Comparison,   apply Accounting Number Format to cells C4:C5, and name the worksheet Price_Comparison.
  Hint: Chart elements can be added or edited on the Design tab in the Chart   Layouts group. 

Delete Sheet 1, if necessary.
 

  Hint: Delete is located on the Home tab in the Cells group.

It is time to complete your sales tracker application. Your marketing department would like the current dollar amount of goods sold this year to be calculated. Total of the goods sold is the combined total of supplies, services, and paper sold, for all sales accounts. This information will be used to promote the success of the company.
Your application needs to be modified to allow all sales personnel to enter their sales data.
For each sales personnel in the company, complete the following:
F1: Accept a sales person’s entry for the dollar amount of office supplies sold, books sold, and apparel sold.
The sum of these three categories will be the total of their supplies sold.
F2: Accept a sales person’s entry for the number of hours of service hours sold and rate per hour.
F3: Accept a sales person’s entry for the number of pounds of paper sold and the price per pound.
Displays the total current sales to date in all 3 categories for the sales person: supplies, books, and paper.
Modify the application to display the total aggregate sales for all sales personnel combined.
Example: Total sales for 2010: $12,500,552
Your application will use the Accounts inheritance hierarchy designed previously to compute the total of goods sold.
There are three types of sales accounts that track sales for your company:
Supplies
Services
Paper.
Each has their own formula for computing the current sales:
Supplies = office supplies sold dollar amount + books sold dollar amount + apparel sold dollar amount
Services = number of hours * rate per hour
Paper = number of pounds * price per pound

 Kavis, Michael J. (2014). Architecting the Cloud: Design Decisions for Cloud Computing
Service Models, (3rd Edition). Hoboken, New Jersey: John Wiley & Sons, Inc., ISBN-
13: 978-1118617618 

A travel company supports international travellers . Discuss the legal and ethical issues associated with the company’s collection and se of data

You and your group will research an advanced telecommunications and network security topic. For this paper, you can pick your own research topic as long as it relates to the objectives of this course. When you decide your topic, you need to obtain my approval. Your task is to write a report summarizing your research (about 6-10 pages). The writing should be original. Before you begin writing your report, you need to read as many references related to the subject as you can. Basically, you would feel a bit insecure writing about a topic until you have digested and completely understood several references. You will have a table of contents for the paper with sections as shown in the suggestions below:: • Abstract section summarizing your research • Introduction section: this section provides an overview or background of the topic and its purpose, including o Define the subject area, and why is this subject important? • Body of work sections: o What are the key issues (pros/cons, if appropriate)? o Identify benefits, obstacles, innovations as appropriate o Methodology: key ideas, summaries, measures, analytical discussions, etc. • Conclusion section: analyze and summarize your findings, state your opinions, conclusions, recommendations. It is common for such a paper to suggest new ideas, critique some of the existing ideas, and propose some new directions. • References section: Sources and references need to be cited properly using APA format. Around 10 or more references are appropriate, some of which must be scholarly peerreviewed articles

Enhance your UI using an HTML editor (such as Notepad++) to include a separate CSS, and with JavaScript to take and validate a text input.

• Use one of the following methods to turn in your assignments
  • If you are using a server
    • ZIP your files and provide the URL to the assignment
    • Upload your files
  • If you do not have server access
    • ZIP your files and provide a screenshot of the assignment
    • Upload your files

How is Cloud Computing different from a simple Client-Server architecture? How is Virtualization different from Cloud Computing? Which is the best to use and why?

 You will use Microsoft Project to create a Gantt chart for your e-commerce company project. Use Microsoft Project to create a Gantt chart identifying the major and minor tasks, illustrating dependency relationships between activities.  Create an initial information systems project plan for a new startup company.

Write an essay of at least 500 words discussing the Safe Harbor provisions under HIPAA.  

Do not copy without providing proper attribution. This paper will be evaluated through SafeAssign. 

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

Use the five paragraph format. Each paragraph must have at least five sentences. Include 3 quotes with quotation marks and cited in-line and in a list of references. Include an interesting meaninful title.

Include at least one quote from each of 3 different articles. Place the words you copied (do not alter or paraphrase the words) in quotation marks and cite in-line (as all work copied from another should be handled). The quotes should be full sentences (no more, less) and should be incorporated in your discussion (they do not replace your discussion) to illustrate or emphasize your ideas.

Cite your sources in a clickable reference list at the end. Do not copy without providing proper attribution (quotation marks and in-line citations).

It is important that you use your own words, that you cite your sources, that you comply with the instructions regarding length of your submission Do not use spinbot or other word replacement software. Proof read your work or have it edited. Find something interesting and/or relevant to your work to write about.