Intro to Computers

Week

Unit

Topics of Focus

1

Office (Word and Excel)

Navigate the Word interface and become familiar with some of its most important features, such as the Ribbon, Quick Access Toolbar, and Backstage view; typing, editing, and organizing text; formatting text and paragraphs; layout and printing; working with objects(images, shapes, tables, charts); Use Excel to store, organize, and analyze information; cell basics; number formats;  worksheets and workbooks; formulas and functions; sorting and filtering data; tables and charts

2

Web Page Design

HTML for web page design; HTML tags and headings; images; styling and CSS

3-4

Animation

Plotting shapes and drawing with shapes; sequencing and debugging; simple commands; randomization; variables; sprites; loops; Booleans; conditionals

4-5

Game Design

Velocity; collision detection; complex movement; collisions; functions; the process; platform games; design a game

6-7

Programming

Python programming language; the micro:bit; scrolling text; using buttons; Input/Output; music on the micro:bit; randomization; gestures; directions; create a program

8-9

3-D Design

Explore sculptural issues and understand 3-D design principles as they relate to the integration of depth and space, volume and surface; Use TinkerCAD to make 3-D designs; program features and tools; design and print your own 3-D model

Week

Unit

Topics of Focus

1-3

Word

• Enter text in a Word document
• Check spelling as you type
• Format paragraphs
• Format text
• Undo and redo commands or actions
• Change theme colors
• Insert digital pictures in a Word document
• Resize pictures
• Format pictures
• Add a page border
• Adjust spacing
• Correct errors and revise a document
• Describe the MLA documentation style for research papers

• Modify a style
• Change line and paragraph spacing in a
document
• Use a header to number pages of a
document
• Apply formatting using keyboard
shortcuts
• Modify paragraph indentation
• Insert and edit citations and their sources
• Add a footnote to a document
• Insert a manual page break
• Create a bibliographical list of sources
• Cut, copy, and paste text
• Find text and replace text
• Find a synonym
• Check spelling and grammar at once
• Look up information		 • Change margins
• Insert and format a shape
• Change text wrapping
• Insert an online picture and format it
• Insert a symbol
• Add a border to a paragraph
• Clear formatting
• Convert a hyperlink to regular text
• Apply a style
• Set and use tab stops
• Insert the current date
• Create, modify, and insert a building
block
• Insert a Word table, enter data in the
table, and format the table
• Address and print an envelope

4-6

Excel

• Describe the Excel worksheet
• Enter text and numbers
• Use the Sum button to sum a range
ofcells
• Enter a simple function
• Copy the contents of a cell to a range
ofcells using the ll handle
• Apply cell styles
• Format cells in a worksheet
• Create a 3-D pie chart
• Change a worksheet name and sheet tab
color
• Change document properties
• Preview and print a worksheet
• Use the AutoCalculate area to display
statistics
• Correct errors on a worksheet

• Use Flash Fill
• Enter formulas using the keyboard
• Enter formulas using Point mode
• Apply the MAX, MIN, and AVERAGE
functions
• Verify a formula using Range Finder
• Apply a theme to a workbook
• Apply a date format to a cell or range
• Add conditional formatting to cells
• Change column width and row
height
• Check the spelling on a worksheet
• Change margins and headers in Page
Layout view
• Preview and print
• Rotate text in a cell
• Create a series of month names
• Copy, paste, insert, and delete cells
• Format numbers using format symbols
• Enter and format the system date
• Use absolute and mixed cell references in

 a formula
• Use the IF function to perform a logical
test
• Create and format sparkline charts
• Change sparkline chart types and styles
• Use the Format Painter button to format
cells
• Create a clustered column chart on a
separate chart sheet
• Use chart filters to display a subset of
data in a chart
• Change the chart type and style
• Reorder sheet tabs
• Change the worksheet view
• Freeze and unfreeze rows and columns
• Answer what-if questions
• Goal seek to answer what-if questions
• Use the Smart Lookup Insight
• Understand accessibility features

7-9

PowerPoint

