The purpose of this project is to demonstrate your understanding of the following course concepts:

1. Create and modify tables.
2. Create and manage reference lists.
3. Insert illustrations and text boxes.
4. Create and modify charts.
5. Modify graphic elements.
6. Create and modify reference elements.

PROJECT DESCRIPTION
For this assignment, you will be formatting a document to include a table, a chart and an image. You will also conduct additional research and cite your sources and include a reference list.

1. Download the Report.docx file that is attached to this assignment and save it as: LastName_Newsletter.docx. replacing “LastName” with your own last name. (Example: Henry_Newsletter). It is a good idea to save your work periodically.
2. Formatting Requirements

a. Insert a Title Page and include the following: Your name, Project name, and Instructor’s name.
b. Document must use 1-inch margins, 12-point professional font, double-space, automatic page numbering, Reference page.

3. Table

a. Convert the text after “The top ten are listed in the table below” and before “The Retail Industry” heading into a table. Separate text at Tabs.
b. Sort the table in ascending order by retailers.
c. Apply any table style.

4. Image

a. Insert any image with a shopping cart and insert the image into the document at the beginning of the first paragraph (It starts with “Retailing is important to understand”).
b. Apply a square text wrap and move the image so it is aligned with the right side of the document.
c. Appropriately resize the image.

5. Hyperlink

a. Locate the phrase “You can view the number of jobs and retail presence in your state at the National Retail Federation (NRF)” in your document. Add a hyperlink to “that leads to this website: https://nrf.com/retails-impact.

6. Chart

a. On the “National Retail Federation (NRF)” website, review the “Retail Impact” for the state in which you reside (if residing outside of the US, choose a state of your liking).
b. Create and insert a chart that depicts the “Direct Employment and GDP Value by major industry” for your state for the following employment:

i. Retail trade (including food services and drinking places).
ii. Arts, entertainment, and recreation.
iii. Construction.
iv. Educational services.
v. Healthcare and social assistance.
vi. Finance and insurance.

c. Place the chart after the last paragraph and apply a chart type and style of your choice.

7. Additional Research
Conduct additional research on the “Importance of the retail industry” and include at least two paragraphs (not less than four fully constructed sentences each) with your results.

Place these paragraphs after your chart. The title for this section should be: “Additional Research”.

8. References
Include at least two professional/scholarly sources for your research using APA citations format citing the sources in-text and creating a Reference list at the end. Note: The Reference list must be on a separate page.

NOTE 1: Please do not use unprofessional sources such as Wikipedia, About.com, Answers.com, Dictionary.com, How.com, or anything remotely similar.  Examples of scholarly sources include textbooks, articles, academic journals, and conference proceedings. Scholarly resources are written by experts in their fields, grounded in research, and often refereed (reviewed and edited by researchers in the field). Examples of professional sources include: trade journals or magazines. Professional sources are written for a specific audience that works in certain field. They are not research-based. You can also use our course content (e.g. Read & Watch resources) as a source as well.  UMGC has a top-notch, extensive online library. You can find many scholarly and professional sources there.

SUBMISSION REQUIREMENTS
Please submit the following to your Assignments Folder:

1. The completed Word Newsletter.docx file.
2. Submit a Project Reflection (see below).

PROJECT REFLECTION
Answer the following questions when you submit your assignments files. 

1. Were there any challenges encountered while completing this assignment? If so, what were the challenges and how did you overcome them?
2. How closely did you follow the parameters of the assignment?
3. What new information did you learn from completing this assignment?

Please submit your Project Reflection as a Microsoft Word document or just copy and paste your answers in your Assignments Folder’s text box when you submit your assignment along with the rest of the required project files.

