Data Collection and Analysis

Details:  you will perform a rudimentary analysis of an existing system (more specifically, the system you plan to redesign) using the System Usability Scale (SUS). This blog will challenge you to recruit participants for your analysis, implement the SUS and interpret the data results.

Requirements:

1. Clearly identify (i.e. explain and discuss) the system you are analyzing. The system should be the system you plan to redesign, or a similar system. 

2. Recruit a minimum of five individuals to participate in a simple user experience questionnaire using the SUS instrument found here: SUS-Instrument.pdf

. While individuals need not be familiar with the exact system you are redesigning, they should be familar with the general category of system. Include all results in your write-up.

3. Perform a rudimentary analysis of the data. Review the instructions on how to interpret SUS here: SUS-Details.pdf

4. Interpret the results. What are the strengths and weaknesses of the system. How might this analysis contribute to the redesign of your own system.

Exp19_Excel_Ch11_Cap_Donors

Exp19_Excel_Ch11_Cap_Donors

 

You are a development officer for a state university. As an officer, you manage a portfolio of important donors who contribute financially to different areas within the university. You categorize the donors based on the college or school for which they want their donations associated. You recently downloaded the portfolio to an Excel workbook. Based on the way the data downloads from the main database, you want to format the text for readability and to make it easier for you to analyze. In addition, you will create an advanced filter to review a list of donors for a particular college or school. Finally, you want to create a look up area to look up data for a specific donor and create a summary section.

2

The first column displays the   name of the college or school (such as ART   or BUSINESS) associated with each.   You want to assign a three-character code for each college and use that code   to attach to existing donor IDs to create a unique field.
 

  In cell B8, insert the LEFT function to extract the first three characters   from the college name in cell A8. Copy the function to the range B9:B35.

3

You now want to combine the college   ID and donor ID.
 

  In cell D8, insert the CONCAT function to combine the college ID in cell B8   with the donor ID in cell C8 with a hyphen between the two text strings. Copy   the function to the range D9:D35.

4

In cell J8, insert a text   function that displays the college name from cell A8 with just the first   letter capitalized, such as Engineering.   Copy the function to the range J9:J35.

5

The Full Name column displays   last and first names of the donors. You want to display last names only in a   separate column.
 

  In cell F8, type Schneider and use Flash Fill to fill in the last names for   the donors in the range F9:F35.

6

The Address column contains   street addresses, city names, and state abbreviations. To manage the address   list better, you will separate the data into three columns.
 

  Select the addresses in the range G8:G35 and convert the text to columns,   separating the data at commas .

7

The top-left section of the   spreadsheet is designed to be able to enter a donor’s ID, such as ENG-15, and   look up that person’s position in the list, display the donor’s full name,   and display the amount donated this year. The first step is to identify the   position number of the donor ID.
 

  In cell B3, insert the MATCH function to look up the donor ID in cell B2,   compare it to the list in the range D8:D35, and then return the donor’s   position within the list.

8

Now you are ready to use the   position number as an argument within the INDEX function.
 

  In cell B4, insert an INDEX function that uses the range D8:K35, looks up the   row position number from the MATCH function result, and then uses the column   position number for Full Name.

9

In cell B5, insert an INDEX   function that uses the range D8:K35, looks up the row position number
  from the MATCH function result, and then uses the column position number for   Donation.

10

You want to format the results   of the INDEX function.
 

  Format the value in cell B5 as Accounting Number Format with zero decimal   places.

11

To analyze the donor records,   you are ready to create criteria and output ranges. You will enter conditions   to find records for donors to the College of Business who donated $1,000 or   more.
 

  Copy the range A7:K7 to cell A38 to create the column labels for the criteria   range. Type Business in cell J39 and >=1000 in cell K39.

12

You are ready to create the   output area and perform the advanced filter.
 

  Copy the column labels to cell A42. Perform the advanced filter by copying   the records to
  the output area.

13

Now that you created a copy of   the records meeting the conditions, you are ready to enter database functions   in the Summary area.
 

  In cell K2, insert the database function to total the value of the donations   for the records that meet the conditions in the criteria range.

14

In cell K3, insert the database   function to calculate the average donation for the records that meet the   conditions in the criteria range.

15

In cell K4, insert the database   function to count the number of records that meet the conditions in the   criteria range.

16

Format the range K2:K3 with   Accounting Number Format with zero decimal places. Format cell K4 with Comma   Style with zero decimal places.

17

You want to use the FORMULATEXT   function to display the functions.
 

  In cell G2, insert the FORMULATEXT function to display the formula stored in   cell B3.
  In cell G3, insert the FORMULATEXT function to display the formula stored in   cell B4.
  In cell G4, insert the FORMULATEXT function to display the formula stored in   cell D8.
  In cell G5, insert the FORMULATEXT function to display the formula stored in   cell K2.

