Computer Fundamentals
Understand computer hardware, software, operating systems, files, folders and everyday computer usage.
VDS SHINE ACADEMY
Master Computer Skills in Mohali Build Your Future.
Build strong computer fundamentals, office productivity, internet skills, Excel expertise, digital tools and professional workplace skills through a structured 12-month practical learning program.
12
Months
48
Weeks
100%
Practical Focus
✓
Beginner friendly • Theory + Practical • Regular assessments
YOUR LEARNING PLAN
Computer Skills
LIVE
1 Year Professional Program
12 Months
Computer Basics
Strong foundation
01
MS Word
Professional documents
03
MS Excel
Formulas & data
05
PowerPoint
Presentations
07
✓
Practical Learning
12
Months of Growth
01 — COURSE OVERVIEW
Build Your Computer Skills Step by Step
This one-year course is designed to take students from basic computer knowledge to confident professional computer usage through structured theory, practical assignments and regular testing.
Typing & Internet
Improve typing speed and learn browsing, email, online communication and safe internet practices.
Microsoft Word
Create professional documents, letters, reports, resumes, tables and formatted business documents.
Microsoft Excel
Learn formulas, functions, formatting, calculations, data management, charts and practical spreadsheets.
PowerPoint
Create professional presentations, slides, layouts, animations and presentation-ready projects.
Digital Skills
Develop practical digital workplace skills including online tools, communication and productivity workflows.
02 — WHO SHOULD JOIN
Designed For Practical Learners
School & College Students
Build a strong foundation for academic and future professional computer requirements.
Job Seekers
Develop practical computer skills required for office and entry-level professional roles.
Beginners
Start from the fundamentals even if you have very little previous computer experience.
Working Professionals
Improve office productivity, Excel and document management skills.
03 — COURSE AT A GLANCE
One Year. Complete Computer Training.
12
Months
Complete structured program
48
Weeks
Weekly theory + practical
36
Quizzes
Weekly Saturday assessments
8
Monthly Tests
Progress evaluation
3
Quarterly Exams
Major academic evaluation
1
Final Exam
Complete course assessment
MONDAY – FRIDAY
Regular Learning
Theory + practical exercises + assignments
SATURDAY
Assessment Day
Quiz, monthly test or examination
04 — 12 MONTH ROADMAP
Your Complete Learning Journey in Mohali
Every month builds on the previous month so students gradually move from basic computer knowledge to practical professional skills.
01
Month 1
Computer Fundamentals
02
Month 2
Typing & Internet
03
Month 3
MS Word
04
Month 4
Advanced Word
05
Month 5
Excel Fundamentals
06
Month 6
Advanced Excel
07
Month 7
PowerPoint
08
Month 8
Digital Skills
09
Month 9
Office Productivity
10
Month 10
Advanced Digital Tools
11
Month 11
Projects & Practice
12
Month 12
Revision & Final Exam
MONTH 01
Computer Fundamentals
Build a strong foundation in computer operations, hardware, software and Windows.
Introduction to Computers
- What is a computer?
- History and generations
- Types of computers
- Computer applications
- Input and output devices
Computer Hardware
- CPU and motherboard
- RAM and storage
- Hard disk and SSD
- Keyboard and mouse
- Printers and scanners
Operating System
- Windows interface
- Desktop and taskbar
- Start menu
- Settings
- Basic troubleshooting
Files & Folders
- Create folders
- Rename and delete
- Copy and move files
- File extensions
- Storage management
Saturday Assessment — Month 1
MONTH 02
Typing, Internet & Email
Develop typing confidence and learn everyday internet and email communication.
Keyboard & Typing
- Keyboard layout
- Home row keys
- Typing practice
- Special characters
- Typing accuracy
Internet Basics
- Internet and web
- Browsers
- Search engines
- Search techniques
- Downloading information
Email Communication
- Create email account
- Compose email
- Attachments
- CC and BCC
- Email etiquette
Online Safety
- Strong passwords
- Phishing awareness
- Safe browsing
- Privacy settings
- Online scams awareness
Saturday Assessment — Month 2
MONTH 03
Microsoft Word Fundamentals
Learn to create, format and manage professional documents using Microsoft Word.
Word Interface
- Create documents
- Save and open files
- Ribbon and toolbar
- Page setup
- Basic formatting
Text Formatting
- Fonts
- Paragraph formatting
- Alignment
- Line spacing
- Bullets and numbering
Tables & Documents
- Create tables
- Merge cells
- Page borders
- Headers and footers
- Page numbers
Practical Project
- Resume creation
- Business letter
- Application writing
- Report formatting
- Document printing
Quarterly Exam 1 — Months 1 to 3
MONTH 04
Advanced Microsoft Word
Move beyond basic documents and create professional reports and formatted business files.
Advanced Formatting
- Styles
- Themes
- Columns
- Page breaks
- Section breaks
Images & Shapes
- Insert images
- Text wrapping
- Shapes
- SmartArt
- WordArt
Professional Documents
- CV and resume
- Business reports
- Certificates
- Official letters
- Templates
Document Project
- Complete report
- Formatting project
- Print settings
- PDF export
- Final practical task
Saturday Assessment — Month 4
MONTH 05
Microsoft Excel Fundamentals
Learn spreadsheet creation, formatting, calculations and essential Excel formulas.
Excel Basics
- Workbook and worksheet
- Rows and columns
- Cells and ranges
- Data entry
- Basic formatting
Basic Calculations
- Addition
- Subtraction
- Multiplication
- Division
- Percentage calculations
Excel Functions
- SUM
- AVERAGE
- MIN
- MAX
- COUNT
Practical Sheets
- Student marksheet
- Salary sheet
- Expense sheet
- Attendance sheet
- Simple invoice
Saturday Assessment — Month 5
MONTH 06
Advanced Excel
Develop practical spreadsheet skills using advanced formulas, functions, sorting, filtering and charts.
Logical Functions
- IF
- AND
- OR
- Nested IF
- IFERROR
Data Functions
- COUNTIF
- SUMIF
- AVERAGEIF
- COUNTIFS
- SUMIFS
Data Management
- Sort data
- Filter data
- Conditional formatting
- Data validation
- Remove duplicates
Charts & Dashboard Basics
- Column charts
- Pie charts
- Line charts
- Chart formatting
- Mini dashboard
Quarterly Exam 2 — Months 4 to 6
MONTH 07
Microsoft PowerPoint
Learn how to create attractive and professional presentations.
Presentation Basics
- Create presentations
- Slides and layouts
- Themes
- Text formatting
- Speaker notes
Visual Design
- Images
- Shapes
- Icons
- SmartArt
- Slide design
Animations & Transitions
- Slide transitions
- Object animations
- Animation timing
- Presentation flow
- Professional effects
Presentation Project
- Business presentation
- Educational presentation
- Image-based slides
- Presentation practice
- Final presentation
Saturday Assessment — Month 7
MONTH 08
Digital Skills & Online Tools
Learn practical digital tools used in modern education, communication and workplaces.
Cloud & Online Storage
- Cloud computing basics
- Online storage
- File sharing
- Google Drive
- Document sharing
Online Communication
- Video meetings
- Online collaboration
- Digital communication
- Professional messaging
- Online etiquette
Digital Productivity
- Online forms
- Digital documents
- Calendar management
- Task management
- Online workflows
Digital Safety
- Password management
- Two-factor authentication
- Privacy
- Secure downloads
- Cyber awareness
Saturday Assessment — Month 8
MONTH 09
Office Productivity
Combine Word, Excel, PowerPoint and digital skills into practical office workflows.
Office Documents
- Professional letters
- Reports
- Office templates
- Document organization
- PDF management
Excel Office Work
- Attendance reports
- Salary calculations
- Sales sheets
- Expense reports
- Data organization
Presentation Work
- Business presentation
- Company profile
- Training slides
- Visual presentation
- Presentation delivery
Office Simulation
- Real-world assignments
- File organization
- Document creation
- Spreadsheet task
- Presentation task
Quarterly Exam 3 — Months 7 to 9
MONTH 10
Advanced Digital Tools
Strengthen workplace productivity with modern digital tools and practical computer workflows.
Online Research
- Advanced searching
- Information verification
- Online resources
- Research organization
- Digital notes
Digital Documents
- PDF creation
- PDF conversion
- File compression
- Document sharing
- Digital signatures
Professional Communication
- Email writing
- Professional attachments
- Meeting communication
- Online etiquette
- Workplace communication
Productivity Practice
- Time management
- File management
- Task organization
- Digital workflow
- Productivity project
Saturday Assessment — Month 10
MONTH 11
Projects & Practical Training
Apply everything learned throughout the course to realistic practical assignments.
Professional Resume
Create and format a professional resume using Microsoft Word.
Excel Business Sheet
Build a practical Excel workbook with formulas, formatting and calculations.
PowerPoint Presentation
Design a complete professional presentation using text, images and visual elements.
Complete Office Project
Combine Word, Excel, PowerPoint and digital tools into one complete office assignment.
Saturday Assessment — Month 11
MONTH 12
Revision, Final Project & Exam
The final month focuses on revision, practical assignments and complete course evaluation.
Computer Revision
- Computer fundamentals
- Windows
- Files and folders
- Internet
Office Revision
- Microsoft Word
- Microsoft Excel
- Microsoft PowerPoint
- Office workflows
- Digital tools
Final Practical
- Word assignment
- Excel assignment
- PowerPoint assignment
- Digital task
- Complete project
Final Evaluation
- Revision tests
- Practical assessment
- Theory assessment
- Final examination
- Course completion
FINAL EXAM
Complete 1-Year Course Assessment
05 — EXCEL FORMULAS
Essential Excel Functions
Students practice essential formulas used in common office and business spreadsheet tasks.
=SUM()
SUM
Add numbers
=AVERAGE()
AVERAGE
Calculate average
=MIN()
MIN
Find minimum value
=MAX()
MAX
Find maximum value
=COUNT()
COUNT
Count numeric cells
=COUNTA()
COUNTA
Count non-empty cells
=IF()
IF
Logical condition
=AND()
AND
Multiple conditions
=OR()
OR
Alternative conditions
=SUMIF()
SUMIF
Conditional sum
=COUNTIF()
COUNTIF
Conditional count
=AVERAGEIF()
AVERAGEIF
Conditional average
=SUMIFS()
SUMIFS
Multiple-condition sum
=COUNTIFS()
COUNTIFS
Multiple-condition count
=IFERROR()
IFERROR
Error handling
=ROUND()
ROUND
Round numbers
06 — TEST & ASSESSMENT
Learn. Practice. Test.
Regular assessments help students track their progress throughout the entire one-year program.
36
Weekly Quizzes
Short Saturday quizzes to reinforce weekly learning.
8
Monthly Tests
Monthly assessments covering the month's syllabus.
3
Quarterly Exams
Major examinations after each three-month learning phase.
1
Final Exam
Complete evaluation of the one-year course.
07 — WEEKLY CALENDAR
A Simple Learning Routine
MONDAY
Theory + Practical
TUESDAY
Theory + Practical
WEDNESDAY
Practice + Assignment
THURSDAY
Practical Training
FRIDAY
Revision + Doubts
SATURDAY
Quiz / Test / Exam
SUNDAY
Rest / Self Practice
08 — GRADING SYSTEM
Measure Your Progress
Attendance & Participation
10%
Weekly Quizzes
15%
Monthly Tests
20%
Quarterly Exams
25%
Final Practical & Exam
30%
09 — COURSE OUTCOME
By The End Of One Year
✓
Confidently operate a computer and Windows.
✓
Create professional Word documents.
✓
Use Excel formulas and spreadsheets.
✓
Create professional PowerPoint presentations.
✓
Use email and internet professionally.
✓
Manage files and digital documents.
✓
Complete practical office assignments.
✓
Build a stronger foundation for office jobs.
VDS SHINE ACADEMY
Ready To Build Your Computer Skills?
Join the Advanced Basic Computer Course and spend one complete year developing practical, workplace-ready computer skills.
✓ 12-Month Program
✓ Practical Training
✓ Regular Assessments
START YOUR JOURNEY
Learn today.
Work confidently tomorrow. Computer fundamentals • Office tools • Digital skills
Work confidently tomorrow. Computer fundamentals • Office tools • Digital skills