Technology Training

Computer Classes and Certificate Programs in Technology Training

One-day and half-day computer classes, as well as multi-course certificate programs in computer technology, can be delivered at your corporate site to develop the skills and competencies of your employees in various software applications. One day and half-day computer topics include the following:

Word: Level I
Word: Level II
Excel: Level I
Excel: Level II
Excel: Level III

PowerPoint: Level I

PowerPoint: Level II

Relational Database Design
Access: Level I
Access: Level II
Access: Level III
Access: Level IV

Project Management: Level I (other levels available as well)

 
Temple trainers provide ample time for hands-on learning, individual attention, and a well-paced learning environment. They are skilled in technical training and working with participants at all levels of technical competency. Temple staff will work with you to assess your employees’ technical needs and customize a program for them. Also, Temple will provide a Certificate of Completion for each training participant and evaluations of each class taught. All arrangements for the instructor and instructional materials are efficiently managed by Temple staff.

Non-credit computer classes and certificate programs are available to the public throughout the year at Temple University Fort Washington. To view the latest schedule of public computer course offerings, click the links below:

Computer Applications
Database Design and Management
Web Site Design

Multi-day certificate programs in computer technology include the following:

Database Design and Management
Web Site Design
Certificate in Microsoft Office
Certificate in Microsoft Office: Advanced

Certificate programs focused on increasing Word, Excel, PowerPoint, Access, and Microsoft Project skills can be delivered as well. Typically, a participant takes three levels of each course area in order to receive a Temple Certificate of Completion.

Computer Course Descriptions

Word: Level I
Prerequisite: Windows XP: Level I, or two months practical experience with Windows.
Learn how to master powerful word processing capabilities, such as creating, modifying, saving, and printing a document. Feel confident formatting characters and paragraphs, and moving, copying, changing, and deleting text. Learn how to proof a document for potential errors by using Word’s proofing tools.

Word: Level II
Prerequisite: Word: Level I or four months of practical experience with Word.
Learn new techniques in Word to make you even more productive. Gain skill in using the powerful mail merge features to create personalized letters, envelopes, and labels. Learn how to insert and format graphic images, including Clip Art, AutoShapes, WordArt and organizational charts. Create and enhance Web pages using templates and themes.

Excel: Level I
Prerequisite: Windows XP: Level I, or two months practical experience with Windows.
This course is designed to give students the skills they need to create spreadsheets in order to track financial, sales, inventory, and personal data. Learn how to create basic formulas, and copy, move, and paste data while making the sheet look attractive. Also learn how to create and modify charts, and save and print a worksheet.

Excel: Level II
Prerequisite: Excel: Level I, or four months practical experience with Excel.

Gain the skills necessary to create templates and graphics. Learn how to calculate advanced formulas and techniques to sort and filter data. Analyze data by creating pivot tables and pivot charts. Also, enhance your worksheet by using charts and multiple graphics.

Excel: Level III
Prerequisite: Excel: Level I and II, or six months practical experience with Excel.
Take your spreadsheets to the next level. Learn how to customize your work area with toolbars and create and edit macros. Analyze worksheet data by creating pivot tables and pivot charts. Learn how to collaborate with other Excel users by protecting your worksheet, sharing your workbook, and tracking changes.

Access: Level I
Prerequisite: Windows XP: Level I or two months practical experience with Windows.
Learn the basics of Microsoft Access, a database management system compatible with other Windows products. Learn how to create a data table and practice entering, changing, and deleting data. Try your hand at developing queries to view selected data and creating reports.

Access: Level II
Prerequisite: Access: Level I, or two months practical experience with Access.
Learn the key principles of table design and table relationships. Pick up table design techniques, including data validation and indexing. Learn how to design select queries and discover how to enhance form designs by adding calculated fields, combo boxes, and unbound controls. Learn how to customize reports created by report wizards.

Access: Level III
Prerequisite: Access: Level I and Level II, or six months practical experience with Access.
Learn how to create complex queries and joins, build forms on joined tables, create macros and command buttons, use macros to provide user interaction, and automate tasks.

Access: Level IV
Prerequisite: Knowledge of Access: Level III

Effective database management calls for mastering the advanced administrative and collaborative features of Access. Learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Relational Database Design
Prerequisite: Familiarity with Windows XP.
Find out how to correctly design tables for use in a relational database application. You’ll learn to: identify data as fields, group fields into tables, select key fields, and identify table relationships; identify data problems and apply data normalization techniques to solve them; use referential integrity and other techniques to support the accuracy of data in the database; and use criteria and operators and perform appropriate table joins in queries. This is primarily a lecture-based course.

