B2B Market

Description

COURSE CONTENT

ZCO001: INTRODUCTION TO COMPUTERS
Module 1: Overview of Computer Systems

• Introduction to Computers: Definition and History
• Types of Computers: Desktops, Laptops, Mobile Devices
• Basic Computer Hardware: Input, Output, Storage Devices

Module 2: Introduction to Software

• Software Types: System Software vs Application Software
• Operating Systems: Functions and Types
• Application Software: Word Processors, Spreadsheets, etc.

Module 3: Data Representation

• Binary Number System
• Data Units: Bit, Byte, Kilobyte, etc.
• Understanding File Formats and Extensions

Module 4: Introduction to Networking

• Basics of Computer Networks
• Types of Networks: LAN, WAN, PAN
• Internet Basics: Browsers, URLs, Search Engines

Module 5: Computer Ethics and Security

• Understanding Computer Ethics
• Introduction to Cybersecurity
• Safe Computing Practices

ZCO002: KEYBOARDING
Module 1: Introduction to Keyboarding

• Overview of Keyboard Layouts: QWERTY and Other Variants
• Home Row Keys and Finger Placement
• Importance of Keyboarding Skills

Module 2: Basic Typing Techniques

• Introduction to Touch Typing
• Practice with Home Row and Basic Keys
• Common Typing Exercises

Module 3: Speed and Accuracy Improvement

• Typing Speed Tests
• Accuracy Exercises: Punctuation and Capitalization
• Error Identification and Correction

Module 4: Typing with Numeric Keypad

• Numeric Keypad Layout
• Basic Calculations and Data Entry
• Practice with Numeric Entries

Module 5: Practical Typing Applications

• Typing Documents: Letters, Reports, Emails
• Online Typing Resources and Tools
• Continuous Practice and Improvement

ZCO003: WINDOWS OPERATING SYSTEM
Module 1: Introduction to Windows OS

• Overview of Windows Operating System
• Versions of Windows: History and Evolution
• Basic Windows OS Components: Desktop, Taskbar, Start Menu

Module 2: File Management

• Understanding the File Explorer
• Creating, Renaming, and Deleting Files and Folders
• File Organization and Navigation

Module 3: System Settings and Customization

• Personalizing the Desktop: Wallpapers, Themes, Icons
• Configuring System Settings: Date, Time, Language, etc.
• Understanding Control Panel and Settings App

Module 4: Application Management

• Installing and Uninstalling Software
• Managing Installed Programs
• Task Manager and Performance Monitoring

Module 5: Windows Security and Maintenance

• Understanding User Accounts and Permissions
• Introduction to Windows Security Features: Firewall, Antivirus
• System Backup and Recovery Options

ZCO004: MICROSOFT WORD
Module 1: Introduction to Microsoft Word

• Overview of Word Processing Software
• Microsoft Word Interface: Ribbons, Menus, Toolbars
• Creating and Saving a Document

Module 2: Document Formatting

• Text Formatting: Fonts, Colors, Styles
• Paragraph Formatting: Alignment, Indentation, Line Spacing
• Working with Lists: Bullets and Numbering

Module 3: Advanced Document Formatting

• Page Layout: Margins, Orientation, Size
• Working with Headers, Footers, and Page Numbers
• Using Styles and Templates

Module 4: Inserting and Editing Content

• Inserting Tables, Images, and Shapes
• Using SmartArt, Charts, and WordArt
• Inserting Hyperlinks and Bookmarks

Module 5: Proofing, Reviewing, and Finalizing Documents

• Spelling and Grammar Check
• Track Changes and Comments
• Printing and Exporting Documents

ZCO005: MICROSOFT EXCEL
Module 1: Introduction to Microsoft Excel

• Overview of Spreadsheets
• Microsoft Excel Interface: Workbooks, Worksheets, Cells
• Creating and Saving a Workbook

Module 2: Working with Data

• Entering and Editing Data
• Basic Formulas and Functions
• Sorting and Filtering Data

Module 3: Formatting Cells and Data

• Formatting Cells: Number, Currency, Date
• Applying Conditional Formatting
• Using Themes and Styles

Module 4: Data Analysis and Visualization

• Creating and Editing Charts
• Using PivotTables and PivotCharts
• Introduction to Data Analysis Tools

Module 5: Advanced Excel Functions

• Working with Advanced Formulas: VLOOKUP, HLOOKUP, IF, etc.
• Data Validation and Protection
• Sharing and Collaborating on Workbooks

ZCO006: MICROSOFT ACCESS
Module 1: Introduction to Databases

• Overview of Database Concepts
• Introduction to Microsoft Access Interface
• Creating and Saving a Database

Module 2: Designing a Database

