Assignment Question

Class,

It was only June 29th, 2007 when the first iPhone came out, but it feels like we have been living with these devices and their apps for much longer. Smartphones have created a new way of living. We are always connected, have instant access to information, instant directions to any location, and much more. The mobile experience is now expected, and enterprises have to adapt and provide these experiences to their customers, employees, and partners.  

  • Discuss why mobile application development is considered unique in comparison to website development. 
  • How has mobile application development impacted the use of Smartphones?  Explain
  • Why are mobile apps an expected part of enterprise development and marketing?

To participate in the Discussion, respond to the Discussion prompt by Day 3. Then, read a selection of your colleagues’ postings. Finally, respond to at least two classmates by Day 5 in one or more of the following ways:

  • Complete the Week #3 Discussion by the assigned due date.  Late assignments will not be accepted. 
  • This is a required assignment and is worth 25 points.
  • You must apply and use the basic citation styles of APA.
  • Do not claim credit for the words, ideas, and concepts of others.
  • Use in-text citation and list the reference of your supporting source following APA’s style and formatting
  • Do not copy and paste information or concepts from the Internet and claim that is your work.  It will be considered Plagiarism and you will receive a zero for your work.
  • Use this link to access the Discussion Board

Return to this Discussion in a few days to read the responses to your initial posting. Note what you have learned and/or any insights you have gained as a result of the comments your colleagues made.

Career Project

you will pick any career the easiest one you can do, I prefer Technology Carrer.

As part of the course, there is a required final project.

  • This project is for you to begin/continue researching potential career fields you are interested in pursuing. This final project is an opportunity to explore something that you are passionate about. Remember, career paths are not linear….they often look like a bowl of spaghetti…and that’s okay! I was determined to be swimming with the dolphins in Hawaii and perpetually smelling like halibut….but my focus changed and now here I am in my true calling.
  • How you decide to present that material to me is up to you…BE CREATIVE! If you would like to write a paper, great. If you want to tape yourself giving a presentation-fantastic. If you want to make a Glogster (online poster)-wonderful. If you want to do a taped skit-superb. I am completely open to anything, as long as I can access it, it covers the required information and it’s your own work.

Dissertation

Part 1

 Overview: Using mentor or model texts is a strategy to improve your own writing.  The New York Times describes mentor texts as, “Demystifying the writing process via examples students can learn from and emulate.” In this assignment, you will locate a mentor text in the form of a dissertation that may or may not be similar to your own topic to use as a model while you write your chapter 2.  It is most helpful to find a dissertation with a literature review similar to your own, but if that is not possible, you may look for the next best option. Directions:

  1. Use ProQuest Dissertations & Theses Global database on the UC Library website to locate mentor text dissertation (preferably it would be related to your topic). 
  2. You may need to use advanced search options to help narrow your search. 
  3. Scan read the entire dissertation.
  4. Carefully read the literature review section.
  5. Provide a one-paragraph summary of the entire literature review.  
  6. Write a second paragraph about what you learned through reviewing chapter 2. 

Additional Information: ProQuest Dissertations & Theses Global database is accessible through the Databases link below the blue picture on the Library website. The Databases tab will access an alphabetical list of the Library databases. The dissertation database is listed twice, as Dissertations and Theses and as ProQuest Dissertations and Theses. Both links access the same database. Many of the dissertations published since 1997 are available in full text with a link to the PDF. Here is the link to the P section of the database listings https://ucumberlands.libguides.com/az.php?a=p 

My Dissertation topic is Cyber Security

Part 2

Please write 250-300 words on the gaps on the research work done on Cyber security and literature review for the same. Please use the attached document as a reference to narrow down the gaps that can be researched further on. 

Create a Risk Assessment Team

 Task Requirements

Imagine that you are a new manager responsible for the IT team in a start-up company that provides hosting services for online storefronts. Shortly before you were hired, the IT systems were compromised, resulting in the services going offline for almost 24 hours before services were restored. As a result, the business suffered financial losses that it could ill afford as a start-up company.

The CEO of the company has directed you to put together a plan to mitigate future risks. The first step is to assemble a team of subject matter experts to help you create the plan. The CEO wants to review a list of the recommended team members before you proceed with the plan. You need to create a list of recommended team members in a form for submission to the CEO. In creating the recommendation, evaluate each role selected, documenting the value that the team member will bring to the process. Also, document any potential issues where team members might have conflicting priorities and you would resolve any conflicts.

Access, Powerpoint, Excel, Word Pro

Project Overview

