INSY-4325-Final Project

Objective
Provide an opportunity for students to apply a technology solution to a business problem in a specific
company or organization that adds value to the organization.
Guidelines  
Step 1: Exploring Information Technology: Project-topic selection (1-2 paragraphs)
Begin thinking of a business problem that could be solved with a technology solution for a company or
organization you are familiar with. See the Course Project Technical Areas for ideas.
1. Subject of Course Project
2. Business problem statement
3. Name of the company or organization
Step 2: Course Project Proposal (1-2 pages) Graded Portion – 5 points (see rubric)
Upon the approval of Course Project Topic from your professor, complete the Course Project Proposal
using this format:
1. Subject of Course Project
2. Business problem statement
3. Name of the company or organization
4. Brief description of proposed solution
5. General benefits it will provide the organization
6. Audience to whom you are presenting the recommendation(s)
Based on the Professor’s feedback to your proposal, develop the Course Project. You are required to use a
minimum of ten credible sources for research on your proposed solution and to correctly cite all references
using APA style. Make sure you do not use more than 20% material from other sources so that 80% of the
paper should be your original words.
See the suggestions below for ideas on ways to develop your project. Use this format for the project:
Course Project Table of Contents (6 -8 pages)
Cover Page
Table of Contents
1. Abstract
2. Brief Company background
3. Discussion of business problem(s)
4. High level solution
5. Benefits of solving the problem
6. Business/technical approach
7. Business process changes
8. Technology or business practices used to augment the solution
9. Conclusions and overall recommendations

10. High-level implementation plan
11. Summary of project
References
Appendices  
Completed Course Project Graded Portion
Final Project Paper – 15 points (see rubric)
Final Project Presentation – 5 points (see rubric)

Course Project Technical Areas  
The Course Project’s focus is on the use of technology to solve specific business problems. While the list of
technologies that you can choose for your Course Project is vast, the following are some current technical
topics that you could consider in solving your business problem.
1. Cloud computing, either cloud storage, and/or cloud applications
2. User involvement in IT projects
3. Mobile devices including phones and tablets
4. B2C and/or B2B and other types of e-commerce
5. Databases required for your project
6. Infrastructure and networking (at a non-technical level)
7. Business and process reengineering to streamline a business, followed by several new business
technologies to support the new business model
8. The implementation of a secure business (website, software development, administration)
9. Development of an e-commerce website for a brick and mortar business
10. IS Management (examples: Outsourcing, ASP’s, ERP, CRM, SCM, Website Development, Linux)
11. Corporate Applications (examples: Information Security, EIS, Expert Systems, Artificial
Intelligence, DSS, Groupware, Intranets/Extranets)
12. Telecommunications and Networks (Examples: Gigabit and higher networks, SAN’s, Video
Conferencing, VoIP, Wireless networking)
13. IS Acquisitions (Examples: Cost Justification Methodology, Total Cost of Ownership, Systems
Development Life Cycle, Prototyping, Weighted Criteria Analysis)
14. Miscellaneous (Examples: Computer Ethics, Virtual Reality, Multimedia, Telecommuting, Data
Security, International Issues, Computer Based Learning)
15. End User Software/Applications (Examples: Database, Operating System, Office Suite, Project
Management)
Course Project Suggestions  
The purpose of the Course Project is to describe the solution to a business problem where technology can
be of value.
Some ideas to identify a business problem:
 Lack of competitiveness and/or profitability
 Inefficient processes
 Slow product development
 Obsolete IT organization and technologies
 Poor corporate communications
 Ongoing personnel issues
Some benefits it will provide the organization could be things like:

 Financial – profitability, revenue, product costs
 Improved competitiveness
 Better marketing positioning
 Efficiency in key processes, e.g., sales, manufacturing, development
 Improved product and/or service quality
 Improved product development
 Better and more accurate support turn-around
 Preparation for the future – how is the organization positioning itself for future growth
Some ideas on how the project could tie together:
 As an example, you could write your paper on some aspect of ecommerce. You might tie it in to
targeted advertising. You could then tie the back-end databases that are necessary to support
ecommerce. For example, how databases contain information that allows vendors to target their
audience and what those databases are.
 Another example might be the functionality of enterprise systems. You might choose a specific
enterprise system like ERP, CRM or SCM and detail how the functionality is delivered. This could
be how a business person would access this type of information.
 The business problem is high cost of IT and product development and the benefits are
profitability, faster development time, or increased sales. The solution might be cloud computing
describing the cloud computing approach taken, e.g., SaaS or cloud virtualization.
Possible audiences might be:
 Senior management
 Customers
 Suppliers
 Specific departments
Summary of Course Project Requirements  
1. The proposal must be submitted and feedback received from the professor before beginning the
project.
2. The project should follow the APA style of citing references in the text and on the bibliography
page. No fewer than ten references must be used for research and properly cited.
3. Credible reference sources are available through the School Library and other sources.
4. The paper must be 6-8 pages in length, double-spaced, using a size 12 standard business font,
using 1-inch margins and topic headings listed for the format requirements

