The code of the National Computer Rank Examination "Computer Basis and MS Office" is 15. Next, I will analyze the computer foundation and the significance of MS Office application. I hope you study hard!

The first-class certificate shows that the holder has basic computer knowledge and preliminary application ability, grasps the use of office automation software and Internet application, and can engage in secretarial and office informatization work in government agencies, enterprises and institutions.

If you can't use a computer, you are a modern illiterate ~ ~ ~

At present, the content of computer grade examination is subject to the examination outline formulated in 20 13 (the examination outline is revised about every five years).

Teaching software: future education software, screen video; Teacher machine establishment? FTP server? The students' homework is compressed and uploaded to the teacher's computer.

Examination contents: Windows operation (10), Word(25), Excel(20), PowerPoint( 15), IE and email (10), and basic computer knowledge (20).

I. Teaching content

(a) Windows7 operating system (10)

Main test site:

1. (about 6 points) Copy, paste, rename, move and delete files and folders.

2.(2 minutes or so) Create a new file or folder.

3. (about 2 o'clock) Set properties (read-only, hidden)

Secondary proving ground:

4. Create a shortcut.

5. Search files and folders (pay attention to the use of wildcards, such as? A*。 DLLA*。 TXT？ Wait).

Non-exam content:

6. foundation 6. Windows operation: explorer (the beginning of the lower left corner of the screen? Right mouse button), attachment (start? All programs? Accessories), control panel (start? Control panel).

7. Drawing, Notepad, Calculator and Screenshot Tool.

8. Common shortcut operations:? Win + D？ Display the desktop; ? Ctrl + Z？ Undo operation; ? Alt？ Activate the menu bar of the active window.

9. Don't merge the taskbar: right-click the taskbar? Attribute? Taskbar Taskbar button, select Never Merge.

10. Copy what the mouse can't select: press and hold? Shift? Key, then continue to press the key, and finally press Ctrl+C to copy.

1 1. Enlarge or reduce the screen display: hold down the Ctrl key and scroll the middle mouse button to enlarge or reduce the screen display.

12. Supplement: sogou Pinyin and Baidu Pinyin Input Method.

13. How to open the control panel in Windows 8: Move the mouse to the upper right corner or the lower right corner, press the gear (setting) button, and the control panel button will appear. Windows 10 opens the control panel: right-click the start menu button in the lower left corner, and then select the control panel.

(2) Word processing (25 points)

Main test sites: (font/paragraph/editing/page layout, etc. 15, table layout/table design, 10)

1.Office interface: tab, ribbon/dialog launcher, button/drop-down button.

2.(3 points or so) Text replacement

3.(5 points or so) Font setting: font, font size, center, bold, color, upper and lower subscripts, character spacing and text effect. (hint:? Italics GB23 12? Is it? Regular script? , other fonts are also expressed in the same way)

4. (About 5 minutes) Paragraph setting: the first line is indented/hanging indent, before/after the paragraph, and the spacing.

5. (About 2 o'clock) column (page layout tab) with initial sinking (insert tab)

6. (about 5 points) table layout (table tool? Layout)

(1) Text to table: selected text? Insert tabs? Form? Convert text into a table.

(2) What's the difference between centering the table and centering the data in the table? )。

(3) Cell size: Cell size, dialog box launcher? Resize rows and columns.

(4) Insert a row or column: right mouse button? Insert? Insert a row or column.

(5) sorting: sorting? Select a line with a title or a line without a title. See Exercise 3.

(6) calculation: formula? Select from the paste function, for example: = sum (left); = average (above); =SUM(B2:B5). See Exercise 3.

Note: If the data changes, press F9 to recalculate automatically.

7.(5 points or so) Form design (form tool? Design)

(1) Table style: Table style.

(2) Table border: first select the line type, thickness and color, and then select the border type. See Exercise 2.

(3) Form shading: shading? Theme color

Secondary proving ground:

8. Text modification

(1) Text box: Start? Paragraph ribbon? Border and shading? Box? Apply to text.

(2) Text shading: paragraph ribbon? Border and shading? Shading? Choose a fill color or pattern style? Apply to text.

(3) Hollow characters: font dialog launcher? Text effect? Text padding is set to no padding, and text border is set to solid line.

9. Others

(1) Insert Footnote: Reference Tab? Insert a footnote.

(2) page layout? Margins, paper orientation, paper size.

(3) Insert pictures, clip art, wordart and text boxes as pictures? Operate under the Drawing Tools tab.

(4) Watermark: page layout? Watermark? Custom watermark? Text watermark.

(5) Subscript: font ribbon, superscript, subscript.

(6) Add bullets and numbers (in the paragraph ribbon).

(7) Save, print preview and undo/restore.

Non-exam content:

10. format brush: start label? Format brush.

1 1. If you want to change the width of one column in the table without affecting the width of other columns, hold down the Shift key and drag the right row of a column.

12. In Word, the table title is displayed on every page: Select the table title? Right mouse button, table properties? Okay？ Repeat as a header line at the top of each page.

13. Rotate the picture in Word.

(3) Excel spreadsheet (20 points)

Main test sites: (formulas and functions, inserting charts, data analysis)

Here is an example of how to deal with students' grades.

References:

Several keys commonly used in Excel operation

1. (about 2 points) Merge cells with the content in the center.

2.(4 points or so) Formulas and functions, in which 1-2 is tested.

(1) formula

Tip: English characters must be used in the formula, such as: =, ",etc.

Difference between absolute and opposite cells (set 7, switch with F4)

(2) Function

References:

Excel function

3.(7 points or so) Insert a chart to beautify it.

(1) Insert Chart: Select some columns in the table? Insert? Chart dialog launcher? Select chart type? Of course.

Note: By default, the chart series is in? Column? .

(2) Table beautification (style ribbon: conditional format, applied table format, cell style)

(3) Graphic beautification (Graphic Tools tab: design, layout and format)

(4) Drag and drop charts

4. Rename the worksheet (about 1 min).

5. (About 6 points) Data analysis (sorting, classification and summary, pivot table, automatic screening), and 2 tests.

Sorting: Select the data in the table? Data? Sorting (if there is a second-level keyword sorting? Add conditions). See Exercise 1 and Exercise 2.

(2) Classification and summary: select the data in the table? Classification and summary (note: classification first, then summary). See Exercise 1 and Exercise 2.

(3) Insert PivotTable: Select all the data in the table? Insert tabs? Insert PivotTable report? Select and enter the location where you want to put the PivotTable report (for example, the I8:M22 cell range of the current worksheet)? Drag and drop row labels, column labels, and summation items. See Exercise 3 and Exercise 4.

(4) Automatic filtering: Select a title? Automatic screening. (See Group 9)

(5) Advanced screening: first list the screening conditions, data? Screening? Advanced? Select list area and condition area. (See Group 8)

Non-exam content:

6. Data population

ID number input: right mouse button? Format cells? Text format.

Student number input: start tag? Edit ribbon? Fill? Series.

Enter the following menu: Data tab? Data validity? Data validity? Sequence? Are you online? Source? Enter menu contents in, separated by,,.

7. Others

(1)Excel printing and typesetting; Horizontal and vertical centering settings (file? Print? Page setup? Margin? Horizontal center, vertical center).

(2) Print title: page layout? Print the title? Select: top header row or left header column.

(3) page scaling: page layout? Adjust to the right size? Adapt? Page width? Page height.

(4) opinion? Freeze pane

(5)EXCEL table column printing

(6) Multi-table consolidated calculation, for example: =SUM(Sheet 1:Sheet20! A 1)

(4) PowerPoint electronic slides (15)

Main test site:

1. Basic operations: design (theme), switching (switching, effect options, all applications), animation (more entry effects, effect options), layout (right mouse button), setting background (right mouse button), and inserting wordart.

Note: the difference between switching and animation.

2. Add, insert, move and delete slides.

Insert picture

(1) Insert a picture: Insert? Insert picture

(2) Set the best proportion of pictures: picture tool? Format? Size? The best proportion of slides.

4. Slide background

(1) Default background color: right mouse button? Format the background? Fill? Gradient fill? Default color.

(2) Texture filling: right mouse button? Format the background? Fill? Picture or texture filling? Texture.

5. Insert WordArt

(1) Insert WordArt: Insert? Art word? Select the desired style.

(2) WordArt effect: WordArt style? Text effect? Conversion.

(3) The position and size of wordart: size? Location or size.

Secondary proving ground:

6. Others

(1) Convert to SmartArt: Select text? Right mouse button? Convert to SmartArt

(2) Slide Notes: View? Normal view? Remarks area (below the slide)

(3) Font RGB color setting: Start? Font? Font color? Other colors? Enter RGB values.

(4) animated text: animation? Choose animation? Animation tab dialog launcher? Animated text? By words/words, etc.

(5) Master: View tab? Slide master (the first one is the master master, the others are the sub-masters, and the master is used to uniformly modify the layout of slides).

Non-exam content:

(4) Make PPT with beautification masters, slim PPT, and save it as PPS format, PPT and other related materials.

(5) Browser use and e-mail sending and receiving (high error rate, strengthening training, 10)

Main test site:

1.(5- 10) IE browser browses the web page and saves it.

Example: http://localhost: 65531/examweb/index.htm (see set 17).

Common mistake: write? HTTP？ Local host; ? Examination network? Index? .

If you can't find the webpage, open it and save it. You must first select the type of savings.

2.(5- 10) (1)Outlook e-mail box receives and replies. (2) Write a new email.

(See setting 17)

References:

Computer Grade Examination Software Operation Diagram

(six) basic computer knowledge (difficult, non-key, 20 points)

References:

Basic knowledge of computer

Second, the exam is related.

(1) Registration time: at the end of each semester, and examination time: at the beginning of the semester.

(2) note: apply for the exam? First-class MS Office? (exam code is 15), not to register? WPS Office？ (Every year, students report mistakes), but still don't sign up? Level two? .

(3) Examination skills: Do basic operation questions first, and then do multiple-choice questions. All multiple-choice questions should be completed within 10 minutes (the time for answering each question should not exceed half a minute). Multiple choice questions can only be entered once, and cannot be entered again after exiting.

;