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:
Aniol | Nicholas |
Becker | Parker |
Gluth | Tristan |
Kubiak | Brianna |
Matthews | Joshua |
Reed | Jacob |
Sanchez | Angel |
Schaftlein | Michael |
Scott | Tia |
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:
Arcella | Nicholas |
Draus | Ryan |
Gutierrez | Vidal |
Johnson | Zachary |
McGuffey | Eli |
Romo | Jeylian |
Salminen | Brayden |
Skipper | Caleb |
Swanson | Connor |
Williams | Rhett |
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