• Select and change a document theme
and variant
• Create a title slide and a text slide with a
multilevel bulleted list
• Add new slides and change slide layouts
• Insert pictures into slides with and
without content placeholders
• Move and resize pictures
• Change font size and color
• Bold and italicize text
• Duplicate a slide
• Arrange slides
• Select slide transitions
• View a presentation in Slide Show view

 • Search for and download an online
theme
• Insert and format pictures
• Insert and size a shape
• Apply effects to a shape
• Add text to a shape
• Change the text font
• Insert a picture to create a background
• Insert and format WordArt
• Format slide backgrounds
• Find and replace text and check spelling
• Add and print speaker notes
• Color a photo
• Add an artistic effect to a photo
• Align paragraph text		 • Change views
• Ungroup, change the color of, and
regroup an illustration
• Copy a slide element from one slide
to another
• Insert and edit a video clip
• Insert an audio clip
• Control audio and video clips
• Insert entrance, emphasis, and exit
effects
• Control animation timing
• Change theme colors
• Change a theme and variant on
one slide
• Print handouts

Week

Unit

Topics of Focus

1-3

Word

• Border a paragraph
• Change paragraph indentation
• Insert and format a SmartArt graphic
• Apply character effects
• Insert a section break
• Insert a Word document in an open
document
• Insert formatted headers and footers
• Sort paragraphs and tables
• Use the format painter
• Add picture bullets to a list
• Create a multilevel list
• Modify and format Word tables
• Sum columns in a table
• Create a watermark
• Change theme fonts

 • Use a template to create a document
• Change document margins
• Personalize a document template
• Indent a paragraph
• Customize theme fonts
• Create and modify a style
• Insert a building block
• Save a Word document as a PDF file
and edit a PDF file
• Run the compatibility checker
• Enable others to access a document on
OneDrive
• Send a Word document using email
• Save a Word document as a webpage
• Format text as a hyperlink
• Change a style set		 • Explain the merge process
• Use the Mail Merge task pane and the
Mailings tab on the ribbon
• Use a letter template as the main
document for a mail merge
• Create and edit a data source
• Insert merge elds in a main document
• Use an IF eld in a main document
• Merge form letters
• Select records to merge
• Sort data records
• Address and print mailing labels and
envelopes
• Change page orientation
• Merge all data records to a directory
• Convert text to a table

4-6

Excel

• Assign a name to a cell and refer to
the cell in a formula using the assigned name
• Determine the monthly payment of a loan using the nancial function PMT
• Understand the nancial functions PV (present value) and FV (future value)
• Create a data table to analyze data in a worksheet
• Create an amortization schedule
• Control the color and thickness of
outlines and borders
• Add a pointer to a data table
• Analyze worksheet data by changing values
• Use range names and print sections of a worksheet
• Set print options
• Protect and unprotect cells in a
worksheet
• Hide and unhide worksheets and
workbooks

• Use the formula
• Format a consolidated worksheet
• Fill using a linear series
• Use date, time, and rounding functions
• Apply a custom format code
• Create a new cell style
• Copy a worksheet
• Drill to add data to multiple worksheets
at the same time
• Select and deselect sheet combinations
• Enter formulas that use 3-D cell
references
• Use the Paste gallery
• Format a 3-D pie chart with an exploded
slice and lead lines
• Save individual worksheets as separate
workbook
• View and hide multiple workbooks
• Consolidate data
• Create and manipulate a table
• Delete duplicate records
• Add calculated columns to a table with
structured references

 • Use the VLOOKUP function to look up a value in a table
• Use icon sets with conditional formatting
• Insert a total row
• Sort a table on one eld or multiple
elds
• Sort, query, and search a table using
AutoFilter
• Remove lters
• Create criteria and extract ranges
• Apply database and statistical
functions
• Use the MATCH and INDEX functions to
nd a value in a table
• Display automatic subtotals
• Use outline features to group, hide, and
unhide data
• Create a treemap chart

7-9

PowerPoint

