Lesson Plan : Lecture Demo Plan
Teacher Name: | Dan Szymczak |
Grade: | College/University |
Subject: | Other |
Topic: | How to track changes in Microsoft Excel- 2016 |
Content: | Find the changes and track them by turning on this feature and list all the changes as a report, also accept or reject changes to customize them. |
Goals: | - Main aim is to track the changes which has been made in the file. - User can identify 'changes' time, location and person who made the changes. - User can accept or reject changes by particular time, location or a person. |
Objectives: | - Turn On the 'Track changes' feature. - Make changes in the file - Track the changes - List all changes in a new sheet - Accept or reject changes - Turn off the 'Track changes' feature. |
Materials: | Microsoft Excel 2016 |
Introduction: | This lesson plan is a detailed description of the activity of tracking the changes in Microsoft Excel- 2016 (The changes can be made in the file which is already created) |
Development: | - Open the excel document in Microsoft Excel- 2016. - Select 'Track Changes' option which is in the 'Review' tab at the top ribbon. - Select 'Highlight changes' from drop down, and mark the check box named 'Track changes while editing' from the dialog box, click 'OK'. - Click 'OK' to confirm in the dialog box. - Now change any cell of the document, a colored border and small triangle on the corner of the changed cell will appear. - The changes can be seen, if mouse pointer is hovered on the changed cell. - If user wants the changes listed, open 'Highlight changes' dialog box again by selecting on 'Track changes' option which is in the 'Review' tab at top of the ribbon. -Mark the checkbox named 'List changes on a new sheet' and click 'OK'. 'History' named worksheet will be prepared with all of the changes listed in that. - To accept or reject changes select 'Accept/Reject changes' from 'Track changes' option which is in the 'Review' tab at top of the ribbon. - Click 'OK', and then user can accept or reject one or all changes from the dialog box. - To turn off the feature, deselect the check box named 'Track changes while editing' in the dialog box, which is appeared by selecting 'Highlight changes' from 'Track changes' option which is in 'Review' tab at the top of the ribbon. |
Practice: | - Make changes after turning the 'Track changes' feature on. - Hover mouse pointer to the changed cell. - List all kind of changes and sort them in ascending/ descending order, - Select different criteria to accept and reject changes. |
Accommodations: | - Make sure that 'Highlight changes on screen' checkbox is marked in 'Highlight changes' dialog box while turning on the track changes. - Make sure which changes should be accepted or rejected. |
Checking For Understanding: | - 'Track changes' is very useful to track the changes in a excel data sheet. - It can be used when many user made the changes in the huge file at different time and different location in the document. |
Closure: | This feature is very helpful when there is a huge data in the file. Anyone can make the changes in the file, so the organization can know when and where the changes are made and who made them. Also, organization can allow whom changes or when or where changes are made, can be accepted or rejected. |
Evaluation: | |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |