CERTIFICATE IN OFFICE AUTOMATION ( M-IT-002 )

Computer Fundamentals Syllabus

Subject Description

This Subject is designed to provide students with a foundational understanding of computers, their components, and basic operations. It covers the essential concepts and principles of computer science, including hardware, software.

Subject Objectives

In this Subject, students will be able to:

1. Understand the basic components of a computer and their functions.
2. Differentiate between various types of software and their applications.

Subject Structure

The Subject is divided into 10 modules, each focusing on a different aspect of computer fundamentals.

Modules

Module 1: Introduction to Computers

• Definition and history of computers
• Types of computers
• Basic computer terminology

Module 2: Computer Hardware

• The CPU, memory, storage devices, input/output devices
• Understanding hardware components and their functions

Module 3: Computer Software

• Definition and types of software (system vs. application)
• Operating systems and their functions
• Introduction to software applications

Prerequisites

None. This Subject is designed for beginners with no prior knowledge of.

Policies

This syllabus is a guideline and may be subject to change based on the instructor's discretion and class needs.

Operating Systems

Introduction to Windows Operating System

Subject Description:
This course provides an overview of the Windows Operating System, focusing on its features, usage, management, and troubleshooting. It is designed for students with little to no prior knowledge of Windows OS.

Subject Objectives:

• Understand the basics of the Windows Operating System.
• Learn how to navigate and use the Windows interface.
• Explore file management and organization.
• Understand system settings and customization.
• Gain knowledge of software installation and management.

• History and versions of Windows
• Basic navigation and usage

• File Explorer and navigation
• Creating, copying, moving, and deleting files and folders
• Organizing files with libraries and tags

• Personalizing the desktop and taskbar
• Adjusting system settings (display, sound, power)
• Managing user accounts and permissions

This syllabus is designed to provide a solid foundation in using and managing the Windows Operating System, preparing students for more advanced topics and real-world applications.

MS Word Beginner Syllabus

Module 1: Introduction to MS Word

• Understanding the interface
• Exploring the Ribbon and Tabs
• Using the Quick Access Toolbar
• Customizing the Quick Access Toolbar

Module 2: Basic Document Creation and Editing

• Creating a new document
• Opening and saving documents
• Basic text entry and editing
• Using the clipboard (cut, copy, paste)
• Undo and redo actions

Module 3: Formatting Text

• Changing font type, size, and color
• Applying bold, italic, and underline
• Using the Format Painter
• Aligning text (left, center, right, justify)
• Working with line and paragraph spacing

Module 4: Working with Lists and Tabs

• Creating bulleted and numbered lists
• Customizing list styles
• Using tabs and tab stops
• Setting indents

Module 5: Page Layout

• Changing page orientation (portrait, landscape)
• Setting margins
• Inserting page breaks
• Viewing and navigating pages

Module 6: Inserting Objects

• Adding images and shapes
• Inserting headers and footers
• Working with text boxes
• Creating hyperlinks

Module 7: Basic Tables

• Inserting a table
• Entering and editing table content
• Merging and splitting cells
• Basic table formatting

Module 8: Printing and Sharing

• Previewing documents
• Adjusting print settings
• Printing selected pages or the entire document
• Saving as PDF
• Sharing documents via email or cloud storage

This syllabus is intended for beginners and can be adjusted based on the learners' needs and the depth of content required.

MS Excel Beginner Syllabus

This syllabus involves covering the essential skills and knowledge that a beginner or intermediate user would need to be proficient in the software.

Introduction to Excel

·       Understanding the Excel interface

·       Navigating the Ribbon and Tabs

·       Creating a new workbook

·       Saving and opening workbooks

Basic Operations

·       Entering and editing data

·       Formatting cells (number format, alignment, font)

·       Basic cell operations (cut, copy, paste, drag-fill)

·       Using AutoSum for quick calculations

Formulas and Functions

·       Understanding formulas and functions

·       Basic arithmetic functions (SUM, AVERAGE, COUNT)

·       Relative and absolute cell references

Working with Data

·       Sorting and filtering data

·       Inserting and deleting rows and columns

·       Basic data organization techniques

Charts and Graphs

·       Creating simple charts (column, line, pie)

·       Formatting chart elements

·       Inserting and modifying chart titles and labels

Printing and View Options

·       Adjusting page setup for printing

·       Using print preview

·       Setting print areas and printing selected ranges

Introduction to Tables

·       Creating and managing tables

·       Using table styles

·       Basic table operations (sorting, filtering within tables)

MS PowerPoint Syllabus

This syllabus involves outlining the fundamental skills and concepts that students should learn.

Introduction to PowerPoint

·       Overview of PowerPoint and its uses

·       Understanding the PowerPoint interface

·       Creating a new presentation

·       Saving and sharing presentations

Basic Slide Layouts and Design

·       Exploring different slide layouts

·       Adding text to slides

·       Using themes and background styles

·       Aligning and arranging objects

Working with Images and Graphics

·       Inserting and formatting images

·       Adding shapes and icons

·       Working with SmartArt graphics

·       Creating and editing charts

Enhancing Presentations

·       Adding transitions and animations

·       Inserting and formatting tables

·       Working with hyperlinks and action buttons

·       Using multimedia elements (audio and video)

Presentation Delivery and Tools

·       Rehearsing timings

·       Using the Presenter View

·       Setting up slide shows

Introduction to Internet and E-Commerce

Subject Description

This Subject provides an overview of the Internet and its role in modern commerce. Students will learn the basics of how the Internet works, the principles of e-commerce, and the various technologies and strategies used in online business.

Subject Objectives

By the end of this Subject, students will be able to:

1. Understand the fundamental concepts of the Internet and its infrastructure.
2. Describe the evolution of e-commerce and its impact on traditional business models.
3. Identify key technologies and platforms used in e-commerce.
4. Analyze the components of a successful e-commerce business.
5. Discuss the legal, ethical, and security issues related to e-commerce.

Subject Outline

Introduction to the Internet

• History and development of the Internet
• Basic Internet technologies: TCP/IP, HTTP, DNS
• Internet service providers and access methods

The World Wide Web and Web Technologies

• Introduction to HTML, CSS, and JavaScript
• Web hosting and domain names
• Search engines and SEO basics

Introduction to E-Commerce

• Definition and types of e-commerce (B2B, B2C, C2C, etc.)
• The e-commerce ecosystem: merchants, marketplaces, payment gateways
• Customer behavior and online shopping trends

Building an E-Commerce Website

• Overview of e-commerce platforms (Shopify, WooCommerce, Magento, etc.)
• Product catalog management
• User experience and interface design

E-Commerce Operations

• Inventory management
• Order fulfillment and shipping
• Customer service and support

Digital Marketing and E-Commerce

• Online marketing strategies: email marketing, social media, PPC advertising
• Content marketing and blogging
• Analytics and performance measurement

Payment Systems and Security

• Payment gateways and processors (PayPal, Stripe, etc.)
• Fraud prevention and detection

This syllabus is designed to be flexible and can be adjusted based on the duration of the Subject and the level of detail required for each topic.

Highschool