Term 1: SY16-17
2013 MS Excel Learning Modules
About this class...
Independent Work
Students will work independently with the worksheets for each activity and are expected to ask for assistance as needed. This is a self-paced environment with one to one assistance available. All activities will be posted on the downloads page to be completed outside of class, as needed.
In each activity there is a NEW SKILL introduced. Students should ask for help when this NEW SKILL is unclear.
Step 1: Read Activity Overview
Step 2: Open a Blank New Spreadsheet
Step 3: Input Data from the Activity Sheet
Step 4: Follow Instructions on the Activity Sheet.
Step 5: Complete all NEW SKILLS on the sheet.
Step 6: Save & name each file to your class folder
Introduction to Navigating MS Excel:
Exercise 1: Creating A Schedule
Input data/Data Entry Basics/Formatting Tools
Creating a Schedule (complete data entry from last week).
Formatting a Chart/Table
Borders & Shading
Alignment of Text
Cell Adjustments: length & width – Auto Fit Action
Auto Fill options (Copy & Paste)
Saved & Named the File. (Schedule) – Saved to your ID.
** Ms. Brown will circulate and check off your work.**
Formatting a Chart/Table
Borders & Shading
Alignment of Text
Cell Adjustments: length & width – Auto Fit Action
Auto Fill options (Copy & Paste)
Saved & Named the File. (Schedule) – Saved to your ID.
** Ms. Brown will circulate and check off your work.**
Additional Tips for Formatting Cells in Excel:
View the Video: Excel 2010 Formatting Cells
Term 1 Activities:
All activities must be made in a new excel file/spreadsheet for each activity.
There will be 30 total activities plus the Schedule at the end of Term 1. Each is worth 3.3 points. If the steps are not followed the activity is a ZERO, even if you typed up the data. This is NOT a Data Entry Course.
Activity 1: Social Networking
Skills: Entering Data, Identifying a Cell, Saving a Spreadsheet.
Activity 2 American Top 40
Skills: Merge and Center and using Alignment Tools.
Activity 3 Text Messaging
Skills: Changing Font Size, Bold, Italics, underline & style-enhancements.
Activity 4 LA Lakers
Skills: Change/Adjust Column Widths to fit text and data.
Activity 5 Class Roster
Skills: Format Cells in to a TEXT Format (ASK TEACHER). Sorting Data in ascending order (a-z).
Activity 6 Automobile Research
Skills: Auto fill feature to complete a number sequence in a spreadsheet.
Activity 7 The GAP
Skills: Formatting Cells in to a NUMBER Format (ASK TEACHER). Increase a cells'decimal place using the proper tool.
Activity 8 Class Roster
Skills: Retrieving a saved file. Saving an existing file with a different file name. Changing the Page Orientation from Portrait (Vertical) to Landscape (Horizontal).
Activity 9 Movie Release Dates
Skills: Formatting cells as dates in a spreadsheet (Ask Teacher).
Activity 10 Quiz Scores
Skills: Calculating numbers in a spreadsheet using an addition formula. Using the Auto Fill Feature to complete formulas, display formulas in a spreadsheet.
Activity 11 Quiz Scores2:
Skills: Data Entry: (Average, Max, Min, Count, Sorting data (a-z).
Activity 12 Teen USA Payroll Register
Skills: Using formulas to multiply, add, subtract. Using parentesis properly in a formula. Use a formula that references the answer to another cell's formula. Changing Page Margins.
Activity 13 MLB Standings
Skills: Print/Setup Gridlines, format cells, print grid lines, copy/paste and using formulas.)
Activity 14 San Fran Giants
Skills: Divide Numbers in formulas, using the SUM function.
Activity 15 Best Buy
Skills: Format a row's height in a spreadsheet.
Activity 16 CompUSA:
Skills: Insert Header Footer, Maximize Row Height, Page Layout.
Activity 17 Facebook
Skills: merge cells in a spreadsheet & inserting a page footer.
Activity 18 Colleges
Skills: Format Text direction.
Activity 19 Concerts
Skills: Changing column widths using auto fit function. Formatting cells as Currency ($$) using the proper tool/menu.
Activity 20 Reality TV
Skills: Using the Text Wrap Function within a cell/cells.
Activity 21 Presidents
Skills: Inserting and Resizing ClipArt into a spreadsheet
Activity 22 Original 13 States'
Skills: Inserting Comments into a cell for additional user information.
NOTE: This activity will be used again in Term 2.
Activity 23 Pro Athletes:
Skills: Format cells, to reflect Currency Symbol. US Dollar, Auto fill, input data, date, and sort)
Activity 24 Checkbook Register
Use the Auto Sum Button.
Activity 25 Sales Report
Skills: Review Skills and reinforcement of all skills previously used.
Activity 26 Accounts Payable
Skills: Format Cells to percentages using the proper tool.
Activity 27 LA Lakers 2
Skills: Cut, Copy & Paste Data. Using sets of parenthesis properly in formulas.
Activity 28 Quarterback Statistics
Skills: Change Cell Shading with the proper tool and menu.
Activity 29 M&M's Candy
Skills: Formatting cells as fractions using the proper tool and menu.
Activity 30 NBA Standings
Skills: Inserting and deleting rows
Challenge: Artistic Use of Excel
Checker Board Activity
(Format cells, applying grid lines, copy/paste and using formulas.)
a. Download the instruction guide below.
b. Save the file to your Class Folder on our Networked Drive.
c. Name a sheet tab in your Excel Workbook - Checker Board.
Alternative Lesson:
Grade Book:
Using Average, Creating a Column Chart/Graph (display & interpret data), formatting a chart)
checkerboard_activity.docx | |
File Size: | 340 kb |
File Type: | docx |
DOWNOLADABLE ACTIVITY SHEETS: Term 1
Review: Autofill Tutorial |
Review:
Transpose (rotate) data from rows to columns. . .
Have a table with data you need to alter the data from column to rows or vice versa?
Download and save the worksheet for future reference.
We will use the ABC Donuts worksheet to review this function.
Download and save the worksheet for future reference.
We will use the ABC Donuts worksheet to review this function.
transpose_data_worksheet.docx | |
File Size: | 119 kb |
File Type: | docx |
Alternative Lessons & Challenges...
Calculation Basics & Formulas (Microsoft Excel)
Used with educational licensure from http://www.motiontrainingweb.com
Used with educational licensure from http://www.motiontrainingweb.com