ACERT-USA

ITRC offers Computer Education Programs and Courses for school students from class VI to class XII. These programs provide International Certification from ACERT (AMERICAN COUNCIL FOR EDUCATION RESEARCH & TRAINING). These courses enable the students to acquire knowledge about various programming tools and office automation tools as well.

School Project
CLASS XII
Duration: 90Hrs.
Syllabus:
Unit-1: Overview of Fundamentals, MS-Word, PowerPoint and Excel (20 Hours)

Unit-2: Overview of networking concepts and Internet. (10 Hours)

Unit-3: Programming in C (40 Hours) History of C language, keywords, identifiers, variables and data types in C Simple C Program, compiling C Program. Decision making in C Loops- Do-While 0, While 0 and For 0 If…Else Arrays and Functions, Introduction to pointers Structures and unions. File management in C

Unit- 4: Introduction to Software Engineering (10 Hours)
System development life cycle Phases of system development Initiation, analysis, development, testing, maintenance

Unit 5: Project in C Language (10 Hours)

CLASS XI
Duration: 90 Hrs.
Syllabus:
Unit-1: Overview of Fundamentals (26 Hours) MS-Word, PowerPoint and Excel

Unit-2: Introduction to programming logic and techniques (10 Hours) constants variables, data types, keywords, identifiers, relational and logical operators, arithmetic operators, do case and end case, IF and NESTED IF, Introduction to loop - FOR Loop, while loop, do while loop, until loop, Flowcharts, pseudo codes, algorithms.

Unit-3: Number system & Boolean Algebra (6 Hours) Introduction to binary, octal, decimal & hexadecimal no system, conversions of one no system to another no system, binary addition, subtraction, multiplication & division, 1's complement & 2's complement.

Unit-4: Fundamentals of C (30 Hours).
History of C language, keywords, identifiers, variables and data types in C Simple C Program, compiling C Program. Decision making in C Loops- Do-While, While and For.

Unit-5: Networking Concepts and Internet (8 Hours).
Types of networks, need of networks, Internet and its use, LAN, WAN and MAN, Internet, History of Internet, Advantages of Internet, E-mail, Terms used in internets, WWW, URL, Web Page and browser, Addressing Systems, Hyperlinks, Hypertext, Home Page, Using Search- Engine.

CLASS X
Duration: 90 Hrs.
Syllabus:
Unit-1: Introduction to Computer Fundamentals (8 Hours) IT Concepts: -Definition of Computers, Characteristics of computer - Speed, Diligence, Accuracy, Versatility, and Storage. Basic Applications of Computers, Concept of Hardware and Software, Components of computer Hardware and. software, Computer Memory - Primary, secondary, RAM & ROM, units of memory, Input/output devices Classification of Software, Operating System and its functions, history of computers and its generationsClassification of computers, Computer Languages - Machine Language, Assembly Language and High Level Language, Role of Assembler and Compiler

Unit-2: MS Word. MS PowerPoint. MS Excel. MS Access (55 Hours) MS Word: Formatting Text: - Font Level Formatting, Aligning Text, bullet and numbering, border and shading, change case, Working with Tabs, Indents & Spacing, Formatting paragraphs Working with tables: Creating a table, adding text to tables, adding/deleting rows and columns, resizing rows and columns, deleting a table, splitting and merging cells. Inserting elements:- page numbers, headers and footers, date and time, pictures and hyperlinks. Mail merge, printing labels and envelopesMicrosoft PowerPoint: Customizing Presentation: -Using templates, selecting a slide layout, using undo, redo, changing slide layouts, adding clip art to your presentation, Background color/designs to slides Using slide transition:- giving timing, sound and adding animations in slides and using preset animations, custom animations

MS Excel: Creating & Editing Workbooks:- Working with spreadsheet, Entering numbers, text, Date/Time, Series Using AutoFill, Editing the worksheet, Inserting/Deleting rows, columns and cells Formatting Workbooks:- Formatting worksheet including change color, size, font, Formatting of rows, columns and cells Viewing, Drawing & Printing:- Viewing the worksheet, Adding headers & footers, working with page setup, setting a print area, using print preview & printing Using Formulas and Functions such as Sum (), Average(), Max(), Min(), If() Embedded charts of various types-Line, Pie, Scatter, Bar and Area in Worksheet.

MS Access: Starting Access, opening a database file, Introduction to the database Window, getting to know the Access screen, Saving & Closing a database file, Using the help menu, Exiting Access Working with databases :-Using the Database Wizard, working with datasheets, moving between record & files, using go to, updating records, Selecting Rows & Columns, changing Column Width, Saving a data sheet, Exiting datasheet Working with tables :- Creating a new database, Adding tables to database, adding fields to tables, inserting a field, setting a primary key, saving a table, adding & sorting Records, Setting Relationships

