Computer Applications in Business
Teacher
Ajitav Acharya
Category
Core Courses
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:
- Alexis Leon and Mathews Leon: Fundamentals of information technology, Leon Techworld Pub.
- Sinha, Computer Fundamentals,
- BPB Pub Malhotra, Computer Applications in Business
- 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.
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
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.
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
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
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
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
Session 8
Flash Fill, Advance Number Formatting, Advance Conditional Formatting, Data Validation, Quick Analysis, Lookup Functions, Match & Index, V lookup, H lookup, SUMPRODUCT Function
Session 9
Match & Index, V lookup, H lookup, SUMPRODUCT Function
Session 10
Files in Google Drive, Form Creation, Sending and receiving a response
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 […]