Business

In each of the assignments in this course, you will be dealing with the following scenario: American Intellectual Union (AIU) has assembled a team of researchers in the United States and around the world to study job satisfaction. Congratulations, you have been selected to participate in this massive global undertaking.

The study will require that you examine data, analyze the results, and share the results with groups of other researchers. Job satisfaction is important to companies large and small, and understanding it provides managers with insights into human behavior that can be used to strengthen the company’s bottom line.

The data set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU). This session’s unique data set may be found in the LEARNING MATERIALS and it contains the following nine sections of data that will be used throughout our course:

GenderAgeDepartmentPositionTenureOverall Job SatisfactionIntrinsic Job Satisfaction—Satisfaction with the actual performance of the jobExtrinsic Job Satisfaction—external to the job, for example, office location, your work colleagues, your own office (cubicle/hard walled office, etc),Benefits—Health insurance, pension plan, vacation, sick days, etc.

In the first assignment you are to complete the following:

• You will need to examine two of the nine sections of data:one section of qualitative data (choose either Gender or Position)one section of quantitative data (choose either Intrinsic or Extrinsic)
• Each section should include all data points listed in the column for the variable. The requirements include:Identify the data you selected.Explain why the data was selected.Explain what was learned by examining these sets of data.Your analysis should include using Microsoft Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode).Your analysis should also include the use of two measures of variability (standard deviation and variance). Some measures are appropriate for qualitative data, and some are appropriate for quantitative data.If a measure is not applicable, then explain why.You will have to also provide one chart/graph for each of the results of the two processed sections of data (2 total), such as a pie or bar chart or a histogram. (A table is not a chart/graph.) Ensure that you label the chart/graph clearly.You will then need to discuss what you additionally learned from the results of this process.Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important.

You will need to combine all of the items above into one comprehensive report. This report must be completed in Microsoft Word and should contain: 

This assignment will be assessed using the rubric provided 

here

.

Load the Data Analysis Toolpak by following 

these instructions

.

NEED HELP?

• Check out the Free Tutoring Available for BUSN311 students. You will need to sign up for the tutoring. Your instructor has the session-specific information. Don’t wait, tutoring appointments fill up quickly.
• Beginning Statistics Lab. Presentations and Resources are Available 24/7. Synchronous Live Sessions and Office Hours are held during the session. Live Sessions are also recorded for viewing at your convenience. Your instructor has the session-specific information.
• The tutors and the lab instructor are qualified faculty members.

Please submit your assignment as a Word document in APA format using the attached 

Template

. Do NOT change the font, page breaks or margins. Using the template without deleting the headings ensures that you cover each segment of the assignment.

**********A NEW SET OF DATA IS USED EACH SESSION**********

If you are taking this class for a second time, submission of past work involving the data sets will result in a zero for the assignment. Your answers will be wrong since you are working with a different
 set of numbers.

If you procure old assignments from students or websites and use the data for your assignment, you will receive a zero because it is considered an egregious violation of the University’s academic integrity policy. The case will be referred to the Office of Academic Affairs and become part of your collegiate record. In certain circumstances, you may be awarded an F for the course.

The only way to succeed in this course is to complete the assignments using the current, dataset accessible through the link in Unit 1 on the assignment list. If you have a question or need clarification, please contact your instructor.

**********A NEW SET OF DATA IS USED EACH SESSION**********

For assistance with your assignment, please use your text, Web resources, and all course materials.

In each of the assignments in this course, you will be dealing with the following scenario: American Intellectual Union (AIU) has assembled a team of researchers in the United States and around the world to study job satisfaction. Congratulations, you have been selected to participate in this massive global undertaking.

The study will require that you examine data, analyze the results, and share the results with groups of other researchers. Job satisfaction is important to companies large and small, and understanding it provides managers with insights into human behavior that can be used to strengthen the company’s bottom line.

The data set for the study is a sample of a survey conducted on the population of the American Intellectual Union (AIU). This session’s unique data set may be found in the LEARNING MATERIALS and it contains the following nine sections of data that will be used throughout our course:

· Gender

· Age

· Department

· Position

· Tenure

· Overall Job Satisfaction

