**Excel and SPSS e-Portfolio Guidelines**

The Excel and SPSS Portfolio will consist of all the Microsoft Excel and SPSS

lab assignments.

It should be in the same sequence as that of being instructed, generally from lab assignment 1 to 8.

The portfolio will consist of a cover page for the entire portfolio and will also consist of a cover page for each lab assignment. The format of the cover page for the entire portfolio and each lab assignment is provided below.

The written text will be double-spaced, font size 12, and Times New Roman.

Please set the Top, Bottom, Left, and Right Margins to 1 inch.

Each lab assignment should have its own cover page, followed by the explanatory paragraph, and printed output pages.

**The Excel and SPSS Portfolio must look professional**.

The Portfolio must consist of a cover page followed by table of contents, followed by all computer laboratory assignments.

Sample portfolio are available with peer tutor and instructors, please feel free to stop by and look at the old sample portfolios.

**PLEASE NOTE THAT THE PORTFOLIO IS SUBMITTED DIGITALLY AS A SINGLE PDF FILE TO DROP BOX ON D2L**

**Please note that the explanatory paragraphs, the title page, table of contents, and title page for portfolio will all be written in word document and converted to PDF.**

**The lab outputs for excel, where you will create the tables will be copied and pasted into word document and converted to PDF document. The output**

**from SPSS will be exported to PDF.**

**Now when time comes to make everything into one file then you can use one of the several available online PDF joiner websites to join your various PDF files in correct sequence and order of the e- portfolio and make them into one single file.**

**For the table of contents, the page numbers are optional, you can insert the page numbers if you have Acrobat Professional (optional).**

**Please make sure you submit it by the due date and time, only one single file can be uploaded to D2L.**

**Failure to comply with these instructions will result in a failing grade**.

The EXCEL and SPSS PORTFOLIO LAYOUT:

o Page One Cover Page

o Page Two Table of Contents

o Page Three Individual Computer laboratory assignments **(Each lab**

**assignment must have its own Tab, Cover Page and Explanatory**

**Paragraph)**

**The cover page for the portfolio will look as provided below:**

**Excel and SPSS Computer Lab Assignment # 5**

1. Using SPSS and the “Regression” data set located in e-learning conduct a frequency distribution and stem-and-leaf plot for variables General Self- Efficacy, Intervention, Predictors of Success, and Academic Motivation.

2. Write an Explanatory Paragraph (not to exceed one page; double-spaced) addressing the results of your frequency distribution and stem-and-leaf plot. Comment on the skeweness and kurtosis of the variables, as well on the distribution of the variables as compared to a normal distribution.

3. The Computer Lab Assignment must follow this format to be graded: Page 1: Cover page

Page 2: Explanatory Paragraph

Page 3: Appendix A (must contain the original SPSS outputs)

**Excel and SPSS Computer Lab Assignment # 6**

1. Using SPSS and “Regression” (** Method: Enter **) data set located in e-learning conduct a multiple linear regression analysis.

2. *Dependent Variable*: General Self-Efficacy

*Independent Variables*: Academic Motivation, Social Activity, Intervention, Predictors of Success

*(Please stick to the same order when entering independent variables into SPSS)*

3. Write the prediction equation at the start of the explanatory paragraph, please center the equation (please insert the values of b1, b2…in the equation below).

Yˆ = a + b1X1 + b2X2 + … + bnXn

4. Please comment on the following below by writing an explanatory paragraph

(maximum of one page; double-spaced) from the results of your regression model:

a. Omnibus F-test (indicates overall status of model)

b. R-Square (coefficient of determination)

c. r (coefficient of correlation)

d. Adjusted R-Square (is R-Square adjusted according to number of predictors and sample size)

e. Standard Error of the Estimate (indicates how much error is in the prediction of the dependent variable)

f. Significant Predictors

g. Non-significant Predictors

h. Standard Error of the Estimate (The standard error of the estimate is a measure of the accuracy of predictions made with a regression line.)

