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.