Computer Applications

Quick Links:
How to Download MS Office at Home
Word Excel Access PowerPoint Other Projects Resources
Ch. 1 Ch. 1 Ch. 1 Ch. 1 - 3 Purchasing a New Vehicle Final Exam Schedule  
Ch. 2  Ch. 2 Ch. 2   Plan A Trip Setting Up Printers
Ch. 3 Ch. 3     Final Project Mapping Network Drives

Monday
Jan. 23

Introduction:

Read over the Syllabus

  The signoff page must be returned by Friday; however, if you return it tomorrow with both sets of signatures you will receive extra credit.

  If I do not receive your signoff sheet, you will receive zeros on assignments until I receive your sheet!

Skyward passwords and assignments--Ask me if you don't know :)

Permanent seating arrangements TODAY!

Getting Started:

Log into your computers

Mapping Network Drives--we will do this together the first time

Create a folder within rm108users (Last Name First Name)

Create folders within your rm108user folder

Create a class website link on your Desktop

Add the class website as a Favorite

Setting Up Printers--Install sh108 K3920 printer

Tuesday
Jan. 24

ICT 1 PreTest

  • Administered through a computer program called ExamView

  • Must be made-up if absent or newly transferred.


Wednesday

Jan. 25

ICT 1 PreTest

  • Administered through a computer program called ExamView

  • Must be made-up if absent or newly transferred.

Thursday
Jan. 26

Word Unit

Assignment:

Word Chapter 1 Vocabulary List

  Open Vocab List

         Must be fully completed by test day

         Can use Google for at home completion

  Save as LastName Word Ch. 1 Vocab List

  Save to rm108user | Period # | Name | Word | Word Chapter 1 folder

Homework Assignment:

Word Chapter 1 Vocabulary List--there are no more in class work days on this assignment after today. If you are not finished with your vocab list, it now becomes homework and is due the day of the Word Chapter 1 test!

Friday
Jan. 27
Syllabus Due
Word Chapter 1

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.
CTE Standards: CA1.1 Modify and manipulate paragraphs and paragraph formatting.
                          CA1.6 Format characters and use the Help features.

Learning Target:

  Students will be able to identify and demonstrate how to format various elements of the text.

Assignment: NO PRINTING!

Word Chapter 1--Step-By-Steps

  Pages 4-53

         Picture of the mountain is located on the shared drive in the Word>Ch. 1>Picture folder>Mountain Trail

  Save As LastName Adventure Flyer

  Do not print!

Monday
Jan. 30

Assignment Due:

Word Chapter 1--Step-By-Steps

  Drop (copy/paste) your Word document into the DropBox.

Assessment (Rubric):

Format text, paragraph spacing, and document elements/themes

Word Chapter 1--Step-By-Steps

  Grab the rubric off of my desk for the Adventure Flyer

         We will go through the rubric together.

         Please ask questions to help further your understanding of entering, editing and formatting text.

Optional Study Aid:

Chapter Review--you may work with a partner

  Click here to open the review--(Open link, Print to K3920 printer, Print on Both Sides)

Tuesday
Jan. 31

End of Chapter Assignment:

In the Lab #1

  Update contact name to your name!

  Click here to open project file

  Save as LastName Puppy For Sale Flyer

  Click here for online steps and click here for project picture (also located on the 108shared drive)

   This allows you to work on it at home!

Extra Credit Homework Opportunity:

Design and Create a Water Park Flyer

  You may work with a partner or individually

  Click here for online instructions

  Save as LastName(s) Water Park

 


Wednesday

Feb. 1

End of Chapter Assignment DUE:

In the Lab #1

  Once you have dropped your file check with your teacher:

         Grab the rubric off of my desk for the Puppy for Sale Flyer

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Thursday
Feb. 2

Vocab List DUE

Extra Credit DUE:

Design and Create a Water Park Flyer

  You may work with a partner or individually

  Click here for online instructions

  Save as LastName(s) Water Park

In Class Review for the Test--KAHOOT!

Study for test:

  Word Ch. 1 Vocab List and Chapter Review assignments

  Online book companion site

o Flash cards, games, sample questions, practice tests, etc...

o Click HERE for help with how to navigate the online resource website.

Friday
Feb. 3

ExamView Test:
    
ExamView Word Chapter 1 Test

Word Chapter 2

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.

CTE Standards: CA1.1 Modify and manipulate paragraphs and paragraph formatting.
                          CA1.3 Customize document formatting.

Learning Targets:

  Students will be able to recognize and create MLA Documentation Style for research papers.

  Students will be able to edit and insert citations and their sources.


Assignment:
Do NOT print

Word Chapter 2--Step-By-Steps

  Pages 66-121

  o   As you step through EVERY time it has you type the name Teddy Bailey use your name instead!

  o   Keyboard shortcuts listed on Page 80--REVIEW FOR TEST!

  Save As LastName Biometric Devices Paper

 

 

