Temporary Location:
305 S. 9th St., St. Charles, IL 60174
MON-THUFRISATSUN
9am - 9pm9am - 8pm9am - 5pm12pm - 5pm
MON-THUFRISATSUN
9am - 9pm9am - 8pm9am - 5pm12pm - 5pm

You are here

Computer Classes

New! Virtual Computer Instructional Videos Delivered to Your Email

Choose a topic and select the date you’d like to receive the learning material.  A link to an instructional video will be emailed to you along with a participant guideand the instructor’s contact information.  Watch the videos at your convenience. The technology educator will check in with you, via email, throughout the week. Assistance is available as needed. All videos offer closed captioning. For more information, please contact Sarah Pistilli at spistilli@scpld.org  

  • Classes are open to St. Charles Public Library cardholders only
  • REGISTER online, by phone or in person at any service desk.
  • Class size is limited to 15.

On the chosen date, you will receive an initial email from our Technology Educator, Sarah Pistilli, containing directions, a link to an online video, and a participant guide. Sarah will send you a second email on the Thursday of that week to check in with you. On the following Monday, you will receive a final email to wrap up the learning experience. 

Google Docs Lesson 1: Introduction to document formatting 
In this instructional video, you will learn how to  

  • Format text 
  • Use tools like spell check and word count 
  • Add lists, columns, and format line spacing 
  • Insert images, tables, page numbers, hyperlinks, and more 
  • Change page orientation, download a pdf and print 

Google Docs Lesson 2: Custom formatting and advanced techniques 
Learn advanced document formatting skills in this instructional video 

  • Customize margins, line spacing, columns, and indents 
  • Apply paragraph styles 
  • Create internal and external links 
  • Embed a spreadsheet 
  • Share a document 

Google Sheets: Create a spreadsheet to track a home improvement budget 
Learn the basic spreadsheet skills through this scenario-based learning activity 

  • Enter data   
  • Change fonts, adjust column sizes  
  • Use formulas to add a list of numbers and to multiple values   
  • Add a fill color and borders   
  • Print 

Google Sheets: Conditional Formatting
Apply formatting automatically based on conditions that you define in advance

  • Resize column widths and row heights
  • Apply conditional formatting to selected groups of cells
  • Merge multiple cells, format fonts, and fill cells
  • Create an image and insert an image in a cell
  • Duplicate and rename sheets

Google Slides: Create newsletters, flyers, scrapbook pages and more 
Slides is more than a presentation tool. Learn how to use it to create custom documents 

  • Choose a canvas size 
  • Add text boxes and shapes 
  • Change the background 
  • Add photos from your computer and online images 

Google Slides: Using the master slide to modify a template
 
Templates are a great way to create a presentation. Learn how to modify the colors, fonts, and layouts in a template to fit your style. 
  • Change the color theme 
  • Change the layout and fonts in a template 

 

Animating objects in Google Slides 
This instructional video shows you how to 

  • Add transitions between slides in a presentation 
  • Add animation to objects and text 

Microsoft Word 2016 Lesson 1: Introduction to document formatting 
In this instructional video, you will learn how to  

  • Format text 
  • Use spell check and word count 
  • Add lists, columns, and format line spacing 
  • Insert images, tables, page numbers, hyperlinks, and more 
  • Make a table of contents 

Microsoft Word 2016 Lesson 2: Custom formatting and advanced techniques 
Learn advanced document formatting skills in this instructional video 

  • Adjust margins, line spacing, and indents 
  • Customize columns 
  • Add shading, borders, bookmarks, and hyperlinks 
  • Insert a chart 
  • Apply preset styles to the document 

Microsoft Word 2016 Lesson 3: More tools and advanced techniques 
Learn how to add even more content to your Word documents in this instructional video 

  • Add internal and external hyperlinks 
  • Use SmartArt, Word Art, and Drop Caps 
  • Take Screenshots, add text boxes and Quick Parts 
  • Use find and replace 
  • Add comments and share a document 

Excel 2016: Create a spreadsheet to track a home improvement budget 
Learn the basic spreadsheet skills through this scenario-based learning activity 

  • Enter data   
  • Change fonts, adjust column sizes  
  • Use formulas to add a list of numbers and to multiple values   
  • Add a fill color and borders   
  • Print 

Excel 2016: Conditional Formatting
Apply formatting automatically based on conditions that you define in advance

  • Resize column widths and row heights
  • Apply conditional formatting to selected groups of cells
  • Merge multiple cells, format fonts, and fill cells
  • Create an image and insert an image in a cell
  • Duplicate and rename sheets

PowerPoint: Create newsletters, fliers, scrapbook pages and more 
PowerPoint is more than a presentation tool. Learn how to use it to create custom documents 

  • Choose a canvas size 
  • Add text boxes and shapes 
  • Change the background 
  • Add photos from your computer and online images 

PowerPoint: Use slide master to modify a template 
Templates are a great way to create a presentation. Learn how to modify the colors, fonts, and layouts in a template to customize it to fit your style. 

  • Change the color theme 
  • Change the layout and fonts in a template 

Animating objects in PowerPoint 
This instructional video shows you how to 

  • Add transitions between slides in a presentation 
  • Add animation to objects and text 

 

 

Check our calendar for this month's computer classes.