Exp19_Excel_Ch01_CapAssessment_Training

 Exp19_Excel_Ch01_CapAssessment_Training 

 Exp19 Excel Ch01 CapAssessment Training 

  

Exp19_Excel_Ch01_CapAssessment_Training

Project Description:

You manage a company that provides corporate training workshops. Your two types of clients are business people and college professors. You want to complete a spreadsheet that calculates gross revenue for upcoming training workshops. Finally, you will improve the appearance of the worksheet by applying font, alignment, and number formats.

     

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

 

Your organization provides a   discount to educators. However, the worksheet contains wording that needs to   be changed to Education.
 

  Use Find and Replace to find Teacher and   replace it with Education.

 

The worksheet contains spelling   errors that need to be corrected.
 

  Check the spelling of the worksheet and correct the errors.

 

You canceled the Charting Basics   workshop because only one person registered for it.
 

  Delete the row containing the Charting   Basics workshop.

 

The Excel Analytics &   Forecasting training course filled, and you opened another course.
 

  Insert a new row between the Big Data   Foundations and Data Mining   rows. Copy row 5 and paste it on the empty row. Change the dates to May 7, 2021 in the range C7:D7. Enter 11 in cell G7 and 10 in cell H7.

 

 

Assigning a code to each   workshop provides a reference number. You will use 05 to indicate the fifth   month (May) and 001 for the first workshop.
 

  Type 05-001 in cell A5. Use AutoFill to   complete the range A6:A10.

 

Instead of displaying dates such   as 5/3/21, you want to display dates as 5/3/2021.
 

  Format the dates in the range C5:D10 with Short Date format (or *3/14/2012   from the Type list).
 

Note, Mac users, select 3/14/2012   as the format.

 

The worksheet contains columns   for the start and end dates. It would be helpful to insert a column to   display the number of days for each workshop.
 

  Insert a column to the right of the End Date column. Type # of Days in cell E4.

 

 

Row 3 contains # of Attendees and Gross Revenue main headings. Centering   these headings over their respective subheadings will help clarify the   details.
 

  Merge and center the cells H3 and I3. Merge and center the range J3:L3.

 

 

Applying a cell style will   improve the appearance of the headings on row 4. In addition, wrapping and   centering the text in the heading cells will further improve the appearance   of the worksheet.
 
  For the range A4:L4, apply the Good cell style, wrap text, and center   horizontally.

 

 

You are ready to calculate the   number of days for the workshops.
 

  In cell E5, enter a formula to calculate the number of days for the first   workshop. Add 1 to the results to include the total number of days, including   the start and end dates. The results may display in date format. Copy the   formula to the range E6:E10.

 

 

The number of days results show   dates rather than values. Applying the Number format will solve this issue.
 

  Apply Number format with zero decimal places and center the results   horizontally in the range E5:E10.

 

 

The gross revenue is calculated   by type of customer. Column J is designed to display the gross revenue for   corporate customers.
 

  In cell J5, enter a formula to calculate the gross corporate revenue for the   first workshop by multiplying the cost per attendee by the number of   corporate attendees. Copy the formula to the range J6:J10.

 

 

Column K is designed to display   the gross revenue for education customers.
 

  In cell K5, enter a formula to calculate the gross education revenue by   subtracting the education discount rate from 1, multiplying the result by the cost per attendee   and multiplying by the number of education attendees. Copy the formula to the   range K6:K10.

 

 

Now that you calculated the   gross revenue for corporate and education customers, you can calculate the   total gross revenue for each workshop.
 

  In cell L5, enter a formula to calculate the total gross revenue by adding   the Corporate Gross Revenue and the Education Gross Revenue. Copy the formula   to the range L6:L10.

 

 

The discount rates look better   when displayed with percent symbols and centered because the rates are all   two digits.
 

  Format the range G5:G10 as Percent Style and center the data horizontally.

 

 

The monetary values in the Cost   per Attendee, Corporate, Education, and Gross Revenue columns would look   better with dollar signs and commas.
 

  Format the ranges F5:F10, J5:L10 with Accounting Number Format with zero   decimal places.

 

 

Change the width of columns G,   H, and I to 9.
 

 

To further improve how the   number of attendees values display below their headings, you can change the   alignment and indent the data.
 

  Right-align data in the range H5:I10 and increase the indent two times.

 

Borders around the # of   Attendees and Gross Revenue sections would help distinguish data and improve   readability.
 

  Apply Outside Borders to the range H4:I10. Apply Outside Borders to the range   J4:L10.

 

 

You want to prepare the   worksheet so that your manager can print it. Because the worksheet data   consumes several columns but only a few rows, it would look better in   landscape orientation.
 

  Select Landscape orientation.

 

 

A larger top margin but smaller   left and right margins will help balance the worksheet data on a printout.   Centering the data between the left and right margins further balances   workshop revenue data on the page.
 

  Set a 1.5-inch top margin, 0.5-inch left and right margins, and center the   worksheet horizontally on the page.

 

 

Even with the smaller left and   right margins, the data does not fit on one page. Therefore, you should   reduce the scaling so that it fits.
 

  Change the scaling to 90%.

 

 