Monday
Feb. 6

Assignment:

Step-by-Steps--work day

Tuesday
Feb. 7

Assignment DUE:

Step-by-Steps--work day--drop file by end of day

Assessment :

Word Chapter 2--Step-By-Steps

  Now that you have dropped your file:

         Grab the rubric off of my desk for the Biometric Devices Paper

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand


Wednesday

Feb. 8

Assignment:

Creating an Online Works Cited Page

  Want to work on at home or have more detailed instruction?
click here for online steps

Thursday
Feb. 9

Assignment DROPPED and Assessment Rubric DUE:

Online Works Cited Page

  Now that you have dropped your file:

         Grab the rubric off of my desk

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Extra Credit:
    
Antivirus Paper

  Click here for online project file

  Click here for online project steps

  Save As LastName AntiVirus Paper

Friday
Feb. 10

Extra Credit DUE

In Class Review Session!!

Study for the test on your own:

  Keyboard shortcuts--page 80

  Chapter 2 Study Questions

  Chapter 2 Review

  Word Ch. 2 Vocab List

  Online book companion site

o Flash cards, games, sample questions, practice tests, etc...

   
Monday
Feb. 13
ExamView Quiz--Covers All of Chapter 2

Word Chapter 3

Power Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.

CTE Standards: CA1.1 Modify and manipulate paragraphs and paragraph formatting.

                          CA1.3 Customize document formatting.

Learning Target:

  Students will be able to set and activate tabs/tab stops.

  Students will be able to create and format a table within a document.


Introduction:

Set Tabs, Remove Hyperlinks, Clear formatting button, Picture tools, Table Styles, Nonbreaking  characters


Assignment: NO PRINTING!

Word Chapter 3--Step-By-Steps

    Pages 138-164 Save As (LastName) Letterhead

  Pages 165-188 Save As (LastName) Thank You Letter

o   Page 187--After typing the envelope information do NOT hit print, instead click Add to Document (added to your Thank You Letter assignment)

Tuesday
Feb. 14

Assignment: NO PRINTING!

Word Chapter 3--Step-By-Steps

    Pages 138-164 Save As (LastName) Letterhead

  Pages 165-188 Save As (LastName) Thank You Letter

o   Page 187--After typing the envelope information do NOT hit print, instead click Add to Document (added to your Thank You Letter assignment)


Wednesday

Feb. 15

Assignment DUE:

Step-by-Steps--work day--Due end of day

Thursday
Feb. 16

Assessment (Rubric):

Word Chapter 3--Step-By-Steps

  Grab the rubric off of my desk for the Thank You Letter and Letterhead

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Assignments:

End of Chapter Assignments

In the Lab #2

  Pages 195-197

  Step #2d--Save As (LastName) Internship Letterhead

  Step #3f--Save As (LastName) Internship Letter

  Want to work on at home or have more detailed instruction?
click here for online steps
click here for theme
click here for swirl image

Friday
Feb. 17

Assignment:

In the Lab #2--work day

   
Monday
Feb. 20

No School!!

Tuesday
Feb. 21

Assignment DROPPED and Assessment Rubric DUE:

Word Chapter 3--End of Chapter Lab #2

  Grab the rubric off of my desk for the Internship Letter and Letterhead

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Extra Credit DUE Tomorrow:
    Applying Knowledge

   Save As (LastName) Extra Credit Resume & (LastName) Extra Credit Letter

  Find an Ad for your ideal high school job. You will need to turn in the ad you find, so make sure you print it or cut it out

  Create a Resume (10pts) use one of the templates listed under the Resume tab when you open Word to start a new document

  Cover Letter (15pts) for the potential job you found (see online examples here)

  Remember your letter should contain a letterhead similar to class examples, a table within the letter, and a bulleted list.

  Print Resume and Cover Letter then staple the job ad to the top

In Class Kahoot! Review Session!!

Study for test:

  Chapter 3 Vocab List

  Chapter 3 Questions and Answers

  Chapter 3 Review--see 108shared drive for answer key...complete it yourself first and then check your answers!

  Online book companion site

o Flash cards, games, sample questions, practice tests, etc...

Wednesday
Feb. 22
ExamView Quiz--Word Chapter 3

Extra Credit DUE:
    Applying Knowledge

Assignment/Homework:

Excel Chapter 1 Review--start on after you complete your test

  Click here to open the review--(Save to your Excel Chapter 1 folder)

Thursday
Feb. 23

Excel Unit

Excel Chapter 1

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.

CTE Standard(s): CA2.2 Insert formulas into a worksheet to enhance its functionality.
Learning Targets:

  Students will be able to construct a spreadsheet and apply basic formatting to the cells within

