Courses Details

Curriculum

Module 1: Introduction to Computer

• Introduction to Computers
• History of computers and its generation
• Classifications of digital computer
• Memory unit & its capacity
• Auxiliary storage devices
• Input and ouput devices
• Computer Software
• Computer Language
• Utility Program
• Virus & its type
• Antivirus & its type.
• Basic application program
• Keyboard layout & key,
• Keyboard button handling
• Nepali Typing
• Typing speed

Module 2: Operating System

• List out the name of operating system
• Differentiate the GUI and CUI operating system
• Major function of operating system
• Define open source operating system
• Define mobile operating system
• General knowledge of MS- DOS.
• Knowledge of POST operation
• Introduction of DOS
• Running and closing DOS.
• Internal and external commands.
• Using command syntax in dos.
• Making and changing directories using MD and DVD command.
• Getting help about commands in dos using HELP command.
• Using TREE commands to view the directories & its contents.
• Different types of files and their extension.
• Creating and saving files.
• Using edit command and edit menu to edit the files.
• Renaming files and directories.
• Deleting files and directories using DEL and RD command respectively.
• Copying and moving files and directories to different location.
• Using XCOPY command.
• Formatting disk.
• Copying& movingfiles & directoriesfrom one location to another location.
• Knowledge on how to search files and folders using * with DIR commands.
• Hiding and attributing the files and directories.
• Using and creating of BAT file.
• Basic Concept of Window XP Professional or Window 7 professional or Window 8.1 Professional.
• Knowledge of development of window operating system
• Different types of windows operating systems.
• Logging on to windows XP,
• Window 7 or Window 8.1.
• Desktop, icons and taskbar.
• Using mouse.
• Using start menu and Help
• Using paintbrush for drawing.
• Saving and opening the drawings.
• Different parts of windows.
• Function of Title bar, Menu bar, caption buttons and Scroll bar
• Resizing the windows using mouse.
• Moving the windows to different direction of the desktop using mouse.
• Default icons of desktop and their use.
• Managing files and folder.
• Using windows explorer to manage files and folder.
• Creating new folder.
• Renaming files and folder.
• Opening files and folder.
• Deleting files and folder.
• Using copy, cut, move and paste.
• Creating shortcut of the files and folder.
• Searching files and folders.
• Handaling pen drive.
• Using the start menu
• Using Programs, Accessories, Startup, Internet Explorer, Documents, Settings, Search, Help, Run and Shutdown
• Changing the position and size of the taskbar.
• Using quick lunch toolbar.
• Hiding and displaying taskbar
• Placing icons on taskbar
• Choosing a screen saver.
• Changing the appearance of windows elements.
• Changing desktop icons and effect.
• Modifying the display of colors and resolution.
• Modify language setting
• Concept of Computer Network
• NIC Card
• File and folder sharing concept
• Concept control panel
• Hardware and software installation
• Power saving
• Disk repairing
• Restore point

Module 3: Word Processing Program

• Definition of word processing with its uses.
• Running Word Processing Program.
• Creating files.
• Saving files.
• Opening files
• Knowledge on setting the page.
• Using margins/gutter.
• Selecting paper size & paper orientation.
• Selecting paper layout
• Print preview of the document and Copying/ sending as email of the document.
• Using send to command from file menu.
• Printing document
• Copy, cut and Paste in different locations including other commands like undo, redo, delete
• Using edit menu and other commands.
• Finding the text.
• Replacing the text.
• Jumping on Page, line paragraph - Using view menu to show/hide toolbars.
• Using header/footer.
• Setting ruler.
• Viewing a document with Magnifying as percentage wise.
• Idea on inserting page, page number, symbols, date, field name.
• Knowledge on inserting text box and formatting it.
• Using colors.
• Using footnote & endnot
• Using bookmark, hyperlink.
• Inserting objects.
• Knowledge on creating style of text (heading1,heading2)
• Creating table of contents
• Using format menu for changing its basic appearances of fonts.
• Using format menu for paragraphs.
• Aligning the text. (left, Center, Right & Justify)
• Using superscript & subscript
• Inserting bullets and numbering
• Inserting background
• Changing the letter case
• Using drop cap & themes
• Inserting columns.
• Selecting the layout of the picture.
• Using spelling & grammar check.
• Using macro recording.
• Knowledge on inserting picture
• Using letter wizard
• Using Track change.
• Using Thesaurus.
• Printing on envelops.
• Knowledge on inserting/ formatting table.
• Splitting & merge cell.
• Using auto format.
• Inserting formula.
• Using table properties.
• Customizing the window.
• Splitting & removing windows.
• Arranging windows.
• Using mail merge.

Module 4: Spreadsheet Program

