Retail and Supplier Education

 

VA Approved Program

AR Workforce Approved Program

 

Certified Retail Analyst Program

 Course Descriptions

 

Pre-requisite Classes*

College Algebra: An overview of the fundamental concepts of algebra.  Topics include linear and quadratic equations and inequalities; the Cartesian plane and graphing using graphing utility functions, graphs and models; polynomial and rational functions; exponential and logarithmic functions; systems of equations, inequalities and matrices; and sequences and series.

English Composition I: Guiding the student through the process of writing with regular practice and analysis of effective writing, this first course of the composition sequence emphasizes the writing of clear, concise, developed academic prose. Generally students are expected to follow the rules of Standard Edited English, to understand paragraph development, and to write a research assignment involving the integration of sources. 

CRA Introduction to Microsoft Office 2010:  Students will learn the most important topics of Microsoft Office 2010.  Students will become familiar with the Windows 7 operating system, file management, the basics of browsers and e-mail, and Microsoft Word, Power Point, Excel and Access through the use of tutorials for hands on learning and assignments that will enable students to expand on what they have learned. 

Class fee is $480 (textbook and software to be purchased separately).

Advanced Excel and Access for RetailStudents will develop a fundamental understanding of Excel through creating, revising and using spreadsheets to perform basic retail analysis.  Students will also gain an understanding of Microsoft Access through creating, revising and utilizing Access databases using retail data.  While the emphasis of this course will be on developing expertise in these tools, the data and learning environment is set to also familiarize students with problems that face retailers and suppliers.  Because of this unique learning environment the student will gain experience using Excel and Access to develop solutions specific to retail.

Class fee is $480.

*Any student that has not completed any of the above prerequisites has an option to "test out".

 

Certified Retail Analyst Course Descriptions

 

Retail Supply Chain & Replenishment:  Students will learn a broad overview of supply chain fundamentals, terminology and replenishment concepts as well as Retail Link applications including CPFR, Scorecards, and MABD applications.  Students will be required to start compiling a program portfolio in this class and will continue to maintain the portfolio throughout the entire program.

Class fee is $530.

Retail Link Data Management:  Students will navigate, comprehend and leverage Wal-Mart’s Retail Link system to solve relevant business problems.  Students will solve retail formulas using Excel, design weekly report templates, and pull Retail Link data in multiple orientations.

Class fee is $530.

Retail Tools Integration:  Students will integrate MS Access and MS Excel to create and maintain a retail database and automate spreadsheets using recorded Excel macros and Visual Basic for Applications (VBA) Macros.

Class fee is $530.

Retail Strategic Analysis:  Students will expand upon baseline analytical techniques taught in the first three classes and learn additional facets of analysis: consumer insights, supply chain, pricing and demand elasticity, competitive environment, store tests, and investment analysis.  Students will develop skills to present analysis clearly and effectively.

Class fee is $530.

Retail Analytical Techniques:  Students will learn to analyze large amounts of data, understand brand and/or category item drivers using the “Velocity/Pricing/Distribution” model, identify regional and seasonal  consumer influences and outside data sources that drive item velocity,  and present/defend strategic fact-based discoveries to affect category, unit sales, gross margin, and GMROII.

Class fee is $530.

 

Retail Internship

Students may have the opportunity to participate in an optional internship with a Consumer Goods Packaging company in Northwest Arkansas.  Internships are NOT guaranteed and are based upon availability, may be paid or unpaid and no class credit is given for internships.  If internships are available, the information will be sent to the students in Class 5; Retail Analytical Techniques.  Applying for the internship and all other details will be handled between the employer and the intern with no interference from NWACC.

 

For any any questions, please refer to the Frequently Asked Question page or send them to retail@nwacc.edu.