Introduction:
   click here to download the example

Assignment:

Excel Chapter 1--Step-By-Steps

  Pages 2-54

  You will be printing your assignments in this chapter

  Create a Header/Footer following these steps

  Save As (LastName) Bob Gleamin Budget

Friday
Feb. 24

Assignments DUE:

Step-By-Steps--drop into DropBox

   
Monday
Feb. 27

Assessment (Rubric):

Excel Chapter 1--Step-by-Steps

  Grab the rubric off of my desk for the Bob Gleamin Budget spreadsheet

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

End of Chapter Assignments

In the Lab #2

  Pages 61-62

  Create a Header/Footer following these steps

  Step #7--Save As (LastName) CinCar Satellite

  Want to work on at home or have more detailed instruction?
click here for click here for online steps

Tuesday
Feb. 28

Kahoot!--In Class Review Session!!

Assignment/Homework DUE:

Chapter Review

Assignment DUE and Assessment:

In the lab #2--drop into DropBox

  Grab the rubric off of my desk for the CinCar Satellite

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Study for test:

  Chapter 1 Study Questions

  Vocab List

  Online book companion site

o Flash cards, games, sample questions, practice tests, etc...


Wednesday

March 1

ExamView Quiz--Excel Chapter 1

Extra Credit DUE:
    Your Turn #2

 Save As (LastName) Sports and You Extra Credit

  Want to work on at home?
click here for online steps

Thursday
March 2

Excel Chapter 2

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.
CTE Standard(s): CA2.2 Insert formulas into a worksheet to enhance its functionality.

Learning Target:

  Students will be able to construct formulas and apply functions.

  Students will be able to identify and apply conditional formatting.

  Students will be able to setup and produce a print ready spreadsheet based on instructions.

Assignment:

Excel Chapter 2--Step-By-Steps

 Pages 66-118

   Save As (LastName) HyperMass Online Storage Salary Report

  Don't forget to add your Header/Footer following these steps on Page 111--you can leave Chief Financial Officer

  PRINT:

   Follow all printing steps on pages 113-116FIT ON 1 PAGE--turn in with rubric

   How to print everything on one page?
     Click HERE for help with printing on 1 page

Friday
March 3

Assignment DUE :

Excel Chapter 2--Step-By-Steps

 Pages 66-118

   Save As (LastName) HyperMass Online Storage Salary Report

  Don't forget to add your Header/Footer following these steps on Page 111--you can leave Chief Financial Officer

  PRINT:

   Follow all printing steps on pages 113-116FIT ON 1 PAGE--turn in with rubric

   How to print everything on one page?
     Click HERE for help with printing on 1 page

   
Monday
March 6

Assessment (Rubric):

Excel Chapter 2--Step-By-Steps--drop into DropBox and you will have 3 printouts to attach to the rubric.

  Grab the rubric off of my desk for the HyperMass Online Storage Salary Report

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

End of Chapter Assignments

Apply Your Knowledge

 Pages 119-120

  Open project file and then Save As to your folder

  Online detailed instruction? click here for online steps

  Save As (LastName) Briteeny Taxi Complete

  Step#6--Add Header/Footer following these steps

  Step#6--Print ENTIRE worksheet with Values--Fits on 1 page

  Step#8--Print SELECTION worksheet as Values--Fits on 1 page

  Step#8--Print ENTIRE worksheet as Formulas--Fits on 1 page

Tuesday
March 7

End of Chapter Assignments DUE and Assessment (Rubric):

Apply Your Knowledge--drop into DropBox

  Grab the rubric off of my desk for the Briteeny Taxi Complete

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Extra Credit:
    In the Lab#1--Loan Balance Worksheet

 Save As (LastName) Extra Credit HelpToday Report

  Want to work on at home or more detailed instruction?
click here for online steps

  Step#11--Add Header/Footer following these steps

  Step#11--Follow printing instructions and remember to print on 1 page


Wednesday

March 8

Kahoot! In Class Review Session!!

Extra Credit DUE:
    In the Lab#1--Loan Balance Worksheet

 Save As (LastName) Extra Credit HelpToday Report

  Want to work on at home or more detailed instruction?
click here for online steps

  Step#11--Add Header/Footer following these steps

  Step#11--Follow printing instructions and remember to print on 1 page

Study for test:

  Chapter 2 Study Questions

  Arithmetic Operators

  Examples of how Excel calculates formulas

  The different Option Buttons in Excel and what they mean

  Vocab List

  Chapter 2 Review--see 108shared drive for answer key...complete it yourself first and then check your answers!

  Function, Formulas, Operator Practice

  Online book companion site

o Flash cards, games, sample questions, practice tests, etc...

Thursday
March 9

ExamView Quiz--Excel Chapter 2

Purchasing a New Vehicle and Apply Advanced Real-World Excel Functions