18

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

19

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

Interactive Computer Graphics -7

 

Discussion:

Mixing two or three of the three primary colors of light with varying degrees of intensity can produce a wide range of other colors. List fifteen different combinations of the primary light colors. 

python

 

Create an app called MyFinances. The app should allow the storing of financial objects. The financial objects are CDs, Loans, and Checking accounts. CDs should be able to store the account number, initial balance, current balance, and interest rate. Loans should be able to store the account number, initial balance, current balance, payment amount, and interest rate. Checking accounts should be able to store the account number and current balance.

▪ The user should select the type of account to enter with RadioButtons.

▪ Selection of the account should enable/disable relevant fields on the data entry activity.

▪ Store objects using a database table when the user clicks the Save button.

▪ The Save button should also display a saved message and clear the screen.

▪ A Cancel button should clear the screen without saving any data.

policies

Section1 

Using the Internet and/or the Library, research and complete the following: 

In 1,000 or more words, respond to the following: 

Evaluate how to implement a secure wireless network using Active Directory and RADIUS server. 

Explain how to do this and provide it in a step-by-step implementation guide using screenshots and explanations. 

Section 2 

In 200 or more words for each answer, respond to the following: 

  • Explain step by step how a hacker would crack passwords, starting with extracting the hash file in a non-Active Directory and an Active Directory client.
  • Write a remote access cybersecurity policy for remote users. 

Assignment: Development Plan for Three Skills

What to submit/deliverables: Word document that contains the Week 9 Assignment Template.

What is the value of doing this assignment? For the last nine weeks, you’ve been learning how the 10 Skills are an essential part of being successful in the future world of work. In Week 4 Assignment, you began to reflect on your skills and goals and how the 10 Skills have helped you reach accomplishments. Your understanding of the skills has been refined, and now it’s time to reflect on your strengths and areas for growth again in order to develop a plan moving forward.

For this assignment, you’ll identify three skills that you’d like to focus on and develop a plan for. This could be the three skills you wrote about for Week 2 Assignment or three new skills. As you think of which skills you’d like to improve upon, consider choosing skills at varying levels. You might, for example, choose a skill that you are already strong in, but would be excited to continue exploring and building upon, as well as a skill in which you might have more room for growth. At the end of the assignment, you’ll leave with the beginning of a tangible plan for personal and professional development that you can review with the Career Center team.

Your goal for this assignment is to: Practice your communication skill by using the Week 9 Assignment Template to outline a plan for developing skills to support a successful learning experience and career. To truly develop your communication skill it is important that you write using your own words and do not cut and paste from the Skills Definition table or any other source. (See the Skill Development Plan Sample .)

Steps to complete: In Week 9, complete and submit your Development Plan for Three Skills using the following steps:

STEP 1: Identify the targeted skill. Summarize your strengths and areas of improvement in this skill area. Then, identify your desired outcomes around this skill area and write a positive goal statement. Review the Skills Definition table if you need a quick reminder of the 10 skills. Complete the following sections of the template:

• Target Skill
• Strengths
• Areas of Improvement
• Desired Outcome
• Goal Statement

STEP 2: Specify the actions you can take to work towards your goals, with specific strategies and practices that you can apply. Identify any potential obstacles and challenges to achieving your goal. Complete the following sections of the template:

• Practices for Growth
• Action Steps
• Potential Obstacles and Challenges

STEP 3: Keeping your action plan in mind, identify trusted supporters and university resources that can help you in your skill development plan. Complete the following sections of the template:

• Key Supporters
• Supporting University Resources

STEP 4: Reflect on the connections between skill development and your overall personal, academic, and professional goals. Complete the following sections of the template:

Benefits From Change and Connections to Personal, Academic, and Career Goals.

STEP 5: Complete Steps 1–4 for the two other skills you have identified. When you are done you should have three plans filled out in the template for three different skills.

Design the logic for a program

  

1.Design the logic for a program that allows the user to enter 10 numbers, then displays them in the reverse order of their entry.

 2.Modify the reverse display program so that the user can enter up to 10 numbers until a sentinel value is entered.

 
 

Case Study

 –  Read Aggressive Sales Quotas or Unfair Business Practice? and complete the questions at the end of the case study   ( https://www.scu.edu/ethics/focus-areas/business-ethics/resources/aggressive-sales-quotas-or-unfair-bus-practice/)

– The answers should be a minimum of two pages with two references attached for each. There should be no plagiarism- attach a plagiarism report with 0% similarity index