tailieunhanh - 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 . | 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 .

• 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
• Business data communications
• Data communications
• Data link layer
• Network criteria
• Data communications system
• Hop to hop delivery
• Error control
• Physical layer
• Transforming data to signals
• Transmission modes
• Ebook Business data communications
• Application layer
• Data communications networks
• Media access control
• Application layer
• Electronic mail
• File transfer
• Internet model
• Transport layer
• Application to application delivery
• Network layer
• Host to host delivery
• Transmission media
• Unguided media
• Guided media
• Cable TV networks
• Telephnone system
• Internet access via telephone
• Local area networks
• Wired Ethernet LANs
• Traditional Ethernet technology
• Virtual LANs
• Wireless LANs
• Wide area networks
• Point to point WANs
• Switched WANs
• Connecting devices
• Backbone networks
• Making backbone networks
• Internet administration
• TCP IP protocol suite
• Private networks
• Network security
• Digital signature
• Security in the internet
• Network analysis
• Network development life cycle
• Analysis phase
• Network management
• Configuration management
• Network management tools
• Business research
• Business research methods
• Lecture Business research methods
• Analysis of data
• Data preparation
• Data description
• Describing data statistically
• Data analysis
• Examining data
• Exploratory data analysis
• Network models
• Network standards
• Application architectures
• Digital transmission