1 / 17

How To Complete the “Outcomes Assessment” Template in Microsoft Office Excel

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.

homer
Download Presentation

How To Complete the “Outcomes Assessment” Template in Microsoft Office Excel

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. How To Complete the “Outcomes Assessment” Template in Microsoft Office Excel

  2. 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.

  3. 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 presentation 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.

  4. 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.

  5. 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.

  6. 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

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

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

  9. The Difference • The main differentiation between Excel 2007 and Excel 97-2003 is their appearance, as far as this instruction is concerned. • The same procedures are used for each when entering data and the images in the following slides 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.

  10. Entering Data in Excel 2007 Please 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). If this video does not work properly, please click here. (TechTutor.tv, 2009)

  11. Completing the Outcomes Assessment Template This is an example of what your Excel sheet may look like if you are using Excel 2007: This box indicates that the cell is selected

  12. 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 tutorial on slide #5). Continue this until you have entered all of your students’ scores.

  13. 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.

  14. Saving Your Template • Please click on one of the following choices: • I am using Excel 97-2003 • I am using Excel 2007

  15. 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.

  16. 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.

  17. 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. • Please click here once you have completed this instructional presentation.

More Related