The candidate who wishes to take admission in this course must have successfully completed GCC TBC 30 wpm or 40 wpm course.
GCC SSD CTC Syllabus:
1.Fundamentals of Computer
a.Introduction
b.History of Computers
c.Generations of Computer
d.Uses of Computers
e.Characteristics of Computer
f.Computer system organizations
g.Secondary storage devices
h.Hardware and Software
i.Types of system Software
j.Programming Language
k.Types of Memory
l.Input and Output Devices
m.Compiler and Interpreter
n.Computer Viruses
2.Operating System
a.Working with shortcut keys
b.Types of files
c.File Extension and File Compression
d.Arranging Desktop
e.Working with PDF Files
f.File Transfer
g.Installing UNICODE Fonts
h.Product of Windows Family
i.Operating system, User Interface, and Environment
j.Types of Windows - Application Windows, Document Windows and Folder Windows
k.Recycle Bin
l.My computer
m.Screen saver
n.Wallpaper
o.Windows Explorer
p.Desktop
q.Windows - WordPad, paint, character map, clock, calculator, notepad
3.Microsoft Word
a.Introduction - Title bar, Menu bar, Tool bar, Ruler, Scroll bar, Page view buttons
b.Retrieving saved document - Exiting word, Creating a new document, Saving the document, Closing the document file, Inserting and Deleting Text, Inserting text in a sentence, Inserting text as a paragraph, Undo and Redo, Selecting Text, Selecting text using the mouse, selecting from the keyboard, Copy, Move and Delete Text, Copying the text by copy and paste method, Deleting the text, Spelling and Grammer Checking, Replacing the text, Formatting the text - character formatting, paragraph formatting and page formatting.
c.Character Formatting - Changing font and font size, Applying bold, italic and underline attribute, Changing the case of characters, Paragraph formatting, Justification of text, Keyboard Shortcuts, Changing line spacing, Setting indents via ruler line, aligning text vertically, Numbering or Bulleting existing text, changing the type and shape of bullets, bordering and shading text, setting page borders, shading text, using tabs
d.Page Formatting - Setting Page Margins, Changing Font Size, Changing Font Style, Using drop cap, Header and Footer, Page Numbering, Setting page size and orientation, Inserting page breaks, column formats, Different views - Normal View, Page Layout view, Outline Layout view and Print Preview
e.Working with Tables
f.Autocorrect Feature
g.Autotext Feature
h.Inserting special symbols and characters
i.Mail Merge
4.Microsoft Excel:
a.Introduction to MS Excel - Worksheets, row, columns and cells, Understanding excel screen elements such as title bar, menu bar, tool bar, standard toolbar, formatting toolbar, formula bar, status bar, Worksheet area, Scroll bars, Vertical scroll bar, Horizontal scroll bar, Sheet tab, Scroll button, moving around the worksheet usign keyboard.
b.Data types supported by Excel - Lable, values, formulas and functions, saving the worksheet, edit key.
c.Clearing cell entry
d.Entering Formulas
e.Selecting Row, Column and Range by Shortcuts - Inserting Row, Inserting Column, Deleting row, Deleting column, Changing column width, setting column width with autofit, changing row height, aligning data in a cell, Merge and Center, Renaming a worksheet, Inserting a new worksheet, Deleting a worksheet, Moving and copying the worksheet in sam workbook, freezing tiles, Entering data with autofill, Creating a custom series.
f.Database Management in Excel - Sorting the database, Creating Reports - Area chart, Column chart, Bar Chart, Line Chart, Pie Chart, Radar Chart, Scatter Chart, 3D Chart.
g.Creating Chart
h.Chart Sheet
5.Microsoft Powerpoint
a.Slides
b.Placeholders
c.Speaker Notes
d.Handouts
e.Slide Show
f.The Main Window - Title bar, Menu bar, Standard Toolbar, Formatting Toolbar, Drawing Toolbar, Status bar, View Slide Button, New Slide Button, Layout button, Template Button, To create a new presentation, Open an existing presentation, To start a slide show
g.Powerpoint Views - Slide view, Outline View, Slide sorter view, Notes page view, Slide show view, Slide Masters, Transition and Animations, Inserting sound and videos in slide
6.Microsoft Access:
a.Introudction
b.Opening and Saving database files
c.Introduction to records
d.Creating a table, adding columns
e.Creating Forms
f.Creating Queries
g.Creating and Printing Reports
The GCC SSD CTC syllabus also includes advanced concepts of MS Word, MS Excel, MS Powerpoint, and MS Access.
Microsoft Word Advanced Concepts:
a.Work tracking tools
b.Create indexes and table of content
c.Bookmarks and Hyperlinks
d.Create Forms
e.Word Macros and VBA
Microsoft Excel Advanced Concepts:
a.Create Macros and use VBA
b.Create Excel Macros and VBA
c.Integrate with office software
d.Interactive/non interactive web pages
e.Pivot Tables
f.Advanced functions
g.Advanced analysis tools
Microsoft Powerpoint Advanced Concepts:
a.Powerful slides with VBA
b.Presentation delivery tips
c.Using Powerpoint animations
d.Slide transitions
e.Use video clip, flash objects
f.Adding sound
g.Integrate with office applications
h.Advanced in-show options
Microsoft Access Advanced Concepts:
a.Advanced access form design
b.Advanced access report design
c.Create Macros and VBA
d.Work with OLE objects
e.Integrate Excel
f.Database Security
GCC SSD CTC syllabus also contains topics of Mobile computing in which we have to study topics related to android, iPhone, and windows phone.
7.Mobile Computing:
a.Android
b.Iphone
c.Windows Phone
d.Personal Digital Assistant(PDA)
8.Pagemaker
a.Introduction
b.Tool Box - Pointer Tool, Text Tool, Rotating Tool, Cropping Tool, Line Tool, Constrained Line Tool, Rectangle Tool, Rectangle frame tool, Ellipse Tool, Ellipse Frame Tool, Polygon Tool, Polygon Frame Tool, Hand Tool, Zoom Tool
c.Menu and Commands - File, Edit, Layout, Type, Element, Utilities, View, Windows
d.Use of Pagemaker - For publication i.e. books, daily newspapers, invitation cards, visiting cards, and others
e.Printing - Direct printing, tracing, positive
f.Creating visiting cards
g.Creating wedding cards
h.Creating Pamphlets, Broachers
9.Tally
a.Basic of Accounting
b.Company creation
c.Alteration/Deletion of company
d.Setting of account heads
e.Creating Groups
f.Alteration and Deletion Group
g.Ledger Creation
h.Alteration or Deletion of Ledger
i.Units of measures
j.VAT(Value Added Tax)
k.Purchase Voucher
l.Sales Voucher
m.Invoicing
n.Generating and Printing Reports - Financial Statements, Balance Sheet, Profit and Loss Account, Trading Account, Trial Balance, Cash Book, Bank Account, Purchase Register, Sales Register, General Register
If you like this article about the GCC SSD CTC syllabus, consider sharing this article with friends.
