| Courses Basic Computer Training | Locality A S Rao Nagar |
Every student need computer knowledge now a days because without computer knowledge you can t survey in the world. How many degrees if you have is not a matter but how much can communicate through digital literacy is matter. so basic computer knowledge is very essential to everyone, every student must first make sure they meet the minimum technical and software requirements in their life, Students who have very little experience with computers can learn the basic skills needed to perform tasks on computers and online. The ability of adults to perform these tasks can be accessed through online, self-guided modules. Included are basic computer digital literacy standards and modules in ten main areas: Basic Computer Use, Internet, Windows Operating System, Mac OS, Email, Microsoft Word, Social Media, Microsoft Excel, Microsoft PowerPoint, and Information Literacy. Our goal is to give you a solid foundation, Once you have understood these basics, you will have a clear understanding on which to build your future knowledge of and skill with computers. To become acquainted with your computer there are certain basic skills to be mastered, To become acquainted with your computer there are certain basic skills to be mastered
Our goal is to give you a solid foundation, Once you have understood these basics, you will have a clear understanding on which to build your future knowledge of, and skill with computers.
Common Courses
The goal of a basic computer literacy course is to equip students with basic computer skills. Additional advanced courses may be taken to strengthen knowledge in a particular area. The descriptions below highlight the curriculum of some common online basic computer courses.
Introduction to Computers
Students who have very little experience with computers can learn the basics in this class. The goal of this course is to illustrate how important computers are in modern society and their value in solving problems. Fundamental operations and functions of the computer will be covered. Specific topics include the use of software applications, the Internet, basic computer functions and the proper identification of computer hardware components.
Internet Navigation
Students enrolled in this course will learn how to successfully navigate the Internet. Some of the topics include cloud computing, advanced search techniques, travel planning, social networking, blogging, bookmarking and how to defend against various types of malware, such as viruses and worms.
Keyboarding
Typing is a key component of computing. Many job hunters lack adequate keyboarding skills. This course enables students to learn the basics of touch-typing by using a computer program, such as FasType for Windows. Students who already know touch-typing will use a typing program to improve their speed and accuracy.
Table of Contents:
Very Basic Computer Skills
Computer Vocabulary
Opening and Saving Files
Skills and Activities Practice
MS Word Exercises
Excel Exercises
Internet
PowerPoint
MS Word Exercises
Exercise 1: Typing and Editing
Exercise 2: Editing and Formatting
Exercise 3: Spell Check
Exercise 4: Spell Check | Teacher notes
Exercise 5: Spell Check
Exercise 6: Editing and Spell Check (Microsoft Word format) | Practice (Microsoft Word format)
Exercise 7: Editing and Formatting | Formatting Practice (Microsoft Word format)
Exercise 8: Tables
Exercise 9: Columns and Indenting
Exercise 10: Bullets and Clip Art
Copying and Pasting Images
Microsoft Word: Using HELP 98 2000 Version
Microsoft Word: Using HELP XP Version
Excel Exercises
Step-by-step instructions with graphics designed to introduce learners to various aspects of MS Excel. These lessons are suitable for NRS level Low Adult Secondary.
Explanation of Excel Cursors
Exercise 1, Basic: Entering Information
Exercise 1: Entering Information
Exercise 2, Basic: Making Lists
Exercise 2: Making Lists
Exercise 3, basic: Budgets
Exercise 4: Adding Totals
Exercise 5: Making Charts
Exercise 6: Budgets
Execise 7: Making Charts
Internet
Lessons and activities on using the internet. These lessons refer to Internet Explorer as the browser. Many activities can be completed regardless of the browser.
What is the internet? (PowerPoint)
Go to a website on the internet
Internet directions: Mapquest
Exercise 1
Exercise 2
Exercise 3
Exercise 4
Internet job search
Online dictionaries and encyclopedias
Internet dictionary
Metro Transit website
Publish your own recipe
PowerPoint
Step-by-step instructions with graphics designed to walk students through the creation of a PowerPoint presentation.
PowerPoint for 2000
PowerPoint for XP
Sample presentation (PPT)
MICROSOFT ACCESS
Introduction to MS- Access
Table Creation, Table in Design view
Creating Data Base Forms
WEB DESINGING
Photo shop
Html / Css and Html-5 /Css-3
Basic web designing components
TALLY ERP 9
1 1. LESSON 1: BASICS OF ACCOUNTING
1.1. Introduction
1.2. Accounting Principles, Concepts and Conventions
1.3. Double Entry System of Book keeping.
1.4. Types of Accounts Real Accounts, Personal Accounts, Nominal Accounts
1.5. Rules of Accounting
1.6. Mode of Accounting
1.7. Financial Statements Trading Account, Profit & Loss Account & Balance Sheet
1.8. Transactions Recording Transactions 2. LESSON 2: FUNDAMENTALS OF TALLY.ERP 9
2.1. Introduction Salient Features of Tally.ERP 9, Technological Advantages.
2.2. Getting Functional with Tally.ERP 9 Tally.ERP 9 Start up, Mouse / Keyboard Conventions, Switching between Screen Areas, Quitting Tally .ERP 9
2.3. Setting up of Company in Tally.ERP 9 Create a Company, Select a Company, Alter a Company, Shut a Company
2.4. F11: Company Features F1:Accounting Features, F2: Inventory Features, F3: Statutory &Taxation, F4:Tally.NET Features, F6: Add-On Features
2.5. F12: Configurations General Configuration, Numeric Symbols, Accts/Inventory Info. Configuration, Voucher Entry Configuration, Invoice /Orders Entry Configuration, Payroll Configuration, Banking Configuration, Printing Configuration, EMailing Configuration, Data Configuration, TDL Configuration, Advanced Configuration, Licensing Configuration
2.6. Practice Exercises 3. LESSON 3 :CREATE ACCOUNTING MASTERS IN TALLY.ERP 9
3.1 Chart of Accounts Pre-defined Groups of Accounts.
3.2 Groups Creating Single Group, Creating Multiple Groups, Displaying Group, Altering Group. 3.3 Ledgers Creating Single Ledger, Creating Multiple Ledgers, Displaying Ledger, Altering Ledger
3.4 Walkthrough for creating Chart of Accounts
3.5 Practice Exercises. 4 LESSON 4: CREATING INVENTORY MASTERS IN TALLY.ERP
4.1 Stock Groups Creating Single Stock Group, Creating Multiple Stock Groups, Displaying Stock Groups, Altering Stock Groups
4.2 Stock Categories Creating Single stock Category, Creating Multiple Stock Categories, Displaying Stock Category, Altering Stock Category
4.3 Units of Measure Simple Units, Compound Units, Creating Simple Units, Creating Compound Units, Displaying Units of Measure, Deleting Units of Measure
4.4 Godowns Creating Single Godown, Creating Multiple Godowns, Displaying Godowns, Altering Godowns
4.5 Stock Items Creating Single Stock Item, Creating Multiple Stock Items, Displaying Stock items, Altering Stock items
4.6 Voucher Types Predefined Vouchers in Tally.ERP 9, Creating Voucher Type, Displaying Voucher Type, Altering Voucher Types
4.7 Walkthrough for creating Inventory Masters
4.8 Practice Exercises 5 LESSON 5: VOUCHER ENTRY IN TALLY.ERP 9
5.1 Accounting Vouchers Contra Voucher(F4), Payment Voucher(F5), Receipt Voucher (F6), Journal Voucher(F7), Purchase Voucher (F9), Sales Voucher (F8), Credit Note Voucher(Ctrl+F8), Debit Note Voucher (Ctrl+F9), Reversing Journal Voucher (F10), Memo Voucher (Ctrl+F10), Optional Vouchers, Post Dated Vouchers
5.2 Walkthrough for recording Accounting Vouchers
5.3 Inventory Vouchers Purchase Order, Sales Order, Rejections Out, Rejection In, Stock Journal, Delivery Note, Receipt Note, Physical Stock Voucher
5.4 Walkthrough for recording Inventory Vouchers 5.5 Invoicing
5.6 Practice Exercises 6 LESSON 6: GENERATING BASIC IN TALLY.ERP 9
6.1 Financial Statements Balance sheet, Profit &Loss A/c, Trial Balance
6.2 Accounting Books & Reports Cash Book, Bank Book, Purchase Register, Sales Register, Journal Register, Debit Note Register, Credit Note Register, Day Book, Statistics Learning Tally.ERP 9 From Accounting to ERP Syllabus Page 3
6.3 Inventory Books &Reports Stock Summary, Stock Item Summary, Stock Group Summary, Stock Transfer Register, Movement analysis, Physical Stock Register
6.4 Exception Reports Negative Stock , Negative Ledgers
6.5 Practice Exercises 7 LESSON 7:MULTILINGUAL CAPABILITIES
7.1 Configuring Tally.ERP 9 for Multilingual Capabilities Creating a company, Defining User Interface Language, Enabling Multilingual Support
7.2 Creating Masters Using Phonetic Keyboard Layouts, Creating Stock Item, Creating ledgers 7.3 Entering Transactions Creating Purchase Invoice, Creating Sales Invoice, Printing Sales Invoice
7.4 Transliterations
7.5 Generating Reports Display Stock Summary, Display Profit &Loss Account, Printing Confirmation Letter in Multiple Languages 8
LESSON 8: TECHNOLOGICAL ADVANTAGES OF TALLY.ERP 9
8.1 Tally Vault Using Tally Vault Feature
8.2 Security Controls Activate Security Control, Create Security levels, Users and Passwords, Altering and Displaying a User/Type of Security, Loading Company with a User name
8.3 Tally. Audit Using Tally Audit Feature
8.4 Backup and Restore Backup , Auto Backup, Restore
8.5 Split Company Data
8.6 Export and Import of Data Export of Data, Exporting of Data for Re- Import into another company, Import of Data, Export to Excel
8.7 ODBC Connectivity
8.8 Web Enabled, Print Preview and Online Help Web Enabled, Internet Publishing, Upload, Mass Mailing, Print Preview, Local / Online Help.
8.9 Printing Reports Display &Print, Multi Account Printing, Type of Print Configuration, Print 9 LESSON
9: ADVANCED ACCOUNTING IN TALLY.ERP 9
9.1 Bill wise Details Activating Bill-wise Details, New Reference, View Outstanding Statement, Against Reference, View Outstanding statement, View Ledger Outstanding Report, View Age-wise Outstanding Statement, Payment Performance of Debtors, Advance, On Account, Bill-wise Details for Non-trading Accounts, Practice Exercises
9.2 Cost Centres and Cost Categories Activating Cost Category and Cost Centre, Creating Cost Categories, Creating Cost Centres, Applying Cost Centres to Ledger accounts, View Cost Centre Reports
9.3 Voucher Classes Creating a Voucher Class, Invoice Entry using Voucher Class, Payment Entry using Voucher Class, Stock Journal using Voucher Class
9.4 Cost Centre Class Practice Exercises
9.5 Multiple Currencies Creating Foreign Currencies, Altering Currencies, Deleting Currencies, Voucher Entry using Foreign Currency, Displaying Forex Gain/Loss, Adjusting Forex Gain/Loss, Practice Exercises
9.6 Interest Calculations Interest Calculation in Simple Mode, Calculating Interest in Advanced Mode, Practice Exercises
9.7 Budget &Controls Activating Budgets, Creating a Budget, Displaying Budgets and Variances, Altering a Budget, Deleting a Budget, Practice Exercises
9.8 Scenario Management Reversing Journals, Memorandum Vouchers, Optional Vouchers, Activating Scenarios, Creating a Scenario, Altering a Scenario, Deleting a Scenario
9.9 Banking Multiple Instrument Support & Tracking, Cheque Printing, Single/Multi Cheque Printing, Bank Reconciliation Statement, Deposit Slip, Payment Advice
9.10 Stock Summary as on March 2012, Trial Balance for March 2012, Practice
LESSON 10: ADVANCED INVENTORY IN TALLY.ERP 9
10.1 Order Processing Purchase Order Processing, Altering a Purchase Order, Sales Order processing, Altering a Sales Order, Display Order Position, Display Columnar Orders & Stock Details, Adjusting Orders
10.2 Reorder Levels Defining Recorder Levels, Display Recorder Status, Practice Exercises
10.3 Tracking Numbers Using Tracking Numbers, Display Purchase Bills Pending
10.4 Batch wise Details Activating Batch-wise Details, Using Batch-wise Details in Purchase Invoice, Using Batch-wise Details in Sales Invoice Learning Tally.ERP 9 From Accounting to ERP Syllabus Page 4
10.5 Additional Cost Details Activating Additional Cost Details, Creating Purchase Voucher with Additional Cost Details, Creating Purchase Invoice with Additional Cost Details, Appropriate Additional Costs, Additional Costs incurred after Purchase, Practice Exercises