Computer Applications

Computer Applications

Computer Applications is an introduction to the operation of Microsoft Office software, including Access, Excel, PowerPoint, and Word. This class aims to provide you with the knowledge necessary to use these applications in other classes, future employment, and in everyday life. 

It counts as 5 technology credits towards the 10 that are required for graduation!

 

Classroom Expectations & Grading

Click here to go to Student Docushare

 

SAMS Testing Site

Typing Practice

Online Typing Test
More Typing Games

Word 2007 Help

 

 

March 15-19

Monday
March 15

Start Excel - Data Files - open, extract, copy to Computer Applications folder

Basic Spreadsheet Information

White pages 4-17 Together

Skills Review, page 29, Together

Tuesday March 16

MicroType - Numeric KeyPad Lessons

Quick Review - Together

Unit A Activities - Salmon Handout

Grades, Candy Sales, Payday - Brown Handout

MicroType - Numeric KeyPad Lessons

Finish both handouts from yesterday (salmon and brown)

Thursday March 18

MicroType - Numeric KeyPad Lessons

Continue working on handouts - Salmon and Brown

When finished with both, do Study Plan - Handout in back

Friday
March 19

MicroType - Numeric KeyPad Lessons

Excel Spreadsheet Activity

March 8-12

Monday
March 8

Work Day

Finish:  Harry Potter, Teens, FBLA

Today's assignment:  Guitar Hero - it should look like this when you are finished!

Tuesday March 9

If you haven't started Guitar Hero - do so now.

If you started it yesterday and didn't quite finish it - do so now.

Other Missing Assignments - see teacher

Independent Challenges 1 and 2 from Unit D on pages 100-101

Wednesday March 10

SAMS Final Word Assessment

Missing Assignments- see teacher

Independent Challenges 1 and 2 from Unit D on pages 100-101

Visual Workshop in book, page 104

Thursday March 11

No School

Friday
March 12

Crazy Laws Final Word Assessment

When finished, work on any missing assignments!

 

March 1 - 5

Monday
March 1

Review

Word Unit C SAMS Test

Missing Assignments

If finished with everything - do this assignment sheet

Tuesday March 2

Unit D Files

Unit D white pages 78-86 Together

Skills Review, page 97 - instructions 1-5 Individually

Wednesday March 3

Open this file - Footprints

Quick Review - Breaks, Columns, Margins, Page Numbers

White Pages 88-94 Together

Finish all instructions Skills Review - pages 97-99 (Individually)

Thursday March 4

Review

Finish Skills Review, pages 97-99

Today's Assignment is Harry Potter - Gold Handout

Friday
March 5

Finish Harry Potter

Today's Assignment is Teens - Open this file and grab a brown handout

If you finish Teens - Begin FBLA

 

February 22-26

Monday
February 22

Quick Review - Borners/Shading, Footnotes/Endnotes

Finish Friday's assignments (SKills Review and Purple Handout)

  • Independent Challenge 1, page 72 - WD C-3.docx
  • Independent Challenge 2, page 73 - WD C-4.docx (Do the Advanced Challenge)
  • Real Life Independent Challenge, page 75 - Only instructions a, b, c,
  • Visual Workshop, page 76 - WD C-6.docx

Tuesday February 23

Work day

Finish Purple Handout - Tabs

New assignments

  • Independent Challenge 1, page 72 - WD C-3.docx
  • Independent Challenge 2, page 73 - WD C-4.docx (Do the Advanced Challenge)
  • Real Life Independent Challenge, page 75 - Only instructions a, b, c,
  • Visual Workshop, page 76 - WD C-6.docx

 

Wednesday February 24

Work Day

1st - Finish yesterday's assignments

Today's assignment is Chuck Norris

Thursday February 25

Unit C Review - Open this file

Work Day

1st - Do Chuck Norris if you didn't yesterday

2nd - Work on Missing Assignments

3rd - Today's Assignment is Name of the Game (white handout)

4th - Today's 2nd Assignment is Lyric Formatting

Friday February 26

Word Unit C Quiz

Work on missing assignments - do Unit C assignments 1st

February 15-19

Monday
February 15

