Course Outline DIT (Revised 2012)
Contents
1. Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 16 3 11 3 Creating Forms Using Wizard and Design View 3 11 4 Adding and Deleting Controls 3 11 5 Changing Properties 3 11 6 Modifying Forms 3 11 7 Deleting Forms Reports 3 12 1 Definition and uses of reports 3 12 2 Creating Reports Using Wizard and Design View 3 12 3 Modifying Reports 3 12 4 Changing Properties Pages 3 13 1 Definition and uses of data access pages 3 13 2 Creating Data Access Pages Using Wizard and 3 13 3 Design View 3 13 4 Editing Webpage Macros 3 14 1 Definition and uses of Macros 3 14 2 Creating and Running Macros Advance Concept 3 15 1 Importing and exporting data 3 15 2 Database Tools 08 08 08 10 4 4 2 4 3 4 4 4 5 4 1 PROGRAMMING FUNDAMENTALS FLOW CHARTS AND PROGRAMMING WITH VB NET 4 1 1 Computer Programming Logic Definition Characteristics 4 1 2 Pseudo code Definition Examples Flow Charts 4 2 1 System flow chart Symbols Examples 4 2 2 Program flow chart Symbols Advantages Disadvantages Sequential program flow charts Introduction to VB net 4 4 1 Basic NET concepts 4 4 2 Using the development environment 4 4 3 Object Oriented Technique 4 4 4 New Active X Control Introduction to VB net Programming 4 5 1 Creating Visual Basic NET Project 4 5 2 Create Names List Application 14 14 14 Developed by Curriculum Section2. 1 2 10 1 2 11 1 2 12 Drawing Tools using Rectangle Circle Lines Polygons Star Complex Star Spiral Outline Tool amp Fill Tool Interactive Tools Using Blend Extrude Drop Shadow Contour amp Transparency Ruler Adjustment amp Ratio Setting Editing Tools Use of Nodes Importing amp Exporting Use of Bitmaps in Design Page Layout Design Arrangements Use of Symbols amp Dockers 1 3 2D Animation with Adobe Flash CS Technology 1 3 1 1 3 2 1 3 3 1 3 4 1 3 5 1 3 6 Types of Animations Animation Techniques Difference between different types of Animations Stage Paste Board Setting Frames amp Key frames Layer Masking amp Guide Layer 45 45 45 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 20 1 3 7 Types of Symbols Graphic Button amp Movie Clip 1 3 8 Scenes 1 3 9 Timeline amp Timeline Effects 1 3 10 Introduction to Basic Actions 1 3 11 Web Publishing 1 4 Web Compilation using Adobe Dreamweaver CS Technology 1 4 1 Making of HTML Static Page 1 4 2 Use of Design View amp Code View 1 4 3 Defining a Site 1 4 4 Table Layout 1 4 5 Use if Div Function 1 4 6 Use of Buttons amp Navigation Bars 1 4 7 Form Designing amp Use of Frames 1 4 8 Use of Spry Lists with CSS 1 4 9 Use of Layers Show Hide behavior 1 4 10 Hyperlinks amp Hot Spots 1 4 11 Uploading Procedure amp Updat
3. 2 Sequence Diagram 2 9 Input Designing Concept 2 9 1 Input stages input types input media input specification input screen designing layout chart 2 10 Output Designing Concept 2 10 1 Output definition output media output specification layout charts specification of printed output for the programmer designing case study 2 11 Testing and Debugging of System 2 11 1 Concepts of Testing and Debugging 2 12 Documentation of System 2 12 1 Preparation of the user manual amp technical manual 2 13 System Implementation 2 13 1 Preparation of implementation user personnel preparation changes over procedures 0 amp 9 09 Introduction to Computer Networking 3 1 Network Devices 3 1 1 Modems 3 1 2 Multiplexers 20 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 22 3 1 3 Concentrator 3 1 4 Connectivity Devices Repeaters Hubs Bridges Switch Routers and Gateways 3 2 Networking Resource Access Models 3 2 1 Peer to Peer 3 2 2 Client Sever 3 2 3 Server based 3 3 Types of Network 3 3 1 LAN 3 3 2 MAN 3 3 3 WAN 3 3 4 Primary Network Components 3 4 Network Topology 3 4 1 Definition of Topology 3 4 2 Bus Topology 3 4 3 Star Topology 3 4 4 Ring Topology 3 4 5 Mesh Topology 3 4 6 Hybrid Topology 3 5 Network Protocols and Architecture 3 5 1 Definition of Protocols 3 5 2 Types of Protoc
4. 3 2 7 Degree and Cardinality Relationship and its types 3 3 1 One to one 3 3 2 One to many 3 3 3 Many to many 3 3 4 Referential integrity Relational data integrity 3 4 1 Primary key Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 15 3 4 2 Foreign key 3 4 3 Candidate key 3 4 4 Alternate key Principles of Database Design 3 5 1 E F Code rules 3 5 2 Database Normalization and its forms 3 5 3 E R Model E R Diagram MS Access Environment Tables 3 6 1 Define the table and explain with examples 3 6 2 Methods of creating new table s 3 6 3 General Field properties 3 6 3 1 Field size 3 6 3 1 Format 3 6 3 1 Input mask 3 6 3 1 Validation rule 3 6 3 1 Validation text 3 6 3 1 Caption 3 6 3 1 Default value 3 6 3 1 Required 3 6 3 1 Indexed Lookup field properties 3 7 1 Row source type 3 7 2 Row source 3 7 3 List row 3 7 4 Limit to list 3 7 5 Saving Table 3 7 6 Table Views 3 7 7 Deleting Tables Relationship 3 8 1 Creating Deleting and Modifying Relationship Queries and its Types 3 9 1 Select query 3 9 2 Action query 3 9 3 Update 3 9 4 Delete 3 9 5 Insert 3 9 6 Make table 3 9 7 Creating Deleting and Modifying Queries 3 9 8 Query Views Introduction to SQL Forms and its types 3 11 1 Definition and uses of forms 3 11 2 Discuss the types of forms with examples 06 08 08 08 06 10
5. Web Development using PHP amp My SQL 60 240 280 5 Project 60 60 6 Functional English I 20 20 40 7 Work Ethics ll 20 20 Total 160 640 800 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 6 DETAIL OF COURSE CONTENTS Diploma in Information Technology 01 Year Course Semester Theory Practical Sr Detail of Topic Hours Hours 1 Introduction to Computer amp Operating Systems DOS WINDOWS 7 LINUX INTRODUCTION TO DATA PROCESSING amp COMPUTER 1 1 1 History of Computer 1 1 2 Definition of Computer 1 1 3 Importance and Capabilities of Computers 1 1 4 Data and its types 1 1 5 Difference between data and information 1 1 6 Data processing cycle TYPES OF COMPUTERS AND APPLICATION 1 2 1 Digital Computer 1 2 2 Analog Computer 1 2 3 Hybrid Computer INTRODUCTION TO EDP SYSTEM 1 3 1 Elements of an EDP system 1 3 2 Hardware 1 3 3 Software 1 3 4 User program 1 3 5 Procedure 1 3 6 Personnel HARDWARE CONFIGURATION 1 4 1 Input output devices 1 4 2 Fixed Drive Hard Disk IDE SATA amp SCSI 1 4 3 Removable Drive CD amp DVD ROM Super Drives CENTRAL PROCESSING UNIT CPU 1 5 1 Arithmetic amp logic unit ALU 1 5 2 Control unit TYPES OF COMPUTER STORAGE 1 6 1 Bit Nibble and Byte 1 6 2 Memory unit Cache Memory Virtual Memory 1 6 3 Storage Primary and Secondary INTRODUCTION TO COMPUTER SOFTWAR
6. through programs 1 34 2 Move text from one application to another 1 34 3 Simultaneously opening two windows on desktop 1 34 4 Opening closing DOS from within program Lab Practice for using above said options 1 34 LINUX 6 1 35 1 Introduction to LINUX 1 35 2 Linux History 1 1 35 3 Use of Linux 1 35 4 Linux concepts versus DOS concepts 1 35 Using the system 1 36 1 Logging in 1 36 2 Creating user 1 36 3 How to get system 1 36 4 Using the system 1 36 5 How to get help 1 36 6 Finding other user on the system 1 36 7 Communicating with other users Lab Practice for using above said options 1 36 The LINUX environment 1 37 1 Redirects 1 37 2 Pipes 1 1 37 3 STDIN STDOUT STDERR AND 6 REDIRECTION 1 37 Users program 1 38 1 Introduction to vi editor 1 38 2 Creating files 1 1 38 3 Editing files 6 1 38 4 Introduction to pico editor Lab Practice for using above said options Linux Commands Alias Cp cd D 1 Cat c corn find 8 Diff Exot ftb lpr Grep Kill Is more Mv mail mkdir telnet Man pwd rm Xhost Xtrem Chmod Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 11 2 BUSINESS APPLICATION Internet usage MS Office Word 2010 MS Office EXCEL 2010 MS Office Power Point 2010 amp E Commerce Internet 2 1 1 2 1 2 2 1 3 2 1 4 2 1 5 2 1 6 2 1 7 2 1 8 2 1 9 Introduction to Internet Difference between Internet Intranet and Extranet Steps
7. 12 Working with Loops and Decision Making 4 12 1 4 12 2 4 12 3 4 12 4 4 12 5 4 13 Working with Arrays 4 13 1 4 13 2 4 13 3 4 13 4 4 14 Us 4 14 1 4 14 2 4 14 3 4 14 4 er Defined Functions 2 4 15 Working with Form 4 15 1 4 15 2 4 15 3 4 15 4 4 16 Displaying Dynamic Contents 4 16 1 4 16 2 4 17 Sending EMAIL 4 17 1 4 17 2 Writing data file 4 17 3 Reading data file 4 18 Basic MySQL Commands 4 18 4 18 2 Alert 4 18 3 Drop 4 18 4 Insert 4 18 5 Update 4 18 6 Delete 3 4 19 Establishing a Database Connection With PHP 4 19 4 20 Creating and Populating Database Tables 4 20 4 20 4 20 Arithmetic operators Logical operators Using variables and operators in a calculations IF and IF ELSE statement For loop While loop Do while Using loops and decisions making in the script What is an Array Creating Arrays Multidimensional Arrays Traversing Arrays Defining a function Retrieving a value from function Using function in the code Using date and time function What is form Creating a form Retrieving values from form Putting a form to work Redirecting to a new location Displaying browser specific code Working with file system 1 Create 1 Connecting to MYSQL database 1 Create a table 2 Basic table definition 3 Field definition 10 10 10 10 12 10 Developed by Curriculum Section Academics Department TEVTA Diploma in I
8. 6 4 Brief History of Windows 2007 1 16 5 Comparison of DOS and WINDOWS 1 17 Introduction with windows opening screen 1 17 1 Desktop Basics Desktop icons of My Computer Explorer 1 17 2 Recycle Bin My document Network Place Task Bar Start Button Application Icons in Task Bar Notification Area 1 17 3 Start Menu Programs Including Accessories Application 1 18 Packages DOS Prompt Documents Setting Search Find Folders amp Files Help Run and Shut Down Options 1 19 Practice for using above said options Working with windows new features Opening an icon Maximizing and restoring a windows Opening a task bar button Resizing and moving windows Scrolling and closing a windows 1 20 Practice for using above said options Using My Computer 1 20 1 View files on storage devices i e Hard Disk Flash Drive etc 1 21 Practice for using above said options 1 22 Manage files folders 1 22 1 Selection one or more files and folders 1 22 2 Delete rename cut paste and copy a files and folders using drag and drop 1 22 3 Shortcut keys menu and tool bars 1 22 4 Create short cuts 1 23 Practice for using above said options 1 23 1 Using Explorer Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 1 24 1 25 1 26 1 27 1 28 1 29 1 30 1 23 2 Collapsing Expanding Level to view folders fil
9. Academics Department TEVTA Diploma in Information Technology 1 Year Course 17 4 6 4 7 4 8 4 9 4 5 3 4 5 4 4 5 5 4 5 6 4 5 7 4 5 8 4 5 9 Working With Forms And Controls Understanding Programming Concepts Using Windows Forms Working With Controls Events Driven Programming in VB NET Create Variables And Constants Using Structure And Arrays Decision Structures And Loops 4 6 1 4 6 2 4 6 3 Using Conditional Expression Using Decision Structures Using Conditional Loop Structure Creating Modules Procedures amp Functions 4 7 1 4 7 2 4 7 3 4 7 4 4 7 5 4 7 6 4 7 7 Working With Procedures Writing Sub Procedures Sub Procedures Syntax Calling a Function Procedure Using a Function to perform a calculation Subroutines and Functions Built in Functions Object Oriented Programming 4 8 1 4 8 2 4 8 3 4 8 4 4 8 5 4 8 6 4 8 7 Understanding Classes Working with Classes Inheritance and Polymorphism Using Class Inheritance Handling Errors and Exceptions Using Debugging Technique Structured Exception Handling Working With VB Net Tool Box Controls 4 9 1 4 9 2 4 9 3 4 9 4 4 9 5 4 9 6 4 9 7 4 9 8 4 9 9 4 9 10 4 9 11 4 9 12 4 9 13 4 9 14 4 9 15 4 9 16 Common Controls Containers Menu And Tool Bars Data Dialogs Reporting Components Creating Menus Creating Toolbars Creating a Status Bar Using ADO NET Database Concepts Working with Data Creating a Contact
10. E 1 7 1 Hierarchy of Language Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 1 7 2 Low Level Language 1 7 3 High Level Language 1 7 4 Language translators 1 7 5 Definition of operating system DEFINITION OF ELECTRONIC DATA PROCESSING 1 8 1 On line processing 1 8 2 Batch processing 1 8 3 Multi programming 1 8 4 Multi processing 1 8 5 Time sharing 1 8 6 Data communication concepts DISK OPERATING SYSTEM 1 9 1 lO SYS 1 9 1 CONFIG SYS 1 9 1 AUTOEXE BAT DEVICE DRIVERS Input Output Devices Practice for creating batch and config sys files Disk Operating System 1 12 1 Definition of operating system 1 12 2 Salient characteristics of MS DOS 1 12 3 Creating a file in DOS 1 12 4 Understanding the concept of internal and external DOS commands 1 12 5 Interface concept 1 12 6 Command line and GUI Practice for creating and saving DOS files Purpose syntax and use of MS DOS Commands CLS TYPE MD COPY VER DIR CD X COPY DATE EXIT RD MOVE TIME PROM PATH DELTREE PT COPY LABEL REN DEL CON ERASE COPY X MOVE COPY DELTREE DEL ERASE Practice for using DOS commands Windows 7 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 1 16 1 What is Graphical User Interface GUI 1 16 2 Salient features of Windows as a Graphical 1 16 3 Operating System 1 1
11. GOVERNMENT OF THE PUNJAB TECHNICAL EDUCATION amp VOCATIONAL TRAINING AUTHORITY CURRICULUM FOR Diploma in Information Technology 1 Year course Revised 2012 CURRICULUM SECTION ACADEMICS DEPARTMENT 96 H GULBERG II LAHORE Ph 042 09263055 9 99263064 gm acad tevta gop pk manager cur tevta gop pk Diploma in Information Technology 1 Year Course 1 TRAINING OBJECTIVES The Course aims to producing the trained man power in the field of Information Technology to fulfill employment requirement of I T industry not only in the country but also abroad The curriculum is divided into two academic semesters The curriculum of Semester l is designed to train the students to work as database developer and work on the MS office alongwith touch of E Commerce The curriculum of semester ll is designed to train the students in the field of Networking Graphics Design amp Animation and Interactive web development CURRICULUM SALIENTS Name of Course Diploma in Information Technology Entry Level Intermediate or Equivalent Duration One Year The course consist of Two Semesters with 20 weeks of teaching delivery duration each Total Training Hours 1600 Hours 800 hours per Semester Training Hours 40 Hours week 7 Hours per day Friday 05 Hours Training Methodology Practical 80 Theory 20 Medium of Training Urdu English Developed by Curriculum Section Academics Department TEVTA Diploma in Information T
12. List Deploying Applications Introduction to Deployment 14 14 20 16 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 18 4 10 4 12 4 13 Debugging Visual Basic Programs 4 10 1 Finding and Correcting Errors 4 10 2 Three types of Errors 4 10 3 Identifying the Logical Errors 4 10 4 Using Debugging Mode 4 10 5 Tracking Variables by using a Watch Window 4 10 6 Debugging Tools that display Data 4 10 7 Using the Immediate and Command Windows Working with Windows Form 4 11 1 Creating Windows Forms Applications 4 11 2 Components of Windows Form User Interface 4 11 3 Windows Form Event Handling 4 11 4 Creating MDI Forms 4 11 5 Configuring Standard Controls 4 11 6 Windows Forms Controls by Function 4 11 7 Building Menus 4 11 8 Implementing Menus Windows Forms 4 11 9 Using Tool Strip Controls 4 11 10 Windows Forms Data Binding 4 11 11 Providing user assistance and enhancing usability 4 11 12 Accessibility Features 4 11 13 Globalization And Localization 4 11 14 Localizing a Windows Form 4 11 15 Dialogue Boxes in a Windows Form Application 4 11 16 Windows From Inheritance 4 11 17 Generating Print Output 4 11 18 Printing in a Windows Form Application 4 11 19 Printing using Common Dialogue Data Base Programming With ADO Net 4 12 1 Working with an Access Database 4 12 2 Database Connectivity 4 12 3 The Da
13. Tables Links Media Clips 10 Illustrations Text Design Ribbon Page Set up Themes 10 Background Animations 10 Preview Transition to This Advance Slide Animations Slide 10 Slide Show Ribbon Start Slide Set up Monitors Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 14 Preview Proofing Comments Project 3 View Presentation Views Zoom Windows 3 Show Hide Color Grayscale Macros Format Ribbon 4 Insert Shapes Word Art Styles Size Shape Arrange Introduction to E Commerce The Internet and Business E Commerce and its types Domain Registration amp Hosting E Commerce standards and terminologies On line Payment Processing Solution Merchant Account Security issues in E Commerce Introduction to Hacking amp Cracking et kt h h 1 alti als 1 1 akWND 1 1 6 1 1 7 3 3 3 3 4 3 5 3 6 DATABASE MANAGEMENT SYSTEM USING MS ACCESS 2010 amp INTERNET MANAGEMENT Overview of a Data Base System 3 3 1 Introduction to Database 3 3 2 Definition of a Database System 3 3 3 Properties and benefits of database system 3 3 4 Components of Database System 3 3 5 Database management system DBMS 3 3 6 What is RDBMS Introduction to RDBMS 3 2 1 Database 3 2 2 Tables relations 3 2 3 Attributes Fields 3 2 4 Tuples Rows 3 2 5 Entities Tables 3 2 6 Key attributes and non key attribute
14. e Web sites Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course CURRICULUM DELIVERY STRUCTURE 1 SEMESTER Course Co Curricular Project Test Total delivery activities vacations Week 1 20 21 23 20 3 0 1 26 2 SEMESTER Course Co Curricular Project Test Total delivery activities vacations Week 1 20 21 23 20 01 04 1 26 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 5 SCHEME OF STUDIES Diploma in Information Technology 01 Year SEMESTER 01 Sr i i Theory Practical Total Main Topics No Hrs Hrs Hrs 1 Introduction to Computer amp Operating 20 120 140 System DOS Windows amp Linux 2 Business Application MS Word MS Excel 40 240 280 MS Power Point 2010 Internet Management amp E Commerce 3 Database Management using MS Access 20 80 100 2010 4 Programming Fundamentals Flow Charts 40 180 220 and Programming with VB Net 5 Functional English 20 20 40 6 Work Ethics 20 20 Total 160 640 800 SEMESTER 02 Theory Practical Total Sr Main Topics Hours Hours Hours 1 Graphics Design amp Animation 20 180 200 2 System Analysis amp Design 20 20 40 3 Introduction to Computer Networking 20 120 140 4
15. echnology 1 Year Course SKILL PROFICIENCY DETAILS On successful completion of this course the trainee should be able to ee a Oa Work on different operating systems like DOS Windows 7 amp Linux Work on different Business applications MS Word 2010 MS Excel 2010 amp MS Power Point 2010 Exercise Business Communication Skills amp Report writing Develop and Manage Database Management System Apply and Analyze E Commerce issues Design Develop and manage interactive Web sites Develop Financial Accounting related issues in E Commerce Desktop applications and integrate them in different projects Host and upgrade the Web sites Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 3 KNOWLEDGE PROFICIENCY DETAILS On successful completion of this course the trainee should be able to understand define and recognize EDP concept Different operating systems DOS Windows Linux Internet Word processing Spread Sheet and Multimedia presentation Business communication issues inside out side the organization and report writing Database Concepts and requirements with MS Access Programming logic using flowchart and developing front end using VB Net System Analysis and Design Web Designing and Development Web Programming with HTML and Java Script Interactive Web programming using PHP MySql amp Apache Web Server Host and upgrade th
16. es 1 23 3 Properties of folders files Practice for using above said options Using control panel complete 1 25 1 Opening Control Panel 1 25 2 Changing system date time and regional setting 1 25 3 Customize mouse and keyboard Practice for using above said options Advance display setting 1 27 1 Choosing Background 1 27 2 Screen saver important of Screen saver 1 27 3 Resolution system colors 1 27 4 Assignment sounds of system events 1 27 5 Add new Hardware Software Practice for using above said options Accessories 1 29 1 System Tools 1 29 2 Scandisk 1 29 3 Maintenance Wizard 1 29 4 Disk Clean up 1 29 5 Task scheduler 1 29 6 Disk Defragmenter 1 29 7 System Information 1 29 8 System restore Practice for using above said options 1 31 Calculator 1 1 Opening and operation 1 2 Copying calculator to application 1 3 Adding office to shortcuts to desktop Lab Practice for using above said options 1 3 1 3 1 3 1 31 Paint Drawing Rectangles Ellipse Circles Squares Paint tools etc Lab Practice for using above said options 1 32 Word pad 1 33 1 Word process of the documents 1 33 2 Cut copy paste operations Lab Practice for using above said options Developed by Curriculum Section Academics Department TEVTA Lab Practice for using above said commands Diploma in Information Technology 1 Year Course 10 1 33 Program applications 1 34 1 Howto run application
17. ichael Moncur SAMS 2000 3 Creative HTML Design 2 Lynda Weinman William Weinman Lynda com 2001 4 PHP essentials by Julie C Melonl 5 PHP 5 MYSQL programming for the absolute beginners by Andy Harris 6 PHP amp MYSQL for dynamic websites by Larry Ullman Introduction to Computer Networking Data Communications and Networking by Behrouz A Forouzan Data and Computer Communication by William Stallings Computer Networks by Douglas E Comer Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 29 EMPLOYABILITY OF GRADUATES This course carries much value and recognized in the private semi government and government sector as well as abroad for jobs as e Assistant Programmer e Web Developer e Books Keeper Developed by Curriculum Section Academics Department TEVTA
18. ing Techniques using File Zilla 45 System Analysis amp Design 2 1 Introduction to System 2 1 1 The System concept 2 1 2 Elements of a system 2 1 3 Characteristics of a system 2 1 4 Types of a System 2 2 Information System 2 2 1 Definition 2 2 2 Components of information system 2 3 New System 2 3 1 Consideration for the new system 2 3 2 Evaluation of old system 2 3 3 Technique and procedures for the implementation of the new system 2 3 4 The SDLC System Development Life Cycle 2 4 System Analyst 2 4 1 Importance of System Analyst in SAD System Analysis amp Design 2 4 2 Responsibilities of System Analyst 2 5 Feasibility Study 2 5 1 Definition and Types of feasibility study 2 5 2 Presentation of case study 2 5 3 Cost benefit Analysis 2 5 4 Feasibility study report Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 21 2 6 Fact Finding Technique 2 6 1 Fact gathering methods amp tools for company project Interviews questionnaires on site observation record reviewing sampling 2 7 The Tools of Structured Analysis 2 7 1 Design Diagram Computer based flow charting E_R diagrams Data Flow diagram maintaining a data dictionary 2 7 2 Decision Tools Decision tree Decision table and Structured English 2 8 The Tools of Object Oriented Analysis 2 8 1 Class Diagram Use case diagram 2 8
19. nformation Technology 1 Year Course 26 4 20 4 Connect to MySQL and create a table 4 20 5 Inserting data 4 20 6 Selecting and displaying data 4 21 User Authentication 4 21 1 Basic HTTP authentication 4 21 2 Configuring authentication on Apachi 4 21 3 Creating the users and group files 4 21 4 Configuring the group files 4 21 5 Configuring the web server 4 22 Database Authentication 4 22 1 Using PHP authentication variables to validate users 4 22 2 Using HTML forms to validate users 4 22 3 Limit by IP address 4 23 Session Management 4 23 1 Understanding session variables 4 23 2 Starting a session and registering variables Managing user preferences with sessions Project 60 Functional English ll 20 20 Work Ethics Il 20 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course SEMESTER I 27 REFERENCE BOOKS Subject Name Reference Books Introduction to Computer amp Operating System DOS Windows7 amp Linux 1 The Concepts of Information Technology 5th Edition by IT Series 2 A Comprehensive Study of Operating Systems amp Networks 4th Ed By IT Series 3 Microsoft Windows 7 Desktop support and Administration by Darril Gibson 4 The Complete Reference Linux Richard Peterson Business Applications amp E commerce 1 E Commerce 2011 by Kenneth C Laudon Carol Guercio Traver P
20. ols 3 5 3 OSI and TCP IP protocol Architecture 3 5 4 IPV 4 and IPV6 20 30 30 20 WEB DEVELOPENT USING PHP amp MYSQL 4 1 HTML Basics 4 1 1 Creating amp Formatting HTML Documents Working with Lists Images amp Tables Hyperlink amp Image maps 4 2 Advanced HTML 4 2 1 Layout with Frames 4 2 2 Working with Forms 4 2 3 Cascading Style Sheets 4 3 JavaScript Basics 4 3 1 Creating a simple Script 4 3 2 Operator amp Control Structures 4 3 3 Function amp Object 4 3 4 Strings amp Arrays 4 4 Interactivity with JavaScript 4 4 1 The document Object Model Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 4 4 2 Using Built in Objects 4 4 3 Events amp Event Handling 4 5 Advanced Web Features 4 5 1 Manipulating browser elements 4 5 2 Validating Forms 4 5 3 Graphic amp Animation 4 6 Labs Creating an HTML document Specifying a page title Specifying a Background color Text Color and Link Color Formatting text Creating an HTML document Creating bulleted amp numbered lists Inserting images in the document and enhancing layout using tables Creating an HTML document Creating Links to previously created documents Linking to other pages through images And using image maps to link to different documents from the same image Creating a page layout using frames Experimenting
21. racking Compare Comments Changes Protect View Ribbon 8 Documents Views Zoom Macros Show Hide Windows Microsoft Excel 2010 6 2 12 1 Introduction to MS Excel 2 12 2 Why We use MS Excel 2 12 3 Environment of MS Excel 2 12 4 Spread Sheet 2 12 5 Fundamentals of MS Excel 2 12 6 Difference b w MS Word and MS Excel 2 12 7 Use of Mouse amp Keyboard in Excel MS Office Button 9 2 13 1 New Save as Publish 2 13 2 Open Print Close 2 13 2 Save Prepare Quick Access Toolbar 9 E mail Spelling Sorting Quick Print Undo Print Preview Redo Home Ribbon Discuss in Detail 9 Clipboard Number Editing Font Style Alignment Cells Insert Ribbon 9 Tables Charts Text Illustrations Links Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 13 Page Layout 9 Themes Scale To Fit Arrange Page Set up Sheet Option Formulas 9 Insert Function Defined Names Watch Window Function Library Formula Editing Calculation Data Ribbon Get External Data Sort And Filter Outlines 9 Connections Data Tools Review Ribbon Proofing Comments Changes 9 View Ribbon Workbook Views Zoom Macros 9 Show Hide Windows Team Work Item Report Help 8 Tree Introduction to MS Power Point Interface of Ms Power Advantage of Ms Start Ms 8 Power Point Point Power Point What is Presentation Short Cut Keys Home Ribbon Discuss in Detail Clipboard Font Drawing 10 Slides Paragraph Editing Insert Ribbon
22. rentice Hall 2010 Business amp Economics 2 The E Commerce book building the E empire by Seffano Korper Junaita Ellis Database Management using MS Access 2010 1 Fundamentals of Database Systems by Ramiz Elmasri and Shamkant Navathe 2 A Fundamental Study of Database Management Systems 2nd Ed IT Series 3 4 Access 20xx For Dummies By Laurie Ulrich Fuller Ken Cook John Kaufeld Publisher Wiley Programming Fundamentals Flow Charts and Programming with VB Net 1 An Introduction to Programming Using Visual Basic NET by David I Schneider 2 Vb Net by Camron Wakefield Henk Evert Sonder SEMESTER II Subject Name Reference Books Graphics Design and 3 Photoshop CS Bible by Deke McClelland Animation 4 Flash Professional CS5 Bible by Todd Perkins 5 Adobe Dreamweaver CS5 Bible By Joseph Lowery System Analysis amp Design 1 System analysis and Design by Kendall and Kendall 2 System analysis and Design by Elias M Awad 3 Applying UML and Patterns An Introduction to Object Oriented Analysis and Design and the Unified Process by Craig Larman Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 28 Web Development using PHP amp MySql 1 JavaScript amp HTML 4 0 Users Resource William H Murray amp Chris H Pappas Prentice Hall 2000 2 SAMS JavaScript in 24 Hours Second Edition M
23. roperties to manipulate values Creating a script that lets the browser respond to mouse events Display alerts on mouse clicks And launches popup windows on clicking a button Using Keyboard events and the on Load Event Creating a document with a button that launches a new browser Using JavaScript to hide the scroll bars the navigation bar and to launch fixed sized popup windows Using the Form object to validate a form checking various input fields for the proper input Creating an animation using an image array 4 7 Introduction to Web Development 4 7 1 What is dynamic website 4 7 2 What Is PHP 4 7 3 What MySQL 4 8 Getting Started with PHP 4 8 1 Installing PHP and configuring Apache Web server on Windows Linux 4 8 2 Installing PHP and configuring PHP on Windows Linux 4 8 3 Modifications with php ini 4 8 4 Installing MySQL 4 8 5 Add Database supports to PHP 4 9 Basic PHP Techniques 4 9 1 Combining HTML and PHP 4 9 2 The importance of instructions terminators 4 9 3 Escaping the code 4 9 4 Commenting the code 4 10 PHP Variables and Data Types 4 10 1 Variables types 4 10 2 Local and global variables 4 10 3 Predefined variables 4 10 4 Data types 4 11 PHP Operators Types 4 11 1 Assignment operators 10 10 10 10 Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 25 4 11 2 4 11 3 4 11 4 4
24. ta Source Window 4 12 4 Using Bound Controls to display 4 12 5 Using SQL Statements 4 12 6 Using the Data Control amp Grid View Reporting 4 13 1 Design VB Net Report 4 13 2 Using Crystal Report 18 19 19 18 5 Functional English 20 20 6 Work Ethics Lab Theory 20 Total 160 640 Developed by Curriculum Section Academics Department TEVTA Semester Il Diploma in Information Technology 1 Year Course DETAIL OF COURSE CONTENTS Diploma in Information Technology 01 Year 19 Sr Detail of Topic Theory Hrs Practical Hrs Graphics Design amp Animation 1 1 Digital Imaging Template Designing Using Adobe Photoshop CS Technology 1 1 1 1 2 1 3 1 4 1 5 1 6 1 7 1 8 1 9 1 1 1 1 ee ee ee d d ee k _ l 1 Discussion on Publishing Media Bitmap Graphics amp Vector Graphics Basic Design Issues Lines Shapes Polygons Rectangles amp Ellipses Web Color Theory amp Color Wheel Transform amp Free Transform Use of Layers Techniques Filters Plug Ins Use of Different Selection Types 0 Image Adjustment 1 Use of different image jpg gif amp png etc files formats 1 12 Different Zoom Options 1 13 Use of Third Party Tools 1 14 Use of Slices amp making of HTML files 1 2 Digital Illustration using CorelDraw X Series 1 2 1 1 2 2 1 2 3 1 2 4 1 2 5 1 2 6 1 2 7 1 2 8 1 2 9
25. to create internet connection Installing and configuring internet protocol TCP IP Introduction to Internet browsers Concepts And Capabilities Relating to the Internet and Basic Procedures for Setting up A System for Internet Access Creating online e mail account using web services Sending and receiving E mails 2 1 10 File attachment 2 1 11 Uploading and downloading file s and software s Microsoft Word Introduction 2 2 1 2 2 2 2 2 3 2 2 4 2 2 5 2 2 6 2 2 1 Environment of MS Word Importance of MS Word Selection of Shortcut Keys Word Processor Starting Word Keyboard Navigation Start Bar MS Office Button New Open Save Save as Publish Print Close Prepare Recent Documents Quick Access Toolbar E MAIL Spell amp Grammar Draw Table Quick Print Undo Etc Print Preview Redo Home Ribbon Discuss All Groups Font Editing Detail Clipboard Paragraph Styles Insert Ribbon Pages Tables Links Symbol Header and Footer Illustrations Text Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 12 Page Layout Ribbon 7 Themes Page Background Arrange Page Set up Paragraph References Ribbon 7 Table of Contents Citation And Index Footnotes Bibliography Table of Caption Authorities op 7 Mailing Ribbon Create Write and Finish Start Mail Merge Insert Files Preview Results Preview Ribbon 8 Proofing T
26. with vertically and horizontally nested frames Creating an HTML document and creating a form for a retail store incorporating the various input methods Creating custom styles in the CSS format and applying them to a series of previously created html documents Creating a simple script in a page that displays a short message amp using a script to display the current time on the page Creating a webpage that displays a string from the smallest to the largest font size by using different loops Use conditional statements to display different alerts Creating amp Calling Functions to display messages according to the input Creating a script with various strings Concatenating the strings Calculating their length Converting their casing and using the substring method Creating an Array Manipulating and accessing the array elements to create a scrolling message Creating a page with a script that manipulates the Developed by Curriculum Section Academics Department TEVTA Diploma in Information Technology 1 Year Course 24 various element of DOM Getting the browser version Adding Back and Forward buttons to the page using the history object amp using the document location object to redirect the browser to a new URL Creating an HTML document with a script that uses built in objects to get the current time to convert it to UTC time To perform various mathematical calculations Using the object p
Download Pdf Manuals
Related Search