Rock Valley College
Rockford, Illinois

Computer Training


COMPUTER TRAINING


Computer Training for Everyone! Enhance: Your Skills!

computer student

Computer courses offered through Continuing Education are designed for students with beginning to advanced computer experience. A variety of short-term, hands-on computer courses are offered at various times and locations to meet the needs of the community. 

Computer Lab Locations:

BLL – Course sections are taught at the Bell School Road Center, 3350 N. Bell School Road, Rockford 

RV – Course sections are taught at the Woodward Technology Center, 3301 N. Mulford Rd., Rockford


Teachers! Watch for the Apples.

“Apples” indicate courses that have been approved by the Illinois State Board of Education. Please let the instructor know when taking the class for CPDUs.


For additional classes approved for CPDU’s, see the Education Careers Tab.



REGISTER EARLY REGISTER ON-LINE


www.rockvalleycollege.edu/ceonline




Getting Started

Mouse


Intro to Computers Part 1

This class is designed for the new user or those with no experience interested in learning computers. Provides individuals with the skills and confidence to continue learning. You will learn terms and fundamentals. What is Windows. Software vs. Hardware. What is a hard/floppy drive/CD-ROM. Memory and storage What is a file. Bring flash drive to class. 4 CPDUs

DPR 001 RV   9/5 Th 9:00 am-1:00 pm $49  WTC Room G02 

DPR 001 BLL 9/14 Sa 8:30 am-12:30 pm $49 BELL SCHOOL CTR Rm 005 


Intro to Computers Part 2

(.5 Credit) This course is a continuation of Computer Basics I. Become familiar with Internet navigation, e-mail, search tools and more. Individual help will be available during class session. Bring a flash drive to class. RECOMMENDED: Computer Basics-Level I or equivalent experience.

DPR 075 BLL 9/27-10/4 F 1-5 pm $69 BELL SCHOOL CTR Rm 005 

Basic Computer Skills

(1.5 Credits) This course covers basic computer skills while offering an  overview of the MS Office 2010 Suite. You will be prepared for other courses offered through Continuing Education. Handouts provided. Bring a flash drive to Class. RECOMMENDED: Computer Basics Level 1 or equivalent experience.

You will learn to:

• type letters and documents using Word

• create formulas in spreadsheets using Excel

• create databases using Access

• create presentations using PowerPoint

DPR 045 RV      9/10-9/19  TTh 9 am-Noon $129  WTC  Room G02 
DPR 045 BLL1 9/21-10/12 Sa 8:30am-12:30pm $129 BELL SCHOOL CTR Rm 005 

Windows 7.0 Basics

(1 Credit) Have you purchased a new computer with Windows 7 operating system and need help discovering the many simple and powerful features? You will learn to: Work your way through the operating system–open documents and folders. Start applications from the desktop. Customize the task bar. Change system settings. Manage files and more—along with all the fun new enhancements found in Windows 7! (If you have Windows XP or Vista, almost everything taught in the class will work for you.) Purchase text at RVC Bookstore before first session. RECOMMENDED: Computer Basics Level I or equivalent experience. 

Bring a flash drive to class. 16 CPDUs

DPR 003 BLL   9/21-10/12  Sa 1:00-5:00 pm $129 BELL SCHOOL CTR Rm 005 


Computer Software Application Series

This set of courses provides the education and skills to begin a career, to advance in a current position or to promote professional growth. You can become a Word Processing Specialist, Spreadsheet Application Specialist, Database Management Specialist, Presentation Application Specialist by successfully completing the required courses for each track. Please consult individual courses in this schedule for dates and times. 

Word Processing Specialist

Word Level 1 – 12 hours

Word Level 2 – 12 hours

Word Level 3 – 12 hours

Spreadsheet Application Specialist

Excel Level 1 – 12 hours

Excel Level 2 – 12 hours

Excel Level 3 – 12 hours

Database Management Specialist

Access: The Complete Course – 28 hours

Presentation Application Specialist

PowerPoint: The Complete Course – 20 hours



RVC Computer Skills Exam