· Intrinsic Job Satisfaction—Satisfaction with the actual performance of the job

· Extrinsic Job Satisfaction—external to the job, for example, office location, your work colleagues, your own office (cubicle/hard walled office, etc),

· Benefits—Health insurance, pension plan, vacation, sick days, etc.

In the first assignment you are to complete the following:

· You will need to examine two of the nine sections of data:

· one section of qualitative data (choose either Gender or Position)

· one section of quantitative data (choose either Intrinsic or Extrinsic)

· Each section should include all data points listed in the column for the variable. The requirements include:

2. Identify the data you selected.

2. Explain why the data was selected.

2. Explain what was learned by examining these sets of data.

2. Your analysis should include using Microsoft Excel to obtain information about the data through the use of three measures of central tendency (mean, median, mode).

2. Your analysis should also include the use of two measures of variability (standard deviation and variance). Some measures are appropriate for qualitative data, and some are appropriate for quantitative data.

2. If a measure is not applicable, then explain why.

2. You will have to also provide one chart/graph for each of the results of the two processed sections of data (2 total), such as a pie or bar chart or a histogram. (A table is not a chart/graph.) Ensure that you label the chart/graph clearly.

2. You will then need to discuss what you additionally learned from the results of this process.

2. Explain why charts/graphs are important in conveying information in a visual format and why standard deviation and variation are important.

You will need to combine all of the items above into one comprehensive report. This report must be completed in Microsoft Word and should contain: 

This assignment will be assessed using the rubric provided 

here

.

Load the Data Analysis Toolpak by following 

these instructions

.

NEED HELP?

· Check out the Free Tutoring Available for BUSN311 students. You will need to sign up for the tutoring. Your instructor has the session-specific information. Don’t wait, tutoring appointments fill up quickly.

· Beginning Statistics Lab. Presentations and Resources are Available 24/7. Synchronous Live Sessions and Office Hours are held during the session. Live Sessions are also recorded for viewing at your convenience. Your instructor has the session-specific information.

· The tutors and the lab instructor are qualified faculty members.

Please submit your assignment as a Word document in APA format using the attached 

Template

. Do NOT change the font, page breaks or margins. Using the template without deleting the headings ensures that you cover each segment of the assignment.

**********A NEW SET OF DATA IS USED EACH SESSION**********

If you are taking this class for a second time, submission of past work involving the data sets will result in a zero for the assignment. Your answers will be wrong since you are working with a different set of numbers.

If you procure old assignments from students or websites and use the data for your assignment, you will receive a zero because it is considered an egregious violation of the University’s academic integrity policy. The case will be referred to the Office of Academic Affairs and become part of your collegiate record. In certain circumstances, you may be awarded an F for the course.

The only way to succeed in this course is to complete the assignments using the current, dataset accessible through the link in Unit 1 on the assignment list. If you have a question or need clarification, please contact your instructor.

**********A NEW SET OF DATA IS USED EACH SESSION**********

For assistance with your assignment, please use your text, Web resources, and all course materials.

\Data Analysis Tool Pak

Load the Analysis ToolPak

The Analysis ToolPak is a MicrosoftOffice Excel add‐in programthatis available when you install Microsoft

Office or Excel. To use itin Excel, however, you need to load itfirst.

1. Click the MicrosoftOffice Button , and then click ExcelOptions.

2. Click Add‐Ins, and then in the Manage box,select Excel Add‐ins.

3. ClickGo.

4. In the Add‐Ins available box,selectthe Analysis ToolPak check box, and then clickOK.

Tip: If Analysis ToolPak is notlisted in the Add‐Ins available box, click Browse to locate it.

If you get prompted thatthe Analysis ToolPak is not currently installed on your computer, click Yesto install it.

5. After you load the Analysis ToolPak,theData Analysis command is available in the Analysis group on

theData tab.

6.

NOTE: To include Visual Basic for Application (VBA)functionsforthe Analysis ToolPak, you load the Analysis

ToolPak ‐ VBA add‐in the same way that you load the Analysis ToolPak. In the Add‐ins available box,selectthe

Analysis ToolPak ‐ VBA check box, and then clickOK.

