Welcome to Information Technology 1 (Info Tech 1)
In Info Tech 1 (previously known as Computer Applications), students will learn Microsoft Office 2013, including Word, Power Point, Excel and Access. Students will also discuss digital literacy, file management, and social media responsibility.
Week 19
Monday 5/15
- Today we will continue our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Tuesday 5/16
- Today we will continue our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Wednesday 5/17
- Today we will continue our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Thursday 5/18
- Today we will continue our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Friday 5/19
- Today we will continue our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Week 18
Monday 5/8
- MOS Excel Certification Exam
Tuesday 5/9
- Today we will be assessed over Excel.
- Assignment: Excel TEST
Wednesday 5/10
- MOS Excel Certification Exam make-up / catch-up day
Thursday 5/11
- Today we will begin our summative final over all of the material learned in this course.
- Assignment: Discuss and begin final part 1 (of 2) – Dance Party
Friday 5/12
- Today we will begin our summative final over all of the material learned in this course.
- Assignment: continue final part 1 (of 2) – Dance Party
Week 17
Monday 5/1
- Lesson 7
Tuesday 5/2
- Make-up/catch up day
Wednesday 5/3
- Skills Mastery Certification Simulation Review
- Copy “Skills Mastery Certification Simulation” folder from Read Only to your Excel folder on Cobra.
Thursday 5/4
- Continue Skills Mastery Certification Simulation Review
- Review instructions for MOS testing
Friday 5/5
- Finish Skills Mastery Certification Simulation Review
- Review instructions for MOS testing
Week 16
Monday 4/24
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Assignment: Music Genres (handout)
- Will need to copy the Music Genres.txt file from Read Only to your Excel folder
- Assignment: Music Genres (handout)
Tuesday 4/25
- Today we will learn how to use charts in Excel.
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
- Open Crabtree_ES3.2 and save as “Period#LastName_ExpenseBudget”
- Assignment: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “Period#LastName_PerfStats”
- Directions: Info Tech WBPerfStats directions
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
Wednesday 4/26
- Today we will create charts in Excel.
- Finish Assignment: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “Period#LastName_PerfStats”
- Directions: Info Tech WBPerfStats directions
- Assignment: Period#LastName_ChartingPractice – turn into “ClassHandin” when done.
- Finish Assignment: Excel Section 3 White Pages 96 – 97
Thursday 4/27
- Today we will review formatting cells and creating charts in Excel.
- Finish Assignment: Period#LastName_ChartingPractice
Friday 4/28
- First: finish assignments from this week
- Second: Lesson 7 – Pivot Tables, SmartArt Graphics, and Charts
- Use this file (6crabtreefundraising_lesson6) and rename: 6LastName_Fundrasing_Lesson 7
Week 15
Monday 4/17
- No School!
Tuesday 4/18
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Together: 6lastnamefundraising_lesson6
Wednesday 4/19
- No Classes – ACT Testing Day (Juniors Only)
Thursday 4/20
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Together: 6lastnamefundraising_lesson6
Friday 4/21
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Assignment: periodlastname_cars
Week 14
Monday 4/10
- Today we will…
- Know: how to calculate formulas and functions with multiple worksheets.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Together: Lesson 5 Formulas & Functions Tutorial
Tuesday 4/11
- Today we will…
- Know: how to calculate formulas and functions with multiple worksheets.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Together: Lesson 5 Formulas & Functions Tutorial
Wednesday 4/12
- Today we will practice inserting complex functions/formulas.
- Assignment: Raise Directions
Thursday 4/13
- Work/catch up day
- Finish Assignment: Raise Directions
- Assignment: Gmetrix Excel Functions, Formulas, Sorting, Referencing Review
Friday 4/14
- No School!
Week 13
Monday 4/3
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel.
- Finish Assignment: Buying a Car Directions
- Finish Assignment: Verizon Wireless (Handout)
Tuesday 4/4
- Today we will learn absolute & mixed cell references in Excel.
- Together: Period#LastName_AbsolutePractice
- Assignment: Gap Payroll – absolute cell referencing / sorting / conditional formatting
Wednesday 4/5
- Today we will…
- Know: how to create data tables and sparklines inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Together: Continue working with 6crabtreefundraising
- Assignment: NBA Results (Handout)
Thursday 4/6
- Today we will…
- Know: how to create data tables and sparklines inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Work day to finish the following assignments:
- Buying a Car
- Verizon Wireless
- The Gap
- NBA Results
Friday 4/7
- Today we will…
- Know: how to create data tables and sparklines inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Assignment: Gmetrix Excel Functions, Formulas, Sorting, Referencing Review
Week 12
Monday 3/27
- Today we will learn to sort data and create conditional formatting in Excel.
- Together: Open payroll_sortingpractice and save to your Excel folder
- Assignment: Golf Rankings
- GolfRankings_000 (Excel file you will use to sort/format data)
- Period#LastName_GolfSortingThingsOut (Word document you will fill out and turn into “ClassHandin” folder when completed)
Tuesday 3/28
- Today we will review information learned in Excel.
- Gmetrix – Excel Basics (training mode)
- Work on any missing/incomplete Excel assignments.
Wednesday 3/29
**Adjusted Schedule – Rec Rally**
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel.
- Together: Fundraiser
Thursday 3/30
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel.
- Together: finish Fundraiser
- Assignment: Buying a Car Directions
Friday 3/31
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel.
- Finish Assignment: Buying a Car Directions
- Assignment: Verizon Wireless (Handout)
Week 11
Monday 3/20
- Today will be a make-up day for PowerPoint. The last day any missing assignments will be accepted for PowerPoint is Friday, 3/31.
- Check synergy!
- Today we will have some fun in Microsoft Excel! All of these games were made and can be played in Excel!
Tuesday 3/21
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data
- Why use Excel?
- Assignment: Ribbon Location Scavenger Hunt
Wednesday 3/22
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data and Formulas
- Continue Assignment: Ribbon Location Scavenger Hunt
- Together: Excel Basics
Thursday 3/23
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data and Formulas
- Together: Finish Excel Basics
- Assignment: periodlastnameqtrlyincome16
Friday 3/24
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data and Formulas
- Finish Assignment: periodlastnameqtrlyincome16
- Together: Period#LastName_FunctionPractice (Sheet 1 & 4 – Tour Revenue & Checkbook)
- Assignment: Finish other 3 tabs in Function Practice
Week 10
Monday 3/6
- Today we will review design tips for PowerPoint.
- Finish Assignment: Best of 2015
- Assignment: Gmetrix Assessment (training mode): PowerPoint Review
Tuesday 3/7
- Today we will be assessed over PowerPoint.
- Assignment: Choice PowerPoint
Wednesday 3/8
- Today we will be assessed over PowerPoint.
- Assignment: Choice PowerPoint
Thursday 3/9
- Today we will review for the PowerPoint Certification and complete any missing assignments.
- PowerPoint Review
- Complete any missing/incomplete Word assignments (tomorrow is last day these will be accepted)
- Complete any missing/incomplete PowerPoint assignments
Friday 3/10
- Today we will complete the MOS PowerPoint 2013 Certification Exam.
Week 9
Monday 2/27
- Today we will finish up any missing/incomplete work in Word.
- Catch up/work day
- Make up certification exams
Tuesday 2/28
- Together: Begin PowerPoint Demo
- “There’s an App for That”
- fonts, design templates, transitions, slide layouts, animations
- “There’s an App for That”
Wednesday 3/1
- Together: Review PowerPoint Demo
- “There’s an App for That”
- SmartArt, Inserting/Deleting slides, changing slide layouts
- Turn into ClassHandin on Cobra if you didn’t on Tuesday
- PowerPoint Design Tips
- Assignment: About Me PowerPoint
- “There’s an App for That”
Thursday 3/2
- Today we will learn design tips for PowerPoint and create a presentation about ourselves.
- PowerPoint Design Tips
- Assignment: About Me PowerPoint
Friday 3/3
- Today we will use what we have learned in PowerPoint to update an already completed presentation.
- Assignment: Best of 2015
Week 8
Monday 2/20
- No School – Happy President’s Day!
Tuesday 2/21
- Today we will review information covered in Word to prepare for the final assessment/MOS Word Certification Exam.
- ***If you have not set up your Certiport account, you MUST do so before the end of the period Thursday – ask if you need help setting this up!!***
- Assignment: Finish Bamboo from Friday (all links are on Friday’s date)
- Assignment: Finish Word Review from Tuesday
- ***If you have not set up your Certiport account, you MUST do so before the end of the period Thursday – ask if you need help setting this up!!***
Wednesday 2/22
- Today we will be assessed over Word.
- Assessment: Open this document (Crazy Laws) and complete the steps listed on the pink Crazy Laws handout.
- PRINT and save to ClassHandin folder when finished.
- Assessment: Open this document (Crazy Laws) and complete the steps listed on the pink Crazy Laws handout.
Thursday 2/23
- Today we will review information from the MOS Word Certification Exam. What do we need to cover in more detail?
- ***If you have not set up your Certiport account, you MUST do so before the end of the period – ask if you need help setting this up!!***
- Finish Crazy Laws assessment
- Together: Discuss MOS Instructions
Friday 2/24
- Today we will be assessed over material covered in Word
- Assessment: MOS Certification Exam
Week 7
Monday 2/13
- Today we will…
- Know how to format a word document with graphics.
- Understand how to apply columns and breaks, insert images, SmartArt, captions, endnotes/footnotes, adjust text wrapping and size, and appy effects/styles to photos.
- Be able to format a document using several tools to make it more visually appealing.
- Together: Wipeout
Tuesday 2/14
- Today we will…
- Know how to format a word document with graphics.
- Understand how to apply columns and breaks, insert images, SmartArt, captions, endnotes/footnotes, adjust text wrapping and size, and appy effects/styles to photos.
- Be able to format a document using several tools to make it more visually appealing.
- Assignment: costumes
Wednesday 2/15
- Today we will…
- Know how to create multilevel lists, insert shapes, text boxes, and WordArt.
- Understand how to incorporate these into a document and format them.
- Be able to create a winter scene using these skills.
- Together: LastName_college_application_list
- Assignment: Winter Scene
Thursday 2/16
- Today we will…
- Know how to insert shapes, text boxes, and WordArt.
- Understand how to incorporate these into a document and format them.
- Be able to create a winter scene using these skills.
- Set up Certiport accounts
- Assignment: finish Winter Scene
- Assignment: Word Review
Friday 2/17
- Today we will review information covered in Word to prepare for final assessment/Word Certification exam
- Together/Assignment: Bamboo Review
- Assignment: finish Word Review
Week 6
Monday 2/6
- Today we will be assessed over what we have learned so far in Word.
- Assessment: LastName_Membership Drive Test
Tuesday 2/7
- Today we will get caught up on assignments we have had so far in Word.
- Review grade report and work on any of the highlighted items. Make sure these go in ClassHandin.
- If you did not complete/finish the Word Part 1 summative yesterday, please do so!
- Today we will learn how to format columns, insert breaks, insert captions, photos (positioning, text wrapping & sizing)
- Assignment: Gmetrix – Learn Column/Breaks/Captions/Photos
- This is in “TRAINING” mode so you can go through the questions and use the lightbulb to help you.
- Assignment: Gmetrix – Learn Column/Breaks/Captions/Photos
Wednesday 2/8
- Today we will learn how to format columns, insert breaks, insert captions, photos (positioning, text wrapping & sizing).
- Together: LastName_gardeners_corner
Thursday 2/9
- Today we will understand how to add captions to images, how to insert Smart Art, and end notes/footnotes. We will review positioning, text wrapping & sizing, and effects/styles of photos. We will also review columns and breaks.
- Assignment: LastName_Healthy Habits for Teens
Friday 2/10
- Today we will review information learned so far
- Work/catch up day
Week 5
Monday 1/30
- Today we will learn how to sort tables, apply table styles, and how to convert tables to text and text to tables
- Together: Sorting, Style, and Converting Practice – LastName_RedSox
- Assignment: LastName_small_towns_converting
Tuesday 1/31
- Today we will learn how to use tabs & tab leaders in Word
- Together: Tab Practice (LastName_RailTravel – from book pages 52-55) – turn into Cobra when finished
Wednesday 2/1
- Today we will apply our knowledge of tables and tabs to a Word document.
- Assignment: Top Retail Stores (handout by printer)
- Assignment: Gmetrix: Tables Practice (testing mode)
Thursday 2/2
- Today we will review how to set tabs and tab leaders in Word.
- Assignment: Movie Ratings (handout)
- Assignment: Grammy’s/Races tabs (handout)
Friday 2/3
- Today we will review and complete missing work.
- Things to know for Word Part 1 Quiz
- Complete any missing/incomplete Word assignments
Week 4
Monday 1/23
- Today we will learn how to set Indents
- Together: Indent practice (open “The Wall” from last week)
- Assignment: 12 Days of Christmas FILE — right click & save
- Directions — just open, no need to save the directions
Tuesday 1/24
- Today we will review indents, learn how to find/replace text, and how to use the thesaurus.
- Together: Find & Replace Practice
- Assignment: LastName_Glee
Wednesday 1/25
- Today we will review information learned so far in word.
- Assignment: LastName_Oslo
- Directions: oslo_directions
- Assignment: LastName_Oslo
Thursday 1/26
**Adjusted Schedule – Rocket Recognition Rally**
- Today we will learn how to create & modify tables in Word.
- Together: Table Practice (class schedule)
- Assignment: Valentine’s Would You Rather
Friday 1/27
- Today we will review tables and learn how to sort contents within a table.
- Together: Table Review
- Assignment: Finish Valentine’s Would You Rather
Week 3
Monday 1/16
- No School – MLK Jr. Day!
Tuesday 1/17
- School Cancelled – Weather Closure
Wednesday 1/18
- Today we will review document themes and colors and learn how to apply page borders, change margins/line spacing, and how to use the thesaurus & format painter.
- Together: finish LastName_TheWall
- Assignment: LastName_ABC
Thursday 1/19
- Today we will apply formatting to a Word document.
- Business Class Offerings
- Finish Assignment: LastName_ABC
- NEW Assignment: Favorites… OR Not (get handout from Mrs. Crabtree/Ms. Obal)
Friday 1/20
- Today we will review basic formatting in Word.
- Assignment: GMetrix Formatting Review Quiz
- Assignment: GMetrix Indent Practice
Week 2
Monday 1/9
- Today we will create a poster about ourselves.
- Finish your word cloud if you have not done so yet.
- Assignment: About Me Info Graphic
- Canva login
- Together: demo and set up infographic
- Find at least 5 pictures to describe you (save to misc folder)
- Upload to Google Classroom
- Canva login
Tuesday 1/10
- Today we will learn how to start a new Word document, format a document from the Home tab, and vocabulary for Microsoft Word.
- Finish Word Clouds and About Me Info Graphics
- Upload to Google Classroom
- Set up GMETRIX account
- Together – practice formatting documents
- Word screen parts / header and footers
- Finish Word Clouds and About Me Info Graphics
Wednesday 1/11
- Today we will learn how to start a new Word document, format a document from the Home tab, and vocabulary for Microsoft Word.
- Together – practice formatting documents
- Word Ribbon Location Scavenger Hunt
- Review Word screen parts / headers and footers
- Texting 101
- Together – practice formatting documents
Thursday 1/12
- Today we will learn how to start a new Word document, format a document from the Home tab, and vocabulary for Microsoft Word.
- Together – practice formatting documents
- Review Word screen parts / headers and footers
- Top Baby Names
- Assignment: 20 Questions
- Together – practice formatting documents
Friday 1/13
- Today we will review formatting, learn Backstage Properties, page navigation, spell check, and 5 ways to cut, copy & paste. We will also learn how to apply document themes, colors, page borders, margins, line spacing, thesaurus & format painter.
- Together: LastName_TheWall
Week 1
Monday 1/2
- Happy New Year! – No Classes
Tuesday 1/3
- Happy New Year! – No Classes
Wednesday 1/4
- First Day of Second Semester
- Today we will learn about Digital Media 1 and go over class expectations.
- Nearpod
- Info Tech 1 Syllabus / Computer Use Guidelines scavenger hunt
- Meet Mrs. Crabtree
- Get to know your classmates
- Nearpod
Thursday 1/5
- Today we will set up our computers for the semester and share information with Mrs. Crabtree.
- Seating chart
- What is Info Tech 1?
- Review syllabus and Computer Use / Equipment Guidelines
- Computer Setup/Housekeeping
- Bookmark this site and/or set as homepage
- Set up folders/Cobra drive, etc
- Assignment: Complete Intro Survey (found in Google Classroom)
Friday 1/6
- Today we will begin our first project – creating an infographic about ourselves.
- Demo & create word cloud on WordClouds
- Assignment: Save to Cobra, upload to Google Classroom
- If you did not complete the Intro Survey in Classroom yesterday, please do so before the end of the period today!
- Assignment: About Me Info Graphic
- Discuss and save at least 5 pics to misc folder on cobra
- Demo & create word cloud on WordClouds
Week 20
Monday 5/22
- Finals!
- Periods 1, 2, and 7
Tuesday 5/23
- Finals!
- Periods 5 and 6
- Gmetrix final assessment
Wednesday 5/24
- Finals!
- Periods 3 and 4
Thursday 5/25
- Enjoy Summer Break!
Friday 5/26
- Enjoy Summer Break!
Week 16
Monday 11/28
- Today we will learn how to use charts in Excel.
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
- Open Crabtree_ES3.2 and save as “Period#LastName_ExpenseBudget”
- Assignment: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “Period#LastName_PerfStats”
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
Tuesday 11/29
- Today we will create charts in Excel.
- Finish Assignment: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “Period#LastName_PerfStats”
- Assignment: Period#LastName_ChartingPractice – turn into “ClassHandin” when done.
- Finish Assignment: Excel Section 3 White Pages 96 – 97
Wednesday 11/30
- Today we will review formatting cells and creating charts in Excel.
- Finish Assignment: Period#LastName_ChartingPractice
- Assignment: Thanskgiving Chart Assignment
Thursday 12/1
- First: finish assignments from this week
- Second: Lesson 7 – Pivot Tables, SmartArt Graphics, and Charts
- Use this file (6crabtreefundraising_lesson6) and rename: 6LastName_Fundrasing_Lesson 7
Friday 12/2
- Lesson 7 – Pivot Tables, SmartArt Graphics, and Charts
Week 15
Monday 11/21
- Black Friday research assignment
Tuesday 11/22
- Black Friday research assignment
Wednesday 11/23
- No School – Thanksgiving Break
Thursday 11/24
- No School – Thanksgiving Break
Friday 11/25
- No School – Thanksgiving Break
Week 14
Monday 11/14
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Together: 6lastnamefundraising_lesson6
Tuesday 11/15
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Together: 6lastnamefundraising_lesson6
Wednesday 11/16
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Assignment: periodlastname_cars
Thursday 11/17
- Lesson 6 – Using Templates, Themes, and Images in Excel
- Assignment: Music Genres (handout)
- Will need to copy the Music Genres.txt file from Read Only to your Excel folder
- Assignment: Music Genres (handout)
Friday 11/18
- Black Friday research assignment
Week 13
Monday 11/7
- Review/finish Lesson 5
- Referencing other worksheets
- Modifying Formulas
- Using If… Then… Else functions
- Advanced Conditional Formatting Rules
- Hiding/Revealing Columns
- Comments
- Finding Information
- Cross-worksheet formulas
- CountIF function
- Order of Evaluation (PEMDAS)
Tuesday 11/8
- Review/finish Lesson 5
- Referencing other worksheets
- Modifying Formulas
- Using If… Then… Else functions
- Advanced Conditional Formatting Rules
- Hiding/Revealing Columns
- Comments
- Finding Information
- Cross-worksheet formulas
- CountIF function
- Order of Evaluation (PEMDAS)
Wednesday 11/9
- Today we will practice inserting complex functions/formulas.
- Assignment: Raise Directions
Thursday 11/10
**Adjusted Schedule – Host State Volleyball (Period 4-7 Only)**
- Gmetrix Crabtree Excel review
- Finish Raise assignment
- When finished – play Excel games:
- 6 Entertaining Games Created ENTIRELY in Excel
Friday 11/11
**Adjusted Schedule – Veteran’s Day Assembly**
- Work/Catch Up Day – check Synergy
Week 12
Monday 10/31
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Assignment: Verizon Wireless (Handout)
Tuesday 11/1
- Today we will…
- Know: how to create data tables and sparklines inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Together: Continue working with 6crabtreefundraising
- Assignment: NBA Results (Handout)
Wednesday 11/2
- Work/catch up day! The following should be in your ClassHandin folder for me to grade:
- Golf Rankings (word document)
- Gradebook
- The Gap
- Fundraiser
- Buying a Car
- Verizon Wireless
- NBA Results
Thursday 11/3
- Today we will…
- Know: how to calculate formulas and functions with multiple worksheets.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Assignment: Lesson 5 Formulas & Functions Tutorial
Friday 11/4
- Today we will…
- Know: how to calculate formulas and functions with multiple worksheets.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Assignment: Lesson 5 Formulas & Functions Tutorial
Week 11
Tuesday 10/25
- Today we will learn how to print/use print preview in Excel. We will review sorting and conditional formatting in Excel.
- Together: BaseballStatsSortingPractice
- Assignment: Gradebook – Sorting and Conditional Formatting
- GradebookConditionalFormatingDIRECTIONS (Word document with instructions)
- Period#LastName_GradeBook (Excel file you will turn in for grading)
Wednesday 10/26
- Today we will learn absolute & mixed cell references in Excel.
- Together: Period#LastName_AbsolutePractice
- Assignment: Gap Payroll – absolute cell referencing / sorting / conditional formatting
Thursday 10/27
**Adjusted Schedule – Rec Rally**
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel.
- Together: Fundraiser
Friday 10/28
- Today we will…
- Know: how to create data tables inside of Excel.
- Understand: how data validation for formulas work in a table.
- Be able to do: create data tables, enter validation rules/formulas, and sort a table in Excel
- Together: Continue Fundraiser
- Assignment: Buying a Car Directions
Week 10
Wednesday 10/19
- Today we will learn basic formulas in Excel. Students will review basic vocabulary; learn number formatting. Students will learn fill down, fill right, and the functions sum, average, min & max.
- Assignment: Period#LastName_grades_candy_payday
Friday 10/21
- Today we will apply basic formulas in Excel. Students will apply formatting and functions to an Excel workbook.
- Assignment: Period#LastName_Formula5
Week 8
Monday 10/3
- Assignment: Personal Newsletter
Tuesday 8/16
- Today we will be introduced to Info Tech 1
- Stations!
- 1 – Info Tech 1 Syllabus / Computer Use Guidelines scavenger hunt
- 2 – Get to know your classmates
- 3 – Growth mindset / goals
- 4 – In a Perfect World
- 5 – Meet Mrs. Crabtree / Say It In Six statements
- Stations!
Week 19
Monday 5/16
- Print MicroType reports
- Finish up review (10-15 minutes)
- Discuss Final – begin final
- No passes will be given during finals – make sure you use the bathroom, etc. before you come to class!
Tuesday 5/17
- Finals – Periods 1, 2, and 7
Wednesday 5/18
- Finals – Periods 3, 4
- Print MicroType Reports if you did not do so on Monday
- Info Tech 1 Final
Thursday 5/19
- Finals – Periods 5, 6
- Print MicroType Reports if you did not do so on Monday
- Info Tech 1 Final
Friday 5/20
- Happy Summer!
Week 18
Monday 5/9
- Today we will be assessed over Access.
- Access Summative Assignment: Access Section 2 – Challenge 1 (pages 73-74)
- Complete steps 1-5
- Make sure you include your Last Name in the Table Names!
- Access Summative Assignment: Access Section 2 – Challenge 1 (pages 73-74)
Tuesday 5/10
- Today we will review for the final.
- First – Finish Access summative from yesterday if you haven’t done so already
- Assignment: FINAL Review Utah Golf Classic 2016
Wednesday 5/11
- Today we will review for the final.
- Assignment: FINAL Review Utah Golf Classic 2016
Thursday 5/12
- Today we will review for the final.
- Assignment: FINAL Review Utah Golf Classic 2016
Friday 5/13
**Adjusted Schedule – May Day Assembly**
- Today we will review for the final.
- Assignment: FINAL Review Utah Golf Classic 2016
Week 17
Monday 5/2
- Today we will work on missing/incomplete assignments.
- Check Synergy – all grades have been updated!
- REMEMBER: Wednesday is the last day I will accept any missing/incomplete Excel assignments! Use your time wisely today to get things turned in!!!
Tuesday 5/3
- Today we will create tables and relationships.
- Together: Access Section 2 – white pages 42-45
Wednesday 5/4
- Today we will create tables and relationships.
- Together: Access Section 2 – white pages 46-51
Thursday 5/5
- Today we will create tables and relationships.
- Access Section 2 – white pages 52-55
- Assignment: Skills Review 1 (pages 67-68)
Friday 5/6
- Work/catch up/review day for Access.
- Check Synergy and work on any missing Access assignments.
- We will have a summative over Access on Monday!
Week 16
Monday 4/25
- Finish Jobs
Tuesday 4/26
- Today we will learn what a database is; how to start and save one in Access and how to maintain data in Access.
- Begin Access Section 1
- SNAP Tutorials 1.1 – 1.11
- Begin Access Section 1
Wednesday 4/27
- Today we will learn to maintain data in Access.
- Together: Access Section 1 (book work, pages 14-21)
- Open file Period#LastName_WEDistributors1.accdb from your Read Only folder on Cobra.
- Together: Access Section 1 (book work, pages 14-21)
Thursday 4/28
- Today we will learn to maintain data in Access.
- Together: Access Section 1 (book work, pages 22-29)
- Assignment: Skills Review 1 & 2 (pages 31-32)
Friday 4/29
- Today we will learn to sort a table, create filters, and review forms.
- Finish Assignment: Skills Review 1 & 2 (pages 31-32)
- NEW Assignment: Skills Assessment 5 – Individual Challenge (page 34)
Week 15
Monday 4/18
- Today we will be assessed over Excel.
- Together: Review and Questions
- Assignment: Excel TEST
Tuesday 4/19
- ACT Day (Juniors Only – no classes)
Wednesday 4/20
- Today we will be assessed over Excel.
- Assignment: finish Excel TEST
- Finish any missing Excel work when finished.
- CHECK SYNERGY! Grades have been updated to include everything except the Excel Review and Excel Test – both of these should be in the ClassHandin folder by the end of the period.
Thursday 4/21
- Jobs
Friday 4/22
- Jobs
Week 14
Monday 4/11
- Today we will create and modify charts in Excel
- Assignment: SNAP
- Grade-It: Excel Section 3, Skills Review 2A
- Grade-It: Excel Section 3, Skills Review 2B
- Assignment: SNAP
Tuesday 4/12
- Today we will create and modify charts in Excel
- Assignment: Period#LastName_BestMusic
Wednesday 4/13
- Block Scheduling – Periods 1, 3, 5, and 7
- Today we will review for our Excel assessment.
- Assignment: Excel Review Spreadsheet
- Directions: Excel Review
- Assignment: Excel Review Spreadsheet
Thursday 4/14
- Block Scheduling – Periods 2, 6, 4, and 7
- Today we will review for our Excel assessment.
- Assignment: Excel Review Spreadsheet
- Directions: Excel Review
- Assignment: Excel Review Spreadsheet
Friday 4/15
- Today we will apply formulas and basic Excel knowledge to create workbooks.
- Shopping spree!
- Open this for directions: 1000 Shopping Spree Directions
- Open this for the spreadsheet: 1000 – save as Period#LastName_1000
Week 13
Monday 4/4
- Today we will learn how to print/use print preview in Excel. We will review sorting and conditional formatting in Excel.
- Together: BaseballStatsSortingPractice
- Assignment: Gradebook – Sorting and Conditional Formatting
- GradebookConditionalFormatingDIRECTIONS (Word document with instructions)
- Period#LastName_GradeBook (Excel file you will turn in for grading)
Tuesday 4/5
- Today we will learn absolute & mixed cell references in Excel.
- Together: Period#LastName_AbsolutePractice
- Assignment: Gap Payroll – absolute cell referencing / sorting / conditional formatting
Wednesday 4/6
- Today we will learn how to use charts in Excel.
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
- Open Crabtree_ES3.2 and save as “Period#LastName_QtrExpBudget”
- Assignment: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “Period#LastName_PerfStats”
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
Thursday 4/7
- Today we will create charts in Excel.
- Assignment: Period#LastName_ChartingPractice – turn into “ClassHandin” when done.
- When finished – check Synergy and work on any missing Excel assignments.
Friday 4/8
- Today we will create charts in Excel.
- Assignment: Period#LastName_nascar2013 – turn into “ClassHandin” when done.
- When finished – check Synergy and work on any missing Excel assignments.
Week 12
Monday 3/28
- Today we will learn basic formulas in Excel. Students will review basic vocabulary; learn number formatting. Students will learn fill down, fill right, and the functions sum, average, min & max.
- Together: open LastName_Payroll from last week
- Assignment: Period#LastName_grades_candy_payday
Tuesday 3/29
- Today we will learn basic formulas in Excel. Students will review basic vocabulary; number formatting; fill down, fill right, and the functions sum, average, min & max.
Wednesday 3/30
- Today we will apply basic formulas in Excel. Students will apply formatting and functions to an Excel workbook.
- Assignment: Period#LastName_Formula5
Thursday 3/31
- Today we will apply basic formulas in Excel. Students will apply formatting and functions to an Excel workbook.
- Work/catch up day
Friday 4/1
- Today we will learn to sort data and create conditional formatting in Excel.
- Together: Open payroll_sortingpractice and save to your Excel folder
- Assignment: Golf Rankings
- GolfRankings_000 (Excel file you will use to sort/format data)
- Period#LastName_GolfSortingThingsOut (Word document you will fill out and turn into “ClassHandin” folder when completed)
Week 11
Monday 3/21
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data
- Why use Excel?
- Open this document: Class Roster
- Font size/ style
- Alignment
- Deleting/Inserting (columns and rows)
Tuesday 3/22
- Today we will be introduced to the basics of Excel.
- Learning Targets: Opening, Saving, and Closing a Workbook | Entering Data in Cells | Performing Calculations Using Formulas | AutoSum | Copying and Testing Formulas | Sorting Data | Excel Help Window | Printing | Displaying Formulas | Navigating and Scrolling
- Assignment: SNAP Excel Section 1 Tutorials – complete all 10 tutorials in Section 1 (1.1 – 1.9B)
- When finished work on any missing assignments or you may continue some of the Excel games from Friday.
Wednesday 3/23
- Today we will enter labels and values and use fill options in Excel. We will also perform calculations using formulas, SUM function, and copy formulas in Excel.
- Together: White Page Activity 1.2-1.5 (pages 8-17)
- Save as “LastName_Payroll”
- Together: White Page Activity 1.2-1.5 (pages 8-17)
Thursday 3/24
- Today we will enter labels and values and use fill options in Excel. We will also perform calculations using formulas, SUM function, and copy formulas in Excel.
- Assignment: Skills Review 1 (page 30)
- NEW: How to add header/footers in Excel
- Open and Save Period#LastNameQtrlyIncome to your Excel folder on Cobra
- Work on any missing/incomplete Word or Excel assignments. Remember next Friday is the last day I will accept any Word assignments.
- Assignment: Skills Review 1 (page 30)
Friday 3/25
- No School!
Week 10
Monday 3/14
- Today we will review information from the MOS Word Certification Exam. What do we need to cover in more detail?
- Assignment: Personal Newsletter
Tuesday 3/15
- Today we will review information from the MOS Word Certification Exam.
- Together: Review for Word test part 2 / MOS testing
- Assignment: finish Personal Newsletter
Wednesday 3/16
- Today we will be assessed over Word.
- Assessment: Open this document (Crazy Laws) and complete the steps listed on the pink Crazy Laws handout.
- PRINT and save to “to be graded” when finished.
- Assessment: Open this document (Crazy Laws) and complete the steps listed on the pink Crazy Laws handout.
Thursday 3/17
- Make-up / re-takes MOS Word Certification exam.
Friday 3/18
- Today we will have some fun in Microsoft Excel!
- Intro to Excel – Spreadsheet program
Week 9
Monday 2/29
- Today we will…
- Know how to insert shapes, text boxes, and WordArt.
- Understand how to incorporate these into a document and format them.
- Be able to create a winter scene using these skills.
- Set up Certiport accounts
- Assignment: finish Winter Scene
- Assignment: Word Review
Tuesday 3/1
- Today we will review information covered in Word to prepare for final assessment/Word Certification exam
- Together/Assignment: Bamboo Review
- Assignment: finish Word Review
Wednesday 3/2
- Today we will review information covered in Word to prepare for the final assessment/MOS Word Certification Exam.
- ***If you have not set up your Certiport account, you MUST do so before the end of the period – ask if you need help setting this up!!***
- Together: Discuss MOS Instructions
- Assignment: Finish Bamboo from yesterday (all links are on Tuesday’s date)
- Assignment: Finish Word Review from Monday
- Practice: Gmetrix Review “Final Word Review (Info Tech 1)”
Thursday 3/3
- Today we will be assessed over material covered in Word
- Assessment: MOS Certification Exam
Friday 3/4
- Today we will finish up any missing/incomplete work in Word.
- Catch up/work day
- Make up certification exams
Week 8
Monday 2/22
- Today we will be assessed over what we have learned so far in Word.
- Assessment: LastName_Membership Drive Test
Tuesday 2/23
- Today we will learn how to format columns, insert breaks, insert captions, photos (positioning, text wrapping & sizing).
- Together: LastName_gardeners_corner
- Assignment: LastName_Healthy Habits for Teens
Wednesday 2/24
- Today we will understand how to add captions to images, how to insert Smart Art, and end notes/footnotes. We will review positioning, text wrapping & sizing, and effects/styles of photos. We will also review columns and breaks.
- Together: Wipeout
- Assignment: Finish LastName_Healthy Habits for Teens
Thursday 2/25
- Today we will…
- Know how to format a word document with graphics.
- Understand how to apply columns and breaks, insert images, SmartArt, captions, endnotes/footnotes, adjust text wrapping and size, and appy effects/styles to photos.
- Be able to format a document using several tools to make it more visually appealing.
- Assignment: costumes
Friday 2/26
- Today we will…
- Know how to create multilevel lists, insert shapes, text boxes, and WordArt.
- Understand how to incorporate these into a document and format them.
- Be able to create a winter scene using these skills.
- Together: LastName_college_application_list
- Assignment: Winter Scene
Week 7
Monday 2/15
- Today we will learn how to sort tables, apply table styles, and how to convert tables to text and text to tables
- Together: Sorting, Style, and Converting Practice – LastName_RedSox
- Assignment: LastName_small_towns_converting
Tuesday 2/16
- Today we will apply our knowledge of tables to a Word document. We will also learn how to set tabs and tab leaders.
- Assignment: Top Retail Stores (handout by printer)
- Assignment: SNAP Tutorials
- Word Section 2 – Tutorials 2.8 & 2.9 (Setting Tabs and Tab Leaders)
Wednesday 2/17
**ADJUSTED SCHEDULE (37 minute periods)**
- Today we will learn how to use tabs & tab leaders in Word
- On Own: Tab Practice (LastName_RailTravel – from book pages 52-55) – turn into Cobra when finished
- Assignment: Movie Ratings (handout)
Thursday 2/18
- Today we will review how to set tabs and tab leaders in Word.
- Assignment: Finish Movie Ratings (handout)
- Assignment: Grammy’s/Races tabs (handout)
Friday 2/19
- Today we will review and complete missing work.
- Things to know for Word Part 1 Quiz
- GMetrix Assessment/Review
- Complete any missing/incomplete Word assignments
Week 6
Monday 2/8
- Today we will learn how to set Indents
- Together: Indent practice (open a blank document)
- Assignment: 12 Days of Christmas FILE — right click & save
- Directions — just open, no need to save the directions
Tuesday 2/9
- Today we will review indents, learn how to find/replace text, and how to use the thesaurus.
- Together: Find & Replace Practice
- Assignment: LastName_Glee
Wednesday 2/10
- Today we will review information learned so far in word.
- Assignment: LastName_Oslo
- Directions: oslo_directions
- Assignment: SNAP Word Section 2
- Skills Review 3
- Assignment: LastName_Oslo
Thursday 2/11
- Today we will learn how to create & modify tables in Word.
- Together: Table Practice (class schedule)
- Assignment: Valentine’s Would You Rather
Friday 2/12
- Today we will review tables and learn how to sort contents within a table.
- Together: Table Review
- Assignment: Finish Valentine’s Would You Rather
Week 5
Monday 2/1
- Today we will apply formatting to a Word document.
- Finish Assignment: LastName_ABC
- NEW Assignment: Favorites… OR Not (get handout from Mrs. Hug)
Tuesday 2/2
- SNOW DAY!
Wednesday 2/3
- SNOW DAY!
Thursday 2/4
- Today we will apply formatting to a Word document.
- FIRST – check Synergy! What are you missing? Next Friday is the last day I will accept any missing PowerPoint assignments!
- Assignment: SNAP Word Section 2
- Skills Review 1 & 5
- Finish Assignment: LastName_ABC
- Finish Assignment: Favorites… OR Not
Friday 2/5
- Today we will work on any missing/incomplete assignments for Word and/or PowerPoint
- Check Synergy to see if you are missing any PowerPoint presentations.
- The following Word assignments should be in your “to be graded” folder:
- Top Baby Names (completed together as a class)
- 20 Questions
- LastName_TheWall (completed together as a class)
- LastName_ABC
- Favorites… OR Not (handout by printer)
- SNAP Word Section 2 – Skills Reviews 1 & 5 (not in your “to be graded” folder but should be completed on the website – remember you can re-take as many times as you want to get a score you are happy with)
Week 4
Monday 1/25
- Today we will assess our skills in PowerPoint and evaluate our peer’s presentations
- Make sure Actor/Actress OR Music PowerPoint is in your “to be graded” folder
- Upload presentations to Google Classroom for peer evaluations
- Need to evaluate yourself and your group member’s presentations using this FORM
Tuesday 1/26
- BLOCK SCHEDULE: Periods 2, 6, and 4
- Today we will learn how to start a new Word document, format a document from the Home tab, and vocabulary for Microsoft Word.
- Set up GMETRIX account
- Set up SNAP account
- Period 4 Enrollment Key: Crabtree S2P4
- Period 6 Enrollment Key: Crabtree S2P6
- Together – practice formatting documents
- Word screen parts / header and footers
- Texting 101
- Top Baby Names
- Assignment: 20 Questions
Wednesday 1/27
- BLOCK SCHEDULE: Periods 1, 3, 5, and 7
- Today we will learn how to start a new Word document, format a document from the Home tab, and vocabulary for Microsoft Word.
- Set up GMETRIX accounts
- Set up SNAP accounts
- Period 5 Enrollment Key: Crabtree S2P5
- Together – practice formatting documents
- Word screen parts / header and footers
- Texting 101
- Top Baby Names
- Assignment: 20 Questions
Thursday 1/28
- Today we will review formatting, learn Backstage Properties, page navigation, spell check, and 5 ways to cut, copy & paste. We will also learn how to apply document themes, colors, page borders, margins, line spacing, thesaurus & format painter.
- Finish Assignment: 20 Questions (10 minutes to finish up)
- Together: LastName_TheWall
Friday 1/29
- Today we will review document themes and colors and learn how to apply page borders, change margins/line spacing, and how to use the thesaurus & format painter.
- Together: finish LastName_TheWall
- Assignment: LastName_ABC
Week 3
Monday 1/18
- No School – MLK Jr. Day
Tuesday 1/19
- Today we will review information learned in PowerPoint to prepare for assessment.
- Business Classes Information
- Work day – do you have all of the below in “To Be Graded”?
- Apps
- About Me
- Best of 2015
- Choice
- MLK
Wednesday 1/20
- Today we will assess our skills in PowerPoint
- Actor/Actress OR Music PowerPoint (Summative)
Thursday 1/21
- Today we will assess our skills in PowerPoint
- Actor/Actress OR Music PowerPoint (Summative)
Friday 1/22
- Today we will assess our skills in PowerPoint and evaluate our peer’s presentations
- Finish Actor/Actress OR Music PowerPoint (Summative)
- Upload presentations to Google Classroom for peer evaluations
- Need to evaluate yourself and your group member’s presentations using this FORM
Week 2
Monday 1/11
- Today we will learn design tips for PowerPoint and create a presentation about ourselves.
- PowerPoint Design Tips
- Assignment: About Me PowerPoint
Tuesday 1/12
- Today we will use what we have learned in PowerPoint to update an already completed presentation.
- Assignment: Best of 2015
Wednesday 1/13
- Today we will review what we have learned in PowerPoint and begin creating a presentation on a topic of our choice.
- Finish Assignment: Best of 2015
- Assignment: Choice PowerPoint
Thursday 1/14
- Today we will work on any missing/incomplete PowerPoint assignments.
- All of the following should be in “to be graded” by the end of the period:
- Apps
- About Me
- Best of 2015
- Choice
- All of the following should be in “to be graded” by the end of the period:
Friday 1/15
- Today we will learn how to insert audio and video into PowerPoint presentations.
- Together: Demo using MLK Jr. PowerPoint Presentation
- Materials needed are in your “read only” folder on Cobra
- Together: Demo using MLK Jr. PowerPoint Presentation
Friday 8/19
- Today we will learn how to format a PowerPoint presentation.
- Warm-up: MicroType
- If you did not complete the Intro Survey from Wednesday, please do so during warm-up time.
- Warm-up: MicroType
Week 20
Monday 12/21
- Finals Periods 3, 4
- MOS Word Certification Exam
- Finish any missing work for the class – check Synergy – many are missing part of the final still!
Tuesday 12/22
- Finals Periods 5, 6
Wednesday 12/23
- Winter Break
Thursday 12/24
- Winter Break
Friday 12/25
- Winter Break
Week 19
Monday 12/14
- Today we will finish reviewing and then take our summative final over all of the material learned in this course.
- Together: Discuss PowerPoint section of FINAL Review – Utah Golf Classic
- Questions over review/for final?
- Together: Discuss PowerPoint section of FINAL Review – Utah Golf Classic
Tuesday 12/15
- Today we will take our summative final over all of the material learned in this course.
- Questions over review/for final?
- Assignment: Info Tech Final
Wednesday 12/16
- Today we will finish our summative for the course and set up our Gmetrix accounts to prepare for the MOS Word Certification Exam.
- Set up Gmetrix account – follow instructions on handout (Gmetrix Account Setup Instructions).
- Assignment: finish Info Tech Final
Thursday 12/17
- Today we will review and prepare to complete the MOS Word Certification Exam.
- Set up Certiport accounts – follow instructions on handout (Certiport Student Account Set up Instructions)
- Discuss and Review for MOS Word exam
- Gmetrix assessment
Friday 12/18
- Finals Periods 1, 2, and 7
Week 18
Monday 12/7
Tuesday 12/8
- Today we will be assessed over Excel.
- Together: Review and Questions
- Assignment: Excel TEST
Wednesday 12/9
- Today we will be assessed over Excel.
- Assignment: finish Excel TEST
- Finish any missing Excel work when finished.
Thursday 12/10
Friday 12/11
Week 17
Monday 11/30
- Today we will review formatting cells and creating charts in Excel.
- Assignment: Thanskgiving Chart Assignment
Tuesday 12/1
- Today we will begin to work with multiple worksheets, tables, and other file formats.
- Assignment: SNAP Section 4 Tutorials 4.1-4.11
- 4.1 Inserting, Moving, Renaming, & Deleting a Worksheet
- 4.2 Formatting & Printing Multiple Worksheets
- 4.3 Using 3-D References
- 4.4 Linking Data between Worksheets
- 4.5 Using Page Break Preview
- 4.6A Formatting Data as a Table
- 4.6B Adding Rows to a Table
- 4.7 Using the Sort Feature in Tables
- 4.8 Filtering a Table
- 4.9 Inserting & Editing Comments
- 4.10 Using Templates
- 4.11 Saving a Workbook in a Different File Format
- Assignment: SNAP Section 4 Tutorials 4.1-4.11
Wednesday 12/2
- Today we will format data as a table, apply table design options, sort and filter table data, and insert, edit, delete, and print comments in Excel.
- Together: Excel Section 4 White Pages (132-140)
- Open WBCatering and save as “LastName_ES4.9”
- Together: Excel Section 4 White Pages (132-140)
Thursday 12/3
- Today we will format, sort, and filter a table. We will also insert and print comments in a Worksheet.
- Assignment: SNAP: Grade-It: Excel Section 4, Skills Review 2
Friday 12/4
- Today we will review all of the information learned in Excel.
- Assignment: SNAP: Performance Evaluation: Excel Sections 1-4
- Use your book as a resource if you are unsure how to complete a task!
- Assignment: SNAP: Performance Evaluation: Excel Sections 1-4
Week 16
Monday 11/23
- Today we will research black Friday sales and traditions.
- Assignment: Black Friday Assignment
Tuesday 11/24
- Today we will research black Friday sales and traditions.
- Assignment: Black Friday Assignment
Wednesday 11/25
- No School – Thanksgiving Break!
Thursday 11/26
- No School – Thanksgiving Break!
Happy Thanksgiving!
Friday 11/27
- No School – Thanksgiving Break!
Week 15
Monday 11/16
- Today we will create formulas with absolute addressing, use statistical functions (average, maximum, minimum, count), write formulas with date functions and dates, create and use range names, and use logical IF function.
- Together: Excel Section 3 White Pages 80 – 83
- Open WBQtrExpBudg and save as “LastName_ES3.2”
- Together: Excel Section 3 White Pages 84-85
- Open WBOverdueAccts and save as “LastName_ES3.3”
- Together: Excel Section 3 White Pages 88-91
- Open WBEmpBonus and save as “LastName_ES3.6”
- Together: Excel Section 3 White Pages 80 – 83
Tuesday 11/17
- Today we will review absolute addressing, statistical functions, date functions, range names, and IF functions.
- Together: review page orientation, margins, header and footers
- Assignment: Excel Section 3 Review 1 (page 105)
- Open WBQtrRev and save as “LastName_ES3_R1” in your Excel folder
- PRINT when finished!
Wednesday 11/18
- Today we will create and modify column, pie, and line charts, and learn how to draw shapes in Excel.
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
- Open Crabtree_ES3.2 and save as “LastName_ES3.10”
- Together: Excel Section 3 White Pages 96 – 97
- Open WBPerfStats and save as “LastName_ES3.9”
- Together: Excel Section 3 WhitePages 92 – 95, 98-99
Thursday 11/19
- Today we will create and modify charts in Excel
- Assignment: Excel Section 3 Review 2 (page 106)
- Open your “LastName_ES3_R1” from Tuesday and save as “LastName_ES3_R2”
- Assignment: Excel Section 3 Review 2 (page 106)
Friday 11/20
- Today we will create and modify charts in Excel
- Assignment: SNAP
- Grade-It: Excel Section 3, Skills Review 2A
- Grade-It: Excel Section 3, Skills Review 2B
- Assignment: SNAP
Week 14
Monday 11/9
- Today we will learn how to change alignment and indentation of cells, use repeat, add borders and shading, copy formats, and apply cell styles and themes. We will also learn how to use Find and Replace, freeze panes, and insert, move, and resize clip art/pictures.
- Assignment: Excel Section 2 – pages 52 – 59
- Use your “LastName_ES2” from last week – when finished, save and copy to your “to be graded” folder.
- Assignment: Excel Section 2 – pages 60 – 65
- Open WBSpecEvents and save as “LastName_ES2.12” – save and copy to “to be graded” when finished. The image you need is in Read Only > Excel > ExcelS2 > TWBLogo.jpg
- Finish any missing work from last week.
- Assignment: Excel Section 2 – pages 52 – 59
Tuesday 11/10
- Today we will assessed over Excel Section 2
- Assignment: SNAP
- Performance Evaluation: Excel Section 2
- Finish any missing work from Section 2
- Assignment: SNAP
Wednesday 11/11
- **Adjusted Schedule – Veteran’s Day Assembly**
- Today we will practice entering data into Excel.
- Assignment: Lemonade Game
Thursday 11/12
- Today we will learn how to use functions, set print options and add visual elements to our Excel Spreadsheets.
- Check Synergy – if you are missing something, get it turned in!!!
- Begin Excel Section 3
- SNAP Tutorials 3.1 – 3.12
- 3.1 Creating Formulas and Absolute Addressing
- 3.2 Using Statistical Functions
- 3.3 Writing Formulas with Date Functions and Dates
- 3.4 Using Financial Functions
- 3.5 Naming and Using a Range
- 3.6 Using the Logical IF Function
- 3.7A Creating Charts in Excel
- 3.7B Changing Chart Design
- 3.8 Formatting with Chart Buttons
- 3.9 Inserting and Formatting a Shape
- 3.10 Changing Chart Formatting
- 3.11 Changing Page Layout Options
- 3.12 Inserting Headers and Footers
- SNAP Tutorials 3.1 – 3.12
Friday 11/13
- Today we will catch up on missing Excel work.
- Check synergy and refer to your printed grade check. USE YOUR TIME WISELY to get assignments turned in!
Week 13
Monday 11/2
- Today we will learn how to test worksheets, improve worksheet appearance, sort data, use the help feature, change page orientation, print a worksheet, and display formulas when printing.
- Together: White Page Activities 1.6-1.9 (page 18-27)
- Use your “LastNameES_1.2” from last week.
- Print gridelines and headings!
- Use your “LastNameES_1.2” from last week.
- Assignment: Skills Review 2 (page 30)
- Use your “LastNameES1-R” from last week’s Review 1
- BEFORE you print – add your name to bottom cell and check “Print” for Gridelines and Headings on Page Layout tab!
- Use your “LastNameES1-R” from last week’s Review 1
- Together: White Page Activities 1.6-1.9 (page 18-27)
Tuesday 11/3
- Today we will apply formulas and basic Excel knowledge to create workbooks.
Wednesday 11/4
- Today we will learn how to edit and format worksheets
- Learning Targets: Edit/Clear Cells | Using Proofing Tools | Inserting/Deleting Columns/Rows | Moving/Copying Cells | Adjusting Column Width/Row Height | AutoFit | Changing Font, Size, Style, & Color of Cells | Formatting Numeric Cells | Adjusting Decimal Places | Using Undo & Redo
- Begin Section 2 (pages 40 – 51)
- Open WBQuoteToMP – save as “LastName_ES2” to your Excel Folder.
Thursday 11/5
- Today we will learn how to edit and format worksheets
- Learning Targets: Edit/Clear Cells | Using Proofing Tools | Inserting/Deleting Columns/Rows | Moving/Copying Cells | Adjusting Column Width/Row Height | AutoFit | Changing Font, Size, Style, & Color of Cells | Formatting Numeric Cells | Adjusting Decimal Places | Using Undo & Redo
- Finish Section 2 (pages 40-51) if you did not do so yesterday.
- Assignment: Review 1 and 2, pages 68 and 69
- Open this and use for BOTH assignments: WBInvToNPC – save as “LastName_ES2_R1-2”
Friday 11/6
- Today we will apply formulas and basic Excel knowledge to create workbooks.
Week 12
Monday, October 26
- Today we will be introduced to the basics of Excel.
- Learning Targets: Opening, Saving, and Closing a Workbook | Entering Data in Cells | Performing Calculations Using Formulas | AutoSum | Copying and Testing Formulas | Sorting Data | Excel Help Window | Printing | Displaying Formulas | Navigating and Scrolling
- Assignment: SNAP Excel Section 1 Tutorials – complete all 10 tutorials in Section 1 (1.1 – 1.9B)
- When finished work on any missing assignments or you may continue some of the Excel games from Friday.
Tuesday, October 27
- Today we will enter labels and values and us fill options in Excel.
- Together: White Page Activity 1.2 (pages 8-11)
- Save as LastNameES_1.2
- Together: White Page Activity 1.2 (pages 8-11)
Wednesday, October 28
- Today we will perform calculations using formulas, use the SUM function, and copy formulas in Microsoft Excel.
- NEW SEATING CHART!
- Together: White Page Activities 1.3-1.5 (pages 12-17)
- Use your “LastNameES_1.2” workbook from yesterday
- Assignment: Skills Review 1 (page 30)
- Save as “LastNameES1-R” to your Excel folder on Cobra
Thursday, October 29
- **Adjusted Schedule**
- Today we will apply the skills learned in Excel to complete some practice workbooks.
- Assignment: Pamper Yourself Hand-Out
- Save as “LastNamePamper” to your Excel folder
- Assignment: Tour Revenue Hand-Out
- Save as “LastNameTourRevenue” to your Excel folder
- Assignment: Pamper Yourself Hand-Out
Friday, October 30
- Today we will use our creativity to complete a Halloween writing activity.
- Finish any missing Excel work first
- Excel Games from last Friday.
Week 11
Monday, October 19
- Today we will create brochures for Rocket House.
- Learning Targets: Brochure Templates | Inserting Images | Spelling & Grammar
- Warm-up: MicroType
- Assignment: Rocket House Brochure Project
- Use the resources in your Read Only folder on Cobra (“RH Brochure Project” folder)
Tuesday, October 20
- Today we will create brochures for Rocket House.
- Learning Targets: Brochure Templates | Inserting Images | Spelling & Grammar
- Warm-up: MicroType
- Assignment: Rocket House Brochure Project
- Use the resources in your Read Only folder on Cobra (“RH Brochure Project” folder)
Wednesday, October 21
- Today we will create brochures for Rocket House.
- Learning Targets: Brochure Templates | Inserting Images | Spelling & Grammar
- Warm-up: MicroType
- Assignment: Last day to finish Rocket House Brochure Project
- Use the resources in your Read Only folder on Cobra (“RH Brochure Project” folder)
Thursday, October 22
- **Adjusted Schedule Today | Period 3 | 10:55 – 11:35 am**
- Today we will be introduced to Microsoft Excel.
- Learning Targets: Formatting Cells and Entering Data
- Why use Excel?
- Open this document: Class Roster
- Font size/ style
- Alignment
- Deleting/Inserting (columns and rows)
Friday, October 23
- Today we will have some fun in Microsoft Excel!
Week 10
Monday, October 12
- Today we will be assessed over Word.
- Open this document (Crazy Laws) and complete the steps listed on the pink Crazy Laws handout.
- PRINT and save to “to be graded” when finished.
Tuesday, October 13
- Today we will be assessed over Word.
- First – finish Crazy Laws assessment from yesterday (PRINT and save to “to be graded” when finished)
- Second – Complete SNAP Assessment:
- Scroll to the bottom of Word Section 4 Assessment section. Click on “Performance Evaluation: Word Sections 1-4” that is listed at the VERY bottom to complete the SNAP assessment.
Wednesday, October 14
- Catch up day
- Complete any missing assessments from this week FIRST
- When finished with assessments, complete any missing Word assignments.
Thursday, October 15
- No School – Fall Break
Friday, October 16
- No School – Fall Break
Week 9
Monday, October 5
- Today we will learn how to format and enhance a document and how to use special features in Word.
- Catch Up Day – what are you missing from last week? Make sure all of the following Section 3 and 4 materials are completed by the end of the period.
- Section 3
- Book Work (see last Monday and Tuesday for links to assignments):
- White Pages 88 – 93
- Skills Review 3, page 105
- White Pages 94 – 97
- Challenge 1, page 109
- SNAP Word Section 3 Skill Exam
- Book Work (see last Monday and Tuesday for links to assignments):
- Section 4
- SNAP Tutorials: 4.1 – 4.6
- Book Work (see last Friday for links to assignments):
- White Pages 122-127
- White Pages 128-131
- Section 3
- Catch Up Day – what are you missing from last week? Make sure all of the following Section 3 and 4 materials are completed by the end of the period.
Tuesday, October 6
- Today we will enhance a document using special features in Word.
- Learning Objectives: Creating and Modifying a Table | Changing the Table Layout | Changing the Table Design | Inserting a File and Section Break | Creating and Modifying Newspaper Columns
- Book Work (together):
- White pages 132 – 137 (use this document: FCTIslandFlights – save as LastName_WS4white132-137)
Wednesday, October 7
- ADJUSTED SCHEDULE TODAY (Schedule B will be followed)
- Test Block 8:00-9:20
- Period 1 – 9:30-10:07
- Period 2 – 10:12-10:49
- Period 3 – 10:54-11:31
- Period 4
- 1 st Lunch 11:36-12:05 | Class 12:11-12:47
- Class 11:36-12:13 | 2nd Lunch 12:18-12:47
- Period 5 – 12:53-1:30
- Period 6 – 1:35-2:12
- Period 7 – 2:17-2:54
- Today we will enhance a document using special features in Word.
- Learning Targets: Creating and Modifying a Table | Changing the Table Layout | Changing the Table Design | Inserting a File and Section Break | Creating and Modifying Newspaper Columns
- Book Work (together):
- Finish White pages 132 – 137
- White pages 138 – 139 (use this document: FCTPetersburgAK – save as LastName_WS4white138-139)
- Book Work (together):
- Learning Targets: Creating and Modifying a Table | Changing the Table Layout | Changing the Table Design | Inserting a File and Section Break | Creating and Modifying Newspaper Columns
Thursday, October 8
- Today we will enhance documents using special features in Word.
- Learning Targets: Creating and Modifying a Table | Changing the Table Layout | Changing the Table Design | Inserting a File and Section Break | Creating and Modifying Newspaper Columns
- Before you begin – CHECK SYNERGY! What are you missing?
- Word Section 4 Book Work (blue pages):
- Review 4 – page 150 (Create a new blank document, save as LastName_WS4R4)
- Challenge 1 – page 155 (use this document: FCTOrcasIsland – save as LastName_Ws4C1)
Friday, October 9
- Today we will review all the information learned in MicroSoft Word to prepare for summative assessment next week.
- Complete Clarity Survey:
- https://www.bbyt.es/
- Student Code: 932FU
- Complete any missing Word Section 4 assignments
- Review for Word Test: FBLA – use pink instruction sheet
- Complete Clarity Survey:
Week 8
Monday, September 28
- Today we will learn how to format and enhance a document.
- Learning Targets: Formatting a Document in MLA Style | Inserting Citations | Creating a Works Cited Page | Editing Sources
- Warm-up: Microtype
- Word Section 3
- Assignment: White Pages 88 – 93 (use this document: FCTMiddletonRpt – save as LastName_WS3white88-93)
- Assignment: Skills Review 3, page 105 (use this document: PTRenaissanceRpt – save as LastName_WS3-R3)
Tuesday, September 29
- Today we will learn how to format and enhance a document.
- Learning Targets: Using Click and Type | Vertically Aligning Text | Inserting, Sizing, and Moving an Image
- Warm-up: Microtype
- Word Section 3
- Assignment: White Pages 94 – 97 (create a new document – save as LastName_WS3white94-97).
- NOTE on inserting graphics:
- If you cannot find the image it asked you to find for the suitcase/globe, find a similar one that fits the travel theme.
- The Logo needed for this document is found in Cobra > 8110 > Read Only > Word > WordS3 > FCTLogo.jpg
- NOTE on inserting graphics:
- Assignment: Challenge 1, page 109 (use this document: PTCostumes – save as LastName_WS3C1)
- NOTE on inserting graphics:
- The Logo needed for this document is found in Cobra > 8110 > Read Only > Word > WordS3 > PTLogo.jpg
- If you cannot find the book clipart image it asked you to use, find a similar one that fits the book theme.
- NOTE on inserting graphics:
- Assignment: White Pages 94 – 97 (create a new document – save as LastName_WS3white94-97).
Wednesday, September 30
- Today we will be assessed over formatting and enhancing a document.
- Warm-up: Microtype
- Assignment: SNAP Word Section 3 Skill Exam
Thursday, October 1
- Today we will learn how to format with special features.
- Learning Targets: Inserting and Modifying Word Art | Inserting and Formatting a Shape | Creating a Drop Cap and Inserting a Text Box | Creating SmartArt | Creating a Table | Changing the Table Layout | Changing the Table Design
- Warm-up: Microtype
- Assignments: SNAP Word Section 4 Tutorials
- 4.1 – Inserting and Modifying WordArt
- 4.2A – Inserting and Formatting a Shape
- 4.2B – Creating a Drop Cap and Inserting a Text Box
- 4.3 – Creating SmartArt
- 4.4 – Creating a Table
- 4.5 – Changing the Table Layout
- 4.6 – Changing the Table Design
Friday, October 2
- Today we will learn how to format and enhance a document.
- Learning Targets: Creating and Modifying WordArt Text | Creating Drop Caps and Text Boxes | Drawing Shapes | Creating SmartArt Graphics
- Warm-up: Microtype
- Word Section 4
- Assignment: White Pages 122-127 (use this document: FCTHawaiianSpecials – save as LastName_WS4White122-127)
- Assignment: White Pages 128-131 (use this document: FCTStructure – save as LastName_Ws4White128-131)
Week 7
Monday, September 21
- Today we will be assessed over formatting characters and paragraphs.
- Warm-up: MicroType
- Assignment: SNAP Assessment
- Skill Exam: Word Section 2 Skill Exam
- Check Synergy – work on any missing/incomplete work when finished
Tuesday, September 22
- Today we will be assessed over formatting characters and paragraphs.
- Warm-up: MicroType
- Review Tabs and Indents – many missed these on the SNAP assessment yesterday.
- Assignment: Finish SNAP Assessment from yesterday
- Skill Exam: Word Section 2 Skill Exam
- Assignment: Tabs/Indent Quiz
- Check Synergy! Grades have been updated – work on any missing/incomplete work when finished
Wednesday, September 23
- Today we will be assessed over formatting characters and paragraphs.
- Warm-up: MicroType
- Check Synergy – ALL grades have been entered/updated. Only 3 students have EVERY assignment turned in! No games until you have ZERO missing assignments.
- Catch up/work day
- Assignments: Finish SNAP Assessment from Monday and Tabs/Indent Quiz from Tuesday
- Work on any missing/incomplete assignments from Word Section 2
- Catch up/work day
Thursday, September 24
- Today we will learn how to format and enhance a document.
- Learning Targets: Cutting, Copying, and Pasting Text | Using the Clipboard Task Pane | Changing Margins, Page Orientation, and Paper Size | Inserting a Watermark, Page Color, and Page Border | Inserting Page Numbers and Page Breaks | Creating Headers and Footers | Modifying Headers and Footers | Inserting and Modifying Sources and Citations | Inserting a Works Cited Page
- Warm-up: MicroType
- Assignments: Word Section 3 SNAP Tutorials
- 3.1 Cutting, Copying, and Pasting Text
- 3.2 Using the Clipboard Task Pane
- 3.3 Changing Margins, Page Orientation, and Paper Size
- 3.4 Inserting a Watermark, Page Color, and Page Border
- 3.5A Inserting Page Numbers and Page Breaks
- 3.5B Creating Headers and Footers
- 3.5C Modifying Headers and Footers
- 3.6 Inserting and Modifying Sources and Citations
- 3.7 Inserting a Works Cited Page
Friday, September 25
- Today we will learn how to format and enhance a document.
- Learning Targets: Changing Margins, Page Orientation, and Paper Size | Inserting a Watermark, Page Color, and Page Border | Inserting Page Numbers and Page Breaks
- Warm-up: MicroType
- Word Section 3
- WS3_W82-84 – use for pages 82 – 87 (add your last name to the beginning of the document title)
- Stop at step 13 on page 85 and raise your hand – I will check this off of your computer before you move on to step 14 (DO NOT PRINT)!
- WS3_W82-84 – use for pages 82 – 87 (add your last name to the beginning of the document title)
Week 6
Monday, September 14
- Today we will learn how to format characters and paragraphs.
- Learning targets: inserting bullets and numbering, symbols
- Warm-up: MicroType
- SNAP Tutorials on own:
- 2.6 (Creating Bulleted and Numbered Lists)
- 2.7 (Inserting Symbols and Special Characters)
- Assignment: 20 Questions
- Finish any missing assignments from last week
Tuesday, September 15
- Today we will learn how to format characters and paragraphs.
- Learning targets: setting tabs and leaders
- Warm-up: MicroType
- Book Work together: pages 52 – 55
- Use this document: WS2-FCTRailTravel
Wednesday, September 16
- Today we will learn how to format characters and paragraphs.
- Learning targets: adding borders and shading, applying styles, style sets, and themes
- Warm-up: MicroType
- Book Work together: pages 56 – 59
- Assignments: Reviews 3-5, pages 63-65
- Use this document: FCTVacPackages
- Save as LastName-WS2-R345
- Use this document: FCTVacPackages
Thursday, September 17
- Today we will apply formatting to characters and paragraphs.
- Learning targets: Applying indent formatting and finding and replacing formatting | creating tabbed text | applying borders, shading, styles, and themes
- Warm-up: MicroType
- Assignments: Finish Reviews 3-5, pages 63-65 from yesterday (remember only one document will be turned in when finished)
- Assignment: Assessment 1, page 65
- Use this document: FCTLakeTahoeSkiing
- Save as LastName-WS2-A1
- Use this document: FCTLakeTahoeSkiing
- Assignment: Assessment 3, page 66
- File > New Document > Save as LastName-WS2-A3
Friday, September 18
- Today we will continue to apply formatting to characters and paragraphs.
- Warm-up: MicroType
- Catch up day – finish any missing work from Word Section 2
Week 5
Monday, September 7
- No School – Labor Day
Tuesday, September 8
- Today we will learn how to format characters and paragraphs.
- Learning Targets: modify font, format using the mini toolbar, highlight text, format using font dialog box, and use the format painter and repeat commands
- SNAP Tutorials
- Word section 2.1A through 2.2B
Wednesday, September 9
- Today we will learn how to format characters and paragraphs.
- Learning Targets: format using font dialog box, format painter/repeat commands, indenting, line and spacing options.
- Word Section 2 pages 40-45 together
- Open this document: FCTOslo
Thursday, September 10
- Warm-up: MicroType
- Today we will learn how to format characters and paragraphs.
- Word Section 2 pages 46-47 (finding and replacing formating)
- Please open LastName-WS2-FCTOslo from yesterday – I will check these on screen after we complete page 47
- Word Section 2 pages 46-47 (finding and replacing formating)
- Assignments: Skills Review 1 and 2, pages 62 and 63
- Open this: FCTPetersburg
- Save as “LastName-WS2-Review1-2” to your word folder, copy/paste to “to be graded” on Cobra
Friday, September 11
- Warm-up: MicroType
- Check your grades in Synergy – many of you are missing assignments from Word Section 1 – make sure you put your final version in “to be graded”
- Today we will apply formatting to characters and paragraphs.
- Assignments:
- Lyric Formatting
- Directions – Lyric Formatting Instructions
- Document to format – Lyric Formatting
- SNAP – Grade-It: Word Section 2, Skills Review 1
- Any missing work from Word Section 1 or 2
- Lyric Formatting
- Assignments:
Week 4
Monday, August 31
- Warm-up: MicroType
- Cell Phone Memo – follow instructions on green handout
Tuesday, September 1
- Warm-up: MicroType
- Snap Registration (Crabtree S1P3)
- Complete Grade-It, Word Section 1
- Skills review 1
- Skills review 3
Wednesday, September 2
- Warm-up: MicroType
- Finish Snap assignments from yesterday if you have not done so already (if you want to re-do the assignment, you may to earn a better score)
- Book work, Page 32
- Challenge 1: MPLtrhd – save as “LastName_Marquee” in Word folder and copy to “to be graded” when finished
- Challenge 2: FCTRenoTahoeVac – save as “LastName_Reno” in Word folder and copy to “to be graded” when finished
Thursday, September 3
- Warm-up: Micro-Type
- Finish assignments from Wednesday first
- Suzuki Letter (handout) – save as “LastName_Suzuki” – PRINT (make sure your name is at the bottom)
- Extra Challenges (handout)
Friday, September 4
- Warm-up: Micro-Type
- Work Day!
Week 3
Tuesday, August 25
- Warm-up: MicroType
- Begin Word Unit, Section 1
Wednesday, August 26
- Warm-up: MicroType or finish any incomplete PowerPoint assignments
- Finish Word Unit, Section 1
- Introduction Memo
- America’s Got Talent Worksheet
Thursday, August 27
- Warm-up: MicroType
- Finish Introduction Memo and America’s Got Talent – PRINT
- NEW: Memo (professional design) – use with XML Memo
Friday, August 28
- Warm-up: MicroType
- Check Synergy – what are you missing?
- Work day to finish any missing assignments (all of these should either be graded and entered in Synergy or should be in your “to be graded” folder)
- Book work – WS1 – FCTVacSpecials and WS1 – MPLtrtoFCT
- Should be in your “to be graded” folder on Cobra
- America’s Got Talent press release
- XML Memo
- Should be in your “to be graded” folder on Cobra