Insert a footer with the text Exploring   Series on the   left side, the sheet name code in the center, and the file name code on the   right side.

 

The worksheet is named Sheet1,   which is not meaningful. You want to add a meaningful sheet name so that it   will display in the footer. In addition, the Sheet2 worksheet is empty and   should be deleted.
 

  Rename Sheet1 as May and then delete Sheet2.

 

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

Literature Review needed for dissertation report

The topic is Inclusive City. I have developed an application that is mainly related to data visualisation. It solely focuses on accessibility needs of the people(mainly wheelchair and visually impaired users currently). The data is visualised and shown in the map as circles with different colors(one color per accessibility). The size of the circle is determined by the number of reviews each place has. The more the number of reviews, the big the circle is. Places can be any place like restaurants, museums, malls..etc The user can add a review for any place(review is solely based on accessibility and nothing else).

In short, the application is like a tripadvisor for accessibility only. There is a list view so that the screen readers will be able to read as many visually impaired users will find it difficult to access the map. I have attached few snapshots of the application.

I want a Literature Review section of minimum 5000 words backed up with references for my dissertation report. I will need it in 5-6 days.

The section should mainly include:

* Brief introduction about Inclusive City(Why cities should be accessible)

* Challenges facing the disabled people

* Why is there a need to build an application that would benefit the disabled

* The local disabled population

* Related Work

* How this application can benefit them

internship march 16

Upon completion of week 4 ssignments and discussion forum responses students should be able to:

  • Identifystrengths in personal background, employment history, and related achievements
  • Explainspecific skills to the interviewer

CIS222 Unit 1 DB: Core Principles

 1 page 

You have been hired as the new Chief Information Security Officer (CISO) for PostCyberSolutions (PCS) LLC to overhaul the cyber security program. In addition to local PCS information systems, the CISO is responsible for ensuring the various program managers maintain security compliance for customer systems under PCS security cognizance. PCS holds several government contracts in various regulatory environments making CISO a challenging position.

One of your first actions to improve the security program is to create a working group between the Information Technology, Engineering, and Security departments to foster better communication, address information system security challenges, and to work off action items. During this week’s working group meeting, an informative debate breaks out regarding the three core principles of information security and which one is most important: confidentiality, integrity, or availability. The working group debate stemmed from discussions regarding security protections for PCS’s new contract to overhaul the early warning missile detection system for the Ministry of Defense in Istanbogus.

Rank each of the three security principles in the order of importance for this system. Explain your rationale for each ranking to include any factors, criteria, and assumptions you made in selecting the order of precedence. Include at least one research reference and associated in-text citation using APA standards. In your replies to your peers discuss their ranking/rationale.

discussion

You were likely instructed about plagiarism during your undergraduate program; it is the misuse of someone else’s work, whether words, statistics, images, or other intellectual property.Try to find a story that relates to the workplace or other non-school setting if possible.

  • Summarize the incident and consequences in your own words. Citation is not required.
  • To make sure you meet the 100-word minimum requirement for the initial post, you may add a second paragraph in which you explain related issues such as reputation, employer problems, etc.
  • Provide the full URL of the source/webpage you found

Security Awareness

  

Company Description (Tech Lopes)

Tech Lopes delivers expert level IT support. We handle both software and hardware issues, as well as general maintenance and IT consultation. We have IT experts ready to provide assistance and results on data recovery, hardware repair, virus removal, and general IT support. We work with all brands of computers, smartphones and tablets in relation to both hardware and software.

Mission: 

Our mission is to provide fast, expert level IT Support and educate our customers on simple IT solutions.

Vision:

Our vision is to become the most reliable IT Support Company for consumers, and small businesses. 

QUESTIONS;

Create an Information Security Strategy Plan. Use the following outline. For each section use the heading provided and address each bulleted point.

IS Mission Statement

· Explain why you are creating this plan and what the security department hopes to achieve for the business by its implementation.

Introduction 

· Explain how this document will set priorities for the entire organization and provide standards and guidelines for reducing risk associated with computing environments.

Governance

· Explain what Information Technology roles your organization has (CIO, CISO, CISSO, etc.) and their descriptions and responsibilities. Who is leading the efforts outlined in this plan?

Strategic Objectives

· Outline strategic objectives that define where your organization needs to be to effectively manage security risks to its information assets such as:

o Data Loss Prevention

o Risk Management

o Crisis and Security Incident Management

Key Initiatives

· Expound upon programs that can be implemented to meet your strategic objectives. Include a description of each, and explain what objectives the program enables as well as its key benefits.

· Example: Initiative 1 – Information Security Awareness Training 

o Enables Objectives – Data loss prevention, improved security of system and network services, proactive risk management and crisis and security incident management 

Description – Make available information security awareness training, which serves to inform employees of their responsibilities for protecting the information in their care. To further engage the user community, the security office will work to develop a variety of information-sharing forums to include electronic and live mediums. 

o Key Benefits 

§ Better awareness of security threats and their impact on information assets 

§ Fewer security incidents 

§ Common knowledge for all staff