ࡱ>  &bjbj B~~########8 $$# %%%%%&&&|#&&&&&##%%4ͦe,e,e,&j#%#%e,&e,e,LR%;;#7'vڜZ04='b=RR=#f<e,&&&*V&&&&&&&=&&&&&&&&&~ ": Computer Data Analysis Instructor: Greg ShawPRIVATE  CGS 2518 Microsoft Excel - Tutorial 5, Session 5.1 Working with Excel Tables, PivotTables, and PivotCharts Skills Checklist and Notes A common use of spreadsheets is to manage data, such as lists of customers, employees, inventory, products, orders, students, CDs in a collection, etc. Such lists are commonly called databases, so this is about using Excel as a database management system a program that creates and maintains databases, and using an Excel table as the database. Terms and Concepts table (aka: worksheet database, list, database table, structured range of data)an organized collection of datafield namescolumn titles that identify the fields in a database - The categories of data, such as First Name, Last Name, Addressfieldone item of information in a database - One persons first name, last name, address, etcrecorda bunch of related fields (i.e., about the same subject) - E.g. the first name, last name, address, of one student - Each record is a row in the database Example: A student database would have one record for each student, and each record would have fields that store First Name, Last Name, Address, City, State, ZIP, etc, etc, etc Regarding Column Titles (aka: Field Names) The Column Titles must be the first row of the database The first record of data must be in the row immediately below the Column Titles Apply a different format to the Column Titles (e.g., bold) Use meaningful (descriptive) Column Titles Database Activities Adding and deleting records Modifying a record (changing the data in one or more fields) Sorting the records so that they display in a specified order Querying the database (retrieving only those records that match certain criteria) Determining totals for numeric fields Analyzing data using database functions Freezing Rows and Columns When working with a large spreadsheet, we can keep the row and column headings from scrolling off the screen by freezing the rows/columns containing the headings View | Window | Freeze Panes Choose Freeze Top Row, Freeze Left Column, or Freeze Panes If Freeze Panes is chosen, all columns to the left of the selected cell and all rows above it will be placed in separate panes and frozen. All cells in the other pane (i.e., to the right and below the active cell) can still be scrolled Creating an Excel Table From a Normal Range of Data (i.e. a plain old spreadsheet) Freeze the top row of the range Click any cell in the range Insert | Tables | Table In the Create Table dialog, the range of cells is displayed. If it is not correct, click the button to the right and select the correct range Make sure the My list has headers box is checked (because the first row should always be the header row) and click OK Make sure you leave at least one blank row and one blank column between the table and any other items on the spreadsheet. Otherwise, Excel will think those other items are part of the table! Note: The table will be automatically formatted in a predefined style Filter arrows will appear in each cell of the header row (to be used to filter (query) and sort the data) The Table Tools Design tab is added to the ribbon Renaming an Excel Table In the Properties group of the Table Tools Design tab, select the current name (e.g. Table1) in the Table Name box and type a new name Table names should start with a letter and may contain only letters, numbers and underscores (_). No spaces! Adding New Records to a Table Move to the blank row below the last record and type (Adding records in the middle of a table is the same as inserting new rows in a spreadsheet, but this is not really necessary as you can sort the table after adding records at the bottom) ( Finding and Editing Records (and Replacing Text) The Find command is used to locate one or more occurrences of a particular word or phrase in a table (or spreadsheet) Press [Ctrl]+[Home] to make A1 the active cell Home | Editing | Find & Select | Find... Enter a word or phrase to search for Click the Find Next button (Excel will locate and select the next occurrence of the word or phrase) Edit or replace the current selection or click Find Next to locate the next occurrence Click Close when done The Replace command not only finds the text, but gives you the option of replacing it with different text Press [Ctrl]+[Home] to make A1 the active cell Home | Editing | Find & Select | Replace... Enter a word or phrase to search for Enter a word or phrase to replace it with Click the Find Next button (Excel will locate and select the next occurrence of the word or phrase) Click the Replace button to replace it or the Find Next button to keep it and find the next occurrence Click Close when done There is also a Replace All button, but you need to be very careful when you use it To investigate some of the Find... and Replace... options, click the [Options >>] button Deleting a Record from a Table Select any field in the record Home | Cells and click the Delete button Another way is to right-click the row heading and choose Delete from the popup menu (just like deleting a row from a spreadsheet) Sorting a Table on a Single Field Sorting means arranging the records of a table sequentially based on the contents of one or more fields To sort based on the values in a single field Select any field value in that column Data | Sort & Filter and click the Sort A to Z or Sort Z to A buttons (Another way is to click the Filter arrow for the field and choose a sort option) Sorting on Multiple Fields Since different records may have identical values in some fields (e.g., a State or Last Name field), sorting on a single field may produce ties To break ties we can sort on multiple fields (up to 64!), also known as levels E.g. we could sort by State, and within State by Last Name, and within Last Name by First Name In this example, State would be the primary sort field, Last Name would be the secondary sort field and First Name would be the tertiary sort field To sort on multiple fields Data | Sort & Filter | Sort Choose the primary sort field (column) from the Sort by list If necessary, choose Values from the Sort On list Choose a sort order (ascending or descending) from the Order list For each additional sort field, click the Add Level button and repeat steps 2 thru 4 Click OK Sorting Using a Custom List If a field contains text, it will be sorted based on alphabetical order If this is not appropriate, we may specify a different order using a custom list E.g. suppose a Condition field contains Excellent, Good, Fair, or Poor. The default descending sort order would be Excellent Fair Good Poor (alphabetical), but we would rather see Excellent Good - Fair Poor (by condition) To sort on an existing custom list or create a new one: Data | Sort & Filter | Sort Choose the sort field from the Sort by list If necessary, choose Values from the Sort On list From the Order list, choose Custom List... Choose one of the existing custom lists or NEW LIST to create a new one If NEW LIST was chosen, enter the list values in the List entries box pressing [Enter] after each one and then click OK (or Add to create another new list) To edit a custom list you have previously created: Data | Sort & Filter | Sort Choose the sort field from the Sort by list If necessary, choose Values from the Sort On list From the Order list, choose Custom List... Choose the list from the Custom lists box In the List entries box, add new entries, delete entries, or edit existing entries for the list Note that Excel has 4 predefined custom lists Sun, Mon, ..., Sat Sunday, Monday, ..., Saturday Jan, Feb, ..., Dec January, February, ..., December   23;<EFGHRWZbcdnoqrsd ɿwlhd]NhCJOJQJ\^JaJ hheIhheIh<"uhDCJaJh<"uh CJaJh<"uh|CJaJh<"uhUCJaJhD h6] hz6] h|6] h)^6] hD6]h&EhD6]hD@OJQJ^Jh%$@OJQJ^J"jh%$@OJQJU^Jh%$@OJQJ^J=FGHrsd e ( ) < = $*$a$gdjg$ & F 0*$^`a$gds$ 0h*$a$gdgdgdeIgdDgdD $*$a$gdD $*$a$gd%$d e   ' ( ) - / ; < = ޻o^oG6 hBhjgCJOJQJ^JaJ,hjghjg56CJOJQJ\]^JaJ heI5CJOJQJ\^JaJ&hjghjg5CJOJQJ\^JaJ h5CJOJQJ\^JaJ#hh*aCJOJQJ\^JaJ)hPhP56CJOJQJ\^JaJhPCJOJQJ\^JaJ&hh6CJOJQJ\^JaJhCJOJQJ\^JaJ#hhCJOJQJ\^JaJ= C D E F K _ t u ̾zhzhVE3#hp/Dhjg5CJOJQJ^JaJ hp/DhCJOJQJ^JaJ#hp/Dh6CJOJQJ^JaJ#heIh6CJOJQJ^JaJ#heIhP6CJOJQJ^JaJheI6CJOJQJ^JaJ#heIheI6CJOJQJ^JaJ hp/DhjgCJOJQJ^JaJheICJOJQJ^JaJ#heIheI5CJOJQJ^JaJheI5CJOJQJ^JaJ#heIheI5CJOJQJ^JaJ= D E =kd$$Iflg0 $N   t0#644 l` a pyteI $*$Ifgdp/D $*$IfgdeI $$*$Ifa$gdeI 8 9 0kd$$Ifl0 $N   t0#644 l` a pyteIV$*$If^V`gdeI T$*$Ifgdp/D $$*$Ifa$gdp/D   # % . 0 7 9 ? e f i v   - ˺wfwUDU hp/DhCJOJQJ^JaJ hp/DhCJOJQJ^JaJ hp/DhsCJOJQJ^JaJ#hp/Dhjg5CJOJQJ^JaJ#heIheI6CJOJQJ^JaJheICJOJQJ^JaJ hp/DhjgCJOJQJ^JaJ hp/DhjgCJOJQJ^JaJ#hp/Dhs6CJOJQJ^JaJ#hp/Dhjg6CJOJQJ^JaJ hp/DhsCJOJQJ^JaJ9 ? e f 5kd$$Ifl0 $N   t0#644 l` a pyteIV$*$If^V`gdeI $*$Ifgdp/D $$*$Ifa$gdp/D   A B Ckd$$IflE0 $N   t0#644 l` a pyteI^$*$If^`^gdp/D $*$Ifgdp/D- 0 B C O V " ' 4 ˽zhVD6hsCJOJQJ^JaJ#hkhk6CJOJQJ^JaJ#hkhk5CJOJQJ^JaJ#hB hk5CJOJQJ^JaJ)hThk5CJOJQJ\]^JaJhkCJOJQJ^JaJhCJOJQJ^JaJ#h iEhjg6CJOJQJ^JaJhjgCJOJQJ^JaJ h*_hjgCJOJQJ^JaJ hp/DhjgCJOJQJ^JaJ#hp/Dhjg6CJOJQJ^JaJB C " # [ nn$ 0*$^a$gdV4$ & F *$^`a$gdT h*$^hgdk$ & F 0*$^`a$gdT$ 0*$^a$gdB $ *$^`a$gdjg$ T*$^`a$gdjg )*+bcl|}ƵtfRA0 h*ahPCJOJQJ^JaJ hP5CJOJQJ\^JaJ&h*ahP5CJOJQJ\^JaJh 8%CJOJQJ^JaJ h*_hdzCJOJQJ^JaJ hThdzCJOJQJ^JaJ hpyhdzCJOJQJ^JaJhdzCJOJQJ^JaJ h9.hdzCJOJQJ^JaJ,hdzhdz56CJOJQJ\]^JaJ)hdzhdz5CJOJQJ\]^JaJhB CJOJQJ^JaJ*+G:bc}~y$ & `0h$ @ P*$a$gdP & F & `08$ @ P*$gdP$ 0*$a$gdP$ & F *$^`a$gdT*$gddz$ & F 0*$^`a$gds } #@AHIO{ijkpu{gVE4 hU5CJOJQJ\^JaJ h|Q5CJOJQJ\^JaJ h 8%hPCJOJQJ^JaJ&hhP5CJOJQJ\^JaJ hP5CJOJQJ\^JaJ&h:rhP5CJOJQJ\^JaJ#hc9hP5CJOJQJ^JaJhPCJOJQJ^JaJ#hPhP5CJOJQJ^JaJh 8%CJOJQJ^JaJ#h 8%hP6CJOJQJ^JaJhPCJOJQJ^JaJ~"#@A|ii?*$ & F ( `0h8$ @ P80*$^8`0a$gdP'$ ) `0h$ @ P*$^`a$gd 8%*$ & F ) `0h$ @ P*$^`a$gd 8%!$ & `0h$ @ P*$^a$gdP!$ & `0h$ @ Ph*$^ha$gdPijka)$ & F* & `08$ @ P*$^`a$gd`/C$ & F 0*$^`a$gd 8% 0*$gd|Q$ & F 0*$^`a$gdB $ 0*$^a$gdV4$ & `0h$ @ P*$a$gdP u$)QS޽nZnK9#h 8%h|QCJOJQJ\^JaJhCJOJQJ\^JaJ&hh|Q5CJOJQJ\^JaJ h 8%5CJOJQJ\^JaJh 8%CJOJQJ\^JaJh|QCJOJQJ\^JaJhTCJOJQJ\^JaJ h|Q5CJOJQJ\^JaJh|Qh-5OJQJ\^J h|Q5CJOJQJ\^JaJ hw5CJOJQJ\^JaJ h 8%5CJOJQJ\^JaJ&/ȶȓpapR@.#hc9hCJOJQJ\^JaJ#hc9hTCJOJQJ\^JaJh]sCJOJQJ\^JaJhDCJOJQJ\^JaJ#hc9hc9CJOJQJ\^JaJ h 8%5CJOJQJ\^JaJ&h 8%h5CJOJQJ\^JaJh 8%CJOJQJ\^JaJ#h 8%h 8%CJOJQJ\^JaJ#h 8%hCJOJQJ\^JaJ#h 8%h|QCJOJQJ\^JaJ&h 8%h|Q5CJOJQJ\^JaJ"yRR'$ ) `0h8$ @ Ph*$^h`a$gd-&$ & F ( `0h8$ @ P8*$^8a$gds%$ & F & `0h8$ @ P*$`a$gds$ 0*$^`a$gdT%$ & `08$ @ PL*$^`La$gd]s!"#)*2>Y\]lrs}ŲنpŲ]L hT5CJOJQJ\^JaJ$h {`5@CJOJQJ\^JaJ*hThT5@CJOJQJ\^JaJ*hTh6@CJOJQJ\^JaJ*hh5@CJOJQJ\^JaJ$hT5@CJOJQJ\^JaJ'hh@CJOJQJ\^JaJ!hT@CJOJQJ\^JaJ*hhrhT5@CJOJQJ\^JaJd'sdXJ 0h*$^hgd:X1 0*$gd:X1 & F 0*$gd:X1&$ & F) ) `0h8$ @ P0*$`0a$gdB #$ ) `0h8$ @ Ph*$^ha$gdBv'$ ) `0h8$ @ Ph*$^h`a$gd-$ & F 0*$^`a$gdT28AKcd¬¬–¬…t^tJ9!h:X1@CJOJQJ\^JaJ'hBvhB @CJOJQJ\^JaJ*hB hB 6@CJOJQJ\^JaJ!hB @CJOJQJ\^JaJ!hT@CJOJQJ\^JaJ*hBvhBv6@CJOJQJ\^JaJ*hBvhBv5@CJOJQJ\^JaJ'hBvhBv@CJOJQJ\^JaJ$hT5@CJOJQJ\^JaJ,hhrhT56CJOJQJ\]^JaJ'(#zͿsfsfYM=MhHDh:X15CJOJQJaJh:X1CJOJQJaJhi5@CJOJQJh:X15@CJOJQJh<h:X15@CJOJQJh:X15@OJQJ jqh:X15CJ OJQJ#h:X1h:X16CJOJQJ^JaJ h:X1h:X1CJOJQJ^JaJh:X1CJOJQJ^JaJ hA;h:X1CJOJQJ^JaJh:X15CJOJQJ^JaJ#hA;h:X15CJOJQJ^JaJ'(s~$ 8Th^ha$gd:X1$ & F T^`a$gd $ 8Ta$gd:X1$ & F T^a$gdi 8Tgd:X1 0h*$gd:X1$ 0h*$^ha$gdR 0*$gd:X1z"raP>#h h:X15@CJOJQJaJ h h:X1@CJOJQJaJ h h @CJOJQJaJh @CJOJQJaJh:X1@CJOJQJaJhi@CJOJQJaJ#hihi5@CJOJQJaJ#hih15@CJOJQJaJh1@CJOJQJaJh:X1@CJOJQJaJh:X1CJOJQJaJhiCJOJQJaJh1CJOJQJaJ"#)*+cqrs˽ܽ{lZK<h-h:X1CJOJQJaJh-hiCJOJQJaJ#hihi5@CJOJQJaJhihiCJOJQJaJ hihi@CJOJQJaJ#hHDhi5@CJOJQJaJhi@CJOJQJaJ h h:X1@CJOJQJaJh @CJOJQJaJ h h @CJOJQJaJ h hi@CJOJQJaJ#h hi5@CJOJQJaJJKLR`{ XYZd´tcR@RcRtRt#h hi5@CJOJQJaJ h hi@CJOJQJaJ h h @CJOJQJaJh @CJOJQJaJ hihi@CJOJQJaJhi5@CJOJQJaJ#hihi5@CJOJQJaJhi@CJOJQJaJ hihi@CJOJQJaJ hih:X1@CJOJQJaJhHDh:X15CJOJQJaJh:X1CJOJQJaJKL{Z-{{ 0*$gd:X1$ & F p880^8`0a$gdB $ & F p0^`0a$gd $ 8Ta$gd:X1$ & F T^`a$gd $ 8Ta$gdi$ & F 8Ta$gd:X1dk,-0H߾tdtXtI:Xh h:X1CJOJQJaJhJxh:X1CJOJQJaJh CJOJQJaJh h:X15CJOJQJaJh:X1CJOJQJaJh-h:X1CJOJQJaJh-hiCJOJQJaJ#hihi5@CJOJQJaJhi@CJOJQJaJhihiCJOJQJaJ#hHDh 5@CJOJQJaJh @CJOJQJaJ#h h 5@CJOJQJaJHLOT[^r~ǹxgYG8h}5CJOJQJ^JaJ#hzhb5CJOJQJ^JaJhbCJOJQJ^JaJ hbh:X1CJOJQJ^JaJhbE5CJOJQJ^JaJ#hbh 5CJOJQJ^JaJ#hbh:X15CJOJQJ^JaJhB CJOJQJ^JaJh:X1CJOJQJ^JaJh h:X1CJOJQJaJh CJOJQJaJh 5CJOJQJaJh h 5CJOJQJaJvwxn_$ 0h*$a$gdhr$ & F 0*$^`a$gds'$ ) `0h8$ @ Ph*$^h`a$gd-$ 0h*$^h`a$gd:M 0*$gd} & F 00*$`0gdz 0h*$^hgd:X1 & F 0*$gd:X1 -3TuvwxmYH7 hz5CJOJQJ\^JaJ hw5CJOJQJ\^JaJ&hhrhhr5CJOJQJ\^JaJ'hBvhb@CJOJQJ\^JaJ hbEhbECJOJQJ^JaJh {`CJOJQJ^JaJ#hbEhbE5CJOJQJ^JaJhbECJOJQJ^JaJ hbEh}CJOJQJ^JaJh}5CJOJQJ^JaJ#hzhb5CJOJQJ^JaJh}CJOJQJ^JaJ #123YmnsǸqq_K<hVQCJOJQJ\^JaJ&h}h}5CJOJQJ\^JaJ#hVQh}CJOJQJ\^JaJ#h}hhrCJOJQJ\^JaJ#hhrhhrCJOJQJ\^JaJh}CJOJQJ\^JaJ&h}h}6CJOJQJ\^JaJhhrCJOJQJ\^JaJ,hhrhhr56CJOJQJ\]^JaJ hH5CJOJQJ\^JaJ h}5CJOJQJ\^JaJ23Yl$ & F 0*$^`a$gds$ 0h0*$^`0a$gdVQ$ 0h*$a$gd}$ & F 0*$^`a$gdVQ$ 0hh*$^ha$gdVQ$ 0hh*$^ha$gdhr$ & F 0h*$a$gdVQ s|\aenʻubN= hA6CJOJQJ\^JaJ&h"Jxhhr6CJOJQJ\^JaJ$hf*hhr56OJQJ\]^J&hFhhr5CJOJQJ\^JaJhhrCJOJQJ\^JaJhFCJOJQJ\^JaJ&hVQhVQ5CJOJQJ\^JaJhVQCJOJQJ\^JaJ#hVQh}CJOJQJ\^JaJ&h}h}5CJOJQJ\^JaJh}CJOJQJ\^JaJVW  $ a *!$ & F 0h*$^`a$gds$ 0h*$^a$gd'E$ & F 0h0*$^`0a$gdVQ$ 0h*$^`a$gdhr$ & F @ 0h*$^a$gds $(1>GHKPUVWhm{޻ާޓޓނނn\H&hVQhVQ6CJOJQJ\^JaJ#hVQhhrCJOJQJ\^JaJ&h?,Ihhr6CJOJQJ\^JaJ hhr6CJOJQJ\^JaJ&hChhr6CJOJQJ\^JaJ&h.hhr6CJOJQJ\^JaJhVQCJOJQJ\^JaJ&h"Jxhhr6CJOJQJ\^JaJhhrCJOJQJ\^JaJ#h.hhrCJOJQJ\^JaJ{   췥p\M9&hOhO5CJOJQJ\^JaJhhrCJOJQJ\^JaJ&h?,Ihhr5CJOJQJ\^JaJ hhr5CJOJQJ\^JaJ#h.hhrCJOJQJ\^JaJ#hVQhhrCJOJQJ\^JaJ#h'Eh'ECJOJQJ\^JaJ#hVQhVQCJOJQJ\^JaJ&hVQhVQ6CJOJQJ\^JaJhVQCJOJQJ\^JaJ&hVQhVQ5CJOJQJ\^JaJ   # $ B T Z [ v | !*!0!2!3!4!˺𫚆t`N@h|OCJOJQJ^JaJ#hbEhA;CJOJQJ\^JaJ&hbEhs*t5CJOJQJ\^JaJ#hbEhs*tCJOJQJ\^JaJ&hs*ths*t5CJOJQJ\^JaJ hs*t5CJOJQJ\^JaJhs*tCJOJQJ\^JaJ hhr5CJOJQJ\^JaJ hO5CJOJQJ\^JaJ&h?,Ihhr5CJOJQJ\^JaJhOCJOJQJ\^JaJ*!3!P!Q!!!!!""##+#W##$ & F! 80*$^`a$gdv $ 0*$a$gdv$ & F# 0*$a$gdv $ 0*$a$gdA$ & F 0*$^`a$gdv$ & F 0h*$^`a$gdhr4!hA5CJOJQJ^JaJ#hV_ChA6CJOJQJ^JaJ h hACJOJQJ^JaJ#hAhA6CJOJQJ^JaJhACJOJQJ^JaJ$hAhA56OJQJ\]^J hV_C5CJOJQJ\^JaJ hA5CJOJQJ\^JaJ&hFhA5CJOJQJ\^JaJ""""""""""#####ο஝~m\H9hV_CCJOJQJ\^JaJ&h?,IhV_C5CJOJQJ\^JaJ hV_C5CJOJQJ\^JaJ hvhvCJOJQJ^JaJhvCJOJQJ^JaJ h hACJOJQJ^JaJ hAhACJOJQJ^JaJ hvhACJOJQJ^JaJh 6CJOJQJ^JaJ#h hV_C6CJOJQJ^JaJ#h hA6CJOJQJ^JaJhACJOJQJ^JaJ####+#J#P#Q#l#r#|###################ɸݸݤݸݤݐ~o~o]o]I]&hvhv5CJOJQJ\^JaJ#hvhvCJOJQJ\^JaJhvCJOJQJ\^JaJ#hvhV_CCJOJQJ\^JaJ&hV_ChV_C5CJOJQJ\^JaJ&hs*thV_C5CJOJQJ\^JaJ hV_C5CJOJQJ\^JaJ&h?,IhV_C5CJOJQJ\^JaJhV_CCJOJQJ\^JaJ&hOhV_C5CJOJQJ\^JaJ###$$$$$%M%x%%&l$ & F( 80*$^`a$gdV_C$ & F( 80*$^`a$gdb'>$ & F( 80*$a$gdb'> $ 0*$a$gd $ & F# 0*$a$gd $ 0*$^a$gd $ & F! 80*$^`a$gdv ##$1$=$M$T$u$w$|$$$$$$$$$$$$$$$$$𻭛yeVBVey&hOhb'>5CJOJQJ\^JaJhb'>CJOJQJ\^JaJ&h?,Ihb'>5CJOJQJ\^JaJ hb'>5CJOJQJ\^JaJ h h CJOJQJ^JaJ#hb'>h 6CJOJQJ^JaJh CJOJQJ^JaJ#hvhvCJOJQJ\^JaJh CJOJQJ\^JaJ&hvhv5CJOJQJ\^JaJhvCJOJQJ\^JaJ$%%%0%6%@%F%G%V%[%i%t%w%%%%%%%%&&/&0&1&𑣑nZF&h hvCJOJQJ\]^JaJ&h hACJOJQJ\]^JaJ&h hvCJOJQJ\]^JaJh CJOJQJ\^JaJ#hb'>hb'>CJOJQJ\^JaJ&hb'>hb'>5CJOJQJ\^JaJ&hV_Chb'>5CJOJQJ\^JaJ&hs*thb'>5CJOJQJ\^JaJ hb'>5CJOJQJ\^JaJhb'>CJOJQJ\^JaJ&0&1&D&b&u&&&&&&&&&&&&&&d$ & F& 0*$a$gd $ 0`*$^`a$gdV_C$ & F$ 0880*$^8`0a$gd 1&4&:&>&?&C&D&J&S&W&X&e&k&o&p&|&&&&&&&&&&쿻hqhjhqhU&h hvCJOJQJ\]^JaJ hb'>CJOJQJ\]^JaJ&h h CJOJQJ\]^JaJ@....()()))()()00P8$:p*aBP/ =!"#$% Dp$$If !vh5N 5#vN #v:V lg  t0#6,5N 5` a pyteI$$If !vh5N 5#vN #v:V l  t0#6,5N 5` a pyteI$$If !vh5N 5#vN #v:V l  t0#6,5N 5` a pyteI$$If !vh5N 5#vN #v:V lE  t0#6,5N 5` a pyteI^A 2 0@P`p2( 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p 0@P`p8XV~_HmH nH sH tH L`L =LNormal$CJOJQJ^J_HaJmH sH tH ^@^  Heading 1$$*$@&a$ 56CJ OJQJ\]^JaJ V@V  Heading 2$$*$@&a$56OJQJ\]^JDA D Default Paragraph FontRi@R  Table Normal4 l4a (k (No List 4+4  Endnote Text>*> Endnote ReferenceH*66  Footnote Text@&!@ Footnote ReferenceH*,1, Document 8@A@ Document 456CJ\]aJ,Q, Document 6,a, Document 5LqL Document 2 CJOJQJ^JaJmH sH tH,, Document 7.. Bibliogrphyp/p Right Par 1 0*$^$CJOJQJ^J_HaJmH sH tH r/r Right Par 2 0*$^$CJOJQJ^J_HaJmH sH tH LL Document 3 CJOJQJ^JaJmH sH tHv/v Right Par 3! 0pp*$^p$CJOJQJ^J_HaJmH sH tH x/x Right Par 4$ 0p@ @ *$^@ $CJOJQJ^J_HaJmH sH tH |/| Right Par 5' 0p@ *$^$CJOJQJ^J_HaJmH sH tH ~/~ Right Par 6* 0p@ *$^$CJOJQJ^J_HaJmH sH tH / Right Par 7-!  0p@ *$^$CJOJQJ^J_HaJmH sH tH /" Right Par 80" 0p@ *$^$CJOJQJ^J_HaJmH sH tH J1J Tech Init CJOJQJ^JaJmH sH tHf/Bf Document 1$$$ 0*$$CJOJQJ^J_HaJmH sH tH p/Rp Technical 5% 0*$`*5CJOJQJ\^J_HaJmH sH tH p/bp Technical 6& 0*$`*5CJOJQJ\^J_HaJmH sH tH NqN Technical 2 CJOJQJ^JaJmH sH tHNN Technical 3 CJOJQJ^JaJmH sH tHh/h Technical 4 ) 0*$*5CJOJQJ\^J_HaJmH sH tH NN Technical 1 CJOJQJ^JaJmH sH tHp/p Technical 7+ 0*$`*5CJOJQJ\^J_HaJmH sH tH p/p Technical 8, 0*$`*5CJOJQJ\^J_HaJmH sH tH (( Doc Init.. Bullet ListNN TOC 1)/ $ 0*$]^`0JJ TOC 2%0 $ 0*$]^`0JJ TOC 3%1 $ p0*$]^p`0JJ TOC 4%2 $ @ 0*$]^@ `0JJ TOC 5%3 $ 0*$]^`0BB TOC 64 $0*$^`0:: TOC 750*$^`0BB TOC 86 $0*$^`0BB TOC 97 $ 0*$^`0N N Index 1%8 $ `*$]^``N N Index 2%9 $ 0*$]^`0>.>  TOA Heading : $*$*"* Caption;:/: _Equation CaptionrCr Body Text Indent = 00*$^`0@CJOJQJ^JaJhRh Body Text Indent 2> 00*$^`0 OJQJ^J`S` Body Text Indent 3? 0X*$^X OJQJ^Jjj jg Table Grid7:V@0@PK![Content_Types].xmlj0Eжr(΢Iw},-j4 wP-t#bΙ{UTU^hd}㨫)*1P' ^W0)T9<l#$yi};~@(Hu* Dנz/0ǰ $ X3aZ,D0j~3߶b~i>3\`?/[G\!-Rk.sԻ..a濭?PK!֧6 _rels/.relsj0 }Q%v/C/}(h"O = C?hv=Ʌ%[xp{۵_Pѣ<1H0ORBdJE4b$q_6LR7`0̞O,En7Lib/SeеPK!kytheme/theme/themeManager.xml M @}w7c(EbˮCAǠҟ7՛K Y, e.|,H,lxɴIsQ}#Ր ֵ+!,^$j=GW)E+& 8PK!Ptheme/theme/theme1.xmlYOo6w toc'vuر-MniP@I}úama[إ4:lЯGRX^6؊>$ !)O^rC$y@/yH*񄴽)޵߻UDb`}"qۋJחX^)I`nEp)liV[]1M<OP6r=zgbIguSebORD۫qu gZo~ٺlAplxpT0+[}`jzAV2Fi@qv֬5\|ʜ̭NleXdsjcs7f W+Ն7`g ȘJj|h(KD- dXiJ؇(x$( :;˹! I_TS 1?E??ZBΪmU/?~xY'y5g&΋/ɋ>GMGeD3Vq%'#q$8K)fw9:ĵ x}rxwr:\TZaG*y8IjbRc|XŻǿI u3KGnD1NIBs RuK>V.EL+M2#'fi ~V vl{u8zH *:(W☕ ~JTe\O*tHGHY}KNP*ݾ˦TѼ9/#A7qZ$*c?qUnwN%Oi4 =3ڗP 1Pm \\9Mؓ2aD];Yt\[x]}Wr|]g- eW )6-rCSj id DЇAΜIqbJ#x꺃 6k#ASh&ʌt(Q%p%m&]caSl=X\P1Mh9MVdDAaVB[݈fJíP|8 քAV^f Hn- "d>znNJ ة>b&2vKyϼD:,AGm\nziÙ.uχYC6OMf3or$5NHT[XF64T,ќM0E)`#5XY`פ;%1U٥m;R>QD DcpU'&LE/pm%]8firS4d 7y\`JnίI R3U~7+׸#m qBiDi*L69mY&iHE=(K&N!V.KeLDĕ{D vEꦚdeNƟe(MN9ߜR6&3(a/DUz<{ˊYȳV)9Z[4^n5!J?Q3eBoCM m<.vpIYfZY_p[=al-Y}Nc͙ŋ4vfavl'SA8|*u{-ߟ0%M07%<ҍPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 +_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!Ptheme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]   d = - }uz"dHs{ 4!"##$1&&!$%')*,-.0134689:<=>@AC= 9 B ~i'*!#&& "#&(+/257;?B@  @ 0(  B S  ?H0(  &,x3Fss))-/==BFKK]t7iv""bb  c v**334:>?DDJSWXekop|Fss))-/==BFKK]t7iv""bb  c v**334:>?DDJSWXekop|*W:'AګfbJ@m=$(>Oz :rJ!˘rrw{(jKf7!ֈZ_vw"ª> d((@z*ѸKRd3(e3 ^ 4@m7@V3v~ZAcpUoF2w| 8MGȆ@d%H(iД0?I@m1'gJOjYL/BQpr?[_Y[l/Q^>UJAa,}gFb<'f!7%gri>hj]o[kp.ƔtQ/Aupɴd${ ?_{^{~d,x+)2 tdh8^8`CJ0OJQJaJ0o(hHFh^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH88^8`56CJaJo(hH. ^`hH. L^`LhH. p^p`hH. @ ^@ `hH. L^`LhH. ^`hH. ^`hH. L^`LhH.h^`CJaJo(hH.h^`OJQJ^Jo(ohpp^p`OJQJ^Jo(h@ @ ^@ `OJQJ^Jo(h^`OJQJ^Jo(oh^`OJQJ^Jo(h^`OJQJ^Jo(h^`OJQJ^Jo(ohPP^P`OJQJ^Jo(h^`CJ0OJQJaJ0o(hHFh^`OJQJ^Jo(ohpp^p`OJQJ^Jo(h@ @ ^@ `OJQJ^Jo(h^`OJQJ^Jo(oh^`OJQJ^Jo(h^`OJQJ^Jo(h^`OJQJ^Jo(ohPP^P`OJQJ^Jo(88^8`CJaJo(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.h^`CJOJQJ^JaJo(h^`OJQJ^Jo(ohpp^p`OJQJ^Jo(h@ @ ^@ `OJQJ^Jo(h^`OJQJ^Jo(oh^`OJQJ^Jo(h^`OJQJ^Jo(h^`OJQJ^Jo(ohPP^P`OJQJ^Jo(h^`CJ0OJQJaJ0o(hHFh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh 8^8`hH.h ^`hH.h  L^ `LhH.h  ^ `hH.h x^x`hH.h HL^H`LhH.h ^`hH.h ^`hH.h L^`LhH.^`56CJaJo(hH. 88^8`hH. L^`LhH.   ^ `hH.   ^ `hH. xLx^x`LhH. HH^H`hH. ^`hH. L^`LhH.#^`56CJOJQJaJo(hH 88^8`hH. L^`LhH.   ^ `hH.   ^ `hH. xLx^x`LhH. HH^H`hH. ^`hH. L^`LhH.p@ @ ^@ `CJOJQJaJo(hHp^`CJ0OJQJaJ0o(hHFp  ^ `OJQJo(hHp  ^ `OJQJo(hHpxx^x`OJQJ^Jo(hHopHH^H`OJQJo(hHp^`OJQJo(hHp^`OJQJ^Jo(hHop^`OJQJo(hHh^`OJQJo(hHh^`CJaJo(hH.hpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh 8^8`hH.h ^`hH.h  L^ `LhH.h  ^ `hH.h x^x`hH.h HL^H`LhH.h ^`hH.h ^`hH.h L^`LhH.h0^0`OJQJ^Jo(hHoh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJ^Jo(hHoh@ ^@ `OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH88^8`56CJaJo(hH. ^`hH. L^`LhH. p^p`hH. @ ^@ `hH. L^`LhH. ^`hH. ^`hH. L^`LhH.h^`OJQJo(hHh8^`789;<CJ8H*OJQJS*TXaJ8o(hH+hpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh-h^h`56CJ OJQJ\]^JaJ o(hHh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh ^ `OJQJo(hHh ^ `OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`CJOJQJ^Jo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hHh88^8`56o(hH.h ^`hH.h  L ^ `LhH.h   ^ `hH.h xx^x`hH.h HLH^H`LhH.h ^`hH.h ^`hH.h L^`LhH.p@ @ ^@ `CJOJQJaJo(hHp^`56CJaJo(hH.p  ^ `CJ0OJQJaJ0o(hHFp  ^ `OJQJo(hHpxx^x`OJQJ^Jo(hHopHH^H`OJQJo(hHp^`OJQJo(hHp^`OJQJ^Jo(hHop^`OJQJo(hHh#^`56CJOJQJaJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH88^8`56CJaJo(hH. ^`hH. L^`LhH. p^p`hH. @ ^@ `hH. L^`LhH. ^`hH. ^`hH. L^`LhH.h ^`o(hH.h8^`789;<CJ8H*OJQJS*TXaJ8o(hH+hpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh-h^h`56CJ OJQJ\]^JaJ o(hHqh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh ^ `OJQJo(hHh ^ `OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHd^`CJ0OJQJaJ0o(hHFdTT^T`OJQJ^Jo(hHod$ $ ^$ `OJQJo(hHd  ^ `OJQJo(hHd^`OJQJ^Jo(hHod^`OJQJo(hHddd^d`OJQJo(hHd44^4`OJQJ^Jo(hHod^`OJQJo(hHh^`CJOJQJaJo(hHoh^`OJQJ^Jo(hHohpp^p`OJQJo(hHh@ @ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohPP^P`OJQJo(hHh^`CJ0OJQJaJ0o(hHFhp^p`OJQJ^Jo(hHoh@ ^@ `OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHhP^P`OJQJ^Jo(hHoh ^ `OJQJo(hH>^`56789;<CJ8H*OJQJS*TXaJ8o(hH+B^`56789;<CJ8H*CJOJQJS*TXaJo(hH  ^ `OJQJo(hH  ^ `OJQJo(hHxx^x`OJQJ^Jo(hHoHH^H`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hHh8^8`CJ0OJQJaJ0o(hHFh^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh#8^8`56CJOJQJaJo(hHh^`OJQJ^Jo(hHoh ^ `OJQJo(hHh ^ `OJQJo(hHhx^x`OJQJ^Jo(hHohH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHhh^h`56CJaJo(hH.#^`56CJOJQJaJo(hH#$ $ ^$ `56CJ0OJQJaJ0o(hHF @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.pp^p`CJaJo(hH.   ^ `hH.  L ^ `LhH. xx^x`hH. HH^H`hH. L^`LhH. ^`hH. ^`hH. L^`LhH.88^8`CJaJo(hH. ^`hH. pLp^p`LhH. @ @ ^@ `hH. ^`hH. L^`LhH. ^`hH. ^`hH. PLP^P`LhH.#0^`056CJ OJQJ\]^JaJ o(qh ^`hH.h ^`hH.h pL^p`LhH.h @ ^@ `hH.h ^`hH.h L^`LhH.h ^`hH.h ^`hH.h PL^P`LhH.h-h^h`56CJ OJQJ\]^JaJ o(hHh8^8`OJQJ^Jo(hHoh^`OJQJo(hHh ^ `OJQJo(hHh ^ `OJQJ^Jo(hHohx^x`OJQJo(hHhH^H`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH^`56CJaJo(hH. ^`hH.  L ^ `LhH.   ^ `hH. xx^x`hH. HLH^H`LhH. ^`hH. ^`hH. L^`LhH.h0^0`OJQJ^Jo(hHoh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHhp^p`OJQJ^Jo(hHoh@ ^@ `OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hH^`CJOJQJ^Jo(hH^`OJQJ^Jo(hHop^p`OJQJo(hH@ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoP^P`OJQJo(hHh^`CJ0OJQJaJ0o(hHFh^`OJQJ^Jo(hHoh  ^ `OJQJo(hHh  ^ `OJQJo(hHhxx^x`OJQJ^Jo(hHohHH^H`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHd  ^ `CJ0OJQJaJ0o(hHFdpp^p`CJ0OJQJaJ0o(hHFd@ @ ^@ `OJQJo(hHd^`OJQJo(hHd^`OJQJ^Jo(hHod^`OJQJo(hHd^`OJQJo(hHdPP^P`OJQJ^Jo(hHod  ^ `OJQJo(hHpp^p`56CJaJo(hH.^`OJQJ^Jo(hHopp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hH*j]oBQ7Q^x+)0rtz*?[8MG{~0ifJ!UoFKf7!7%g d(/Au=$( vw"tKRd3gFb1'gJ@YL(jkp?_{AafbJ~ZA@d%HY[d${(e30?I~^ 4~W:'w{**1R        Pd0                 1R        ଼7        TF        1R                 ଼7        W܌        W܌1R        e]                         Pd0         ( y       ڇa        F `l        Pd0        W܌Pd01R      W܌        Pd0         ( y       [        1R        ~        1R        )mW܌       1R        W܌         LW܌1R      ଼7        e]                 ڇa         L                 8^         1R        1R1R       Pd0        Be;ik)i_%'B1 wY y8Ac  Z7_E`wvrdz ?2D QjwB  E* e!{0"%$rl$ 8%3'4X(u(w.,9,A,U-.. c. 1:X1V41 7Ky8c9A;yx;#>b'>? C`/CV_Cp/DbE'ErF'H I=L~MO|O'PQVQ|QSJwSzTAUIVYW`W6X=[XpYY[m^1_u`kM`]d`gi` {`*a?a5lbNcjg6hqh?iMjB:k#Jl?elonp]ss*t0t<"uSu/Sy}o}%R:MmBvf})^1HD eIvR|[}}D,94+Iq7PpHsg-g)&EYT\&y+]v -a7Le _LzFs/\<>+tb-: ehRsDvoME-3$U ,Ru"Sx*[ts5stp12|n hr/ zU@`@UnknownG* Times New Roman5Symbol3. * Arial?= * Courier New;Wingdings71 Courier_Monotype SortsZapfDingbatsA BCambria Math")FF+g77$)4d 2Q)X?D2!xx!Introduction to Microcomputers sFIU-SCS*                           ! " # $ % & ' ( ) Oh+'0 , L X d p|$Introduction to Microcomputers s Normal.dotmFIU-SCS2Microsoft Office Word@F#@M$@t;@t;՜.+,0 hp  Hotel DeGregorio7 "Introduction to Microcomputers Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDFGHIJKLNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~Root Entry FB;Data E1TableMWordDocumentBSummaryInformation(DocumentSummaryInformation8CompObjy  F'Microsoft Office Word 97-2003 Document MSWordDocWord.Document.89q