Directions:

1. Create a login demo video or screenshots and login code.
2. Create a connection demo video or screenshots and connection code.

 NOTE: You should have your detailed design and a development schedule.  One of the first things that you should do is to verify connections.  If you have a database, a simple login page is good to verify that your software can connect and read from the database.  If you are using two or more components, it’s good to verify that you can get them to interact.  Component integration frequently takes more time than anticipated, and it’s a good idea to work that out early rather than leaving it for later.  If you are using any environments or components for the first time, it’s good to verify that you all your pieces working at a basic level before doing detailed work.  In any case, this is the week to start your development in earnest! 

Relational DatabasesDownload Relational Databases

Database Design Basics Links to an external site.(it’s for MS Access, but the design principles apply to any relational database)

SQL ZooLinks to an external site.

W3Schools SQL

essay (500 words) and 3 responses (100 words each)

 Compose a short paper in Microsoft Word on how you feel about communicating through electronic devices. Is it easier than communicating with someone face to face? What do you think are the pros and cons of communicating electronically? What is your opinion on this issue? Make sure to use specific reasons and examples to support your position. If you use sources or direct quotes, be sure to cite them at the end of your paper. 

Please use writing template attached

600 words min

Project 1: Migration Proposal Presentation

Hide Assignment InformationInstructions

Faster Computing has contacted Go2Linux and requested a brief proposal presentation for migrating its systems from Windows to Linux.

The company is specifically interested in seeing the following information:

(10.1.1: Identify the problem to be solved.)

• Based on your current understanding of Faster Computing’s business, what are some potential benefits of Linux?
• The company is aware that many different Linux derivatives exist. Be very specific and choose only one version (e.g., Ubuntu, Mint, Zorin, Redhat, CentOS, Kali). Which would Go2Linux recommend, and why? Give specific reasons for your choice (e.g., security features, support, updates, user interface).

(10.1.2: Gather project requirements to meet stakeholder needs.)

• What steps will be required to migrate the systems from Windows to Linux?
• Are there graphical interfaces available for the Linux workstations that would provide similar functionality to Windows? Some users are concerned about working with a command-line interface.

(10.1.3: Define the specifications of required technologies.)

• What tools are available on Linux for the servers to provide file sharing, Linux services, and printing? (e.g., Apache/Nginx, Samba, CUPS, SSH/SCP). Ensure you identify what the functions/services are used for (e.g., Samba is used for file sharing).

(1.1.3: Present ideas in a clear, logical order appropriate to the task.)

The deliverable for this phase of the project is a three- to five-slide PowerPoint narrated presentation.

• An introductory slide
• A summary slide
• Voice narration on every slide

For each slide, you will embed your own audio recording as if you were presenting the content to the Faster Computing team. Faster Computing has not yet committed to the project, so this should be presented as a proposal. The presentation should be visually appealing; the inclusion of at least one image that supports the content and adds value to the proposal is required.

(1.3.3: Integrate appropriate credible sources to illustrate and validate ideas.)

You must cite at least two quality sources.

You used at least 2 references and your references were cited properly following an accepted style. Ask your instructor for clarification.

Use the Migration Proposal Presentation template to get started.

(2.3.1: State conclusions or solutions clearly and precisely.)

You should present your proposal as if you are selling to the company. Revisit all of these important reasons in the summary slide.

Assume you are a network administrator in your organization, describe the most cost-effective ways to secure your organization’s connection to the outside world. Briefly discuss the risk assessment components necessary to secure the organization’s asset (in this case, data).

Please submit a resume for the FAKE JOB description below:

Resume Template. 2 docx.docx download

* The only real information is your name. However, use the template provided to apply for the job. It is fictional so you have already graduated and had the years experience for this position. So sell yourself. 

• Registered Nurse Pre-Op/PACU, Bethesda 
  • Outpatient Surgery Center at Bethesda West  
• FT, 7:00am – 3:30pm
• Baptist Outpatient Services (Links to an external site.)
• Requirements:
• The RN is a licensed professional who delivers patient-family-centered care in a culturally competent manner utilizing evidence-based standards of quality, safety, and service while ensuring the appropriate care for all age groups in the specific population of the unit. The RN demonstrates the following core competencies and behaviors: nursing process, technical skills, communication, critical thinking, interpersonal skills, flexibility, organizational skills, accountability and leadership.
• Qualifications: Degrees: Associates Licenses & Certifications: Registered Nurse Pediatric Advanced Life Support Neonatal Resuscitation Program Basic Life Support Advanced Cardiovascular Life Support Additional Qualifications: Associate degree in Nursing or Bachelors degree in Nursing. RNs hired prior to 2/2012 are not required to have a BSN to continue in their non-leadership role as an RN. RNs hired after 2/2012 with an Associate degree will have 5 years from their date of hire to complete the BSN degree. Life Support Certificate (BLS, NRP, PALS, ACLS) as per department standard. RN must complete a preceptor class within six months of hire. Minimum Required Experience: 2 years

 Exp19_Access_Ch03_Cap – Brilton Madley Games 1.0

 Exp19 Access Ch03 Cap Brilton Madley Games 1.0

 Access Chapter 3 Capstone – Brilton Madley Games 

 EX19_AC_CH03_GRADER_CAP_HW

Project Description

Brilton Madley, a board game  manufacturer, hired a new CEO. She asked for your assistance in  providing summaries of data that took place before she started with the  company. To help her with her strategic planning, you will create  queries to perform data analysis. Based on your meeting, you plan on  creating four queries. One query will find orders with minor delays.  Another query will summarize company revenue and cost by country. A  third query will be used to help evaluate payments made by customers on  their orders. The final query will calculate the total sales by sales  representative title.

Create a query using Query Design.   From the Customers table,  include the fields FirstName, LastName, and Phone   (in that order).  From the Orders table, include the fields OrderID,   OrderDate, and  ShippedDate (in that order). Run the query and then examine the records.  Save the query as Shipping   Efficiency.

Add   a calculated field named DaysToShip   to  calculate the number of days taken to fill each order. (Hint: the    expression will include the OrderDate and ShippedDate fields; the  results   will not contain negative numbers.) Run the query and then  examine the   results. Save the query.

Add   criteria to limit the query results to include any order that took more than 30 days to ship.

Add the Quantity field from the   Orders table and the ProductName  field from the Products table to the query   (in that order). Sort the  query by ascending LastName.

Add the caption Days to Ship to the DaysToShip field. Switch to   Datasheet view to view the final results. Save and close the query.

Create a query using Query Design and   add the Customers, Orders,  and Products tables. Add the Country field from   the Customers table.  Set the field’s Total row to Group By. Save the   query as Revenue and Cost by Country.

Add a calculated field in the second   column. Name the field TotalRevenue.    This field should multiply the quantity ordered (from the Orders  table) by   the unit price for that item (from the Products table).  Format the calculated   field as Currency and change the caption to Total Revenue.   Change the Total row for the TotalRevenue field to Sum.

Add a calculated field in the third   column. Name the field TotalCost.    The field should multiple the quantity ordered (from the Orders  table) by the   unit cost for that item (from the Products table).  Format the calculated   field as Currency   and add a caption of Total Cost.   Change the Total row to Sum. Run the query. Save the query. Return to Design   view.

Add the OrderDate field and criteria   to that field so that only orders made between 7/1/2018   and 12/31/2018  are displayed. Change the Total row   to Where. This expression will  display only orders that were completed during   the second half of  2018. Run the query and view the results. Save and close   the query.

Create   a copy of the Revenue and Cost by Country query named Customer Payments.  Switch to Design view of the new   query and remove the Country,  TotalCost, and OrderDate fields. Add the   FirstName and LastName  fields. Move the TotalRevenue field to the end. Rename   the  TotalRevenue field to OrderTotal.   Change the caption to Order Total.

Add   a new field using the Expression Builder named SamplePayment.   Insert the Pmt function with the following parameters:
 •   Use .05/12 for the rate argument (5% interest,   paid monthly)
 •   Use the number 12   for the num_periods argument (12 months)
 •   Use the calculated field OrderTotal   for the present_value
 •   Use 0 for both future_value and type

Change   the Total row to Expression for the SamplePayment field.  Change the Format   for the SamplePayment field to Currency. Run the  query and verify the second   order(with LastName Sparks) has a sample  payment of $26.80. Note: it will   display as a negative number. Save  and close the query.

Create   a copy of the Revenue and Cost by Country query named Revenue by Sales Rep.  Switch to Design view of the new   query and remove the entire  Customers table, the TotalCost, and OrderDate   fields. Add the Sales  Reps table. Add the Title field from the Sales Reps   table and move it  to the front of the TotalRevenue field.
 

Run   the query and then examine the summary records; there should be  4 Titles   listed. Switch to Design view and change the sort order so  that the title   with the highest TotalRevenue is first and the title  with the lowest   TotalRevenue is last. Run the query and verify the  results. Save and close   the query.

1

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

  The Excel workbook contains circular references. When you open the file, an   error message displays. This error will be resolved as part of the project

2

The   Tip Left column in the Friday worksheet contains a fill color and number   formatting. You want to fill these formats to the other daily worksheets.
 

  Group the Friday through Monday worksheets, staring with the Friday   worksheet. Fill the format only for the range E5:E24.

3

Now   you want to insert column totals for the five worksheets simultaneously.
 

  With the worksheets still grouped, insert SUM functions in the range B25:E25   and apply the Totals cell style. Ungroup the worksheets.

4

The   Week worksheet is designed to be a summary sheet. You want to insert a   hyperlink to the Total heading in the Monday worksheet.
 

  On the Week worksheet, in cell A5, insert a hyperlink to cell A25 in the   Monday worksheet with the ScreenTip text Monday’s Totals. Test the hyperlink to   ensure it works correctly.

5

