ITA+-+Excel+&+Access

Excel Ribbon Activity

Excel Lesson 1 PPT

__February 2, 2012 __ Begin Anatomy of a Spreadsheet and Guided Practice:Spreadsheet Formatting

__February 3, 2012 __ Complete Guided Practice: Spreadsheet Formatting Begin Independent Practice: Spreadsheet Formatting

*You should email me your Guided Practice Spreadsheet and your Independent Practice Spreadsheet and turn in your 4 page packet that says "Anatomy of a Spreadsheet" on the front.

__February 6, 2012 __ Begin Guided Practice: More Formatting You will need the following file. ..

__February 7, 2012 __ Finish up the Guided Practice: More Formatting packet.


 * You should email me your Guided Practice: More Formatting Spreadsheet and turn in your packet at the end of class.

Begin the "Formula and Basic Function Notes" with me as I go over the information on the SMARTBoard.

__February 8, 2012 __ Yesterday we got through number 7 on the "Formula and Basic Function Notes" Today we will complete them. You will also complete the "Fun with Basic Formulas and Functions". This is due today.

__February 9, 2012 __ Today you will have a substitute. Open the following Word Document for the Lesson 2 Notes. As soon as you open the document you need to do "SAVE AS" and name it as Lesson2NotesYourName and save it either in your folder, your documents or on your flash drive. Then open the PPT and fill in the information requested. You will type in the answers on the document. Save the file when you are done and email it to me at scarlett.tyndall@jonesnc.net.





IF I DO NOT RECEIVE A DOCUMENT FROM YOU THAT IS COMPLETE I WILL GIVE YOU A ZERO.

When you are finished with the Lesson 2 Notes, start the worksheet called "Guided Practice: Use Basic Formulas and Functions". You will need the following spreadsheet file to start this. As soon as you get your paper from the sub, put your name on it. As soon as you open the Excel Spreadsheet, do SAVE AS and save it in your drive with today's date (Feb9) in the file name.

February 13, 2012

Write down the following vocabulary words for an upcoming quiz. Show me your words when you finish for credit.

February 14, 2012

__ February 15, 2012 __ Complete the Wal-Mart Sales Formatting Activity according to the instructions that were passed out at the beginning of class.

Complete the Lesson 3 Guided Notes paper (back and front) and turn in completed before you leave.

Use this Lesson 3 PowerPoint for help.

February 16, 2012



__ February 17, 2012 __

First you will have just a few minutes to study for the vocabulary quiz.

Take the quiz.

If you have not completed the 20 foods spreadsheet from yesterday, finish that AFTER you have turned in your quiz.

Then take these practice quizzes until the end of class. You do not have to record your grade, just do your best and see what you know.

[]

[]l

__February 21, 2012__

Today you received a handout. On the first side you will make a spreadsheet for the Caswell High School Athletic Booster Club.

On the other side is directions for Student Assignment 2 which is also about the Booster Club. You will need this file:

You need to open this file and SAVE AS into your student drive.

__ February 22, 2012 __

Finish yesterday's assignment if you did not complete. If you turned in your paper, they are on my desk - ask the sub for it.

Today's assignments:

Today's New Assignment: You have been given an American Express Black Card (they have no spending limit) to take a trip around the United States to learn more about the country you live in. Use the internet to plan your trip. What states will you visit? Why will you choose those states? You will be traveling by car (or RV, but no planes). You have three weeks to be away on your trip. If you'd like to visit the World's Largest Frying Pan or something like that - it's cool with me, just write, write, write! What historical places would you like to visit? Who would you hope to meet while you were gone?
 * Writing - Use MS Word**

3 pages, double spaced, one inch margins, 12 point font Times New Roman or Arial

**Excel** Lesson 4 Guided Notes Open this file - Put your name in a header and type the answers to the questions. You will use this PPT to complete the Guided Notes

I know this seems like a lot of work, but it isn't bad. You will be in here for 2 hours today because it is Wednesday - use your time wisely!

Email both assignments to tyndallta@gmail.com

__February 23, 2012__

Today you will use these two PPT's to complete the packet that the sub will give you.