The course final project is designed for you to apply the software application skills you acquired during the term. For this project, you will use all four of the Microsoft Office applications to create a unified project on a single topic. The instructions below are not step-by-step instructions – as part of the previous assignments you’ve already learned how to carry out various functions in Word, Excel, PowerPoint, and Access. Instead, the information below details the requirements for the final project. If you need assistance with “how to do something in one of the Office applications” return to your SIMnet MS Office textbook. You can access this via the “Library” link in the top right-hand corner of SIMnet.

Software Requirements

You must use the following software applications to create the final project:

• Microsoft Word 2019

• Microsoft Excel 2019

• Microsoft Access 2019

• Microsoft PowerPoint 2019

No other versions of Office may be used. If you’re missing any of the above applications, keep in mind that the computers in the Open Computer Lab (DTEC 462) have all these applications available for your use.

Project Topic

Your project topic is your intended major/career.  You should begin developing your project after researching your intended major and career via the Careers in IT sections of the textbook and websites linked in Module 13.  This is the focus of your final project. You will use ALL the Office applications to create content related to your chosen topic. 

Project Minimum Requirements

The minimum requirements for each of the four applications are detailed in the checklists below.

  1. Each application component is valued at 65pts.
  2. There are 40 points (10 pts each application) allocated for professionalism, effort, and creativity.
  • Professionalism is assessed in evaluation of proper use of the required skills (e.g. competent in tables), grammar, spelling, and overall appearance.
  • Effort is assessed in whether the presentation exceeded the minimum requirements
  • Students who meet only the minimum requirements for each software application may not receive the 40 points for professionalism, effort, and creativity.
  • Creativity is demonstrated by applying the software skills acquired during the term.
  • Creativity is measured in various ways, including:

o  applying additional skills covered in the course but not listed as a minimum requirement,

o  adding additional graphics or pictures,

o  applying varying color schemes,

o  creative formatting of the Excel chart,

o  using various design backgrounds with presentation slides,

o  creating your own slide background instead of using a design template,

o  adding a border to the Microsoft Word document component,

o  graphically editing pictures and other graphics,

o  adding external sounds or movie clip in the PowerPoint component, etc.

  1. This project must be an original creation, not a copy and paste from this semester’s assignments. All rules concerning Academic Dishonesty and Plagiarism will be strictly enforced.
  2. The project must be based on your original work.

Microsoft Access – (65 points)

___1. Create a database and name the file using your last name_final project

___2. Create a table

___3. Create a minimum of 5 fields in table

___4. Create a minimum of 6 records in table

___5. Assign a primary key (note the primary key must be unique for all possible data)

___6. Create a form based on table

___7. Create a query containing 3 fields – your choice of fields

___8. Create another query containing 4 fields – sort the query on your choice of field

___9. Create a query with at least 3 fields and restrict the query results with your choice of criteria

___10. Create a report based on table or one of queries

Microsoft Excel – (65 points)

___1. Create an Excel workbook and name the file using your last name_final project

___2. Create a worksheet with a minimum of 5 columns (title each) – apply formatting other than Excel’s default.

___3. Add a minimum of 7 rows to the worksheet (title each) – apply formatting other than Excel’s default. and 7 rows

___4. Create formulas in no less than 4 cells, these are separate from the functions in #5 and must be 4 different formulas

___5. Use the MIN, MAX, and AVERAGE functions

___6. Create a title for the worksheet merging and centering the text using a minimum of 5 cells – apply formatting other than Excel’s default.

___7. Rename the Sheet Tab using your last name and apply color to the sheet tab.

___8. Create a chart on separate sheet using the data on the main sheet; name the sheet tab Chart

___9. Add Sparklines to one or more pieces of data

___10. Change the Number Formatting from General to a Number Format of your choosing to one or more rows/columns of data

Microsoft PowerPoint – (65 points)

___1. Create a presentation and name the file using your last name_final project

___2. Use a minimum of 10 slides. Each slide must have a title.

___3. Select a design theme or create your own theme.  Use high contrast font color based on the color of the slide background.

___4. First slide must be title slide layout with your name, course and section number

___5. Add a picture of your face on the title slide and apply a style to the picture

___6. Use the Notes Pane to add a slide note to at minimum 1 slide

___7. Add a footer to the presentation with the date of development or slide number

___8. Add Online Pictures or other graphics to a minimum of 4 slides

___9. Add WordArt to at least one slide

___10. Apply slide transition to all slides in the presentation

___11. Use a SmartArt Diagram

___12. Add entrance effects to at least 1 text and 1 piece of Clip Art

___13. Create a table with a minimum of 2 columns and 3 rows

___14. Create a simple column chart

___15. Add a title to the chart

