CSC     195

195     CSC 195 – INTERMEDIATE CSS3 AND HTML5 (1 Cr) – Today’s websites require streamlined code that adapts to a variety of devices, screen resolutions, Web browsers, and user needs. CSS3 and HTML5 are the keys to creating that, and they’re the foundation upon which all modern websites built (not to mention many mobile apps, games, and even desktop apps). This means today’s software developers need a deep understanding of CSS3 and HTML5. In this course, you’ll take your CSS and HTML skills to the next level and learn how to create professional-quality websites. You’ll find out the methods the pros use to quickly build effective sites that are easy to maintain and modify. You’ll discover the secrets to ensuring you keep total creative control over every aspect of a site. You’ll master specific techniques for using background images and controlling opacity, visibility, and scrollbars. You’ll create picture thumbnail galleries, cool hover (mouseover) effects, drop-down menus and flyout menus, and animation effects that work on hover as well as touchscreens like the iPhone and iPad. You’ll also discover wonderful easy-to-code methods for creating responsive layouts that scale well to all screen sizes and devices.

CSC     195

195     CSC 195 – INTERMEDIATE FLASH CS6 (1 Cr) – Take your Adobe Flash skills to the next level by learning advanced Movie Clip symbol, ActionScript, animation, application programming, and interactivity techniques.

CSC     195

195     CSC 195 – INTEGRATING TECHNOLOGY IN THE CLASSROOM (1 Cr) – In this professional development course for teachers, you’ll learn the secrets of technology integration in the classroom, gaining the skills educators need to use tools such as wikis, podcasts, and blogs effectively. You’ll discover simple ways to integrate technology to enhance your subject material and meet your course goals. We’ll explore quick-and-easy, standards-based solutions for more interactive lesson plans, exciting WebQuests, and challenging assignments. We’ll also unleash the power of Web resources, Word, Excel, and PowerPoint. Together, we’ll look at basic integration, subject-specific activities, and smart ways to make your integration seamless.

CSC     195

195     CSC 195 – INTERMEDIATE JAVA PROGRAMMING (1 Cr) – Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional. You’ll learn about reading and writing data files, organizing information with multiple classes in Java’s class hierarchy, and creating GUI applications using tools like windows, menus, buttons, text boxes, check boxes, scrolling, and more.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT ACCESS 2010 (1 Cr) – You’ll start by learning how to create your new database by importing information from Excel spreadsheets into tables. Using action queries, you’ll add and update key fields that allow you to build relationships among the tables. Then you’ll master the steps for building complex yet easy-to-use forms to manage table data. The course offers you tips and techniques for optimizing your database, including ways to build crosstab and summary queries so you can access information quickly and easily. You’ll also learn about outer table joins that can make you queries more effective. Once you’ve built your database, you’ll examine how to build reports using conditional formatting to highlight key data points, and explore Visual Basic, a powerful programming language that allows you to automate simple and complex tasks. Finally, you’ll put the finishing touches on your database as you build a navigation form to make it easy for your users to find what they need.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT ACCESS 2007 (1 Cr) – In this course, you’ll master the tools and techniques required to create user-friendly Access 2007 databases. You’ll learn to design one-to-many and many-to-many databases and create queries, forms, and reports to reflect those relationships. You’ll find out how to create a switchboard form, change database settings, and use macros to make a database easy and intuitive enough for even a computer novice to use.

CSC     195