TURN IN TO THE SUB - IF YOU ARE FINISHED OR NOT.

After you finish this, type a one page paper, double spaced, Times New Roman, size 12 answering this questions:

Name 3 times when you feel that you have been treated unfairly. Describe each situation clearly and how you think the situation should have been handled.

Email to tyndallta@gmail.com

__ February 28, 2012 __

Today you will use any PPT’s on the wiki and complete the 2 page packet. TURN IN TO THE SUB - IF YOU ARE FINISHED OR NOT.

 After you finish this, type a one page paper, double spaced, Times New Roman, size 12 answering this question:

Do you think that Americans have become overly dependent on technology. Give your reasons of why or why not. Give specific examples or reference news articles to help build your argument.

 Email to tyndallta@gmail.com <span style="font-family: 'Arial','sans-serif';">.

<span style="font-family: 'Arial','sans-serif';">February 29, 2012

<span style="font-family: 'Arial','sans-serif';">March 1, 2012

<span style="font-family: 'Arial','sans-serif';">Open this file in Excel

<span style="font-family: 'Arial','sans-serif'; line-height: 0px; overflow: hidden;">

Use the handout to complete the changes to the spreadsheet.

March 2, 2012

Open this file and then SAVE AS into your drive and name it Lesson6NotesYourName



Use these PPT's to complete the notes





March 7, 2012

After lunch: Open the following document. You should already have the first 10 questions written in your notebooks. If you do not, make SURE you write them down now. For the remainder of the class and for remediation, write the remaining questions in your notes. When you get finished you should have 35 questions total.

Darian __WILL BE__ checking this __TOMORROW__ so make sure you do it and make sure you have it with you tomorrow.



March 8, 2012

Open the Type of Charts document. Save as into your drive. We will complete it together.



March 9, 2012

This is the Chart Components PowerPoint that we used in class to fill in Notes.



March 14, 2012

Complete the crossword puzzle given to you by the sub. Use the PowerPoints that have to do with Charts to complete.

Here is a word bank for the CW.


 * chart || column chart || data marker || data point || data series ||
 * embedded chart || gridline || legend || line chart || pie chart ||
 * plot area || tickmark || x axis || y axis || xy chart ||

After completing that, you will complete items 36-75 of the exam questions. Do these in the same format that you have done the others - write the questions and the four answer choices and highlight the correct answer.



March 15, 2012

Complete the Lesson 5 Assignments. You will find the instructions in this word document





March 16, 2012

Today you will complete the first part of a review guide. The sub will pass this out to you. Complete and make sure your name is on it and turn in at the end of class.

Today you will copy the next set of questions from the exam question bank. You should have 100 questions total written with the correct answers highlighted.



This will be checked on Monday.

If you did not finish the Lesson 5 Project yesterday, you can wait until Monday to finish it when I am here.

March 21, 2012

You will need this file to complete the assignment



March 23, 2012





March 26, 2012



March 28, 2012



April 3, 2012



April 4, 2012

April 6th thru April 15th - HAVE A FABULOUS SPRING BREAK!!!

ALL MIDTERM CORRECTIONS ARE DUE TO ME NO LATER THAN TUESDAY AT 3:05PM!!

April 17th

Use the data in this spreadsheet to complete the Friday_Relay_4 Activity



April 19th - Use this spreadsheet for the Independent Practice Part



April 24, 2012

Lesson 6



April 27, 2012



April 30, 2012

You will need this file to complete the Friday Relay #5 Activity



May 1, 2012



May 4, 2012





May 8, 2012



Part 3 will not load - too big







May 9, 2012







Lesson 5



May 15, 2012 Access PPT's







May 25, 2012

Finish making your own 50 questions Excel exam and email it to me. I also need your Access exam if you have not emailed it to me either. If you have finished with both, go to www.quizlet.com and type in MSITA and look for stuff that says Access or Excel. You can also google "Jennifer Tyndall" + "Spring Creek High School" and find her teacher website - she has a whole bunch of Excel and Access reviews up there.

For remediation - just continue on with studying - if nothing else, study your packets - just do SOMETHING that will help you on the exam.