Computer System – Unit 1

Time Period / Standards / Unit/Chapter/Skills / Activities / Assessment
Approximate Time Frame:
6 class periods / Pennsylvania Academic Standards for Science and Technology:
3.7.7.C-Computer Operations
Explain and demonstrate basic computer operations and concepts.
  • Describe the function of advanced input and output devices and demonstrate their use.
/

Windows 7

  • Find an application using the search tool on the start menu
  • Pin a program to the toolbar
  • Create a shortcut on the desktop
  • Log Off / Shutdown / Restart / Sleep
File Management
  • Identify popular drives
  • Create folders
  • Rename existing folders and files
  • Copy, move, delete, existing files
Computer Systems
  • Identify types of computers
  • Identify types of input, output, and processing devices
/
  • Concept Review
  • Skills Review
  • Independent Challenges
  • Real Life Independent Challenge

Internet – Unit 2

Time Period / Standards / Unit/Chapter/Skills / Activities / Assessment
Approximate Time Frame:
5 class periods / Pennsylvania Academic Standards for Science and Technology:
Technological Devices
3.7.7.E – Computer Communication Systems
  • Describe the organization and functions of the basic parts that make up the World Wide Web
  • Apply basic on-line research techniques to solve a specific problem
/
  • Identify the elements of an Internet Explorer window
  • Use multiple tabs
  • Save websites in favorites
  • Effective web browsing
  • Evaluation of websites
/
  • Concept Review
  • Skills Review
  • Independent Challenges
  • Real Life Independent Challenge

Word – Unit 3

Time Period / Standards / Unit/Chapter/Skills / Activities / Assessment
Approximate Time Frame:
15 class periods / Pennsylvania Academic Standards for Science and Technology:
Technological Devices
3.7.7.C-Computer Operations
  • Know specialized computer applications used in the community
  • Demonstrate age appropriate keyboarding skills and techniques
3.7.7.D – Computer Software
  • Identify software designed to meet specific needs
  • Identify and solve basic software problems relevant to specific software applications
  • Demonstrate a basic knowledge of desktop publishing applications
  • Apply intermediate skills in utilizing word processing, database and spreadsheet software
  • Apply basic graphic manipulation techniques
/
  • Select, cut, copy, paste, move text
  • Document margins (Display / Hide ruler)
  • Page orientation
  • Assign fonts, sizes, colors, styles, effects, and alignments
  • Format painter /clear formatting
  • Line spacing
  • Insert bulleted and numbered list
  • Insert simple headers / footers
  • Page break / insert blank page
  • Insert and position a graphic into a document (resize, relocate, alignment)
/
  • Concept Review
  • Skills Review
  • Independent Challenges
  • Real Life Independent Challenge
/ UNIT 3 FINAL

Excel – Unit 4

Time Period / Standards / Unit/Chapter/Skills / Activities / Assessment
Approximate Time Frame:
15 class periods / Pennsylvania Academic Standards for Science and Technology:
Technological Devices
3.7.7.C-Computer Operations
  • Know specialized computer applications used in the community
3.7.7.D – Computer Software
  • Identify software designed to meet specific needs
  • Identify and solve basic software problems relevant to specific software applications
  • Apply intermediate skills in utilizing word processing, database, and spreadsheet software.
  • Apply basic graphic manipulation techniques
/
  • Identify rows, columns, and cells
  • Navigate to cells using the mouse and keyboard
  • Enter and delete data in a cell
  • Resize a cell to fit text
  • Select a cell or a group of cells
  • Insert and delete a row or column
  • Format data in a cell using the toolbar (fonts, sizes, colors, styles)
  • Format values (currency, percentage, comma style, decimal places)
  • Format cell (border, alignment, shading)
  • Understand basic formulas (+,-,*,/,%,^)
  • Functions (Autosum, Average, Max, Min, Count)
  • Copy a formula or function (fill) (use absolute cell reference $)
  • Create a chart
/
  • Concept Review
  • Skills Review
  • Independent Challenges
  • Real Life Independent Challenge

PowerPoint – Unit 5

Time Period / Standards / Unit/Chapter/Skills / Activities / Assessment
Approximate Time Frame:
15 class periods / Pennsylvania Academic Standards for Science and Technology:
Technological Devices
3.7.7.C-Computer Operations
  • Know specialized computer applications used in the community
3.7.7.D – Computer Software
  • Identify software designed to meet specific needs
  • Identify and solve basic software problems relevant to specific software applications
  • Identify basic multimedia applications
  • Apply basic graphic manipulation techniques
/
  • Create a new presentation
  • Select a design theme
  • Customize theme and backgrounds
  • Assign fonts, sizes, colors, font styles, and alignment to text
  • Insert new slides
  • Edit existing slides
  • Insert, position, and resize graphics
  • Insert a text box
  • Apply transitions and animations to slides
  • Set slides to advance automatically
  • Rearrange order of slides
  • Print presentation (full page slides, handouts, and notes)
/
  • Concept Review
  • Skills Review
  • Independent Challenges
  • Real Life Independent Challenge