• Opening Spreadsheet.
• Entering the Data.
• Customizing the key cell movement
• Knowledge on the movement of the key cell.
• Knowledge on selecting range, sheet, column, rows.
• Inserting row and column.
• Checking spelling and grammar.
• Knowledge on workbook.
• Working with worksheet.
• Using copy, paste, find, go to commands of the edit menu.
• Handling built in tools.
• Wrapping text.
• Setting Styles.
• Formatting number, text.
• Setting decimal places
• Viewing worksheet as magnifying.
• Modifying the worksheet’s cell, row and column.
• Deleting cells.
• Inserting border.
• Copying the column with formula.
• Using several methods to move and copy data.
• Knowledge on the types of operators used in Spread Sheet.
• Using formula.
• Inserting charts and editing work.
• Setting page margins.
• Inserting header and footer.
• Making suitable arrangements for printing.
• Editing document in print preview.
• Printing documents in a customized way.
• Using various printing options
• Inserting worksheets.
• Knowledge on freezing panes.
• Grouping sheets.
• Creating series.
• Using conditional formatting
• Customizing the data entered in a cell.
• Formatting the fonts.
• Formatting the sheet.
• Displaying columns, rows and whorksheet.
• Defining formula for calculating
• Amount sheet (Purchase Bill),Salary sheet and mark sheet.(using mathematical operators-i.e arithmetical operator, relationaloperator, logical operator and also if(condition operator)
• Sorting Data.
• Creating filter.
• Using advance filter.
• Finding subtotal
• Creating data forms.
• Entering records.
• Deleting records.
• Using validation.
• Setting other rules for validation.
• Using goal seek.
• Creating scenario.
• Recording and using macro.
• Setting password.
• Creating pivot table
• Inserting Pictures and comments.
• Creating hyperlink.
• Editing formula required for daily mathematical problems.
• Creating profit and loss.

 

 

Module 5: Presentation Program

• Introduction presentation program.
• Using the auto content wizard
• Using the Template and styles to prepare slides.
• Presentation media
• Effectiveness of presentation tips
• Viewing the slides in different styles.
• Selecting the proper style (slide layout) according to the need.
• Moving from one text box to another.
• Adding new line/ paragraph within the same text book.
• Selecting the type of presentation.
• Preparing title slide.
• Viewing the contents of the slides.
• Using bullets
• Increasing/ decreasing the space between the lines and bullets.
• Inserting a new line without bullet.
• Inserting sub-level bullets.
• Switching to outline view to create a presentation.
• Making new slide.
• Entering more slide titles.
• Reducing the view of slides.
• Moving slides and bullet.
• Writing summary slide.
• Formatting the text in the slide.
• Using drawing tools in the slide.
• Using auto shapes.
• Bringing changes in the auto shapes.
• Selecting more objects at a time
• Grouping/Ungrouping/ regrouping the objects.
• Aligning the objects.
• Rotating the objects
• Copying, cutting, pasting or duplicating any object.
• Applying various types of colors for background, shadow, and text.
• Printing the slides.
• Measuring the paper and print out.
• Showing the slides.
• Adding animation of various types.
• Setting up the time for custom animation of the text or objects.
• Setting the slide transition method
• Showing the slide in different styles for a number of times or continuously.
• Setting up the loop.
• Using zoom to make full screen view.
• Applying design.
• Ending the slide show.
• Setting the event on mouse click or in the certain interval of time.
• Applying various animation effects.
• Definition of mater slide.
• Using master slide.
• Creating the slide show short cut.
• Inserting Action buttons

Module 6: Database Program

• Introduction to MS Access.
• Definition of DBMS/RDBMS
• Importance & use of Access and electronic database.
• Data, information, database, field, record, table, Data type.
• Choosing the proper field properties for the suitable data like text, number, date and time, currency, look up wizard.
• Definition of primary & foreign key.
• Use of primary key
• Identify the function of validation rules, validation text, and caption, indexed.
• Mention the use of Primary Key (P.K.)
• Differentiating the flat database and relational data base.
• Definition of Relationship
• Uses of relationship
• Types of relationship.
• Establishing relationship between the tables.
• Applying referential Integrity
• Distinguishing one to one, one to many and many to many relationships.
• Give the introduction of the objects used in MS Access like forms, query, and reports.
• Using various types of queries.
• Calculating the fields using update query.
• Creating query in design view and by using wizard.
• Changing between the views
• Definition & uses of parameters
• Mentioning the use of forms.
• Creating the different styles of forms using wizard.
• Inserting the images.
• Connecting table with the form.
• Using the naming convention of buttons, text box, list box.
• Mentioning the form properties and select the required properties for the form.
• Linking query in the form.
• Mentioning the use of Macros.
• Creating useful macros.
• Using VB for decision.
• Using nested if
• Using text box control
• Using check box control on the form.
• Using radio buttons on the form.
• Using do command.
• Displaying message box.
• Creating log on dialogue box.
• Creating splash screen.
• Knowledge on the function of the reports.
• Opening a report using the conditional macros.
• Mentioning the use of SQL (Structured Query language)
• Using CREATE, SELECT, AS, FROM, ORDER BY, WHERE in SQL.

Module 7: Photo Editor Program

• Introduction to photo editor program
• Tool bar, Option bar, Color palate, History bar etc.
• File format (JPEG, GIF, TIFF, PDF, PNG etc)
• Different selection tools (Marquee tool, Lasso Tool, Magic Wand)
• Crop, resize, Shape/drawing
• Type tool, Wrapping Text
• Resolution, pixel
• Image mode
• Brightness, Contrast, Auto color, Auto level, Color balance, Hue/Saturation.
• Opacity, Stamp tool, Blur, Sharpen, smudge tool and different types of Mode.
• Normal fill, Gradient fill
• Different types of effect
• Rotation/Transform image
• Use of layer
• Use of filter
• Rotation/Transform image
• Use of layer
• Use of filter

Module 8: Email, Internet & Webpage

• Define Internet
• Advantages/use of Internet
• Internet Service Provider
• Dial up connection.
• Define Web Site
• Use of Website.
• Brief knowledge of home page, web page, web browser, WWW, HTTP and domain name.
• Search engine, searching techniques and download.
• History
• Useful websites including social network websites
• Define email
• Advantages/use of email.
• Free email service
• Compose, Inbox, Sent item, Trash, Reply, Forward, CC, BCC.
• Address book
• Concept of Outlook Express.
• Use of POP, SMTP, IMAP
• Introduction to HTML.
• Structure of HTML and HTML Tags.
• Heading Tags, Paragraph Tags and their attributes.
• Font Tag and their attributes.
• Body tags and attributes
• Strike through, super script and sub script tag
• Multi column tag and attributes
• IMG tag and attributesBulleted list, Number list tag and attributes
• Define hyperlink
• Types of link(Internal and external link)
• Anchor and hyperlink tag and attributes
• Define table, row, column and cell.
• Table tag and attributes.
• Table caption and header
• Row span, col span
• Definition of tags, attributes, form, textbox, checkbox, radio button, select, submit, reset, text area.

Module 9: Computer Hardware & Networking

• Concept of assembled and branded computer.
• Concept and working principle of Flash drive
• Different peripheral components, their driver and finding and installing appropriate application software for them to upload or download the data
• Understanding hardware installation, hardware listing, updating drivers, viewing different hardware components in the system.
• Understanding the concept of Virtual memory, page file and environment variables.
• Using startup and recovery option for booting settings.
• Understanding the concept of booting the computer for installing operating system.
• The concept of BIOS setup.
• The concept of formatting hard disk and Windows file systems like NTFS and FAT32.
• The concept of installing Operating system in different partitions available in the computer.
• The concept of serial numbers, copyright issues in Operating Systems.
• The process of creating Primary and Extended partitions in the hard disk.
• Concept of application program
• Concept of motherboard and its components.
• Motherboard, its manufacturers, processor type, processing speed, hard disk, DVD ROM, DVDRW, DVD R, DVD RW and their specification should be cleared.
• Introduction to Graphics card, Sound Card, Ethernet card (inbuilt or extra) and their specification should be cleared
• Introduction to the Network
• Types of Network - LAN, MAN & WAN
• Introduction to the Network Topology i.e. Bus, Star, Ring, Mesh.
• Concept of Network protocols like Ethernet, Token Ring, TCP/IP and UDP.
• Concept of Network color code standards.
• Knowledge of Switch, hub, bridge and gateways.
• Knowledge of IP Addressing Techniques. Different Class of IP Addresses.
• Knowledge of DHCP and DNS
• Concept of Default gateway and Preferred DNS Server and alternate DNS Server.
• Concept of Subnet Mask, and static and dynamic IP Addressing.
• Concept of ADSL Broadband Internet Configuration.
• Concept of Wi-MAX Internet configuration.
• Concept of Wirelss Broadband&Cable InternetConfiguration
• Network connection wizard.
• ISP
• Username & password security.
• Speed & bandwidth. 
• Understanding the working principle of the Network
• Understanding Network bandwidth.
• Concept of file server.
• Concept of Print server.
• Concept of Shared folders in the domain or Network

Module 10: Computer Security

• Understanding Firewall
• Concept of IP Address and domain names
• Concept of different Security Threats
• Introduction to hacking, external challenges on network
• Concept of Data Security
• Concept of Network filtering
• Concept of Virus, Malware, Worms, Trojan, Spyware, Adware
• Activation of Antivirus Software

Module: 11 : Entrepreneurship Development

• Introduction to business/enterprise
• Classification of business/enterprises
• Overview of MSMEs(Micro, Small and Medium Enterprises) in Nepal
• Cost & Benefits of self- employment/salaried job
• Wheel of success
• Risk taking attitude
• Business idea generation
• Evaluation of business ideas
• Concept of market and marketing
• Description of product or service
• Selection of business location