What are the various technologies employed by wireless devices to maximize their use of the available radio frequencies? Also discuss methods used to secure 802.11 wireless networking in your initial thread.

 Exp19_Excel_Ch03_ML2_Grades

Project Description:

You are a teaching assistant for Dr. Elizabeth Croghan’s BUS 101 Introduction to Business class. You have maintained her gradebook all semester, entering three test scores for each student and calculating the final average. You created a section called Final Grade Distribution that contains calculations to identify the number of students who earned an A, B, C, D, or F. Dr. Croghan wants you to create a chart that shows the percentage of students who earn each letter grade. Therefore, you decide to create and format a pie chart. You will also create a bar chart to show a sample of the students’ test scores. Furthermore, Dr. Croghan wants to see if a correlation exists between attendance and students’ final grades; therefore, you will create a scatter chart depicting each student’s percentage of attendance with his or her respective final grade average.

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

A pie chart is an effective way   to visually illustrate the percentage of the class that earned A, B, C, D,   and F grades.
  Use the Insert tab to create a pie chart from the Final Grade Distribution   data located below the student data in the range F35:G39 and move the pie   chart to its own sheet named Final Grade Distribution.

You should enter a chart title   to describe the purpose of the chart. You will customize the pie chart to   focus on particular slices.
  •Apply the Style 12 chart style.
  •Type BUS   101 Final Grades: Fall 2021 for the chart title.
  •Explode the A grade slice by 7%.
  •Change the F grade slice to Dark Red.
  •Remove the legend.

A best practice is to add Alt   Text for accessibility compliance.
  Add Alt Text: The pie chart shows percentage of students who earned   each letter grade. Most students earned B and C grades. (including the period).

You want to add data labels to   indicate the category and percentage of the class that earned each letter   grade
  Add centered data labels. Select data label options to display Percentage and   Category Name in the Inside End position. Remove the Values data labels. 

Apply 20-pt size and apply   Black, Text 1 font color to the data labels.

You want to create a bar chart   to depict grades for a sample of the students in the class.
  Create a clustered bar chart using the ranges A5:D5 and A18:D23 in the Grades   worksheet. Move the bar chart to its own sheet named Sample   Student Scores 

Customize the bar chart with   these specifications: Style 5 chart style, legend on the right side in 11 pt   font size, and Light Gradient – Accent 2 fill color for the plot area.

Type Sample Student Test Scores for the chart title.

Displaying the exact scores   would help clarify the data in the chart.
  Add data labels in the Outside End position for all data series. Format the   Final Exam data series with Blue-Gray, Text 2 fill color.

Select the category axis and   display the categories in reverse order in the Format Axis task pane so that O’Hair is listed at the top and Sager is listed at the bottom of the   bar chart.
  Add Alt Text: The chart shows test scores for six students in the   middle of the list. (including   the period).

You want to create a scatter   chart to see if the combination of attendance and final averages are related.
  Display the Grades worksheet. Select the range E5:F31 and create a scatter   chart. Cut the chart and paste it in cell A42. Set a height of 5.5″ and a width of 5.96″.

Add Alt Text: The scatter   chart shows the relationship of each student’s final grade and his or her   attendance record. (including   the period).

Titles will help people   understand what is being plotted in the horizontal and vertical axes, as well   as the overall chart purpose.
  Make sure the scatter chart is selected. Type Final Average-Attendance Relationship as the chart title, type Percentage of   Attendance as   the primary horizontal axis title, and type Student Final Averages as the primary vertical axis   title.

To distinguish the points   better, you can start the plotting at 40 rather than 0.
  Make sure the scatter chart is selected. Apply these settings to the vertical   axis of the scatter chart: 40 minimum bound, 100 maximum bound, 10 major units, and a number format with zero decimal places.

Make sure the scatter chart is   selected. Apply these settings to the horizontal axis: 40 minimum bound, 100 maximum bound, automatic units.   

Adding a fill to the plot area   will add a touch of color to the chart.
  Make sure the scatter chart is selected. Add the Parchment texture fill to   the plot area.

You want to insert a trendline   to determine trends.
  Make sure the scatter chart is selected and insert a linear trendline.

You want to add sparklines to   detect trends for each student.
  Select the range B6:D31 on the Grades sheet, create a column Sparkline, and   type H6:H31 in the Location Range box.   Display the Low Point. Set the Vertical Axis Minimum and Maximum Values to be   the same for all Sparklines.