• Insert a SmartArt graphic
• Insert images from a file into a SmartArt graphic
• Format a SmartArt graphic
• Convert text to a SmartArt graphic
• Create and format a chart
• Rotate a chart
• Change the chart title and legend
• Separate a pie chart slice
• Create and format a table
• Insert a symbol in a table
• Change table text alignment and
orientation
• Add an image to a table

 • Combine PowerPoint files
• Accept and reject a reviewer’s proposed changes
• Delete, reply to, and insert comments
• Reuse slides from an existing presentation
• Insert slide footer content
• Set slide size and presentation resolution
• Save les as a PowerPoint show
• Package a presentation for storage
• Save a presentation in a previous
PowerPoint format
• Inspect and protect files
• Use presentation tools to navigate
and annotate slide shows		 • Create a presentation from a Microsoft
Word outline
• Add hyperlinks to slides and objects
• Hyperlink to other Microsoft Office
documents
• Add action buttons and action settings
• Display guides to position slide elements
• Align placeholder text
• Create columns in a placeholder
• Change paragraph line spacing
• Format bullet size and color
• Change bullet characters to pictures and
numbers
• Hide slides

Coming Soon

Coming Soon

Week

Unit

Topics of Focus

1

Getting acquainted with the Adobe Animate Program

Starting Adobe Animate CC and Opening a File; Understanding Document Types; Getting to Know the Workspace; Working with the Library Panel; Understanding the Timeline; Organizing Layers in a Timeline; Using the Properties Panel; Using the Tools Panel; Undoing Steps in Animate; Previewing Your Movie; Modifying the Content and Stage; Saving Your Movie

2

Creating graphics and text

Understanding Strokes and Fills; Creating Shapes; Making Selections; Editing Shapes; Using Gradient and Bitmap Fills; Using Variable-Width Strokes; Using Swatches and Tagged Swatches; Creating Curves; Using Transparency to Create Depth; Being Expressive with the Paint Brush; Creating and Editing Text; Aligning and Distributing Objects;
Converting and Exporting Art

3

Creating and Editing Symbols

Importing Adobe Illustrator Files; About Symbols; Creating Symbols; Importing Adobe Photoshop Files; Editing and Managing Symbols; Changing the Size and Position of Instances; Changing the Color Effect of an Instance; Understanding Display Options; Applying Filters for Special Effects; Positioning in 3D Space

4

Animating symbols

About Animation; Understanding the Project File; Animating Position
Changing the Pacing and Timing; Animating Transparency; Animating Filters; Animating Transformations; Changing the Path of the Motion
Swapping Tween Targets; Creating Nested Animations; Graphic Symbols; Easing; Frame-by-Frame Animation; Animating 3D Motion; Animating Camera Moves; Testing Your Movie

5

Advanced motion tweening

About the Motion Editor; Understanding the Project File; Adding Motion Tweens; Editing Property Curves; Viewing Options for the Motion Editor; Copying and Pasting Curves; Adding Complex Eases

6

Animating shapes and using masks

Animating Shapes; Understanding the Project File; Creating a Shape Tween; Changing the Pace; Adding More Shape Tweens; Creating a Looping Animation; Using Shape Hints; Previewing Animations with Onion Skinning; Animating Color; Creating and Using Masks; Animating the Mask and Masked Layers; Easing a Shape Tween

7

Natural and character animation

Natural Motion and Character Animation with Inverse Kinematics; Creating a Walk Cycle; Disabling and Constraining Joints; Inverse Kinematics with Shapes; Simulating Physics with Springiness

8

Creating interactive navigation

About Interactive Movies; Creating Buttons; Understanding ActionScript 3.0; Preparing the Timeline; Adding a Stop Action; Creating Event Handlers for Buttons; Creating Destination Keyframes; Creating a Home Button Using Code Snippets; Code Snippets Options; Playing Animation at the Destination; Animated Buttons

9

Working with sound and video

Understanding the Project File; Using Sounds; Understanding Video; Using Adobe Media Encoder CC; Playback of External Video in Your Project; Working with Video and Transparency; Embedding Video

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon

Coming Soon