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.)
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.)
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.)
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 #4 – 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
REMINDER: Please check Skyward. Several Missing assignments from Word Chapter #7
DAY #3 – 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 #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 #1 – 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