Computers & Information Technology

COMPUTERS & INFORMATION TECHNOLOGY

Computer students: please bring a USB flash drive to class.
Classes are taught with Windows 8 and Office 2013.

Where required, textbooks can be purchased at the bookstore at 914-606-6475 or ordered online at www.sunywcc.edu/bookstore

Computer Basics 1 – Operational Skills
Increase your proficiency in the basic operations of using a Windows-based computer: working with the mouse and keyboard, the Windows desktop, using programs such as word processing, using menus and toolbars and more. This workshop is ideal for new computer users or those who want to brush up or enhance their basic skills.
CE-COMP 2001, $140 (+ textbook).
Sec. A: 1 Sat., Sept. 12, 9:00 am-4:00 pm (1-hour lunch break), GTW-209. #82924
Sec. B: 2 M/T, Sept. 21 & 22, 9:00 am-12:00 noon, GTW-209. #82925
Sec. C: 2 Mon., Sept. 28 & Oct. 5, 6:00-9:00 pm, GTW-215. #82926
Sec. D: 2 M/W, Nov. 16 & 18, 6:30-9:30 pm, GTW-203. #82927

Computer Basics 2 – Mastering Windows and File Management
Build your confidence and get control of your computer with these techniques for using Windows. Learn to manage and organize your files and folders; search for files; work with shortcuts; use control panels; set some custom features to make it easier to work with Windows. Prerequisite: Computer Basics 1 or equivalent experience.
CE-COMP 2002, $140 (+ textbook).
Sec. A: 1 Sat., Sept. 19, 9:00 am-4:00 pm (1-hour lunch break), GTW-209. #82928
Sec. B: 2 M/T, Sept. 28 & 29, 9:00 am-12:00 noon, GTW-209. #82929
Sec. C: 2 Mon., Oct. 12 & 19, 6:00-9:00 pm, GTW-215. #82930
Sec. D: 2 M/W, Nov. 30 & Dec. 2, 6:30-9:30 pm, GTW-203. #82931

Computer Basics 3 – Internet and Email
Become a more proficient Internet user. Learn the benefits of different browsers and search engines and how to make your Internet use more efficient and safe. Learn how to manage your email folders and attachments. Get a glimpse of popular social media sites including Facebook and Twitter. Prerequisite: Computer Basics 1 or equivalent experience.
CE-COMP 2003, $140 (+ textbook).
Sec. A: 1 Sat., Sept. 26, 9:00 am-4:00 pm (1-hour lunch break), GTW-209. #82932
Sec. B: 2 M/T, Oct. 5 & 6, 9:00 am-12:00 noon, GTW-209. #82933
Sec. C: 2 Mon., Oct. 26 & Nov. 2, 6:00-9:00 pm, GTW-215. #82934
Sec. D: 2 M/W, Dec. 7 & 9, 6:30-9:30 pm, GTW-203. #82935

Save $$ when you register for all three Computer Basics classes during this term for only $378.
Savings will reflect when your course fees are calculated after enrolling.

Keyboarding on the Computer
This course provides students with the basic skills necessary to learn touch typing on a computer keyboard. The ability to type faster and accurately saves time and increases productivity. A great course for anyone who uses the computer, including health care professionals who have to make entries in patient electronic records. Only basic operational computer skills are required for this hands-on class.
CE-COMP 2016, GTW-203, $150.
Sec. A: 8 Sat., Sept. 19-Nov. 7, 9:00-10:30 am. #82946
Sec. B: 8 T/Th, Sept. 29-Oct. 22, 6:00-7:30 pm. #82947

Social Networking and Internet Applications

Social Media Overview
Learn how to connect and more efficiently use several of the more popular social media sites: LinkedIn, Facebook, Pinterest, Twitter, Flixster, Google Plus, and Flickr. Learn how to join these sites, understand when to “like” something, set security features, promote yourself, join groups, understand hashtags, and social media “etiquette.” Prerequisite: Computer Basics 1 and 3 or equivalent experience.
CE-COMP 2015, 4 M/W, Sept. 28-Oct. 7, 6:00-9:00 pm, GTW-203, $200. #82945