1. Start the “TCP/IP” (reliable connection simulator) applet.
2. In the text field labeled “Your message:”, type the following: “Computer networking is essential in our world today.“. Then press the button “Send a message.”
3. Watch the entire sequence of packets that are sent for the sample message. How many “DAT” packets were sent? How many “ACK” packets were sent?
4. If each character or blank in a packet header counts for one character, and all “DAT” packets except the last carry 10 characters (including the blanks), and “ACK” packets have no data characters (though they do have a header), count up how many characters were sent in total.
5. There are 52 characters in the above message, including blanks and punctuation. Subtract 52 from the total number of characters sent in both directions in all packets. Divide this number by the total number of characters to get the overhead (those characters which are not really data but yet you have to transmit them), represented as a percentage.
6. Imagine that you have a million-character message to send, perhaps a large file. How many characters in total (and to your best estimate) would be sent in all packets necessary to move it from node 0 to node 1?
7. What would be an obvious way to decrease the overhead?
8. Repeat Steps 1 and 2.
9. Select “Delete packets that are touched“.
10. Delete some data packets by clicking on them as they move along the wire and watch the retransmission after timeout.
11. What happens if you delete the re-transmitted packet?
12. Now try deleting some ACK or NAK packets. What happens?
13. See if you can compute the checksum as TCP/IP does. Run the applet, using any message. Select a data packet, but don’t select the last packet because it might be too short, less than 10 characters. Count up the characters, including blanks. If they do not equal 10, assume there are blanks at the end so that the character count is 10.
14. Using the “Text Encoding in ASCII” applet, type in the characters from the data packet, and click on “translate text“.
15. Add up the values for each of the characters. Then calculate the modulus of this number using 256.
16. Compare your manually computed checksum for the first packet of the message “Introduction to Computer Science” against what the applet shows for the packet. Do they match?
17. Now damage your packet by altering one character. Re-compute the checksum. You should realize how the applet can spot errors.
18. Think of a way that a packet can be damaged and still have the same checksum as the undamaged version. Give one example for this scenario.

Payroll Lab

You will be taking in a file (payroll.txt) which details a number of departments (at least 1) and in each department are a set of employees (each department will have at least 1 employee or it would not appear on the payroll sheet). Your job is to read the file in separate out each employee and calculate the total values (hours, salary, number of employees) for each department and in each category (F1, F2, F3, F4). In your final submission please include the .cpp file which should work for any kind of payroll file I supply (which will naturally match the format of the examples below). Be sure to indicate in your submission text if you have attempted any of the bonus points .

An example file:

The IT Department
Bill 8 7 8 9 7 F1
Bob 205103 0.08 F3
Betty 8 8 7 8 8 F2
Brandon 10 10 9 6 9 F2
Brad 9 8 10 9 9 4 1 F4

The Sales Department
Kyle 88840 0.105 F3
Tyler 105203 0.085 F3
Konner 8 6 7 6 9 F2
Sam 309011 0.045 F3
Kent 9 8 9 9 9 0 0 F4
EOF

An additional example file:

The Sales Department
Mike 5 6 1 3 5 F1
Mark 98103 0.115 F3
Jill 8 8 8 8 8 F2

Frank 106101 0.095 F3

Mark 76881 0.091 F3

Department of Records
Konner 8 6 7 6 9 F2
Tammy 7 3 7 2 8 F1

Anika 8 8 8 8 8 F2

Marta 1 0 0 5 2 F1
Kent 9 8 9 9 9 0 0 F4
EOF

Last in the row after the hours comes the pay grade (F1, F2, F3, F4). The number of hours recorded is based on the pay grade of the employee. F1 and F2s will have 5 numbers for their hours. F3s are commission based where a sales amount and a commission percentage is given. F3s are also assumed to work 30 hours if their commission is 10% or below and 40 hours if their commission is above 10%. F4s will have 7 numbers (as they are on-call during the weekend). Each of the pay grades will also have different pay calculations which are as follows:

F1 = The total number of hours * 11.25
F2 = (The total number of hours – 35) * 18.95 + 400
F3 = The total sales amount * the commission rate
F4 = The first 5 hourly totals * 22.55 + Any weekend hourly totals (the last 2) * 48.75

Your output to the screen should start with the department name, followed by the total pay for all of the employees, then the total number of hours, and the total number of employees. After that you should have a breakdown of each category of employee: F1 total pay and total hours, F2 total pay and total hours…

