Summary of Training Courses
Banner for Advisors
Pre-Req: Approval of Loreto D'Monte
Overview of Banner with focus on information needed for the advising process such as gpa, class standing, level, major, degree, etc.
Banner Web for Faculty
Pre-requisite: Active faculty status
Overview of the BannerWeb application; logging in to the system; navigating the menus; accessing student transcripts; accessing a class roster; entering final grades; locating a student's address, phone number(s) and e-mail information; changing personal settings.
Banner Navigation
Pre-Requisite: Completion of FERPA Training with the Registrar and Request by immediate Supervisor for Banner Navigation training.
- Banner Login procedures
- Creation of password
- Authorization for access
- Navigating Banner Forms
- Terminology and Keystrokes
- General overview of both Student and Financial Aid systems
- Commonly used forms in the the Student System
MS Word - Part I (2 hours)
- Navigate the tool bar
- Create/open a document
- Preview and print a file
- Format text (font styles, sizes and colors)
- Change spacing and margins
- Use cut, copy, paste and undo functions
- Use the format painter
MS Word - Part II (2 hours)
Pre-Requisite: MS Word - Part I
- Setting tabs
- Bullets
- Headers/footers
- Page numbering
- Using columns and tables
- Using the Auto Correct feature
- Envelopes and mailing labels
- Using basic drawing tools and clipart
Mail Merge with MS Office
Pre-Requisite: Working knowledge of MS Word, and MS Excel or MS Access
- Create a source document
- Create a main document
- Sort records
- Query records
- Use Word fields
- Use Excel or Access as the source file
MS Powerpoint
- Open, save and create a presentation
- Use templates
- Navigate the menu bar
- Explore views
- Adding and deleting slides
- Moving slides
- Formatting slides (text, sizing objects)
- Applying transitions and animation effects
- Printing options
- Slide shows
MS Excel - Part I
- Workbook basics
- Navigate the tool bar
- Inserting, renaming, moving, copying, deleting and hiding worksheets
- Working with rows and columns
- Working with cells - Part I
Formatting, aligning text, font attributes,
cell borders, colors, AutoComplete, AutoFill,
moving and copying data.
- Printing
MS Excel - Part II
Pre-Requisite: MS Excel Part I
- Working with cells - Part II
Formulas, naming a range of cells, using AutoCalculate,
relative and absolute references
- Creating charts
- Navigational functions
- Advanced printing options
- Getting Help
