Managerial Computing – ExPGP 2007-10 (Week End) Term - II
We will start with the basic Computing Concepts – Basic Computer and Computing Systems, Operating Systems Concepts, and basic Networking Concepts.
Next, we will study some of the managerial problem solving and decision making exercises using EXCEL.
Next we will study some of the basic features of MS ACCESS as an example of using a database.
Course Contents:
Basic Computers and Computing Systems :
· Components of a Computer – Software, Hardware, Firmware
· Working/Operation of a Computer
· Basic Terminology – Program, Data, High Level Language, Object Code, Compiler
· Functional Units - CPU, Memory, I/O Units
· Classification of Computers – Palm PCs/PDA, Notebooks/Laptops, Desktops, Workstations, Servers, Mainframes and Super Computers
· Computing architecture
· Client server computing
Operating Systems Concepts:
· Introduction to OS Concepts
· Process Subsystem – Process Scheduling
Networking Concepts:
· Networking – fundamental concepts
· OSI Model
· TCP/IP
Excel:
· Basic Spreadsheet Concepts
· Managing and Editing Workbook and Files
· Advanced Worksheet Editing
· Entering Formulas
· Excel Functions
· Worksheet Formatting
· Creating Charts
· What-if Analysis using One-Input and Two-Input Data Tables
· Scenarios
· Managing Lists – Sorting, Filtering Lists, Database Functions
· Decision making, forecasting and other applications of Excel
· Intro to MS ACCESS
References:
· Dynamic Memory Computer Course, by B. Roy Chowdhury, Fusion Books
· Mastering EXCEL 2000, BPB
· Working with Excel, A Hands on Tutorial, TataMcGraw Hill
· Teach Yourself Excel for Windows, M &T Publishing Inc, USA, ISBN – 81-7029-6777-3
Evaluation:
· Quiz 20%
· Lab Test 20%
· End Term 35%
· Take Home Assgn 25% (Write-up on an assigned current topic)