Make sure that you’ve finished ALL of the steps in creating your timetable before you attempt this one.

Your timetable should look something kinda sorta like this:

Excel is a lot like Microsoft Word in many ways that we’ve seen so far, but it also has some big differences. When we set up our Timetable last year in Word, we started by placing it on a file that would eventually print out on a standard sheet of printer paper (8.5″ x 11″). But Excel isn’t really set up for creating documents the same way. To see this in action, go to File and Print (NOTE: PLEASE DO NOT ACTUALLY PRINT OUT YOUR TIMETABLE!)

 

Start by pressing Ctrl + P  or going into the File menu

and selecting Print

Make sure you select Microsoft Print to PDF!

You’ll see a preview of your page on the right…

No good! It’s cut off on the right hand side!

There are some settings that will help, though.

The first one should probably say Print Active Sheets. That will work for us.

OR

You could go back and highlight the stuff you want to print (your timetable) and then choose Print Selection

Our timetable is a lot wider than it is tall, so flip that paper so that it is Landscape Orientation

You may also wish to cut down the amount of white space around your timetable by making your Margins smaller. I like Narrow

That might do it for us, but you can also Scale the size of your print to fit all of your columns on the page as well

That’s not bad

But you may wish to fill up the page even more! I’m going to press Esc to go back to see my work again

You’ll notice a dotted line around your work. That represents the edges of the page if you were to print it out. Currently, there’s a LOT of room left on that page

What I like to do is highlight the rows for Day 1 to 6 (for me that’s rows 4 to 9.) Click on one of those numbers on the side, then hold Shift and click on the last one to highlight those entire rows

As I showed you before, you can adjust the size of your rows or columns. With all 6 days selected, you can adjust them all at once and make sure that they stay the same size

Click at the bottom right between the last row of your timetable and the first blank row (for me that’s between 9 and 10)

Pull that down A LITTLE BIT / SLOWLY

and you’ll see some of that extra space start to disappear

If you keep slowly and carefully adjusting (and/or pressing Ctrl + Z to Undo if you go too far) your rows will get deeper but you won’t go onto another page

And you’ll end up with very little space left at the bottom

Resulting in a much nicer looking page to print

Here’s one more look at the settings I chose to make mine fit on the page well

 

So long as you’re sure that you’re on Microsoft Print to PDF, you can now hit Print

Rather than spitting out a piece of paper, this will give you a file to drop off, which I will give you marks for and print for you. Save it into your Documents or OneDrive folder

and then drop it off!

After following the directions in STEP 1, you should have something that looks kinda sorta like this:

If not, go back to the posts for your class and follow those directions until you do have something kinda sorta like that. You should ALWAYS FILL IN YOUR INFORMATION BEFORE YOU MAKE IT PURTY! Don’t start messing around with colours and pictures and stuff unless you’ve actually got something to purty up!

Now that we do have everything filled in, let’s make it purty!

See that top line? That’s a headline. Let’s make it stand out!

You can make it BOLD

 

use ITALICS

 

Underlining:

 

I like BOLD for a title, personally

 

But it should also be a little bigger as well

That looks better!

 

It might be nice to have things like the periods stand out as well, so I’ll BOLD those as well:

Time for a splash of colour!

As usual, click on any cell to select it

Look for the paint bucket to fill

and choose your colour 

But say you don’t want to do things cell by cell (who would?) You can select a range of cells by clicking and dragging (or clicking then holding down Shift or Ctrl and then clicking on another)

Let’s say that you like the look of a cell and you want other cells to look the same way (same font, size, colour, shading, etc.). Select a cell (like my Period 1)

Double click on something called the Format Painter

You’ll see a dotted line around the cell that you’re going to copy the formatting from

and then you can go and click (paint) to apply that formatting elsewhere

  becomes 

Now the two areas match

I like to make all of my subjects look different, but all of the classes for each subject look the same. Choose a look for one of your subjects

And double click that Format Painter 

Go paint that on the rest of the classes for that subject

Carry on and do the rest of your courses!

One thing to watch for. Sometimes if you fill a cell with a dark colour, your text will be rather hard to read