195     CSC 195 – INTRODUCTION TO CSS3 AND HTML5 (1 Cr) – Learn how to create state-of-the-art Web sites using modern CSS3 and HTML5 techniques. Take your existing HTML skills to the next level and start building sites like the pros. If you want to survive and excel in the fast-paced world of Web publishing, you’re going to need to keep up with ever-evolving standards. The new standard for Web developers is to use CSS3 and HTML5. CSS3 and HTML5 not only make it easier for you to build and manage large Web sites, these powerful languages can also give you more precise control over the appearance of every page you build. Almost every Web development tool–including Dreamweaver, Microsoft Expressions Web, and Visual Web Developer–offer support for CSS3 and HTML5. This course will provide you with the foundation you’ll need to master two critical and fast-growing new Web languages. If you’re a Web developer, why not begin your transition to CSS3 and HTML5 today?

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT EXCEL 2007 (1 Cr) – Master advanced features of Microsoft Excel 2007, including charting and PivotTables. Learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007’s filtering techniques. Become adept at using Excel 2007 to gain further insight into your valuable data. Find out how to create macros that eliminate repetitive tasks, and set yourself apart from the casual Excel user by understanding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving functions.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT EXCEL 2010 (1 Cr) – Take your Excel skills to the next level! In these hands-on lessons, you’ll master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010. You’ll learn how to harness the power of Excel’s data analysis and filtering tools and see how easy it is to create macros that eliminate repetitive tasks. You’ll also set yourself apart from the casual Excel user by adding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving functions to your repertoire. So get ready for six fun, action-packed weeks that will make you an Excel expert!

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT EXCEL 2013 (1 Cr) – Take your Microsoft Excel 2013 skills to the next level as you master charts, graphs, PivotTables, Slicers, Sparklines, AutoFilter, macros, and other advanced Excel functions.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT WORD 2007 (1 Cr) – Microsoft Word 2007 is a powerful and popular program, yet most people use only a fraction of its features. In this course, you’ll learn Microsoft Word’s more advanced features, which can make writing easier, faster, and more fun. You’ll discover how to create an index, a list of figures, tables of contents, do desktop publishing, perform a mail merge, and use timesaving macros. By the end of the course, you’ll know how to use Word both to save lots of time and to set your creativity free!

CSC     195

195     CSC 195 – INTRODUCTION TO PYTHON 2.5 PROGRAMMING (1 Cr) – Learn the fundamentals of computer programming in Python to create basic programming structures like decisions and loops. You’ll then move on to more advanced topics such as object-oriented programming with classes and exceptions, and later unique Python data structures such as tuples and dictionaries. You’ll even learn how to create Python programs with graphical elements that range from simple circles and squares to graphical user interface objects like buttons and labels. Whether you’re interested in writing simple scripts, full programs, or graphical user interfaces in Python, this course will give you the foundation you need.

CSC     195

195     CSC 195 – INTERMEDIATE PHP AND MYSQL (1 Cr) – Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. You’ll see how to use the popular MySQL database server to store product information (including images) and track customer orders. You’ll also learn how to use the PHP programming language to display product images in your online store, allow customers to shop online using a shopping cart in their browser, and provide an administrative section to manage the store.

CSC     195

195     CSC 195 – INTERMEDIATE CSS3 AND HTML5 (1 Cr) – Today’s websites require streamlined code that adapts to a variety of devices, screen resolutions, Web browsers, and user needs. CSS3 and HTML5 are the keys to creating that, and they’re the foundation upon which all modern websites built (not to mention many mobile apps, games, and even desktop apps). This means today’s software developers need a deep understanding of CSS3 and HTML5. In this course, you’ll take your CSS and HTML skills to the next level and learn how to create professional-quality websites. You’ll find out the methods the pros use to quickly build effective sites that are easy to maintain and modify. You’ll discover the secrets to ensuring you keep total creative control over every aspect of a site. You’ll master specific techniques for using background images and controlling opacity, visibility, and scrollbars. You’ll create picture thumbnail galleries, cool hover (mouseover) effects, drop-down menus and flyout menus, and animation effects that work on hover as well as touchscreens like the iPhone and iPad. You’ll also discover wonderful easy-to-code methods for creating responsive layouts that scale well to all screen sizes and devices.

CSC     195

195     CSC 195 – INTERMEDIATE PHOTOSHOP CS5 (1 Cr) – In this course, you’ll become an expert at using layers, layer masks, and other advanced features that let you change images easily long after you create them (and long after the Photoshop “undo” command expires). Non-destructive editing lets you work faster and reuse parts of images over and over. In these lessons, you’ll learn how to save every single pixel in your original image so you never have to say, “I’m sorry¿I tossed that information.” In addition, you’ll discover how to use Smart Objects so you can crop or resize an image and return it to its original size months afterward. (You’ll even learn some clever tricks for warping Smart Objects!) After that, you’ll find out how to add shadows or embossing non-destructively. And if you want to design page layouts you can fill with different images, you’ll learn how to create templates you can reuse.

CSC     195

