TAILIEUCHUNG - Lecture Computing for management - Chapter 8

Lecture 8 - Managing business data. After studying this chapter you will be able to understand: Business data, how to manage business data, Microsoft Excel, purpose elements, components, formula bar, toolbar, workbook and work sheets. | Managing Business Data Lecture 8 Summary of Previous Lecture File Systems Purpose and Limitations Database systems Definition, advantages over file systems Different DBMS software Oracle, Microsoft SQL Server etc. Database Systems in Work NADRA, COMSIS, Payroll System etc. Summary of Previous How database Systems are Developed? 1) Feasibility study 2) System analysis 3) System design 4) Coding 5) Testing and Implementation 6) Maintenance Today’s Lecture Business Data How to manage business data Microsoft Excel Purpose Elements Components Formula Bar Toolbar Workbook and Work Sheets Today’s Lecture Columns Rows Cells Tab and Entry Keys Entering Data Auto Fill Auto Complete Summary Business Data Businesses are growing day by day. Electronic record keeping is essential for meeting the needs. Different tools are being used in business to store and retrieve data. Business Data Two important software systems to save business data are, Microsoft Excel Microsoft Access. These software are mostly used to handle different types of data. Microsoft Excel 2007 What is MS Excel? A complete file system. Electronic spreadsheet program that can be used for storing, organizing and manipulating data. Purpose of Using Excel Creating budgets Working with taxes Recording student grades Do Scientific modeling Excel Element Definitions Active cell: An active is the cell you are currently working on (selected). Auto sum: A formula that will add up a column of numbers. Cell Reference: The column number and the row letter of a cell. Cell: Each individual box on the spreadsheet. Column: The vertical reference on the spreadsheet. Fill: To fill a cell with color using the paint bucket tool Excel Element Definitions (2) Fill handle: The dot at the bottom right of each cell while it is active. Filter: The procedure to select certain information in a spreadsheet. Formula: A formula must always starts with “=” signs and what the calculations for each cell. Formula Bar: Where data and formulas .

• Tin học văn phòng
• Computing for management
• Tin học quản lý
• Lecture Computing for management
• Computer science
• Managing business data
• Business data
• Lecture Introduction to computing
• Bài giảng Nhập môn máy tính
• Introduction to computing
• Data management
• Data intensive computing
• Simple relational database
• Information system job
• Information system management framework
• Computer systems
• Computers for individual use
• Notebook computers
• Input devices
• Inputting data
• Game controllers
• Video cards
• Data projectors
• Number systems
• Database systems
• Text codes
• Binary arithmetic
• Boolean algebra
• Network topology
• Computer networks
• Data communications
• The world wide web
• Applications of internet
• Web servers
• Static website
• Dynamic websites
• Front page
• Writing HTML
• Electronic commerce
• E commerce infrastructure
• Advertisement in electronic commerce
• Information systems
• Information technology
• Working across
• Information systems planning
• Planning techniques
• Security in information technology
• Intellectual property
• Open source code
• Trade secrets
• Computer programming
• Problem solving process
• C programming
• C programming language
• If statement
• Else statement