To make the Sparklines more effective   and easier to read, you will increase the row height.
  Change the row height to 22 for rows 6 through 31.

Insert a footer with Exploring   Series on the   left, the sheet name code in the center, and the file name code on the right   on all the sheets. Group the two chart sheets together to insert the footer.   Then insert the footer on the Grades sheet. Change to Normal view

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

Overview:

For this assignment, write a two-page project plan for Sporting Goods. For example, if choosing the creation of a website for a company, some of the tasks involved in Sporting Goods might be the hiring of a web designer and programmer, interviews with users to ascertain their requirements, the creation of a home page, etc.

Instructions:

Include in the Sporting Good plan the start date of each task, the estimated end dates, the resources assigned to each task (that is, the people, equipment, supplies, etc. needed for each task), the cost associated with each task, and the order of the tasks that are specific to your project. Also, include how the tasks are related to each other, that is, which tasks must be completed before other tasks can begin. Also, milestones should be included. Examples of milestones might be: “completion of phase one,” “hiring of all project employees completed,” and “entire project completed.”

Requirements:

• The plan should be 2 pages in length, with additional cover and reference pages.

• The summary should be double-spaced, written in 12-point Times New Roman font, and use a 1-inch margin.

• Use at least two (2) scholarly sources and include all references and citations properly formatted in APA.

• Use complete sentences and appropriate grammar and spelling.

Week 4 Discussion — Business Strategies and Market Opportunities

No unread replies.No replies.

Hello, 

Week 4 Class Discussion topic comes from —

Chapter Three “Business Strategies and Their Marketing Implications”

Chapter Four “Understanding Market Opportunities”

Chapter Five “Measuring Market Opportunities: Forecasting and Market Knowledge”

This class expects you to contribute two times:

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

When entrepreneurs and corporation marketing decision makers face either (1) an opportunity to enter or (2) an attempt to increase their share of a growing market, they must get a clear assessment of the following three questions raised in Chapter Four:

• How attractive is the market we serve or propose to serve?
• How attractive is the industry in which we would compete?
• Are the right resources — in terms of people and their capabilities and connections — in place to effectively pursue the opportunity at hand?

To respond to the above three questions, Exhibit 4.1 “The Seven Domains of Attractive Opportunities” (attached) uses seven domains to undertake a thorough examination.  

Your contribution one — answer one question only out of five questions below —

Question #1 To assess market attractiveness at macro level, what are six major components that marketers must looked at? Explain each component briefly.

Question #2 To assess industry attractiveness at macro level, what are five forces (also called Porter’s Five Competitive Forces) that determine it? Explain each force briefly.

Question #3 To understand markets at the micro level, what kind of situations would be called as attractive?  Explain why.

Question #4 To understand industries at the micro level, what kind of capabilities corporation should have when attractive opportunities are there for taken? Explain why.

Question #5 To pursuit attractive opportunities, people who will pursue them must be “fit” in one way or another defined as “Team Domains”.  What are three “Team Domains”? Explain each domain briefly.

.

• If you are the first person to answer any one of above five questions, given you list the question you choose to response first, followed by your answer.
• If you do not provide an answer to the same question again given student X1 answered Question 1 already (which means that classmate had got here before you did; you should pick Question 2, 3, 4 or 5 instead).
• Otherwise, you will not receive a full 2 points.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Your contribution two — comment on one of your classmates’ posting about his/her contribution one.

You will earn maximum 2 points from your completed contribution two, if —

• Your comment starts with a classmate’s name – making it clear that his/her contribution one that you would like to critique on or discuss with.
• By doing so, this class could follow with each other’s discussion thread without confusion; otherwise, you will not receive a full 2 points.

Hello, need help entering a code into eclipse. 

Part I:

Review the “7 Steps to Solving a Problem” attachment above

Part II:

Read the story below: 

You are currently working at a small company of about 100 employees. Your company just lost a very large client and therefore they need to let go of five employees in your department.

The workload of the five employees has been divided up between you and a fellow employee. Your fellow employee is very upset about this because now they must take on more work and not get a pay raise. This employee wants you to join them and fight your boss together for more money. You don’t feel comfortable doing this because you love your job. You would like to make more money, but you do not want to upset anyone and lose your position. On top of this situation, there is a big project that needs to be completed in three days!