195     CSC 195 – TRAVEL PHOTOGRAPHY FOR THE DIGITAL PHOTOGRAPHER (1 Cr) – The lure of travel is surpassed only by the inevitable desire to bring home pictures and share your adventures. Join us and discover the world through a photographer’s eye. This course will address the tools and tricks that enable digital photographers to capture scenes from around the world and bring them home. We’ll share various examples from destinations across the globe, and expand your knowledge of techniques for shooting digitally and working with the images after you get back.

CSC     195

195     CSC 195 – INTERMEDIATE PHOTOSHOP CS6 (1 Cr) – Photoshop is one of the most amazing software programs ever developed. It’s a fun and creative way to alter photos and prepare them for print or the Web. In this course, you can take your Photoshop skills to the next level by exploring more advanced features in Photoshop that let you easily re-edit projects long after they were originally created (and long after the Photoshop “undo” command has expired). These techniques, called non-destructive editing, let you work faster and reuse parts of images over and over again. If you like scrapbooking or want to make page layouts that you can fill with different graphics, you’ll learn how to create reusable templates. You’ll learn how to save every single pixel in your original image so you never have to say, “I’m sorry I tossed that information.” You’ll see how to use Smart Objects, so that even if you crop or resize an image, you’ll be able to get it back to its original size months afterwards. (And you’ll learn some tricks to warp Smart Objects that will make the tabloid newspapers jealous!) Whether you’re a photographer who wants to use Photoshop to edit photos, a scrapbooker, or an artist, this course will teach you the building blocks you need to unleash your creativity. It’s also a lot of fun!

CSC     195

195     CSC 195 – INTERMEDIATE JAVA PROGRAMMING (1 Cr) – Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional. You’ll learn about reading and writing data files, organizing information with multiple classes in Java’s class hierarchy, and creating GUI applications using tools like windows, menus, buttons, text boxes, check boxes, scrolling, and more.

CSC     195

195     CSC 195 – INTERMEDIATE PHP AND MYSQL (1 Cr) – Learn how to create an interactive online store complete with an online catalog of products, allowing customers to browse the catalog to select items, place them in a shopping cart, and complete an order. You’ll see how to use the popular MySQL database server to store product information (including images) and track customer orders. You’ll also learn how to use the PHP programming language to display product images in your online store, allow customers to shop online using a shopping cart in their browser, and provide an administrative section to manage the store.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT EXCEL 2007 (1 Cr) – Master advanced features of Microsoft Excel 2007, including charting and PivotTables. Learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007’s filtering techniques. Become adept at using Excel 2007 to gain further insight into your valuable data. Find out how to create macros that eliminate repetitive tasks, and set yourself apart from the casual Excel user by understanding VLOOKUP, INDEX & MATCH, and Excel’s other time-saving functions.

CSC     195

195     CSC 195 – INTERMEDIATE QUICK BOOKS 2012 (1 Cr) – QuickBooks is a popular way for small and midsized businesses to keep track of their accounting, but many users aren’t aware of the software’s powerful advanced features. In this course, you’ll find out how to get the most out of this feature-packed program. We’ll go beyond the basic concepts to discover the software’s most useful in-depth features and applications. You’ll learn how to manage multiple company files and how to export and import list data from one file to the next. You’ll also learn how to enter price levels and track discounts and credits. If your business handles inventory, you’ll learn to enter units you’ve purchased and track them all the way through to sale. You’ll even learn how to enter and track mileage for any vehicles that you use in your business. You’ll discover the answers to many other common questions that small business owners have, including how to create customer statements and assess finance charges on overdue balances. And you’ll see how to write off these past-due balances when it appears that the customer is not going to pay. In addition, you’ll learn how to enter common transactions that occur between the owner and the business, such as the owner taking money out of the business or investing new capital. You’ll even learn how to deal with those sticky situations where you pay for a business expense using personal cash. We’ll discuss how to track loans and how to use the budgeting feature to better plan for business expenses.

CSC     195

195     CSC 195 – CREATING A CLASSROOM WEB SITE (1 Cr) – Learn how to create a classroom Web site in this fun, easy-to-understand course for teachers. In no time, you’ll build a site with text, images, animations, tables, links, and more. Then you’ll create a WebQuest and a blog to add to your site. You’ll do all this and more as you discover how simple creating a classroom Web site can be and how having one can make you a more effective and dynamic teacher.