NEW! Advanced Social Media Overview
If you know the basics of using Facebook, Twitter, and Pinterest, go further into more advanced features. You’ll create Facebook groups and events, manage photo albums, and manage your friends and what you see of their posts. Use links in tweets, set favorites, and learn how to search for someone to follow. Manage your Pinterest boards and add comments. Learn about security settings and how to link your various social media sites. Prerequisite: Social Media Overview or equivalent experience.
CE-COMP 2135, 2 M/W, Oct. 19 & 21, 6:00-9:00 pm, GTW-203, $120. #83009

NEW! Making the Most of Google+
Integrate your Gmail account with Google plus and enjoy the benefits of Google’s huge social network. Video chat with up to 10 friends as though you were in the same room. Share photos instantly right through your email with one click. Use all the other Google tools such as mapping, Google toolbar, posting your work for others to share with Drive, etc. Sync other social media sites into one. Tune into live video chats from experts and take part in communities of interest to you.
CE-COMP 2129, 1 Mon., Sept. 21, 6:00-9:00 pm, GTW-203, $50. #82991

NEW! Making the Most of YouTube
Watching music videos and finding new rising stars isn’t all you can do with YouTube. It’s a great educational tool and can be valuable for product research as well as posting your own videos to get your message out there. Businesses can use it as an effective tool for marketing as well. Tweets are increasingly including YouTube links, leading to increased viewership of the video. Explore the bigger picture!
CE-COMP 2130, 1 Thurs., Sept. 21, 6:00-9:00 pm, GTW-203, $50. #82992

Create a Powerful Profile with LinkedIn
LinkedIn is the world’s largest professional networking site and is a valuable tool for creating and maintaining a list of contacts with others. Job seekers, employers, and those looking for business opportunities all benefit from the power of LinkedIn. Find out how to improve your profile to be most effective. Prerequisite: Computer Basics 1 and 3 or equivalent experience.
CE-COMP 2099, 1 Sat., 10:00 am-12:00 noon, GTW-203, $50.
Sec. A: Sept. 12. #82977
Sec. B: Nov. 14. #82978

Social Media for Business Certificate
Is your company taking advantage of social media and using it wisely? Complete the following three courses to earn a non-credit Certificate in Social Media for Business. Prerequisite for all three classes is Social Media Overview or equivalent experience.

What’s In It For Your Company?
Social media has burst onto the scene faster than businesses know how to handle it. With new ways to reach clients, companies find themselves grappling to understand and implement new strategies. What is the social media landscape, how does it work, and how much of a game changer will it be for your business. Shape your understanding of social media marketing and think more critically about your company’s use of social networks.
CE-COMP 2110, 2 Wed., Oct. 7 & 14, 6:00-9:00 pm, GTW-215, $120. #82980

Tools & Techniques for Marketing Your Business
Explore how a variety of social media tools such as LinkedIn, Facebook, Twitter, and YouTube can increase your business’ visibility and consumer impact. Get hands-on training on how to open accounts and participate in these networks to drive traffic to your company website. We’ll also look at tracking how effective your social media campaigns are and how to gather information for targeted marketing.
CE-COMP 2111, 2 Wed., Oct. 21 & 28, 6:00-9:00 pm, GTW-215, $120. #82981

What’s Your Strategy?
We’ll look at the data, decisions, and tools you’ll need to develop the social media plan for your business. Participants are encouraged to share ideas and get feedback to help in defining a successful and robust strategy.
CE-COMP 2117, 2 Wed., Nov. 4 & 11, 6:00-9:00 pm, GTW-203, $120. #82982

Save $$ when you register for all three Social Media for Business classes during this term for only $324.
Savings will be reflected when your course fees are calculated after enrolling.

NEW! Launch It! Crowd Funding and Online Fundraising
It’s interest free and totally based on the faith that online donors have in your product/service. KickStarter reached their “billion dollars contributed” milestone and Quirky is turning everyday people into millionaires. How can you raise money through your peers and online supporters? What crowd funding platforms should you use? What needs to be already in place prior to starting? What tax rules do I need to know about? Topics include: rules every crowd funding campaign should follow; when is the right time to brand; how do I craft my message; and legal and ethical considerations
CE-COMP 2125, 2 Thurs., Oct. 8 & 15, 6:00-9:00 pm, GTW-215, $120. #82989

