All posts by : chebby

Read and independently research an Article, Amendment, or Section of the U.S. Constitution of your choice. Consider how, as the supreme law of the land, it may have influenced or framed one of the laws or regulations that was discussed in the text and lectures. If at first you do not see how, for example, the Constitutional mandate about voting age relates to information security or privacy, think more critically. Did we discuss the various ages that the law views a “child” as? Every law, by definition, relates back to the U.S. Constitution in one manner. Countless civil and criminal lawsuits—car wrecks, contract issues in business, any crime, etc.—contain arguments that touch on the Constitution, even when the issue at bar seems far afield. It is because of that omnipresent and important function of the U.S. Constitution that this exercise will help you understand the entire course in its light.

500 words APA format with references needed.

In addition to the Enterprise Resource Planning (ERP) system, you are also updating the office automation software for the new client. They plan to upgrade to the newest version of Microsoft Office©. Choosing a commercial off the shelf (COTS) solution for office automation is very common since the basic applications provided are used across different industries. The ERP and other business applications running on the server are customized and developed using the System Development Life-Cycle (SDLC). Write a two-page white paper discussing the business applications used on the customer network.

Refer to the attached document for complete details and grading rubric.

Windows Network Proposal

You have been hired by Universal LLC as an Information Technology consultant to develop a technology proposal. Universal LLC manufactures and distributes solar panel for the consumer market. Your job is to submit a proposal that meets their criteria.Current Implementation/Concerns:
• The company will have 3 locations (Los Angeles, Dallas, and Houston) but are planning to grow rapidly due to high demand in solar panels. Main staff will be at Dallas and Houston offices.
• Data security is priority since patent and trademarks are at stake.
• Los Angeles sales personnel will need secure remote access to Houston office.
• The WAN connectivity is in place and it is not an issue. There is ample bandwidth in place.
• Feel free to make other assumptions but they need to be noted in the paper.
Topics to Cover:
Your document should cover the content presented in the course. The outline below contains recommended points to cover. You are free to add other related information.Describe the technical and business reasons for each choice, citing other resources as appropriate. The Windows Server 2012 operating system should be used for all aspects of the solution.The topics include:
Active Directory:
• What forest/domain model should Universal LLC implement? What is the domain name?
• Where should the domain controllers be place? Should RODC be part of the consideration?
• FSMO Roles placement
• Plan for AD backup and recoveryGroup Policy:
• Is Group Policy needed?
• What settings might be considered via Group Policy?DNS:
• What namespace should Universal LLC implement?
• What types of zones needed?File Services:
• How will the shares be secured?
• Will quotas be used? FSRM be configured?
• Will DFS be implemented?Remote Services:
• What technology will be implemented to provide secure remote access for users?
• Who should have remote access?WSUS:
• How will the servers and clients be updated?
• How will new servers be deployed?
Submission Requirements:
There are specific requirements for the assignment: The final submission should contain at least 6 pages’ worth of text written by the student (not counting title page, images, diagrams, tables, or quotations), but may be longer, not to exceed approximately 10 pages’ worth of student-supplied text. (With the required diagram, and other images, title page, etc., the final submission may end up being more than 10 pages in length.) It must be double-spaced, have 1-inch margins, and use 12-point Times New Roman or 10-point Arial/Helvetica font. A title page is required; APA format for the title page is optional.
• At least one diagram must be included (not counted towards the minimum length described above). You can have more.
• The submission must cover all of the 6 major topics outlined above. Each choice should be explained with technical and business reasoning. The solution should be reasonably detailed.
• The structure of the final submission is flexible. There is no specific format required, although it should be organized logically and represent a single, unified solution. It is likely that the format will include separate sections for each of the 6 topics required, as well as a summary.
• At least one non-textbook, non-Wikipedia reference is required; preferably, this would be a “best practice” guide or similar content from Microsoft or an experienced provider of Microsoft solutions.
• Be sure to properly quote or cite any sources used. APA format is required for in-text citations and the list of works cited at the end. In its simplest form, if you are using text from a source, you must cite and/or quote it. If plagiarism is found, then there will be a penalty to the grade.