Unit-3: -Introduction to HTML and Internet (17 Hours)HTML:- Terms and Concepts, web browser, document tags, formating tags, lists, Linking web pages, working with imagesInternet-What is Internet, Advantages of Internet, Network Architecture, History of internet, E-mail, World Wide Web, File Transfer Protocol, utilities

Unit-4: Project Work (10 Hours)

Class IX
Duration: 90 Hrs.
Syllabus:
Unit-1: Introduction to Computer Fundamentals (12 Hours) IT Concepts: -Definition of Computers, Characteristics of computer - Speed, Diligence, Accuracy, Versatility, Storage, Basic Applications of Computers, Concept of Hardware and Software, Components of computer. Hardware and software, Computer Memory - Primary, Secondary, RAM & ROM, units of memory, Input/output devices. Classification of Software, Operating System and its functions, history of computers and its generations Classification of computers, Computer Languages- Machine Language, Assembly Language and High Level Language, Role of Assembler and Compiler.

UNIT-2: Microsoft Word, MS-PowerPoint, MS -Excel, MS-Access (60 Hours) Microsoft Word: Formatting Text: - Font. Level Formatting, Aligning Text, bullet and numbering, border and shading, change case, working with Tabs, Indents & Spacing, and Formatting paragraphs.Working with tables: Creating a table, adding text to tables, adding/deleting rows and columns, resizing rows and columns, deleting a table, splitting and merging cells. Inserting elements: - page numbers, headers and footers, date and time, pictures and hyperlinks. Mail merge, Envelopes and Labels. Microsoft PowerPoint: Creating a Presentation: - creating a new presentation, using the auto content wizard, changing the text formats, adding bullets, aligning text, Using different Layouts, Using Drawing Toolbar, Inserting Graphs and Organization Charts. Customizing Presentation: -Using emulates, selecting a slide layout, using undo, redo, changing slide layouts, adding clip art to your 'presentation, Background Color/designs to slides, Slide Master View. Using slide transition: -giving timing, sound and adding animations to slides and using preset animations. Custom Animation- Animating pictures and Text with Sound effects

MS Excel: Creating & Editing Workbooks:- Creating New Workbooks, Entering Data, Selecting, Moving & Deleting Cells, Cut ,Copy, Paste, using undo, redo, Find & Replace, Using Formulas, Inserting and Deleting rows and columns, Cell referencing, Sorting of Data. Formatting Workbooks:-Formatting Rows and Columns, changing cell alignments, using number formatting Viewing, Drawing & Printing:- Viewing the worksheet, Adding headers & footers, working with page setup, setting a print area, using print preview & printing. Working with graphs.MS Access Introduction to Access, What is data, Starting Access, opening a database file, Introduction to the database Window, getting to know the Access screen, Saving & Closing a database file, Using the help menu, Exiting Access

Unit-3: Networking and Internet (8 Hours) What is a network, Advantages of network, Differentiate between LAN, WAN and MAN, Internet and its History, Advantages of Internet, Requirements of Internet, World Wide Web, web browser, types of Internet Access, search information, Services on the web- E-mail, Newsgroups, FTP, Search Engines, Chat, E¬ Commerce

Unit-4: Project Work (10 Hours)

E-Saksharta Mission Class VIII
Duration: 90 Hrs.
Syllabus:

Unit-1: Introduction to Computer Fundamentals. (12 Hours) IT Concepts: -Definition of Computers, Characteristics of computer - Speed, Diligence, Accuracy, Versatility, Storage. Basic Applications of Computers, Concept of Hardware and Software, Components of computer.Hardware and software, Computer Memory - Primary, secondary, RAM & ROM, units of memory, Input/output devices. Classification of Software, Operating System and its functions, history of computers and its generations

UNIT-2: Introduction to windows and its Accessories (15 Hours) Exploring your Computer. - Managing files & folders, creating folders, finding files & folders, opening & renaming files & folders, copying & moving files & folders. Setting date and time, control panel, display properties: - background, screensaver, appearance and Revision tour for paint & notepad.

UNIT-3: Microsoft Word ,MS-Power Point MS –Excel (50 Hours) Microsoft Word: Creating & Editing Text:-Opening a document, Selecting & Moving Text, Editing with Cut, Copy & Paste, Undo & Redo, Spell Check .Formatting Text: - Font Level Formatting, Aligning Text, bullets and numbering, border and shading, change case, Working with Tabs, Indents & Spacing, Formatting paragraphs, Format Painter. Working with tables: Creating a table, adding text to tables, adding/deleting rows and columns, resizing rows and columns, deleting a table, splitting and merging cells. Inserting elements: - page numbers, headers and footers, date and time, pictures and hyperlinks. Word art, Spell check, thesaurus, using help, Page Setting and Printing

Microsoft PowerPoint: Creating a Presentation: - creating a new presentation, using the auto content wizard, changing the text formats, adding bullets, aligning text. Customizing Presentation: -Using templates, selecting a slide layout, using undo, redo, changing slide layouts, adding clip art to your presentation, adding charts of different types to slide, organization chart, Background color / designs to slides. Using slide transition:-giving timing, sound and adding animations to slides and using preset animations.

