Skyview Middle School Website
Click the title for each subject's assignments.
Business Info
Career

Business Info   

Week 2
E.R. Friday
Week of
March 25

Testing
ELA

Week 3

Week of
April 1

Testing
Math

Week 4
E.R. Friday
Week of
April 8

Testing
8th Grade Sci

Week 9

Week of
May 13

May 13 School Visits
      6th & 8th graders
May 14 Tuesday
      Yearbooks
May 15 Wed.
      Bike the Loop
May 16 Grad. Day
      Field Day

Fire Drill
Info.

Click
for Map

Schedule

Email a Teacher Subject / Tone

firstnamedotlastname@gdotkpbsddotorg
mickey.mouse@g.kpbsd.org

 

 

 

 

Typetastic
https://kpbsdistrict.typetastic.com/login

panther2324

 

 

 

 

 

 

 

 

How to download from Google Drive to your Bizzzzz Folder.

 

 

 

 

 

How to DOWNLOAD your Google Sheet to your Biz Folder on your computer.
You will then be able to work on the Sheet in Excel and Drop the Excel Sheet into the Assignment Turn-in Folder.

 

 

 

Scratch Web site   

 

 

 

 

 

 

 

Email a Teacher

Example

 

 

 


 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

pg

 


 

 

 

 

 

 

 

pg

 

 

 

 

 

 

 

 

 

pg

 

 

 

 

 


 

 

 

pg

4adminadsoldotnams

Business Info


Week 1-2

TypeTastic

Reach 4.1

WELCOME
Review Fire Drill Procedures

Fire Drill Info.
Click for Map

Foldering in Google Sheets
and
Cleaning Desktops


Add an Envelope

Week
_Biz_Info
 
02
Dear
Mrs. Lucy

Save as
         Last_First name_02_Lucy
Add an Envelope
Save as
         Last_First_name_03_Jones
Add an Envelope
Add an Envelope

Save as
         Last_First_name_04_Bic

Add an Envelope
Save as
        Last_First_name_ 05_Convoy
Add an Envelope
 

 


 

 

 

 

 

 

Business Info

 

Week 3-4


#1 Videos Google Drive > Download the letter to the Bizzzzz Folder 3:28
#3 Videos Add an envelope in Microsoft Word > Save into the Bizzzzz Folder 2:16
#4 Turn the letter into the Assignment Turn-in Folder > Church Drop > Biz Drop Videos0:58

Week 3-4
Reach 6

Formatting the Word Document.
       
Page 1 Video

Step by Step

1.     Make the Word Doc look like the PDF file.


Save to your Bizzzzzzzzz Folder.


Save as last_name_first_name_dog


Solomon How to SNIP. Desktop SNIP Solomon How to SNIP.

the pictures on the PDF file. Insert or Paste onto the Word Doc.

Solomon How to SNIP. Chromebook SNIP Solomon How to SNIP.

      

#1 Starting and Saving

   
 

#2 Adding Bullet Points
Edits Should include: Click the SHOW / Hide Tools

Page Layout > Margins Narrow


Insert > Page Break


Align Left, Center Justify

Shift Enter Hard Enter


Wrap Text > Through Pictures


Hold the Shift Key down while
    adjusting the size of pictures.


Insert > Header - Name & Per.


TAB or 5 spaces for paragraphs


Text Highlights


Bold, Italic, Underline


Line Spacing


Text Box on page 4
11 font Calibri
with Hyperlink
Justify Align the text..


Page 1
18 font Calibri (Body)
14 font Calibri (Body)
16 font Calibri (Body)
Page 2
14 font Times New Roman
16 font Times New Roman
Page 3
14 font Calibri (Body)
12 font Calibri (Body)
16 font Calibri (Body)
12 font Calibri (Body)
Page 4
18 font Calibri (Body)
12 font Calibri (Body)


Right click on the
red
& blue underlined words to
fix the errors.

\

 

Typetastic
https://kpbsdistrict.typetastic.com/login
panther2324

 

 

 

Business Info

Week 5 - 8

Reach 8

TypeTastic

Numberpad
Intro to Excel and Google Sheets
Click on the Assignment #
# 1 CW - USA
Calculations
# 2 Formulas
# 3 ABC
# 4 ABC(2) Charts
# 5 ABC (2) # 6 G.P.A.

# 6 G.P.A. Chart in Google Sheets Example
Click for an Example
Do not go on to Part 3 until
Part 2
has been graded
and you have an A+.
Finish Part 1 and
wait for it to be graded and you have scored an A+.
Finish Part 2 and
wait for it to be graded and you have scored an A+.
Part 4
Step # 13
Condence all G.P.A. Sheets
Part 5
Step # 14
Record Current Quarter Grades on the Quarter Sheet.


How to download from Google Drive to your Bizzzzz Folder.
How to turn in your Excel Sheets into the
Assignment Turn-In Folder
How to turn in your Excel Sheets into the
Assignment Turn-in Folder.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.



...below this point. Don't Print.

 

 


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.



...below this point. Don't Print.

 

 


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.



...below this point. Don't Print.

 


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.


...below this point. Don't Print.



...below this point. Don't Print.

 

