Computer And Information Technology

Program Description

Charts allow you to communicate information visually, in a way that’s more impactful than raw data, and they happen to be one of the most powerful and easy-to-use features in Microsoft Excel. Let Dennis Taylor show you how to create different kinds of Excel charts, from column, bar, and line charts to exploded pies, and decide which type works best for your data. Plus, learn how to fine-tune your chart’s color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.

Course Duration

4 Total Hours

Specific Objectives

At the end of the course, the students should be able to know the following:

1. Selecting the right chart type?
2. Choosing data to display as a chart.
3. Creating charts fast with the Quick Analysis tool.
4. Choosing a chart layout.
5. Changing the location of the source data.
6. Dealing with empty and hidden cells.
7. Moving and resizing charts.
8. Adding data labels.
9. Analyzing existing and future data with trendlines.
10. Adding shapes and arrows.
11. Working with column, bar, line, pie, and area charts.
12. Working with specialized chart types: Gantt, Pareto, and Frequency charts.
13. Creating dynamic charts.
14. Printing and sharing your chart.

Program Description

Whether you’re a novice or an expert wanting to refresh your skillset with Microsoft Excel, this course covers all the basics you need to start entering your data and building organized workbooks. Author Dennis Taylor teaches you how to enter and organize data, perform calculations with simple functions, work with multiple worksheets, format the appearance of your data, and build charts and PivotTables. Other lessons cover the powerful IF, VLOOKUP, and COUNTIF family of functions; the Goal Seek, Solver, and other data analysis tools; and how to automate many of these tasks with macros.

Course Duration

16 Total Hours

Specific Objectives

At the end of the course, the students should be able to know the following:

1. What is Excel and what is it used for?
2. Using the menus.
3. Working with dates and times.
4. Creating simple formulas.
5. Formatting fonts, row and column sizes, borders, and more.
6. Inserting shapes, arrows, and other graphics.
7. Adding and deleting rows and columns.
8. Hiding data.
9. Moving, copying, and pasting.
10. Sorting and filtering data.
11. Printing your worksheet.
12. Securing your workbooks.
13. Tracking changes.

Program Description

The course will expose students to a suite of open source software tools useful for knowledge workers. This includes software for word processing, spreadsheets, presentation, electronic mail, and graphics. Not only that, in this course, students will also know the fundamentals of Presentation Skills.

Course Duration

60 Total Hours

Specific Objectives

After completing this course, students will be able to:

1. Master the Microsoft Office application software particularly using Word, Excel, and Powerpoint;
2. Have a glimpse background on what GIMP (Photo Editing) Software is;
3. Use Outlook for e-mail messages and calendar task;
4. Develop critical thinking and logical reasoning;
5. Acquire desirable habits and attitudes in learning the course;
6. Develop the values of accuracy, neatness, and of being systematic;
7. Imbibe the values of honesty, orderliness, patience, and persistence in one’s work in order to carry on such desirable traits in the practice of one’s profession.

Course Description

This course provides the students with the knowledge and skills necessary to install, configure, administer, and manage mail and web services. Topics include system installation and configuration, administrative utilities, creating and managing storage groups and stores, SMTP, configuring internet protocols, disaster recovery, etc.

Duration: 70hrs

Course Objectives

At the end of the course, the students should be able to:

  1. Obtain the hardware and software information necessary to conduct installation;
  2. Configure and administer mail and web services;
  3. Implement mail and network services;
  4. Develop critical thinking and logical reasoning;
  5. Acquire desirable habits and attitudes in learning the course;
  6. Imbibe the values of honesty, orderliness, patience, and persistence in one’s work in order to carry on such desirable traits in the practice of one’s profession.

Course Description

This course is an introduction of the principles of network security, and the configuration of security on both separate and shared networks. It also provides detailed discussion on network security, including encryption techniques, design of secure systems and protocols, as well as enhancement for existing internet and related protocols.

Duration: 70hrs

Course Objectives

