Syllabus of AFC4 Introduction to Information Technology

Get access to latest and updated syllabus of AFC subjects. Here you will find detailed course content or Syllabus of AFC4 Introduction to Information Technology for Winter 2021.

Please Note that AFC examinations will be discontinued after winter 2021 attempt.

Now you know what topics to study and practice .The next step would be to download the latest official AFC Introduction to Information Technology Study Text. Click

to Download.

Syllabus GRID

Here is the grid of Syllabus of AFC Introduction to Information Technology for Winter 2021.

GRID	WEIGHTAGE
Computer hardware and types of operating system	3-6
Microsoft Excel	18-22
Microsoft Word	12-18
Microsoft Power point	8-12
Total	50

Course Outline

The course outline gives an overview of Syllabus of AFC Introduction to Information Technology for Winter 2021. The detailed Syllabus of AFC Introduction to Information Technology for Winter 2021 attempt is given below.

Computer hardware and operating systems:

• Central Processing Units (CPUs) –processor, hard disk, random access memory, read-only memory
• Input devices – Key board, mouse, touch pads, magnetic ink character reader, optical mark reader, optical character reader, barcode reader and electronic point of sale
• Output devices – monitor, printer
• Operating systems – DOS, Windows, Linux
• Core Windows tasks – customize desktop and start menus, work with files and folders, log-on and log-off, search for information, lock the computer, use a screen-saver password, reset a password

Microsoft Excel:

• Construction of formulae and application of constructed and built-in functions and formulae
• Creating and modifying customized data formats
• Using conditional formatting
• Protecting cells, worksheets and workbook
• Merging work books
• Importing and exporting data to and from excel
• Creating and editing charts and templates

Microsoft Word:

• Creating custom style for text, tables and lists
• Creating and modifying tables
• Creating and modifying a table of contents
• Use of Review and Reference tab commands

Microsoft Powerpoint:

• Creating new presentations from templates
• Inserting and editing text-based content
• Inserting, and editing tables, charts, diagrams, pictures, shapes, graphs and objects
• Running and printing presentations

Computer hardware, software and operating systems:

Introduction to computer systems:

• Introduction to computer systems
• The central processing unit (CPU)
• Input devices
• Output devices
• Storage devices

Software and operating systems:

• Introduction to computer software
• Key operating system commands

Core Windows tasks:

Core Windows tasks:

• Customizing the desktop
• Customizing the start menu

Working efficiently with files and folders:

• Working efficiently with files and folders

Security and safeguarding your work:

Introduction to computer security:

• Introduction to computer security

Using core Windows security features:

• Logging on and off
• Locking the computer in Microsoft Windows
• Using the Windows screen-saver
• Changing your Windows password

Introduction to Microsoft Excel:

Introduction to Microsoft Excel :

• Introduction to Microsoft Excel 2016
• Practical uses for Microsoft Excel
• Basic components of an Excel workbook

Creating a new workbook:

• Open a new, blank workbook
• Base a new workbook on an existing workbook
• Base a new workbook on a template
• Create and edit your own templates

Backstage view:

• What is the Office Backstage view?
• What can you do with the Office Backstage view?

Printing:

• Previewing worksheets before printing
• Printing worksheets and workbooks

Formatting data and contents:

Entering, formatting and editing data:

• Entering data
• Formatting data
• Editing data
• Viewing data
• Copying and moving data
• Formatting numbers

Conditional formatting:

• Introduction
• Using conditional formatting

Selecting, navigating and managing worksheets:

• Selecting and navigating worksheets
• Managing worksheets
• Adding comments

Organizing and analysing data:

Introduction to formulas:

• Introduction to formulas
• Create your first formula
• Using functions to create a formula
• Nested formulas
• Relative and absolute references
• Avoiding common formula errors
• Deleting a formula

Useful functions for accountants:

• Introduction
• Compatibility functions
• Date and time functions
• Financial functions
• Information functions
• Logical functions
• Lookup and reference functions
• Math and trigonometry functions
• Statistical functions
• Text functions

Managing data and workbooks:

Introduction to managing data:

• Introduction to managing data

Importing and exporting data:

• Importing data from a text file
• Using the Text Import Wizard
• Exporting data to a text file

Representing data:

• Use of Charts
• Steps for Drawing up Charts
• Types of charts
• Elements of a Chart
• Modifying Chart

Data connections:

• Introduction
• Finding existing data connections
• Editing connection properties
• Refreshing data connections
• Exchanging data with other data sources
• Exporting data from Excel to Word

Security and sharing:

Protecting worksheets, workbooks and cells:

• Password protect a worksheet or workbook
• Mark as final
• Encrypt with a password
• Protect current sheet
• Protect workbook structure
• Add a digital signature
• Lock cells

Sharing and managing workbooks:

