Foundation of Information Technology
(Code No. 165)
1. To familiarize with basics of information technology
2. To develop basic skills of using tools for information representation and processing.
3. To use Information Processing tools for enhancing productivity and quality.
1. Cognitive domain : Knowledge and understanding
To develop basic understanding of IT tools.
2. Psychomotor domain : Skills
To develop skills in using Information Processing tools.
3. Affective domain : Personality traits
To develop habit of teamwork, structure presentation and abide by ethical principles of computing
|Unit ||Description ||Periods ||Marks |
| || ||Theory ||Practical ||Theory ||Practical |
|1 ||Basics of Information Technology ||10 ||00 ||10 ||00 |
|2 ||Information Processing Tools ||35 ||20 ||30 ||10 |
|3 ||IT Applications ||30 ||20 ||30 ||10 |
|4 ||Societal impacts of IT ||05 ||00 ||10 ||00 |
| || |
|80 ||40 ||80 |
Unit 1 : Basics of Information Technology
Internet : World Wide Web, Web Servers, Web sites, Web Pages, Web Browsers, Blogs, Newsgroups, HTML, Web address, Email address, URL, HTTP.
Services available on Internet: Information Retrieval, Locating sites using search engines and finding people on the net, Chat, FTP, Downloading and Uploading files from or to remote site.
Web services : Chat, email, Video conferencing, e-Learning, e-Banking, e-shopping, e-reservation, e-Groups, Social Networking.
UNIT II : Information Processing Tools
Database Management Tool : Basic Concepts and need for a database, Creating a database, Setting the Primary Key, Entering data into a database, Inserting and deleting fields, Inserting and deleting Records,
Data Validation: Field Size, Default Value, Validation Rule, Validation Text, Required, Allow Zero Length.
INFORMATION REPRESENTATION METHODS
Hyper Text Markup Language
Introduction to Web Page Designing using HTML, Creating and saving an HTML document, accessing a web page using a web browser (Internet Explorer, Mozilla firefox, Operat Apple Safari, Netscape Navigator, Google Chrome);
Elements in HTML : Container and Empty elements, Designing web pages using the following elements: HTML, HEAD, TITLE, BODY (Attributes: BACKGROUND, BGCOLOUR, TEXT, LINK, ALINK, VLINK, LEFTMARGIN, TOPMARGIN), FONT (Attributes: COLOUR, SIZE, FACE), BASEFONT (Attributes :COLOUR, SIZE, FACE), CENTER, BR (Break), HR (Horizontal Rule, Attributes: SIZE, WIDTH, ALIGN, NOSHADE, COLOUR), COMMENTS, ! for comments, H1.. H6 (Heading), P (Paragraph), B(Bold), I (Italics), U (Underline), UL & OL (Unordered List & Ordered List Attributes: TYPE, START), LI (List Item), Insertion of images using the element IMG (Attributes : SRC, WIDTH, HEIGHT, ALT, ALIGN), Superscript SUP and subscript SUB. Inserting table-TABLE, TR, TD, ROWSPAN, COLSPAN
Internal and External Linking between Web Pages: Signficance of linking, A-Anchor Element (Attributes: NAME HREF, TITLE, ALT)
Introduction to XML, Difference between XML and HTML with respect to the following : Data sepration, data sharing, documents structure, tags, nesting of elements, attribute, values.
XML Elements - Defining your own tags in XML, Root element, child elements and their attributes; Comments in XML, White space and new line in XML, well formed XML documents, validating XML documents, XML Parser, Viewing XML documents in a web browser.
UNIT III : IT Applications
Students are suggested to work on the following areas using Database Management Tools and HTML on topics implementing the tools covered in the course.
Personal Data Management System
School/Class Result with student-wise and subject-wise marks
Employee Payroll (Computation of Monthly Salary)
Stock Inventory (Purchase and Issue records)
Personal Blog with Name, Photo, Areas of Interest, School, State, Country
School Website - Infrastructure, Facilities, Uniform, Motto, School Pictures, Extra-Curricular Activities, Subject and Language Options
Travel and Tourism
Indian Statistics - State wise Area, Population, Literacy (Enrolment in Primary, Middle, Secondary, Senior Secondary), Gender Ratio
Environment (Save Energy) and Pollution (Global Warming)
UNIT IV : Societal Impacts of IT
Virus, Worms, Trojans and Anti-Virus Software, Spyware, Malware, Spams, Data Backup and recovery tools and methods, Online Backups, Hacker and Cracker with regard to Computer Data and Applications.
Information security provisions in e-Commerce
|One Practical Paper ||Time: 2 Hours ||20 Marks || |
|(A) HANDS ON EXPERIENCE || |
Design of a Practical Question Paper
There is no pre-set question paper provided by CBSE for conducting practical examination. This flexibility has been provided to give more freedom to the examiners for the improvement of practical examination, keeping in view the resources and other facilities available in the laboratory of the School. However, detailed instructions on the basis of syllabus, distribution of marks and conduction of practical examination have been provided. The internal examiner and the external examiner together set the question paper according to the prescribed curriculum and distribution of marks.
I. Buisness Computing Problem :*
A business-computing problem is required to be solved using Database Management Tools for testing the following aspects of database. Creating and entering data into a database:
Setting the primary key
Validation of data
II. Web Page Designing:*
A Problem on Web Page designing (Minimum 2 pages) to be given for testing in the following HTML elements:
Adding a title to webpage
Putting main points using ordered or/and unordered list
Writing text in paragraphs
Inserting content in tabulated from.
The students are supposed to know the tools and style for designing domain specific WebPages from real life applications and the topic mentioned in the syllabus
Students to be asked to create an XML document on the lines of XML concepts covered in theory syllabus.
Break up of Marks (HTML)
Visual Effect : 1
Linking : 1
Coding : 2
* Printout of the document(s) should be attached with the answer sheet.
|(B) IT Application Report File || |
Students are supposed to make a IT Application Report File Containing Real life assignments/ presentations using Database Management Tools and HTML on topics from the domain. Must have print outs of the following:
4 database solutions from Business Computing
8 HTML source code along with browser view
The questions can be asked from any portion of the syllabus covered during Class IX and Class X.
NOTE: Teachers are suggested to give first-hand demonstration covering the aspects such as : Connecting to internet, Using popular Search Engines, Web Browsing, Opening E-mail accounts, Sending and Receiving E-mails, Downloading files and pictures.