11GCSE – Period 5: Thursday 22nd October October 22, 2009
Posted by ictatshr in 11GCSE.add a comment
Starter: Codebreaker
Homework
Software justification – please complete a first draft of this. You should try and identify at least 6 features of access (tables, reports, queries, forms, primary keys, validation etc.) and explain why they will be useful by relating them to problems you are trying to solve. For example; “one of the features of access is the ability to validate data entry, this will be useful because I want to ensure that appointments can only be entered for future dates. I can create this validation in the design view of the table and I can also enter a validation message explaining why data has been rejected. To create this type of validation I can use the formula….”
Task 1 – validations
After you have populated your members/clients/customer table with names and addresses you can add the validation to your tables in design view.
In your implementation log you only need to describe in detail each type of validation you might be using once. E.g. one presence check, one range check, one drop down list etc.
Task 2 – creating your relationships
If you haven’t designed your relationships yet you need to do that before creating them in your realtionships. Scroll down a few lessons for details on designing your relationships.
You do not need to cover every single relationship you make in your log, but make sure you talk about one to many joins and enforcing referential integrity if possible. Ensure that you include a finished screenshot of your relationships showing all the fields and all the joins.
7W Period 2 Thursday 22nd October 2009 October 21, 2009
Posted by shrlloyj1 in 7W.add a comment
Objectives:
Carry out an evaluation of your presentation.
print handouts with notes on to explain and justify choices.
Task 1
Use the self-assessment sheet: senior/ict/7.1 where I live/presentations/self-assessment
Open and ’save as’ to your ICT/presentations folder. Complete the self-assessment.
Task 2
make notes on each slide to explain and justify your choices.
Task 3
Print out handouts showing the notes you made.
8Y Period 4 Wednesday 21st October 2009 October 21, 2009
Posted by shrmunrl1 in 8Y.add a comment
This will be your last lesson in this section of work. After half term you will have an assessment which will test your understanding of MS Excel.
TASK 1 CHECKLIST
Open your presentation and make sure that you have…
- A maximum of six slides
- The name of the company and the slogan
- The contact details
- A page about how tourism is harming the environment (five points from today’s lesson)
- A page about how some problems can be solved (five points from today’s lesson)
- A page with up-to-date wether information (your web query which you created a couple of lessons ago)
Task 2 Adding Special Offers
Use the Internet to see how other travel agents (e.g. Thomas Cook) promote their holidays. Some offer BOGOF - buy one get one free. Some offer free child places. Decide what you are goinmg to use to promote your “Green” holidays and add this to your presentation.
Extension Task 1 – Adding Hyperlinks.
Watch the following video and try to add appropriate hyperlinks to your presentation .
Extension Task 2 – Adding Action Buttons
Watch the following video and try to add appropriate action buttons to your first slide.
TASK 2 Printing your Presentation
You need to print your presentation as a handout with 6 slides per page. To learn how to do this please grab your headphones watch this video.
TASK 3 Saving your Presentation as a Web Page.
When you have completed your presentation, you need to save it as a website. To do this, simply choose file – save as web page and save the website in G:\ICT\Year 8\8X 2009 10\8X Powerpoint WEB PAGE.
TEST YOURSELF
I will open Millionaires or Weakest Links?, spreadsheet.
We are going to play a game called Millionaires or Weakest Links?, which revises many of the key terms in this unit.
The class will be divided into two teams, Team 1 and Team 2.
I am going to ask some questions.
One person from each team may answer (you may confer).
You should write your answer on a piece of paper and hand it to me.
If the answer is correct, I will fill the bottom square in their team’s grid in black.
If the answer is incorrect, I do not fill in a cell, and I will move onto the next question.
The winning team is either the team who reaches £1000,000 first, or has the highest black column by the end of the game.
8X Period 3 Wednesday 21st October 2009 October 21, 2009
Posted by shrmunrl1 in 8X.add a comment
This will be your last lesson in this section of work. After half term you will have an assessment which will test your understanding of MS Excel.
TASK 1 CHECKLIST
Open your presentation and make sure that you have…
- A maximum of six slides
- The name of the company and the slogan
- The contact details
- A page about how tourism is harming the environment (five points from today’s lesson)
- A page about how some problems can be solved (five points from today’s lesson)
- A page with up-to-date wether information (your web query which you created a couple of lessons ago)
Task 2 Adding Special Offers
Use the Internet to see how other travel agents (e.g. Thomas Cook) promote their holidays. Some offer BOGOF - buy one get one free. Some offer free child places. Decide what you are goinmg to use to promote your “Green” holidays and add this to your presentation.
Extension Task 1 – Adding Hyperlinks.
Watch the following video and try to add appropriate hyperlinks to your presentation .
Extension Task 2 – Adding Action Buttons
Watch the following video and try to add appropriate action buttons to your first slide.
TASK 2 Printing your Presentation
You need to print your presentation as a handout with 6 slides per page. To learn how to do this please grab your headphones watch this video.
TASK 3 Saving your Presentation as a Web Page.
When you have completed your presentation, you need to save it as a website. To do this, simply choose file – save as web page and save the website in G:\ICT\Year 8\8X 2009 10\8X Powerpoint WEB PAGE.
TEST YOURSELF
I will open Millionaires or Weakest Links?, spreadsheet.
We are going to play a game called Millionaires or Weakest Links?, which revises many of the key terms in this unit.
The class will be divided into two teams, Team 1 and Team 2.
I am going to ask some questions.
One person from each team may answer (you may confer).
You should write your answer on a piece of paper and hand it to me.
If the answer is correct, I will fill the bottom square in their team’s grid in black.
If the answer is incorrect, I do not fill in a cell, and I will move onto the next question.
The winning team is either the team who reaches £1000,000 first, or has the highest black column by the end of the game.
9W Period 2 Wednesday 21st October 2009 October 21, 2009
Posted by shrmunrl1 in 9W.add a comment
WEEK 7 – 13th October
9.1 Lesson 7 Mayhem Manor: Making and Interpreting Charts
LEARNING OBJECTIVES
In today’s lesson you will learn how to;
- Create a chart to represent two data series.
- Interpret a chart and draw conclusions.
Starter: Interpreting Charts.
Grab a white board, pen and cloth. Work in pairs. Look at Chart Starter (Reso7a). Jot down on your white boards what you think the data on the chart represents. (HINT: Look at the y-axis values – these are too high to represent temperatures. What else might they be measuring?)
Look at Sheet 2. This chart shows the number visitors per month to Mayhem Manor over two years. On your white boards jot down the answers to the following questions;
- What happens in January at the theme park?
- When did the theme park close last year?
- When does the theme park close this year?
- What was the busiest month last year?
- What happens one month later this year than last year?
- Is the theme park making more or less money this year?
- Is this chart the best chart type to show this data?
- What other chart type could be used?
Task 1 Chart Types.
The Big Wheel has now been running for six months. Your task is to create a chart to compare the actual with the projected ticket sales for the last six months. Work in pairs. Jot down on your white boards;
- Which chart type would be the most useful for presenting the information?
- Why are charts good for comparing datasets?
Task 2 Creating a Comparative Bar Chart.
Open Mayhem Manor Sales Figures spreadsheet (Reso7b). This contains two tables – Table A contains the projected sales figures for the theme park and Table B contains the actual figures. To create a chart using discontinuous cells (total sales figures from both tables and these are not next to each other), then you need to use the Ctrl key with the mouse to select only the correct data. Save this into your Unit 9.1 Mayhem Manor folder. Add your name to the header (View / Header and Footer / Custom Header). Call the spreadsheet Mayhem Manor Sales Figures.
- Select the total figures for the projected and the actual sales (row 10 and 18). REMEMBER to hold the Ctrl key down. Choose Insert / Chart to open the Chart Wizard.
- On Step 1 of the wizard, select a chart type. Which chart type will give you the best results? Some charts won’t give you any useful information. They just look pretty! Choose Press and Hold to View Sample to see what your chart will look like. Select one that shows the data clearly, and then click on Next.
- In Step 2 select the Series tab. This screen allows you to name the data series. Click on Series 1 and then in the first text entry field, type Projected figures. Click on Series 2 and in the text entry field, type Actual figures.
- In this screen you can also change the x-axis labels to show months instead of numbers. Go to the bottom of the screen and click the red, white and blue button (Collapse dialogue button) on the right of the text entry field. The Wizard will minimise allowing you to select the labels from your table. Select the cells Apr – Sep at the top of Table A. Click on the Collapse dialogue button to return to the Wizard.
- Go to Step 3 of the Wizard. Here you can add titles for your chart, and for the x- and y-axes. Title the chart Mayhem Manor Sales Figures: Projected versus Actual. Label the y-axis, Number of Tickets Sold.
- Sometimes it is useful to look at a table and chart together. In Step 4 of the Wizard, choose to place the chart As object in Sheet 1 and click on Finish.
Task 3 Analysing your Chart.
Work in pairs. Take a good look at your completed charts. Jot down on your white boards;
- What conclusions can you draw from the completed chart?
- Were the predictions accurate?
- Are the actual figures better or worse than the projected figures?
- What are the implications for the theme park?
- How could you increase ticket sales?
Task 4 Adding a Third Data Series to your Chart.
You can find a data table on Sheet 2 of the Mayhem Manor Sales Figures spreadsheet. Try to work out how to do this on your own. If you have difficulties, use worksheet Adding a series to a chart (Reso7c) to help you.
TEST YOURSELF
Look at the Plenary Chart. Work in pairs. You minutes have five to prepare a statement to give to the manager of the theme park, explaining what the chart shows. One person in each pair must read the statement you have agreed to the class.
EXTENDED TASK
Print preview your chart to make sure that your name is in the Header. To add your name to the header, choose View / Header and Footer / Custom Header. Print your chart to the KC2mono printer. Write an email to the park manager, explaining why she needs to increase ticket sales. Give her some suggestions on how she might do this. Send a copy of this email to me at l.munro@shr.gdst.net
8Z – Period 4: Wednesday 21st November October 20, 2009
Posted by ictatshr in 8Z.add a comment
Starter: Wordwall – word machine
Task 1 – Creating charts in Excel
Please open your your copy of go green sample data which you were working on at the start of this unit.
Using the sheet and your friends to help you, create a chart which for either the temperature or the light level.
Task 2 – Formatting your chart
Once you have created your chart you can experiment with the font styles, font colours, background colour etc.
Task 3 – Extension tasks
If you complete your chart quickly, try these extension tasks
Add another series to your chart (eg, add the temperature and light level to the same chart)
Plot the extra series on a secondary axis – click here for help
Add a trend line or lines to your chart – click here for help
Task 4 – Revision
Your first lesson back after half term will include a test on everything you have learned so far. You will need to know how to do the following;
calculate an average, calculate a minimum and maximum, calculate a range
create charts, add a trendline
Make sure you know how to do these by the end of today’s lesson!
Task 5 – If you finish…
Make sure that you have done everything you needed to do from last lesson – scroll down to remind yourself.
Then you can try any of the activities on this page.
finishing off powerpoint if necessary and saving in general
10GCSE – Period 2: Wednesday 21st October October 20, 2009
Posted by ictatshr in 10GCSE.add a comment
Starter:
Task 1
Please continue to develop your hand drawn plans for your spreadsheet.
10S2 Period 5 Tuesday 20th October 2009 October 20, 2009
Posted by shrlloyj1 in 10S2.add a comment
continuing lesson 3…
Printing your evidence document.
Print preview your work BEFORE you print it. Check that your NAME is in the header. Have you included:
- KEYWORDS
- RESULTS (HITS)
- HOMEPAGE
- OUTFIT (Main item of outfit e.g. dress, suit, etc)
- PRICES
- CONTACT DETAILS
- OTHER – MAP, VIRTUAL TOUR
- SELECTION of IMAGES (e.g. Logo, banner, etc)
NOW print your work to the KC2mono printer.
LESSON 3
Starter: What do you know about webpages? Try this SPOT the TEACHER quiz to find out.
Developing Text for the Leaflet
- Either by copying or pasting from the internet or writing in your own words, in Word write a few short paragraphs about your Retail Outlets. Call this document Text Information about my Retail Outlets; add your NAME, FORM / GROUP and DATE to the header and PAGE NUMBERS to the footer. Write this in plain text; don’t use headings or bullet points at this stage.
- Print out your paragraphs and then annotate them to show which words you will change, how you will create headings, formatting you might apply and where you will insert bullet points etc.
EXTENSION TASK
What have you learned about websites? Click here to test yourself. If you get them all correct then try this.
7x Period 3 Tuesday 20th October 2009 October 20, 2009
Posted by shrlloyj1 in 7X.add a comment
Objectives:
Carry out an evaluation of your presentation.
print handouts with notes on to explain and justify choices.
Task 1
Use the self-assessment sheet: senior/ict/7.1 where I live/presentations/self-assessment
Open and ’save as’ to your ICT/presentations folder. Complete the self-assessment.
Task 2
make notes on each slide to explain and justify your choices.
Task 3
Print out handouts showing the notes you made.
8W Period 4 Tuesday 20th October 2009 October 20, 2009
Posted by shrmunrl1 in 8W.add a comment
This will be your last lesson in this section of work. After half term you will have an assessment which will test your understanding of MS Excel.
TASK 1 CHECKLIST
Open your presentation and make sure that you have…
- A maximum of six slides
- The name of the company and the slogan
- The contact details
- A page about how tourism is harming the environment (five points from today’s lesson)
- A page about how some problems can be solved (five points from today’s lesson)
- A page with up-to-date wether information (your web query which you created a couple of lessons ago)
Task 2 Adding Special Offers
Use the Internet to see how other travel agents (e.g. Thomas Cook) promote their holidays. Some offer BOGOF - buy one get one free. Some offer free child places. Decide what you are goinmg to use to promote your “Green” holidays and add this to your presentation.
Extension Task 1 – Adding Hyperlinks.
Watch the following video and try to add appropriate hyperlinks to your presentation .
Extension Task 2 – Adding Action Buttons
Watch the following video and try to add appropriate action buttons to your first slide.
TASK 3 Printing your Presentation
You need to print your presentation as a handout with 6 slides per page. To learn how to do this please grab your headphones watch this video.
TASK 4 Saving your Presentation as a Web Page.
When you have completed your presentation, you need to save it as a website. To do this, simply choose file – save as web page and save the website in G:\ICT\Year 8\8X 2009 10\8X Powerpoint WEB PAGE.
TEST YOURSELF
I will open Millionaires or Weakest Links?, spreadsheet.
We are going to play a game called Millionaires or Weakest Links?, which revises many of the key terms in this unit.
The class will be divided into two teams, Team 1 and Team 2.
I am going to ask some questions.
One person from each team may answer (you may confer).
You should write your answer on a piece of paper and hand it to me.
If the answer is correct, I will fill the bottom square in their team’s grid in black.
If the answer is incorrect, I do not fill in a cell, and I will move onto the next question.
The winning team is either the team who reaches £1000,000 first, or has the highest black column by the end of the game.
