TE10 Curriculum Map
From Brush Schools Wiki
Go back to main Technology page.
Contents |
August
Content and Essential Skills
Students will review and sign an District Acceptable Use Policy.
Students learn the steps of logging on, saving and printing to a network.
Identify the objects on the Microsoft Windows XP desktop.
Review the Windows desktop.
Skills
Read over the AUP and have signed by parents.
Password Privacy.
Students learn the steps of logging on, saving and printing to a network.
Review the Windows desktop.
Differences between the Mac and PC Multi tasking
Technical terminology
Assessment
Teacher observation
Students are consistently able to log into their accounts without assistance.
Resources
Optional
September
Content and Essential Skills
Creating and editing a Word document
Creating a Research Paper
Creating a Resume using a wizard and a Cover Letter with a table
Skills
Creating and editing a Word document
- Start Word
- Describe the Word window
- Describe the speech and handwriting recognition capabilities of Word
- Zoom page width
- Change the default font size of all text
- Enter test into a document
- Scroll through a document
- Check the spelling as you type
- Save a document to the server
- Select text
- Change the font size of selected text
- Change the font of selected text
- Right-align a paragraph
- Center a paragraph
- Undo commands or actions
- Italicize selected text
- Underline selected text
- Bold selected text
- Insert clip art into a document
- Resize a graphic
- Print a document
- Open a document
- Correct errors in a document
- Use Word Help
- Quit Word
Creating a Research Paper
- Describe the MLA documentation style for research papers
- Change the margin settings in a document
- Adjust line spacing in a document
- Use a header to number pages of a document
- Enter text using Click and Type
- Apply formatting using shortcut keys
- Indent paragraphs
- Use Word's AutoCorrect feature
- Add a footnote to a research paper
- Modify a style
- Count the words in a document
- Insert a manual page break
- Create a hanging indent
- Insert a symbol automatically
- Create a hyperlink
- Sort selected paragraphs
- Go to a specific location in the document
- Move text
- Find and replace text
- Use the Paste Options button
- Understand how Smart Tags work
- Find a synonym for a word
- Check spelling and grammar at once
- Display a Web page associated with a hyperlink
- Email a copy of a document
Creating a Resume using a wizard and a Cover Letter with a table
- Create a resume using Words Resume Wizard
- Identify the Word screen in print layout view
- Zoom text width
-Identify styles in a document
- Replace selected text with new text
- Insert a line break
- AutoFormat text as you type
- Use print preview to view and print a document
- Open a new document
- Add color to characters
- Set and use tab stops
- Switch form one open Word document to another
- Collect and paste using the Clipboard task pane
- Add a bottom border to a paragraph
- Clear formatting
- Convert a hyperlink to regular text
- Identify the components of a business letter
- Insert the current date
- Create an AutoText entry
- Insert a nonbreaking space
- Insert a AutoText entry
- Insert a Word Table
- Enter data into a word table
- Format a word table
- Create a bulleted list as you type
- Address and print an envelope
Assessment
Timed Writing
Must be at least 30 wmp
Internet Basics
Word Basics
Correspondence
Students will complete the following projects:
- a business letter
- a personal letter and envelope
- a memorandum using a template
- a business letter using a Wizard
- a two page report with title page and bibliography
Vocabulary Test
Resources
Optional
October
Content and Essential Skills
Reports and Long Documents
Students will learn to use features found in Word to format and edit reports and long documents.
Meeting Documents, Schedules, and Forms
Students will learn to create meeting documents, schedules, and forms that typically organize information using an outline and/or table format. Meeting documents include those that are used to prepare for a meeting, such as an agenda, a program, and minutes. Schedules include documents that list dates, times, and events. Forms are documents that contain fill-in blanks in which you enter information.
Sales and Marketing Documents
Students will learn to use features in Word to format sales and marketing documents. Sales and marketing documents include anything that helps sell or promote a product or service. Examples include press releases, flyers, advertisements, newsletters, brochures, and catalogs.
Skills
Reports and Long Documents
- Insert page breaks
- Set line and paragraph spacing
- Line spacing
- Paragraph spacing
- Indent text
- Insert headers, footers, and page number
- Use bullets and numbering
- Set vertical centering
- Use borders and shading
- Create a section break
- Use columns
- Apply styles
- Use Research services
- Dictionary
- Thesaurus
- Encyclopedia
- Translation
- Web search
- Find and replace text
- Insert a file
- Track Changes in a Document
- Insert, View, and Edit Comments
- Compare and Merge Documents
- Word Count and Document Summary
Meeting Documents, Schedules, and Forms
- Create and outline
- Edit an outline
- Create an outlined numbered list
- Create a table and enter text
- Convert text to a table
- Modify a table
- Change column width
- Add/delete columns and rows
- Format a table
- Align data within cells
- Set row height
- Apply borders and shading
- Use AutoFormat
- Set and modify tabs
- With leaders
- Within table cells
Sales and Marketing Documents
- Set character spacing
- Apply text effects
- Work with text boxes
- Create a text box and enter text
- Move and size a text box
- Format a text box
- Wrap text around a text box
- Work with images
- Work with objects
- Shapes/AutoShapes
- Lines
- WordArt
- Charts and diagrams
- Wrap text around objects
- Group and layer objects
Assessment
Resources
Optional
November
Content and Essential Skills
Excel Basics
Students will learn about the Excel screen, including the toolbars, menus and view preferences. Students will use navigation techniques, express movements, and learn some basic worksheet concepts while exploring the Excel screen. Students will also learn about creating and renaming folders for file management.
Business Forms
Students will learn to use Excel to design business forms and to customize both software and online templates. You will use the Internet to email a form and to access Microsoft Office Online.
Accounting Records
Students will learn to create accounting records and statements. They will use formulas, functions and formation to complete the tasks. Students will use the Internet to locate tax forms and rates.
Skills
Excel Basics
- Start Excel
- Explore the Excel workbook
- Explore menus and toolbars
- Set view preferences
- Navigate the worksheet
- Use scroll bars
- Use the Go To command
- Create a folder for saving workbooks
- Rename a folder
Business Forms
- Enter text, dates, and numbers
- Use Smart Tags
- Format cell data
- Format dates
- Format for currency
- Format text
- Use Save and Save As
- Edit cell data
- Edit cell contents
- Align cell data
- Clear cell contents
- Check spelling
- Use the Thesaurus
- Use AutoComplete
- Use Print Preview
- Select a range of cells
- Set Print Area
- Change print settings
- Work with templates
- Save a file as a template
- View Web templates
Accounting Records
- Change row or column size
- Cut, copy, and paste
- Apply and clear number formats
- Use the Office Clipboard to cut, copy, and paste
- Use formula basics
- Enter functions
- AutoSum
- Enter the range in a formula
- AutoSum List
- Formula bar
- Use the Fill Handle tool
- Modify page setup options
- Orientation
- Set page margins and centering
- Edit formulas using the Formula bar
- Move selected cells
- Insert, view, and edit cell comments
- Apply and modify cell formats with the Format Cells dialog box
- Use the Format Painter
Assessment
Resources
Optional
December
Content and Essential Skills
Data Analysis
Students will learn to use Excel features, functions, and multiple worksheets and workbooks to create and complete analysis of business data. Completed worksheets and workbooks will be saved as a Web page.
Financial Reports
Students will learn to use logical functions, 3-D formulas, print settings, and the linking and formatting features in Excel to prepare financial reports.
Charts and Diagrams
Students will learn to use features in Excel to create, modify, print, and position charts, diagrams, and graphics.
Informative Presentations
Students will learn to use PowerPoint features to create and enhance informative presentations, which either report or explain. Students will complete presentations on the following topics:
- Marketing strategies for a new product
- Information about the care of plants
- Information about a company’s services
- A new employee orientation
- Information about a travel destination
Sale Presentations
Students will learn to use PowerPoint features to create effective sales presentations. Businesses use sales presentations to sell a product, a service or an idea.
Persuasive Presentations
Students will learn to use PowerPoint features to create persuasive presentations. Persuasive presentations should generate understanding, change or form attitudes or opinions, and build consensus.
Skills
Data Analysis
- Apply and modify cell formats
- Cell borders
- Decimal place and negative number format
- Insert a page break
- Lists
- Sort lists
- Filter lists using AutoFilter
- Use numeric labels
- Indent text
- Insert and delete rows and columns
- Use formulas with absolute and relative reference
- Convert workbooks into Web pages
- Add a Background Pattern
- Use Web Page Preview
- Save a workbook as a Web page
- Apply and modify worksheet formats
- AutoFormat
- Fill color and font color
- Modify workbooks
- Insert and delete worksheets
- Move and copy worksheets
- Rename and format worksheet tabs
- Group worksheets
- Use date formats and functions
- Use financial functions
- The PMT functions
- The FV function
- The PV function
- Use Paste Special, Values
Financial Reports
- Merge, center, and split cells
- Workbook layout and links
- Split and arrange multiple workbooks
- Paste link between workbooks
- Hide workbooks
- Work with hyperlinks
- Insert a hyperlink
- Use a hyperlink
- Edit a hyperlink
- Modify row and column layout
- Hide and unhide rows and columns
- Freeze and unfreeze rows and columns
- Modify page set up options
- Print nonadjacent sections of a worksheet
- Print titles
- Use logical functions in formulas
- Add headers and footers to worksheets
- Add customized headers and footers
- Enter 3-D references
- Use styles
- Apply a style
- Define a new style
- Modify a style
- Remove a style
- Find and replace cell data and formats
- Find cell data
- Find and replace data and formats
Charts and Diagrams
- Create, modify, and position charts
- About charts
- Create charts
- Apply chart options
- Create pie chart
- Position a chart
- Chart types and subtypes
- Modify charts
- Copy and paste charts
- Format charts
- Print charts
- Create, position, and modify graphics
- Insert and download graphics and clip art
- Create, modify, and position diagrams
- Create stock charts
PowerPoint Basics
- Start PowerPoint
- Explore the PowerPoint window
- Open a presentation
- Navigate through a presentation
- Change views
- Run a slide show
- Select page setup options
- View a presentation in grayscale or black and white
- Print a presentation
Informative Presentations
- Create a presentation using blank slides
- Apply slide layouts
- Add slide to a presentation
- Work with placeholders
- Add text to placeholders
- Move, copy, delete, and size placeholders
- Create a placeholder
- Format a placeholder
- Create a presentation using a design template
- Change slide color scheme
- Change slide background
- Create a custom background
- Replace fonts
- Move, copy, duplicate, and delete slides
- Work with clip art and photographs
- Insert clip art and photographs
- Edit clip art and photographs
- Apply slide transitions
- Apply animation schemes
- Check spelling and grammar
Sale Presentations
- Work with outlines
- Create a summary slide
- Hide a slide
- Link slides
- Format bullets
- Insert headers and footers
- Work with slide and title masters
- Save as a template
- Create a custom show
- Link to a custom show
- Link the table of contents slide to a custom show
- Work with Objects
- Create Shapes/AutoShapes
- Create WordArt
- Format objects
- Layer objects
- Group, ungroup, and regroup objects
- Use grids and guides
- Nudge objects
- Align or distribute objects
- Use Action buttons
Persuasive Presentations
- Use template presentations
- Use the AutoContent Wizard
- Work with tables, charts, and diagrams
- Work with media
- Use custom animations
- Use the annotation pen
- Work with a photo album
- Use handouts
- Use speaker notes
- Work with the Handout and Notes Master
- Rehearse timings
Assessment
Resources
Optional
January
Content and Essential Skills
Students will review and sign an District Acceptable Use Policy.
Students learn the steps of logging on, saving and printing to a network.
Identify the objects on the Microsoft Windows XP desktop.
Review the Windows desktop.
Creating and editing a Word document
Creating a Research Paper
Skills
Read over the AUP and have signed by parents.
Password Privacy.
Students learn the steps of logging on, saving and printing to a network.
Review the Windows desktop.
Describe the Microsoft Windows XP desktop
Differences between the Mac and PC Multi tasking
Technical terminology
Creating and editing a Word document
- Start Word
- Describe the Word window
- Describe the speech and handwriting recognition capabilities of Word
- Zoom page width
- Change the default font size of all text
- Enter test into a document
- Scroll through a document
- Check the spelling as you type
- Save a document to the server
- Select text
- Change the font size of selected text
- Change the font of selected text
- Right-align a paragraph
- Center a paragraph
- Undo commands or actions
- Italicize selected text
- Underline selected text
- Bold selected text
- Insert clip art into a document
- Resize a graphic
- Print a document
- Open a document
- Correct errors in a document
- Use Word Help
- Quit Word
Creating a Research Paper
- Describe the MLA documentation style for research papers
- Change the margin settings in a document
- Adjust line spacing in a document
- Use a header to number pages of a document
- Enter text using Click and Type
- Apply formatting using shortcut keys
- Indent paragraphs
- Use Word's AutoCorrect feature
- Add a footnote to a research paper
- Modify a style
- Count the words in a document
- Insert a manual page break
- Create a hanging indent
- Insert a symbol automatically
- Create a hyperlink
- Sort selected paragraphs
- Go to a specific location in the document
- Move text
- Find and replace text
- Use the Paste Options button
- Understand how Smart Tags work
- Find a synonym for a word
- Check spelling and grammar at once
- Display a Web page associated with a hyperlink
- Email a copy of a document
Assessment
Students will keyboard at 30wpm
Internet Basics
Word Basics
Correspondence
Students will complete the following projects:
- a business letter
- a personal letter and envelope
- a memorandum using a template
- a business letter using a Wizard
-a two page report with title page and bibliography
Rehearsal Task
Vocabulary Test
Resources
Optional
February
Content and Essential Skills
Reports and Long Documents
Students will learn to use features found in Word to format and edit reports and long documents.
Meeting Documents, Schedules, and Forms
Students will learn to create meeting documents, schedules, and forms that typically organize information using an outline and/or table format. Meeting documents include those that are sued to prepare for a meeting, such as an agenda, a program, and minutes. Schedules include documents that list dates, times, and events. Forms are documents that contain fill-in blanks in which you enter information.
Sales and Marketing Documents
Students will learn to use features in Word to format sales and marketing documents. Sales and marketing documents include anything that helps sell or promote a product or service. Examples include press releases, flyers, advertisements, newsletters, brochures, and catalogs.
Skills
Reports and Long Documents
- Insert page breaks
- Set line and paragraph spacing
- Line spacing
- Paragraph spacing
- Indent text
- Insert headers, footers, and page number
- Use bullets and numbering
- Set vertical centering
- Use borders and shading
- Create a section break
- Use columns
- Apply styles
- Use Research services
- Dictionary
- Thesaurus
- Encyclopedia
- Translation
- Web search
- Find and replace text
- Insert a file
- Track Changes in a Document
- Insert, View, and Edit Comments
- Compare and Merge Documents
- Word Count and Document Summary
Meeting Documents, Schedules, and Forms
- Create and outline
- Edit an outline
- Create an outlined numbered list
- Create a table and enter text
- Convert text to a table
- Modify a table
- Change column width
- Add/delete columns and rows
- Format a table
- Align data within cells
- Set row height
- Apply borders and shading
- Use AutoFormat
- Set and modify tabs
- With leaders
- Within table cells
Sales and Marketing Documents
- Set character spacing
- Apply text effects
- Work with text boxes
- Create a text box and enter text
- Move and size a text box
- Format a text box
- Wrap text around a text box
- Work with images
- Work with objects
- Shapes/AutoShapes
- Lines
- WordArt
- Charts and diagrams
- Wrap text around objects
- Group and layer objects
Assessment
Reports and Long Documents
Students will complete the following projects:
- A one-page report with indented paragraphs
- A two-page report with headers and footer
- A bibliography
- A cover page for a report
- Five pages of a handbook
Meeting Documents, Schedules, and Forms
Students will complete the following projects:
- An outline of an agenda
- An agenda
- Minutes of a meeting
- An itinerary
- A schedule
- An employment form
- A letter with an inserted table
Sales and Marketing Documents
Students will complete the following projects:
- A press release
- A flyer
- An advertisement
- A newsletter
- A catalog
Resources
Optional
March
Content and Essential Skills
Excel Basics
Students will learn about the Excel screen, including the toolbars, menus and view preferences. Students will use navigation techniques, express movements, and learn some basic worksheet concepts while exploring the Excel screen. Students will also learn about creating and renaming folders for file management.
Business Forms
Students will learn to use Excel to design business forms and to customize both software and online templates. You will use the Internet to email a form and to access Microsoft Office Online.
Accounting Records
Students will learn to create accounting records and statements. They will use formulas, functions and formation to complete the tasks. Students will use the Internet to locate tax forms and rates.
Skills
Excel Basics
- Start Excel
- Explore the Excel workbook
- Explore menus and toolbars
- Set view preferences
- Navigate the worksheet
- Use scroll bars
- Use the Go To command
- Create a folder for saving workbooks
- Rename a folder
Business Forms
- Enter text, dates, and numbers
- Use Smart Tags
- Format cell data
- Format dates
- Format for currency
- Format text
- Use Save and Save As
- Edit cell data
- Edit cell contents
- Align cell data
- Clear cell contents
- Check spelling
- Use the Thesaurus
- Use AutoComplete
- Use Print Preview
- Select a range of cells
- Set Print Area
- Change print settings
- Work with templates
- Save a file as a template
- View Web templates
Accounting Records
- Change row or column size
- Cut, copy, and paste
- Apply and clear number formats
- Use the Office Clipboard to cut, copy, and paste
- Use formula basics
- Enter functions
- AutoSum
- Enter the range in a formula
- AutoSum List
- Formula bar
- Use the Fill Handle tool
- Modify page setup options
- Orientation
- Set page margins and centering
- Edit formulas using the Formula bar
- Move selected cells
- Insert, view, and edit cell comments
- Apply and modify cell formats with the Format Cells dialog box
- Use the Format Painter
Assessment
Excel Basics
Business Forms
Accounting Records
Resources
Optional
April
Content and Essential Skills
Data Analysis
Students will learn to use Excel features, functions, and multiple worksheets and workbooks to create and complete analysis of business data. Completed worksheets and workbooks will be saved as a Web page.
Financial Reports
Students will learn to use logical functions, 3-D formulas, print settings, and the linking and formatting features in Excel to prepare financial reports.
Charts and Diagrams
Students will learn to use features in Excel to create, modify, print, and position charts, diagrams, and graphics.
PowerPoint Basics
Students will be introduced to PowerPoint and its basic features.
Skills
Data Analysis
- Apply and modify cell formats
- Cell borders
- Decimal place and negative number format
- Insert a page break
- Lists
- Sort lists
- Filter lists using AutoFilter
- Use numeric labels
- Indent text
- Insert and delete rows and columns
- Use formulas with absolute and relative reference
- Convert workbooks into Web pages
- Add a Background Pattern
- Use Web Page Preview
- Save a workbook as a Web page
- Apply and modify worksheet formats
- AutoFormat
- Fill color and font color
- Modify workbooks
- Insert and delete worksheets
- Move and copy worksheets
- Rename and format worksheet tabs
- Group worksheets
- Use date formats and functions
- Use financial functions
- The PMT functions
- The FV function
- The PV function
- Use Paste Special, Values
Financial Reports
- Merge, center, and split cells
- Workbook layout and links
- Split and arrange multiple workbooks
- Paste link between workbooks
- Hide workbooks
- Work with hyperlinks
- Insert a hyperlink
- Use a hyperlink
- Edit a hyperlink
-Modify row and column layout
- Hide and unhide rows and columns
- Freeze and unfreeze rows and columns
- Modify page set up options
- Print nonadjacent sections of a worksheet
- Print titles
- Use logical functions in formulas
- Add headers and footers to worksheets
- Add customized headers and footers
- Enter 3-D references
- Use styles
- Apply a style
- Define a new style
- Modify a style
- Remove a style
- Find and replace cell data and formats
- Find cell data
- Find and replace data and formats
Charts and Diagrams
- Create, modify, and position charts
- About charts
- Create charts
- Apply chart options
- Create pie chart
- Position a chart
- Chart types and subtypes
- Modify charts
- Copy and paste charts
- Format charts
- Print charts
- Create, position, and modify graphics
- Insert and download graphics and clip art
- Create, modify, and position diagrams
- Create stock charts
PowerPoint Basics
- Start PowerPoint
- Explore the PowerPoint window
- Open a presentation
- Navigate through a presentation
- Change views
- Run a slide show
- Select page setup options
- View a presentation in grayscale or black and white
- Print a presentation
Assessment
Data Analysis
Financial Reports
Charts and Diagrams
PowerPoint Basics
Resources
Optional
May
Content and Essential Skills
Informative Presentations
Students will learn to use PowerPoint features to create and enhance informative presentations, which either report or explain. Students will complete presentations on the following topics:
- Marketing strategies for a new product
- Information about the care of plants
- Information about a company’s services
- A new employee orientation
- Information about a travel destination
Sale Presentations
Students will learn to use PowerPoint features to create effective sales presentations. Businesses use sales presentations to sell a product, a service or an idea.
Persuasive Presentations
Students will learn to use PowerPoint features to create persuasive presentations. Persuasive presentations should generate understanding, change or form attitudes or opinions, and build consensus.
Skills
May 2007 Informative Presentations
Students will learn to use PowerPoint features to create and enhance informative presentations, which either report or explain. Students will complete presentations on the following topics:
- Marketing strategies for a new product
- Information about the care of plants
- Information about a company’s services
- A new employee orientation
- Information about a travel destination
Sale Presentations
Students will learn to use PowerPoint features to create effective sales presentations. Businesses use sales presentations to sell a product, a service or an idea.
Persuasive Presentations
Students will learn to use PowerPoint features to create persuasive presentations. Persuasive presentations should generate understanding, change or form attitudes or opinions, and build consensus.
Informative Presentations
- Create a presentation using blank slides
- Apply slide layouts
- Add slide to a presentation
- Work with placeholders
- Add text to placeholders
- Move, copy, delete, and size placeholders
- Create a placeholder
- Format a placeholder
- Create a presentation using a design template
- Change slide color scheme
- Change slide background
- Create a custom background
- Replace fonts
- Move, copy, duplicate, and delete slides
- Work with clip art and photographs
- Insert clip art and photographs
- Edit clip art and photographs
- Apply slide transitions
- Apply animation schemes
- Check spelling and grammar
Sale Presentations
- Work with outlines
- Create a summary slide
- Hide a slide
- Link slides
- Format bullets
- Insert headers and footers
- Work with slide and title masters
- Save as a template
- Create a custom show
- Link to a custom show
- Link the table of contents slide to a custom show
- Work with Objects
- Create Shapes/AutoShapes
- Create WordArt
- Format objects
- Layer objects
- Group, ungroup, and regroup objects
- Use grids and guides
- Nudge objects
- Align or distribute objects
- Use Action buttons
Persuasive Presentations
- Use template presentations
- Use the AutoContent Wizard
- Work with tables, charts, and diagrams
- Work with media
- Use custom animations
- Use the annotation pen
- Work with a photo album
- Use handouts
- Use speaker notes
- Work with the Handout and Notes Master
- Rehearse timings
Assessment
Informative Presentations
Sale Presentations
Persuasive Presentations
Resources
Optional