NEW! eCommerce Marketing
You have the products, the website, the PayPal account, and the packaging materials all ready to go. Now, the next step is bringing traffic to your website and converting it into paying customers. Marketing an ecommerce business can be challenging, but you can jumpstart your online success. Is your website ready for customers? What are your page load times? What is your website audit timeline? Topics include: SEO and website optimization; product placement and description; customer conversion; and word of mouth advertising
CE-BUS 2022, 2 Thurs., Oct. 22 & 29, 6:00-9:00 pm, GTW-215, $120. #82921

NEW! Email Marketing
33% of email recipients open email based on subject line alone and emails that include social sharing buttons have a 158% higher click-through rate. Learn how to capitalize on this method of advertising that is still more popular than Facebook. What platforms should you use? How do you decipher the stats? What are the best times to send an email campaign? How do you merge your social platforms and website with your email marketing campaign? How do you deal with those who unsubscribe? What are the ethical requirements of your email?
CE-BUS 2023, 2 Thurs., Nov. 5 & 12, 6:00-9:00 pm, GTW-215, $120. #82922

NEW! Social Data Analytics
So now you understand Social Media Marketing and how to create your campaigns but what do you do with all the data that you now have access to? How do you convert data into leads, sales, and product development? What insights can you gather from the comments, likes, views, and downloads you receive? This course will teach you how to research and analyze social, digital and mobile data. We will look at the data generated from social networking sites and use real-time data analytics to ultimately determine various engagement factors such as influence, reach, relevancy and trend spotting.
CE-COMP 2134, 3 Wed., Nov. 18 & Dec. 9 (skip 11/25), 6:00-9:00 pm, GTW-215, $200. #82999

Cloud Computing Basics for Business
What is the cloud and why should your business care? Get a conceptual and hands-on understanding of cloud computing and explore its aspects of availability, security and how it’s set up.
CE-COMP 2118, $150.
Sec. A: 2 T/W, Sept. 29 & 30, 6:30-10:00 pm, GTW-215. #82984
Sec. B: 1 Sat., Oct. 24, 9:00 am-5:00 pm (includes 1-hour lunch break), Room TBD. #82985

Accounting and Finance

Bookkeeping with QuickBooks and Excel Certificate
Earn this non-credit certificate by completing our Introduction to QuickBooks class, the Excel series, and Accounting & Bookkeeping for Beginners. Apply for the certificate upon completing all requirements.

NEW! Behind the Scenes of QuickBooks
Debits, credits, journals, ledgers…having a working knowledge of the principles behind the bookkeeping capability of Quickbooks will simplify the process of mastering this software. The goal is to understand the “behind the scenes” of how business transactions are correctly recorded and how QuickBooks handles them. No QuickBooks experience is needed – this is the perfect first class for someone who plans to learn QuickBooks but will also be useful for QuickBooks users who need additional understanding of bookkeeping processes.
CE-COMP 2132, $175.
Sec. A: 4 Thurs., Sept. 10-Oct. 1, 9:00-11:00 am, GTW-209. #82993
Sec. B: 4 Tues., Oct 13-Nov. 3, 6:00-8:00 pm, GTW-215. #82994

Introduction to QuickBooks
Learn how to handle accounts payable and receivable, customer info, inventory, and track your business’s financial health. These sections are open to all students but are particularly suitable for those who have some previous experience with bookkeeping. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2013, GTW-203, $410 (+ textbook).
Sec. A: 4 M/T/W/Th, Oct. 5-8, 9:00 am-1:30 pm. #82943
Sec. B     : 6 T/Th, Oct. 27-Nov. 12, 6:00-9:00 pm. #82944