Unit B Review Together
Today's Assignments:

  1. Independent Challenge 1, page 45 - no Advanced Challenge - WD B-3.docx
  2. Independent Challenge 3, page 47 - do the Advanced Challenge - WD B-5.docx
  3. Visual Workshop, page 48 - WD B-7.docx

Tuesday February 16

Work Day - Get Grade Sheet from teacher and work on all assignments that have a Z (zero). If you don't have your Rock and Roll PowerPoint turned in, do so today as that is worth a lot of points.

If finished with everything, open this assignment sheet and do it.

Wednesday February 17

Unit C - Formatting Text and Paragraphs

White pages 50-57 Together - WD C-1

Skills Review pages 69-70, Instructions 1-4 Individually - WD C-2

Thursday February 18

Quick Review pages 50-57 (Childers)

White pages 58-63 Together (Lambert)

Skills Review pages 69-71 - Continue where you left off yesterday thru Instruction 7

Friday February 19

Quick Review - Tabs, Indents, Bullets/Numbering

White pages 64-67 Together

  • Finish ALL of Skills Review - Print for Credit
  • Purple Handout on Tabs

 

February 8-12

Monday

February 8

Period 5 Meets from 11:30 - 12:59

Word Unit A - White Pages Together

  • Parts of Word Window - pages 4-5
  • Starting a Document - pages 6-13
  • Creating a Document Using a Template - pages 14-15
  • Viewing and Navigating a Document - pages 16-17

Go over Parts of a Business Letter - Byers

Assignments

  • White Handout - Byers and Crando
  • Skills Review - pages 19-20 - Individually

When finished with all of the above - finish up PowerPoints if needed - OR - do some online typing

Typing Practice

Online Typing Test
More Typing Games

Tuesday February 9

Period 2 Meets from 7:45 - 9:15

Same as Monday!

Wednesday February 10

Quick Review of Unit A Word

  • Parts of Screen, Selecting Text, Mini Toolbar, Parts of Business Letter, No Spacing
  • Learn - Margins, Headers/Footers, Word Wrap, Spell Check
  • Learn - Letterheads
  • Assignments - Letter to Mrs. Childers

Thursday February 11

Begin Unit B - White Pages 26-37 Together - You will need this file:  WD B-1.docx

Skills Review, pages 43-44, Instructions 1-4 Individually - You will need this file: WD B-2.docx

Friday February 12

  1. Continue Unit B White Pages 38-41 Together
  2. Period 2 - Begin the Skills Review on pages 43-44-
  3. Period 5 - Finish the Skills Review on pages 43-44
  4. When finished with Skills Review - work on missing assignments - the teacher will give you handout of all your assignments!
  5. If you have no missing assignments, turn to Word page 45 - open this file - WD B-3, and do the Independent Challenge 1.

February 1-5

Monday
February 1

No Class Period 2

Period 5 meets from 11:30-12:59

  • MicroType
  • Finish About Me - Upload to DocuShare
  • Begin Rock and Roll PowerPoint Project

Tuesday February 2

