Computing Management for Business is a practical and application-oriented textbook designed to equip learners with essential computing skills required in today’s technology-driven business environment. It bridges the gap between business knowledge and digital tools, enabling students to efficiently manage modern organizational tasks.
The book covers key areas such as business graphic design using Canva, database management concepts, SQL applications, and data analytics using advanced Excel. It provides step-by-step guidance for creating professional business documents, managing and querying data, and analyzing information for better decision-making.
Written in a clear and learner-friendly style, the book emphasizes hands-on learning through practical examples and real-world applications. It helps readers develop the technical competence and confidence needed to apply computing tools effectively in business scenarios.
An ideal resource for students and beginners, this book supports academic learning while preparing learners for real-world business and professional challenges.
1. Introduction to Business Graphic Design Tool Canva
1.1 Logging / Setup Canva Account
1.2 Layouts & Templates
1.3 Get you setup with your Canva & Account
1.4 Tour of your dashboard
1.5 Learn about the different types of templates Canva has
1.6 Learn how to use the pre-designed layouts
1.7 Downloading your work
1.8 Working with text; Photo backgrounds & Shapes
1.9 Illustrations, icons and lines; Adding pages to a design
1.10 Image; Text features and Charts
2. Creating Business Related Documents with Canva
2.1 Designing CV
2.2 Business Posters
2.3 Business Cards
2.4 Calander
2.5 Labels
2.6 Presentations
3. Business Database Management with Structured Query Language (SQL)
3.1 Concept of DBMS, RDBMS and OORDBMS
3.2 Tables, relationships between tables and applying constraints
3.3 Create user command; Alter user command; Drop user command; Create table command; Alter table command; Drop table command
4. SQL and its Applications in Business
4.1 Insert, update, delete and select commands
4.2 Select command with where, having, order by and
4.3 Group by clause Design tables for sales order system
5. Data Analytics with Advance Excel - I
5.1 Creating Business Data Sheets
5.2 Importing data into Excel
5.3 Using formulas – math, stat and finance formulas
5.4 Searching data; Sorting data; Pivot Table
5.5 Use of IF – Else
6. Data Analytics with Advance Excel - II
6.1 Use of Hyperlinking of data sheets
6.2 Using VLOOKUP
6.3 Using Filters
6.4 Working on Text with functions
This textbook is aligned with the revised syllabus as outlined by the National Education Policy 2020 (NEP 2020) for the Commerce and Management Faculty at K.B.C. North Maharashtra University, Jalgaon, effective from June 2025.