Need it in 4 hrs.

Exp19_Excel_Ch02_CapAssessment_Inland_Jewelers

 Exp19 Excel Ch02 CapAssessment Inland Jewelers 

Project Description:

You are an account manager for Inland Jewelers, a regional company  that makes custom class rings for graduating seniors. Your supervisor  requested a workbook to report on new accounts created on payment plans.  The report should provide details on total costs to the student as well  as payment information. Each ring financed has a base price that can  fluctuate based on ring personalization.

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

Insert a function in cell B2 to   display the current date from your system.

With cell B2 selected, set the   width of column B to AutoFit.

Insert a VLOOKUP function in   cell C5 to display the ring cost for  the first student. The cost of the ring   type should be an exact match.  Use appropriate relative and absolute cell   references.

Copy the formula from cell C5 to   the range C6:C11.

Apply Accounting number format   to the range C5:C11.

Insert an IF function in cell E5 to calculate the total   due. If the  student has chosen to personalize the ring, there is an   additional  charge of 5% located in cell B21 that must be added to the cost of   the  ring; if not, the student only pays the base price. Use appropriate    relative and absolute cell references.

Copy the formula from cell E5 to   the range E6:E11.

Apply Accounting number format   to the range E5:E11.

Insert a function in cell G5 to   calculate the first student’s  monthly payment, using appropriate relative and   absolute cell  references. Ensure the result is a positive number.

Copy the formula from cell G5 to   the range G6:G11.

Apply Accounting number format   to the range G5:G11.

Calculate totals in cells C12,   E12, and G12.

Apply Accounting number format   to the cells C12, E12, and G12.

Set 0.3″ left and right   margins and ensure the page prints on only one page.

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

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

1. What are some examples of computer crime? Are the current laws too restrictive or too prohibitive? What new legislation has been passed recently?
2. What is privacy? What is a good definition? Is privacy possible? Is the loss of privacy worth the potential increase in security? 

Discussion 8 B

Find a recent article that relates to a software that has malfunctioned and caused either serious injury, death, or loss of revenue. Summarize the article and discuss whether you believe this will impact the adoption of this type of technology.

Post your reply by Wednesday at midnight. Your response should be at least 250 words and appropriately cite your resources.

Respond to two of your classmates by Sunday at midnight. Your responses should be at least 100 words and should be substantive. You should offer additional resources, insight, or other helpful feedback. A simple “I like your post” will result in a 0.

You will not be able to see other posts until you make your first post.

Write a paragraph description for each of the following terms. Use APA formatting. (For APA coaching, refer to the Announcements tab on the course Canvas shell.)

1. Computer
2. Operating system
3. System software
4. Applications software
5. Mobile computing
6. E-Commerce
7. Database
8. Malware
9. System security
10. Data security

 * IntegerSet.java
*//**
*
* @author StudentName
*/
public class IntegerSet {
/**
* Creates a new instance of IntegerSet
*/
// TODO: implement the constructor
/**
* Return a new IntegerSet containing the union of the two IntegerSet objects
* passed as arguments
*/
// TODO: implement the union method
/**
* Return a new IntegerSet containing the intersection of the two IntegerSet objects
* passed as arguments
*/
// TODO: implement the intersection method
/**
* Inserts an element into the IntegerSet by setting the corresponding
* value within the set array to true. Returns false if the value was out
* of range and true otherwise.
*/
// TODO: implement the insertElement method
/**
* Deletes an element from the IntegerSet by setting the corresponding
* value within the set array to false. Returns false if the value was out
* of range and true otherwise.
*/
// TODO: implement the deleteElement method
/**
* @Override the toString method in the Object class
* Displays the integers contained by the IntegerSet separated by spaces.
* An empty set should be displayed as:
* { — }
* An integer set containing 5 and 10 should be displayed as:
* { 5 10 }
*/
// TODO: implement the toString method
/**
* Returns true iff the current IntegerSet contains the same integers as
* the IntegerSet supplied as an argument
*/
// TODO: implement the isEqualTo method

please see document 6-8 hours

 Review APA criteria and Chapter 1

 You will write a Python program that finds all the ORFs in a genomic sequence. 

A genomic sequence has 6 reading frames, corresponding to the six possible ways of translating the sequence into three-letter codons. Frame 1 treats each group of three bases as a codon, starting from the first base. Frame 2 starts at the second base, and frame 3 starts at the third base. Frames 4, 5 and 6 are defined in a similar way, but refer to the opposite strand, which is the reverse complement of the first strand. 

Specifications: 

Write a Python program called orfs to find all the open reading frames (ORFs) in the input sequence. 

INPUT: The program will take in as input a file, which will contain any number of DNA sequences in the FASTA format: – A line beginning with a “>” is the header line for the next sequence – All lines after the header contain sequence data. – There will be any number of sequences per file. – Sequences may be split over many lines. – Sequence data may be upper or lower case. – Sequence data may contain white space, which should be ignored. 

Ask the user for the minimum ORF to search for. The default is 50, which means your program should print out all ORFs with at least 50 bases. 

OUTPUT: 

Print your output in FASTA format, with one header line for each ORF, followed by the DNA in the ORF. The header should be the same as the header in the input file, followed by a bar “|” followed by FRAME = POS = LEN = , where is the frame number (1-6) 

is the genomic position of the start of the ORF (left end is base 1) is the length of the ORF (in bases) If N = 4, 5 or 6, then P should be a negative number that indicates the position of the start of the ORF from the right end of the sequence. The DNA in the ORF should be printed out with a space between each codon, and no more than 15 codons per line. 

Answer the following questions based on this scenario.

Problem: Write a program that reads 10 username and password values into parallel arrays. After the arrays have been loaded, the program should behave like a login screen, prompting for a username and a password. Based on the data read and stored in the arrays, the program should respond appropriately with one of three output messages: “Username not found.”, “Username and password does not match.” or “Access granted.”

Question 1: Would you write this program asking a user to enter the usernames and passwords or would you use a file that contains all the username and passwords as input?  Explain why you would choose one over the other.  

Question 2: Will your answer remain the same if the number of username and password values change to 40, and why?