Upon successful completion of a Specialist Series in MS Word, Excel, Access or PowerPoint, students will receive a RVC Skills Certificate plus be eligible to take the RVC Computer Skills Exam at no additional charge. The exam will be offered on 5/31 from 9-11 am for all topics. (Exam not offered for Web Page Design) Students have one year to complete all of the required Specialist Series courses. To register for the exam, call RVC Continuing Education at (815) 921-3900. 

OSB 099 RV2  12/17  T  9:00-11:00 am  FREE  WTC Room G02


RVC Keyboarding / Typing Certificate

Do you need an instant reliable, accurate typing certification? We’ll test your speed and accuracy. Earn your RVC Certificate with your scores to show an employer. Cost $10. Call Continuing Education to register (815) 921-3900.


Word 2010 Level 1

(.5 Credit) Word 2010, a powerful word processing program allows you to do much more than type documents. Purchase text at RVC Bookstore before first session. RECOMMENDED: Basic Computer Skills or equivalent experience. Bring a flash drive to class. 12 CPDUs 

You will learn to:

•open Word and review the new Ribbon interface

•navigate and close Word documents

•create documents and search Help for more information

•create/enhance documents using margins

•work with line spacing, bullets, borders, and shading

•use spell and grammar checker, AutoCorrect, Format Painter

•cut, copy, paste, drag and drop

•create document with mail merge

DPR 023 RV     9/24-10/10  TTh 9:00-11:00 am $99  WTC Room G02 

DPR 023 RV1   9/24-10/10  TTh 7:30-9:30 am   $99  WTC Room G02

DPR 023 BLL  10/19-11/2   Sa 8:00 am-Noon  $99  BELL SCHOOL CTR Rm 005 


Word 2010 Level 2

(.5 Credits) Learn intermediate Word skills. (Use same text as Word Level I) RECOMMENDED: Word Level 1 or equivalent experience. Bring a flash drive to class. Purchase text at RVC Bookstore. 12 CPDUs 

You will learn to:

•create, sort, format, merge and perform calculations in tables

•work with section breaks, insert columns and column breaks

•insert WordArt, clip art and themes

•create custom Building Blocks & create a one-page promotional brochure

•set page orientation and size, work with shapes, picture editing

•insert and format Smart Art and format page background

•create research paper including footnotes and endnotes, headers 

and footer with captions and table of figures

•use built-in templates

DPR 026 RV    10/15-10/31  TTh 9:00-11:00 am  $99 WTC Room G02 

DPR 026 RV1  10/15-10/31  TTh 7:30-9:30 pm  $99  WTC Room G02 

DPR 026 BLL   11/9-11/23   Sa 8:00 am-Noon   $99  BELL SCHOOL CTR Rm 005 


Word 2010 Part 3

(.5 Credits) Learn intermediate Word skills. (Use same text as Word Level I) RECOMMENDED: Word Part 1 and Word Part 2 or equivalent experience. Bring a flashdrive to class. 12CPDU’s.

You will learn to:

• create, sort, format, merge & perform calculations in tables 

• create footnotes & endnotes, headers & footer with captions & table of figures

• work with section breaks, insert columns and column breaks

• insert WordArt, clip art & themes

• create custom Building Blocks & create a one-page promotional brochure

• set page orientation & size, work with shapes, picture editing 

• insert & format Smart Art & format page background

• use built-in template

DPR 036 RV    11/5-1/21  TTh 9:00-11:00 am  $99R  WTC Room G02 

DPR 036 RV1  10/5-10/31  TTh 7:30-9:30 pm  $99   WTC Room G02

 

Excel 2010 Level 1

(.5 Credits) Learn Excel 2010, a powerful spreadsheet application. The focus of this course is on basic skills, starting with a review of the new Office Ribbon interface. RECOMMENDED: Basic Computer Skills or equivalent experience. Purchase text at RVC Bookstore before first session. Bring a flash drive to class. 12 CPDUs. 

You will learn to:

• enter & edit data           

• elect and format cells and ranges

• create formulas & functions   

• adjust row and column

• page setup and printing worksheets

DPR 024 RV     9/24-10/10  TTh 11:15 am-1:15 pm $99  WTC Room G02

