Exp19_Excel_Ch12_ML1_Sorority_Dues

Exp19 Excel Ch12 ML1 Sorority Dues

Excel Chapter 12 Mid-Level 1 – Sorority Dues 

Project Description:

You are the outgoing treasurer of your sorority and as your last task, you would like to create a membership template to enable future treasurers to track memberships, dues, and activities. To reach your goal you will download and customize an Excel template. As part of the customization process, you will create a macro to format text, use VBA to protect the workbook, and inspect the workbook for issues.

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

Click cell A1, delete the   template text, and type Membership Dues.

Delete Column L.

Select the range A1:L7 and clear   all data validation that was included in the template.

Add a comment in cell A1 that   says “Unprotect the   worksheet before editing.“. Be sure to enter the comment as it appears, including the   period and excluding the quotation marks.

Use the Macro Recorder to record   a macro named Sort that sorts the records in ascending order based on selection   (Hint: use relative references when recording the macro).

Ensure the Developer Tab is   enabled, then create a Form Control Button named Sort spanning the cell range C1:D1 (ensure that the   button is inside the cell borders), and assign the Sort macro. Be sure the   label is displayed on the Form Control Button.

Use the VBA Editor to insert a   new module named Unprotect. To complete the step, type the code as it appears   below. Note there is one blank line after the opening declaration (sub   Unprotect). The remaining code does not have space between lines.
 

Sub   Unprotect()
 

‘Unprotect   Sheet
Worksheets(“Member   List”).Unprotect.Password = “eXploring”

Insert a new module named Protect. To complete the step, type the   code as it appears below. Note there is one blank line after the declaration   (Sub Protect). The remaining code does not have space between lines. Type the   following to complete the procedure.
 

Sub   Protect()
 

‘Protect   Sheet
Worksheets(“Member   List”).protect.Password= “eXploring”

Exit the VBA Editor and create a   Form Control Button named Unprotect spanning the cell B1. Assign the   UnprotectWorksheet macro. Be sure the label Unprotect appears on the Form control   button. Then save the file as a macro enabled workbook.

Create a Form Control Button   named Protect spanning the cell E1. Be sure   to display the label Protect on the Form Control Button and then assign the Protect macro.

Use the Document Inspector to   check the document for issues. Remove the Document Properties and Personal   Information and the Headers and Footers information. Do not remove Comments   and Macro information. Note: If using a Mac, please skip this step and   proceed to step 13.

Check the document for   Accessibility and compatibility with Excel 2010, 2013, and 2016.

Insert a new worksheet named Code.

Open the VBA Editor, open module   1, and copy the code. Paste the code in the Code worksheet starting in cell   A1. Then delete the rows that are blank (2,4,5, and 6).

Open the VBA Editor, open the   Protect module, and copy the code. Paste the code in the Code worksheet   starting in cell A17. Delete any additional blank rows that appear in the   code (row 18).

Open the VBA Editor, open the   Unprotect module, and copy the code. Paste the code in the Code worksheet   starting in cell A22. Then delete any additional blank rows that appear in   the code (row 23).

Save and close Exp19_Excel_Ch12_ML1_HW_MembershipDues.xlsx.   Be sure to save the workbook as a .xlsx   file, not a macro enabled workbook. Exit Excel. Submit the file as directed.

For this interactive assignment, you will continue to utilize loops and functions and write a Python program that asks the user for an integer (number) greater than 1. Once the user enters an integer, it should then allow the user to choose between the following two options:
If 1 is entered, a countdown from that number to zero is printed.
If 2 is entered, the factorial of the number is *****
If the user inputs a number less than 1, your program should display a message informing the user that the program only accepts numbers greater than 1.
(Note: As a programmer, you should always consider telling the user what type of data the program is expecting before they attempt to enter that data.)
Once you have completed the program, take a screen shot of the completed functionality (including the input and the output) and save it in a Word document, along with the script.

What are problems and challenges of sentiment analysis in present time ?

Write a Multithread Echo Client Server Program

Network Programming – JAVA

Provide a reflection of at least 500 words (or 2 pages double spaced) of how the knowledge, skills, or theories of this course have been applied, or could be applied, in a practical manner to your current work environment. If you are not currently working, share times when you have or could observe these theories and knowledge could be applied to an employment opportunity in your field of study. 

Requirements:

Provide a 500 word (or 2 pages double spaced) minimum reflection.

Use of proper APA formatting and citations. If supporting evidence from outside resources is used those must be properly cited.

Share a personal connection that identifies specific knowledge and theories from this course.

Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment. 

You should not, provide an overview of the assignments assigned in the course. The assignment asks that you reflect how the knowledge and skills obtained through meeting course objectives were applied or could be applied in the workplace.

Be sure to not self-plagiarize as this assignment is similar in multiple courses.

Our e-book has mentioned blogs, LinkedIn, Twitter and search engine to assist us in finding the answers to broken down equipment and software (installation and removal if infected with viruses/trojan horses/worms/ransomware. Advice from lots of nice people around the world discuss keyboards, monitors, laptops, desktops – memory, fan, clocks, and much more. However, we must be careful to not open files with .exe (executable files just like the ones that run our operating systems, etc.) and unsolicited files.

One such place is TED TALKS. Google tells us “TED is a nonprofit devoted to spreading ideas, usually in the form of short, powerful talks (18 minutes or less). TED began in 1984 as a conference where Technology, Entertainment and Design converged, and today covers almost all topics — from science to business to global issues — in more than 100 languages.”

In working with technology/machines, we need to watch KEVTECH videos also.

Our assignment is to write a 5-sentence paragraph explaining to users (that’s our audience) on each of the following topics:

Using WORD software to write about all 5 topics and submit as 1 document:

1. Watch 1 TED TALK (watch one video that could help you) – then write what you think about this short talk. ADD a Captured Screen and/or Photo.

2. Watch 1 KEVTECH video – then write what you think about this short talk. ADD a Captured Screen and/or Photo.

3. Research and find a job in LinkedIn – then write what you think about this.  ADD a Captured Screen and/or Photo.

4. Research Twitter – then write what you think about this. ADD a Captured Screen and/or Photo.

5. Research and find out about Facebook – then write what you think about this. ADD a Captured Screen and/or Photo.

a math problem that need very simple code on Julia. 

Describe in detail one application of machine learning and how the output of analytics has transformed an industry in the past 24-36 months?

Ship, CruiseShip, CargoShip Classes, and Displayable Interface

Design an abstract Ship class that has the following members:

• A field for the name of the ship (a string).• A field for the year that the ship was built (a string). • A constructor and appropriate accessor and mutators.• A toString method that displays the ships name and the year it was built.

Design a CruiseShip class that extends the Ship class. The CruiseShip class should have the following members:

• A field for the maximum number of passengers (an int).• A constructor, a copy constructor, and appropriate accessors and mutators.• A toString method that overrides the toString method in the base class. The CruiseShip class’s toString method should display only the ship’s name and the maximum number of passengers.

Design a CargoShip class that extends the Ship class. The CargoShip class should have the following members:

• A field for the cargo capacity in tonnage (an int).• A constructor, a copy constructor, and appropriate accessors and mutators.• toString method that overrides the toString method in the base class. The CargoShip class’s toString method should display only the ship’s name and the ship’s cargo capacity.

In a driver program (shipDemo.java) 

• Demonstrate the classes in a Ship array. Assign various CruiseShip and CargoShip objects to the array elements. The program should then step through the array, calling each object’s display method. (polymorphism)• Create an ArrayList of Ship objects and add various CruiseShip and CargoShip objects to the array list. The program should then step through the array list, calling each object’s toString method. (polymorphism)• Test your copy constructors in both CruiseShip and CargoShip in shipDemo.java

Interface to your lab 3 (Ship implements Displayable).

public interface Displayable
{
 void display();
}

Resource: 

• UML• Sample Program (OOP_example_2)

Deliverables:

• Displayable.java (10%)• Ship.java (20 %)• CargoShip.java (15%)• CruiseShip.java (15%)• ShipDemo.java (30%)• Screenshot (10%)

Note: Sparingly comment your java source code, save all the files in your_lastname_lab_3 folder, zip it, and upload for grading.

Thank you!

https://www.homeworkmarket.com/questions/individual-assignment-20150483