SOURCE: Microsoft.com

Although Mac is currently only supported for use in the AIUBachelor of Fine Arts Program,thisinformation is

provided to assist you in completing the course. Be advised that neither yourinstructor nortechnicalsupport

representativesmay be familiar with the Mac version of MicrosoftOffice.

MACHELP: I can’tfind theAnalysis ToolPak

Cause: Excel 2008 does notinclude the Analysis ToolPak.

Solution: Download StatPlus:mac LE forfree fromAnalystSoft, and then use StatPlus:mac LE with Excel 2008.

You can use StatPlus:mac LE to performmany ofthe functionsthat were previously available in the Analysis

ToolPak,such asregressions, histograms, analysis of variance (ANOVA), and t‐tests.

1. Visitthe AnalystSoft Web site, and then follow the instructions on the download page.

2. After you have downloaded and installed StatPlus:mac LE, open the workbook that containsthe data

that you wantto analyze.

3. Open StatPlus:mac LE.

4. Fromthe StatPlus:mac LEmenu,selectthe function that you want.

5. In StatPlus:mac LE,selectthe workbook data you wantto work with,set your parameters and any

optionsthat you want, and then clickOK.

Note Excel 2008 does notincludeHelp for StatPlus:m

1

Undergraduate Program Rubric—BACHELOR OF BUSINESS ADMINISTRATION and ASSOCIATE OF ARTS IN BUSINESS ADMINISTRATION
Expectations: Student work at the undergraduate level is expected to focus on a broad overview of the academic discipline, along with—where appropriate—basic theoretical
frameworks of professional practices and familiarity with discipline-specific tools and their application.

Criteria Exemplary (A)) Accomplished (B) Proficient (C) Partially Proficient (D) Unacceptable (F)

Functional areas include, where
applicable:

BUSINESS PROGRAM CONTENT

Leadership, management,
innovation, and teambuilding

Operations and Marketing
Finance
Economics
Qualitative and quantitative

tools
Technology and Internet
Ethical and legal issues
International issues

Demonstrates
outstanding or
exemplary mastery of
content, appropriate to
the assignment and the
relevant terminal course
objectives and program
learning outcomes.

All requirements of the
assignment are included
in the response.

Demonstrates sound
or accomplished
mastery of content,
appropriate to the
assignment and the
relevant terminal
course objectives and
program learning
outcomes.

Most requirements of
the assignment are
included in the
response.

Demonstrates adequate
or proficient mastery of
content, appropriate to
the assignment and the
relevant terminal
course objectives and
program learning
outcomes.

Many requirements of
the assignment are
included in the
response.

Demonstrates
inadequate or partially
proficient mastery of
content, appropriate
to the assignment and
the relevant terminal
course objectives and
program learning
outcomes.

Some requirements of
the assignment are
included in the
response.

Demonstrates
unacceptable mastery
of content,
appropriate to the
assignment and the
relevant terminal
course objectives and
program learning
outcomes.

Few or no
requirements of the
assignment are
included in the
response.

Approach and Purpose,
Organization, Style, Grammar,
Mechanics, Format,
Presentation and Delivery
(where applicable)

EFFECTIVE COMMUNICATION

Demonstrates outstanding
or exemplary application
of written, visual, or oral
skills.

Demonstrates outstanding
expression of topic, main
idea, and purpose.

Audience is addressed
appropriately.

Language clearly and
effectively communicates
ideas and content relevant
to the assignment.

Errors in grammar,
spelling, and sentence
structure are minimal.

Organization is clear.

Format is consistently
appropriate to assignment.

Demonstrates sound or
accomplished
application of written,
visual, or oral skills.

Demonstrates sound or
accomplished expression
of topic, main idea, and
purpose.

Audience is usually
addressed appropriately.

Language does not
interfere with the
communication of ideas
and content relevant to
the assignment.

Errors in grammar,
spelling, and sentence
structure are present,
but do not distract.

Organization is apparent

Demonstrates adequate
or proficient application
of written, visual, or oral
skills.

Demonstrates adequate
expression of topic, main
idea, and purpose.

Audience is generally
addressed appropriately.

