Conestoga College Logo - Home Page

Distance Learning - Part-time Courses - Computer Applications

Click on the course code or title below for a full description of the course. If available for registration, clicking on "Details" in the Status column will open a new browser tab or window in the Student Portal.

Courses
Course # Courses Status
COMP1626 Achieving Top Search Engine Positions

Description: The vast majority of Web traffic comes from search engines. That means the most important thing you can do to increase your website's traffic is to improve its search engine ranking. To do that, you have to understand both the art and science of search engine optimization (SEO).
In this course, you'll gain the knowledge you need to boost your website's visibility. You'll discover how search engines crawl the Web, rank websites, and find previously undiscovered sites, and learn which HTML tags are key to getting sites on a search engine's radar. You'll also explore how to select keywords, why you should amass as many potential keyword choices as possible, and which keywords hold the most potential.
In addition, we'll discuss why you should complete a pre-submission analysis, how to do a post-submission analysis using tools such as Google Analytics, and how to manage the SEO cycle to maximize results. By the end of the course, you'll have mastered proven, step-by-step SEO strategies that you can implement right away.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1823 Advanced Comp TIA A+ Certification Preparation

Description: The Advanced CompTIA A+ Certification Prep course focuses on fun technology. You'll learn everything you need to know to select, install, and service video, sound, and portable computers. The course teaches networking, both wired and wireless, because every well-rounded tech needs to know it. You'll learn about security, security, security. Plus you'll get excellent insight into adding mobile devices such as tablets and smartphones to your computing environment. The Advanced course completes the three-course CompTIA A+ Certification Exam Prep cycle and prepares you for both the 901/902 exams and for real life as a tech. Let's get to it!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1208 Advanced CSS3 and HTML5

Description: You've heard the buzz about CSS3 and HTML5? These latest versions of HTML and CSS have redefined how Web pages are created. So if you're going to design Web pages, you need to know how to work with CSS3 and HTML5.
This course will teach you how to take advantage of HTML5 "semantic" tags that make page design far more intuitive, faster, and easier compared to older versions of HTML. And you'll learn to use HTML5 to create basic mobile pages and apps.
In this class, you'll learn to use HTML5 to provide video that works in any environment. HTML5 makes it possible to build inviting forms that test user data without back-end coding. It also allows designers to include friendly tools like calendars, calculators, and color palettes to encourage accurate user input. You'll leave this course with the skills to create all those elements.
And you'll learn to wield new CSS3 features essential for fast-loading, exciting, interactive websites, especially mobile sites. You'll create complex gradient blend backgrounds for pages and page elements, without using image files. And you'll learn to use jQuery Mobile to create app-like mobile Web pages and themes— complex sets of styles for mobile sites.

In short, you'll leave this course with valuable skills essential to creating modern websites.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1048 Advanced Microsoft Excel 2007

Description: Any proficient Microsoft Excel user will agree that MS Excel is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features at your disposal? In this practical and information-packed course, you'll see how to maximize Excel's functions and capabilities.
Most organizations rely heavily on Microsoft Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization. Your ability to generate information with increased accuracy, timeliness, and usefulness will lead you and others to better decision-making.
Over the next six weeks, you'll see how to use the additional analytical tools provided by Excel add-ins. You'll become skilled in the use of validation to protect the integrity of your worksheets from other, less experienced users. You'll impress your coworkers by learning how to add functional and eye-catching controls to any worksheet and how to use scenarios and data tables to quickly perform multiple what-if analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. 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. Learn how Excel 2007 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
COMP1029 Advanced Microsoft Excel 2010

Description: Any proficient Microsoft Excel user will agree that this program is a very powerful analytical tool. Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.
Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.
You'll see how to work with the additional analytical tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analyses. You'll discover advanced techniques for PivotTables, such as creating calculated fields and calculated items. Become adept at consolidating and importing external data, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Learn how Excel 2010 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1573 Advanced Microsoft Excel 2016

Description: Wouldn't it be great to learn how to effectively use all the advanced Excel features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.
Most organizations rely heavily on Excel to consolidate, analyze, and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.
You'll see how to work with the additional analysis tools provided by Excel add-ins and become skilled in using validation to protect the integrity of your worksheets from less experienced users. Impress your coworkers by learning how to add functional and eye-catching custom controls to any worksheet and how to use scenarios and data tables to quickly perform what-if data analysis. You'll discover ways to work with databases and advanced techniques for PivotTables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's consolidation function to efficiently summarize data from multiple sources, become adept at importing external data using Excel's built-in Power Query tool, and master the art of conditional formatting to highlight duplicate entries and other common worksheet problems.
Learn how Excel 2016 table tools take the complexity out of table creation and management. As you become proficient at nesting functions within other functions, you'll be able to accomplish just about anything Microsoft Excel has to offer!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1031 Advanced PC Security

Description: When is hacking legal? When you use it to secure your own network. This new method of hacking, called ethical hacking or white-hat hacking, uses common and readily available hacking tools and techniques to audit your network so you can locate and close security holes. Whether you're running a small home network or you're an enterprise network administrator, this course will teach you how to better protect your system against those who wish to gain unauthorized access.
You'll gain an understanding of the complex method of electronic breaking and entering. You'll learn the terms and programming behind the interaction between hardware and software when communicating through a network. You'll follow packets of data from one point to another through an entire network, and find out where the flaws exist for data loss and security breaches. You'll discover the role of the seven layers of the OSI model, and the dependencies of hardware and software interaction through packet transmission. And you'll find out how private data can quickly become public knowledge.
Hackers are costing businesses around the globe several billions of dollars every year. Don't become part of that sad statistic. Sooner or later, you know that somebody is going to try and break into your network. Why not learn how hackers think so you can harden your defenses against them?
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1287 Advanced Web Pages

Description: Take your Web design skills to the next level! Whether you want to work as a freelance Web designer, join a Web development team, or build websites for your organization, this course will give you the advanced tools you need.
In these lessons, you'll learn to write HTML code for page content and CSS code for page styling. You'll master cutting-edge techniques that take advantage of HTML5 and CSS3, the latest versions of the languages used to create modern websites.
With the help of step-by-step instructions, you'll build interactive websites that collect information from visitors through email signup and feedback forms. In addition, you'll learn the latest and most effective techniques for presenting layouts and video that work in any browsing environment from a desktop computer to a mobile device. Along the way, you'll explore aesthetics, color scheming, and accessible Web page design.
And don't worry if you have only the most basic exposure to Web design! This course walks you all the way through to purchasing and uploading your site to a remote server. You won't need any special software, either—just the text editor that comes installed with your computer.
Whether you're a beginner or an experienced Web designer wanting to update and enhance your skills, this course is perfect for you. In just a few weeks, you'll be designing state-of-the-art websites that offer all the sophisticated elements that today's Web users expect to see.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1821 Basic Comp TIA A+ Certification Preparation

Description: Time to roll up those sleeves and dive inside the personal computer! The Basic CompTIA A+ Certification Prep course teaches you about the hardware common to virtually every personal computer, including microprocessors, RAM, power supplies, motherboards, UEFI/BIOS, the system setup utility, the expansion bus, and input/output devices. You'll learn how things work, how to configure everything, and how to troubleshoot in real-world environments. This course gives you the knowledge upon which you'll base the rest of your CompTIA A+ certification studies for the 220-901 and 220-902 exams. Plus it helps you take that first step to becoming an excellent PC technician. So what are you waiting for?!?
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1676 Blogging and Podcasting for Beginners

Description: If you're thinking of starting a blog or just beginning one, this course is for you. Perhaps you'd like to try out podcasting too. You can and it's easy. In this course, you'll learn how to create, manage, and promote your own blog and audio and video podcast using tools that you already have on your computer—no paid software or equipment is needed.

You'll begin by developing a plan for the content, setup, and long-term maintenance of a blog, and then you'll use free blogging software like Blogger and WordPress to put that plan into action. After that, you'll learn how to record a professional-sounding audio podcast with a very simple recording tool you already have. You'll edit the file with another free software program, add music to it, and then post it online for others to enjoy. Your instructor will guide you through all these steps. Finally, you'll find out how to record a video podcast. You'll use pre-recorded video to learn the editing process, and then you'll apply what you've learned to your own video file. You'll edit it, add special effects, drop in a podcasting-safe music file, and then publish it online.

Through hands-on exercises, you'll discover the benefits of using free web tools like Blogger, WordPress, Audacity, and YouTube. Guided by an expert instructor, you'll find that creating a blog and podcast is much easier than you ever imagined. And by the end of this course, you'll be amazed how much you've accomplished.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1343 CompTIA Network+ Certification Prep

Description: This course will teach you everything you need to take and pass the CompTIA Network+ certification exam (N10-007). You will learn about the OSI seven-layer model, protocol suites, modern network operating systems, network hardware, cabling standards, remote connectivity, Internet connections, cloud computing, network security, network troubleshooting, and more.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1247 compTIA Security+ Certification Prep 1

Description: The U.S. Department of Labor forecasts that information security analysts will be among the fastest-growing occupations through 2022. CompTIA's Security+ certificate is widely regarded as the entry-level certificate for this fast-growing field. Getting that certificate requires passing CompTIA's challenging SY0-501 exam.
This course covers the key terminology and concepts you need to know to ace the exam, all in a condensed format for rapid reading. The course provides helpful study tools including games and practice questions to aid with learning. All of the content is geared toward helping you pass the SY0-501 exam, so you can leave the test center with your Security+ certificate in hand, whether you are taking the exam for the first time, or using it as a refresher to renew your certification.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1248 compTIA Security+ Certification Prep 2

Description: The U.S. Department of Labor forecasts that computer security and related computer-support specialties will be among the fastest-growing occupations through 2026. CompTIA's Security+ certificate is widely regarded as the entry-level certificate for this fast-growing field. Getting that certificate requires passing CompTIA's challenging SY0-501 exam.
This course, the second of two courses, reviews the key terminology and concepts needed to ace the exam, all in a condensed format for rapid reading. The course provides helpful study tools, including games and practice questions to aid your learning. All of the content is geared toward helping you prepare to pass the SY0-501 exam, so you can leave the test center with your Security+ passing score in hand.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1852 Computer Skills for the Workplace

Description: Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not. This course is a great introduction to Windows 10 and Office 2016 and is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace. You will learn how to implement the powers of modern office software to work faster and more efficiently. We'll focus on practical application for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1297 Creating Mobile Apps with HTML5

