Monthly Archives: June 2023

 Exp19_Excel_Ch02_ML2_SmartPhone

Project Description:

You have just graduated from college and before beginning your first professional job, you would like to purchase a new smartphone. You have the option to purchase the new phone in one payment or make monthly payments by taking advantage of a 36 month flex payment plan. The payment plan charges an APR of 1.75% for the service. Prior to making your payment decision, you would like to make a worksheet to calculate the monthly payment for consumer reports top three smartphones for young professionals.

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

Rename Sheet 1 FlexPay.
  Hint: Double-click the sheet name tab to rename the worksheet.

Type Flex Pay Calculator in cell A1, and then merge and   center the title on the first row in the range A1:C1. Apply bold, 20 pt font   size, Blue, Accent 1, font color.

Merge and center the range   A2:C2, type Inputs, and apply Thick Outside Borders. Note, Mac users, apply Thick   Box Border.

Type APR and # of payments in the range A3:A4.

Type 1.75% in cell B3 and 36 in cell B4. Merge and center the range A6:C6, type   Outputs, and apply Thick Outside   Borders.

Type Model in cell A7, Price in cell B7, and Payment in cell C7. 

Type iphone x in cell A8, Samsung   Galaxy in cell   A9, and LG V30   in cell A10. Enter the corresponding prices 949, 799, and 650 in the range B8:B10 and apply Currency Number Format. Resize column A as needed to display all   text.

In cell C8, enter a PMT function   to calculate the monthly flex payment for the first option. Be sure to use   the appropriate absolute, relative, or mixed cell references. Use the fill   handle to copy the function down through cell C10. Make sure each of the   monthly flex payments is a positive value.

Type Highest payment, Average payment, and Lowest   payment in the   range A12:A14.

In cell B12, use the MAX   function to calculate the highest flex payment, in cell B13, use the AVERAGE   function to calculate the average flex payment, and in cell B14, use the MIN   function to calculate the lowest flex payment. 

Insert a footer with your name   on the left side, the sheet name in the center, and the file name code on the   right side of the worksheet.

Save the workbook. Close the   workbook and then exit Excel. Submit the workbook as directed.

For college writing, originality is a critical component. When you carry out a piece of academic work, you will be expected to research your subject thoroughly. It will be necessary for you to show an understanding of the contributions of other researchers and practitioners to your field of study. Keep in mind that plagiarism isn’t simply inadequate use of citations, it represents inadequate thinking. This project requires you to develop your own business idea instead of copying and pasting sentences and paragraphs from various websites. 

Once you submit your paper using the Turnitin link below, you will be able to view the similarity report. For this particular project, a returned percentage of below 20% would probably indicate that plagiarism has not occurred. You can submit draft assignments using the Turnitin link and view the similarity score before final submission to assess and improve your writing. 

If a student has copied someone else’s work, be it another student’s paper or taken material directly from some other source and made it appear to be their own; this is plagiarism. 

A submission with a similarity score above 40% and a Turnitin report indicating evidence of plagiarism will result in a 0 grade for the project and potentially an F grade for the course. 

Brainstorm ideas for a new business you (or your team if you work with other students–you may work in a team of maximum three people) want to start in the future–it can be a physical good or a service, but make sure your business is legit and ethical. In the Modules section under Final Project: Business Plan Information, I have uploaded a list of questions that you should cover in your business plan, a sample Word template (BA 100 Business Plan Submission Template.docx, also available in “Modules_Business Plan”) that you can use to organize the sections, as well as a sample Excel spreadsheet for the income statement section. Feel free to edit or format the template as needed. Please answer all questions but do not copy the entire questions directly to your document, as copying and pasting questions could impact the similarity score report from Turnitin. 

Choose a business idea that is appropriate for college learning. It could be fictional or real. Maybe you’ve already participated in a family business (e.g., a family restaurant) and want to expand it or improve the sales–that is great. If fictional, state clearly that it is for a future business and all numbers are estimated. Your estimates (e.g., sales and costs) should be realistic. For example, very few people will be able to borrow or make millions of dollars when starting a business. The best way to get good estimates is to observe a similar business nearby, count the number of customers per hour, and estimate the amount each customer spends. Then you can estimate daily/weekly/monthly/annual sales. Make sure that you stay safe and follow social distancing rules if you choose to observe a business. 

At the end of your business plan, include a simple income statement for next year that include expected sales, revenue, profit, expenses. You can use the sample Excel spreadsheet provided in “Modules_Business Plan”.

Submit you file using the Turnitin link below for the assignment. If working as a team (maximum 3 members per team), please upload only ONE copy with all members’ names on the first page.

Word/PDF Document: 500 words minimum.

Business case:  White & Bule Sky Airport Miami FL.

As an IT Manager, you were tasked to improve the performance of the local White & Bule Sky Airport Passenger Processing system.  This is to make the airport more efficient and more secure. 

