Advanced Computer Applications

THUR-FRI 5-17 / 5-18 EXCEL FINAL EXAM REVIEW

Mrs. Bratcher — Thu, 17 May 2012 11:04:50 +0000

Click to complete Excel Final Exam Review

TUE-WED 5-15 / 5-16 WORD FINAL EXAM REVIEW

Mrs. Bratcher — Tue, 15 May 2012 11:03:06 +0000

MONDAY 5-14-12 PPT PRESENTATIONS

Mrs. Bratcher — Mon, 14 May 2012 14:38:40 +0000

1.Be sure you have submitted ALL of your late work. Submit your PPT presentation 1st.
2. We will Play your ppt presentations today while you work on your Word review.

We still have 8 days of school & I expect that you all continue to work hard. The only programs that you should be on are Word, PowerPoint, or Access. The only sites you should be on are Edmodo or mrsbratcher.com.
2. Begin Word Review.

FRIDAY 5-11-12 ACCESS

Mrs. Bratcher — Fri, 11 May 2012 11:09:19 +0000

1. Learn how to use templates in Access. Click for Lesson 3 (add .docx)
2. Learn hot to sort info in a table. CLICK FOR L4 Directions & File (This is a ZIPPED folder. Open it)

Be sure you have submitted your PPT file.

Creating Forms in Access

A form is a screen that allows you to enter, change, and view the data in a database. Think of forms as windows into your data that help users understand and work with that data.

Click here to read through the course on Forms.
Click on the link to practice in Access. Follow the pop up directions. Your finished product should look like the image below.

THURSDAY 5-10-12 ACCESS P1

Mrs. Bratcher — Thu, 10 May 2012 09:54:24 +0000

Review Basic Access Terms
1. File Extension for Access .acddb
2. Field & record
3. Data types

1. Lesson 1 – Creating a Crosstab Queries

Complete Project 1. aproj1
Click for Lesson 1 & 2 Directions & data files. (click open> click copy> paste on your H drive)
SKILL:

Crosstab query- Summarizes data in a very specific way.
You are asked to choose the table & field.
You can choose up to 3 fields for row headings.
You can then summarize the data either by summing a # or counting text.

Complete Project 3 & 4 Creating queries that find unmatched or duplicate records.
Directions for Project 3 Data file for Project 3 ((aproj3))

WEDNESDAY 5-9-12 MAKE UP DAY

Mrs. Bratcher — Wed, 09 May 2012 18:39:30 +0000

1. Finish HOw to.
Add music- accross all slides
Pres should run on its own
inlcude video
Custom styles
Package presentation & zip (right click folder>send to compressed folder)
Submit in Edmodo.

FOR TOMORROW.
REVIEW OR LEARN ACCESS
Keep hitting next to complete the access training.
Test yourself

TUESDAY 5-8-12 LAST DAY FOR PPT FINAL PROJECT

Mrs. Bratcher — Tue, 08 May 2012 11:07:52 +0000

1. Is everything animated on ALL slides
2. Have you added music & made it play accross all slides
3. Have you made each slide advance automatically?
4. Have you added an effect to each picture?
5. Are there pictures in your family tree?
6. Have you inserted a movie that plays automatically?
7. Do you have credits?
8. Have you printed handouts. (office button>publish>handouts)
9. PACKAGE PRESENTATION (Office button>publish>package for CD)
10. Click to take self check quiz

11. Click to take self check quiz for lesson 2

MONDAY 5-7-12 MULTIMEDIA IN PPT

Mrs. Bratcher — Mon, 07 May 2012 12:50:47 +0000

1. Create short picture slide show using ANIMOTO or Movie Maker & insert in PowerPoint as a movie. You can use the animoto you made the first week of class. You will need to insert a picutre on the slide and hyperlink it to the Animoto. I suggest putting it on your last slide.
2. Insert Music in the background & loop presentation.
SHOWS SHOULD BE COMPLETE at the end of class TOMORROW. Automatic F if you are not ready to present on FRIDAY

THURSDAY 5-3-12 PPT PROJ WITH PICS

Mrs. Bratcher — Thu, 03 May 2012 13:28:46 +0000

Pictures are DUE today. Have them open so I can check you off. (-2 letter grades if missing)
Today add all pictures to your show. Pictures should be on every slide.
1. Add an effect to EVERY picture.
2. Add an animaton to EVERY pictures. (They should start with or after previous)
3. We will make our movie maker file NEXT.
4. We will finalize presentations on Tuesday, loop, and mix them down.
5. Presentations will be Wednesday