Description: Do you want to make mobile apps that run on iPhone and iPad, as well as on Android, and Windows Phone? Sure you do! Do you want to learn five different programming languages? Of course you don't!
Fortunately, you're about to discover a better way to build apps. In this course, you'll learn how to imagine, design, build, and optimize a cross-platform mobile app using the very latest HTML5 standards. The result will be a mobile app that's fast and runs on just about any smartphone or tablet computer.
You'll also learn some of the most sought-after skills in Web and mobile development, including:
HTML5 and how it's different from previous versions of HTML.
CSS3, the layout and styling language of the mobile Web.
Scripting with JavaScript and several JavaScript frameworks and techniques such as jQuery, jQuery Mobile, and AJAX.
How to use Web services such as Google Maps in your app.
How to determine an app's user location by accessing the built-in geolocation capabilities of the user's smartphone.
How to use Web Application Programming Interfaces (Web APIs) to combine different Web services to create mobile mashups.
How to optimize your app for performance to make sure that it runs as fast as possible for your users.
How to convert your HTML5 apps into native apps that you can submit to app stores such as Apple's App Store and Google Play.
By the end of the course, you'll have built your first mobile web app, and you'll be on your way to making your dream of being a successful mobile app developer a reality!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1286 Creating Web Pages

Description: Create and post your very own Web site on the Internet using HTML in this extensive, hands-on, six week workshop. First, you'll learn about the capabilities of the World Wide Web and the fundamentals of web design. Then, with your instructor's patient guidance, you'll plan the content, structure and layout of your Web site, create pages full of neatly formatted text, build links between the pages and to the outside world, and add color, backgrounds, graphics, and tables. You'll also learn critical and timely information on securing the best possible location in search engine listings, and powerful no-cost or low-cost web marketing strategies.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1039 Creating WordPress Websites

Description: Learn how to create attractive, sophisticated blogs and websites—without any coding! WordPress is the world's most popular website publisher, powering more than 25% of all sites on the Internet. WordPress is an easy-to-use solution that will help you put your site on the Web in far less time than by coding, and at a much lower cost than hiring a professional.
In these lessons, you'll get hands-on experience with this powerful tool as you create your own WordPress.org site and blog. You'll find out how to use WordPress to create pages and posts, add images and videos, change a site's look and feel, and include user-friendly features. You'll discover the ease of using WordPress design themes to express your creativity, and you'll see how much fun it is to be part of the vibrant WordPress online community.
In addition to mastering the technical elements of WordPress, you'll learn how to organize a blog or website, create appealing content, keep your site secure, and achieve better positions on search engine results pages. By the end of this course, you'll be able to confidently use WordPress to create a blog or a personal, business, or organizational website.
The WordPress.org version covered in this class is the platform the pros use. While it normally requires a paid hosting account, this course includes a totally free, no obligation SiteGround hosting account for three months, along with a private place on the Web for practice.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1041 Creating WordPress Websites II

Description: Discover how to get the most from websites and blogs built with WordPress, the world's most popular Web page publisher.
After reviewing the system's basic features, you'll learn to use an online administrative area that makes creating and updating content as simple as composing an email. Your online visitors will be able to comment on your articles, fill out forms and applications, buy your products, and even make appointments.
While WordPress requires no coding, you'll find out how to use simple HTML and CSS to customize a website's appearance. You'll take advantage of the dynamic features known as plugins, which add every imaginable function to your website. And you'll explore how use plugins to turn a site into an ecommerce powerhouse and improve search engine page results.
To take this course, you should have at least some blog or website publishing experience and good computer skills. WordPress also requires a paid hosting account, but the class includes 90-days of completely free hosting with SiteGround, one of only four hosting companies that WordPress recommends.
If you want to build or maintain a professional WordPress website with all the bells and whistles, this course is for you.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1064 Designing Effective Websites

Description: These days, creating a website is so easy almost anyone can do it. But with all the competition on the Web, creating a site that's effective is more challenging than ever. To do that, you need to employ good design principles. Regardless of your current skills or level of knowledge, in this course you'll master the basics of Web design and learn how to build sites that are better and more effective. Get ready to take your Web design skills to the next level!
We'll examine the tension between form and function, explore the six major states of the website development process, and learn the basics of user-centered design. We'll also cover the five basic steps to organizing information, find out how site design themes can be used for information delivery, and review Web page design considerations. Along the way, we'll talk about effective type and graphics and explore the idea of Web 2.0.
This course is a must for Web designers, giving the tips and tools that will help them establish a solid career.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1675 How to get Started in Game Development

Description: There's never been a better time to start a career in the game development industry. Games can be found on computers, the Web, gaming consoles, and virtually every mobile tablet and phone. Industry forecasts indicate that gaming will be worth close to $100 billion dollars in the next two years. Talented, creative, and enthusiastic people are in great demand in this industry.
Whether you want to start your own indie game project in your basement or work with a small creative team or for a large game development studio, this course will prepare you to start developing your own games.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1073 Intermediate C# Programming

Description: Build upon your current knowledge of programming logic by writing Graphical User Interface (GUI) applications in the C# programming language. This course will show you how to write professional looking applications with many of the common GUI controls, such as buttons, labels, text boxes, check boxes, and radio buttons. You'll also learn how to put menus and toolbars into your program to make them easier to use. And later in the course, you'll find out how to make your program interact with sequential files, random access files, and databases.
This six-week course will walk you through computer application design and implementation by giving you real examples that you can enter as you learn. Since practicing is the best way to learn programming, most lessons have more than one example, and each provides a programming problem you can solve to demonstrate your new knowledge.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1822 Intermediate Comp TIA A+ Certification Preparation

Description: The Intermediate CompTIA A+ Certification Prep course picks up where the Basic course left off and plunges you head-first into Windows, macOS, and Linux. You learn how to install, organize, maintain, and troubleshoot three different versions of Windows, plus explore similar features in macOS and Linux. You'll examine and compare the features and structures of Windows Vista, 7, and 8/8.1. I'll even throw in some Windows 10 because it's cool. Toward the end of the course you'll get a deeper understanding of how we use virtualization and virtual machines in modern networks. Plus you'll learn about printers and multifunction devices, from the various technologies in use to installing and troubleshooting. This course takes you through the second of three steps you need to become both a highly-competent PC tech and a CompTIA A+ certified technician, using the 901 and 902 competencies.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1212 Intermediate CSS3 and HTML5

Description: 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.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1856 Intermediate Dreamweaver CS6

Description: Take your Adobe Dreamweaver skills to the next level with more advanced techniques under the tutelage of a proven Web development expert. In this new intermediate-level Dreamweaver course, you'll learn to harness the power of this industry-standard Web design tool.
You'll examine pure CSS layout and discover how to get the most out of Dreamweaver's templates. The course also shows you how to incorporate multimedia elements such as video and manipulate data using XML data and XSL. Throughout the course, you'll get hands-on experience with Dreamweaver as you develop a sample site using your new skills.
Whether you're planning a career in Web design, designing a website for your business, or developing sites as a hobby, this course will give you the tools you need to work like a pro. By the end of this course, you'll have a solid, in-depth understanding of traditional layout and how it translates to the Web so you can make your sites clearer, cleaner, and more accessible.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
COMP1790 Intermediate InDesign CC

Description: If you've ever struggled to complete a project in InDesign, or wondered how to save time and increase efficiency in your work, this is the course for you! You'll get hands-on training and experience using many of the more advanced tools and features of this powerful program. While the course focuses on using InDesign in the Creative Cloud (CC), it includes instruction and practice files for any version of InDesign CS4 or newer.
In each lesson, you'll master important features as you prepare a range of print and online products for a fictional resort and conference center. You'll get dozens of files to work with, including templates and partially completed InDesign documents to start each lesson, and the graphics, fonts, and other content to complete the project. Many lessons include advanced content, such as techniques for managing snippets, swatch files, and color. And for reference, you'll always get a copy of the finished InDesign project file—usable in InDesign CS4 and newer.
Lesson by lesson, you'll discover how to use program features to produce professional brochures, forms, and documents, and produce publications for different page sizes and devices. By the time you finish the course, you'll not only be comfortable designing and planning your own workflows and templates, you'll also know the most efficient and effective ways to take your InDesign publications to the next level.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1064 Intermediate Java Programming

Description: Deepen your understanding of the Java programming language, and start writing programs that are more sophisticated and professional. Learn how to save data permanently on a disk by writing it to a sequential data file. See how to read the file to get the data back and process it. Organize information using multiple classes in Java's class hierarchy and inheritance. Explore some of the hundreds of classes that are built into the Java language. Find out how to create GUI applications in Java using tools like windows, menus, buttons, text boxes, check boxes, scroll bars, and other GUI tools.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1115 Intermediate Microsoft Access 2010

Description: Do you have experience building Microsoft Access 2010 databases, but want to take your skills to the next level? In this course, you'll build an entire database project from scratch. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.
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.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1473 Intermediate Microsoft Access 2016

Description: Do you want to take your Microsoft Access skills to the next level? In this course, you'll master more advanced techniques for this powerful database program and build an entire database project from scratch.
You'll start by importing customer and order information from several Excel spreadsheets as tables in a new database. You'll learn how to add key fields to the tables, update these fields using action queries, and build relationships between the tables.
Once you've mastered proper table construction, you'll build on that knowledge by learning how to create forms to manage table data. You'll discover how to construct crosstab and summary queries, and crunch numbers using query calculations. You'll also learn about outer table joins that can make your queries more effective.
From building reports to using conditional formatting, you'll see how to present your data and gain techniques for using Visual Basic to automate common tasks. Finally, you'll build a navigation form to make it easy for your users to find their way around your database. By the time you've completed the course, you'll have a fully functional database that tracks customer and order information.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1720 Intermediate Microsoft Excel 2007

Description: Master advanced features of Microsoft Excel 2007, including charting and PivotTables, and discover how this powerful MS Office program can boost your productivity. In this practical, hands-on course, you'll learn how to create informative and eye-catching charts, as well as how to harness the power of Excel 2007's filtering techniques. You'll see how Excel 2007 can give you further insight into your valuable data. And by learning how to create macros that eliminate repetitive tasks, you'll earn your coworkers admiration and gratitude. With your macro knowledge, you'll be able to manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll set yourself apart from the casual Excel user by learning how to use Excel's VLOOKUP, INDEX & MATCH, and other time-saving functions. So get ready for six fun, action-packed weeks that will take your Excel skills to the next level!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
COMP1092 Intermediate Microsoft Excel 2010

Description: Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2010, and discover how this powerful MS Office program can boost your productivity.
In these hands-on lessons, you'll learn how to create informative, eye-catching charts and harness the power of Excel's data analysis and filtering tools. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1443 Intermediate Microsoft Excel 2013

Description: Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2013, and discover how this powerful MS Office program can boost your productivity.
In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1567 Intermediate Microsoft Excel 2016

Description: Take your Excel skills to the next level! Master charting, PivotTables, Slicers, Sparklines, and other advanced features of Microsoft Excel 2016, and discover how this powerful MS Office program can boost your productivity.
In these hands-on lessons, you'll learn how to create informative, eye-catching charts and graphs, and harness the power of Excel's data analysis tools and AutoFilter commands. In addition, you'll find out how easy it is to create macros that let you manipulate data with the push of a button. You'll also discover how to use Goal Seek and Solver and apply them to real-world problems. And you'll 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1097 Intermediate Microsoft Word 2010

