Session 5 B203

Today the students were given a chance to review, with Kevin's review sheet to guide them. Since Kevin was gone, Felipe took over the duties of head instructor, and the students asked questions. Terrance and Thuy Dan were asking some really good questions about functions and formatting. It was great that the students were thinking about Excel, and a lot of them had been thinking about it between sessions.

After the break, AJ came in and talked to the students about Google Docs. The intro video, wherein a young man tries to get his friends to edit a letter asking a girl on a date, went over like a house on fire His friends circulate the document to their friends, everyone paring the letter down to the basics, until it's eventually shared with the woman he's hoping to ask out. It's cute and fun and shows just how useful and easy to spread Google Docs can be.

The students had a great time editing a shared document, some of them a little too much fun. Lakoye got a little too excited about making changes to other peoples' entries, but enthusiasm is always appreciated.

Then, once the Google Docs section was finished, the students began to work on their BTWs. Some of them thought they could just use the information that Kevin put into his example template, but we made sure they understood that the information was out-of-date or just completely made up.

Here's an example of what Thuy Dan made:



Here's an example of Eileen's work:


Then students worked on a project about where they may want to study in the future. It was very interesting talking with the students about what colleges they're looking at and what they plan to study. Jasmine is looking at UW - Milwaukee, simply because she's planning to study nursing and they have an excellent program for that. Having attended UWM for my graduate degree, I was able to offer her some advice on looking for a place to live in the area, since there's a good deal of reasonable apartments in the campus area, and very little dorm space. This led to me telling the students to check out apartments in whatever area they're looking at, since on-campus housing is not the only option they should explore when filling in their budgets or, indeed, for planning out this next, very big step in their lives.

I look forward to seeing the completed projects, and I know the students can't wait to have it finished!

Session VI: 2nd Day of Excel (and 1st Day w/ Zon)!

Many of you (or perhaps just A.J.) may be reading this title and thinking... "Zon's working with Cristina and Elizabeth?! Didn't I tell her to work with Paul and Felipe? Hm..."

Well, Elizabeth had unfortunately missed her alarm clock today. So Cristina was on her own again, BUT because Zon was in Felipe and Paul's room, Cristina stole Zon from Felipe and Paul.

During the review, the projector went out! And because this is Information Technology Academy, we definitely needed the projector, so Elizabeth and Cristina (and Zon) sent the students on an early break... of course the class would start early. In the meantime, the instructors hoped for the projector to fix its sweet self.

The projector was probably overheated because it started working after a couple minutes of "off" time.

Unfortunately, due to these technical issues with the projector and other confusion, the students got a longer break which took away from their learning time; however, the projector started running and Elizabeth realized that the speaker jack was flipped and it really does work with a Mac (because it's universal, but the instructors completely forgot this).

The introduction to the Google Documents was a video by Google, and can be found here. It's a hilarious sketch on a guy who is trying to ask out a girl he likes, but fails pretty miserably at writing her an e-mail to do so. He enlists the help of his friends (via googledocs!) to help him win the girl :)



After the Google doc introduction and brief run through, the students began their BTW.

***
College research queries soon became the focus of the day. Eddie looked into MIT, while Cristina told Ivan, who is interested in film production, about checking out universities in California. Kiran shared with Elizabeth her interest in University of Massachusetts in Amherst. "I'm not sure why I want to go there . . . but I just do!" The college search process is stressful, but each student has so much promise. Though the process may not always be comfortable, it will be well worth it when they have come to the end of it satisfied with their college careers.

After some work time passed, Ivan mumbled something and Noah replied, "You shouldn't be doing that right now, you should be doing this."

"I am doing that, so don't be coming at me like that," retorted Ivan.

And then the two went back to work. Then they started talking about the STEM panels today.

***
When break time came, the students didn't want to leave their computers (some really didn't). Kiran asked, "Can I just sleep here?" She was denied, and was sent out to "socialize." Although she may not have felt she needed more socialization time, she and others had a good time out in the hallway enjoying one another's company away from computer screens.

***
When the time came to take the Permit test again, the students discovered that there was no test available on learn@UW!

"Yay, free time!," cried Thor.

Cristina, luckily, was quick on the draw, much to the students' disappointment - after she activated the quiz, the students began their second attempt.

***
After they completed the permit test, Elizabeth instructed the students to utilize the quiet test-taking atmosphere to work on their blogs. This transition went smoothly; at one point, though, Lejia needed help to capture a screen shot... so he yelled out, "CRISTINA" which took everyone in the heretofore silent room by surprise! He was listening to music at the time, so perhaps we can forgive him. ;)

Overall, another fine day of Excel-ing for the juniors!

Session V with Cristina and ... Just Cristina!

Cristina got to the room at 7:00AM, spending her extra hour pushing the tables together and sliding the chairs to their "rightful" spots.

An hour or so later...

The students started walking in and sitting in the same spots that they always do.

The only difference today was (it's pretty self explanatory... just look at the title!) Elizabeth is absent and Cristina is on her own!

The day started on track. At 9:00AM the students, all started their learn@UW.

When that was done, Cristina got right to teaching charts. Although this lesson went smoothly, when the topic of printing came along, Noah began asking questions, "How come you also have the chart because I only have the graph...," Which led us to discuss page break views and landscape orientation.

Understanding these topics went by quickly, though the "paste special" feature proved to be a bit of a challenge for the juniors ... though that may have been because they weren't following along as Cristina showed and explained the function of Formulas, Values, and Column width. :) Fortunately, they soon got it (when they listened).

The next part of the session included the Excel Functions Jeopardy Game. When the class was divided into two teams, Lejia was the one to start, but with a confused look on his face, he asked, "Where are the categories?"

"There are no categories because... everything's about functions - look at the title," responded Cristina.

Excel functions are pretty self explanatory, for example, "Adds" defines adding the arguments or "Exact" means two values are to be the same in order for the condition to be True. It isn't terribly necessary to memorize all this information . . . easily the students could just look it up under the 'Insert Function' button.

Noah and Thor eventually figured this out and were on a roll (their teammates were happy).

Today was just a day of gaming! After break was done, the students (just the guys...then again, there was only one female student) were excited to play THE EXCEL YOUR SKILLS excel game again, their profiles at the ready from last week!
When Kiran looked lonely, Cristina played with her. Cristina was sitting in Tenzin's spot and discovered that he had bought more than he could pay for out of his allotted and earned money... soon, other students' rule bending was discovered - Lejia had bought THREE calculators when you're only allowed one of each item!

"THAT's why you're winning," stated Thor who had been losing for the first time against anyone.

As everyone was in the middle of gaming (Cristina included), A.J. stepped into the room to see how things were going. But no matter where AJ goes, the students soon find a way to utilize him and his knowledge! Eddie was soon asking why, ".avi files don't work in Vegas." A.J. in turn questioned him about his lack of appearance.

During the exploration section, the guys were so set on winning that Kiran and Cristina sat back, played the game and chatted about their majors. Kiran and Cristina may major in the same thing: Business and international relations with a certificate in an East Asian Language.

When Thor was undefeated (besides losing to the "[unknown] cheating" Lejia and Tenzin, he played against his brother. "You have no weak point!" said Noah when Noah's life just kept draining..."Noo, it's ONE, it just hasn't come up yet," Thor remarked.

Well, the class continued like this with a couple of minutes here and there dedicated to explaining the hidden cells or the random die rolling.

When the First Permit Test was completed, the students were once again bummed about blogging. Because they expressed this to A.J., he came in and talked about blogging with Cristina. A.J. read one of Cristina's blog, as the class reminisced about the day the blog post described: Eddie remembered when he said that he was "perfect," but not Tenzin's remark, though Tenzin remembered it "like it was yesterday". The students may not realize it yet, but their reflection on the past through these blogs is allowing them to remember and retain more. ITA sessions aren't just going to waste anymore.

In addition, A.J. explained that blogs are like words to our eyes. We can't always listen to them (but we most certainly would love to), but we can always read what they say - anytime and anywhere (if internet is accessible).

In addition, Eddie stated that he didn't know what to write about, though he really wanted to read his peer's blogs. "You know... you can wri-" "about that," Eddie finished Cristina's sentence. Cristina smiled and walked away.

When the blogs were done, Cristina wanted everyone to send her an email so that she could pile their gmails together and send out the list to all of the students. Every one wanted to read each other's blogs! Hopefully they'll gain more motivation to write blogs for their friends to read and enjoy (or as Eddie put it, "talk smack" about each other).

Today was largely review for the Excel students, in order to cover topics that might not have been given enough depth in previous sessions, as well as to prepare them for the upcoming Permit test. Terrence asked some really good questions, and was on-the-ball when it came to identifying functions. In general, everyone was interested in the graphing and other visual representations of data. Excel has a lot of different ways to do it, and the students got into how many options are available.

There was a lot of energy in the room this morning, and after the review session we had a few minutes for the Excel jeopardy game. Their enthusiasm got the better of them, though, since they largely went for the 500-point questions right away. But, points for effort!

During exploration, students had another go at the Excel game. Unfortunately, due to technical (and a few motivational) issues, we didn’t have more than 4 pairs playing throughout the hour, and no tournament either. Yet students learned some Excel, profiles were made, and battles were won (and lost).

The College BTW was introduced, to an unprecedented, completely silent room. When Kevin asked why that was, a few students replied “because this is actually interesting!” So hopefully the college BTW will be worthwhile.

The Permit Test brought the usual round of resistance, but it didn’t take long for people to start working. Some finished quickly, some took their time, and then afterwards people did their blogging. Several of them posted screenshots. They seemed interested in the game and the college sections, for the most part.

Session IV: The Exxcceelll Game

Elizabeth started the day like any other day... except today was a special day (the students just didn't know it yet). As Elizabeth would put it, "Today has come...now..the EXCEL GAME!(imagine a deep voice that echoes tuned to music from The Space Odyssey~)" Elizabeth's cheesiness may have been obvious, but the students seemed to enjoy her in her oddity :)

Fortunately, Cristina was in the room at the time to see the students faces (priceless) before she ran out of the room to once again look for that missing digital camera!

So commenced the set-up of the Excel Game! As Elizabeth taught the students how to add the necessary developer tab by right clicking on the ribbon, the class discovered they didn't really know how to right click on macs! This was quickly remedied. Oh the things that PC users learn when they're forced to Mac-it for a day. =)

When the class had to put combo boxes over cells, complaints soon arose as they discovered the boxes didn't fit over the cell PERFECTLY. Eddie, on the other hand, claimed that perfection for his combo boxes. "Yeah, because Eddie is just perfect," Tenzin exclaimed sarcastically.

As the lesson continued on to the copying and pasting of the combo box, Kiran pointed out that when you change the content of one box, EVERY box changes to the same content! This was a great leeway for getting into the the next lesson point: the necessity of changing the cell link...

When Elizabeth told the students about the useful feature of auto-fill, they were bummed that they had previously wasted time by repeating the same functions over and over when they could have just clicked and dragged! Nevertheless, because of all that repetition, the students learned very well functions like vLookup and the process of linking documents.

On a random note, Cherry stopped by to drop off the digital camera that was missing - it was misplaced (and should go into A.J.'s desk)! Cristina could now take pictures of the class for this blog!

Elizabeth soon introduced the concept of cell naming, along with the danger of changing these names without being careful (once they're changed, it's set in stone and there's no going back!) During worktime, Tenzin, much to his dismay, thought he have had a little mishap in this regard; he had named everything correctly, but placed it in the wrong place! A.J. was excited that he might have to restart his whole project (presumably for educational reasons ;) ). Unfortunately for A.J., "undo" was able to fix the problem. Phew! Tenzin breathed a sigh of relief.

The example game consisted of Elizabeth's player, eZoom2, and Lejia's pseudonym LejZoom, but because he had to fix something really quick, Elizabeth dropped him and picked up Kiran's Taenikyun (a Korean name she chose).
Unfortunately, problems with finding and replacing the name came up... maybe because her REAL player's name is Taekyunik! (spelled slightly differently than the above name) So.. since Kiran's didn't work, Elizabeth went crawling back to Lejia's LejZoom, "Lejia's second chance," Elizabeth said.

Once Lejia and Elizabeth had a successful (and fair) game, the other students could start their own games. And as the games started around the room, the students started to enjoy the game more and more.

And Elizabeth got all into it with the Lord of the Rings' music which continued throughout their blogging session. The day was coming to an end...

...and then Ann came in...
To present about the INTERNSHIPS next year!!

Which are... A couple of the research professors are looking for skilled Vegas students to come and video tape them (for records of their research)! Whether it is paid or not, this is a great networking opportunity for these students. Plus, A.J. will even mentor those who are interested (so those who want it will most definitely do a great job)!

Thanks, Ann! Hopefully the students are interested (because this will get them far~).

10/24/09

The class started with the students taking the Learn@UW quiz. Kevin started showing the students how to set up their player profile. He showed the students how to use the Developer Tab to add combo boxes to the player profile so that they could be later used for adding weapons or armor. He went through using the formulas (sum, vlookup) to set your combo boxes and fields to work properly. The students were shown how to name their cells and were warned that if they name them wrong, they would have to restart their sheet. The class had a 10 minute break and started working on their player profiles when they came back.



By the second break, almost everyone was done with their player profile (aside from the back row, and Henry, who gave up...) Students were getting up and helping each other.



The students complained when we told them to turn off their monitors and leave the room for their second break but they eventually complied.

Session III

Today, Elizabeth started off with functions in Excel. She had Ivan, Noah, and Thor come up to demonstrate the functions "Sum," "Average," and "Count." Though they successfully demonstrated these functions, the class did not succeed in counting letters or finding "Count A."

As Elizabeth was teaching her lesson, Tenzin, Eddie, and Leija were looking at Tenzin's computer and giggling. Though Cristina walked by Tenzin, she noticed that they weren't doing anything to the computer and an image was just up... What she didn't know was that he had intertwined the mice and was using his mouse on his lap as the other one sat on the table! How sneaky...

After going through all of the functions, Cristina introduced herself, and continued the lesson with "Excel Automation." Cristina taught her lesson rather quickly because she thought that the students had a version of their own... So, after going through the WHOLE lesson, she remembered that the students didn't have their own version, and the two instructors saved it onto the Excel unit for the students. They opened up the document and played around with Sort and Filter. They finally knew what Cristina was talking about.

Next came the break where Eddie's train of thought led us to rediscover our inner child by watching the "Arthur" and "Magic School Bus" theme songs.

During work time, the students agreed on playing "Forever" by Drake. The boys were having a "heated discussion" about why the song was written and whatnot. Since the song had a couple of swear words, it was immediately changed and "clean" songs are now the only thing to be played in Elizabeth and Cristina's lab.

The group eventually came together to agree on songs and the rest of work time went by smoothly.

When break started and the students (once again) found out that they couldn't use the computers, they were devastated but eventually found a new leisure activity! They were hacky-sacking (don't really know what it's called...) and having a blast.