w11.word_lesson_2__1_.pdf | |
File Size: | 182 kb |
File Type: |
SpreadsheetsDay 1: Intro to ExcelToday's Goals:
PowerPoint is linked below
Study Guide is linked below
Excel Window is linked below
Quizlets are linked belowDay 2: Excel Scavenger Hunt , Keyboarding LogToday's Goals:
Scavenger Word Doc is linked below
Quizlets are linked belowDay 3: Finish Scavenger Hunt, quizlets, keyboarding logToday's Goals:
Excel Exercise 6, quizlets, keyboarding log
Instructions are linked below
Excel Exercise 6
Excel Exercise 7
Excel Window Quiz & Excel Exercise 8
Excel Window Quiz
|
excel_ex._9_instructions_countries_1_updated.doc | |
File Size: | 125 kb |
File Type: | doc |
exercise_9_population.area.xlsx | |
File Size: | 8 kb |
File Type: | xlsx |
exercise_9_finished_corrected.xlsx | |
File Size: | 29 kb |
File Type: | xlsx |
Exercise 9 & 10
- Finish Excel Exercise 9.
- Do the keyboarding drill linked below.
- Do three timed writings and save them in my folder.
- Begin Exercise 10. We will do the chart section tomorrow.
lesson_4_keyboarding.docx | |
File Size: | 259 kb |
File Type: | docx |
s10.excel_ex._10_instructions.doc | |
File Size: | 138 kb |
File Type: | doc |
Exercise 10 continued...
- Finish Excel Exercise 10.
- Next, do makeup work.
Exercise 11
1. Do Exercise 11 today.
Take the two quizlets linked below.
Take the two quizlets linked below.
exercise_11_countries_chart_finished.xlsx | |
File Size: | 240 kb |
File Type: | xlsx |
11_and_12_new_instructions.doc | |
File Size: | 35 kb |
File Type: | doc |
Exercise 12!
Excel Unit Test on Thursday!
1. Do Exercise 12 today. The instructions are linked below and are on the same sheet as Exercise 11.
2. Do the keyboarding drill linked below.
3. Do missing exercises or other makeup work.
2. Do the keyboarding drill linked below.
3. Do missing exercises or other makeup work.
___s11.excel_ex._11___12_instructions.doc | |
File Size: | 35 kb |
File Type: | doc |
lesson_4_page_14_keyboarding.docx | |
File Size: | 534 kb |
File Type: | docx |
Excel Charts & Functions
- We will begin today with a powerpoint on Excel charts and functions.
- Next, I will go over the test review. Reminder: test is on Thursday.
- Take the three quizlets. Take the new one until you get a 100%
- If time permits we will begin a virus research assignment.
excel_charts.pptx | |
File Size: | 183 kb |
File Type: | pptx |
test_review_for_excel-1-2.xlsx | |
File Size: | 25 kb |
File Type: | xlsx |
Excel Test Review
- Verbal Quiz will be first.
- Take the three quizlets linked below.
- Continue work on the virus research powerpoint assignment.
test_review_for_excel-1.xlsx | |
File Size: | 19 kb |
File Type: | xlsx |
Begin the bibliography assignment. The link is below. Save it in Mrs. Jennings' folder.
how_to_do_a_bibliography_assignment__updated_9-16.docx | |
File Size: | 16 kb |
File Type: | docx |
bibliography_assignment_part_2.docx | |
File Size: | 13 kb |
File Type: | docx |
Excel Test Today!
There will be three parts to the test today:
- Part 1: Verbal Test
- Part 2: Create an excel spreadsheet. Use the two blue sky links below. One has the data and the other the instructions.
- Part 3: Click the last link to view the multiple choice questions. Get your bubble sheet out of your folder and a marker from the table. Clean it off after scanning it into the computer. File when you are done.
- Mrs. Jennings will give a verbal test first.
- Next, open the link below. Write your answers on a paper and turn it in.
final_excel_test.xlsx | |
File Size: | 22 kb |
File Type: | xlsx |
3. Open the two links below. One is the spreadsheet that you will need to make changes to. The other are the instructions of what to do to the spreadsheet.
excel_test_blue_sky.xls | |
File Size: | 22 kb |
File Type: | xls |
____excel_test_blue_sky_instructions_updated_9.29.doc | |
File Size: | 28 kb |
File Type: | doc |
4. Open the link below and put your answers on a bubble sheet. Come scan your answers when you are finished.
Blue Sky answers are below for TEACHER ONLY!
____excel_test_blue_sky_answers.xls | |
File Size: | 52 kb |
File Type: | xls |
unit_test_spreadsheettest_final.pdf | |
File Size: | 45 kb |
File Type: |
Old Exercise 9
s9.excel_ex._9_instructions.doc | |
File Size: | 141 kb |
File Type: | doc |
s4.excel_ex._1-4_instructions.doc | |
File Size: | 460 kb |
File Type: | doc |
Databases, Viruses & Bibliography
Day 1: Getting acquainted with Access
Open the link below and watch the first two videos *units 1-2".
Take the database quizlet until you get 100%.
Open the PowerPoint and the Sample Access file linked below and follow the instructions as we watch the videos as a class.
access2016_sampledatabase.accdb | |
File Size: | 1376 kb |
File Type: | accdb |
access_assignment_to_slide_18_revised_mar_22_2017__2_.pptx | |
File Size: | 79 kb |
File Type: | pptx |
2_access_powerpoint_queries.pptx | |
File Size: | 49 kb |
File Type: | pptx |
test__databases___quizlet.pdf | |
File Size: | 69 kb |
File Type: |
- DATABASE TEST!
- Open the access file linked below.
- Open the Powerpoint instructions linked below and follow the instructions.
- Take the bubble test linked below.
- Open the access file linked below.
- When you finish the test, do typingclub.com to lesson 53. Take a picture and save it in my folder.
- COMMON WORD COMMANDS as time permits!
final_test__databases___quizlet.pdf | |
File Size: | 70 kb |
File Type: |
final_database_test_instructions.pptx | |
File Size: | 1077 kb |
File Type: | pptx |
Bibliography continued & Virus PowerPoint
DO NOT USE GOOGLE AS A SOURCE! Click a link to a website to find your ansers!
- Open your bibliography assignment part 2 and do it.
- Begin the virus research assignment.
- You MUST HAVE AT LEAST THREE DIFFERENT SOURCES. You cannot use Google for any of them.
sample_of_bibliography__1_.png | |
File Size: | 18 kb |
File Type: | png |
w7.virus_research_assignment.docx | |
File Size: | 13 kb |
File Type: | docx |
Virus Powerpoint
- Every slide must have a different transition
- Photo editing:
- Add a frame to every picture
- Do an artistic effect to every picture
- Change the color of one picture
- Put a filled-in border on one Word Art Title. Put a thick, dashed border around it.
- Rearrange slides in reverse order to learn about slide views.
- Create a Bibliography page for your powerpoint. You MUST have at LEAST one line that has a hanging indent.
capture.png | |
File Size: | 67 kb |
File Type: | png |
Grading as a class - virus powerpoints
1. Open your powerpoints and trade seats with someone in the class.
2..Mrs. Jennings will guide you through grading your classmates presentation.
3. Take the Virus Quizlet until you get 100%.
Explanation of points:
Entrances & Exits: students need to click the animations tab and open up the animation pane by clicking the button in the advanced animation group. There should be at least 3 green stars and 3 red stars to get full points. Partial points may be given, 1 for each entrance and exit.
Transition: means that the slides have an effect of some kind when they change from one side to the next. Each effect may be different.
Links: will only work if you are watching the powerpoint - not in creation mode.
2..Mrs. Jennings will guide you through grading your classmates presentation.
3. Take the Virus Quizlet until you get 100%.
Explanation of points:
Entrances & Exits: students need to click the animations tab and open up the animation pane by clicking the button in the advanced animation group. There should be at least 3 green stars and 3 red stars to get full points. Partial points may be given, 1 for each entrance and exit.
Transition: means that the slides have an effect of some kind when they change from one side to the next. Each effect may be different.
Links: will only work if you are watching the powerpoint - not in creation mode.
Create a bubble quiz for the virus quiz.
Teacher Stuff!
w7.virus_research_grading_sheet__1__updated_mar_2017.docx | |
File Size: | 27 kb |
File Type: | docx |
w7.virus_research_grading_sheet__1_.docx | |
File Size: | 27 kb |
File Type: | docx |
w7.plagiarism__and_bibliography_quiz.docx | |
File Size: | 17 kb |
File Type: | docx |
Quizlet review and keyboarding day!
- Finish your Powerpoint and turn it in.
- Take each of the quizlets linked below as a review for yourself. DO NOT SAVE THEM IN MRS. JENNINGS FOLDER.
- Click the link below and take the real quiz that you will be graded on. It will be a combination of the quizlets you practiced. Don't use a bubble sheet today, just write down the answers on paper. We will fill in the bubbles and scan them on Monday.
- Do the keyboarding drill linked below.
- Catch up on missing work.
quiz_combinedemailspreadsheetquiz.pdf | |
File Size: | 53 kb |
File Type: |
lesson_4_page_15_keyboarding.docx | |
File Size: | 501 kb |
File Type: | docx |
Word, Folders, & Viruses Assignment Today!
Mrs. Jennings will pass out a handout for today's assignment. There is no link.
w8.word.virus.folders__1_.docx | |
File Size: | 26 kb |
File Type: | docx |
Spreadsheets
grade sheets &
other useful stuff
s2.demo_for_ppoint.xlsx | |
File Size: | 18 kb |
File Type: | xlsx |
s1._study_guide_answers.doc | |
File Size: | 30 kb |
File Type: | doc |
s2.excel_window_worksheet_answers.doc | |
File Size: | 334 kb |
File Type: | doc |
s3.format_cells_scavenger_hunt.doc | |
File Size: | 38 kb |
File Type: | doc |
s3.scavenger__excel_sheet_answers.xlsx | |
File Size: | 10 kb |
File Type: | xlsx |
s3.scavenger_worksheet_answers.doc | |
File Size: | 40 kb |
File Type: | doc |
s6.grading_guide_for_exercise_6.docx | |
File Size: | 12 kb |
File Type: | docx |
s6.ex_6_answers.xlsx | |
File Size: | 13 kb |
File Type: | xlsx |
s7.exercise_7_main_answers.xlsx | |
File Size: | 13 kb |
File Type: | xlsx |
s7.exercise_7_grading_sheet.docx | |
File Size: | 19 kb |
File Type: | docx |
s8.exercise_8_grading_sheet.docx | |
File Size: | 19 kb |
File Type: | docx |
s8._ex_8_answers.xlsx | |
File Size: | 23 kb |
File Type: | xlsx |
s9.exercise_9_grading_sheet.docx | |
File Size: | 20 kb |
File Type: | docx |
s9.ex_9_answers.xlsx | |
File Size: | 131 kb |
File Type: | xlsx |
s10.exercise_10_grading_sheet.docx | |
File Size: | 20 kb |
File Type: | docx |
s.10.ex_10_answers_ticket.xlsx | |
File Size: | 19 kb |
File Type: | xlsx |
excel_charts.pptx | |
File Size: | 183 kb |
File Type: | pptx |
s11._ex_11_sample_for_demo.xlsx | |
File Size: | 10 kb |
File Type: | xlsx |
s11.exercise_11_grading_sheet.docx | |
File Size: | 19 kb |
File Type: | docx |
s11.ex_11_answers.xlsx | |
File Size: | 37 kb |
File Type: | xlsx |
___s11.excel_ex._11___12_instructions.doc | |
File Size: | 35 kb |
File Type: | doc |
excel_verbal_quiz_in_writing_for_absent_students.docx | |
File Size: | 12 kb |
File Type: | docx |
test_review_for_excel-1.xlsx | |
File Size: | 19 kb |
File Type: | xlsx |
test_review_for_excel-1-2.xlsx | |
File Size: | 25 kb |
File Type: | xlsx |
Word grade sheets &
other useful stuff
w14.state_statistics-answers.doc | |
File Size: | 31 kb |
File Type: | doc |
w13.compucity_answers_activity_3.docx | |
File Size: | 24 kb |
File Type: | docx |
9.memos_answers.docx | |
File Size: | 16 kb |
File Type: | docx |
10.memo_grading_sheet.docx | |
File Size: | 28 kb |
File Type: | docx |
18.business_letter_assignments_and_grade_sheet-1.doc | |
File Size: | 68 kb |
File Type: | doc |
Word
Common Word Commands
- Today Mrs. Jennings will guide you through the assignments.
- Fill out the worksheet as you go. It is the first link in the list below. The answers will be found on the pages linked below it.
- Follow the instructions in red on page 1.
- Open Page 2, follow the instructions in red, and copy and paste it to the bottom of page 1.
- Open Page 3 and follow the instructions.\
- On the Mini Toolbar, use the following buttons there: font style, font size, bold, italics, underline, shading, text color, bullets, and numbering. Just select a few words and change them.
- copy and paste Page 3 to the bottom of Page 2.
- All three pages should now be inside one Word document.
- Save it in your own folder.
common_word_commands_find_the_answer_sheet.docx | |
File Size: | 15 kb |
File Type: | docx |
w1._page_1_word_commands.doc | |
File Size: | 30 kb |
File Type: | doc |
w2._page_2_word_commands_-_copy.doc | |
File Size: | 38 kb |
File Type: | doc |
w3._page_3_word_commands_-_copy.doc | |
File Size: | 31 kb |
File Type: | doc |
Common Word Commands continued...
- 1. We will continue Common Word commands today with pages 4 and 5.
- Remember to fill out your worksheet as you go.
- Open Page 4 and follow the instructions below:
- Copy "Emery School District is Great" and paste it 3 times underneath where the others are.
- Open the clipboard (Home tab, clipboard dialog box launcher).
- Copy three different groups of text and notice that it goes to the clipboard.
- Use the snipping tool to take a picture of your clipboard items and save them inside the clipboard folder.
- Go to the view tab and click the split screen button. Scroll the top window clear to the top of the document and go to the bottom window and scroll to the bottom of the page.
- Click in the very bottom of the document and paste all three paste items on the clipboard there by clicking on each of them.
- Take a picture and save it in the split screen folder.
- Open at least 3 Word documents. After opening the last one and enable editing, click the view tab and "arrange all" button.
- Take a picture and save it in the "arrange all" folder.
- Close all documents except for two. BE SURE TO SAVE YOURS BEFORE YOU ACCIDENTALLY CLOSE IT.
- From the view tab, click the synchronized scrolling button.
- Take a picture and save it in the "synchronized scrolling" folder.
- Copy and paste page 4 to the bottom of page 3.
- Open the link to page 5 and use it to finish filling out the worksheet and turn it in.
w4._page_4_word_commands_-_copy.doc | |
File Size: | 38 kb |
File Type: | doc |
w5._page_5_word_commands_-_copy.doc | |
File Size: | 30 kb |
File Type: | doc |
w6.common_word_command_answers_-_copy.docx | |
File Size: | 18 kb |
File Type: | docx |
Begin Word Lesson 1
- Today we will grade the "Common Word Commands" worksheet that you turned in yesterday.
- Next do the keyboarding drill.
- Take the Common Word Commands Quizlet until you get a 100%. Real quiz on it tomorrow!
- Finally, wait for Mrs. Jennings instructions for a worksheet she will hand out.
lesson_6_pg_19.pdf | |
File Size: | 423 kb |
File Type: |
w9.word_lesson_1__2_.pdf | |
File Size: | 321 kb |
File Type: |
Finish Word Lesson 1 & Start 2
- Practice Common Word Commands quizlet then take the bubble quiz.
- Finish Word Lesson 1 worksheet with your partner.
- We will grade the worksheet.
- Take the Bubble Quiz if you are missing it.
- We will do Word Lesson 2 today in partners.
Create a bubble quiz.
w11.word_lesson_2__1_.pdf | |
File Size: | 182 kb |
File Type: |
Finish Word Lesson 2
- Finish Word Lesson 2 with your partners so we can grade them as a class.
- Take the virus quizlet linked below until you feel like you can get a 100%. Then take the bubble quiz on it
test__viruses___quizlet.pdf | |
File Size: | 63 kb |
File Type: |
Share/Teach
- Marlene will ask you to come up in teams and teach the class. After each team demonstrates, do the same thing to your Word document inside the Word document you started on Tuesday.
- If there is not enough time for every group, they can take a turn tomorrow.
- If all teams finish, do makeup work.
Word, fill -in form
- Finish team teaching if not all groups had a chance yesterday.
- Open the link below and find the answers filling in the form as you go.
- Mrs. Jennings will instruct you on your Google Docs assignment that you will do on Friday.
word._what_you_need_to_know.docx | |
File Size: | 27 kb |
File Type: | docx |
Google Docs
- Take the combined Virus and Common Word Commands bubble quiz
- Begin Google Docs assignment.
Continue the Google Docs Assignment
Word Activity 1
- Minutes as needed to finish google docs then we will create the fill-in form
- Do Word Activity 1 "Race Track". You will need to open both links below.
w13.working_with_word_activities_1_to_3.doc | |
File Size: | 73 kb |
File Type: | doc |
w12.race_track.doc | |
File Size: | 35 kb |
File Type: | doc |
Word Activities 2-3
w14.state_statistics.doc | |
File Size: | 29 kb |
File Type: | doc |
Word Activities 4-5
w14.more_working_with_word_activities_4_to_6__1_.doc | |
File Size: | 68 kb |
File Type: | doc |
Word Activity 6
Today we will:
- Do Word Activity . Instructions are in yesterday's link.
- Lesson 6 Keyboarding drill
- Do 3 timed writings
lesson_6_pg_20.pdf | |
File Size: | 281 kb |
File Type: |
Memos
Today we begin memos. Fill out the listening guide as you go through the PowerPoint.
Next, we will begin the memo assignments 1-3.
Next, we will begin the memo assignments 1-3.
7.memorandum_listening_guide.doc | |
File Size: | 75 kb |
File Type: | doc |
8.memos_presentation.pptx | |
File Size: | 106 kb |
File Type: | pptx |
10.memo_grading_sheet.docx | |
File Size: | 28 kb |
File Type: | docx |
7.merged_memos_1_to_3.docx | |
File Size: | 16 kb |
File Type: | docx |
Finish Memos
If time permits begin Begin Letters
Marlene will be in charge today.
- Finish up your memos from Friday.
- Go through the Powerpoint linked below and answer the questions on the handout.
7.merged_memos_1_to_3.docx | |
File Size: | 16 kb |
File Type: | docx |
15.letter_formatting.pptx | |
File Size: | 170 kb |
File Type: | pptx |
17.spacing_and_parts_of_a_letter.doc | |
File Size: | 69 kb |
File Type: | doc |
16.letter_formatting.doc | |
File Size: | 24 kb |
File Type: | doc |
Quizlet & keyboarding
- Take the quizlets until you get an A, then take the bubble quiz on it. Put your bubble quiz in your folder and we will scan it in tomorrow. You can use your worksheets.
- Do the Keyboarding Drill - someone please create a folder
- Do 3 timed writings - someone please create a folder
- Finish your memos or do makeup work.
test__combo_with__business_letters__and_2_others___quizlet.pdf | |
File Size: | 91 kb |
File Type: |
lesson_6_pg_22.pdf | |
File Size: | 384 kb |
File Type: |
Letter Assignments
18.business_letter_assignments_and_grade_sheet-1.doc | |
File Size: | 68 kb |
File Type: | doc |
Finish Letters
- Finish your letters.
- Practice the Business Letters Quizlet
- Take the Business Letters bubble quiz.
test__business_letters___quizlet.pdf | |
File Size: | 66 kb |
File Type: |
Editing and finding letter errors
15.letter_formatting.pptx | |
File Size: | 170 kb |
File Type: | pptx |
sample_block_style_mixed_punctuation.docx | |
File Size: | 188 kb |
File Type: | docx |
Assignment: Open up each letter linked below and make the corrections using the editing feature.
Letter 1 has 6 errors.
1_block_style_mixed_punctuation.docx | |
File Size: | 24 kb |
File Type: | docx |
Letter 2 has 8 errors.
2_block_style_mixed_punctuation.docx | |
File Size: | 26 kb |
File Type: | docx |
Letter 3 has 6 errors.
3_modified_block_open_punctuation.docx | |
File Size: | 13 kb |
File Type: | docx |
Letter 4 has 8 errors.
4_modified_block_open_punctuation.docx | |
File Size: | 44 kb |
File Type: | docx |
Assignment 5: DO NOT USE THE EDITING FEATURE, just fix the errors.
Finally, do the timed writing.
5_modified_block_mixed_punctuation_indented_paragraphs.docx | |
File Size: | 21 kb |
File Type: | docx |
s2.demo_for_ppoint.xlsx | |
File Size: | 18 kb |
File Type: | xlsx |