Week 1 – January 4th – 6th
Wednesday:: Updated-2016-Course-Syllabus, MicroType set up
A little bit about Mr Mercer
Assignment: MicroType, writing activity – describe a memorable 1st Semester activity using 8-10 complete sentences
Thursday: Begin PowerPoint
Today we will:
Know how to create a PowerPoint presentation
Understand what transitions and animations are
Be able to add formatting to a presentation
begin “Class Schedule” assignment if time
Friday:Today we will:
Know how to create a PowerPoint presentation
Understand what transitions and animations are
Be able to work on the “Class Schedule Assignment”
Week 2 – January 9th – 13th
Monday: Finish your “Class Schedule Assignment”, copy/paste in your “To Be Graded” folder
Begin work on your ALL ABOUT ME presentation
You will also know how to print a presentation and understand why it is recommended to print multiple slides per page
Tuesday: Finish All About Me!
Today you will know how to print a presentation, understand why its recommended to print multiple slides per page, and be be able to completer your All About Me assignment.
Wednesday: NEW ASSIGNMENT!
“Updated 2016 Choice PPT”
You will know where to find the Word Art button, understand a good use for it and be able to insert Word Art into your presentation.
Thursday: Continue working!! Check to see where everyone is with their progress…..
Friday: Finish Choice PowerPoint?
Week 3 – January 16th – January 20th
Monday: NO SCHOOL
Tuesday: NO SCHOOL, ICE DAY!
Wednesday: Story Starters – join Classroom
Thursday: NEW PowerPoint
10Things – read all directions, copy/paste to your “Done” folder when you have completed everything
Friday: Finish 10Things
Week 4 – January 23rd – January 27th
Monday: Finish PPT, begin Word section 1
open FCTVacSpecials and save it to your Word folder
Today you will know how to open a Word document,
understand some of the basic tools, and be able to locate and
use the tools in assignments on Tuesday.
Tuesday: Review Word basics, Template Introduction
Today you will know where to find templates in Word, understand how to make the template “yours” and be able to create a memo using a template.
Wednesday: New tools in Word
Today students will know how to find/replace text, use the thesaurus, and insert headers
Students will understand the importance of headers and be able to include them on future assignments.
Assign: americas got talent
Thursday: new memos
Assignment:
Customer Memo – re-type the memo from the handout into a memo template of your choice. Save as “CustomersLastName” and turn in electronically.
Business Memo – re-type the memo from the handout into a memo template of your choice. Save as “BusinessLastName” and turn in electronically.
Friday: 2 new assignments
Suzuki Letter (handout) – save as “Suzuki” – PRINT, make sure your name is at the bottom!
Extra Challenge 1 – open WD BX-1, follow the directions on the hand-out – ONLY DO CHALLENGE 1! Print when you are done.
Week 5 – January 30th – February 3rd
Monday: Finish work from Thursday and Friday
Tuesday: Open FCTOslo
Work on pages 38 – 41 on your own or together with the person sitting next to you
Save to your “Incomplete” folder when you are done, we’ll talk about it together on Wednesday
Wednesday: Review pages 38-41
NEW:
Open Working with Microsoft Word and be ready to learn more formatting for Word
Today we will know how to make formatting changes to a document, understand what an indent is, and be able to apply these formatting changes to a Word document.
Assignment: Open FCTPetersburg
Complete Skills Review 1 and 2, pages 62-63.
Save as “Section2SkillsReview” to your “Incomplete” folder, copy/paste to the “To Be Graded” folder when done.
Thursday:
Assignment: Lyric Formatting
Directions: Song Lyrics Directions
Friday: Today you will know how to perform a variety of formatting changes and understand where to find the buttons needed to make the changes. You will be able to complete 1 assignment.
Assignment: 20Questions
Open a blank Word document and make the formatting changes. Save as “20 Questions” and turn in electronically.
Week 6 – February 6th – February 10th
Monday: Today you will know how to perform a variety of formatting changes and understand where to find the buttons needed to make the changes. You will be able to complete 1 assignment.
Assignment: LastName_ABC
Tuesday: Today you will know how to set tab stops and understand why that task is important. You will be able to create tables using tab stops as well.
Open RailTravel (1) and use with the book, pages 52-55 TOGETHER
Wednesday: Today you will know how to set tab stops and understand why that task is important. You will be able to create tables using tab stops as well.
Assignment: 4 Tables Handout – turn in electronically when you are done
Thursday: Today you will know how to set tab stops and understand why that task is important. You will be able to create tables using tab stops as well.
Assignment: Turn both in electronically
Movie Ratings Handout
Grammy Winners Handout
Friday: Today you will know how to set tab stops and understand why that task is important. You will be able to create tables using tab stops as well.
Assignment: AT40 – read the directions and complete, turn in electronically
Week 7 – February 13th – February 17th
Monday: Today we will:
Know how to apply more formatting changes to a Word document
Understand what a theme is in Word and be able to apply theme changes to a Word doc
BOOK WORK TOGETHER:
Begin on page 56 using RailTravel-1
Assignment: Review 4 and 5, page 64,65
Open this: FCTVacPackages
***Raise your hand when you are done and I’ll check it off
Tuesday: Finish Review 4 and 5, tell me when you are done
NEW: Create your own menu
Wednesday: Finish your menu and print
Thursday: Learn tables
Assign: Top Retailers
Friday: Finish Top Retailers and other missing work
Week 8 – February 20th – February 24th
Monday: NO SCHOOL, PRESIDENTS DAY
Tuesday: Review for Word Part 1 Test
Go through things_to_know_for_word_test_part_1 (1) together
Assign: OLD Instructions
OLD_001 – turn this in electrically when you are done
Wednesday: RGDE TESTING SCHEDULE
Finish Review, ask questions as needed!!
Thursday: Word Part 1 Test
Open this and wait for directions: ChuckNorris
Friday: Story Starters
Week 9 – February 27th – March 3rd
Monday:
Open the following document and wait for directions: WordCapstoneDataFile_000
Tuesday:
Finish work from Monday
NEW: open Working with Microsoft Word
Assign: open Cell Phones and Sleep, follow directions on the handout and turn into Cobra when done
Wednesday:
Finish Cell Phones and Sleep, follow directions on the handout and turn into Cobra when done
Thursday: Begin review for Word test
Word Art Practice
Open: HarryPotterDocument_000 and follow directions on the hand-out
Friday:
Finish Thursday work
Week 10 – March 6th – March 10th
Monday: WORD TEST!!
Open CrazyLaws_000 and wait for directions
Turn in to Cobra Drive when you are done!!
Tuesday:
Finish Test
Register on Certiport for Word Certification Test
Wednesday:
MEET IN LAB 235
Word Certification Test
Thursday:
Rock N Roll PowerPoint
Friday:
Rock N Roll PowerPoint
Week 11 – March 20th – March 24th
Monday: Finish Rock N Roll PowerPoint
Tuesday: New PowerPoint lessons
Open this: MPProj and follow along with me!
Assignment:PowerPoint Assignments_2017
Wednesday: Continue working on new PowerPoint assignments
Thursday: Keep working on PowerPoint!
Friday: PowerPoint
Week 12 – March 27th – 31st
Monday: Last day to work on assignments!
Tuesday: Review and update computers
Wednesday:
Thursday: PowerPoint Certification Test
Friday: Steve Jobs
Week 13 – April 3rd – April 7th
Monday: Steve Jobs
Tuesday: Finish “Jobs” movie
Wednesday: Begin Excel
Work on pages 8-21 in the book together
Thursday: Finish intro pages
Assign: “Tour Revenue” and “Pamper”
Turn in to Cobra drive when done
VOTE FOR PROM:
Friday: Join the class in Google Classroom
Review what we’ve done for the week – questions?
NEW: “Payday, Grades, Candy Sales”
VOTE FOR PROM:
Week 14 – April 10th – April 14th
Monday: Join the class in Google Classroom if you did not do that on Friday – fill out the Exit Ticket too!
NEW TODAY: PeriodLastName_Formula5 (2)
Ask questions as needed, turn in electronically when you are done
Tuesday: Learning new Excel content today!
First 10 minutes – continue working on PeriodLastName_Formula5 (2)
We will work together on: payroll_sortingpractice
New tasks: filtering, custom sort, conditional formatting
Assignment:
GolfRankings_000 – use this spreadsheet to sort, this is where you will find answers to the Word doc
PeriodLastName_GolfSortingThingsOut – use this Word doc for your answers – turn in electronically when you are done
Wednesday:
VOTE FOR PROM FINALISTS!! Enter the following jump codes on the LPS website:
Thursday: Continue working in Excel
Students will:
know how to sort data
understand why sorting data is helpful
be able to sort multiple columns of data at one time
New assignment: PeriodLastName_FunctionPractice – turn in electronically when completed
Friday: NO SCHOOL
Week 15 – April 17th – 21st
Monday: NO SCHOOL
Tuesday: New Excel Assignment
Today students will:
Know how to keep track of spending by using a spreadsheet
Understand why keeping track of spending is important
Be able to go “shopping” at Target and keep track of spending
NEW ASSIGNMENT:
1500-1 – directions
1500 – spreadsheet to input pricing, turn this in!!
Wednesday: ACT Day – Juniors only
Thursday: Conditional Formatting practice
Today student’s will:
Know how to apply conditional formatting to a spreadsheet
Understand why conditional formatting is helpful when looking at data
Be able to complete 1 new assignment
NEW:
GradebookConditionalFormatingDIRECTIONS
PeriodLastName_GradeBook
Friday: More shopping!
Today students will:
Know how to keep track of spending by using a spreadsheet
Understand why keeping track of spending is important
Be able to go “shopping” at Best Buy and keep track of spending
1000 – word doc with directions
1000 – spreadsheet to work on
Week 16 – April 24th – April 28th
Monday:
Today we will
Know what an absolute cell reference is
Understand how to apply an absolute cell reference to a formula
Be able to apply absolute cell references to formula’s in Excel
Together: PeriodLastName_AbsolutePractice (1)
On your own: TheGapInstructions (1)
PeriodLastName_TheGapDataFile
Tuesday:
Today we will
Know what an absolute cell reference is
Understand how to apply an absolute cell reference to a formula
Be able to apply absolute cell references to formula’s in Excel
On your own: TheGapInstructions (1)
PeriodLastName_TheGapDataFile
Wednesday:
Today we will:
Know how to create data tables inside of Excel
Understand how to add different style sets to data tables
Be able to create a data table and sort data within the tables in Excel
Together: NCAA Scoring
Assignment: Buying-a-Car-Directions (1)
Thursday: Work day!
Today we will:
Know how to create data tables inside of Excel
Understand how to add different style sets to data tables
Be able to create a data table and sort data within the tables in Excel
Assignment: Buying-a-Car-Directions (1)
Friday:
Complete all assignments from the week, call me over when you are done and I’ll spot check them for a grade
Today we will:
Know how to create data tables inside of Excel
Understand how to add different style sets to data tables
Be able to create a data table and sort data within the tables in Excel
Week 17 – May 1st – May 5th
Monday: Finish Excel Unit C assignment
Today we will:
Know how to create data tables inside of Excel
Understand how to add different style sets to data tables
Be able to create a data table and sort data within the tables in Excel
NEW: Literary City Handout
Tuesday: Begin Charts
Today we will:
Know how to insert different types of charts in Excel
Understand the correct steps needed to include an accurate chart
Be able to create a column, bar, line, and pie chart on our own.
Together: WBQtrExpBudg, pages 92 – 99
Wednesday: Charts
Today we will:
Know how to insert different types of charts in Excel
Understand the correct steps needed to include an accurate chart
Be able to create a column, bar, line, and pie chart on our own.
Together: Finish WBQtrExpBudg, pages 92 – 99
ASSIGNMENT: Excel Extras (1) – turn in through the Cobra drive when you are done
Thursday: Charts
Today we will:
Know how to insert different types of charts in Excel
Understand the correct steps needed to include an accurate chart
Be able to create a column, bar, line, and pie chart on our own.
ASSIGNMENT: Excel Extras (1) – turn in through the Cobra drive when you are done
Friday: Excel
Today we will:
Know how to perform all formatting changes to an Excel spreadsheet
Understand the correct printing procedures
Be able to complete a review assignment without help
NEW: “Car Shopping” handout – PRINT
Week 18 – May 8th – 12th
Monday: last week of Excel!
Today we will:
Know how to perform all formatting changes to an Excel spreadsheet
Understand the correct printing procedures
Be able to complete a review assignment without help
NEW: Brochure Costs – handout – Turn in to your Cobra drive when completed
Tuesday: Review!
Today we will:
Know how to perform all formatting changes to an Excel spreadsheet
Understand the correct printing procedures
Be able to complete a review assignment without help
NEW: ExcelReview
Wednesday:Review!
Today we will:
Know how to perform all formatting changes to an Excel spreadsheet
Understand the correct printing procedures
Be able to ask questions about parts of Excel that have been troublesome
NEW: Thanksgiving Chart if you are done with your review
Thursday: Excel Test!
Today we will:
Know how to perform all formatting changes to an Excel spreadsheet
Understand what the expectations are for completing the Excel test
Be able to work quietly and independently on the Excel test
ExcelFinal16_17
Friday: Missing work day!!! Last chance to turn in any work from Excel
Week 19 – May 15th – May 19th
Monday: REVIEW FOR FINAL!!!
Utah Golf Packet
Tuesday: Review packet
Wednesday: Review Packet
Thursday: Final Sample Test
Friday: Final Sample Test