A4 Introduction
Part 1: Establishing the Schedule
Start a new workbook and outline all materials due for the class
Include Today's Date (as a function that will update daily) with a label in a separate cell to identify it
The formatting of the date should be: Day of Week, Month, Day, Year
Create column headers for the Week#, Activity, Estimated Time for Completion, Due Date, Days Left, Completed (Y/N), and Grade. (These headers can be in any order you would like on the spreadsheet)
Headers should be formatted differently than standard data entry with any or all of the following elements (at least one required): Bold, Italics, Underline, Borders, Unique Color
A4 Part 1 Tutorial 1 of 2
Enter all activities and graded items for the class into your spreadsheet. (Use your resources from the FSO Platform expected course activities. Include BOTH weighted AND unweighted activities - anything you spend time on)
Create a Summary Row for each Week. (You will add a function at a later point.)
Enter expected due dates for each activity. (These can be due dates you establish for yourself or ones expected for the class based on the FSO platform.)
Enter your best guess of estimated hours it will take to complete each activity.
Enter "Yes" or "No" completion reference for each activity.
Create a Validation for each item in the Grade column that does not allow an entry greater than 100. (The tutorial will show you how to copy/paste this validation for quicker entry.)
A4 Part 1 Tutorial 2 of 2 Validation
Enter grade(s) if known for each activity that is weighted. (It is recommended this is done as a whole number instead of as a percentage for ease in conditional formatting, formulas, and validation; however, it is up to you on how you present)
Create borders to separate the unique weeks from each other.
Format all Columns and Rows to be legible. Use Column & Row Re-Sizing, Wrap Text, Merge Cells, or Shrink to Fit if necessary.
Part 2: Functions on Schedule Sheet
For each week's summary row, use a SUM function to properly calculate all of the hours estimated for the week's activities. SUM function should include a colon ( : ) not commas ( , ) or addition symbols ( + ) for full credit.
Include a custom format for each Summary of Estimated hours to include the word "hours" after the calculated result.
A4 Part 2 Tutorial 1 of 3
Create a nested IF/THEN function to demonstrate how many days are left until the assignment is due or if it is overdue in the days remaining column for each activity. The final nested IF statement should also show a blank cell if the item has already been completed. (See tutorial if you need help on this function.)
Example showing the results of the IF/THEN Statement
Create a conditional format to highlight if the activity is overdue for each row (do this even if you did not have any overdue items).
Part 3: Grade Calculation Sheet
Add a second worksheet and create a label for the "Points Earned".
Create column headers for the Activity, Grade, Portion of Final Grade, and Weighted Grade Calculation. A "Weeks" column is optional.
Establish links for each graded activity name. (See tutorial if you need help on how to do this and the explanation of why it will help in the future.)
Establish links for each weighted activity point value.
Hand-type the percentage weight each activity holds towards your final grade in the class. Format this figure as a percentage ( % ).
Insert formulas for the Weighted Grade Calculation of each Activity.
Create a conditional format to highlight specific grades (high, low, or both: your choice, but it should apply to all activities' grades).
Example: All Grades ≥ 90 are Green or All Grades ≤ 70 are Red.
Use a SUM function to properly calculate all of the points earned for the month. Include all activities within the SUM function, even if they do not yet have a grade. SUM function should include a colon ( : ) not commas ( , ) or addition symbols ( + ) for full credit.
Format all Columns and Rows to be legible. Use Column & Row Re-Sizing, Wrap Text, Merge Cells, or Shrink to Fit if necessary.
Apply all Worksheet Design Guidelines
Attachment:- LINK TO VIDEO.rar