- Course Title
- Computer Skills for the Workplace
Discover the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace and learn the basics of Windows 10 and Office 2016. Implement the powers of modern office software to work faster and more efficiently while focusing on practical application for software most common to the workplace. Once finished this course, you will have learned why employers consider technological literacy so critical to the success of any organization.
- Overview: The Workplace Technology Solution: Find out why computer skills are so important in the workplace, and get familiar with your computer's desktop, program controls, and file organization system.
- Outlook: E-Mail and Scheduling: Create and manage e-mails, appointments, and contacts in Microsoft Outlook to improve your efficiency and effectiveness.
- Word: Creating and Formatting Documents: Open Microsoft Word; get acquainted with its layout; and practice creating, saving, editing, and formatting basic documents.
- Word: More Advanced Formatting: Discover more of Word's powerful formatting features, including alignment options, bullets and numbering, Styles, templates, tables, and graphics.
- Excel: Spreadsheet Basics: Use Microsoft Excel to create, format, and apply basic formulas to data in spreadsheets.
- Excel: Formatting, Charts, and Printing: Build on your Excel skills by learning more advanced formatting techniques, adding charts, and viewing and printing spreadsheets.
- Access: Database Basics: Learn how databases work, and use Microsoft Access to design, create, and manage a simple database.
- PowerPoint: Creating and Editing a Presentation: Use Microsoft PowerPoint to design a presentation from scratch, and learn how to apply themes, insert images and animations, and prepare the slide show for viewing or sharing.
- Integrating Microsoft Office Programs: Export data to generic file types, import data between Office programs, and perform a mail merge in Word using data from Excel.
- Using the Internet: Explore the ins and outs of your Web browser; get familiar with directories, search engines, and portals; and learn how to protect your information online.
- Transferring and Protecting Data: Find out how to efficiently transfer information between computers using e-mail, portable hard drives, Zip files, and CDs, and keep your data safe with anti-virus software and regular hard drive maintenance.
- Putting Your Skills to Work: Take advantage of your computer skills to find a new job or to move up in the one you have, and make a plan for continued learning.
Wednesday - Lesson 01
Whether you're looking for a new job or looking to improve your position at your current company, computer skills are essential to your success. In our first lesson, we'll examine how companies set up and use technology solutions. Then we'll take a close look at some of the components of those solutions. Just understanding how technology fits into the overall flow of work at your company will advance your position relative to your peers.
Friday - Lesson 02
Your computer has a software program installed on it that's referred to as an "operating system." Most often, this system is Microsoft Windows, but it could be others, such as Macintosh or Linux. In this lesson, you'll learn how this system controls many important parts of the computer and how you use those controls every day for tasks like managing where you keep important files, and printing hard copies of documents. We'll also talk about menus, taskbars, and shortcuts along the way.
Wednesday - Lesson 03
Next to email, the word processor is probably the most frequently used application software in the workplace. Yet, if you've never taken the time to learn the basic features of most word processors, you're not performing nearly to your potential. In today's lesson, you'll learn and practice the important capabilities of word processors like Microsoft Word.
Friday - Lesson 04
There are many excellent features in Microsoft Word that can enable you to create and edit very professional-looking documents. In this lesson, we are going to incorporate some of the more advanced Word functions to create documents that are sure to impress your peers and your supervisor. We'll focus on formatting and organizing your information using a wide range of Word processor tools.
Wednesday - Lesson 05
During today's lesson, we'll go over some important fundamental concepts related to spreadsheets, including spreadsheet organization, formatting, basic formulas, and data sorting. Once you discover how to create a basic budget spreadsheet, you'll see how the skills and knowledge you gain from this lesson can have a powerful impact on your ability to contribute more in the workplace.
Friday - Lesson 06
In this lesson, we'll discuss more details about the spreadsheet, and how to provide easy-to-understand, accurate data. You'll learn how to build graphs that can graphically display numeric information so you can easily demonstrate trends, analyze past results, and predict future performance. You'll also find out how to use some advanced spreadsheet tools that can make your spreadsheets even more effective.
Wednesday - Lesson 07
During this lesson, we'll examine the components of a database, focusing primarily on the user interface. In your job, you might use this interface to perform a lot of different functions, including data input, data output, and data maintenance. Clerks work with databases to input information. Other employees might work with databases to filter, sort, and read information. Database-management personnel interface with databases to keep them accurate, reliable, and secure.
Friday - Lesson 08
PowerPoint is an important tool for creating presentations suitable for the work environment. This powerful program has many features, but they must be used correctly or else your audience will be distracted or overloaded. In this lesson, we'll explore the best ways to create an effective presentation that incorporates the right mix of multimedia. You'll learn how to insert graphics and audio into your presentation in an effective and organized manner.
Wednesday - Lesson 09
The suite of Microsoft Office products includes Excel and Access, which are both very powerful on their own. In this lesson, you are going to learn how to actually integrate information from one program to the other. You can create data lists with either program and easily transfer the information to the other. Considering all the work we do with lists on the computer, this is a very important skill in today's work environment. Plus, you'll find out how mail merge can save you time and effort by allowing you to customize letters, labels, and more!
Friday - Lesson 10
In today's lesson, we're going to have fun working with the Internet. This is the greatest source of information you'll ever have access to—yet it can be confusing and overwhelming if you are not familiar with the basic Internet tools. You'll really enjoy seeing how easy it is to find information that specifically meets your needs and interests.
Wednesday - Lesson 11
Today, we'll go over various methods for transferring information from one computer to another. We'll explore different terms used to describe the volume of information—or size of a file—and then learn how to most effectively and efficiently move that data from place to place. You'll learn about bytes, megabytes, memory sticks, and external hard drives.
Friday - Lesson 12
In our final lesson, we will focus on putting all your new knowledge to work! We have three specific goals. The first is to identify ways to use your computer skills to find a new job. The second is to use those same computer skills to get a promotion within your current organization. Our third goal is to explore strategies for continued learning in order to support your ever-growing employment goals.
Method of Instruction