At the end of the course, the students should be able to:

  1. Discuss the scope of network security;
  2. Set up network firewalls;
  3. Perform the techniques of encryption;
  4. Develop defense measures against network security threats;
  5. Configure network security protocols.

Program Description

In Powerpoint 2010 Essential Training, author David Diskin demonstrates how to engage an audience with images, video, sound, charts, and diagrams in professional presentations. The course also covers a variety of methods to share presentations with others and provides comprehensive tutorials on how to design presentations that successfully deliver a quality message.

Course Duration

16 Total Hours

Specific Objectives

At the end of the course, the students should be able to:

1. Using the Office 2010 Backstage View.
2. Using and customizing the Office 2010 ribbon.
3. Starting a presentation from scratch.
4. Applying slide layouts for consistency.
5. Rearranging slides.
6. Running a presentation for an audience.
7. Formatting with font, color, bullets, and alignment.
8. Adding and customizing photos, clip art, shapes, audio, and video.
9. Applying picture effects such as background removal, brightness, and color effects.
10. Modifying slide masters.
11. Adding a logo to the background.
12. Adding and customizing tables, charts, diagrams, and data from Excel.
13. Printing a presentation.
14. Sharing a presentation with others through video, the web, SharePoint, and PDF.

Program Description

Get a new Windows 10 PC ready for general home use, family sharing, or a small office. This course explores the first things to do after unpacking your new PC, including connecting to Wi-Fi, registering the computer, and personalizing your account. Expert author Joli Ballew then explores important backup and recovery options, including how to configure and use System Restore. She shows how to remove all the unnecessary and unwanted software and then add your desired software and apps. The course wraps up with some advanced tasks, including setting program defaults, configuring virtual desktops, adding users, and configuring family safety and security settings.

Course Duration

1 Hour and 9 Minutes

Topics Include

1. Registering a new PC
2. Connecting to networks
3. Installing updates
4. Setting up backups
5. Creating a recovery drive
6. Installing software
7. Setting program defaults
8. Adding users
9. Configuring Family Safety
10. Accessing media

Program Description

Are you a help desk specialist or the go-to technical troubleshooter in your department? If people rely on you to diagnose and fix their computer issues, this course was designed to help you help them. Join PC expert Dan Gookin as he takes you through diagnostic and repair steps. First, he explains how to determine if the source is hardware or software related. Then he provides instructions on how to resolve the most common issues, such as dealing with errors, running recovery processes, leveraging the Task Manager, fixing Windows, and more. In addition, he also demonstrates maintenance techniques to help protect storage drives and how to address problems you encounter with devices like printers and monitors. He wraps up with how to restore network and Internet connectivity.

Course Duration

2 Hours and 12 Minutes

Topics Include

1. Diagnosing the causes of PC issues.
2. Troubleshooting hardware and software.
3. Performing startup and system restore steps.
4. Accessing the Task Manager.
5. Using the Registry Editor.
6. Fixing Windows.
7. Maintaining storage drives.
8. Restoring network connectivity.

Course Description

This course deals with the software tools and environments for developing dynamic, secured and database-driven web applications using PHP and MySQL. Cross-Site Scripting (XSS) attacks, Cross-Site Request Forgery (CSRF/XSRF) attacks, SQL Injections, SSL Certificates, SSH and other security issues for a web application is also discussed in this course.

Duration: 70hrs

Course Objectives

At the end of the course, the students should be able to:

  1. Learn the platform-neutral fundamentals of dynamic and secured web application development.
  2. Learn how to implement a web application using one specific set of open source server-side tools.
  3. Efficiently continues to expand their web development knowledge on their own.
  4. Have a level of web application security knowledge exceeding that of many web developers in industry.

Program Description

Being able to administer a Windows machine is a key skill for any Windows administrator. Keep your skills sharp and up to date with this Windows 10 administration training. Martin Guidry takes a detailed look at the operating system, focusing on the administrative tasks necessary for keeping Windows 10 in tiptop shape.

Course Duration

2 Total Hours

Topics Include

