 |
 |
History:
FDI Home : FDI
2006 Spring : Microsoft Excel: Essential Skills for Educators |
|
Microsoft Excel: Essential Skills for Educators |
|||
| .................................................................................................................................................................................................................................................... | |||
 |
|||
| Liesl Combs | |||
 |
|||
| Are you ready to begin using technology to help you manage and calculate student grades? This short course will provide participants with a hands-on survey of the most commonly used features of Microsoft Excel. While the skills taught during this session can be used for a number of different purposes, the instructional approach will be the creation and management of a gradebook. Specific skills taught will include entering and storing data, calculations and formulas, charts and graphs, and data presentation. Participants are encouraged to bring their own class roster; this will enable them to create a gradebook for one of their own courses during this short course.
Workshop Assumptions: • Participants will have a basic knowledge of Microsoft programs and menus. • Participants will have prior skill in navigating through a computer screen, using a mouse and a keyboard. • Participants will have basic knowledge of opening and saving new files. Workshop Objectives: • Describe and model basic functions of Excel software • Discuss uses and applications of Excel files • Model and practice tasks such as: o Entering data o Inserting cells, columns and rows o Deleting items o Headings o Formatting cells, columns and rows o Sort data o Borders, color and font formats o Average and sum functions o Formulas o Printing • Model and practice creating a class roster • Model and practice creating a grade book based on average, total points and weighted type • Print desired area and save files Instructional Outcomes: • Participants will be able to recognize appropriate uses and applications of spreadsheet software. • Participants will be able to perform basic functions of Excel program to include: o Entering data o Formatting cells o Using formulas o Set printing options • Participants will be able to import a class roster from HokieSpa. • Participants will be able to create a grade type-specific grade book. |
|||
| .................................................................................................................................................................................................................................................... | |||
|
|||
| Excel Activity Guide for Mac Users (PDF) Excel Activity Guide for Windows Users(PDF) Excel Presentation Handout(PDF) Excel Presentation (PDF) |
|||
| .................................................................................................................................................................................................................................................... | |||
 |
|||
Basic Excel tutorial: http://www.usd.edu/trio/tut/excel/0.html Excel Tutorial 2002/2003: http://www.baycongroup.com/el0.htm Microsoft Excel Modules: http://www.internet4classrooms.com/on-line_excel.htm Free Excel Templates: http://www.dotxls.com/free-templates/19/free-excel-templates---education-and-teaching |
|
 |
|
| FDI Evaluations | |
| .................................................................................................................................................................................................................................................... | |
| Contact
us at fdi@vt.edu ©
2006 Faculty Development Institute
|