PRINIT |
| Unit: EXCEL |
| Assigned/ Completion Date |
Assignment |
File Name
(Use the naming format yyyymmdd File Name
Your Name) |
Teacher Notes |
1.17
1.24 |
Keyboarding Online Lesson 19
Keyboarding Online Lesson 20 |
|
|
| 1.26 |
Part 1 - Excel Basics
Task 1--Open Spreadsheet, Identify Worksheet Parts, Save Workbook with
Different Name
Task 2-Move within Spreadsheet, Insert Column, Enter Data
Task 3-Insert Row
Task 4-Change Data, Verify Data
Task 5-Preview, Print |
TimeSpent |
|
| 1.27 |
Task 6-Create New File
Review: Application 1
Application 2 |
My Grades
Accident Report
Home Downpayment |
|
| 1.28 |
Application 3
Application 4 |
Budget Results
Game Statistics |
|
| 1.31 |
Keyboarding Online Lesson 21
Part 1 Excel Basics Test
Part 2 - Spreadsheet Appearance
Task 1-Change Font, change Font Size
Task 2-Change Column Width, Change Row Height
Task 3-Format Numbers, Format Curency
Task 4-Bold, Italics, Underline |
Fruit Stand |
|
| 2.1 |
Task 5-Borders, Fill Color, Text Color
Task 6 Wrapping, Rotating, Indenting, Aligning
Review: Application 1
Application 2 |
Maple Syrup Production
Mesa Cafes |
|
| 2.2 |
Application 3
Application 4
Application 5 |
Off Road Bikes
Beet Red Bookstore
Limpia Creek Football |
|
| 2.3 |
Application 6
Application 7 |
Antex
Crop Summaries |
|
| 2.4 |
Part 2 - Spreadsheet Appearance Test
Part 3 - Organizing a Spreadsheet
Task 1 Cut, Paste, and Drag to Move Data
Task 2 Copy, Paste, and Drag to Copy Data
Task 3 Fill Down
Task 4 Replace, Delete Data |
MWSI |
|
| 2.7 |
Keyboarding Online Lesson 22
Task 5 Fill Right
Task 6 AutoFill
Review Application 1
Application 2 |
Garmin
Banner Travel
Jay's Assets
Office Supply Inventory |
|
| 2.8 |
Application 3
Application 4 |
Burro Path Links
Calorie Counter |
|
| 2.9 |
Part 3 - Organizing a Spreadsheet Test
Part 4 - Calculation
Task1 Enter Formulas with Relative Cell References
Task 2 Delayed Calculation
Task 3 Order of Evaluation, Modify a Formula with the Formula Bar
Task 4 Enter Formulas with Absolute Cell References |
Payroll
Drama Attendance
Your Time |
|
| 2.10 |
Review: Application 1
Application 2
Application 3
Application 4 |
Census
Football Score
Apartment Expenses
Interest Charge |
|
| 2.11 |
Keyboarding Online Optional Timing 9 Writing on Clay Tablets
Application 5
Application 6 |
Currency Conversion
Tax Estimation |
Make sure you have a recorded Grade for Keyboarding before exiting. |
| 2.14 |
Keyboarding Online Lesson 23
Part 4 - Calculation Test
Create a Valentine Card in PrintShop, It must contain a poetic verse. |
|
Valentine should be displayed on the wall on your side of the room. |
| 2.15 |
Part 5 - Function Formulas
Task 1 Enter a SUM Function Formula
Task 2 Enter Date and Time Function Formulas
Task 3 Enter Statistical Function Formulas, Drag to Enter a Range
Task 4 Enter Logical Function Formulas |
Fundraiser
Class Grades |
|
| .216 |
TAsk 5 Enter Financial Function Formulas
Review: Application 1
Application 2
Application 3
Application 4 |
Interest Payment
Factory Production
Boreal
Cross Country
Bring My Jacket |
|
| 2.17 |
Part 5 - Function Formulas Test
Part 6 - Charts
Task 1 Create a Pie Chart
Task 2 Create, Modify a Column Chart
Task 3 Create, Modify a Line Chart
Task 4 Create a Stacked Column Chart |
Survey Results
School Dropouts
Batting Average
Product Mix |
|
| 2.18 |
Review Application 1
Application 2
Application 3
Application 4 |
Personal Expenditures
Schedule
Violent Crime
Pay Increases |
|
| 2.22 |
Keyboarding Online Lesson 24
Application 5
Application 6
Application 7 |
Inventory Change
Teenage Pregnancy
Grade Inflation |
|
| 2.23 |
Part 6 - Charts Test
Job 1
Job 2 |
Funds
Fund Link |
|
| 2.24 |
Job 3
Job 4 |
Table Stats
Fund Link2 |
|
| |
|
|
|
