Instructions:

1) Change array to ArrayList to store students in public class Course and change public class TestCourse accordingly.

2) Implement the dropStudent method (for option 2, see below). 

3) Add a new method named clear() that removes all students from the course (for option 3, see below).

4) Modify your test program that creates two courses, adds three students and two students to each course respectively, removes one student from a course, and displays the students in each of the courses. Test it also to remove all students from a course and show number of students afterwards. (for option 1, 2, 3, see below).

• Select one of your family’s language(s) or dialect(s) to research for your Language Autobiography Project. For example, if your family speaks mostly English but you have Irish, German, Persian or Chinese ancestors, and you have relatives who are speakers of any of those national languages, you can select one of these languages for your project. If your relatives speak only English, you could focus on the regional or ethnic variant or dialect of American English spoken in your family, for example: Southern, Northwestern, Tex-Mex, Californian, African-American English (AAE or Ebonics), Cajun English etc. If your family speaks any language(s) other than English, you can choose the language that interests you the most.
• In addition to the linguistic topics required for the Linguistic Autobiography Project (i.e., language history, evolution, syntax, grammar, tones, morphemes, etc.) think about and choose any specific sociocultural issue or issues that you would like to explore (for example, how the language has changed due to migration dynamics, power relations, social and political perceptions, etc.). Choose whatever topic is of interest to you. Remember that the main goal of this assignment is to do some fieldwork research through interviews with relatives who speak the language and can tell you about their experience with the language.
• Send me (your instructor) an email describing briefly your choice of language, why you chose it, and the topics you would like to focus on. This step is required since you need to receive my feedback and approval in order to proceed. Please don’t wait until the last minute to write me.
• Once you have received approval, you can write your formal proposal, which should be at least one page long, stating the reason for choosing your language or dialect, what do you wish to explore and learn from it, and how do you envision conducting your research.

Please write a paragraph as to how these learning outcomes align with your current employment 

Collect, clean, and transform data from a variety of sources into useful data to drive business decisions

Communicate insights effectively using data visualization and reporting tools appropriate for diverse audiences

Design and query databases to organize large amounts of data

Execute real-time analytics using stored and live datasets to quickly respond to customer needs Interpret data using a variety of statistical tools

refer to the attached document

#Exp19_Word_Ch01_Cap_Space

#Exp19 Word Ch01 Cap Space

# Word Chapter 1 Capstone – Space 

Project Description:

As an intern with NASA’s Space Camp program, you are involved with promoting related educational opportunities. You use Word to prepare a two-page flyer, ensuring a well-designed, error-free, and informative document.

Start   Word. Download and open the file named Exp19_Word_Ch01_Cap_Space.docx. Grader has automatically added   your last name to the beginning of the filename.

Inserting text from an existing   document can save time and ensure accuracy. For example, suppose you are   reusing text from an earlier memo, making a few additions or modifications.   Simply insert text from the earlier memo into the currently open document,   and then modify as necessary. In this case, you include text from a earlier   developed flyer that is appropriate for this one, saving time in retyping the   text.
 

  Display nonprinting characters. In the blank paragraph above Adult Space Academy on the second   page, insert text from Family.docx.

Hyphenated text that should not   be separated between lines can be forced to remain together by the insertion   of a Nonbreaking Hyphen between the words.
 

  Remove the two blank paragraphs after the Family Space Camp section. Replace   the hyphen following the word three in   the paragraph below the Adult Space   Academy heading with a Nonbreaking Hyphen.

By viewing a document as   multiple pages, you will often identify problems with layout or placement of   objects. When working on a page in Print Layout view, you are less likely to   consider its placement within the document as a whole, so it may be beneficial   to view a lengthy document in the multiple page arrangement occasionally.
 

  Preview the document in Multiple Pages. Note the poor placement of the text   box on the third page. Remove the five blank paragraphs before the text box   so that it moves up the page to a better position. Be sure that you do not   delete the end of paragraph marker after Perform   an extended-duration simulated mission! The document should display as   two pages. Return to 100% view.

Change margins to Narrow. Insert   a page break before the Family Space   Camp heading at the bottom of the   first page. Return to 100% view.