Business Info

Typetastic


https://kpbsdistrict.typetastic.com/login

Week 3

Videos How to turn in Google Doc. assignments.8:25 Videos How to turn in Google Doc. assignments. 3:14


Week
_Biz_Info
 
02
Dear
Mrs. Lucy

Save as
         Last_First name_02_Lucy
Add an Envelope
Save as
         Last_First_name_03_Jones
Add an Envelope
Add an Envelope

Save as
         Last_First_name_04_Bic

Add an Envelope
Save as
        Last_First_name_ 05_Convoy
Add an Envelope
 

Color the Keyboard

 

 

 

 



 

Business Info

Week

Reach
_Biz_Info

 

 



 

Business Info

Week

Reach 6

Intro to Excel
Classwork # 1 CW - USA / Calculations

 

 

 


Business Info

 

Import to Google Drive
2:12
How to IMPORT your Excel Sheet into your Google Drive Shared Biz Folder.
You will then be able to work on assignments at home and in Advisory.
 
Download from Google Drive to the computer.
3:09
How to DOWNLOAD your Google Sheet to your Biz Folder on your computer.
You will then be able to work on the Sheet in Excel and Drop the Excel Sheet into the Assignment Turn-in Folder.

 

 

 

 

Business Info

 

Choose 2
Typing Quest

Reach 10-14
       Advance Excel
or
Scratch Web site
or
   001 & 002  Tables      

 

 

Advance

Excel

       Advance G.P.A. Video
Create a new GPA Excel Document with drop down windows,
Value Look up formulas and conditional formatting
for each G.P.A. range.

Save as ...

                   LastName_FirstName_GPA2

Excel 8     G.P.A. Video

Youtube

Conditional Formating     Conditional Formating Videos

Youtube

How to get rid of the #N/A as a VALUE.

=IFERROR(VLOOKUP(B4,Table2,2,FALSE),"")

Use the =isblank(B4:S12) Rule
if the value is blank make it white.

In Row 11 use this Sum formula to get rid of the #N/A in the TOTAL Row
=sumif(C4:C10,"<>#n/a")

When you download the video you'll see the following image at the bottom of your webpage.

Click the Shark's tooth > Click open.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Tables in Microsoft Word

Click for the requirements
001 Video of how to insert a table into Microsoft WORD

Save as ...

                   last_name_first_name_001

001 Video Table
Watch the Video and
make the 3 tables.

Click for the requirements.
002 Inserting tables into a Word Doc.

Save as ...

                   last_name_first_name_002  

002 Make 2 Tables
Make two tables of
your own tables.
Assignment

001

       001 Inserting Tables into a Word Doc.

Save as ...

                   last_name_first_name_001

Back to WEEK 9

Excel Videos

Google Docs Videos

Tables#1     Inserting tables. 10:18 min.          

Step 1 - Insert a 9x3 table before watching Youtube.

Step 2 - Watch the video to complete
           Table #1 and Table #2
.
Tables

Step 3 - Insert an enter after Table #2.
           (Put a space between each table).

Creating & Formatting tables in Google Docs

Inserting Tables

Formatting Tables in Google Drawing for use in Google Docs

Table Cell Border Styling in Google Docs

Cell Margins#2             Cell Margins and Spacing 2:25 min.

Step 4 - Insert a 4x4 table before watching Youtube.

Step 5 - Watch the video to complete
          Table #3 Cell Margins.

Step 6 - Drop or Share one Word document with 3 tables on one page!

Click to see what your 3 tables on one page should look like.

Assignment

002

002 Inserting tables into a Word Doc.

 

Save as ...

                   last_name_first_name_002 

 

             Create 2 unique and different tables on 2 separate pages.

1. Use a variety of table techniques.      "Artsie Fartsie Fancy Dancey"
           ex. Cell padding, Merging, Pleasing colors, Pictures etc..

2. The table needs to be interesting, detailed and informative.
Teach me something.

3. Make sure one of the tables is irregular by using the draw tools.

4. Only one table may be as simple as a calendar.
        If you want the A simple tables need to be fabulous!
             No chess boards or multiplication tables!

5. The title of the table will need to be within the table and aliened correctly.

Click to see Example #1 of an irregular table.

Click to see Example #2
Rubric for 002
Two Tables
Name__________________________
Table 1
Used a variety of table techniques.      
       ex. Cell padding, Merging, Pleasing colors, Pictures.
1....2....3....4
Table presents detailed information in a logical format.
1....2....3....4
"Artsie Fartsie Fancy Dancey"
1....2....3....4
Table 2
Used a variety of table techniques.      
       ex. Cell padding, Merging, Pleasing colors, Pictures.
1....2....3....4
Table presents detailed information in a logical format.
1....2....3....4
"Artsie Fartsie Fancy Dancey"
1....2....3....4
One of the tables is irregular by using the draw tools. Quality???
1....2....3....4
Total =

 

 

 

 

 

 

 

 

 

Scratch Web site   

 

Business Info

 

Intro to Excel and Google Sheets
Click below for the Assignment #
# 1a CW - USA
# 1b Calculations
# 2 Formulas

 


 

SS