Period 2 meets from 7:45-9:15 (don't be late)

No Class Period 5

  • MicroType
  • Finish About Me - Upload to DocuShare
  • Begin Rock and Roll PowerPoint Project

Wednesday February 3

Go over Concepts Quiz

More PowerPoint Features

Finish Rock and Roll PowerPoint

Me PowerPoint

Thursday February 4

Quick Review

PowerPoint Assessment

Work on Missing PowerPoint Assignments

  • About Me
  • Rock and Roll
  • Me (yesterday's assignment)

Friday February 5

MicroType for 5 Minutes
  • Open up TestPowerPoint and finish it if you didn't yesterday - then upload to DocuShare again.
  • Finish Rock and Roll PowerPoint if you don't have it finished.
  • Finish ME PowerPoint if ou don't have it finished.
  • Once you have all PowerPoint finished, open this assignment sheet and do what it says. 

January 25-29

Monday
January 25

No Class Period 2!

Period 5 Class Meets from 11:35 - 12:59 (go to lunch at 11:00)

  • MicroType
  • Finish Computer Concepts PowerPoint and Structured Notes
  • Continue LPS PowerPoint and Features of PowerPoint
  • If Time Permits - Begin About Me

Tuesday January 26

No Class Period 5!

Period 2 Class Meets from 8:00-9:25

  • MicroType OR Web site
  • Finish Computer Concepts PowerPoint and Structured Notes
  • Continue LPS PowerPoint and Features of PowerPoint
  • If Time Permits - Begin About Me

Wednesday January 27

MicroType

Thursday January 28

MicroType

1st - Login to Student DocuShare and then Open a new Tab and go to my Web site

2nd - Click on the appropriate link:  - Period 2 Pictures - Period 5 Pictures

Insert Picture from File - Pictures/Shapes

Work on About Me

Bring a pencil for the test tomorrow!

Friday January 29

MicroType

Computer Concepts Test

Finish About Me if needed

January 18-22

Monday
January 18

No School

Tuesday January 19

No School

Wednesday January 20

First Day Technical Activities (server down - do Thursday)

First Day PowerPoint and Expectations

MicroType - 3 minute assessment

Data Files for Students

SAMS Testing Site - School ID Number V7631897

Thursday January 21

Technical Activities

First Day PowerPoint

Anatomy of a Computer Handout

Office 2007 Features in PowerPoint

Friday January 22

MicroType

Business Did You Know?

Computer Concepts PowerPoint

Understanding Essential Computer Concepts - Structured Notes

 

 

Links for Future Use

 

 

 

 

 

January 11-15

Monday

January 11

Mail Merge and Integration

Video Project - you will need this Excel file Arcade Maintenance Record

Semester Project

Tuesday

January 12

Review for Final

Wednesday

January 13

Finals Periods 1, 2, and 7

Thursday

January 14

Finals Periods 3 and 4

Computer Application's Final

Friday
January 15

Finals Periods 5 and 6

January 4-8

Monday

January 4

Integration Unit B Files - Click on link - Open - Extract All Files - Copy new Integration B folder to your Computer Applications folder.

Start Excel and open INT B-1.xlsx from Integration B folder

White pages Integration 20-27 Together

Skills Review, pages 28-29

Tuesday

January 5

Learn Mail Merge

You will need this spreadsheet file:  Service Hours

Wednesday

January 6

Snow Day

Thursday

January 7

Snow Day

Friday
January 8

Snow Day

 

December 14-18

Monday

December 14

Skills Review Together - Open this file!

Assignments

  1. Independent Challenge 1, page47
  2. Independent Challenge 2, page 47
  3. Independent Challenge 3, page 48 - no Advanced Challenge
  4. Visual Workshop - page 50

Tuesday

December 15

Quick Review using Santas List

Finish yesterday's Assignments.  When finished with the first 3 - the Independent Challenges, copy and paste the following queries from the exercises above to a Word file.

Save the word file as UnitBQueriesLastname and upload to DocuShare for credit.

When finished with the Visual Workshop on page 50, rename the HighPerformer's Query so your name is in the Query name and then Print it for credit.

Wednesday

December 16

Santa's List Assignment - purple handout

Golf Stats   Assignment - pink handout

Thursday

December 17

Christmas Movie PowerPoint - Instructions

We Wish You A Merry Christmas MP3 File

Friday
December 18

  1. Access Test - You will need this file for Quiz 3 - RealEstate
  2. Finish Christmas Movies PowerPoint
  3. Work on Missing Access Assignments
  4. Have a Merry Christmas

 

December 7 - 11

Monday

December 7

Access Unit B white pages together

Skills Review individually

Tuesday

December 8

Snow Day

Wednesday

December 9

Snow Day

Thursday

December 10

Snow Day

Friday
December 11

Do the 3 handouts in the back of the room

  1. Arcade
  2. Nascar
  3. Backpacks

 

 

November 30 - December 4

Monday

November 30

Begin Access Unit A - Understanding Relational Databases

Access Files - Open, Extract All Files, Copy to Computer Apps folder

Tuesday

December 1

Do the Basketball assignment - yellow handout.

Wednesday

December 2

Quick Review and Learning Together (sort, resize columns, decimals, date format, relationships, delete records, relationship report, save as 2007 database, orientation)

Assignments

  • Real Estate
  • Media
  • Celebrity Addresses

Thursday

December 3

Access

Finish Yesterday's assignments first

Today

  • Rap Albums
  • Movies
  • American Idol
  • Weather

Friday
December 4

Access Quiz

Work on missing assignments from Wednesday and Thursday

November 23-25

Monday

November 23

Fast Food Fun Project

Open the link above - follow directions to complete project!

PowerPoint presentation on Cyber Bullying.

Tuesday

November 24

Check your Grades so you know what you still have missing.

Finish Fast Food Fun Project

Finish Cyber Safety PowerPoint and upload again for more credit!

Wednesday

November 25

SAMS Test - Take the Word and Excel Childers Test

Work on Missing Assignments

Thanksgiving Activity

Thursday

November 26

No School - Happy Thanksgiving

Friday
November 27

No School

November 16-20

Monday

November 16

Create a new folder called Integration in your Computer Apps folder.

Begin Excel/Word Integration - Unit A Files - Open, Extract All, Copy to Integration folder

  1. White pages Integration 4 thru 11
  2. Skills Review pages 12-14

Tuesday

November 17

Today's Assignments:
  1. Finish Skills Review, pages 12-14
  2. Independent Challenge 1, page 14
  3. Independent Challenge 2, pages 14-15

Wednesday

November 18

PLAN Testing - Late Start

  1. Finish yesterday's assignments
  2. Do Independent Challenge 3, page 15
  3. Do Visual Workshop, Page 16
  4. Do White Handout - The Files needed to complete Extra Challenges are below:

Thursday

November 19

Cyber Bullying - Discussion, Videos, Handouts

Handout 1

Handout 2

Compy Handout

Friday
November 20

Finish yesterday's Handouts and then do this PowerPoint presentation on Cyber Bullying.

 

November 9-13

Monday

November 9

Quick Review

Excel Problem Test - Open this Files - Excel Test

Excel SAMS Test - Take the Excel Final Exam - Childers

Tuesday

November 10

Money Smart Week Activities

  • Cost of Raising a Child
  • This Check Won't Bounce

When finished, open this file and work on formulas and charts!  Note - there are several sheets in this one spreadsheet!

Wednesday

November 11

Everyone quickly do this.

Money Smart Week Activities

  1. Identity Theft Flyer
  2. Budget
  3. Informational Flyer on Credit in Word

Thursday

November 12

Continue working on MoneySmart activities from Tuesday and Wednesday.

When finished, open this file and work on formulas and charts!  Note - there are several sheets in this one spreadsheet!

Friday
November 13

1) Best Buy Shopping Spree File

1) Best Buy Shopping Spree Instructions