If major headings in a document   are formatted in hierarchical fashion, collapsing the display to Outline view   enables you to check the arrangement and even rearrange sections, if   necessary.
 

  Change the view to Outline. Click All Levels beside Show Level and select   Level 1 to show only major headings. Click + beside Space Camp and drag the heading to position it above Space Academy. Click Close Outline   View in the Close group.

Because nonprinting characters   are displayed, you can see the page break indicator, so it is easy to delete.
 

  Remove the page break on the first page along with the subsequent blank   paragraph mark that precedes Space   Academy. Insert a page break before the Family Space Camp heading.

Including a registered symbol   beside the camp name provides proper legal acknowledgment to a product or   entity.
 

  Insert a registered symbol after the words Space Camp in the first body paragraph under the Space Camp   heading. Ensure that the symbol is placed beside the camp name in the   paragraph and not beside the camp name in the heading.

Including selected document   properties as a header or footer helps to identify the document in printed   form at the top or bottom of every page.
 

  Insert an unformatted left-aligned footer with the Document Property,   Keywords, inserted as a field. You should select from Quick Parts on the   Header & Footer Tools Design tab when inserting the footer. Close the   footer.

A watermark is often used to   identify a document by its purpose or owner. In this case, it is identified   as a copy.
 

  Insert a horizontal blue watermark with the word Copy (type the text using the correct case). The Blue   color is the eighth color shown in Standard colors.

Although not shown when a   document is displayed or printed, document properties serve a purpose in   identifying a document’s origin, owner, or purpose, among other things. They   can also serve as search terms to help locate the file later.
 

  Open Document Properties and add Space Camp Flyer as the Subject.

A flyer is typically intended   for widespread distribution. By checking a document carefully for errors   before the document is distributed, you are viewed as well-prepared and professional;   your effort is more likely to be taken seriously.
 

  Check the document for spelling and grammatical errors. Correct any errors,   Use the thesaurus to identify a synonym for the word exciting in the first paragraph under the Adult Space Academy heading.   The synonym you select should begin with the letter t. Change the word an that   precedes the newly inserted synonym to the word a so that it is grammatically correct.

In the case of any document   intended for distribution, you should ensure that it is readable by as much   of your audience as possible. Checking for accessibility enables you to   identify and address any concerns that might limit accessibility by those   with various disabilities.
 

  Check for accessibility and correct any problems identified.

Save and close Exp19_Word_Ch01_Cap_Space.docx. Exit   Word. Submit the file as directed.

Please see the HW 9 document for the questions.

You have been hired by a small company to install network infrastructure with shared storage. The office has 15 users. The accounting department, which has one user, does not want to be on the same network as the operation network and does not want to share the storage with any other users.

Please consider the following Technology or some of it:

• Windows Server and AD
• DHCP
• SubNet Mask
• NAS
• Print Server

Please provide diagrams of at least two design options. 

Discuss and compare the advantages and disadvantages of each proposed design and justify your recommendations. Consider cost, security, on-going maintenance, adding new users, printing, log-in, and Internet connection to all users.

#Exp19_Excel_AppCapstone_IntroAssessment_Travel

Solution File + Step by Step Video Link is Available in Answer

You are considering several cities for a vacation. In particular, you are interested in Washington DC, Philadelphia, and Boston. You will format a list of memorials in DC, add Sparklines to compare the number of visitors over a 15-year period, and create a bar chart to illustrate annual visitors at each memorial. In addition, you will create a table of sightseeing locations, sort and filter the data, apply conditional formatting, and add a total row to display average time needed to spend at each memorial. Finally, you will complete a worksheet by adding formulas to compare estimated major expenses for each city.

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

On the DC sheet, check the   spelling and correct all misspelled words.

#On the DC worksheet, select the   range A4:G4, wrap the text, apply Center alignment, and apply Blue, Accent 5,   Lighter 60% fill color.

On the DC worksheet, merge and center the title in the range A1:G1. Apply Blue, Accent5 cell style and bold to the title.

On the DC worksheet, change the   width of column A to 34.

On the DC worksheet, select the range C5:F10 and insert Line Spark lines in the range G5:G10.

On the DC worksheet, select the   range G5:G10, display the high point sparkline marker, and change the color   of the high point markers to Dark Red.

On the DC worksheet, select the   range G5:G10, apply Same for All Sparklines for both the vertical axis   minimum and maximum values.

