Introduction to MS Excel
Unit 4 of Comp Apps
Class One Using Ms Excel
Unit Essential Question:
How will understanding the fundamentals (basic skills) of MS Excel help me improve as a student?
Objective for MS Excel:
Students will become familiar with the fundamentals of MS Excel, its tools functions and how it can be used for classroom projects and in business.
Task 1: Video Tutorials & Take Away Sheet
Lesson Title: E1 Take Away Worksheet
Excel Basic Training
Lesson Objective:
Students will become familiar with the fundamentals of MS Excel, its tools functions and how it can be used for classroom projects and in business.
Lesson Overview:
Today we will watch these Excel Training Videos, complete a take away worksheet and then complete a few introductory lessons using MS Excel.
Instructions:
1. Download the Take Away Worksheet (E1) - it is below Instruction #5
Forgot how to save to the excel folder (instructions are below).
2. Save this file to your Excel Folder found in your Comp Apps Folder.
3. After you save the file, Type your name in the header on the document and then read the directions in the header, Re-Save. (CTRL+S).
4. Please be aware the videos are accessible on the worksheet ( the document you just downloaded & saved).
To access a video - just right click the video title and click open hyperlink the link to the video.
5. You will probably need to open the videos using Google Chrome. If you are struggling with viewing a video, cal the teacher over.
e1_take_away_worksheet_excel_basic_training.docx | |
File Size: | 20 kb |
File Type: | docx |
How to Save to Your Excel Folder:
1. Download the E1- Take Away Sheet
2. Open the file, click ENABLE EDITING (if it is there.)
3. Click File,
4. Click Save AS,
5. Click Browse,
6. Click Desktop,
7. Click My Drive,
8. Open the Comp Apps Folder,
9. Open the Excel Folder,
10. SAVE this file to your Excel Folder.
Task 2: Intro to Excel -
Lesson E- 1b - Undergraduate Enrollment
A Pre-Assessment Activity
Job Description:
By editing this spreadsheet you are preparing a database of demographic data for the simulated business named College Concierge.
This information will appear on the company website.
This will assist prospective students in making their decision to attend the University of Learning.
By editing this spreadsheet you are preparing a database of demographic data for the simulated business named College Concierge.
This information will appear on the company website.
This will assist prospective students in making their decision to attend the University of Learning.
Skills Covered in E-1b Undergraduate Enrollment
- Saving a Spreadsheet
- Entering Data in a spreadsheet
- Identifying Cell Addresses ( A1, B3, C7, H11)
- Formatting Cells
Instructions:
1. Click the button below to access the E-1b Undergraduate Assignment.
2. Lesson directions appear on the Spreadsheet Document, there is no paper copy.
1. Click the button below to access the E-1b Undergraduate Assignment.
2. Lesson directions appear on the Spreadsheet Document, there is no paper copy.