当前位置: 首页 > >

初中信息技术考试实用excel教案

发布时间:

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market economy, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' duty consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and n ot a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on th e party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf -di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

《EXCEL》教案
教学对象 11 机电一班、二班 第四章 Excel 2000 电子表格系统 4.1 Excel 2000 基础知识和基本操作; 4.2 编辑 Excel 2000 工作表。 1.使学生了解 Excel 2000 基础知识; 2.掌握 Excel 2000 的基本操作,学会编辑工作表。 编辑 Excel 2000 工作表。 教学时间 2011 年 11 月

教学内容

教学目的

教学重点

教学难点

Excel 2000 工作表中数据的输入、数据的修改。

建议学时

理论:2 上机:4

教学教具

多媒体教学系统

教学方法

理论:使用多媒体教学方法讲授(.PPT); 上机:指导上机实验

演示设计 板书设计

4.1 Excel 2000 基础知识和基本操作; 4.2 编辑 Excel 工作表。

教学过程 先举一个例子,输入简单的、有代表性的例子,结合实例处理一些数据, 如输入数学、英语、政治三门课的成绩,再求一下这三门课的总成绩及*均 分,以引起同学们的兴趣,再引出本节新的内容。 1.电子表格的主要功能; 2.Excel 应用程序的启动和退出; 3.Excel 窗口界面; 4.Excel 文件操作; 5.Excel 工作表操作; 6.数据的分类; 7.单元格数据的表示; 8.数据的填充; 9.数据的修改; 10.数据的删除和清除。

课程导入 主要内容

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that , the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he lo cal fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public serv ants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme nt ation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

详细内容及要求 第四章、Excel 2000 电子表格系统 一、教学内容: 1、Excel 2000 基础知识和基本操作 2、编辑 Excel 工作表 3、设置 Excel 工作表 4、Excel 公式和函数的使用 5、Excel 数据库管理功能 6、Excel 图表功能 二、教学基本要求 掌握 Excel2000 工作表的编辑、 格式化操作; 掌握 Excel2000 公式和函数的使 用;了解 Excel2000 数据库的概念及特点;掌握数据排序;掌握数据筛选;掌握分 类汇总。掌握 Excel2000 图表功能。 三、重点与难点 重点: Excel2000 工作表的编辑、格式化操作;数据排序;数据筛选;分类汇 总。Excel2000 图表功能。 难点:公式和函数的使用;数据排序;数据筛选;分类汇总。 四、课时分配:讲授 6 学时、实验 12 学时 五、教学方法:讲授(ppt) 六、教学过程:

第一讲、Excel 2000 基础知识和基本操作(1 学时)
一、Excel 2000 的主要功能 1、Excel 2000 文件管理功能; 2、Excel 2000 电子表格功能; 3、 Excel 2000 数据管理功能; 4、 Excel 2000 数据图表功能。 二、Excel 2000 应用程序的启动和退出

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

三、认识 Excel 2000 窗口界面 1、Excel 应用程序窗口的组成 2、Excel 文件窗口 标题栏 全选框:位于文件窗口的左上角,用于选择当前窗口工作簿的所有单元。 行号:行的编号,顺序是 1、2、3、……65536,共 65536 行。 列号:列的编号,顺序是 A、B…Z、AA…AZ、BA…BZ、…IA…IV,共有 256 列。 滚动条:有水*滚动条和垂直滚动条,分别位于工作表的右下方 工作表标签:即工作表名称,位于文件窗口的左下方。 工作表移动按钮:位于文件窗口左下方的四个图标按钮 标签拆分线 3、几个重要概念 Excel 工作簿:即 Excel 文件,或称活页夹,其扩展名为“.xls”。 工作表:一张由行和列组成的巨大的二维表,共有 65536 行 256 列。 单元格:工作表中的每个小矩形,由行和列的交叉构成,是工作表的最小单位。 单元地址:由列号和行号组成,指出某单元在工作表中的位置。 当前单元格:即活动单元,指当前正在操作的单元格,由黑色线框住。 四、Excel 2000 文件操作 新建、打开、关闭、保存、打印预览、打印 五、Excel 2000 工作表操作 工作表操作包括: 工作表的插入:在当前 Excel 工作簿插入工作表、图表、宏表或对话框等。 工作表的删除:将工作表从当前工作簿中删除。 工作表重命名:以新的名称代替原工作表标签。 工作表移动:调整工作表在工作簿中的顺序。 工作表选定全部:全部选定工作簿中的所有工作表。 和右侧。

第二讲、编辑 Excel 工作表(1 学时)
一、xcel 数据的分类 1、数值型数据

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

2、正文型数据或字符型数据 不能进行运算的数据 二、单元格或区域的选取和表示 1、单元格的选取 1)选取一个单元格 方法一: 用鼠标单击所需的单元格,或者移动键盘上的方向键。 方法二:[编辑][定位],输入单元地址。 2)选取连续的多个单元格 操作:单击左上角的单元格,<Shift>+单击右下角单元格。 3)选取不连续的多个单元格 操作:先选取一部分连续的单元格,<Ctrl>+单击另外的单元格。 2、整行或整列的选取 操作:单击行号或列号。 3、全部单元格的选取 操作:单击全选框按钮。 4、取消选定的单元格 操作:单击工作表的任意处。 5、区域的表示 由区域的两个对角线单元地址表示;也可以定义域名,通过域名来引用和操作。 三、数据的输入 Excel 工作表中的数据不仅可以从键盘直接输入,还可以自动输入 操作步骤: *单击要输入数据的单元格。 *输入数据。 *确定输入的数据。 确定输入数据的方法有:回车键;单击编辑栏中的“√”按钮;按 方向键;单击其他单元格等。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

1、正文的输入 2、数字的输入 3、公式的输入 格式要求 1)由等号开始。 2)等号后面是由运算符、单元地址、数值、正文等组成的表达式。 4.函数的输入 1)函数是系统研制者定义好的供用户直接引用的特殊的公式。 2)函数格式:函数名(参数 1,参数 2,…) 3)函数的输入方法 5.日期数据的输入 方法一:使用 DATE(年,月,日)函数输入。 方法二:输入日期数,然后转换成日期的显示格式。 方法三:按“年/月/日”的格式直接输入。 6.时间数据的输入 方法一:使用 TIME(时,分,秒)函数输入。 方法二:输入时间数(一个小于 1 的小数),然后转换成时间的显示格式。 四、填充数据 1、自动填充 操作:(拖动“填充柄”进行填充) 输入初始单元数据,1 个或 2 个单元格。 选定包含初始值的单元格。 指向 “填充柄”并拖动填充柄经过待填充区域。 2.编辑填充操作 操作步骤: 首先在工作表中输入一个初始值。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

选择包括初始值的区域,操作[编辑][填充][…]。 五、数据的修改 1、输入过程中修改 2、修改单元数据 方法一:光标定位于要修改单元,重新输入数据。 方法二:双击要修改单元进入编辑状态。 方法三:光标定位于要修改单元,然后单击编辑栏或按 F2 键进入编辑状态,编辑 数据。 六、数据的删除和清除 1、删除 操作:[编辑][删除]。 2.清除 操作: [编辑][清除][全部]:删除格式、数据内容和批注。 [编辑][清除][内容]:删除数据内容。 [编辑][清除][格式]:删除格式。 [编辑][清除][批注]:删除批注。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

教学小结

本节要求学生重点掌握 Excel 2000 中单元格数据的编辑,要会利用多种方 式进行数据的填充、修改、复制、粘贴和清除与删除等操作,做到熟练掌 握和处理。

学*指导