___16. Last slide must indicate that the presentation is ending

Microsoft Word – (65 points)

___1. Create a document and name the file using your last name_final project

___2. Apply a document theme that is different from the default “Office” theme

___3. Set margins to 1.25-inch top and bottom and 1.50 inch left and right

___4. Set line spacing to double

___5. Set paragraph spacing to before: 6, after: 6

___6. Create a header with your full name aligned left and the course number & section number aligned right

___7. Create a footer with the page number centered to the page

___8. Create a bulleted list, or numbered list, with a minimum of 2 items in list

___9. Add a picture of your face

___10. Create a title for your document: font of your choice, 14pt or larger, bold, italics, color (change from default of black), set to Small Caps, and centered to the page

___11. Create a subtitle for your document: format it using the Subtitle Style

___12. Document must be no less than 150 words

___13. Insert a comment within the document

___14. Using the Advanced Document Properties, add a Title, Subject, and update the Author to Your Name

Sending (uploading) the Project

  1. Launch MyHCC/Canvas
  2. Navigate to the Final Project Module
  3. Upload all files to the Final Project Submission link, be sure all 4 files are attached before clicking Submit.

Grade Point Distribution – 300 Points

Microsoft Access

65

Microsoft Excel

65

Microsoft PowerPoint

65

Microsoft Word

65

Professionalism, effort, and creativity

  • Professionalism is assessed in evaluation of proper use of the required skills (e.g. competent in tables), grammar, spelling, and overall appearance
  • Effort is assessed in whether the presentation exceeded the minimum requirements
  • Students who meet only the minimum requirements for each software application may not receive the 40 points for professionalism, effort, and creativity.
  • Creativity is demonstrated by applying the software skills acquired during the term.

Creativity is measured in various ways, including:

  • applying additional skills covered in the course but not listed as a minimum requirement,
  • adding additional graphics or pictures,
  • applying varying color schemes,
  • creative formatting of the Excel chart,
  • using various design backgrounds with presentation slides,
  • creating your own slide background instead of using a design template,
  • adding a border to the Microsoft Word document component,
  • graphically editing pictures and other graphics,
  • adding external sounds or movie clip in the PowerPoint component etc.

This project must be an original creation, not a copy and paste from this semester’s assignments. All rules concerning Academic Dishonesty and Plagiarism will be strictly enforced.

40

Total Points

300

Deliverable 2-Effective Data Visualization

Assignment Content

  1. Competency
    Determine audience needs for effective data visualization.

    Student Success Criteria
    View the grading rubric for this deliverable by selecting the “This item is graded with a rubric” link, which is located in the Details & Information pane.

    Scenario
    You are the facility manager for EnVision, a high-tech vehicle maker located in Atlanta. This new company designs, manufactures, and sells electric vehicles and charging units. EnVision’s unique designs, technical prowess, and limited competition has placed them in the enviable position of having a high demand for their line of products. This demand has generated over a billion dollars in pre-sale orders, and a new manufacturing facility is required to meet customer’s needs. The firm’s CEO, Mark Hammel, has asked you to select a new site that will accommodate a new state-of-the-art facility. EnVision is a privately held organization that consists of a board of directors, management and staff, all of whom are familiar with data visualization presentations.

    The existing 600 employees and a handful of investors also have an interest in the company’s success. All of the EnVision employees are acquainted with the company’s operations and goals and have at least a high school education; they do not want their employment jeopardized. A small group of investors is also interested in any decisions that might affect the firm’s bottom line. The extent of data visualization techniques is unknown by these two latter groups.

    Instructions
    The CEO, Mark Hammel has asked you to help him plan for a presentation for sharing your findings on the site selection and other information, to be presented to all levels of the company in an internal meeting. Your site selection criteria need to be presented and explained by all the various entities within EnVision. Be sure to include the following, being mindful of your visual presentation of the data and information.
    Create a presentation report that includes the following:

    • Identification of the needs and goals of the various stakeholder groups.
    • Evaluation of the audience member’s background and skills.
    • Definition of the motivating factors for audience participation in the presentation.
    • Compare and contrast the desired outcomes of the visuals to be included in the presentation.
    • Resources
    • For assistance on creating a presentation report, please visit the Rasmussen College Answers page.
    • For additional writing assistance, please visit the Rasmussen College Writing Guide

Exp19_DSP_Access – Business 1.0

 

Exp19_DSP_Access – Business 1.0

Project Description:

You are the assistant director for the Information Technology (IT)  department at Healthy Living Motorcycles, Inc. In addition to overseeing  hardware and software selection, system maintenance, and employee IT  training, you create and maintain databases for the whole organization.  The organization uses one central database rather than maintaining  several individual ones to reduce data redundancy and errors. You will  take the opportunity to create an efficient database to keep track of  and manage information regarding the company’s employees, products, and  shareholders.

You   have an existing database that contains the products sold by  the company.   However, you need to create   a table that will classify  each product under a specific category. After the   table is created,  you import the category data into the new table.
 

  Import the data in the 02a_ProductCategory.xlsx   Excel  file into a new table. Use the column headings from the Excel file,    select the CategoryID field as the primary key, and then save the  table as Product Category.
   Hint: On the External Data tab, in Import & Link group, click New Data   Source.
 

  See next page for Instruction 3

With the Product Category table   open in Design view. Ensure the  field properties of the Product Category   table have been modified as  follows:

Field Name

Data Type

Field Size

Comments

CategoryID

Short Text

2

Description = This field is assigned a 2-letter code

Caption = Category ID

This is a required field

Set Indexed = Yes (No Duplicates)

Primary key

CategoryName

Short Text

25

Caption = Category Name

This is a required field

Set Indexed = Yes (No Duplicates)

Description

Long Text

SupplierID

Short Text

4

Caption = Supplier ID

Description = All Supplier ID must begin with an “S”

Set Indexed = No

  Hint: To open the table in Design view, right-click, and then click  Design   View. Use the Field Properties pane to modify the properties.

View the data in the Product   Category table in Datasheet view and adjust column widths so all data is   visible.
 

  Save and close the table.

You create relationships among   the four tables (Employees, Product  Category, Suppliers, and Products) so   that you can make the database  more efficient.
 

  Create the following relationships and enforce referential integrity:
 

• Product Category and Suppliers   tables using the SupplierID field
  • Suppliers and Employees tables   using the EmployeeContactID and EmployeeID fields
  • Product Category and Products   tables using the CategoryID field
 

  Save and close the Relationships window.
   Hint: On the Database Tools tab, in the Relationships group, click   Relationships.

You need to quickly find the   products that were supplied by a  foreign country. You will open the Suppliers   table and filter the  records.
 

  Open the Suppliers table in Datasheet view.
 

  Filter the records for the suppliers who were outside of the United States.   You should have 11 records.
 

  Close the table.
   Hint: Click the arrow to the right of the S_Country field, and then deselect   the USA checkbox.

The director of marketing has   requested a list of the suppliers  that have a capacity of more than 25,000   square feet for manufacturing  and warehouse space.
 

  Create a query using the Suppliers table to display the SupplierID,    SupplierName, and Capacity fields for those plants with more than  25,000   square feet. Sort the results by SupplierName in ascending  order.
 

  Run the query. Name the query Supplier Size. Save and close the query.
   Hint: On the Create tab, in the Queries group, click Query Design. In the   Capacity column, enter >25000 as the criteria.

The director of marketing wants   a list of the employees who are the  main contact with the suppliers. He also   wants the addresses of these  contact employees so that he can personally send   them a letter  thanking them for working diligently with these suppliers.
 

  Create a query using the Suppliers and Employees tables.
 

  Display the SupplierName, EmployeeLastName, EmployeeFirstName,    E_StreetAddress, E_City, E_State, and E_PostalCode fields. Sort the  results   by EmployeeLastName, in ascending order.
 

  Run the query. Save the query as Contact Employee Address. Close the query.

The human resources manager   would like a list of all employees and  the approximate length of time they   have worked for the company.
 

  Create a query using the Employees table and include the EmployeeLastName,   EmployeeFirstName, and Date_of_Hire fields.
 

  Create an expression in the first blank column of the query that  calculates   the number of years employees have worked for the company,  using the   Date_of_Hire field and the current date. Do not adjust for  days off. Name the   expression Tenure. Format the Tenure field as Fixed with 2 decimal places. Name   the query Employee Tenure.
   Hint: Enter Tenure: (Date()-[Date_of_Hire])/365 as the last field in the query.

Create a report from the   Employee Tenure query. Group by  Date_of_Hire by month. Sort ascending by   Date_of_Hire. Change the  title to Employee Tenure Report. Make sure all fields display   appropriately.
 

  Widen the columns to display all text. Save the report with the default name,   Employee Tenure, and close it.
   Hint: With the query selected, on the Create tab, in the Reports  group, click   Report. On the Design tab, in the Grouping & Totals  group, click Group   & Sort.

