Computer Applications in Business

Teacher

Ajitav Acharya

Category

Course Attendees

Still no participant

Course Reviews

Still no reviews

Course Name : Computer Applications in Business

Code(Credit) : CUTM1686(0+5+1 )

Course Objectives

To understand the application of computers in the business organization with a focus on Microsoft Word, Microsoft Excel and Microsoft PowerPoint.

Learning Outcomes

On completion of this course, learners will be able to:

  • To understand the basic uses of Microsoft word in business,
  • To understand the basic uses of Microsoft Excel in business,
  • To understand the basic uses of Microsoft PowerPoint in business.

Course Syllabus

Unit-1: 

 

Word processing Introduction: Creating and saving your document, displaying different views, working with styles and character formatting, working with paragraph formatting techniques using indents, tabs, alignment, spacing, bullets and numbering and creating borders. Page setup and sections: Setting page margins, orientation, headers and footers, end notes and foot notes, creating section breaks and page borders.
Unit-2: 

 

Working with tables: Creating tables, modifying table layout and design, sorting, inserting graphics in a table, table math, converting text to table and vice versa. Create newspaper columns, indexes and table of contents. Spellcheck your document using inbuilt and custom dictionaries, checking grammar and style, using thesaurus and finding and replacing text. Create bookmarks, captions and cross referencing, adding hyperlinks, adding sources and compiling and bibliography Mail merge: Creating and editing your main document and data source, sorting and filtering merged documents and using merge instructions like ask, fill-in and if-then else. Linking and embedding to keep things together
Unit-3: 

 

Spreadsheets Introduction: Concept of worksheets and workbooks, creating, opening, closing and saving workbooks, moving, copying, inserting, deleting and renaming worksheets, working with multiple worksheets and multiple workbooks, controlling worksheet views, naming cells using name box, name create and name define. Using formulae and functions: Understanding absolute, relative and mixed referencing in formulas, referencing cells in other worksheets and workbooks, correcting common formula errors, working with inbuilt function categories like mathematical, statistical, text, lookup, information, logical, database, date and time and basic financial functions.
Unit-4: 

 

Consolidating worksheets and workbooks using formulae and data consolidate command Printing and Protecting worksheets: Adjusting margins, creating headers and footers, setting page breaks, changing orientation, creating portable documents and printing data and formulae. Implementing file level security and protecting data within the worksheet Creating charts and graphics: Choosing a chart type, understanding data points and data series, editing and formatting chart elements, and creating Sparkline graphics. Analyzing data using pivot tables: Creating, formatting and modifying a pivot table, sorting, filtering and grouping items, creating calculated field and calculated item, creating pivot table charts, producing a report with pivot tables. Performing what-if analysis: Types of what if analysis (manual, data tables, scenario manager).
Unit-5: 

 

PowerPoint presentation Introduction: Creating a blank presentation using a design template, basing a new presentation on an existing one, creating and managing slides, using content place holders, creating graphs, tables, diagrams, organization charts, inserting clip art and images. Viewing and navigating a presentation: Organizing ideas in outline view, using slide sorter to rearrange a presentation, previewing presentation in slide show, understanding master views, using title master, slide master, handout master and notes master, working with headers and footers, using hyperlinks, advanced navigation with action settings, navigation short hand with action buttons
Unit-6: 

 

Animation and multimedia: Using and applying animation schemes, custom animation, understanding sound file formats and video types, adding music, sound and video clips. Final presentation: Applying transition to slides, controlling transition speed, using hidden slides, using custom shows, using on screen pen and adding and accessing notes during a presentation
Unit-7: 

 

Database Designs for Accounting and Business Applications: Reality- Expressing the Application; Creating Initial design in Entity Relationship(ER) Model; Transforming ER Model to Relational data model concepts; Implementing RDM design using an appropriate DBMS. SQL and Retrieval of Information: Basic Queries in SQL; Embedded Queries in SQL; Insert, Delete and Update statements in SQL DBMS Software: Environment; Tables; Forms; Queries; Reports; Modules;  Applying DBMS in the areas of Accounting, Inventory, HRM and its accounting, Managing the data records of Employees, Suppliers and Customers
Unit-8: 

 

Flash Fill, Advance Number Formatting, Advance Conditional Formatting, Data Validation, Quick Analysis, Lookup Functions, Match & Index, V lookup, H lookup, SUMPRODUCT Function

 

Unit-9:  Google Drive: Files in Google Drive, Form Creation, Sending and receiving response

 

Books Recommended:

 

  1. Alexis Leon and Mathews Leon: Fundamentals of information technology, Leon Techworld Pub.
  2. Sinha, Computer Fundamentals,
  3. BPB Pub Malhotra, Computer Applications in Business
  4. Saxena, Sanjay, ‘‘A First Course in Computers’’, Vikas Publishing House.

Session Plan

Session 1

Creating and saving your document, displaying different views, working with styles and character formatting, working with paragraph formatting techniques using indents, tabs, alignment, spacing, bullets and numbering and creating borders. Page setup and sections: Setting page margins, orientation, headers and footers, endnotes and footnotes, creating section breaks and page borders.