这一节中对数据的填充要强调不同类型数据的输入方法:特别是日期型、 数字字符型数据的输入,要教会学生利用 Excel 提供给我们的有利工具,高 效率的、准确地输入数据。

参阅教材

第四章 第一节,第二节

作业

上机操作 Excel 2000 部分的课后练*。

教学后记

该部分内容理论 2 学时,可以完成; 实验 4 学时上机,时间较紧,因这部分的操作很耗时,特别是关于数据的 几种填充方式,要分别举出实例演示才行。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

《计算机应用基础》教案
教学对象 11 机电一班、二班 第四章 Excel 2000 电子表格系统 4.3 设置 Excel 工作表; 4.4 Excel 公式和函数的使用。 1.掌握 Excel 工作表的单元格格式的设置; 1. 掌握 Excel 工作表行和列的设置; 2. 掌握 Excel 工作表窗口格式的设置。 Excel 工作表单元格式的设置、行与列的设置。 教学时间 2011 年 11 月

教学内容

教学目的

教学重点

教学难点

Excel 公式和函数的使用。

建议学时

理论:4

上机:8

教学教具

多媒体教学系统

教学方法

理论:使用多媒体教学方法讲授(.PPT); 上机:指导上机实验

演示设计 板书设计

4.3 设置 Excel 工作表; 4.4 Excel 公式和函数的使用。

教学过程

课程导入 主要内容

先提问一下上节课有关数据与单元格的概念,在此基础上,进一步引出 本节新的内容。 1.设置单元格格式; 2.行和列格式的设置; 3.工作表操作; 4.窗口操作; 5.自动格式化工作表操作; 6.单元地址和引用; 7.公式; 8.函数; 9.自动求和、计数功能;

详细内容及要求

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

第三讲、设置 Excel 工作表格(1 学时)
指对 Excel 工作表格式进行设置,不改变工作簿的数据内容。主要格式设置有: 单元格格式,包括数据的显示格式、对齐、字符外观、边框、图案和保护等。 行和列格式,包括行高和列宽、隐藏行或列、取消隐藏行或列等。 工作表格式,包括工作表命名、隐藏工作表、工作表背景设置等。 窗口格式,包括拆分窗口、冻结拆分窗口(即冻结标题)等。 一、设置单元格格式 二、行和列格式的设置 三、工作表操作 四、窗口操作 五、自动格式化工作表 1、条件格式的设置 根据设置的条件动态地为满足条件的单元格自动设 置格式。 操作: 选取要设置格式的单元格区域。 [格式][条件格式]。 设置条件表达式和设置单元格格式。 2、格式的复制 3、工作表自动套用格式

第四讲、Excel 公式和函数的使用(2 学时)
一、 单元地址及其引用 1、地址的分类: 相对地址:相对当前单元的相对位置。表示如:A5:B9 、A5 、B8 。 绝对地址:单元格在表中的绝对位置, 表示在相对地址前加“$” 。 如,$A$5:$B$9 $A$5 $B$8。 混合地址:相对地址和绝对地址的混合。表示如:A5:$B$9 、A$5、$B8。 2.单元地址的引用 格式:[工作簿名] 工作表名! 单元格地址

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

例: [BOOK 1] Sheet1!A4 ; [BOOK 1] Sheet1!$B$6 Sheet1!A3 ; Sheet1!$B$5 (注:省略工作簿名,则默认为当前工作簿) A4 ; $B$9 (注:默认为当前工作簿的当前工作表) 二、公式 1、公式的格式 公式 = 操作数 + 运算符 1)要求: 由等号开始。 等号后面是由操作数和运算符组成的表达式。 2)操作数:可以是数字、单元地址、字符、区域名、区域、函数 3)运算符 ① 算术运算符、② 比较运算符③ 文本运算符“&”④ 括号:( )

4)运算符的优先级 ( )>算术运算符>文本运算符>比较运算符,( )最优先。 2、公式的改变 1) 改变被引用的单元数据时,公式的值相应地改变。 2) 移动公式时,其引用的单元地址不改变,值也不变。 3)移动被引用的单元数据时,公式中被引用的地址相应地改变,其值不改变。 3、公式的复制 公式在复制过程中,其引用的相对地址将相应地发生改变,其结果也将改变。 三、函数 格式: 函数名(参数 1,参数 2,…) 参数的取值范围是:常数、单元格、区域、区域名、逻辑值、文本、公式、其他函

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

数。now()函数没有参数。 四、自动求和、计数功能 1、自动求和功能 操作: 定位结果存放的单元格。 单击自动求和按钮:∑ 。 选择求和的数据单元区域。 [回车]。 2、自动计算功能 步骤: 鼠标指向自动计算区域函数名框。 单击右键,出现自动计算的函数菜单。 选择函数。 选择自动计数区域。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

教学小结

本节要求学生重点掌握 Excel 2000 中公式和函数的使用,学会使用常用函 数的用途,利用这些函数处理实际问题。要做到熟练掌握。

学*指导

这一节中对单元格数据的处理,重点放在公式和函数使用上。要强调不同 函数的使用方法及它们的使用条件。

参阅教材

第四章 第三节,第四节

作业

上机操作本节 Excel 2000 部分的课后练*。

教学后记

该部分内容理论 2 学时,可以完成; 实验 4 学时上机,时间较紧,关于函数,同学们大都初次接触,会感到有 些抽象,特别是条件函数,举例子要由减到繁,循序渐进,最好举此与学 生本身有关的实例。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

《计算机应用基础》教案
教学对象 第四章 Excel 2000 电子表格系统 4.5 Excel 数据库管理功能; 4.6 Excel 图表功能。 1.使学生掌握 Excel 关于数据库管理功能; 2.学会利用 Excel 图表对数据进行统计操作。 数据的排序、自动筛选、分类汇总及图表操作。 教学时间 年 月 日

教学内容

教学目的

教学重点

教学难点

数据的分类汇总、图表编辑。

建议学时

理论:2

上机:4

教学教具

多媒体教学系统

教学方法

理论:使用多媒体教学方法讲授(.PPT); 上机:指导上机实验

演示设计 板书设计

4.5 Excel 数据库管理功能; 4.6 Excel 图表功能。

教学过程

课程导入 主要内容

本节内容较多,与前面内容关系不密切,可直接引出新内容。 1.什么是 Excel 数据库; 2.数据排序; 3.自动筛选; 4.分类汇总; 5.Excel 图表区域的组成; 6.图表的生成; 7.图表的编辑; 8.图表工具栏的使用。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

详细内容及要求

第五讲、Excel 数据库管理功能(1 学时)
一、什么是 Excel 数据库 1、数据库的概念 数据库是一个二维表,按字段和记录的形式组织数据。 Excel 数据库指基本符合数据库特征的 Excel 工作表区域,也称 Excel 数据列表。 2、Excel 数据库的特点 字 段:同一类型的一列数据。 字段名:第一行为字段名,各字段名在同一行上,不能有相同的字段名。 记 录:含有每一个字段的一行数据,每行表示一个对象。 行、列的顺序关系不影响二维表所包含的信息内容。 3、建立和编辑数据列表 相同工作表的建立和编辑,也可利用[数据][记录单]命令建立和编辑。 4、规则要求 1)数据列表与其他数据之间至少保留一个空行或空列。 2)数据列表中不能有空行或空列。 3)数据列表的第一行为列标题,称为字段名。

二、数据排序 1、简单排序 步骤: 选择参与排序的数据区域(注:一般不包括字段名行,但包括所有列)。 单击工具栏中的升序或降序按钮。 2、复杂排序 步骤: 选择参与排序的数据区域。 [数据][排序]。 选择关键字和排序方向。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

确定。 三、自动筛选 筛选指只显示满足条件的数据记录。有自动筛选和高级筛选两种方法。 操作步骤: 光标位于数据列表上。 [数据][筛选][自动筛选]。 单击筛选按钮,取值或选取自定义后给出筛选条件。 取消筛选:[数据][筛选][自动筛选] 四、分类汇总 操作: 1 按某关键字段进行排序(分类)。 2[数据][分类汇总]。 3 对“分类汇总”对话框进行如下操作:

分类字段。 汇总方式。 选定汇总项(可有多个)。 替换当前分类汇总。 每组数据分页/不分页。 汇总结果显示在数据下方。

第六讲、图表功能(1 学时)
?一、Excel 图表区域的组成 Excel 图表是根据已有的数据生成的,它的构成包括数据区域和图表区域。如下是图 表区域的组成。 绘图区:包括网格线、数据标志、图形。 数 轴:包括 X 轴(分类轴)、Y 轴(数据轴)、数轴标记、数轴刻度。 标 题:包括主标题、X 轴标题、Y 轴标题。 图 例 数据表 ?二、图表的生成 操作步骤:

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

1 输入数据(系统将根据输入的数据生成图表)。 2[插入][图表],选择图表类型。 3[下一步],选取生成图表的数据。 4[下一步],分别对标题、坐标轴、网格线、图例、数据标志、数据表等进行操作。 5[下一步],确定图表的位置,选择新工作表或嵌入工作表。 6[完成]。 ?三、图表的编辑 ?四、图表工具栏的使用 实验十:Excel 基本操作(1 学时) 实验目的 1、掌握 Excel 的启动和退出; 2、了解 Excel 窗口的各个组成部分; 3、掌握 Excel 文件操作,包括 Excel 文件的创建、打开、保存、关闭等操作; 4、掌握 Excel 工作表操作,包括插入、删除、重命名、移动和复制等操作。 实验十一:Excel 工作表的编辑操作(1 学时) 实验目的 1、掌握 Excel 数据的输入、数据的填充; 2、了解 Excel 数据的编辑操作,包括:修改、移动、复制、删除和清除等。 实验十二:Excel 工作表的设置操作(2 学时) 实验目的 1、掌握 Excel 工作表的单元格式设置; 2、掌握 Excel 工作表行和列的设置; 3、掌握 Excel 工作表的设置; 4、掌握 Excel 工作表窗口格式的设置。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or de r have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of "two not" phe nome non rendering four a features : a is posit ions consum ption system lost ha s due of binding , right is greater than rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self-dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four palaces, foll ow the fas hion, rivalr ies, wasteful , and post cons um ption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring temporary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

实验十三:Excel 公式和函数的使用(2 学时) 实验目的 掌握公式和函数的使用 实验十四:Excel 数据库管理操作(2 学时) 实验目的 1、了解 Excel 数据库或数据列表的特点; 2、掌握数据的排序、筛选、分类汇总等操作。 实验十五:Excel 图表操作(2 学时) 实验目的 1、了解图表的生成过程和方法; 2、掌握图表的编辑操作。 七、教学小结 本章学*了 Excel2000 基本知识;工作表的基本操作(工作表的创建、保存和打开; 工作表的插入、删除、重命名、移动);工作表的编辑(数据的分类、输入和数据 自动填充;单元格或区域的选定);数据的编辑操作(包括数据的修改、复制、移 动、删除和清除)。工作表的格式化操作(设置单元格格式、设置行和列格式、设 置工作表格式、 工作表窗口的拆分和冻结、 条件格式的设置和自动套用格式的使用) ; 公式和函数的使用(包括 SUM、AVERAGE、COUNT、IF、MAX、MIN、DATE、 TIME);Excel2000 数据管理(数据库的概念及特点、数据排序、数据筛选、分类 汇总);Excel2000 图表功能(图表的组成、图表的生成过程和方法、掌握图表的编 辑和工具栏的使用)。

教学小结

本节要求学生重点掌握 Excel 数据的排序、筛选、分类汇功能;还要 会利用图表对数据进行统计和处理。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a difficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: f irst, under the existi ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. Second, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds approve d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s erv ants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynam i c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty c ons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta bl is h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publi c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting consumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetizatio n reform of politics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonstrated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Sec ondly, the

positi on-relate d cons umption of civil servants has been swe pt by finance, consumer, reg ardle ss of cost, extravaga nce a nd wa ste in the civil servi ce positi on -relate d cons umption, a bus e, corrupti on a nd em bezzl ement, corruption is important. T hen, under the conditi ons of market econom y, how t o reform the existi ng civil duty cons umption manageme nt, expl ores a s our ce to prevent a nd cur b the post consumpti on corr uption way, is curre ntly a major is sue faced by honest w ork. Recently, I conducted res earch on this is sue , this probl em on some humble opi nions. First, t he existing publi c servant s ' dut y consum ption t he main pr obl ems see n from the inv estigation and reas ons , in re cent year s, publi c servant s ' duty consum ption caused by the a bus es and not a pers on of integrity, is one of the major pr oblems i n the party in G overnme nt, its operation or der have a negative effe ct on the party and G overnme nt organs, seri ous ly damaging t he image of the party and t he Gov ernment, undermining t he relations hip betwee n party and the mas ses, effect, openi ng up a nd e conomi c constr uction. From I County in re cent year s of gover nance situation see, positi ons cons umption in t he pr oduce d of " two not" phe nome non rendering four a features : a is positions consum ption system lost ha s due of binding , right is greater th an rul es, and right is gre ater than met hod of phenomenon more highlig ht; II is i n positions consum ption i n the Camera Obs cura operati on, using terms , will positions consum ption into has personal consumpti on, will corpor ate poi nts to i nto pers onal poi nts to, makes positi ons cons umption in s ome as pects has i nto positi ons enj oy and self -dealing of means ; three is t o positions consumpti on for name, fraud, false impers onat or, Tre nd of negative corrupti on phe nome na s uch as corruption a nd mis appropri ation; four pal aces, foll ow the fas hion, rivalr ies, wasteful , and post cons umption be came a symbol of s howi ng off their individual ca pacities. Caus ed by public servants ' duty cons umpti on of many "two" phenomenon i n whi ch people reflect t he bigge st problems are : (a) the official car pr obl ems. Mai nly in thre e aspects : one is the larg er buses cost ex penditure . Accordi ng to stati stics, until Novem ber 2003 , XX County t ownship Departme nt bus 159 cars, which de partment owns t he bus 14 5 vehi cles, a nd s howed a n increasi ng trend. Fina ncial ex penses cost per bus per ye ar to 35, 000 yua n, and in fact ev ery cost up t o 50,0 00 yua n. Some units al so hiring tem porary drivers a nd ex penditure on wag es and s ubsi dies . Ne ces sary to "keep a car", but al so "dependa nts", leadi ng to larger expens es. Se cond, g ong che siyong bree d unhealt hy tendencies. S ome pe ople believe t hat now some bus drivers use one -thir d, one-t hird lea ding private one-t hird use d for official purpose s. Some publi c serva nts, e spe cially lea ding officials motori ng, car s for private purpose s, violati ng the s elf-di sci pline reg ulations, a nd ev en lea d to traffic accide nts. A ccordi ng to statisti cs from related de partment s, since 20 04, the corre ct inve stigation in our County serves nearly 30 cars for private pur pos es, only the first half of this year, cars for private pur pos es or

学*指导

这一节中对数据的分类汇总,要强调它的前其工作,不能直接进行分 类汇总,否则会出现错误。关于图表的操作,要学会对图表中各项数 据的数据的操作。

参阅教材

第四章 第五节,第六节

作业

上机操作 Excel 2000 该部分的课后练*。

