Computer Tech 7 & 8 Scope and Sequence |
|
|
|
Key: |
I - Introduce |
|
|
R-Reinforce |
|
|
M- Master |
|
VOCABULARY AND IDENTIFICATION |
|
|
Use and understand basic computer related terms |
CT 7 |
CT 8 |
cursor |
M |
M |
scroll/drag/click |
M |
M |
special keyboard keys |
M |
M |
word processing |
M |
M |
hardware |
M |
M |
software |
M |
M |
menu |
M |
M |
web page |
M |
M |
edit |
M |
M |
internet |
M |
M |
URL/web address |
M |
M |
print |
M |
M |
electronic mail |
M |
M |
copyright |
M |
M |
software piracy |
M |
M |
text |
M |
M |
graphic |
M |
M |
file |
M |
M |
cyberspace |
M |
M |
login |
M |
M |
multimedia |
R |
M |
desktop publishing |
I |
R |
copy |
M |
M |
paste |
M |
M |
cut |
M |
M |
insert |
M |
M |
save and save as |
M |
M |
document |
M |
M |
justification |
M |
M |
open |
M |
M |
user name |
M |
M |
local area network vs wide are network |
I |
I |
password |
M |
M |
|
|
|
Identify basic computer hardware components |
7 |
8 |
keyboard and mouse |
M |
M |
monitor or screen |
M |
M |
printer |
M |
M |
file server |
M |
M |
hard drive |
M |
M |
storage devices |
M |
M |
network cables |
R |
R |
computer memory |
R |
R |
peripheral devices |
R |
R |
|
|
|
|
|
|
Demonstrate care and appropriate use of hardware |
7 |
8 |
demonstrate appropriate care and use of hardware/peripherals |
M |
M |
demonstrate appropriate care and use of storage devices and media |
M |
M |
demonstrate appropriate care and use of CD ROM |
M |
M |
demonstrate ability to turn computer off/on independently |
M |
M |
understand safety and ergonomic issues |
M |
M |
|
|
|
|
|
|
DEMONSTRATE BASIC COMPUTER MANAGEMENT SKILLS |
7 |
8 |
Basic Usage |
M |
M |
demonstrate ability to access and exit software |
M |
M |
save files to appropriate location |
M |
M |
demonstrate ability to manage files |
M |
M |
use multiple storage locations |
R |
M |
locate files in a directory |
M |
M |
log in using username/password |
M |
M |
demonstrate ability to organize file |
R |
M |
use web browser |
M |
M |
use navigational tools |
M |
M |
use pull down menus |
M |
M |
copy and paste a url/web address |
R |
M |
use hyperlinks |
R |
M |
transfer information/graphics from internet to local computer |
M |
M |
search |
M |
M |
search online reference resources |
I |
R |
conduct categorical search |
R |
M |
conduct keyword search |
R |
M |
understand and identify file extensions |
I |
I |
|
|
|
Evaluation/Assessment |
7 |
8 |
select information appropriate to problem/user |
R |
R |
assess validity of website |
R |
R |
|
|
|
|
|
|
Keyboarding |
7 |
8 |
touch type |
R |
R |
7th grade 30 WPM |
R |
R |
8th grade 40 WPM |
|
R |
|
|
|
|
|
|
Demonstrate appropriate legal/ethical conduct |
7 |
8 |
demonstrate responsible use of computers |
R |
R |
demonstrate appropriate computer etiquette |
R |
R |
respect the privacy of all users per rules in OHS Acceptable User Policy |
R |
R |
obey copyright laws |
R |
R |
|
|
|
|
|
|
SOFTWARE SPECIFIC SKILLS |
|
|
Word Processing |
7 |
8 |
Create and save a new document |
M |
M |
identify intended use |
M |
M |
use save and save as |
M |
M |
Open, view, and print documents |
M |
M |
use print preview |
M |
M |
print entire file or selected parts |
M |
M |
different views |
M |
M |
select text |
M |
M |
show/hide formatting marks |
I |
I |
understand toggle commands |
I |
I |
undo/redo/repeat |
M |
M |
Format documents |
M |
M |
justify text |
M |
M |
select font style and size |
M |
M |
Change font color and style |
M |
M |
Use different underline styles and font effects |
R |
R |
highlight text |
M |
M |
line spacing/before & after spacing |
R |
M |
use format painter |
I |
R |
understand styles and apply Quick Styles |
I |
R |
Create a new quick style |
I |
R |
change theme |
I |
R |
clear formatting |
R |
R |
set paragraph indents |
R |
M |
utilize the ruler |
I |
R |
change vertical alignment |
I |
R |
select page orientation |
M |
M |
set margins |
M |
M |
set and clear tabs & different tab alignments |
R |
R |
use headers, footers & pagination |
R |
R |
hanging indent |
R |
R |
Edit text |
M |
M |
change font style & size |
M |
M |
cut,copy,paste & delete text |
M |
M |
use office clipboard |
I |
R |
create and modify bulleted and numbered lists |
R |
R |
create an outline numbered list |
R |
R |
organize a document in outline view |
I |
R |
using spell check |
M |
M |
use the thesaurus |
R |
M |
insert symbols |
I |
R |
use find & replace |
R |
M |
use the Go To command |
I |
R |
use document statistics |
I |
R |
use autocorrect, autoformat, quick parts, autocomplete |
I |
R |
insert automatic date/time |
I |
R |
Use desktop publishing techniques |
R |
R |
insert and format graphics |
M |
M |
create columns |
R |
M |
Add borders and shading |
R |
M |
understand objects and how to use them in documents |
R |
M |
insert, resize, and move inline objects |
R |
M |
change inline object to a floating object |
I |
R |
recolor graphics |
I |
R |
draw and modify shapes |
I |
R |
set transparent color to a graphic |
I |
R |
add text to drawings |
I |
R |
create callouts |
I |
R |
create and modify SmartArt |
I |
R |
tables |
R |
M |
use text boxes |
R |
M |
insert clipart and pictures |
M |
M |
type reports |
R |
M |
generate letters |
R |
M |
add entries to a bibliography/works cited |
R |
R |
layer graphics |
I |
R |
group graphics |
I |
R |
type memos |
|
I |
type various business documents in correct format |
|
I |
create a letterhead |
|
I |
type table of contents |
|
I |
type title page |
|
I |
|
|
|
Use spreadsheet programs |
7 |
8 |
Create and save spreadsheets |
|
I |
identify intended use |
|
I |
open and existing workbook |
|
I |
save a workbook |
|
I |
specify data organization |
|
I |
determine columns and rows |
|
I |
identify and use active cell |
|
I |
select cells and enter data |
|
I |
find and replace data |
|
I |
set cell attributes |
|
I |
create simple calculation formulas |
|
I |
enter and edit data |
|
I |
Retrieve data |
|
I |
sort data |
|
I |
create various types of charts |
|
I |
preview & print spreadsheet |
|
I |
print formulas |
|
I |
Edit data |
|
I |
insert column or row |
|
I |
delete column or row |
|
I |
change column width and row height |
|
I |
position data within a cell by aligning, wrapping, rotating, and indenting |
|
I |
change the appearance of cells using fonts, font sizes, font styles, colors, and borders |
|
I |
designate the number format used for data stored in a cell |
|
I |
Use the format painter to copy formatting from one cell to another |
|
I |
apply and clear cell styles |
|
I |
Find and replace cell formats |
|
I |
copy and move date to other cells |
|
I |
use the drag and drop method and auto fill options to add data to cells |
|
I |
insert/delete rows, columns, and cells |
|
I |
freeze panes in a worksheet |
|
I |
split a worksheet window |
|
I |
check spelling in a worksheet |
|
I |
prepare a worksheet for printing |
|
I |
insert headers and footers |
|
I |
enter and edit formulas |
|
I |
distinguish between relative, absolute, and mixed cell references |
|
I |
use the point and click method to enter formulas |
|
I |
use the sum button to perform calculations |
|
I |
Use statistics bar to preview data |
|
I |
display formulas instead of results |
|
I |
preview calculations |
|
I |
identify parts of a function |
|
I |
enter formulas with functions |
|
I |
use functions to solve mathematical problems |
|
I |
use functions to solve statistical problems |
|
I |
use functions to solve financial problems |
|
I |
use logical functions to make decisions with worksheet data |
|
I |
use functions to insert times and dates in a worksheet |
|
I |
use text functions to format and work with cell contents |
|
I |
use fill down/across |
|
I |
use autofilter to display only specified data in a worksheet |
|
I |
apply conditional formatting to highlight data |
|
I |
hide worksheet columns and rows |
|
I |
insert a shape in a worksheet |
|
I |
insert a smartart graphic in a worksheet |
|
I |
use a template to create a new workbook |
|
I |
insert a hyperlink in a worksheet |
|
I |
save a workbook in a different file format |
|
I |
insert, edit, and delete comments |
|
I |
use the research task pane |
|
I |
move between worksheets in a workbook |
|
I |
rename worksheets |
|
I |
change the color of sheet tabs |
|
I |
reposition worksheets |
|
I |
high and unhide worksheets |
|
I |
insert and delete worksheets |
|
I |
create cell references to other worksheets |
|
I |
create 3-d reference formulas |
|
I |
print all or part of a workbook |
|
I |
arrange multiple workbooks in the program window |
|
I |
move and copy worksheets between workbooks |
|
I |
save updated spreadsheet |
|
I |
identify the purpose of charting worksheet data |
|
I |
identify the types of charts you can create in Excel |
|
I |
Create a chart embedded in a worksheet |
|
I |
move a chart to a chart sheet |
|
I |
update a data source |
|
I |
select chart elements |
|
I |
choose a chart layout and style |
|
I |
create a 3-d chart |
|
I |
display or hide chart elements |
|
I |
format and modify a chart |
|
I |
edit and format chart text |
|
I |
change the chart type |
|
I |
|
|
|
Use multimedia software |
7 |
8 |
use graphic tools |
R |
|
edit graphics |
R |
|
evaluate appropriate use of multimedia |
R |
|
incorporate clip art, digital pictures, and graphics |
R |
|
reorder slides, sort slides and create transitions |
R |
|
create a slide show |
R |
|
create animation |
I |
|
use slides and outline tabs |
I |
|
use notes pane |
I |
|
change layout |
I |
|
delete a slide |
I |
|
print a presentation |
I |
|
insert headers and footers in a slideshow and notes |
I |
|
apply themes |
I |
|
use the slide master |
I |
|
use the notes and handout master |
I |
|
edit pictures |
I |
|
add slides |
I |
|
find and replace text |
I |
|
add text to slides |
I |
|
add notes to slides |
I |
|
change alignment, spacing, case, and tabs |
I |
|
work with bullets |
I |
|
change font attributes |
I |
|
check spelling, style and usage |
I |
|
format slides |
I |
|
add clip art and sounds to slides |
I |
|
insert hyperlinks |
I |
|
apply custom animations |
I |
|
apply slide transitions |
I |
|
insert SmartArt graphic |
I |
|
convert text to a SmartArt graphic |
I |
|
change the style of a SmartArt Graphic |
I |
|
Add and format an organization chart |
I |
|
Enter text into a SmartArt graphic |
I |
|
Create and format WordArt |
I |
|
build and format charts |
I |
|
create a table |
I |
|
modify a table's style and layout |
I |
|
draw, select, manipulate, and format an object |
I |
|
scale and size an object |
I |
|
copy, move, and group objects |
I |
|
create a text box on a shape |
I |
|
animate shapes |
I |
|
order visual elements on a slide |
I |
|
insert objects on a slide |
I |
|
add a header or footer |
I |
|
record narration |
I |
|
record audio |
I |
|
insert audio and play through slideshow |
I |
|
record video |
I |
|
transfer video files from device |
I |
|
insert video into slideshow |
I |
|
format slideshow as a video |
I |
|
present slideshow to audience |
I |
|
|
|
|
Adobe Photoshop |
|
|
open picture |
I |
|
crop picture |
I |
|
resize picture |
I |
|
remove color (chroma key) |
I |
|
set a transparent background |
I |
|
save a picture as a psd, jpeg, gif |
I |
|
|
|
|
Google |
7 |
8 |
access and utilize Gmail |
I |
R |
access and utilize Google Drive |
I |
R |
share a file |
I |
R |
collaborate |
I |
R |
create a document |
I |
R |
create a spreadsheet |
I |
R |
create a presentation |
I |
R |
create a drawing |
I |
R |
|
|
|
Schoology |
7 |
8 |
Login and join course(s) |
I |
R |
access assignments |
I |
R |
access data files |
I |
R |
access course content |
I |
R |
navigate around the interface |
I |
R |
submit assignments |
I |
R |
create comments/discussion |
I |
R |
|
|
|
Computer Coding |
7 |
8 |
What is computer science? |
I |
R |
What is a computer scientist? |
I |
R |
Being a responsible computer scientist |
I |
R |
Applications of computer science |
I |
R |
Basic understanding of binary |
I |
R |
How to debug |
I |
R |
How the Internet works |
I |
R |
Programming concepts |
I |
R |
Sequencing |
I |
R |
Loops |
I |
R |
Conditionals |
I |
R |
Functions |
I |
R |
Functions with parameters |
I |
R |
Variables |
I |
R |
Computational Thinking |
I |
R |
Decomposition |
I |
R |
Patterns |
I |
R |
Abstraction |
I |
R |
Algorithms |
I |
R |
|
|
|
OneNote |
7 |
8 |
Creating a new notebook |
|
I |
working with pages and subpages |
|
I |
deleting pages |
|
I |
moving pages |
|
I |
typing into pages |
|
I |
inserting pictures |
|
I |
working with pictures |
|
I |
inserting symbols |
|
I |
using mathematical formulas |
|
I |
creating linked notes |
|
I |
using ribbon tools |
|
I |
working with text boxes |
|
I |
saving as a pdf |
|
I |
writing in pen and converting to type |
|
I |
|
|
|
Video |
7 |
8 |
Create a project in Premiere Elements |
|
I |
Choose project settings |
|
I |
import source clips |
|
I |
place clips on timeline |
|
I |
edit clips on timeline |
|
I |
chroma key out color |
|
I |
layer video tracks |
|
I |
insert a title |
|
I |
export to mp4 |
|
I |
create menu markers for scenes |
|
I |
create menu |
|
I |
create dvd |
|
I |
|
|
|
Internet/Online Safety |
7 |
8 |
Review personal media habits |
R |
|
respecting others works |
R |
|
creative rights and responsibilities |
R |
|
copyright, piracy, plagiarism |
R |
|
safe online talk |
R |
|
inappropriate and risky behavior |
R |
|
aspects of online talking and messaging |
R |
|
benefits and risks of presenting identities online |
R |
|
possible outcomes associated with online profiles |
R |
|
judge whether certain ways people present themselves online are harmless or harmful |
R |
|
analyze opportunities and limitations for expression in virtual worlds |
R |
|
learn they have a digital footprint |
|
R |
their online information can be searched, copied, and passed on and seen by large, audience and it can persist |
|
R |
people's online information can be helpful or harmful to their reputation and image |
|
R |
what do they want their digital footprint to look like in the future |
|
R |
understand how the ease of publishing on the Internet affects how much you can trust the content of some sites |
|
R |
learn criteria to help evaluate websites |
|
R |
apply the criteria to a site to determine how trustworthy and useful it is |
|
R |
reflect and identify digital drama and consequences |
|
R |
analyze online bullying behaviors that cross the line |
|
R |
learn about various ways cyber bullying occurs |
|
R |
adopt a point of view of teens who have been cyber bullied and offer solutions |
|
R |
identify points required for a creative work to fall under fair use |
|
R |
understand the value of fair use by reworking, remixing copyrighted material |
|
R |
|
|
|
Desktop Publishing |
7 |
8 |
publication terminology |
I |
|
choose a template |
I |
|
understand window and task panes |
I |
|
save a publication |
I |
|
modify a publication |
I |
|
create a publication |
I |
|
insert design gallery objects |
I |
|
print a publication |
I |
|
use guides |
I |
|
enter text |
I |
|
insert pictures/clip art/word art |
I |
|
work with objects |
I |
|
create columns |
I |
|
create double sided print document |
I |
|
|
|
|
Animation |
7 |
8 |
what is animation |
|
I |
how is animation create |
|
I |
create a object and animate the object |
|
I |
|
|
|
Career Exploration |
7 |
8 |
Create Log in for Career Information System |
|
I |
Create a portfolio |
|
I |
Learn about self |
|
I |
Research career options & clusters |
|
I |
Interest profile to match careers |
|
I |
Identify skills enjoyed |
|
I |
Identify work related needs and view matching occupation |
|
I |
Complete Assessment |
|
I |
Goal Setting |
|
I |
Make plans for future |
|
I |