Summer Course Listing
All our documentation is available at our How To section.
You may also download a copy of our class brochure.
| Computer Basics | |
|---|---|
Computer LiteracyThis course is for the new or novice computer user. Learn computer basics including definitions of computer terms, different types of software, how to use a mouse, and how to navigate a Windows environment, including opening programs, and manipulating windows.
Offered: |
Windows XP LiteracyLearn to manipulate Windows, including sorting files, creating and renaming files and folders, using the taskbar and the recycle bin. Learn how to open, close, and save documents, how to copy and paste material, and how to move and copy files and folders.
Offered: |
| What's New in Office 2007 |
|---|
Microsoft has made extensive changes to Word, Excel, and PowerPoint in Office 2007. Although these changes may be daunting at first, Microsoft has attempted to make the Office programs easier to use. This course will give you an overview of how to navigate the new 2007 interface.
Offered: Friday, June 27 at 1:30 PM - 3:30 PM |
| Microsoft Word | |
|---|---|
Word I 2003 / 2007Learn the parts and layout of the Word program. Learn the basics of document creation and editing. Learn how to format a document, including margins, line spacing, line justification, and font formatting. Learn to work with headers and footers and how to print.
Offered: 2007 - Tuesday, July 8 at 9:00 AM - 11:00 AM |
Word II 2003 / 2007Learn how to correct spelling and typing errors in a document, to modify autocorrect features, and use find and replace. Learn how to format your document with headings, styles, indents, and tabs. Insert and manipulate images, tables, and newspaper style columns. Prerequisite: Word I 2007 - Monday, July 28 at 1:30 PM - 3:30 PM |
Mail Merge 2003 / 2007Learn how to create mass mailings and address labels. Using Word’s mail merge features, you will use an Excel database to insert addresses and information into Word letters and labels. Prerequisite: Word II 2007 -Friday, August 1 at 9:00 AM - 10:00 AM |
| Microsoft Excel | |
|---|---|
Excel I 2003 / 2007Understand spreadsheets by identifying components of the work area. Enter and edit data, use formulas, sum a cell range, insert and delete rows and columns. Also learn text and number formatting and worksheet printing.
Offered: 2007 -Tuesday, July 8 at 1:30 PM to 3:30 PM |
Excel II 2003 / 2007Learn advanced editing techniques, insert functions, format cells with borders and shading, generate charts, sort records and use basic database functions to extract specific pieces of information. Prerequisite: Excel I 2007 - Thursday, July 31 at 9:00 AM - 11:00 AM |
Excel PivotTables 2003 / 2007Create and manipulate data in PivotTables. Sort data and generate summaries using PivotTables. Create, format, and make queries with both PivotTables and Pivot Reports. Prerequisite: Excel II 2007 -Tuesday, August 5 at 1:30 AM - 3:30 AM |
| Microsoft PowerPoint | |
|---|---|
PowerPoint I 2003 / 2007Create a presentation, use the five slide views, format presentations. Understand the use of slide and outline views to enter text, change text attributes for one slide and/or an entire presentation. Also learn to reorder slides, use drawing tools and produce an on-screen slide show.Offered: 2003 -Thursday, May 29 at 9:00 AM - 11:00 AM 2007 -Thursday, July 3 at 1:30 PM - 3:30 PM |
PowerPoint II 2003 / 2007Focus on editing existing slides, re-ordering text, and adding slides to an existing presentation. Learn to import images, create and edit graphs, import charts from Excel, and outlines from Word. Develop speaker's notes, apply transitions to slide shows, add clip art and hyperlinks to presentations. Prerequisite: PowerPoint I 2007 - Friday, July 11 at 9:00 AM - 11:00 AM |
| Microsoft Office Integration |
|---|
Microsoft Office Integration 2003 / 2007Learn how to use Office programs together. Learn how to insert Excel charts and graphs into Word and PowerPoint. Learn how to copy information from one Office program into another, so that when the source data is updated, those changes are reflected in the other programs. Prerequisite: Word II, Excel II & PowerPoint II
Offered: 2007 -Tuesday, August 5 at 1:30 AM - 3:30 AM |
| Microsoft Access | |
|---|---|
Access I 2003 / 2007Learn to create database files and discover the importance of the primary key. Create and format tables including creating input masks and making required fields. Learn proper data entry and deletion. Also learn how to create queries and forms. Prerequisites: Excel II |
Access II 2003 / 2007Learn how to import and export data. Work with table properties, including validation rules and text, captions, and indexed fields. Work with conditional operators. Create a variety of queries, including parameter queries, make table queries, update queries, and calculation queries. Learn how to create and format reports. Prerequisites: Access I |
Access III 2003 / 2007Learn how to create relationships between tables and work with table joins. Create multi-table queries and aliases. Work with dates and calculate ages. Learn how to next queries and filter datasheets. Create combo boxes. Work with forms including subforms and command buttons. Prerequisites: Access II |
Access IV 2003 / 2007Learn about database start-up options and various Access options. Learn how to find duplicate records, create aggregate functions, and work with date and time functions. You will create append queries and create string functions, and work with reports, including creating mailing labels. Prerequisites: Access III |
Access V 2003 / 2007Work with null values and immediate if functions. Explore the differnent types of joins: equi-joins, outer-joins, self joins, and Theta joins. Create cross tab queries and queries to create unique value lists. Work with object dependencies and learn how to compact and repair a database. Prerequisites: Access IV
Offered: |
Introduction to Relational Database DesignA non-mathematical introduction to the rules governing the design of relational databases. Covers First, Second and Third Normal Forms. A finished application and sample database will be presented. Prerequisites: Access V
Offered: |
| Internet Literacy |
|---|
Learn how to “surf the web” using a web browser. Learn what URLs and domain names are, how to go to a specific page, or how to find information. Learn how to bookmark a favorite page, and how change program settings. Also learn about internet security and safe browsing. Wednesday, July 2 at 9:00 AM - 11:00 AM |
| HTML | |
|---|---|
HTML ILearn to create web pages using HTML. Learn the basic elements of HTML, and how to format text, create lists, insert images, and create hyperlinks. Prerequisites: Internet Literacy |
HTML IILearn how to create and use tables in HTML for greater flexibility in layout and design, as well as data presentation. Prerequisites: HTML I |
HTML FormsCreate HTML forms. Prerequisites: HTML I & II |
CSSLearn how to use Cascading Style Sheets for web page layout and design. Create a new style sheets, and apply those styles to your HTML page. Create separate style sheets for viewed and printed documents. Prerequisites: HTML I & II |
Web Design Resources
| Adobe Dreamweaver CS3 | ||
|---|---|---|
Prerequisites MUST be met for the Dreamweaver II and III classes |
||
Dreamweaver ILearn how to manage existing website using the Dreamweaver software. Learn how to modify web pages, insert images, create hyperlinks, download and upload files. Prerequisite: Internet Literacy.
Offered: |
Dreamweaver IIWork in the Code View in Dreamweaver. Learn about the basics of site design and creation. Also learn some of the features of Dreamweaver including automatically updating dates, and Dreamweaver libraries. Prerequisites: Dreamweaver I & HTML II |
Dreamweaver IIILearn to use Cascading Style Sheets within Dreamweaver. Create and modify styles for design and layout. Apply styles to one or more pages. Create separate style sheets for viewed and printed documents. Prerequisites: Dreamweaver II & CSS
Offered: |
Web Design Resources
| Adobe Photoshop CS3 | |
|---|---|
Photoshop IIntroduction to the Photoshop environment and the basics of creating images for web sites, presentations, and documents, including changing the color mode, cropping images, changing image size and resolution, and an introduction to working with layers and text. Wednesday, July 2 at 1:30 PM - 3:30 PM |
Photoshop IIThis course builds on the skills learned in the Photoshop I class, and includes image correction, selecting objects in images, and further skills with layers. Tuesday, July 29 at 1:30 PM - 3:30 PM |
| Camtasia |
|---|
Camtasia gives you the power to easily record your screen, voice, and webcam video to create compelling video tutorials, presentations, and rich demonstrations for web and CD-ROM delivery. Supports Flash, CD, and streaming video formats. Camtasia Studio videos allow you to reach any viewer.
Offered: |
| TurningPoint Audience Response System |
|---|
The TurningPoint audience response system integrates 100% into Microsoft PowerPoint and allows audiences and students to participate in presentations or lectures by submitting responses to interactive questions using a ResponseCard keypad or laptop computer. Using a TurningPoint audience response system, your PowerPoint presentations become powerful data collection and assessment tools that collect real-time audience responses and dramatically improves productivity and results. Author, deliver, assess and report without ever leaving PowerPoint. Engage participants, assess learning, gather data, or enhance presentations with TurningPoint.
Download the TurningPoint Software |
| GroupWise | |
|---|---|
|
Available by request |
CalendarLearn to use the calendar and the specific views, create and reschedule meetings, and posted messages, schedule multiple users, schedule recurring appointments, print calendars, grant proxy rights and run notify.Available by request |
| Reference Software and Pub Med | |
|---|---|
EndNoteUse EndNote to search remote libraries for journal articles, organize your references, and then build your bibliography as you write your paper.
Offered: |
Reference ManagerUse this reference building software to develop reference lists or bibliographies for journal articles, grant applications, curriculum vitae, a thesis or dissertation.Offered: Thursday, June 12 at 9:00 AM - 11:00 AM |
PubMedDiscover how PubMed can be utilized as an effective tool for the research process. And how it relates to other Databases from the National Library of Medicine and the National Institute of Health.Offered: Thursday, July 10 at 9:00 AM - 11:00 AM |
Science Citation Index ExpandedLearn to use Science Citation Index Expanded to access current and retrospective bibliographic information, author abstracts, and cited references found in 3,700 of the world's leading scholarly science and technical journals covering more than 100 disciplines. Learn to create a Citation Alert to receive e-mail alerts on future citations to a reference. Link from the search screen to the library's journal holdings or to the full-text of the article. Export search results to a bibliographic management software such as Reference Manager.
Offered: |
Who Cited WhomDocumenting your citations and explaining their significance is critical when applying for promotion and/or grant funding. Learn how to utilize new and existing WVU Library databases to research, including Web of Science, SciFinder Scholar, and Google Scholar (WVU Version). Experience graphical methods of documentation, effectively presenting information. Explore Journal Impact Factors and discuss Personal Impact Factors.
Offered: |
RefWorksRefWorks is a tool for creating and storing a personal database of research, managing RSS alerts, sharing research with colleagues, and creating bibliographies in multiple formats. Learn how to create a personal database online and store an unlimited number of records accessible from any computer linked to the Internet. No downloading software or installation required. Learn how to import references automatically from multiple databases, organize and manage references, and share references to easily collaborate with members of your own institution or with other researchers, faculty members, and students.
Offered: Tuesday, July 29 at 1:30 PM - 3:30 PM |
| Electronic Thesis 2003 / 2007 |
|---|
|
Look at using Word to correctly format a thesis or dissertation for electronic submission. Learn how to create a table of contents, footnotes, and adjust pagination. Offered: Consultations available by request |
| Digital Devices | |
|---|---|
PDA Basics - Pocket PC OSGain a thorough understanding of the capabilities of your Pocket PC PDA. Explore more advanced features such as wireless capabilities and syncing with GroupWise Email.
Offered: |
PDA Basics - Palm OSGain a thorough understanding of the capabilities of your Palm OS PDA and be more comfortable using it for daily tasks.
Offered: |
Registration Information
Students, faculty, and staff of the WVU Health Sciences Center, West Virginia University Hospitals, University Health Associates, and the University at large may register for courses. Registration is determined on a first-come, first-served basis, and class size is limited to ten participants.
To register for a course, call 293-6128 between the hours of 9:00am and 12:00pm, Mon through Fri.
We will accommodate groups of 5 or more to arrange special class offerings. If you would like to have a class arranged for your group please contact the Learning Center at 293-6128. Additionally one-on-one tutoring is available upon request.
Cancellation Request
As a courtesy to our waitlisted registrants, please notify us of any cancellations 24 hours in advance.
Since space in each workshop is limited, many of our classes have a waiting list. If you sign up for, but miss a course without notifying the Learning Center, you may be denying a waitlisted person the opportunity to attend the course. We ask that registrants only sign up for workshops that they plan to attend. When we encounter persons who frequently register and do not attend class, that person will be placed on the waitlist until everyone else has been accommodated.
If you sign-up and miss a class that is a pre-requisite for another, you will automatically be dropped from the following course.
All courses are taught in the Learning Center.
Reservations are confirmed by telephone prior to the workshop. If you have any questions, please take this opportunity to ask them.