विश्लेषणात्मक क्षमता और डिजिटल जागरूकता

Programme /Class: Certificate

Year: Third

Semester: Fifth

Co-Curricular Course

Course Title: Analytic Ability and Digital Awareness

Course outcomes:

CO 1: Familiarize with analogy, number system, set theory and its applications, number system and puzzles.

 CO 2: To understand the basics of Syllogism, figure problems, critical and analytical reasoning.

CO 3: Familiarize with word processing application and work sheet.

CO 4: To understand the basics of web surfing and cyber security

Credits: 2

Compulsory

Max. Marks: 25+75

Min. Passing Marks: 8+25

Unit

Topics

I

Alphabet test, Analogy, Arithmetic Reasoning, Blood relations, Coding and Decoding, Inequalities, Logical Venn diagram, Seating Arrangements, Puzzles and Missing numbers

II

Syllogism, Pattern completion and figure series, Embedded Figure and counting of figures, Cube & Dice, Paper cutting and folding, Data sufficiency, Course of Action, Critical Reasoning, Analytical and decision making

III

Computer Basics:

Block diagram of Digital Computer, Classification of Computers, Memory System, Primary storage, Auxiliary memory, Cache memory, Computer Software (System/Application Software),

MS Word Basics:

The word screen, Getting to word documents, typing and Revising text, Finding and Replacing, Editing and Proofing tools, Formatting text characters, Formatting Paragraph, Document templates., Page set up, tables, Mail Merge, Macros, protecting documents, printing a document.

MS-Excel

Introduction, Worksheet basics, Creating worksheet, Heading information, Data & Text, Date & Time, Alphanumeric values, Saving & quitting worksheet, Opening and moving around in an existing worksheet, Toolbars and Menus, Excel shortcut and function keys, Working with single and multiple workbook, Working with formulae & cell referencing, Auto sum, coping formulae, Absolute & relative addressing, Worksheet with ranges, Formatting of worksheet, Previewing & Printing worksheet, Graphs and charts, Database, Creating and using macros, Multiple worksheets- concepts Introduction of Open Source Applications: LibreOffice, OpenOffice and Google Docs etc

IV

Web Surfing:

An Overview: working of Internet, Browsing the Internet, E-Mail, Components of E-Mail, Address Book, Troubleshooting in E-Mail, Browsers: Netscape Navigator, Microsoft Internet Explorer, Google Chrome, Mozilla Firefox, Tor, Search Engines lik Google, DuckDuckGo etc, Visiting web sites: Downloading. Cyber Security:

Introduction to Information System, Type of information system, CIA model of Information Characteristics, Introduction to Information Security, Need of Information Security, Cyber Security, phishing, spamming, fake news, general issues related to cyber security, Business need, Ethical and Professional issues of security