Digital Applications 2

Lesson Plans


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.) (Links to an external site.)

Complete All Mindtap Assignments BY the end of the day on May 20th

  • EXCEL Module 6 Training
  • EXCEL Module 6 SAM Exam
  • EXCEL Module 7 Training
  • EXCEL Module 7 SAM Exam
  • ACCESS Module 4 Training
  • ACCESS Module 4 SAM Exam
  • ACCESS Module 5 Training
  • ACCESS Module 5 SAM Exam
  • ACCESS Module 6 Training
  • ACCESS Module 6 SAM Exam

MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.) (Links to an external site.)

Complete All Mindtap Assignments BY the end of the day on May 20th

  • EXCEL Module 6 Training
  • EXCEL Module 6 SAM Exam
  • EXCEL Module 7 Training
  • EXCEL Module 7 SAM Exam
  • ACCESS Module 4 Training
  • ACCESS Module 4 SAM Exam
  • ACCESS Module 5 Training
  • ACCESS Module 5 SAM Exam
  • ACCESS Module 6 Training
  • ACCESS Module 6 SAM Exam

MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.) (Links to an external site.)

QUIZ: Access #6 Quiz – 30 Points – Canvas

ACCESS CODE is located on Canvas Assignment

REMINDER: Textbook is in Mindtap = Blue Textbook on Right Side of Mindtap Page and text says FULL BOOK


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

ACCESS MODULE 6: Creating Reports and Forms

ASSIGNMENT: Access #6 SAM EXAM


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

ACCESS MODULE 6: Advanced Report Techniques
VIDEOS:  Complete all Videos (Located right below Sam Training) Access Module 6 SAM Videos

ASSIGNMENT: Use the Videos to Complete – Access Module 6 SAM Training
HINT:  You can have both videos and assignment open at same time.  You could watch the video and then complete the assignment in the exam.  


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.) (Links to an external site.)

QUIZ: Access #5 Quiz – 30 Points – Canvas

ACCESS CODE is located on Canvas Assignment

REMINDER: Textbook is in Mindtap = Blue Textbook on Right Side of Mindtap Page and text says FULL BOOK


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

PAST ASSIGNMENT: Please make sure to complete the Access Module 5 SAM Exam

ASSIGNMENT:  Complete the AC Chapter #5 Review Questions on Canvas. Same process as as always. Access code is chapter5.


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

ACCESS MODULE 5: Creating Reports and Forms

ASSIGNMENT: Access #5 SAM EXAM


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

ACCESS MODULE 5: Creating Reports and Forms
VIDEOS:  Complete all Videos (Located right below Sam Training) Access Module 5 SAM Videos

ASSIGNMENT: Use the Videos to Complete – Access Module 5 SAM Training
HINT:  You can have both videos and assignment open at same time.  You could watch the video and then complete the assignment in the exam.  


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

QUIZ: Access #4 Quiz – 30 Points – Canvas

ACCESS CODE is located on Canvas Assignment

REMINDER: Textbook is in Mindtap = Blue Textbook on Right Side of Mindtap Page and text says FULL BOOK


We are using our Blue Day/White Day Schedule. You will receive assignments from Blue Day Classes today (4/15) and for White Day Classes on Tuesday (4/16). This will continue until further notice.

MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

PAST ASSIGNMENT: Please make sure to complete the Access Module 4 SAM Exam

ASSIGNMENT:  Complete the AC Chapter #4 Review Questions on Canvas. Same process as as always. Access code is chapter4.


Today we start our Blue Day/White Day Schedule. You will receive assignments from Blue Day Classes today (4/13) and for White Day Classes on Tuesday (4/14). This will continue until further notice.

MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT:  Access Module 4 SAM Exam


MINDTAP THROUGH CENGAGE LEARNING

ONLINE – Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

ACCESS MODULE 4: Creating Reports and Forms
VIDEOS:  Complete all Videos (Located right below Sam Training) Access Module 4 SAM Videos

ASSIGNMENT: Use the Videos to Complete – Access Module 4 SAM Training
HINT:  You can have both videos and assignment open at same time.  You could watch the video and then complete the assignment in the exam.  


MINDTAP THROUGH CENGAGE LEARNING

REGISTER:  If you did NOT register do so NOW!

REGISTER FOR COURSE INSTRUCTIONS

STEP #1 – Copy this code to use on sign up – MTPNDTNNWDQ4

STEP #2 – Use Link to Sign-Up for the Course and Use previous code – http://nglsync.cengage.com/rostering/registration/course/MTPNDTNNWDQ4 (Links to an external site.) (Links to an external site.) (Links to an external site.) (Links to an external site.)

 (Links to an external site.) (Links to an external site.)

ONLINE – If you registered Monday, Log into system – LINK (Links to an external site.)

EXPLANATION ON GRADING – Students will receive a completion score for the Training they complete in each section.  If you complete the training you will receive full points.  For the SAM EXAM you will receive the grade you score.  Please note the difference.  In this unit you will have the Project Questions and QUIZ as well.  This will use the textbook.

ASSIGNMENT:  Excel Chapter #7 Quiz will be Monday. Always open book and Mindtap access.


MINDTAP THROUGH CENGAGE LEARNING

REGISTER:  If you did NOT register do so NOW!

REGISTER FOR COURSE INSTRUCTIONS

STEP #1 – Copy this code to use on sign up – MTPNDTNNWDQ4

