Monthly Archives: June 2023

Excel_5G_Sports_Programs

Project Description:

In this project, you will create a worksheet for Sandy Chase, Assistant Director of Athletics, with data that has been sorted, filtered, and grouped and that analyzes sports programs at Laurel College.

Open   the Excel workbook Student_Excel_5G_Sports_Programs.xlsx   downloaded with   this project.

Display the Valley-Park-West   worksheet. Select the range A1:J40, insert a table, and then display the   Table Styles gallery. In the third row, apply the fourth style or choose   another style.

Sort the table on the Campus   column using a Custom List in the following order: Valley, Park, West. (Mac   users, create the custom list in the Excel, Preferences, Custom Lists dialog   box.) Add a second level sort by Sport Group and a third level sort by   Program Name both in ascending order.

Display the Sports Season   Comparison worksheet. Copy the range A6:G7, paste it in cell A1, and then   change the title in cell A1 to Criteria. Select the range A2:G3, and then name this range Criteria.

Copy the range A1:G2, and then   Paste the copied range in cell A36. Change the title in cell A36 to Fall-Summer   Sports Season.   Name the range A37:G37 Extract and then name the range A7:G34 Database.

Create an advanced filter that   will place in the Extract area the records from the Database range in which Fall is the primary season and Summer is the secondary season.

Display the Stipends by Group   worksheet. Sort the data in ascending order first by Group and then by Coach   Stipend.

Apply subtotals to the Coach   Stipend column at each change in Group. AutoFit columns C:D and then collapse   the outline so that the Level 2 summary information is displayed.

On the Valley-Park-West   worksheet, in cell J1, insert a Hyperlink to the file you downloaded with   this project, e05G_Coach_Information.   Display the ScreenTip, type Click here for contact information and then test your hyperlink.   Close the e05G_Coach_Information   file.

Select all three worksheets.   Insert a footer in the left section that includes the file name, and in the   right section, insert the Sheet Name. Set the Width and Height to 1 page, and   Center the worksheets horizontally. Change the Theme to Slice, and then change   the Fonts theme to Corbel.

Display the workbook Properties,   and then as the Tags, type sports programs As the Subject, type your course name and section   number. Be sure your name displays as the Author.

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

1. For each of the following code segments, use OpenMP pragmas to make the loop parallel, or

explain why the code segment is not suitable for parallel execution.

a. for (i = 0; i < (int) sqrt(x); i++) {

a[i] = i + 12;

if (i < 10) b[i] = a[i];

}

b. flag = 0;

for (i = 0; (i < n) & (!flag); i++) {

a[i] = 2.8 * i;

if (a[i] < b[i]) flag = 1;

}

c. for (i = 0; i < n; i++) {

a[i] = fun(i);

}

d. for (i = 0; i < n; i++) {

a[i] = fun(i);

if (a[i] < b[i]) b[i] = a[i];

}

e. for (i = 0; i < n; i++) {

a[i] = fun(i);

if (a[i] < b[i]) break;

}

f. product = 0;

for (i = 0; i < n; i++) {

product += a[i] * b[i];

}

g. for (i = j; i < 3 * j; i++) {

a[i] = a[i] + a[i-j];

}

h. for (i = j; i < n; i++) {

a[i] = c * a[i-j];

}

2. Suppose a parallel program completes execution on 32 processors in 348 seconds, and it has

been found that this program spends 21 seconds in initialization and cleanup on one processor, and for

the remaining time all 32 processors are active. What is the scaled speedup of this parallel program?

3. Suppose a parallel program executing on 20 processors spends 98% of its time inside parallel

code. What is the scaled speedup of this parallel program?

4. The table below shows the speedups observed for six different parallel programs A, B, C, D,

E, F as the number of processors is increased from 1 through 8.

Processors

Speedup

A

B

C

D

E

F

1

1.00

1.00

1.00

1.00

1.00

1.00

2

1.60

1.92

1.92

1.96

1.74

1.94

3

2.00

2.73

2.78

2.88

2.30

2.82

4

2.29

3.39

3.57

3.67

2.74

3.65

5

2.50

3.91

4.31

4.46

3.09

4.42

6

2.67

4.29

5.00

5.22

3.38

5.15

7

2.80

4.55

5.65

5.93

3.62

5.84

8

2.91

4.71

6.25

6.25

3.81

6.50

Using the Karp-Flatt metric as the basis, choose the statement that best describes the expected speedup

for each program with 16 processors.

I. The speedup achieved on 16 processors will probably be at least 40% higher than the speedup

achieved on eight processors.

II. The speedup achieved on 16 processors will probably be less than 40% higher than the speedup

achieved on eight processors, due to the increase in overhead as processors are added.

III. The speedup achieved on 16 processors will probably be less than 40% higher than the speedup

achieved on eight processors, due to the large serial component of the computation.

5. Let n ≥ f(p) denote the isoefficiency relation of a parallel system and let M(n) denote the

amount of memory required to store a problem of size n. Use the scalability function to rank the

parallel systems shown below from the most scalable to the least scalable:

a. f(p) = Cp, M(n) = n2.

b. f(p) = C√p, M(n) = n2.

c. f(p) = C√plog p, M(n) = n2.

d. f(p) = Cplog p, M(n) = n2.

e. f(p) = Cp, M(n) = n.

f. f(p) = Cp√p, M(n) = n.

g. f(p) = Cp2√p, M(n) = n.

6. Suppose a problem of size 100,000 can be solved in 15 hours on a computer today. Assuming

that the execution time is solely determined by the CPU speed, determine how large a problem can be

solved in 15 hours time by a computer that is 100 times as fast as today’s computer, if the algorithm

used to solve the problem has a time complexity given by (for a problem size of n):

a. Θ(n2)

b. Θ(nlog2n)

c. Θ(n3)

The final paper of this course will be due during Module 9. The paper will be a 3-4 page analysis of a literary concept of your choice.

For this week’s proposal, submit 2 page overview discussing the topic you intend to use for your final paper. The paper can be about a specific author, a work of prose, a concept, or poetry. It will include preliminary research (citations, references)

The following are some ideas you can use or you can go on your own:

• Selected poems from an author (Shakespeare, Langston Hughes, Haiku’s by Basho, etc)
• Social commentary of a selected work
• The social context of a work (i.e how did Frankenstein reflect the rise of the Industrial Revolution)
• Fables (i.e. how did Aesop’s fables convey a message)
• How did Shakespeare influence modern day English (i.e. Shakespeare made up many new words that still exist today!)
• How did an author convey a theme (i.e. life, death, love, conflict) in a work or across his/her works?
• The development of a character in a work. 

There are many ideas, so you are welcome to choose any topic you want. These are just a few. 

CITE AND REFERENCE

Please let me know if you have questions about this assignment. 

  When responding to classmates please MENTION THEIR NAME.

Please take a few minutes and check the discussion board  to respond to peer OR my comments/queries,

Comments to 2 classmates must be of substance; not just “I agree” or “Good Post.” The purpose of the responses is to convert the discussion forum into a quality learning environment through which you improve your knowledge and understanding of the subject matter.

Discussion Topic

Chapter 10

1. Describe why a project manager needs good verbal and written communication skills.

2. What is meant by the term interpersonal skills? Give some examples of interpersonal skills and explain why they are important.

ü  Students should avoid using phrases like, “In my opinion,” or “I think,” or “I believe.” To support your response post to the weekly discussion question

students are required to provide at least one supporting reference.

Research how Tacoma, WA used the concepts of CPTED to build a sense of community using lighting, natural access control, and natural surveillance. Determine if the strategies used could work in your area.

Fully address the question(s) in this discussion; provide a valid rationale or a citation for your choices and should be at least 350 words in length

Attached 

Week 4 is the last assignment and week 5 is the question.

Article attached 

Write a 2 1/2 page paper that supports or opposes the author’s findings.  Please find two to three other peer-reviewed articles that support your position/argument.

I need to write a term paper on the topic Siemens Simatic- PCS7/WINCC (SCADA) 

Prepare a professional cover letter

Articulate effective interview strategies

Explain the difference between a “good” interview and a “bad” interview

Lecture Notes:
There are 3 sections of a cover letter that are required when writing a professional cover letter to include with your resume:
Introductory paragraph (to attract the potential employer’s attention)
Main Body (to highlight and draw attention to your skills)
Closing paragraph (to ask for an interview

Week 2 assignment #1—related to cover letter  

Using the lecture notes above, the video in this week’s discussion forum, and sources from the internet, write and submit a cover letter for a job you are interested in applying for. You can use indeed.com, careerbuilder.com, LinkedIn, or look for job opening on a company’s website to find a job opportunity that interest you. Be sure to include a copy of the job posting with your cover letter.

Week 2 Assignment #2—interview prep—good interview vs. bad interview (interviewing techniques

https://www.youtube.com/watch?v=HG68Ymazo18 [Title: Top Interview Tips: Common Questions, Nonverbal Communication & More] 

https://www.youtube.com/watch?v=rAIXkf8WOlk [Title: Good interview, bad interview]

After watching both video, write a one to two paragraph reflection of what you will do differently in an interview as a result of what your learned. Explain what you did wrong prior to watching this video. If you have never interviewed for a job, then write about your interview for admission into the  Graduate School.