该部分内容理论 2 学时,可以完成; 教学后记 实验 4 学时上机,时间较紧,这部分的操作很复杂,特别是关于图表 的操作,要分别举出不同情况下的实例才行。

leaders driving a ve hicle a cci de nt caused by roa d accide nts, 1, 1 people kille d and dire ct economic l osse s amounting to m ore tha n 100, 000 yua n. T hird, high efficie ncy a nd low cost of the bus . Surveys s how that, the oper ating costs of taxis for the 820 0/. .. Is a fundame ntal pri ority of the reform, it i s a di fficult pr oblem that must be solve d in the reform proces s. Clearly , the post consumpti on aver ages thre e years before as a base a nd fine -tuned on t he bas is of this single practi ces must be impr oved. Improv ements to a dhere to thre e principles: first, under the ex isti ng policy provisi ons approv ed for publi c servant s ' duty consumpti on standards , cali bration, is not contrary to poli cy. S econd, accor ding to t he local fina ncial s ituation and pe opl e's s ustaina bility, publi c serva nts ' duty cons umption sta ndar ds ap prove d, both fina ncia l reach, and pe ople pas sing thr oug h. Thir d, accor ding t o the operati onal needs of civil s ervants re sponsi ble for a uthori zed public servants ' duty consumpti on sta ndar ds, bot h 。 动 活 的 常 正 行 进 对 收 验 量 质 施 各 和 纸 图 计 据 根 度 制 作 关 有 司 公 及 则 细 划 ”、 范 规 “设 按 格 严 后 场 现 入 驻 目 项 了 建 组 即 随 , 起 同 合 理 监 立 订 自 程 工 本 high and low positions, but als o the nature of the work a nd the workl oad. In reform of method Sha ng, approve d civil s ervants pos itions cons umpti on sta ndar d to "big unified, a nd small dis perse d" suita ble, that most positions consumpti on proje ct s hould accor ding t o pol icy pr ovide s pr oposed unified sta ndar d, consider t o ranks , and unit s and the w ork task of differences s ex, unifie d of sta ndar d shoul d has elastic of and dynami c of, makes regi ons , and unit s in impleme ntation unified sta ndar d Shi ha s must of flexible dis posal right; but si nce set of standard must after financial, and a udit, se ctor a udit a ppr oved H ou to im plementati on. (C) reform pa ckage. Public s ervants ' duty cons umpti on ela sticity of consumpti on to limit consumpti on, turni ng mess i nto kitchen after di nner, follow the civil servant wit h a how to use per sonal title subsi dies, or how to manag e a pers onal duty consumpti on use of subsidie s. T herefore, w e must esta blis h and perfect w ith publi c serva nts ' duty consum ption monetizati on reform s upport of the series of governa nce systems s uch as the civil s ervice examination of responsibility, sy stem, low fault i nvestigati on sy stem, the re port sai d. While other meas ures t o keep up. Discipline i ns pecti on a nd s upervision orga ns, fina ncial , auditing de partment s s houl d stre ngthe n supervisi on a nd i nspecti on of publ i c serva nts ' duty cons umption monetization reform pr ogress, t o strengt hen t he reform of publi c servant s ' duty consum ption m oneti zation system, meas ures t o devel op a nd monitor the implementati on of ins pecti on, not consumpti on a s requir ed, eve n shifting co nsumer behavi or to st op, serious ca ses t o deal wit h. T hree ide as, publi c serva nts ' duty cons umption monetization reform of p olitics , the e conomy and the deepeni ng of the reform, publi c serva nts ' duty cons umption as s omewhere betw een a reform al so demonst rated its importance and urgency. First of all, civil serva nts es peci ally party and G overnme nt leader s and public servant s ' duty consumpti on t here are big draw back s. NPC deputi es and CPPCC members a nd t he br oad mas ses are concer ned a bout. Secondly, the




友情链接: