Course Outcomes (COs):
Course |
Learning outcome (at course level) |
Learning and teaching strategies |
Assessment Strategies |
|
Course Code |
Course Title |
|||
25AFIT400
|
Introduction To Information Technology
|
CO1. Explain the fundamental concepts of computer and use of AI in daily life CO3. Design spreadsheets and use basic functions, create charts to analyses data. CO4. Design presentation using presentation tools and enhance presentation skills CO6. Contribute effectively in course-specific interaction |
Interactive Lectures, Discussions, student centered approach, Through Video Tutorials Learning activities: Presentations, Quizzes and Assignments |
|
Introduction to Computers (definition, characteristics & uses), System unit (memory, ALU & control unit), Input / Output devices, Storage devices (Memory- primary & secondary).
Introduction to Software, its type (system, application & utility); Programming languages (machine, assembly & high-level), Language processors (assembler, compiler & interpreter).
Definition and brief history of AI, AI applications and impact on society, basic concepts of machine learning and generative AI.
Introduction to word processing, Features of Word processors, Working with formatted documents, Shortcut keys. Finding & replacing text, Go To (F5) command. Formatting documents, Selecting text, formatting characters, Changing cases, Paragraph formatting, Indents, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs. Proofing text (Spell check, Auto correct), Inserting pictures, Mail merging, Printing.
Introduction, spreadsheet, workbooks, saving a file, opening an existing worksheet, Rows and columns, cell entries (numbers, labels, formulas), spell check, find and replace, Adding and deleting rows and columns, filling series, fill with drag, data sort, formatting worksheet, Introduction to charts, types of charts, Renaming sheet, Printing worksheet.
Functions (FLOOR, CEILING, ROUND, SUM, PRODUCT, QUOTIENT); Text (EXACT, LEFT,LEN, LOWER, MID, PROPER,REPLACE, RIGHT, TRIM, UPPER, VALUE,); Statistical Functions(AVERAGE,COUNT,MAX, MIN, MEDIAN, MODE)
R.K.Taxali, “PC Software For Windows” , Tata McGraw Hill