DPR  024 RV1  9/24-10/10  TTh 5:15 - 7:15 pm     $99  WTC  Room G02


Excel 2010 Level 2

(.5 Credits) Learn intermediate Excel skills. RECOMMENDED: Excel Level 1 or equivalent experience. (Use same text as Level I). Bring a flash drive to class. Purchase text at RVC Bookstore.  12 CPDUs. 

You will learn to:

• freeze headings and split worksheet windows

• sort worksheet rows

• set print options

• insert art, draw, move, size, rotate and add styles

• create SmartArt

• use office template and create custom templates

• lock/unlock cells, apply protection, set password/attach a digital signature

• copy/move worksheets, copy formatting between worksheets/use linked formulas

• sort/filter table data, hide detail data using the outline/grouping commands

DPR 027 RV     10/15-10-/31 TTh 11:15 am-1:15 pm $99 WTC Room G02 

DPR 027 RV1  10/15-10/31   TTh 5:15 - 7:15 pm     $99 WTC Room G02 


Excel 2010 Level 3

(.5 Credits) Learn advanced Excel features including integrating Excel with other Office programs. RECOMMENDED: Excel Level 2 or equivalent experience. (Use same text as Level I). Bring a flash drive to class. Purchase text at RVC bookstore before first session. 12 CPDUs 

You will learn to:

• create Macros to automate routine tasks

• create and format Pivot Table & Pivot Charts

• use PMT & FV functions, Goal Seek, Solver, Analysis Tool Pak & Scenario Manager

• use 3-D cell references, HLOOKUP, VLOOKUP and IF functions

• consolidate data from detail and group worksheets

• use Data Validation and Conditional Formatting

• create data tables and trend lines

• set up project folders, insert comments feature

DPR 037 RV     11/5-11-/21  TTh 11:15 am-1:15 pm $99 WTC  Room G02 

DPR 037 RV1  11/5-1/21     TTh 5:15 - 7:15 pm      $99 WTC  Room G02 


Access 2010 Complete

(1 Credit) (Level 2-3) Begin building the skills needed to use this powerful database management software then learn the more advanced techniques of Microsoft Access. Purchase text at RVC bookstore before first session. RECOMMENDED: Basic Computer Skills or equivalent experience. Bring a flash drive to class. 18 CPDUs

You will learn to:

• define database concepts – produce reports

• create, build and modify tables – create/modify select queries

• create/use a form to enter data into a table

• strengthen tables – form relationships/format fields

DPR 089 BLL     11/5-11-/21  TTh 1:30-3:00 pm $99  WTC Rm G02 

                      NO CLASS 11/28


PowerPoint 2010 Essentials

(1 Credit) Everything you need to know to assemble and present your own basic PowerPoint presentation. Purchase text at RVC Bookstore before first session. RECOMMENDED: Basic Computer Skills or equivalent experience. Bring a flash drive to class. 20 CPDUs. 

You will learn to: 

• use Slide Master – change color schemes

• create charts – create and run slide shows

• auto Content Wizard – print handouts and outlines

DPR 095 RV  11/26-12-/12  TTh 9:00 am-1:00 pm WTC Room G02 

                   NO CLASS 11/28


Basic Web Technology Mini Certificate 

Computer-girl_81245389

Learn and apply HTML, CSS, and Java Script to web pages and understand the web development process. Upon completion of the five (5) courses below you will receive the Basic Web Technology Mini Certificate:

HTML Essentials – 12 hours

CSS Essentials – 12 hours

Java Script Essentials – 12 hours

Server Side Technologies – 12 hours

WordPress – 4 hours



HTML Essentials

(.5 Credit) HTML is used to define the content of a web page. A solid understanding of HTML will allow you to maintain web pages without using an HTML editor. Even if you are using an HTML editor such as Dreamweaver, you will need to know enough HTML to make necessary “code tweaks” in order to get your web pages to do what you want them to do. This course is designed to show you how to create web pages using nothing more than HTML. An overview of Open Source HTML tools will be covered along with how to use text, image, list, link and table tags. RECOMMENDED: Basic Computer Skills or equivalent experience. Bring a flash drive to class.  

CIS 064 RV 9/14-9/28  Sa 8:30 am-12:30 pm $99 WTC  Room G02 


Cascading Style Sheets (CSS) Essentials

(.5 Credit) Where HTML is used to define the content of a web page, CSS (Cascading Style Sheets) is used to define presentation of that content. This course is designed to show you the basics of CSS, how to convert HTML tags to CSS elements, and how to control those elements via style sheets. RECOMMENDED: HTML Essentials or equivalent experience. Bring a flash drive to class.  

CIS 066 RV  10/12-10/26  Sa 8:30 am-12:30 pm $99 WTC Room G02           


JavaScript Essentials

(.5 Credit) While HTML defines the content of a web document and CSS defines the presentation of that content, JavaScript controls the behavior of the web document. This means that JavaScript makes it possible to add user inter activity to your web document (e.g. form validation, calculations, etc.). This course is designed to give you a basic understanding of the JavaScript scripting language, and how to integrate it into your web documents. RECOMMENDED: CSS or equivalent experience. Bring a flash drive to class.

CIS 068 RV 11/2-11/16  Sa 8:30 am-12:30 pm $99 WTC Room G02


Server Side Technologies

(.5 Credit) To deliver dynamic web content to your website visitors, you will need to understand various server-side scripting technologies. Using these technologies, you can dynamically edit, change or add any content of a Web Page, respond to user queries and form data, access databases, access files, transform XML, date to HTML data and return the results to a browser, customize a Web page, provide security and access control to Web pages, tailor your output to different types of browsers and more. RECOMMENDED: Java Script Essentials or equivalent experience. Bring a flash drive to class. 

CIS 069 RV  11/23-12/7  Sa  8:30 am-12:30 pm $99 WTC Room G02

                  NO CLASS 8/10


Special Topics 

Word_

QuickBooks 2012 Level 1


(1 Credit) Learn the basics of this powerful financial management program for small business. RECOMMENDED:  Basic Computer Skills or equivalent experience. Purchase text at RVC Bookstore.  Bring a flash drive to class. 
DPR 029 RV  9/11-10/16  W  5:30-8:45 pm  $145 WTC  Room G02
 

QuickBooks 2012 Level 2

(1 Credit) This course provides a continuation of QuickBooks 2012 Level 1. Purchase text at RVC Bookstore (same text as Level 1) Bring a flash drive to class.

DPR 057 RV  10/23-12/4  W  5:30-8:45 pm  $145  WTC  Room G02 


Marketing Your Business Through Social Networking

(.5 Credit) This course is designed for business owners interested in learning how and why to use social media as part of their marketing strategy. This class will provide a comprehensive overview on the fundamentals of creating and managing social media for your small business. Learn how to grow your social network, gain brand exposure and generate web traffic for your business. Learn about the most popular types of social media, how to interact and attract customers with the these media forms and the “do’s and don’ts” of social media etiquette. Information on Facebook, Twitter, Flickr, Linked In as well as blogging for business will be presented. This timely class will also help you repurpose your business marketing materials into fresh and informative information to add content to your social media venues.  

DPR 098 RV   9/9  M 6:00-9:00 pm  $39 WTC  Room G02


Facebook for Small Business

(.5 Credit) Learn about Facebook and how to use it for small business. Students will open an account, set up a Facebook page and learn what Facebook can and can’t do for a small business. Join us to see how to reach out to customers with this social media tool and how to use Facebook time and resources to your advantage. 

DPR 098 RV3  9/23  M  6:00-9:00 pm $39  WTC Room G02

 

Blogging for Small Business (Word Press)

(.5 Credit) Are you looking to gain customers and increase your status in your industry? Blogging may be the answer! Learn how to open a blog account, what to write about in a business blog, as well as how to use material you may already have to create fun and interesting blog posts.  We will also explore places to Host your blog including Word Press and others. 

DPR 098 RV2  9/16 M  6:00-9:00 pm $39  WTC  Room G02


Twitter for Small Business