So you might have to switch to a lighter colour for your text

Something else that makes things look a lot better is having borders around the cells. When we used Word, they were already there, but here, not so much, so you have to turn them on

Select your cells but DO NOT INCLUDE ANY EMPTY CELLS

Beside the Shading paint bucket there’s an option to change your borders.

Much better!

You may wish to Merge some of those big blocks. You may have different things going on in your schedule on different days of the cycle, but probably not. If you go to Pokemon Club every Day 2, maybe you want to put that in, but if not, how about one big lunch break. Once again you can select a range of cells:

And use Merge & Center to join them

Or perhaps you just want to hide the borders and still have individual cells there:

Maybe you want to label those

If you want, you can change the orientation of the text in the cell. Select it:

The only thing left is to add some logos/pictures!

You may wish to add a GWMS logo. You can get those from HERE

OR

You can go to my LINKS page (or your class Assignments page)

Find a logo you like (.png is my favourite because it has a transparent background, but .jpg will work too)

Click on whichever logo you like

Then at the top right corner, click on Download, then Direct download

Depending on your browser, it will probably go directly into your Downloads folder. If you get a window like this (Firefox), make sure you Save the file

Go back to your spreadsheet and click Insert

then Pictures

Look in youur Downloads folder for the file and Insert it from there

You can click on it and move it easily

But it’ll likely be rather large, so you’ll have to resize by grabbing a corner and pulling in. Please HOLD SHIFT while resizing, so the shape of the picture doesn’t distort!

Put in as many photos/logos as you like, but make sure that you can still read/use your timetable!

As always, SAVE your work!

There’s one more nifty step! You’ll have to drop off an Excel file (.xls) AND a .pdf file. We’ll show you how to do that in the next set of instructions!

 

 

With the new school schedule to get used to, I thought it might be good to revisit our first assignment from last year, but do it in a new and interesting way. Again you’ll create a copy of your class schedule (or perhaps the schedule of your dreams) but we’ll use a different program this time, Microsoft Excel.

Excel is usually used more for math formulas and graphs and stuff (which we’ll get to later) but you can also use it to design your timetable.

Here’s a sample of my finished schedule for 605

Here’s your class schedule:

I like mine to look like this:

There are a *few* paper copies of your timetable in a black binder at the front of the room. Ask to borrow the one for your class if you like, but you need to take care of it and put it back!

You may, of course, change your classes to be whatever you want (eat, sleep, Fortnite, etc.) but I think it might be useful to make a realistic one.

Step ONE is just to type everything into its own cell (those boxes). Every bit of information goes into a separate cell. In the beginning, it might look like this:

You can see the first set of steps for setting up your timetable in the video below. If you are going to watch, USE HEADPHONES and WATCH A BIT AT A TIME. Stop the video when I complete a step and go do that step before playing the video again.

Step By Step:

Open Excel either by opening the Windows menu at the bottom left and scrolling to Excel

Or use the search bar and type in excel

The first time you use the program you might see a license agreement. Click Accept

Blah, blah, blah… Close

Choose the option to create a Blank workbook

The first step in any project is to SAVE!

Click the File menu at the top left (or click Ctrl + S)

Save As because we’ll be changing the name and the location

Click Browse to pick the perfect spot for your file

Two places you can save your file. If you’ve got OneDrive set up and RUNNING on your computer (your cloud is blue), you should save your file in your OneDrive folder

If not, you can always save in Documents

Call it Timetable

Click Save 

And now you’ll see at the top of your document that it’s saved with the proper name:

When we did this last year in Word, we had to set up our page and then instert a table. Well, Excel takes care of that for us. The page is as big as we want it to be and there’s already a massive table just waiting.

Each box is called a CELL.

At the top of your screen you see your COLUMNs (verticle, labelled with letters)

