|
|
Course Title: Computer Fundamentals
& Programming.
Course NO.: ICTED 311 Full Mark:100(75+25) Nature of the Course : Theory 75% + Practical 25% Pass Mark: 35 (27+10) Periods Per weak: 6+3 Total number of working periods 150 per year [Note: 1 period = 50 min] COURSE DESCRIPTION:- This course contains Computer Fundamentals, Hyper Text Markup Language (HTML), Application packages (Word processing, Spreadsheet, Data processing and Presentation Package including Windows Operating System) and Programs in QBASIC. In the Computer fundamentals Introduction to Computer system including its evolution, generation, classification, working speed, measurement units, Logic functions and Boolean Algebra, etc. covered as well as it studies hardware details, storing medias, networking, communication technology and Internet, E-mail etc. HTML covers the webpage designing skills. In application packages Windows Operating system, Word Processing skills, simple mathematical record keepings including logical, statistical, trigonometrical, arithmetical functions graphic and database management system (DBMS) skills are studied. This paper contains 75% theoretical part and 25% practical part. OBJECTIVES:- On completion of this course students will be able to:
|
SN | Objectives | Contents | Period | Testing Strategies | Reference | Evaluation |
1 | COMPUTER FUNDAMENTALS To define, use, demonstrate and apply the computer system. |
1. Introduction to computer system: | 6 Periods (Theory only) |
1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Leon Chapter (1 to 9) |
1. Question & answer. 2. Writing test 3. Discussion. |
To get familiarized with computer software, operating system, programming languages general software features and trends and data processing. |
6. Computer Software: | 8 Periods (Theory only) | 1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Leon Chapter (10 to 13) |
1. Question & answer. 2. Writing test 3. Discussion | |
To describe the DBMS, Introduction to telecommunication, compute network, communication system, www, Intranets and multimedia. |
11. Database Management System: | 10 Periods (Theory only) |
1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Leon Chapter (15, 17, 18, 19, 21) |
1. Question & answer. 2. Writing test 3. Discussion | |
To get familiarized with compute security, IT policies, cyber law, data representations and history of computers. |
19. Computer Securities | 5 Periods (Theory only) | 1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Use reference books | 1. Question & answer. 2. Writing test 3. Discussion |
|
To describe impact of ICT and e-Technologies. | 23. Impact of the Computer Technology in the society. 24. e-Technology | 1 Periods (Theory only) | 1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Use reference books | 1. Question & answer. 2. Writing test 3. Discussion |
|
2 | HTML: To define and use the general and simple concept of program writing steps. To gain skill in web site designing. |
- Introduction - Creating & Opening - Formatting - Setting - Creating links - Inserting Image - Working with table | 12 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test. | Use reference books | 1. Writing test. 2. Practical test. |
3 | (A) WINDOWS XP: To run windows operating system DOS basic concepts. |
- Introduction to OS its classification. - Role of OS, Booting and shut down a pc. - Basic terms of Dos commands. - DOS Commands (Internal + Externals). - GUI Environments. - Introduction to Windows OS. - Working with Files & Folders - Working with a windows application programs. - Customizing the Task bar and desktops. - Customizing windows. - Use of Accessories. | 6 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test. | Any reference book Nepali author | 1. Writing test. 2. Practical test. |
(B) WORDS PROCESSING: To run a word processing package. |
- Introduction to Word-processing. - Types of Bars. - Typing text, saving a file on your folder. - Selecting text. - Spell checking. - Formatting documents. - Header and Footer. - Pg No, Page Break. - Using word Arts, Picture Art. - Making tables. - Printing text & Preview. - Copy a file on a pen drive or CD. - Copy a file in HD from CD or CD. | 18 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test.. | Any reference book | 1. Writing test. 2. Practical test. | |
(C) SPREAD SHEET: Run a spread sheet package. |
- Introduction to Spreadsheet. - Creating table with data. - Insert & delete, Rows & Columns. - Using formula (+,-,*, /). - Using logical functions (If, AND, OR). - Using colors, fonts & font size. - Using different types of Functions. - Creating different types of the charts. - Save the file on your folder. | 12 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test. | Any reference book | 1. Writing test. 2. Practical test. | |
(D) DATABASE MANAGEMENT SYSTEM (DBMS): Run a Database Management System (DBMS) package. |
- Introduction to DBMS, - Create a Database - Create table, Fields and their properties - Create Relational Database, - Create and Run Queries - Working with Forms, - Generate Report, - Formatting Forms and Reports. | 12 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test. | Any reference book | 1. Writing test. 2. Practical test. | |
(E) PRESENTATION PACKAGE: - To enable creating and editing presentation - To enable designing of custom animation -To enable to work with table, graphic, word Art - To enable to work with multimedia |
- Concept of presentation - Type and use of presentation program - Editing a presentation program - Designing and formatting presentation - Transition of presentation - Animation and custom Animation - Working with Table, Graphics, Word Art - Working with Graphics and Organization Charts - Working with Multimedia | 6 hrs. (T+P) | 1. Interaction. 2. Discussion. 3. Writing test. 4. Group discussion | Any reference book | 1 Writing test 2. Practical test | |
4 | QBASIC PROGRAM: Draw a flow chart according to a given problem. Convert a flow chart into QBASIC program codes. Entry the program codes into the computer as a self made program. Process the data using self made program. |
- General concept of a program. - Introduction to QBASIC Program - Elements of QBASIC programming language. - Control statements (Using with procedures and file handling) - Library functions - Functions and Sub procedures. - File handling - Project in QBASIC. | 54 hr (T+P) | 1. Oral test. 2. Writing test. 3. Practical test. | Any reference book | 1. Writing test 2. Practical test |
1. Alexis Leon and Mathew Leon- Fundamentals of Information Technology –Bikash Publishing House Pvt. Ltd. New Delhi.
Reference Book:
1. Hari Gopal Shrestha - Computer Paricharya Bhag (1) and Bhag (2), Ratna Pustak Bhandar.
2. Donald H, Sanders, Computer Today with Basic 3rd Edition, McGraw- Hill, Inc.
3. B.Ram, Computer Fundamentals Architecture and Organization, 3rd Edition, New Age International Pvt. Ltd. India.
4. Basandra SK, Computers Today Updated Edition, Galgotia Publication, 2008
5. URL: http// www.w3.org/html/
*** END ***