This course will reinforce the rules you learned in school and teach you some you didn't, and will equip you to write more effectively from day one with lessons from grammar basics to more advanced concepts like parallelism and agreement to the finer points of capitalization and punctuation.

Explore the world of digital court reporting in courtroom and freelance settings. There is a huge need for more digital reporters, and you can work from home.

The New York State Education Department requires healthcare, educational, and other licensed professionals to be trained to identify and report child abuse. Matriculated students at MVCC should consult with academic advisors before enrolling in this course.

The New York State Education Department requires healthcare, educational, and other licensed professionals to be trained to identify and report child abuse. Matriculated students at MVCC should consult with academic advisors before enrolling in this course.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This course will address the social patterns of harassment, bullying, and discrimination including, but not limited to, those acts based on a person's actual or perceived race, color, weight, national origin, ethnic group, religion, religious practice, disability, sexual orientation, gender, or sex. It will also cover the identification and mitigation of harassment, bullying, and discrimination and strategies for effectively addressing problems of exclusion and bias and aggression in educational settings. Successful completion of this course will meet the certificate requirements in 14(5) of Chapter 102 of the Laws of 2012.

This workshop satisfies the New York State Education Department's requirement for two-hour school violence prevention training (SAVE). The course focuses on issues relating to violence and safety for school-age children from both the identification and prevention perspectives. Topics include abuse and neglect, abduction, substance abuse, traffic and fire safety, and violence. Teachers' legal responsibilities, dangerous behavior identification, intervention techniques, effective classroom management, and promoting positive attitudes and behaviors will also be discussed.

This workshop satisfies the New York State Education Department's requirement for two-hour school violence prevention training (SAVE). The course focuses on issues relating to violence and safety for school-age children from both the identification and prevention perspectives. Topics include abuse and neglect, abduction, substance abuse, traffic and fire safety, and violence. Teachers' legal responsibilities, dangerous behavior identification, intervention techniques, effective classroom management, and promoting positive attitudes and behaviors will also be discussed.

Data Analysis is quickly becoming one of the most sought-after skills in the workplace. Companies have vast amounts of data, but it is rare to have someone with the ability to analyze that data to see trends and make predictions. Add a whole new skill set to your portfolio, and make a big difference in the success of your organization by acquiring data analysis skills. Begin with getting a basic understanding of how to analyze data in a business setting. Then learn how many of your business decisions involve comparing groups for differences. You will know the statistics behind these group differences and relationships. Finally you will find out how to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Whether your business is home based or a large company, this certificate will take you to the next level where important decision-making is concerned.

After taking this advanced course in Data Analysis, you will be able to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on statistically significant information. Whether your business is home based or a large company, this class will take you to the next level where important decision-making is concerned.

After taking this advanced course in Data Analysis, you will be able to perform inquiries that will be useful to your business or organization, and have the skill necessary to communicate these results through graphs and text that your fellow employees will understand. Take the guesswork out of important company decisions and make decisions based on statistically significant information. Whether your business is home based or a large company, this class will take you to the next level where important decision-making is concerned.

This course will give you a basic understanding of how to analyze data in a business setting. Businesses look for candidates with an understanding of how to analyze the data they have been collecting; this course will help you start on that journey.

Many of your business decisions involve comparing groups for differences. For example, would men and women prefer different product features? In addition, you may look at relationships between variables. Does product recognition relate to subsequent product purchase? This Intermediate Data Analysis course will introduce you to the statistics behind these group differences and relationships. In addition, you'll learn how to work with ratings, graphs and user-friendly reports of statistical results.

Take away a practical strategy and techniques for implementing social networks for your organization or business. Learn how to create your own private social network using Ning, work socially using Google Docs and calendars, and move your web site to an interactive Web 2.0 site. Your instructor will help you choose which social network tools are right for your situation, and then integrate them into your web site to develop a social networking strategy for your organization. Find out what you can be doing, what you should be doing, and take back a plan to integrate social networks into your communication and marketing.

