WEBVTT

1
00:00:01.350 --> 00:00:11.219
William Rosener: hello, this is Dr bill roesner and the short video on the show you how to upload your assignments for spreadsheet analysis to weebly COM for grading purposes.

2
00:00:11.639 --> 00:00:17.160
William Rosener: Some before you is my web page on weebly that i've created to help students upload or.

3
00:00:17.880 --> 00:00:29.580
William Rosener: A show right here so it's a Roadrunner that we've been icon and you can see right now i've got a home button and i've got two one for assignments for 1003 and assignments for 3053 a little picture here, and that is all.

4
00:00:30.240 --> 00:00:45.210
William Rosener: I like to actually have two browsers open here's Romana view my work and i'm gonna open up another browser and here's probably be doing my editing so after you've created your account on weebly hopefully you've got a URL i'm going to simply press on edit site.

5
00:00:47.700 --> 00:00:55.350
William Rosener: Okay, and what I could do at this point is come up here to pages and press on the plus and create a new page.

6
00:00:55.680 --> 00:01:04.170
William Rosener: Just for this class, but only want to make this video a little bit simpler don't have to do is come on down here and insert the hyperlink so right on my main page.

7
00:01:04.470 --> 00:01:21.600
William Rosener: it's going to come back here Rosa with it, I calm right down here i'm just going to go ahead and insert some hyperlinks for them to the versus lemons so i'm gonna come back down here going to press on build and then i'm going to simply drag this text right down here.

8
00:01:22.800 --> 00:01:28.740
William Rosener: Then i'm gonna go ahead and where it says click to edit the type to sign with one.

9
00:01:30.390 --> 00:01:31.560
William Rosener: Simon to.

10
00:01:32.850 --> 00:01:41.430
William Rosener: Sign the three and you can keep going so now what i'm gonna do is first of all let me show you how to hyperlink Microsoft excel file.

11
00:01:41.760 --> 00:01:49.380
William Rosener: So i'm gonna highlight assignment number one system, this is a Microsoft excel phone i'm going to go ahead and press on the CRATE link been so.

12
00:01:49.770 --> 00:02:07.410
William Rosener: subtypes and taxed highlighted press on the crepe link button i'm going to choose file would choose upload new and i've got this here on my desktop in a directory called a temp assignment one and that's the Microsoft excel file and i'm gonna go ahead and press open.

13
00:02:09.210 --> 00:02:18.360
William Rosener: Okay now let's go ahead and assume assignment to was in Google sheets so i'm gonna go ahead and highlight assignment to tell you what first of all I need to get the URL.

14
00:02:18.870 --> 00:02:24.180
William Rosener: So let's assume this is assignment to and i'm going to come up here to the press on the share button.

15
00:02:24.840 --> 00:02:42.570
William Rosener: And we can see that the original editor was bill roesner at gmail COM and imagine that you and you have shared it with me whoa rosenfarb Rosa ready to showcase it to you that's where you're always going to share with what you're going to do is come right down here and hit copy link.

16
00:02:43.980 --> 00:02:48.570
William Rosener: Again, now i'm going to come back to you know highlight assignment to.

17
00:02:50.280 --> 00:03:03.840
William Rosener: Over the press on the CRATE link button and i'm just going to choose a website URL and i'm going to simply position right in there, I just hit paste on the PC that's just a control V to paste.

18
00:03:06.030 --> 00:03:15.960
William Rosener: Okay, at this point i've now have one link to Microsoft excel cycle one to a Google sheets they'll make sure you publish it's very important to hit the publish button.

19
00:03:18.210 --> 00:03:22.260
William Rosener: that's going to actually tell me words publishing it's gonna publisher that rose near weebly.com.

20
00:03:23.490 --> 00:03:39.990
William Rosener: i'm now going to come back here and hit reload where the refresh button and if I scroll down here scroll down a little bit right here on my homepage they're going to be there's a couple of links here here's a sign of one on the personal net I could do open with.

21
00:03:41.160 --> 00:03:43.740
William Rosener: And that's going to open up my Microsoft excel file.

22
00:03:45.720 --> 00:03:51.840
William Rosener: And I can see take like my grid it's real important to make sure I can see this formulas.

23
00:03:54.330 --> 00:04:04.110
William Rosener: Okay, then here is the assignment to, and when I press on that it's going to open up why Google sheets document that i've created.

24
00:04:04.830 --> 00:04:14.070
William Rosener: and get the goddess and so, probably the same thing here, I can take a look at my grade, to make sure at formulas or used.

25
00:04:15.030 --> 00:04:31.290
William Rosener: Hopefully this video you learn how to actually close this out how to insert hyperlinks to both in this case, the first one was a Microsoft excel file and the second one was to a Google sheets document know yeah I think i'll catch you later bye.