Everyone have a Safe and Enjoyable Summer Break!
Good luck to all Seniors as you embark on New Adventures!
EXAM SCHEDULE
May 30 (Thursday) – White Day – Soft Period 5, Exam 6, Period 6, Exam 4
EXAM SCHEDULE
May 29 (Wednesday) – Blue Day – Soft Period 1, Exam 2, Period 3, Exam 3
May 30 (Thursday) – White Day – Soft Period 5, Exam 6, Period 6, Exam 4
EXAM SCHEDULE
May 28 (Tuesday) – White Day – Exam 5, Period 7, Period 6, Exam 7
May 29 (Wednesday) – Blue Day – Soft Period 1, Exam 2, Period 3, Exam 3
May 30 (Thursday) – White Day – Soft Period 5, Exam 6, Period 6, Exam 4
EXAM SCHEDULE
May 24 (Friday) – Blue Day – Exam 1, Period 2, Period 3, Period 4
May 28 (Tuesday) – White Day – Exam 5, Period 7, Period 6, Exam 7
May 29 (Wednesday) – Blue Day – Soft Period 1, Exam 2, Period 3, Exam 3
May 30 (Thursday) – White Day – Soft Period 5, Exam 6, Period 6, Exam 4
REMINDER: ACCESS #4/#5 QUIZ TODAY
REMINDER: ALL ACCESS ASSIGNMENT DUE TODAY!
EXAM SCHEDULE
May 24 (Friday) – Blue Day – Exam 1, Period 2, Period 3, Period 4
May 28 (Tuesday) – White Day – Exam 5, Period 7, Period 6, Exam 7
May 29 (Wednesday) – Blue Day – Soft Period 1, Exam 2, Period 3, Exam 3
May 30 (Thursday) – White Day – Soft Period 5, Exam 6, Period 6, Exam 4
Reminder: Access Project #4/#5 Quiz on Wednesday
Day #5 – Access Project #4/#5 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Day #4 – Access Project #4 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Chapter Directions – PrattLastAssociates
Lab #1 – Horticulture4U
Day #3 – Access Project #4 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Chapter Directions – PrattLastAssociates
Lab #1 – Horticulture4U
Day #3 – Access Project #4 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Chapter Directions – PrattLastAssociates
Lab #1 – Horticulture4U
Day #2 – Access Project #4 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Chapter Directions – PrattLastAssociates
Lab #1 – Horticulture4U
Reminder: Project #7 Quiz on Today!
Day #1 – Access Project #4 – Creating Reports and Forms
Group, Sort, and Total in a Report
Conditionally Format Controls in a report
Filter Report Records
Create a Multiple-Table Report
Create a form using the Form Wizard
Modify Controls in a control layout on a form
Filter From Records
Create Mailing Labels
Chapter Directions – PrattLastAssociates
Lab #1 – Horticulture4U
Reminder: Project #7 Quiz on Wednesday
Day #4 – Excel Project #7 – Creating Templates, Importing Data, and Working with Smartart, Images, and Screenshots
Create a Template with sample data and formulas
Use a Template to create a new workbook
Import and format outside Data into an Excel workbook
use the Quick Analysis gallery to create totals and charts easily.
Find and Replace data
Insert and format a Bar Chart
Create and format a Smartart graphic to display pictures and text
Add a hyperlinked Screenshot
Chapter Directions – High School Analysis
Lab #1 – Custom Fragrances
Day #3 – Excel Project #7 – Creating Templates, Importing Data, and Working with Smartart, Images, and Screenshots
Create a Template with sample data and formulas
Use a Template to create a new workbook
Import and format outside Data into an Excel workbook
use the Quick Analysis gallery to create totals and charts easily.
Find and Replace data
Insert and format a Bar Chart
Create and format a Smartart graphic to display pictures and text
Add a hyperlinked Screenshot
Chapter Directions – High School Analysis
Lab #1 – Custom Fragrances
Day #2 – Excel Project #7 – Creating Templates, Importing Data, and Working with Smartart, Images, and Screenshots
Create a Template with sample data and formulas
Use a Template to create a new workbook
Import and format outside Data into an Excel workbook
use the Quick Analysis gallery to create totals and charts easily.
Find and Replace data
Insert and format a Bar Chart
Create and format a Smartart graphic to display pictures and text
Add a hyperlinked Screenshot
Chapter Directions – High School Analysis
Lab #1 – Custom Fragrances
Day #1 – Excel Project #7 – Creating Templates, Importing Data, and Working with Smartart, Images, and Screenshots
Create a Template with sample data and formulas
Use a Template to create a new workbook
Import and format outside Data into an Excel workbook
use the Quick Analysis gallery to create totals and charts easily.
Find and Replace data
Insert and format a Bar Chart
Create and format a Smartart graphic to display pictures and text
Add a hyperlinked Screenshot
Chapter Directions – High School Analysis
Lab #1 – Custom Fragrances
Reminder: Project #6 Quiz today
Day #5 – Excel Project #6 – Creating, Sorting, and Querying a Table
Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart
Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete
Day #4 – Excel Project #6 – Creating, Sorting, and Querying a Table
Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart
Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete
Day #3 – Excel Project #6 – Creating, Sorting, and Querying a Table
Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart
Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete
Day #2 – Excel Project #6 – Creating, Sorting, and Querying a Table
Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart
Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete
Day #1 – Excel Project #6 – Creating, Sorting, and Querying a Table
Create and Format a Table
Use Lookup Tables in the worksheet
Insert Calculated Fields using structured references
Apply Conditional Formatting and icon sets
Sort Tables
Query a Table
Extract records with criteria ranges
Use Database functions and Conditional Functions
Display automatic subtotals, outline and treemap chart
Chapter Directions – Coffee Craft Daily Services
Lab #1 – City Market Complete
Reminder: Project #5 Test TODAY!
Day #5 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Reminder: Project #5 Test Thursday
Day #5 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Day #4 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Day #3 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Day #2 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Day #1 – Excel Project #5 – Working with Multiple Worksheets and Workbooks
Create and Format the Consolidated Worksheet
Fill using a Linear Series
Use Date and ROUND Functions
Apply a Custom Format Code
Create Cell Styles
Add and Populate Worksheets
Insert a 3-D Pie Chart
Link Workbooks
Chapter Directions – Multiple Worksheets
Lab #1 – Gladstone Schools Complete
Lab #2 – Commission Annual, Commission Quarter 1-4
Reminder: Excel Project #4 Quiz Today
Day #4 – Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Reminder: Excel Project #4 Quiz Friday
Day #4 – Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Day #3 – Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Day #2 – Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Day #1 – Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Reminder: Word Project #7 Quiz Today
Excel Project #4 – Financial Functions, Data Tables, and Amortization Schedules
Create the mortgage payment calculator in the worksheet
Create a data table in the worksheet
Create the amortization schedule in the worksheet
Format the worksheet
Create print areas in the worksheet
Protect cells in the worksheet
Check formulas of the worksheet
Chapter Directions – Mortgage Payment Calculator
Lab #1 – Education Savings Calculator
Lab #2 – Consumer Debt Calculator
Reminder: Project #7 Test on Monday
DAY #5 – Project #7 Creating a Newsletter with a Pull-Quote & Graphics
Chapter – Complete Security Trends
*Reminder – Put your name instead of Monthly Newsletter
Lab #1 – Complete Vintage Living Newsletter
*Reminder – Put your name instead of Monthly Newsletter
Lab #2 – Complete Health Check Newsletter
*Reminder – Put your name instead of Monthly Newsletter
QUESTIONS – WORD CHAPTER #7
Reminder: Project #7 Test on Monday
DAY #4 – Project #7 Creating a Newsletter with a Pull-Quote & Graphics
Chapter – Complete Security Trends
*Reminder – Put your name instead of Monthly Newsletter
Lab #1 – Complete Vintage Living Newsletter
*Reminder – Put your name instead of Monthly Newsletter
Lab #2 – Complete Health Check Newsletter
*Reminder – Put your name instead of Monthly Newsletter
QUESTIONS – WORD CHAPTER #7
DAY #3 – Project #7 Creating a Newsletter with a Pull-Quote & Graphics
Chapter – Complete Security Trends
*Reminder – Put your name instead of Monthly Newsletter
Lab #1 – Complete Vintage Living Newsletter
*Reminder – Put your name instead of Monthly Newsletter
Lab #2 – Complete Health Check Newsletter
*Reminder – Put your name instead of Monthly Newsletter
QUESTIONS – WORD CHAPTER #7
DAY #2 – Project #7 Creating a Newsletter with a Pull-Quote & Graphics
Chapter – Complete Security Trends
*Reminder – Put your name instead of Monthly Newsletter
Lab #1 – Complete Vintage Living Newsletter
*Reminder – Put your name instead of Monthly Newsletter
Lab #2 – Complete Health Check Newsletter
*Reminder – Put your name instead of Monthly Newsletter
QUESTIONS – WORD CHAPTER #7
DAY #1 – Project #7 Creating a Newsletter with a Pull-Quote & Graphics
Chapter – Complete Security Trends
*Reminder – Put your name instead of Monthly Newsletter
Lab #1 – Complete Vintage Living Newsletter
*Reminder – Put your name instead of Monthly Newsletter
Lab #2 – Complete Health Check Newsletter
*Reminder – Put your name instead of Monthly Newsletter
QUESTIONS – WORD CHAPTER #7
**Reminder: Project #6 Quiz on Today!
DAY #4 – Project #6 Generating Form Letters, Mailing Labels, and a Directory
Chapter – Complete Yazzie Merged Cover Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #1 – Complete Boskovich Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #2 – Complete Washington Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
QUESTIONS – WORD CHAPTER #6
**Reminder: Project #6 Quiz on Monday
DAY #4 – Project #6 Generating Form Letters, Mailing Labels, and a Directory
Chapter – Complete Yazzie Merged Cover Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #1 – Complete Boskovich Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #2 – Complete Washington Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
QUESTIONS – WORD CHAPTER #6
DAY #3 – Project #6 Generating Form Letters, Mailing Labels, and a Directory
Chapter – Complete Yazzie Merged Cover Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #1 – Complete Boskovich Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #2 – Complete Washington Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
QUESTIONS – WORD CHAPTER #6 QUESTIONS – chapter6
DAY #2 – Project #6 Generating Form Letters, Mailing Labels, and a Directory
Chapter – Complete Yazzie Merged Cover Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #1 – Complete Boskovich Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #2 – Complete Washington Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
QUESTIONS – WORD CHAPTER #6 QUESTIONS – chapter6
Project #6 Generating Form Letters, Mailing Labels, and a Directory
Chapter – Complete Yazzie Merged Cover Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #1 – Complete Boskovich Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
Lab #2 – Complete Washington Merged Letters
*Reminder – Replace First Data Source Entry with YOUR information
QUESTIONS – WORD CHAPTER #6 QUESTIONS – chapter6
Project #5 Test Today!
Word Project #5 – Using a Template to Create a Resume and Sharing a Finished Document
Chapter – Complete Yazzie Resume
*Reminder – Change Nina Tamaya Yazzie to your Name
Lab #1 – Complete Boskovich Resume
*Reminder – Change Jovan Marko Boskovich to your name
Lab #2 – Complete Washington Resume
*Reminder – Change Kaylee Jada Washington to your name
QUESTIONS – WORD CHAPTER #5 QUESTIONS – chapter5
Project #5 Test will be on Monday.
Word Project #5 – Using a Template to Create a Resume and Sharing a Finished Document
Chapter – Complete Yazzie Resume
*Reminder – Change Nina Tamaya Yazzie to your Name
Lab #1 – Complete Boskovich Resume
*Reminder – Change Jovan Marko Boskovich to your name
Lab #2 – Complete Washington Resume
*Reminder – Change Kaylee Jada Washington to your name
QUESTIONS – WORD CHAPTER #5 QUESTIONS – chapter5
Word Project #5 – Using a Template to Create a Resume and Sharing a Finished Document
Chapter – Complete Yazzie Resume
*Reminder – Change Nina Tamaya Yazzie to your Name
Lab #1 – Complete Boskovich Resume
*Reminder – Change Jovan Marko Boskovich to your name
Lab #2 – Complete Washington Resume
*Reminder – Change Kaylee Jada Washington to your name
QUESTIONS – WORD CHAPTER #5 QUESTIONS – chapter5
Word Project #5 – Using a Template to Create a Resume and Sharing a Finished Document
Chapter – Complete Yazzie Resume
*Reminder – Change Nina Tamaya Yazzie to your Name
Lab #1 – Complete Boskovich Resume
*Reminder – Change Jovan Marko Boskovich to your name
Lab #2 – Complete Washington Resume
*Reminder – Change Kaylee Jada Washington to your name
Snow Day Today – Enjoy the family time!
Snow Day Today – Enjoy the family time!
Snow Day Today – Enjoy the family time!
Snow Day Today – Enjoy the family time!
Snow Day Today – Enjoy the family time!
Word Project #5 – Using a Template to Create a Resume and Sharing a Finished Document
Chapter – Complete Yazzie Resume
*Reminder – Change Nina Tamaya Yazzie to your Name
Lab #1 – Complete Boskovich Resume
*Reminder – Change Jovan Marko Boskovich to your name
Lab #2 – Complete Washington Resume
*Reminder – Change Kaylee Jada Washington to your name
DAY #5 – WORD CHAPTER #4
TODAY – Complete the Word Project #4 Questions – Access Code given in class.
REMINDER: Project #4 Quiz will be Tuesday of next week.
ASSIGNMENT: Word Chapter #4 – Creating a Document with a Title Page, Lists, Tables, and a Watermark
REMINDER: Page #WD 213 Change HEADER text to your name instead of Dover Park Animal Clinic
REMINDER: Lab #1 – Change FOOTER text to your name instead of www.javajunction.com
REMINDER: Lab #2 – Change HEADER text to your name instead of A-PLUS TUTORS
Surf Flyer – Sales Proposal – 3 Pages
Lab #1 – Coffee House Proposal
Lab #2 – Tutoring Center Proposal
DAY #4 – WORD CHAPTER #4
ASSIGNMENT: Word Chapter #4 – Creating a Document with a Title Page, Lists, Tables, and a Watermark
REMINDER: Page #WD 213 Change HEADER text to your name instead of Dover Park Animal Clinic
REMINDER: Lab #1 – Change FOOTER text to your name instead of www.javajunction.com
REMINDER: Lab #2 – Change HEADER text to your name instead of A-PLUS TUTORS
Surf Flyer – Sales Proposal – 3 Pages
Lab #1 – Coffee House Proposal
Lab #2 – Tutoring Center Proposal
DAY #3 – WORD CHAPTER #4
ASSIGNMENT: Word Chapter #4 – Creating a Document with a Title Page, Lists, Tables, and a Watermark
REMINDER: Page #WD 213 Change HEADER text to your name instead of Dover Park Animal Clinic
REMINDER: Lab #1 – Change FOOTER text to your name instead of www.javajunction.com
REMINDER: Lab #2 – Change HEADER text to your name instead of A-PLUS TUTORS
Surf Flyer – Sales Proposal – 3 Pages
Lab #1 – Coffee House Proposal
Lab #2 – Tutoring Center Proposal
DAY #2 – WORD CHAPTER #4
ASSIGNMENT: Word Chapter #4 – Creating a Document with a Title Page, Lists, Tables, and a Watermark
REMINDER: Page #WD 213 Change HEADER text to your name instead of Dover Park Animal Clinic
REMINDER: Lab #1 – Change FOOTER text to your name instead of www.javajunction.com
REMINDER: Lab #2 – Change HEADER text to your name instead of A-PLUS TUTORS
Surf Flyer – Sales Proposal – 3 Pages
Lab #1 – Coffee House Proposal
Lab #2 – Tutoring Center Proposal
DAY #1 – WORD CHAPTER #4
ASSIGNMENT: Word Chapter #4 – Creating a Document with a Title Page, Lists, Tables, and a Watermark
REMINDER: Do NOT forget to add the HEADER correctly to each document
REMINDER: All Documents are to be printed, stapled, and turned in together in your bin!
*Print on Color LaserJet Printer
Surf Flyer – Sales Proposal – 3 Pages
Lab #1 – Coffee House Proposal
Lab #2 – Tutoring Center Proposal
Word Chapter #4 Review Questions
Word Chapter #4 Quiz
Student Seating Chart
Introduce Course to Students
Go Over Course Syllabus with Students
Go over Course Website with Students (New Version)
Place Student Log-In Numbers on Computer Screens – Record
Clean Out Log-In Numbers
Welcome back to semester 2.