TE11 Curriculum Map
From Brush Schools Wiki
Go back to main Technology page.
Contents |
August
Content and Essential Skills
Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks
Skills
Financial Functions, Data Tables, Amortization Schedules, and Hyperlinks
-Control the color and thickness of outlines and borders
-Assign a name to a cell and refer to the cell in a formula by using the assigned name
-Determine th monthly payment of a loan using the financial function PMT
-Enter a series of percents using the fill handle
-Create a data table to analyze data in a worksheet
-Add a pointer to a data table using conditional formatting
-Determine a present value of a loan using th PV function
-Create an amortization schedule
-Analyze worksheet data by changing values
-Add a hyperlink to a workbook
-Protect and unprotect cells
-Analyze worksheet data by goal seeking
Assessment
EX4Chex - WeSaveU National Bank Worksheet
Create a Amortization table for a car or house
-Use the Internet or a newspaper to obtain item, price, down payment, years, and interest rate
Resources
Microsoft Office 2000 Advanced Concepts and Techniques
Internet
Newspaper
Optional
September
Content and Essential Skills
Create a Business Card in Microsoft Word
Creating an Online Form
Working with a Master Document, and Index, and a Table of Contents
Skills
Create a Business Card in Microsoft Word
-Create labels and enter text and wordart
Create and Designing Personal Business Cards, Letterheads, and Envelopes
-Students will create individual business stationary with a common theme
-Students will use the Avery 5371 template to create the Business card
-Use the Header and Footer command to create the Letterhead
-Students will use the Avery 5160 template to create labels
-Students will use the Envelope and Labels command to create their envelope
Creating an Online Form (Proj 7)
- Design an online form
- Create a document template
- Highlight text
- Insert a table into a form
- Insert a text form field into a form
- Insert a drop-down form field into a form
- Insert a check box into a form
- Format form fields
- Use the Format Painter button
- Add help text to form fields
- Insert and format a rectangle drawing object
- Animate text
- Protect a form
- Open a new document based on a template
- Fill out a form
- Save data on a form in a text file
- Modify the location of workgroup templates
Working with a Master Document, and Index, and a Table of Contents
- Insert, modify, review, and delete comments
- Track changes in a document
- Save multiple versions of a document
- Accept and reject tracked changes
- Add and modify a caption
- Create a cross-reference
- Mark index enteries
- Password-protect a document
- Work with a master document and subdocuments
- Create and modify and outline
- Insert and format a diagram
- Create a table of figures
- Build and modify an index
- Create and modify a table of contents
- Add a bookmark
- Create alternate headings
- Set a gutter margin
- Use the Document Map
Assessment
WD7CHEX - Brim's Survey
Online Form-
Design and Create an Online form
Sketch form layout on scratch paper
Must include:
Table Layout
Instructions
Text Form Field
Check Box
Drop Down Form Field
Help Text
Format form
Resources
Optional
October
Content and Essential Skills
Working with Macros and Visual Basics for Applications (PowerPoint)
Use a computer to run a business
Students will be served with a list of various assignments that must be completed for a business in Morgan County (not a franchise)
Skills
Working with Macros and Visual Basics for Applications (PowerPoint)
-Create a toolbar
-Customize a toolbar by adding buttons -Use the macro recorder to create a macro
-Customize a menu by adding a command
-Open a presentation and print it by executing a macro
-Create a form to customize a presentation
-Create a user interface
-Add controls, such as command buttons and combo boxes, to a form
-Assign properties to controls
-Write code to create a unique presentation
Use a computer to run a business
-Choose a business in Morgan County
-Create an interview script to obtain the necessary information to complete these projects
-Discuss the possibility of substitute projects where applicable
-Students will choose the appropriate program to complete each project from the following list:
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Publisher
Adobe Photoshop
-Project 1: Getting Started-Logo
This first project will simply be designing a logo for your business. This can be done using the Adobe Photoshop and by importing clipart from outside sources to be used in your production. This logo will be used on all outgoing correspondence: memos, letters, invoices, etc. Be sure to try to make the logo "professional-looking." It should not look like it was thrown together at the last minute. This logo will represent your image in the industry. Save the logo as: LOGO
-Project 2: Getting Started-Letterhead
Create a letterhead to be used for all outgoing letters. This letterhead must include the logo created in Project 1 and must include the name of the company, manager name, company address and phone, manager's e-mail, and company telephone number. Save the letterhead as: LHEAD
-Project 3: Sale Flyer
Create a flyer for your business. Be sure to include information so that the customer could find your company, such as a map. The flyer should be carefully designed, professional in appearance, and should provide a brief description of your merchandise or services. Save flyer as: GOFLYER
-Project 4: Newspaper Advertisement
Create a quarter page newspaper advertisement, which will run in your local paper. Be sure to utilize your space wisely and to include either your company logo and/or slogan. Also, type a letter with this advertisement asking the paper for space and telling them how long you would like the ad to run. The letter should be created in the correct business letter format. Save the advertisement as: AD1 and the letter as: NEWS1
-Project 5: Door Sign with Hours
This is a simple desktop publishing project for your company. Create a nice sign, which designates the hours the company is open for business. Include your logo on this sign. Save the sign as: HOURS
-Project 6: Job Application
Create a job application to be used for potential employees. Be sure all the information you want prior to an interview is included. Save this as: JOBAPP
-Project 7: Welcome Letter
Prepare a welcome letter that might be mailed out to prospective customers. This letter should be on company letterhead and should include a description of your company and a friendly invitation for them to visit your business. It might be a good idea to include a coupon at the bottom of the page that the customer can use on their first visit. Be sure to use the salutation "Dear Prospective Customer" and include your store location, hours, and any other relevant information. Save this as: WELCOME
-Project 8: Business Card
Create a business card with the business logo and location. The card should include the manager’s name, company name, address, phone number, fax number, and e-mail address. Design a unique eye catching design. Save this as: BUSCARD
-Project 9: Invoice, Quotation Form, or Order Form
Create the forms to be used throughout the day to day operations of your business. Quotation forms should be used to provide estimates, order forms should be used to take orders from customers, and invoices should be used when shipping an order. Each form should contain your company logo and all important company information. These forms should be created in table format, either using word processing software to create tables or by creating the forms entirely in a spreadsheet program. Be prepared to enter in formulas to be used to add columns and multiply within rows. See examples. Save each as follows: INVOICE, QUOTE, or ORDER FORM
-Project 10: Menu - Catalog
Create a catalog or menu of your merchandise or services, including pictures as appropriate, a price list, shipping specifications, and any other information which would be useful to your customers. Your company must have 15-30 items/services for sale. The manager and all executives must be involved in this process. Save this publication as: CATALOG or MENU
Complete a cover page, table of contents and bind the final project in a professional manner.
Assessment
PP5Chex - The Other Side of the Desk Presentation
PP6Chex - Buying Your First Home Presentation
Business Plan Final Projects must be bound in a professional binder with a table of contents and cover page with the following assignments included.
Logo
Letterhead
Sale Flyer
Newspaper Advertisement
Door Sign w/Hours
Job Application
Welcome Letter
Business Card
Invoice, Quote, Order form
Menu/Catalog
Binder
Resources
Microsoft Office XP Post Advanced Concepts and Techniques
"Business Cards for Tara Dupre" Handout
"Tips on designing business cards" handout
Optional
November
Content and Essential Skills
Introduction to the power and features of Adobe Photoshop
Making accurate selections in Adobe Photoshop
Skills
Introduction to the power and features of Adobe Photoshop-("photoshop for beginners" DVD)
-Determine which tools to use and which tools to avoid
-Essential Techniques
-New document
-Building a master palette
-Workspace
-Navigation
-Making Selections
-Why select?
-Rectangle and Elliptical marquee
-Lasso tools
-Fine-tuning a selection
-Magic Wand
-Cropping
-Transformations
-Free transform
-Context-sensitive menu
-Using image size
-Painting Tools
-Brushes and the brushes palette
-Airbrush options
-Eraser
-Clone stamp tool
-Healing brush and patch tool
-The history palette and history brush
-Introduction to Layers
-The background layer
-Drag and drop layers
-Layer effects
-Opacity controls
-The type tool
-Locking layers
-Naming layers
-Flattening
-Image adjustments
-Variations
-Auto color
-Unsharp mask
-Show picture package
-Managing your images
-File browser
Making accurate selections in Adobe Photoshop-(adobe photoshop 7.0 selection secrets DVD)
-Learn the keys to using each selection tool
-Selection essentials
-Why we need selections
-Feathering
-Adding/Subtracting
-Hiding selection border
-Deselecting
-The select menu
-Selection tools
-Rectangular marquee
-Elliptical marquee
-Fixed size
-Lasso tools
-Magic Wand
-Selection timesavers such
-Saving selections
-Reselect
-Command-click selections
-Loading selections through layers
-Precise selections with the Pen tool
-Pen basics
-Converting into selection
-Save a clipping path
-Magnetic pen and Free form pen
-Alternative tools and methods that can serve as great selection tools
-Making round selections
-Transform selections
-Keyboard modifiers
-Adjustment layers
-The keys to advanced techniques
-Quick Mask
-Extract
Assessment
DVD Collage 1
Layers Tutorial
DVD Collage 2
Selection Tutorial - Melon Head
DVD Collage 3
Resources
Microsoft Office XP Introductory Concepts and Techniques Textbook
"photoshop for beginners" DVD
Layer Tutorial Packet
"adobe photoshop 7.0 selection secretes" DVD
Selection Tutorial Packet
"the secrets of retouching people" DVD
Optional
December
Content and Essential Skills
Portrait retouching, body sculpting, and dealing with common photo retouching tasks
Tools and techniques for creating text in Adobe Photoshop
Adobe Photoshop User Magazine
Tutorials
Skills
ortrait retouching, body sculpting, and dealing with common photo retouching tasks-("the secrets of retouching people" DVD)
-Anti Aging Techniques
-Removing wrinkles
-Hiding crows feet
-More realistic healing
-Using the patch tool
-Removing aging lines
-Retouching Skin
-Removing blemishes
-Smoothing skin
-Removing dark circles
-Enhance eyes
-Whitening eyes
-Fixing bloodshot eyes
-Creating catch lights
-Enhance eyelashes
-Portrait Retouching
-Balancing overall color
-Whitening teeth
-Removing hot spots
-Altering features
-Glamour softening
-Body Sculpting
-Slimming and trimming
-Losing the love handles
-Toning stomachs
-Trimming thighs
-Common Fixes
-Dodging and burning
-Recoloring hair
-Adding a smile
-Removing moire
-Fixing red eye
Assessment
Complete the following tutorials
-Ritz
-Post
-Son of Beach
-Tarzan
-Polaroid
-Media collage
Resources
Photoshop User Magazines
"adobe photoshop type secrets" video
"photoshop down and dirty tricks, part 1" video
"photoshop down and dirty tricks, part 2" video
"the best of photoshop user: the 5th edition" DVD
Optional
January
Content and Essential Skills
Replicate every element of a magazine cover using Adobe Photoshop
Skills
Replicate a Magazine Cover using Adobe Photoshop
-Text Selection
Shadows/Bevels/Effects
Color/Gradient/Stroke
-Logo
Shape, Text Selection, Layer Effects
Color/Gradient/Stroke
-Effects
Shape, Color, Texture, Filters, Layer
-Extra Text
Text Selection, Size, Effects
-Extra Graphics and Shapes
-Banners
-Characters
-Background
-Proportion
-Completeness
-Overall Appearance
Assessment
Completed magazine cover laminated and handed in with original
Resources
Magazines
Optional
February
Content and Essential Skills
Convert black and white picture to color
Create a family collage using the techniques learned in Photoshop
Skills
Convert black and white picture to color
-Scan b/w picture
-Retouch areas that are in need
-Use paint brush set to color mode to color every element of the picture
-Use the note tool to record each color used
Create a family collage using the techniques learned in Photoshop
-Scan family pictures
-Use quick mask to create borders for each picture
-Design an eye appealing layout
-Design a background that enhances the pictures
Assessment
Comparison sheet - b/w copy vs color copy
Completed family collage
Resources
Business owner
Sample Business Plans
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Microsoft Publisher
Adobe Photoshop
Optional
March
Content and Essential Skills
Learn the concepts and techniques used in the blue screen technique
Skills
-Learn the concepts and techniques used in the blue screen technique
-Students will take pictures with a digital camera in front of a blue screen.
-Use the extract command to remove the background
-Choose a background image sized appropriately to place their picture in
-Create an appropriate drop shadow
-Adjust the hue and saturation, brightness and contrast as needed
Assessment
Two completed pictures
-One realistic photograph
-One unrealistic photograph
Completed animation
Online Volcano Tutorial
Resources
Netscape
Adobe GoLive
Notepad
Optional
April
Content and Essential Skills
Learn the concepts and techniques used in the blue screen technique
Create animations using Adobe Imageready
Develop a web site using html code
Web Design Basics
An Overview of Web Publishing
Skills
Learn the concepts and techniques used in the blue screen technique
-Students will take pictures with a digital camera in front of a blue screen.
-Use the extract command to remove the background
-Choose a background image sized appropriately to place their picture in
-Create an appropriate drop shadow
-Adjust the hue and saturation, brightness and contrast as needed
Create animations using Adobe Imageready
-Students will use the animation window in ImageReady to create frames
-Add tween frames
-Save optimized image as a gif
-View animation in the Internet
Create a web page using an online tutorial
-Use Notepad
-Internet site
-Netscape composer
Web Design Basics
-Types of web sites
-Tools for creating web pages
An Overview of Web Publishing
-Basic design principles
-Writing for the web
-Understanding color on the web
Assessment
Two completed pictures
-One realistic photograph
-One unrealistic photograph
Completed animation
Online Volcano Tutorial
Resources
Netscape
Adobe GoLive
Notepad
Optional
May
Content and Essential Skills
Developing a Design Plan for a Web site
Typography and Graphics on the Web
Multimedia and Interactivity on the Web
Testing, Publishing, Marketing, and Maintaining a Web site
Skills
Developing a Design Plan for a Web site
-Define the purpose
-Identify the audience
-Plan the content
-Plan the structure
-Plan the web pages
-Plan the navigation
Typography and Graphics on the Web
-Typography tips
-Source for graphics
-Preparing and optimizing graphics
-Graphics file formats (JPEG, GIF, PNEG)
Multimedia and Interactivity on the Web
-Using slide shows
-Animation
-Audio
-Video
-Interactivity
Testing, Publishing, Marketing, and Maintaining a Web site
-Testing a web site before publishing
-Marketing the web site
-Maintaining and updating the web site
Assessment
Develop a plan for a web site
Create a web site on the topic of your choice
-Minimum Number of Pages 5
-Minimum Number of References 4
-Minimum Number of Web Links 6 -Minimum Number of Graphics 6
-Minimum Number of Animations 1
Resources
Adobe GoLive, Adobe Photoshop, Adobe ImageReady
Optional
