Slide 1

Slide 1 text

GET EXCEL FROM THE DRIVE TO THE COMPUTER

Slide 2

Slide 2 text

Double-click to open in your browser in a Google Sheet (Next Slide) 1. 2. 4.

Slide 3

Slide 3 text

1. Click file 2. Click download to .xlsx 3. Using Chrome, save file (next slide)

Slide 4

Slide 4 text

2. Click download to .xlsx The data goes somewhere: - downloads folder - desktop Save to the desktop!

Slide 5

Slide 5 text

Here it is Warning: If you do not have Excel on your computer then the file will not look like this

Slide 6

Slide 6 text

HOW TO IMPORT EXCEL INTO SPSS 1. COMPUTER LAB OR 2. SPSS IS ON YOUR COMPUTER

Slide 7

Slide 7 text

1. Make sure the Excel file is on your computer

Slide 8

Slide 8 text

1. Open SPSS If you are in a computer lab or have SPSS on your computer then simple do the following

Slide 9

Slide 9 text

2. Click file to open 3. Select Excel 4. Find your data (on Desktop) 4. Open Now you can do your statistics for the class!

Slide 10

Slide 10 text

SAVE YOUR SPSS DOCUMENTS FOR HW OUTPUT AND SYNTAX PSY-312

Slide 11

Slide 11 text

SAVE YOUR DOCUMENTS After you complete all the parts of the Lab HW, save the: 1. Output (figures) 2. Syntax

Slide 12

Slide 12 text

SAVE YOUR SPSS OUTPUT

Slide 13

Slide 13 text

Saving Your Output 1. Click File 2. Click Export

Slide 14

Slide 14 text

1. Make sure it exports to word 2. Choose the Desktop 4. Click Ok 3. name it: “/lab#-name-output.doc”

Slide 15

Slide 15 text

Ready to upload to BB after you have your syntax! (next slides)

Slide 16

Slide 16 text

SAVE YOUR SPSS SYNTAX

Slide 17

Slide 17 text

SAVE THE SYNTAX • Syntax allows you to save what you did and redo it anytime • Otherwise you have to remember what you clicked • You can also tell the story of your data analysis with comments. • Providing syntax and data is necessary for reproducibility

Slide 18

Slide 18 text

Click Save Notice how I elaborated on syntax Please do this!!

Slide 19

Slide 19 text

2. Save to Desktop 1. Use appropriate name “lab2-bedics” here

Slide 20

Slide 20 text

Notice Name is changed at Top! Two on the desktop! Ready to upload to BB!