Description: Microsoft Word 2010 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 improve your creativity and efficiency at the same time!
In the first part of the course, you'll learn how to perform a mail merge, and we'll explore shortcuts, styles, and templates. Shortcut keys and macros let you type repetitive words and phrases quickly and accurately at the touch of a button. Styles let you save text formatting. Templates let you create documents that contain predefined formatting and text, making it a snap to create documents that look right every time.
In the second part of the course, we'll cover how to use Word as a simple desktop publishing program to create signs, flyers, menus, brochures, and even newsletters. You'll learn how to insert different types of graphics in a document including digital photographs from your own camera, clip art images provided by Microsoft, and different types of charts such as bar, line, or pie charts.
Next, you'll find out how to wrap text around graphic images and divide a page into columns and text boxes. Both columns and text boxes give you different ways to display text beyond the traditional appearance of text that fills an entire page.
Finally, in the last part of this course, you'll learn about printing labels, making form letters, and creating an index, table of contents, and list of figures automatically. If you need to create long documents, you'll appreciate Word's ability to keep track of page numbers for your chapter headings or index entries.
Whether you need to produce a short letter, flyer, report, or book-length manuscript, this course will teach you how to get the most out of Microsoft Word 2010!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1840 Intermediate Microsoft Word 2013

Description: Go beyond the basics of desktop publishing with Microsoft Word 2013. In this course, you'll learn how to automate Word 2013 to help you write more while typing less. You'll also learn different ways to format text; how to add graphics to create signs, newsletters, or greeting cards; and how to generate documents with indexes and tables of content.

We'll go through tips on automating Word using macros, shortcut keys, and templates so you can create even the most complex formatted documents quickly and easily. You'll also learn how to create and organize text in tables, add graphics to a document, mix graphics and text together, and merge spreadsheet and data to create mailing labels and form letters.

Along the way, we'll go through lots of short examples and hands-on exercises so you can see how Word's advanced features work—but more importantly, you'll see how you can use these advanced features for your projects. By the end of this course, you'll know how to use Word more effectively and take advantage of all its features so you can get your work done more quickly and easily than you thought possible.
visit www.ed2go.com/conestoga for more information
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1448 Intermediate Microsoft Word 2016

Description: Go beyond the basics of word processing and master the more advanced features of Microsoft Word 2016 (now available through Office 365). In this course, you'll learn how to automate Word 2016 using shortcuts to help you write more while typing less. From signs, newsletters, and greeting cards to long documents, you'll learn how to create whatever you need—quickly and with professional-looking results.
We'll go through tips for automating Word using macros, shortcut keys, and templates so you can create even the most complex formatted documents quickly and easily. You'll also learn how to create and organize text in tables, mix graphics and text together to turn Word into a simple desktop publishing program, and merge spreadsheet and database data to create mailing labels and form letters.
Along the way, we'll go through lots of examples and exercises so you can see how Word's advanced features work; but more importantly, you'll see how you can use these advanced features at home and on the job. By the end of this course, you'll know how to use Word more effectively and take advantage of all its many features so you can get your work done more quickly and more easily than you ever thought possible.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1069 Intermediate Networking

Description: Learn real-world applications for the concepts you learned in Introduction to Networking. Continue to build your knowledge of networks and networking, with detailed treatments of TCP/IP, how switches and routers operate, DNS, and more. You'll gain a full understanding of almost every aspect of networking technology, including hot topics such as virtual private networks, security, Internet connectivity, and cloud computing. Completion of this course and its prerequisite should serve as a springboard for a career in computer networking or training for CCNA Certification.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1066 Intermediate Oracle

Description: Gain hands-on experience with Oracle's PL/SQL programming language, with expert assistance from an IT veteran. PL/SQL is Oracle's procedural language extension to Structured Query Language (SQL). This course will give you the skills you need to write powerful and flexible programs using that language. You'll learn the building blocks and core features of PL/SQL, including expressions, various iterations, and built-in functions. Then, you'll begin building fully functional PL/SQL programs with procedures, packages, debugging routines, database structures, triggers, and cursor processing. By the time you finish this course, you will be able to store PL/SQL programs in a database and execute them.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1001 Intermediate Photoshop CC

Description: Photoshop is the world's most popular photo-editing program. It's a fun and creative way to alter photographs and prepare them for print or the Web. If you're already familiar with Photoshop, this course will help you explore the program's more advanced features.

You'll master the techniques of non-destructive editing so you can re-edit, re-use, and change projects long after they were originally created (and long after the Photoshop "undo" command has expired). If you like scrapbooking or you want to make page layouts that you can fill with graphics, you'll appreciate the reusable templates you can create with Photoshop CC.

You'll also learn how to save every single pixel in your original image, and use Smart Objects to crop or resize an image and get it back to its original size months afterwards. (You'll even gets some tips on how to warp Smart Objects that will make the tabloid newspapers jealous!) And you'll see how to make adjustments to your images, such as shadowing and embossing, that can be edited at any time without destroying the original image.
Whether you want to use Photoshop to edit photos, design scrapbook pages, or do original artwork, this class will give you the building blocks you need. You'll take a giant leap forward in creativity and productivity—and you'll also have a lot of fun!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
DSGN1310 Intermediate Photoshop CS6

Description: 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). 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1047 Intermediate PHP and MySQL

Description: 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. In this six-week online course, you'll see how to create a commercial online store using the PHP programming language and the MySQL database server.
We'll walk through the steps for developing a complete online store Web application. During the course, you'll see step-by-step how to create all of the software and database objects used in the application. The application consists of two parts, an administrative Web application allowing a store manager to post new products, alter product information, and process customer orders, and a customer Web application allowing customers to browse the catalog of products, select products for purchase, and check out using a shopping cart. At the end of the course, you'll be able to use these code templates to create your own online store application.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
ACCT1480 Intermediate QuickBooks 2013

Description: Learning how to use QuickBooks to its full potential goes far beyond learning the basic features of the program. Even many experienced QuickBooks users often struggle when applying certain business situations to QuickBooks. In this course, we'll go beyond the basic introductory concepts and you'll learn how to utilize many of the more advanced 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. If your business handles inventory, you'll learn how to enter price levels and track discounts and credits. You'll even learn how to enter and track mileage that you incur on any vehicles that you use in your business.
This course also covers many other common topics that small business owners encounter. You'll learn how to create customer statements, assess finance charges on overdue balances, and write off these past due balances when it appears that the customer is not going to pay.
Lastly, you'll learn how to enter common transactions that occur between the owner and the business, including when the owner takes money out of the business or invests new capital. You'll even learn how to make journal entries to deal with those difficult situations when you may pay for a business transaction using personal cash. The course concludes with a discussion of how to track loans and how to use the budgeting feature to better plan and control your business.
This course is designed for those QuickBooks users who already feel that they have a good grasp on the basics or have successfully completed the Introduction to QuickBooks course. Whether you are a small business owner, bookkeeper, or accountant needing a QuickBooks refresher, after taking this course, you'll feel more confident and secure in accounting for your business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1876 Intermediate QuickBooks 2015

Description: Software is not included. Students will need access to a full version of QuickBooks 2015 to participate in this course.
Learning how to use QuickBooks to its full potential goes beyond learning the program's basic features. Even experienced QuickBooks users struggle when applying certain business situations to QuickBooks. In this course, we'll go beyond the basics as you master QuickBooks' more advanced features and applications.

You'll learn to manage multiple company files, export and import list data from one file to another, and make journal entries. If your business handles inventory, you'll learn how to enter price levels and track discounts and credits. You'll even learn how to track mileage on vehicles you use in your business.

This course also covers many other common topics that small business owners encounter, including how to create customer statements and assess finance charges on overdue balances, as well as how to write off past due balances when the customer won't pay.

Finally, you'll learn how to enter common transactions between the owner and the business, including when the owner takes money out of the business or invests new capital. The course concludes with a discussion of how to track loans and use the budgeting feature to better plan and control your business.

This course is designed for those who already have a good grasp on the basics of this program or have successfully completed the Introduction to QuickBooks course. Whether you're a small-business owner, or bookkeeper or accountant needing a QuickBooks refresher, this course will make you more confident and secure in accounting for your business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1563 Intermediate QuickBooks 2016

Description: Learning how to use QuickBooks to its full potential goes beyond learning the program's basic features. Even experienced QuickBooks users struggle when applying certain business situations to QuickBooks. In this course, we'll go beyond the basics as you master QuickBooks' more advanced features and applications.
You'll learn to manage multiple company files, export and import list data from one file to another, and make journal entries. If your business handles inventory, you'll learn how to enter price levels and track discounts and credits. You'll even learn how to track mileage on vehicles you use in your business.
This course also covers many other common topics that small business owners encounter, including creating customer statements, assessing finance charges on overdue balances, using QuickBooks' batch invoicing features to create multiple invoices, and writing off past due balances when the customer won't pay.
Finally, you'll learn how to enter common owner transactions, including when the owner takes money out of the business or invests new capital. You'll even learn how to deal with those difficult situations where you may pay for a business transaction using personal cash. The course concludes with a discussion of how to track loans and use the budgeting feature to better plan and control your business.
This course is designed for those who already have a good grasp on the basics of this program or have successfully completed the Introduction to QuickBooks course. Whether you're a small-business owner, or bookkeeper or accountant needing a QuickBooks refresher, this course will make you more confident and secure in accounting for your business.
PLEASE NOTE; SOFTWARE IS NOT INCLUDED WITH THIS COURSE. STUDENTS MUST HAVE A FULL WORKING COPY OF QUICKBOOKS 2016 INSTALLED AND FULLY FUNCTIONAL TO COMPLETE THIS COURSE.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1892 Intermediate QuickBooks 2017

Description: SOFTWARE IS NOT INCLUDED IN THIS COURSE, YOU MUST HAVE ACCESS TO A FULL WORKING COPY OF QUICKBOOKS 2017
Learning how to use QuickBooks to its full potential goes beyond learning the program's basic features. Even experienced QuickBooks users struggle when applying certain business situations to QuickBooks. In this course, we'll go beyond the basics as you master QuickBooks' more advanced features and applications.
You'll learn to manage multiple company files, export and import list data from one file to another, and make journal entries. If your business handles inventory, you'll learn how to enter price levels and track discounts and credits. You'll even learn how to track mileage on vehicles you use in your business.
This course also covers many other common topics that small business owners encounter, including creating customer statements, assessing finance charges on overdue balances, using QuickBooks' batch invoicing features to create multiple invoices, and writing off past due balances when the customer won't pay.
Finally, you'll learn how to enter common owner transactions, including when the owner takes money out of the business or invests new capital. You'll even learn how to deal with those difficult situations where you may pay for a business transaction using personal cash. The course concludes with a discussion of how to track loans and use the budgeting feature to better plan and control your business.
This course is designed for those who already have a good grasp on the basics of this program or have successfully completed the Introduction to QuickBooks course. Whether you're a small-business owner, or bookkeeper or accountant needing a QuickBooks refresher, this course will make you more confident and secure in accounting for your business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1066 Intermediate SQL

Description: Expand your knowledge of Structured Query Language (SQL), the industry standard database programming language.
In this course, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. First, you'll explore how to write and implement complex queries on multiple tables simultaneously and how to apply advanced filtering techniques. You'll learn to create union queries that combine records from multiple queries, and you'll discover how to use union queries to exclude or include duplicate records. In addition, you'll find out how to use text strings within union queries.
Next, you'll master advanced techniques for updating various types of data stored in your tables. You'll learn how to update a single field, multiple fields, multiple records, date fields, and calculated fields. And you'll see how to update and set NULL values using an update statement.
In addition, you'll use advanced insertion techniques to add data to your tables and learn how to create, query, and modify temporary tables. You'll also see how to implement techniques to handle duplicate values stored in a table and how to limit the results of a result set. And finally, you'll discover how to use string functions to perform complicated searches on strings, how to implement date and time functions to insert and extract portions of a date, and how to create queries that accept input from users.
By the end of this course, you'll be able to use a wide range of advanced SQL techniques with confidence. Your new skills with databases will enhance your competitiveness in the technical fields of software development and database administration.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1093 Intermediate Visual Basic

Description: Why is Visual Basic the most widely used programming language for creating Windows applications? Because it's easier to learn and faster to use than most other programming languages.
If you're a VB programmer who wants to go beyond the introductory level to create the sophisticated and powerful programs business users need, this course is for you. As we focus on database applications, you'll learn the in-demand programming skills you need to get new work in the business world.
We'll begin by discussing how to enrich the graphical user interface with custom menus and toolbars. Next, we'llC87:C88 explore multiple form applications, starting with built-in dialog controls, and then turning to helper forms and Multiple Document Interface applications.
After that, we'll deepen your understanding of databases. You'll find out how to access and modify data with data-bound controls, ADO .NET, and Structured Query Language (SQL). And we'll finish up with a survey of other areas you might be interested in studying, including information on additional SQL functionality, Web applications, and XML.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1017 Introduction to Access 2010

Description: Take control over your data! Whether you're a novice or an experienced database user, this course will show you how to harness the full power of Microsoft Access 2010.
In these practical and project-oriented lessons, you'll learn how to use this award-winning MS Office software to create and customize tables. You'll build relationships between your tables to eliminate redundancies and slash data entry time. And you'll discover how to achieve huge reductions in data entry errors by setting default values, creating validation rules, and building input masks.
In addition, you'll find out how to make your database more user-friendly with custom data entry forms, smart lists, and other sophisticated controls. You'll learn how to retrieve exactly what you need from your database with powerful queries and reports, and you'll even start automating routine tasks with labor-saving macros.
By the time you've finished this course, you'll know how to create an effective database for any information you need to store, document, and manage—at home or on the job.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1841 Introduction to Adobe Acrobat X

Description: 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!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1113 Introduction to C# Programming

Description: Learn the fundamentals of computer programming with C#, the in-demand and incredibly useful programming language that incorporates the best features of Visual Basic, C++, and Java.
You'll first develop your understanding of programming fundamentals: input/output operations, decision making, and looping. Then, we'll explore the many benefits of object oriented programming, with plenty of vivid, real-life examples.
Then, you'll gain hands-on experience with sequential data files, and you'll be able to build a professional-looking and intuitive Graphical User Interface (GUI) application on your very own computer.
Because there is no better way to learn programming than hands-on practice, almost every lesson includes practical examples and assignments you can use to develop your knowledge of programming.
Learn to program the right way: by using a state-of-the-art language to build impressive applications on your schedule and on your very own computer.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1307 Introduction to C++ Programming

Description: Learn how to program in C++ from a master programming instructor and published author. In this project-oriented course, you'll skip all the gobbledygook and get right to programming--even if you have no prior programming experience! Before you know it, you'll be putting together programs that have their own windows and controls, and you'll see how easy programming really is.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1023 Introduction to Crystal Reports 10

Description: Want to "wow" people with your business reports? In this course, you'll master the techniques the pros use to produce attractive, reader-friendly reports for any audience.
Designed for Crystal Reports XI, Crystal Reports 2008, and Crystal Reports 2011, this course will teach you how to transform the information that lies buried in your database or accounting program into clear, easy-to-understand documents.
You'll hone your Crystal Reporting skills as you get hands-on practice in extracting, sorting, and grouping your data. In addition, you'll find out how to include totals for groups of figures or for the entire report. Next, you'll master the art of building your reports and formatting your material to create a polished, professional look.
Whether you're new to Crystal Reports or want to enhance your skills, this course is ideal for you. By the time you're done, you'll be able to produce anything from a quick meeting handout to an elaborate annual report—and you'll never be intimidated by report-writing tasks again!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1205 Introduction to CSS3 and HTML5

Description: 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?
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1058 Introduction to Database Development

Description: A number of powerful tools are available to help you build databases and database applications. However, if you do not apply a systematic, structured approach to the use of those tools, you will probably produce systems that fail to meet user needs. Many projects bog down or are never completed for lack of a disciplined approach to development. This course will guide you step-by-step through all the phases of a system development project to guarantee that the resulting product will not only work as it was designed to work, but also that the design truly responds to user needs.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1224 Introduction to Digital Scrapbooking

Description: Learn to use digital editing techniques to show off your photos and memorabilia in Introduction to Digital Scrapbooking! Using Photoshop Elements 11, 12, or 13, this course will teach you how to make the most of your scrapbooking talents and artistic ideas when you combine traditional and digital scrapbooking.
Starting with simple projects, you'll quickly learn how to build pages, use artistic journaling, and produce sophisticated illusions. Photoshop Elements lets you build your own clip art, create frames, and develop multi-layer pages with an endless array of layouts and designs.
You'll see how to draw and create your own art, build collages and scrapbooks to share, and work with both color and black and white. If you need to restore or age images—the tools are all available to you.
Join us and take your scrapbooking to a new level!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1643 Introduction to Google Analytics

Description: Nearly every business and non-profit organization has a website, and probably a Facebook page and a YouTube channel. Individuals have them too, to promote ideas, to share a vision, or to educate the public. No matter what brings you to the Web, your hope is that a lot of people see your website, your wall, your tweets, and your videos. Why else go to the trouble of sharing them?
In this course, you'll learn to use Google Analytics to make the most of your online traffic. You'll see how you can track not just the traffic to all of your online content, but also determine which content is the most appealing, where your visitors came from, what devices they used, how long they stayed, which links they clicked, and where they went when they left.
The course guides you step by step, report by report, through the major parts of the Google Analytics interface. From setting up your Google Analytics account and getting the all-important code you'll need to add to your website's pages to begin tracking your visitors, you'll learn everything you need to know to get everything you can from the data that Google Analytics provides. You'll even find out about Google AdWords and other tools to enhance your traffic as well as your Google Analytics reporting.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1730 Introduction to Illustrator CS6

Description: If you want to get a job as a graphic artist, you need to learn Adobe Illustrator. In this course, you'll see how Adobe Illustrator CS6 can give you the power to design, draw, and color images quickly and easily.
From drawing objects with the shape tools to mastering the all-important Pen tool to working with shape gradients, you'll gain the techniques you need to produce stunning vector graphics. You'll learn to apply and work with color, create shading effects and painterly brushstrokes, and add special effects such as 3D to your drawings that will set your work apart. You can also easily move designs back and forth between Photoshop and Illustrator to take advantage of the strengths of both programs.
Each lesson contains an assignment that challenges both your creativity and your growing skill with the program. The course is designed to let you work at your own level, whether you're just getting started with Illustrator or looking to refresh your Illustrator skills. Come experience the fun of Adobe Illustrator!
Visit www.ed2go.com/conestoga for more information.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1945 Introduction to InDesign CC

Description: Have you ever seen a terrific-looking brochure or newsletter and wondered how it was made? Chances are the designer used Adobe InDesign CC, the industry-standard desktop publishing software now available through the Creative Cloud. The course is applicable to any version of InDesign CS4 or newer.

In each lesson, we'll cover an important aspect of InDesign CC as you prepare a range of print and online products for a fictional company, Natalie's Nautical Emporium. You'll get dozens of files to work with, including a partially completed InDesign document used to start each lesson. Then you'll use the downloaded graphics, images, fonts, and other content to complete the project. And to check your work or troubleshoot any problems you encounter, you'll always get a copy of the finished InDesign project file.

Lesson by lesson, you'll discover how the program features relate to producing actual usable documents as we explore the best ways to create different types of material, how to reuse items such as colors and artwork, and how to produce publications for different page sizes and devices. You'll come away knowing how to use this popular page layout software to design and create professional-quality letterhead, business cards, brochures, forms, interactive PDF files, an eBook, and more. You don't have to be a designer or an artist to produce professional quality documents!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1955 Introduction to InDesign CS6

Description: In this Adobe InDesign CS6 class, you'll get hands-on desktop publishing training and come away knowing how to use this popular page layout software program to design and create professional-quality letterhead, business cards, brochures, PDF files that play movies, and more. You'll discover that you don't have to be a designer or an artist to produce professional-quality documents!
In each lesson, we'll cover an important aspect of InDesign CS6 as you prepare a range of print and online products for Natalie, the fictional owner of Natalie's Nautical Emporium. You'll get dozens of files to use in the lessons—partially completed InDesign files, as well as the graphics, images, fonts, and other content required for the project. And to check your work or troubleshoot any problems you encounter, you'll always get a copy of the finished InDesign project file.
Lesson by lesson, you'll explore the best ways to use the features in this program to create different types of material, how to organize and name your files, and how to reuse items such as colors and artwork. By the time you finish the course, you'll not only be comfortable with the tools and features that InDesign CS6 offers, you'll also know the most efficient ways to use the program to produce the materials you need for your own work, recreation, or hobbies.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1062 Introduction to Java Programming

Description: If you want to learn computer programming but don't have any prior experience, you'll enjoy a tour of Java, one of the most widely used computer languages in the world. It's a breeze to learn in a friendly and supportive environment. Start with the basics of programming and go on to write your own programs and integrate input and output, calculations, decision making, and loops. Build your knowledge and confidence with easy-to-understand examples and plenty of skill-building exercises. So whether you just want to try it out to see if you like it or plan on doing more with Java, this is a great place to start!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1072 Introduction to JavaScript

Description: You may already know how to use HTML and CSS to create websites. If so, you're ready to add more power to your programming with JavaScript. This programming language lets you add interactivity to your pages by creating features such as buttons, picture carousels, and collapsible panels to your Web pages.

The course begins with the basics of JavaScript code and then moves on to more advanced topics. You'll learn how to define what happens when a user clicks a button or presses a key on your pages, and see how JavaScript enables your pages to make "if . . . then . . . else" decisions about what to do based on circumstances. You'll also get a chance to try out loops and timers to create animation effects. Throughout the course, you'll get plenty of hands-on practice to give you the experience you need to really understand how JavaScript works.
And since no JavaScript course would be complete without a discussion of jQuery, we cover it as well. This free "write less, do more" JavaScript library has become virtually synonymous with modern Web and mobile app development. By the end of the course, you'll understand how to use jQuery to catapult your basic JavaScript knowledge to incredible new heights.
This course assumes students already know HTML and CSS. JavaScript is always used with these two programming languages, not as an alternative to them.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1980 Introduction to Lightroom 5

Description: Do you have a lot of images to manage? Adobe Photoshop Lightroom 5 is a fantastic tool for any digital photographer who needs to edit and sort images quickly. Whether you're a busy parent shooting lots of pictures or a professional photographer with many clients, Lightroom 5 will help you get the results you want in a lot less time.
In this course, you'll see how Lightroom 5 can help you prepare, edit, and organize your photos quickly and effectively. Using Lightroom 5's non-destructive editing, you'll be able to control how you edit your images and make additional alterations later. You'll learn to apply changes to multiple images while developing an efficient image processing workflow. You'll also see how to organize, tag, and make collections with Lightroom's powerful organization tools; create customized slideshows and presentations; and fine-tune the overall color and lighting of your images. You can use Lightroom 5 as a companion to Photoshop, Photoshop Elements, or other digital photo editors, and you can export or print your work in exactly the size or format you need.
So put some polish on your photos, save time, impress clients, and stay organized as you unlock the mysteries of Adobe Photoshop Lightroom 5. The hands-on, easy-to-follow exercises in this course will help you perfect your collections of digital photos!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1082 Introduction to Lightroom CC

Description: Do you have a lot of images to manage? Adobe Photoshop Lightroom is a fantastic tool for digital photographers at any skill level who need to manipulate and organize photos images.
This course will teach you how to use Lightroom Classic CC, Adobe's easy-to-use software that prepares, edits, and organizes photos quickly and effectively. Through hands-on exercises, you will learn to use Lightroom Classic CC like a pro and perfect your digital photos!
Note: Adobe offers two versions of Lightroom CC: Lightroom Classic CC and Lightroom CC. This course is written for Lightroom Classic CC only.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1985 Introduction to Microsoft Access 2013

Description: Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2013 to organize, store, edit, manage, and report on hundreds of thousands of records.
You'll start with the basics of database concepts and structure, and learn to build and customize tables to store data. With that foundation in place, you'll then learn about relational databases, and see how you can use them to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables—often with just a few clicks of your mouse! You'll also discover how to use macros to automate repetitive tasks and increase your efficiency.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1432 Introduction to Microsoft Access 2016

Description: Take control of your data! In this course, you'll learn how to harness the power of Microsoft Access 2016 to organize, store, edit, manage, and report on hundreds of thousands of records.
You'll start with the basics of database concepts and structure, and learn to build and customize tables to store data. With that foundation in place, you'll then learn about relational databases, and see how you can use them to build forms, generate reports, and search for data with queries across thousands of records in hundreds of tables—often with just a few clicks of your mouse! You'll also discover how to use macros to automate repetitive tasks and increase your efficiency.
Through easy-to-follow, step-by-step instructions, this course will help you master Access and put it to creative, confident use. You'll develop not only strong Access skills, but a solid understanding of good database design concepts. By the time you've finished the course, you'll know how to organize and assemble an effective database for any kind of information you need to store, document, and manage.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1378 Introduction to Microsoft Excel 2007

Description: Work with numbers? Then you need to learn Excel 2007. In this unique six-week online workshop, you'll discover dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas, using the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. You'll also learn the best ways to sort and analyze data, create custom charts and graphs, create 3-dimensional workbooks, build links between files, endow your worksheets with decision-making capabilities, and automate oft-repeated tasks with macros and buttons.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
COMP1004 Introduction to Microsoft Excel 2010

Description: Do you work with numbers? Then you need to master Microsoft Excel 2010—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.
These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons.
This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2010 tool like a pro.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1217 Introduction to Microsoft Excel 2013

Description: Do you work with numbers? Then you need to master Microsoft Excel 2013—and this is the place to do it. Even ""non-techie"" beginners will find it easy to learn Excel in this fun, step-by-step online course. These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more. In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers the new Quick Analysis, Flash Fill, and charting capabilities available in Excel 2013. This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2013 application like a pro.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1434 Introduction to Microsoft Excel 2016

Description: Do you work with numbers? Then you need to master Microsoft Excel 2016 (now available through Office 365)—and this is the place to do it. Even "non-techie" beginners will find it easy to learn Excel in this fun, step-by-step online course.
These lessons will teach you dozens of shortcuts and tricks for setting up fully formatted worksheets quickly and efficiently. You'll also learn the secrets behind writing powerful mathematical formulas and discover how to use the function wizard to quickly and automatically calculate statistics, loan payments, future value, and more.
In addition, you'll get tips on sorting and analyzing data, designing custom charts and graphs, creating three-dimensional workbooks, building links between files, endowing your worksheets with decision-making capabilities, and automating frequently-repeated tasks with macros and buttons. This informative course covers Quick Analysis, Flash Fill, and powerful charting capabilities available in Excel 2016.
This is not a tutorial, but an in-depth class where you'll get training, help, and personal support from an experienced instructor as you're learning Excel basics step-by-step. By the time you're done, you'll be using this vital Office 2016 tool like a pro.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1219 Introduction to Microsoft Outlook 2013

Description: Want to learn Microsoft Outlook 2013 quickly? Want to become a confident and productive user of this powerful program without having to memorize a lot of technical mumbo-jumbo? In this course, you'll see what's new in Outlook 2013 and get up and running with the most important aspects of the program, starting with mastering the new Windows 8 style look and feel. From there, you'll quickly learn how to manage your email, calendar, and contacts, and how to streamline and automate your work with keyboard shortcuts, rules, Search Folders, and Quick Steps.
The goal of this course is to teach you what you really need to know to be productive with Outlook 2013. That means you won't waste your time on low-value aspects of Outlook. Instead, you'll focus on the important things like sending, receiving, and managing your mail, and using tools such as the calendar, tasks, and to-dos so you can manage your schedule and get your work done. You'll also learn about the redesigned Contacts section of Outlook (now called People). You'll discover how Outlook can connect to your social networks, and discuss the pros and cons of making those connections.
The course also shares secrets about how to get the most from Outlook. For example, did you know that you can create, send, and receive email messages without ever touching the mouse? It's faster and more efficient, and can even reduce some of the strain on your aching mouse hand. Introduction to Outlook 2013 dedicates an entire lesson to the instructor's favorite Outlook tips and tricks. Whether you're new to Outlook or you've been using it for years, you're sure to learn something useful in every lesson.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1885 Introduction to Microsoft PowerPoint 2013

Description: Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2013 or PowerPoint 365 to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.
You'll see how to plan a presentation for your audience, format it with themes and color, and use slide and layout masters to make global changes. You'll embellish your slides with text and objects, including pictures, shapes, WordArt, and SmartArt, and learn to add multimedia effects to create animated presentations.
And that's just the start! With this PowerPoint training, you'll explore the options on the PowerPoint Ribbon, including the new Online Pictures command, File menu options, and Backstage View, and you'll learn how to print slides, handouts, and even an outline. And you'll discover the best view for creating and editing your slides and running your presentations.
You'll have fun creating a PowerPoint photo album with your digital pictures, and become acquainted with OneDrive and PowerPoint Online to save, edit, and share your presentations online. Finally, you'll add versatility to your PowerPoint skills as you learn how to use the new Share and Export commands to save presentations as PDF files, videos, and more. If you want to become a PowerPoint pro, this is the course for you!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1457 Introduction to Microsoft PowerPoint 2016

Description: Take your PowerPoint presentations from ordinary to extraordinary! In these lessons, you'll learn how to use Microsoft PowerPoint 2016 (now available through Office 365) to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.
You'll start by learning how to plan and create dazzling slide presentations using a variety of slide and layout masters that make global changes to your presentation in a snap. You'll also see how to embellish your slides with pictures, shapes, WordArt, and SmartArt, as well as multimedia effects such as animations, slide transitions, audio, video, and text and object hyperlinks.
And that's just the start! You'll explore the options on the PowerPoint Ribbon, including the new Tell Me feature (an enhanced Help feature) and Smart Lookup, which allows you to look up definitions of a word or phrase. You'll explore the File menu options and Backstage View, and learn how to print slides, handouts, and even an outline. And you'll discover the best view for creating and editing your slides and running your presentations, including how to use Reading View to proof your work.
You'll have fun creating a PowerPoint photo album with your digital pictures, and become acquainted with OneDrive and PowerPoint Online to save, edit, and share your presentations online. Finally, you'll add versatility to your PowerPoint skills as you learn how to use the Share and Export commands to save presentations as PDF files, videos, and more.
Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1007 Introduction to Microsoft Project 2010

Description: Discover how to effectively plan, implement, and control projects using Microsoft Project 2010. In these lessons, you'll learn how to use Microsoft Project to think through and organize your project's details, plan a schedule, sequence tasks, produce a baseline, assign resources and costs, track your progress, identify and analyze variances, and revise your project plan.
Once you've constructed a basic schedule, you'll see how to enlarge it and share it with clients and co-workers. In addition, you'll learn Microsoft Project's techniques for fine-tuning different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates.
The knowledge you gain from this course will help you avoid going down dead-end alleys and prevent you from overloading your schedule. If you encounter trouble on your project, you'll be able to apply a number of powerful problem resolution techniques to help get your project back on track.
No matter how complex your projects are, Microsoft Project will help you cut them down to size. By the end of the course, you'll be able to produce project plans that wow your audience and empower you to achieve your business goals.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1045 Introduction to Microsoft Project 2013

Description: Discover how to effectively plan, implement, and control projects using the world's most popular project management software, Microsoft Project 2013. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress, analyzing variances, and revising your project plan, Microsoft Project can help you organize all your project's details quickly and effectively.
In this course, you'll master the basics of Microsoft Project 2013 so you can create a project schedule in no time flat and then share it with clients and co-workers. Using the program's different views, such as the Calendar and Gantt chart views, you'll be able to manage your project information and produce effective reports. Armed with this information, you'll avoid going down dead-end alleys and overloading your schedule. And should you encounter trouble, you'll master a number of tried-and-true problem-resolution techniques to help get your project back on track.
You'll also learn how to fine-tune different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates. After completing the course, you'll know how to develop, implement, and control a project plan that meets organizational and customer objectives.
SOFTWARE IS NOT INCLUDED IN THIS COURSE. STUDENTS MUST HAVE A FULLY WORKING COPY OF MS PROJECT 2013 TO COMPLETE THIS COURSE.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1493 Introduction to Microsoft Project 2016

