SPCA online Course-Smart Computing for office management

Smart Computing for office management

Smart computing saves our time & money

Course Duration: 4 (Four) Months

Course Description: 

Course Method: Online LMS based course with Moodle. Online classes with live streaming, lecture sheet & PPT, remote P2P assistance & online assessment system. 

Course fee & payment method: 

Prerequisites:  Students taking this course should have the following skills: End-user skills with Windows-based personal computers, including the ability to: Browse and search for information on the Internet. Start up and shut down the computer. Log on to a computer and computer network. Run programs. Move, copy, delete, and rename files in Windows Explorer. Basic knowledge of computing concepts, including The difference between hardware and software. The functions of software components, such as the operating system, applications, and file systems


  • Broadband Internet Connection 
  • PC with TeamViewer, Oracle VM Virtual Box 
  • Android smartphone with Moodle, Kahoot, Skype, YouTube, Facebook messenger apps 
  • Google, Skype, Facebook account 

Course Details

  • PC Fundamentals
    • PC structure
    • PC Hardware
    • PC Software
  • Typing
    • Advanced typing techniques
    • Voice Commands
    • Voice to text typing (English & Bangla)
    • Online spelling & grammar checking
    • Typing ads in
    • Using a smartphone as a Keyboard/mouse
  • MS Word
    • Menu & ribbon customization 
    • Working with Multiple Paged Documents 
    • Creation & uses of Macros 
    • Use of paste special, format painter 
    • Use of Microsoft Translator, dictation 
    • Design, develop & use of form 
    • Mail merge 
    • Hyperlink, video embodying, linking with others file 
    • Equation writing  
    • Handwriting  
    • Voice to text writing 
    • Themes and Templates management 
    • Creating Reports and Newsletters 
    • References 
    • Document inspection & review 
    • Document protections 
    • Digital signature & certificate management 
    • Document share & export 
    • Plugins/Add-ins management 
    • Online file processing 
    • Teamwork 
    • MS office custom installation 
  • MS Excel
    • Cell formatting 
    • Various Functions 
    • Conditional Formatting 
    • Data shorting & filtering, Validation, Drop-Down Lists 
    • AutoFill a Series, AutoFill Non-Adjacent Cells, AutoFill on Multiple Sheets, Creating Custom Lists, Series Formatting 
    • Adding, Deleting and Hiding Worksheets 
    • Grouping Worksheets, Moving, Copying, Deleting and Hiding Grouped Worksheets 
    • Personal & official budget, Invoice, Cash memo, Bill creation 
    • Graph & charts 
    • Formula creation & management, Logical formula development by if function 
    • Intersheet reference 
    • Data Import 
    • Data share, export & publishing 
    • Data & Sheet Protection 
    • Use of templates & ad-ins 
    • Custom Printing-Print Area selection, Column heading printing for every page, Print Tiles, Multipage printing, etc. 
    • Macros 
  • MS PowerPoint
    • Creating a presentation
    • Using Presentation Tools: Optimization and Compression
    • Designing a presentation
    • Designing the slides
    • Setting up Slide Masters
      • Creating a Slide Master
      • Using Placeholders
      • Using Slide Masters
      • Using Hand-out Masters
      • Using Notes Masters
    • Designing the template
    • Animation
    • Animations and Multimedia, Pictures & Charts
    • Adding Tables Charts and Diagrams
    • Hyperlinks
    • Macros
    • Video editing
    • Video embedding
    • Reviewing Presentations
      • Using Comments
      • Reviewing a Presentation
    • Keyboard Shortcuts
    • Creating Advanced Types of Shows
      • Setting up Your Show
      • Presenting Your Show
      • Creating a Custom Show
      • Advanced Presentation Techniques
    • New features of PowerPoint 2019
    • Security
      • Using Password
      • Adding a Digital Signature
    • Sharing Presentation
      • Share with people
      • E-mail
      • Online Presentation
      • Store on cloud
    • Exporting presentations
      • Changing the file type
      • Creating PDF/XPS docs
      • Packaging presentation for CD
      • Creating handouts
    • Add-ins
      • Getting Add-ins
      • Managing Google drive adds on
      • Managing MIX adds on
  • MS Visio
    • Introducing Microsoft Visio
    • Working with Shapes and Stencils
    • Controlling Shapes
    • Working with Text
    • Linking Objects
    • Flowcharts and Process Diagrams
    • Finishing your Diagram
    • Organization Charts
  • Communication
    • E-mail management
      • E-mail ethics
      • Using E-mail Templates
      • E-mail linking & forwarding
      • Email signature/Canned Responses (Templates)
      • E-mail auto responses
      • E-mail filtering
      • E-mail Client Management
      • Offline email management
      • E-mail security certificate management
      • Digital signature
      • Add-ons
      • E-mail newsletter
    • Live Chat
    • Video conference
    • Webcasting
    • Webinars
  •  Social media ethics & management
    • Social media uses policies & ethics
    • Importance to use social media ethics
    • Social media password policies
    • Application of multistage verification methods, OTP, etc.
    • Post management
  • Information & cybersecurity basics
    • User management & protection of information
      • User management basics
      • Creation & management of User & Group
      • Uses of system password, BIOS password, user password
      • Password policies
      • user rights by group policy
      • Deployment of individual-level folder & drives security.
      • Disk quota management.
    • Cybersecurity management.
      • The role of cybersecurity in our information
      • Use a hashing program in the lab to verify the integrity of data.
      • Explanation of various type cyber-attacks.
      • The determination of whether the computer has been cyber attacked
      • Design a comprehensive security plan
      • Uses of proper tools to prevent cyber-attacks.
      • Installation, configuration & management of antivirus & windows firewall.
  • Basics digital signature & certificate management
    • Implementation process digital signature & certificate
    • Email management with digital signature & certificate
  • Cloud computing & storage
    • Online file processing
    • Team operation
    • Basics of cloud storage
    • Data store, backup & synchronization with cloud storage
    • Google drive (file uploading/downloading, sync info, privacy, link publishing by website or Facebook, online editing, etc.)
    • One Drive & Dropbox
  • System tuning
    • Windows Update
    • Drivers update
    • Programs update
    • System performance monitoring
    • System settings for best performance
    • Uses of windows system tuning tools
    • Uses of third-party system tuning tools
    • Remote supports

