Scribd Logo
Upload

Welcome to Scribd!

  • 7 views

    Excel Lab Lesson - Plan - BATCH 1

    Uploaded by

    thende

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Excel Lab Lesson - Plan - BATCH 1

    Uploaded by

    thende
    7 views3 pages

    Original Title

    Excel Lab Lesson_plan_BATCH 1

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    7 views3 pages

    Excel Lab Lesson - Plan - BATCH 1

    Uploaded by

    thende

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    MAHARAJA INSTITUTE OF TECHNOLOGY THANDAVAPURA

    DEPARTMENT OF ARTIFICIAL INTELLIGENCE AND DATA SCIENCE


    LESSON PLAN
    Academic Year: 2024- 2025

    Course: Data Analytics with Excel Lab Course code: BCS358A


    Faculty: Prof. Girish Kumar B C Semester: III
    Core/Elective: Core Total Hours Credits: 01
    Contact Hours L T P CIE Marks: 50
    24
    /week: 0 0 2 SEE Marks: 50
    Course outcomes
    At the end of course, the student will be able to:
    CO1 ● To Apply analysis techniques to datasets in Excel
    CO2 ● Learn how to use Pivot Tables and Pivot Charts to streamline your workflow in Excel
    CO3 ● Understand and identify the principles of data analysis
    CO4 ● Become adept at using Excel functions and techniques for analysis
    CO5 ● Build presentation ready dashboards in Excel

    Duratio Method of Proposed Date of Deviations if


    Sl. No Topics Planned n (Hr.) Teaching date of Actual any
    coverage coverage
    LAB PROGRAMS
    MAHARAJA INSTITUTE OF TECHNOLOGY THANDAVAPURA
    DEPARTMENT OF ARTIFICIAL INTELLIGENCE AND DATA SCIENCE
    LESSON PLAN
    Academic Year: 2024- 2025
    Getting Started with Excel:
    Execution and
    Creation of spread sheets, Insertion
    1 Explanation on 19/08/2024
    of rows and columns, Drag & Fill, 3
    Eclipse IDE
    use of Aggregate functions.

    2 Working with Data : Importing Execution and


    2 data, Data Entry & Manipulation, 3 Explanation on 26/08/2024
    Sorting & Filtering. Eclipse IDE

    Working with Data: Data Execution and


    3
    3 Validation, Pivot Tables & Pivot Explanation on 02/09/2024
    Charts. Eclipse IDE
    Data Analysis Process: Conditional Execution and
    4 Formatting, What-If Analysis, Data Explanation on 09/09/2024
    3
    Tables, Charts & Graphs. Eclipse IDE

    5 Cleaning Data with Text Functions: Execution and


    use of UPPER and LOWER, TRIM Explanation on 16/09/2024
    3
    function, Concatenate Eclipse IDE

    Cleaning Data Containing Date and


    Execution and
    Time Values: use of DATEVALUE
    6. 3 Explanation on 23/09/2024
    function, DATEADD and DATEDIF,
    Eclipse IDE
    TIMEVALUE functions.
    Conditional Formatting:
    Execution and
    formatting, parsing, and
    7 3 Explanation on 30/09/2024
    highlighting data in spreadsheets
    Eclipse IDE
    during data analysis.
    Working with Multiple Sheets:
    work with multiple sheets within a
    Execution and
    workbook is crucial for organizing
    8 3 Explanation on 07/10/2024
    and managing data, perform
    Eclipse IDE
    complex calculations and create
    comprehensive reports
    Create worksheet on Inventory
    Management: Sheet should contain
    Product code, Product name,
    Product type, MRP, Cost after % of Execution and
    9 discount, Date of purchase. Use 3 Explanation on 14/10/2024
    appropriate formulas to calculate Eclipse IDE
    the above scenario. Analyze the
    data using appropriate chart and
    report the data.
    Develop a JAVA program to create
    Execution and
    a package named mypack and
    10 3 Explanation on 21/10/2024
    import & implement it in a suitable
    Eclipse IDE
    class.
    11 Create worksheet on Sales analysis 3 Execution and 28/10/2024
    of Merchandise Store: data Explanation on
    consisting of Order ID, Customer Eclipse IDE
    ID, Gender, age, date of order,
    month, online platform, Category of
    product, size, quantity, amount,
    shipping city and other details. Use
    of formula to segregate different
    categories and perform a
    MAHARAJA INSTITUTE OF TECHNOLOGY THANDAVAPURA
    DEPARTMENT OF ARTIFICIAL INTELLIGENCE AND DATA SCIENCE
    LESSON PLAN
    Academic Year: 2024- 2025
    comparative study using pivot
    tables and different sort of charts.
    Generation of report & Execution and
    12 presentation using Auto filter 3 Explanation on 04/11/2024
    &macro. Eclipse IDE
    13 Practice lab 3 11/11/2024
    14 Test 1 3 18/11/2024
    15 Practice Lab 25/12/2024
    16 Test 2 02/12/2024
    17 Practice Lab 09/12/2024

    Course outcomes (Course Skill Set):


    At the end of the course the student will be able to:

    ● Use advanced functions and productivity tools to assist in developing worksheets.


    ● Manipulate data lists using Outline and PivotTables.
    ● Use Consolidation to summarize and report results from multiple worksheets.
    ● Apply Macros and Auto filter to solve the given real-world scenario.

    Signature of Staff In-Charge HOD

    You might also like