On the DC worksheet, select the   ranges A4:A10 and C4:F10 and create a clustered bar chart. Apply the   Monochromatic Palette 12 chart color. Apply the gradient fill to the chart   area. Do not change the default gradient options.

#Cut the chart and paste it in   cell A13. Change the chart height to 6″ and the chart width to 7″.   Add Alt Text The bar chart shows the number of visitors to each   memorial for the years 2002, 2007, 2012, and 2017.

Change the chart title to Annual   Visitors. Apply   Blue, Accent 5, Darker 25% font color to the chart title and category axis   labels. Change the value axis display units to Millions. Add Primary Minor   Vertical gridlines to the chart.

Apply data labels to the outside   end of the 2017 data series. Apply Number format with 1 decimal place to the data   labels.

On the Places sheet, find all   occurrences of BOS and replace them with Boston.

On the Places sheet tab, convert   the data to a table, assign the table name Tourist_Attractions, and apply Blue, Table Style   Medium 2.

On the Places sheet, freeze the   top row.

#On the Places worksheet, sort   the data by City in alphabetical order and then within City, sort by   Sightseeing Locations in alphabetical order.

On the Places worksheet, add a   total row to display the average of the Time Needed column. Apply Number format   with zero decimal places to the total.

#On the Places worksheet, select   the values in the Time Needed column and apply conditional formatting to   highlight cells containing values greater than 60 with Light Red Fill.

On the Places worksheet, apply a   filter to display only fees that are less than or equal to $10.

On the Cities worksheet, click   cell F4 and enter a formula that will subtract the Departure Date (B1) from   the Return Date (B2) and then multiply the result by the Rental Car per Day   value (F3).

#On the Cities worksheet, click   cell E13. Depending on the city, you will either take a shuttle to/from the   airport or rent a car. Insert an IF function that compares to see if Yes or   No is located in the Rental Car? Column for a city. If the city contains No,   display the value in cell F2. If the city contains Yes, display the value in   the Rental Car Total (F4). Copy the function from cell E13 and use the Paste   Formulas option to copy the function to the range E14:E18 without removing   the border in cell E18.

#On the Cities worksheet, click   cell F13. The lodging is based on a multiplier by City Type. Some cities are   more expensive than others. Insert a VLOOKUP function that looks up the City   Type (B13), compares it to the City/COL range (A7:B10), and returns the COL   percentage. Then multiply the result of the lookup function by the Total Base   Lodging (B5) to get the estimated lodging for the first city. Copy the   function from cell F13 and use the Paste Formulas option to copy the function   to the range F14:F18 without removing the border in cell F18.

#On the Cities worksheet, click   cell H13 and enter the function that calculates the total costs for the first   city, including airfare, shuttle or rental, lodging, and meals. Copy the   function in cell H13 and use the Paste Formulas option to copy the function   to the range H14:H18 without removing the border in cell H18.

#On the Cities worksheet, select   the range E14:H18 and apply Comma Style with zero decimal places. Select the   range E13:H13 and apply Accounting Number format with zero decimal places.

On the Cities worksheet, in cell   I2, enter a function that will calculate the average total cost per city. In   cell I3, enter a function that will identify the lowest total cost. In cell   I4 enter a function that will return the highest total cost.

Group the three worksheets and   create a footer with Exploring Series on the left side, the sheet tab code in the   center, and the file name code on the right side.

On the Cities worksheet, select   Landscape orientation, set a 1″ top margin, and center the worksheet   data horizontally on the page.

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

Q1. How can software assist in procuring goods and services? 

Q2. What is e-procurement software? When is it used? What are the top 5 industries using e-procurement software? 

Q3. Do you see any ethical issues with e-procurement? 

Q4. In your opinion, should stores be able to block people with smartphones from taking pictures of barcodes to do comparison shopping?

Q5. How is e-procurement expected to change in the next decade?

CASE 1 Maersk Develops a Global Shipping Management System 