i. Multi-collinearity (Collinearity (or multi-collinearity) is the undesirable situation where the correlations among the independent variables are strong

5. Create a Conceptual Model (Figure 1) and a Zero-Order Correlation Matrix (Table 1), and, please run a bivariate correlation analysis and create your correlation matrix in word or excel. Make sure your tables have the same font size and style as mentioned in the guidelines. *Do not copy paste the SPSS output as a table.*

6. The Computer Lab Assignment must follow the following sequence:

Page 1: Cover page

Page 2: Explanatory Paragraph One

Page 3: Explanatory Paragraph Two (correlation table)

Page 4: Cause and Effect Model (Figure 1) – Conceptual Model; Page 5: Zero Order Correlation Matrix (Table 1)

*Use landscape display*

Page 6: Appendix A (must contain the original SPSS outputs)

**Excel and SPSS Computer Lab Assignment #7**

1. Using SPSS and “Regression” (** Method: Stepwise **) data set located in e-learning conduct a multiple linear regression analysis.

2. *Dependent Variable*: General Self-Efficacy

*Independent Variables*: Academic Motivation, Social Activity, Intervention, Predictors of Success

*(Please stick to the same order when entering independent variables into SPSS)*

3. Write the prediction equation at the start of the explanatory paragraph, please center the equation.

Yˆ = a + b1X1 + b2X2 + … + bnXn

4. Please comment on the following below by writing an explanatory paragraph

(maximum of one page; double-spaced) from the results of your regression model:

a. Omnibus F-test (indicates overall status of model)

b. R-Square (coefficient of determination)

c. r (coefficient of correlation)

d. Adjusted R-Square (is R-Square adjusted according to number of predictors and sample size)

e. Standard Error of the Estimate (indicates how much error is in the prediction of the dependent variable)

f. Significant Predictors

g. Non-significant Predictors

h. Standard Error of the Estimate (The standard error of the estimate is a measure of the accuracy of predictions made with a regression line.)

i. Multi-collinearity (Collinearity (or multi-collinearity) is the undesirable situation where the correlations among the independent variables are strong

5. Create a Regression output (Table 1) for this regression assignment using direct method. *Do not copy paste the SPSS output as a table.*

6. The Computer Lab Assignment must follow the following sequence:

Page 1: Cover page

Page 2: Explanatory Paragraph

Page 3: Regression Output (Table 1) (Use Direct method for this table, sample table will be provided)

Page 4: Appendix A (must contain the original SPSS outputs from both enter methods as well as stepwise)

**Excel and SPSS Computer Lab Assignment #8**

1. Using SPSS and “Regression” (** Method: Hierarchical **) data set located in e-learning conduct a multiple linear regression analysis.

2. *Dependent Variable*: Academic Motivation

*Independent Variables*: General Self-Efficacy (Block 1 variable), Social Activity, Predictors of Success, Intervention, Overall Grade

Point Average (OGPA)

*(Please stick to the same order when entering independent variables into SPSS)*

3. Write the prediction equation at the start of the explanatory paragraph, please center the equation.

Yˆ = a + b1X1 + b2X2 + … + bnXn

4. Please comment on the following below by writing an explanatory paragraph

(maximum of one page; double-spaced) from the results of your regression model:

a. Omnibus F-test (indicates overall status of model)

b. R-Square (coefficient of determination)

c. r (coefficient of correlation)

d. Adjusted R-Square (is R-Square adjusted according to number of predictors and sample size)

e. Standard Error of the Estimate (indicates how much error is in the prediction of the dependent variable)

f. Significant Predictors

g. Non-significant Predictors

h. Standard Error of the Estimate (The standard error of the estimate is a measure of the accuracy of predictions made with a regression line.)

i. Multi-collinearity (Collinearity (or multi-collinearity) is the undesirable situation where the correlations among the independent variables are strong

6. Create a Conceptual Model (Figure 1), a Zero-Order Correlation Matrix (Table 1), a table for your Descriptive Statistics (Table 2), and a table for your regression output (Table 3). Example tables will be provided.

7. The Computer Lab Assignment must follow the following sequence: Page 1: Cover Page

Page 2: Explanatory Paragraph One (Regression)

Page 3: Explanatory Paragraph Two (correlation table) Page 4: Figure 1 (Conceptual Model)

Page 5: Table 1 (Zero-Order Correlation Matrix) Page 6: Table 2 (Descriptive Statistics)

Page 7: Table 3 (Regression Output)

Page 8: Appendix (must contain the original SPSS output)

**Excel and SPSS Computer Lab Assignment #9**

1. Using SPSS, run a one-way ANOVA using the data set “Regression” located in

“Suman Niranjan Drop Box”.

2. **Dependent Variables**: General Self-Efficacy, Predictors

of Success, Overall Grade Point Average (OGPA), Academic

Motivation

**Factor Variable**: Gender

*(Please stick to the same order when entering independent variables into SPSS)*

3. Conduct a Contrast analysis on Gender, the factor variable.

4. Please comment on the following below by writing an explanatory paragraph (maximum of one page; double-spaced) of the results from your ANOVA and Contrast analysis testing by commenting on the following parameters:

Omnibus F-test (indicates overall status of model)

Observe T-values and Sig. levels of the contrast tests

Significant variables

Non-significant variables

Comment on Homogeneity of Variance Tests (HVT)

(All HVTs must be non-significant; please mention HVT results in your

Explanatory Paragraph)

5. The Computer Lab Assignment must follow this format to be graded: Page 1: Cover Page

Page 2: Explanatory Paragraph

Page 3: ANOVA output table (Table 1)

Page 4: Appendix (must contain the original SPSS output)

**Excel and SPSS Computer Lab Assignment #10**

1. Using the “Regression” data set and SPSS, run the following Independent Samples T- Test analysis:

** Test Variables **: General Self-Efficacy, Social Activity, Intervention, Predictors of Success, Overall Grade Point Average (OGPA), Academic Motivation

** Grouping Variable **: Gender

*(Please stick to the same order when entering independent variables into SPSS)*

2. Please comment on the following below by writing an explanatory paragraph (maximum of one page; double-spaced) by addressing the significance and/or non- significance of your findings.

3. Comment specifically on the following outcomes:

a) Two-tailed significance of test variables