Course Syllabus
SYLLABUS
ROLE OF A ADAT ENTRY OPERATOR
- Role of a Data Entry Operator
- What is data entry?
- Skills required to become a data entry operator
- What mindset is required to become a good data entry operator?
- How to acquire the basic skills to become a good data entry operator?
- Tips to improve upon basic data entry skills
- Online and free applications that help data entry operators to practice typing
JOBS AND FREELANCE OPPORTUNITIES
- Various job opportunities available for data entry professionals
- Expected salary range for data entry professionals
- Finding freelancing data entry jobs on Fiverr and Upwork
- How can freshers look up freelancing
- What are the common tools ?
KEYBOARD AND TYPING TECHNIQUES
- Various Keyboard Layout and Typing speed
- Typing Techniques
- Right postures and Keyboard introduction
- Introduction to Keyboard
- Use of Home Row, Top Row and Bottom Row
- Top Row
- Bottom Row
- Shift key
- Caps lock key
- Numeric keys
- Special Character Keys
- Use TAB key
- Finger motions
- Tips for increasing Typing Speed
- Introduction
- Google Doc Voice Typing
- Outcome
FONTS
- Font
- Kruti Dev/Devlys to Unicode
- Shree Lipi to Unicode
- ISM font introduction and installation
- Calligraphic fonts
- Applying Font Settings
DATA ENTRY TOOLS
- Data Entry Tools
- FormTools
- Winautomation
- Different data entry methods, Zoho Forms & Survey Monkey
- Objective
- Define Zoho Forms
- What Are Some Of The Features Of Zoho Forms?
- How can Zoho Forms help in data entry?
- How to create a free account and form on Zoho Forms website?
- What is Survey Monkey?
- What are some of the features of Survey Monkey and how does it help in data entry?
- How can you create a free account and survey on the Survey Monkey Website?
- Summary
- Outcome
- Kamisha Soft
- MoreApp Forms
- ElectroNeek Studio IDE
- Teamscope
- Grammarly
- About Grammarly Tool
- Using Grammarly Tool
- Summary
- Outcome
- Komprehand
- Mathtype
- Chemdraw
TYPE OF FORMS
- Excel Forms
- Google Forms
- Customizing google form
- Filling google form
KEY DATA ENTRY SKILLS
- Key data entry skills
- What is image assisted data entry
- Scanning Image (De-pixelation)
- Resizing images
- Data Validation in Excel
- Compression of documents
- Applying page size settings and print settings
- Merging and splitting documents Intro
- Merge Documents
- Split Documents
- Report Creation
- Reporting and presentation of data
- Adding Digital Signature
- Manage and Share Workbooks-Connect to external data
- Formatting Email
- Proofreading your document
- Proofreading your document with auto-correct
- Password Protection
- Encrypted PDFs
DOCUMENTS CONVERSIONS
- Intro
- Doc to PDF
- PDF to Google Doc
- PDF to Excel
- Excel to PDF
- Excel to CSV
- PDF to ePUB
- PDF to JPG and PNG
- PDF to RTF
- PDF to Word using OCR
- PDF to Word using online tool
DATA ENTRY TASK ( BASIC, INTERMEDIATE & ADVANCED LEVEL)
- Data Entry Tasks
- Quickly convert hard copy to soft copy
- Changing the layout of data from columns to rows quickly
- Adding forms to the Quick Access Toolbar
- Entering numbers, dates, days or months serially into cells
- Entering text to specify quantity before or after a numeric value
- Using the summation formula to calculate the total amount in a spreadsheet
- Changing the format of the date entered into selected cells
- Calculating the balance amount and displaying negative numbers properly
- Deleting blank or redundant cells from the middle of the spreadsheet
- Entering same data into various cells of the spreadsheet
- Deleting duplicate data from the spreadsheet
- Data Validation: Introducing a dropdown list for entering a fixed or limited range of data into the cells
- Using the data validation feature to quickly introduce more than two kinds of data into the dropdown list for cells
- See the fixed list of values for a column cell
- Conditional Formatting
- Sort & Filter
- File conversion from PDF to word
SOFT SKILLS IN DATA ENTRY
- Efficient written and verbal communication skills
- Self-motivation
- Accuracy and attention to detail
- Time Management
- Multi-tasking
INTRODUCTION TO DATA MANAGEMENT
- What is Data Management and how it differs from Data Entry?
- Typical Data Management Jobs in the market
- Basic Introduction to Data Management
- Define Data
- Where do we use data?
- What is data management?
- How does data management help businesses to achieve their goals?
- What are the various steps involved in data management?
- What skills do data management professionals require?
- What is data entry?
- What are the skills required to become a data entry operator?
- What are some tips to improve upon basic data entry skills?
- What are some online and free applications that help data entry operators to practice typing?
- What are the various job opportunities available for data entry professionals?
- What is the expected salary range for data entry professionals?
- How can one find freelancing data entry jobs on Fiverr and Upwork?
- How do professionals organize their data?
- What is a database?
- What mediums do professionals use for storing data?
- How do professionals organize and store official data?
- What are some good practices for organizing and storing data?
- Meta Data and Big Data
- What is Metadata?
- What are the types of metadata?
- What is Big Data?
- Define Data Analytics
- What course of study can you persue to become an expert in Data Analytics?
DIFFERENT STAGES OF DATA MANAGEMENT
- Data Collection Techniques
- Data Cleaning Techniques: Downloading, Saving, and Cleaning data
- Data Cleaning Techniques: Freezing and Cleaning data
MICROSOFT OFFICE SKILLS
- Microsoft Excel
- Entering Text, Numbers and Dates
- Creating Text, Number and Date Series
- Inserting and Deleting Rows, Column
- Changing Cell Height and Width
- Editing Worksheet Data
- Sort and Filter - Advanced filter
- Adding comments
- Worksheet Protection
- Fill options and other functions in Excel
- Solver Add-In
- Excel Shortcuts
- Microsoft Word
- Cut, Copy, and Paste the text
- Text Formatting
- Paragraph Alignment, Spacing, and Formatting Marks
- Bullets and Numbering
- Increase and decrease Indent
- Text and Paragraph Shading
- Text sorting, Paragraph indenting, and spacing
- Macros
- Inserting Table
- Designing Table
- Aligning Table
- Table of Contents
- Mail Merge
- Add multiple footers in word
- Microsoft PowerPoint
- Introduction to PowerPoint presentation
- PowerPoint Slides
- Creating Presentation
- PowerPoint Transitions
- PowerPoint Animations
- Setup SlideShow
- Start Slide Show
DATA ANALYSIS
- Data Analysis
- Google Data Studio - An Introduction
- Data Sources
- Data Blending
- Data Blending inside
- Google Data Studio-Creating Reports and Chart Types
- Report canvas interface
- Creating chart types- Table, Pivot table
- Bar Chart
- Line Chart
- Time series chart
- Scorecard Pie Maps charts
- Google Data Studio - Action controls for Reports and Managing Reports
- Community visualization
- Embed URL in reports
- Creating Groups
- Page and report level
- Creating multi page report with navigation
- Using parameters to get user input
- Copying chart formatting
- Managing data segments
- Regular expressions
- Google Data Studio -Sharing Reports, Collaborating on Reports and Tips to create an effective report
FREE AND OPEN SOURCE TOOLS FOR DATA MANAGEMENT - GOOGLE WORKPLACE
- Google Docs
- Creating a Spreadsheet
- Outcome
- Google Slides
- Creating a Google Slide File
- Inserting Images
- Slide Transitions
- Google Slides Other Options
- Outcome
- Google Keep
- Google Keep: Creating a Note
- New Note with Drawing
- New Note with Image
- Google Keep View and Settings
- Outcome
- Canva Introduction
- Objective
- Introduction
- What is Canva?
- What are the features of Canva?
- How can you create free account in Canva?
- How can you use Canva to make a checklist for data collection?
- Summary
- Outcome
INTRODUCTION TO SMALL BUSINESS MANAGEMENT
- How to create a project in ProofHub?
- How to use Canva for Branding?
- How to create digital notes using Evernote?
- How to book tickets on MakeMyTrip?
- How to maintain the digital record in Khatabook?
- How to automate the note-taking process using Otter?
- How to schedule emails using Boomerang?
- How to create a to-do list and note reminders using Sticky Notes?
- How to download copyright-free images?
- How to manage projects using Trello?
- How to communicate with people using Slack?
- How to create a private YouTube channel?
- How to manage tasks using Asana?
- How to convert files using Format Factory?
- How to search files quickly using Search Everything?
- How to communicate with colleagues using LAN Messenger?
- How to share your free time slots with colleagues using Doodle?
- How to use templates to create documents using Smart Business Box?
- How to share files with your clients using Dropbox?
- How to digitally store visiting cards using Card Scanner?
- How to calculate scientific expressions using the Scientific Calculator?
- How to assign tasks and processes using Smartsheet?
- How to track user statistics of social media handles using Social Blade?
- How to create a communication site using Microsoft SharePoint?
- How to scan printed documents using Microsoft Lens?
- How to create a to-do list using Todoist?
- How to save passwords using LastPass?
- How to share heavy files using Wormhole?
- How to start accepting payments using Razorpay?
- How to manage and analyze your social media handles using Buffer?