Description: Discover how to effectively plan, implement, and control projects using Microsoft Project 2016. From sequencing tasks, producing a baseline, and assigning resources and costs, to tracking progress, analyzing variances, and revising your project plan, Microsoft Project can help you organize all your project's details quickly and effectively.
In this course, you'll master the basics of Microsoft Project 2016 so you can create a project schedule in no time flat and then share it with clients and co-workers. Using the program's different views, such as the Calendar and Gantt Chart views, you'll manage your project information and produce effective reports. Armed with this information, you'll avoid going down dead-end alleys and overloading your schedule. And should you encounter trouble, you'll master a number of tried-and-true problem-resolution techniques to help get your project back on track.
You'll also learn how to fine-tune different aspects of your project, including splitting tasks for work interruptions and defining material consumption rates. After completing the course, you'll know how to develop, implement, and control a project plan that meets organizational and customer objectives.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1703 Introduction to Microsoft Publisher 2013

Description: In this course, you'll learn to use Microsoft Publisher 2013 to create impressive publications. It's perfect for beginners who want to learn how to produce professional-quality newsletters, fliers, letterheads, and brochures.
You'll start by learning how to navigate the Publisher workspace using the ribbon, and how to access both local and online Publisher templates. Next, you'll find out how to create and manage text, pictures, graphics, and other elements, such as tables and shapes, and see how you can use these different components to create a variety of documents.
As the course progresses, you'll learn about different kinds of publications Publisher can help you produce. You'll see how to create documents from scratch, but you'll also learn how to modify existing templates so you can create customized documents more easily. Finally, you'll learn all about printing your publications and how to share Publisher documents electronically.
Once you learn how to manage Publisher tools and features and how to design effective publications, you'll be able to create anything you might need. Introduction to Publisher 2013 is a course that will help you do just that!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1396 Introduction to Microsoft Word 2007

Description: Learn to use the word processor PC Magazine ranked as one of the 'strongest and most intelligent programs ever written.' In this hands-on workshop, you'll learn how to add, move through, and edit text, move words from one part of your document to another, work on two or more documents simultaneously, change the size or appearance of text, change margins and tab settings, automatically center, right align, justify, and indent text; run the integrated grammar and spelling checker; use the thesaurus, and save, retrieve, copy, organize, and print your documents.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Closed
COMP1011 Introduction to Microsoft Word 2010

Description: Master the basics of the word processor PC Magazine ranked as one of the “strongest and most intelligent programs ever written.” In this hands-on workshop, you'll learn how to add, move through, and edit text; move words from one part of your document to another; work on two or more documents simultaneously; change the size or appearance of text; change margins and tab settings; automatically center, right align, justify, and indent text; run the integrated grammar and spelling checker; use the thesaurus; and save, retrieve, copy, organize, and print your documents. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be able to use Word confidently at home or on the job.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1447 Introduction to Microsoft Word 2016

Description: One of the most basic skills needed in any job is writing reports and letters using Microsoft Word 2016 (now available through Office 365). In this course, you'll gain the foundational skills you need to make the most of this powerful program.
Through hands-on instructions, you'll learn how to add and edit text; move words from one part of your document to another; work on two or more documents simultaneously; and format your text. You'll also see how to save, retrieve, copy, organize, and print your documents.
You'll learn dozens of ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. If you need to type foreign language characters or symbols, you can do that in Word too.
By using Word's spell and grammar checker, you can catch typos and grammatical mistakes before you print or share your document with others. You'll also explore the program's thesaurus feature, which can help you find exactly the right word. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be able to use Word confidently at home or on the job.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1068 Introduction to Networking

Description: Introduction to Networking explains computer networking basics in terms that you can easily understand, using concepts common to everyday, non-computing experience. A brief introduction to networking history provides context, explaining how networks have become so important to businesses and individuals. The course emphasizes networking fundamentals, explaining the software and hardware that makes networking possible. The course stresses understanding how and why networks work, rather than focusing on memorization of terms or numbers.
Upon completion of the course, you will be capable of performing basic computer networking tasks, such as DSL connectivity or configuring connections to an Internet Service Provider. This course will give you the foundation you need to begin training for CCNA Certification or employment in a computer networking career.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1065 Introduction to Oracle

Description: Learn how to use the Oracle database management system to plan, organize, and manage your data. Introduction to Oracle will provide you with a practical hands-on approach to relational databases concepts and Oracle's database management system. This course will introduce you to the Structured Query Language (SQL), Oracle's SQL*Plus, and other valuable tools used to develop, manage, and reference an Oracle database.
In this six-week online course, you will learn how to create an Oracle database, build various database objects for the database, and write simple SQL statements that access the data from the database. This course will teach you how to write Data Definition Language statements to create, update, and delete database objects. You will learn how to execute Data Control Language statements to give or delete access rights to database objects. You will write Data Manipulation Language statements to insert, update, and delete records from a database. Finally, you will learn how to query the data and create finished reports.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1102 Introduction to Outlook 2010

Description: Are you overwhelmed by emails, meetings, and to-do lists? Harness the power of Microsoft Outlook 2010, and you'll instantly enhance your efficiency and productivity.
In this course, you'll learn your way around the new ribbon-based interface and get up and running quickly. Then you'll focus on the core skills you really need in order to work smarter and faster.
First, you'll learn how to manage the flood of emails you receive, creating folders and archives so you can always find what you need. Then you'll discover how to keep track of your contacts and how to use Outlook's Calendar and Alert features. You'll also find out how to customize Outlook so it perfectly meets your needs, and you'll discover how to automate your work with rules.
As a bonus, you'll get insider tips that will make you the Outlook guru in your office. For example, did you know that you can create, send, and receive email messages without ever touching the mouse? You'll find out how, and learn lots of other tricks for getting the most out of Outlook's versatile tools.
Whether you're new to Outlook or you've been using it for years, you're sure to learn something useful in every lesson. In just a few weeks, you'll be a skilled and confident user of this time-saving tool—and you'll never have to worry about missing a meeting, losing an email, or forgetting an important task again!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1880 Introduction to PC Security

Description: What you don't know about PC security really can hurt you! Learn why you're at risk and what you can do to protect your precious personal and business data from the outside world. This course, taught by a security expert, will quickly bring you up to speed on the fundamentals of PC and network security.
You'll understand and explore the many vulnerabilities of operating systems, software, and networks. Then, you'll get into the minds of hackers and crackers, developing an understanding of the exploits they use to access your computer without your knowledge. You'll find out why, where, and how viruses, worms, and blended threats are created. You'll be able to identify and work to prevent DoS, SYN flooding, and other network attacks. You'll learn a safe way to share files and data across the Internet through a virtual private network. And you'll be able to install and configure a firewall to build an impenetrable moat around your computer or network.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1032 Introduction to PC Troubleshooting

Description: Don't spend your hard-earned cash on expensive PC repairs! The vast majority of the problems people experience with their computers are completely avoidable, and most can be solved with nothing more than a few minutes of your time. Intro to PC Troubleshooting takes you step by step through the typical hardware and operating system problems encountered by technicians, teaching troubleshooting techniques to decipher any problem, and giving you the skills you need to solve them. Once you've mastered the basics, the course launches into some of the more advanced and nasty problems that crop up in the PC, teaching you how to diagnose and fix those problems as well! Finally, Intro to PC Troubleshooting shows you how to maintain and optimize a Windows PC. So what are you waiting for? Let's troubleshoot - and fix - some PCs!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
DSGN1260 Introduction to Photoshop CS5

Description: Photoshop is the world's best-known photo-editing program—the tool that artists, photographers, designers, and hobbyists all rely on for image creation and editing. In this course, you'll learn how to use Photoshop with skill and confidence, even if you're a beginner.

You'll get detailed, step-by-step instructions from an expert and columnist for Photoshop User magazine who's twice been nominated for the Photoshop Hall of Fame. You'll have no trouble following each step—even if you've never used a computer for graphics before. And you'll have lots of fun putting your new skills into action in this project-oriented course.

Adobe Photoshop CS5 has a host of impressive new features for photographers, and you'll get to know several of them in these lessons. You'll begin with an introduction to the Photoshop environment. Next, you'll learn how to create simple digital paintings and find out about the new brushes that let you alter a photo to achieve the look of an oil painting.
After that, you'll edit your own photos to get rid of dust and scratches, fix the color, and correct the image exposure. You'll also learn how to switch the backgrounds in images and how to remove wrinkles and blemishes from photos, just like professionals do in magazines.

By the time you finish this fun, hands-on course, you'll be well on your way to expressing yourself with the most exciting graphics program ever developed.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
DSGN1061 Introduction to Photoshop CS6

Description: Photoshop is the world's best-known photo-editing program. Artists, photographers, designers, and hobbyists all rely on Adobe Photoshop for image creation and editing. Discover the fastest and most effective ways to use Photoshop from an expert and former columnist for Photoshop User magazine. You'll learn how to use Photoshop with detailed, step-by-step instructions that you'll have no trouble following—even if you've never used a computer graphics program before! And you'll have a lot of fun doing it.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1045 Introduction to PHP and MySQL

Description: Learn how to create an interactive Web site, allowing visitors to post and retrieve information provided by you or your site's visitors. In this six-week online course, you'll see how to create dynamic Web pages using the PHP programming language and the MySQL database server.
During the course, you'll walk through the development of a complete content management system Web application. You'll receive clear, step-by-step, instructions demonstrating how to create a complete Web site capable of dynamically displaying data from a MySQL database.
You'll discover how you can allow your site's visitors to add new information to an online database, search through posted data, and create meaningful printed reports. By the end of this course, you'll have plenty of useful code templates that will help you create your very own dynamic, Web-based, content management system.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1107 Introduction to PowerPoint 2010

Description: Take your PowerPoint presentations from "so-so" to sensational! In these lessons, you'll learn how to use Microsoft PowerPoint 2010 to create professional-quality slide presentations that grab and hold your audience's attention from start to finish.
First, you'll explore the latest features of PowerPoint, from the all-new File menu to the Backstage View. After that, you'll find out how to create dazzling presentations formatted with themes and a variety of slide layouts. You'll embellish your slides with text, objects, SmartArt, multimedia, animation, sound, charts, clip art, and hyperlinks, and you'll discover that global changes are a snap with the Slide Master.
In addition, you'll find out how to download an online image and insert it onto a slide. You'll also discover how to edit clip art, images, WordArt, and shapes easily with the commands on the Ribbon. You'll explore the printing interface in Backstage View, and find out how to view your presentations in the new Reading View.
And that's just the start! You'll also learn how to create a PowerPoint photo album with your digital pictures, and you'll work with PowerPoint Web App—an online version of PowerPoint. Finally, you'll add versatility to your PowerPoint skills as you learn to save presentations as PDF files and videos.
Whether you're a beginner or an experienced user, these lessons will teach you how to turn simple slides into a polished and exciting presentation that will make your message memorable. If you want to take your PowerPoint skills to a higher level, this is the course for you!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1865 Introduction to Publisher 2010

