Business Technology Certificate Program
Level One: Foundation Courses
These courses provide a foundation of core skills in File Management and common Microsoft programs. Each of them is a pre-requisite for some of the courses in the next level of the curriculum.
File Management Core Skills
Participants in this foundation course will master file management with the many tools provided by Microsoft's Windows operating system, as well as explore the use of the University's network resources to store, access, share and back up data.
Word 2010 Core Skills
In this course participants will master core word processing skills and common best practices for document production with Word 2010. We will configure Word to our working preferences; work with templates, styles and defaults to set up various document types, and explore Word's powerful editing and formatting features. We will also explore using toolbar, mouse and keyboard shortcuts to save time and effort.
Excel 2010 Core Skills
In this course participants will master core worksheet skills with Excel 2010. We will configure Excel to our working preferences; work with worksheet set-up shortcuts, data entry timesavers and formatting features to create a variety of worksheets. We will learn the principles of good worksheet layout and discuss common best practices for working with worksheet data. We'll also explore using toolbar, mouse and keyboard shortcuts to save time and effort.
Outlook 2010 Core Skills
Participants will explore many of Outlook's powerful e-mail and calendar tools. We'll master email and calendar management with the many tools provided by Outlook 2010. Participants who have an Outlook Exchange mailbox will work with their own account to set up mail, calendar and archiving options.
Level Two: Program Courses
These courses expand the participant's ability to apply technology skills to common business activities such as document production, web site creation and maintenance, data analysis, electronic communications and schedule management. These courses may be taken in any order, but some require a foundation course as a prerequisite.
Creating Professional Documents
This course presents the most efficient and effective ways to produce and distribute professional-looking documents using Microsoft Office. Participants will first examine the principles of document production that are common to all MS Office products. Then we’ll create a complex document using Word and Excel features such as templates, page layouts, sectioning, and headers and footers. We'll further enhance the document with tables, figures and a table of contents. We'll finish by exploring the best ways to prepare the document for electronic distribution and/or printing, including the use of PDF files and Adobe Professional. Prerequisite: Word 2010 Core Skills
This course presents a variety of Excel tools for organizing, analyzing and presenting data. We will explore using advanced sorting and filtering techniques, data consolidation, 3-D formulas and subtotals as a way to summarize and understand our data. We’ll work with logical and look-up functions to organize and review data, and use Pivot Tables and Scenario Manager to analyze data and facilitate decision-making. Prerequisite: Excel 2010 Core Skills
Working with Collaboration Tools
This course provides a comprehensive experience with common collaboration tools, including SharePoint and MS Office. Participants will explore the collaborative features of each product, discuss choosing the best tool for the job, and create a collaborative SharePoint site for use by a typical work team. Prerequisite: Word 2010 Core Skills
This course addresses the use of Outlook's powerful features for creating, distributing, controlling and storing electronic communications. Participants will use templates, distribution lists and Word mail merge to create and distribute email. Prerequisite: Outlook 2010 Core Skills
This course presents Outlook's powerful features for managing schedules and meetings. Participants will use group schedules, multiple calendars, custom views and shared calendars to create and maintain schedules. We'll also explore using web-based options for displaying and distributing calendar content. Prerequisite: Outlook 2010 Core Skills
Creating Web Sites at Princeton
Participants will explore web site creation and maintenance. We'll consider the University's site standards and the guidelines set forth by the Office of Communications for information architecture, usability and style as we design a web site. We will construct a basic web site, and finish by examining common web site maintenance tasks.
Information Management, Security and Privacy
This class explores a wide range of privacy and security issues surrounding information management at both personal and organizational levels. Through the use of case studies, we'll explore current threats such as identity theft, information misuse, phishing and privacy, while discussing actions and precautions that can help to protect from them.
Level Three: Elective Courses
In this level of the curriculum, participants may choose from a variety of elective courses to meet their particular needs and interests. The course offerings in this level will change periodically to address new software and technology advances as they become available on campus. After graduating from the program, participants may choose from among this list to keep their skills current with changing technology. Participants must complete at least two electives to be eligible for the Business Technology Certificate.