• Creating Tables and Defining Fields
• Setting Primary Keys and Data Types
• Establishing Relationships between Tables

Module 3: Querying the Database

• Creating Basic Queries: Select, Update, Delete
• Using Criteria to Filter Data
• Creating Calculated Fields in Queries

Module 4: Forms and Reports

• Designing Forms for Data Entry
• Customizing Form Layouts and Controls
• Creating and Customizing Reports

Module 5: Advanced Database Management

• Working with Macros and Modules
• Importing and Exporting Data
• Database Backup and Maintenance

ZCO007: MICROSOFT PUBLISHER
Module 1: Introduction to Desktop Publishing

• Overview of Microsoft Publisher
• Publisher Interface: Menus, Toolbars, and Ribbons
• Creating and Saving Publications

Module 2: Designing Publications

• Working with Layout Guides and Rulers
• Inserting and Formatting Text Boxes
• Inserting Images and Shapes

Module 3: Working with Templates and Themes

• Using Built-in Templates
• Customizing Templates for Different Types of Publications
• Applying and Modifying Themes

Module 4: Creating and Formatting Content

• Working with Tables, Charts, and Calendars
• Adding and Editing Borders and Backgrounds
• Creating Professional Brochures, Flyers, and Newsletters

Module 5: Finalizing and Publishing Documents

• Proofing and Reviewing Publications
• Exporting Publications to PDF and Other Formats
• Printing and Distributing Publications

ZCO008: MICROSOFT POWERPOINT
Module 1: Introduction to Microsoft PowerPoint

• Overview of Presentation Software
• PowerPoint Interface: Slides, Ribbons, Toolbars
• Creating and Saving a Presentation

Module 2: Designing Slides

• Inserting and Formatting Text
• Working with Slide Layouts and Themes
• Adding and Formatting Images and Shapes

Module 3: Creating Effective Presentations

• Using SmartArt, Charts, and Graphs
• Adding Multimedia: Videos, Audio, Animations
• Applying Transitions and Effects

Module 4: Slide Show Preparation and Delivery

• Customizing Slide Show Settings
• Rehearsing and Timing the Presentation
• Presenting the Slide Show: Tips and Techniques

Module 5: Reviewing and Sharing Presentations

• Proofing and Reviewing Slides
• Exporting Presentations: PDF, Video Formats
• Sharing and Collaborating on Presentations

ZCO009: NETWORKING & INTERNET
Module 1: Introduction to Networking

• Overview of Networking Concepts
• Types of Networks: LAN, WAN, PAN, MAN
• Basic Networking Hardware: Routers, Switches, Cables

Module 2: Networking Protocols and Models

• Understanding the OSI and TCP/IP Models
• Common Networking Protocols: HTTP, FTP, SMTP, etc.
• IP Addressing and Subnetting

Module 3: Introduction to the Internet

• Overview of the Internet: History and Evolution
• Internet Services: Email, Web, FTP
• Understanding Domain Names and DNS

Module 4: Web Browsing and Online Safety

• Using Web Browsers: Features and Functions
• Safe Browsing Practices: Avoiding Malware and Phishing
• Introduction to VPNs and Proxies

Module 5: Basic Network Troubleshooting

• Identifying Network Issues
• Basic Tools: Ping, Traceroute, nslookup
• Network Troubleshooting Techniques

ZCO010: BASIC COMPUTER TROUBLESHOOT
Module 1: Introduction to Computer Troubleshooting

• Overview of Common Computer Issues
• Importance of Troubleshooting Skills
• Troubleshooting Process: Identify, Diagnose, Resolve

Module 2: Hardware Troubleshooting

• Identifying Common Hardware Problems
• Basic Hardware Diagnosis: Power, Display, Peripherals
• Replacing and Upgrading Components

Module 3: Software Troubleshooting

• Troubleshooting Software Issues: Crashes, Freezes, Errors
• Identifying and Removing Malware
• Reinstalling and Repairing Software

Module 4: Network Troubleshooting

• Diagnosing Network Connectivity Issues
• Common Network Problems: IP Conflicts, Slow Speeds
• Troubleshooting Internet Connection Issues

Module 5: Preventative Maintenance

• Routine System Maintenance: Updates, Backups, Cleanup
• Best Practices for Extending Hardware Life
• Creating a Troubleshooting and Maintenance Plan

RESOURCE CENTERS

1. STUDENT PORTAL dlm.nestict.com
2. ELMS PORTAL      lms.nestict.com
3. GENERAL NOTES blog.nestict.com

THE TRAINING WILL BE CONDUCTED AT THE ZONAL CYBERCAFE NEXT TO JESUS REVIVAL GOSPEL CENTER, MIGADINI.