Digital Applications

PERIOD #2 – FINAL EXAM: DIGITAL APPS COMPUTER TEST

FINAL EXAM SCHEDULE

• PERIOD #1 – SOFT PERIOD #1
• PERIOD #2 – EXAM TODAY
• PERIOD #3 – NORMAL CLASS
• PERIOD #3 – EXAM TODAY

PERIOD #1 – FINAL EXAM: DIGITAL APPS COMPUTER TEST

FINAL EXAM SCHEDULE

• PERIOD #1 – EXAM TODAY
• PERIOD #2 – NORMAL CLASS
• PERIOD #3 – NORMAL CLASS
• PERIOD #4 – NORMAL CLASS

FINAL EXAM PROJECT: DUE BY END OF CLASS TODAY

DAY #5 – Final Exam Project

HANDOUT: Students are to read the handout very carefully. All the information you need is in the handout.

Students MAY work in groups of 2. NO MORE than 2 students.

Requirements:

• Cover Sheet – Locate examples online if necessary
• Word Documents – Complete 2 Word Documents from examples on sheet
• Excel Spreadsheets – Complete 2 Excel Spreadsheets form examples on sheet
  • One may be a simple spreadsheet
  • Second one must be more advanced
• Database – Create 2 separate tables. Then follow instructions on items to create from those two tables.
• Graphics – You must create a full page flyer. Then choose a second item form the list.

DAY #4 – Final Exam Project

HANDOUT: Students are to read the handout very carefully. All the information you need is in the handout.

Students MAY work in groups of 2. NO MORE than 2 students.

Requirements:

• Cover Sheet – Locate examples online if necessary
• Word Documents – Complete 2 Word Documents from examples on sheet
• Excel Spreadsheets – Complete 2 Excel Spreadsheets form examples on sheet
  • One may be a simple spreadsheet
  • Second one must be more advanced
• Database – Create 2 separate tables. Then follow instructions on items to create from those two tables.
• Graphics – You must create a full page flyer. Then choose a second item form the list.

DAY #3 – Final Exam Project

HANDOUT: Students are to read the handout very carefully. All the information you need is in the handout.

Students MAY work in groups of 2. NO MORE than 2 students.

Requirements:

• Cover Sheet – Locate examples online if necessary
• Word Documents – Complete 2 Word Documents from examples on sheet
• Excel Spreadsheets – Complete 2 Excel Spreadsheets form examples on sheet
  • One may be a simple spreadsheet
  • Second one must be more advanced
• Database – Create 2 separate tables. Then follow instructions on items to create from those two tables.
• Graphics – You must create a full page flyer. Then choose a second item form the list.

DAY #2 – Final Exam Project

HANDOUT: Students are to read the handout very carefully. All the information you need is in the handout.

Students MAY work in groups of 2. NO MORE than 2 students.

Requirements:

• Cover Sheet – Locate examples online if necessary
• Word Documents – Complete 2 Word Documents from examples on sheet
• Excel Spreadsheets – Complete 2 Excel Spreadsheets form examples on sheet
  • One may be a simple spreadsheet
  • Second one must be more advanced
• Database – Create 2 separate tables. Then follow instructions on items to create from those two tables.
• Graphics – You must create a full page flyer. Then choose a second item form the list.

DAY #1 – Final Exam Project

HANDOUT: Students are to read the handout very carefully. All the information you need is in the handout.

Students MAY work in groups of 2. NO MORE than 2 students.

Requirements:

• Cover Sheet – Locate examples online if necessary
• Word Documents – Complete 2 Word Documents from examples on sheet
• Excel Spreadsheets – Complete 2 Excel Spreadsheets form examples on sheet
  • One may be a simple spreadsheet
  • Second one must be more advanced
• Database – Create 2 separate tables. Then follow instructions on items to create from those two tables.
• Graphics – You must create a full page flyer. Then choose a second item form the list.

DAY #2 ACCESS PROJECT #3 – MAINTAINING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-M3Q#-PAGE #

Printing: Project #3 – Print Using C126 Color (01) printer – Printing on BOTH SIDES

• Page #1 – M3Q01
• Page #2 AND Back of Page #2 – M3Q02
• Page #3 – Account Financial Report