• Introduction
• Sharing workbooks
• Opening a shared workbook
• Editing a shared workbook
• Removing a user from a shared workbook
• Resolving conflicting changes in a shared workbook
• End the sharing of a shared workbook
• Merging workbooks

Introduction to Microsoft Word:

Introduction to Microsoft Word:

• Introduction to Microsoft Word 2016
• Practical uses for Microsoft Word

Creating and saving a new document:

• Open a new, blank document
• Save a document
• Base a new document on an existing document
• Base a new document on a template
• Create and edit your own templates
• Adding and deleting pages, cover pages and themes

Page numbers, headers and footers:

• Adding headers and footers
• Adding page numbers
• Removing page numbers, headers and footers

Page breaks and section breaks:

• Page breaks
• Section breaks

Page setup:

• Watermarks
• Rulers
• Page orientation
• Line numbers
• Margins

The Office backstage view in Microsoft Word:

• The Office Backstage view in Microsoft Word
• Comparing the Office backstage views of Word and Excel

Printing a document:

• Previewing documents before printing
• Printing documents
• Print tracked changes

Formatting, illustrations and tables:

Formatting:

• Style
• Fonts
• Paragraph setting
• Sorting lists alphabetically

Illustrations:

• Pictures and Clip Art
• Shapes
• Charts
• Text boxes
• WordArt

Tables:

• Create a table
• Edit a table
• Delete a table

Table of contents and other references:

Creating a table of contents:

• Introduction
• Use built-in heading styles to mark entries
• Create a table of contents from the gallery
• Create a custom-style table of contents
• Update a table of contents
• Delete a table of contents

Using footnotes and endnotes:

• Insert a footnote or endnote
• Edit a footnote or endnote
• Delete a footnote or endnote

Captions and cross references:

• Introduction
• Insert captions
• Insert cross-references

Creating a bibliography:

• Introduction
• Add a new citation and source into a document
• Create a bibliography

Introduction to Microsoft PowerPoint:

Introduction to Microsoft PowerPoint :

• Introduction to Microsoft PowerPoint 2016
• Practical uses for Microsoft PowerPoint
• Building effective presentations

Creating a new presentation:

• Open a new, blank PowerPoint presentation
• Base a new presentation on an existing presentation
• Base a new presentation on a PowerPoint template
• Create and edit your own templates
• Slide master and placeholders

Inserting and editing text-based content:

• Introduction
• Add text to a placeholder or text box
• Add text to shapes
• Bullets and numbers
• Indents
• Colours
• Superscript, subscript and capitalization
• Changing the direction of text
• Fonts
• Paragraph settings
• AutoFit
• Find and replace

The Office backstage view in Microsoft PowerPoint:

• The Office backstage view in Microsoft PowerPoint
• Comparing the Office backstage views of PowerPoint and Excel

Printing:

• Printing presentations
• Previewing presentations before printing

Using visual aids in presentation:

Introduction:

• Using Visual aids in presentation

Tables:

• Introduction
• Create a table in Microsoft PowerPoint
• Copy and paste a table from Microsoft Word
• Copy and paste cells from Microsoft Excel
• Insert an Excel worksheet into Microsoft PowerPoint
• Entering text into a cell
• Modifying a table’s design and layout

Images:

• Pictures
• Clip arts
• screen-shots

Illustrations:

• Shapes
• SmartArt
• Charts and graphs

Media:

• Videos
• Audio

Slide transitions and animation:

Slide transitions:

• Add a transition to a slide
• Change transition settings
• Remove a transition

Slide animations:

• Add animation to text or an object
• Change animation settings
• Removing animations

Slide show:

• Setting up Slide shows
• Recording Slide shows
• Customizing Slide shows

Useful keyboard shortcuts:

Keyboard shortcut keys in Microsoft Windows:

• Top Keyboard shortcuts
• General Keyboard shortcuts
• New Keyboard shortcuts

Keyboard shortcut keys in Microsoft Office:

• Common Short Cut Keys
• Function key Shortcuts
• Shift + Function key
• Ctrl + Function key
• Ctrl Key
• Press Ctrl + Shift + Function key
• Alt + Function key

Syllabus of AFC4 Introduction to Information Technology:

Syllabus of AFC4 Introduction to Information Technology abc.

Syllabus of AFC4 Introduction to Information Technology def.

Syllabus of AFC4 Introduction to Information Technology ghi.

Syllabus of AFC4 Introduction to Information Technology jkl.

Syllabus of AFC4 Introduction to Information Technology mno.

Syllabus of AFC4 Introduction to Information Technology pqr.

Syllabus of AFC4 Introduction to Information Technology stu.Syllabus of AFC4 Introduction to Information Technology vwx.

Syllabus of AFC4 Introduction to Information Technology yz1.

Syllabus of AFC4 Introduction to Information Technology 234.

Syllabus of AFC4 Introduction to Information Technology 567.

Syllabus of AFC4 Introduction to Information Technology 8910