About the Instructor 

Md. Sohel Parvez 

A faculty member at Jashore Polytechnic Institute, DTE, TMED, MoE Bangladesh 

A Microsoft Certified Systems Engineer specializing in software and IT management for mid-sized and large clients. I have extensive experience overseeing the development, implementation, and management of information technology systems that improve accessibility and resolve networking issues. This experience has helped me develop a range of relevant skills, including in-depth knowledge of Windows server architecture, confident project leadership, and familiarity with a range of technological applications. 

3 thoughts on “SPCA online Course-Smart Computing for office management

  • June 7, 2019 at 5:14 pm

    I have seen that fees for online degree gurus tend to be an excellent value. For instance a full College Degree in Communication in the University of Phoenix Online consists of Sixty credits from $515/credit or $30,900. Also American Intercontinental University Online offers a Bachelors of Business Administration with a complete school requirement of 180 units and a cost of $30,560. Online studying has made having your education far more easy because you can certainly earn the degree in the comfort of your dwelling place and when you finish from work. Thanks for all tips I’ve learned from your website.

  • June 7, 2019 at 5:29 pm

    Another issue is that video games are generally serious in nature with the most important focus on mastering rather than entertainment. Although, we have an entertainment part to keep your young ones engaged, just about every game is usually designed to work with a specific skill set or curriculum, such as numbers or scientific discipline. Thanks for your posting.

  • June 30, 2019 at 1:24 am

    This is very fascinating, You are an excessively professional blogger. I have joined your rss feed and look forward to in quest of more of your excellent post. Additionally, I’ve shared your site in my social networks!


Leave a Reply

Your email address will not be published. Required fields are marked *