How To Complete the “Outcomes Assessment” Template in

Microsoft Office Excel

What is Microsoft Office Excel?

• Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

• A spreadsheet is a grid that organizes data into columns and rows. Spreadsheets make it easy to display information, and people can insert formulas to work with the data.

What is an Outcomes Assessment Template?

• Wilmington University assesses student learning and you will be collecting student scores through assignments in your classroom.

• A template is an electronic file with a predesigned, customized format and structure.

• The template you will be given is a Microsoft Office Excel file and you will use this program to enter your students’ scores.

• This tutorial will teach you how to open your template, enter scores, save your template, attach your template in an email, and send it to the appropriate Wilmington University staff member.

How Will I Receive My Template?

• Your template will be sent to you via email by your program coordinator or the administrative assistant of your college. It will be sent to your Wilmington University email address.

Opening Your Template

• Open the email containing your template as an attachment.

• If your Excel file is attached, double-click on it. You will be asked if you would like to “Save” or “Open” this file. Choose the option to “Open” the file and it will open in Excel.

• If there is a “Compressed (zipped)” folder attached, double-click to open it. Find the file or files with your last name and double-click to open the file in Excel.

• Here is an example of what your file’s name may look like: HUM 361 B2N02 FA09 SMITH.

Which Version of Excel Are You Using?

Please click on one of the following choices:

A. I am using Excel 97-2003

B. I am using Excel 2007

C. I am unsure

If your Excel sheet looks like the image below, please click here.

If your Excel sheet looks like this image below, please click here.

I Am Using Excel 97-2003This is an example of what your Excel sheet may look like if you are using Excel 97-2003:

I Am Using Excel 2007This is an example of what your Excel sheet may look like if you are using Excel 2007:

The Difference

• The main difference between Excel 2007 and Excel 97-2003 is their appearance, as far as this tutorial is concerned.

• The same procedures are used for each when entering data and the images in the following slide images have been taken from Excel 2007. If you are using Excel 97-2003 your screen may look slightly different, however, the procedure for entering data is the same.

• Saving the files in each version is also different and this will be explained in detail at the end of this presentation.

Entering Data in Excel 2007Please click on the video below to view a short tutorial on how to enter

data in Excel 2007 (this also applies if you are using Excel 97-2003). Please make sure that the volume is turned up and working on your computer.

(TechTutor.tv, 2009)

If this video does not work properly, please click here.

Completing the Outcomes Assessment Template

This box indicates that the cell is selected

This is an example of what your Excel sheet may look like (Excel 2007):

Entering Scores

Enter your student’s score next to his/her respective name. Hit the “tab” button on your keyboard to move on to the next cell (as demonstrated in the previous video tutorial). Continue this until you have entered all of your students’ scores.

This is an example of what your completed template may look like. Notice that the totals and averages have been automatically

calculated. Do not change anything in these cells.

Note: if there is a student who did not complete the assignment, please leave his/her scores blank.

Saving Your Template

• Please click on one of the following choices:

A. I am using Excel 97-2003

B. I am using Excel 2007

Saving Your Template in Excel 97-2003

Click on “File” and select “Save As.” Once you choose this option you will be prompted to choose a destination where the file will be saved. Saving to “My Documents” or to your Desktop will make it easier to find the file when you need to attach it to an email.

Saving Your Template in Excel 2007

Click on the “Office Button,” select “Save As,”And select “Excel Workbook,” as shown. Once you choose this option you will be prompted to choose a destination where the file will be saved. Saving to “My Documents” or to your Desktop will make it easier to find the file when you need to attach to an email.

Emailing Your Template

• To send your Outcomes Assessment Excel file in an email, you must first attach it.

• Click here for an easy, step-by-step guide on how to attach a file to an email.

• Once you have attached your template, please send it to nicole.m.karam@wilmu.edu or to your program coordinator.

• Please click here once you have completed this tutorial.