Power Standard: 9-12.NC.3.2--Integrate technology into school, home, and community.
Learning Target:

  Students will be able to apply previous skills and concepts from Excel Chapters 1 and 2 in order to create a spreadsheet that calculates the cost of owning a vehicle in order to connect learning to real-world situations.

Assignment:

Purchasing a Vehicle

  Click to open project research requirements

  Complete steps before class time tomorrow

  Read steps carefully

Friday
March 10

Assignment:

Purchasing a Vehicle

  Click to open project spreadsheet requirements

  Read steps carefully

  Refer to chapters 1 and 2 for formatting references

   
Monday
March 13

Assignment DUE and Assessment (Rubric):

Purchasing a Vehicle--DUE Beginning of Class--1st 5 mins.

  Grab the rubric off of my desk for the Vehicle Purchasing Project

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Excel Chapter 3

Essential Standard: 9-12.NC.3.2--Integrate technology into school, home, and community.
CTE Standard(s): CA2.2 Insert formulas into a worksheet to enhance its functionality.
                             CA2.4 Create charts within a spreadsheet to represent data graphically.

Learning Targets:

  Students will be able to identify and create absolute cell references

  Student will be able to apply a variety of functions

  Student will be able to create and modify a variety chart styles

 

Introduction:

  Absolute vs. Relative References, Date Stamps, IF statements

Tuesday
March 14

Assignment:

Excel Chapter 3--Step-By-Steps

 Pages 133-191

   Save As (LastName) FroYoToGo Financial Projection

  DO NOT print on page 180

  STOP on page 187


Wednesday

March 15

Assignment DUE and Assessment (Rubric):

FroYoToGo Financial Projection

  Grab the rubric off of my desk for the FroYoToGo Financial Projection

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

Homework/Assessment:

Formula Practice

  Open Formula Practice Sheet

  Add your Name to the Header then PRINT and complete!

  This is your ticket into class tomorrow!!

Thursday
March 16

Formative Assessment:

Understanding Absolute vs. Relative cell references--Turn in Homework--Formula Practice Sheet

End of Chapter Assignment:

In the Lab #1

  Save As (LastName) Adaptive Solutions

  Part 1 & 2 ONLY--do not update the numbers in the last section of part 1 below the figure

  Want to work on at home or have more detailed instruction?
click here for online steps

Friday
March 17

End of Chapter Assignment DUE and Assessment (Rubric):

Adaptive Solutions

  Grab the rubric off of my desk for the Adaptive Solutions

         Completely fill out the rubric on your own

o   Please ask questions if there is something you do not understand

   
Monday
March 20

Kahoot! In Class Review Session!!

Extra Credit:
 Create Your Own (10 pts.)
           
o Choose a Topic
           
o Design Spreadsheet w/ a Chart
           o Use Formulas (absolute and relative cell references) and Functions (AVG, MIN, MAX, IF, Date Stamp, SUM)
           o Incorporate techniques from all chapters
           o Cannot replicate any assignment we have done or those laid out in the book
           o Type up a Word Document explaining why you should received the full 10 pts (what did you include that makes it worthy of ten points)
           o PRINT as: Values, Formulas, Chart, and Word Document

Study for test:

  Chapter 3 Chapter Review

  Homework Absolute vs. Relative references sheet

  Cell references

  Operators

 Online book companion site

o Flash cards, games, sample questions, practice tests, etc...

Tuesday
March 21

ExamView Quiz--Excel Chapter 3

Extra Credit DUE

 

Cumulative Project for Excel and Word--Plan A Trip

Power Standards:

     Design a research project using a variety of technologies to find information and to solve a real-world problem

     Integrate technology into school, home, and community.

     Incorporate knowledge and enhanced usage skills to create a product.

Learning Targets:

     Students will be able to utilize skills and concepts from Word and Excel combined with researching in order to construct projects related to planning and paying for a trip.

After you finish your test:

  Make sure you have a folder created titled LastName Plan A Trip with 2 subfolders--pictures and research

  Read the directions for our big end of unit project Plan a Trip that we will officially start tomorrow

    Pick a partner, you will have a $3,500 budget. You will need to tell Mrs. Lewis who you are working with by end of class.

  Research a place you would like to visit (OUTSIDE SD) so you can sign-up in class tomorrow.

  Do some quick basic research like...airfare costs (would it even be affordable), activities, etc...

    Do not start fully researching everything just incase your place is taken tomorrow.

  You CANNOT book airfare, hotels, and car rentals as packages!!!

  I would recommend having a backup destination as well :)

  If you are traveling outside of the United States

http://travel.state.gov/content/passport/fees/fees_837.html --Traveling outside the US...passport book or passport card?? SCREENSHOT THE PRICE!


Wednesday

