About This Course
What you will learn:
|
|
Study Computer Skills of the Workplace Online Course Learn How to Implement the Powers of Modern Office Software
Most jobs today require a working knowledge of certain computer skills. Employers seek and reward employees with the skills and knowledge to send messages across the country via e-mail; use a spreadsheet to create a graph and paste it into a report; add and edit data in a database; understand the implications of file sizes, memory limitations, and network arrangements; and recognize the function and features of modern computer components. Any job candidate who already possesses these skills will stand above those who do not.
With the ever-evolving digital landscape, it's more important than ever to stay up-to-date on the latest advances in technology. From basic computer skills such as file management and word processing to more advanced topics, like Artificial Intelligence (AI) and computer networks, you’ll learn everything you need with CFS.
This computer skills for the workplace online course is designed to provide the fundamental computer competencies you need to survive and prosper in today's fast-changing workplace.
You will learn how to implement the powers of modern office software to work faster and more efficiently.
We'll focus on practical applications for software most common to the workplace. When you finish this course, you will have learned why employers consider technological literacy so critical to the success of any organization.
What you will learn with our Computer Skills of the Workplace Online Course
● The Workplace Technology Solution
● E-Mail and Scheduling
● Creating and Formatting Documents
● More Advanced Formatting
● Spreadsheet Basics
● Formatting, Charts, and Printing
● Database Basics
● Creating and Editing a Presentation
● Integrating Microsoft Office Programs
● Using the Internet
● Transferring and Protecting Data
● Putting Your Skills to Work
Computer Skills of the Workplace Online Course - Requirements
The Computer Skills of the Workplace Course is delivered 100 percent online 24/7.
To successfully complete this course, a student must:
● Have access to the internet and the necessary technical skills to navigate the online learning resources
● Have access to any mobile device with internet connectivity (laptop, desktop, tablet)
● Be a self-directed learner
● Possess sound language and literacy skills
Quick Course Facts
Course content is structured for easy comprehension
Registered students gain unrestricted access to the Computer Skills of the Workplace Course
All course material is available online 24/7 and can be accessed using any device
Study online from anywhere in your own time at your own pace
All students who complete the course will be awarded with a certificate of completion
For any additional questions please see our comprehensive FAQS tab below.
Computer Skills of the Workplace Online Course Outline
Lesson 1: Overview: The Workplace Technology Solution
Chapter 1: Introduction
Employees who can't send an e-mail with an attachment, don't know how to format tables in a document, or can't insert formulas in a spreadsheet irritate managers. If you can show them right away in your resume that you can accomplish all of those things with ease, your resume will have a far better chance of making it through the first round.
Chapter 2: The Windows 10 Desktop
You've probably used some of these functions before, but it never hurts to go over them again and make sure you understand what they all do.
Topics to be discussed include:
● Using Shortcuts
● Managing Open Windows
Chapter 3: Controls
When you use programs on your computer, you'll notice that there are numerous ways to control the program's contents. These could be buttons that you press, boxes that you input into, or other methods of selecting data. The majority of the controls in Office 2016 are organized into Ribbons. These can be seen running across the top of your screen. By clicking the tabs above the Ribbon, you can access different ribbons.
Chapter 4: Files and Folders
All of the data on your computer is saved in individual files. Even if your computer is brand new, it has thousands of files. You'll generate new files as you use the various programs. Soon, that computer will have tens of thousands of files, and your task will be to keep them all organized so that you can quickly access the ones you need, even years after they were generated.
Topics to be discussed include:
● File Name Components
● Common Tasks in File Explorer
● How to rename a folder or file
● How to delete a file or folder
● How to move files from one folder to another
● How to create a new folder
Chapter 5: Summary
You'll be one step ahead of your competition if you grasp the importance of computer skills in the workplace and have a good idea of what human resources managers are looking for. Developing and strengthening computer abilities isn't just for job seekers. They're also necessary for people who desire to advance in their careers.
Lesson 2: Outlook: Email and Scheduling
Chapter 1: Introduction
Outlook is a popular email and calendar program used by many businesses. Office workers typically keep Outlook open throughout the day and then open and close other programs as needed. This is useful, but it can also be annoying at times. Outlook, on the other hand, has immense power. This useful tool will assist you in being more organized and developing crucial communication skills.
Chapter 2: E-mail Setup and Use
The program may manage multiple accounts at the same time, with one of them being chosen as the default account. This implies that until you specify otherwise, an email will be sent from that account.
Topics to be discussed include:
● Creating and Sending Email
● Creating a Signature
● Receiving Email
● Creating and Maintaining Email Folders
Chapter 3: E-mail Attachments
Sending attachments is one of the most important features of email. An attachment is a digital file that contains information that you wouldn't ordinarily type into the email body. You wouldn't enter a 10-page handbook into a message, but you could attach it as a PDF if you wanted to distribute it to technicians at a remote location.
Topics to be discussed include:
● Email Etiquette
Chapter 4: Additional Outlook Functions
When people think of Outlook, they think of email. However, as you'll see, it has a number of other quite useful features. The explosive proliferation of personal data devices is one reason why these functions have become so crucial. Outlook is usually synchronized with smartphones and other mobile devices.
Topics to be discussed include:
● Using Outlook's Calendar
● Editing Calendar Appointments
● Using Outlook's Contact List
Chapter 5: Summary
Microsoft Outlook's capabilities are really useful, especially given how crucial multitasking has become and how many demands we have in our busy lives. Understanding them is, of course, the key to employing them.
Lesson 3: Word: Creating and Formatting Documents
Chapter 1: Introduction
Moving on to the next level, we'll discuss how to use Microsoft Word to produce and edit professional-looking documents. This software is the most widely used program for preparing electronic documents in the corporate world today. A word processor is Microsoft Word. There are plenty different word processors available. Some offer a feature set that is comparable to Microsoft Word's.
Chapter 2: Starting Microsoft Word
The first step in writing a document is to launch the Microsoft Word application. That may appear to be a simple task, but there are several options available, and you should choose the one that best suits your needs. You can utilize a shortcut on your desktop or taskbar or choose Word from the Start button menu.
Topics to be discussed include:
● Getting Familiar With Word
● Save and Save As
Chapter 3: Managing Files
Now that you've learned a little about saving files, it's time to talk about how to organize them. Figure out a way for naming files and creating and naming folders that works for you as you start creating files in Word. The key to opening and modifying files once your naming scheme is in place is to be aware of which file you've opened.
Topics to be discussed include:
● Editing Documents
Chapter 4: Formatting Basics
The Font group's buttons regulate text style and size, as well as some upgrades like underline, bold, and italic.
Topics to be discussed include:
● Format Painter
Chapter 5: Summary
In their regular work, many employees utilize a word processor more than any other software. While there are several options on the market, most businesses nowadays use Microsoft Word. This word processor is a computer program that allows you to create and edit documents using text and graphics.
Lesson 4: Word: More Advanced Formatting
Chapter 1: Introduction
We'll use some of Word's more complex capabilities to take our documents to the next level.
Chapter 2: Paragraph Formatting
We'll now look at how you can change the appearance of entire paragraphs in your document. Maybe you want to put a paragraph in the middle of your page, or develop a bulleted list to make your content easier to read. You may achieve this using the functions in the Paragraph group on the Home tab, which is just to the right of the Font group.
Topics to be discussed include:
● Aligning and Spacing Paragraphs
● Bullets and Numbering
Chapter 3: Professional Editing
You may use a variety of tools in Word to rapidly make your papers look professional and vibrant. Even though these tools are simple to use and offer a wide range of options, it's surprising how few people use them. It all boils down to preparation. Templates and Styles are two of these tools.
Topics to be discussed include:
● Templates
● Styles
● Removing a Style
Chapter 4: Tables, Graphics, and Finishing Touches
Tables make it easier for readers to understand information, and you can then add pictures to truly grab their attention.
Topics to be discussed include:
● Tables
● Graphics
● Spelling and Grammar Check
Chapter 5: Summary
Lists, both bulleted and numbered, are powerful tools for conveying information. The variety of numbering formats can be intimidating at first, but with practice, you'll be able to apply them in your work. Shortcuts to success are Templates and Styles. Use them to create papers fast that might otherwise take too long. Tables are an excellent method to organize and show data.
Lesson 5: Excel: Spreadsheet Basics
Chapter 1: Introduction
Learning Microsoft Excel will help you advance in your career. You can use this program to achieve many fantastic things in the office, regardless of your job function, but few people take the effort to learn how to use it properly. Many people believe, incorrectly, that it is simply too tough to find out.
Chapter 2: Getting Familiar With Excel
When you first launch Excel, it produces a blank spreadsheet. When you first open Excel, you'll find that it uses the same methodology to handle organization as Microsoft Word. Ribbons are accessible by tabs, and groups are contained within ribbons. There are several controls in each group. Many of the tabs, groups, and controls found in Excel are comparable to those found in Word.
Topics to be discussed include:
● Spreadsheet Formatting
● Text
Chapter 3: Building a Worksheet
Topics to be discussed include:
● Creating a Title
● Using AutoFill
● Adding Formulas
Chapter 4: Columns and Rows
A spreadsheet is essentially a large table, as you can see. Controlling the width of the columns, the height of the rows, and the appearance of any lines between them is an important component of formatting. In this chapter, we'll look at those alternatives. Column widths and row heights must be considered while creating a spreadsheet.
Topics to be discussed include:
● Borders
Chapter 5: Summary
Excel is a spreadsheet program that is specially intended to work with numbers. Many of the options you learned about in Word are available in this program. This makes switching between Office programs a breeze. Spreadsheets, often known as workbooks, are similar to large tables. They have a lot of rows and columns, and a cell is the intersection of two rows and columns.
Lesson 6: Excel: Formatting, Charts, and Printing
Chapter 1: Introduction
The numbers on spreadsheets can grow very complicated at times, making it difficult for readers to understand the information they provide. When this is the case, charts can be used to graphically portray data.
Chapter 2: Adding Rows and Columns
Topics to be discussed include:
● Calculating Averages
● Using the Sort Options
Chapter 3: Creating Charts
Excel has a wide range of chart kinds to pick from, as well as several options for each kind. We'll look at two of the most frequent types of charts, discuss why you'd use each one, and then look at how to update existing charts in this course.
Topics to be discussed include:
● Column Charts
Chapter 4: Viewing and Printing in Excel
Excel spreadsheets are a little different from your usual document when it comes to previewing and printing your work. It might be difficult to get everything to print out the way you want it to because they can hold so much information.
Topics to be discussed include:
● Excel Views
● Printing Spreadsheets
Chapter 5: Summary
You'll probably want to add more information to your spreadsheet as time goes on once you've created it. In most cases, adding data entails inserting rows or columns. You learnt how to do this by selecting one or more rows and columns, then right-clicking and selecting Insert, or using the Insert button on the Home tab's Cells group.
Lesson 7: Access: Database Basics
Chapter 1: Introduction
Databases can be found all over the place. You most likely use them on a daily basis without even realizing it. You connect with a database every time you use your ATM card. A database is used to log into any software, including this course. Databases are used by most businesses for a variety of purposes. Probably the most popular one is a list, sometimes large, of clients and future consumers.
Chapter 2: Database Components
Although a database is basically a table, the various components of a database are referred to by different names. Fields and records are terms used to describe the columns and rows of a database. A rudimentary database can resemble a simple address book.
Topics to be discussed include:
● Creating a Database in Access
Chapter 3: Queries
Query may sound like a technical term reserved for programmers, but it's actually fairly straightforward. A query is nothing more than a request for data from a database. Sort and filter are the two main functions associated with inquiries. Sorting entails arranging items in a specific order. Excel is a database program, yet everyone refers to it as a spreadsheet software.
Topics to be discussed include:
● Inputting Data With Forms
● Creating Reports
Chapter 4: Database Management
All that's left now is to manage your database after you've created it, named your fields, and created your form. Maintaining data accuracy, preserving data from destruction, and restoring data in the event of a crisis are the three basic components of database management.
Topics to be discussed include:
● Maintaining Data Accuracy
● Data Protection
● Data Restoration
Chapter 5: Summary
You learnt a lot about databases in this class. As you can see, we use databases in a variety of ways on a daily basis. A database can be a valuable asset to a corporation depending on the information it includes. We learned that a database is nothing more than a table (or a collection of tables) that stores data in rows and columns.
Lesson 8: PowerPoint: Creating and Editing a Presentation
Chapter 1: Introduction
You've definitely sat through at least one PowerPoint presentation in your life, whether it was a sales pitch, a research presentation, an annual sales report, or a forwarded email attachment. Microsoft's presentation software has become a standard in the modern industry and school due to its ease of use and power.
Chapter 2: Slides
A PowerPoint presentation's basic components are called slides. You're simply producing a series of slides when you make a presentation. You'll tailor the content of each one to match the objectives of the presentation's various stages in a relevant and engaging manner.
Topics to be discussed include:
● Themes
● Notes
● Strategies for Effectiveness
Chapter 3: Graphics, Animations, and Audio
Keep in mind that using a PowerPoint presentation rather than merely writing words on a whiteboard has the advantage of allowing you to incorporate images and other media to create a more powerful and relevant message. A presentation can be enhanced with images, animations, and audio, as well as transitions, which determine how the presentation flows from one slide to the next.
Topics to be discussed include:
● Adding Graphics
● Adding Audio
● Adding Animation
● Strategies for Effectiveness
Chapter 4: Presenting, Publishing, and Printing
The Slide Sorter is an important display choice. On the main area of the screen, you can see all of your slides in this view. It comes in handy when you need to rearrange your slides.
Topics to be discussed include:
● Exporting
● Printing
● Strategies for Effectiveness
Chapter 5: Summary
You learned how to make a PowerPoint presentation in Lesson 8. You've seen that there are a variety of slide kinds to pick from, each of which is suited for a specific aspect of your presentation. Of course, you can change the look of every slide by adding, modifying, or removing elements like text boxes and graphics.
Lesson 9: Integrating Microsoft Office Programs
Chapter 1: Introduction
One of the concepts we'll cover is information exchange across programs. On a far larger scale, this is an important topic as well. Companies are constantly looking for new ways to share electronic data. Electronic Data Interchange, or EDI for short, is a term used in several industries to describe data sharing.
Chapter 2: Exporting Data
Sending information out and bringing information in are the two fundamental functions of data sharing. It's called exporting data when we transmit data out of a software. Importing data is the process of bringing data into a program. We'll concentrate on data exporting in this chapter.
Topics to be discussed include:
● Exporting Data From Excel
● Exporting Data From Access
Chapter 3: Importing Data
Importing data involves putting information into a program that isn't part of the program's normal files. We can bring data into Access that isn't from an Access database file, and we can import data into Excel that isn't from an Excel spreadsheet file. In the 2016 versions of Access and Excel, Microsoft has considerably improved the importing tools, making it easier to import data.
Topics to be discussed include:
● Importing Data to Access
● Importing Data to Excel
● Exporting and Importing Wrap-Up
Chapter 4: Mail Merge
A mail merge allows you to send the same letter to multiple persons while also personalizing certain elements of the letter with information relevant to each recipient.
Chapter 5: Summary
We looked at how to link our Microsoft Office products in this class. We basically learned how to transfer data from one program to another. On a larger scale, information sharing, also known as Electronic Data Interchange, can save a lot of time and effort, making it a crucial activity in the workplace.
Lesson 10: Using the Internet
Chapter 1: Introduction
ARPA developed technology that linked important information centers, including several of the country's best colleges, so they could share information quickly. Later, when the technology became more widely used, the government made it available for public use. We now refer to it as the Internet.
Chapter 2: The Browser Window
Many people use Internet Explorer or Firefox from Microsoft. Safari and Chrome are two other popular choices. Each has its own method of organizing its tools, but they all serve the same purpose. Microsoft has released a new browser application named Edge for Windows 10. This is what we'll be using for this lesson. The option to view websites in Internet Explorer is also available in Microsoft Edge.
Topics to be discussed include:
● Getting Around the Web
● Hyperlinks
● Navigation Buttons
● Favorites
●