Do you consider cyberstalking to be an offense? What are your experiences with cyberstalking? How can the issue of cyberstalking be handled? Are the current laws adequate? Are there any international cyberstalking laws that can help? 

refer to the attached document in the uploads for the details

I need to write a term paper on the topic Siemens Simatic- PCS7/WINCC (SCADA) 

 Topic – Customer sentiment analysis using Artifical Intelligence

• In the current literature, what counterarguments have you discovered about your topic?
• In lieu of these counterarguments, justify why you chose the argument that is the foundation for your proposed study.

Create a discussion thread (with your name) and answer the following question(s):

Discussion 1 (Chapter 14): Discuss insertion, deletion, and modification anomalies. Why are they considered bad? Illustrate with examples.

Instructions:  Your response to the initial question should be 250-300 words.  Next respond to two postings provided by your classmates. The first post should be made by Wednesday 11:59 p.m., EST. I am looking for active engagement in the discussion.  Please engage early and often. You are require to create your initial thread in order to view and respond to the threads posted by other students.  There must be at least one APA formatted reference (and APA in-text citation) to support the thoughts in the post as needed.  Do not use direct quotes, rather rephrase the author’s words and continue to use in-text citations.

Hy, there I want you to go through the slides I have provided you from week 1 to week 11 first. Then I want you to include all the information and what I would have learned from these weekly slides that I have provided you. 

At least, 5 references and I want Turnitin to check too.

You are the office manager for a real estate company in northern Utah County. You tracked real estate listings, including city, agent, listing price, sold price, etc. Agents can represent a seller, a buyer, or both (known as dual agents). Your assistant prepared the spreadsheet structure with agent names, agent types, the listing and sold prices, and the listing and sold dates. You want to complete the spreadsheet by calculating the number of days each house was on the market before being sold, agent commissions, and bonuses. In addition, you will use conditional functions to calculate summary statistics. For further analysis, you will insert a map chart to indicate the average house selling price by city. Finally, you will create a partial loan amortization table and calculate cumulative interest and principal to show a potential buyer to help the buyer make decisions.

The   spreadsheet contains codes (BA, DA, SA) to represent agent roles (Buyer’s   Agent, Dual Agent,   Seller’s Agent). You want to switch the codes for the actual descriptions.
  In cell E12 of the Details sheet, insert the SWITCH function to evaluate the   agent code in cell D12. Include mixed cell references to the codes and roles   in the range J2:K4 for the values
  and results arguments. use all cell references in the function. Copy the   function to the range E13:E39.

Now you want to calculate the   number of days between the list date and sale date.
 

  In cell J12, insert the DAYS function to calculate the number of days between   the Listing Date and the Sale Date. Copy the function to the range J13:J39.

You want to calculate agent   commissions based on their role.
 

  In cell K12, insert the IFS function to calculate the agent’s commission   based on the agent code and the applicable rates in the range L2:L4. Use   relative and mixed references correctly. Copy the function to the range   K13:K39.

You want to calculate a bonus if   the sold price was at least equal to the listing price, and if the house sold   within 30 days after being listed.
 

  In cell L12, insert an IF function with a nested AND function to calculate a   bonus. The AND function should ensure both conditions are met: Sold Price   divided by the Listing Price is greater than or equal to 100% (cell L7) and   the Days on Market are less than or equal to 30 (cell L8). If both conditions   are met, the bonus is $1,000 (cell L9). Otherwise, the bonus is $0. Use mixed   cell references to the input values in the range L7:L9. Copy the function to   the range L12:L39.

The top-left section of the   spreadsheet is designed for summary statistics for one condition. You will   calculate average selling prices and the number of houses sold in each city   (the condition).
 

  In cell B2, insert the AVERAGEIF function to calculate the average Sold Price   for houses in the city of Alpine. Use mixed references for the range; use a   relative reference to cell A2. Copy the function and use the Paste Formulas   option to paste the function in the range B3:B5 so that the bottom border in   cell B5 is preserved.