There are three databases in the Airport Passenger Processing IT system:

1-Passenger database will record and authenticate each passenger in the airport

2-Employee database will record and authenticate each employee in the airport

3-Flight database will record each flight in the airport

Answer the airport owners’ questions about this IT system:

QUESTION 1. At the airport, there is a risk of data storage disk failure (fire, smoke, or flood) which will also damage the disk backup in the Airport IT system data center. What can you do to reduce data storage disk failure?

QUESTION 2 It was decided to move Passenger Database to the cloud.  How can you provide Security for the Passenger Database? Here you should address the questions

1. a) Security Devices that access the Passenger Database
2. b) Security of Passenger Data -at-rest
3. c) End user security. Where the user would be accessing the Passenger Database from the airport  

QUESTION 3 Assume that Passenger Database is already moved on the cloud side. And the airport has fast and reliable network connections.  If the cloud service provider devices fail to operate, then the Passenger Database would be not reachable (Loss of Control).  That will have a huge impact on Airport operations.  

What would you do to Minimize Loss of Control, so the impact would be less?

Assignment Overview
This assignment will give you more experience on the use of both loops and if statements. You are going to write a program that asks the user for two numbers to create and print a Latin Square.

Background
A Latin Square is an n*n table filled with n different symbols in such a way that each symbol occurs exactly once in each row and exactly once in each column (see http://en.wikipedia.org/wiki/L… ). For example, two possible Latin Squares of order 6:
1 2 3 4 5 6
2 3 4 5 6 1
3 4 5 6 1 2
4 5 6 1 2 3
5 6 1 2 3 4
6 1 2 3 4 5
3 4 5 6 1 2
4 5 6 1 2 3
5 6 1 2 3 4
6 1 2 3 4 5
1 2 3 4 5 6
2 3 4 5 6 1
Obviously, the top-left numbers are 1 and 3 respectively.

Project Description / Specification
Your program will ask user to input two numbers. The first number is ***** order of square; the second one is the top-left number of the square. Note that the second number should be between 1 and the first number, so your program should check this situation. Then, your program will print the corresponding Latin Square. Here is some example output:

Deliverables
program3.py — your source code solution (remember to include your name, the date, program number and comments).Getting Started
Break the problem down into smaller parts. For example:
The range function and the % (modulus) operator are both useful for this project.
Can you generate a sequence beginning with 1 of the appropriate order? A sequence of order 5 would be 1 2 3 4 5
Can you generate a sequence of the appropriate order beginning with a number other than 1? For a sequence of order 5 starting with 3 would be 3 4 5 1 2
Can you generate the second in the Latin sequence? For example, starting with 1 2 3 4 the next sequence would be 2 3 4 1second program
Python Program 4Assignment Overview
This assignment will give you more experience with while loops and if statements, and give you an opportunity to work with strings.
The Problem
Scientists measure how closely related a species is by looking at the DNA sequences for key proteins and seeing how similar/dissimilar they are. If the two sequences of DNA are essentially the same, the two species are considered to be evolutionarily closer since there is a relationship between changes and time. This process is called sequence alignment.Consider the two strings of DNA below (completely made up, miss matches in red):Species 1: AATAACGAAA
Species 2: AAAACGAAAAA scientist can change the alignment by assuming that an insertion or deletion, of one of the bases has occurred. They could make such a change, called an indel for short, to see if it improves the alignment:Species 1: AATAACGAAA-
Species 2: AA-AACGAAAAAssuming two indels, marked as two dashes(-), the alignment is greatly improved. The scientist would assume that two changes happened, one change in each species.While complex algorithms exist to do sequence alignment, it is also useful to support a researcher and allow them to do an alignment by hand.

Program Specifications::
1. You will prompt for two strings. The strings can have any characters you like, but to be “biological” it should consist of: “A”, “T”, “C”, “G”. The strings do not have to be of the same length.
2. You will then prompt for one of 3 commands:
a. “a” for add. Add an indel
b. “d” for delete. Delete an indel
c. “s” for score. Score the present alignment
d. “q” for quit. Stop the process.
3. Adding an Indel. When you add an indel, you must prompt for two pieces of information:
a. which string to change
b. at what index (starting at 0) do you wish to place the indel (placement is before the given index, Error if the index is out of range).
The string should then be modified and a dash(-) added.
4. Delete an Indel: If you can add an indel, you should be able to delete it if it doesn’t do what you want. Again, you must prompt for two pieces of information
a. which string to change
b. the index (starting at 0) to delete the indel. It is an Error to delete a character that is not an indel.
5. Scoring. You will report the number of matches and the number of mismatches.
a. Any indel is automatically a mismatch.
b. If one string is shorter than the other, the shorter string is filled out with indels.
c. After you score, you print both strings.
i. Matching characters are printed in lower case. If the user entered upper case letters, you convert them to lower case on a match.
ii. All mismatches are printed in upper case.
iii. Indels are printed as dashes.Deliverables
Turn in proj04.py be sure to use the specified file name, i.e. program4.py. Make sure to include your name and the assignment number as well as the date in the comments. Be sure to add necessary comments to explain what you are doing.

Assignment Notes:
1. As before, try to do this in pieces:
a. get the command loop working
b. get individual commands to work (scoring is the most work, save it till last)
2. Printing the string is best done by creating

using methods and arrays where appropriate, create a program that calculates how much it costs to fill up a gas tank. It should ask how much a gallon costs and assume that the gas tank capacity is 20 gallons. The amount should be printed in dollars and cents.

/*

using methods and arrays where appropriate, create a program that

calculates how much it costs to fill up a gas tank. It should ask how much a gallon costs

and assume that the gas tank capacity is 20 gallons.

The amount should be printed in dollars and cents

1. Autobiography: Write a 3 paragraph, 500-word autobiography (written in 1st person) that describes:
   • your life to this point including where you were born and an interesting fact about where you were born;
   • your education and experience in your major area of study;
   • and the goals you set for yourself after you obtain your masters in computer science 

Purpose

Bike Stores is a successful small chain of stores selling a wide range of cycling equipment. The company currently has stores in Texas, New York, and California. The owners are looking to expand the business to additional locations where cycling is popular. The database currently leveraged by the company tracks bike sales and inventory. It is very basic in design and limited in what it can provide for the company. For example, the database does not store customer payment, supplier transactions, or employee financial details. The owners are seeking to expand the company’s database capabilities to store these details. Download the design diagram for the current database state below.

• Bikestores Database Design Diagram

The database capability expansion desired by the company’s owners comes with significant concerns. The current database maintains a minimal security posture since it does not contain any customer, supplier, or employee financial data. The security requirements for the database change dramatically with the inclusion of these data.

You have been tasked to develop a white paper describing the security features that need to be applied to the Bike Stores database to maintain proper protection of sensitive financial details. Research the security features of Microsoft SQL Server, which is the relational database management system (RDBMS) leveraged by the company. Describe how specific Microsoft SQL Server security features will protect sensitive Bike Stores data. Also, denote challenges or issues associated with security measure implementation. Delineate regulatory requirements that need to be satisfied by the database’s security design.

Assignment Instructions

First, navigate to the Academic Tools area of this course and select Library then Required Readings to review the Unit 4 videos covering facets associated with database security. It is very important that you watch the Unit 4 videos before completing the assignment.

Generate a 3- to 5-page white paper addressing the application of Microsoft SQL Server security features on the Bike Stores database. This page requirement only includes the body of the paper containing the researched content. The paper must adhere to APA formatting requirements, which includes one-inch margins, use of 12-point Times New Roman font, and double-spacing. A separate title page must be provided showing the paper title, course name, and student name. A separate reference page must be provided with a minimum of two reputable sources for the paper.

Assignment Requirements

The paper must comply with the following:

• Minimum of three full pages of researched content
• Minimum of four Microsoft SQL Server security features that can be applied to the Bike Stores database
• Minimum of three challenges or issues associated with security measure implementation
• Minimum of two regulatory requirements that need to be satisfied by the database’s security design
• Title page with paper title, course name, and student name
• Reference page with a minimum of two reputable sources
• Paper adheres to APA requirements

Submit a bulleted list of DoD-compliant policies, standards, and controls that affect the WAN, Remote Access, and System/Application Domains.

Directions: Use Visual Logic Console for all inputs and outputs.  If you are not familiar with Visual Logic, a flow chart can be used instead of a program to answer the questions that require Visual Logic.

Choose any 4 out of 5 Questions.

1. Write a Visual Logic program that calculates the following.    

a) The user enters an amount

b) The program calculates the interest at 5%. Write a procedure to calculate the interest earned and the total amount which includes the interest.

c) Write the output using format currency to display the interest earned and the total amount calculated in b).

Copy and paste the program and the output for credit and upload the program file.

2. Write a Visual Logic program where the user rolls two dice and the program displays the sum of them. Each dice contains numbers from 1-6.

a) Use random for the first dice. Display the first dice.

b) Use random for the second dice. Display the second dice.

c) Add them together as the sum.

Copy and paste the program and the output for credit and upload the program file.

If the highest subscript in an array is nine and the subscripts start at zero, what is the size of the array?

Think about arrays that they use in everyday life situations. What are the advantages of using these types of arrays? Are there any disadvantages?

5.       a) Write a Visual Logic program to declare and populate an array to hold five student test scores.  

           b) Write a Visual Logic program to calculate the student’s average for the test scores. Output the average test score.

 Of the seven elements in project closeout management, which do you view as being most important? Why?  (you may use an example or case to illustrate) 

 • Book- Project Management: Achieving Competitive Advantage (5th ed.) Jeffery K. Pinto