March 22
Cumulative Project for Excel and Word--Plan A Trip

Assignment:

     Sign-up for your destination

  Start researching transportation--Flight costs? Rental car costs? Gas prices? Fuel tank size and gallon capacity?

     Read the section TRANSPORTATION for more directions on what and how to research

     Start completing your Research Rubric--Due Friday 3/30 beginning of class!

Research Resources:  

http://www.expedia.com/ --book flights, hotels, rental cars
http://www.travelocity.com/ --book flights, hotels, rental cars
http://www.hertz.com/ --one example of rental car site (you rent your car from your destination airport)
http://www.rentabikenow.com/ --bicycle rentals
https://travel.state.gov/content/passports/en/passports/information/fees.html --Traveling outside the US...passport book or passport card??
http://www.gasbuddy.com/ --find gas prices--You have to get gas at least ONCE while you are there

Minimum Research Goal for the Day - Select destination, "book" flight and XPS/PDF Flight Itinerary, "rent" a car and XPS/PDF Car Pickup Itinerary, find car fuel tank size and gas prices for the area (XPS/PDF/Screenshot)

Thursday
March 23
Assignment:

     Finish the TRANSPORTATION section

     Read the section LODGING for more directions on what and how to research

Minimum Research Goal for the Day - Finish researching the transportation section and start/finish researching a hotel

Friday
March 24
Assignment:

     Finish the LODGING section

     Research ACTIVITIES for each day of your vacation, except for travel days


Research Resources:
  

http://www.tripadvisor.com/ --search top places to visit in your city--go to actual website to fully research
Use Google to search for interesting places to see and visit!!

Remember each daily activity has to cost something...meaning they can't be free and it has to be "provable"!

Activities and food cannot be package deals!

Minimum Research Goal for the Day - Finish researching lodging and research your 5 activities

HOMEWORK:

     Finish the research for Transportation, Hotel and Activities by Monday and work on the completing the research rubric.

   
Monday
March 27
Assignment:

     Read the FOOD section for more directions on what and how to research

Research Resources:  

http://www.tripadvisor.com/ --search for restaurants in your city
http://www.urbanspoon.com/ --menus, food prices, restaurants
Airport websites will list the restaurants that are located in each airport terminal

Minimum Research Goal for the Day - Finish researching food
Tuesday
March 28
Assignment:

Read Activity List Requirements and View the Example

Open Word and start creating your Activity List.

Do not include your flights. I only want to see your DAILY activities!

Wednesday
March 29
Assignment:

Finish Activity List

** optional--turn into drop box for REVIEW not a grade--must be fully completed for me to evaluate it!

Thursday
March 30
Assignment:

Read Letter Requirements and View the Example

Open Word and start creating your Letter.

Your letter should be setup and formatted just like the letters you created for Word Chapter 3.

Assignment: DUE

     DUE Research Rubric--both sets of signatures required--this document was handed out during class Friday

Friday
March 31
Assignment:

Finish Letter Requirements and View the Example

** optional--turn into drop box for REVIEW not a grade--must be fully completed for me to evaluate it!

   
Monday
April 3
Assignment:

Read Flyer Requirements and View the Example

Open Word and start creating your Flyer.

Tuesday
April 4

CLASS MEET IN THE THEATER--SMARTER BALANCE TESTING IN LABS FOR JUNIORS

Wednesday
April 5

CLASS MEET IN THE THEATER--SMARTER BALANCE TESTING IN LABS FOR JUNIORS

Thursday
April 6
Assignment:

Finish Flyer Requirements and View the Example

** optional--turn into drop box for REVIEW not a grade--must be fully completed for me to evaluate it!

Assignment:

Read Cost Sheet Requirements and View the Example

Open Excel and start creating your Cost Sheet (Budget).

Remember no formulas=zero points!

Friday
April 7
Assignment:

Read Cost Sheet Requirements and View the Example

Open Excel and start creating your Cost Sheet (Budget).

Remember no formulas=zero points!

   
Monday
April 10
Assignment:

Finish Cost Sheet

** optional--turn into drop box for REVIEW not a grade--must be fully completed for me to evaluate it!

Tuesday
April 11
Assignment:

Read References/Works Cited Requirements and View the Example

Open Word and start creating your Works Cited by using the Reference tab just like we did in Word Chapter 2.

Wednesday
April 12
Assignment:

Finish References/Works Cited Requirements and View the Example

Read Title Page Requirements and View the Example

Use the remaining class time to go back through previous assignments and check for completion and put some extra finishing touches on them!!!

 

Project Points Breakdown--Rubric--Grade yourselves!

Organize your folder!!!


Thursday
April 13

Project Due--There are no extensions or exceptions! (even if you miss class this week or last week). This is a FIRM due date!

Make sure your folder has your last name(s) listed.
   example:
Lewis and Jacobs Plan A Trip

The following image shows how your folder should be organized:


DROP your folder!
   Must contain the following assignments:

    1. Activity List
    2. Flyer
    3. Letter
(w/ envelope if completing extra credit)
    4. Cost Sheet
    5. Works Cited
   
6. Title Page
    7. Itinerary
(if completing for extra credit)
Print & Staple in Order below
(Do NOT print the Itinerary)

      
1. Plan A Trip Completed Rubric
       2. Title Page

       3. Letter (Do NOT print the envelope!)
       4. Activity List
       5. Flyer

       6. Cost Sheet (3 printouts)-
Click HERE for help with printing on 1 page
         
o Worksheet in Value View (Don't forget Header/Footer)
          o Worksheet in Formula View (Don't forget Header/Footer)
          o Chart (Don't forget Header/Footer)

      7. Works Cited
      8. Research Rubric-
I reviewed this @ the beginning of the project

If you do not Print AND Drop your assignments you will NOT receive credit for the assignment.

Friday
April 14
No School
   
Monday
April
17
No School
Tuesday
April 18

Access Unit

Access Chapter 1

Essential Standard: 9-12.NC.3.2--Integrate technology into school, home, and community.
CTE Standard:
CA 3.1 Create a database table.

Learning Target:

     Students will be able to create and design a database, tables, forms, and reports.

Assignment:

Access Chapter 1--Tables

  In class assignment--Create PDF and DROP PDF

   How to Make PDFs?

   We will create Last Name Class Information Table together in class

 

Wednesday
April 19

Assignment:

Tables DUE

If you were absent on Wednesday, I have a copy of the Database we created in class, please let me know if you need it. You will have to copy it into your rm108user Access Chapter 1 folder in order to complete the below assignments.
**Please come in before school or during lunch to go over how to setup tables since you will have to do this on your own later.

 

Great introductory video for students https://www.youtube.com/watch?v=eQMc30gSPN8

Assignment:

Forms DUE

  Use Creating Forms instructions create Split Form and Form View

  Create PDFs and DROP PDFs and DROP Word Document Comparison

   How to Make PDFs?

 

Report DUE

  In class assignment--We will create Last Name Birthday Report together in class

   Use the Favorite Food instructions to create the Last Name Favorite Food Report--on your own

  Create PDFs and DROP PDFs and DROP Word Document Comparison

   How to Make PDFs?

 

All In Class Assignments dropped by today:
 
1. Classmate Table
  2. Birthday Report
  3. Favorite Food Report
  4. Split Form
  5. Form

Thursday
April 20

All In Class Assignments dropped by today:
  1. Report Differences Word document
  2. Form Differences Word document

End of Chapter Assignment:

Open your Access Chapter 1 folder---Create a LastName Dartt Database folder
Open the 108shared and then copy the Lab 1 Dartt Offsite Services database within the
Access Chapter 1 folder into your 108users Dartt Database Folder.

Dartt Offsite Services

  Detailed instruction--click here for online steps

  Save all PDFs into your LastName Dartt Database folder--You will have 4 PDFs when you're done!

   How to Make PDFs?

Friday
April 21

End of Chapter Assignment DUE and Rubric:

Dartt Offsite Services

  Drop your LastName Dartt Database folder with all PDFs into the drop box by the end of the period.--You will have 4 PDFs when you're done!

  Complete and submit the rubric once your folder is dropped.

Access Chapter 2

Essential Standard: 9-12.NC.3.2--Integrate technology into school, home, and community.
CTE Standard:
CA 3.2 Create relationships between tables and CA3.3 Perform queries and filter records
Learning Target:

     Students will be able to construct different types of queries.


Assignment:

Access Chapter 2--Queries

We are going to make queries together in class for our Classmates Database before starting in the book. So, if you were absent on this day, please see me for instructions/steps to update your database.
   
Monday
April 24

Assignment:

Access Chapter 2 Step-By-Steps

  Copy Bavant Publishing database from the shared drive into your 108user Access Ch. 2 folder

  Create a folder titled LastName Step by Steps--you will save all of your PDFs into this folder and then drop this folder for grading

Tuesday
April 25

Assignment DUE and Rubric:

Access Chapter 2 Step-By-Steps

  Drop your Step-by-Steps Folder

  What should you PDF and turn in for a grade?

 Complete and submit the rubric once your folder is dropped.


Wednesday

April 26

End of Chapter Assignment:

In the lab #2--Hockey Fan Zone

  Copy Hockey Fan Zone database from the shared drive into your 108user Access Ch. 2 folder

  Create a folder titled LastName Hockey Fan Zone--you will save all of your PDFs into this folder and then drop this folder for grading

  Click here for project directions/steps

Thursday
April 27

End of Chapter Assignment DUE:

In the lab #2--Hockey Fan Zone

  Drop your Hockey Fan Zone Folder

  What should you PDF and turn in for a grade?

Friday
April 28

End of Chapter Assessment Rubric:

In the lab #2--Hockey Fan Zone

 Complete and submit the rubric once your folder is dropped.

Extra credit (Choose 1 or the other):

Weather Database (13 pts.) --I have a rubric for this file :)

  Start from scratch!!

  Save your database as LastName Weather

  Detailed instruction? click here for online steps

  Create a folder titled LastName Weather--you will save all of your PDFs into this folder and then drop this folder for grading

  Hint: Research your cities weather information at home to save you TIME!

 

Create Your Own Database (15 pts.)

  Create at least 1 table with at least 5 fields (format your fields appropriately--currency, hyperlink, dates, etc...)

  Create 4 different queries based on what you have learned so far (less than, totals, zoom, wild card, show only 1, etc...)

  Create a report that utilizes grouping, sorting and a Totals of some kind--make it visually appealing

  Create a Form using Form View

Review for test:

  We will do a quick review in class! It will take most of the period.

   
Monday
May 1

Test:

  Access Chapter 2--Production Style Test--not ExamView

  Takes all class period--Be here and logged in before the bell rings--If you don't finish, you will receive zeros on the ones that are not done.

Extra credit DUE:

  Due by end of day

Tuesday
May 2

PowerPoint Unit

PowerPoint Chapter 2

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.

CTE Standard(s): CA 4.1 Create a presentation using presentation software and CA 4.2 Modify a presentation.
Learning Targets:

  Students will be able to create a PowerPoint presentation and use advanced printing.

  Students will be able to create a PowerPoint that utilizes the notes pane.

Assignment:

PowerPoint Chapter 2 Step-By-Steps

  Save as LastName Emergency Plan to your rm108user PowerPoint Chapter 2 folder.

  Add Header and Footer to your Notes and Handouts section of your PrPt.

  Pages 121-124--Print Speaker Notes


Wednesday

May 3

Assignment DUE and Rubric:

PowerPoint Chapter 2 Step-By-Steps

   Drop Emergency Plan

   Staple printouts to the completed rubric and submit for grading into the assignment basket


PowerPoint Chapter 3

Essential Standard: 9-12.CT.1.1--Incorporate knowledge and enhanced usage skills to create a product.

CTE Standard(s): CA 4.1 Create a presentation using presentation software.
                             CA4.2 Modify a presentation.
                             CA 4.4 Add visual appeal and animation to presentation
.
Learning Target:

  Students will be able to create a PowerPoint presentation that incorporates sound and video clips.

Assignment:

PowerPoint Chapter 3 Step-By-Steps

  Save as LastName Watch for Motorcycles to your rm108user PowerPoint Chapter 3 folder.

  Add Header and Footer to your Notes and Handouts section of your PrPt.

  Pages 167-171

     o Insert a Movie--located on the rm108shared drive
o Insert a Audio--located online (which changes often) use Dirt Bike Passes sound clip

  Pages 188-190--Print as Handouts

   Print out and submit Handouts with 3 slides per page for Watch for Motorcycles into the assignment basket

Thursday
May 4

Assignment DUE:

PowerPoint Chapter 3 Step-By-Steps

   Drop Watch for Motorcycles

   Staple printouts to the completed rubric and submit for grading into the assignment basket

Friday
May 5

Final Research Project

Power Standards:

     Design a research project using a variety of techonologies to find information and to solve a real-world problem

     Integrate technology into school, home, and community.

     Incorporate knowledge and enhanced usage skills to create a product.

Learning Targets:

     Students will be able to utilize skills and concepts from Excel, Access, and PowerPoint combined with researching in order to construct projects related to planning and paying for their future career and lifestyle.

Assignment:

  Make sure your have a folder created titled--LastName Final Project and a Picture folder and a Research Folder inside

  Part 1a: Do some career/job research to figure out what you'd like to do/be after high school.

        Use http://www.bls.gov/ or https://www2.careercruising.com/my/login/sd to find a career/job.
     If the career you want is not listed with a yearly salary on the BLS.gov website, you cannot use it!

  Part 1b--start creating your PowerPoint

Resources:

Symbaloo--All in One Resource Links!

Assessment (Optional Extra Credit): All 10 rubrics submitted on time with initials in order to be eligible for extra credit!!

Part 1a and Part 1b Spot Check Rubric--Due tomorrow beginning of class w/ initials

   
Monday
May 8

Assignment:

  Part 2 (Make a screenshot PDF of your Wages website screen...you will use those wages/numbers in Part 8 when creating your database)

You will need to site your sources on your PowerPoint--Remember use the Notes section within your PowerPoint

Resources:

PowerPoint Guidelines--Remember the 7 by 7 rule...MUST READ THIS BEFORE MOVING ON!!

Download a PowerPoint template---look for templates that will compliment your career choice! This is optional...not a requirement.

Assessment (Optional Extra Credit):

Part 2 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Tuesday
May 9

Assignment:

Part 3--Education--Find out what is needed!

DO NOT start looking up schools!
      Research what type of education/training/licensing is needed for your career/job and place on your PowerPoint
      Then start thinking about what schools would offer that type of training or education.


Wednesday

May 10

Assignment:

Part 3--Education--Find a school and it's related costs

Resources:

Collegeboard.com--help with finding college costs

Attending a college that is in the WUE programs, means you pay a lower tuition rate (In-State costs usually)
Click here to find out which colleges offer lower tuition based on WUE (Western Undergraduate Exchange)

Help finding Credit Hours

Assessment (Optional Extra Credit):

Part 3 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Thursday
May 11

Assignment:

Part 4--Create a Tour of the City you Chose to Live In

Resources:

How do you create a Hyperlink? Watch this video

Friday
May 12

Assignment:

Part 4--Create a Tour of the City you Chose to Live In

Part 5--Find a House

Assessment (Optional Extra Credit):

Part 4 Spot Check Rubric--Due Monday beginning of class w/ initials

   
Monday
May 15

Assignment:

Part 5--Find a House

Assessment (Optional Extra Credit):

Part 5 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Tuesday
May 16

Assignment:

Part 6--Find a Car--use this spreadsheet for formulas--open link and read directions in red

Part 7--Calculate Miscellaneous Expenses

Assessment (Optional Extra Credit):

Part 6 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Wednesday
May 17

Assignment:

Part 8--Create a Database

Assessment (Optional Extra Credit):

Part 7 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Thursday
May 18

Assignment:

Part 8--Create a Database

Assessment (Optional Extra Credit):

Part 8 Spot Check Rubric--Due tomorrow beginning of class w/ initials


Friday
May 19

Assignment:

Part 9--Create Pie Chart and Finish Excel

Assessment (Optional Extra Credit):

Part 9 Spot Check Rubric--Due Monday beginning of class w/ initials

   
Monday
May 22

Assignment:

Part 10--Cite Sources and Finalize PowerPoint formatting


Tuesday
May 23

Assignment:

Part 10--Cite Sources and Finalize PowerPoint formatting

Assignment:

Part 11--Extra Credit & Final Touches on PowerPoint (transitions, animations, working hyperlinks, spell check, 7x7 rule, etc...)

Resources:

     PowerPoint Guidelines Remember the 7 by 7 rule

Double Check--GRADE YOURSELF
  PowerPoint Rubric
  Excel Rubric
  Access Rubric

Assessment (Optional Extra Credit):

Part 10 Spot Check Rubric--Due tomorrow beginning of class w/ initials

Wednesday
May 24

Project Due:

There are no extensions or exceptions! This is a FIRM due date!

Since this is a STRICT DUE DATE! If you are absent on this day, I will pull the files you have in your folder and grade them!

Submit Project for Grading--Drop your entire Final Project Folder!!!
                                           Print PowerPoint and Excel files as listed below.

Folder titled LastName Final Project that includes:
  1. PowerPoint (Print as Handouts with 9 slides per page)
  2. Excel (Print on 1 page each...values, formulas, and chart)
  3. Access Database
  4. 2 PDFs (reports) and the 2 JPEGs of your reports Pictures
    (should be in their own folder within)
  5. Extra Credit files--movies/songs
  6. Pictures (should be in their own folder within)
An Image of what your folder should look like...organize it before you drop it!

If you do not Print AND Drop your project you will NOT receive credit for the project.

Finals

The review exam will be activated on 5/11 for student's to take outside of class time!!

How Does the Review Test Work?
 
1. There are 250 questions on the review. You will see fewer but the same questions on your final test.
  2. You can take the review test as many times as you want before final testing days start.
  3. You can stop halfway through the test, save and exit. When you return, it will start at the saved location.

  4. On the review there is a Check button (bottom left) to check your answers before getting to the end of the test.
  5. You may not print the test or copy questions from the test.

Sign into ExamView like you normally would to take a test.
Your password for the review is
password. Happy Studying! :)

Thursday
May 25

The entire class will be using ExamView to review for the final test

Friday
May 26
Period 1    8:15-9:45
Period 3    9:55-11:25
Lunch       11:25-12:35
Period 5    12:40-2:10
Make-up    2:10-3:30
   
Monday
May 23
Period 2    8:15-9:45
Period 6    9:55-11:25
Lunch       11:25-12:35
Period 4    12:40-2:10
Make-up    2:10-3:30
Tuesday
May 24
Period 7    8:15-9:45
Period 8   
9:55-11:25