Language is adequate,
generally communicating
ideas and content
relevant to the
assignment.

Errors in grammar,
spelling, and sentence
structure are present and
sometimes distract from
meaning or presentation.

Organization is adequate,

Demonstrates
inadequate or partially
proficient application of
written, visual, or oral
skills.

Demonstrates
inadequate or partial
expression of topic,
main idea, and purpose.

Audience is often not
addressed appropriately.

Language often impedes
the communication of
ideas and content
relevant to the
assignment.

Errors in grammar,
spelling, and sentence
structure are frequent
and often distract from

Demonstrates
unacceptable application
of written, visual, or oral
skills.

Demonstrates
unacceptable, unclear
expression of topic, main
idea, and purpose.

Audience is not
addressed appropriately.

Language does not
clearly and effectively
communicate ideas and
content relevant to the
assignment.

Errors in grammar,
spelling, and sentence
structure are pervasive
and consistently
distracting.

2

Criteria Exemplary (A)) Accomplished (B) Proficient (C) Partially Proficient (D) Unacceptable (F)
Presentation and delivery
are confident and
persuasive (where
applicable).

and mostly clear.

Format is appropriate to
assignment, but not
entirely consistent.

Presentation and
delivery are mostly
confident and
persuasive (where
applicable).

though confusing or
unclear at times.

Format is adequate, but
inconsistent.

Presentation and delivery
are adequate, with
evident lack of
confidence and
persuasive power (where
applicable).

meaning or
presentation.

Organization is
inadequate, confusing,
and distracting.

Format is inadequate
and obscures meaning.

Presentation and
delivery are inadequate,
lacking confidence and
persuasive power
(where applicable).

Format is absent or
consistently appropriate
to assignment.

Organization is not
apparent and completely
inadequate.

Presentation and
delivery are
unacceptable, with little
or no confidence and
persuasive power
(where applicable).

CRITICAL AND CREATIVE
THINKING, PROBLEM-SOLVING

PRACTICAL REASONING

Demonstrates outstanding
or exemplary ability to
analyze assumptions and
evaluate evidence,
complexities of issues, and
alternatives. Where
required, demonstrates
outstanding or exemplary
ability to use creativity and
originality in problem-
solving.

Demonstrates sound or
accomplished ability to
analyze assumptions and
evaluate evidence,
complexities of issues,
and alternatives. Where
required, demonstrates
sound or accomplished
ability to use creativity
and originality in
problem-solving.

Demonstrates adequate
or proficient ability to
analyze assumptions and
evaluate evidence,
complexities of issues,
and alternatives. Where
required, demonstrates
adequate or proficient
ability to use creativity
and originality in
problem-solving.

Demonstrates
inadequate or partially
proficient ability to
analyze assumptions and
evaluate evidence,
complexities of issues,
and alternatives. Where
required, demonstrates
inadequate or partially
proficient ability to use
creativity and originality
in problem-solving.

Demonstrates
unacceptable ability to
analyze assumptions and
evaluate evidence,
complexities of issues,
and alternatives. Where
required, demonstrates
unacceptable ability to
use creativity and
originality in problem-
solving.

INFORMATION LITERACY AND
RESEARCH

PRACTICAL REASONING

Demonstrates
outstanding selection
and use of high quality,
credible, and relevant
sources to develop ideas
that are appropriate to
the assignment.

Sources are consistently
cited according to
required documentation
(e.g., APA), with almost
no errors.

Demonstrates sound
selection and use of
credible, relevant
sources to support
ideas that are
appropriate to the
assignment.

Sources are generally
cited according to
required
documentation (e.g.,
APA), with few errors.

Demonstrates adequate
selection and use of
credible and/or
relevant sources to
support ideas that are
appropriate to the
assignment.

Sources are cited
according to required
documentation (e.g.,
APA), with some errors.

Demonstrates
inadequate selection
and use of sources to
support ideas in the
writing.

Sources are
inconsistently cited
according to required
documentation (e.g.,
APA), with frequent
errors.

Demonstrates
unacceptable selection
and use of sources to
support ideas in the
writing.

Sources are not cited
according to required
documentation (e.g.,
APA).