At the side, you see your ROWs (horizontal, labelled with numbers

You’ll put a title across the top. You should select the CELLS in ROW 1, COLUMNS A to K

Select those CELLS by either clicking in A and holding your mouse down to DRAG across to K OR Click in A then hold SHIFT and click in K

We want all of those 11 cells to be one wide cell. On the ribbon above your CELLS you will see a button that looks like this:

Click that and it will join all of the cells together and center the text, even though we don’t have any text in the cell yet.

If we start typing in the cell, we’ll be using the boring, horrible default font and size

YUCK! How BORING! You should ALWAYS CHOOSE YOUR OWN FONT! If we change it now, though, only the cell(s) selected will change and we’ll have to change the rest later. Save a step and change EVERYTHING AT ONCE.

Up in the top left corner of your table, there’s an empty cell between 1 and A. Click that to highlight the entire spreadsheet

Now if you make a change to the font and size, you won’t have to worry about it later because everything will be changed. You will still make some changes later, but most of our text will look like this, or at the very least we won’t have to see that boring, horrible default font.

This is what I chose, but you should choose something that:
LOOKS GOOD TO YOU
IS EASY TO READ

Now we can start entering our information. You’ll notice that when you click on a cell, up above there’s something called the Formula Bar. Everything you type goes into there and you’ll see it in the cell. So I have A1 selected and I’m going to type in my title

Down below that, we’ll SKIP A2 and start typing in our periods

You’ll notice that they aren’t quite fitting, but that’s OK. We’ll fix that in a minute, but you should keep entering your information.

Some of the information will look like it’s going into two cells:

but if you click on E2, you’ll see that there’s actually nothing in that cell and you can enter the next period there

It’ll start to look a bit messy, but keep going.

Once you’ve got them all typed in, we can start to widen the columns to make the information fit.

Between two Column letters (like C and D in the image below) you can click that line and drag it to the left or right to resize.

OR, even BETTER, you can just CLICK that line and it will automatically adjust the size to fit whatever is in the column

Some of the columns get really wide though (Morning and Afternoon Break). I don’t like that. I prefer to have the two words go on separate lines.

Select D2 (Morning Break)

Then look up above on the Ribbon for a button called Wrap Text. Click that

Now if you drag the line between D and E to the left to narrow the column, the word Break should jump to a second line

If it doesn’t, you may need to adjust the depth of the ROW. Again, between two ROW numbers, you can click and drag to adjust

After that, Morning Break will look much better

Do the same thing for Afternoon Break

Now you can see that the words aren’t centered and all of the text is sitting on the bottom of the box.

Again, select everything by clicking the box at the top left, between 1 and A

And look on the ribbon for two justification buttons, horizontal and vertical

You may have to click each button TWICE because not all of our cells are the same (we centered A1 already)

But once you have both buttons in the middle

That row will look much better 

 

 

** From time-to-time as you work, make sure you SAVE YOUR WORK! **

Easiest method is to press Ctrl + S

OR press the little save icon at the top left corner  

Or open the File menu

and press Save  

 

 

In row 3 we will put the times for each period and break. Again, skip column A and put the times below each period/break

Again, they don’t really fit properly. I like to WRAP that TEXT as well. You can select all of those cells by clicking in the ROW number: 3

That should do the trick. I got really picky and got rid of the first space before the hyphen (you DO NOT have to do this if you don’t want to)

So mine looks like this:

The last thing you have to set up before filling your schedule in is the school days along the left

Here’s one of the many cool things that Excel can do:

Type in Day 1 in row 4

At the bottom left of the cell there is a tiny little box. That’s called a FILL HANDLE. If you pull that handle, Excel applies a similar formula (or same text) to other cells. Click it and pull down

Excel will count for you!

Of course, that’s way too many, so just go from row 4 to row 9

now just fill in the text for your class or make up your own schedule if you like!

Whether you’re brand new to computers or a veteran, it’s good to go over some things that you should know and do before you get started working on your (super fun) projects.

First, log in. Your user name is: your first initial a dot, then your last name (some people add a number afterward)

ex: g.waters
or: g.waters2

Your password is: The first three letters of your first name (CAPITAL ON THE FIRST ONE ONLY) then the first three letters of your last name then the last 3 numbers of your student ID

ex: Geowat123

Remember to keep your log in SECRET! You do not want anyone logging in as you and messing up your work or doing something bad that you will get blamed for!

 

***************************************************************

For the next section, the video immediately below will show you everything that is written below that, so you can choose to either watch the video, read the instructions, or both!

Once you’re logged in, your desktop will look something like this:

You will see a couple of quick launch icons on the desktop and a Recycle Bin where files go when you delete them.

 

Down in the bottom right you’ll see a Start button

Clicking that gets you an area where you can open programs and sometimes see information like the weather:

Next to that is a search bar:

You can use this like Google (even though it launches another horrible search engine called Bing. It should be called Barf.)

Typing in a question or something like that will initiate an Internet search:

You can also ask it to do things like convert units for you:

And it will display the results for you:

This is a great way to get the answer to simple math questions and things like that!

You can also use this bar to launch programs. Type in the name of a program you want to open (like my favourite Internet browser, Firefox):

And it’ll give you a quick link to launch that program:

Beside that, you’ll see something called the Task Bar, which includes links to commonly used programs (and a couple of useless ones…)

   

That blue E launches a horrible browser that no sane person should ever use. I get tired of seeing it there, but you can remove it by RIGHT CLICKING on it. To RIGHT CLICK you either use a mouse and click the button on the right side OR tap on the track pad on your laptop with TWO FINGERS AT THE SAME TIME (NOT the same thing as a double click!)

When you RIGHT CLICK, you’ll get the name of the horrible program and the chance to Unpin it from the taskbar so you never have to see its ugly face again. Do it!

Next to that piece of junk is a program that we use A LOT! This program is called File Explorer and it helps you to locate, open, move, or rename files (or a whole bunch of other cool options!)

Opening up File Explorer will launch a window like this:

On the left, you will see a bunch of common locations. DOCUMENTS is one of only TWO safe places to save your files. If you save files into DOCUMENTS, you will be able to see them from any computer in the school:

Down in the bottom right corner there are two options for viewing your files, one is a list of details, like you see above. If you click the other one, you can see a “thumbnail” preview of the file:

Now those same files look like this. This allows us to know what a picture is of without opening it.

Next to that is another totally useless program:

Get rid of that one too!

In the bottom right corner you’ll see a few things as well.

You will see whether you’re connected to the Internet or not with the little wi-fi icon. Sometimes that gets turned off for some reason. If you can’t connect to the Internet, check to make sure that is turned on.

If you can’t connect to the Internet, you may be on Flight Mode for some reason. If that’s on, you can’t connect.

OR…

Sometimes Mr. Robson will catch you doing something you shouldn’t be doing on your computer (I see EVERYTHING!) and will turn off your Internet!

You can also see how good your battery is on the laptop. If they don’t get plugged in properly they can get low. You should notice before it dies!

 

There’s also a little arrow that you can click to Show hidden icons:

One of those icons connects you to OneDrive. OneDrive is where you will drop off your work to me and also a great place to store your files so that you can have access to them on ANY computer or device, even when you’re not at school.

See the OneDrive post for more information about how & why to use that application/site!

 

 

For this post, the video immediately below will show you everything that is written below that, so you can choose to either watch the video, read the instructions, or both!

There are 3 Internet Browsers on your computer that can connect you to websites, Firefox, Google Chrome, and Microsoft Edge (YUCK!)

In a previous assignment, you should have seen how to customize your Task Bar area (at the bottom of the screen) to remove that yucky browser (and the Microsoft Store, which you’ll never need.)

You should also have seen how to open a program. You can either use the Windows menu at the bottom left of your screen

Or use the search bar and type in the name of the browser you want. I use Firefox, so my demonstrations will focus on it. I recommend using it as well unless you’re used to Google Chrome. If you’re used to that other thing, CHANGE YOUR WAYS!

Once you have a browser open you’ll see it in your Task Bar. To get it to stay there (it will only “stick” on the computer you are using today, so if you switch computers, you may want to do this again), right click on the browser icon

And then choose Pin to taskbar

If you choose Firefox (good for you!) it will probably ask you if you want to make it your Default browser

Look for the Web browser section and click it, then click your chosen browser

That dumb Microsoft browser likes to make sure that you want to switch. Of course you do! Click Switch anyway

 

Visiting websites:

The top bar *can* be used to search for a site or topic, but if you know the address of a website, you can (and should) just type it in to go directly there.

Go to my site by typing in misterjrobson.com (you’ve already done this, obviously. Good job!)

Hit enter and you will be magically transported into Mr. Robson’s World

This is a site that you will need to visit a lot, so there are a couple of ways of getting here even more easily in the future

One is to add a Bookmark. You can click the little star to the right of the address bar to add a Bookmark. If the star is blue, you’ve already got one!

You can type in a custom name for the bookmark or just take whatever comes up

I like to make sure that my main Bookmarks go on my Bookmarks Toolbar

If you have that toolbar turned on, you’ll see a handy link to my site right in your browser window at all times. All you need to do is click it to be transported!

You can also edit or delete Bookmarks. I don’t use the Getting Started, so I like to right click on it and Delete

 

There are a few options that you can explore inside the “Hamburger” menu on the right hand side of your window (optoional!)

You can actually create a Firefox account so that you can save your preferences, like those bookmarks, and have them the same on every computer you use. I like this feature a lot.

You can also make sure that Firefox will start up exactly where you left off after you close the program by making sure that it will Restore previous session

We’ll talk more about this later, but you can also set where your Downloads go, or can choose to be asked every time:

 

 

For this post, the video immediately below will show you everything that is written below that, so you can choose to either watch the video, read the instructions, or both!

Click the little cloud to open the OneDrive app:

Click Sign in to, uh, sign in…

Sign in is your computer user name @sjasd.ca

ex:  

That should take you to another login page where you’ll put your password

On the next screen, you need to press Next

And then one more time to start to connect your computer to your online folder:

After that, there’s a little tour you can take if you want:

Or just Close the window:

Now you actually have a new folder on your computer where you can safely store your files AND back them up online automatically:

Now in your File Explorer window you’ll see a OneDrive folder:

Anything you put in that folder will be automatically uploaded online. You’ll know that it’s backed up when you see a green check mark on the file.

 

 

Starting today, we’ll discover the wonderful world of audio editing!

You’ll need to download this file: CLICK HERE

And then open it with 

When you’re done, your file should sound something like this, but NOT EXACTLY

Once you’ve downloaded the file (you have done that, right?), you’ll have to open Audacity

Then you’ll have to press Ctrl + O or go to the File menu and press Open

SAVING YOUR WORK

Please note: SAVING IN AUDACITY IS DIFFERENT than you’re used to!

When it comes time to save your work at the end of the class, you need to EXPORT your file to WAV

Once you’ve exported the WAV, you DO NOT have to save the project! If you try to save the project in your Documents folder it WILL NOT WORK.

Part 1: Reorganizing Audio

The first section of the file is in the wrong order. It should say:

Welcome students, to the wonderful world of audio editing. Once you learn how to edit audio, anything seems possible.

So you’ll have to rearrange the lines. To do this:

Click the magnifying glass with the + sign inside of it. I would click it TWICE if I were you.

Once you do this, the timeline at the top should look like this:

Each number represents a second of audio. You are editing the first 11 seconds only right now.

The section from 10 seconds to 11 seconds is actually the piece that should go at the beginning. Click on screen where those waveforms are and drag across to highlight like this:

Once you’ve got it selected, you just need to CUT by pressing Ctrl + X or the scissors on the top tool bar

Press the Home button on your keyboard to jump back to the beginning of your file.

Then press Ctrl + V or the clipboard on the tool bar at the top to paste

The second block, from around 2 seconds to around 4 seconds, actually goes at the end. Click and drag across to highlight

Go to the space between 8 and 9 seconds and paste

 

Only one more piece to move! Take the section from about 4 seconds to about 5.5 seconds and highlight that

Cut and Paste that section at about the 2 second mark

Now listen to your newly reorganized section to make sure that it sounds OK. If there are any extended gaps that don’t sound good, just delete some of the silence.

Something else that we should check regularly is the volume of a section. You’ll notice in the file that some parts are louder than others (the waveform bubbles appear larger.)

If you find a quieter section, or just want to check and make sure that the volume is right, just highlight the section (like this newly edited 12 seconds or so)

Then look under Effects and choose Normalize

Don’t worry about what the box says for now, just click OK

This particular section won’t change a lot, but it will get a bit louder and it’ll be at the ideal volume.

    

 

Section 2: Fixing Mistakes

Sometimes when you’re trying to record audio you stutter or stumble and make mistakes. No problem, it’s very easy to fix!

Look at the section from about 12 seconds to about 26 seconds. I stutter a lot, so we need to get rid of the bad bits.

The section at about 16 seconds is pretty good. It says, “You can fix.”

Highlight the section before that (about 12 to 16 seconds) and delete (Backspace) or cut (Ctrl + X) that

There’s another pretty messed up section from around 13 to 21 seconds

Get rid of that as well and you’re left with this

Again, listen to it to see if there’s too much space between the words or anything. On my example below, there’s too much space so it doesn’t sound natural

Highlight the extra silence and press Backspace or Ctrl + X to bring the words closer together

 

Section 3: Audio Effects

 

Now for the fun stuff! The section from around 15.5 to 21 seconds needs to be higher. Select that part.

I notice that it looks a little quiet, so I’ll Normalize first

 

Then go into Effects then choose Change Pitch

There’s a little slider down near the bottom that controls the change in pitch. You can also click in the Percent Change box and type in a number. I like to raise mine about 50 percent, but feel free to play around and find a number that sounds good to you.

You’ll need to click Preview to see how it sounds before you accept a change

If it sounds good to you, click OK and move on to the next section from about 22 to about 25 seconds

Again, it’s quiet, so I’ll Normalize

This time, you want to move the percentage down (negative). I used -50 percent (but again, play around a bit. Just don’t get too carried away. We still want to be able to understand what’s said

The next section is from about 27 to about 29 seconds. Highlight that.

We need to speed that up, so go into the Effects menu and choose Change Speed…

Again, you can use the slider or type in a percentage number to change. I like about 50 percent. Make sure you Preview to see how it sounds before clicking OK

The next section is right around 30 seconds

To slow it down, move the slider to the left or type in a negative number (I liked -50). Again, preview before clicking OK.

After that, there’s a long section from about 35 to 42 seconds that needs to be turned backwards.

Under Effects, choose Reverse

The next section is from about 45 seconds to 47 or so

You have two options here.

1. Choose Echo…

Or…

2) Reverb

I notice that mine now looks really qiet, so we should definitely Normalize

The next section is from about 48 seconds to about 51

This time, we want to go into Effects and choose Distortion

To preview this, choose Start Playback

And then instead of OK, you’ll click Apply

That one looks a little quiet again, so Normalize it

 

Section 4: Inserting Sound Effects and other Audio Clips

 

You’ll need at least 3 sound effects. There are lots of places to get sound effects, but we want ones that are free and legal.

A great one is the BBC Sound Effects Library

I also like THIS SITE. The problem with that one is that you can’t really preview most of the files, which is a bit of a pain. Some pages will let you (like these space sounds) but not all.

THIS ONE is also pretty good. Pick a category and browse (the search function doesn’t really help)

You can sample the tracks by pressing play

Then you have to click on the name of the sound to download and save

Once you have 3 (or more) sound effects downloaded, you need to Open them in Audacity

You can actually open all 3 at the same time by selecting more than one (click on one and then hold down Shift to select a range OR click Ctrl to select files one by one)

Then, one by one, go into each file, highlight the part you want to use (or the whole thing if it isn’t too long)

Then Copy (Ctrl + C or the two sheets of paper between the scissors and the clipboard)

Find the spot in your editing exercise file and paste in the sound effect

 

Trim the sound effect if it’s really long (a few seconds should do it)

or just select a piece of the file you downloaded and copy that

The last part is to find a sound clip that you can insert at the end. A movie clip can be found here

LOTS of them don’t work, unfortunately, so you might want to download a few just in case

Paste your clip at the end

And you’re done!

Remember to EXPORT as WAV! You DO NOT need to save your project IF you’ve exported the WAV

Save your WAV in your ONEDRIVE or DOCUMENTS folder

Keep the file name the same

Then go to Teams and drop off your 01_AudioEdit_intro.wav attached to the Audio Editing assignment.