ICT LAB

Paper Code: 
CBCA 102
Credits: 
3
Periods/week: 
6
Max. Marks: 
100.00
Objective: 

The course will enable the students to

  1. Familiar with MS-DOS: basic external and internal commands.
  2. Use productivity software likeWord, Excel, Power Point and Access.
  3. Use of Google Drive to save, store, share and access files and folders from anywhere.

 

Course Outcomes (COs):

Learning Outcome (at course level)

Learning and teaching strategies

Assessment Strategies

CO 6 Learn the fundamental of word processors tool and will able to create well formatted documents.

CO 7 Design spreadsheets and employ basic functions, create charts, perform statistical analysis.

CO 8 Design an effective presentation.

CO 9Comprehend the fundamental of database management software’s and develop an ability to manage data.

CO 10 Develop an ability to work on google drive and apply the concepts of saving storing, sharing and accessing files and folders on the cloud.

Approach in teaching:

Interactive Lectures, Discussion, Tutorials, Reading assignments, Demonstration, Team teaching

 Learning activities for the students:

Self-learning assignments, Effective questions, Simulation, Seminar presentation, Giving tasks.

 

Class test, Semester end examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects

 

Exercises given will be based on following topics:

  • MS-DOS: Overview, Internal Commands (DIR, CD, MD, RD, COPY, COPY CON, DEL, REN, DATE, TIME, VER, CLS, TYPE, PROMPT, PATH) and External Commands (TREE, DELTREE, EDIT).
  • Introduction to types of Internet Connections (Dial Up, DSL, Broadband, VSAT, WiFi, 3G, 4G)
  • Introduction to various types of Protocols (SMTP, POP, Telnet, FTP, HTTP, HTTPS)
  • Word Processor: Features of Word processors, Shortcut keys, formatting documents: Selecting text, Copying & moving data, formatting characters, changing cases, Paragraph formatting, Indents, Drop Caps, Using format painter, Page formatting, Header & footer, Bullets & numbering, Tabs, Creating tables, styles and templates. Finding & replacing text, GoTo (F5) command, Text Proofing features, Macros, Inserting pictures, Hyperlinks, Mail merge, Printing.
  • Spreadsheet Software: workbooks and worksheets, working with single and multiple workbook cell entries (numbers, labels, and formulas), Filling series fill with drag, data sort, formatting worksheet, cell referencing (Relative, Absolute, Mixed).
  • Some useful Functions in excel: If Function, Date & Time: DATE, DAY, MINUTE, HOUR, NOW, SECOND. Statistical: AVERAGE, COUNT, MAX, MIN. Text: CHAR, CONCATENATE, EXACT, LEFT, LEN, LOWER, MID, REPLACE, RIGHT, SEARCH, TEXT, TRIM, UPPER. Math & Trig: CEILING, FACT, FLOOR, INT, ROUND, SQRT, SUM.
  • Introduction to charts: types of charts, creation of chart from adjacent data/ nonadjacent data, formatting charts. Printing worksheets, OLE (importing & exporting data), Hyper linking, data sort and filters, Macros.
  • Introduction to Presentation Software: Presentation tips, components of slide, slide templates, master slide, header and footer, images and auto shapes, presentation views, transition and animations, inserting audio, video, action buttons and hyperlinks, rehearse timings, printing slides.
  • Use of Google Drive to save, store, share and access files and folders from anywhere.
Academic Year: 
2020-21
  • Printer-friendly version