DAY #1 ACCESS PROJECT #3 – MAINTAINING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-M3Q#-PAGE #

Printing: Project #3 – Print Using C126 Color (01) printer – Printing on BOTH SIDES

• Page #1 – M3Q01
• Page #2 AND Back of Page #2 – M3Q02
• Page #3 – Account Financial Report

Reminder: Access Project #2 Test Today!

DAY #5 ACCESS PROJECT #2 – QUERYING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-LAB #1-STEP #
• SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

• OMIT Step #12, #13, #14
• SAVE AS – Access 2 – Lab #1 Printouts

Printing Lab #1

• Page #1 – Steps #1, #2, #3, #4, #6
• Page #2 – Steps #7, #8
• Page #3 – Steps #9, #10, State Sales Rep Crosstab

LAB #2 – Querying the Museum Gift Shop Database

• OMIT Step #15
• SAVE AS – Access 2 – Lab #2 Printouts

Printing Lab #2

• Page #1 – Steps #1, #2, #3, #4
• Page #2 – Steps #5, #6, #7, Vendor Item Query
• Page #3 – Steps #12, #13, #14

Access #2 Word Bank

MIN, OR, aggregate, fixed-width, ?, parameter, asterisk, Wildcards, AND, Datasheet, primary sort, asterisk, property sheet, query,

Reminder: Access Project #2 Test on Wednesday

DAY #4 ACCESS PROJECT #2 – QUERYING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-LAB #1-STEP #
• SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

• OMIT Step #12, #13, #14
• SAVE AS – Access 2 – Lab #1 Printouts

Printing Lab #1

• Page #1 – Steps #1, #2, #3, #4, #6
• Page #2 – Steps #7, #8
• Page #3 – Steps #9, #10, State Sales Rep Crosstab

LAB #2 – Querying the Museum Gift Shop Database

• OMIT Step #15
• SAVE AS – Access 2 – Lab #2 Printouts

Printing Lab #2

• Page #1 – Steps #1, #2, #3, #4
• Page #2 – Steps #5, #6, #7, Vendor Item Query
• Page #3 – Steps #12, #13, #14

Access #2 Word Bank

MIN, OR, aggregate, fixed-width, ?, parameter, asterisk, Wildcards, AND, Datasheet, primary sort, asterisk, property sheet, query,

DAY #3 ACCESS PROJECT #2 – QUERYING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-LAB #1-STEP #
• SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

• OMIT Step #12, #13, #14
• SAVE AS – Access 2 – Lab #1 Printouts

Printing Lab #1

• Page #1 – Steps #1, #2, #3, #4, #6
• Page #2 – Steps #7, #8
• Page #3 – Steps #9, #10, State Sales Rep Crosstab

LAB #2 – Querying the Museum Gift Shop Database

• OMIT Step #15
• SAVE AS – Access 2 – Lab #2 Printouts

Printing Lab #2

• Page #1 – Steps #1, #2, #3, #4
• Page #2 – Steps #5, #6, #7, Vendor Item Query
• Page #3 – Steps #12, #13, #14

Access #2 Word Bank

MIN, OR, aggregate, fixed-width, ?, parameter, asterisk, Wildcards, AND, Datasheet, primary sort, asterisk, property sheet, query,

DAY #2 ACCESS PROJECT #2 – QUERYING A DATABASE

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-LAB #1-STEP #
• SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

• OMIT Step #12, #13, #14
• SAVE AS – Access 2 – Lab #1 Printouts

LAB #2 – Querying the Museum Gift Shop Database

• OMIT Step #14, and #15
• SAVE AS – Access 2 – Lab #2 Printouts

DAY #1 ACCESS PROJECT #2 – QUERYING A DATABASE

ASSIGNMENTS
CHAPTER WORK:  CREATE AND WORK TOGETHER ON CHAPTER #2 TOGETHER

*VERY IMPORTANT INFORMATION IN THE NEXT LINE

• SAVE ALL STEPS BY YLN-LAB #1-STEP #
• SAVE ALL STEPS BY YLN-LAB #2-STEP #

LAB #1 – Querying the Garden Naturally Database

• OMIT Step #12, #13, #14
• SAVE AS – Access 2 – Lab #1 Printouts