Your organization is always   looking for more suppliers to  manufacture products. You create a new form to   make it easier to enter  new supplier information.
 

  Create a new form based on the Suppliers table using the Form tool. Change   the title label control to Enter Supplier Information.  Reduce the text box widths to   one-half of their original size. Change  the form’s control padding to Narrow.   Save the form as Enter Supplier Information.
   Hint: With the table selected, on the Create tab, in the Forms group,  click   Form. To change the control padding, on the Arrange tab, in the  Position   group, click Control Padding.

Switch to Form view. Enter a new   supplier record, #15, using the following information:
 

  Supplier ID: S115
   Supplier Name: Oakland Supply
   Delete the content in Employee Contact ID.
   Supplier Contact Last Name: Williams
   Supplier Contact Title: Intern
   Street Address: 12 Oak Street
   S_City: Washington
   S_State: MI
   Postal Code: 48094
   S_Country: USA
 

  Leave Capacity at 0. Leave the S_Phone, S_Fax, Home Page, and ProductID   fields blank.
 

  Sort the form by Supplier Name in ascending order.
 

  Save and close the form.
   Hint: To sort the data, click in the SupplierName field and, on the  Home tab, in the Sort & Filter group,   click Ascending.

The director of marketing would   like a report that lists the  suppliers who manufacture the various   motorcycles. You create a query  and the report for him using the Report   Wizard.
 

  Create a query and name it Motorcycles by Suppliers.  Add the SupplierName,   SupplierContactLastName, and Capacity fields  from the Suppliers table. Add   the ProductName and ProductSize fields  from the Products table. Add the   Product Category table. Sort in  descending order by Capacity, but do not   display the field in the  query.
 

  Run, save, and close the query.
   Hint: To hide the field from the query results, in Design view, in  the   Capacity column, click to remove the check mark from the Show box.

Create a report based on the   Motorcycles by Suppliers query. View  the data by Suppliers, and group the data   by SupplierName. Sort the  data by ProductName, ascending order. Select   Landscape Orientation for  the report. Use Block layout.
 

  Change the report title to Motorcycles Grouped by Suppliers.  Preview the report. Change the   column widths so all the data is  visible. Ensure the Report Header title   control is wide enough so the  entire title is visible. Switch to Print   Preview and make sure that  the report is displayed on one page. Exit Print   Preview and close the  report.
   Hint: On the Create tab, in the Reports group, click Report Wizard.

The director of accounting wants   to know the cost of  time-and-a-half overtime, over and above the regular   payroll, for all  hourly employees in the organization. You will create a   query to find  all the employees who worked overtime and create a report based   on the  query results.
 

  Create a query using the Employees table to calculate the hourly  rate at time   and a half for those employees who work more than 40  hours per week. Include the following fields:   EmployeeFirstName,  EmployeeLastName, Hours, Rate, and E_State. Calculate the   weekly  overtime costs in a column called Weekly Overtime.  Please note: Only the hours   worked over 40 hours per week count toward  overtime pay. Format the field as   Currency with 2 decimal places.
 

  Name and save the query as Weekly Overtime.
   Hint: In the Hours column, enter >40 as the criteria. Enter Weekly Overtime:   ([Hours]-40)*([Rate]*1.5) as the last field in the query.

Create a report for the Weekly   Overtime query. Switch to Layout  view and use the SUM function to calculate   the total cost of overtime  pay to all employees. Apply the Organic theme to   the report. Change  the report title to Employee Weekly Overtime, format the title in bold.   Ensure the Control Margins is set to None.
 

  Preview the report and adjust column widths so that the content appears on   one page.
 

  Save the report as Employee Overtime and close the report.
   Hint: To calculate the total cost, on the Design tab, in the Grouping  &   Totals group, click Totals. To change the theme, in the Themes  group, click   Themes. If the theme is not available on your machine,  click Browse for   Themes, and then select the downloaded theme file Organic.thmx.

Computer and Information Networking

 Discussion: 3 pages

1:  Is architectural design a must or just one of the choices for developing and design software system? Does architectural design need to follow standard developing steps or procedures? Is there any flexibility needed? 

2.  What is Hadoop (Explaining Hadoop) ? 

3. What is HDFS? 

4. What is YARN (Yet Another Resource Negotiator)? 

5. For transaction, there are 4 properties, please address those properties.

6. For concurrent control, please describe the required reason of use concurrent control and how to implement concurrent control?

7. If there is Conflict Serializability issue, how to handle it?

8. For database management systems, there are a lot of different design such as Centralized databaseDistributed databasePersonal databaseEnd-user databaseCommercial databaseNoSQL databaseOperational databaseRelational databaseCloud databaseObject-oriented databaseGraph oriented database, and etc. 

Are there any relations between different systems? How to integrate multi-different systems?