(.5 Credit) Learn about Twitter and how to use it for your small business. Learn what a “hash tag” is and how to post interesting information about your business and products to gain Twitter followers. Students will open a Twitter account, design a Twitter page and learn the important points of posting for business. 

DPR 098 RV3 9/30 M  6:00-9:00 pm $39  WTC  Room G02


Getting Started with an iPhone

You will learn to use the apps that come with your iPhone including mail, Internet, music and more. Plus we will use the App Store to purchase and download many useful and fun apps. Bring your iPhone to class

DPR 051 RV  10/1  T  6:00-9:00 pm $39 BELL SCHOOL CTR Room 005

 

Getting Started with an iPad

Learn how to organize, explore and maximize your new digital device. Pinch, swipe, tap and shake your way through the features and functions including photos, videos, calendar and various apps. Find some hidden gems and tips to make you a confident and proud iPad owner. Bring your iPad to class

DPR 051 RV1 10/8  T  6:00-9:00 pm $39 BELL SCHOOL CTR Room 005


Evernote Organizational Program  

This program will help you organize your “to do” list, projects, notes, recipes, genealogy and more. You’ll learn how to add information from websites, web info and pictures, how to Sync information across computers, smartphones, tablets and any device with Internet access. Learn to edit, share and organize your notes. RECOMMENDED: Computer Basics l or equivalent experience.

DPR 025 BLL 11/1-11/8  F  12:30-4:30 pm $59 BELL SCHOOL CTR Room 005


Storing Information on the Cloud 

iCloud

(.5 Credits) Learn about different Cloud storage sites and amounts available such as Dropbox, iCloud, Googledrive, Skydrive and Sugarsync. Learn advantages of different storage sites, new storage contenders on the market, syncing information from your computer to online storage for backup, deleting content from the Cloud, free or fee storage, sharing information on storage with others and how to utilize storage on all your devices. RECOMMENDED: Computer Basics l or equivalent experience.

DPR 090 BLL 10/11-10/18 F  12:30-4:30 pm $69 BELL SCHOOL CTR Room 005

 

Adobe Photoshop CS5

(.5 Credits) (Level 2) Learn how to correct and enhance your photos with Adobe Photoshop CS5. You will learn how to retouch and enhance your photos through hands-on experience. You will learn how to use many of the tools to edit your photos and images including selection tools, resizing and cropping, removing red eye, re-coloring certain areas of your photo, contrast and brightness and filters and many other techniques to correct those photos you thought were useless. Purchase text at RVC bookstore before class. Bring a flash drive to store pictures used in the class. RECOMMENDED: Computer Basics l or equivalent experience.

DPR 042 RV   10/1-10/17 TTh  1:30 am-4:00 pm $139 WTC Room G02


Mac for Newcomers

(.5 Credits) This introductory class is designed for the NEW Mac user or individuals with little or NO Mac experience and are interested in learning how to get around the Mac computer. Your will learn the desktop, menu bar, how to use the mouse and dock, basic windows, menu features including finder and file handling. Bring a flash drive to class. Purchase text at RVC Bookstore before the first session. 

DPR 019 RV  9/20-10/11   F  1:00-4:00 pm $99 WTC Room 152


Mac Applications

(.5 Credits) This course is a continuation of Mac for Newcomers. It will cover the basic functions of iCal, iDVD, iPhoto, iMovie and iTunes.Mac for Newcomers or equivalent experience with Mac computers. Purchase text at RVC Bookstore-the same text is used for Mac for Newcomers. RECOMMENDED: Mac for Newcomers or equivalent experience with Mac computers.

DPR 015 RV  10/18-11/8  F  1:00-4:00 pm $99 WTC Room 152


EBAY: Buying & Selling

This class will focus on how to buy and sell items on EBAY’s online auction. Participants who want to take advantage of this hands-on training should already be registered with EBAY. Otherwise you may also choose to observe the buying and selling process that will be demonstrated during the class. RECOMMENDED: Computer Basics ll, Internet or equivalent experience.

OSB 096 BLL  9/7  Sa  8:30 am -12:3 pm $49 BELL SCHOOL RD CTR Rm 005

Laptop_