Microsoft Project : Level I
Prerequisite: Students should be familiar with terms such as Gantt Chart, task, critical path, and resource. Students should also be familiar with terms such as computer memory, data files, and program files. No knowledge of MS Project 2003 is assumed.
Learn MS Project 2003 to assist you in managing a single project or several related projects simultaneously. In this course, students will: identify steps involved in project planning; become familiar with project management software; plan a project using MS Project 2003; work with subtasks in an outline form, link tasks effectively, and work with time constraints; and resolve time and resource conflicts.

Computer Technology Certificate Programs — Course Descriptions

Certificate in Database Design and Management
Learn how to properly design databases and use MS Access to manipulate data. This expertise will allow you to effectively and efficiently work with your data while also eliminating confusions that can lead to lost time and lost data. The five required courses are: Relational Database Design; Access: Level I; Access: Level II; and Access: Level III; Access: Level IV

Relational Database Design
Prerequisite: Familiarity with Windows XP.
Find out how to correctly design tables for use in a relational database application. You’ll learn to: identify data as fields, group fields into tables, select key fields, and identify table relationships; identify data problems and apply data normalization techniques to solve them; use referential integrity and other techniques to support the accuracy of data in the database; and use criteria and operators and perform appropriate table joins in queries. This is primarily a lecture-based course.

Access: Level I
Prerequisite: Windows XP: Level I or two months practical experience with Windows.
Learn the basics of Microsoft Access, a database management system compatible with other Windows products. Learn how to create a data table and practice entering, changing, and deleting data. Try your hand at developing queries to view selected data and creating reports.

Access: Level II
Prerequisite: Access: Level I, or two months practical experience with Access.
Learn the key principles of table design and table relationships. Pick up table design techniques, including data validation and indexing. Learn how to design select queries and discover how to enhance form designs by adding calculated fields, combo boxes, and unbound controls. Learn how to customize reports created by report wizards.

Access: Level III
Prerequisite: Access: Level I and Level II, or six months practical experience with Access.
Learn how to create complex queries and joins, build forms on joined tables, create macros and command buttons, use macros to provide user interaction, and automate tasks.

Access: Level IV
Prerequisite: Knowledge of Access: Level III

Effective database management calls for mastering the advanced administrative and collaborative features of Access. Learn how to exchange data with other applications, automate business processes by using VBA code, and secure and share databases.

Certificate in Web Site Design
In this certificate program, participants will learn to build a Web site from the ground up with HTML, make sites visually engaging with Dreamweaver, and manipulate photo elements using Photoshop. The certificate program includes seven courses: Creating a Usable Web Site; Introduction to HTML for Web Site Design; Adobe Photoshop: Level I; Adobe Photoshop: Web Production; Adobe Dreamweaver: Level I; Adobe Dreamweaver: Level II; and Build Your Web Site: Putting It All Together.

Creating a Usable Web Site

A good web site is more than just images, text and links. In order for the average user to have a good experience, the designer must know how to create a usable web site — one that works well for its intended purpose without the user getting hopelessly frustrated. This course will show you how the user sees, thinks and reads, and how best to incorporate these concepts into your web site.

Introduction to HTML for Web Site Design
The Hypertext Markup Language (HTML) is the underlying language of every Web page. This simple text-based language can be written on any computer, regardless of platform, using nothing more than a plain text editor like Windows Notepad. Students will learn the syntax of HTML by identifying the language’s building blocks (called tags), their attributes, and the values these attributes are assigned. By examining how tags are used to define individual portions of Web page content (called elements), students will learn how to properly construct HTML documents, format text, embed images, and create hyperlinks.

Adobe Photoshop: Level I
Students are introduced to the application’s basic tools for making selections, cropping images, painting, drawing, erasing, creating shapes, adding type to an image, applying color, and making basic adjustments to image quality. Also learn about Photoshop’s many palettes, how the palettes are used, how to resize and reposition them within the workspace, and save a specific workspace arrangement for future use.

Adobe Photoshop: Web Production
This course builds upon the skills learned in Level I and applies them to Photoshop’s companion application, ImageReady. Students will create rollover images and animations, mastering ImageReady’s tools for creating Web graphics that respond to site visitors’ mouse clicks and movements, and movies that run automatically within a Web page. Students will build their confidence and technical skill, resulting in the creation of more creative and complex interactive images and animations for the Web.

Adobe Dreamweaver: Level I
Prerequisite: Students should have taken Introduction to HTML, or have equivalent knowledge.
Learn the basics of Macromedia Dreamweaver, the standard HTML (Web) developing program. With Dreamweaver anyone can create dynamic HTML pages. This introductory class will familiarize users with the Dreamweaver interface and the basics of the Internet. Upon completion of this course, you will be able to create Web pages for personal or professional purposes.

