Syllabus: MicroSoft Office Specialist/EXCEL 2000 (MOUS)
One Mester, 5 credits, Course #: 211077
[ Course Syllabus | Student Performance Portfolio ]
Based on MS
Office Specialist Certificaiton Requirements.
Exam tips:
http://www.microsoft.com/traincert/mcp/officespecialist/examtips.asp
Outline of Microsoft Office Specialist Exam Objectives and Skills
Exam objectives are categories of examination tasks, identified by subject-matter experts, that certify an ability to productively use Microsoft Office programs. These categories are organized into skill sets representing the more basic functions of each Office program.
Excel 2000 Expert
Importing and Exporting Data
- Import data from text files (insert, drag-and-drop) operations
- Import from other applications
- Import a table from an HTML file (insert and drag and drop operations, including HTML round tripping)
- Export to other applications
Using Templates
- Apply templates
- Edit templates
- Create templates
Using Multiple Workbooks
- Use a workspace
- Link workbooks
Formatting Numbers
- Apply number formats (accounting, currency, and number)
- Create custom number formats
- Use conditional formatting
Printing Workbooks
- Print and preview multiple worksheets
- Use the Report Manager
Working with Named Ranges
- Add and delete a named range
- Use a named range in a formula
- Use Lookup Functions (Hlookup or Vlookup)
Working with Toolbars
- Hide and display toolbars
- Customize a toolbar
- Assign a macro to a command button
Using Macros
- Record macros
- Run macros
- Edit macros
Auditing a Worksheet
- Work with the Auditing Toolbar
- Trace errors (find and fix errors)
- Trace precedents (find cells referred to in a specific formula)
- Trace dependents (find formulas that refer to a specific cell)
Displaying and Formatting Data
- Apply conditional formats
- Perform single and multilevel sorts
- Use grouping and outlines
- Use data forms
- Use subtotaling
- Apply data filters
- Extract data
- Query databases
- Use data validation
Using Analysis Tools
- Use the Microsoft PivotTable® autoformat
- Use Goal Seek
- Create Microsoft PivotChart® reports
- Work with Scenarios
- Use Solver
- Use data analysis and PivotTable
- Create interactive tables for the Web with PivotTable
- Add fields to a table using the Web browser
Collaborating with Workgroups
- Create, edit, and remove a comment
- Apply and remove worksheet and workbook protection
- Change workbook properties
- Apply and remove file passwords
- Track changes (highlight, accept, and reject)
- Create a shared workbook
- Merge workbooks
PowerPoint 2000 Core
Creating a Presentation
- Delete slides
- Create a specified type of slide
- Create a presentation from a template or a wizard
- Navigate among different views (slide, outline, sorter, and tri-pane)
- Create a new presentation from existing slides
- Copy a slide from one presentation into another
- Insert headers and footers
- Create a blank presentation
- Create a presentation using the AutoContent Wizard
- Send a presentation via e-mail
Modifying a Presentation
- Change the order of slides using Slide Sorter view
- Find and replace text
- Change the layout for one or more slides
- Modify the Slide Master
- Modify slide sequence in the outline pane
- Apply a design template
Working with Text
- Check spelling
- Change and replace text fonts (individual slide and entire presentation)
- Enter text in tri-pane view
- Import text from Microsoft Word
- Change the text alignment
- Create a text box for entering text
- Use the Wrap text in TextBox feature
- Use the Office Clipboard
- Use the Format Painter
- Promote and Demote text in slide and outline panes
Working with Visual Elements
- Add a picture from the Clip Art Gallery
- Add and group shapes using WordArt or the Drawing Toolbar
|
|
| Word Processing | Create a one page resume including personal information (can be sample info), educational experience, work experience, educational goals, career goals. |
| Word Processing | Create a plan for four year schedule of classes using tables. Indicate required and elective classes. |
| Word Processing | Create a one page announcement flier using clip art. Show the use of two fonts, regular and italic styles, |
| Word Processing | Create a one page newsletter using two columns. |
| Spreadsheet | Create a spreadsheet which calculates the expenses of a birthday party attended by ten members and involving eight purchases. |
| Spreadsheet | Create a spreadsheet which calculates the deductions for ten employees, including state and federal taxes, social security, health insurance, disability, retirement. |
| Spreadsheet | Create a bar graph based on the birthday party spreadsheet and paste it into a word processing document. Explain the graph in that one page. |
| Spreadsheet | Create a pie graph based on the employee payroll spreadsheet and paste it into a word processing document. Explain the graph in that one page. |
| Database | Create a database inventorying six CDs, recording artist, song composer, record company, year, song titles, music categories, song length. |
| Database | Create a report based on the CD database. |
| Presentation | Create an eight page presentation that displays a clear, logical sequence using good word processing skills. |
| Presentation | Create a three page html presentation that is logically linked. |
| Research Skills | Reference content downloaded from the Internet: Two images and two text references. |
| AUP | One page essay on in the importance of respecting Intellectual property rights and correctly referencing content. |
| AUP | One page essay on the importance of every organization that provides Internet access to enforce an Acceptable Use Policy (AUP). |
| AUP | Pass the Jefferson High School LAUSDnet Student Internet test and get an LAUSDnet account. |
| [ Computer Dept. | Departments ] |