1. A line segment with an arrow in the program flow chart indicates ().
A. Original relationship
B. data flow
C. control flow
D. Call relationship
2. The basic principle of structured programming does not include ().
A. Polymorphism
B. Top-down
C. modularization
D. Gradual refinement
3. The standard of module division in software design is ().
A. Low cohesion and coupling
B. High cohesion and low coupling
C. Low cohesion and high coupling
D. High cohesion and high coupling
4. In software development, the main document produced in the requirement analysis stage is ().
A. Feasibility analysis report
B. Software requirements specification
C. Outline design specification
D. integration test plan
5. The finiteness of the algorithm refers to ().
A. The running time of the algorithm program is limited.
The amount of data processed by the algorithm program is limited.
C. the length of the algorithm program is limited.
D. The algorithm can only be used by limited users.
6. Sort the linear table with length n. In the worst case, if the comparison times are not n(n- 1)/2, the sorting method is ().
A. Rapid classification
B. bubble classification
C. insert sorting directly
D. heap sorting
7. The following statement about the stack is true ().
A. stack pressure? First in first out? Organizational data
B. stack pressure? First in, last out? Organizational data
C. Data can only be inserted at the bottom of the stack.
D. Unable to delete data
8. In database design, the process of transforming E-R diagram into relational data model belongs to ().
A. Demand analysis stage
B. Conceptual design stage
C. Logic design stage
D. Physical design stage
9. There are three tables showing students' course selection. Student's (student number, name, gender, age, ID number), course C (course number, course name) and course selection SC (student number, course number, grade), then the key word (key or code) of table SC is ().
A. Class number, grade
B. Student number and grades
C. student number, class number
D. Student ID, name and grades
Second, the word processing problem (***30 points)
Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic.
Note: The following files must be saved in the examinee folder [%USER%].
Documents? Beijing government statistical work annual report. docx？ It is a written document obtained from the Internet. Please open the document according to the following requirements and save it in typesetting:
(1) Delete all Spanish spaces in the document.
(2) Set the paper size to 16, the top margin to 3.2 cm, the bottom margin to 3cm, and the left and right margins to 2.5cm.
(3) Make a cover with the first three documents of the material, which can occupy one page (see file? Sample cover. png？ )。
(4) Will there be a title? (3) What about consulting? The paragraphs marked in blue below are converted into tables, and table styles are applied to tables to make them more beautiful. On the basis of table data, insert a pie chart below the table to reflect the proportion of various consulting tables, and only the percentage needs to be displayed in the pie chart.
(5) use "? First,? 、? Second, the opening paragraph is set to? Title l? Style; With what? ( 1)? 、? (2) The opening paragraph is set to? Title two? Style; With what? 1、? 、? 2. The first paragraph is set to? Title 3? Style.
(6) The text marked in red in the second paragraph of the text? Bureau of statistics team government website? Add a hyperlink with an address? /? . At the same time? Bureau of statistics team government website? Add a footnote at the end, which reads as follows: http://www.bjstats.gov.eft? .
(7) Display all contents except the cover in two columns, but the above tables and related charts still need to be displayed in the middle column without columns.
(8) Insert a table of contents between the cover and the text. The table of contents should include the title L-3 and the corresponding page number. The table of contents occupies a page without columns.
(9) In addition to the cover page and the table of contents page, add a header to the body page, with the content of document title? Beijing municipal government information disclosure annual report? And page numbers, requiring the text page numbers to start from 1 page, in which odd-numbered headers are displayed on the right, page numbers are displayed on the right of the title, even-numbered headers are displayed on the left, and page numbers are displayed on the left of the title.
(10) First, use the original Word format and file name to typeset the finished product. Beijing government statistical work annual report. docx？ Save it, and then generate another PDF document with the same name to save.
Three, spreadsheet questions (***30 points)
Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic.
Note: The following files must be saved in the examinee folder [%USER%].
China's population development situation is very severe. The National Bureau of Statistics conducts a national census every 10 to grasp the growth rate and scale of the national population. Complete the statistical analysis of the fifth and sixth population census data according to the following requirements:
(1) Create a new blank Excel document and rename the worksheet sheetl? The fifth census data? , rename sheet2 to? The sixth census data? What's in that document? Analysis of national census data. xlsx？ Save as file name.
(2) browsing the web? Bulletin of the fifth national census. hun？ Will it be one of them? What are the main data of the fifth national census in 2000? Import tables into worksheets? The fifth census data? Medium; Browse the web? Bulletin of the sixth national census. htm？ Will it be one of them? 20 10 what are the main data of the sixth national census? Import tables into worksheets? The sixth census data? Medium (it is required to import from cell A 1, and the data in the two worksheets are not sorted).
(3) Apply an appropriate table style to the data areas in the two worksheets, requiring at least four borders and even lines with shading, and set the number format of all population series as integers with thousands of separators.
(4) Merge the contents of two worksheets and put the merged worksheet into a new worksheet? Compare data? (starting from cell A 1), and take the leftmost column as the region name, and the column title in cell A 1 as? Region? , adjust the row height, column width, font size, border shadow, etc. To make it easy to read. With what? Region? Pairing worksheets for keywords? Compare data? In ascending order.
(5) In the merged worksheet? Compare data? The rightmost data area in increases in turn? Population growth? And then what? Specific gravity change? Two columns, calculate the values of these two columns, and set the appropriate format. In which: population growth =20 10 population -2000 population; Proportional change =20 10 -2000.
(6) Open the workbook? Statistical indicators. xlsx？ , will the worksheet? Statistics? Insert into the document being edited? Analysis of national census data. xlsx？ Intermediate worksheet? Compare data? On the right of ...
(7) In the workbook? Analysis of national census data. xlsx？ Worksheet? Compare data? Fill in the corresponding cells in the statistical results.
(8) Based on the worksheet? Compare data? Create a PivotTable report and store it separately in a file named. Perspective analysis? In the worksheet. In the PivotTable report, it is required to screen out the regions with a population of more than 50 million in 20 10, their population, the proportion in 20 10 and the population growth, and sort them according to the population from most to least. Finally, adjust the number format in the PivotTable appropriately. (hint: what is the line mark? Region? The digital items are the population in 20 10 years, the proportion in 20 10 years, and the population growth.
Four, the statement of the topic (***20 points)
Please choose the command to enter the examinee folder under the answer menu and complete the following operations according to the requirements of the topic.
Note: The following files must be saved in the examinee folder [%USER%].
The physics teacher of Class 5, Grade 2, junior high school in a school asked the students to make a physics courseware in pairs. Xiao Ceng and Xiao Zhang joined together voluntarily. See the documents they produced in the last three sections of the first chapter? Section 3 -pptx? , the first two parts are stored in a text file? Section 65438 +0-2. pptx？ Medium. Xiao Zhang needs to complete the integrated production of courseware according to the following requirements:
(1) is a presentation? Section 65438 +0-2. pptx？ Specify an appropriate design theme; For a speech? Number three? Section pptx? Specify another design theme that should be different.
(2) Will it be demonstrated? Section 3 -pptx? And then what? Section 65438 +0-2. pptx？ Merge all slides to? Physics courseware. pptx？ All slides are required to keep the original format. All future operations are in the document? Physics courseware. pptx？ In the middle.
(3) in? Physics courseware. pptx？ After the third slide in, insert a slide with the format? Only the title? Slide, enter the title text? The state of matter? Make a ray list diagram under the heading, for example? Chart materials and examples. doex？ The required pictures are in the examinee's folder. Adding an appropriate animation effect to a diagram requires the same level of content to appear at the same time, and different levels of content to appear one after another.
(4) Insert a sheet with the format? Title and content? The slides, inserts and materials in this slide? Similarities and differences between evaporation and boiling. doex？ Display the same table in the document and add appropriate animation effects to the table.
(5) Connect the fourth and seventh slides with the related words in the third and sixth slides respectively.
(6) In addition to the title page, add a number and a footer to the slide. What is the content of the footer? Chapter 1: State of matter and its changes? .
(7) Set appropriate switching modes for slides to enrich the screening effect.