Computer Equipment
Computer Hardware
Objectives:
Lecture: The Basics of Computer Hardware Powerpoint, “Personal Computer Hardware” at http://en.wikipedia.org/wiki/Computer_hardware, “Basic Hardware Glossary” at http://en.wikipedia.org/wiki/Glossary_of_computer_terms
“Learn what components are inside your PC” http://www.youtube.com/watch?v=4eNTlwnnhss
History of COmputers - https://www.youtube.com/watch?v=LvKxJ3bQRKE
Participation: Class Lecture and Discussion, Taking off PC case, Drawing and Labeling PC internal parts, creating a study guide of internal and external computer hardware parts
Assessment: Computer Hardware Quiz
- Identify key components of a desktop system
- Identify components by outlining briefly the definitions of each part
- Identify internal pieces (practical)
- Compose a basic diagram of inside pieces, along with definitions included
Lecture: The Basics of Computer Hardware Powerpoint, “Personal Computer Hardware” at http://en.wikipedia.org/wiki/Computer_hardware, “Basic Hardware Glossary” at http://en.wikipedia.org/wiki/Glossary_of_computer_terms
“Learn what components are inside your PC” http://www.youtube.com/watch?v=4eNTlwnnhss
History of COmputers - https://www.youtube.com/watch?v=LvKxJ3bQRKE
Participation: Class Lecture and Discussion, Taking off PC case, Drawing and Labeling PC internal parts, creating a study guide of internal and external computer hardware parts
Assessment: Computer Hardware Quiz
Operating Systems
Objectives:
Participation: Operating Systems Worksheet, Operating Systems PDF-lecture notes
Assessment: Computer Software Quiz
- Identify the purpose of the operating system.
- Identify the various elements of a computer's operating system.
Participation: Operating Systems Worksheet, Operating Systems PDF-lecture notes
Assessment: Computer Software Quiz
Word Processing
Using a Word Processor
Objectives:
Enter and Modify Text
Check Spelling and Grammar
Duplicate and Move Text
Format Text
Finding and Replacing Text
Use a Thesaurus
Create Hyperlinks
Email a document
Track Changes
Equations
Warm Ups: Proofreading Dropbox Folder and Website
Lecture: A guide to Microsoft 2010 p. 35 - 56
Participation: Orientation, Handbook
Assessment: Soccer, Computer Maintenance, Proposal, Taking Tests, Sculptors, Water, Conservation, Xeriscap
Enter and Modify Text
Check Spelling and Grammar
Duplicate and Move Text
Format Text
Finding and Replacing Text
Use a Thesaurus
Create Hyperlinks
Email a document
Track Changes
Equations
Warm Ups: Proofreading Dropbox Folder and Website
Lecture: A guide to Microsoft 2010 p. 35 - 56
Participation: Orientation, Handbook
Assessment: Soccer, Computer Maintenance, Proposal, Taking Tests, Sculptors, Water, Conservation, Xeriscap
Formatting Documents
Objectives:
Set Margins and indents
Create Lists
Setting tab Stops
Adding headers, footer,s, and page numbers
inserting graphics and screen shots
Creating templates and HTML files
Portfolio creation
Creating address labels
Creating Blogs
Warm Ups: Addresses and Invitations, Letter Formats, State Abbreviations, US Capitals
Lecture: A guide to Microsoft 2010 p.71-97
Participation: Training, Gadgets Map
Assessment: Inventory, Learning Journal, Welcome, Travel, Telecommuting, U.S. Presidents
Set Margins and indents
Create Lists
Setting tab Stops
Adding headers, footer,s, and page numbers
inserting graphics and screen shots
Creating templates and HTML files
Portfolio creation
Creating address labels
Creating Blogs
Warm Ups: Addresses and Invitations, Letter Formats, State Abbreviations, US Capitals
Lecture: A guide to Microsoft 2010 p.71-97
Participation: Training, Gadgets Map
Assessment: Inventory, Learning Journal, Welcome, Travel, Telecommuting, U.S. Presidents
Advanced Formatting
Objectives:
Formatting with styles and themes
Divide a document into sections
Formatting Columns
Use Tables
Create a Table of Contents
Insert SmartArt Graphics
Hyphenating a document
Creating brochures and newsletters
Adding citations and a bibliography
Using text boxes
Warm Ups: Addresses and Invitations, Letter Formats, State Abbreviations, US Capitals
Lecture: A Guide to Microsoft 2010 p. 113 - 143
Participation:Volcanoes, Tutoring, Space Transmissions
Assessment: Elements, Saturn
Formatting with styles and themes
Divide a document into sections
Formatting Columns
Use Tables
Create a Table of Contents
Insert SmartArt Graphics
Hyphenating a document
Creating brochures and newsletters
Adding citations and a bibliography
Using text boxes
Warm Ups: Addresses and Invitations, Letter Formats, State Abbreviations, US Capitals
Lecture: A Guide to Microsoft 2010 p. 113 - 143
Participation:Volcanoes, Tutoring, Space Transmissions
Assessment: Elements, Saturn
Microsoft excel
Using a Spreadsheet
Objectives:
Entering worksheet data
Editing cell contents
Formatting cells and apply themes
Using formulas to perform calculations
Copying and pasting between Word and Excel
Conditional Formatting
Adding Graphics
Protecting worksheets and workbooks
Using tools to review a worksheet
Using Templates
Creating HTML files
Warm-Ups: Business Math Dropbox Folder
Lecture: A Guide to Microsoft Office 2010 p.155 - 188
Participation: Dept Memo, Gadgets Logo, Summer Sales
Assessment: YC Logo, TWO News, Tour Prices, Keypad, Sales Analysis
Entering worksheet data
Editing cell contents
Formatting cells and apply themes
Using formulas to perform calculations
Copying and pasting between Word and Excel
Conditional Formatting
Adding Graphics
Protecting worksheets and workbooks
Using tools to review a worksheet
Using Templates
Creating HTML files
Warm-Ups: Business Math Dropbox Folder
Lecture: A Guide to Microsoft Office 2010 p.155 - 188
Participation: Dept Memo, Gadgets Logo, Summer Sales
Assessment: YC Logo, TWO News, Tour Prices, Keypad, Sales Analysis
Functions and Data Organization
Objectives:
Modifying and creating cell styles
Inserting and deleting columns and rows
Using functions
Using absolute cell references in formulas
Sorting data
Printing large worksheets
Creating amortization tables
Working with multiple sheets
Asking "What if?" questions
Lecture: A Guide to Microsoft Office 2010 p. 213 - 241
Participation: Planets, Commission Summary, Payroll, Loan, Car Sales, Fundraiser
Assessment: School Loan
Modifying and creating cell styles
Inserting and deleting columns and rows
Using functions
Using absolute cell references in formulas
Sorting data
Printing large worksheets
Creating amortization tables
Working with multiple sheets
Asking "What if?" questions
Lecture: A Guide to Microsoft Office 2010 p. 213 - 241
Participation: Planets, Commission Summary, Payroll, Loan, Car Sales, Fundraiser
Assessment: School Loan
Creating Charts
Objectives:
Creating a pie, bar, and line charts
Moving, sizing, and deleting charts
Copying a chart to a Word document
Modifying and formatting charts
Exploring other chart types
Using sparklines
Lecture: A Guide to Microsoft Office 2010 p. 257 - 279
Participation: Continues, Temperature, Travel, Sales Quota
Assesment: Break Even, Business Analysis
Creating a pie, bar, and line charts
Moving, sizing, and deleting charts
Copying a chart to a Word document
Modifying and formatting charts
Exploring other chart types
Using sparklines
Lecture: A Guide to Microsoft Office 2010 p. 257 - 279
Participation: Continues, Temperature, Travel, Sales Quota
Assesment: Break Even, Business Analysis
Advanced Spreadsheet Techniques
Objectives:
Using Dates and Times
Creating Tables
Applying Data Validation
Creating Pivot Tables and Pivot Table Reports
Using the CHOOSE and VLOOKUP function
Naming a cell range
Freezing Cells
Creating Hyperlinks and Embedding Objects
Creating Macros
Lecture: A Guide to Microsoft Office 2010 p. 295 - 317
Participation: Corporate Sales, Employee Discounts, Payroll Memo
Assessment: Florida Flights, Music Sale, Business Payroll, Flower Store, Service Hours, Advertising Sales
Using Dates and Times
Creating Tables
Applying Data Validation
Creating Pivot Tables and Pivot Table Reports
Using the CHOOSE and VLOOKUP function
Naming a cell range
Freezing Cells
Creating Hyperlinks and Embedding Objects
Creating Macros
Lecture: A Guide to Microsoft Office 2010 p. 295 - 317
Participation: Corporate Sales, Employee Discounts, Payroll Memo
Assessment: Florida Flights, Music Sale, Business Payroll, Flower Store, Service Hours, Advertising Sales
Microsoft ACcess
Working with a Database
Objectives:
Using Forms
Populating a database
Using datasheets
Sorting and filtering records
Copying, importing, and collecting data
Lecture: A Guide to Microsoft Office 20120 p. 331 - 352
Participation: Gadgets Logo, Production Memo, New Retailer, Tiny Toys
Assessment: Museum Exhibits, Library, Boat Storage, Catering, Messages, Photo Collection, Puffin, Bear1, Bear2, Chicks, Lab
Using Forms
Populating a database
Using datasheets
Sorting and filtering records
Copying, importing, and collecting data
Lecture: A Guide to Microsoft Office 20120 p. 331 - 352
Participation: Gadgets Logo, Production Memo, New Retailer, Tiny Toys
Assessment: Museum Exhibits, Library, Boat Storage, Catering, Messages, Photo Collection, Puffin, Bear1, Bear2, Chicks, Lab
Relational Database Techniques
Objectives:
Developing a Database Schema
Creating a Database
Restricting Data Entry
Understanding Relationships
Creating Select Inquiries
Designing Range and Complex Queries
Using Wildcards, Fiels and parameters in Query Criteria
Utilizing an update query
Lecture: A Guide to Microsoft Office 2010 p. 363 - 402
Participation:Aligh Logo, Milla Hardware
Assessment: None
Developing a Database Schema
Creating a Database
Restricting Data Entry
Understanding Relationships
Creating Select Inquiries
Designing Range and Complex Queries
Using Wildcards, Fiels and parameters in Query Criteria
Utilizing an update query
Lecture: A Guide to Microsoft Office 2010 p. 363 - 402
Participation:Aligh Logo, Milla Hardware
Assessment: None
Analyzing Data in a Database
Objectives:
Creating and Modifying Reports
Printing Reports
Distributing Reports Electronically
Creating Calculated Fields
Exporting Access Data
Lecture: A Guide to Microsoft Office 2010 p. 417 - 438
Participation: Pizza Palace Logo
Creating and Modifying Reports
Printing Reports
Distributing Reports Electronically
Creating Calculated Fields
Exporting Access Data
Lecture: A Guide to Microsoft Office 2010 p. 417 - 438
Participation: Pizza Palace Logo
Microsoft Powerpoint
Creating Presentations
Objectives:
Planning a creating presentations
Editing and Formatting Slides
Adding and Deleting Slides
Viewing and Printing Presentations
Using Themes in a presentation
Adding Slide Footers
Using the Slide Master
Adding Graphics and Charts
Using Speaker Notes
Collaborating on a Presentation
Lecture: A Guide to Microsoft Office 2010 p. 449 - 470
Participation: Better Burger, Burger, Fat Content
Assessment: Management Plan, Align Logo
Planning a creating presentations
Editing and Formatting Slides
Adding and Deleting Slides
Viewing and Printing Presentations
Using Themes in a presentation
Adding Slide Footers
Using the Slide Master
Adding Graphics and Charts
Using Speaker Notes
Collaborating on a Presentation
Lecture: A Guide to Microsoft Office 2010 p. 449 - 470
Participation: Better Burger, Burger, Fat Content
Assessment: Management Plan, Align Logo
Advanced Powerpoint Features
Objectives:
Adding slide transitions and animations
Drawing annotations during a show
Creating Templates and HTML files
Adding Sound and Movies
Packaging a presentation
Creating hyperlinks on slides
Creating a Photo Album
Lecture: A Guide to Microsoft Office 2010 p. 497 - 505
Participation: Human Geography Quiz, Contini Logo, Guest House, Rooster, Chickens, AK Bear AK Caribou, AK Otter, AK Salmon, AK Sheep
Assessment: Meow, Scuba Anemone, Scuba Butterfly Fish, Scuba Coral, Scuba Gray Angel, Scuba Sponges, Bubbles
Adding slide transitions and animations
Drawing annotations during a show
Creating Templates and HTML files
Adding Sound and Movies
Packaging a presentation
Creating hyperlinks on slides
Creating a Photo Album
Lecture: A Guide to Microsoft Office 2010 p. 497 - 505
Participation: Human Geography Quiz, Contini Logo, Guest House, Rooster, Chickens, AK Bear AK Caribou, AK Otter, AK Salmon, AK Sheep
Assessment: Meow, Scuba Anemone, Scuba Butterfly Fish, Scuba Coral, Scuba Gray Angel, Scuba Sponges, Bubbles
Microsoft Publisher
Desktop Publishing
Objectives:
Create publications with objects
Viewing and printing publications
Inserting graphics
Using the master page
Using building blocks
Creating a greeting card
Adding text from a Word document
Creating a mail merge publication
Creating Template
Lecture: A Guide to Microsoft Office 2010 p. 513 - 535
Participation: SOS Quarterly, Peace River, Binoculars, Sage's Outdoor Supplies
Assessment: Music Lessons, Instruments, Music List
Create publications with objects
Viewing and printing publications
Inserting graphics
Using the master page
Using building blocks
Creating a greeting card
Adding text from a Word document
Creating a mail merge publication
Creating Template
Lecture: A Guide to Microsoft Office 2010 p. 513 - 535
Participation: SOS Quarterly, Peace River, Binoculars, Sage's Outdoor Supplies
Assessment: Music Lessons, Instruments, Music List
ALICE
Alice Lesson 1 - Getting Started
Objectives:
Identify scene components
Create and Save a new project
Add an object to a scene
Communicate the value of saving multiple versions of a scene
Code a simple programming instruction
Use copy and undo command
Understand the value of testing and debugging
Lecture: Lesson 1 Slides
Participation: Try It practice instructions 1 - 6
Assessment: Complete one of the Option activities: Mars or Wonderland
Identify scene components
Create and Save a new project
Add an object to a scene
Communicate the value of saving multiple versions of a scene
Code a simple programming instruction
Use copy and undo command
Understand the value of testing and debugging
Lecture: Lesson 1 Slides
Participation: Try It practice instructions 1 - 6
Assessment: Complete one of the Option activities: Mars or Wonderland
Alice Lesson 2 - Add Position Objects
Objectives:
Open a saved version of a project
Add multiple objects to a scene
Describe the difference between precise position and drag-and-drop (or imprecise) positioning
Use a one-shot procedure to precisely position an object in a scene
Edit properties of an object in scene editor
Describe three-dimensional positioning axes
Position the sub-parts of an object in a scene editor
Lecture: Lesson 2 Slides
Participation: Try it practice instructions 1-6
Assessment Complete one of the Optional activities: Ocean Scene, Snow Scene, or Amazon Scene
Open a saved version of a project
Add multiple objects to a scene
Describe the difference between precise position and drag-and-drop (or imprecise) positioning
Use a one-shot procedure to precisely position an object in a scene
Edit properties of an object in scene editor
Describe three-dimensional positioning axes
Position the sub-parts of an object in a scene editor
Lecture: Lesson 2 Slides
Participation: Try it practice instructions 1-6
Assessment Complete one of the Optional activities: Ocean Scene, Snow Scene, or Amazon Scene
Alice Lesson 3 - Procedures and Arguments
Objectives:
Toggle between and describe the visual differences between, the Scene editor and Code editor
Locate and describe the purpose of the methods panel
Use procedures to move objects
Add Java programming procedures to Code editor
Demonstrate how procedure values can be altered
Create programming comments
Reorder, edit, delete, copy disable programming statements
Test and debug and animation
Partipation: Try it practice instructions 1-6
Assessment: Complete one of the Optional activities: Cat & Chicken or Dolphin & Clown Fish
Toggle between and describe the visual differences between, the Scene editor and Code editor
Locate and describe the purpose of the methods panel
Use procedures to move objects
Add Java programming procedures to Code editor
Demonstrate how procedure values can be altered
Create programming comments
Reorder, edit, delete, copy disable programming statements
Test and debug and animation
Partipation: Try it practice instructions 1-6
Assessment: Complete one of the Optional activities: Cat & Chicken or Dolphin & Clown Fish
Alice Lesson 4 - Rotation & Randomization
Objectives:
Correlate storyboard statements with program execution
Add a control statement to the Code editor
Use random numbers to randomize motion
Participation: Try it Practice Instructions 1-4
Assessment: Complete one of the Optional Activites: Southwest Scene, Snow Theme, or Biped Scene
Correlate storyboard statements with program execution
Add a control statement to the Code editor
Use random numbers to randomize motion
Participation: Try it Practice Instructions 1-4
Assessment: Complete one of the Optional Activites: Southwest Scene, Snow Theme, or Biped Scene
Alice Lesson 5 - Declare Procedures
Objectives:
Compare and define an animation and a scenario
Write a storyboard
Flowchart a storyboard
Describe inheritance and how traits are passed from superclasses to subclasses
Describe when to implement procedural abstraction
Demonstrate how to declare a procedure
Identify and use procedural abstractions techniques to simplify animation development
Participation: Try It Practice Instruction 1-7
Assessment: Complete two of the Optional Activities: Flowchart or Visual/Textual Storyboard AND Amazon or Bunnies
Compare and define an animation and a scenario
Write a storyboard
Flowchart a storyboard
Describe inheritance and how traits are passed from superclasses to subclasses
Describe when to implement procedural abstraction
Demonstrate how to declare a procedure
Identify and use procedural abstractions techniques to simplify animation development
Participation: Try It Practice Instruction 1-7
Assessment: Complete two of the Optional Activities: Flowchart or Visual/Textual Storyboard AND Amazon or Bunnies
Alice Lesson 6 - Use Control Statements
Objectives:
Define multiple control statements to control animation timing
Create an animation that uses a control statement to control animation timing
Recognize programming constructs to invoke simultaneous movement
Participation: Try Practice Instructions 1-4
Assessment: Complete one of the optional activities: Fantasy or Ice Mountain
Define multiple control statements to control animation timing
Create an animation that uses a control statement to control animation timing
Recognize programming constructs to invoke simultaneous movement
Participation: Try Practice Instructions 1-4
Assessment: Complete one of the optional activities: Fantasy or Ice Mountain
Alice Lesson 7 - Use Functions
Objectives:
Use functions to control movement based on a return value
Participation: Try It Practice instructions 1-4
Assessment: Complete one of the Optional Activities: Lioness or Grassy Scene
Use functions to control movement based on a return value
Participation: Try It Practice instructions 1-4
Assessment: Complete one of the Optional Activities: Lioness or Grassy Scene
Alice Lesson 8 - If and While
Objectives:
Use IF control structure to effect execution of instructions
Use While control structure to create a conditional loop for repetitive behavior
Participation: Try It Practice instructions 1-4
Assessment: Complete one of the Optional Activities: Cheshirecat, Queen, or Desert
Use IF control structure to effect execution of instructions
Use While control structure to create a conditional loop for repetitive behavior
Participation: Try It Practice instructions 1-4
Assessment: Complete one of the Optional Activities: Cheshirecat, Queen, or Desert
Alice Lesson 9 - Use Expressions
Objectives:
Create an expression to perform a math operation
Interpret a math expression
Participation: Try it Practice instructions 1 - 4
Assessment: Complete one of the Optional Activities: Outer Space or Mad Hatter
Create an expression to perform a math operation
Interpret a math expression
Participation: Try it Practice instructions 1 - 4
Assessment: Complete one of the Optional Activities: Outer Space or Mad Hatter
Alice Lesson 10 - Use Variables
Objectives:
Understand variable and how they are used in programming
Participation: Try it Practice instruction 1-4
Assessment: Complete the only Optional Activity: Grass Scene
Understand variable and how they are used in programming
Participation: Try it Practice instruction 1-4
Assessment: Complete the only Optional Activity: Grass Scene
Alice Lesson 11 - Use Keyboard Controls
Objectives:
Use Keyboard controls to manipulate an animation
Participation: Try it Practice Instruction 1-4
Assessment: Complete one of the Optional Activities: Sea Floor or Hiking
Use Keyboard controls to manipulate an animation
Participation: Try it Practice Instruction 1-4
Assessment: Complete one of the Optional Activities: Sea Floor or Hiking
Alice Lesson 12 - Develop Complete Animation
Objectives:
Use functional decomposition to write a scenario and storyboard
Complete and animation
Test an animation
Re-position objects at a run-time
Plan the presentation of a completed animation project
Participation: Try it Practice Activities: 1-6
Assessment: Your own creation :)
Use functional decomposition to write a scenario and storyboard
Complete and animation
Test an animation
Re-position objects at a run-time
Plan the presentation of a completed animation project
Participation: Try it Practice Activities: 1-6
Assessment: Your own creation :)