A.P. Moller-Maersk is a Danish shipping, logistics, and energy  which operates the largest
container feet in the world with over 600 ships, moving 13 million containers a year, with
340 port facilities in 36 countries, and ofces in 130 countries.  Standard steel shipping
containers revolutionized world shipping in the latter half of the 20th Century because
they could be used to bundle cargo into unitized loads in a single steel box that could be
easily moved, stored, and re-used.  Also called “inter-modal containers”,  they can be moved
from ship to rail and trucks without re-loading or breaking up the contents by hand, greatly
adding to the efciency of world trade.  The standard container is 8.5 feet high, and 20 or 40
feet long.  Containers are more than just steel boxes. With the growth in global shipments
of food and produce, specialized reefer containers refrigerate their contents to levels of
temperature and humidity needed to preserve food.  Maersk ships 25% of the refrigerated
containers in the world.

Maersk refers to itself as the world’s largest shipping company.  Founded in 1904 by steam-
ship captain Peter Maersk Moller, in 2018 it accounts for about 15% of the world’s $80 trillion global domestic product, which amounts to an estimated $12 trillion in goods.  Today it
operates as two separate divisions: transport and logistics, and energy logistics. In 2017 it
exited the oil exploration business, but retained its energy logistics business.   In 2017 it
generated $31 billion in revenue, up 7% from the previous year, and cut its 2016 losses of
nearly $2 billion down to $1.1 billion, a 40% improvement.  Maersk has 88,000 employees
worldwide.

While most industries and frms have undergone extensive changes and disruptions in the  
last 25 years as digital technology and the Internet have developed, this has not been true
of the global shipping industry.   The underlying business processes involved in shipping  
today are still largely manual paper-based transactions although individual companies  
have made extensive digital investments in ship systems, navigation, communications,
and container tracking.  The culture of global shipping frms has focused primarily on the
process of shipping, and not on the processes needed to manage millions of containers,
or provide digital services to their customers.   The lack of industry- wide and government-
wide standards has been a major impediment to improving performance using digital
systems.  In part this is because of the complexity of shipping goods among 130 countries,
each of which has diferent kinds of documents like bills of lading, diferent export-import
documents and procedures, and diferent legal and fnancial systems.  Firms that use inter-
national shipping also have their own unique shipping systems developed by a variety of
enterprise software companies.  There are no industry or inter-governmental standards that  
address the business processes for managing global container shipping.   

Standardization typically comes about in industries when either one or a few companies
dominate the industry, and establish standards (as in the telephone industry), or through
some government intervention that forces standards on industries (as in the automobiles  
and pharmaceutical industries).  The Internet is an exception to this rule: the Internet
grew out of university and private eforts at frst, and then was developed by both non-
government engineering groups, and government agencies within the United States.   
None of these conditions apply to global shipping frms where no one frm dominates the  
industry, and international standards have not been imposed by international organizations  
such as the United Nations.  This is a problem for an industry with over 200 million shipping
containers, six million of them onboard vessels, and making 200 million trips a year!  For
each container shipped, there may be up to 30 diferent parties involved such as govern-
ment agencies, the shippers and the receivers of goods, port authorities, and tax authorities,  
communicating up to 200 times for each container being shipped.  The result is costly and
inefcient industry-wide business practices, with signifcant opportunities for improvement.   

Maersk is one global shipping frm that has built an enterprise-wide digital shipping
management system that can reduce fuel consumption of its feet by optimizing voyage
routing,  optimize utilization of its containers, enhance the tracking of containers on its
ships, as well as manage the empty containers waiting to be deployed.  One foundation of this efort involves the Internet of Things (IoT): using sensors on every container to continu-
ously monitor its location, and movement, along with the temperature and humidity of its  
contents for reefers.  A second foundation of Maersk’s system is using business analytics
to achieve optimal fuel and voyage management.  Longer term, Maersk is planning to  
commercialize this capability by enabling shipping customers to access the system to track
their cargos directly, and to reserve containers for their use based on their own produc-
tion and shipping plans.  The goal, in the end, is to make global shipping as convenient as
domestic UPS or FedEx shipping.  Changing the culture at Maersk involves in part becoming
a digital services company with a customer-friendly system, while maintaining its feet of
ships and containers.   

Answer the following questions and save in a word doc:

1. Why is Maersk’s business model “complex”?
2. What role do IoT sensors play in Maersk’s systems?
3. Why is tracking empty containers so important to efcient operations?
4. What is the “data driven culture” that Maersk is trying to strengthen?
5. Why does Maersk want to give their customers access to their system?