From building to improving an online course, from fostering online discussion to encouraging student interaction, from traditional assessment to online tests, the program will give you the fundamentals of teaching online, as well as the most advanced tips and techniques in the business. Your instructors are authors, speakers, and consultants in online learning and teaching. This certificate includes Advanced Teaching Online, Designing Online Instruction, and Fostering Online Discussion.

In the 21st century, half of all learning will be online. The opportunities are tremendous for teaching online. Discover how to plan, develop and teach an online course. Take home a ten step model for developing your online course. Experience one of the most advanced online classrooms for teachers. Learn how to create online audio lectures with slide shows. Plus, find out how self quizzes enhance learning.

Learn about the online instructional environment, envisioning your online course, developing a web course, phases of design and development, design guidelines, and more. Discover the principles behind the adoption of technology innovation and the nature of the online learning environment. Then get tips for planning your online course, identifying resources and design guidelines. Discuss the phases of design and development and models, motivating student-student interaction, and managing interaction. Get the latest information on copyright issues, assessment and evaluation.

Being engaged with your online learners throughout the course is one of the three biggest weaknesses of online teachers. It is also one of the three biggest ways to take your online course to the next level, making it a superior learning experience for your learners. Come experience how to do it from the creator of the concept and practice of 'continual engagement' in teaching. Discover how to build student success through your interaction, how to give online learners feedback, communicating with them about everything from subject matter to delicate issues to grading. You will come away with advanced, practical, how-to tips from one of the foremost authorities on fostering online discussion. And you will see how your instructor models great interaction and engagement in the online environment.

Come get a fundamental yet advanced introduction to eMarketing, including improving email promotions, analyzing your website traffic, doing search engine optimization, and how to successfully employ online advertising. Relevant for any type of organization, including businesses, companies, non-profits, and government agencies. No eMarketing experience or expertise is necessary. If you are already at an advanced level, your instructors are experts and can provide the latest most advanced information and answer your toughest questions.

Acquire the basic skills to boost your web site traffic, including how to analyze your visitor traffic, how to use search engine optimization to get greater visibility and exposure in Google searches, and how to redesign your web site copy to increase your visitors and results.

Discover new ways to improve your email promotions, including when to email, what to email, and testing email copy. Then find out how to analyze your email response rates, including getting the bench marks for open rates and click through rates. Learn how to improve your email promotion and responses with tracking and testing.

Get the keys to making online advertising work for you and your organization. See how pay-per-click advertising with Google AdWords works. Find out how to test low budget Adword campaigns. Learn how you can target local audiences. Then discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach.

Get the keys to making online advertising work for you and your organization. See how pay-per-click advertising with Google AdWords works. Find out how to test low budget Adword campaigns. Learn how you can target local audiences. Then discover Facebook advertising and how you can determine the demographics and even numbers of people you want to reach.

Structured Query Language (SQL) is the industry standard database programming language. It is one of the most in demand skills in occupations that require interaction with data and analyzing data. Through your knowledge of Structured Query Language, you will become more marketable in computer related career fields that pertain to database administration. Learning SQL can also lead to a job that is specific to analyzing data such as a data analyst, a quality assurance analyst, or a business analyst. You'll first learn about relational database structures, the history and uses of Structured Query Language, and how to use Structured Query Language to create a database, add records to database tables, and how to use SQL queries to extract meaningful data from database tables. You will quickly progress from creating simple SQL queries that query a single table to querying multiple tables simultaneously. You'll also learn how to alter data in a database and how to gather significant statistics from data stored in a database. Finally, you'll learn techniques that will enable you to write powerful queries that perform complicated searches and sorts on your data. This certificate will enhance your competitiveness in the field of database administration and data analyst jobs.

Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database.