WEDNESDAY 5-2-12 PPT FINAL PROJ

Mrs. Bratcher — Wed, 02 May 2012 09:27:39 +0000

Open your About me.
It should have transitions, a unique background and font, and a family tree smartart.
YOU NEED PICS BY TOMORROW.
If you have internet, you can save pictures that others have posted of you.

TODAY: Fill in information.

PPT Final Project (Test Score)
-Learn how to insert SmartArt & add Pics to the background
-Add hyperlinks to each Name
-Begin filling in information on each slide
(you will lose 1 letter grade for not having your own custom music that fits the presentation & 2 letter grades for not having your own pictures. You will lose 1 letter grade for not being prepared & having the materials needed on the specified days)

TUESDAY 5-1-12 MAZE

Mrs. Bratcher — Tue, 01 May 2012 12:55:07 +0000

CAA3.5.6

1. 15 min- Move around the room & play other student’s maze game. (let us know if you win!)
2. Submit Maze game in EDMODO

MONDAY 4-30-12 ADD OBSTACLES TO MAZE

Mrs. Bratcher — Mon, 30 Apr 2012 11:05:21 +0000

1. Finish drawing path for your maze.
2. Add obstacles. (Use custom animation)
3. Add a start & finish shape.
Be creative!
Be sure you have turned in your habits & timer
Caa3.2.1

FRIDAY 4-27-12 ACTION BUTTONS “MAZE”

Mrs. Bratcher — Fri, 27 Apr 2012 09:45:49 +0000