In   cell A6 on the Week worksheet, insert a hyperlink to cell A25 in the Tuesday   worksheet with the ScreenTip text Tuesday’s Totals. Test the hyperlink to   ensure it works correctly.

6

In   cell A7, insert a hyperlink to cell A25 in the Wednesday worksheet with the   ScreenTip text Wednesday’s Totals. Test the hyperlink to ensure it works   correctly.

7

In   cell A8, insert a hyperlink to cell A25 in the Thursday worksheet with the   ScreenTip text Thursday’s Totals. Test the hyperlink to ensure it works   correctly.

8

In   cell A9, insert a hyperlink to cell A25 in the Friday worksheet with the   ScreenTip text Friday’s Totals. Test the hyperlink to ensure it works   correctly.

9

Now,   you are ready to insert references to cells in the individual worksheets.   First, you will insert a reference to Monday’s Food Total.
 

  In cell B5 on the Week worksheet, insert a formula with a 3-D reference to   cell B25 in the Monday worksheet. Copy the formula to the range C5:E5.

10

The   next formula will display the totals for Tuesday.
 

  In cell B6, insert a formula with a 3-D reference to cell B25 in the Tuesday   worksheet. Copy the formula to the range C6:E6.

11

In   cell B7, insert a formula with a 3-D reference to cell B25 in the Wednesday   worksheet. Copy the formula to the range C7:E7.

12

In   cell B8, insert a formula with a 3-D reference to cell B25 in the Thursday   worksheet. Copy the formula to the range C8:E8.

13

In   cell B9, insert a formula with a 3-D reference to cell B25 in the Friday   worksheet. Copy the formula to the range C9:E9.

14

Now   you want to use a function with a 3-D reference to calculate the totals.
 

  In cell B10 on the Week worksheet, insert the SUM function with a 3-D   reference to calculate the total Food purchases (cell B25) for the five days.   Copy the function to the range C10:E10.

15

The   servers are required to share a portion of their tips with the Beverage   Worker and Assistants. The rates are stored in another file.
 

  Open the Exp_Excel_Ch09_Cap_Assessment_Rates.xlsx   workbook. Go back to the Exp_Excel_Ch09_Cap_Assessment_Tips.xlsx   workbook. In cell F5 of the Week worksheet, insert a link to the Beverage   Worker Tip Rate (cell C4 in the Rates workbook) and multiply the rate by the   Monday Drinks (cell C5). Copy the formula to the range F6:F9.

16

Next,   you will calculate the tips for the assistant.
 

  In cell G5 in the Tips workbook, insert a link to the Assistant Tip Rate   (cell C5 in the Rates workbook) and multiply the rate by the Monday Subtotal   (cell D5). Copy the formula to the range G6:G9. Close the Rates workbook.
 

  Note: The tip is a monetary value in the Week worksheet. It should be   formatted for Accounting Number Format.

17

You   noticed a circular error when you first opened the Tips workbook. Now you   will find and correct it.
 

  On the Week worksheet, check for errors and correct the formula with the   circular reference. 

18

You   want to create a validation rule to prevent the user from accidentally   entering a negative value. For now, you will create a validation in the   Friday worksheet.
 

  Select the range E5:E24 in the Friday worksheet, create a validation rule to   allow a decimal value greater than or equal to zero. Enter the input message   title Tip and   the input message Enter the amount of tip. (including the   period). Use the Stop alert with the error alert title Invalid Number and the error   alert message   The tip must be zero or more. (including the period). Test the   data validation by attempting to enter -20 in cell E5 and then cancel the change.

19

Now   you will copy the validation settings to the other daily worksheets.
 

  Copy the range E5:E24 in the Friday worksheet. Group the Monday through   Thursday worksheets, select the range E5:E24, and use Paste Special   Validation to copy the validation settings.

20

You   want to unlock data-entry cells so that the user can change the tips in the   daily worksheets.
 

  Group the Monday through Friday worksheets. Select the ranges E5:E24 and   unlock these cells.

21

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

22

Now   that you unlocked data-entry cells, you are ready to protect the worksheets   to prevent users from changing data in other cells. Individually, protect   each sheet using the default allowances without a password.

23

Mark   the workbook as final.
 

  Note: Mark as Final is not available in Excel for Mac. Instead, use Always   Open Read-Only on the Review tab.

24

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

Select ONE ARTICLE from the following links and summarize the reading in your own words. Your summary should be 2-3 paragraphs(300 words) in length and uploaded as a WORD DOCUMENT with References. 

What is most important is that you use YOUR OWN WORDS to summarize the news article. It is essential that you do not copy text directly from the Internet. Plagiarism is unacceptable. You can easily avoid this by rephrasing the contents and summarizing it using your own words.

http://topics.nytimes.com/top/reference/timestopics/subjects/c/computer_security/index.html

https://www.lifewire.com/learn-how-antivirus-4102748

http://www.sans.org/newsletters/

http://news.cnet.com/security/https://www.onlinesecurity.com/news–publications-pagehttp://www.esecurityplanet.com/viewshttp://netsecurity.about.com/

Please see the attached document.