Emerging Technologies and application

Paper Code: 
SBBA 201
Credits: 
2
Contact Hours: 
60.00
Max. Marks: 
100.00
Objective: 

The course aims to acquaint the students with the computers and office automations skills in various business operations in an organization.

Course Outcomes: 

Course

Learning outcomes

(at course level)

Learning and teaching strategies

Assessment

Strategies

Course Code

   Course   Title

25SBBA 201

Emerging Technologies and application

(Practical)

CO: Design files & folders using windows and create Google Sheets.

CO: Create business reports, event catalogues   using images, tables and other tool of MS- Word.

CO: Develop business analytical skills based on what if analysis tools and logical functions of spreadsheet.

CO: Create an effective business presentation using layout & Power Point animation tools.

CO: Create database table, query, report and analyse them for managerial decision.

CO:  Contribute effectively in course-specific interaction.

Approach in teaching: Interactive Sessions, Tutorials, Reading assignments

 

Learning activities for the students:

Self-learning assignments, Classroom Presentations, Project tasks

 

Continuous Assessment Test, Semester End Examinations, Quiz, Solving problems in tutorials, Assignments, Presentation, Individual and group projects, Project file and Viva-voce

 

 

 

12.00
Unit I: 
Exploring the Windows

Lab exercise on Exploring the windows: Windows App
Lab exercise on Managing files & folders: creating folder & files
Lab exercise on Compressing/ Zipping files (WinZip, Winrar)
Lab exercise on Google Drive/Google Sheets /Google Docs

12.00
Unit II: 
Introduction to Word Processing

Lab exercise Formatting documents: Paragraph formatting (alignment, line & paragraph spacing, borders & shading, bullets and numbering), orientation, page margins.
Lab exercise on Editing text: find & replace, proofing text (spell check & check grammar using thesaurus), Insert & format pictures, hyperlinks, headers and footers.
Lab exercise on Tables: Create, format, sort, table formula (Sum, Min, Max, Avg), converting text to table and vice versa.
Lab exercise on Create bookmarks/ cross referencing, adding sources and bibliography.
Lab exercise on Mail merge: Creating and editing the main document and data source. OLE (Object Linking and embedding).

Unit III: 
Introduction to Spreadsheet

Lab exercise on workbooks (saving, opening, moving, copy & paste special, inserting, deleting and renaming worksheets), controlling worksheet views,
Lab exercise on Filling series, sort, formatting worksheet, Shortcut keys, Protecting worksheets
Lab exercise on Tools & Functions: Inbuilt function (SUM, AVERAGE, COUNT, MAX, MIN), lookup, IF (logical), date and time.
Lab exercise on Charts in Excel: Creation of chart from adjacent data/ nonadjacent data, printing a worksheet / chart data series, editing / formatting chart.
Lab exercise on performing what-if analysis: Goal Seek, Solver, Filter, scenario manager, Consolidate.
Lab exercise on Analysis using pivot tables: Creating, formatting and modifying a pivot table and pivot table charts.

12.00
Unit IV: 
PowerPoint Presentation

Lab exercise on Creating presentation using design template, managing slides, inserting clip art/ images, shortcut keys.
Lab exercise on Creating graphs, tables, diagrams, organization charts.
Lab exercise on Viewing Presentation: outline view, slide sorter, slide & title master, handout/ notes master, headers and footers.
Lab exercise on Navigating presentation: hyperlinks, advanced navigation with action settings, action buttons.
Lab exercise on Animation: Applying animation, custom animation and adding sound, music and video clips.
Lab exercise on Final presentation: Applying transition to slides, controlling transition speed, using hidden slides, custom shows, screen pen

12.00
Unit V: 
Introduction to Databases Management

Lab exercise on Create Database: Creating Tables, table fields with Data types, Changing table design, Field Properties, Primary Keys and field validation and record validation rules.
Lab exercise on working with multiple tables, Relationships & Integrity check, Records Editing (modify, delete, add, Sorting & Filtering)
Lab exercise on queries: Creating Query by design & by wizard, creating multi table queries, creating & working with table joins. Using operators & expressions: Creating simple & advance criteria.
Lab exercise on forms: Create forms by design & by wizard from table and queries.
Lab exercise on Reports: Create Reports by design & by wizard, Creating Header & Footer, Placing Controls on reports.

Essential Readings: 

1. Henry C. Lucas, Information Technology for Management, McGraw Hill, International Edition.
2. Mastering Word – Mansfield & Olsen
3. Mastering Excel – Martin, Hansen, Klingher & Beth
4. Mastering Power Point – Murray

References: 

1. Peter Nortons : “Introduction to Computers” (Fourth Edition)
2. Mastering Access 2000 – Simpson Alan, Robinson, & Celeste.

E-Resources:

1. http://www.w3schools.com.
2. https://www.oecd-ilibrary.org/science-and-technology/books/i
3https://www.tutorialspoint.com/computer_concepts/computer_concepts_sprea...
4. https://sk.sagepub.com/books/primary-computing-and-digital-technologies-...

Academic Year: 
2025-2026
  • Printer-friendly version
  • PDF version