Adobe Dreamweaver: Level II
With Dreamweaver Level II, learn to create advanced image-based layouts with tables and layers. Customize your site with style sheets, templates and library elements. Use the site management features to analyze and publish your site.

Build Your Web Site: Putting It All Together
Take the skills you have learned in HTML, Photoshop and Dreamweaver, and spend the day creating a personal Web site. Usability and graphic design practices will be emphasized, teaching students how to develop the best possible Web site. The instructor will guide you as you develop your site. When your site is complete, the instructor will critique it and make recommendations. You will also receive information on how to test your page, find a host for your site, get your own domain name, and transfer files to a server.

Certificate in Microsoft Office 2007

Reach a level of competency using computers and related software programs to enhance your resume and build your skills. The Microsoft Office 2007 Certificate Program will provide instruction on the most commonly used software programs used in business today. Also, learn how to integrate applications like Word with PowerPoint and Word with Excel. The following five courses are required to earn the certificate:

• Word 2007: Level I

• Excel 2007: Level I

• PowerPoint 2007: Level I

• Access 2007: Level I

• Integrating Microsoft® Office Applications

Word: Level I
Prerequisite: Windows XP: Level I, or two months practical experience with Windows.
Learn how to master powerful word processing capabilities, such as creating, modifying, saving, and printing a document. Feel confident formatting characters and paragraphs, and moving, copying, changing, and deleting text. Learn how to proof a document for potential errors by using Word’s proofing tools.

Excel 2003: Level I
Prerequisite: Windows XP: Level I, or two months practical experience with Windows.
This course is designed to give students the skills they need to create spreadsheets in order to track financial, sales, inventory, and personal data. Learn how to create basic formulas, and copy, move, and paste data while making the sheet look attractive. Also learn how to create and modify charts, and save and print a worksheet.

Access: Level I
Prerequisite: Windows XP: Level I or two months practical experience with Windows.
Learn the basics of Microsoft Access, a database management system compatible with other Windows products. Learn how to create a data table and practice entering, changing, and deleting data. Try your hand at developing queries to view selected data and creating reports.

PowerPoint : Level I
Prerequisite: Windows XP: Level I, or practical experience with computers.
Learn how to create interesting overheads, hand-out materials, and on-screen presentations. Learn how to develop and modify your presentation and how to run an automated presentation. Enhance your presentations with bullets, tables, and text. You’ll also learn about and practice adding Clip Art, changing fonts, and using wizards, design templates, and the slide sorter.

Integrating Microsoft® Office Applications

Prerequisite: familiarity with Word documents, spreadsheets and presentations

Discover how to use Word 2007 with other programs. You will learn how to embed Excel data in PowerPoint, link Access data to an Excel file, and use a Word outline to create a presentation. You will also learn how to use proofing tools and publish Office documents to the web.

Certificate in Microsoft Office 2007: Advanced

Take your skills to the next level. Learn more advanced features of the most commonly used software programs used in business today. The following four courses are required to earn the certificate:

• Word 2007: Level II (spring only)

• Excel 2007: Level II

• PowerPoint 2007: Level II (spring only)

• Access 2007: Level II

Word: Level II
Prerequisite: Word: Level I or four months of practical experience with Word.
Learn new techniques in Word to make you even more productive. Gain skill in using the powerful mail merge features to create personalized letters, envelopes, and labels. Learn how to insert and format graphic images, including Clip Art, AutoShapes, WordArt and organizational charts. Create and enhance Web pages using templates and themes.

Excel: Level II
Prerequisite: Excel: Level I, or four months practical experience with Excel.
Learn to work with templates and create graphics. Learn techniques to sort and filter data. Enhance your worksheet by using charts, creating trendlines and using multiple graphics. Also learn how to import data from other Office applications and publish worksheets to the Web.

Access: Level II
Prerequisite: Access: Level I, or two months practical experience with Access.
Learn the key principles of table design and table relationships. Pick up table design techniques, including data validation and indexing. Learn how to design select queries and discover how to enhance form designs by adding calculated fields, combo boxes, and unbound controls. Learn how to customize reports created by report wizards.

PowerPoint: Level II
Prerequisite: PowerPoint: Level I, or equivalent knowledge.
Take your presentations to the next level! Extend your knowledge further and learn to work with design templates, custom animations and enhancements, techniques for delivering presentations, Web presentations, and presentation broadcasting. Make your presentations stand out from the rest!

For more information on Corporate Training Programs offered by Temple University Fort Washington, contact: