按照评价功能的不同，教学评价可分为哪些种类

1、诊断性评价 诊断性评价是指在教学活动开始前，对评价对象的学习准备程度做出鉴定，以便采取相应措施使教学计划顺利、有效实施而进行的测定性评价。诊断性评价的实施时间，一般在课程、学期、学年开始或教学过程中需要的时候。其作用主要有二：确定学生的学习准备程度。适当安置学生。 2、形成性评价 形成性评价是在教学过程中，为调节和完善教学活动，保证教学目标得以实现而进行的确定学生学习成果的评价。形成性评价的主要目的是改进、完善教学过程，步骤是： ①确定形成性学习单元的目标和内容，分析其包含要点和各要点的层次关系。 ②实施形成性测试。测试包括所测单元的所有重点，测试进行后教师要及时分析结果，同学生一起改进、巩固教学。 ③实施平行性测试。其目的是对学生所学知识加以复习巩固，确保掌握并为后期学习奠定基础。 3、总结性评价 总结性评价是以预先设定的教学目标为基准，对评价对象达成目标的程度即教学效果做出评价。总结性评价注重考察学生掌握某门学科的整体程度，概括水平较高，测验内容范围较广，常在学期中或学期末进行，次数较少。 按评价所参照的标准划分：目标参照评价 常模参照评价。 根据评价所运用的方法和标准不同，可分为：相对性评价和绝对性评价。  4、相对性评价 相对评价法是从评价对象集合中选取一个或若干个对象作为基准，将余者与基准做比较，排出名次、比较优劣的评价法。相对评价法便于学生在相互比较中判断自己的位置，激发竞争意识。 5、绝对性评价 绝对评价法是在被评价对象的集合以外确定一个客观标准，将评价对象与这一客观标准相比较，以判断其达到程度的评价方法。 绝对评价设定评价对象以外的客观标准，考察教学目标是否达成，可以促使学生有的放矢，主动学习，并根据评价结果及时发现差距，调整自我，具有明显的教育意义。 发展趋势 首先，在评价主体上，更加强调学生的自评。 其次，在评价功能上，更加注重发挥评价的教育功能。 再次，在评价类型上，更加重视实施形成性评价。 最后，在评价方法上，更多采用相对评价法。 扩展资料 评价意义 课堂教学评价的目的不仅仅是对教师的课堂教学进行评价，相反，它更是激励教师有目的性、有针对性地不断学习、改进、提高的过程。简要地说，开展课堂教学评价具有如下重要作用。 1、课堂教学评价具有导向功能，能够促进课堂教学改革 课堂教学评价体系的建立和实施，可以充分发挥评价的导向作用，促进教师尽快转变教育思想，在课堂教学中更好地发挥教师的教育创新意识，达到改进课堂教学的目的。 评价体系的建立，意味着对课堂教学中与教和学相关的各种因素的选择和侧重点不一样，这些不一样的地方将促使教师在今后的课堂教学中，更加注重评价所侧重的各种相关因素，并将其作为课堂教学中展示和发挥的重点，发挥评价的导向功能。 2、课堂教学评价具有激励功能，可以加强教师之间的相互交流 课堂教学评价能够有效地评析教师课堂教学的状况和优缺点，只有让教师了解了自己在课堂教学实践中的优点、亮点、特点和弱点，才能找到今后努力发展的基点和方向。 课堂教学评价正是教师了解自己教学情况的一条关键途径。同时，课堂教学评价还可以使教师在相互之间的听课、评课活动中增进了解，互相学习，在听课、评课的交流中激发内在的需要和动力。 3、课堂教学评价是促进教师专业发展的重要途径 对于教师而言，课堂教学水平和能力是教师立足的基点，如何有效提高教师的教学水平与能力是教师教育最重要的课题之一。我们的课堂教学评价正好可以为广大的教师提供一个科学了解自身教学状况的窗口，使其明了自己教学中存在的不足和今后努力的方向，为教师的专业发展提供一个很好的平台。 针对新课程改革实施过程中存在的教师的适应性问题而言，课堂教学评价特别是发展性的课堂教学评价，正是保证新课程顺利实施，促进教师专业发展的重要方法。 4、课堂教学评价具有决策和鉴定功能，是学校管理工作的重要组成部分 课堂教学评价是教师工作评价的重要组成部分，也是学校评价体系的核心内容。通过开展科学有效的课堂教学评价，能够有效地鉴定教师的教学态度、教学质量、工作能力、业务水平等，使学校的管理工作更系统化，决策更科学化。 5、课堂教学评价是对一个教师的肯定，是对学生的责任所在 课堂教学评价是对一名教师来说对她工作态度及成绩的肯定，所以，课堂教学评价一定要科学，公平。 参考资料来源：搜狗百科-课堂教学评价 参考资料来源：搜狗百科-教学评价

《试题通》怎么把自己的题库录入进去

1、自助导入-自己按照要求整理为Excel文档，在自己手机内选择文件直接导入到app题库，2、辅助导入-联系客服-发送文档-等待试题上线-自己做题。

大学专业课试题：何谓“以人为中心的管理”？又如何实现“以人为中心的管理”？

这道题目来源于周三多第五版教材第三章《管理的基本原理》的课后习题（P140），主要涉及管理原理中的人本原理。答案要点如下：1.所谓以人为本的管理是指管理活动要围绕人展开，是目的是为了造福人类，促进人的全面发展。人本原理是以人为主体的管理思想，是主要包括下述主要观点：职工是企业的主体；职工参与是有效管理的关键；使人性得到最完美的发展是现代管理的核心；服务于人是管理的根本目的。2.实现以人为主体的管理的途径：①树立以人为本，人是一切的中心的管理理念。在企业中，员工不只是管理的客体，也是管理的主体，企业管理既是对人的管理，也是为人的管理，企业经营的目的，不是单纯的商品的生产，而是为包括企业职工在内的人的社会发展而服务的。②员工参与管理。员工参与管理的形式是多种多样的，但有三种形式应当是最基本的。a.通过职工代表大会选举代表参加企业的最高决策机构——管理委员会或董事会。职工代表在管委会和董事会中应占有一定比例，并享有与其他代表同等的权利和义务；b.由职工代表大会选举代表参加企业的最高监督机构——监事会。职工代表在监事会中应占有较多的名额，与其他监事一样，享有监督企业生产经营活动的职权；c.广泛参加日常生产管理活动（如质量管理、设备管理、成本管理、现场管理等）。由于劳动者最了解自己直接参与的那部分生产经营活动的实际情况，因此在参与日常生产管理活动时应有更大的发言权，并且一定能取得更好的效果。

英美文学选读试题及答案

展开全部

全国2003年4月高等教育自学考试英美文学选读试题[找答案]
作者：未知 文章来源：互联网 点击数：18 更新时间：2005-11-29
全部题目用英文作答，答案写在答题纸相应的位置上。
PART ONE
Ⅰ.Multiple Choice (40 points in all, 1 for each)
Select from the four choices of each item the one that best answers the question or completes the statement. Write the answers on the answer sheet.
1. “For a week after the commission of the impious and profane offence of asking for more, Oliver remained a close prisoner in the dark and solitary room ...”(Dickens, Oliver Twist) What did Oliver ask for?
[A]More time to play. [B]More food to eat.
[C]More book to read. [D]More money to spend.
2. Mrs. Warren’s Profession is one of George Bernard Shaw’s plays. What is Mrs. Warren’s profession then ?
[A]Real estate. [B]Prostitution.
[C]House-keeping. [D]Farming.
3. Dr. Faustus is a play based on the German legend of a magician aspiring for
and finally meeting his tragic end as a result of selling his soul to the Devil.
[A]immortality [B]political
[C]money [D]knowledge
4. The statement “A demanding mother turns away from her husband and gives all her affection to her sons” sums up the main plot of D. H. Lawrence′s .
[A]Lady Chatterley’s Lover [B]Women in love
[C]Sons and Lovers [D]The Plumed Serpent
5.“Come to me－come to me entirely now,” said he ; and added, in his deepest tone, speaking in my ear as his cheek was laid on mine, “Make my happiness－I will make yours.”
The above passage presents a scene in .
[A]Emily Bronte’s Withering Heights
[B]Charlotte Bronte’s Jane Eyre
[C]John Galsworthy′s The Forsyte Saga
[D]Thomas Hardy′s Tess of the D′Urbervilles
6.Which of the following is NOT written by William Butler Yeats?
[A] “Sailing to Byzantium.” [B] “The Lake Isle of Innisfree.”
[C] “Leda and the Swan.” [D] “The Waste Land.”
7. “Drive my dead thought over the universe
Like withered leaves to quicken a new birth.”
(Percy Bysshe Shelley, “Ode to the West Wind”)
What rhetorical device does the poet use in the quoted lines?
[A]Synecdoche. [B]Metaphor.
[C]Simile. [D]Onomatopoeia.
8.Crusoe is the hero in The life and Strange Surprising Adventures of Robinson Grusoe, of York, Mariner (also known as Robinson Crusoe)by .
[A]Jonathan Swift [B]Daniel Defoe
[C]George Eliot [D]D.H.Lawrence
9. “Beauty is truth, truth beauty” is an epigrammatic line by .
[A]John Keats [B]William Blake
[C]William Wordsworth [D]Percy Bysshe Shelley
10.Christoper Marlow’s “The Passionate Shepherd to His Love” is a (n) .
[A]pastoral lyric [B]elegy [C]eulogy [D]epic
11.Which of the following is NOT regarded as one of the characteristics of Renaissance humanism?
[A]Cultivation of the art of this world and this life.
[B]Tolerance of human foibles.
[C]Search for the genuine flavor of ancient culture.
[D]Glorification of religious faith.
12. “In dream vision Arthur witnessed the loveliness of Gloriana, and upon awaking resolves to seek her.” The two literary figures Arthur and Gloriana are form .
[A]Edmund Spenser’s The Faerie Queene
[B]William Shakespeare’s Romeo and Juliet
[C]Christopher Marlowe’s “The Passionate Shepherd to His love”
[D]John Donne’s “A Valediction: Forbidding Mourning”
13.Which of the following best describes the nature of Thomas Hardy’s later works?
[A]Sentimentalism. [B]Tragic sense.
[C]Surrealism. [D]Comic sense.
14. “...This grew: I gave commands;
Then all smiles stopped altogether....”
(Robert Browning, “My Last Duchess”)
The above lines imply that .
[A]the Duchess was killed by her husband
[B]the Duchess stopped smiling at her husband’s order
[C]the Duchess died of laughing too much
[D]the Duchess did not want to smile as much as her husband requested
15.In which of the following works can you find the proper names “Lilliput,” “Brobdingnag,” “Houyhnhnm,” and “Yahoo”?
[A]James Joyce’s Ulsses.
[B]Charles Dickens’s Bleak House.
[C]Jonathan Swift’s Gulliver’s Travels.
[D]D. H. Lawrence’s Women in love.
16.As a literary figure, Belinda appears in Alexander Pope’s .
[A] “The Dunciad” [B] “An Essay on Man”
[C] “An Essay on Criticism” [D] “The Rape of the lock”
17. “The novel is structured around the discovery of the hero’s origin.” This novel is most probably .
[A]Charles Dickens’s David Copperfield
[B]James Joyce’s A Portrait of the Artist as a Young Man
[C]Thomas Hardy’s Far from the Madding Growd
[D]Henry Fielding’s Tom Jones
18. “To wage by force or guile eternal war,
Irreconcilable to our grand Foe.”（John Milton, Paradise lost)
By what means were Satan and his followers to wage this war against God?
[A]By planting a tree of knowledge in the Garden of Eden.
[B]By turning into poisonous snakes to threaten man’s life.
[C]By removing God from His throne.
[D]By corrupting man and woman created by God.
19. “When the evening is spread out against the sky
Like a patient etherized upon a table.”
(T. s. Eliot, “The Love song of J. Alfred Prufrock”)
What does the image in the quoted lines suggest?
[A]Violence. [B]Horror. [C]Inactivity. [D]Indifference.
20.Which of the following is NOT typical of metaphysical poetry best represented by John Donne’s works?
[A]Common speech. [B]Conceit.
[C]Argument. [D]Refined language.
21.William Wordsworth, a romantic poet, advocated all of the following except .
[A]normal contemporary speech patterns
[B]humble and rustic life as subject matter
[C]elegant wording and inflated figures of speech
[D]intensely subjective feeling toward individual experience
22.In Samuel Taylor Coleridge′s “Kubla Khan,” “A sunny pleasure dome with caves of ice” .
[A]refers to the palace where Kubla Khan once lived
[B]vividly describes a building of poor quality
[C]is the gift given to a beautiful girl called Abyssinian
[D]symbolizes the reconciliation of the conscious and the unconscious
23.The hightide of Romanticism in American literature occurred around .
[A]1820 [B]1850 [C]1880 [D]1920
24.The subject matter of Robert Frost’s Poems focuses on .
[A] ordinary country people and scenes
[B]battle scenes of ancient Greek and Roman legends
[C]struggling masses and crowded urban quarters
[D]fantasies and mythical happenings
25.Which group of writers are among those who may be called early pioneers of American literature?
[A]Mark Twain and Henry James.
[B]Fenimore Cooper and Washington lrving.
[C]Ernest Hemingway and William Faulkner
[D]Jack London and O’Henry.
26.To Theodore Dreiser, life is “so sad, so strange, so mysterious and so inexplicable.” No wonder the characters in his books are often subject to the control of the natural forces, especially those of and heredity.
[A]fate [B]morality
[C]social conventions [D]environment
27.Hawthorne generally concerns himself with such issues as in his fiction.
[A]the evil in man’s heart [B]the material pursuit
[C]the racial conflict [D]the social inequality
28. provides the main source of influence on American naturalism.
[A]The puritan heritage
[B]Howells’ ideas of realism
[C]Darwin’s theory of evolution
[D]The pioneer spirit of the wild west
29.In Mark Twain’s The Adventures of huckleberry Finn, Huck writes a letter to inform against Jim, the escaped slave, and then he tears the letter up. This fact reveals that .
[A]Huck has a mixed feeling of love and hate
[B]there is a conflict between society and conscience in Huck
[C]Huck is always an indecisive person
[D]Huck has very little education
30.Which terms can best describe the modernists’ concern of the human situation in their fiction?
[A]Fragmentation and alienation.
[B]Courage and honor.
[C]Tradition and faith.
[D]Poverty and desperation.
31.Whitman’s poems are characterized by all the following features except .
[A]a strict poetic form
[B]a simple and conversational language
[C]a free and natural rhythmic pattern
[D]an easy flow of feelings
32.All his novels reveal that, as time went on, Mark Twain became increasingly .
[A]prolific [B]artistic.
[C]optimistic [D]pessimistic
33.The poem “I like to see it lap the Miles－” is an interesting poem written by Emily Dickinson. What does “it” in the poem stand for?
[A]The hound. [B]The star.
[C]The horse. [D]The train.
34.Which of the following is NOT a typical feature of Henry James’s writing style?
[A] exquisite and elaborate language
[B]minute and detailed descriptions
[C]lengthy psychological analyses
[D]American colloquialism
35.In the beginning paragraph of Chapter 3, The Great Gatsby, Fitzgerald describes a big party by saying that “men and girls came and went like moths.” The author most likely indicates that .
[A]there was a crowd of party-goers
[B]such life does not have real meaning
[C]these people were light-hearted
[D]these were crazy and ignorant characters
36.In Hemingway’s “Indian Camp,” Nick, the main character, witnesses
[A]a tragic killing of the Indians by the white men
[B]real friendship between the white men and the Indians
[C]a senseless killing of each other
[D]terrible scenes of birth and death
37.Which one of the following statements is NOT true of William Faulkner?
[A]He is master of stream-of-consciousness narrative.
[B]His writing is often complex and difficult to understand.
[C]He often depicts slum life in New York and Chicago.
[D]He represents a new group of Southern writers.
38.American “Transcendentalists most typically believe that .
[A]man is divine in name [B]art is superior to life
[C]man can transform nature [D]poetry is the highest form of art
39.By the end of Sister Carrie, Dreiser writes, “It was forever to the pursuit of that radiance of delight which tints the distant hilltops of the world.” Dreiser implies that .
[A]there is a bright future lying ahead
[B]there is no end to man’s desire
[C]one should always be forward-looking
[D]happiness is found in the end
40.We can perhaps describe Emily Grierson in Faulkner’s short story “A Rose for Emily” in all the following ways except that .
[A]she is psychologically deformed
[B]she is wicked and morally corrupted
[C]she is a symbol of the Old South
[D]she is a prisoner and victim of the past
PART TWO
Ⅱ.Reading Comprehension (16 points in all, 4 for each)
Read the quoted parts carefully and answer the questions in English. Write your answers in the corresponding space on the answer sheet.
41. “The boast of heraldry, the pomp of power,
And all that beauty, all that wealth e’er gave.
Awaits the inevitable hour.
The paths of glory lead but to the grave.”
Questions:
A. Identify the author and the title of the poem from which this passage is taken.
B. What does the phrase “inevitable hour” mean?
C. Write out the main idea of the passage in plain English.
42. “A violet by a mossy stone
Half hidden from the eye!
－Fair as a star, when only one
Is shining in the sky.”
Questions:
A. Identify the author and the title of the poem from which this stanza is taken.
B. Pick out the metaphor used in this stanza.
C. What quality does the author intend to show by using the metaphor?
43. “We passed The School, where Children strove
At Recess－in the Ring－
We passed The Fields of Gazing Grain
We passed The Setting Sun－”
Questions:
A. Who is the author of this stanza taken from the poem “Because I could not stop for Death－?
B. What do the underlined parts symbolize?
C. Where were “we” heading toward?
44. “It was you that broke the new wood.
Now is a time for carving.
We have one sap and one root－
Let there be commerce between us.”
Questions:
A. Whom does the “us” refer to?
B. What does the phrase “broke the new wood” mean here?
C. What is the intention of the poet in writing the poem “A Pact” from which these lines are taken?
Ⅲ.Questions and Answers (24 points in all, 6 for each)
Give brief answers to each of the following questions in English. Write your answers in the corresponding space on the answer sheet.
45.In Chapter 15 of Wuthering Heights, Heath cliff said to Catherine: “Why did you betray your own, Cathy?... You loved me－then what right have you to leave me?... I have not broken your heart－you have broken it－and in breaking it, you have broken mine.”
Taking the whole novel into consideration, do you think Heathcliff’s above accusation of Catherine’s betrayal can be justified? If you think so, what reasons does Catherine have to betray Heathcliff and their love?
46.John Bunyan’s The Pilgrim’s Progress is generally regarded as a religious allegory. What does the work symbolically concern? What is the predominant metaphor that is carried on through the whole work? And what is the author’s purpose in writing such a book?
47. The following passage is taken from The Merchant of Venice. Read it carefully and find the dramatic it contains. Use it as an example to illustrate what dramatic irony is.
“Bassanio: Antonio, I am married to a wife
Which is as dear to me as life itself;
But life itself, my wife, and all world,
Are not with me esteem’d above thy life;
I would lose all, ay, sacrifice them all
Here to this devil, to deliver you.
Portia: Your wife would give you little thanks for that,
If she were by to hear you make the offer.”
48. What is the most famous theme in Henry James′s fiction? And what is his favourite approach in characterization, which makes him different from Mark and W. D. Howells as realists? Give two titles of his works in which this theme and this approach are employed.
Ⅳ.Topic Discussion (20 points in all, 10 for each)
Write no less than 150 words on each of the following topics in English in the corresponding space on the answer sheet.
49.In Pride and Prejudice, Jane Austen explored three kinds of motivations of marriage the middle-class people had in the second half of the 18th century. Try to make a brief discussion about them with specific examples from the novel. Make comments on Austen’s attitude towards these motivations.
50.Retell in a few sentences the story of the last chapter (Ch, 135) “The Chase－Third Day” of Melville’s novel Moby-Dick. Discuss the meaning of the ending of the story.

大一学前教育心理学期末考试题及答案专科

学前儿童发展心理学 试题
一、名词解释题（每小题4分，共20分） 1．个体心理发展 2．知觉
3．自传体记忆 4．自我中心 5．社会性游戏
二、填空题（每空1分，共20分）
1．学前儿童心理学是研究---------学前儿童心理年龄特征和发展规律的科学。 2.---------是生命的最基本特征之一，是生物界的普遍现象。
3．新生儿视觉调节机能较差，---------很难随客体远近的变化而变化。
4.8个月以后的婴儿主要采用两种方式开展交流活动，一种是----------，另一种是 ------------。
5．皮亚杰将儿童的道德水平分为------、----------、-----------
6．学前儿童的----------是学前儿童音乐表现能力、欣赏能力的基础和前提。 7．随着年龄的递增，儿童的社会性游戏不断向更高层次发展，从---------到平 行游戏，从平行游戏再到-------------- ，最后发展到------。
8．儿童的性别概念主要包括三方面的内容：-----------、一--------和---------。 9．华生强调-----------对塑造儿童行为的决定性作用，进而发展为---------， 强调对____。
10.格塞尔认为，个体的发展取决于--------- ，而成熟的顺序取决于------决定的时间表。
三、简答题（每小题8分，共24分） 1．简述个体心理发展的基本规律。 2．简述儿童思维发展的一般趋势。 3．简述依恋的特征。 四、论述题（16分）
试述母亲对胎儿发育的影响及如何做好优生。 五、案例分析题（20分）
材料：她易于察觉别人不易察觉的事情。在实验中，两根铁丝本应是等长的，但实际上有极细微的差异。先后参加实验的10个同龄小朋友，只有她一人注意到这个差异。
她不喜欢说话，喜欢一个人玩。有时其他小朋友凑过来玩，她也不说话，只是厌烦地把他们推开，更不易与陌生人接触。
她情绪不易外露，受到表扬时，也没有什么表示。在幼儿园里遇到不高兴的事，可以毫无表情，但回家后对着妈妈哭。
她上课时很安静，总是一个姿势坐着。吃饭时，不管饭菜多么好，从不见她大口吃。 午睡时，她总是把衣服一件件叠好放在椅子上。如果椅子稍歪一点，她要把它放正，还要看上几眼，然后才躺下。起床时，穿衣动作也很慢。
根据材料描述请指出孩子的气质类型，并谈谈如何根据此类气质进行教育。

本学期期末学员共参加了3门课的考试，即Java，C，SQL，编写方法计算每位学员3门课的平均分。

class Student {
    private double javaRecord;
    private double cRecord;
    private double sqlRecord;
    public Student(double javaRecord, double cRecord, double sqlRecord) {
        this.javaRecord = javaRecord;
        this.cRecord = cRecord;
        this.sqlRecord = sqlRecord;
    }
    public double getcRecord() {
        return cRecord;
    }
    public double getJavaRecord() {
        return javaRecord;
    }
    public double getSqlRecord() {
        return sqlRecord;
    }
}
public class StudentBiz {
    public double getAvg(Student stu) {
        return (stu.getJavaRecord()+stu.getcRecord()+stu.getSqlRecord())/3;
    }
    public static void main(String args[]) {
        Student stu = new Student(100, 80, 50);
        System.out.println("平均成绩是："+new StudentBiz().getAvg(stu));
    }
}

一次数学考试共有50题,规定答对一题得2分,答错一题扣1分,未答得题不计分。考试结束后，小明得了81分。

50题如果全部答对可得100分，但有奇数道题目没有答，没答一题少得2分，没答三题少得6分……
于是，如果没有答错的题，得分应该是98、94……一定是偶数。
然而得分是81，这说明小明因为答错而少得了98-81=17分、94-81=13分……
答错一题比答对一题少得3分，所以在17、13……里找可以被3除开的数——9。
9÷3=3，说明答错3道。如果不答错这3道题，小明可以得81+9=90分，说明他有（100-90）÷2=5题没答，有50-3-5=42题答对。

数据库题，设有一个学生—课程数据库，其中包括三个表

1．查询所有学生的学号、姓名、所在系
Select sno,sname,sdept
From student
2.查询全体学生的学号、姓名、性别，年龄，系别的信息
Select *
From student
3.查询全体学生的姓名及其出生年份
Select sname,datadiff(year,sage,2010) as 出生年份
From student
4.查询信息工程系全体学生的名单
Select sname
From student
Where sdept=’信息工程系’
5.查询所有年龄在20岁以下的学生姓名以及年龄
Select sname,sage
From student
Where sage<20
6.查询考试成绩不及格的学生的学号
Select sno
From score
Where grade<60
7.查询年龄在20-25（包括20、25）之间的学生的姓名、系别和年龄
Select sname,sdept,sage
From student
Where sage>=20 and sage<=25
8.查询不在软件系、网络系、也不在外语系学生的姓名和性别
select sname,sex
from student
where sdept <>软件系、网络系、外语系
9.查询所有姓李且全名为三个汉字的学生的姓名、学号、和性别
select sname,sno,sex
from student
where sname like 李_ _
10.查询姓名中第二个字为阳字的学生的姓名
select sname
from student
where sname like _阳%
11.查询信息工程系年龄在20岁以下的学生的姓名
select sname
from student
where sage<20 and sdept=信息工程系
12.查询选修了3号课程的学生的学号及其成绩，查询结果按分数的降序排列
select sno,grade
from score
where cno=3
order by grade desc
13.查询全体学生的学号、姓名等情况，结果按照所在系的升序排序，同一系的按年龄降序排列
select sno,sname
from student
order by sdept asc,sage desc
14.统计学生总人数
select count(*) as 人数
from student
15.查询选修课课程的学生人数
select count(*) as 人数
from score
16.计算1号课程的学生平均分数
select avg(grade) 均分
from score
where cno=1
17.查询选修了1号课程的学生最高分数
select max(grade) 最高分
from score
where cno=1
18.求各课程号及相应的选修课人数
select cno,distinct(sno)
from score
group by cno
19.查询选修了3门以上课程的学生号
select sno
from score
group by sno
having count(cno)>3
20.查询选修2学分的课程且该课程的成绩在90分以上的所有学生的姓名
select sname
from student,course,score
where student.sno=score.sno and course.cno=score.cno and ccredit=2 and grade>90
21.查询每个学生的学号、姓名、选修的课程号和成绩
select student.sno,sname,cno,grade
from student,score,course
where student.sno=score.sno and score.cno=course.cno
22.查询所有选修了1号课程的学生姓名
select sname
from student,score
where student.sno=score.sno and score.cno=1
23.查询选修了课程名为“计算机信息管理”的学生的学号和姓名
select sno,sname
from student,course,score
where student.sno=score.sno and course.cno=score.cno
and cname=计算机信息管理
希望能给你帮助 差不多一样