Luoyang Bridge, Quanzhou, China

During my last day in Quanzhou I took a bike ride on Fenghai Road with the goal to visit Luoyang Bridge. The bridge is one of the four ancient bridges in China and is a major attraction in Quanzhou.

The Travel China Guide Website says, “Construction of the Luoyang Bridge started in 1053 and was completed in 1059. The project of building the bridge was led by Cai Xiang, the governor of Quanzhou who was also one of the four famous calligraphers in the Song Dynasty (960-1279)." Read More

LinkedIn Pulse Articles

New and Featured Videos

Diving
Software Training

Software Training Services

The software training workshops can either be taken online at your own pace or during an live online meeting.

Placeholder image

Microsoft OneNote is a digital note taking application. In addition to typed notes, users can include graphics and screenshots along with typed content. Like traditional paper notes, content can be organized into “notebooks” and grouped with tab dividers, pages and a sub-pages. Unlike paper notes, content can easily be re-organized at any time. Notes can easily be shared with others for collaborative projects. Quickly learn the basics in this workshop and start using OneNote today.

Topics

  • What is OneNote
  • Launching OneNote and touring the interface
  • Vocabulary
  • How to Use OneNote
  • How to Create a OneNote Notebook
  • Tags
  • Dock to Desktop
  • Linked Notes
  • Demonstration & Exercise: Comparison Shopping Review

Price: Free Sample

Access Code: 8D69C-DVGPK

Placeholder image

Learn how styles can be used to format document faster than traditional direct formatting. Styles help you maintain consistent formatting that is easier and faster to change at a later time. Learn how styles and themes enable you to change the entire look of a document with a few click of the mouse button.

"Word is designed to be used with Styles. In fact, Styles are the very foundation of Word."

Read more about the advantages of using styles in my LinkedIn Pulse article titled, "Understand Styles to Understand Word".

Topics

  • Text Formatting
  • Line and Paragraph Spacing
  • The Show/Hide Button
  • Exploring the benefits of Microsoft Word styles
  • Demonstration & Exercise: Apply built-in Styles
  • Themes
  • Demonstration & Exercise: Edit a Microsoft Word Style
  • Demonstration & Exercise: Show and use hidden styles
  • How to create a Microsoft Word style
  • Review

Price: Free

Access Code: 3PJJS-C5J8K

Placeholder image

Formula and Functions are one of Excel's most powerful features. Learn to write both simple and complex formula. Discover how functions can help you do tasks like calculating loan payments and calculating totals based on specific conditions.

Topics

  • Vocabulary
  • Cell Reference
  • Solving Real Life Problems with Excel
  • Simple Formula
  • Complex Formula
  • Functions
  • SUMIF Function
  • COUNTIFS and SUMIFS Function
  • Nested Functions
  • Loan Payments with the PMT Function
  • Text Functions

Price: Free Sample

Access Code: TNC2T-6JH9B

Copy the Access Code and click on the Instructions Tab to register and access the workshop.

Placeholder image

Formatting can make your data easier to read giving your work a more professional look. Learn best practices for laying out and formatting an Excel worksheet. Find out how correct layout allows you to take advantage of Excel’s data analysis features. Discover how conditional formatting can improve data analysis allowing you to quickly see trends and patterns.

Read more about conditional formatting in my LinkedIn Pulse titled, "Excel Conditional Formatting and Sparklines"

Topics

  • Why Layout Matters
  • Direct Formatting
  • Apply Cell Styles
  • Edit Cell Styles
  • Tables Styles
  • Conditional Formatting
  • Page Layout
  • Printing Workbooks

Price: Free

Access Code: QVNJC-9SWX3

Placeholder image

Microsoft Excel has some powerful features for sorting and filtering data. Sorting and filtering skills will help you quickly find and edit data in addition to improving your data analysis abilities. Students will also learn the mechanics of applying sorts and filters to data tables.

Topics

  • Presentation: Layout Matters
  • Sorting Data
  • Demonstration & Exercise: Sorting Data
  • Filtering Data
  • Demonstration & Exercise: Filter Data
  • Demonstration & Exercise: Filter Data by Date
  • Demonstration & Exercise: Text Filters
  • Review

Price: Free

Access Code: 3XC3R-WK29D

Video Lessons

Most lessons include video tutorials. Bullet points below the video summarize the main concepts from the video lesson. Some of the videos are made by me specifically for the workshop. Others are free YouTube tutorials from quality channels like Lynda.com or GCFLearnFree.org.

Vocabulary

Workshops include a vocabulary list with definitions followed by a vocabulary review quiz. Students match the terms to the definitions.

Demonstration & Exercise

Workshops include video demonstations followed by a student exercise. Students complete the same task that is demonstrated in the video.

Ask Questions

Students with questions can either post a question to the Updates Page or send an email to the instructor.

Final Review Quiz

The final review quiz has questions that cover the major concepts introduced during the workshop.

Student Grades

Student can easily see the results of review quizes and the Final Review Quiz for each workshop.

Login and Enrollment Instructions

Once you have the access code vist the Schoology Website and follow the instructions below.

New Students & Schoology Users

New users to Schoology will create a free student account while submitting the access code for the course. Below the orange button is a link that says, Have an Access Code? Click Here.

Select Student at the next screen.

Access Screen Code

Paste or type your access code and click Continue.

New Student Account Form

Complete the account information form and start your workshop from the Materials Page.


Copyright © 2015 · All Rights Reserved · The Digital Gallery