ASANSOL INSTITUTE OF ENGINEERING AND MANAGEMENT - POLYTECHNIC
LEADING TOWARDS A BRIGHT FUTURE
APPROVED BY AICTE || AFFILIATED TO WBSCT & VE & SD

(+91)8001500263

Mon-Fri: 10am to 5pm & Sat:10am to 2pm


ESTD-2015
EIET
AIEM-P


Computer Science and Technology Engineering

Introduction to IT System Laboratory


  1. Browser features, browsing, using various search engines, writing search queries .
  2. Visit various e-governance/Digital India portals, understand their features, services offered
  3. COMPUTER FUNDAMENDALS- Computer and operating system-fundamentals of computer-components of computer system-Input and Output Devices-Memory handling-Storage devices
  4. Read Wikipedia pages on computer hardware components, look at those components in lab, identify them, recognize various ports/interfaces and related cables, etc.
  5.  Install Linux and Windows operating system on identified lab machines, explore various options, do it multiple times
  6.  Connect various peripherals (printer, scanner, etc.) to computer, explore various features of peripheral and their device driver software.
  7. Practice HTML commands with CSS try them with various values, make your basic own Webpage
  8. MS Excel
    • Apply Custom Formats and Layouts

      A Learner is able to apply skills in Advanced Excel, is able to –

      • Format Cells
      • Apply Custom Values and predefined Formats
      • Apply Borders
      • Design Borders
      • Custom Formatting

    • Create advanced formulas

      A Learner is able to Use Simple and Advanced Formulas like –

      • Nested if
      • Reference formulas like –
        lookup, vlookup, hlookup,
        count formula with conditions
      • Index, Match
      • Conditional Loops, etc

    • Use Scenarios

      A Learner is able to seek use Goal Seek function, alter scenarios and values in a cell to reach a goal.

    • Create Advanced Charts

      A Learner can tell where to use what type of charts, and obtain graphical Charts in various scenarios 3DGraphs, Bar Charts, Pie Chart, Histograms, Line Graph, Sparklines, trend, etc.

    • Pivot tables & charts

      A Learner is able to Apply

      • Pivot Tables
      • Design Pivot Table
      • Customize Values

    • Manage and Share Workbooks

      A Learner is able to Share Workbook Online, email, save on cloud, edit it Online in Google Sheets, Add Collaborators etc.

  9. MS PowerPoint
    • Create a Power Point presentation using slide template.
    • Create a Power Point presentation using animation.
    • Create a Power Point presentation using transition
    • Create a Power Point Presentation with Adding movie and sound.
    •  Create a Power Point Presentation with Adding tables and chart etc.
    • Changing slide colour scheme in presentation.
    • Viewing the presentation using slide navigator.
    • Create, Save, Run and Print the Power Point Presentation.
  10. Google Utilities
    • Create and share files/folders in Google drive
    • Create and share Google docs.
    • Create and share Google sheets.
    • Create and share Google Forms.
    • Create and share Google slides.
 back
ADMISSION OPEN FOR WORKING PROFESSIONAL IN THE DEPARTMENT OF MINING ENGINEERING, ELECTRICAL ENGINEERING AND COMPUTER SCIENCE & TECHNOLOGY. Contact no:- 8001500263

Contact Us

Location:

Bagbandi Road, Near Radhyaswami Satsang, Kalipahari More
City: Asansol
District : Paschim Bardhaman
State : West Bengal
Pin Code: 713339

Fax:

0341-6610 310

Email:

infoaiem2015@gmail.com

Call:

(+91) 8001500263 (For Admissions)

Landline No.: 0341 6610 300/305

Loading
Your message has been sent. Thank you!