Computer-Applications-in-Business

https://www.youtube.com/watch?v=Ut9B_DFxH7g

Session 2

Creating tables, modifying table layout and design, sorting, inserting graphics in a table, table math, converting text to a table and vice versa. Create newspaper columns, indexes and table of contents. Spellcheck your document using inbuilt and custom dictionaries, checking grammar and style, using the thesaurus and finding and replacing text. Create bookmarks, captions and cross-referencing, adding hyperlinks, adding sources and compiling and bibliography Mail merge: Creating and editing your main document and data source, sorting and filtering merged documents and using merge instructions like ask, fill-in and if-then-else. Linking and embedding to keep things together

Computer-Applications-in-Business

https://www.youtube.com/watch?v=Ut9B_DFxH7g

Session 3

Concept of worksheets and workbooks, creating, opening, closing and saving workbooks, moving, copying, inserting, deleting and renaming worksheets, working with multiple worksheets and multiple workbooks, controlling worksheet views, naming cells using name box, name create and name define. Using formulae and functions: Understanding absolute, relative and mixed references in formulas, referencing cells in other worksheets and workbooks, correcting common formula errors, working with inbuilt function categories like mathematical, statistical, text, lookup, information, logical, database, date and time and basic financial functions.

Computer-Applications-in-Business

https://www.youtube.com/watch?v=rwbho0CgEAE

Session 4

Consolidating worksheets and workbooks using formulae and data consolidate command Printing and Protecting worksheets: Adjusting margins, creating headers and footers, setting page breaks, changing orientation, creating portable documents and printing data and formulae. Implementing file-level security and protecting data within the worksheet Creating charts and graphics: Choosing a chart type, understanding data points and data series, editing and formatting chart elements, and creating Sparkline graphics. Analyzing data using pivot tables: Creating, formatting and modifying a pivot table, sorting, filtering and grouping items, creating calculated field and calculated item, creating pivot table charts, producing a report with pivot tables. Performing what-if analysis: Types of what-if analysis

Computer-Applications-in-Business

Microsoft Excel 2010 notes

NCERT MS Excel

https://www.youtube.com/watch?v=rwbho0CgEAE

Session 5

Creating a blank presentation using a design template, basing a new presentation on an existing one, creating and managing slides, using content place holders, creating graphs, tables, diagrams, organization charts, inserting clip art and images. Viewing and navigating a presentation: Organizing ideas in outline view, using slide sorter to rearrange a presentation, previewing presentation in slide show, understanding master views, using title master, slide master, handout master and notes master, working with headers and footers, using hyperlinks, advanced navigation with action settings, navigation shorthand with action buttons

Computer-Applications-in-Business

Working_With_PowerPoint

MS PowerPoint

http://youtube.com/watch?v=XF34-Wu6qWU

Session 6

Animation and multimedia: Using and applying animation schemes, custom animation, understanding sound file formats and video types, adding music, sound and video clips. Final presentation: Applying a transition to slides, controlling transition speed, using hidden slides, using custom shows, using an on-screen pen and adding and accessing notes during a presentation

Computer-Applications-in-Business

Working_With_PowerPoint

MS PowerPoint

http://youtube.com/watch?v=XF34-Wu6qWU

Session 7

Database Designs for Accounting and Business Applications: Reality- Expressing the Application; Creating Initial design in Entity Relationship(ER) Model; Transforming ER Model to Relational data model concepts; Implementing RDM design using an appropriate DBMS. SQL and Retrieval of Information: Basic Queries in SQL; Embedded Queries in SQL; Insert, Delete and Update statements in SQL DBMS Software: Environment; Tables; Forms; Queries; Reports; Modules;  Applying DBMS in the areas of Accounting, Inventory, HRM and its accounting, Managing the data records of Employees, Suppliers and Customers

DATABASE MANAGEMENT SYSTEMS

https://www.youtube.com/watch?v=FR4QIeZaPeM

Session 8

Flash Fill, Advance Number Formatting, Advance Conditional Formatting, Data Validation, Quick Analysis, Lookup Functions, Match & Index, V lookup, H lookup, SUMPRODUCT Function

Advance excel formula

https://www.youtube.com/watch?v=SXbTY0c9hs0

Session 9

Match & Index, V lookup, H lookup, SUMPRODUCT Function

Advance excel formula

https://www.youtube.com/watch?v=SXbTY0c9hs0

Session 10

Files in Google Drive, Form Creation, Sending and receiving a response

Guide-to-Google-Drive

https://www.youtube.com/watch?v=IDWVpHvG5Ok

Case Studies

Case Studies

Our Main Teachers

Ajitav Acharya is working as a faculty at at at Centurion University of Technology and Management, Bhubaneswar. He is having more than 10 years of experience in academics and industry. He is currently pursuing his Ph.D. at Utkal University. He has completed his MBA (Finance and Marketing) from Siksha ‘O’ Anusandhan University, MCom and Bcom […]