2012信息技术考试外围软件配置标准说明文件
2012年信息技术会考操作题知识要点讲解
Word2003操作知识点1.页边距、纸张：文件\页面设置2.查找、替换：编辑\查找（ctrl+F）编辑\替换（ctrl+H）3.页眉、页脚：视图\页眉页脚4.字体、字色、字号、字形（加粗、倾斜）、文字效果、字体效果的设置：先选中需要设置的文字，然后点击鼠标的右键，选择字体命令（或者单击格式菜单，选择字体命令）或者5.左缩进、右缩进、特殊格式（首行缩进、悬挂缩进）、间距、行距的设置：先选中需要设置的段落，然后点击鼠标的右键，选择段落命令（或者单击格式菜单，选择段落命令）或者其中，悬挂缩进和首行缩进的单位可以是字符，亦可是厘米，默认的单位是字符，如需设置为厘米，则需直接输入数值和单位（如下图）6.艺术字：（插入\图片\艺术字）输入艺术字后，单击艺术字，弹出艺术字工具栏，如下图：其中文字环绕又称版式7.图片：（插入\图片\来自文件）注意：考试时，所有的操作题文件均会出现在C：\Myexam文件夹下图片的格式设置，只需要在再插入的图片上双击鼠标即可弹出格式设置对话框，如下图：8.边框和底纹：（格式\边框和底纹）设置边框和底纹的时候注意应用的范围，看清楚是段落还是文字！ 9. 项目编号和项目符号：（格式\项目符号和编号）选中相应的段落文字，单击项目符号和编号，选中相应的选项即可！如没有特殊要求，则可直接单击相应按钮来完成，如下所示：**********************************************************************************************************************************************************************************************Excel203操作知识点工作表的基本操作1、 工作表的插入：例如，在sheet2前插入一新工作表则：右击“sheet2”，——“插入”——在菜单中选择“工作表”——“确定”重命名：右击标签——“重命名”——输入名称——按回车键 删除：右击标签——“删除”移动和复制：右击标签——“移动或复制工作表”（如右图）（一般是移动，如果在“建立副本”前打钩则是复制） 2、 数据修改输入：先选中目标单元格，在编辑栏中修改（建议复制、粘贴）。
2012信息技术学生用考签5
2012年盐城市初中信息技术毕业考查考签（5）
（考生用）
学校________________班级_______姓名_______桌号_______
一、任务描述
为了制作“缤纷校园”为主题的网站，某校学生准备从“趣味课堂”、“才艺舞台”、“运动乐土”这三个版块展示本校丰富多彩的校园文化。
你是该网站设计团队中的一员，请你根据“网站运行效果视频”以及以下制作要求，完成网页设计。
二、考查时间：30分钟。
三、资源提供：D:\考签5——缤纷校园\素材。
四、制作要求
1、作品要求：
(1) 可使用软件：FrontPage2003等网页制作软件。
(2) 打开“缤纷校园”网站。
为“daohang.htm”网页中的各个交互式按钮设置超链接，以便能够打开对应的网页。
(3) 打开“shouye.htm”网页，用给定的文字、图片等素材制作网页，要求如下：
①选择合适的文字和图片，完善首页内容，使其能概述三个版块的内容。
②用表格对网页进行布局，表格大小以及位置适中，内容区域划分合理。
③对使用到的图片素材进行适当的处理，以提高网页浏览的速度。
④对网页进行适当的美化，如：文字的修饰、背景以及小图标的使用等。
2、文件及文件夹管理要求：
（1）网站中使用到的所有插图都保存到网站中的“images”文件夹中，交互式按钮的图片保存到“images”文件夹中的“button”文件夹内。
（2）在D盘根目录下新建一个自己的考试文件夹，取名为“准考证号”+“姓名”，将“缤纷校园”网站复制到该文件夹中。
四、评价量规。
Autodesk Flare 2012 软件系统要求说明书
Autodesk®Flare™ 2012 SoftwareSystem RequirementsOperating SystemAutodesk® Flare™ 2012 software is supported only on the following operating systems:Determining the Appropriate OSRed Hat Enterprise Linux operating system is a commercial Linux distribution, which requires a subscription fee. Red Hat offers several types of enterprise-class support, along with training, documentation, and consulting. This distribution is recommended for most users, especially if you need assistance with Linux system administration and configuration. Note that Autodesk does not provide Linux system administration and configuration support. For more information, contact Red Hat .CentOS is a free, enterprise-class Linux distribution derived from the Red Hat Enterprise Linux sources. It is built and maintained by the online community. Unofficial support and documentation are freely available online, through mailing lists, and discussion groups. Use this distribution if you are an experienced Linux user and do not need support with Linux system administration and configuration. For more information, contact CentOS .Hardware RequirementsAt a minimum, Autodesk® Flare™ 2012 software requires these supported hardware specifications:Operating SystemVersion Red Hat® Enterprise Linux® Desktop with Workstation Option for 64-bit x86-64 AMD/Intel5.2, 5.3, 5.5, 5.7 CentOS for 64-bit x86-64 AMD/Intel 5.2, 5.3, 5.5, 5.7Component MinimumNotes CPUAMD64 or Intel 64 Two Single-Core, or one Dual-Core., 64-bit configurationRAM8GB or moreMatching the Autodesk® Flame®/Autodesk® Inferno® system memory configuration is recommended.HDD 500 MB free drive space Network Card On-board GigEGraphicsNVidia® Quadro® and Quadro*See the certified hardware page .Learn more about certified hardware for Autodesk Flare on the certified hardware page .Qualified DriversThe drivers specified in this section were used for the qualification process. While it may be possible to use Flare successfully with other drivers, Autodesk strongly recommends using qualified drivers.*See the certified hardware page .Card FX series graphic cards.Audio Card ALSA compatible card Monitor Single screen, resolution of 1,920 x 1,200 Optical DriveDVD-ROMPeripherals Keyboard, MousePen tablet is recommendedComponent DescriptionDriver Version Display Driver Linux driver for qualified NVIDIA Quadro FX familydisplay cards*Linux driver for qualified NVIDIA Quadro family display cards 190.53*260.19.44*Audio DriverALSA—Generic ALSA audio driver*This Driver is required for RH/Centos 5.2 only.*Audio is optional for Flare. See the Flare installation guide for details on how to configure Flare without Audio alsa-lib-1.0.17-1Pen Tablet Driver*Wacom—Latest pen tablet driver for Wacom® Intuos2 tablet, Intuos3 and Intuos4 tablet support*A tablet is optional for Flare. Supported tablets are Wacom Intuos2, Intuos3 and Intuos4Linux wacom 0.8.4-4。
TCS2012软件说明书
5M-TCS 2012一卡通管理系统软件手册广州市鑫澳康科技有限公司二〇一二年八月目录第一章综述 (5)1-1系统设备及专用术语 (5)1-1-1系统设备参数定义 (5)1-1-2系统中的编号 (6)1-1-3查询操作 (6)1-1-4选择操作 (6)1-1-5输出格式 (9)1-1-6操作类 (9)1-2安装SQL Server服务器 (9)1-2-1安装“Microsoft SQL2000个人版” (10)1-2-2安装“Microsoft SQL2000企业版” (16)第二章系统管理 (23)2-1模块功能 (23)2-2初次启用系统设置 (23)2-2-1登录 (23)2-2-2数据库设置 (23)2-2-3消费配置 (27)2-2-4单位密码设置 (27)2-3设置数据库和消费配置 (31)2-4修改单位名称 (31)2-5操作员管理 (31)2-6修改操作员密码 (34)2-7系统操作日志 (34)2-8数据备份 (35)2-9数据恢复 (36)2-10消费数据结算 (37)第三章人事管理 (38)3-1模块功能 (38)3-2人事参数设置 (38)3-2-1职务管理 (38)3-2-2学历管理 (41)3-2-3员工附加信息 (42)3-3部门设置 (45)3-4员工登记 (47)3-4-1录入 (47)3-4-2查询 (50)3-4-3资料修改 (52)3-4-4设置显示格式 (53)3-4-5资料输出 (54)3-5员工部门调动 (55)3-6登记离职人员 (57)3-7离职库人员 (59)3-8导入员工信息 (59)3-8-1整理欲导入的表格 (59)3-8-2导入表格 (60)3-8-3校正表格 (62)3-8-4导入表格注意事项 (65)3-9汇总与统计 (65)3-9-1入职员工汇总 (65)3-9-3生日员工汇总 (66)3-9-4工龄统计 (67)3-9-5年龄统计 (68)第四章卡管理 (69)4-1模块功能 (69)4-2检测IC发卡器 (70)4-3卡类型管理 (70)4-4 水控参数卡设置 (75)4-5发卡 (77)4-5-1单人发卡 (78)4-5-2批量发卡 (80)4-6卡充值 (83)4-7卡多人充值 (85)4-8正常退卡 (87)4-9卡挂失 (88)4-10卡挂失处理 (90)4-10-1取消挂失 (90)4-10-2强行退卡 (92)4-11卡消费退款 (96)4-12卡取款 (98)4-13销卡 (100)4-14 个人卡查询 (102)第五章消费管理 (103)5-1模块功能 (103)5-2就餐时间设置 (104)5-3收款员管理 (106)5-4消费设备登记 (107)5-4-1通用项设置 (108)5-4-2系统消费类别设置 (110)5-5消费设备通讯 (116)5-6订餐管理 (118)5-6-1订餐时段设置 (118)5-6-2正常日订餐 (119)5-6-3订餐汇总 (120)5-6-4订餐就餐明细表 (120)5-7补贴管理 (121)5-7-1设置员工对应补贴机 (121)5-7-2新增补贴数据 (123)5-7-3修改补贴数据 (126)5-7-4删除补贴数据 (129)5-7-5发放补贴 (130)5-7-6停止发放补贴 (132)5-7-7查询已发放补贴信息 (133)5-7-8统计补贴信息 (134)5-8消费明细查询 (137)5-9汇总统计 (139)5-9-1现金收支日报表 (140)5-9-2现金收支月报表 (141)5-9-3现金收支汇总表 (142)5-9-4总帐日报表 (143)5-9-6总帐汇总表 (145)5-9-7消费统计日报表 (146)5-9-8消费统计月报表 (147)5-9-9消费统计汇总表 (148)5-9-10定义报表 (149)5-10按个人汇总 (154)5-11卡余额查询 (154)5-12查询卡管理操作记录 (155)第一章综述“5M-TCS 2012一卡通管理系统”，是我公司的消费机设备使用的管理软件。
信息技术学业考试考前软硬件环境要求(机房环境)
贵州省信息技术学业水平考试系统软硬件环境要求一、硬件要求监考机环境要求考生机环境要求注：1、所有操作系统不要使用Ghost版本(如番茄花园、雨林木风等)、考生端Windows XP 不用使用Home版。
2、请将显示的属性设置为“Windows经典”主题。
二、应用程序版本要求注：监考机和学生机必须同样完全安装Office2003以及其它所需的软件.详细软件安装方法请参阅<<附件1.系统应用软件安装操作说明>>。
三、考前机房环境的处理要求1、确保机器无毒环境，监考端和考生端的操作系统及相应的应用软件环境符合考试环境要求。
监考机和考生机必须完全安装Office 2003软件，IE浏览器必须使用6.0；2、考试期间请禁用杀毒、防火墙（包括Window 自带的防火墙）等软件；禁用电子教室等软件。
3、监考端与考生端安装前请确保之前所有考试系统包括单机练习版本已经彻底清除干净。
尤其是监考端一定不能安装练习版。
4、考生机的电脑磁盘分区不能使用盘符Y,因为Y盘为考试系统使用盘。
5、双网卡的在安装监考端时必须先禁用外网，启用局域网的网卡；6、考试期间监考机先启用外网校时然后断开外网，以免病毒感染。
7、开始——运行——输入“temp”将temp里的内容清理干净。
四、常规设置针对监考机必须设置自动获取IP才能上网的设置方法：1、先给监考机设定一个固定IP，然后设置监考机、导入考试数据。
2、安装学生端，并启动学生端到登陆界面。
3、将监考机IP改为自动获取，开启监考机，连网较时，进入到考场管理界面。
4、再把监考机IP改为原设置的固定IP，并重新启动数据服务器。
5、正常开始考试如果监考机是双网卡的使用方法？答：如果装双网卡，建议这样操作：1、先禁用连接外网的网卡，安装监考管理系统和更新考生端系统。
2、启用连接外网的网卡，进行网络校时。
3、校时成功后，断掉外网，并重新启动数据服务器。
关于还原卡设置？答：考试期间可以启用还原卡，但是要禁用对考生作答包盘符（默认是D:盘）起作用：如果启用，会造成数据包丢失，对考生做不了单机交卷。
Autodesk Revit MEP 2012系统要求与推荐说明书
Autodesk® Revit® MEP 2012System Requirements and RecommendationsMinimum: Entry-level configurationDescription RequirementOperating System Microsoft® Windows® 7 32-bit▪Enterprise▪Ultimate▪Professional▪Home PremiumMicrosoft® Windows® Vista® 32-bit (SP2 or later)▪ Enterprise▪ Ultimate▪ Business▪ Home PremiumMicrosoft® Windows® XP (SP2 or later)▪ Professional▪ HomeBrowser Microsoft® Internet Explorer® 7.0 (or later)CPU type Microsoft Windows 7 32-bit or Microsoft Windows Vista 32-bit (SP2 or later)▪ Intel® Pentium® 4 or AMD Athlon® Dual Core, 3.0 GHz (or higher) withSSE2 technologyMicrosoft Windows XP (SP2 or later)▪Intel Pentium 4 or AMD Athlon Dual Core, 1.6 GHz (or higher) with SSE2technologyMemory 4 GB RAM▪Usually sufficient for a typical editing session for a single model ofapproximately 100MB on disk. This estimate is based on internal testingand customer reports. Individual models will vary in their use of computerresources and performance characteristics.▪Models created in previous versions of Revit software may require moreavailable memory for the one-time upgrade process.▪/3GB RAM switch not recommended. Revit software and system stabilitycan be affected by memory conflicts with video drivers when the /3GBswitch is active.Video Display 1,280 x 1,024 display with True ColorVideo Adapter Basic Graphics▪Display adapter capable of 24-bit colorAdvanced Graphics▪256 MB DirectX® 10 capable graphics card with Shader Model 3 asrecommended by Autodesk at:/revitmep-graphicscardHard Disk 5 GB free disk spacePointing Device MS-Mouse compliantMedia Download or installation from DVD9Connectivity Internet connection for license registration and prerequisite component downloadValue: Balanced price and performanceDescription RequirementOperating System Microsoft® Windows® 7 64-bit▪Enterprise▪Ultimate▪Professional▪Home PremiumMicrosoft® Windows Vista® 64-bit (SP2 or later)▪Enterprise▪Ultimate▪Business▪Home PremiumMicrosoft® Windows® XP Professional x64 Edition (SP2)Browser Microsoft® Internet Explorer® 7.0 (or later)CPU type Microsoft Windows 7 64-bit or Microsoft Windows Vista 64-bit (SP2 or later)▪ Intel® Core™ i5-2300 quad-core processor [2.8GHz, 6MB cache] orequivalent AMD® processorMicrosoft Windows XP Professional x64 Edition (SP2)▪ Intel® Pentium® 4 or AMD Athlon® Dual Core, 1.6 GHz (or higher) withSSE2 technologyMemory 8 GB RAM▪Usually sufficient for a typical editing session for a single model ofapproximately 300MB on disk. This estimate is based on internal testingand customer reports. Individual models will vary in their use of computerresources and performance characteristics.▪Models created in previous versions of Revit software may require moreavailable memory for the one-time upgrade process.Video Display 1,680 x 1,050 display with True ColorVideo Adapter 1 GB DirectX® 10 capable graphics card with Shader Model 3 as recommended by Autodesk at:/revitmep-graphicscardHard Disk 5 GB free disk spacePointing Device MS-Mouse compliantMedia Download or installation from DVD9Connectivity Internet connection for license registration and prerequisite componentdownloadPerformance: For large, complex modelsDescription RequirementOperating System Microsoft® Windows® 7 64-bit▪Enterprise▪Ultimate▪Professional▪Home PremiumBrowser Microsoft® Internet Explorer® 7.0 (or later)CPU type Intel® Core™ i7-2600 quad-core processor [3.8GHz, 8MB cache] or equivalent AMD® processorMemory 16 GB RAM▪Usually sufficient for a typical editing session for a single model ofapproximately 700MB on disk. This estimate is based on internal testingand customer reports. Individual models will vary in their use of computerresources and performance characteristics.▪Models created in previous versions of Revit software may require moreavailable memory for the one-time upgrade process.Video Display 1,920 x 1,200 display with True ColorVideo Adapter 2GB+ DirectX® 10 capable graphics card with Shader Model 3 as recommended by Autodesk at:/revitmep-graphicscardHard Disk 5 GB free disk space10000+ RPM (important for Point Cloud interactions)Pointing Device MS-Mouse compliantMedia Download or installation from DVD9Connectivity Internet connection for license registration and prerequisite componentdownloadAutodesk® Revit® Server 2012Description RequirementOperating System ▪ Microsoft® Windows® Server 2008 R2 64-bit▪ Microsoft® Windows® Server 2008 64-bitWeb Server Microsoft® Internet Information Server 7.0 (or later)< 100 Concurrent Users(multiple models)Minimum Value PerformanceCPU type 4+ cores2.6 GHz+ 6+ cores2.6 GHz+6+ cores3.0 GHz+Memory 4 GB RAM 8 GB RAM 16 GB RAMHard Drive 7200+ RPM 10000+ RPM 15000+ RPM100 + Concurrent Users(multiple models)Minimum Value PerformanceCPU type 4+ cores2.6 GHz+ 6+ cores2.6 GHz+6+ cores3.0GHz+Memory 8 GB RAM 16 GB RAM 32 GB RAM Hard Drive 10000+ RPM 15000+ RPM High-Speed RAID Array Virtualization VMware® Support (See Revit Server Administrator’s Guide)Autodesk Revit MEP 2012 software for Citrix XenApp6* Description RequirementCitrix System ▪ XenApp® 6.0▪ Citrix® License Manager▪ Citrix® Profile ManagerAuthentication Microsoft® Active Directory▪Roaming Profiles supportedLicense Server Dedicated Autodesk license server for session-specific licensesClient OS ▪ Microsoft® Windows® 7 64-bit▪ Microsoft® Windows® 7 32-bit▪ Microsoft® Windows® XP Professional x64 Edition (SP2)▪ Microsoft® Windows® XP (SP2 or later)Client Browser ∙ Internet Explorer® 8∙ Internet Explorer7User Access ▪Client computers should be bound to the network domain. Each clientcomputer should have either the full or web online client plug-in installed.▪Users should use their domain logins to access both the Citrix web consoleand the LAN.*Additional Disclaimer: Autodesk Revit MEP software does not include the Citrix application, nor does Autodesk provide support for issues with the Citrix application. Users should contract Citrix directly with questions related to procurement and operation of the Citrix application.Autodesk and Revit are registered trademarks or trademarks of Autodesk, Inc., and/or its subsidiaries and/or affiliates, in the USA and/or other countries. Citrix and XenApp are registered trademarks of Citrix Systems, Inc. All other brand names, product names, or trademarks belong to their respective holders. Autodesk reserves the right to alter product and services offerings, and specifications and pricing at any time without notice, and is not responsible for typographical or graphical errors that may appear in this document.©2011 Autodesk, Inc. All rights reserved.。
微软2012年办公软件数据库管理指南说明书
Spreadsheet Management with the new OfficeSpreadsheets and databases (known as end-user computing (EUC) applications) are extraordinarily powerful tools that enable users to store, analyze, and manipulate data efficiently. They have become ubiquitous in firms for a wide range of activities from financial reporting to securities trading to risk analysis.Unfortunately, this ease of use often causes EUCs to proliferate beyond the reach of governance rules and IT administrators. EUC applications may be designed, developed, tested, and used by a small group or even an individual, and they are often created in response to an immediate need without formal requirements or management approval. However, the data they provide is used to create reports and make business-critical decisions. Even if the data and outputs in an EUC are correct, versions may not be refreshed in step with one another, leading to multiple views of key performance indicators instead of a unified understanding of a company’s numbers and health.The results can be dire. Erroneous, incomplete, or fraudulent EUCs can subject companies to unwanted attention from auditors and regulators and result in noncompliance with regulations promulgated by Sarbanes-Oxley 404, the National Association of Insurance Commissioners Model Audit Rule, the Office of the Comptroller of the Currency, the Financial Services Authority, Solvency II, Basel II, and MFID. Companies may even experience significant financial losses.The reality is that companies may have hundreds or thousands of EUCs lurking in SharePoint or on file shares. Without the right technology, administrators and compliance officers have no efficient means of finding and managing EUCs, and users lack the tools to maximize their value without creating unnecessary business risk. Formerly, organizations needing Microsoft Office EUC discovery, auditing, and management capabilities needed to use costly third-party solutions. In 2011, Microsoft acquired Prodiance, a leading provider of EUC control solutions. This strategic acquisition means organizations now have access to a comprehensive EUC management toolset, integrated with Excel and SharePoint and directly supported by Microsoft. With these offerings, organizations can empower users while reducing the risk inherent in unmanaged EUCs—all with technology that is familiar and integrated with Microsoft Office.Automating Discovery, Inventory, and Risk AssessmentDiscovery and Risk AssessmentFor many companies, the first challenge in corralling EUCs is finding them. One of the key difficulties presented by EUCs is that they can be stored virtually anywhere—on SharePoint sites, file shares, and even PCs. Many organizations have little insight into the sheer number of EUCs in use, let alone how many versions of each exist, which files are business-critical, and the levels of risk represented by each one. Even for companies with formal rules concerning EUCs, attempting to manually discover, inventory, and manage them consistently can be difficult or impossible, and linked files are often missed.Discovery and Risk Assessment gives companies an easy-to-use, comprehensive way to discover and evaluate EUCs. It scans network shares and SharePoint document libraries automatically or on demand, creating an inventory of files. Each EUC is analyzed and assigned a risk level based on complexity measures and business impact, which can be tailored to the needs of the organization.Discovery and Risk Assessment helps organizations categorize spreadsheets and Access databases based on robust, highly configurable rules that enable the evaluation of materiality, complexity, use, and other company-specific parameters. Spreadsheet content and structure are evaluated, along with linked spreadsheets and queries to external data. The tool uses a template-based approach that helps organizations get started quickly while enabling fine-tuned control for a range of corporate governance needs.In organizations where EUCs are used, management of EUCs is an ongoing process, not a steady state. Discovery and Risk Assessment is designed with this in mind; it can run on a scheduled basis to find, incorporate, and assess spreadsheets and databases created by users day after day.Automating the Spreadsheet and EUC Management Life CycleAudit and Control Management ServerAlong with the ability to maintain a detailed, up-to-date inventory and assessment, organizations need a way to manage the actual content and functionality of EUCs. To accomplish this, once EUCs have been discovered, they can be placed under the control of Audit and Control Management (ACM) Server.By remotely monitoring files on corporate file shares and SharePoint document libraries, ACM Server captures a cell-level audit trail of changes to EUCs. This, in turn, supports change control and versioning. ACM Server is a web-based application that is transparent to users. The administrative user interface of ACM Server is very similar to SharePoint, making it easier for administrators to learn and use.When users update EUCs, ACM Server automatically saves that version of the file and tracks what changes the user has made since the prior version. With ACM Server, an administrator can see, for example, that a formula in a spreadsheet has been modified, who modified it, and what the previous values were. It maintains a version history to enable historical comparisons of EUC versions and the ability to revert files that have been corrupted with errors or unauthorized changes. ACM Server was designed in close partnership with leading tax and audit firms to satisfy mandates for SOX 404, the NAIC Model Audit Rule, OCC, FSA, Solvency II, Basel II, and MiFID. As such, the application supports all recommended controls including change control, access control, version control, analytics, backup and archiving, security and data integrity, and segregation of duties. The result is that your mission-critical EUCs are managed with the highest level of integrity and trust throughout their life cycle.With ACM Server, organizations can greatly reduce the complexity of managing EUCs and detect errors or fraud before they cause financial losses. In tandem with Discovery and Risk Assessment, they can greatly reduce the time and expense associated with audits.Accelerating EUC Review and ApprovalSpreadsheet Compare and Database CompareServer-based discovery, auditing, and change management tools empower administrators and compliance officers to manage EUCs across the organization. Users need ways to ensure the quality and consistency of the EUCs they rely on. Manually tracking and managing changes to shared EUCs can be difficult and time consuming. With more-complex EUCs, even the most diligent manual comparison can easily miss a change that has significant consequences for the organization. Spreadsheet Compare and Database Compare are fast, feature-rich, easy-to-use applications that give users instant and comprehensive insight into the differences between EUC versions.Spreadsheet Compare and Access Database Compare are standalone applications that come with Office Professional Plus 2013 or Office 365 ProPlus. Spreadsheet Compare can be accessed through the “Inquire” add-in in Excel. Both applications enable users to graphically compare two files. For spreadsheets, these include formulas, errors, calculated values, links, data connections, structural changes, formatting, and names. For Access databases, changes highlighted include tables, queries, modules, macros, reports, pages, and forms. Spreadsheet Compare automatically detects when rows and/or columns have been inserted or deleted and realigns rows for more-efficient comparisons. Both applications enable line-by-line comparisons of macros and VBA code. Comparison results can be exported to Excel for reporting or further analysis.Automating Diagnostics, Error Checking, and OptimizationSpreadsheet InquireOrganizations relying on spreadsheets for financial calculations, business analysis, and other mission-critical tasks need to know that their models are error-free. Spreadsheet Inquire, included with Office 2013 Professional Plus and Office 365 ProPlus, enables users to easily perform diagnostics, error checking, and optimization from Office Excel 2013 without specialized expertise. The tool can analyze workbooks, cells, and cell dependencies. Over 40 diagnostics are included such as formula errors, inconsistent formulas, invisible cells, hidden rows and columns, very hidden worksheets (hidden by macros), formulas referencing hidden or blank cells, formulas returning text, duplicate formulas, cells with conditional formatting or validation logic, warnings, and more. The results of such an analysis can be documented in a separate workbook and submitted with comments by end users. Whether analyzing existing spreadsheets or creating new ones, Spreadsheet Inquire helps users build quality into the models they rely on for important business functions. Complete EUC Risk Management with the new OfficeEUCs are a crucial part of a wide range of business activities, yet if unmanaged, they create significant financial, operational, legal, and compliance risk. Now, Microsoft offers a comprehensive suite of tools for discovering, managing, auditing, and validating EUCs. Organizations can get the full power of EUCs while minimizing enterprise risk. Users are empowered to implement robust quality assurance procedures, while administrators get company-wide visibility and control. Whether a company is beginning to get a handle on EUCs or wants to move from a third-party solution to one that is integrated with Microsoft Office, these new tools will help reduce costs, streamline business processes, and minimize business risks.Businesses face mounting compliance challenges given increasing volumes of data, rapidly advancing technology, and ever-more-stringent regulations. That is why powerful, easy-to-use compliance tools are built into the new Office—and EUC controls are only part of the story. For example, SharePoint now supports robust enterprise content management as well as unified eDiscovery across SharePoint, Exchange, and Lync from a web-based console. Exchange offers immutable, in-place archiving that helps organizations simultaneously reduce the cost and complexity of managing archives while improving experiences for IT and users. Together, these and other capabilities of the new Office help organizations meet today’s compliance challenges with tools that work together seamlessly and help everyone in an organization manage risk.How to Get ItTool Installed on server Part of OfficeProfessional Plus 2013NotesDiscovery and RiskAssessmentXRequires ACM ServerACM ServerX Additional SharePoint ECAL license required. Runs on a stand-alone serverSpreadsheetCompareX Standalone application also accessible via Inquire tab in Excel 2013 (when enabled) as “Compare file s”Database CompareXStandalone applicationSpreadsheet InquireX Accessible via Excel 2013 add-in enabled in Excel Options menu。
2012年全国计算机等级考试大纲汇总
二、程序设计基础1. 程序设计方法与风格。
2. 结构化程序设计。
3. 面向对象白勺程序设计方法，对象，方法，属性及继承与多态性。
三、软件工程基础1. 软件工程基本概念，软件生命周戎概念，软件工具与软件开发环境。
2. 结构化分析方法，数据流图，数据字典，软件需求规格说明书。
3. 结构化设计方法，总体设计与详细设计。
4. 软件测试白勺方法，白盒测试与黑盒测试，测试用例设计，软件测试白勺实施，单元测试、集成测试和系统测试。
5. 程序白勺调试，静态调试与动态调试。
四、数据库设计基础1. 数据库白勺基本概念：数据库，数据库管理系统，数据库系统。
2. 数据模型，实体联系模型及E-R图，从E-R图导出关系数据模型。
3. 关系代数运算，包括集合运算及选择、投影、连接运算，数据库规范化理论。
4. 数据库设计方法和步骤：需求分析、概念设计、逻辑设计和物理设计白勺相关策略。
考试方式1、公共基础白勺考试方式为笔试，与C语言(VisualBASIC、Visual FoxPro、Java、Ac cess、Visual C++)白勺笔试部分合为一张试卷。
公共基础部分占全卷白勺30分。
2、公共基础知识有10道选择题和5道填空题。
《C语言程序设计》◆基本要求1.熟悉 Visual C++ 6.0 集成开发环境。
2.掌握结构化程序设计白勺方法，具有良好白勺程序设计风格。
3.掌握程序设计中简单白勺数据结构和算法并能阅读简单白勺程序。
4.在 Visual C++ 6.0 集成环境下，能够编写简单白勺C程序，并具有基本白勺纠错和调试程序白勺能力◆考试内容一、C语言程序白勺结构1.程序白勺构成，main函数和其他函数。
2.头文件，数据说明，函数白勺开始和结束标志以及程序中白勺注释。
3.源程序白勺书写格式。
4.C语言白勺风格。
二、数据类型及其运算1.C白勺数据类型（基本类型，构造类型，指针类型，无值类型）及其定义方法。
2.C运算符白勺种类、运算优先级和结合性。
- 1、下载文档前请自行甄别文档内容的完整性，平台不提供额外的编辑、内容补充、找答案等附加服务。
- 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
- 3、如文档侵犯您的权益，请联系客服反馈,我们会尽快为您处理(人工客服工作时间：9:00-18:30)。
2012信息技术考试外围软件配置标准说明文件
1.1软件运行环境要求及优化调试
1.1.1考试客户端操作系统设置要求
1.1.2考试客户端被考查软件版本要求
客户端软件说明如下：
1、office2003软件安装过程说明如下
密码匙：GWH28-DGCMP-P6RC4-6J4MT-3HFDY
请选择“完全安装”选项。
出现上面画面选择内容都不要选。
2、IE6.0安装过程中如果出现下列界面
说明操作系统中已经安装了该软件，或者安装的版本比较高。
3、ACDSEE 10安装过程中出现下面界面，应该选择“完全安装”，不要采用默认选项。
出现下面界面:选择不安装谷歌输入法
4.搜狗输入法容易引起考试程序崩溃，建议不用搜狗输入法，改用QQ拼音。
5、暴风影音安装过程中将以下界面的复选项全部去掉
1.1.3考试客户端对于系统产生的影响。