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 like Word, Excel, Power Point and Access.
  3. Use of Google Drive to save, store, share and access files and folders from anywhere.

Course Outcomes (COs):

Course Outcome (at course level)

Learning and teaching strategies

Assessment Strategies

The students will:

CO6. Create well formatted documents using various features of word processor tool

CO7. Design spreadsheets, apply basic functions and charts to analyse data

CO8. Infer the features of presentation software and design effective presentation.

CO9. Recall the fundamentals of database management software and manage data.

CO10. Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive.

Approach in teaching:

 

Interactive Lectures, Discussion, Tutorials, Demonstration,

 

Learning activities for the students:

 

Self-learning assignments, Practical questions

Class test, Semester end examinations, Quiz, Presentation, Individual and group Assignments

  • 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.

JOURNALS:

1.    https://journal-bcs.springeropen.com/

2.    https://jisajournal.springeropen.com/

3.    https://www.sciencedirect.com/journal/thinking-skills-and-creativity

E-RESOURCES:

  1. https://home.csulb.edu/~murdock/dosindex.html
  2. https://support.microsoft.com/en-us/office/basic-tasks-for-creating-a-powerpoint-presentation-efbbc1cd-c5f1-4264-b48e-c8a7b0334e36
  3. https://www.excel-easy.com/
  4. https://support.microsoft.com/en-us/office/analyze-data-in-excel-3223aab8-f543-4fda-85ed-76bb0295ffc4
  5. https://edu.gcfglobal.org/en/googledriveanddocs/
  6. https://support.google.com/a/users/answer/9282958?hl=en
Academic Year: 
2023-24
  • Printer-friendly version