1. Understanding the different versions of Windows 10.
2. Installing and updating drivers.
3. Administering multitasking.
4. Working with Windows Group Policy.
5. Adding domain users and accounts to a Windows 10 PC.
6. Administering BitLocker and EFS.
7. Understanding the boot process.
8. Installing Client Hyper-V for Windows virtualization.
9. Managing Windows Firewall.
10. Backing up and restoring Windows 10.
11. Troubleshooting Windows 10.

Program Description

Learn all the essential features of Windows 10. This comprehensive course covers everything you need to know to install Windows, customize it to your liking, and start working with files and applications. Author Nick Brazzi shows how to manage folders, use Cortana to search and navigate, browse the web with the new Microsoft Edge browser, and work with Mail, Calendars, and People (aka contacts).Plus, learn about sharing via a home network, multiuser configurations, security and privacy, and troubleshooting Windows.

Course Duration

8 Total Hours

Topics Include

1. Installing or upgrading to Windows 10.
2. Connecting to the Internet.
3. Launching, quitting, and managing applications.
4. Creating, copying, moving, and renaming files and folders.
5. Zipping and unzipping files.
6. Using Cortana to search.
7. Browsing the web with Edge.
8. Sending email.
9. Installing new apps.
10. Sharing files over home networks.
11. Backing up and restoring files.
12. Configuring Windows updates.
13. Using Windows Defender.

Program Description

Start building better documents with Microsoft Word. In this course, author David Rivers teaches you the basics of creating, editing, and formatting documents in Word 2013. Discover how to leverage templates and building blocks to create a stylish document with instant purpose; collaborate with other writers and editors; create numbered and bulleted lists; and work with tables. Plus, learn to automate these tasks with macros, and use the proofing tools in Word to check spelling and grammar and more.

Course Duration

16 Total Hours

Specific Objectives

At the end of the course, the students should be able to:

1. Creating new documents.
2. Saving documents and document versions.
3. Editing PDFs in Word.
4. Cutting, copying, and pasting text.
5. Finding and replacing text.
6. Undoing mistakes.
7. Adjusting paragraph and page formatting.
8. Applying themes and styles to documents.
9. Illustrating with pictures, shapes, and clip art.
10. Creating and saving macros and Quick Parts.
11. Checking spelling and grammar.
12. Tracking changes and inserting comments.

Program Description

Learn how to use Word styles to help save time creating consistent and well-designed documents. Author Gini Courter demonstrates the benefit of styles and shows how to create, apply, and modify a variety of style types, from paragraph styles to list styles. More advanced topics include generating a dynamic table of contents from styles, using Quick Styles and style sets, restricting formatting and document use with styles, using keyboard shortcuts, and much more.

Course Duration

4 Total Hours

Specific Objectives

At the end of the course, the students should be able to:

1. Understanding the different types of styles;
2. Creating styles;
3. Applying styles;
4. Basing new styles on existing styles;
5. Editing styles;
6. Formatting a document in one click with Quick Styles;
7. Copying, deleting, and renaming styles;
8. Creating a table of contents with styles;
9. Managing style options, such as keyboard shortcuts and template defaults.

Program Description

If you know how to use templates, you can become much more efficient in Word. In this course, Gini Courter helps you get the most out of templates in Word 2013. She shows how to find, open, and customize the thousands of existing templates, as well as how to transform your own documents into templates you can reuse again and again. Next, explore template styling and ways of locking down certain areas of a document to keep users from editing them. Then discover how to share templates—via email, a network, and SharePoint—and dig into advanced features, including building blocks, content codes, and add-ins.

Course Duration

2 Total Hours

Specific Objectives

At the end of the course, the students should be able to:

1. Opening, customizing, and saving templates.
2. Converting an existing document to a template.
3. Best practices for template creation.
4. Styling your templates.
5. Restricting editing to certain areas.
6. Modifying the Normal template.
7. Sharing templates via email and SharePoint.
8. Using building blocks.
9. Using content controls.
10. Using field codes.
11. Creating and attaching add-ins.