Each department will have at least 1 employee and each department will contain the word “Department.”

The IT Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Bill, Bob, Betty, Brandon, Brad 

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

The Sales Department
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##
Roster: Kyle, Tyler, Konner, Sam, Kent

F1:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F2:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F3:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

F4:
Total Salary: $##.##
Total Hours: ###
Total Number of Employees: ##

Before coding your solution, take the time to design the program. What are the possible things that the file can have that you need to anticipate? What are the actions that you need to take (read the file, add up hours…)? Are those actions things that could be placed in separate functions? What about the function – can you guess some of the things that will happen? Such as, using substring to pull out part of a line in the file maybe using stoi to convert a string to an integer to add it to the total or creating variables to hold the employee type you find before passing it to another function. Finally, how are these functions called, what is the order and what information is passed to and from? 

Scoring Breakdown

25% program compiles and runs
30% program reads in and calculates the figures for output
10% the program is appropriately commented
35% outputs the correct information in a clear format 

5% bonus to those who can output the F# responses in a columned output like that shown above.

5% order the employees in the roster according to their F status, F1’s first, then F2’s and so on.
5% bonus to those who do a chart comparing the data at the end to show the relation between the pay grades and the amount of salary spent in each (they style of chart is up to you and more points may be given for more difficult charts (like a line chart):

B Department
F1 – 00000000
F2 – 000000
F3 – 00000
F4 – 000000000000 

K Department
F1 – 0
F2 – 0000
F3 – 0000000000
F4 – 0000000 

Or event something like this instead:

0
0 0
0 0 0
0 0 0 0
0 0 0 0
F1 F2 F3 F4

Answer the question in the attach document.

Introduction

The purpose of this project component is to provide a first experience in the actual writing of computer programs. Using a relatively simple introductory scripting language (Python), you will create program code in an editor (Notepad), save it to your disk, and run it from the command line prompt.

You will gain experience in planning, writing, debugging, documenting, and running simple programs. Learning Python serves as a convenient stepping-stone to more complex object-oriented languages, such as Java.

In this project, you will use online resources, including downloadable Python tools and tutorials.

Before writing programs, it is useful to plan the programming steps and actions by writing an algorithm. An algorithm is a set of plain English language commands or steps, each of which is then replaced by the appropriate command line for the programming language used. This technique becomes less useful when using complex object-oriented languages such as Java, but may be helpful in the early stages of learning to design programs. You will write algorithms for your first two programming exercises in this project.

The project will be graded for completeness and correct functioning of programs.

Acquiring the Tools

Download and install Python version 2.2 or higher by following the instructions at the Python download site.

The downloaded file will be called Python-2_2.exe. After downloading, run this file to complete the installation. You can view the installed components from your “Start” list.

Writing Algorithms

In the traditional approach to programming, the program is seen as a series of steps, which may include branches and loops. A branch occurs when a program may go in two or more different directions, depending upon a logical condition or a choice made by the user. A loop is a situation where a particular step, or series of steps, may be repeated until a certain condition or choice occurs.

The following simple example of an algorithm includes both elements, and describes a simple program for performing addition or multiplication.

Step 1—display the program name “Addition and Multiplication”

Step 2—display the options menu “(A)dd, (M)ultiply”

Step 3—request and store input of user choice A or M as “choice”

Step 4—if “choice” does not equal “A” or “M”, go to Step 9

Step 5—request and store the first number to be used as variable X

Step 6—request and store the second number to be used as variable Y

Step 7—if “choice” = “A” go to Step 11

Step 8—if “choice” = “M” go to Step 13

Step 9—display message “Choose A or M”

Step 10—go to Step 3

Step 11—display “Sum is” X+Y

Step 12—go to Step 3

Step 13—display “Product is” X*Y

Step 14—go to Step 3

Writing, Storing, and Running Python Programs

The actions involved in creating and running Python programs are relatively simple:

Input the code using Notepad, and save the file as *.py (e.g., prog1.py). Save your programs in the Python folder on your hard disk.

Open the MS-DOS prompt window.

Change directory from Windows to Python22 (enter “cd”

Refer to Information Technology and Organizational Learning (Langer, 2018) Chapter 2 for Q1.

Q1. Please note some key foundational factors that non-executives need to know and understand regarding technology.  Also, note how non-IT departments interact with IT and how the change in the market will change how business is performed. Your response should be 250-300 words.

Refer to Information Systems for Business and Beyond Questions (Bourgeois, 2014) Chapter 2 for Exercise 2.

Exercise 2. Review the timeline of computers at the Old Computers website. Pick one computer from the listing and write a summary. Include the specifications for CPU, memory, and screen size. Now find the specifications of a computer being offered for sale today and compare. Did Moore’s Law hold true? Your response should be 150-200 words.

Please follow APA 7 guidelines for References.

PowerPoint_2G_Orientation #PowerPoint_2G_Orientation

Project Description:

In the following project, you will format a presentation that is shown to Sensation Park Entertainment Group employees on their first day of a three-day orientation.

Open   the file Student_PowerPoint_2G_Orientation.pptx downloaded with this project.

On Slide 1, format the subtitle—New Employee Orientation—as WordArt   using the last style in the first row.

Select the picture and then Crop   the image from the left side so that the center-left crop handle aligns with   the left half of the horizontal ruler at 5 inches.

Change the picture Height to 3.5   and then apply a Glow: 8 point; Turquoise, Accent color 1 picture effect to   the image. Use the Align Selected Objects command to apply Align Middle to   the title and the picture.

On Slide 2, remove the bullet   symbol from the paragraph, and then change the Shape Fill to, under Theme   Colors, in the third column, the second color, and the Shape Outline to under   Theme Colors, in the second column, the first color.

On Slide 3, convert the bulleted   list to the Hierarchy type SmartArt graphic—Hierarchy List. Change the color   to Colorful Range – Accent Colors 3 to 4, and then apply the 3-D Inset style.

On Slide 4, change the two   bulleted lists to Numbering.

On Slide 5, change the bullet   symbols to Filled Square Bullets, change the Color to under Theme Colors, in   the third column, the fourth color, and then change the Size to 100.

On Slide 5, in the placeholder   on the right, insert an online picture by searching for fire alarm and then insert a picture of a   fire alarm with a background.
  Note—alternatively, insert the image p02G_Alarm.jpg   downloaded with the data files for this project.

If the option is available,   remove the background from the picture, and then apply the Glow: 18 point,   Bright Green, Accent color 3 picture effect.

On Slide 5, insert a Text Box   below the content placeholder on the left side of the slide. In the text box,   type All   employees will be tested on park safety procedures! Using the Align to Slide option   Align Center the text box and apply Align Bottom.

On Slide 6, from the Shapes   gallery, under Basic Shapes, insert a Diamond of any size anywhere on the   slide. Resize the diamond so that its Shape Height is 6 and its Shape Width   is 8. 

Using the Align to Slide option,   apply Align Center, and Align Middle to the diamond shape. Apply the Moderate   Effect – Bright Green, Accent 3 shape style.

In the diamond, type Sensation   Park Entertainment Group Welcomes You! Change the Font Size to 28, and then apply the   Round Convex Bevel effect to the diamond shape. Note—this effect may be   called Art Deco on some systems.

Insert a Header & Footer on   the Notes and Handouts. Include the Date and time updated automatically, the   Page number, and a Footer with the text 2G_Orientation 

Display the document properties.   As the Tags type orientation.

Save and close the file, and   then submit for grading.

Chapter 1 – Review the Key Lessons from Chapter 1 – Explain the five key lessons and note the importance of each key lesson from chapter 1.  Also, note why is it important to understand these basic concepts. 

• Chapter 2 – Note why the IT organizational structure is an important concept to understand.  Also, note the role of IT in the overall business strategy.

Required at least 2pages.

Do not use MINST digit dataset. Use dataset.load_digits() from sklearn

 Describe in 500 words discuss the scope of a cloud computing audit for your business