Description: In this course, you'll learn to use Microsoft Publisher 2010 to create impressive publications. It's perfect for beginners who want to learn how to produce professional-quality newsletters, fliers, letterheads, and brochures. You'll start by learning how to navigate the Publisher workspace using the ribbon, and how to access both local and online Publisher templates. Next, you'll find out how to create and manage text, pictures, graphics, and other elements, such as tables and shapes, and see how you can use these different components to create a variety of documents. As the course progresses, you'll learn about different kinds of publications Publisher can help you produce. You'll see how to create documents from scratch, but you'll also learn how to modify existing templates so you can create customized documents more easily. Finally, you'll learn all about printing your publications and how to share Publisher documents electronically. Once you learn how to manage Publisher tools and features and how to design effective publications, you'll be able to create anything you might need. Introduction to Publisher 2010 is a course that will help you do just that!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
PROG1255 Introduction to Python 3 Programming

Description: Enhance your résumé by adding Python to your programming skills! The Python programming language was developed to provide a way to develop code that's easy to create and understand. While Python contains the same basic structures as other languages, it also offers unique functionality that makes your life as a programmer easier.
This course will show you how to create basic programming structures including decisions and loops. Then you'll move on to more advanced topics such as object-oriented programming with classes and exceptions. In addition, you'll explore unique Python data structures such as tuples and dictionaries. You'll even learn how to create Python programs with graphic elements that range from simple circles and squares to graphical user interface (GUI) objects like buttons and labels.
Whether you're interested in writing simple scripts, full programs, or graphical user interfaces, this course will give you the tools you need to use Python with skill and confidence.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
ACCT1470 Introduction to QuickBooks 2013

Description: Learn how to quickly and efficiently gain control over the financial aspects of your small business with this powerful accounting software program. In 12 lessons, you'll master the tools you'll need to set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports. With QuickBooks, you get the same ease of use of Quicken coupled with a more traditional approach to accounting to meet the needs of small to midsized businesses. Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of financial accounting for your business. Software is not included in this course. Students need to have a fully activated copy of QuickBooks 2013 to participate in this course.
Visit www.ed2go.com/conestoga for more information.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1667 Introduction to QuickBooks 2014

Description: Software is not included. You will need to have access to a computer with Quickbooks 2014 to complete this couse.

Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small to midsized business owner who enjoys Quicken's ease of use but prefers a more traditional approach to accounting.
You'll gain hands-on experience as you learn how this well-designed accounting program can make it a snap to set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.
Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1026 Introduction to QuickBooks 2015

Description: Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.
In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.
Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1668 Introduction to QuickBooks 2016

Description: Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.
In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.
Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.
SOFTWARE IS NOT INCLUDED WITH THIS COURSE. STUDENTS MUST HAVE A FULLY FUNCTIONAL AND WORKING COPY OF QUICKBOOKS 2016 TO COMPLETE THIS COURSE.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1891 Introduction to QuickBooks 2017

Description: Learn to manage the financial aspects of your small business quickly and efficiently with this powerful accounting software program. QuickBooks is designed especially for the small- to midsized-business owner who needs a fully functional accounting system that's also easy to use.
In 12 lessons, you'll gain hands-on experience as you master the tools you need set up a chart of accounts; reconcile your checking account; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; and generate reports.
Whether you're new to QuickBooks or have already used earlier versions of this accounting software program, this course will empower you to take control of the financial accounting for your business.
SOFTWARE IS NOT INCLUDED IN THIS COURSE. YOU MUST HAVE ACCESS TO A FULL COPY OF QUICKBOOKS 2017
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1533 Introduction to QuickBooks Online

Description: In this course, you'll learn to manage the financial aspects of your small business quickly and efficiently using QuickBooks Online. This powerful accounting software program has helped thousands of business owners just like you manage their finances. With the online version, you also gain all the advantage of computing in the cloud, so that your files will be available to you virtually anytime, anywhere.

As we explore the pros and cons of online accounting, you'll soon see how easy it is to use the navigation features of QuickBooks Online. Then you'll gain hands-on experience as you learn all the ways this well-designed accounting program makes it a snap to manage your business' finances—from recording income and expenses, to entering checks and bank transfer entries, to setting up a chart of accounts. You'll see how to reconcile your checking account and manage credit card and loan payments; create and print invoices, receipts, and statements; track your payables, inventory, and receivables; create estimates; generate reports; and much more.

Whether you're new to QuickBooks or have already used other versions of this software program, this course will empower you to take control of the financial accounting for your business, all with the ease and convenience of an online platform.

PLEASE NOTE; When your course starts, you will be directed to access and utilize the free QuickBooks Online PRACITCE site to complete the lessons and assignment steps. This site requires that you have access to the internet and that you have a common web browser installed, such as Explorer, Firefox or Chrome. You do not need to purchase a subscription or additional software to complete this course.

However, please note that this course is suitable only for the QuickBooks Online version. The desktop versions of QuickBooks are not compatible with this course and should not be used. If you have the desktop version, you should consider registering for the course specifically designed for your version.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1094 Introduction to SQL

Description: Learn the key concepts of Structured Query Language (SQL), and gain a solid working knowledge of this powerful and universal database programming language.
In this course, you'll learn about the basic structure of relational databases and how to read and write simple and complex SQL statements and advanced data manipulation techniques. First, you'll learn about the traditional database structure, the structure and history of the relational database, and what structured query language (SQL) is and how it relates to the relational-database structure.
Next, you'll discover how to use SQL to filter retrieved data and how to use SQL to sort and retrieve data from tables. You'll learn how to reformat retrieved data with calculated fields and how to merge columns and create alternate names for columns. You'll also learn how to gather significant statistics from data using aggregate functions, and you'll see how to extract data from multiple tables simultaneously using joins and subqueries. In addition, you'll learn how to manipulate data using the INSERT, UPDATE, and DELETE statements.
We'll also cover how to use SQL to create and maintain tables, and you'll learn how to create and use views to simplify complex queries, summarize data, and manipulate data stored in tables. You'll discover how transaction processing, constraints, and indexes are implemented in SQL. And finally, you'll discover how stored procedures, triggers, and cursors are implemented in SQL.
By the end of this course, you'll have a solid working knowledge of structured query language. You'll feel confident in your ability to write SQL queries to create tables; retrieve data from single or multiple tables; delete, insert, and update data in a database; and gather significant statistics from data stored in a database.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1043 Introduction to Visual Basic

Description: Visual Basic is the most widely used programming language for creating Windows applications. Why? Because it's easy to learn, and doesn't require you to memorize difficult commands like other programming languages. In this course, you'll learn how to write Windows applications and programs using the Visual Basic programming language and the Visual Basic development environment.
Creating a Windows application ordinarily requires you to write lengthy and complex code. But, as you'll see, the Visual Basic development environment relieves you of this task. Instead, it enables you to create the application program and its components literally with the click of a button or menu item. It even writes all of the necessary code to get the application started for you, which you can then view and fine-tune.
Over the course of 12 lessons, you'll learn the building blocks of programming, including using variables to store data, control structures, and loops. You'll find out how to use the large function library built into Visual Basic, including the .NET Framework, as well as how to write and use your own functions. You'll also see how to use Windows' large and varied library of controls and how to access files and handle errors. And since Windows applications are event-driven and everything in Visual Basic is treated as a programmable object, you'll learn about event-driven and object-oriented programming—concepts that are important not just in Visual Basic, but in other programming languages as well.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1669 Introduction to Windows 10

Description: Welcome to Windows 10, the completely new operating system from Microsoft, which offers a more robust, more powerful, and completely unique computing experience. In this course, you'll gain the foundation you need to get started right away using Windows 10.

We'll begin with the basics: finding your way around the operating system. You'll get to know the expanded Start menu, desktop, and system settings so you can feel right at home. Next, you'll learn to customize the features of this operating system and personalize your desktop so you can make your computer truly your own.

Then we'll take a look at files. You'll see how File Explorer can help you manage your files, and learn to create basic text documents using WordPad. From to finding files and folders, to organizing and editing photos, to managing files on external drives, you'll learn everything you need to know about getting the most from this operating system. And since security is important, you'll also learn how to protect your files, as well as how to protect and update Windows 10. You'll even see how to use the new Microsoft Edge browser to access the Internet.

By the time you finish this course, you'll have mastered the basic skills you need to get the most from Windows 10 for both work and play.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1079 Introduction to Word 2013

Description: Knowing how to write reports and letters using Microsoft Word is a basic skill needed in nearly any job. This powerful word-processing program lets you professionally type, edit, format, spell check, and print documents.

In this course, you'll master all the basics of Microsoft Word. You'll learn how to add, move through, and edit text; move words from one part of your document to another; work on two or more documents simultaneously; change the size or appearance of text; change margins and tab settings; automatically center, right align, justify, and indent text; use tools such as the grammar checker, spell checker, and thesaurus; and save, retrieve, copy, organize, and print your documents.

You'll also learn dozens of different ways to modify the appearance and content of your documents by adjusting page margins, paragraph tab settings, and line spacing to create great-looking documents quickly and easily. By the time you're done with the step-by-step lessons and hands-on activities in this course, you'll be able to use Word confidently at home or on the job. visit www.ed2go.com/conestoga for more information
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1078 Introduction to XML

Description: XML is today's most popular way to store and send information. In this course, you'll master the essentials of XML through easy-to-follow, real-world examples. Even if you've never tried computer programming, you'll discover how quickly you can learn to produce powerful "code." And the biggest surprise is how much fun programming can be!

From the very first lesson, you'll dive in, creating your first XML document. You'll use one of the greatest bargains in computer programming—Microsoft's free yet powerful Visual Studio (VS) Express. Then you'll go on to learn the elements of programming: variables, loops, and branching. Using VS's full-featured design editor, you'll see how to build efficient, professional-looking user interfaces.

XML stores and transmits information for applications, but is also widely used with Internet browsers like Chrome and Internet Explorer. You'll learn methods for formatting XML so it looks great on Web pages using cascading style sheets and XSL. And you'll explore all the main XML techniques—XPath, XSL, schemas, namespaces, DOM, and SAX. You'll practice using XML to search, manipulate, validate, and merge XML files. We'll also work with SVG, XML's drawing language for displaying graphics like charts, drawings, and diagrams.

Finally, you'll deepen your understanding of XML and programming by transforming the cookbook program into two equally useful programs. First is an all-purpose quiz that will help anyone practice for any kind of test—geography, driver's test, whatever. And the second program is a coin-collection scrapbook with over a dozen fields of information (and optional photographs) for each coin. This program, too, can be easily modified to manage any kind of collection—stamps, rocks, baseball cards, anything.
When you've finished this course, you'll also understand how XML simplifies computer programming, and you'll have built a surprisingly sophisticated cookbook program that displays, modifies, searches, imports, and deletes recipes stored in XML format. It's your first step toward writing custom programs or furthering your career!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1238 LPI Linux Essentials Exam Preparation