How would you solve the above problem? 

1. Review the “7 Steps to Solving a Problem” attachment. Reflect on, and discuss, how the problem described above can be resolved using the steps.
2. Analyze and explain your application of each of the 7 steps in the “7 Steps to Solving a Problem” attachment to solving the problem described in the above story

Your submission should be a minimum of one page of content in length. Please type the question as well as your answer. Properly cite any source utilized in APA format.

 Attached Files:

•  Instructions for PowerPoint.pdf Instructions for PowerPoint.pdf – Alternative Formats (129.46 KB)

This presentation should summarize what you learned from your Word Assignment about your chosen careers. You will be able to complete the PowerPoint presentation with features you learned in the attachment. Your presentation must include: SUmmary of work Excel (Evaluation Matrix) and Description of two careers (Advance Registered nurse and cybersecurity analyst) used Microsoft Word Documents

1. Themes 
2. Transitions  
3. Pictures  
4. Animation  
5. Audio – Audio should enhance the purpose of your presentation. Do not just add random music or read your slides. 
6. Video (convert the PowerPoint into a video)   

You are required to follow Guy Kawasaki’s 10 20 30 rule. This rule is you should have no more than 10 slides, you should not talk for more than 20 minutes and you should not use a font size that is less than 30 points. Look Guy up and see what his background is. Check out his web page. He explains the rule nicely in this short video:

http://www.youtube.com/watch?v=-M13SObffog

we have been building our Database using concepts of design and Structured Query Language (SQL). Now, your database should be ready to be deployed into action. This usually means the database structure and relationships have been thoroughly tested and everything functions as anticipated to begin the development of a Database Management Systems (DBMS) or Web pages (GUI) that will interact with it.

In the next couple weeks, you need to work with a database management system (DBMS) that will be your Graphical User Interface (GUI) for building and maintaining your database. Use this additional information on DBMS functions and resources as you complete your assignment.

This week, find and submit a database management system (DBMS) proposal for your final project. Choose a DBMS that you believe you will be able to execute during these last couple weeks. Your proposal must include the name and description of the DBMS (documentation and/or links). Include 1-2 paragraphs explaining why this DBMS interests you. Also, share a few challenges you anticipate by using the DBMS in your database project.

Exp19_Excel_Ch11_HOEAssessment_Accountants

Exp19 Excel Ch11 HOEAssessment Accountants

Excel Chapter 11 Hands-On Exercise Assessment – Accountants

Project Description:

You work for a tax accounting firm that has offices in San Diego, Dallas, Miami, and Albany. Previously, you downloaded data from the employee database. Now you will use text, database, and lookup functions to obtain the results you want.

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

Your first step is to create a   unique ID for each accountant using the year hired, date hired, and number.
 

  In cell D2, enter 2007-1018-10 and use Flash Fill to complete the pattern to   create the remaining IDs in the range D3:D26.

The accountants’ full names are   located in column E. You want to separate the first and last names.
 

  Select the range E2:E26 and convert text to columns using the space as the   delimiter. Change cell E1 to First Name.

Next, you want to display the   accountants’ names with the last name and first name, separated by a comma.
 

  In cell G2, insert the TEXTJOIN function to join the last name and first name   for the first accountant, using a comma and space as the delimiter. The name   should display as Adams, Camille.   Copy the function to the range G3:G26.

Column J contains the phone   numbers. You want to extract the area codes.
 

  In cell K2, use the MID function to extract the area code for the phone   number for the first employee. The Start_num argument should be the position   of the first digit in the area code to avoid including the opening   parenthesis. Make sure the function extracts the three-digit area code. Copy   the function to the range K3:K26.

The Location column displays the   city names in all capital letters. Because this is hard to read, you will use   a text function to display the cities in upper and lowercase.
 

  In cell M2, use the PROPER function to display the first city name in upper   and lowercase. Copy the function to the range M3:M26.

You want to create a criteria   range to perform an advanced filter. The criteria are (1) Tax Accountants in   Miami and (2) Tax Accountants in San Diego.
 

  Copy the range A1:M1 and paste it in the range A28:M28. Enter Tax Accountant and Miami in the respective cells on row 29. Enter Tax   Accountant and San Diego in the respective cells on row   30.

Now you are ready to perform the   advanced filter by copying the data below the criteria range.
 

  Click within the dataset. Select A1:M26 as the list, the criteria range you   defined in the previous step, and A32:M32.