How do you manage the finances of a business? Whether you are an entrepreneur, running a family business, or just looking to advance your career and add to your skill set, this Bookkeeping Certificate will provide you with the knowledge needed to measure, and manage, the financial health of your business. This program focuses on cash basis accounting. No one will care more about the financial health of your business than you! It's imperative that you understand how the process works and are able to complete the accounting cycle accurately and in a timely fashion. Even if you plan to outsource your bookkeeping needs, you should still understand how the process works. No one should be clueless when it comes to the finances of their business.

In this course, you will learn about the accounting equation and the five categories involved in every business (Assets, Liabilities, Owner's Equity, Revenue and Expenses). Every financial transaction falls into one or more of these categories. Learn how to create a chart of accounts that meet the needs of your business. You will learn how double entry bookkeeping works and the process of recording debits and credits. This course will show you how to identify, analyze and record transactions using journal entries under the cash basis accounting method.

Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously.

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.

Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution.

This course shows you how to create a worksheet used to adjust the account balances and prepare the financial statements. Use your financial statements to measure performance, make improvements and set goals. The final step covered in this course is closing your books and preparing them for the next accounting period; this is done by journalizing and posting closing entries.

This course shows you how to create a worksheet used to adjust the account balances and prepare the financial statements. Use your financial statements to measure performance, make improvements and set goals. The final step covered in this course is closing your books and preparing them for the next accounting period; this is done by journalizing and posting closing entries.

Are you frustrated by the communication gap that can occur between you and your Spanish-speaking patients? If you answered yes, this Spanish class - designed specifically for healthcare professionals - will help you bridge that gap. You will practice the basic, practical language skills needed to effectively communicate with your Spanish-speaking patients and their families. You will learn the basics of the language, gain an understanding of the culture, and know how to ask the questions crucial to quality healthcare. 
   Whether you speak some Spanish and need a refresher, or speak no Spanish, you will complete the course with the skills you will need to effectively communicate with your Spanish-speaking patients. 

NOTE: Students will also need to order an eBook for under $15, or the paperback book version (please see book information below).

Students will purchase (on their own) McGraw-Hill Education Complete Medical Spanish, 3rd Edition: ISBN-13: 978-0071841887. The eBook version is available at Barnesandnoble.com. You can also purchase the paperback book version if you wish, available from numerous sources including Amazon.

Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results.

This course provides basic knowledge and skills in the use and development of sport-specific coaching methods and skills. New York State high school rules and regulations, teaching methods, performance skills, organization and management of practice sessions, and conditioning are explored. An internship in a specific sport under the supervision of a master coach or athletic trainer and seminar sessions in inter-school athletic history are required. This is one of three mandatory courses required by the New York State Education Department to become permanently certified to coach high school athletics. Prerequisite: CO231 Philosophy, Principles & Organization of Athletics in Education.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world.

Begin with learning how an Excel worksheet is constructed, populated with content, and edited for delivery. Discover how various menu items, commands, settings and processes affects the look of your Excel worksheets and workbooks. Then, increase your efficiency by learning how to organize, display and calculate your data into useful information. Identify different types of data and how data can be best visually represented or formatted, by using different data tool techniques. Finally, you’ll learn a variety of Excel’s most powerful features to analyze data quickly and easily. This Certificate will help you discover how to attractively visualize your data into meaningful information with confidence.

A must-have skill to succeed in business, whether an entrepreneur or a valued employee, is the ability to create, edit and manage spreadsheets. Microsoft Excel is the most used spreadsheet tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of Excel change over time. Examine the life of an Excel worksheet and workbook, from creation to presentation. Learn how an Excel worksheet is constructed, populated with content, and edited for delivery. Master the options that can take your Excel worksheet from plain, drab numbers to exciting and engaging multimedia. You will leave class with a set of skills that are in high demand and will be a deciding factor in your future success.

Have you ever wondered why Excel is one of the most powerful applications used today by many businesses? Excel is one of the most important applications that you can study now to take your skills to the next level!
This course will help you increase your efficiency by learning how to organize, display and calculate your data into useful information. Find out how you can consolidate your data proficiently into readable rows and columns using different table designs and styles. Create a unique style for yourself to improve your spreadsheet appearance to make the content easier to understand for your target audience. Learn from the trainer on how beneficial it is to become more productive in generating different everyday business functions. Discover how easily pivot tables can be created to quickly summarize large amounts of data. Through this course, these tasks will make your work outstanding and unique in what you do.

We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.

We are faced with different types of business decisions each day that can change the data we work with along with our financial outcomes. Have you ever wondered what type of workplace skills you can learn to make wiser decisions? Learning Advanced Excel contains these tools that can help you prepare your worksheets accurately, examine your data for authentication, and then find those answers to your most difficult questions. This course will help you learn these required business functions along with the tools required to analyze data efficiently within the workplace. Save time for yourself by protecting your valuable data and know with assurance that the entered data is accurate without any errors. By completing the course, discover how to attractively visualize your data into meaningful information with confidence.

First, gain the skills, tools and templates to confidently develop and maintain a project. Then, acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge Guide. Finally, learn the 10 Project Management Knowledge Areas and their support role and relationships to the five Project Management Processes.

In today’s business environment, there is a need for good project management.  Project management provides visibility of project health to the business and the customer.  Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholder for quick resolution, including project cancelation. Project management is one of the fastest paths to promotion by increasing your network through greater exposure.  You will have the skills, tools and templates to confidently develop and maintain a project.  An overview of salaries, certification costs, education and experience requirements are provided.  We hope you will choose Project Management as a career.

Acquire a well-rounded knowledge of the five Project Management Processes relating to the Project Management Body of Knowledge (PMBOK) Guide. This basic information will assist you in learning the beginnings of Project Management, whether you are interested in project management, in a project management field, or in any line of work.   Come away with a solid foundation of the five processes to learn and use when any type of project occurs in your employment arena.

In today’s business environment, there is a need for good project management.  Project management provides visibility of project health to the business and the customer.  Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholders for quick resolution, including project cancelation.  The Project Management Professional community does this through the five (5) Project Management Processes supported by the ten (10) Project Management Knowledge Areas.  This course introduces the student to the ten (10) Project management Knowledge Areas and their support role and relationships to the five (5) Project Management Processes.

In today’s business environment, there is a need for good project management.  Project management provides visibility of project health to the business and the customer.  Through continuous monitoring, early detection of variations to plan, schedule, and budget can be communicated to stakeholders for quick resolution, including project cancelation.  The Project Management Professional community does this through the five (5) Project Management Processes supported by the ten (10) Project Management Knowledge Areas.  This course introduces the student to the ten (10) Project management Knowledge Areas and their support role and relationships to the five (5) Project Management Processes.

Must-have skills to succeed in the workplace include the ability to create, edit and manage presentations in MS PowerPoint, documents in MS Word, email and calendars in MS Outlook, and spreadsheets in MS Excel. Microsoft Office Suite of applications is the most used software tool in the world. Stay current with this class, as it is always up-to-date and will change as the features of MS Office change over time. Master the most common uses so that you can work faster and more efficiently and can take your computer skills from plain and drab to exciting and engaging. You will leave class with a set of skills that are a workplace requirement in today’s fast paced ever-changing environment and will enable your future career success.

Video marketing is the latest hot new marketing trend. Shoppers who viewed product videos were 144% more likely to add the product to their cart.  Video with good SEO has a 53% higher chance of showing up on page one of Google searches. When done correctly, video can tell a story, and stories connect people. Video also leads to an emotion ‘trigger’ that plain text cannot do.

Sight, sound and motion are much more compelling than static words on a page. Video is very hypnotic and it quickly speeds up the “know, like and trust,” factor with your audience. In this course you will discover how to use simple online video to quickly bond with your viewer, drive traffic to your website, boost business and build brand awareness. 

Find out how to shoot simple, effective videos without costly fancy equipment or savvy technical skills.  Discover the secrets to creating content that commands attention.  Learn how to dominate Google and YouTube with your video and to strategically use YouTube to market your business 24/7 -- even while you sleep. 

Increase your business with YouTube, the online video site and now the second largest search engine. Discover the power of video for your organization, and how to use video as a marketing tool to reach and serve more people. Find out what types of video work best on YouTube, how other business organizations are using YouTube, how to create your own YouTube channel, and the techniques of adding captions, annotations and other extra features.
After attending this course you will take back proven strategies and techniques for making YouTube work successfully for your organization.

Learn how to get your YouTube video on the first page of Google Search. Just like Facebook, YouTube is a social network that needs to be set-up, optimized, and used regularly to be effective. Your patters of behavior on YouTube may be working against you. Learn how YouTube can compliment your current marketing and social media strategy and how to maximize your YouTube Channel to get the greatest return.

Gain insights into your data!  Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. 

Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using  DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports.

Adobe InDesign is the industry standard page-layout program that works with Adobe Illustrator and Photoshop seamlessly. InDesign allows you to create simple to complex multi-page documents such as brochures, flyers, books and magazines. This course is a comprehensive exploration of InDesign tools and capabilities to create professional documents. You will learn how to manage the InDesign environment, create, setup, design, enhance and finalize multi-page documents. Access to Adobe InDesign software required.

Working remotely does not make you an expert on remote work.

Gain new insights, experiences and advanced tips for working from home.  Find out the 5 bad habits too many remote workers and their managers acquire from lack of experience, tools and expertise. Then acquire the latest strategies for communicating with remote workers. 

Come away with a deeper understanding of this enormous cultural and work shift going on in the workplace and in society. 

Take your Live Online teaching to the next level for greater student satisfaction, learning, completion, and retention. Come away with practical how-to tips and techniques, plus the pedagogy of Live Online teaching.

You cannot manage remote workers like you manage office workers. But you can manage remote workers better, with greater productivity and efficiency. Discover the keys to successful managing in the new workplace of the 21^st century.  

Get a step-by-step practical guide you won’t get anywhere else.  Employees and employers both like the new system. You’ll want to apply these practices to your office workers as well. 

This program is designed for beginning or advanced legal workers. To receive a certificate, you must pass numerous quizzes and successfully complete several writing assignments. To enroll, contact the Center for Legal Studies at 1-800-522-7737. Books and materials must be purchased separately. For more information, visit https://www.legalstudies.com/product/mohawk-valley-community-college-paralegal-certificate-course/

This eight-hour initial certification course is required for any renovators without previous training to become a certified lead-safe contractor. Bring a pen, pencil, and paper; all other materials will be provided. The course concludes with a 25-question exam. Students should also bring lunch.

This eight-hour initial certification course is required for any renovators without previous training to become a certified lead-safe contractor. Bring a pen, pencil, and paper; all other materials will be provided. The course concludes with a 25-question exam. Students should also bring lunch.

How do you keep track of the day-to-day financial transactions of a business? At the end of the cycle, what do the numbers mean? Whether you are looking to advance in your career, are an entrepreneur, or part of a family business, this course will help you understand the numbers, where the numbers go, and why. You’ll learn bookkeeping terminology as well as what it means to keep track of the numbers.

If you have wanted to become a notary public, but have been worried about the exam, this class will help. Don't let the terminology scare you−you can become familiar with the terms and laws and learn the skills necessary to sit for the notary exam and earn the license to become a more valuable asset in your workplace.

The New York State Education Department requires this class for licensed professionals, including physicians, physicians' assistants, specialist assistants, dentists, dental hygienists, Registered Nurses, Licensed Practical Nurses, optometrists, and podiatrists. Certification is valid for four years. (0.3 CEUs)