Description: The Linux Professional Institute (LPI) Linux Essentials exam is an industry standard that demonstrates to employers that you know the basics of the Linux operating system. In this course, you'll gain the support you need to study, prepare for, and pass the Linux Essentials exam.
We'll start with the history of Linux, how it was originally developed, and why there are so many different distributions available. You'll learn about the open source software movement, and how the various types of open source software licensing differ. The course walks you through the basics of all the Linux distributions, but focuses on the Ubuntu Linux 14.04 LTS distribution.
As you progress, you'll see how to use both the Linux graphical desktop and the text-based command line, and you'll master the basics so you can work comfortably in either environment. You'll explore how Linux uses standard folders to organize system files, application files, and user files, and you'll learn how to manipulate files within the different types of folders. The course also demonstrates the power of Linux in working with text files, so you can create, edit, and search for data in text files.
As you work through the lessons, you'll gain practical, real-world Linux tips and techniques, as well as the skills required to pass the LPI Linux Essentials exam. From there, you'll be on your way to a career as a Linux system administrator!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1686 Marketing Your Business on the Internet

Description: Find out how to market your business on the Internet, even if you have little or no money to spend! In this practical, hands-on course, you'll discover proven methods that will help you establish an Internet presence and build an online brand identity. You'll learn how search engine optimization (SEO) works and how to track your site's performance using Web analytics. You'll understand how to use online advertising, email marketing, and social media (including blogs) to drive business to your Web site. Finally, you'll learn how to keep your visitors coming back again and again!
Throughout the course, you'll learn to think strategically about marketing your website, products, and services using Internet technologies. You'll explore how to use an Internet marketing checklist and other tools and materials to develop a sound online business strategy. Before you know it, you'll have the skills and knowledge you need to develop a winning Internet marketing plan for your own business.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1897 Microsoft Excel Pivot Tables

Description: Wouldn't it be great to learn how to effectively use all the advanced Excel pivot table features? In this practical and information-packed course, you'll see how to maximize this program's functions and capabilities.
Most organizations rely heavily on Microsoft Excel pivot tables to analyze and report financial information. Your company is probably no exception. By learning these advanced techniques, you can become more valuable to your organization.
You'll see how to work with the numerous pivot table options and system settings to become skilled in developing useful analysis models and reports within your company. Impress your coworkers by learning how to create functional and eye-catching interactive dashboards using a combination of pivot tables, Pivot Charts, and Slicers. You'll discover advanced techniques for pivot tables, like creating Timelines, calculated fields, and calculated items. You'll learn how to use Excel's Table function to efficiently manage changes to the pivot table's source data in order to avoid reporting mistakes when data is added or deleted.
Whether you're new to pivot tables, need a refresher, or want to become the pivot table guru within your organization, this course is for you!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1175 Photoshop CC for the Digital Photographer

Description: Adobe Photoshop CC (also known as Photoshop Creative Cloud) is a powerful subscription software solution providing support and specialized editing tools for digital photographers and graphic artists. In this course, you'll master techniques to edit and enhance your digital images and add a professional polish to your work. Designed for those with no image-editing experience, this class will take you from novice to accomplished photo editor. This course offers simple, step-by-step instructions for basics like cropping, rotating, and sizing images. You'll also experiment with Photoshop's tools for correcting exposure, adjusting color and color casts, as well as working with Adobe's powerful layer and selection tools. You'll learn exactly what you need to do to add text, retouch, and even clone away unwanted elements from your images. You'll see how to work with raw images and prepare images for print or online use. All along the way, your instructor will guide you with detailed explanations and instructions for using the tools that make this software so popular and unique in the world of digital image editing. The lessons are yours to keep so you'll have all the information you need to work on your own images. As the high-end program in Adobe's collection of photo-editing software, Photoshop CC gives users all the tools they need to create outstanding digital images. Because this course is specifically targeted at photographers, you'll come away with a collection of useful techniques and quickly start seeing amazing results in your images!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1185 Photoshop CC for the Digital Photographer II

Description: Adobe's Photoshop CC is the industry standard professional photo editing software for digital photographers and graphic artists, now available through the Creative Cloud. If you already know the basics of this powerful program, you're ready to expand your skills and put the power of Photoshop to work.
You'll learn advanced techniques with layering, working with multiple selections, applying type masks and special effects, and using filters to enhance images. You'll also take multiple images and combine them in to collages and panoramic photos, retouch portraits, and learn the tools and techniques for photo restoration. As we move through the class, you'll see how to take multiple images of the same subject and apply high definition range (HDR) for amazing color and contrast.
In addition, you'll master a workflow for efficiently processing your images and have a chance to bring all your skills together in a final exercise.
This class is perfect for you if you're already familiar with cropping, printing, color adjustments, and the basics of using layers and selection tools, and you want to take your photo-editing skills to the next level.
If you haven't fully unlocked the mysteries of Photoshop CC, you'll find all the answers you need in this course. By the time you complete these fun, easy-to-follow lessons and hands-on activities, you'll be a true Photoshop guru.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1400 Photoshop Elements 13 for the Digital Photographer

Description: Bring out the best in your photos! In this course, you'll learn how to use Adobe Photoshop Elements to do everything from quick fixes to detailed enhancements that will greatly improve the look of your digital images. If you're upgrading from an earlier version, you'll build a strong foundation in using Adobe's award-winning editing program. Even if you have no image-editing experience, this class will take you from novice to accomplished user.
As you explore this program's many easy-to-use features and tools, you'll gain control of Photoshop Elements' award-winning technology. Elements is so well designed that even from the start, you'll be able to get results that you never imagined possible. You'll master techniques for editing images, fixing flaws, enhancing the final product, creating simple art projects, preparing images for email and the Web, and organizing your images.
With easy-to-follow, step-by-step instructions, this course makes it easy to learn how to edit your images like a pro. You'll also get plenty of practice as you complete fun, hands-on exercises that ensure you understand the basics of this program as well as more advanced techniques.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1306 Photoshop Elements 13 for the Digital Photographer II

Description: Bring out the best in your digital images! If you have a basic working knowledge of Adobe's Photoshop Elements 13, these lessons will help you take your skills to the next level. Gain ability and confidence as you master the advanced features of this award-winning software, specifically designed for photo enthusiasts. Packed with hands-on activities and step-by-step instructions, this course will make you an accomplished user in just a few weeks.

Adobe combines the power of their award-winning technology with the ease of use and quick results you want. You'll be amazed at how effectively you can use artistic filters, layering techniques, and advanced editing tools. Before long, you'll be creating collages, turning images into text, merging images, and restoring old photos like a pro.
Photoshop Elements 13 gives you room to grow while allowing you to create exciting effects right from the beginning. Because it offers you more features and tools than you'll find in simpler programs, it broadens the options available to you as an amateur photographer. With the techniques you'll learn here, you'll be able to edit and enhance your photos with ease, and you'll have the power to transform any shot from "okay" to "wow!
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1081 Responsive Web Design

Description: In today's online environment, designers must create websites that are responsive. Their sites must reshape and morph to provide a positive experience in every viewport—from small touch-screen environments to large-screen browsers where users interact using a mouse or pointing device. This is the heart of responsive Web design (RWD).
In this course, you'll learn to identify and address every aspect of responsive Web design: from scaling elements and adjusting page layout, to adapting color schemes and implementing accessible forms. You'll master how to use HTML5 linked to media queries in CSS3 to adapt content to fit your user's viewport, and see how jQuery Mobile can help you to mobile sites.
Today's world of Web design requires building sites that are intuitive, inviting, accessible, and attractive in every possible device and environment. In this course, you'll learn to design and build fully responsive websites optimized for smartphones, tablets, and laptop/desktop viewing environments.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
BUS1595 Start Your Own Online Business

Description: In the past, fulfilling an entrepreneurial dream required a traditional business plan, a physical storefront and a significant upfront investment to get things started. Today, the Internet has changed everything. It's now entirely possible to create, launch, and build a profitable business from the convenience of your home with little to no upfront investment. Whether you feel the nudge of your inner entrepreneurial spirit or simply would like to generate more income, this course will give you a solid foundation for building and growing a successful digital business.
The course outlines a step-by-step approach that's easy to follow—from building a simplified strategy to branding your business. Then you'll dive into the details of creating a product and building and launching your very own website. Next, we'll examine how to engage with prospects and customers online by creating and implementing lead generation processes that consistently drive fresh leads to your business. And finally, we'll outline how to easily implement an online partnership program and support portal to keep your customers happy.
In today's Internet-enabled world, creating your very own online business is a reality to anyone with an Internet connection and the willingness to take action. No college degree or other special skills are required to make it happen. Instead, you simply need to know what to do and how to do it. So whether you're looking to generate a nice side income or even to replace your current income and ditch your full-time job, this course is for you. Visit www.ed2go.com/conestoga for more information.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1740 Understanding the Cloud

Description: What is the cloud? If you have trouble answering this question, you're not alone. In this course, we'll explore how the cloud works, what drives its incredible growth, and how you can use cloud services. And don't worry if you're not tech-savvy! We'll relate the cloud to things you encounter every day, using practical, non-technical language.
We'll start by looking at the building blocks of the cloud, where it started, and how it transitioned from an experiment into an unstoppable force. You'll also gain a clear understanding of IaaS, SaaS, and PaaS, and see why each may be attractive to some businesses, but not others. And you'll learn about the different kinds of clouds (public, private, and hybrid).
We'll also take an inside look at the engine rooms of the cloud: data centers. You'll examine the concept of big data¯the overwhelmingly huge amounts of data that make analysis so challenging—and how the cloud infrastructure enables data to zip across the globe at lightning speed.
Social networking has also played an incredibly important role in the growth of the cloud. We'll examine how Facebook and Twitter contribute to the cloud, and how apps go from idea to app store. You'll gain an understanding of how mobile devices and major mobile ecosystems¯like Apple, Android, and Windows¯continue to shape the cloud, and how start-ups can use social media to shake things up like never before.
So come see how the how the cloud can work for you! Whatever your technical background, by the end of this course, you'll be thoroughly cloud-savvy.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
SOC1040 Using Social Media In Business

Description: In today's fast-paced and globally connected environment, social media is a game changer for businesses and business owners who use this powerful medium in the right way. So whether you're looking for a new way to market your business or simply hoping to gain a better understanding about the excitement that surrounds social media, this course will empower you.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details
COMP1592 Wireless Networking

Description: Wireless networking is one of the fastest growing segments of the computer industry. Every electronic device seems capable of wireless connections these days: computers, handhelds, cell phones , and even digital cameras are all capable of transmitting without a tether. To many people, those wireless connections are nothing short of technical wizardry. This course will remove the mystery and give you a thorough understanding of this fascinating and lucrative technology.
You'll learn how wireless works, how wireless devices connect to networks, and how to build and connect to your own wireless network. We'll also explore wireless standards, wireless security, satellite Internet and cellular phone technology, as well as the future of wireless.
Becoming knowledgeable about wireless networking is easier than ever. With a helpful instructor who is also a working industry expert, a practical and thoughtful approach to teaching, and an emphasis on giving you a practical, hands-on understanding how wireless works, this course will teach you everything you want to know about the world of wireless connectivity.
Hours: 24
Credits: 2
Pre-Requisites:
CoRequisites:

Details

Program contacts for Computer Applications.

Back To Top