Performing Payroll in QuickBooks
Preparing payroll for a small business can be much easier with the powerful features of QuickBooks. Learn to set up a payroll, pay employees, use timesheets and reports, and create standard federal and state payroll forms. Prerequisite: Introduction to QuickBooks or equivalent experience.
CE-COMP 2033, 1 Tues., Nov. 17, 6:00-9:00 pm, GTW-203, $70. #82969

NEW! Fixing Common QuickBooks Errors
You know how to use QuickBooks when everything goes smoothly, but this course will help with handling the times when some things just don’t go right. We’ll look at corrections for things like using the wrong account type, merging duplicate accounts, voiding checks, reversing mistakes, correcting wrong amounts, and more. We’ll also cover setting up a company from the beginning to ensure that things are done properly. Prerequisite: Introduction to QuickBooks or equivalent experience.
CE-COMP 2133, 4 T/Th, Dec. 1-10, 6:00-9:00 pm, GTW-203, $70. #82995

Professional Bookkeeping with QuickBooks – Online Program
Get full details at careertraining.ed2go.com/sunywcc

Microsoft Office Applications
Prepare for the Microsoft Office certification exams or just build new skills. Our Microsoft applications courses are taught using MS Office 2013.

MS Office Skills for the Workplace
Today’s workplace is competitive! Don’t let weak computer skills hold you back. Learn to use key applications in the Microsoft Office Suite – Word, Excel, PowerPoint, and Outlook – in this intensive introductory course. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2004, 20 M/W/F, Oct. 12-Nov. 25, 9:00 am-12:00 noon, GTW-209, $999 (+ textbook). #82936

MS Word – Level 1
Get started with Word even if you have never done word processing before. Covers editing documents, formatting text, paragraphs and documents, and creating and formatting tables – fundamental skills for creating letters, reports and documents. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2029, 4 M/W, $280 (+ textbook).
Sec. A: Oct. 12-21, 6:30-9:30 pm, GTW-209. #82964
Sec. B: Oct. 26-Nov. 4, 1:00-4:00 pm, GTW-203. #83006

MS Word – Level 2
Expand your skills and enhance your documents by adding graphics, using styles and templates, and managing multi-page documents. Create personalized mailings by merging data into your documents. Learn how easy it is to turn your Word document into a web page. Prerequisite: Microsoft Word Level 1 or equiv. experience.
CE-COMP 2030, 4 M/W, $280 (+ textbook).
Sec. A: Oct. 26-Nov. 4, 6:30-9:30 pm, GTW-209. #82965
Sec. B: Nov. 9-18, 1:00-4:00 pm, GTW-203. #83007

MS Word – Level 3
Master more advanced features of Word such as building forms, creating charts and diagrams, collaborating with others on a document, working with references, advanced graphics, and integrating Word with other applications. Prerequisite: Microsoft Word Level 2 or equivalent experience.
CE-COMP 2031, 4 M/W, $280 (+ textbook).
Sec. A: Nov. 9-18, 6:30-9:30 pm, GTW-209. #82966
Sec. B: Nov. 30-Dec. 9, 1:00-4:00 pm, GTW-203. #83008

Save $$ when you register for all three Word classes during this term for only $756.
Savings will be reflected when your course fees are calculated after enrolling.

MS Excel – Level 1
Get started with Excel even if you have never used a spreadsheet before. Includes building and editing worksheets, formatting a worksheet, working with charts and working with formulas and functions. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2020, $280 (+ textbook).
Sec. A: 4 T/Th, Sept. 8-17, 6:30-9:30 pm, GTW-209. #82951
Sec. B: 3 Sat., Oct. 3-17, 9:00 am-1:00 pm, GTW-209. #82952
Sec. C: 4 M/W, Oct. 26-Nov. 4, 9:00 am-12:00 noon, GTW-203. #83003

MS Excel – Level 2
Expand your skills in Excel by learning to use and analyze tables and enhance your charts and worksheets. Explore techniques for managing workbooks, sharing Excel files, and incorporating web information. Prerequisite: Microsoft Excel Level 1 or equivalent experience.
CE-COMP 2021, $280 (+ textbook).
Sec. A: 4 T/Th, Sept. 29-Oct. 8, 6:30-9:30 pm, GTW-209. #82953
Sec. B: 3 Sat., Oct. 24-Nov. 7, 9:00 am-1:00 pm, GTW-209. #82954
Sec. C: 4 M/W, Nov. 9-18, 9:00 am-12:00 noon, GTW-203. #83004