2) The Gap File

2) The Gap Instructions

3) Finish any missing assignments from this week!

November 2 - 6

Monday

November 2

Begin Unit D in Excel

Open the folder above - Extract All files - copy and paste to Excel folder.

Do Excel pages 84-94 - upload to DocuShare when finished.

Begin the Skills Review on Pages 97-98.  Try to finish with Instruction 4 before the bell rings!

Tuesday

November 3

Mrs. Childers is gone today - Mr. Wiehn will be your substitute.  You should work on the following assignments today:

  1. Finish the Skills Review you started yesterday, pages 97-98, ALL instructions
  2. Car Sales – Green Handout – BE SURE TO DO BOTH SIDES!
  3. Best Music – Brown Handout – BE SURE TO DO BOTH SIDES!

Upload all finished files to DocuShare for credit - Do not print!

You should not be on the Internet for any reason other than to check my Web site!

Wednesday

November 4

Finish yesterday's 3 assignments FIRST.

THEN - Pink Handout - Three Dog Bakery and Immigration

Visual Workshop on page 104

Thursday

November 5

Finish all Excel assignments.

When finished, take the Excel Unit C - Childers SAMS test. 

When finished, take the Excel Charts - Childers SAMS test.

Friday
November 6

Open this Excel Review

Grab a White Handout from back of room and complete the review.  The review is very similar to the Test on Monday - so if you have questions on how to do something, please ask!

October 19-23

Monday

October 19

SAMS Unit A & B Review

Today's Assignments

  • Organically Yours - Brown Handout
  • FunNGames - Brown Handout

Tuesday

October 20

Open EX C-1.xlsx and Save as QSTAdvertisingLastName to your Excel folder.

White pages 52-63, Together

Skills Review – Pages 71-72 - Instructions 1-6, Individually EX C-2.xlsx