You want to count the number of   houses in one city.
 

  In cell C2, insert the COUNTIF function to count the number of houses in the   city of Alpine. Use mixed references for the range; and use a relative   reference to cell A2. Copy the function and use the Paste Formulas option to   paste the function in the range C3:C5 so that the border in cell C5 is   preserved.

You want to calculate the total commissions   for each agent (the condition).
 

  In cell B7, insert the SUMIF function to total the commissions by agent. Use   mixed references for the ranges; and use a relative reference to cell A7.   Copy the function and use the Paste Formulas option to paste the function in   the range B8:B9 so that the borders are preserved.

The top-middle section of the   spreadsheet is designed for summary statistics for multiple conditions. You   will calculate the number of houses sold for each agent when he or she served   as a Dual Agent (DA). Use mixed references for ranges and the agent code   condition in cell J3. Use relative cell references to the agent condition in   cell E2. When you copy the formulas, use the paste Formulas options to   preserve border formatting.
 

  In cell F2, insert the COUNTIFS function in cell F2 to count the number of   houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Use all cell references in the function. Copy the function to the   range F3:F4 and preserve the bottom border for cell F4.

You are ready to calculate the   total value of those houses for each agent when he or she served as a Dual   Agent (DA). Use mixed references for ranges and the agent code condition in   cell J3. Use relative cell references to the agent condition in cell E2. When   you copy the formulas, use the paste Formulas options to preserve border   formatting.
 

  In cell G2, insert the SUMIFS function to sum the selling prices of the   houses sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Copy the function to the range G3:G4 and preserve the bottom   border for cell G4.

Now, you will calculate the   highest-price house highest-price house sold for each agent when he or she   served as a Dual Agent (DA). Use mixed references for ranges and the agent   code condition in cell J3. Use relative cell references to the agent   condition in cell E2. When you copy the formulas, use the paste Formulas   options to preserve border formatting.
 

  In cell H2, insert the MAXIFS function in cell H2 to display the highest-price   house sold by the first agent (cell E2) who was a Dual Agent (DA) (J3) for   that house. Copy the function to the range H3:H4 and preserve the borders in   the range H3:H4.

The Map worksheet contains a   list of cities, postal codes, and average house sales. You will insert a map   chart to depict the averages visually using the default gradient fill colors.
 

  Display the Map worksheet, select the range B1:C5 and insert a map chart.

Cut the map chart and paste it   in cell A7. Set a 2.31″ height and 3.62″ width.

You want to enter a meaningful   title for the map.
 

  Change the map title to Average Selling Price by Zip Code.

Display the Format Data Series   task pane, select the option to display only regions with data, and show all   labels. Close the task pane.

You are ready to start   completing the loan amortization table.
 

  Display the Loan worksheet. In cell B8, type a reference formula to cell B1.   The balance before the first payment is identical to the loan amount. Do not   type the value; use the cell reference instead. In cell B9, subtract the   principal from the beginning balance on the previous row. Copy the formula to   the range B10:B19.

Now, you will calculate the   interest for the first payment.
 

  In cell C8, calculate the interest for the first payment using the IPMT   function. Copy the function to the range C9:C19.

Next, you will calculate the   principal paid.
 

  In cell D8, calculate the principal paid for the first payment using the PPMT   function. Copy the
  function to the range D9:D19.

Rows 21-23 contain a summary   section for cumulative totals after the first year.
 

  In cell B22, insert the CUMIPMT function that calculates the cumulative   interest after the first year. Use references to cells A8 and A19 for the   period arguments.

The next summary statistic will   calculate the principal paid after the first year.
 

  In cell B23, insert the CUMPRINC function that calculates the cumulative   principal paid after the first year. Use references to cells A8 and A19 for   the period arguments.

Rows 25-28 contain a section for   what-if analysis.
 

  In cell B27, use the RATE financial function to calculate the periodic rate   using $1,400 as the
  monthly payment (cell B26), the NPER, and loan amount in the original input   section.

In cell B28, calculate the APR   by multiplying the monthly rate (cell B27) by 12.

Create a 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 each worksheet.