MS Excel – Level 3
Master more advanced features of Excel such as analyzing data with PivotTables, exchanging data with other programs, and advanced worksheet management. Prerequisite: Microsoft Excel Level 2 or equivalent experience.
CE-COMP 2022, $280 (+ textbook).
Sec. A: 4 T/Th, Oct. 13-22, 6:30-9:30 pm, GTW-209. #82955
Sec. B: 3 Sat., Nov. 14-Dec. 5 (skip 11/28), 9:00 am-1:00 pm, GTW-209. #82956
Sec. C: 4 M/W, Nov. 30-Dec. 9, 9:00 am-12:00 noon, GTW-203. #83005

Save $$ when you register for all three Excel classes during this term for only $756.
Savings will be reflected when your course fees are calculated after enrolling

MS Access – Level 1
Get started with Access, the Office Suite’s powerful database program. Includes building and editing tables, using queries, forms and reports, and modifying your database structure. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2017, 4 T/Th, Oct. 27-Nov. 5, 6:30-9:30 pm, GTW-209, $280 (+ textbook). #82948

MS Access – Level 2
Expand your skills in Access by learning to create multiple table queries, develop forms and subforms, create charts and PivotTables, and build advanced queries. Explore how to share Access data with other applications and enhance your reports. Prerequisite: Microsoft Access Level 1 or equivalent experience.
CE-COMP 2018, 4 T/Th, Nov.10-19, 6:30-9:30 pm, GTW-209, $280 (+ textbook). #82949

MS Access – Level 3
Master more advanced features of Access such as creating macros, creating modules, and developing advanced forms and reports. Learn how to simplify the database interface for other users and tips for maintaining your database. Prerequisite: Microsoft Access Level 2 or equivalent experience.
CE-COMP 2019, 4 T/Th, Dec. 1-10, 6:30-9:30 pm, GTW-209, $280 (+ textbook). #82950

Save $$ when you register for all three Access classes during this term for just $756.
Savings will be reflected when your course fees are calculated after enrolling.

MS PowerPoint – Level 1
Learn the basics of this easy-to-use program to create visually compelling presentations and slides. Wizards and templates give you a quick start on professional presentations and you’ll also learn to develop your own designs with text, graphics and special effects. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2025, 4 M/W, Sept. 14-23, 6:30-9:30 pm, GTW-209, $280 (+ textbook). #82959

MS PowerPoint – Level 2
Enhance your presentations with a variety of chart types. Integrate PowerPoint with other programs, like Excel, to represent data graphically with more impact. Include multimedia and web resources in your presentations. Explore options for preparing a presentation for live delivery, web delivery, and distribution on CD. Prerequisite: Microsoft PowerPoint Level 1 or equivalent.
CE-COMP 2026, 4 M/W, Sep. 28-Oct. 7, 6:30-9:30 pm, GTW-209, $280 (+ textbook). #82960

Save $$ when you register for both MS PowerPoint classes during this term for just $504.
Savings will be reflected when your course fees are calculated after enrolling.

MS Outlook – Email Functions
Tame your Inbox with these techniques for managing your email. Learn the many options Outlook provides for creating, reading and sending email, working with attachments, flagging and categorizing messages, and working with distribution lists and your contacts. Prerequisite: Essential Computer Skills 1 and 2 or equivalent experience.
CE-COMP 2079, 2 M/W, Nov. 30-Dec. 2, 6:30-9:30 pm, GTW-209, $140 (+ textbook). #82973

MS Outlook – Calendars and Task Management
Outlook is more than just email! Improve your time and task management with advanced features of Outlook mail, the powerful calendar and meeting scheduler, contacts and address book, and task manager. Prerequisite: Essential Computer Skills 1 and 2 or equivalent experience.
CE-COMP 2080, 2 M/W, Dec. 7-9, 6:30-9:30 pm, GTW-209, $140 (+ textbook). #82974

Save $$ when you register for both MS Outlook classes during this term for just $252.
Savings will be reflected when your course fees are calculated after enrolling.

Microsoft Office – One on One
Get the benefits of the expertise of our experienced instructors in a one on one, 2-hour session! Whether you want a private tutorial or you’re struggling with getting an Office application to do what you need, our One on One program can help. We will match you with one of our excellent instructors to meet at our Valhalla campus for a session arranged by appointment. Call Mary Beth Jerry at 914-606-7904 to set an appointment time. A 2-hour session is $240

MS Office Skills Non-Credit Certificate
The applications in the Microsoft Office Suite (Access, Excel, Word, PowerPoint) are widely used and these skills are expected of today’s working professional. Complete our series of classes in these four programs to qualify for this non-credit certificate. Apply for the certificate upon completing all requirements.

Microsoft Certification Training – Online Programs
If our class schedule doesn’t match your availability, you can still train for a new career and sharpen your computer skills by enrolling in our online class offered in partnership with Ed2Go. For more information, visit http://careertraining.ed2go.com/sunywcc

Take Your Microsoft Office Certification Exams on Campus!
You can now take your Microsoft Office Specialist certification exams at the Valhalla campus. Contact Michele Maya by email at michele.maya@sunywcc.edu for further details or to make a test appointment.

Business Solutions with Microsoft Office
Your time and training dollars are stretched – these short courses are designed to teach just the skills you require to meet specific business needs. NEW! Now both evening and day sections on many classes!

MS Word Basics
Learn the fundamentals of word processing for creating basic documents. Enter and edit text, correct spelling and grammar as you type, change fonts and font sizes, emphasize text, set margins and tabs, use bullets and numbering, create an envelope, search for and replace text. Prerequisite: Essential Computer Skills 1 and 2 or equivalent experience.
CE-COMP 2032, GTW-203, $140 (+ textbook).
Sec. A: 1 Fri., Sept. 25, 9:00 am-4:00 pm (1-hour lunch break). #82967
Sec. B: 2 M/W, Oct. 12 & 14, 6:00-9:00 pm. #82968

Creating Brochures, Flyers and Newsletters with MS Word
Learn the desktop publishing features of Word, including using clip art, graphics, Word Art objects and watermarks, inserting special characters and symbols, formatting text in columns and text boxes, and using borders and shading. Prerequisite: Word Basics or equivalent experience.
CE-COMP 2009, $140.
Sec. A: 1 Fri., Oct. 9, 9:00 am-4:00 pm (1-hour lunch break), GTW-203. #82939
Sec. B: 2 M/W, Nov. 9 & 11, 6:00-9:00 pm, GTW-215. #82940

Creating Custom Mailings with Word Mail Merge
Design form letters with merge fields; create data lists in Word or use data from Excel or Access; sort and select data records; create mailing labels. Prerequisite: Word Basics or Word Level 1 or equivalent experience. Excel and/or Access experience is helpful.
CE-COMP 2006, $70 (+ textbook).
Sec. A: 1 Fri., Oct. 2, 9:00 am-1:00 pm, GTW-209. #82937
Sec. B: 2 M/W, Oct. 26 & 28, 6:00-8:00 pm, GTW-203. #82938

Managing Complex Documents with MS Word
Conquer page numbers, headers/footers, tables of contents, foot/endnotes, styles and more to make working with large documents easier. Prerequisite: Word Basics or equivalent experience.
CE-COMP 2124, 1 Fri., Oct. 16, 9:00 am-4:00 pm (1-hour lunch break), GTW-203, $140. #82988

MS PowerPoint Basics
Learn the fundamental skills needed to create effective PowerPoint presentations that incorporate text, graphics, charts, and tables. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2027, $140 (+ textbook).
Sec. A: 1 Fri., Oct. 23, 9:00 am-4:00 pm (1-hour lunch break), GTW-203. #82961
Sec. B: 2 T/Th, Dec. 15 & 17, 6:00-9:00 pm, GTW-215. #82962

MS Excel Basics
Learn the fundamentals: enter and edit text and values; create simple formulas; select cells and ranges; move around the worksheet; change column widths and row heights; insert and delete rows and columns; format numbers; copy and move data from one location to another using menus, fill-handle and drag and drop; save, retrieve and print worksheets. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2023, $140 (+ textbook).
Sec. A: 1 Fri., Oct. 30, 9:00 am-4:00 pm (1-hour lunch break), GTW-203. #82957
Sec. B: 2 T/Th, Nov. 17 & 19, 6:00-9:00 pm, GTW-215. #82958

Constructing MS Excel Formulas
Learn how to build more complicated formulas, use functions and combine them in powerful ways. Covers using absolute and relative references in formulas and the order of precedence of operations. Troubleshoot formulas using the auditing tools. Document the formulas that you create. Use named ranges and cells in your formulas to better understand the purpose of the formula. Prerequisite: Excel Basics, MS Excel Level 1 or equivalent experience.
CE-COMP 2052, 1 Fri., Nov. 20, 9:00 am-4:00 pm (1-hour lunch break), GTW-203, $140. #83010

Database Management with MS Excel
No need to learn a new, complicated database program – Excel may be able to do the job! Learn to sort data with multiple keys, validate data, create a data-entry form and get subtotals based on various criteria. Use named ranges and Lookup tables to retrieve and summarize data. Import data into Excel from other applications. Prerequisite: Excel Basics or Excel Level 1 or equivalent experience.
CE-COMP 2010, $140.
Sec. A: 1 Fri., Nov. 13, 9:00 am-4:00 pm (1-hour lunch break), GTW-203. #82941
Sec. B: 2 T/Th, Dec. 1 & 3, 6:00-9:00 pm, GTW-215. #82942

Using MS Excel Charts
Excel supports a wide variety of standard types of charts and graphs. Create effective charts that clearly and accurately convey the meaning of your data. Prerequisite: Excel Basics or Excel Level 1 or equivalent experience.
CE-COMP 2034, $70.
Sec. A: 1 Fri., Nov. 6, 9:00 am-4:00 pm (1-hour lunch break), GTW-203. #82970
Sec. B: 2 T/Th, Dec. 8 & 10, 6:00-9:00 pm, GTW-215. #82971

Using PivotTables in Excel
A PivotTable is an interactive table that automatically extracts, organizes, and summarizes your data, making it easier to analyze. If you work with large data sets, PivotTables can help you make comparisons, detect patterns and relationships, and analyze trends with ease. Prerequisite: Excel Level 2 or equivalent experience.
CE-COMP 2086, 1 Fri., Dec. 4, 9:00 am-1:00 pm, GTW-203, $70. #82976

MS Access Basics
Learn the fundamentals of developing a database in this powerful application. This intensive course will give you a quick introduction to the concepts and tools you need to get started in creating tables, forms, queries and reports. Prerequisite: Computer Basics 1 and 2 or equivalent experience.
CE-COMP 2081, 1 Fri., Dec. 11, 9:00 am-4:00 pm (1-hour lunch break), GTW-203, $140. #82975

Information Technology and Programming

Health Information Technology
Westchester Community College’s non-credit training program is designed to meet the nation’s emerging need for health information technology professionals. The next offering will be Fall 2015. Participants must have a background in healthcare or information technology to qualify. To find out how you could make a leap into this new career, visit www.sunywcc.edu/hit or email hitech@sunywcc.edu.

NEW! Intro to Program Design with Python
This course give you an understanding of basic programming concepts as implemented in Python. We’ll cover data types, assignment, conditional statements, basics of analysis, and input/output. No previous programming experience is required. Prepare for more in-depth study in Python.
CE-COMP 2137, 2 Sat., Oct. 10 & 17, 1:00-4:00 pm, $140, GTW-203. #83072

NEW! Mobile App Development Using jQuery Mobile
Mobile friendly websites are easy with jQuery because it works with HTML. This course will show you how to structure your sites for mobile devices and how to use “wrapper” technologies to create native applications. Previous knowledge of HTML, CSS and JavaScript are recommended.
CE-COMP 2128, 3 Sat., Oct. 24-Nov. 7, 9:00 am-4:00 pm (1-hour lunch break), GTW-215, $350 (+ textbook). #82990

NEW! Implementing Windows Server 2012 R2
Provides the skills and knowledge necessary to implement a basic Windows Server 2012 R2 infrastructure in an existing enterprise environment. Covers implementing, managing, maintaining, and provisioning services and infrastructure, and the initial implementation and configuration of essential services such as Active Directory, networking services and initial Hyper-V configuration. Prerequisite: intended for IT professionals with previous knowledge of Windows operating system.
CE-COMP 2136, 4 Sat., Oct. 31-Nov. 21, 9:00 am-5:00 pm (includes 1-hour lunch break), $900, Room TBD. #83071

Introduction to SQL
This course will allow the student to understand and write SQL (Structured Query Language), the language used to manipulate and read data from relational databases such as Access, Oracle, and Microsoft SQL Server.
CE-COMP 2102, 3 Sat., Oct. 3-17, 9:00 am-4:00 pm (includes 1-hour lunch break), GTW-215, $350 (+ textbook). #82979

UNIX/LINUX Administration Basics
Gain basic systems administration skills to manage and deploy small to large systems. You’ll get a conceptual and hands-on understanding of UNIX/LINUX administration for a business environment. Prerequisite: Computer Basics 1, 2 and 3
CE-COMP 2123, $150.
Sec. A: 1 Sat., Sept. 26, 9:00 am-5:00 pm (includes 1-hour lunch break), Room TBA. #82986
Sec. B: 2 T/W, Nov. 10 & 11, 6:30-10:00 pm, Room TBA. #82987

Looking to learn Java, C#, Python? Check out our online courses at www.ed2go.com/sunywcc

Project Management

NEW! Fast Track to Project Management
In this comprehensive course you will learn tools and techniques to help deliver solutions on time and within budget within a collaborative group setting. The course includes base concepts followed by activities that practically apply the tool or technique learned. Topics include project definition, planning, resource allocation, measurement management, risk management, communications management, reporting and ethical analysis.
CE-BUS 2068, 3 Sat., Aug. 1-15, 9:00 am-4:00 pm (1-hour lunch break), GTW-209, $350 (+ textbook). #5970

Online Project Management Courses with Cheetah Learning

PMI-ACP Online Exam Prep
Become a PMI Agile Certified Practitioner. Agile is a topic of growing importance in project management. The marketplace reflects this importance, as project management practitioners increasingly embrace agile as a technique for managing successful projects. The PMI-ACP certification recognizes an individual’s expertise in using agile practices in their projects, while demonstrating their increased professional versatility through agile tools and techniques. In addition, the PMI-ACP certification carries a higher level of professional credibility as it requires a combination of agile training, experience working on agile projects, and examination on agile principles, practices, tools, and techniques. This global certification also supports individuals in meeting the needs of organizations that rely on project practitioners to apply a diversity of methods to their project management. $2,399.

Online CAPM Exam Prep prepares you to earn the Project Management Institute’s Certified Associate in Project Management credential (CAPM) and build your PM skills. This 70-hour program includes access to certified CAPM coaches as you prepare to take the CAPM exam. $2,360.

Cheetah Online Exam Prep for the PMP® Exam includes the two-week Cheetah Exam Prep® for the PMP® Pre-Course which satisfies PMI’s required 35 hours of education. Prepare for the exam with access to a personal PMP exam prep coach for four weeks. $3,163

Email PDC@sunywcc.edu for details on these online programs offered in partnership with Cheetah Learning.

Employer-Sponsored Staff Training and Development Programs

The Professional Development Center at Westchester Community College helps local employers provide high-quality, up-to-date, and affordable training programs for their employees. They are delivered locally, cutting down on travel and time away from the office. If you’re looking for programs for your staff members in leadership or management; business acumen; business communications such as writing or presenting; sales and customer service; technology including Microsoft Office training; or English as Second Language and other language training, please contact us at 914-606-6669 or 914-606-6598 or visit our website www.sunywcc.edu/pdc.