Submit your timer and habits file in Edmodo
Save slide as a .jpg (office button>save as> file type> .jpg
Create a Maze using PowerPoint. Put your maze & timer in the same slide show. Submit in Edmodo

THURSDAY 4-26-12 PPT LESSON 2 Habits File

Mrs. Bratcher — Thu, 26 Apr 2012 08:31:46 +0000

1. Be sure you have finished and submitted your review Game. We will play the game as a class tomorrow.
2. Be sure you have finished pg 21 (or 25) Vocab 1-5 & 7-10. Answers go as a comment in turn in spot on Edmodo.
2. Click for online version of PPT Book
Complete PPT Lesson 2 Packet. PG 31-39

Click for data file. (Habits) (click on Lesson 2, Open , Open, )

WEDNESDAY 4-25-12 PPT pg 35-43

Mrs. Bratcher — Wed, 25 Apr 2012 09:38:39 +0000

1. Complete ppt Vocab Sheet PG 21. Type answers in Edmodo Vocab turn in spot.
2. Learn how to use installed templates. Using terms from Lesson 1 & 2. Create a quiz. You can use just slide 8, or a combination of both.

Steps: Office Button> New>Installed Templates> Quiz Show

For Tomorrow:

Click for online version of PPT Book
Complete PPT Lesson 2 Packet. PG 35-43
Click for data file. (Habits)

TUESDAY 4-24-12 PPT L1

Mrs. Bratcher — Tue, 24 Apr 2012 09:56:50 +0000

Click to open and save the Garden2 file.
Learn basic skills in PowerPoint
Click for ppt L1 instructions
Complete pg 21 Vocab Review & turn in at the end of the period
Click here for help with the vocab sheet

MONDAY 4-23-12 Timers in PPT

Mrs. Bratcher — Mon, 23 Apr 2012 09:21:08 +0000

Finish Excel Review

1. Practice Timing Create Timers

FRIDAY 4-20-12 Test over filters

Mrs. Bratcher — Fri, 20 Apr 2012 09:03:16 +0000

Click to vote for the Lady A poster created by FC’s Erika Hunter.

Go over data validation, what if, conditional formatting
1. Open Grade Sheet. (be sure you have a graph, conditional formatting, & a what if analysis)
2. Turn in Jobs, Budget, & Zoo & Excel Review
3. Test over filters, Data Validation, Tables, Merge & center, conditional formatting, SUBMIT IN EDMODO

Skills: Saving ppt as a jpg, order, & effects
We are creating a collage in PPT and then saving it as a JPG. We will add this to our Portfolio as well.
1. Create a Wordle – Use words that describe you. Print screen the wordle then add to your ppt
2. Edit an image of yourself using picnik, then add to ppt
3. Add more images to the ppt to create a collage about yourself. Save the slide as a JPG and add to your Weebly Site

THURSDAY 4-19-12 Excel Review

Mrs. Bratcher — Thu, 19 Apr 2012 09:57:26 +0000

Complete pages 30-36 (What if analysis & scenario summary) Open your blues file to complete.

Excel Review
There will be a test Tuesday that closely resembles this review file. If you do not understand something, be sure to get my help today.
CAA3.3.15

WEDNESDAY 4-18-12 Zoo & Grade Sheet

Mrs. Bratcher — Wed, 18 Apr 2012 12:55:50 +0000

Study for Quiz: Lesson 1 Self Check Quiz & Lesson1 Interactive Review

1.Open your grade sheet & have excel circle all grades that are below a 60%. If you do not have grades below a 60% then choose 70% or higher.
2. Name a cell range: on your grade sheet name the column of your points & the column of total points (See pg 180 for help)
3. Use the data validation to create a drop down list for the programs used on the advanced computer applications page.
4.Excel Quiz pg 31 #’s9,10, &11 click for Zoo Data File
Submit Jobs, Budget, & Blues in EDMODO
Review tomorrow & Test on Friday over Excel

TUESDAY 4-17-12 PRACTICE IT & OYO (Jobs & Budget)

Mrs. Bratcher — Tue, 17 Apr 2012 09:54:55 +0000

1.Complete pg 20 Review Questions & Vocab. Put in Red tray with your name.
2. Complete practice it activities & OYO on pages 21-25.
3. Click for “Jobs & Budget Data File”
4. Learn What If Analysis & Scenario Summary
5.Perform a What If analysis on your grade sheet. One analysis should be for your best possible grade on a certain assignment & the other should be for the lowest. (pg 182-185 for help)
6. Create a Scenario summary.
CAA3.3.15

MONDAY 4-16-12 Lesson 1-5 through 1-12

Mrs. Bratcher — Mon, 16 Apr 2012 14:31:58 +0000

1. Open your blues file.
2.Open the online book.
We will complete lessons 1-5 through 1-12 today.
Data Validation, Naming a Range, Evaluating a formula

FRIDAY 4-13-12 Lesson 1-1 /1-5

Mrs. Bratcher — Fri, 13 Apr 2012 12:40:37 +0000

1. Open Grade Sheet & finish. Submit to Edmodo
2.Submit your digital story & storyboard.
3. Click for online book (pg’s 9-22 or Lesson 1-1 – 1-12)
4. Click for “Blue’s Data File”

THURSDAY 4-12-12 Grade Sheet

Mrs. Bratcher — Wed, 11 Apr 2012 13:01:15 +0000

Open your Excel Grade Sheet. Finish adding data. Learn how to do the steps listed below.

1. Apply Filters (click in the title row> click data>filter
2.Apply conditional formatting to grade sheet. (any grade below a D, highlight)
3. Format your data using shading & borders.
4. Create a chart that displays your grades
5. Enter all classes and overall grades on sheet tab 1
6. rename your sheet tabs
7. Hyperlink each teacher’s class to their name on sheet 1

Excel Self-Check Lesson 1
Complete Lesson 1 Interactive Review

caa3.2

WEDNESDAY 4-11-12 Grade Sheet in Excel

Mrs. Bratcher — Tue, 10 Apr 2012 11:01:14 +0000

caa3.2

Create a Grade Sheet in Excel (SKILLS: Conditional Formatting, IF function, hyperlink function, filters, & graphs.
CLICK FOR GRADE SHEET INSTRUCTIONS

MON-TUE 4-10/4-11 Templates in Excel

Mrs. Bratcher — Mon, 09 Apr 2012 11:30:50 +0000

1. First 5 min. Finish up movie. You must submit the storyboard & the .wmv file. Be sure you have music, titles, transitions, and credits.

2. Finish ALL Mail Merge assignments. (Envelope, invitation, certificate, letter(announce file), & envelope)

MAIL MERGE REVIEW FROM FRIDAY
Online Book pg 31(I also printed the pages out for you)
1. Mail Merge click for announce data file & save office address list
2. Mail Merge Envelopes - Online Book pg 33 & 34

3.Intro to Excel: Using templates in excel. Go to Microsoft’s web site and search for different templates. There are templates for almost everything. Calendars, meal plans, exercise/weight lifting, homework, grades, party planning, music, budgets.

Spend at least 15 minutes searching for different templates. Choose your three favorite, or most useful for you. Fill information in one of them, save it and submit in Edmodo. ALL templates must be in Excel

FRIDAY 4-6-12 MAIL MERGE

bratcher — Fri, 06 Apr 2012 15:20:58 +0000

First 5 min: Finish up Movie file. Submit Storyboard & movie. (MUST BE A .WMV)

1. Create a Mail Merge of an invitaton & envelope.
Assume you are having a party and would like to send out Personalized invitations.
- Create the list using at least 6 contacts.
- Design your invitation using an image & a matching color scheme.
-Insert Mail Merge fields & finish the merge. SAVE AS mymerge

2. Create a Certificate of Achievement and use mail merge to personalize each one.

MAIL MERGE REVIEW
Online Book pg 31(I also printed the pages out for you)
1. Mail Merge click for announce data file & save office address list
2. Mail Merge Envelopes - Online Book pg 33 & 34

THURSDAY 4-05-12 MAIL MERGE REVIEW

Mrs. Bratcher — Thu, 05 Apr 2012 11:11:25 +0000

1. Be sure to submit your Movie file. It MUST have music. Ask me for help if you cannot download a music file. Mix down. The file you submit MUST be a .wmv.
2. MAIL MERGE ON YOUR OWN
1. Create a Mail Merge of an invitaton & envelope.
Assume you are having a party and would like to send out Personalized invitations.
- Create the list using at least 6 contacts.
- Design your invitation using an image & a matching color scheme.
-Insert Mail Merge fields & finish the merge. SAVE AS mymerge

2. Create a Certificate of Achievement and use mail merge to personalize each one.

FOR TOMORROW: MAIL MERGE REVIEW
Online Book pg 31(I also printed the pages out for you)
1. Mail Merge click for announce data file & save office address list
2. Mail Merge Envelopes - Online Book pg 33 & 34

WEDNESDAY 4-04-12 DIGITAL STORY MIX DOWN

Mrs. Bratcher — Wed, 04 Apr 2012 11:21:47 +0000

FINISH & SUBMIT YOUR MOVIE.
Your Movie should be finished. It should have sound. If you did not bring in sound do so by Friday. (See me if you have any concerns) Be sure to complete step three > Mixing down your movie to a .wmv file that can be played on all computers.

Mon-Tue 4-11 & 4-12 Create Movie

Mrs. Bratcher — Mon, 02 Apr 2012 15:07:16 +0000

REMINDER: If you did not include music, you need to do so by Friday. Without music or sound, you will lose 2 letter grades. You can find a music video on Youtube and use Zamzar to download the Mp3 version of it.

1. Open Movie Maker
2. Import Pictures.
3. Put them in order (It should tell a story or inform us about something)
4. Import Music (It should be school appropriate & fit the story)
5. Add titles (We should be able to easily read them. They should inform us about the picture)
6. Add effects & transitions (Keep it simple. Too many effects are distracting)
7. Mix down movie (Save to computer as a .wmv)
8. Watch Movies as a class.(Wednesday)

FRIDAY 3-23-12 DIGITAL STORY

Mrs. Bratcher — Fri, 23 Mar 2012 09:07:37 +0000

1. Learn how to create digital stories using Windows Movie Maker
2. Create a folder on your H drive called “digital story”.
3. Todays goals:Come up with an idea, create a storyboard, find images.
CLICK FOR DIGITAL STORY DIRECTIONS

In PowerPoint or Word use a table or text boxes to create a layout for a storyboard. Paste thumbnails of your images in the order you want them to go in. Place text where you want it to go using wordart or a text box.

THURSDAY 3-22-12 PROJECTS & RESUME

Mrs. Bratcher — Thu, 22 Mar 2012 11:35:01 +0000

Open your Yola OR Weebly site.
1. Finish your Project page. (5 projects with titles, detailed descriptions, Screen shots, and a link to the actual file)
2. Open Word. Create a resume. You may use the templates provided.
Resume Tips for High School Students.

3. We are going to create a page on our portfolio about our professional goals. Where do you want to go to college?
What career do you want to pursue?
What are the steps you are going to take to obtain your goal.

WEDNESDAY 3-21-12 DIGITAL PORTFOLIOS

Mrs. Bratcher — Wed, 21 Mar 2012 11:15:25 +0000

Digital Portfolios Day 2
Open your Yola site. www.yola.com
Your main page should be complete.
1. Add a new page titled about me. Include pictures and hobbies. Do not include contact info.
2. Include a third page titled portfolio. We will add at least 5 pieces of work. Each item added must have a description of what the project was, how it was created, as well as what you learned.