STEP #2 – Use Link to Sign-Up for the Course and Use previous code – http://nglsync.cengage.com/rostering/registration/course/MTPNDTNNWDQ4 (Links to an external site.) (Links to an external site.)

 (Links to an external site.)

ONLINE – If you registered Monday, Log into system – LINK

EXPLANATION ON GRADING – Students will receive a completion score for the Training they complete in each section.  If you complete the training you will receive full points.  For the SAM EXAM you will receive the grade you score.  Please note the difference.  In this unit you will have the Project Questions and QUIZ as well.  This will use the textbook.

ASSIGNMENT:  Complete the EX Chapter #7 Review Questions on Canvas. Same process as as always. Access code is chapter7.

REMINDER: Excel Chapter #7 Quiz will be Monday. Always open book and Mindtap access.


MINDTAP THROUGH CENGAGE LEARNING

REGISTER:  If you did NOT register do so NOW!

REGISTER FOR COURSE INSTRUCTIONS

STEP #1 – Copy this code to use on sign up – MTPNDTNNWDQ4

STEP #2 – Use Link to Sign-Up for the Course and Use previous code – http://nglsync.cengage.com/rostering/registration/course/MTPNDTNNWDQ4 (Links to an external site.) (Links to an external site.)

 (Links to an external site.)

ONLINE – If you registered Monday, Log into system – LINK

EXPLANATION ON GRADING – Students will receive a completion score for the Training they complete in each section.  If you complete the training you will receive full points.  For the SAM EXAM you will receive the grade you score.  Please note the difference.  In this unit you will have the Project Questions and QUIZ as well.  This will use the textbook.

ASSIGNMENT:  Complete the Excel Module 7 SAM Exam

GRADES:  Now that I’m feeling better, I will update grades for unit #6.


**YOU MUST LOG IN TO CANVAS EACH ASSIGNMENT DAY FOR ATTENDANCE PURPOSES. LC WILL USE THIS TO KEEP ATTENDANCE RECORDS TO MEET REGULATIONS

MINDTAP THROUGH CENGAGE LEARNING

REGISTER:  If you did NOT register do so NOW!

REGISTER FOR COURSE INSTRUCTIONS

STEP #1 – Copy this code to use on sign up – MTPNDTNNWDQ4

STEP #2 – Use Link to Sign-Up for the Course and Use previous code – http://nglsync.cengage.com/rostering/registration/course/MTPNDTNNWDQ4 (Links to an external site.) (Links to an external site.)

 (Links to an external site.)

ONLINE – If you registered Monday, Log into system – LINK (Links to an external site.)

ASSIGNMENT: 

Excel Module 7: Creating Templates, Importing Data, and Working with SmartArt, Images and Screenshots
VIDEOS:  Complete all Videos (Located right below Sam Training) Excel Module 7 SAM Videos

ASSIGNMENT: Use the Videos to Complete – Excel Module 7 SAM Training
HINT:  You can have both videos and assignment open at same time.  You could watch the video and then complete the assignment in the exam.  


**YOU MUST LOG IN TO CANVAS EACH ASSIGNMENT DAY FOR ATTENDANCE PURPOSES. LC WILL USE THIS TO KEEP ATTENDANCE RECORDS TO MEET REGULATIONS

ATTENDANCE FORM – CLICK (MANDATORY)

Please click the link above and complete the form to provide attendance information.

CANVAS – Access Canvas to see your Assignment for Today!


**YOU MUST LOG IN TO CANVAS EACH ASSIGNMENT DAY FOR ATTENDANCE PURPOSES. LC WILL USE THIS TO KEEP ATTENDANCE RECORDS TO MEET REGULATIONS

ATTENDANCE FORM – CLICK (MANDATORY)

Please click the link above and complete the form to provide attendance information.

Please go to your CANVAS account and go to today. The course sign-up is attached with instructions. Please follow the instructions and get everything completed for today/tomorrow.


We will be using toddiwema.com on Wednesday to start our e-learning classes. Please check back on Monday, Wednesday, and Friday on days that were to be normal classes. I will keep track of the students attendance through an online attendance form.

Stay Safe!

Mr. Iwema


REMINDER: Please check Skyward. Several Missing assignments from Word Chapter #7

REMINDER: Project #5 Quiz today

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: Please check Skyward. Several Missing assignments from Word Chapter #7

REMINDER: Project #5 Quiz on Thursday

DAY #4Excel Project #5 – Working with Multiple Worksheets and Workbooks

Project #5 Objectives:

  • 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

Project #5 Assignments:

  • Chapter Directions – Multiple Worksheets
  • Lab #1 – Gladstone Schools Complete
  • Lab #2 – Commission Annual, Commission Quarter 1-4

REMINDER: Please check Skyward. Several Missing assignments from Word Chapter #7

DAY #3Excel Project #5 – Working with Multiple Worksheets and Workbooks

Project #5 Objectives:

  • 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

Project #5 Assignments:

  • 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

Project #5 Objectives:

  • 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

Project #5 Assignments:

  • Chapter Directions – Multiple Worksheets
  • Lab #1 – Gladstone Schools Complete
  • Lab #2 – Commission Annual, Commission Quarter 1-4

DAY #1Excel Project #5 – Working with Multiple Worksheets and Workbooks

Project #5 Objectives:

  • 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

Project #5 Assignments:

  • Chapter Directions – Multiple Worksheets
  • Lab #1 – Gladstone Schools Complete
  • Lab #2 – Commission Annual, Commission Quarter 1-4