When finished do MicroType Numeric Keypad!

Wednesday

October 21

Quick Review

White Pages 64-69 Together

Finish Skills Review - pages 71-72 - ALL Instructions

Independent Challenge 1 - page 73   EX C-3.xlsx

Thursday

October 22

Learn Icon Sets

  1. Finish Skills Review, pages 71-72 - ALL Instructions
  2. Independent Challenge 1 - page 73  EX C-3.xlsx
  3. White Handout
    • South Bend - EX C-4.xlsx
    • City Tech Force
    • Bayside Fitness
  4. Visual Workshop - page 78  EX C-5.xlsx

Friday
October 23

Check your grades and finish yesterday's assignments.

When finished, do:

October 12-16

Monday

October 12

MicroType - Numeric Keypad

Create an Excel folder in your Computer Application's folder

Unit A Files - Open, Extract All Files, Next, Next, Finish - Right Click and Copy folder - Paste it in your Excel folder.

Start Excel

Today: 

  • White pages 2-17 - Together
  • Skills Review, pages 19-20

Tuesday

October 13

MicroType - Numeric Keypad

Skills Review (instructions 4-8)

Today's Assignments - Blue Handout in Back of Room

Wednesday

October 14

MicroType - Numeric Keypad

Work Day in Excel

  • Finish Blue Handout - all 4 problems
  • Do the Green Handout - all 3 problems

Thursday

October 15

MicroType - Numeric Keypad

Unit B Files - Open, Extract All Files, Next, Next, Finish - Right Click and Copy folder - Paste it in your Excel folder.

White pages 26-41

Skills Review, pages 44-45

Friday
October 16

Quick Review (relative vs absolute)