MS Excel: Creating & Editing Workbooks:- Creating New Workbooks, Saving, Closing and Opening Workbook, Entering Data, Selecting, Moving & Deleting Cells, Cut, Copy , Paste, using undo, redo, Find & Replace, Entering Formulas. Formatting Workbooks:-Adjusting column and row sizes, changing cell alignments, using number formatting. Viewing. Drawing & Printing: - Viewing the worksheet, Adding headers & footers, working with page setup, setting a print area, using print preview & printing

Unit-4: Internet (8 Hours) Internet, History of internet, Advantages of Internet, Requirements of Internet, World Wide Web, web browser, types of Internet Access, search information, Services on the web- E-mail, Newsgroups, FTP, Search Engines.

Unit-5: Typing Practice (5 Hours)Hands on Experience for Typing practice

E-Saksharta Mission Class VII
Duration:90 Hrs. 
Unit - 1:Introduction to Computer Fundamentals, IT Concepts: -Definition of Computers, Characteristics of computer - Speed, Diligence, Accuracy, Versatility, Storage, Basic Applications of Computers, Concept of Hardware and Software, Components of computer Hardware and software, Computer Memory - Primary, secondary, RAM & ROM, units of memory,Input/output devices.

Unit 2:Introduction to windows and its Accessories, Basic components of windows, Icons, types of icons, Taskbar, Activating Windows, Moving & Scrolling Windows, Using your desktop, title bar, Minimize, Maximize & close Buttons, Running Applications.

Explore your computer. - Managing files & folders, creating folders, finding files & folders, opening & renaming files & folders, copying, deleting and moving files & folders Painting Pictures with Paint brush

Introduction to paintbrush:-Opening an existing picture, starting a new picture, basic painting techniques, Setting the foreground & background colors. Using Painting Tools:-Tool box, palette, Curve tool, Rectangle tool, Brush Tool. Manipulating areas of pictures:-Selecting an area, moving an area, flipping & rotating Selections, Inverting Colors, Stretching & Shrinking area, zooming a picture

Unit 3:Microsoft Word : Creating & Editing Text, Formatting Text, Working with tables, Creating a Presentation, Customizing Presentation, MS Excel : Introduction to Excel, Creating & Editing Workbooks, MS-Power Point

Unit 4:Introduction to Internet: -What is Internet, History of Internet, Advantages of Internet, World Wide Web, E-mail, web browser, types of Internet ACCESS, search information.

Unit 5:Twinge Practice, Hands on Experience for Typing practice

E-Saksharta Mission - Class VI
Duration: 90 Hrs.
Syllabus:
UNIT-1: Introduction to Computer Fundamentals. (5 Hours)
IT Concepts: -Definition of Computers, Characteristics of computer - Speed, Diligence, Accuracy, Versatility, Storage, Basic Applications of Computers, Concept of Hardware and Software, Components of computer,

UNIT-2: Windows, Notepad, Word Pad, Paint Brush, Calculator (30 Hours) Introduction to Windows: -What is windows, Starting & Exiting Windows, Parts of Windows screen, Icons, Types of icons, Taskbar, Activating Windows, Moving & Scrolling Windows, title bar, Minimize, Maximize & close Buttons. Running applications: -How to run Program, Running a Program from the start Button, Running a Program from my Computer Notepad Word Pad:- Simple word processing, Creating & Saving a document, Entering Text & Editing Document, Formatting Characters, Searching & Replacing Text, printing your document Painting Pictures With Paintbrush Introduction to paintbrush:-Opening an existing picture, starting a new picture, basic painting techniques, Setting the foreground & background colors. Using Painting Tools:-Tool box, palette, Curve tool, Rectangle tool, Brush Tool. Manipulating areas of pictures:-Selecting an area, Moving an area, flipping & rotating Selections, inverting Colors, Stretching & Shrinking area, Zooming a picture ,Using Calculator.- Performing functions of Calculator

UNIT-3: Microsoft Word, MS-PowerPoint (40 Hours) Microsoft Word: Introduction to Word, What is Word, Starting Word, Getting to know the Word screen, Creating Documents, Saving Documents, Using Help, Exiting Word. Creating & Editing Text-Opening a document, Selecting & Moving Text, Editing with Cut, Copy & Paste, Undo & Redo, Spell Check, Using Find, Replace & Go To. Formatting Text: - Font Level Formatting. Microsoft PowerPoint: - Introduction to Power Point, What is PowerPoint, starting PowerPoint, creating and opening a presentation, PowerPoint views, moving between slides, saving/ closing a presentation, exiting PowerPoint, Creating a new presentation using the auto content wizard and slide layout. Formatting Presentation: - changing the text formats, adding bullets, aligning text

UNIT-4: Introduction to Internet. (5 Hours)

UNIT-5: Typing Practice (10 Hours) Hands on Experience for typing practice