COMPUTER BASED SKILLS- I

Paper Code:

AAF 117

Credits:

2

Contact Hours:

30.00

Max. Marks:

100.00

Objective:

Course Outcomes (COs):

Course Outcomes	Learning and teaching strategies	Assessment Strategies
On completion of this course, the students will be able to: CO35: Create well formatted documents using various features of word processor tool CO36: Design spreadsheets, apply basic functions to analyse data. CO37: Infer the features of presentation software and design effective presentation. CO38: Creating tables, forms, queries and reports using MS-Access CO39: Apply the concepts of storing and accessing files and folders on the cloud and demonstrate the ability to work on google drive.	Class lectures, Seminars, Tutorials, Group discussions, Workshops and Question preparation	Quiz, Poster Presentations, Open book test, Semester End Examination

Course Outcomes

Learning and teaching strategies

Assessment Strategies

On completion of this course, the students will be able to:

CO35: Create well formatted documents using various features of word processor tool

CO36: Design spreadsheets, apply basic functions to analyse data.

CO37: Infer the features of presentation software and design effective presentation.

CO38: Creating tables, forms, queries and reports using MS-Access

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

Class lectures, Seminars, Tutorials, Group discussions, Workshops and Question preparation

Quiz, Poster Presentations,

Open book test, Semester End Examination

6.00

Unit I:

· Introduction to word processing: Working with formatted documents, Shortcut keys. Finding & replacing text, Go To command. selecting text, changing cases,

· Paragraph and page formatting. Header & footer, proofing text, Inserting pictures, Mail merging.

6.00

Unit II:

· Handling data using Spreadsheets: Creating a Table, formatting of table, auto fill series, Basic Functions (SUM, AVERAGE, COUNT, MAX, MIN),Sorting and filtering, Cell referencing, Importing external data, basic charts(bar, column charts)

6.00

Unit III:

· Data management using MS-ACESS (creating tables, forms, queries and reports), importing and exporting data.

6.00

Unit IV:

· Presentation Software: using templates and wizards, creating presentation using blank presentation, Adding objects and action buttons. Various presentation views,

· Working in slide sorter view, adding transition and animations to slide show, printing slides, adding master-slide.

6.00

Unit V:

· Cloud based Office Tools- Google drive, Google docs, Google sheets, Google slides. Sharing and creating files, uploading and downloading files and folders. Creating and designing forms using Google forms.

· Introduction to office365 and its applications

Essential Readings:

· Mastering Word 2000 – Mansfield &Olsen

· Mastering Excel 2000 – Martin, Hansen, Klingher & Beth

· Mastering Power Point 2000 – Murray

References:

· Dr. Leena Bhatia & Dr. Bindu Jain, Elementary Computer Application

· Shubhi Lall, Elementary Computer Application

· Mastering DOS – Robbins

· Mastering Windows 98 – Robert & Cowart

e- RESOURCES:

· https://www.excel-easy.com/