LAB #2 – Querying the Museum Gift Shop Database

• OMIT Step #14, and #15
• SAVE AS – Access 2 – Lab #2 Printouts

Access Chapter #1 Quiz Today!

DAY #4 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to p126 Black and White – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to p126 Black and White – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

Access Chapter #1 Quiz on Thursday

DAY #4 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to p126 Black and White – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to p126 Black and White – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

Access Chapter #1 Quiz on Thursday

DAY #3 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to p126 Black and White – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to p126 Black and White – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

DAY #2 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to COLOR LaserJet – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to COLOR Laserjet – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

DAY #2 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to COLOR LaserJet – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to COLOR Laserjet – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

DAY #1 – ACCESS CHAPTER #1

LAB #1 – Garden Naturally Database

• YLN – Sales Rep Table
• YLN – Customer Table
• YLN – Customer Query
• YLN – Customer Financial Report

LAB #2 – Museum Gift Shop Database

• YLN – Vendor Table
• YLN – Item Table
• YLN – Item Query
• YLN – Item Form
• YLN – Item Status Report

Printing – Query and Tables
Click the PRINT PREVIEW icon – Change to LANDSCAPE VIEW – Change Margins to NORMAL – Click PRINT – Change Printer to COLOR LaserJet – Click PRINT

Printing – Forms and Reports
Click the PRINT PREVIEW icon – Click the PRINT button – Change to COLOR Laserjet – SET FROM PAGE 1 TO PAGE 1 – Click PRINT

NEW ASSIGNMENT:  Review Questions – Access Chapter #1

WORD BANK – Design, records, Database design, Currency, green, Insert Field, redundancy, printout, database management system, field, systems analysis, Click to Add

REMINDER: Excel Project #3 Test Today!

DAY #4: EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if.

Period #1 Dual Credit Testing:

DAY #3 (Extended due to internet issues and Dual Credit): EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if.

Period #2 Dual Credit Testing:

DAY #2 (Extended due to internet issues): EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if.

DAY #2: EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if.

DAY #1: EXCEL PROJECT #3 – WORKING WITH LARGE WORKSHEETS, CHARTING, AND WHAT-IF ANALYSIS

ASSIGNMENTS
CLASS WORK:  KAITLYN’S ICE CREAM SHOP FINANCIAL PROJECTION
APPLYING YOUR KNOWLEDGE (PART #3 ONLY):  ABSOLUTE CELL REFERENCE (FORMULAS ONLY!)
PROJECT:  LAB 1 AND LAB #1 PART #2 – AUGUST ONLINE TECHNOLOGY EIGHT YEAR FINANCIAL PROJECTION

PRINTING:  PRINT DISPLAY AND FORUMULAS UNLESS NOTED – ALWAYS ADD A FOOTER ON BOTTOM RIGHT OF DOCUMENT – ALL PAGES MUST FIT ON ONE SHEET

WORD LIST – CH #3 QUESTIONS
#REF!, absolute, Assumptions, Copy Cells, drag and drop, Fill Formatting Only, Fill Months, Fill Series, Fill Series, Fill Without Formatting, freeze, IF, keyboard shortcuts, SPARKLINE TOOLS DESIGN tab, what-if.

DAY #4 – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

Reminder: Quiz for Excel Project #2 will be TODAY

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING: Same printing rules as Excel Project #1 – Follow directions on printing instruction sheet

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy

Dual Credit: Re-Take day for Ivy Tech Dual Credit

DAY #EXTRA DAY – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

Reminder: Quiz for Excel Project #2 will be Wednesday

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING: Same printing rules as Excel Project #1 – Follow directions on printing instruction sheet

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy

DAY #3 – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING: Same printing rules as Excel Project #1 – Follow directions on printing instruction sheet

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy

DAY #2 – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING: Same printing rules as Excel Project #1 – Follow directions on printing instruction sheet

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy

DAY #1 – EXCEL PROJECT #2 – FORMULAS, FUNCTIONS, AND FORMATTING

ASSIGNMENTS
CLASS WORK:  OLIVIA’S ART SUPPLY SALARY REPORT
APPLYING YOUR KNOWLEDGE:  PROXIMITY BUS COMPLETE (FORMULA COPY ONLY)
PROJECT:  LAB 1 – AYLIN INSURANCE PREMIUM ANALYSIS
PROJECT:  LAB 2 – INTERNATIONAL MOVING COMPANY REPORT

PRINTING: Same printing rules as Excel Project #1 – Follow directions on printing instruction sheet

REVIEW QUESTION WORD LIST: 
Page Layout, division, Page Layout, subtraction, Margins, pixel, warmer, Best fit, fill handle, formula, ESC, Hiding cell, circular reference, mm/dd/yyyy

DUAL CREDIT: Room E221 for Dual Credit Accuplacer Testing

QUIZ: Excel Project #1 Quiz on TODAY!

REMINDER: Excel Project #1 Quiz on Wednesday!

DAY #4: EXCEL PROJECT #1 – CREATING A WORKSHEET & AND A CHART

ASSIGNMENTS
CLASS WORK:  LINDA FOX BUDGET 
PROJECT:  LAB 1 – KATIE’S KICKS
PROJECT:  LAB 2 – DAVIS MOBILE CONCEPTS

WORD BANK – QUESTIONS
Auto Fill Options, AutoCorrect, BACKSPACE, Calibri, chart, Font style, formula bar, Green computing, line, Merging, Name box, planning, plus sign, relative reference, SUM, Sum

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

GRAPH COPY – Tap or Click on the MONTHLY EXPENSES tab at the bottom of the Excel Window – Tap or Click the FILE tab – Tap or Click the PRINT tab – Select the HP Color LaserJet 3800 – VERIFY that LANDSCAPE ORIENTATION – Tap or Click the PRINT button

DAY #3: EXCEL PROJECT #1 – CREATING A WORKSHEET & AND A CHART

ASSIGNMENTS
CLASS WORK:  LINDA FOX BUDGET 
PROJECT:  LAB 1 – KATIE’S KICKS
PROJECT:  LAB 2 – DAVIS MOBILE CONCEPTS

WORD BANK – QUESTIONS
Auto Fill Options, AutoCorrect, BACKSPACE, Calibri, chart, Font style, formula bar, Green computing, line, Merging, Name box, planning, plus sign, relative reference, SUM, Sum

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

GRAPH COPY – Tap or Click on the MONTHLY EXPENSES tab at the bottom of the Excel Window – Tap or Click the FILE tab – Tap or Click the PRINT tab – Select the HP Color LaserJet 3800 – VERIFY that LANDSCAPE ORIENTATION – Tap or Click the PRINT button

DAY #2: EXCEL PROJECT #1 – CREATING A WORKSHEET & AND A CHART

ASSIGNMENTS
CLASS WORK:  LINDA FOX BUDGET 
PROJECT:  LAB 1 – KATIE’S KICKS
PROJECT:  LAB 2 – DAVIS MOBILE CONCEPTS

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

GRAPH COPY – Tap or Click on the MONTHLY EXPENSES tab at the bottom of the Excel Window – Tap or Click the FILE tab – Tap or Click the PRINT tab – Select the HP Color LaserJet 3800 – VERIFY that LANDSCAPE ORIENTATION – Tap or Click the PRINT button

DAY #1: EXCEL PROJECT #1 – CREATING A WORKSHEET & AND A CHART

ASSIGNMENTS
CLASS WORK:  LINDA FOX BUDGET 
PROJECT:  LAB 1 – KATIE’S KICKS
PROJECT:  LAB 2 – DAVIS MOBILE CONCEPTS

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

GRAPH COPY – Tap or Click on the MONTHLY EXPENSES tab at the bottom of the Excel Window – Tap or Click the FILE tab – Tap or Click the PRINT tab – Select the HP Color LaserJet 3800 – VERIFY that LANDSCAPE ORIENTATION – Tap or Click the PRINT button

DUAL CREDIT: Dual Credit Application Due by 9/20! – IVY TECH LINK

QUIZ: Project #3 Quiz will be Today (9/19)

DAY #1: EXCEL PROJECT #1 – CREATING A WORKSHEET & AND A CHART

ASSIGNMENTS
CLASS WORK:  LINDA FOX BUDGET 
PROJECT:  LAB 1 – KATIE’S KICKS
PROJECT:  LAB 2 – DAVIS MOBILE CONCEPTS

PRINTING:

Enter a FOOTER – Click the INSERT TAB – Select the Header & Footer Button – Scroll to BOTTOM OF PAGE – Type Your Name, Bob Gleamin Budget, Period # Today’s Date

DO NOT USE QUICK PRINT

DISPLAY COPY – Tap or Click the FILE Tab – Tap or Click the PRINT tab – SELECT the HP Color LaserJet 3800 – Tap or Click the PORTRAIT ORIENTATION button and select LANDSCAPE – Tap or Click the NO SCALING BUTTON and select ‘FIT SHEET ON ONE PAGE – Tap or Click the PRINT button

FORMULAS COPY – Hold down the CTRL KEY and hit the ACCENT KEY ( ~ ) to display the formula’s copy – Tap or Click the FILE Tab – VERIFY that LANDSCAPE ORIENTATION and FIT SHEET ON ONE PAGE is STILL Selected – Tap or Click the PRINT button.

GRAPH COPY – Tap or Click on the MONTHLY EXPENSES tab at the bottom of the Excel Window – Tap or Click the FILE tab – Tap or Click the PRINT tab – Select the HP Color LaserJet 3800 – VERIFY that LANDSCAPE ORIENTATION – Tap or Click the PRINT button

DUAL CREDIT: Dual Credit Application Due by 9/20! – IVY TECH LINK

QUIZ: Project #3 Quiz will be Tomorrow (9/19)

Day #3 – WORD CHAPTER #3

ASSIGNMENT:  Word Chapter #3 – Creating a Business Letter with a Letterhead and Table

REMINDER:  Do NOT forget to add the HEADER correctly to each document
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

Lee Vendor Letter – Chapter Work
Applying Your Knowledge – Fall Semester Schedule (Pgs. #WD174 – #WD175)
Lab #1 – Internship Letter (Pgs. #WD179 – #WD180)
Lab #2 – Confirmation Letter (Pgs. #WD180 – #WD182)

Word Chapter #3 Review Questions – WORD BANK: 

building block, cell, clear formatting, column boundary, date line, dimension, end-of-cell mark, Floating, inline, nonbreaking hyphen, nonbreaking space, row boundary, tab character, tab stop, table, table resize handle, floating

Word Chapter #3 Quiz

Day #2 – WORD CHAPTER #3

ASSIGNMENT:  Word Chapter #3 – Creating a Business Letter with a Letterhead and Table

REMINDER:  Do NOT forget to add the HEADER correctly to each document
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

Lee Vendor Letter – Chapter Work
Applying Your Knowledge – Fall Semester Schedule (Pgs. #WD174 – #WD175)
Lab #1 – Internship Letter (Pgs. #WD179 – #WD180)
Lab #2 – Confirmation Letter (Pgs. #WD180 – #WD182)

Word Chapter #3 Review Questions – WORD BANK: 

building block, cell, clear formatting, column boundary, date line, dimension, end-of-cell mark, Floating, inline, nonbreaking hyphen, nonbreaking space, row boundary, tab character, tab stop, table, table resize handle, floating

Word Chapter #3 Quiz

Day #1 – WORD CHAPTER #3

ASSIGNMENT:  Word Chapter #3 – Creating a Business Letter with a Letterhead and Table

REMINDER:  Do NOT forget to add the HEADER correctly to each document
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

Lee Vendor Letter – Chapter Work
Applying Your Knowledge – Fall Semester Schedule (Pgs. #WD174 – #WD175)
Lab #1 – Internship Letter (Pgs. #WD179 – #WD180)
Lab #2 – Confirmation Letter (Pgs. #WD180 – #WD182)

REMINDER:  WORD CHAPTER #2 QUIZ TODAY

WORD CHAPTER #3

ASSIGNMENT:  Word Chapter #3 – Creating a Business Letter with a Letterhead and Table

REMINDER:  Do NOT forget to add the HEADER correctly to each document
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

Lee Vendor Letter – Chapter Work
Applying Your Knowledge – Fall Semester Schedule (Pgs. #WD174 – #WD175)
Lab #1 – Internship Letter (Pgs. #WD179 – #WD180)
Lab #2 – Confirmation Letter (Pgs. #WD180 – #WD182)

Word Chapter #3 Review Questions – WORD BANK: 

building block, cell, clear formatting, column boundary, date line, dimension, end-of-cell mark, Floating, inline, nonbreaking hyphen, nonbreaking space, row boundary, tab character, tab stop, table, table resize handle, floating

Word Chapter #3 Quiz

EXTENDED – Project #2 Quiz on Wednesday

EXTENDED – DAY #3 WORD CHAPTER #2

WORD CHAPTER #2 – Creating a Research Paper with References and Sources

REMINDER:  Do NOT forget to add the HEADER correctly to each document (Last Name, Page #)
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

CHAPTER WORK – HEADPHONES AND EARBUDS RESEARCH PAPER
LAB #1 – WEARABLE DEVICES RESEARCH PAPER
LAB #2 – TWO STEP VERIFICATION PAPER

QUESTIONS – WORD CHAPTER #2 QUESTIONS – chapter2

WORD BANK – AutoCorrect, AutoCorrect Options button, automatic page breaks, background repagination, Click, formatting, hanging indent, header, Line spacing, manual page break, note reference mark, parenthetical references, Paste Options button, proofreading, soft page breaks, works cited

QUIZ – WORD CHAPTER #2 QUIZ

Project #2 Quiz on Monday

DAY #3 WORD CHAPTER #2

WORD CHAPTER #2 – Creating a Research Paper with References and Sources

REMINDER:  Do NOT forget to add the HEADER correctly to each document (Last Name, Page #)
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

CHAPTER WORK – HEADPHONES AND EARBUDS RESEARCH PAPER
LAB #1 – WEARABLE DEVICES RESEARCH PAPER
LAB #2 – TWO STEP VERIFICATION PAPER

QUESTIONS – WORD CHAPTER #2 QUESTIONS – chapter2

WORD BANK – AutoCorrect, AutoCorrect Options button, automatic page breaks, background repagination, Click, formatting, hanging indent, header, Line spacing, manual page break, note reference mark, parenthetical references, Paste Options button, proofreading, soft page breaks, works cited

QUIZ – WORD CHAPTER #2 QUIZ

DAY #2 WORD CHAPTER #2

WORD CHAPTER #2 – Creating a Research Paper with References and Sources

REMINDER:  Do NOT forget to add the HEADER correctly to each document (Last Name, Page #)
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

• CHAPTER WORK – HEADPHONES AND EARBUDS RESEARCH PAPER
• LAB #1 – WEARABLE DEVICES RESEARCH PAPER
  • Carter = Article in a Periodical
  • Pappas = Book
  • Yazzie = Website
• LAB #2 – TWO STEP VERIFICATION PAPER

QUESTIONS – WORD CHAPTER #2 QUESTIONS – chapter2

QUIZ – WORD CHAPTER #2 QUIZ

QUIZ: Word Project #1 Quiz Today!!

DAY #1 WORD CHAPTER #2

WORD CHAPTER #2 – Creating a Research Paper with References and Sources

REMINDER:  Do NOT forget to add the HEADER correctly to each document (Last Name, Page #)
REMINDER:  All Chapter Documents are to be printed, stapled, and turned in together in your bin!

CHAPTER WORK – HEADPHONES AND EARBUDS RESEARCH PAPER
LAB #1 – WEARABLE DEVICES RESEARCH PAPER
LAB #2 – TWO STEP VERIFICATION PAPER

QUESTIONS – WORD CHAPTER #2 QUESTIONS – chapter2

QUIZ – WORD CHAPTER #2 QUIZ

**Dual Credit Registration – Ivy Tech Link

DAY #3 – WORD CHAPTER #1 (Day #2 due to Dual Credit Application)

**Digital Apps Project #1 Quiz on Thursday

Student Data File Location: File Explorer – Click this PC – Click Business Folder – Click Iwema Folder – Click Digital Apps – Click SDF Word – Click Module 1

ASSIGNMENT:  Word Chapter #1 – Creating, Formatting, and Editing a Word Document with a Picture

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!

• Surf Flyer – Chapter Work
  • Image Location – This PC-Business Drive-Common Folder-Iwema Folder-Digital Apps Folder-SDF Word Folder-Module 1
• Applying Your Knowledge – Graduation Flyer (Pg. #WD48-#WD49)
• Lab #1 – Commodity Trading Flyer (Pgs. #WD52 – #WD54)
• Lab #2 – Spring Break Flyer (Pgs. #WD54 – #WD56)

Word Chapter #1 Review Questions

CHAPTER #1 WORD BANK

body, bulleted, centered, Character formatting, default, drag and drop, formatting mark, insert, insert mode, Paragraph formatting, Resizing, selection rectangle, SPACEBAR, Underlined, virus

Word Chapter #1 Quiz

**Dual Credit Registration – Ivy Tech Link

DAY #2 – WORD CHAPTER #1 (Day #2 due to Dual Credit Application)

Student Data File Location: File Explorer – Click this PC – Click Business Folder – Click Iwema Folder – Click Digital Apps – Click SDF Word – Click Module 1

ASSIGNMENT:  Word Chapter #1 – Creating, Formatting, and Editing a Word Document with a Picture

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!

• Surf Flyer – Chapter Work
  • Image Location – This PC-Business Drive-Common Folder-Iwema Folder-Digital Apps Folder-SDF Word Folder-Module 1
• Applying Your Knowledge – Graduation Flyer (Pg. #WD48-#WD49)
• Lab #1 – Commodity Trading Flyer (Pgs. #WD52 – #WD54)
• Lab #2 – Spring Break Flyer (Pgs. #WD54 – #WD56)

Word Chapter #1 Review Questions

Word Chapter #1 Quiz

**We will be registering for Dual Credit TODAY! Text your parents for SS# if you did not get my message last night.
*Complete and turn in Review Assignment in your bin

DAY #2 – WORD CHAPTER #1

Student Data File Location: File Explorer – Click this PC – Click Business Folder – Click Iwema Folder – Click Digital Apps – Click SDF Word – Click Module 1

ASSIGNMENT:  Word Chapter #1 – Creating, Formatting, and Editing a Word Document with a Picture

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!

• Surf Flyer – Chapter Work
  • Image Location – This PC-Business Drive-Common Folder-Iwema Folder-Digital Apps Folder-SDF Word Folder-Module 1
• Applying Your Knowledge – Graduation Flyer (Pg. #WD48-#WD49)
• Lab #1 – Commodity Trading Flyer (Pgs. #WD52 – #WD54)
• Lab #2 – Spring Break Flyer (Pgs. #WD54 – #WD56)

Word Chapter #1 Review Questions

Word Chapter #1 Quiz

*Complete and turn in Review Assignment in your bin

DAY #1- WORD CHAPTER #1

ASSIGNMENT:  Word Chapter #1 – Creating, Formatting, and Editing a Word Document with a Picture

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!

• Surf Flyer – Chapter Work
  • Image Location – This PC-Business Drive-Common Folder-Iwema Folder-Digital Apps Folder-SDF Word Folder-Module 1
• Applying Your Knowledge – Graduation Flyer (Pg. #WD48-#WD49)
• Lab #1 – Commodity Trading Flyer (Pgs. #WD52 – #WD54)
• Lab #2 – Spring Break Flyer (Pgs. #WD54 – #WD56)

Word Chapter #1 Review Questions

Word Chapter #1 Quiz

*Complete and turn in Review Assignment in your bin

DAY #1- WORD CHAPTER #1

ASSIGNMENT:  Word Chapter #1 – Creating, Formatting, and Editing a Word Document with a Picture

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!

Surf Flyer – Chapter Work
Applying Your Knowledge – Graduation Flyer (Pg. #WD48-#WD49)
Lab #1 – Commodity Trading Flyer (Pgs. #WD52 – #WD54)
Lab #2 – Spring Break Flyer (Pgs. #WD54 – #WD56)

Word Chapter #1 Review Questions

Word Chapter #1 Quiz

**Clean out student folders at beginning of class

Assignment:  Digital Communications Review Assignment – LINK

Complete a Memo
Complete a Personal Business Letter
Complete a Business Letter

Print, Staple, and Turn in when completed

Student Seating Charts
Introduce Course to Students
Go Over Course Syllabus with Students
Go over Course Website with Students
Place Student Log-In Numbers on Computer Screens – Record
Clean Out Log-In Numbers