四川理工学院专升本
- 格式:doc
- 大小:33.00 KB
- 文档页数:5
四川理工学院15年真题16. I haven't seen Ann for _____ long that I've forgotten what she looks like.A. suchB. veryC. soD. too17. I will buy the book_____ it costs.A. howeverB. whateverC. wheneverD. wherever18. _____ at the city, a car picked him up to an unknown place.A. while arrivingB. Having arrivedC. On its arrivalD. When he arrived19.Two ships were barely _____ on the horizon.A. sensibleB. passableC. visibleD. available20. We are getting excited and looking forward to_____ the new movie and the movie stars.A. seeB. be seeingC. seeingD. having seen21. A man cannot smile like a child, _____a child smiles with his eyes, while a man smiles with his lips alone.A. soB. butC. andD. for22. My father _____ an invitation to a dinner party, but he _____ it.A. accepted… receivedB. received…acceptedC. received… didn’t acceptD. accepted… didn’t receive23. We’ll have a picnic in the park this Sunday _____ its rains or it’s very old.A. sinceB. ifC. untilD. unless24. Ten years ago the population of our village was_____ that of theirs.A. as twice large asB. twice as large asC. twice as much asD. as twice much as25. It was _____ he saw the doctor coming out of the emergency room with an expression as grave as a judge_____ he realized the seriousness of his wife’s illness.A.not until…thatB.after…whenC.until…thenD.before…that26. The open-air celebration has been put off _____ the bad weather.A. in case ofB. in spite ofC. instead ofD. because of27. It _____ that 200 people died and over 5,000 lost their shelters after the floodA.reportedB.reportsC.has been reportedD.has reported28.The moment I got home,I found I_____ my jacket on the playground.A.had leftB.leftC.have leftD.was leaving29. You will be criticized _____ you get that crazy idea out of your mind.A. ifB. unlessC. supposingD. so far as30. Many things _____ impossible in the past are quite common today.A. to considerB. being consideredC. consideringD. considered31. I tried to convey in my speech how _____ we all were for his help.A. regretfulB. respectfulC. hopefulD. grateful32. The brain is too _____ and complex for that sort of treatment.A. sensateB. sensationalC. sensitiveD. sensible33. In order to _____ a good knowledge of English, he gave up his job and went to study in an English school.A. acquireB. RequireC. inquireD. inquest34.His nationality is not ____ to whether he is a good lawyer.A. reluctantB.restrictedC. resultantD. relevant35. When we met for the first time, Peter didn’t _____me much.A. impressB. oppressC. possessD. progressSection 3 Reading Comprehension 40%Passage oneResearchers have found that REM(rapid eye movement) sleep is important to human beings. This type of sleep generally occurs four or five times during one night of sleep, lasting five minutes to forty minutes for each occurrence. The deeper a person’s sleep becomes,the longer the periods of rapid eye movement.There are physical changes in the body to show that a person has changed from NREM(non-rapid eye movement.to REM sleep. Breathing becomes faster,the heart rate increases,and,as the name implies,the eyes begin to move quickly. Accompanying these physical changes in the body is a very important characteristic of REM sleep. It is during REM sleep that a person dreams.36.According to the passage,how often does REM sleep occur in one night?A. OnceB. TwiceC. Four or five timesD.Forty times37. The word “deeper” in paragraph 1 is closes t in meaning to which of the following?A. HeavierB. LouderC. StrongerD. Happier38. Which of the following shows that a person is NOT dreaming in his sleep?A. His eyes begin to move.B. His breathing becomes faster.C. His heart rate increases.D. His eyes stop moving.39. The subject of this passage is.A. why people sleepB. the human need for REM sleepC. the characteristics of REM sleepD. physical changes in the human body40. Which of the following is the best title of the article?A. REM SleepB. Two Types of SleepC. SleepersD. What Happens to Sleepers Passage TwoPersons who are overweight should watch their diet carefully in order to lose pounds. The, best way to do this is to start a weight control program. At first it is wise to talk with your doctor. He can advise you of the number of calories(卡路里). you should have in your meals each day. He can tell you about exercising while on your diet. A good rule is to lose slowly. A loss of a pound or two is plenty.Plan meals around foods you know. This means that it is wise to include foods that you are used to and that are part of your regular eating habits. When you have lost the weight you wish, simple items can be added to your diet so that you can maintain the weight you want. While you are dieting, try to build a pattern of eating that you can followlater to maintain your desired weight.When dieting, choose low-calorie foods. Avoid such items as fats, fried food, sweets, cakes, cream and soft drinks. Try to take coffee and tea without sugar or cream. Snacks can be part of your diet. For example, a piece of fruit or a simple dessert save d from mealtime can be eaten between meals.Keep busy! This way you will not be tempted to go off the diet. Make full use of opportunities to exercise. Try walking instead of riding whenever possible. Happy dieting!41. What is the main idea of the passage?A. How to diet.B. Why we should diet.C. What we should diet.D. Where we should diet.42. While dieting you should ________.A. choose fried foodsB. choose low-calorie foodC. choose snack as hamburger in McDonaldsD. talk to your doctor43. When you have lost the weight you wish, you can ________.A. have some more simple items in your dietB. eat more and more foods you likeC. stop dietingD. tell the doctor what you've done44. According to the passage, which of the following statements is NOT true?A. While dieting, you should ask the doctor so that you can lose your weight quickly.B. Plan meals means to have some foods you like and take them as your daily eating habits.C. When you have lost your weight, you can have some coffee and tea without sugaror cream.D. As you are dieting, don't forget exercise.45. If you want to start a weight control program, you should ________.A. ask your doctorB. plan meals and choose low-calorie foodsC. do some exerciseD. all of the abovePassage ThreeIn the old days, divers used to go down into the sea looking for ships that had sunk,because they hoped to find gold and jewels.Now divers still search for valuable things in sunken ships,but they also try to bring to the surface the ships themselves,or parts of them.The value of different kinds of metals has increased greatly over the last twenty or thirty years and even though a ship has been under the sea for many years,it may be worth a great deal.One famous sunken ship is the “Lusitania”,which sank off the southern coast of Ireland in 1915 with a loss of nearly 1,500 lives.It has four huge propellers made of an expensive metal.Today each of those propellers is worth $300,000 or more.The ship,lying on the sea-bed has been bought by a man called John Light.He paid about $1,200,000 for the whole ship.He hopes to bring up those propellers and sell them.He also hopes to sell other parts of the ship,when he has brought them to the surface,for about $ 600,000.46.Divers today try to bring to the surface _____.A.gold and jewelsB.parts of shipsC.whole shipsD.all of the above47.Diver try to bring up metals because_____.A.they have been in the sea for a long timeB.gold and jewels are not valuable thingsC.some kinds of metals are worth a lot of money todayD.it is easy to bring up metals48.The word “surface” in the passage m eans the _____.A.marketB.airC.top of a liquidD.sea49.John Light hopes that he may be able to sell all the parts of the “Lusitania” for about _____.A.$12,000B.$300,000C.$1,200,000D.$1,800,00050.John Light bought the “Lusitania” _____.A.before 1915B.before it sankC.after it sankD.after he had brought up the propellersPassage FourEnglish is the official language of the United Kingdom and its first language of the vast majority of its citizens. The use of language is extremely important to Britain’s class structure.Some educated English people. Regardless of their class origin, strive to free themselves of regional or local accents(口音) in order to sound like educated English-speaking people. Some people in England regard regional accents and slang as substandard. On the other hand many local people, such as Cockneys in East Londonand people in northern England, enjoy their particular way of speaking, regarding it as warmer and friendlier than standardEnglish.Scottish people appreciate the Scottish accent so much they insist the BBC carry programs with Scottish-accented speakers. The Celtic language, an ancient tongue, continues to be spoken in Scottish-accented speakers in Scotland by some people, usually those in the more remote areas of the country. Approximately 80,000 Scots speak Scottish Gaelic, a type of Celtic language. English is the main language in Northern Ireland, although at least some of the Roma Catholic minority speak Irish, another Gaelic dialect, as a second language.The ancient Celtic language of Wales is strongly tied to the cultural nationalism of the region. At the time of the 1991 census(人口调查),about 20 percent of the Welsh population could speak Welsh. Welsh isspoken in northern and western Wales much more than in southern Wales, where many English people have relocated. Many schools in Wales offer bilingual education, and there is a Welsh-language television channel. In in 1993, after long and considerable struggle by Welsh nationalists, the gover nment made Welsh a joint official language with English in Wales for use in the courts, the civil service, and other aspects of the government department.51. According to the passage, which of the following sentence is NOT true?A. English is the official language of the United Kingdom.B. English is spoken by the vast majority of world citizens.C. the use of language is extremely important to Britain’s class structure.D. Some educated English people, regardless of their class origin, strive to freethemselves of regional or local accents in order to sound like educated English-speaking people.52. “Some people in England regard regional accents and slang as substandard.”“substandard” means _____.A. not as good as the averageB. low standardC. low social statusD. acceptable53. Scottish people appreciate the Scottish accent so much that they insist _____.A. the BBC carry programs with ScottishB. the BBC carry programs withScottish speakersC. the BBC carry programs with non-Scottish-accented speakersD. the BBC carry programs withspeakers whose pronunciation is Scottish dialect54. At the time of the 1991, if the Welsh is 10 million, how many Welsh population could speak Welsh?A. 10 millionB. 1 millionC. 2 millionD. 0.2 million55. What does “bilingual education” probably mean?A. Many schools in Wales offer education in English and French.B. Many school in Wales offer education in English and Scottish.C. Many school in Wales offer education in English and Welsh.D. Many school in Wales offer education in English and Irish.Section 4 Close 10%Directions: For each bland in the following passage, there are four choices given belowand marked A, B, C and D. Choose the one that is most suitable and mark your answer by blackening the corresponding letter on the Answer Sheet.Robert Edwards was blinded in a traffic accident. He was also a little deaf _56_ old age. Last week, he was taking a walk near his home when a thunderstorm came. He hid _57_ the storm under a big tree and was struck by lightning. He was knocked _58_ the ground and woke up some 20 minutes _59_, lying face down in water in water below a tree. He went into the house and lay down in bed. A short time later, he awoke; his legs felt _60_ and he was trembling, but, when he opened his eyes, he could see the clock across the room fading in and out in front of him. When his wife entered, he _61_ her for the first time in nine years. Doctors _62_ that he had regained his sight and hearing obviously from the flash of lightning, but they were unable to explain that. The only _63_ explanation offered by one doctor was that, _64_ Edwards lost his sight as a result of trauma in a terrible accident, perhaps the only way it could be restored was by _65_ trauma.56. A. because B. because of C. as D. since57. A. from B. away C. against D. contrary58. A. at B. in C. to D. on59. A. dying B. dead C. die D. being died60. A. saw B. watched C. noticed D. examined61. A. say B. thought over C. made sure D. agreed to62. A. possibly B. possible C. probably D. mainly63. A. although B. because of C. even though D. since64. A. others B. other C. another D. one otherSection 5 Translation 10%66. This type of sleep generally occurs four or five times during one night of sleep, lasting five minutes to forty minutes for each occurrence.(Passage 1)67. Persons who are overweight should watch their diet carefully in order to lose pounds.(Passage 2)68. Now divers still search for valuable things in sunken ships,but they also try to bring to the surface the ships themselves,or parts of them.(Passage 3)69.Some educated English people. Regardless of their class origin, strive to free themselves of regional or local accents(口音) in order to sound like educated English-speaking people.(Passage 4)Section 6 Writing 15%Directions: In this section, you are required to write a composition on the topic Online Shopping. You should write at least 100 words and base your composition on the outline (given Chinese)below.1.现在网上购物已经成为一种时尚;2.网上购物有很多好处,但也有不少问题;3.我的建议。
四川理工学院成人教育学院
佚名
【期刊名称】《继续教育》
【年(卷),期】2006(20)4
【摘要】四川理工学院是一所以工学、理学为主,管理学、文学、经济学、法学、教育学协调发展的理工结合、文理渗透、多层次发展的全日制多科性普通本科高校,是经教育部批准的学士学位和硕士学位授予单位。
【总页数】1页(PF0004-F0004)
【关键词】成人教育学院;四川理工学院;多层次发展;理工结合;协调发展;文理渗透;
本科高校;学位授予;学士学位;管理学
【正文语种】中文
【中图分类】G724
【相关文献】
1.成人高等教育《大学英语》重点课程建设的实践和思考——以东莞理工学院成人教育学院为例 [J], 黄为
2.<四川理工学院学报(自然科学版)>期刊变更启事/四川理工学院学报(自然科学版)投稿须知 [J],
3.东华理工学院职业技术学院成人教育学院 [J],
4.四川大学成人教育学院 [J],
5.四川省人民政府授予四川理工学院四川省高新技术产业示范科研单位 [J],
因版权原因,仅展示原文概要,查看原文内容请购买。
专升本学生思想政治工作创新探讨———就四川某高校会计学08级本科为例沈文婷张婉娟(四川自贡四川理工学院643000)摘要:自我国开始实行“专升本”制度以来,我国大学生中通过专升本进入本科院校中的学生数量已达一定规模。
本文从思想政治教育工作者的角度,以四川某高校会计学08级本科专升本班级为例,对专升本学生的共同特点进行分析,并提出工作创新对策:做好专升本学生的适应性教育,提供学业帮助,解决心理问题,做好职业规划。
关键词:专升本思想政治教育自九十年代以来,我国开始实施通过正规考试从普通专科学校在校生中选拔优秀学生进入本科阶段学习,俗称为“专升本”的模式。
[1]这也成为目前高职专科院校学生的就业途径之一。
这种人才培养模式的产生不仅促进了我国高等教育的发展,也打破了一考定终身的制度,给予了高考失利的学生新的机会。
[5]自高校扩招以来,高校“专升本”学生数量急速增长。
以笔者工作的四川某高校为例,现有的08级会计专业共九个班级,而全部由专升本学生组成的班级就有四个,基本占全专业总人数的一半。
专升本学生在升入本科院校以后,一方面由于不适应本科阶段的生活、学习各方面情况,容易出现一些思想问题;另一方面,很多本科院校并没有专门为“专升本”学生制定培养方案,而是沿袭普通本科的培养目标和课程设置。
这在一定程度上忽视了“专升本”学生的教育背景和适应程度,必然会出现新的问题。
[4]本文从学生工作的角度,对“专升本”学生的特点予以分析,针对专升本学生容易出现的问题提出解决方案。
一、专升本学生特点分析作为已完成专科阶段学习的“专升本”学生,他们在诸多方面都体现出与普通本科学生的特殊性。
第一,专升本学生的适应困难。
专升本学生一般升入本科院校仅呆两年时间,可称为短学制,这就是明显与普通本科学生的区别。
正如笔者与一位专升本学生访谈时,他谈到升本后自己的心路历程:以一名新生的身份进入,但其实已是大学的“老”人。
两年的短学制生活给人的感觉是屁股没坐热就要走了,因此很多专升本人都不能融入或者说是不想融入新的生活。
四川理工学院“专升本”选拔考核办法(修订)根据四川省教育厅“专升本”工作有关文件精神,结合我校实际,特制定“专升本”选拔考核办法。
一、专升本选拔基本条件(一)在校期间政治思想表现优秀,未受到任何纪律处分。
(二)学习成绩优秀。
(三)身心健康。
同时符合以上三项条件的应届专科毕业学生方可申请参加“专升本”选拔考试。
二、专升本选拔程序(一)免试推荐。
对高职(专科)学生(含新生保留入学资格)应征入伍服义务兵役,在服兵役期间荣立三等功及以上奖励身心健康的学生,按照国家有关文件精神实行免试录取。
正式录取前在学校张榜公示无异议后,上报四川省教育厅高教处审批,经省教育厅审核同意后,升入本科相同或相近专业三年级学习。
(二)考试选拔1.应届专科毕业学生(免试推荐除外)申请专升本,必须参加我校组织的“专升本”考试。
凡符合选拔条件的学生由学生所在学校负责审核,经审查合格后按要求将参加“专升本”考试的考生名单报四川理工学院教务处。
同时,各学校将按第4条计算的专科阶段成绩(占30%部分)和符合第3条奖励加分的结果(相关材料由各学校负责审查并报送四川理工学院教务处备查),在本学校公示无异议后,报四川理工学院教务处。
2.专升本考试科目及时间安排3.奖励加分办法(1)在校期间获得市、州以上人民政府奖励的应届专科毕业生给予奖励分4分;毕业时获得“四川省普通高等学校优秀毕业生”荣誉特别优秀的奖励4分;以上两者同时获得者,不重复计算。
(2)凡符合选拔基本条件的专科生在校期间,在数学建模竞赛、电子设计竞赛中获奖,或CET-4(英语、日语专业学生CET-6)合格、国家或省计算机二级证书获得者(非计算机专业),按下表分值给予奖励加分,同时获该类别多种奖励加分条件者,只按最高一类加分,不重复计算。
4.专科阶段成绩的计算专科阶段成绩的计算方法是:计算各门必修课程(实行学分制的)或考试课程(实行学年制的)的成绩之总和(采用等级计分的课程,按如下方法折算:①五级计分制,优-90分,良-80分、中-70分,及格-60分;②四级计分制,优-90分,良-75分,及格-60;③两级计分制,合格-75分),将成绩总和除以计算的课程门数,得到课程平均成绩。
2021年四川理工学院专升本?高等数学?考试题〔理工类〕一、单项选择题〔每题3分,共21分〕1、向量}1,,2{-=λa ,}5,2,{λ=b 的数量积为0,那么=λ〔 〕〔A 〕41 〔B 〕21 〔C 〕43 〔D 〕45 2、设c x x dx x f +=⎰sin )(,那么=)(x f 〔 〕〔A 〕x x sin + 〔B 〕x x cos + 〔C 〕x x x cos sin + 〔D 〕x x x cos sin - 3、函数582+-=x x y 的极小值为〔 〕〔A 〕5 〔B 〕11- 〔C 〕7 〔D 〕44、关于函数)(x f ,以下说法错误的选项是〔 〕〔A 〕假设)(x f 是无穷小量,那么)(x f 是很小很小的数;〔B 〕假设函数在0=x 处可导,那么函数0=x 处连续;〔C 〕假设)0()(lim )(lim 00f x f x f x x ==-→+→,那么)(x f 在0=x 处连续; 〔D 〕假设35)(-=x x f ,那么∞=→)(lim 3x f x 。
5、关于以下收敛性的说法,错误的选项是〔 〕〔A 〕∑∞=131n n 发散 〔B 〕∑∞=181n 发散〔C 〕∑∞=132n n 收敛 〔D 〕∑∞=-11)1(n n n 条件收敛 6、假设A 是三阶矩阵,3=A ,那么=A 2〔 〕〔A 〕3 〔B 〕6 〔C 〕12 〔D 〕247、='⎰)3(02xdt t 〔 〕〔A 〕x 3 〔B 〕x 2 〔C 〕23x 〔D 〕22x二、填空题:〔每题3分,共18分〕1、设函数)(x f 的定义域为)3,1[-,那么)42(x f -的定义域为 。
2、假设xe y 5cos =,那么=''y 。
3、幂级数∑∞=13n n nx 的收敛半径为 ;4、极限)13(lim 2+--+∞→x ax x x 存在,那么=a 。
,要使极限存在,必须使09=-a ,即9=a 。
四川理工学院专升本《计算机专业综合》课程考试大纲第一部分 考试说明一、考试性质《C语言程序设计》、《数据结构》、《微机原理与接口技术》是计算机各专业的专业基础课。
它能够反映计算机科学技术各专业学生具有的基本的专业理论基础及程序设计能力,以利于计算机科学与技术各专业择优选拔本科生。
考试对象为参加四川理工学院专升本考试的考生。
二、考试范围具体要求见本考试大纲第二部分的“考查要点”。
三、评价目标注重考查基本概念、基本知识、基本方法,考查学生运用基本知识来分析和解决实际问题的能力,和基本计算机硬件知识、基本算法、基本程序设计的能力。
四、考试形式1. 答卷方式:闭卷,笔试。
2. 考查内容及其考查比例《C语言程序设计》 30分;《数据结构》 40分;《微机原理与接口技术》 30分。
五、教材参考教材:《C语言程序设计教程》(第二版),谭浩强、张基温等,清华大学出版社《数据结构》(C语言版),严蔚敏、吴伟民编著,清华大学出版社《微型计算机原理与接口技术》,李文英,清华大学出版社《微型计算机原理及接口技术》,李伯成,华大学出版社《微型计算机原理及应用》,唐俊杰,高等教育出版社第二部分 考查要点一 《C语言程序设计》部分(30分)一)C语言基础1、C语言的结构C语言的程序构成特点;main函数;C语言中的头文件、函数的组成;C语言源程序的书写格式要求。
2、C语言的数据类型(1)整型数整型数的有十进制、八进制及十六进制;整型数分类、取值范围。
(2)实型数:实型数的十进制数形式和科学计数形式;实型数据长度。
(3)字符型常量字符型常量表示形式、常用字符数字、大写字母和小写字母的ASCII码值;转义字符字符串常量。
(4)符号常量符号常量的定义与使用。
(5)枚举类型枚举类型数据的定义、枚举元素的值。
3、C语言中的运算C语言中常用运算符的优先级与结合性;算术运算符、关系运算符、逻辑运算符、条件运算符、逗号运算符的使用。
二) C语句基本语句、数据的输入输出、顺序结构程序设计表达式语句、空语句、复合语句、goto语句的使用;getchar、putchar函数的使用;格式输出函数printf的使用;格式输入函数scanf的使用;顺序结构程序的编写。
2012年四川理工计算机专升本模拟试题一、单项选择(每小题1分,共40分)1. 微型计算机中的辅助存储器,可以与下列___________部件直接进行数据传送?A.运算器B.内存储器C.控制器D.微处理器2. 微型计算机中使用的人事档案管理系统,属下列计算机应用中的___________。
A.人工智能B.专家系统C.信息管理D.科学计算3. 在计算机网络中,表征数据传输可靠性的指标是___________。
A.误码率B.频带利用率C.信道容量D.传输速率4. 在计算机网络中,表征数据传输有效性的指标是___________。
A.误码率B.频带利用率C.信道容量D.传输速率5. 下列四条叙述中,有错误的一条是___________。
A.两个或两个以上的系统交换信息的能力称为兼容性B.当软件所处环境(硬件/支持软件)发生变化时,这个软件还能发挥原有的功能,则称该软件为兼容软件C.不需调整或仅需少量调整即可用于多种系统的硬件部件,称为兼容硬件D.著名计算机厂家生产的计算机称为兼容机6. 为了指导计算机网络的互联、互通和互*作,ISO颁布了OSI参考模型,其基本结构分为_______。
A.6层B.5层C.7层D.4层7. 下列字符中,ASCII码最小的是________A.KB.aC.hD.H8. 和通信网络相比,计算机网络最本质的功能是________A.数据通信B.资源共享C.提高计算机的可靠性和可用性D.分布式处理9. 调制解调器(Modem)的功能是实现________A.模拟信号与数字信号的转换B.数字信号的编码C.模拟信号的放大D.数字信号的整形10. 局域网组网完成后,决定网络使用性能的关键是________A.网络的拓扑结构B.网络的通信协议C.网络的传输介质D.网络的*作系统11. 网卡(网络适配器)的主要功能不包括________A.将计算机连接到通信介质上B.进行电信号匹配C.实现数据传输D.网络互连12. 微处理器处理的数据基本单位为字。
四川理工学院专升本
《大学计算机基础》考试大纲
一、总体要求
要求考生掌握必备的计算机基础知识和应用能力,掌握计算机的基本操作和使用方法,并为以后的计算机课程学习打下必要的计算机知识基础。
具体要求为:
1.了解并掌握计算机的发展史、分类、特点、应用和发展趋势等基础知识。
2.了解并掌握数据与信息的概念、常用进位计数制及转换、计算机编码技术和计算机处理汉字的基本过程。
3.了解并掌握计算机工作原理、计算机软硬件系统的组成及主要技术指标。
4.了解并掌握多媒体技术的概念与应用。
5.了解并掌握计算机病毒的特征、分类与防治。
6. 了解并掌握计算机网络的概念、组成和分类;计算机与网络信息安全的概念和防控;因特网的基本概念、原理和应用。
7.了解并掌握操作系统的基本概念、分类、常见的操作系统和操作系统的主要管理功能;掌握Windows 7的基础知识、文件及文件夹的基本概念、磁盘管理和程序管理。
8.了解并掌握文字处理的基础知识、在Word 2010 中创建并编辑文档、Word 2010 的高级编辑与排版、长文档的编辑与管理、文档修订与共享和邮件
合并;
9.了解并掌握Excel 2010 的制表基础知识、工作簿与多工作表操作、Excel 2010 中公式和常用函数的使用、在Excel2010 中创建和编辑图表、Excel2010 的数据分析与处理。
10.了解并掌握PowerPoint 2010 制作演示文稿的基础知识、在PowerPoint 2010 中演示文稿的高级制作操作、演示文稿的交互和优化、放映与共享演示文稿。
二、考试用时
考试用时:120分钟。
三、考题范围
(一)计算机基础知识
1.计算机的发展史,计算机的特点,计算机的分类、计算机的用途及应用(电子商务、大数据、移动互联网等),未来计算机的发展趋势。
2.计算机信息技术基础:数据与信息概念,信息的单位,常用进位计数制(2进制、8进制、16进制、10进制)及相互转换,计算机内部采用二进制的原因,计算机中数的编码和字符的编码;汉字编码(区位码、国标码、汉字内码)及计算机处理汉字的基本过程。
3.计算机硬件系统:运算器、控制器、存储器(内存、外存),计算机结构(冯•诺依曼型计算机的特点;计算机指令类型及结构概念)。
4.计算机软件系统:软件概念、软件系统及其组成;操作系统的概念、分类、五大管理、及常见的操作系统。
(二)计算机网络基础、因特网基础及应用
1.计算机网络的基本概念:计算机网络与数据通信、计算机网络的分类、网络拓扑结构、网络硬件、网络软件、无线局域网。
2.因特网基础:因特网的起源与发展,TCP/IP 协议,因特网IP 地址和域名系统,接入因特网的方法。
3.因特网的简单应用:因特网的基本概念(万维网、超文本和超链接、统一资源定位器、浏览器、FTP文件传输协议),IE的使用(包括网页的保存和
收藏夹的使用),电子邮件的使用(包括电子邮件的格式)。
(三)多媒体、病毒及其防治
1.多媒体技术基础:多媒体的特征,媒体的数字化技术,多媒体数据压缩。
2.计算机病毒及其防治:计算机病毒的特征和分类,计算机病毒的预防。
(四)操作系统
1.操作系统基础:常见的操作系统,操作系统的管理功能:进程管理、存储管理、设备管理、文件管理、用户界面。
2.Windows 7 的基础知识和基本操作;文件及文件夹管理的基本概念,“计算机”和“库”的使用;Windows 7的磁盘管理和磁盘格式化、修改磁盘卷标方法;Windows的程序管理,任务管理器的监控功能;控制面板的基本操作方法;Windows的系统维护与其它常用附件;常用的Windows命令和DOS 命令的功能。
(五)Word 2010及其高级应用
1.创建并编辑文档:创建空白的新文档、利用模板创建新文档,输入并编辑文本,查找与替换文本,保存与打印。
2.文档的高级编辑与排版:设置文档格式:字符格式、段落格式、主题,设置页面布局:页边距、纸张大小和方向、页面背景、文档网格,在文档中应
用表格:文本转换为表格、表格简单排序和公式使用,设置和使用图片和图形:设置图片格式、绘制图形、使用SmartArt图形、设置文字环绕方式、设置
图片在页面上的位置,在文档中插入其他内容:自定义文档部件、文件框的使用、使用文档封面、插入艺术字、首字下沉、插入图表。
3.长文档的编辑与管理:在文档中定义并使用样式,文档分页、分节与分栏,文档中设置和使用页眉、页脚与页码,项目符号与编号的使用文档中引用的使用,文档目录的使用。
4.文档修订与共享:开启修订状态、设置修订标志与选项、添加批注,拼写与语法检查、快速比较文档、合并文档、通过电子邮件共享文档、转换成PDF 文档。
5.邮件合并:使用邮件合并制作邀请函和信封,邮件合并规则的使用。
(五)Excel及其高级应用
1.Excel 制表基础:输入简单数据、自动填充数据、控制数据的有效性,对表格进行基本整理和修饰,设置工作表边框和底纹,自动套用预置样式,设定与使用主题,条件格式,工作表的打印输出。
2.工作簿与多工作表操作:基于模板创建工作簿、工作簿打开权限密码的设置,工作簿的隐藏与保护,工作表基本操作,工作表的保护,同时对多张工作表进行操作,工作窗口的视图控制。
3.Excel 公式和函数:公式中绝对引用和相对引用的使用,名称的定义与引用,Excel中函数的应用:SUM、AVERAGE、MAX、MIN、ROUND、
LEFT、RIGHT 等简单函数,条件求和SUMIF 函数、多条件求和SUMIFS 函数、向下取整函数INT函数、取整函数TRUNC函数、ROUND四舍五入函数、垂直查询函数VLOOKUP、IF函数、AVERAGEIF函数、多条件平均值函数AVERAGEIFS、COUNTA函数、COUNTIF函数多条件计数函数、COUNTIFS、RANK 函数、文本合并函数CONCATENATE、MID 函数、删除空格函数TRIM、AND函数、WEEKDAY函数。
4.在Excel 中创建图表:创建并编辑迷你图,创建、修饰与编辑图表,打印图表。
5.Excel 数据分析与处理:合并计算,数据排序,自动筛选、高级筛选,分类汇总,数据透视表和透视图。
(六)PowerPoint 2010制作演示文稿
1.创建演示文稿:依据主题创建、基于模板创建、根据现有演示文稿创建、从Word文档中创建。
2.幻灯片基本操作:设置幻灯片大小、设置幻灯片方向,选择幻灯片、向幻灯片添加内容,添加幻灯片编号、添加日期和时间,演示文稿视图。
3.演示文稿的高级制作操作:幻灯片版式的应用,编辑文本内容,插入图形和图片、使用SmartArt智能图形,应用设计主题、变换背景,幻灯片母板应用。
4.演示文稿的交互和优化:使用音频和视频,添加动画效果,设置幻灯片切换效果,幻灯片的链接跳转。
5.放映与共享演示文稿:应用排练计时,幻灯片放映控制,自定义放映方式,将演示文稿发布为视频文件、转换为直接放映格式,创建并打印演示文稿讲义。