CSC     195

195     CSC 195 – INTERMEDIATE QUICKBOOKS 2014 (1 Cr) – Master the advanced features of QuickBooks and learn to manage multiple company files, create customer statements, enter price levels for inventory, and much more.

CSC     195

195     CSC 195 – PHOTOGRAPHING NATURE WITH YOUR DIGITAL CAMERA (1 Cr) – Jump into the world of nature photography! In this course, you’ll master taking beautiful outdoor photos of everything from landscapes to specific nature items such as water, flowers, trees, animals, and more. Along the way, you’ll learn all about digital camera equipment, telephoto photography, and even macro photography. With plenty of examples and opportunities to share your work, you’ll be shooting breathtaking photos in no time!

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT ACCESS 2007 (1 Cr) – In this course, you’ll master the tools and techniques required to create user-friendly Access 2007 databases. You’ll learn to design one-to-many and many-to-many databases and create queries, forms, and reports to reflect those relationships. You’ll find out how to create a switchboard form, change database settings, and use macros to make a database easy and intuitive enough for even a computer novice to use.

CSC     195

195     CSC 195 – INTERMEDIATE MICROSOFT WORD 2007 (1 Cr) – Microsoft Word 2007 is a powerful and popular program, yet most people use only a fraction of its features. In this course, you’ll learn Microsoft Word’s more advanced features, which can make writing easier, faster, and more fun. You’ll discover how to create an index, a list of figures, tables of contents, do desktop publishing, perform a mail merge, and use timesaving macros. By the end of the course, you’ll know how to use Word both to save lots of time and to set your creativity free!

CSC     195

195     CSC 195 – INTRODUCTION TO ADOBE ACROBAT X (1 Cr) – If all you think Acrobat does is create PDF files, you’re in for a big surprise! In this course, you’ll discover how to bring together a wide range of content from dozens of programs that you can reuse and customize in Acrobat X Pro. Need to change some text? No problem. Create a new file? That’s easy. Add a page from this file and an image from that file? Or add a new page? Not a big deal. You can do all that and more! Bringing together content is just the beginning. You’ll work with many features, such as backgrounds, bookmarks, and modified page sizes to help unify your documents. You’ll see how to protect your work using password security, and dig into the metadata within your PDF file. You’ll discover how to add more to your documents as you learn about bookmarks and links for navigation. You’ll even master some JavaScript! You’ll learn how Acrobat X can automatically find and configure fields on a page to convert it to a form. Then you’ll use form tracking to send your form to others to fill in and send back to you, and see how Acrobat X collects the data automatically in a specialized PDF Portfolio. You’ll also see how Acrobat X can help streamline the entire collaboration process and simplify how you conduct, control, and manage a document review cycle. You’ll even find out how to work in real-time using a chat window in Acrobat X or online using a free Web conferencing room. Finally, you’ll discover how to wrap a set of PDF files (and other documents, too) into a PDF Portfolio, complete with a Flash interface and display features, to create the ultimate in customized presentations. In each lesson, you’ll work with an important Acrobat X Pro feature or process using source files (available for both Mac and Windows) provided with the course. You’ll soon see why Adobe Acrobat X has become the best-selling Adobe software of all time!

CSC     195

195     CSC 195 – ADVANCED MICROSOFT EXCEL 2007 (1 Cr) – Maximize your investment in Microsoft Excel 2007 by mastering advanced Excel features that most users don’t even know exist. In this practical, hands-on course, you’ll discover how to use scenarios and data tables to quickly perform multiple what-if analyses. You’ll discover a variety of advanced techniques for PivotTables, like creating calculated fields and calculated items, as well as how to restore the “Classic PivotTable Style” drag-and-drop functionality. You’ll see how to use validation to protect the integrity of your worksheets from other, less experienced users. You’ll become adept at consolidating and importing data from other sources, and you’ll master the art of conditional formatting to highlight duplicate entries and other common worksheet problems. Impress your coworkers by learning how to add functional and eye-catching controls to any worksheet, and find out how to nest one function inside another to accomplish just about anything MS Excel has to offer!