Independent Challenge 2, page 47 (don't do the Advanced Challenge)

White Handout - IC3 and Real Life

Visual Workshop on page 50 if time permits

 

October 5 - 9

Monday

October 5

Review

Tables (merging)

When make lists - don't select the list heading

Help button

Work Time

  • 1st - Harry Potter if not finished
  • 2nd - Independent Challenge 1, page 100
  • 3rd - Independent Challenge 2, page 101
  • 4th - Visual Workshop, page 104

Tuesday

October 6

First do Oh Canada

Then work on Unit D Missing Assignments - Independent Challenges 1 & 2

Finished with both Independent Challenges - do the Visual Workshop on Page 104

Wednesday

October 7

First do FBLA - Formative Assessment

Second take the Unit D Quiz on SAMS

Then work on missing assignments from Unit D

  • Oh Canada
  • Independent Challenge 1
  • Independent Challenge 2
  • Visual Workshop

Finished with everything?  Do OLD - handout in back of room!

Thursday

October 8

1st - Guitar Hero Formative Assessment (White Handout)

2nd - Missing Work

3rd - Check out these Web sites

Friday
October 9

1st - Word Formative Assessment - Crazy Laws

2nd - SAMS Test - Word Final

September 28-October 2

Monday

September 28

MicroType

Today's Assignments

When finished with the above two assignments, work on missing assignments!

Tuesday

September 29

MicroType

SAMS Unit C Quiz

Finish Chuck Norris if you didn't yesterday

Today's assignments:  Lyric formatting And 12 Days of Christmas

Wednesday

September 30

MicroType

Unit D Files - Open, Extract All, Copy to Word Folder

White pages 78-91 Together

Skills Review pages 97-98, Instructions 1-7

Thursday

October 1

MicroType

Quick Review - headers/footers, breaks, page numbers, columns, sections, margins

Today's Assignments:

  • Finish the Skills Review pages 97-99, All Instructions!
  • Independent Challenge 1, page 100

Friday
October 2

MicroType

Assignments:

  • Harry Potter - Pink Handout
  • Independent Challenge 1, page 100

September 21-25

Monday

September 21

MicroType

White pages 58-63 (Tabs & Indents, Bullets & Numbering) - Together

Open LastMinuteDealsLastName

Skills Review - Open Franklin EDA Report LastName

  • Finish 1-4 first
  • Then do 5-7

Extra Challenges

Tuesday

September 22

MicroType

Open LastMinuteDeals - White Pages 64-67 Together

Open FranklinEDAReport - Skills Review Pages 69-71

  • Finish All Instructions and upload to DocuShare

Today's Assignments:

  • Extra Challenge 1 & 2 (Pink Handout)
  • Independent Challenge 1, page 72 - Jermanok

Files Needed for Pink Handout: 

Wednesday

September 23

Work Day

Check your Grades and work on missing assignments from Unit C

Today's assignments:

  • Independent Challenge #2, page 73 - Membership Drive
  • Visual Workshop, page 76 - Nina's Trackside

Thursday

September 24

MicroType

Unit C Review

Work on missing assignments in this order!

  1. IC1 - Jermanok, Page 72
  2. IC2 - Membership Drive, Page 73
  3. Any other missing assignments you have

Friday
September 25

Finish Jermanok and Membership Drive FIRST and then do:

  • Pink Sheet - Unit C Extra Challenges 1 & 2 (last 2 pages)
  • File Needed:  WD CX-1.docx

September 14-18

Monday

September 14

MicroType

Use the Byers Letter to Review Formatting, Spacing, and Parts of a Business Letter

Don't forget to hit the No Spacing button before typing letters!

Assignments -

  • Finish Byers and Edo Letters from Last Tuesday - Gold Handout
  • Moynihan Letter - Purple Handout
  • Crando Letter - Blue Handout
  • Wong Cover Letter - Word page 24

When finished with all letters, work on any other missing assignments from last week.

Tuesday

September 15

Check your grades

Work on missing assignments!

Wednesday

September 16

MicroType

Get Unit C Files

Review Unit B

Quiz Unit B - SAMS Testing Site

Work on missing assignments

Today's assignments:  Cut and Paste Practice

Thursday

September 17

MicroType

Begin Unit C - Formatting Text and Paragraphs

White Pages 50-57 Together

Skills Review pages 69-70, Instructions 1-4 Individually

Friday
September 18

MicroType

Quick Review

Name of the Game (thanks Shannon)

Finish Skills Review Instructions 1-4

 

September 7-14

Monday

September 7

No School

Tuesday

September 8

MicroType

Get Unit B Files saved to computer

Review Parts of a Business Letter - Byers

Assignments

Wednesday

September 9

MicroType

Begin Unit B in Word - Editing Documents

  • White pages 26-37 Together
  • File Needed WD B-1.docx
  • Open and save as WanderlustPRLastName

Assignment:

  • Skills Review pages 43-44, Instructions 1-4  Individually
  • File Needed:  WD B-2.docx
  • Open and save as PAOS2010PRLastName

MicroType or Baracuda typing game if you finish early

Thursday

September 10

MicroType

Continue Unit B in Word

  • White pages 38-41 Together
  • Open WanderlustPRPublic

Continue Skills Review, pages 43-44, Individually

  • Finish Instructions 1-4 and then do instructions 5-7 (do not do the Advanced Challenge)
  • Open PAOS2010PRLastName

MicroType or Baracuda typing game if you finish early

Friday
September 11

MicroType

Continue Unit B in Word

Assignments:

Finish Skills Review, Instructions 1-7

Independent Challenge 1, page 45

  • File Needed WD B-3.docx (don't do the Advanced Challenge)

Visual Workshop, page 48

Work on any missing assignments for this week!

MicroType or Baracuda typing game if you have everything finished!

Monday

September 14

August 31-September 4

Monday

August 31

Continue working on your About Me PowerPoint.

Make sure you meet all of the Requirements

I'll take your picture today so you have one to put on the first slide. 

Tuesday

September 1

Last day to work on About Me PowerPoint

  • Upload it to DocuShare when finished

When finished, open this assignment - ME - and begin!

Wednesday

September 2

Check your Grades - Yes means I have the assignment but I haven't graded it yet.

Sign up for SAMS testing together

Finish About Me PowerPoint and ME assignment from yesterday.

MicroType or Typing Games Online - Baracuda

Thursday

September 3

Creating Documents with Word 2007

White Pages 2-13 (together)

Skills Review Pages 19-20 (individually - Instructions 2-5)

Friday
September 4

Review Creating Documents with Word 2007

White Pages 14-17 (together)

Learn how to create a Letterhead

Finish Pages 19-20 (individually - Instructions 2-5)

Letter to Childers