Excel Intermediate Learn the techniques for handling large spreadsheets. Use the Solver Add-In analysis tool, the conditional IF function, cell references linking formulas between worksheets, cell and range naming and using named ranges in functions, formatting and customizing charts, the VLOOKUP function and creating a basic macro to automate a regularly used process. Flash drive required: Students must activate their My Northshore account prior to first class.

Intermediate-Advanced English Pronunciation for ESL Students This course is intended for students at the high-intermediate to advanced level who want to further improve their English pronunciation to communicate more successfully with native speakers. The focus is on differentiating between more complex vowel and consonant sounds as well as practicing more complicated American English stress and intonation patterns. Textbook required. Prerequisite: ELLC 186+.

Low Advanced ESL This course is intended for students who already possess intermediate-level English skills and are ready for more advanced level noncredit classes or who wish to transition to credit classes in the future. The focus is on reinforcing and developing individual reading, writing, and oral skills as well as reviewing more advanced grammatical concepts. Textbook required. Prerequisite: ELLC 186+.

QuickBooks: Level 2 This course is intended for learners who have foundational knowledge of QuickBooks Cloud and want to expand their skills in handling more complex accounting functions. It covers various advanced areas of QuickBooks, including reconciliations, credit card and liability management, class tracking, 1099 reporting, sales tax setup, and essential utilities like importing/exporting files and data backup options. You will also learn to manage budgets, create forecasts, and record journal entries for comprehensive financial tracking. By the end of the course, you will have confidence in using advanced QuickBooks tools for accurate financial management and reporting, enhancing their ability to support business decision-making. Prerequisite: Completion of QuickBooks Level 1 or equivalent experience. Course Requirements: 1. Flash Drive: Required for file storage and backup. 2. Textbook: Please visit www.SHOPNSCC.com to order the required textbook. 3. Students must activate their My Northshore account prior to the first class.

Phlebotomy and EKG Career Path The combined Phlebotomy and EKG Technician program provides the necessary skills required to function as a vital member of the clinical laboratory team. Learn to collect blood specimens from clients for the purpose of laboratory analysis, become familiar with all aspects of blood collection, and the necessary skills needed to perform venipunctures safely. Combined with EKG, the course further covers topics and processes critical to conducting and interpreting electrocardiograms (EKGs) including the anatomy and physiology of the heart, technology used such as the EKG machine, how to interpret a rhythm strip, and details of a myocardial infarction. Students who successfully complete this program are eligible to participate in an optional volunteer externship opportunity with a local company/agency/organization in order to gain valuable hands-on experience. Courses prepares students to take the leading national/industry-recognized certification exam(s) essential to entry-level employment in this fast growing field: NWCA National Certification (NWCA) Phlebotomy Technician (CPT) Exam. Course includes CPR and required textbooks. Exam(s) not included in the cost of the program. Prerequisite: High School Diploma or equivalent. Health Care Requirements for Non-Credit Health courses: 1. Accuplacer Placement Exam: It is strongly recommended that students take the exam for advising purposes. For testing information or to schedule an exam please visit the Testing Center Web Page: https://www.northshore.edu/cas/testing/index.html 2. A CORI Check. 3. Proof of immunizations, a negative TB test, a COVID-19 vaccine with a booster, or a drug screening may be required for certain healthcare classes. You will receive an email from jmccloud@northshore.edu before the first class, containing the student healthcare packet. This packet must be reviewed, electronically signed, and submitted prior to the start of class. If you have any questions, please call us at (978) 236-1200.

Floral Design II Keep your creativity flowing! Create more challenging arrangements using tropical flowers, exotics, lilies, Dutch flowers, and several species of roses. Use an unusual and diverse variety of greenery and interesting containers to complement each arrangement. Discuss cut flower identification and preservation. Fresh cut flowers and floral supplies are provided in class. Please bring scissors, knife, ribbon cutters and wire cutters to class. Textbook required:(Same as Floral Design I) Please visit www.SHOPNSCC.com to order book, Flower Arranging Complete Guide by Blacklock: ISBN# 9780955239175. Prerequisite: Floral Design I or equivalent experience. Cost of class includes a $150 perishable fee.

Dental Assisting Prepare for an entry-level position as a chair-side Dental Assistant. Become familiar with all areas of administrative and clinical dental assisting to work in a dental practice. Learn the history of dentistry, introduction to the dental office, the legal aspects of dentistry, introduction to oral anatomy, dental operatory, introduction to tooth structure (primary and permanent teeth), the oral cavity; and other areas. Students who successfully complete this program are eligible to participate in an optional volunteer externship opportunity with a local company/agency/organization in order to gain valuable hands-on experience. Course prepares students to take the leading national/industry-recognized certification exam(s) essential to entry-level employment in this fast-growing field: National Workforce Career Association (NWCA) Dental Assistant Clinical Certification (DACC). Includes CPR and required textbook. Exam not included in the cost of the program. Prerequisite: High school diploma or equivalent. Health Care Requirements for Non-Credit Health Courses: 1. Accuplacer Placement Exam: It is strongly recommended that students take the exam for advising purposes. For testing information or to schedule an exam please visit the Testing Center Web Page: https://www.northshore.edu/cas/testing/index.html 2. A CORI Check. 3. Proof of immunizations, a negative TB test, a COVID-19 vaccine with a booster, or a drug screening may be required for certain healthcare classes. You will receive an email from jmccloud@northshore.edu before the first class, containing the student healthcare packet. This packet must be reviewed, electronically signed, and submitted prior to the start of class. If you have any questions, please call us at (978) 236-1200.

Excel Advanced This course covers Excel Database and Table Features including importing data, sorting and filtering, Excel Table features, Input Forms, creating and using a PivotTable Report, counting functions, conditional counting and summing, financial functions PMT and PV and Editing a macro in the Visual Basic Editor. Flashdrive required .Students must activate their My Northshore account prior to first class.