Next you want to calculate the   total salaries for all Tax Accountants in Miami and San Diego.
 

  In cell P2, insert the DSUM function using the dataset, column heading Salary, and the defined criteria   range.

Next, you will calculate the   average salary for Tax Accountants in Miami and San Diego.
 

  In cell P3, insert the DAVERAGE function to calculate the average salary   using the column heading Salary.

You want to identify the highest   salary for Tax Accountants in Miami and San Diego.
 

  In cell P4, insert the DMAX function.

Next, you want to identify the   lowest salary of Tax Accountants in Miami and San Diego.
 

  In cell P5, insert the DMIN function.

Finally, you want to count the   number of Tax Accountants in Miami and San Diego.
 

  In cell P6, insert the DCOUNT function.

The range O8:P9 contains a new   set of criteria to identify the one Senior Accountant in San Diego. You want   to obtain that person’s salary.
 

  In cell P11, insert the DGET function.

The range O13:P16 is designed to   look up a person’s name to return the position number and salary for that   person. First, you will look up the person’s location within the dataset.
 

  In cell P15, insert the MATCH function to look up the name in cell P14 and   return that person’s position within the Last Name column. Use only the range   containing the actual last names in the argument.

Now that you have the position   number for the accountant, you are ready to identify that person’s salary.
 

  In cell P16, insert the INDEX function using the range F2:M26 as the range   and the position number identified by the MATCH function.

In cell O19, insert the   FORMULATEXT function to display the formula that is stored in cell P15. Copy   the function to cell O20.

Create a footer with your name   on the left side, the sheet tab code in the center, and the file name code on   the right side of the worksheet.

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

1) Project goals.
2) Database description: A general description of the database, what data is stored in the database.
How the database will benefit the users.
3) Data model & design:
o Completed ER/EER diagram, 5 tables minimum (8 tables in case the group has 2
members)
 MUST use https://www.draw.io to draw the ER diagram, and then take a
snapshot.
 Include a snapshot of the diagram in the report.
o Business rules.
o Data dictionary: For each one of the tables, list columns, data types, column restrictions,
column descriptions.

4) Implementation:
o Use MySQL Server and MySQL Workbench to create the database/tables.
 Include a snapshot of the SQL code in your report
o Populate the each table with a minimum of 20 rows of sample data. Make sure the
entered data is descriptive (not just random numbers and letters.
 Include a snapshot of the SQL code in your report.
o Use MySQL Server and MySQL Workbench to write/run the SQL queries below. For
each query, provide the following in Report 2:
  Snapshot of the code and the output in the report.  
 In about 2 lines, explain what the query returns.
Queries:
 1 trivial query. Simple select with ordering.
 2 medium difficulty queries. Queries that use composite condition for selection,
computations, aggregate function and grouping.  
 1 query that uses subquery.
 2 queries that uses join (1 inner join, 1 left or right outer join).
 1 view (query must use join – hint: you can use one of the queries from the
previous question).
 1 query that uses union.
 1 custom stored function.
 1 custom stored procedure. 

 ENTITIES WITH ATTRIBUTES

 CHILDREN: Id, First Name, Last Name ,Age, Gender, Instructor Id,  Guardian Number PROFESSOR : Id, First Name,  Last Name,  Home Address, Department,  Office Hours, Office Phone

 ACCOUNTING: Date,  Rental fee,  Electricity,Servicing , Tax paid ,Earning , Worker’s salary , Contribution

 HEALTH SECTOR: Children Id,  Sickness,  Disabled,  Hypersensitive,  Vaccination,  Health Records,  Prescription 

CATALOG: Books, Cardboard, Ink-pen, Highlighter,  pencil

  List of the 10 questions 

1. Display all the columns and rows of the children’s table whose first name starts with the letter B for every class. 

2. Display all the columns from the professor table whose office phone starts with 6.

 3. Display how many children have each professor has. 

4. Display worker’s salary and electricity bill of 2020. 

5. Display Guardian Number of the children with prescription. 

6. Display the name of the children with disabilities whose names start with c, d, and f.

 7. Display the name of the children who are healthy and have no medical history. 

8. Display the name of the children who have hypersensitive. 

9. Display the name of the children who are using cardboard and have medical prescriptions. 

10. Display tax paid and contribution.